public DataSet getExcelData(string _file, string tablename)
        {
            DataTable dt = new DataTable(tablename);

            impData.Tables.Add(iobj.ConvertXLS(_file, dt));
            return(impData);
        }
Beispiel #2
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);
        }