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