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