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));
}
