public static List<CalendarEventType> AllCalendarEventTypes() { var dataModel = new DesignEntities(); var query = from p in dataModel.CalendarEventTypes orderby p.Name select p; var list = query.ToList(); return list; }
public static void UpdateDataBaseCalendarEventTime(SiteCalenderApiController.CalendarEvents calendarEvent) { var dataModel = new DesignEntities(); var item = (from p in dataModel.CalendarEvents where p.CalendarEventId == calendarEvent.CalendarEventId select p).FirstOrDefault(); if (item != null) { item.StartDate = calendarEvent.StartDate; item.EndDate = calendarEvent.EndDate < calendarEvent.StartDate ? calendarEvent.StartDate.AddHours(1) :calendarEvent.EndDate; } dataModel.SaveChanges(); }
public static void SaveUserCreatedPoint(MapPlace place) { var dataModel = new DesignEntities(); dataModel.MapPlaces.Add(place); dataModel.SaveChanges(); EmailMe.SendMeAEmail(new EmailMe.Email { Body = string.Format("A new map point created, {0} {1}",place.Title,place.Description), EmailAddress = "*****@*****.**", Name = "Jons Site", Subject = "Point created from your site" }); }
public static CalendarEvent InsertCalendarEvent(SiteCalenderApiController.CalendarEvents calendarEvent) { var dataModel = new DesignEntities(); var item = new CalendarEvent { CalendarEventTypeId = calendarEvent.CalendarEventTypeId, Title = calendarEvent.Title, Description = calendarEvent.Description, StartDate = calendarEvent.StartDate, EndDate = calendarEvent.EndDate, Editable = calendarEvent.Editable }; dataModel.CalendarEvents.Add(item); dataModel.SaveChanges(); return item; }
public static CalendarEvent RetrieveCalendarEventById(int id) { var dataModel = new DesignEntities(); var item = (from p in dataModel.CalendarEvents where p.CalendarEventId == id select p).FirstOrDefault(); return item; }
public static List<CalendarEvent> AllCalendarEvents() { var dataModel = new DesignEntities(); var query = from p in dataModel.CalendarEvents select p; return query.ToList(); }
public static List<MapPlace> AllUserCreatedPoints() { var dataModel = new DesignEntities(); var query = from p in dataModel.MapPlaces select p; return query.ToList(); }