public static IndividualAdultHealthRecordViewModel LoadVisitSummary()
{
IndividualAdultHealthRecordViewModel objIndividualHealthRecord = new IndividualAdultHealthRecordViewModel();
return(objIndividualHealthRecord);
}
public static IndividualAdultHealthRecordViewModel LoadMaternalandChildHealthRecord()
{
IndividualAdultHealthRecordViewModel objIndividualHealthRecord = new IndividualAdultHealthRecordViewModel();
return(objIndividualHealthRecord);
}
public static IndividualAdultHealthRecordViewModel LoadOutreachTeamMonthlySummary()
{
IndividualAdultHealthRecordViewModel objIndividualHealthRecord = new IndividualAdultHealthRecordViewModel();
return(objIndividualHealthRecord);
}
public ActionResult SubmitIndividualAdultHealthRecord(IndividualAdultHealthRecordViewModel individualAdultHealthRecord)
{
try
{
using (var connection = AppUtils.GetOpenConnection())
{
//Insert CHW
CHW chw = individualAdultHealthRecord.CHW;
string sql = @"INSERT INTO CHW (HouseholdIdNumber,Name) VALUES";
sql += "(@HouseholdIdNumber, @Name)";
Dapper.SqlMapper.Execute(connection, sql, chw);
//Insert Clinic
Clinic clinic = individualAdultHealthRecord.Clinic;
sql = @"INSERT INTO clinic (ClinicDescription,Active) VALUES";
sql += "(@ClinicDescription, @Active)";
Dapper.SqlMapper.Execute(connection, sql, clinic);
//Insert Ward
Ward ward = individualAdultHealthRecord.Ward;
sql = @"INSERT INTO Ward (HouseholdIdNumber,Name) VALUES";
sql += "(@HouseholdIdNumber, @Name)";
Dapper.SqlMapper.Execute(connection, sql, ward);
//Insert Household
Household household = individualAdultHealthRecord.Household;
sql = @"INSERT INTO Household (VisitId,Address,RespondentId,AllMembersRegistered,PregnancyPerionIn6Weeks,Note) VALUES";
sql += "(@Visit.Id,@Address,@RespondentId,@AllMembersRegistered,@PregnancyPerionIn6Weeks,@Note)";
Dapper.SqlMapper.Execute(connection, sql, household);
//Insert NextOfKin
NextOfKin nextOfKin = individualAdultHealthRecord.NextOfKin;
sql = @"INSERT INTO NextOfKin (Name,ContactNumber) VALUES";
sql += "(@Name,@ContactNumber)";
Dapper.SqlMapper.Execute(connection, sql, nextOfKin);
//Insert IndividualMember
IndividualMember member = individualAdultHealthRecord.Head;
sql = @"INSERT INTO IndividualMember (HouseholdId,VisitId,NextOfKinId,RelationshipStatusId,Name,DOB,Age,Gender,Tel,BirthWeight,ReceivingGrant,Head) VALUES";
sql += "(@Household.Id,@Visit.Id,@NextOfKin.Id,@RelationshipStatus.Id,@Name,@DOB,@Age,@Gender,@Tel,@BirthWeight,@ReceivingGrant,@Head)";
Dapper.SqlMapper.Execute(connection, sql, member);
//Insert Visits
foreach (var visits in individualAdultHealthRecord.Visits)
{
sql = @"INSERT INTO Visits (UserId,CHWId,PreviousVisitId,ActionPerformedId,VisitDate) VALUES";
sql += "(@User.Id,@CHW.Id,@PreviousVisitId,@ActionPerformedId,@VisitDate)";
Dapper.SqlMapper.Execute(connection, sql, visits);
}
//Insert Referrals
foreach (var referral in individualAdultHealthRecord.Referrals)
{
sql = @"INSERT INTO Referral (VisitId,ReferralReasonId,ReferralOutcome,ReferredTo,BackReferralReceived) VALUES";
sql += "(@Visit.Id,@ReferralReason.Id,@ReferralOutcome,@ReferredTo,@BackReferralReceived)";
Dapper.SqlMapper.Execute(connection, sql, referral);
}
}
return(RedirectToAction("Index", "Home"));
}
catch
{
return(PartialView("_CreateIndividualAdultHealthRecord"));
}
}
