public IQueryable<brdhc_Event> upcomingEvents() { eventsCalendarDataContext objUp = new eventsCalendarDataContext(); var upcoming = objUp.brdhc_Events.Where(x => x.EventDate >= DateTime.Today).Select(x => x).Take(3); //(from u in objUp.brdhc_Events where u.EventDate >= DateTime.Today select u); return upcoming; }
public bool deleteEvent(Guid eventID) { eventsCalendarDataContext objEvents = new eventsCalendarDataContext(); using (objEvents) { var events = objEvents.brdhc_Events.Where(x => x.EventId == eventID); objEvents.brdhc_Events.DeleteAllOnSubmit(events); objEvents.SubmitChanges(); return true; } }
public void updateEvent(string eventId, string _title, string _description, string _date, string _start, string _end, string _location, string _heldBy) { eventsCalendarDataContext objEvents = new eventsCalendarDataContext(); var events = objEvents.brdhc_Events.Single(x => x.EventId == new Guid(eventId)); events.EventTitle = _title; events.EventDescription = _description; events.EventDate = DateTime.Parse(_date.ToString()); events.EventStartTime = _start; events.EventEndTime = _end; events.EventLocation = _location; events.EventsHeldBy = _heldBy; objEvents.SubmitChanges(); }
protected void smallCalendar(object sender, System.Web.UI.WebControls.DayRenderEventArgs e) { if (Page.IsPostBack) { Calendar.StartDate = small_calendar.SelectedDate; Calendar.DataSource = objEvents.getEvents(); } e.Day.IsSelectable = false; eventsCalendarDataContext db = new eventsCalendarDataContext(); var events = (from p in db.brdhc_Events where p.EventDate == e.Day.Date select p); var upcoming = (from u in db.brdhc_Events where u.EventDate >= DateTime.Today select u); if (events.Count() > 0) { foreach (brdhc_Event x in events) { e.Cell.BackColor = System.Drawing.Color.DarkGreen; e.Cell.Font.Bold = true; e.Cell.ForeColor = System.Drawing.Color.White; } } }
public bool insertEvent(Guid eventID, string _title, string _description, Guid _createdBy, DateTime _date, string _start, string _end, string _location, string _heldBy //bool _isApproved ) { eventsCalendarDataContext objEvents = new eventsCalendarDataContext(); using (objEvents) { brdhc_Event objNewEvent = new brdhc_Event(); objNewEvent.EventId = Guid.NewGuid(); objNewEvent.EventTitle = _title; objNewEvent.EventDescription = _description; objNewEvent.EventCreatedBy = Guid.Parse(_createdBy.ToString()); objNewEvent.EventDate = _date; objNewEvent.EventStartTime = _start; objNewEvent.EventEndTime = _end; objNewEvent.EventLocation = _location; objNewEvent.EventsHeldBy = _heldBy; //objNewEvent.IsApproved = _isApproved; objEvents.brdhc_Events.InsertOnSubmit(objNewEvent); objEvents.SubmitChanges(); return true; } }
public IQueryable<brdhc_Event> getEventByID(Guid eventID) { eventsCalendarDataContext objEvents = new eventsCalendarDataContext(); var singleEvent = objEvents.brdhc_Events.Where(x => x.EventId == eventID).Select(x => x); return singleEvent; }
public IQueryable<brdhc_Event> getEvents() { eventsCalendarDataContext objEvents = new eventsCalendarDataContext(); var allEvents = objEvents.brdhc_Events.Select(x => x); return allEvents; }