public ExceptionTypes SetCurrentBatchStatus(out string errorMessage) { try { DAHelper dah = new DAHelper(); DataSet dsTable = new DataSet(); errorMessage = string.Empty; long executionResult = 0; executionResult = dah.ExecuteScalar(ConstantTexts.Query_Update_MQTRRBatchStatus, new List <SqlParameter>().ToArray(), out object obj, out string erorrMessage); if (executionResult == 0) { return(ExceptionTypes.Success); } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { Console.WriteLine("Error : " + ex.Message); errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } }
public ExceptionTypes CheckValidRecordCount(long BulkImportID, out string errorMessage) { try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; long lRowsEffected = 0; DataSet dsTable = new DataSet(); errorMessage = string.Empty; List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; sqlParam = new SqlParameter(); sqlParam.ParameterName = "@GEN_FDRBulkImportId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = BulkImportID; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ImportStatusLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = (long)ImportStatus.ImportSuccessful; parameters.Add(sqlParam); sqlParam = new SqlParameter(); 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 = 0; executionResult = executionResult = dah.ExecuteDMLSP(ConstantTexts.SP_USP_BGP_UPD_FDRTotalRecordsCount, parameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage); sqlParam = parameters.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); } }
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 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 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); } }
/// <summary> /// Method to update the cases for TRC155 Macro /// </summary> /// <param name="objDOMacroUpdate"></param> /// <param name="userid"></param> /// <returns></returns> public ExceptionTypes UpdateCaseForTRC155Macro(DOMacroUpdate objDOMacroUpdate, long userid, out string errormessage) { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; errormessage = string.Empty; SqlParameter sqlParam = new SqlParameter(); List <SqlParameter> _lstParameters = new List <SqlParameter>(); //call function to map object properties to SQL parameters for query execution sqlParam = new SqlParameter(); sqlParam.ParameterName = "@GEN_QueueId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOMacroUpdate.GEN_QueueId; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@Status"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOMacroUpdate.Status; _lstParameters.Add(sqlParam); //sqlParam = new SqlParameter(); //sqlParam.ParameterName = "@CurrentUser"; //sqlParam.SqlDbType = SqlDbType.VarChar; //sqlParam.Value = objDOMacroUpdate.LoginID; //_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.ExecuteDMLSP(ConstantTexts.SP_UPD_TRC155_Macro, _lstParameters.ToArray(), out lErrocode, out lErrorNumber, out long lRowsEffected, out string 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); } }
public ExceptionTypes UpdateOOAMIIMComments(List <DOMIIMOOACommentUpdate> lstDOMIIMOOACommentUpdate, long userid) { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; SqlParameter sqlParam = new SqlParameter(); List <SqlParameter> _lstParameters = new List <SqlParameter>(); //call function to map object properties to SQL parameters for query execution if (lstDOMIIMOOACommentUpdate.Count() > 0) { DataSet ds = new DataSet("tbl_Comments"); ds.Tables.Add(lstDOMIIMOOACommentUpdate.Where(x => x.ERSCaseId != 0).ToList().ToDataTable()); string xmlData = ds.GetXml(); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@XMLComments"; sqlParam.SqlDbType = SqlDbType.NVarChar; sqlParam.Value = xmlData; _lstParameters.Add(sqlParam); } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@LoginUserId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = userid; _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.ExecuteDMLSP(ConstantTexts.SP_APP_UPD_UpdateOOAComments, _lstParameters.ToArray(), out lErrocode, out lErrorNumber, out long lRowsEffected, out string 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); } }
public ExceptionTypes GetIncludeInTodaysSubmission(out List <IncludeInTodaysSubmission> lstIncludeInTodaysSubmission, out string errorMessage) { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; long lRowsEffected = 0; DataSet dsTable = new DataSet(); errorMessage = string.Empty; lstIncludeInTodaysSubmission = new List <IncludeInTodaysSubmission>(); errorMessage = string.Empty; List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; try { 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 = 0; executionResult = executionResult = dah.ExecuteDMLSP(ConstantTexts.SP_BGP_SEL_IncludeInTodaysSubmission, parameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage); sqlParam = parameters.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); } }
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); } }
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 SaveAlert(DOADM_AlertDetails objDOADM_AlertDetails, out string errorMessage) { errorMessage = string.Empty; 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 parameters = MapAlertDetailsAlertDO(objDOADM_AlertDetails); //Extra parameter when adding or editing record for releasing lock //not needed when searching records SqlParameter sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ScreenLkup"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = (long)ScreenType.Alerts; parameters.Add(sqlParam); long executionResult = dah.ExecuteDMLSP(ConstantTexts.USP_APP_INS_UPD_AlertsDetails, parameters.ToArray(), out lErrocode, out lErrocode, out lErrorNumber, out errorMessage); if (executionResult == 0) { return(ExceptionTypes.Success); } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } }
public ExceptionTypes GetCaseDiscrepancyCategory(long lQueueID, out long lDiscrepancyCategory, out string errorMessage) { DAHelper dah = new DAHelper(); errorMessage = string.Empty; List <SqlParameter> parameters = new List <SqlParameter>(); //call function to map object properties to SQL parameters for query execution SqlParameter sqlParam = new SqlParameter(); sqlParam.ParameterName = "@lQueueID"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = lQueueID; parameters.Add(sqlParam); string query = "Select DiscrepancyCategoryLkup from Gen_Queue where Gen_QueueId=@lQueueID"; long executionResult = dah.ExecuteScalar(query, parameters.ToArray(), out object DiscrepancyCategoryLkup, out string erorrMessage); lDiscrepancyCategory = (!DiscrepancyCategoryLkup.IsNull()) ? DiscrepancyCategoryLkup.ToInt64() : 0; return((ExceptionTypes)executionResult); }
public ExceptionTypes GetQueueIdFromMIIMRefernceId(string strMIIMReferenceId, out string strErsCaseId, out string errorMessage) { DAHelper dah = new DAHelper(); errorMessage = string.Empty; strErsCaseId = string.Empty; List <SqlParameter> parameters = new List <SqlParameter>(); //call function to map object properties to SQL parameters for query execution SqlParameter sqlParam = new SqlParameter(); sqlParam.ParameterName = "@strMIIMReferenceId"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = strMIIMReferenceId; parameters.Add(sqlParam); string query = "Select GEN_QueueId from Gen_Queue where MIIMReferenceId = @strMIIMReferenceId"; long executionResult = dah.ExecuteSQL(query, parameters.ToArray(), out DataSet GEN_QueueIds, out string erorrMessage, true); strErsCaseId = (!GEN_QueueIds.IsNull()) ? String.Join(",", GEN_QueueIds.Tables[0].AsEnumerable().Select(x => x.Field <Int64>("GEN_QueueId").ToString()).ToArray()) : string.Empty; return((ExceptionTypes)executionResult); }
public ExceptionTypes InsertFDRBulkImport(DOGEN_FDR objDOGEN_FDR, out string errorMessage) { try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; long lRowsEffected = 0; DataSet dsTable = new DataSet(); errorMessage = string.Empty; List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; sqlParam = new SqlParameter(); sqlParam.ParameterName = "@SubmissionId"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOGEN_FDR.SubmissionID; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ContractNumber"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOGEN_FDR.ContractNumber; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@TransactionType"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOGEN_FDR.TransactionTypeLValue; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ExcelFileName"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOGEN_FDR.ExcelFileName; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ExcelFilePath"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOGEN_FDR.ExcelFilePath; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ImportStatusLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = (long)ImportStatus.ReadyForImport; parameters.Add(sqlParam); sqlParam = new SqlParameter(); 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 = 0; executionResult = executionResult = dah.ExecuteDMLSP(ConstantTexts.SP_USP_BGP_INS_FDR_BulkImport, parameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage); sqlParam = parameters.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); } }
// Save Configuration Master public ExceptionTypes SaveConfigMaster(DOMGR_ConfigMaster objDOMGR_ConfigMaster, out string errorMessage) { try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; long lRowsEffected = 0; DataSet dsTable = new DataSet(); errorMessage = string.Empty; List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ConfigId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOMGR_ConfigMaster.MGR_ConfigMasterId; parameters.Add(sqlParam); if (!string.IsNullOrEmpty(objDOMGR_ConfigMaster.ConfigName)) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ConfigName"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOMGR_ConfigMaster.ConfigName; parameters.Add(sqlParam); } if (!string.IsNullOrEmpty(objDOMGR_ConfigMaster.ConfigValue)) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ConfigValue"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOMGR_ConfigMaster.ConfigValue; parameters.Add(sqlParam); } if (objDOMGR_ConfigMaster.StartDate != null) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@StartDate"; sqlParam.SqlDbType = SqlDbType.DateTime; sqlParam.Value = objDOMGR_ConfigMaster.StartDate; parameters.Add(sqlParam); } if (objDOMGR_ConfigMaster.EndDate != null) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@EndDate"; sqlParam.SqlDbType = SqlDbType.DateTime; sqlParam.Value = objDOMGR_ConfigMaster.EndDate; parameters.Add(sqlParam); } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@IsActive"; sqlParam.SqlDbType = SqlDbType.Bit; sqlParam.Value = objDOMGR_ConfigMaster.IsActive; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@LoginUserId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOMGR_ConfigMaster.CreatedByRef; parameters.Add(sqlParam); //Extra parameter when adding or editing record for releasing lock sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ScreenLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = (long)ScreenType.Configuration; 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 = 0; executionResult = executionResult = dah.ExecuteDMLSP(ConstantTexts.USP_APP_INS_UPD_ConfigMaster, parameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage); if (executionResult == 0) { return(ExceptionTypes.Success); } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } }
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 AddSkills(DOADM_SkillsMaster objDOADM_SkillsDetails, long lLoginId, out string errorMessage) { errorMessage = string.Empty; try { DAHelper dah = new DAHelper(); List <SqlParameter> parameters = new List <SqlParameter>(); long lErrorCode = 0; long lErrorNumber = 0; DataSet dsResultData = new DataSet(); 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); } if (!string.IsNullOrEmpty(objDOADM_SkillsDetails.IsActive.ToString())) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@IsActive"; sqlParam.SqlDbType = SqlDbType.Bit; sqlParam.Value = objDOADM_SkillsDetails.IsActive; parameters.Add(sqlParam); } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@LoginUserId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = lLoginId; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ScreenLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = ScreenType.Skills; parameters.Add(sqlParam); if (objDOADM_SkillsDetails.lstDOADM_SkillWorkQueuesCorrelation.Count() > 0) { DataTable skillsWorkQueue; SetSkillsWorkQueue(objDOADM_SkillsDetails.lstDOADM_SkillWorkQueuesCorrelation, out skillsWorkQueue); DataTableReader dtrSkillWorkQueues = new DataTableReader(skillsWorkQueue); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@TV_Queues"; sqlParam.SqlDbType = SqlDbType.Structured; sqlParam.Value = dtrSkillWorkQueues; 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.ExecuteDMLSP(ConstantTexts.SP_USP_APP_INS_UPD_Skills, parameters.ToArray(), out lErrorCode, out lErrorCode, out lErrorNumber, out errorMessage); sqlParam = parameters.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); } }
public ExceptionTypes InsertFDRSubmissionLog(List <FDRSubmissionRow> lstCases, long LoginUserId, bool IsFDRSubmissionCompleted, string errormessage, out string errorMessage) { FDRSubmissionRow objFDRSubmissionRow = new FDRSubmissionRow(); try { DAHelper dah = new DAHelper(); List <SqlParameter> parameters = new List <SqlParameter>(); long lErrorCode = 0; long lErrorNumber = 0; DataSet dsResultData = new DataSet(); SqlParameter sqlParam; if (lstCases.Count() > 0) { DataTable dtCases; SetFDRSubmissionLog(lstCases, IsFDRSubmissionCompleted, errormessage, out dtCases); DataTableReader dtrFDRSubmissionLog = new DataTableReader(dtCases); //DataSet ds = new DataSet("TVP_FDRStaging"); //ds.Tables.Add(dtCases); //string xmlData = ds.GetXml(); //sqlParam = new SqlParameter(); //sqlParam.ParameterName = "@XMLData"; //sqlParam.SqlDbType = SqlDbType.NVarChar; //sqlParam.Value = xmlData; //parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@TVP_FDRSubmissionLog"; sqlParam.SqlDbType = SqlDbType.Structured; sqlParam.Value = dtrFDRSubmissionLog; parameters.Add(sqlParam); } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@LoginUserId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = LoginUserId; 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.ExecuteDMLSP(ConstantTexts.SP_USP_APP_INS_FDRSubmissionLog, parameters.ToArray(), out lErrorCode, out lErrorCode, out lErrorNumber, out errorMessage); sqlParam = parameters.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); } }
/// <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 GetBulkImportID(out long BulkImportID, out string ExcelFilePath, out string errorMessage) { BulkImportID = 0; ExcelFilePath = string.Empty; try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; long lRowsEffected = 0; DataSet dsTable = new DataSet(); errorMessage = string.Empty; List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; sqlParam = new SqlParameter(); sqlParam.ParameterName = "@GEN_FDRBulkImportId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Direction = ParameterDirection.Output; sqlParam.Size = 200000000; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ExcelFilePath"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = string.Empty; sqlParam.Direction = ParameterDirection.Output; sqlParam.Size = 2000; 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 = 0; executionResult = executionResult = dah.ExecuteDMLSP(ConstantTexts.SP_USP_BGP_SEL_FDR_BulkImportPath, parameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage); sqlParam = parameters.FirstOrDefault(x => x.ParameterName == "@ErrorMessage"); if (sqlParam != null && sqlParam.Value != null) { errorMessage += sqlParam.Value.ToString(); } sqlParam = parameters.FirstOrDefault(x => x.ParameterName == "@GEN_FDRBulkImportId"); if (sqlParam != null && sqlParam.Value != null) { BulkImportID = Convert.ToInt64(sqlParam.Value); } sqlParam = parameters.FirstOrDefault(x => x.ParameterName == "@ExcelFilePath"); if (sqlParam != null && sqlParam.Value != null) { ExcelFilePath = Convert.ToString(sqlParam.Value); } if (executionResult == (long)ExceptionTypes.Success && string.IsNullOrEmpty(errorMessage)) { return(ExceptionTypes.Success); } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } }
public ExceptionTypes UpdatMQTRRCaseDetails(long lMQTRRWorkQueueItemId, long lMQSourceTypeLkup, long lUpdateCMSTransactionCaseNumber, long CurrentUserId, out string errorMessage) { try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; long lRowsEffected = 0; DataSet dsTable = new DataSet(); errorMessage = string.Empty; long executionResult = 0; List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; sqlParam = new SqlParameter(); sqlParam.ParameterName = "@MQTRRWorkQueueItemsId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = lMQTRRWorkQueueItemId; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@MQSourceTypeLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = lMQSourceTypeLkup; parameters.Add(sqlParam); if (lUpdateCMSTransactionCaseNumber != 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@GEN_QueueId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = lUpdateCMSTransactionCaseNumber; parameters.Add(sqlParam); } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CurrentUserId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = CurrentUserId; 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); executionResult = dah.ExecuteDMLSP(ConstantTexts.SP_USP_BGP_INS_UPD_MQTRRProcess, parameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage); sqlParam = parameters.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) { Console.WriteLine("Error : " + ex.Message); errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } }
public ExceptionTypes InsertFDRStagingData(DOGEN_FDR objDOGEN_FDR, out string errorMessage) { try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; long lRowsEffected = 0; DataSet dsTable = new DataSet(); errorMessage = string.Empty; List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; sqlParam = new SqlParameter(); sqlParam.ParameterName = "@GEN_FDRBulkImportId"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOGEN_FDR.FDRBulkImportID; parameters.Add(sqlParam); sqlParam = new SqlParameter(); //DataTableReader drTable = new DataTableReader(objDOGEN_FDR.dtExcelData); DataSet ds = new DataSet("TVP_FDRStaging"); ds.Tables.Add(objDOGEN_FDR.dtExcelData); string xmlData = ds.GetXml(); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@XMLData"; sqlParam.SqlDbType = SqlDbType.NVarChar; sqlParam.Value = xmlData; 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); DataSet dsResult = new DataSet(); long executionResult = 0; executionResult = dah.ExecuteDMLSP(ConstantTexts.SP_USP_BGP_INS_FDR_Staging, parameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage); // executionResult = dah.ExecuteSelectSP(ConstantTexts.SP_USP_BGP_INS_FDR_Staging, parameters.ToArray(),out dsResult, out lErrorNumber, out lRowsEffected, out errorMessage); sqlParam = parameters.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); } }
public ExceptionTypes AddEditAccessGroup(long lLoggedInUserId, UIDOAccessGroup objUIDOAccessGroup, out string errorMessage) { errorMessage = string.Empty; try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; long lNumberOfRowsEffected = 0; DataSet dsTable = new DataSet(); List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; if (objUIDOAccessGroup.ADM_AccessGroupMasterId > 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ADM_AccessGroupMasterId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objUIDOAccessGroup.ADM_AccessGroupMasterId; parameters.Add(sqlParam); } if (objUIDOAccessGroup.AccessGroupName != string.Empty) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@AccessGroupName"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objUIDOAccessGroup.AccessGroupName; parameters.Add(sqlParam); } if (objUIDOAccessGroup.AccessGroupDescription != string.Empty) { if (objUIDOAccessGroup.AccessGroupDescription == null) { objUIDOAccessGroup.AccessGroupDescription = ""; } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@AccessGroupDescription"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objUIDOAccessGroup.AccessGroupDescription; parameters.Add(sqlParam); } if (objUIDOAccessGroup.RoleLkup > 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@RoleLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objUIDOAccessGroup.RoleLkup; parameters.Add(sqlParam); } if (objUIDOAccessGroup.WorkBasketLkup > 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@WorkBasketLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objUIDOAccessGroup.WorkBasketLkup; parameters.Add(sqlParam); } if (objUIDOAccessGroup.DescripancyCatLkup > 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@DiscrepancyCategoryLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objUIDOAccessGroup.DescripancyCatLkup; parameters.Add(sqlParam); } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@IsActive"; sqlParam.SqlDbType = SqlDbType.Bit; sqlParam.Value = objUIDOAccessGroup.IsActive; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@LoginUserId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = lLoggedInUserId; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ScreenLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = ScreenType.AccessGroup; parameters.Add(sqlParam); if (objUIDOAccessGroup.lstDOADM_AccessGroupSkillsCorrelation.Count() > 0) { DataTable accessGroupSkills; SetAccessGroupSkills(objUIDOAccessGroup.lstDOADM_AccessGroupSkillsCorrelation, out accessGroupSkills); DataTableReader dtrAccessGroupSkills = new DataTableReader(accessGroupSkills); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@TV_Skills"; sqlParam.SqlDbType = SqlDbType.Structured; sqlParam.Value = dtrAccessGroupSkills; parameters.Add(sqlParam); } if (objUIDOAccessGroup.lstDOADM_AccessGroupReportCorrelation.Count() > 0) { DataTable accessGroupReports; SetAccessGroupReports(objUIDOAccessGroup.lstDOADM_AccessGroupReportCorrelation, out accessGroupReports); DataTableReader dtrAccessGroupReport = new DataTableReader(accessGroupReports); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@TV_Reports"; sqlParam.SqlDbType = SqlDbType.Structured; sqlParam.Value = dtrAccessGroupReport; 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.ExecuteDMLSP(ConstantTexts.SP_USP_APP_INS_UPD_AccessGroup, parameters.ToArray(), out lErrocode, out lErrorNumber, out lNumberOfRowsEffected, out errorMessage); sqlParam = parameters.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) { 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 MQTRRRecordsToProcess(long savedMessagesBGPId, out List <DOMQTRRWorkQueueItems> lstDOMQTRRWorkQueueItems, out string errorMessage) { lstDOMQTRRWorkQueueItems = new List <DOMQTRRWorkQueueItems>(); DOMQTRRWorkQueueItems objDOMQTRRWorkQueueItems; try { DAHelper dah = new DAHelper(); DataSet dsTable = new DataSet(); errorMessage = string.Empty; long executionResult = 0; string query = string.Format(ConstantTexts.Query_Select_MQTRRRecords, savedMessagesBGPId); executionResult = dah.ExecuteSQL(query, new List <SqlParameter>().ToArray(), out DataSet MQTRRRecordDetailsDataSet, out string erorrMessage, true); if (executionResult == (long)ExceptionTypes.Success) { if (!MQTRRRecordDetailsDataSet.IsNullOrEmpty()) { if (MQTRRRecordDetailsDataSet.Tables.Count > 0 && MQTRRRecordDetailsDataSet.Tables[0].Rows.Count > 0) { foreach (DataRow row in MQTRRRecordDetailsDataSet.Tables[0].Rows) { objDOMQTRRWorkQueueItems = new DOMQTRRWorkQueueItems(); if (row.Table.Columns.Contains("MQTRRWorkQueueItemId")) { if (!DBNull.Value.Equals(row["MQTRRWorkQueueItemId"])) { objDOMQTRRWorkQueueItems.MQTRRWorkQueueItemId = Convert.ToInt64(row["MQTRRWorkQueueItemId"]); } } if (row.Table.Columns.Contains("MQSourceTypeLkup")) { if (!DBNull.Value.Equals(row["MQSourceTypeLkup"])) { objDOMQTRRWorkQueueItems.MQSourceTypeLkup = Convert.ToInt64(row["MQSourceTypeLkup"]); } } if (row.Table.Columns.Contains("ERSCaseNumber")) { if (!DBNull.Value.Equals(row["ERSCaseNumber"])) { objDOMQTRRWorkQueueItems.ERSCaseNumber = Convert.ToInt64(row["ERSCaseNumber"]); } } lstDOMQTRRWorkQueueItems.Add(objDOMQTRRWorkQueueItems); } return(ExceptionTypes.Success); } return(ExceptionTypes.ZeroRecords); } return(ExceptionTypes.ZeroRecords); } else if (executionResult == 2) { return(ExceptionTypes.ZeroRecords); } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { Console.WriteLine("Error : " + ex.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); } }
public ExceptionTypes UpdateRPRQueue(long QueueID, string CMSProcessDate, string DispositionCode, string DispositionCodeDescription, long TransactionTypeLkup, out string errorMessage) { errorMessage = string.Empty; try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; long lRowsEffected = 0; DataSet dsTable = new DataSet(); errorMessage = string.Empty; List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; sqlParam = new SqlParameter(); sqlParam.ParameterName = "@GEN_QueueId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = QueueID; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CMSProcessDate"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = CMSProcessDate; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@DispositionCode"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = DispositionCode; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@DispositionCodeDescription"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = DispositionCodeDescription; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@TransactionTypeLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = TransactionTypeLkup; 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 = 0; executionResult = executionResult = dah.ExecuteDMLSP(ConstantTexts.SP_USP_BGP_UPD_RPR_Queue, parameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage); sqlParam = parameters.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); } }
//save Department Master public ExceptionTypes SaveDepartment(DOCMN_Department objDOCMN_Department, out string errorMessage) { try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; long lRowsEffected = 0; DataSet dsTable = new DataSet(); errorMessage = string.Empty; List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CMN_DepartmentId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOCMN_Department.CMN_DepartmentId; parameters.Add(sqlParam); if (!string.IsNullOrEmpty(objDOCMN_Department.ERSDepartmentName)) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ERSDepartmentName"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOCMN_Department.ERSDepartmentName; parameters.Add(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.VarChar; sqlParam.Value = objDOCMN_Department.DepartmentLkup; parameters.Add(sqlParam); if (objDOCMN_Department.EffectiveDate != null) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@EffectiveDate"; sqlParam.SqlDbType = SqlDbType.DateTime; sqlParam.Value = objDOCMN_Department.EffectiveDate; parameters.Add(sqlParam); } if (objDOCMN_Department.InactivationDate != null) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@InactivationDate"; sqlParam.SqlDbType = SqlDbType.DateTime; sqlParam.Value = objDOCMN_Department.InactivationDate; parameters.Add(sqlParam); } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@IsActive"; sqlParam.SqlDbType = SqlDbType.Bit; sqlParam.Value = objDOCMN_Department.IsActive; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@LoginUserId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOCMN_Department.CreatedByRef; parameters.Add(sqlParam); //Extra parameter when adding or editing record for releasing lock sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ScreenLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = (long)ScreenType.Department; 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 = 0; //if (objDOADM_UserMaster.ADM_UserMasterId == 0) //{ executionResult = executionResult = dah.ExecuteDMLSP(ConstantTexts.SP_USP_APP_INS_UPD_Department, parameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage); //} //else //{ // executionResult = executionResult = dah.ExecuteDMLSP(ConstantTexts.SP_USP_APP_UPD_ADM_UserMaster, parameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage); //} if (executionResult == 0) { return(ExceptionTypes.Success); } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } }
public ExceptionTypes UpdateFDRPackageDate(List <long> caseIds, FDRSubmissionCategory submissionCategory, long LoginUserId, out string errorMessage) { string strCaseIds = String.Concat(caseIds.Select(x => x.ToString() + ",")); errorMessage = string.Empty; try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; long lRowsEffected = 0; DataSet dsTable = new DataSet(); errorMessage = string.Empty; List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CaseIds"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = strCaseIds; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@FDRSubmissionCategoryLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = (long)submissionCategory; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@LoginUserId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = LoginUserId; 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 = 0; executionResult = executionResult = dah.ExecuteDMLSP(ConstantTexts.SP_USP_BGP_UPD_FDRPackageDates, parameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage); sqlParam = parameters.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); } }