public ExceptionTypes GetBulkImportExcelTemplate(out UIDOGEN_BulkImportExcelTemplate objUIDOGEN_BulkImportExcelTemplate, out string errorMessage) { _dsResult = new DataSet(); _lstParameters = new List <SqlParameter>(); SqlParameter sqlParam; long lErrocode = 0; long lErrorNumber = 0; errorMessage = string.Empty; objUIDOGEN_BulkImportExcelTemplate = new UIDOGEN_BulkImportExcelTemplate(); try { 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_BulkImportExcelTemplate, _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)) { MapGEN_BulkImportExcelTemplate(_dsResult, out objUIDOGEN_BulkImportExcelTemplate); return(ExceptionTypes.Success); } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } finally { _dsResult = null; _lstParameters = null; } }
public ExceptionTypes SearchCOnfigurationID(long?TimeZone, DOMGR_ConfigMaster configMaster, out List <DOMGR_ConfigMaster> lstDOMGR_ConfigMaster, out string errorMessage) { lstDOMGR_ConfigMaster = new List <DOMGR_ConfigMaster>(); errorMessage = string.Empty; try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; DataSet dsResultData = new DataSet(); List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; sqlParam = new SqlParameter(); sqlParam.ParameterName = "@MGR_ConfigMasterId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = configMaster.MGR_ConfigMasterId; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@IsActive"; sqlParam.SqlDbType = SqlDbType.Bit; sqlParam.Value = configMaster.IsActive; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ErrorMessage"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = string.Empty; sqlParam.Direction = ParameterDirection.Output; sqlParam.Size = 2000; parameters.Add(sqlParam); long executionResult = dah.ExecuteSelectSP(ConstantTexts.USP_APP_SEL_ConfigMaster, parameters.ToArray(), out dsResultData, out lErrocode, out lErrorNumber, out errorMessage); if (executionResult == 0) { if (dsResultData.Tables.Count > 0 && dsResultData.Tables[0].Rows.Count > 0) { MapConfigMstDetails(TimeZone, dsResultData.Tables[0], out lstDOMGR_ConfigMaster); return(ExceptionTypes.Success); } else { return(ExceptionTypes.ZeroRecords); } } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } }
public ExceptionTypes CheckDuplicateDep(long?TimeZone, DOCMN_Department objDOCMN_Department, out List <DOCMN_Department> lstDOCMN_Department, out string errorMessage) { lstDOCMN_Department = new List <DOCMN_Department>(); errorMessage = string.Empty; try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; DataSet dsResultData = new DataSet(); List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; sqlParam = new SqlParameter(); sqlParam.ParameterName = "@BusinessSegmentLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOCMN_Department.BusinessSegmentLkup; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@DepartmentLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOCMN_Department.DepartmentLkup; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ErrorMessage"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = string.Empty; sqlParam.Direction = ParameterDirection.Output; sqlParam.Size = 2000; parameters.Add(sqlParam); long executionResult = dah.ExecuteSelectSP(ConstantTexts.SP_USP_APP_SEL_Department, parameters.ToArray(), out dsResultData, out lErrocode, out lErrorNumber, out errorMessage); if (executionResult == 0) { if (dsResultData.Tables.Count > 0 && dsResultData.Tables[0].Rows.Count > 0) { MapDepartmentDetails(TimeZone, dsResultData.Tables[0], out lstDOCMN_Department); return(ExceptionTypes.Success); } else { return(ExceptionTypes.ZeroRecords); } } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } }
public ExceptionTypes GetAccessGroupForEdit(DOADM_AccessGroupMaster objDOADM_AccessGroupMaster, out UIDOAccessGroup objUIDOAccessGroup) { objUIDOAccessGroup = new UIDOAccessGroup(); try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; DataSet dsTable = new DataSet(); string errorMessage; List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; if (objDOADM_AccessGroupMaster.ADM_AccessGroupMasterId > 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@AccessGroupMasterId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOADM_AccessGroupMaster.ADM_AccessGroupMasterId; parameters.Add(sqlParam); } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ErrorMessage"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = string.Empty; sqlParam.Direction = ParameterDirection.Output; sqlParam.Size = 2000; parameters.Add(sqlParam); long executionResult = dah.ExecuteSelectSP(ConstantTexts.SP_USP_APP_SEL_AccesssGroup, parameters.ToArray(), out dsTable, out lErrocode, out lErrorNumber, out errorMessage); if (executionResult == 0) { if (dsTable.Tables.Count > 0 && dsTable.Tables[0].Rows.Count > 0) { MapUIDOAccessGroupObjectProperties(dsTable, out objUIDOAccessGroup); if (objUIDOAccessGroup != null) { return(ExceptionTypes.Success); } } return(ExceptionTypes.ZeroRecords); } else if (executionResult == 2) { return(ExceptionTypes.ZeroRecords); } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { return(ExceptionTypes.UnknownError); } }
public ExceptionTypes GetAllLookups(long?lookupTypeId, out List <DOCMN_LookupType> lstLookupType, out List <DOCMN_LookupMaster> lstLookupMaster) //out List<DOCMN_LookupMaster> lstDOCMN_LookupMaster) { lstLookupType = new List <DOCMN_LookupType>(); lstLookupMaster = new List <DOCMN_LookupMaster>(); try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; _dsResult = new DataSet(); string errorMessage; _lstParameters = new List <SqlParameter>(); SqlParameter sqlParam; if (lookupTypeId != null && lookupTypeId > 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CMN_LookupTypeId"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = lookupTypeId; _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 = dah.ExecuteSelectSP(ConstantTexts.SP_APP_SEL_Lookups, _lstParameters.ToArray(), out _dsResult, out lErrocode, out lErrorNumber, out errorMessage); if (executionResult == 0) { if (_dsResult.Tables.Count > 0 && _dsResult.Tables[1].Rows.Count > 0) { MapAllLookups(_dsResult, out lstLookupType, out lstLookupMaster); return(ExceptionTypes.Success); } else { return(ExceptionTypes.ZeroRecords); } } else { return(ExceptionTypes.UnknownError); } } catch { //need log return(ExceptionTypes.UnknownError); } }
public ExceptionTypes GetMIIMQueueDetailsByHICN(string MemberHICN, out List <DOMIIMGetQueue> Queues) { List <DOMIIMGetQueue> lstDOMIIMGetQueue = new List <DOMIIMGetQueue>(); string errorMessage = string.Empty; Queues = new List <DOMIIMGetQueue>(); DataSet dsResultData = new DataSet(); try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; List <SqlParameter> parameters = new List <SqlParameter>(); //call function to map object properties to SQL parameters for query execution SqlParameter sqlParam = new SqlParameter(); sqlParam.ParameterName = "@HICN"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = MemberHICN; parameters.Add(sqlParam); long executionResult = dah.ExecuteSelectSP(ConstantTexts.SP_APP_SEL_GetQueueDetailsByHICN, parameters.ToArray(), out dsResultData, out lErrocode, out lErrorNumber, out errorMessage); if (executionResult == 0) { if (dsResultData.Tables.Count > 0 && dsResultData.Tables[0].Rows.Count > 0) { MappingDatasetToObject(dsResultData, out Queues); return(ExceptionTypes.Success); } else { return(ExceptionTypes.ZeroRecords); } } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } }
public ExceptionTypes SearchResources(long?TimeZone, DOADM_ResourceDetails objDOADM_ResourceDetails, out List <DOADM_ResourceDetails> lstDOADM_ResourceDetails, out string errorMessage) { lstDOADM_ResourceDetails = new List <DOADM_ResourceDetails>(); errorMessage = string.Empty; try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; DataSet dsResultData = new DataSet(); List <SqlParameter> parameters = new List <SqlParameter>(); //call function to map object properties to SQL parameters for query execution parameters = MapResourceDetailsResourceDO(objDOADM_ResourceDetails); //Is it required SqlParameter sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ConsiderDates"; sqlParam.SqlDbType = SqlDbType.Bit; sqlParam.Value = objDOADM_ResourceDetails.ConsiderDates; parameters.Add(sqlParam); long executionResult = dah.ExecuteSelectSP(ConstantTexts.SP_USP_ERS_APP_SEL_ResourceDetails, parameters.ToArray(), out dsResultData, out lErrocode, out lErrorNumber, out errorMessage); if (executionResult == 0) { if (dsResultData.Tables.Count > 0 && dsResultData.Tables[0].Rows.Count > 0) { //call function to map dataset result to object properties MapResourceDOResourceDetails(TimeZone, dsResultData.Tables[0], out lstDOADM_ResourceDetails); return(ExceptionTypes.Success); } else { return(ExceptionTypes.ZeroRecords); } } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } }
/// <summary> /// Method to get the cases for TRC155 macros /// </summary> /// <param name="p_HouseholdID"></param> /// <param name="p_HICN"></param> /// <param name="p_Contract"></param> /// <param name="p_PBP"></param> /// <param name="p_EffectiveDate"></param> /// <param name="p_DiscrepancyType"></param> /// <param name="Queues"></param> /// <returns></returns> public ExceptionTypes GetCasesForTRC155Macro(string p_HouseholdID, string p_HICN, string p_Contract, String p_PBP, string p_EffectiveDate, string p_DiscrepancyType, out List <DOMacroData> Queues, out string errorMessage) { List <DOMacroData> lstDoMacroTRCData = new List <DOMacroData>(); p_HouseholdID = ((p_HouseholdID == null) || (p_HouseholdID == "null")) ? null : p_HouseholdID; p_HICN = ((p_HICN == null) || (p_HICN == "null")) ? null : p_HICN; p_Contract = ((p_Contract == null) || (p_Contract == "null")) ? null : p_Contract; p_PBP = ((p_PBP == null) || (p_PBP == "null")) ? null : p_PBP; p_EffectiveDate = ((p_EffectiveDate == "null") || (p_EffectiveDate == "01/01/0001") || (p_EffectiveDate == null)) ? null : p_EffectiveDate.Replace('-', '/'); p_DiscrepancyType = ((p_DiscrepancyType == null) || (p_DiscrepancyType == "null")) ? null : p_DiscrepancyType; errorMessage = string.Empty; Queues = new List <DOMacroData>(); DataSet dsResultData = new DataSet(); try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; SqlParameter sqlParam = new SqlParameter(); List <SqlParameter> parameters = new List <SqlParameter>(); //call function to map object properties to SQL parameters for query execution sqlParam = new SqlParameter(); sqlParam.ParameterName = "@HouseholdID"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = p_HouseholdID; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@HICN"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = p_HICN; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@Contract"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = p_Contract; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@PBP"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = p_PBP; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@EffectiveDate"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = p_EffectiveDate; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@DiscrepancyType"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = p_DiscrepancyType; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ErrorMessage"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = string.Empty; sqlParam.Direction = ParameterDirection.Output; sqlParam.Size = 2000; parameters.Add(sqlParam); long executionResult = dah.ExecuteSelectSP(ConstantTexts.SP_APP_SEL_TRC155_Macro, parameters.ToArray(), out dsResultData, out lErrocode, out lErrorNumber, out errorMessage); sqlParam = parameters.FirstOrDefault(x => x.ParameterName == "@ErrorMessage"); if (sqlParam != null && sqlParam.Value != null) { errorMessage += sqlParam.Value.ToString(); } if (executionResult == 0 && string.IsNullOrEmpty(errorMessage)) { if (dsResultData.Tables.Count > 0 && dsResultData.Tables[0].Rows.Count > 0) { MappingDatasetToObject(dsResultData, out Queues); return(ExceptionTypes.Success); } else { return(ExceptionTypes.ZeroRecords); } } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { DALCommon.LogError(23, MethodBase.GetCurrentMethod().ToString(), (long)ErrorModuleName.Macro, (long)ExceptionTypes.Exception, ex.InnerException.Message, ""); errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } }
public ExceptionTypes GetAllReports(long?lRptIdout, string sReportName, out List <DORPT_ReportsMaster> lstDORPT_ReportsMaster, out string errorMessage) { lstDORPT_ReportsMaster = new List <DORPT_ReportsMaster>(); errorMessage = string.Empty; try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; DataSet dsTable = new DataSet(); List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; if (lRptIdout > 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@RPT_ReportsMasterId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = lRptIdout; parameters.Add(sqlParam); } if (sReportName != string.Empty) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ReportName"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = sReportName; parameters.Add(sqlParam); } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ErrorMessage"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = string.Empty; sqlParam.Direction = ParameterDirection.Output; sqlParam.Size = 2000; parameters.Add(sqlParam); long executionResult = dah.ExecuteSelectSP(ConstantTexts.SP_USP_APP_SEL_Reports, parameters.ToArray(), out dsTable, out lErrocode, out lErrorNumber, out errorMessage); if (executionResult == 0) { if (dsTable.Tables.Count > 0 && dsTable.Tables[0].Rows.Count > 0) { MapObjectProperties(dsTable, out lstDORPT_ReportsMaster); if (lstDORPT_ReportsMaster.Count > 0) { return(ExceptionTypes.Success); } } return(ExceptionTypes.ZeroRecords); } else if (executionResult == 2) { return(ExceptionTypes.ZeroRecords); } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { return(ExceptionTypes.UnknownError); } }
/// <summary> /// Get All Lookup For LookUp Type Search /// </summary> /// <param name="strDescription"></param> /// <param name="isActive"></param> /// <param name="lstDOCMN_LookupType"></param> /// <returns></returns> public ExceptionTypes GetAllLookupTypes(long?TimeZone, string strDescription, bool isActive, out List <DOCMN_LookupType> lstDOCMN_LookupType) { _dsResult = new DataSet(); _lstParameters = new List <SqlParameter>(); SqlParameter sqlParam; long lErrocode = 0; long lErrorNumber = 0; string errorMessage = string.Empty; lstDOCMN_LookupType = new List <DOCMN_LookupType>(); try { if (strDescription != string.Empty) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@LookupTypeDescription"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = strDescription; _lstParameters.Add(sqlParam); } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@IsActive"; sqlParam.SqlDbType = SqlDbType.Bit; sqlParam.Value = isActive; _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_Lookups, _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)) { MapAllLookupTypes(TimeZone, _dsResult, out lstDOCMN_LookupType); return(ExceptionTypes.Success); } else { return(ExceptionTypes.UnknownError); } } catch (Exception) { return(ExceptionTypes.UnknownError); } finally { _dsResult = null; _lstParameters = null; } }
public ExceptionTypes SearchSkills(long?TimeZone, DOADM_SkillsMaster objDOADM_SkillsDetails, out List <DOADM_SkillsMaster> lstDOADM_SkillsDetails, out string errorMessage) { lstDOADM_SkillsDetails = new List <DOADM_SkillsMaster>(); objDOADM_SkillsDetails.lstDOADM_SkillWorkQueuesCorrelation = new List <DOADM_SkillWorkQueuesCorrelation>(); errorMessage = string.Empty; try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; DataSet dsResultData = new DataSet(); List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; if (objDOADM_SkillsDetails.ADM_SkillsMasterId != 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ADM_SkillsMasterId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOADM_SkillsDetails.ADM_SkillsMasterId; parameters.Add(sqlParam); } if (!string.IsNullOrEmpty(objDOADM_SkillsDetails.SkillsName)) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@SkillsName"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_SkillsDetails.SkillsName; parameters.Add(sqlParam); } if (objDOADM_SkillsDetails.RoleLkup != 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@RoleLkup"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_SkillsDetails.RoleLkup; parameters.Add(sqlParam); } if (objDOADM_SkillsDetails.BusinessSegmentLkup != 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@BusinessSegmentLkup"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_SkillsDetails.BusinessSegmentLkup; parameters.Add(sqlParam); } if (objDOADM_SkillsDetails.DiscrepancyCategoryLkup != 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@DiscrepancyCategoryLkup"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_SkillsDetails.DiscrepancyCategoryLkup; parameters.Add(sqlParam); } if (objDOADM_SkillsDetails.CMN_DepartmentRef != 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CMN_DepartmentRef"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_SkillsDetails.CMN_DepartmentRef; parameters.Add(sqlParam); } if (objDOADM_SkillsDetails.WorkBasketLkup != 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@WorkBasketLkup"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_SkillsDetails.WorkBasketLkup; parameters.Add(sqlParam); } //Uncomment after User search SP modofication //No Null check, IsActive key boolean key by defaut will be false and cannot be null sqlParam = new SqlParameter(); sqlParam.ParameterName = "@IsActive"; sqlParam.SqlDbType = SqlDbType.Bit; sqlParam.Value = objDOADM_SkillsDetails.IsActive; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ErrorMessage"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = string.Empty; sqlParam.Direction = ParameterDirection.Output; sqlParam.Size = 2000; parameters.Add(sqlParam); long executionResult = dah.ExecuteSelectSP(ConstantTexts.SP_USP_APP_SEL_Skills, parameters.ToArray(), out dsResultData, out lErrocode, out lErrorNumber, out errorMessage); if (executionResult == 0) { if (dsResultData.Tables.Count > 0 && dsResultData.Tables[0].Rows.Count > 0) { MapSkillsDOSkillsMaster(TimeZone, dsResultData, out lstDOADM_SkillsDetails); return(ExceptionTypes.Success); } else { return(ExceptionTypes.ZeroRecords); } } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } }
public ExceptionTypes GetAccessGroupBasedOnSearch(long?TimeZone, DOADM_AccessGroupMaster objDOADM_AccessGroupMaster, out List <DOADM_AccessGroupMaster> lstDOADM_AccessGroupMaster) { lstDOADM_AccessGroupMaster = new List <DOADM_AccessGroupMaster>(); try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; DataSet dsTable = new DataSet(); string errorMessage; List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; if (objDOADM_AccessGroupMaster.ADM_AccessGroupMasterId > 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@AccessGroupMasterId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOADM_AccessGroupMaster.ADM_AccessGroupMasterId; parameters.Add(sqlParam); } if (!string.IsNullOrEmpty(objDOADM_AccessGroupMaster.AccessGroupName)) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@AccessGroupName"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_AccessGroupMaster.AccessGroupName; parameters.Add(sqlParam); } if (!string.IsNullOrEmpty(objDOADM_AccessGroupMaster.AccessGroupDescription)) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@AccessGroupDescription"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_AccessGroupMaster.AccessGroupDescription; parameters.Add(sqlParam); } if (objDOADM_AccessGroupMaster.IsActive != null) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@IsActive"; sqlParam.SqlDbType = SqlDbType.Bit; sqlParam.Value = objDOADM_AccessGroupMaster.IsActive; parameters.Add(sqlParam); } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ErrorMessage"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = string.Empty; sqlParam.Direction = ParameterDirection.Output; sqlParam.Size = 2000; parameters.Add(sqlParam); long executionResult = dah.ExecuteSelectSP(ConstantTexts.SP_USP_APP_SEL_AccesssGroup, parameters.ToArray(), out dsTable, out lErrocode, out lErrorNumber, out errorMessage); if (executionResult == 0) { if (dsTable.Tables.Count > 0 && dsTable.Tables[0].Rows.Count > 0) { MapObjectProperties(TimeZone, dsTable, out lstDOADM_AccessGroupMaster); if (lstDOADM_AccessGroupMaster.Count > 0) { return(ExceptionTypes.Success); } } return(ExceptionTypes.ZeroRecords); } else if (executionResult == 2) { return(ExceptionTypes.ZeroRecords); } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { return(ExceptionTypes.UnknownError); } }
public ExceptionTypes GetCaseDetails(string strContractId, string strHICN, long lDiscrepancyType, long lTransactionTypeLkup, out List <FDRSubmissionRow> lstResults, out string errorMessage) { _dsResult = new DataSet(); _lstParameters = new List <SqlParameter>(); SqlParameter sqlParam; long lErrocode = 0; long lErrorNumber = 0; lstResults = new List <FDRSubmissionRow>(); try { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CurrentHICN"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = strHICN; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ContractID"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = strContractId; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@TransactionTypeLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = lTransactionTypeLkup; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@DiscrepancyTypeLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = lDiscrepancyType; _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); //Current Queues(RPR - Re - Submission, RPR - SCC RPR Re - Submission, RPR - SCC RPR Sent, RPR - Sent to RPC) long executionResult = _objDAHelper.ExecuteSelectSP(ConstantTexts.SP_BGP_SEL_FDRGetCaseDetails, _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)) { MapCaseDetails(_dsResult, out lstResults); return(ExceptionTypes.Success); } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } finally { _dsResult = null; _lstParameters = null; } }