private static bool InsertFileDataInDatabase(DataTable tblFileData, WaweDBEntities context) { bool result = true; try { foreach (DataRow row in tblFileData.Rows) { context.tblUploads.Add(new tblUpload { Date = Convert.ToDateTime(row[0]), Category = row[1].ToString(), EmployeeName = row[2].ToString(), EmployeeAddress = row[3].ToString(), ExpenseDescription = row[4].ToString(), PreTaxAmount = Convert.ToDecimal(row[5]), TaxName = row[6].ToString(), TaxAmount = Convert.ToDecimal(row[7]) }); } context.SaveChanges(); } catch (Exception ex) { result = false; throw new Exception(ex.Message); } result = true; return(result); }
{ //zahoorbutt public static DataTable ProcessUpload(string fileLocation) { WaweDBEntities context = new WaweDBEntities(); bool result = false; DataTable dtFile = new DataTable(); dtFile = ProcessCSV(fileLocation); if (dtFile != null) { result = InsertFileDataInDatabase(dtFile, context); } return(dtFile); }