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