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);
}
