public List <DCRiskCriteria> GetMitigationByRCDescription(string RiskCriteriaDescription)
{
lstDCRiskCriteria = new List <DCRiskCriteria>();
objDatabaseHelper = new DatabaseHelper();
try
{
objDatabaseHelper.AddParameter("pRiskCriteriaDescription", RiskCriteriaDescription == string.Empty ? DBNull.Value : (object)RiskCriteriaDescription);
DbDataReader reader = objDatabaseHelper.ExecuteReader(BLDBRoutines.SP_GETMITIGATIONBYRCDESCRIPTION, CommandType.StoredProcedure);
if (reader.HasRows)
{
while (reader.Read())
{
objDCRiskCriteria = new DCRiskCriteria();
objDCRiskCriteria.RiskCriteria = reader.IsDBNull(reader.GetOrdinal("RiskCriteria")) ? string.Empty : reader.GetString(reader.GetOrdinal("RiskCriteria"));
objDCRiskCriteria.RiskCriteriaDescription = reader.IsDBNull(reader.GetOrdinal("RiskCriteriaDescription")) ? string.Empty : reader.GetString(reader.GetOrdinal("RiskCriteriaDescription"));
objDCRiskCriteria.Mitigation = reader.IsDBNull(reader.GetOrdinal("Mitigation")) ? string.Empty : reader.GetString(reader.GetOrdinal("Mitigation"));
objDCRiskCriteria.RCMitigationId = reader.IsDBNull(reader.GetOrdinal("RCMitigationId")) ? 0 : reader.GetInt32(reader.GetOrdinal("RCMitigationId"));
lstDCRiskCriteria.Add(objDCRiskCriteria);
}
objDCRiskCriteria.Code = GetSuccessCode;
}
return(lstDCRiskCriteria);
}
catch (Exception exec)
{
throw exec;
}
finally
{
if (objDatabaseHelper != null)
{
objDatabaseHelper.Dispose();
}
}
}
/// <summary>
/// Get Risk Criteria
/// </summary>
/// <returns></returns>
public List <DCRiskCriteria> GetRiskCriteria()
{
lstDCRiskCriteria = new List <DCRiskCriteria>();
objDatabaseHelper = new DatabaseHelper();
try
{
DbDataReader reader = objDatabaseHelper.ExecuteReader(BLDBRoutines.SP_GETRISKCRITERIA, CommandType.StoredProcedure);
if (reader.HasRows)
{
while (reader.Read())
{
objDCRiskCriteria = new DCRiskCriteria();
objDCRiskCriteria.RiskCriteriaId = reader.IsDBNull(reader.GetOrdinal("RiskCriteriaId")) ? 0 : reader.GetInt32(reader.GetOrdinal("RiskCriteriaId"));
objDCRiskCriteria.RiskCriteria = reader.IsDBNull(reader.GetOrdinal("RiskCriteria")) ? string.Empty : reader.GetString(reader.GetOrdinal("RiskCriteria"));
objDCRiskCriteria.Attribute = reader.IsDBNull(reader.GetOrdinal("Attribute")) ? string.Empty : reader.GetString(reader.GetOrdinal("Attribute"));
objDCRiskCriteria.DataValue = reader.IsDBNull(reader.GetOrdinal("DataValue")) ? string.Empty : reader.GetString(reader.GetOrdinal("DataValue"));
lstDCRiskCriteria.Add(objDCRiskCriteria);
}
objDCRiskCriteria.Code = GetSuccessCode;
}
return(lstDCRiskCriteria);
}
catch (Exception exp)
{
throw exp;
}
finally
{
if (objDatabaseHelper != null)
{
objDatabaseHelper.Dispose();
}
}
}
public DataOperationResponse AddRCMitigation(DCRiskCriteria objDCRiskCriteria)
{
try
{
objDatabaseHelper = new DatabaseHelper();
objDataOperationResponse = new DataOperationResponse();
objDatabaseHelper.AddParameter("pRiskCriteria", objDCRiskCriteria.RiskCriteria == string.Empty ? DBNull.Value : (object)objDCRiskCriteria.RiskCriteria);
objDatabaseHelper.AddParameter("pRiskCriteriaDescription", objDCRiskCriteria.RiskCriteriaDescription == string.Empty ? DBNull.Value : (object)objDCRiskCriteria.RiskCriteriaDescription);
objDatabaseHelper.AddParameter("pMitigation", objDCRiskCriteria.Mitigation == string.Empty ? DBNull.Value : (object)objDCRiskCriteria.Mitigation);
int result = objDatabaseHelper.ExecuteNonQuery(BLDBRoutines.SP_INSERTRCMITIGATION, CommandType.StoredProcedure);
if (result > 0)
{
objDataOperationResponse.Code = GetSuccessCode;
objDataOperationResponse.Message = "Mitigation Added Successfully";
}
else
{
objDataOperationResponse.Code = GetErrorCode;
objDataOperationResponse.Message = "Unable to add/Mitigation already exists";
}
return(objDataOperationResponse);
}
catch (Exception exec)
{
throw exec;
}
finally
{
if (objDatabaseHelper != null)
{
objDatabaseHelper.Dispose();
}
}
}
public List <DCRiskCriteria> GetRCActionItems()
{
lstDCRiskCriteria = new List <DCRiskCriteria>();
objDatabaseHelper = new DatabaseHelper();
try
{
DbDataReader reader = objDatabaseHelper.ExecuteReader(BLDBRoutines.SP_GETRCACTIONITEMS, CommandType.StoredProcedure);
if (reader.HasRows)
{
while (reader.Read())
{
objDCRiskCriteria = new DCRiskCriteria();
objDCRiskCriteria.RiskCriteria = reader.IsDBNull(reader.GetOrdinal("RiskCriteria")) ? string.Empty : reader.GetString(reader.GetOrdinal("RiskCriteria"));
objDCRiskCriteria.RiskCriteriaDescription = reader.IsDBNull(reader.GetOrdinal("RiskCriteriaDescription")) ? string.Empty : reader.GetString(reader.GetOrdinal("RiskCriteriaDescription"));
objDCRiskCriteria.ActionItem = reader.IsDBNull(reader.GetOrdinal("ActionItem")) ? string.Empty : reader.GetString(reader.GetOrdinal("ActionItem"));
objDCRiskCriteria.RCActionItemId = reader.IsDBNull(reader.GetOrdinal("RCActionItemId")) ? 0 : reader.GetInt32(reader.GetOrdinal("RCActionItemId"));
lstDCRiskCriteria.Add(objDCRiskCriteria);
}
objDCRiskCriteria.Code = GetSuccessCode;
}
return(lstDCRiskCriteria);
}
catch (Exception exec)
{
throw exec;
}
finally
{
if (objDatabaseHelper != null)
{
objDatabaseHelper.Dispose();
}
}
}
public ActionResult AddRCMitigation(FormCollection frmcol)
{
if (Session["UserLogon"] != null)
{
if (!string.IsNullOrEmpty(frmcol["btnAddMitigation"]))
{
DCUsers objDCUsers = (DCUsers)Session["UserLogon"];
objBLRiskCriteria = new BLRiskCriteria();
objDCRiskCriteria = new DCRiskCriteria();
objDCRiskCriteria.RiskCriteria = frmcol["hdnRiskCriteria"];
objDCRiskCriteria.RiskCriteriaDescription = frmcol["ddlRiskCriteriaDescription"];
objDCRiskCriteria.Mitigation = frmcol["txtMitigation"];
objDataOperationResponse = objBLRiskCriteria.AddRCMitigation(objDCRiskCriteria);
if (objDataOperationResponse.Code > 0)
{
TempData["successMessage"] = objDataOperationResponse.Message;
}
else
{
TempData["errorMessage"] = objDataOperationResponse.Message;
}
TempData["activetab"] = "3";
// return Redirect("/RiskCriteria/ViewRiskCriteria");
return(Redirect("/RiskCriteria/AddRCMitigation"));
}
}
return(View());
}
/// <summary>
/// Add Risk Criteria
/// </summary>
/// <returns></returns>
///
public ActionResult AddRiskCriteria(FormCollection frmColl)
{
if (Session["UserLogon"] != null)
{
if (!string.IsNullOrEmpty(frmColl["btnAddRiskCriteria"]) || !string.IsNullOrEmpty(frmColl["btnAddAttribute"]))
{
DCUsers objDCUsers = (DCUsers)Session["UserLogon"];
objBLRiskCriteria = new BLRiskCriteria();
objDCRiskCriteria = new DCRiskCriteria();
if (string.IsNullOrEmpty(frmColl["ddlAttribute"]) && string.IsNullOrEmpty(frmColl["ddlRiskCriteria"]))
{
objDCRiskCriteria.Attribute = "RC";
objDCRiskCriteria.DataValue = frmColl["txtRiskCriteria"];
objDCRiskCriteria.RiskCriteria = frmColl["txtRiskCriteria"];
}
else
{
objDCRiskCriteria.Attribute = frmColl["ddlAttribute"];
objDCRiskCriteria.DataValue = frmColl["txtAttributeDescription"];
objDCRiskCriteria.RiskCriteria = frmColl["hdnRiskCriteria"];
}
objDCRiskCriteria.CreatedBy = objDCUsers.UserId;
objDataOperationResponse = objBLRiskCriteria.AddRiskCriteria(objDCRiskCriteria);
if (objDataOperationResponse.Code > 0)
{
if (string.IsNullOrEmpty(frmColl["ddlAttribute"]) && string.IsNullOrEmpty(frmColl["ddlRiskCriteria"]))
{
TempData["successMessage"] = "Risk Criteria Added Successfully";
TempData["activetab"] = "1";
}
else
{
TempData["successMessage"] = "Risk Criteria Attribute Added Successfully";
TempData["activetab"] = "2";
}
}
else
{
if (string.IsNullOrEmpty(frmColl["ddlAttribute"]) && string.IsNullOrEmpty(frmColl["ddlRiskCriteria"]))
{
TempData["errorMessage"] = objDataOperationResponse.Message;
TempData["activetab"] = "1";
}
else
{
TempData["errorMessage"] = objDataOperationResponse.Message;
TempData["activetab"] = "2";
}
}
}
}
return(View());
}
/// <summary>
/// Author : Satish
/// Description : Add Risk Criteria this method used to add Risk Criteria
/// Date : 13/10/2017
/// </summary>
/// <returns></returns>
public DataOperationResponse AddRiskCriteria(DCRiskCriteria objDCRiskCriteria)
{
try
{
objDatabaseHelper = new DatabaseHelper();
objDataOperationResponse = new DataOperationResponse();
objDatabaseHelper.AddParameter("pRiskCriteria", objDCRiskCriteria.RiskCriteria == string.Empty ? DBNull.Value : (object)objDCRiskCriteria.RiskCriteria);
objDatabaseHelper.AddParameter("pUserId", objDCRiskCriteria.CreatedBy == 0 ? DBNull.Value : (object)objDCRiskCriteria.CreatedBy);
objDatabaseHelper.AddParameter("pAttribute", objDCRiskCriteria.Attribute == string.Empty ? DBNull.Value : (object)objDCRiskCriteria.Attribute);
objDatabaseHelper.AddParameter("pDataValue", objDCRiskCriteria.DataValue == string.Empty ? DBNull.Value : (object)objDCRiskCriteria.DataValue);
objDatabaseHelper.AddParameter("oRegisterMessage", string.Empty, ParameterDirection.Output);
int result = objDatabaseHelper.ExecuteNonQuery(BLDBRoutines.SP_INSERTRISKCRITERIA, CommandType.StoredProcedure);
string strMessage = Convert.ToString(objDatabaseHelper.Command.Parameters["oRegisterMessage"].Value);
if (result > 0)
{
objDataOperationResponse.Code = GetSuccessCode;
objDataOperationResponse.Message = "Risk Criteria Added Successfully";
}
else
{
objDataOperationResponse.Code = GetErrorCode;
objDataOperationResponse.Message = strMessage;
}
return(objDataOperationResponse);
}
catch (Exception exce)
{
throw exce;
}
finally
{
if (objDatabaseHelper != null)
{
objDatabaseHelper.Dispose();
}
}
}
