public static List<LodgeMember> SearchMembers(string searchText, string searchField, string xmlFileName) { var lodgeMembers = new List<LodgeMember>(); try { XmlDocument xdoc = new XmlDocument(); xdoc.Load(xmlFileName); //"MasonId", "Last Name", "First Name" if (searchField == "MasonId") { var memberNodes = xdoc.SelectNodes("//Members/Member[contains(@MasonId,'" + searchText + "')]"); foreach (XmlNode memberNode in memberNodes) { var lodgeMember = new LodgeMember(); lodgeMember.MemberNumber = int.Parse(memberNode.Attributes["MasonId"].InnerText); var personNode = xdoc.SelectSingleNode("//People/Person[@PersonId='" + memberNode.Attributes["PersonId"].InnerText + "']"); lodgeMember.MemberStatusText = xdoc.SelectSingleNode("//Refs/refItem[@refCode='" + memberNode["CurrentStatus"].InnerText + "']").Attributes["refDescription"].InnerText; lodgeMember.FirstName = personNode["FirstName"].InnerText; lodgeMember.LastName = personNode["LastName"].InnerText; lodgeMember.MiddleName = personNode["MiddleName"].InnerText; lodgeMember.FullName = lodgeMember.FirstName + (lodgeMember.MiddleName == "" ? " " : " " + lodgeMember.MiddleName + " ") + lodgeMember.LastName; lodgeMembers.Add(lodgeMember); } } if (searchField == "Last Name") { XmlNodeList people = xdoc.SelectNodes("//People/Person[contains(LastName,'" + searchText + "')]"); foreach (XmlNode person in people) { var lodgeMember = new LodgeMember(); lodgeMember.FirstName = person["FirstName"].InnerText; lodgeMember.LastName = person["LastName"].InnerText; lodgeMember.MiddleName = person["MiddleName"].InnerText; lodgeMember.FullName = lodgeMember.FirstName + (lodgeMember.MiddleName == "" ? " " : " " + lodgeMember.MiddleName + " ") + lodgeMember.LastName; var memberNode = xdoc.SelectSingleNode("//Members/Member[@PersonId='" + person.Attributes["PersonId"].InnerText + "']"); lodgeMember.MemberNumber = int.Parse(memberNode.Attributes["MasonId"].InnerText); lodgeMember.MemberStatusText = xdoc.SelectSingleNode("//Refs/refItem[@refCode='" + memberNode["CurrentStatus"].InnerText + "']").Attributes["refDescription"].InnerText; lodgeMembers.Add(lodgeMember); } } if (searchField == "First Name") { XmlNodeList people = xdoc.SelectNodes("//People/Person[contains(FirstName,'" + searchText + "')]"); foreach (XmlNode person in people) { var lodgeMember = new LodgeMember(); lodgeMember.FirstName = person["FirstName"].InnerText; lodgeMember.LastName = person["LastName"].InnerText; lodgeMember.MiddleName = person["MiddleName"].InnerText; lodgeMember.FullName = lodgeMember.FirstName + (lodgeMember.MiddleName == "" ? " " : " " + lodgeMember.MiddleName + " ") + lodgeMember.LastName; var memberNode = xdoc.SelectSingleNode("//Members/Member[@PersonId='" + person.Attributes["PersonId"].InnerText + "']"); lodgeMember.MemberNumber = int.Parse(memberNode.Attributes["MasonId"].InnerText); lodgeMember.MemberStatusText = xdoc.SelectSingleNode("//Refs/refItem[@refCode='" + memberNode["CurrentStatus"].InnerText + "']").Attributes["refDescription"].InnerText; lodgeMembers.Add(lodgeMember); } } if (lodgeMembers.Count == 0) lodgeMembers.Add(new LodgeMember() { FullName = "No results found" }); } catch (Exception ex) { lodgeMembers.Add(new LodgeMember() { FullName = ex.Message }); } return lodgeMembers; }
public static List<LodgeMember> GetMemberList(string xmlFileName) { var lodgeList = new List<LodgeMember>(); try { XmlDocument xDoc = new XmlDocument(); xDoc.Load(xmlFileName); XmlNodeList members = xDoc.SelectNodes("//Members/Member[@Status!='MBX']"); //"MBX" ="Deceased" /> foreach (XmlNode memberNode in members) { var lodgeMember = new LodgeMember(); lodgeMember.MemberNumber = int.Parse(memberNode.Attributes["MasonId"].InnerText); lodgeMember.MemberStatusText = xDoc.SelectSingleNode("//Refs/refItem[@refCode='" + memberNode.Attributes["Status"].InnerText + "']").Attributes["refDescription"].InnerText; lodgeMember.MemberStatus = memberNode.Attributes["Status"].InnerText; lodgeMember.LodgeStatus = xDoc.SelectSingleNode("//Refs/refItem[@refCode='" + memberNode.Attributes["LodgeStatus"].InnerText + "']").Attributes["refDescription"].InnerText; lodgeMember.Raised = memberNode.Attributes["Raised"].InnerText; lodgeMember.LastReinstated = memberNode.Attributes["LastReinstated"].InnerText; string personId = memberNode.Attributes["PersonId"].Value; XmlNode personNode = xDoc.SelectSingleNode("//People//Person[@PersonId='" + personId + "']"); lodgeMember.FirstName = personNode.Attributes["FirstName"].InnerText; lodgeMember.MiddleName = personNode.Attributes["MiddleName"].InnerText; lodgeMember.LastName = personNode.Attributes["LastName"].InnerText; lodgeMember.FullName = lodgeMember.FirstName + (lodgeMember.MiddleName == "" ? " " : " " + lodgeMember.MiddleName + " ") + lodgeMember.LastName; XmlNode addressNode = personNode.SelectSingleNode("Addresses/Address[last()]"); lodgeMember.StreetAddress = addressNode.Attributes["StreetAddress"].InnerText; lodgeMember.City = addressNode.Attributes["City"].InnerText; lodgeMember.State = addressNode.Attributes["State"].InnerText; lodgeMember.Zip = addressNode.Attributes["Zip"].InnerText; XmlNode CommDevicesNode = personNode.SelectSingleNode("CommDevices"); lodgeMember.HomePhone = CommDevicesNode.Attributes["HomePhone"].InnerText; lodgeMember.PersonalEmail = CommDevicesNode.Attributes["PersonalEmail"].InnerText; lodgeList.Add(lodgeMember); } if (lodgeList.Count == 0) lodgeList.Add(new LodgeMember() { LastName = "No records found" }); } catch (Exception ex) { lodgeList.Add(new LodgeMember() { LastName = ex.Message }); } return lodgeList; }
public static string MemberAddUpdate(LodgeMember lodgeMember, string xmlFileName) { string success = "ono"; try { XmlDocument xdoc = new XmlDocument(); xdoc.Load(xmlFileName); success = LodgeDataXml.MemberAddUpdateRow(lodgeMember, xdoc); xdoc.Save(xmlFileName); } catch (Exception ex) { success = ex.Message; } return success; }
private List<LodgeMember> LoadIntoModelCollection(HttpPostedFileBase file) { //List<GrandLodgeTexasCSV> importRows = new List<GrandLodgeTexasCSV>(); List<LodgeMember> importRows = new List<LodgeMember>(); string line = String.Empty; string[] values; StreamReader sr = new StreamReader(file.InputStream); try { var firstline = sr.ReadLine(); while ((line = sr.ReadLine()) != null) { try { values = line.Split(','); //GrandLodgeTexasCSV importRow = new GrandLodgeTexasCSV(); LodgeMember lodgeMember = new LodgeMember(); lodgeMember.MemberNumber = int.Parse(values[0]); lodgeMember.LastName = values[1]; lodgeMember.FirstName = values[2]; lodgeMember.MiddleName = values[3]; lodgeMember.SuffixName = values[4]; lodgeMember.Birthdate = values[5]; lodgeMember.Joined = values[6]; lodgeMember.MemberStatus = StatustoRefCode(values[7]); lodgeMember.MemberStatusText = values[7]; lodgeMember.LastUpdated = values[8]; lodgeMember.StreetAddress = values[9] + " " + values[10]; lodgeMember.City = values[11]; lodgeMember.State = values[12]; lodgeMember.Zip = values[13]; //importRow.AddressType = values[14]; lodgeMember.HomePhone = values[15]; lodgeMember.WorkPhone = values[16]; //importRow.Fax = values[17]; lodgeMember.MobilePhone = values[18]; lodgeMember.PersonalEmail = values[19]; lodgeMember.BusinessEmail = values[20]; lodgeMember.Initiated = values[22]; lodgeMember.Passed = values[23]; lodgeMember.Raised = values[24]; //importRow.MemberOrCandidate = values[25]; importRows.Add(lodgeMember); } catch (Exception ex) { importRows.Add(new LodgeMember() { LastName = ex.Message }); } } } catch (Exception ex) { importRows.Add(new LodgeMember() { LastName = ex.Message }); } return importRows; }
public static LodgeMember GetMember(int id, string filename) { var lodgeMember = new LodgeMember(); try { XmlDocument xdoc = new XmlDocument(); xdoc.Load(filename); var memberNode = xdoc.SelectSingleNode("//Members/Member[@MasonId='" + id + "']"); string personId = memberNode.Attributes["PersonId"].InnerText; lodgeMember.MemberNumber = id; lodgeMember.Joined = memberNode.Attributes["Joined"].InnerText; lodgeMember.Initiated = memberNode.Attributes["Initiated"].InnerText; lodgeMember.Passed = memberNode.Attributes["Passed"].InnerText; lodgeMember.Raised = memberNode.Attributes["Raised"].InnerText; lodgeMember.MemberStatus = memberNode.Attributes["Status"].InnerText; lodgeMember.LodgeStatus = memberNode.Attributes["LodgeStatus"].InnerText; lodgeMember.LastUpdated = memberNode.Attributes["LastUpdated"].InnerText; lodgeMember.LastReinstated = memberNode.Attributes["LastReinstated"].InnerText; XmlNode pictureNode = memberNode.SelectSingleNode("Picture"); if (pictureNode != null) lodgeMember.Picture = pictureNode.InnerText; var personNode = xdoc.SelectSingleNode("//People/Person[@PersonId='" + personId + "']"); lodgeMember.FirstName = personNode.Attributes["FirstName"].InnerText; lodgeMember.LastName = personNode.Attributes["LastName"].InnerText; lodgeMember.NickName = personNode.Attributes["NickName"].InnerText; lodgeMember.MiddleName = personNode.Attributes["MiddleName"].InnerText; lodgeMember.FullName = lodgeMember.FirstName + (lodgeMember.MiddleName == "" ? " " : " " + lodgeMember.MiddleName + " ") + lodgeMember.LastName; lodgeMember.Birthdate = personNode.Attributes["Birthdate"].InnerText; lodgeMember.BirthLocation = personNode.Attributes["BirthLocation"].InnerText; lodgeMember.Died = personNode.Attributes["Died"].InnerText; XmlNode addressnode = personNode["Addresses"].SelectSingleNode("Address[last()]"); lodgeMember.StreetAddress = addressnode.Attributes["StreetAddress"].InnerText; lodgeMember.City = addressnode.Attributes["City"].InnerText; lodgeMember.State = addressnode.Attributes["State"].InnerText; lodgeMember.Zip = addressnode.Attributes["Zip"].InnerText; XmlNode commDevicesNode = personNode.SelectSingleNode("CommDevices"); lodgeMember.HomePhone = commDevicesNode.Attributes["HomePhone"].InnerText; lodgeMember.PersonalEmail = commDevicesNode.Attributes["PersonalEmail"].InnerText; lodgeMember.MobilePhone = commDevicesNode.Attributes["MobilePhone"].InnerText; lodgeMember.WorkPhone = commDevicesNode.Attributes["WorkPhone"].InnerText; lodgeMember.BusinessEmail = commDevicesNode.Attributes["BusinessEmail"].InnerText; } catch (Exception ex) { lodgeMember.FullName = ex.Message; } return lodgeMember; }
public static LodgeMember GetOfficer(string masonicYear, string chair, string xmlFileName) { var member = new LodgeMember(); try { XmlDocument xdoc = new XmlDocument(); xdoc.Load(xmlFileName); XmlNode OfficerNode = xdoc.SelectSingleNode("//Officers/Year[@MasonicYear='" + masonicYear + "']/" + chair); if (OfficerNode != null) { member.MemberNumber = int.Parse(OfficerNode.InnerText); string personId = xdoc.SelectSingleNode("//Members/Member[@MasonId='" + member.MemberNumber + "']").Attributes["PersonId"].InnerText; XmlNode PersonNode = xdoc.SelectSingleNode("//People/Person[@PersonId='" + personId + "']"); member.FirstName = PersonNode["FirstName"].InnerText; member.MiddleName = PersonNode["MiddleName"].InnerText; member.LastName = PersonNode["LastName"].InnerText; member.FullName = member.FirstName + (member.MiddleName == "" ? " " : " " + member.MiddleName + " ") + member.LastName; } } catch (Exception ex) { member.FullName = ex.Message; } return member; }
public static string MemberAddUpdateRow(LodgeMember lodgeMember, XmlDocument xdoc) { string success = "ok"; try { XmlNode memberNode = xdoc.SelectSingleNode("//Members//Member[@MasonId='" + lodgeMember.MemberNumber + "']"); XmlNode person = null; string[] goodCodes = { "MBA", "MBC", "MBD", "MBG", "MBH", "MBI", "MBJ", "LIF" }; if (memberNode != null) { #region update memberNode.Attributes["Initiated"].InnerText = lodgeMember.Initiated; memberNode.Attributes["Passed"].InnerText = lodgeMember.Passed; memberNode.Attributes["Raised"].InnerText = lodgeMember.Raised; memberNode.Attributes["LastReinstated"].InnerText = lodgeMember.LastReinstated; memberNode.Attributes["Joined"].InnerText = lodgeMember.Joined; memberNode.Attributes["Status"].InnerText = lodgeMember.MemberStatus; memberNode.Attributes["LodgeStatus"].InnerText = lodgeMember.LodgeStatus; memberNode.Attributes["LastUpdated"].InnerText = DateTime.Today.ToShortDateString(); var personId = memberNode.Attributes["PersonId"].InnerText; person = xdoc.SelectSingleNode("//People//Person[@PersonId='" + personId + "']"); person.Attributes["FirstName"].InnerText = lodgeMember.FirstName; person.Attributes["LastName"].InnerText = lodgeMember.LastName; person.Attributes["MiddleName"].InnerText = lodgeMember.MiddleName; person.Attributes["NickName"].InnerText = lodgeMember.NickName; person.Attributes["Birthdate"].InnerText = lodgeMember.Birthdate; person.Attributes["BirthLocation"].InnerText = lodgeMember.BirthLocation; person.Attributes["Died"].InnerText = lodgeMember.Died; XmlNode addressnode = person["Addresses"].SelectSingleNode("Address[last()]"); addressnode.Attributes["StreetAddress"].InnerText = lodgeMember.StreetAddress; addressnode.Attributes["City"].InnerText = lodgeMember.City; addressnode.Attributes["State"].InnerText = lodgeMember.State; addressnode.Attributes["Zip"].InnerText = lodgeMember.Zip; XmlNode CommDevices = person.SelectSingleNode("CommDevices"); CommDevices.Attributes["HomePhone"].InnerText = lodgeMember.HomePhone; CommDevices.Attributes["MobilePhone"].InnerText = lodgeMember.MobilePhone; CommDevices.Attributes["WorkPhone"].InnerText = lodgeMember.WorkPhone; CommDevices.Attributes["BusinessEmail"].InnerText = lodgeMember.BusinessEmail; CommDevices.Attributes["PersonalEmail"].InnerText = lodgeMember.PersonalEmail; success = "updated"; #endregion } else { string personGuid = Guid.NewGuid().ToString(); memberNode = xdoc.CreateElement("Member"); XmlAttribute CurrentStatus = xdoc.CreateAttribute("Status"); CurrentStatus.InnerText = lodgeMember.MemberStatus; memberNode.Attributes.Append(CurrentStatus); XmlAttribute LodgeStatus = xdoc.CreateAttribute("LodgeStatus"); LodgeStatus.InnerText = goodCodes.Contains(lodgeMember.MemberStatus) ? "ACT" : "INA"; memberNode.Attributes.Append(LodgeStatus); XmlAttribute MasonId = xdoc.CreateAttribute("MasonId"); MasonId.Value = lodgeMember.MemberNumber.ToString(); memberNode.Attributes.Append(MasonId); XmlAttribute PersonId2 = xdoc.CreateAttribute("PersonId"); PersonId2.Value = personGuid; memberNode.Attributes.Append(PersonId2); XmlAttribute Joined = xdoc.CreateAttribute("Joined"); Joined.InnerText = lodgeMember.Joined; memberNode.Attributes.Append(Joined); XmlAttribute Initiated = xdoc.CreateAttribute("Initiated"); Initiated.InnerText = lodgeMember.Initiated; memberNode.Attributes.Append(Initiated); XmlAttribute Passed = xdoc.CreateAttribute("Passed"); Passed.InnerText = lodgeMember.Passed; memberNode.Attributes.Append(Passed); XmlAttribute Raised = xdoc.CreateAttribute("Raised"); Raised.InnerText = lodgeMember.Raised; memberNode.Attributes.Append(Raised); XmlAttribute LastReinstated = xdoc.CreateAttribute("LastReinstated"); LastReinstated.InnerText = lodgeMember.Raised; memberNode.Attributes.Append(LastReinstated); XmlAttribute LastUpdated = xdoc.CreateAttribute("LastUpdated"); LastUpdated.InnerText = lodgeMember.LastUpdated; memberNode.Attributes.Append(LastUpdated); XmlNode MemberDetails = xdoc.CreateElement("MemberDetails"); memberNode.AppendChild(MemberDetails); XmlNode members = xdoc.SelectSingleNode("//Members"); members.AppendChild(memberNode); person = xdoc.CreateElement("Person"); XmlAttribute PersonId = xdoc.CreateAttribute("PersonId"); PersonId.Value = personGuid; person.Attributes.Append(PersonId); XmlAttribute firstName = xdoc.CreateAttribute("FirstName"); firstName.InnerText = lodgeMember.FirstName; person.Attributes.Append(firstName); XmlAttribute lastName = xdoc.CreateAttribute("LastName"); lastName.InnerText = lodgeMember.LastName; person.Attributes.Append(lastName); XmlAttribute MiddleName = xdoc.CreateAttribute("MiddleName"); MiddleName.InnerText = lodgeMember.MiddleName; person.Attributes.Append(MiddleName); XmlAttribute NickName = xdoc.CreateAttribute("NickName"); NickName.InnerText = lodgeMember.NickName; person.Attributes.Append(NickName); XmlAttribute Birthdate = xdoc.CreateAttribute("Birthdate"); Birthdate.InnerText = lodgeMember.Birthdate; person.Attributes.Append(Birthdate); XmlAttribute BirthLocation = xdoc.CreateAttribute("BirthLocation"); BirthLocation.InnerText = lodgeMember.BirthLocation; person.Attributes.Append(BirthLocation); XmlAttribute Died = xdoc.CreateAttribute("Died"); Died.InnerText = lodgeMember.Died; person.Attributes.Append(Died); XmlNode CommDevices = xdoc.CreateElement("CommDevices"); XmlAttribute HomePhone = xdoc.CreateAttribute("HomePhone"); HomePhone.InnerText = lodgeMember.HomePhone; CommDevices.Attributes.Append(HomePhone); XmlAttribute WorkPhone = xdoc.CreateAttribute("WorkPhone"); WorkPhone.InnerText = lodgeMember.WorkPhone; CommDevices.Attributes.Append(WorkPhone); XmlAttribute MobilePhone = xdoc.CreateAttribute("MobilePhone"); MobilePhone.InnerText = lodgeMember.MobilePhone; CommDevices.Attributes.Append(MobilePhone); XmlAttribute PersonalEmail = xdoc.CreateAttribute("PersonalEmail"); PersonalEmail.InnerText = lodgeMember.PersonalEmail; CommDevices.Attributes.Append(PersonalEmail); XmlAttribute BusinessEmail = xdoc.CreateAttribute("BusinessEmail"); BusinessEmail.InnerText = lodgeMember.HomePhone; CommDevices.Attributes.Append(BusinessEmail); person.AppendChild(CommDevices); XmlNode Addresses = xdoc.CreateElement("Addresses"); XmlNode Address = xdoc.CreateElement("Address"); XmlAttribute MoveIn = xdoc.CreateAttribute("MoveIn"); MoveIn.InnerText = lodgeMember.LastUpdated; Address.Attributes.Append(MoveIn); XmlAttribute StreetAddress = xdoc.CreateAttribute("StreetAddress"); StreetAddress.InnerText = lodgeMember.StreetAddress; Address.Attributes.Append(StreetAddress); XmlAttribute City = xdoc.CreateAttribute("City"); City.InnerText = lodgeMember.City; Address.Attributes.Append(City); XmlAttribute State = xdoc.CreateAttribute("State"); State.InnerText = lodgeMember.State; Address.Attributes.Append(State); XmlAttribute Zip = xdoc.CreateAttribute("Zip"); Zip.InnerText = lodgeMember.Zip; Address.Attributes.Append(Zip); Addresses.AppendChild(Address); person.AppendChild(Addresses); XmlNode people = xdoc.SelectSingleNode("//People"); people.AppendChild(person); success = "added"; } } catch (Exception ex) { success = ex.Message; } return success; }
public ActionResult xxMemberDetails(LodgeMember model) { ActionResult rtn = View(model); if (ModelState.IsValid) { try { string lodgeFileName = Server.MapPath("\\App_Data\\") + MasonMasterData.GetUserProfile(User.Identity.Name).DatabaseName; MemberDataXml.MemberAddUpdate(model, lodgeFileName); if (Request.Form["exitMode"].Length > 30) { rtn = RedirectToAction("MemberAccomplishments", new { masonId = model.MemberNumber, memberDetailId = Request.Form["exitMode"] }); } else { switch (Request.Form["exitMode"]) { case "return": if (Session["lodgeMemberList"] != null) rtn = RedirectToAction("MemberDetails", new { Id = model.MemberNumber }); break; case "continue": { if (Session["lodgeMemberList"] != null) { List<LodgeMember> ss = (List<LodgeMember>)Session["lodgeMemberList"]; var EditedMember = ss.Where(em => em.MemberNumber == model.MemberNumber).First(); EditedMember = model; } } rtn = RedirectToAction("MemberList"); break; case "details": rtn = RedirectToAction("MemberAccomplishments", new { masonId = model.MemberNumber }); break; case "addressess": rtn = RedirectToAction("Address", "Person", new { id = model.MemberNumber }); break; case "employment": rtn = RedirectToAction("Employment", "Person", new { id = model.MemberNumber }); break; case "family": rtn = RedirectToAction("Geneology", "Person", new { id = model.MemberNumber }); break; default: break; } } } catch (Exception e) { ModelState.AddModelError("", e.Message); } } return rtn; }
public static List<LodgeMember> GetActiveMasons(string xmlFileName) { var lodgeList = new List<LodgeMember>(); try { XmlDocument xDoc = new XmlDocument(); xDoc.Load(xmlFileName); XmlNodeList members = xDoc.SelectNodes("//Members/Member[@LodgeStatus='ACT']"); foreach (XmlNode memberNode in members) { var lodgeMember = new LodgeMember(); lodgeMember.MemberNumber = int.Parse(memberNode.Attributes["MasonId"].InnerText); lodgeMember.MemberStatusText = xDoc.SelectSingleNode("//Refs/refItem[@refCode='" + memberNode.Attributes["Status"].InnerText + "']").Attributes["refDescription"].InnerText; lodgeMember.MemberStatus = memberNode.Attributes["Status"].InnerText; lodgeMember.Raised = memberNode.Attributes["Raised"].InnerText; string personId = memberNode.Attributes["PersonId"].Value; XmlNode personNode = xDoc.SelectSingleNode("//People//Person[@PersonId='" + personId + "']"); lodgeMember.FirstName = personNode.Attributes["FirstName"].InnerText; lodgeMember.MiddleName = personNode.Attributes["MiddleName"].InnerText; lodgeMember.LastName = personNode.Attributes["LastName"].InnerText; lodgeMember.FullName = lodgeMember.FirstName + (lodgeMember.MiddleName == "" ? " " : " " + lodgeMember.MiddleName + " ") + lodgeMember.LastName; lodgeList.Add(lodgeMember); } if (lodgeList.Count == 0) lodgeList.Add(new LodgeMember() { FullName = "No records found" }); } catch (Exception ex) { lodgeList.Add(new LodgeMember() { FullName = ex.Message }); } return lodgeList; }
public string MemberSave(LodgeMember lodgeMember) { string success = "ono"; string lodgeFileName = Server.MapPath("\\App_Data\\") + MasonMasterData.GetUserProfile(User.Identity.Name).DatabaseName; success = MemberDataXml.MemberAddUpdate(lodgeMember, lodgeFileName); Session["lodgeMemberList"] = null; return success; }
public static List<LodgeMember> GetFiftyYearExempt(string xmlFileName) { var memberList = new List<LodgeMember>(); try { DateTime today = DateTime.Today; XmlDocument xDoc = new XmlDocument(); xDoc.Load(xmlFileName); XmlNodeList members = xDoc.SelectNodes("//Members/Member"); string currentStatus = ""; //XmlNode fiftyYearNode; DateTime raised; TimeSpan t1; string[] desiredStatuses = new[] { "MBA", "MBC", "MBD", "MBG", "MBH", "MBI", "MBE", "MBJ", "LIF" }; //{ "Active", "Endowed Member", "Elected", "Life Member", "Entered Apprentice", "Fellowcraft", "Life & Endowed Mbr", "Petition Read" }; foreach (XmlNode memberNode in members) { currentStatus = memberNode.Attributes["Status"].InnerText; if (desiredStatuses.Contains(memberNode.Attributes["Status"].InnerText)) { DateTime.TryParse(memberNode["Raised"].InnerText, out raised); if (raised != DateTime.MinValue) { t1 = today - raised; var totalyears = t1.TotalDays / 365.2425; if (totalyears >= 50) { //XmlNodeList MemberDetials = memberNode.SelectNodes("MemberDetails"); //foreach (XmlNode MemberDetail in MemberDetials) //{ //fiftyYearNode = MemberDetail.SelectSingleNode("MemberDetail[@Type='FIF']"); //if (fiftyYearNode != null) //{ var lodgeMember = new LodgeMember(); //lodgeMember.MemberStatus = memberNode.SelectSingleNode("CurrentStatus").InnerText; lodgeMember.LodgeStatus = memberNode.SelectSingleNode("LodgeStatus").InnerText; lodgeMember.MemberNumber = int.Parse(memberNode.Attributes["MasonId"].InnerText); lodgeMember.Raised = memberNode.SelectSingleNode("Raised").InnerText; lodgeMember.MemberStatusText = xDoc.SelectSingleNode("//Refs/refItem[@refCode='" + memberNode["CurrentStatus"].InnerText + "']").Attributes["refDescription"].InnerText; string personId = memberNode.Attributes["PersonId"].Value; XmlNode personNode = xDoc.SelectSingleNode("//People//Person[@PersonId='" + personId + "']"); lodgeMember.FirstName = personNode.Attributes["FirstName"].InnerText; lodgeMember.MiddleName = personNode.Attributes["MiddleName"].InnerText; lodgeMember.LastName = personNode.Attributes["LastName"].InnerText; lodgeMember.FullName = lodgeMember.FirstName + (lodgeMember.MiddleName == "" ? " " : " " + lodgeMember.MiddleName + " ") + lodgeMember.LastName; lodgeMember.Birthdate = personNode.Attributes["Birthdate"].InnerText; memberList.Add(lodgeMember); } } } } if (memberList.Count == 0) memberList.Add(new LodgeMember() { FullName = "No records found" }); } catch (Exception ex) { memberList.Add(new LodgeMember() { FullName = ex.Message }); } return memberList; }
public static List<LodgeMember> GetOfficersList(string masonicYear, string xmlFileName) { var memberList = new List<LodgeMember>(); try { XmlDocument xDoc = new XmlDocument(); xDoc.Load(xmlFileName); XmlNode officersNode = xDoc.SelectSingleNode("//Officers/Year[@MasonicYear='" + masonicYear + "']"); if (officersNode != null) { XmlNode memberNode; foreach (XmlNode officerNode in officersNode) { var lodgeMember = new LodgeMember(); lodgeMember.Birthdate = xDoc.SelectSingleNode("//Refs/refItem[@refCode='" + officerNode.Name + "']").Attributes["refDescription"].InnerText; memberNode = xDoc.SelectSingleNode("//Members/Member[@MasonId='" + officerNode.Attributes["MasonId"].InnerText + "']"); lodgeMember.MemberStatusText = xDoc.SelectSingleNode("//Refs/refItem[@refCode='" + memberNode.Attributes["Status"].InnerText + "']").Attributes["refDescription"].InnerText; lodgeMember.MemberNumber = int.Parse(officerNode.Attributes["MasonId"].InnerText); string personId = memberNode.Attributes["PersonId"].Value; XmlNode personNode = xDoc.SelectSingleNode("//People//Person[@PersonId='" + personId + "']"); lodgeMember.FirstName = personNode.Attributes["FirstName"].InnerText; lodgeMember.MiddleName = personNode.Attributes["MiddleName"].InnerText; lodgeMember.LastName = personNode.Attributes["LastName"].InnerText; lodgeMember.FullName = lodgeMember.FirstName + (lodgeMember.MiddleName == "" ? " " : " " + lodgeMember.MiddleName + " ") + lodgeMember.LastName; memberList.Add(lodgeMember); } } if (memberList.Count == 0) memberList.Add(new LodgeMember() { FullName = "No records found" }); } catch (Exception ex) { memberList.Add(new LodgeMember() { FullName = ex.Message }); } return memberList; }
public static List<LodgeMember> GetMemberList(string xmlFileName) { var lodgeList = new List<LodgeMember>(); try { XmlDocument xDoc = new XmlDocument(); xDoc.Load(xmlFileName); XmlNodeList members = xDoc.SelectNodes("//Members/Member"); string currentStatus = ""; string[] desiredStatuses = new[] { "MBA", "MBC", "MBD", "MBG", "MBH", "MBI", "MBE", "MBJ", "LIF" }; //{ "Active", "Endowed Member", "Elected", "Life Member", "Entered Apprentice", "Fellowcraft", "Life & Endowed Mbr", "Petition Read" }; foreach (XmlNode memberNode in members) { currentStatus = memberNode.Attributes["Status"].InnerText; if (desiredStatuses.Contains(currentStatus)) { var lodgeMember = new LodgeMember(); //lodgeMember.MemberStatus = memberNode.SelectSingleNode("CurrentStatus").InnerText; lodgeMember.MemberNumber = int.Parse(memberNode.Attributes["MasonId"].InnerText); lodgeMember.Raised = memberNode.Attributes["Raised"].InnerText; lodgeMember.MemberStatusText = xDoc.SelectSingleNode("//Refs/refItem[@refCode='" + memberNode.Attributes["Status"].InnerText + "']").Attributes["refDescription"].InnerText; string personId = memberNode.Attributes["PersonId"].Value; XmlNode personNode = xDoc.SelectSingleNode("//People//Person[@PersonId='" + personId + "']"); lodgeMember.FirstName = personNode.Attributes["FirstName"].InnerText; lodgeMember.MiddleName = personNode.Attributes["MiddleName"].InnerText; lodgeMember.LastName = personNode.Attributes["LastName"].InnerText; lodgeMember.FullName = lodgeMember.FirstName + (lodgeMember.MiddleName == "" ? " " : " " + lodgeMember.MiddleName + " ") + lodgeMember.LastName; lodgeMember.Birthdate = personNode.Attributes["Birthdate"].InnerText; XmlNode addressnode = personNode["Addresses"].SelectSingleNode("Address[last()]"); lodgeMember.StreetAddress = addressnode.Attributes["StreetAddress"].InnerText; lodgeMember.City = addressnode.Attributes["City"].InnerText; lodgeMember.State = addressnode.Attributes["State"].InnerText; lodgeMember.Zip = addressnode.Attributes["Zip"].InnerText; lodgeMember.HomePhone = personNode["CommDevices"].Attributes["HomePhone"].InnerText; lodgeMember.MobilePhone = personNode["CommDevices"].Attributes["MobilePhone"].InnerText; lodgeMember.WorkPhone = personNode["CommDevices"].Attributes["WorkPhone"].InnerText; lodgeMember.BusinessEmail = personNode["CommDevices"].Attributes["BusinessEmail"].InnerText; lodgeMember.PersonalEmail = personNode["CommDevices"].Attributes["PersonalEmail"].InnerText; lodgeList.Add(lodgeMember); } } if (lodgeList.Count == 0) lodgeList.Add(new LodgeMember() { FullName = "No records found" }); } catch (Exception ex) { lodgeList.Add(new LodgeMember() { FullName = ex.Message }); } return lodgeList; }
public static List<LodgeMember> GetDateByMonth(string sortDate, string xmlFileName) { var lodgeList = new List<LodgeMember>(); try { XmlDocument xDoc = new XmlDocument(); xDoc.Load(xmlFileName); XmlNodeList members = xDoc.SelectNodes("//Members/Member"); string currentStatus = ""; string[] desiredStatuses = new[] { "MBA", "MBC", "MBD", "MBG", "MBH", "MBI", "MBE", "MBJ", "LIF" }; //{ "Active", "Endowed Member", "Elected", "Life Member", "Entered Apprentice", "Fellowcraft", "Life & Endowed Mbr", "Petition Read" }; DateTime raised; foreach (XmlNode memberNode in members) { currentStatus = memberNode.Attributes["Status"].InnerText; if (desiredStatuses.Contains(currentStatus)) { var lodgeMember = new LodgeMember(); //lodgeMember.MemberStatus = memberNode.SelectSingleNode("CurrentStatus").InnerText; lodgeMember.MemberNumber = int.Parse(memberNode.Attributes["MasonId"].InnerText); lodgeMember.Raised = memberNode.Attributes["Raised"].InnerText; lodgeMember.MemberStatusText = xDoc.SelectSingleNode("//Refs/refItem[@refCode='" + memberNode.Attributes["Status"].InnerText + "']").Attributes["refDescription"].InnerText; string personId = memberNode.Attributes["PersonId"].Value; XmlNode personNode = xDoc.SelectSingleNode("//People//Person[@PersonId='" + personId + "']"); lodgeMember.FirstName = personNode.Attributes["FirstName"].InnerText; lodgeMember.MiddleName = personNode.Attributes["MiddleName"].InnerText; lodgeMember.LastName = personNode.Attributes["LastName"].InnerText; lodgeMember.FullName = lodgeMember.FirstName + (lodgeMember.MiddleName == "" ? " " : " " + lodgeMember.MiddleName + " ") + lodgeMember.LastName; lodgeMember.Birthdate = personNode.Attributes["Birthdate"].InnerText; try { if (sortDate == "Birthday") lodgeMember.SortMonth = (Convert.ToDateTime(lodgeMember.Birthdate)).Month; else { DateTime.TryParse(memberNode.Attributes["Raised"].InnerText, out raised); if (raised != DateTime.MinValue) lodgeMember.SortMonth = (Convert.ToDateTime(lodgeMember.Raised)).Month; else lodgeMember.SortMonth = 99; } } catch (FormatException) { lodgeMember.SortMonth = 99; } catch (Exception ex) { lodgeMember.FirstName = ex.Message; } lodgeList.Add(lodgeMember); } } if (lodgeList.Count == 0) lodgeList.Add(new LodgeMember() { FullName = "No records found" }); } catch (Exception ex) { lodgeList.Add(new LodgeMember() { FullName = ex.Message }); } return lodgeList; }