public ActionResult UpdateFieldsRun(UpdateFieldsModel m) { m.Run(ModelState); if (!ModelState.IsValid) { return(View("UpdateFields", m)); } TempData["success"] = "{0} updated with the value '{1}' for {2} records ".Fmt(m.Field, m.NewValue, m.Count); return(RedirectToAction("UpdateFields")); }
public ActionResult UpdateWarning(UpdateFieldsModel m) { if (m.Field == "Drop All Enrollments") { return(Content(@" Important! Drop All Enrollments will make all the selected people previous members of every organization in which they are enrolled. There is no Undo button.")); } return(new EmptyResult()); }
public ActionResult UpdateFieldsRun(UpdateFieldsModel m) { m.Run(ModelState); if (!ModelState.IsValid) { return(View("UpdateFields", m)); } Util.TempSuccessMessage = $"{m.Field} updated with the value '{m.NewValue}' for {m.Count} records "; return(RedirectToAction("UpdateFields")); }
public ActionResult UpdateFields() // UpdateForATag { var m = new UpdateFieldsModel(); var success = (string)TempData["success"]; if (success.HasValue()) { ViewData["success"] = success; } ViewData["text"] = ""; return(View(m)); }
public ActionResult UpdateFieldsCount(UpdateFieldsModel m) { var q = m.People(); return(Content(q.Count().ToString())); }
public ActionResult UpdateFields() // UpdateForATag { var m = new UpdateFieldsModel(); if (Request.HttpMethod.ToUpper() == "GET") { var success = (string)TempData["success"]; if (success.HasValue()) { ViewData["success"] = success; } ViewData["text"] = ""; return(View(m)); } UpdateModel(m); var a = m.Tag.SplitStr(":", 2); if (a.Length > 1) { a[1] = a[1].TrimStart(); } IQueryable <Person> q = null; if (a[0] == "last query") { q = DbUtil.Db.PeopleQuery(Util.QueryBuilderScratchPadId); } else if (a[0] == "tag") { var b = a[1].SplitStr(":", 2); var tag = DbUtil.Db.TagById(b[0].ToInt()); q = tag.People(DbUtil.Db); } else if (a[0] == "exval") { var b = a[1].SplitStr(":", 2); q = from e in DbUtil.Db.PeopleExtras where e.Field == b[0] where e.StrValue == b[1] select e.Person; } foreach (var p in q) { switch (m.Field) { case "Member Status": p.MemberStatusId = m.NewValue.ToInt(); break; case "New Member Class": p.NewMemberClassStatusId = m.NewValue.ToInt(); break; case "Drop Type": p.DropCodeId = m.NewValue.ToInt(); break; case "Baptism Status": p.BaptismStatusId = m.NewValue.ToInt(); break; case "Baptism Type": p.BaptismTypeId = m.NewValue.ToInt(); break; case "Campus": p.CampusId = m.NewValue.ToInt(); break; case "Marital Status": p.MaritalStatusId = m.NewValue.ToInt(); break; case "Family Position": p.PositionInFamilyId = m.NewValue.ToInt(); break; case "Entry Point": p.EntryPointId = m.NewValue.ToInt(); break; case "Gender": p.GenderId = m.NewValue.ToInt(); break; case "Occupation": p.OccupationOther = m.NewValue; break; case "School": p.SchoolOther = m.NewValue; break; case "Employer": p.EmployerOther = m.NewValue; break; case "Grade": if (m.NewValue == "+1") { p.Grade = p.Grade + 1; } else { p.Grade = m.NewValue.ToInt(); } break; case "Statement Options": p.ContributionOptionsId = m.NewValue.ToInt(); break; case "Envelope Options": p.EnvelopeOptionsId = m.NewValue.ToInt(); break; case "Approval Codes": { var i = p.Volunteers.SingleOrDefault(); if (i == null) { i = new Volunteer { PeopleId = p.PeopleId }; DbUtil.Db.Volunteers.InsertOnSubmit(i); DbUtil.Db.SubmitChanges(); } var code = m.NewValue.ToInt(); var app = (from v in DbUtil.Db.VoluteerApprovalIds where v.ApprovalId == Math.Abs(code) where v.PeopleId == p.PeopleId select v).SingleOrDefault(); if (code < 0) { if (app != null) { DbUtil.Db.VoluteerApprovalIds.DeleteOnSubmit(app); } } else if (code > 0) { if (app == null) { p.VoluteerApprovalIds.Add(new VoluteerApprovalId { ApprovalId = code, }); } } else if (code == 0) { DbUtil.Db.VoluteerApprovalIds.DeleteAllOnSubmit(p.VoluteerApprovalIds); } } break; case "Background Check Date": { var i = p.Volunteers.SingleOrDefault(); if (i == null) { i = new Volunteer { PeopleId = p.PeopleId }; DbUtil.Db.Volunteers.InsertOnSubmit(i); DbUtil.Db.SubmitChanges(); } i.ProcessedDate = m.NewValue.ToDate(); } break; case "Title": p.TitleCode = m.NewValue; break; case "ReceiveSMS": p.ReceiveSMS = m.NewValue.ToBool(); break; } DbUtil.Db.SubmitChanges(); } TempData["success"] = m.Field + " Updated"; return(RedirectToAction("UpdateFields")); }
public static IEnumerable <CodeValueItem> Fetch(string field, ref bool useCode) { IEnumerable <CodeValueItem> m = null; var lookups = new CodeValueModel(); switch (field) { case "Approval Codes": m = lookups.VolunteerCodes(); break; case "Baptism Status": m = lookups.BaptismStatusList(); break; case "Baptism Type": m = lookups.BaptismTypeList(); break; case "Bad Address Flag": m = UpdateFieldsModel.BadAddressFlag(); useCode = true; break; case "Campus": m = lookups.AllCampuses(); break; case "Statement Options": m = lookups.EnvelopeOptionList(); break; case "Electronic Statement": m = UpdateFieldsModel.ElectronicStatement(); useCode = true; break; case "Decision Type": m = lookups.DecisionTypeList(); break; case "Do Not Call": m = UpdateFieldsModel.DoNotCall(); useCode = true; break; case "Do Not Mail": m = UpdateFieldsModel.DoNotMail(); useCode = true; break; case "Drop Type": m = lookups.DropTypeList(); break; case "Envelope Options": m = lookups.EnvelopeOptionList(); break; case "Entry Point": m = lookups.EntryPoints(); useCode = false; break; case "Family Position": m = lookups.FamilyPositionCodes(); break; case "Gender": m = lookups.GenderCodes(); break; case "Grade": m = UpdateFieldsModel.Grades(); useCode = true; break; case "Join Type": m = lookups.JoinTypeList(); break; case "Marital Status": m = lookups.MaritalStatusCodes(); break; case "Member Status": m = lookups.MemberStatusCodes(); break; case "New Member Class": m = lookups.NewMemberClassStatusList(); break; case "ReceiveSMS": m = UpdateFieldsModel.ReceiveSMS(); useCode = true; break; } return(m); }