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