public static List<Accomplishment> GetAccomplishments(int masonId, string xmlFileName) { var memberAccomplishments = new List<Accomplishment>(); try { XmlDocument xDoc = new XmlDocument(); Accomplishment accomplishment; xDoc.Load(xmlFileName); XmlNodeList accomplishmentNodes = xDoc.SelectNodes("//Members/Member[@MasonId='" + masonId + "']/MemberDetails/MemberDetail"); if (accomplishmentNodes != null) { foreach (XmlNode accomplishmentNode in accomplishmentNodes) { accomplishment = new Accomplishment(); accomplishment.MasonId = masonId; accomplishment.AccomplishmentId = accomplishmentNode.Attributes["Id"].InnerText; accomplishment.AccomplishmentType = xDoc.SelectSingleNode("//Refs/refItem[@refCode='" + accomplishmentNode.Attributes["Type"].InnerText + "']").Attributes["refDescription"].InnerText; accomplishment.StartDate = accomplishmentNode.Attributes["StartDate"].InnerText; if (accomplishmentNode.Attributes["EndDate"] != null) accomplishment.EndDate = accomplishmentNode.Attributes["EndDate"].Value; if (accomplishmentNode.SelectSingleNode("ShortTitle") != null) accomplishment.ShortTitle = accomplishmentNode["ShortTitle"].InnerText; if (accomplishmentNode.SelectSingleNode("Location") != null) accomplishment.Location = accomplishmentNode["Location"].InnerText; if (accomplishmentNode.SelectSingleNode("Comments") != null) accomplishment.Comments = accomplishmentNode["Comments"].InnerText; memberAccomplishments.Add(accomplishment); } } } catch (Exception ex) { memberAccomplishments.Add(new Accomplishment { Comments = ex.Message }); } return memberAccomplishments; }
public static string xxMemberDetailAddUpdate(Accomplishment model, string connString) { string success = "ono"; try { using (var connection = new System.Data.SqlClient.SqlConnection(connString)) { connection.Open(); using (var command = connection.CreateCommand()) { command.CommandText = "lodge.MemberDetailAddUpdate"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@MemberDetailId", model.AccomplishmentId); command.Parameters.AddWithValue("@MasonId", model.MasonId); command.Parameters.AddWithValue("@MemberDetailTypeRef", model.AccomplishmentType); command.Parameters.AddWithValue("@ShortTitle", model.ShortTitle); command.Parameters.AddWithValue("@Location", model.Location); command.Parameters.AddWithValue("@StartDate", model.StartDate); command.Parameters.AddWithValue("@EndDate", model.EndDate); command.Parameters.AddWithValue("@Comments", model.Comments); command.ExecuteNonQuery(); } } } catch (Exception ex) { success = ex.Message; } return success; }
public static Accomplishment GetAccomplishment(int masonId, string memberDetailId, string xmlFileName) { var accomplishment = new Accomplishment(); accomplishment.MasonId = masonId; try { XmlDocument xDoc = new XmlDocument(); xDoc.Load(xmlFileName); XmlNode accomplishmentNode = xDoc.SelectSingleNode("//Members/Member[@MasonId='" + masonId + "']/MemberDetails/MemberDetail[@Id='" + memberDetailId + "']"); if (accomplishmentNode != null) { accomplishment.AccomplishmentId = accomplishmentNode.Attributes["Id"].InnerText; accomplishment.AccomplishmentType = accomplishmentNode.Attributes["Type"].InnerText; accomplishment.StartDate = accomplishmentNode.Attributes["StartDate"].InnerText; if (accomplishmentNode.Attributes["EndDate"] != null) accomplishment.EndDate = accomplishmentNode.Attributes["EndDate"].Value; if (accomplishmentNode.SelectSingleNode("ShortTitle") != null) accomplishment.ShortTitle = accomplishmentNode["ShortTitle"].InnerText; if (accomplishmentNode.SelectSingleNode("Location") != null) accomplishment.Location = accomplishmentNode["Location"].InnerText; if (accomplishmentNode.SelectSingleNode("Comments") != null) accomplishment.Comments = accomplishmentNode["Comments"].InnerText; } } catch (Exception ex) { accomplishment.Comments = ex.Message; } return accomplishment; }
public static string AccomplishmentAddUpdate(Accomplishment memberDetail, string xmlFileName) { string success = "ono"; try { XmlDocument xDoc = new XmlDocument(); xDoc.Load(xmlFileName); XmlNode memberDetailNode = xDoc.SelectSingleNode("//Members/Member[@MasonId='" + memberDetail.MasonId + "']/MemberDetails/MemberDetail[@Id='" + memberDetail.AccomplishmentId + "']"); if (memberDetailNode == null) { XmlNode memberDetailsNode = xDoc.SelectSingleNode("//Members/Member[@MasonId='" + memberDetail.MasonId + "']/MemberDetails"); if (memberDetailsNode == null) { XmlNode memberNode = xDoc.SelectSingleNode("//Members/Member[@MasonId='" + memberDetail.MasonId + "']"); memberDetailsNode = xDoc.CreateElement("MemberDetails"); memberNode.AppendChild(memberDetailsNode); } memberDetailNode = xDoc.CreateElement("MemberDetail"); XmlAttribute Id = xDoc.CreateAttribute("Id"); Id.InnerText = Guid.NewGuid().ToString(); memberDetailNode.Attributes.Append(Id); XmlAttribute TypeId = xDoc.CreateAttribute("Type"); TypeId.InnerText = memberDetail.AccomplishmentType; memberDetailNode.Attributes.Append(TypeId); XmlAttribute StartDate = xDoc.CreateAttribute("StartDate"); StartDate.InnerText = memberDetail.StartDate; memberDetailNode.Attributes.Append(StartDate); if (memberDetail.EndDate != null) { XmlAttribute EndDate = xDoc.CreateAttribute("EndDate"); EndDate.InnerText = memberDetail.EndDate; memberDetailNode.Attributes.Append(EndDate); } if (memberDetail.ShortTitle != null) { XmlNode ShortTitle = xDoc.CreateElement("ShortTitle"); ShortTitle.InnerText = memberDetail.ShortTitle; memberDetailNode.AppendChild(ShortTitle); } if (memberDetail.Location != null) { XmlNode Location = xDoc.CreateElement("Location"); Location.InnerText = memberDetail.Location; memberDetailNode.AppendChild(Location); } if (memberDetail.Comments != null) { XmlNode Comments = xDoc.CreateElement("Comments"); Comments.InnerText = memberDetail.Comments; memberDetailNode.AppendChild(Comments); } memberDetailsNode.AppendChild(memberDetailNode); } else { memberDetailNode.Attributes["Type"].InnerText = memberDetail.AccomplishmentType; memberDetailNode.Attributes["StartDate"].InnerText = memberDetail.StartDate; if (memberDetail.EndDate != null) { if (memberDetailNode.Attributes["EndDate"] == null) { XmlAttribute EndDate = xDoc.CreateAttribute("EndDate"); memberDetailNode.Attributes.Append(EndDate); } memberDetailNode.Attributes["EndDate"].InnerText = memberDetail.EndDate; } if (memberDetail.ShortTitle != null) { if (memberDetailNode.SelectSingleNode("ShortTitle") == null) { XmlNode ShortTitle = xDoc.CreateElement("ShortTitle"); memberDetailNode.AppendChild(ShortTitle); } memberDetailNode["ShortTitle"].InnerText = memberDetail.ShortTitle; } if (memberDetail.Location != null) { if (memberDetailNode.SelectSingleNode("Location") == null) { XmlNode Location = xDoc.CreateElement("Location"); memberDetailNode.AppendChild(Location); } memberDetailNode["Location"].InnerText = memberDetail.Location; } if (memberDetail.Comments != null) { if (memberDetailNode.SelectSingleNode("Comments") == null) { XmlNode Comments = xDoc.CreateElement("Comments"); memberDetailNode.AppendChild(Comments); } memberDetailNode["Comments"].InnerText = memberDetail.Comments; } } xDoc.Save(xmlFileName); success = "ok"; } catch (Exception ex) { success = ex.Message; } return success; }
public string SaveAccomplishment(Accomplishment accomplishment) { string lodgeFileName = Server.MapPath("\\App_Data\\") + MasonMasterData.GetUserProfile(User.Identity.Name).DatabaseName; return MemberDataXml.AccomplishmentAddUpdate(accomplishment, lodgeFileName); }
public ActionResult AccomplishmentEdit(int Id, string DetailId) { var Model = new Accomplishment() { MasonId = Id, AccomplishmentId = DetailId }; return View("MemberAccomplishments", Model); }
public ActionResult MemberAccomplishments(int Id) { var lodgeFileName = Server.MapPath("\\App_Data\\") + MasonMasterData.GetUserProfile(User.Identity.Name).DatabaseName; var model = new Accomplishment(); model.FullName = MemberDataXml.GetMember(Id, lodgeFileName).FullName; model.MasonId = Id; return View(model); }