/// <summary>
/// This method is used for Add Update CAPA Details
/// </summary>
/// <param name="objDCCAPADetails"></param>
/// <returns></returns>
///
public ActionResult AddUpdateCAPADetails(FormCollection frmColl, string mitigationData)
{
objDCUsers = (DCUsers)Session["UserLogon"];
objDataOperationResponse = new DataOperationResponse();
if (Session["UserLogon"] != null)
{
objDCCAPADetails = new DCCAPADetails();
objDCCAPADetails.AssessmentTypeId = string.IsNullOrEmpty(frmColl["hdnAssessmentTypesId"]) ? 0 : Convert.ToInt32(frmColl["hdnAssessmentTypesId"]);
objDCCAPADetails.RiskScoreId = string.IsNullOrEmpty(frmColl["hdnRiskScoreId"]) ? 0 : Convert.ToInt32(frmColl["hdnRiskScoreId"]);
objDCCAPADetails.SectionId = string.IsNullOrEmpty(frmColl["hdnSectionId"]) ? 0 : Convert.ToInt32(frmColl["hdnSectionId"]);
objDCCAPADetails.CAPADetailsId = string.IsNullOrEmpty(frmColl["hdnCAPADetailsId"]) ? 0 : Convert.ToInt32(frmColl["hdnCAPADetailsId"]);
objDCCAPADetails.ConfirmationOfComplianceImprovement = frmColl["ddlConfirmationOfComplianceImprovement"];
objDCCAPADetails.Impact = frmColl["ddlImpact"];
StringBuilder objStrBuilder = new StringBuilder();
if (!string.IsNullOrEmpty(frmColl["ddlMitigation"]))
{
string[] strMitigationIds = frmColl["ddlMitigation"].Split(',');
objStrBuilder.Append("<MitigationIds>");
foreach (string MitigationId in strMitigationIds)
{
objStrBuilder.Append("<MitigationId>" + Convert.ToInt32(MitigationId) + "</MitigationId>");
}
objStrBuilder.Append("</MitigationIds>");
}
objDCCAPADetails.Mitigation = Convert.ToString(objStrBuilder);
objDCCAPADetails.RiskCriteria = frmColl["ddlRiskCriteria"];
objDCCAPADetails.RiskCriteriaDescription = frmColl["ddlRiskCriteriaDescription"];
objBLCAPADetails = new BLCAPADetails();
objDCCAPADetails.CreatedBy = objDCUsers.UserId;
objDataOperationResponse = objBLCAPADetails.AddUpdateCAPADetails(objDCCAPADetails);
if (objDataOperationResponse.Code > 0)
{
TempData["successMessage"] = objDataOperationResponse.Message;
return(Redirect("~/CAPADetails/ViewCapaDetails"));
}
else
{
TempData["errorMessage"] = objDataOperationResponse.Message;
return(View("ViewCapaDetails"));
}
}
else
{
return(Redirect("~/Account/Login"));
}
}
/// <summary>
/// This method is used to Get CAPA Details
/// </summary>
/// <param name="SectionId"></param>
/// <param name="RiskScoreId"></param>
/// <param name="UserId"></param>
/// <returns></returns>
public List <DCCAPADetails> GetCAPADetails(int SectionId, int RiskScoreId, int UserId, int AssessmentTypeId)
{
try
{
objDatabaseHelper = new DatabaseHelper();
lstDCCAPADetails = new List <DCCAPADetails>();
objDatabaseHelper.AddParameter("pSetionId", SectionId == 0 ? DBNull.Value : (object)SectionId);
objDatabaseHelper.AddParameter("pRiskScoreId", RiskScoreId == 0 ? 0 : (object)RiskScoreId);
objDatabaseHelper.AddParameter("pUserID", UserId == 0 ? DBNull.Value : (object)UserId);
objDatabaseHelper.AddParameter("pAssessmentTypeId", AssessmentTypeId == 0 ? DBNull.Value : (object)AssessmentTypeId);
DbDataReader reader = objDatabaseHelper.ExecuteReader(BLDBRoutines.SP_GETCAPADETAILS, CommandType.StoredProcedure);
if (reader.HasRows)
{
while (reader.Read())
{
objDCCAPADetails = new DCCAPADetails();
objDCCAPADetails.CAPADetailsId = reader.IsDBNull(reader.GetOrdinal("CAPADetailsId")) ? 0 : reader.GetInt32(reader.GetOrdinal("CAPADetailsId"));
objDCCAPADetails.ConfirmationOfComplianceImprovement = reader.IsDBNull(reader.GetOrdinal("ConfirmationOfComplianceImprovement")) ? string.Empty : reader.GetString(reader.GetOrdinal("ConfirmationOfComplianceImprovement"));
objDCCAPADetails.Impact = reader.IsDBNull(reader.GetOrdinal("Impact")) ? string.Empty : reader.GetString(reader.GetOrdinal("Impact"));
objDCCAPADetails.Mitigation = reader.IsDBNull(reader.GetOrdinal("Mitigation")) ? string.Empty : reader.GetString(reader.GetOrdinal("Mitigation"));
objDCCAPADetails.RiskCriteria = reader.IsDBNull(reader.GetOrdinal("RiskCriteria")) ? string.Empty : reader.GetString(reader.GetOrdinal("RiskCriteria"));
objDCCAPADetails.RiskCriteriaDescription = reader.IsDBNull(reader.GetOrdinal("RiskCriteriaDescription")) ? string.Empty : reader.GetString(reader.GetOrdinal("RiskCriteriaDescription"));
objDCCAPADetails.RiskScoreId = reader.IsDBNull(reader.GetOrdinal("RiskScoreId")) ? 0 : reader.GetInt32(reader.GetOrdinal("RiskScoreId"));
objDCCAPADetails.SectionId = reader.IsDBNull(reader.GetOrdinal("SectionId")) ? 0 : reader.GetInt32(reader.GetOrdinal("SectionId"));
lstDCCAPADetails.Add(objDCCAPADetails);
}
}
return(lstDCCAPADetails);
}
catch (Exception exec)
{
throw exec;
}
finally
{
if (objDatabaseHelper != null)
{
objDatabaseHelper.Dispose();
}
}
}
/// <summary>
/// This method is used to Add Update CAPA Details
/// </summary>
/// <param name="objDCCAPADetails"></param>
/// <returns></returns>
public DataOperationResponse AddUpdateCAPADetails(DCCAPADetails objDCCAPADetails)
{
try
{
objDatabaseHelper = new DatabaseHelper();
objDataOperationResponse = new DataOperationResponse();
objDatabaseHelper.AddParameter("pCAPADetailsId", objDCCAPADetails.CAPADetailsId == 0 ? DBNull.Value : (object)objDCCAPADetails.CAPADetailsId);
objDatabaseHelper.AddParameter("pSectionId", objDCCAPADetails.SectionId == 0 ? DBNull.Value : (object)objDCCAPADetails.SectionId);
objDatabaseHelper.AddParameter("pRiskScoreId", objDCCAPADetails.RiskScoreId == 0 ? 0 : (object)objDCCAPADetails.RiskScoreId);
objDatabaseHelper.AddParameter("pRiskCriteria", objDCCAPADetails.RiskCriteria == string.Empty ? DBNull.Value : (object)objDCCAPADetails.RiskCriteria);
objDatabaseHelper.AddParameter("pRiskCriteriaDescription", objDCCAPADetails.RiskCriteriaDescription == string.Empty ? DBNull.Value : (object)objDCCAPADetails.RiskCriteriaDescription);
objDatabaseHelper.AddParameter("pConfirmationOfComplianceImprovement", objDCCAPADetails.ConfirmationOfComplianceImprovement == string.Empty ? DBNull.Value : (object)objDCCAPADetails.ConfirmationOfComplianceImprovement);
objDatabaseHelper.AddParameter("pImpact", objDCCAPADetails.Impact == string.Empty ? DBNull.Value : (object)objDCCAPADetails.Impact);
objDatabaseHelper.AddParameter("pMitigation", objDCCAPADetails.Mitigation == string.Empty ? DBNull.Value : (object)objDCCAPADetails.Mitigation);
objDatabaseHelper.AddParameter("pUserId", objDCCAPADetails.CreatedBy == 0 ? DBNull.Value : (object)objDCCAPADetails.CreatedBy);
objDatabaseHelper.AddParameter("pAssessmentTypeId", objDCCAPADetails.AssessmentTypeId == 0 ? DBNull.Value : (object)objDCCAPADetails.AssessmentTypeId);
int result = objDatabaseHelper.ExecuteNonQuery(BLDBRoutines.SP_ADDUPDATECAPADETAILS, CommandType.StoredProcedure);
if (result > 0)
{
objDataOperationResponse.Code = GetSuccessCode;
objDataOperationResponse.Message = objDCCAPADetails.CAPADetailsId == 0 ? "Added Successfully" : "Updated Successfully";
}
else
{
objDataOperationResponse.Code = GetErrorCode;
objDataOperationResponse.Message = "Unable to add";
}
return(objDataOperationResponse);
}
catch (Exception exc)
{
throw exc;
}
finally
{
if (objDatabaseHelper != null)
{
objDatabaseHelper.Dispose();
}
}
}