public DataSet importPutnam(string _file)
        {
            DataTable dt = new DataTable("PutnamTable");

            impData.Tables.Add(iobj.ConvertRangeXLS(_file, dt, "First Name", 0));
            return(impData);
        }
Beispiel #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);
        }
Beispiel #3
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);
        }
        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);
        }