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();
}
