public async Task <ActionResult> DeleteConfirmed(int id)
{
IndividualMember individualMember = await db.IndividualMembers.FindAsync(id);
db.IndividualMembers.Remove(individualMember);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,Name,Surname,DOB,Age,Gender,Tel,BirthWeight,ReceivingGrant,Head,IsReferral")] IndividualMember individualMember)
{
if (ModelState.IsValid)
{
db.Entry(individualMember).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(individualMember));
}
public async Task <ActionResult> Create([Bind(Include = "Id,Name,Surname,DOB,Age,Gender,Tel,BirthWeight,ReceivingGrant,Head,IsReferral")] IndividualMember individualMember)
{
if (ModelState.IsValid)
{
db.IndividualMembers.Add(individualMember);
await db.SaveChangesAsync();
return(RedirectToAction("SelectedForm", "Documents"));
}
return(View(individualMember));
}
// GET: IndividualMembers/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
IndividualMember individualMember = await db.IndividualMembers.FindAsync(id);
if (individualMember == null)
{
return(HttpNotFound());
}
return(View(individualMember));
}
public ActionResult SubmitReferral(ReferralViewModel referral)
{
try
{
using (var connection = AppUtils.GetOpenConnection())
{
//Insert CHW
CHW chw = referral.CHW;
string sql = @"INSERT INTO CHW (HouseholdIdNumber,Name) VALUES";
sql += "(@HouseholdIdNumber, @Name)";
Dapper.SqlMapper.Execute(connection, sql, chw);
//Insert Clinic
Clinic clinic = referral.Clinic;
sql = @"INSERT INTO clinic (ClinicDescription,Active) VALUES";
sql += "(@ClinicDescription, @Active)";
Dapper.SqlMapper.Execute(connection, sql, clinic);
//Insert Ward
Ward ward = referral.Ward;
sql = @"INSERT INTO Ward (HouseholdIdNumber,Name) VALUES";
sql += "(@HouseholdIdNumber, @Name)";
Dapper.SqlMapper.Execute(connection, sql, ward);
//Insert House
Referral objReferral = referral.Referral;
sql = @"INSERT INTO Referrals (VisitId,ReferralReasonId,ReferralOutcome,ReferredTo,BackReferralReceived) VALUES";
sql += "(@Visit.Id,@ReferralReason.Id,@ReferralOutcome,@ReferredTo,@BackReferralReceived)";
Dapper.SqlMapper.Execute(connection, sql, objReferral);
//Insert IndividualMember
IndividualMember individualMember = referral.Member;
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, individualMember);
//Insert Question
foreach (var question in referral.Questions)
{
sql = @"INSERT INTO Questions (QuestionCategoryId,QuestionDescription,Active) VALUES";
sql += "(@QuestionCategory.Id,@QuestionDescription,@Active)";
Dapper.SqlMapper.Execute(connection, sql, question);
}
}
return(RedirectToAction("Index", "Home"));
}
catch
{
return(PartialView("_CreateReferralForm"));
}
}
public ActionResult SubmitMaternalandChildHealthRecord(MaternalandChildHealthRecordViewModel maternalAndChild)
{
try
{
using (var connection = AppUtils.GetOpenConnection())
{
//Insert CHW
CHW chw = maternalAndChild.CHW;
string sql = @"INSERT INTO CHW (HouseholdIdNumber,Name) VALUES";
sql += "(@HouseholdIdNumber, @Name)";
Dapper.SqlMapper.Execute(connection, sql, chw);
//Insert Clinic
Clinic clinic = maternalAndChild.Clinic;
sql = @"INSERT INTO clinic (ClinicDescription,Active) VALUES";
sql += "(@ClinicDescription, @Active)";
Dapper.SqlMapper.Execute(connection, sql, clinic);
//Insert Ward
Ward ward = maternalAndChild.Ward;
sql = @"INSERT INTO Ward (HouseholdIdNumber,Name) VALUES";
sql += "(@HouseholdIdNumber, @Name)";
Dapper.SqlMapper.Execute(connection, sql, ward);
//Insert IndividualMember Mother
IndividualMember mother = maternalAndChild.Mother;
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, mother);
//Insert IndividualMember Child
IndividualMember child = maternalAndChild.Child;
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, child);
//Insert Visits
foreach (var visits in maternalAndChild.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 Question
foreach (var question in maternalAndChild.Questions)
{
sql = @"INSERT INTO Questions (QuestionCategoryId,QuestionDescription,Active) VALUES";
sql += "(@QuestionCategory.Id,@QuestionDescription,@Active)";
Dapper.SqlMapper.Execute(connection, sql, question);
}
}
return(RedirectToAction("Index", "Home"));
}
catch
{
return(PartialView("_CreateMaternalandChildHealthRecord"));
}
}
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"));
}
}
