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