using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace MMDAL.DTO.Usage { public class LoadUsageExportDetailDTO { private Int64 slno; private int documentdetailid; private string itemname; private string contractnumber; private DateTime contractdate; private string party; private string branch; private decimal quantity; private string uom; public Int64 SlNo { get { return slno; } set { slno = value; } } public int DocumentDetailId { get { return documentdetailid; } set { documentdetailid = value; } } public string ItemName { get { return itemname; } set { itemname = value; } } public string ContractNumber { get { return contractnumber; } set { contractnumber = value; } } public DateTime ContractDate { get { return contractdate; } set { contractdate = value; } } public string Party { get { return party; } set { party = value; } } public string Branch { get { return branch; } set { branch = value; } } public decimal Quantity { get { return quantity; } set { quantity = value; } } public string UOM { get { return uom; } set { uom = value; } } public static LoadUsageExportDetailDTO FromCsv(string csvLine) { string[] values = csvLine.Split(','); LoadUsageExportDetailDTO TempDTO = new LoadUsageExportDetailDTO(); TempDTO.SlNo = Convert.ToInt64(values[0]); TempDTO.DocumentDetailId = Convert.ToInt32(values[1]); TempDTO.ItemName = Convert.ToString(values[2]); TempDTO.ContractNumber = Convert.ToString(values[3]); // TempDTO.ContractDate = Convert.ToDateTime(values[4]);we can not give convert to date in Csv..through service date format issue is coming TempDTO.Party = Convert.ToString(values[5]); TempDTO.Branch = Convert.ToString(values[6]); TempDTO.Quantity = Convert.ToDecimal(values[7]); TempDTO.UOM = Convert.ToString(values[8]); return TempDTO; } } }