public static HouseholdRegistrationViewModel LoadHouseholdRegistration()
{
HouseholdRegistrationViewModel objHouseholdRegistration = new HouseholdRegistrationViewModel();
objHouseholdRegistration.Clinics = LoadClinics();
objHouseholdRegistration.Wards = LoadWards();
objHouseholdRegistration.CHW = CurrentCHW();
objHouseholdRegistration.Households = LoadHouseholds();
objHouseholdRegistration.QuestionCategories = LoadQuestionCategories();
return(objHouseholdRegistration);
}
private PartialViewResult LoadHouseholdRegistration(HouseholdRegistrationViewModel model)
{
string viewName = "HouseholdRegistration/_CreateHouseHoldRegistration";
if (model == null)
{
var householdRegForm = AppUtils.LoadHouseholdRegistration();
TempData["CHW"] = householdRegForm.CHW.Id;
return(PartialView(viewName, householdRegForm));
}
else
{
return(PartialView(viewName, model));
}
}
public static List <HouseholdRegistrationViewModel> LoadIndividualAdultHealthRecord()
{
//TODO: To be completed properly
List <HouseholdRegistrationViewModel> list = new List <HouseholdRegistrationViewModel>();
using (var connection = AppUtils.GetOpenConnection())
{
string sql = "select top 100 * from Visit";
List <Visit> visits = Dapper.SqlMapper.Query <Visit>(connection, sql).ToList();
foreach (Visit visit in visits)
{
HouseholdRegistrationViewModel model = new HouseholdRegistrationViewModel();
model.House.Household.Visit = visit;
list.Add(model);
}
}
return(list);
}
public ActionResult SubmitHouseHoldRegistration(HouseholdRegistrationViewModel householdRegistration)
{
try
{
using (var connection = AppUtils.GetOpenConnection())
{
//Insert CHW
CHW chw = householdRegistration.CHW;
string sql = @"INSERT INTO CHW (HouseholdIdNumber,Name) VALUES";
sql += "(@HouseholdIdNumber, @Name)";
Dapper.SqlMapper.Execute(connection, sql, chw);
//Insert Clinic
Clinic clinic = householdRegistration.Clinic;
sql = @"INSERT INTO clinic (ClinicDescription,Active) VALUES";
sql += "(@ClinicDescription, @Active)";
Dapper.SqlMapper.Execute(connection, sql, clinic);
//Insert Ward
Ward ward = householdRegistration.Ward;
sql = @"INSERT INTO Ward (HouseholdIdNumber,Name) VALUES";
sql += "(@HouseholdIdNumber, @Name)";
Dapper.SqlMapper.Execute(connection, sql, ward);
//Insert House
House house = householdRegistration.House;
sql = @"INSERT INTO House (HouseholdId,Electricity,PipedWater,Toilet,Fridge,Rooms,AmountOfGrants,AmountOfWorkingMembers,NameOfSchools) VALUES";
sql += "(@Household.Id,@Electricity,@PipedWater,@Toilet,@Fridge,@Rooms,@AmountOfGrants,@AmountOfWorkingMembers,@NameOfSchools)";
Dapper.SqlMapper.Execute(connection, sql, house);
//Insert IndividualMember
foreach (var individualMember in householdRegistration.Members)
{
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 householdRegistration.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("_CreateHouseHoldRegistration"));
}
}
