Пример #1
0
        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);
        }
Пример #2
0
        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);
        }
Пример #3
0
        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);
        }
Пример #4
0
        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);
        }