public SelectList GenderList()
{
var cv = new CodeValueModel();
return new SelectList(cv.GenderCodes(), "Id", "Value");
}
private static void UpdatePeople(DbConnection cn, CMSDataContext Db, int userPeopleId)
{
var cv = new CodeValueModel();
var pcmd = cn.CreateCommand();
pcmd.CommandText = "select * from [Sheet1$]";
var rd = pcmd.ExecuteReader();
while (rd.Read())
{
var i = Util.GetAs(rd, typeof(UpdatePeopleItem)) as UpdatePeopleItem;
var p = Db.LoadPersonById(i.PeopleId);
//var psb = new StringBuilder();
var psb = new List<ChangeDetail>();
p.UpdateValue(psb, "TitleCode", i.Title);
p.UpdateValue(psb, "FirstName", i.First);
p.UpdateValue(psb, "NickName", i.GoesBy);
p.UpdateValue(psb, "LastName", i.Last);
p.UpdateValue(psb, "SuffixCode", i.Suffix);
p.UpdateValue(psb, "EmailAddress", i.Email1);
p.UpdateValue(psb, "EmailAddress2", i.Email2);
p.UpdateValue(psb, "DOB", i.BirthDate.FormatDate());
p.UpdateValue(psb, "WeddingDate", i.Anniversary);
p.UpdateValue(psb, "JoinDate", i.Joined);
p.UpdateValue(psb, "CellPhone", i.Cell.GetDigits());
p.UpdateValue(psb, "WorkPhone", i.Work.GetDigits());
p.UpdateValue(psb, "AltName", i.AltName);
p.UpdateValue(psb, "SchoolOther", i.School);
p.UpdateValue(psb, "OccupationOther", i.Occupation);
p.UpdateValue(psb, "EmployerOther", i.Employer);
p.UpdateValue(psb, "Grade", i.Grade);
p.UpdateValue(psb, "DeceasedDate", i.Deceased);
p.UpdateValue(psb, "MemberStatusId", CviOrNull(cv.MemberStatusCodes().SingleOrDefault(c => c.Value == i.Member)) ?? 20);
p.UpdateValue(psb, "GenderId", CviOrNull(cv.GenderCodes().SingleOrDefault(c => c.Value == i.Gender)) ?? 0);
p.UpdateValue(psb, "MaritalStatusId", CviOrNull(cv.MaritalStatusCodes().SingleOrDefault(c => c.Value == i.Marital)) ?? 0);
p.UpdateValue(psb, "PositionInFamilyId", CviOrNull(cv.FamilyPositionCodes().SingleOrDefault(c => c.Value == i.FamilyPos)) ?? 0);
p.UpdateValue(psb, "CampusId", CviOrNull(cv.AllCampuses().SingleOrDefault(c => c.Value == i.Campus)));
p.LogChanges(Db, psb);
Db.SubmitChanges();
}
}
public static IEnumerable<SelectListItem> GenderCodes()
{
var cv = new CodeValueModel();
return CodeValueModel.ConvertToSelect(cv.GenderCodes(), "Id");
}
public IEnumerable<TitleItems> FetchTitleItems()
{
var Model = new CodeValueModel();
return new List<TitleItems>
{
new TitleItems { title = "Approval Codes", Instructions = "(negative to remove, 0 to remove all)", items = Model.VolunteerCodes() },
new TitleItems { title = "Baptism Status Codes", items = Model.BaptismStatusList() },
new TitleItems { title = "Baptism Type Codes", items = Model.BaptismTypeList() },
new TitleItems { title = "Campus Codes", items = Model.AllCampuses() },
new TitleItems { title = "Contribution Statement Options", items = Model.EnvelopeOptionList() },
new TitleItems { title = "Decision Type Codes", items = Model.DecisionTypeList() },
new TitleItems { title = "Drop Type Codes", items = Model.DropTypeList() },
new TitleItems { title = "Envelope Options", items = Model.EnvelopeOptionList() },
new TitleItems { title = "Entry Point Codes", items = Model.EntryPoints() },
new TitleItems { title = "Family Position Codes", items = Model.FamilyPositionCodes() },
new TitleItems { title = "Gender Codes", items = Model.GenderCodes() },
new TitleItems { title = "Grades", items = Grades(), UseCode = true},
new TitleItems { title = "Join Type Codes", items = Model.JoinTypeList() },
new TitleItems { title = "Marital Status Codes", items = Model.MaritalStatusCodes() },
new TitleItems { title = "Member Status Codes", items = Model.MemberStatusCodes() },
new TitleItems { title = "New Member Class", items = Model.NewMemberClassStatusList() },
new TitleItems { title = "Receive SMS", items = ReceiveSMS(), UseCode = true},
};
}
public IEnumerable<TitleItems> TitleItems()
{
var Model = new CodeValueModel();
return new List<TitleItems>
{
new TitleItems { title = "Member Status Codes", items = Model.MemberStatusCodes() },
new TitleItems { title = "Drop Type Codes", items = Model.DropTypes() },
new TitleItems { title = "Baptism Status Codes", items = Model.BaptismStatuses() },
new TitleItems { title = "Baptism Type Codes", items = Model.BaptismTypes() },
new TitleItems { title = "Campus Codes", items = Model.AllCampuses() },
new TitleItems { title = "Marital Status Codes", items = Model.MaritalStatusCodes() },
new TitleItems { title = "Gender Codes", items = Model.GenderCodes() },
new TitleItems { title = "Family Position Codes", items = Model.FamilyPositionCodes() },
new TitleItems { title = "Contribution Statement Options", items = Model.EnvelopeOptions() },
new TitleItems { title = "Envelope Options", items = Model.EnvelopeOptions() },
new TitleItems { title = "Entry Point Codes", items = Model.EntryPoints() },
new TitleItems { title = "New Member Class", items = Model.NewMemberClassStatusCodes() },
new TitleItems { title = "Approval Codes (negative to remove, 0 to remove all)", items = Model.VolunteerCodes() },
};
}
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 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;
}