public static void Create(Event m_Event) { SqlConnection conn = DB.DbConnect(); conn.Open(); string queryString; queryString = "INSERT INTO CMS_Events(contentGroup, eventTitle, eventStartDate, eventEndDate, branch, body, pageWorkFlowState, lockedBy, lastModifiedBy, lastModifiedDate, featuredEvent) VALUES(@contentGroup, @eventTitle, @eventStartDate, @eventEndDate, @branch, @body, 1, @lockedBy, @lastModifiedBy, @lastModifiedDate, @featuredEvent)"; SqlCommand createEvent = new SqlCommand(queryString, conn); string myStartTime = string.Empty; string myEndTime = string.Empty; if (m_Event.EventStartHour != -1 && m_Event.EventStartMin != -1 && m_Event.AmpmStart != "-1") { myStartTime = " " + m_Event.EventStartHour.ToString() + ":" + m_Event.EventStartMin.ToString() + " " + m_Event.AmpmStart; } if (m_Event.EventEndHour != -1 && m_Event.EventEndMin != -1 && m_Event.AmpmEnd != "-1") { myEndTime = " " + m_Event.EventEndHour.ToString() + ":" + m_Event.EventEndMin.ToString() + " " + m_Event.AmpmEnd; } createEvent.Parameters.AddWithValue("contentGroup", m_Event.ContentGroup); createEvent.Parameters.AddWithValue("eventTitle", m_Event.EventTitle); createEvent.Parameters.AddWithValue("eventStartDate", DateTime.Parse(m_Event.EventStartDate.ToString("MM/dd/yyyy") + myStartTime)); createEvent.Parameters.AddWithValue("eventEndDate", DateTime.Parse(m_Event.EventEndDate.ToString("MM/dd/yyyy") + myEndTime)); createEvent.Parameters.AddWithValue("branch", m_Event.Branch); createEvent.Parameters.AddWithValue("body", m_Event.Body); createEvent.Parameters.AddWithValue("lockedBy", HttpContext.Current.Session["uid"]); createEvent.Parameters.AddWithValue("lastModifiedBy", HttpContext.Current.Session["uid"]); createEvent.Parameters.AddWithValue("lastModifiedDate", DateTime.Now); createEvent.Parameters.AddWithValue("featuredEvent", m_Event.FeaturedEvent); createEvent.ExecuteNonQuery(); conn.Close(); }
public bool EventStartTimeBeforeEventEndTime(Event m_Event) { if (m_Event.AmpmStart == "pm" && m_Event.AmpmEnd == "am") { return false; } else if (m_Event.AmpmStart == "am" && m_Event.AmpmEnd == "pm") { return true; } else { if (m_Event.EventStartHour < m_Event.EventEndHour) { return false; } else if (m_Event.EventStartHour > m_Event.EventEndHour) { return true; } else { if (m_Event.EventStartMin <= m_Event.EventEndMin) { return false; } else { return true; } } } }
public ActionResult Add() { ViewBag.Branchs = DBEvent.BranchNames(); ViewBag.myContentGroups = DBEvent.ContentGroups(); Event m_Event = new Event(); return View("Add", m_Event); }
public bool EventEndTimeErrorChecking(Event m_Event) { if (m_Event.EventEndHour != -1 && (m_Event.EventEndMin == -1 || m_Event.AmpmEnd == "-1")) { return false; } if (m_Event.EventEndMin != -1 && (m_Event.EventEndHour == -1 || m_Event.AmpmEnd == "-1")) { return false; } if (m_Event.AmpmEnd != "-1" && (m_Event.EventEndHour == -1 || m_Event.EventEndMin == -1)) { return false; } return true; }
public bool EventStartTimeErrorChecking(Event m_Event) { if (m_Event.EventStartHour != -1 && (m_Event.EventStartMin == -1 || m_Event.AmpmStart == "-1")) { return false; } if (m_Event.EventStartMin != -1 && (m_Event.EventStartHour == -1 || m_Event.AmpmStart == "-1")) { return false; } if (m_Event.AmpmStart != "-1" && (m_Event.EventStartHour == -1 || m_Event.EventStartMin == -1)) { return false; } return true; }
public ActionResult Add(Event m_Event) { ViewBag.Branchs = Utility.BranchNames(); ViewBag.myContentGroups = Utility.ContentGroups(); if (!EventRepository.EventStartTimeErrorChecking(m_Event)) { ModelState.AddModelError("EventStartHour", "A complete start time including AM or PM is required"); } if (!EventRepository.EventEndTimeErrorChecking(m_Event)) { ModelState.AddModelError("EventEndHour", "A complete end time including AM or PM is required"); } if (!EventRepository.EventTimeBothErrorChecking(m_Event)) { ModelState.AddModelError("EventStartHour", "You cannot input an end time without a start time"); } if (!EventRepository.EventStartTimeBeforeEventEndTime(m_Event)) { ModelState.AddModelError("EventStartHour", "Start Time must be before End Time"); } if (ModelState.IsValid) { EventRepository.Create(m_Event); return RedirectToAction("Index", "Calendar", new { id = DateTime.Parse(m_Event.EventStartDate.ToString()).ToString("MM-dd-yyyy")}); } else { return View("Add", m_Event); } }
public bool Update(Event m_Event) { DBEvent.Update(m_Event); return true; }
public bool Create(Event m_Event) { DBEvent.Create(m_Event); return true; }
public Event RetrieveOne(int m_Eid) { Event m_Event = new Event(); m_Event = DBEvent.RetrieveOne(m_Eid); return m_Event; }
public ActionResult Edit(Event m_Event) { ViewBag.myContentGroups = Utility.ContentGroups(); ViewBag.Branchs = Utility.BranchNames(); if (!EventRepository.EventStartTimeErrorChecking(m_Event)) { ModelState.AddModelError("EventStartHour", "A complete start time including AM or PM is required"); } if (!EventRepository.EventEndTimeErrorChecking(m_Event)) { ModelState.AddModelError("EventEndHour", "A complete end time including AM or PM is required"); } if (!EventRepository.EventTimeBothErrorChecking(m_Event)) { ModelState.AddModelError("EventStartHour", "You cannot input an end time without a start time"); } if (!EventRepository.EventStartTimeBeforeEventEndTime(m_Event)) { ModelState.AddModelError("EventStartHour", "Start Time must be before End Time"); } if (m_Event.LockedBy > 0 && m_Event.LockedBy != (int)System.Web.HttpContext.Current.Session["uid"]) { ModelState.AddModelError("EventTitle", "This Event is currently locked and not editable"); } if (ModelState.IsValid) { EventRepository.Update(m_Event); return RedirectToAction("Index", "Calendar"); } else { return View("Edit", m_Event); } }
public static Event RetrieveOne(int id) { SqlConnection conn = DB.DbConnect(); conn.Open(); string queryString; string action = HttpContext.Current.Request.RequestContext.RouteData.Values["action"].ToString(); if (action == "PagePreview") { queryString = "SELECT * FROM CMS_Events WHERE id = @id"; } else { queryString = "SELECT * FROM CMS_Events WHERE id = @id AND pageWorkFlowState != 4"; } SqlCommand getEvent = new SqlCommand(queryString, conn); getEvent.Parameters.AddWithValue("id", id); SqlDataReader myEvent = getEvent.ExecuteReader(); Event m_Event = new Event(); if (myEvent.Read()) { m_Event.EventID = myEvent.GetInt32(0); m_Event.ContentGroup = myEvent.GetInt32(1); m_Event.EventTitle = myEvent.GetString(2); m_Event.EventStartDate = myEvent.GetDateTime(3); m_Event.EventEndDate = myEvent.GetDateTime(4); m_Event.Branch = myEvent.GetInt32(5); m_Event.BranchName = Utility.getBranchName(m_Event.Branch); m_Event.Body = myEvent.GetString(6); m_Event.PageWorkFlowState = myEvent.GetInt32(7); m_Event.LockedBy = myEvent.GetInt32(8); m_Event.FeaturedEvent = myEvent.GetInt32(11); if(m_Event.EventStartDate.Hour >= 12) { if (m_Event.EventStartDate.Hour == 12) { m_Event.EventStartHour = 12; } else { m_Event.EventStartHour = m_Event.EventStartDate.Hour % 12; } m_Event.AmpmStart = "pm"; } else { m_Event.AmpmStart = "am"; m_Event.EventStartHour = m_Event.EventStartDate.Hour; } if(m_Event.EventEndDate.Hour >= 12) { if (m_Event.EventEndDate.Hour == 12) { m_Event.EventEndHour = 12; } else { m_Event.EventEndHour = m_Event.EventEndDate.Hour % 12; } m_Event.AmpmEnd = "pm"; } else { m_Event.AmpmEnd = "am"; m_Event.EventEndHour = m_Event.EventEndDate.Hour; } m_Event.EventStartMin = m_Event.EventStartDate.Minute; m_Event.EventEndMin = m_Event.EventEndDate.Minute; } conn.Close(); return m_Event; }
public static List<Event> RetrieveAll(DateTime searchDate) { List<Event> myEvents = new List<Event>(); SqlConnection conn = DB.DbConnect(); conn.Open(); string queryString; queryString = "SELECT id, eventTitle, pageWorkFlowState, lockedBy from CMS_Events WHERE @searchDateStart >= eventStartDate AND @searchDate <= eventEndDate AND pageWorkFlowState != 4"; SqlCommand getEvent = new SqlCommand(queryString, conn); getEvent.Parameters.AddWithValue("searchDateStart", DateTime.Parse(searchDate.ToString("MM/dd/yyyy") + " 23:59:59")); getEvent.Parameters.AddWithValue("searchDate", DateTime.Parse(searchDate.ToString("MM/dd/yyyy") + " 00:00:00")); SqlDataReader eventReader = getEvent.ExecuteReader(); while (eventReader.Read()) { Event tempEvent = new Event(); tempEvent.EventID = eventReader.GetInt32(0); tempEvent.EventTitle = eventReader.GetString(1); tempEvent.PageWorkFlowState = eventReader.GetInt32(2); tempEvent.LockedBy = eventReader.GetInt32(3); myEvents.Add(tempEvent); } conn.Close(); return myEvents; }
public static Event getTopByEventId(int id) { SqlConnection conn = DB.DbConnect(); conn.Open(); string queryString = "SELECT TOP 1 * FROM CMS_Events WHERE id = @id ORDER BY id DESC"; SqlCommand getEvent = new SqlCommand(queryString, conn); getEvent.Parameters.AddWithValue("id", id); SqlDataReader myEvent = getEvent.ExecuteReader(); Event m_Event = new Event(); if (myEvent.Read()) { m_Event.EventID = myEvent.GetInt32(0); m_Event.ContentGroup = myEvent.GetInt32(1); m_Event.EventTitle = myEvent.GetString(2); m_Event.EventStartDate = myEvent.GetDateTime(3); m_Event.EventEndDate = myEvent.GetDateTime(4); m_Event.Branch = myEvent.GetInt32(5); m_Event.BranchName = Utility.getBranchName(m_Event.Branch); m_Event.Body = myEvent.GetString(6); m_Event.PageWorkFlowState = myEvent.GetInt32(7); m_Event.LockedBy = myEvent.GetInt32(8); m_Event.FeaturedEvent = myEvent.GetInt32(11); if (m_Event.EventStartDate.Hour >= 12) { if (m_Event.EventStartDate.Hour == 12) { m_Event.EventStartHour = 12; } else { m_Event.EventStartHour = m_Event.EventStartDate.Hour % 12; } m_Event.AmpmStart = "pm"; } else { m_Event.AmpmStart = "am"; m_Event.EventStartHour = m_Event.EventStartDate.Hour; } if (m_Event.EventEndDate.Hour >= 12) { if (m_Event.EventEndDate.Hour == 12) { m_Event.EventEndHour = 12; } else { m_Event.EventEndHour = m_Event.EventEndDate.Hour % 12; } m_Event.AmpmEnd = "pm"; } else { m_Event.AmpmEnd = "am"; m_Event.EventEndHour = m_Event.EventEndDate.Hour; } m_Event.EventStartMin = m_Event.EventStartDate.Minute; m_Event.EventEndMin = m_Event.EventEndDate.Minute; } conn.Close(); return m_Event; }
public static List<Event> getFeaturedEvents() { SqlConnection conn = DB.DbConnect(); conn.Open(); string queryString = "SELECT TOP 5 * FROM CMS_Events WHERE featuredEvent = 1 AND eventEndDate >= @startDate AND pageWorkFlowState = 2 ORDER BY eventStartDate ASC"; SqlCommand getEvents = new SqlCommand(queryString, conn); getEvents.Parameters.AddWithValue("startDate", DateTime.Parse(DateTime.Now.ToString("MM/dd/yyyy") + " 00:00:00")); //getEvents.Parameters.AddWithValue("endDate", DateTime.Parse(DateTime.Now.ToString("MM/dd/yyyy"))); SqlDataReader eventReader = getEvents.ExecuteReader(); List<Event> myEvents = new List<Event>(); while (eventReader.Read()) { Event tempEvent = new Event(); tempEvent.EventID = eventReader.GetInt32(0); tempEvent.EventTitle = eventReader.GetString(2); tempEvent.PageWorkFlowState = eventReader.GetInt32(7); tempEvent.LockedBy = eventReader.GetInt32(8); DateTime startDate = eventReader.GetDateTime(3); DateTime endDate = eventReader.GetDateTime(4); tempEvent.EventStartDate = DateTime.Parse(startDate.ToString("MM/dd/yyyy")); tempEvent.EventEndDate = DateTime.Parse(endDate.ToString("MM/dd/yyyy")); tempEvent.EventStartHour = startDate.Hour % 12; tempEvent.EventStartMin = startDate.Minute; tempEvent.EventEndHour = endDate.Hour % 12; tempEvent.EventEndMin = endDate.Minute; if (startDate.Hour >= 12) { tempEvent.AmpmStart = "PM"; } else { tempEvent.AmpmStart = "AM"; } if (endDate.Hour >= 12) { tempEvent.AmpmEnd = "PM"; } else { tempEvent.AmpmEnd = "AM"; } tempEvent.Branch = eventReader.GetInt32(5); tempEvent.BranchName = Utility.getBranchName(tempEvent.Branch); myEvents.Add(tempEvent); } conn.Close(); return myEvents; }
public static void Update(Event m_Event) { SqlConnection conn = DB.DbConnect(); conn.Open(); string queryString = "UPDATE CMS_Events SET contentGroup = @contentGroup, eventTitle = @eventTitle, eventStartDate = @eventStartDate, eventEndDate = @eventEndDate, branch = @branch, body = @body, pageWorkFlowState = 1, lockedBy = @lockedBy, lastModifiedBy = @lastModifiedBy, lastModifiedDate = @lastModifiedDate, featuredEvent = @featuredEvent WHERE id = @EventID"; SqlCommand updateEvent = new SqlCommand(queryString, conn); string myStartTime = string.Empty; string myEndTime = string.Empty; if (m_Event.EventStartHour != -1 && m_Event.EventStartMin != -1 && m_Event.AmpmStart != "-1") { myStartTime = " " + m_Event.EventStartHour.ToString() + ":" + m_Event.EventStartMin.ToString() + " " + m_Event.AmpmStart; } if (m_Event.EventEndHour != -1 && m_Event.EventEndMin != -1 && m_Event.AmpmEnd != "-1") { myEndTime = " " + m_Event.EventEndHour.ToString() + ":" + m_Event.EventEndMin.ToString() + " " + m_Event.AmpmEnd; } updateEvent.Parameters.AddWithValue("contentGroup", m_Event.ContentGroup); updateEvent.Parameters.AddWithValue("eventTitle", m_Event.EventTitle); updateEvent.Parameters.AddWithValue("eventStartDate", DateTime.Parse(m_Event.EventStartDate.ToString("MM/dd/yyyy") + myStartTime)); updateEvent.Parameters.AddWithValue("eventEndDate", DateTime.Parse(m_Event.EventEndDate.ToString("MM/dd/yyyy") + myEndTime)); updateEvent.Parameters.AddWithValue("branch", m_Event.Branch); updateEvent.Parameters.AddWithValue("body", m_Event.Body); updateEvent.Parameters.AddWithValue("EventID", m_Event.EventID); updateEvent.Parameters.AddWithValue("lockedBy", HttpContext.Current.Session["uid"]); updateEvent.Parameters.AddWithValue("lastModifiedBy", HttpContext.Current.Session["uid"]); updateEvent.Parameters.AddWithValue("lastModifiedDate", DateTime.Now); updateEvent.Parameters.AddWithValue("featuredEvent", m_Event.FeaturedEvent); updateEvent.ExecuteNonQuery(); conn.Close(); }
public bool EventTimeBothErrorChecking(Event m_Event) { if (m_Event.EventEndHour != -1 && m_Event.EventStartHour == -1 && EventEndTimeErrorChecking(m_Event) && EventStartTimeErrorChecking(m_Event)) { return false; } else { return true; } }
public bool Update(Event m_Event) { Event tempEvent = DBEvent.getTopByEventId(m_Event.EventID); m_Event.PageWorkFlowState = tempEvent.PageWorkFlowState; if (m_Event.EventID != tempEvent.EventID) { m_Event.EventID = tempEvent.EventID; } DBEvent.Update(m_Event); return true; }