public DataSet getExcelData(string _file, string tablename)
{
DataTable dt = new DataTable(tablename);
impData.Tables.Add(iobj.ConvertXLS(_file, dt));
return(impData);
}
public int ImportHRAAUDITR(string _filepath, string _source, string _qy)
{
int _counter = 0;
HRAImportDAL iobj = new HRAImportDAL();
HRAConvertExcel tObj = new HRAConvertExcel();
HRAParseData pObj = new HRAParseData();
DataSet ds = new DataSet(); ds.Clear();
DataTable dt = new DataTable("AUDITRTable");
iobj.Rollback(_source, _qy);
ds.Tables.Add(tObj.ConvertXLS(_filepath, dt));
_counter = pObj.parseHRAAUDITR(ds, _qy);
return(_counter);
}