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