Boolean ImportFile(List <string> filepaths, List <string> sources, string wiredt)
{
string _yrmo = ddlYrmo.SelectedItem.Text;
bool importStat = false;
VWA_ExcelImport tObj = new VWA_ExcelImport();
DataSet ds = new DataSet(); ds.Clear();
int _totalcounter = 0;
for (int i = 0; i < filepaths.Count; i++)
{
VWAImportDAL.Rollback(sources[i], _yrmo);
ds = tObj.importRemittance(filepaths[i], sources[i]);
_counter = tObj.parseRemittance(ds, _yrmo, sources[i]);
VWAImportDAL.insertImportStatus(_yrmo, sources[i]);
SetImportStatus(sources[i]);
_totalcounter += _counter;
}
VWAImportDAL.updateRemitWireDt(wiredt, _yrmo);
VWA_Results.SavePrintFiles(source, _yrmo);
Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1;
Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "VWA", "VWA Imports", "VWA_remit", "Remittance Reports", _yrmo, _totalcounter);
importStat = true;
return(importStat);
}
Boolean ImportFile(string strFilePath1)
{
string _yrmo = ddlYrmo.SelectedItem.Text;
bool importStat = false;
VWAImport vobj = new VWAImport();
VWAImportDAL.Rollback("BankStat", _yrmo);
_counter = vobj.importBOA_VWA(_yrmo, strFilePath1);
VWAImportDAL.insertImportStatus(_yrmo, source);
Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1;
Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "VWA", "VWA Imports", "VWA_Bank", "Bank Statement", _yrmo, _counter);
importStat = true;
return(importStat);
}