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