private UIBulkUploadSearch PLoadBulkUpload() { long?TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; UIBulkUploadSearch objUIBulkUploadSearch = new UIBulkUploadSearch(); List <DOGEN_BulkImport> lstDOGEN_BulkImport = new List <DOGEN_BulkImport>(); errorMessage = string.Empty; try { long workBasketLkp = currentUser.WorkBasketLkup.ToInt64(); objUIBulkUploadSearch.WorkbasketLkup = workBasketLkp; objUIBulkUploadSearch.lstWorkbasket = CacheUtility.GetAllLookupsFromCache(LookupTypes.WorkBasket.ToInt64()); objUIBulkUploadSearch.lstDiscCategary = CacheUtility.GetAllLookupMasterCorrelationFromCache((long)LookupTypesCorrelation.WorkBasketVsDiscripancyCategory, workBasketLkp); objUIBulkUploadSearch.lstDOGEN_BulkImportExcelTemplateMaster = CacheUtility.GetBulkImportExcelTemplateFromCache().lstDOGEN_BulkImportExcelTemplateMaster.Where(x => x.TemplateTypeLkup == TemplateType.BulkUpload.ToInt64()).ToList(); objUIBulkUploadSearch.TemplateTypeLkup = TemplateType.BulkUpload.ToLong(); ExceptionTypes result = _objBLBulkUpload.GetBulkUploadSearchResult(TimeZone, objUIBulkUploadSearch, out lstDOGEN_BulkImport, out errorMessage); if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.BulkUpload, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage); } objUIBulkUploadSearch.lstDOGEN_BulkImport = lstDOGEN_BulkImport; return(objUIBulkUploadSearch); } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.BulkUpload, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString()); throw ex; } }
/// <summary> /// Get Bulk upload search result /// </summary> /// <param name="objUIBulkUploadSearch"></param> /// <returns></returns> public ActionResult GetSearchResult(UIBulkUploadSearch objUIBulkUploadSearch) { try { return(PartialView("_SearchResult", PLoadBulkUploadSearchResult(objUIBulkUploadSearch))); } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.BulkUpload, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString()); return(PartialView("")); } }
private List <DOGEN_BulkImport> PLoadBulkUploadSearchResult(UIBulkUploadSearch objUIBulkUploadSearch) { long?TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; List <DOGEN_BulkImport> lstDOGEN_BulkImport = new List <DOGEN_BulkImport>(); errorMessage = string.Empty; try { objUIBulkUploadSearch.TemplateTypeLkup = TemplateType.BulkUpload.ToLong(); ExceptionTypes result = _objBLBulkUpload.GetBulkUploadSearchResult(TimeZone, objUIBulkUploadSearch, out lstDOGEN_BulkImport, out errorMessage); if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.BulkUpload, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage); } return(lstDOGEN_BulkImport); } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.BulkUpload, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString()); throw ex; } }
public ExceptionTypes GetBulkUploadSearchResult(long?TimeZone, UIBulkUploadSearch objUIBulkUploadSearch, out List <DOGEN_BulkImport> lstDOGEN_BulkImport, out string errorMessage) { _dsResult = new DataSet(); _lstParameters = new List <SqlParameter>(); SqlParameter sqlParam; long lErrocode = 0; long lErrorNumber = 0; errorMessage = string.Empty; lstDOGEN_BulkImport = new List <DOGEN_BulkImport>(); try { if (!objUIBulkUploadSearch.BulkImportID.IsNull()) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@GEN_BulkImportId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objUIBulkUploadSearch.BulkImportID; _lstParameters.Add(sqlParam); } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@TemplateTypeLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objUIBulkUploadSearch.TemplateTypeLkup; _lstParameters.Add(sqlParam); if (!objUIBulkUploadSearch.WorkbasketLkup.IsNull()) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@WorkbasketLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objUIBulkUploadSearch.WorkbasketLkup; _lstParameters.Add(sqlParam); } if (!objUIBulkUploadSearch.DiscrepancyCategoryLkup.IsNull()) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@DiscrepancyCategoryLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objUIBulkUploadSearch.DiscrepancyCategoryLkup; _lstParameters.Add(sqlParam); } if (!objUIBulkUploadSearch.StartDate.IsNull()) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@StartDate"; sqlParam.SqlDbType = SqlDbType.Date; sqlParam.Value = objUIBulkUploadSearch.StartDate; _lstParameters.Add(sqlParam); } if (!objUIBulkUploadSearch.EndDate.IsNull()) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@EndDate"; sqlParam.SqlDbType = SqlDbType.DateTime; sqlParam.Value = objUIBulkUploadSearch.EndDate; _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.ExecuteSelectSP(ConstantTexts.SP_APP_SEL_BulkImport, _lstParameters.ToArray(), out _dsResult, out lErrocode, out lErrorNumber, 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)) { MapGetBulkImport(TimeZone, _dsResult, out lstDOGEN_BulkImport); return(ExceptionTypes.Success); } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } finally { _dsResult = null; _lstParameters = null; } }
public ExceptionTypes GetBulkUploadSearchResult(long?TimeZone, UIBulkUploadSearch objUIBulkUploadSearch, out List <DOGEN_BulkImport> lstDOGEN_BulkImport, out string errorMessage) { _exceptionTypes = new ExceptionTypes(); return(_exceptionTypes = objDALBulkUpload.GetBulkUploadSearchResult(TimeZone, objUIBulkUploadSearch, out lstDOGEN_BulkImport, out errorMessage)); }