public RootCauseInvestigation SaveRootCauseInvestigationDetail(RootCauseInvestigation rootCauseInvestigation)
{
var param = new SqlParameter[]
{
new SqlParameter("@ID", rootCauseInvestigation.ID),
new SqlParameter("@CMRequestID", rootCauseInvestigation.CMRequestID),
new SqlParameter("@DepartmentID", rootCauseInvestigation.DepartmentID),
new SqlParameter("@UserID", rootCauseInvestigation.UserID),
new SqlParameter("@IsNotified", rootCauseInvestigation.IsNotified),
new SqlParameter("@IsExtensionRequested", rootCauseInvestigation.IsExtensionRequested),
new SqlParameter("@IsEscalatedWithinDept", rootCauseInvestigation.IsEscalatedWithinDept),
new SqlParameter("@IsEscalatedToSuperAdmin", rootCauseInvestigation.IsEscalatedToSuperAdmin),
new SqlParameter("@RecordStatusId", rootCauseInvestigation.RecordStatusId),
new SqlParameter("@CreatedBy", rootCauseInvestigation.CreatedBy),
new SqlParameter("@ModifiedBy", rootCauseInvestigation.ModifiedBy),
new SqlParameter("@RootCause", rootCauseInvestigation.RootCause),
new SqlParameter("@PlantResponse", rootCauseInvestigation.PlantResponse),
new SqlParameter("@PlantID", rootCauseInvestigation.PlantID)
};
return(SqlHelper.ExecuteProcedureReturnSingleObject <RootCauseInvestigation>(ConnectionString, SPConstants.uspSaveRootCauseInvestigationDetail, param));
}
public IActionResult SaveRootCauseInvestigationDetail(RootCauseInvestigation rootCauseInvestigation)
{
var saveRootCauseInvestigationDetail = Newtonsoft.Json.JsonConvert.SerializeObject(rootCauseInvestigation);
if (!Convert.IsDBNull(rootCauseInvestigation.DepartmentID) &&
rootCauseInvestigation.DepartmentID > 0 &&
!Convert.IsDBNull(rootCauseInvestigation.UserID) &&
rootCauseInvestigation.UserID > 0 &&
!Convert.IsDBNull(rootCauseInvestigation.CMRequestID) &&
rootCauseInvestigation.CMRequestID > 0)
{
//var data = _CreditMemoTrackingRecord.SaveRootCauseInvestigationDetail(rootCauseInvestigation);
var data = _CreditMemoTrackingRecord.SaveRootCauseInvestigationDetail_JSON(saveRootCauseInvestigationDetail);
RouteData.Values.Add(MessageConstants.ReturnMessage, MessageConstants.DataSaved);
return(Ok(data));
}
else
{
RouteData.Values.Add(MessageConstants.ReturnMessage, MessageConstants.InvalidData);
return(Ok(rootCauseInvestigation));
}
}
public RootCauseInvestigation SaveRootCauseInvestigationDetail(RootCauseInvestigation rootCauseInvestigation)
{
var data = _CreditMemoTrackingDBClient.SaveRootCauseInvestigationDetail(rootCauseInvestigation);
return(data);
}
