public int ImportWgwkInvoice(string _filepath, string _source, string yrmo)
{
int _counter = 0;
HRAConvertExcel tObj = new HRAConvertExcel();
HRAParseData pObj = new HRAParseData();
DataSet ds = new DataSet();
DataTable dt = new DataTable("WgwkInvTable");
ds.Tables.Add(tObj.ConvertRangeXLS(_filepath, dt, "Last Name", 1));
_counter = pObj.parseWageworkInvoice(ds, _filepath, _source, yrmo);
return(_counter);
}
public int ImportPtnmPartData(string _filepath, string _source, string _qy)
{
int _counter = 0;
HRAConvertExcel tObj = new HRAConvertExcel();
HRAParseData pObj = new HRAParseData();
DataSet ds = new DataSet(); ds.Clear();
DataTable dt = new DataTable("PutnamPartTable");
ds.Tables.Add(tObj.ConvertRangeXLS(_filepath, dt, "SSN", 0));
_counter = pObj.parsePutnamPartData(ds, _filepath, _source, _qy);
return(_counter);
}
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);
}
public DataSet getCignaAdminFeeBillData(string _file, string tablename)
{
///wire access - Importing Cigna Fee Bill Dat
//DataTable dt = new DataTable(tablename);
//impData.Tables.Add(iobj.ConvertRangeXLS(_file, dt, "Account Number", 9));
//return impData;
int _counter = 0;
HRAConvertExcel tObj = new HRAConvertExcel();
HRAParseData pObj = new HRAParseData();
DataSet ds = new DataSet(); ds.Clear();
DataTable dt = new DataTable("CignaAdminFeeTable");
ds.Tables.Add(tObj.ConvertRangeXLS(_file, dt, "Account Number", 0));
//_counter = pObj.parsePutnamPartData(ds, _filepath, _source, _qy);
return(ds);
}