コード例 #1
0
ファイル: WebGrids.cs プロジェクト: dmooring52/MySource
        public string EventData(string eventkey, string column, DateTime data)
        {
            MVCEvents target          = null;
            MVCEvents targetreference = null;

            foreach (MVCEvents q in events)
            {
                if (q.EventKey == eventkey)
                {
                    target = q;
                    break;
                }
            }
            foreach (MVCEvents q in eventsref)
            {
                if (q.EventKey == eventkey)
                {
                    targetreference = q;
                    break;
                }
            }
            if (target != null)
            {
                return(util.datestyle(target.EventDate, (targetreference == null) ? DateTime.MinValue : targetreference.EventDate));
            }
            else
            {
                return(string.Format("<text>{0}</text>", data));
            }
        }
コード例 #2
0
ファイル: WebGrids.cs プロジェクト: dmooring52/MySource
        public string Save()
        {
            string            result         = "";
            int               recordschanged = 0;
            SingingClubClient client         = new SingingClubClient();

            client.Open();
            if (events != null && eventsref != null)
            {
                List <MVCEvents> tobeadded = new List <MVCEvents>();
                foreach (MVCEvents q in events)
                {
                    bool found = false;
                    foreach (MVCEvents qref in eventsref)
                    {
                        if (q.KeyEquals(qref) == true)
                        {
                            found = true;
                            if (MVCEvents.FieldsEqual(q, qref) == false)
                            {
                                result = client.GeneralStore("TSCEvents", "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 (MVCEvents tba in tobeadded)
                    {
                        result = client.GeneralStore("TSCEvents", "INSERT", tba.GetDataXml());
                        if (result != null && Utility.IsNumber(result) && int.Parse(result) > 0)
                        {
                            recordschanged++;
                        }
                    }
                }
            }
            client.Close();
            return(recordschanged.ToString());
        }
コード例 #3
0
ファイル: WebGrids.cs プロジェクト: dmooring52/MySource
        public string EventData(string eventkey, string column, string data)
        {
            MVCEvents target          = null;
            MVCEvents targetreference = null;

            foreach (MVCEvents q in events)
            {
                if (q.EventKey == eventkey)
                {
                    target = q;
                    break;
                }
            }
            foreach (MVCEvents q in eventsref)
            {
                if (q.EventKey == eventkey)
                {
                    targetreference = q;
                    break;
                }
            }
            if (target != null)
            {
                switch (column)
                {
                case "EventName":
                    return(util.textstyle(target.EventName, (targetreference == null) ? null : targetreference.EventName));

                case "EventDate":
                    return(util.datestyle(target.EventDate, (targetreference == null) ? DateTime.MinValue : targetreference.EventDate));

                case "EventAddress":
                    return(util.textstyle(target.EventAddress, (targetreference == null) ? null : targetreference.EventAddress));

                case "EventEmail":
                    return(util.textstyle(target.EventEmail, (targetreference == null) ? null : targetreference.EventEmail));

                default:
                    return(string.Format("<text>{0}</text>", data));
                }
            }
            else
            {
                return(string.Format("<text>{0}</text>", data));
            }
        }
コード例 #4
0
        public ActionResult PageEditEvent(string VenueKey, string EventKey)
        {
            MVCEvents tscevent = null;

            if (VenueKey != null && EventKey != null && VenueKey.Trim().Length > 0 && EventKey.Trim().Length > 0)
            {
                EventData eventData = new EventData(VenueKey, EventKey, SessionBag.Current.EventsXml as XmlDocument);
                tscevent = eventData.GetEvent();
            }
            else
            {
                tscevent = new MVCEvents();
                XmlDocument vdoc = SessionBag.Current.VenuesXml as XmlDocument;
                if (vdoc != null)
                {
                    XmlNodeList nodes = vdoc.SelectNodes("Root/Data/VenueKey");
                    if (nodes != null)
                    {
                        foreach (XmlNode node in nodes)
                        {
                            string venue = node.InnerText;
                            if (venue != null && venue == "IAG")
                            {
                                tscevent.VenueList.Add(venue);
                                break;
                            }
                        }
                        foreach (XmlNode node in nodes)
                        {
                            string venue = node.InnerText;
                            if (venue != null && venue.Trim().Length > 0 && venue != "IAG")
                            {
                                tscevent.VenueList.Add(venue);
                            }
                        }
                    }
                }
            }
            return(View(tscevent));
        }
コード例 #5
0
        public ActionResult PageSetEvent(MVCEvents model)
        {
            string venuekey = Request.Form["VenueList"];

            if (venuekey == null || venuekey.Trim().Length == 0)
            {
                venuekey = Request.Form["VenueKey"];
            }
            string eventkey     = Request.Form["EventKey"];
            string eventname    = Request.Form["EventName"];
            string eventdate    = Request.Form["EventDate"];
            string eventaddress = Request.Form["EventAddress"];
            string eventemail   = Request.Form["EventEmail"];

            string command = Request.Form["command"];

            if (command == null)
            {
                command = "";
            }
            else
            {
                command = command.Trim().ToLower();
            }
            if (command == "remove" && venuekey != null && venuekey.Trim().Length > 0 && eventkey != null && eventkey.Trim().Length > 0)
            {
                MVCEvents theevent = new MVCEvents();
                theevent.VenueKey = venuekey;
                theevent.EventKey = eventkey;
                SingingClubClient client = new SingingClubClient();
                client.Open();
                string result = client.GeneralStore("TSCEvents", "DELETE", theevent.GetDataXml());
                if (result != null && Utility.IsNumber(result) && int.Parse(result) > 0)
                {
                    string _EventsXml = client.GeneralStore("TSCEvents", "GET", (new MVCEvents()).GetDataXml());
                    client.Close();
                    XmlDocument EventsXml          = new XmlDocument();
                    XmlDocument EventsXmlReference = new XmlDocument();

                    EventsXml.LoadXml(_EventsXml);
                    EventsXmlReference.LoadXml(_EventsXml);

                    SessionBag.Current.EventsXml          = EventsXml;
                    SessionBag.Current.EventsXmlReference = EventsXmlReference;
                }
            }

            EventsGrid events = new EventsGrid();

            if (SessionBag.Current.EventsXml != null && SessionBag.Current.EventsXml is XmlDocument &&
                SessionBag.Current.EventsXmlReference != null && SessionBag.Current.EventsXmlReference is XmlDocument &&
                venuekey != null && eventkey != null && venuekey.Trim().Length > 0 && eventkey.Trim().Length > 0)
            {
                XmlDocument doc    = SessionBag.Current.EventsXml as XmlDocument;
                XmlDocument docref = SessionBag.Current.EventsXmlReference as XmlDocument;
                XmlNodeList nodes  = doc.SelectNodes("/Root/Data");
                bool        found  = false;
                foreach (XmlNode node in nodes)
                {
                    MVCEvents add = new MVCEvents(node);
                    if (add.VenueKey == venuekey && add.EventKey == eventkey)
                    {
                        SetText(node, "EventName", eventname);
                        SetDate(node, "EventDate", eventdate);
                        SetText(node, "EventAddress", eventaddress);
                        SetText(node, "EventEmail", eventemail);
                        add   = new MVCEvents(node);
                        found = true;
                    }
                    events.events.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, "EventKey", eventkey);
                            SetText(data, "EventName", eventname);
                            SetDate(data, "EventDate", eventdate);
                            SetText(data, "EventAddress", eventaddress);
                            SetText(data, "EventEmail", eventemail);
                            MVCEvents add = new MVCEvents(data);
                            events.events.Add(add);
                        }
                    }
                }
                nodes = docref.SelectNodes("/Root/Data");
                foreach (XmlNode node in nodes)
                {
                    events.eventsref.Add(new MVCEvents(node));
                }
                events.events.Sort();
                events.events.Reverse();
                events.Bind();
                ViewData.Model = events;
            }

            return(View());
        }