/// <summary> /// make entry to database /// </summary> /// <param name="oldFileName"></param> /// <param name="newFileName"></param> /// <param name="filePath"></param> /// <param name="workbasketId"></param> /// <param name="discripanctCatgoryLkup"></param> /// <param name="templateId"></param> /// <param name="errorMessage"></param> /// <returns></returns> private bool SaveToDB(string oldFileName, string newFileName, string filePath, long workbasketId, long discripanctCatgoryLkup, long templateId, out string errorMessage) { bool isScuess = false; DOGEN_BulkImport objDOGEN_BulkImport = new DOGEN_BulkImport(); errorMessage = string.Empty; try { long loginUserID = currentUser.ADM_UserMasterId; objDOGEN_BulkImport.WorkBasketLkup = workbasketId; objDOGEN_BulkImport.DiscrepancyCategoryLkup = discripanctCatgoryLkup; objDOGEN_BulkImport.GEN_BulkImportExcelTemplateMasterRef = templateId; objDOGEN_BulkImport.ExcelFileName = oldFileName; objDOGEN_BulkImport.DuplicateFileName = newFileName; objDOGEN_BulkImport.ExcelFilelPath = filePath; objDOGEN_BulkImport.ImportStatusLkup = (long)ImportStatus.ReadyForImport; objDOGEN_BulkImport.IsActive = true; ExceptionTypes result = _objBLBulkUpload.SaveBulkUpload(objDOGEN_BulkImport, loginUserID, out errorMessage); if (result == ExceptionTypes.Success) { isScuess = true; } } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.BulkUpload, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString()); throw ex; } return(isScuess); }
public ExceptionTypes SaveBulkUpload(DOGEN_BulkImport objDOGEN_BulkImport, long loginUserID, out string errorMessage) { _lstParameters = new List <SqlParameter>(); SqlParameter sqlParam; long lErrocode = 0; long lErrorNumber = 0; errorMessage = string.Empty; long lRowsEffected = 0; try { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@WorkBasketLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOGEN_BulkImport.WorkBasketLkup; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@DiscrepancyCategoryLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOGEN_BulkImport.DiscrepancyCategoryLkup; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@GEN_BulkImportExcelTemplateMasterRef"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOGEN_BulkImport.GEN_BulkImportExcelTemplateMasterRef; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ExcelFileName"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOGEN_BulkImport.ExcelFileName; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@DuplicateFileName"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOGEN_BulkImport.DuplicateFileName; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ExcelFilelPath"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOGEN_BulkImport.ExcelFilelPath; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ImportStatusLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOGEN_BulkImport.ImportStatusLkup; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@LoginUserId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = loginUserID; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@GEN_BulkImportID"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Direction = ParameterDirection.Output; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ErrorMessage"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = string.Empty; sqlParam.Direction = ParameterDirection.Output; sqlParam.Size = 2000; _lstParameters.Add(sqlParam); long executionResult = _daHelper.ExecuteDMLSP(ConstantTexts.SP_APP_INS_GEN_BulkImport, _lstParameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage); sqlParam = _lstParameters.FirstOrDefault(x => x.ParameterName == "@ErrorMessage"); if (sqlParam != null && sqlParam.Value != null) { errorMessage += sqlParam.Value.ToString(); } if (executionResult == (long)ExceptionTypes.Success && string.IsNullOrEmpty(errorMessage)) { return(ExceptionTypes.Success); } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } finally { _lstParameters = null; } }
public ExceptionTypes SaveBulkUpload(DOGEN_BulkImport objDOGEN_BulkImport, long loginUserID, DataTable dtFileData, out long GEN_BulkImportID, out string errorMessage) { retValue = new ExceptionTypes(); return(retValue = _objDALCommon.SaveBulkUpload(objDOGEN_BulkImport, loginUserID, dtFileData, out GEN_BulkImportID, out errorMessage)); }
public ExceptionTypes SaveBulkUpload(DOGEN_BulkImport objDOGEN_BulkImport, long loginUserID, out string errorMessage) { _exceptionTypes = new ExceptionTypes(); return(_exceptionTypes = objDALBulkUpload.SaveBulkUpload(objDOGEN_BulkImport, loginUserID, out errorMessage)); }