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