public vCaseChildren UpdateChildren(CaseBook caseBook) { var parmsCollection = new ParmsCollection(); var caseChildrenTable = UserDefinedTableTypes.CaseChildren; caseChildrenTable.Rows.Add(new object[] { caseBook.SelectedChildren.CaseChildrenId, caseBook.SelectedChildren.CaseId, caseBook.SelectedChildren.Name, caseBook.SelectedChildren.Age, caseBook.SelectedChildren.GenderLookupId, caseBook.SelectedChildren.RelationshipWithAbuserLookupId, caseBook.SelectedChildren.CreatedBy, caseBook.SelectedChildren.CreatedDateTime, caseBook.SelectedChildren.ModifiedBy, caseBook.SelectedChildren.ModifiedDatetime, }); caseChildrenTable.AcceptChanges(); var updatedChildren = this.unitOfWork.DbContext.ExecuteStoredProcedure <vCaseChildren>("[Ops].[saveChildren]", parmsCollection .AddParm("@caseChildrenType", SqlDbType.Structured, caseChildrenTable, "[Ops].[CaseChildrenType]") ).Last(); return(updatedChildren); }
public IActionResult UpdatePrimaryInfo([FromBody] CaseBook caseBook) { caseBook.Case.ModifiedDatetime = DateTime.Now; var updatedCase = this.caseBusinessAccess.UpdatePrimaryInfo(caseBook); return Ok(updatedCase); }
public IActionResult UpdateCaseStatus([FromBody] CaseBook caseBook) { //var caseBook = JsonConvert.DeserializeObject<CaseBook>(cb.ToString()); caseBook.Manage.CaseId = caseBook.Case.CaseId; caseBook.Manage.TypesOfCounselingLookupId = caseBook.Manage.TypesOfCounselingLookupArray.ToArrayString(); caseBook.FamilyHouseHold.CaseId = caseBook.Case.CaseId; caseBook.FamilyHouseHold.PeacemakerAssistanceLookupId = caseBook.FamilyHouseHold.PeacemakerAssistanceLookupArray.ToArrayString(); caseBook.Spouse.CaseId = caseBook.Case.CaseId; caseBook.PhysicalHealth.CaseId = caseBook.Case.CaseId; caseBook.PhysicalHealth.ReasonForSeekingHelpLookupId = caseBook.PhysicalHealth.ReasonForSeekingHelpLookupArray.ToArrayString(); caseBook.PhysicalHealth.WhoIsAbusingYouLookupId = caseBook.PhysicalHealth.WhoIsAbusingYouLookupArray.ToArrayString(); caseBook.Abuse.CaseId = caseBook.Case.CaseId; caseBook.Abuse.FeelAboutAbuseLookupId = caseBook.Abuse.FeelAboutAbuseLookupArray.ToArrayString(); caseBook.Abuse.ParentsFeelAboutAbuseLookupId = caseBook.Abuse.ParentsFeelAboutAbuseLookupArray.ToArrayString(); caseBook.Abuse.LawFeelAboutAbuseLookupId = caseBook.Abuse.LawFeelAboutAbuseLookupArray.ToArrayString(); caseBook.Abuse.TypesOfPhyscialAbuseLookupId = caseBook.Abuse.TypesOfPhyscialAbuseLookupArray.ToArrayString(); caseBook.Abuse.TypesOfEmotionalAbuseLookupId = caseBook.Abuse.TypesOfEmotionalAbuseLookupArray.ToArrayString(); caseBook.Abuse.TypesOfSexualAbuseLookupId = caseBook.Abuse.TypesOfSexualAbuseLookupArray.ToArrayString(); caseBook.Abuse.TypesOfEconomicAbuseLookupId = caseBook.Abuse.TypesOfEconomicAbuseLookupArray.ToArrayString(); caseBook.Abuse.ReasonsForAbuseLookupId = caseBook.Abuse.ReasonsForAbuseLookupArray.ToArrayString(); var updatedCase = this.caseBusinessAccess.UpdateCaseStatus(caseBook); return(Ok(updatedCase)); }
public IActionResult UpdateSpouse([FromBody] CaseBook caseBook) { caseBook.Spouse.CaseId = caseBook.Case.CaseId; var updatedCase = this.caseBusinessAccess.UpdateSpouse(caseBook); return(Ok(updatedCase)); }
public vCaseFeedback UpdateFeedback(CaseBook caseBook) { CaseFeedback caseObj; vCaseFeedback vCaseObj; try { caseObj = this.unitOfWork.DbContext.Feedback.Find(caseBook.SelectedFeedback.CaseFeedbackId); if (caseObj != null) { this.unitOfWork.DbContext.Entry(caseObj).CurrentValues.SetValues(caseBook.SelectedFeedback); } else { caseObj = this.unitOfWork.DbContext.Feedback.Add(caseBook.SelectedFeedback); } int flag = this.unitOfWork.DbContext.SaveChanges(); vCaseObj = this.unitOfWork.DbContext.vFeedback.Find(caseObj.CaseFeedbackId); } catch (Exception ex) { return(null); } return(vCaseObj); }
public int UpdateCaseManagement(CaseBook caseBook) { CaseManage caseManageObj; Case caseObj; try { caseManageObj = this.unitOfWork.DbContext.Manage.Find(caseBook.Manage.CaseManageId); if (caseManageObj != null) { this.unitOfWork.DbContext.Entry(caseManageObj).CurrentValues.SetValues(caseBook.Manage); } else { caseManageObj = this.unitOfWork.DbContext.Manage.Add(caseBook.Manage); } caseObj = this.unitOfWork.DbContext.Cases.Find(caseBook.Case.CaseId); caseObj.CaseStausId = caseBook.Case.CaseStausId; int flag = this.unitOfWork.DbContext.SaveChanges(); } catch (Exception ex) { throw; } return(caseManageObj.CaseManageId); }
public vCaseMental UpdateMental(CaseBook caseBook) { CaseMental caseObj; vCaseMental vCaseObj; try { caseObj = this.unitOfWork.DbContext.Mental.Find(caseBook.SelectedMental.CaseMentalId); if (caseObj != null) { this.unitOfWork.DbContext.Entry(caseObj).CurrentValues.SetValues(caseBook.SelectedMental); } else { caseObj = this.unitOfWork.DbContext.Mental.Add(caseBook.SelectedMental); } int flag = this.unitOfWork.DbContext.SaveChanges(); vCaseObj = this.unitOfWork.DbContext.vMental.Find(caseObj.CaseMentalId); } catch (Exception ex) { return(null); } return(vCaseObj); }
public vCaseChildren UpdateChildren(CaseBook caseBook) { CaseChildren caseObj; vCaseChildren vCaseObj; try { caseObj = this.unitOfWork.DbContext.Children.Find(caseBook.SelectedChildren.CaseChildrenId); if (caseObj != null) { this.unitOfWork.DbContext.Entry(caseObj).CurrentValues.SetValues(caseBook.SelectedChildren); } else { caseObj = this.unitOfWork.DbContext.Children.Add(caseBook.SelectedChildren); } int flag = this.unitOfWork.DbContext.SaveChanges(); vCaseObj = this.unitOfWork.DbContext.vChildren.Find(caseObj.CaseChildrenId); } catch (Exception ex) { return(null); } return(vCaseObj); }
public vCaseOffender UpdateOffender(CaseBook caseBook) { CaseOffender caseObj; vCaseOffender vCaseObj; try { caseObj = this.unitOfWork.DbContext.Offenders.Find(caseBook.SelectedOffender.CaseOffenderId); if (caseObj != null) { this.unitOfWork.DbContext.Entry(caseObj).CurrentValues.SetValues(caseBook.SelectedOffender); } else { caseObj = this.unitOfWork.DbContext.Offenders.Add(caseBook.SelectedOffender); } int flag = this.unitOfWork.DbContext.SaveChanges(); vCaseObj = this.unitOfWork.DbContext.vOffenders.Find(caseObj.CaseOffenderId); } catch (Exception ex) { return(null); } return(vCaseObj); }
public vCaseAddress UpdateAddress(CaseBook caseBook) { CaseAddress caseAddressObj; vCaseAddress vcaseAddressObj; try { caseAddressObj = this.unitOfWork.DbContext.Addresses.Find(caseBook.SelectedAddress.CaseAddressId); if (caseAddressObj != null) { this.unitOfWork.DbContext.Entry(caseAddressObj).CurrentValues.SetValues(caseBook.SelectedAddress); } else { caseAddressObj = this.unitOfWork.DbContext.Addresses.Add(caseBook.SelectedAddress); } int saveflag = this.unitOfWork.DbContext.SaveChanges(); vcaseAddressObj = this.unitOfWork.DbContext.vAddresses.Find(caseAddressObj.CaseAddressId); } catch (Exception ex) { throw; } return(vcaseAddressObj); }
public IActionResult UpdateFeedback([FromBody] CaseBook caseBook) { caseBook.SelectedFeedback.CaseId = caseBook.Case.CaseId; var updatedCase = this.caseBusinessAccess.UpdateFeedback(caseBook); return(Ok(updatedCase)); }
public CaseHeader UpdateLegal(CaseBook caseBook) { var parmsCollection = new ParmsCollection(); var caseChildrenTable = UserDefinedTableTypes.Legal; caseChildrenTable.Rows.Add(new object[] { caseBook.Legal.CaseLegalId, caseBook.Legal.CaseId, caseBook.Legal.CaseNumber, caseBook.Legal.Court, caseBook.Legal.Prayer, caseBook.Legal.LegalRepresentative, caseBook.Legal.LegalConsentFormLookupId, caseBook.Legal.LegalActionLookupId, caseBook.Legal.OutcomeLookupId, caseBook.Legal.DocumentsLookupId }); caseChildrenTable.AcceptChanges(); var updatedCase = this.unitOfWork.DbContext.ExecuteStoredProcedure <CaseHeader>("[Ops].[saveLegal]", parmsCollection .AddParm("@caseLegalType", SqlDbType.Structured, caseChildrenTable, "[Ops].[CaseLegalType]") ).First(); return(updatedCase); }
public IActionResult UpdateSessionLog([FromBody] CaseBook caseBook) { caseBook.SelectedSessionLog.CaseId = caseBook.Case.CaseId; var updatedCase = this.caseBusinessAccess.UpdateSessionLog(caseBook); return(Ok(updatedCase)); }
public vCaseSessionLog UpdateSessionLog(CaseBook caseBook) { CaseSessionLog caseObj; vCaseSessionLog vCaseObj; try { caseObj = this.unitOfWork.DbContext.SessionLogs.Find(caseBook.SelectedSessionLog.CaseSessionLogId); if (caseObj != null) { this.unitOfWork.DbContext.Entry(caseObj).CurrentValues.SetValues(caseBook.SelectedSessionLog); } else { caseObj = this.unitOfWork.DbContext.SessionLogs.Add(caseBook.SelectedSessionLog); } int flag = this.unitOfWork.DbContext.SaveChanges(); vCaseObj = this.unitOfWork.DbContext.vSessionLog.Find(caseObj.CaseSessionLogId); } catch (Exception ex) { return(null); } return(vCaseObj); }
public vCaseAddress UpdateAddress(CaseBook caseBook) { var parmsCollection = new ParmsCollection(); var caseAddressTable = UserDefinedTableTypes.CaseAddress; caseAddressTable.Rows.Add(new object[] { caseBook.SelectedAddress.CaseAddressId, caseBook.SelectedAddress.CaseId, caseBook.SelectedAddress.Address, caseBook.SelectedAddress.Area, caseBook.SelectedAddress.CityId, caseBook.SelectedAddress.StateId, caseBook.SelectedAddress.PIN, caseBook.SelectedAddress.CreatedBy, caseBook.SelectedAddress.CreatedDateTime, caseBook.SelectedAddress.ModifiedBy, caseBook.SelectedAddress.ModifiedDatetime, }); caseAddressTable.AcceptChanges(); var updatedAddress = this.unitOfWork.DbContext.ExecuteStoredProcedure <vCaseAddress>("[Ops].[saveAddress]", parmsCollection .AddParm("@caseAddressType", SqlDbType.Structured, caseAddressTable, "[Ops].[CaseAddressType]") ).Last(); return(updatedAddress); }
public IActionResult UpdateOffender([FromBody] CaseBook caseBook) { caseBook.SelectedOffender.CaseId = caseBook.Case.CaseId; var updatedCase = this.caseBusinessAccess.UpdateOffender(caseBook); return(Ok(updatedCase)); }
public IActionResult UpdateCaseManagement([FromBody] CaseBook caseBook) { int updatedCase = 0; caseBook.Manage.CaseId = caseBook.Case.CaseId; caseBook.Manage.TypesOfCounselingLookupId = caseBook.Manage.TypesOfCounselingLookupArray.ToArrayString(); updatedCase = this.caseBusinessAccess.UpdateCaseManagement(caseBook); try { updatedCase = this.caseBusinessAccess.UpdateCaseManagement(caseBook); } catch (Exception ex) { if (ex.InnerException is DeletedRowInaccessibleException) { return(StatusCode(409)); } else if (ex.InnerException is UpdateException) { return(StatusCode(500)); } else { return(StatusCode(400)); } } return(Ok(updatedCase)); }
public IActionResult UpdateMental([FromBody] CaseBook caseBook) { caseBook.SelectedMental.CaseId = caseBook.Case.CaseId; caseBook.SelectedMental.MentalAbstractionLookupId = caseBook.SelectedMental.MentalAbstractionLookupArray.ToArrayString(); caseBook.SelectedMental.MentalAttentionLookupId = caseBook.SelectedMental.MentalAttentionLookupArray.ToArrayString(); caseBook.SelectedMental.MentalBehaviourLookupId = caseBook.SelectedMental.MentalBehaviourLookupArray.ToArrayString(); caseBook.SelectedMental.MentalBodyTypeLookupId = caseBook.SelectedMental.MentalBodyTypeLookupArray.ToArrayString(); caseBook.SelectedMental.MentalContentLookupId = caseBook.SelectedMental.MentalContentLookupArray.ToArrayString(); caseBook.SelectedMental.MentalDressLookupId = caseBook.SelectedMental.MentalDressLookupArray.ToArrayString(); caseBook.SelectedMental.MentalEstimatedIntellectLookupId = caseBook.SelectedMental.MentalEstimatedIntellectLookupArray.ToArrayString(); caseBook.SelectedMental.MentalExpressionLookupId = caseBook.SelectedMental.MentalExpressionLookupArray.ToArrayString(); caseBook.SelectedMental.MentalFlowOfThoughtLookupId = caseBook.SelectedMental.MentalFlowOfThoughtLookupArray.ToArrayString(); caseBook.SelectedMental.MentalHygieneLookupId = caseBook.SelectedMental.MentalHygieneLookupArray.ToArrayString(); caseBook.SelectedMental.MentalImpulseControlLookupId = caseBook.SelectedMental.MentalImpulseControlLookupArray.ToArrayString(); caseBook.SelectedMental.MentalInformationLookupId = caseBook.SelectedMental.MentalInformationLookupArray.ToArrayString(); caseBook.SelectedMental.MentalInsightLookupId = caseBook.SelectedMental.MentalInsightLookupArray.ToArrayString(); caseBook.SelectedMental.MentalJudgementLookupId = caseBook.SelectedMental.MentalJudgementLookupArray.ToArrayString(); caseBook.SelectedMental.MentalMemoryLookupId = caseBook.SelectedMental.MentalMemoryLookupArray.ToArrayString(); caseBook.SelectedMental.MentalMotorActivityLookupId = caseBook.SelectedMental.MentalMotorActivityLookupArray.ToArrayString(); caseBook.SelectedMental.MentalSpeechLookupId = caseBook.SelectedMental.MentalSpeechLookupArray.ToArrayString(); caseBook.SelectedMental.MentalVocabularyLookupId = caseBook.SelectedMental.MentalVocabularyLookupArray.ToArrayString(); caseBook.SelectedMental.MentalOrientationLookupId = caseBook.SelectedMental.MentalOrientationLookupArray.ToArrayString(); var updatedCase = this.caseBusinessAccess.UpdateMental(caseBook); return(Ok(updatedCase)); }
public IActionResult UpdateLegal([FromBody] CaseBook caseBook) { caseBook.Legal.CaseId = caseBook.Case.CaseId; caseBook.Legal.OutcomeLookupId = caseBook.Legal.OutcomeLookupArray.ToArrayString(); caseBook.Legal.DocumentsLookupId = caseBook.Legal.DocumentsLookupArray.ToArrayString(); var updatedCase = this.caseBusinessAccess.UpdateLegal(caseBook); return Ok(updatedCase); }
public IActionResult UpdatePhysicalHealth([FromBody] CaseBook caseBook) { caseBook.PhysicalHealth.CaseId = caseBook.Case.CaseId; caseBook.PhysicalHealth.ReasonForSeekingHelpLookupId = caseBook.PhysicalHealth.ReasonForSeekingHelpLookupArray.ToArrayString(); caseBook.PhysicalHealth.WhoIsAbusingYouLookupId = caseBook.PhysicalHealth.WhoIsAbusingYouLookupArray.ToArrayString(); var updatedCase = this.caseBusinessAccess.UpdatePhysicalHealth(caseBook); return Ok(updatedCase); }
public CaseHeader SavePrimaryCase(CaseBook caseBook) { var parmsCollection = new ParmsCollection(); var caseTable = UserDefinedTableTypes.Case; caseTable.Rows.Add(new object[] { caseBook.Case.CaseId, caseBook.Case.CaseNumber, caseBook.Case.CenterId, caseBook.Case.CaseStausId, caseBook.Case.CounselorId, caseBook.Case.PeaceMakerId, caseBook.Case.ClientFirstName, caseBook.Case.ClientLastName, caseBook.Case.Mi, caseBook.Case.FatherName, caseBook.Case.GenderLookupId, caseBook.Case.RequireAssistanceLookupId, caseBook.Case.MaritalStatusLookupId, caseBook.Case.Remarks, caseBook.Case.RegisterDate, caseBook.Case.MobileNumber, caseBook.Case.CreatedBy, caseBook.Case.CreatedDateTime, caseBook.Case.ModifiedBy, caseBook.Case.ModifiedDatetime, }); caseTable.AcceptChanges(); var caseAddressTable = UserDefinedTableTypes.CaseAddress; caseAddressTable.Rows.Add(new object[] { caseBook.SelectedAddress.CaseAddressId, caseBook.SelectedAddress.CaseId, caseBook.SelectedAddress.Address, caseBook.SelectedAddress.Area, caseBook.SelectedAddress.CityId, caseBook.SelectedAddress.StateId, caseBook.SelectedAddress.PIN, caseBook.SelectedAddress.CreatedBy, caseBook.SelectedAddress.CreatedDateTime, caseBook.SelectedAddress.ModifiedBy, caseBook.SelectedAddress.ModifiedDatetime, }); caseAddressTable.AcceptChanges(); var updatedCase = this.unitOfWork.DbContext.ExecuteStoredProcedure <CaseHeader>("[Ops].[savePrimaryCase]", parmsCollection .AddParm("@caseType", SqlDbType.Structured, caseTable, "[Ops].[CaseType]") .AddParm("@caseAddressType", SqlDbType.Structured, caseAddressTable, "[Ops].[CaseAddressType]") ).First(); return(updatedCase); }
public IActionResult UpdateHouseHold([FromBody] CaseBook caseBook) { caseBook.FamilyHouseHold.CaseId = caseBook.Case.CaseId; caseBook.FamilyHouseHold.ChildrenDeceasedLookupId = caseBook.FamilyHouseHold.ChildrenDeceasedLookupArray.ToArrayString(); caseBook.FamilyHouseHold.PeacemakerAssistanceLookupId = caseBook.FamilyHouseHold.PeacemakerAssistanceLookupArray.ToArrayString(); caseBook.FamilyHouseHold.HouseHoldMembersLivingLookupId = caseBook.FamilyHouseHold.HouseHoldMembersLivingLookupArray.ToArrayString(); var updatedCase = this.caseBusinessAccess.UpdateHouseHold(caseBook); return Ok(updatedCase); }
public IActionResult UpdateAddress([FromBody] CaseBook caseBook) { caseBook.SelectedAddress.CreatedBy = this.LoggedInUserId; caseBook.SelectedAddress.ModifiedBy = this.LoggedInUserId; caseBook.SelectedAddress.CreatedDateTime = DateTime.Now; caseBook.SelectedAddress.ModifiedDatetime = DateTime.Now; var updatedCase = this.caseBusinessAccess.UpdateAddress(caseBook); return Ok(updatedCase); }
public CaseHeader UpdateAbuse(CaseBook caseBook) { var parmsCollection = new ParmsCollection(); var caseChildrenTable = UserDefinedTableTypes.Abuse; caseChildrenTable.Rows.Add(new object[] { caseBook.Abuse.CaseAbuseId, caseBook.Abuse.CaseId, caseBook.Abuse.SufferingFromAbuseLookupId, caseBook.Abuse.SufferingFromAbuseDesc, caseBook.Abuse.FeelAboutAbuseLookupId, caseBook.Abuse.ParentsFeelAboutAbuseLookupId, caseBook.Abuse.LawFeelAboutAbuseLookupId, caseBook.Abuse.SignsOfPhysicalAbuseLookupId, caseBook.Abuse.SignsOfPhysicalAbuseDesc, caseBook.Abuse.WeaponsUsedLookupId, caseBook.Abuse.WeaponsUsedDesc, caseBook.Abuse.TypesOfPhyscialAbuseLookupId, caseBook.Abuse.FrequencyOfPhyscialAbuseLookupId, caseBook.Abuse.NumberOfYearsOfPhyscialAbuse, caseBook.Abuse.TypesOfEmotionalAbuseLookupId, caseBook.Abuse.FrequencyOfEmotionalAbuseLookupId, caseBook.Abuse.NumberOfYearsOfEmotionalAbuse, caseBook.Abuse.TypesOfSexualAbuseLookupId, caseBook.Abuse.FrequencyOfSexualAbuseLookupId, caseBook.Abuse.NumberOfYearsOfSexualAbuse, caseBook.Abuse.TypesOfEconomicAbuseLookupId, caseBook.Abuse.FrequencyOfEconomicAbuseLookupId, caseBook.Abuse.NumberOfYearsOfEconomicAbuse, caseBook.Abuse.ReasonsForAbuseLookupId, caseBook.Abuse.ReasonForAbuseDesc, caseBook.Abuse.PhysicalAbuseDesc, caseBook.Abuse.EmotionalAbuseDesc, caseBook.Abuse.SexualAbuseDesc, caseBook.Abuse.EconomicAbuseDesc, }); caseChildrenTable.AcceptChanges(); var updatedCase = this.unitOfWork.DbContext.ExecuteStoredProcedure <CaseHeader>("[Ops].[saveAbuse]", parmsCollection .AddParm("@caseAbuseType", SqlDbType.Structured, caseChildrenTable, "[Ops].[CaseAbuseType]") ).First(); return(updatedCase); }
public CaseHeader UpdateCaseStatus(CaseBook caseBook) { UpdateCaseManagement(caseBook); var updatedCaseHeader = UpdateHouseHold(caseBook); updatedCaseHeader = UpdateSpouse(caseBook); updatedCaseHeader = UpdatePhysicalHealth(caseBook); updatedCaseHeader = UpdateAbuse(caseBook); return(updatedCaseHeader); }
public IActionResult UpdateChildren([FromBody] CaseBook caseBook) { if(caseBook.SelectedChildren.CaseChildrenId==0) { caseBook.SelectedChildren.CreatedBy = this.LoggedInUserId; caseBook.SelectedChildren.ModifiedBy = this.LoggedInUserId; caseBook.SelectedChildren.CreatedDateTime = DateTime.Now; } caseBook.SelectedChildren.ModifiedDatetime = DateTime.Now; var updatedCase = this.caseBusinessAccess.UpdateChildren(caseBook); return Ok(updatedCase); }
public int UpdateCaseManagement(CaseBook caseBook) { int updatedCaseManagement; try { updatedCaseManagement = this.caseDataAccess.UpdateCaseManagement(caseBook); } catch (Exception ex) { throw; } return(updatedCaseManagement); }
public IActionResult UpdateAbuse([FromBody] CaseBook caseBook) { caseBook.Abuse.CaseId = caseBook.Case.CaseId; caseBook.Abuse.FeelAboutAbuseLookupId = caseBook.Abuse.FeelAboutAbuseLookupArray.ToArrayString(); caseBook.Abuse.ParentsFeelAboutAbuseLookupId = caseBook.Abuse.ParentsFeelAboutAbuseLookupArray.ToArrayString(); caseBook.Abuse.LawFeelAboutAbuseLookupId = caseBook.Abuse.LawFeelAboutAbuseLookupArray.ToArrayString(); caseBook.Abuse.WeaponsUsedLookupId= caseBook.Abuse.WeaponsUsedLookupArray.ToArrayString(); caseBook.Abuse.TypesOfPhyscialAbuseLookupId = caseBook.Abuse.TypesOfPhyscialAbuseLookupArray.ToArrayString(); caseBook.Abuse.TypesOfEmotionalAbuseLookupId = caseBook.Abuse.TypesOfEmotionalAbuseLookupArray.ToArrayString(); caseBook.Abuse.TypesOfSexualAbuseLookupId = caseBook.Abuse.TypesOfSexualAbuseLookupArray.ToArrayString(); caseBook.Abuse.TypesOfEconomicAbuseLookupId = caseBook.Abuse.TypesOfEconomicAbuseLookupArray.ToArrayString(); caseBook.Abuse.ReasonsForAbuseLookupId = caseBook.Abuse.ReasonsForAbuseLookupArray.ToArrayString(); var updatedCase = this.caseBusinessAccess.UpdateAbuse(caseBook); return Ok(updatedCase); }
public CaseHeader UpdatePhysicalHealth(CaseBook caseBook) { var parmsCollection = new ParmsCollection(); var caseChildrenTable = UserDefinedTableTypes.PhysicalHealth; caseChildrenTable.Rows.Add(new object[] { caseBook.PhysicalHealth.CasePhysicalHealthId, caseBook.PhysicalHealth.CaseId, caseBook.PhysicalHealth.SufferingFromAnyMajorIllnessLookupId, caseBook.PhysicalHealth.SufferingFromAnyMajorIllnessDesc, caseBook.PhysicalHealth.DiagnosedPsychiatricIllnessLookupId, caseBook.PhysicalHealth.DiagnosedPsychiatricIllnessDesc, caseBook.PhysicalHealth.SleepPerNightLookupId, caseBook.PhysicalHealth.AppetiteLookupId, caseBook.PhysicalHealth.ExerciseLookupId, caseBook.PhysicalHealth.AnyMedicationLookupId, caseBook.PhysicalHealth.AnyMedicationDesc, caseBook.PhysicalHealth.AnySubstanceLookupId, caseBook.PhysicalHealth.AnySubstanceDesc, caseBook.PhysicalHealth.CurrentlyPregnantLookup, caseBook.PhysicalHealth.CurrentlyPregnantDesc, caseBook.PhysicalHealth.ReasonForSeekingHelpLookupId, caseBook.PhysicalHealth.WhoIsAbusingYouLookupId, caseBook.PhysicalHealth.WhoIsAbusingYouDesc, caseBook.PhysicalHealth.ReasonForSeekingHelpDesc }); caseChildrenTable.AcceptChanges(); var updatedCase = this.unitOfWork.DbContext.ExecuteStoredProcedure <CaseHeader>("[Ops].[savePhysicalHealth]", parmsCollection .AddParm("@casePhysicalHealthType", SqlDbType.Structured, caseChildrenTable, "[Ops].[CasePhysicalHealthType]") ).First(); return(updatedCase); }
public IActionResult SaveCasePrimary([FromBody] CaseBook caseBook) { caseBook.Case.CreatedBy = this.LoggedInUserId; caseBook.Case.ModifiedBy = this.LoggedInUserId; caseBook.Case.CreatedDateTime = DateTime.Now; caseBook.Case.ModifiedDatetime = DateTime.Now; caseBook.SelectedAddress.CreatedBy = this.LoggedInUserId; caseBook.SelectedAddress.ModifiedBy = this.LoggedInUserId; caseBook.SelectedAddress.CreatedDateTime = DateTime.Now; caseBook.SelectedAddress.ModifiedDatetime = DateTime.Now; caseBook.Case.RegisterDate = DateTime.Now.Date; //caseBook.Addresses = new List<CaseAddress> { caseBook.SelectedAddress }; var createdCase = this.caseBusinessAccess.SavePrimaryCase(caseBook); return Ok(createdCase); }