public string VenueData(string venuekey, string column, DateTime data) { MVCVenues target = null; MVCVenues targetreference = null; foreach (MVCVenues q in venues) { if (q.VenueKey == venuekey) { target = q; break; } } foreach (MVCVenues q in venuesref) { if (q.VenueKey == venuekey) { targetreference = q; break; } } //if (target != null) //{ // return datestyle(target.EventDate, (targetreference == null) ? DateTime.MinValue : targetreference.EventDate); //} //else return(string.Format("<text>{0}</text>", data)); }
public string VenueData(string venuekey, string column, string data) { MVCVenues target = null; MVCVenues targetreference = null; foreach (MVCVenues q in venues) { if (q.VenueKey == venuekey) { target = q; break; } } foreach (MVCVenues q in venuesref) { if (q.VenueKey == venuekey) { targetreference = q; break; } } if (target != null) { switch (column) { case "VenueName": return(util.textstyle(target.VenueName, (targetreference == null) ? null : targetreference.VenueName)); case "VenueEmail": return(util.textstyle(target.VenueEmail, (targetreference == null) ? null : targetreference.VenueEmail)); case "VenueAddress": return(util.textstyle(target.VenueAddress, (targetreference == null) ? null : targetreference.VenueAddress)); case "VenueContact": return(util.textstyle(target.VenueContact, (targetreference == null) ? null : targetreference.VenueContact)); case "VenuePhone": return(util.textstyle(target.VenuePhone, (targetreference == null) ? null : targetreference.VenuePhone)); default: return(string.Format("<text>{0}</text>", data)); } } else { return(string.Format("<text>{0}</text>", data)); } }
public string Save() { string result = ""; int recordschanged = 0; SingingClubClient client = new SingingClubClient(); client.Open(); if (venues != null && venuesref != null) { List <MVCVenues> tobeadded = new List <MVCVenues>(); foreach (MVCVenues q in venues) { bool found = false; foreach (MVCVenues qref in venuesref) { if (q.KeyEquals(qref) == true) { found = true; if (MVCVenues.FieldsEqual(q, qref) == false) { result = client.GeneralStore("TSCVenues", "UPDATE", q.GetDataXml()); if (result != null && Utility.IsNumber(result) && int.Parse(result) > 0) { recordschanged++; } } } } if (found == false) { tobeadded.Add(q); } } if (tobeadded.Count > 0) { foreach (MVCVenues tba in tobeadded) { result = client.GeneralStore("TSCVenues", "INSERT", tba.GetDataXml()); if (result != null && Utility.IsNumber(result) && int.Parse(result) > 0) { recordschanged++; } } } } client.Close(); return(recordschanged.ToString()); }
public ActionResult PageEditVenue(string VenueKey, string Command = "") { MVCVenues tscvenue = null; if (VenueKey != null && VenueKey.Trim().Length > 0) { VenueData venueData = new VenueData(Command, VenueKey, SessionBag.Current.VenuesXml as XmlDocument); tscvenue = venueData.GetVenue(); } else { tscvenue = new MVCVenues(); tscvenue.command = Command; } return(View(tscvenue)); }
public ActionResult PageSetVenue(MVCVenues model) { string venuekey = Request.Form["VenueKey"]; string venuename = Request.Form["VenueName"]; string venueemail = Request.Form["VenueEmail"]; string venueaddress = Request.Form["VenueAddress"]; string venuecontact = Request.Form["VenueContact"]; string venuephone = Request.Form["VenuePhone"]; string command = Request.Form["command"]; if (command == null) { command = ""; } else { command = command.Trim().ToLower(); } if (command == "remove" && venuekey != null && venuekey.Trim().Length > 0) { MVCVenues venue = new MVCVenues(); venue.VenueKey = venuekey; SingingClubClient client = new SingingClubClient(); client.Open(); string result = client.GeneralStore("TSCVenues", "DELETE", venue.GetDataXml()); if (result != null && Utility.IsNumber(result) && int.Parse(result) > 0) { string _VenuesXml = client.GeneralStore("TSCVenues", "GET", (new MVCVenues()).GetDataXml()); client.Close(); XmlDocument VenuesXml = new XmlDocument(); XmlDocument VenuesXmlReference = new XmlDocument(); VenuesXml.LoadXml(_VenuesXml); VenuesXmlReference.LoadXml(_VenuesXml); SessionBag.Current.VenuesXml = VenuesXml; SessionBag.Current.VenuesXmlReference = VenuesXmlReference; } } VenuesGrid venues = new VenuesGrid(); if (SessionBag.Current.VenuesXml != null && SessionBag.Current.VenuesXml is XmlDocument && SessionBag.Current.VenuesXmlReference != null && SessionBag.Current.VenuesXmlReference is XmlDocument && venuekey != null && venuekey.Trim().Length > 0) { XmlDocument doc = SessionBag.Current.VenuesXml as XmlDocument; XmlDocument docref = SessionBag.Current.VenuesXmlReference as XmlDocument; XmlNodeList nodes = doc.SelectNodes("/Root/Data"); bool found = false; foreach (XmlNode node in nodes) { MVCVenues add = new MVCVenues(node); if (add.VenueKey == venuekey) { SetText(node, "VenueName", venuename); SetText(node, "VenueEmail", venueemail); SetText(node, "VenueAddress", venueaddress); SetText(node, "VenueContact", venuecontact); SetText(node, "VenuePhone", venuephone); add = new MVCVenues(node); found = true; } venues.venues.Add(add); } if (found == false && command != "remove") { XmlNode root = doc.SelectSingleNode("/Root"); if (root != null) { XmlNode data = doc.CreateNode(XmlNodeType.Element, "Data", null); if (data != null) { root.AppendChild(data); SetText(data, "VenueKey", venuekey); SetText(data, "VenueName", venuename); SetText(data, "VenueEmail", venueemail); SetText(data, "VenueAddress", venueaddress); SetText(data, "VenueContact", venuecontact); SetText(data, "VenuePhone", venuephone); MVCVenues add = new MVCVenues(data); venues.venues.Add(add); } } } nodes = docref.SelectNodes("/Root/Data"); foreach (XmlNode node in nodes) { venues.venuesref.Add(new MVCVenues(node)); } //venues.venues.Sort(); venues.Bind(); ViewData.Model = venues; } return(View()); }