public bool Upload(string strFileName, int iClass)
 {
     ExcelDataAccess exceldataaccess = new ExcelDataAccess();
     DataSet ds = (DataSet)exceldataaccess.GetDataSetFromExcel(strFileName);
     foreach (DataRow dr in ds.Tables[0].Rows)
     {
         InsertIntoTempTable(iClass, ds.Tables[0].Columns, dr);
     }
     return true;
 }
 public int Upload(string strFileName)
 {
     ExcelDataAccess exceldataaccess = new ExcelDataAccess();
     DataSet ds = (DataSet)exceldataaccess.GetDataSetFromExcel(strFileName);
     int iBatchID = GetBatchID();
     foreach (DataRow dr in ds.Tables[0].Rows)
     {
         InsertIntoTempTable(iBatchID, ds.Tables[0].Columns, dr);
     }
     return ValidateUpload(iBatchID);
 }