public bool ImportData(Object Configuration, String DBConnectionString) { IMSClasses.Jobs.Job oCurrentJob = (IMSClasses.Jobs.Job)Configuration; DataTable oDT = null; bool bCorrect = true; String sError = ""; db oDB = new db(DBConnectionString); try { oDT = IMSClasses.excellHelpper.ExcelHelpper.getExcelData(oCurrentJob.InputParameters.Files[0].FileName, oCurrentJob.SQLParameters.TableName); } catch (Exception xlException) { bCorrect = false; sError = "Error getting excel data --> Exception --> " + xlException.Message; } if (bCorrect) { try { bCorrect = oDB.LoadTable(oDT); } catch (Exception dbException) { bCorrect = false; sError = "Error loading data in DB --> Exception --> " + dbException.Message; } } return bCorrect; }
public bool ImportData(Object Configuration, String DBConnectionString) { IMSClasses.Jobs.Job oCurrentJob = (IMSClasses.Jobs.Job)Configuration; DataTable oDT = null; bool bCorrect = true; db oDB = new db(DBConnectionString); int iIdentity = 1; List<IMSClasses.Jobs.File>.Enumerator oEFiles = oCurrentJob.InputParameters.Files.GetEnumerator(); while (oEFiles.MoveNext() && bCorrect) { try { String sTableName = oCurrentJob.SQLParameters.TableName.Replace(@"%identity%", iIdentity.ToString()); IMSClasses.Jobs.File oCurrentFile = oEFiles.Current; oDT = ExcelHelpper.getExcelData(oCurrentFile.FileName, sTableName); } catch(Exception eLoadException) { bCorrect = false; } if (bCorrect) { try { bCorrect = oDB.LoadTable(oDT); } catch (Exception dbException) { bCorrect = false; } } if (bCorrect) iIdentity++; } return bCorrect; }