public static List <CalendarEvent> LoadAllAppointmentsInDateRange(double start, double end)
{
//var fromDate = ConvertFromUnixTimestamp(start);
//var toDate = ConvertFromUnixTimestamp(end);
using (EventsP1Context ent = new EventsP1Context())
{
var rslt = ent.CalendarEvents;
//Where(s => s.DateStart >= fromDate && s.DateFinish <= toDate);
List <CalendarEvent> result = new List <CalendarEvent>();
foreach (var item in rslt)
{
CalendarEvent rec = new CalendarEvent();
rec.CalendarEventID = item.CalendarEventID;
rec.Name = item.Name;
rec.DateStart = item.DateStart;
// "s" is a preset format that outputs as: "2009-02-27T12:12:22"
rec.DateFinish = item.DateFinish;
//rec.EndDateString = item.DateTimeScheduled.AddMinutes(item.AppointmentLength).ToString("s");
// field AppointmentLength is in minutes
rec.Allday = item.Allday;
result.Add(rec);
}
return(result);
}
}
public IEnumerable <Attendee> getAttendess()
{
IEnumerable <Attendee> friendsList;
EventsP1Context db = new EventsP1Context();
friendsList = db.Attendees.ToList();
return(friendsList);
}
public static void UpdateCalendarEvent(int id, string NewEventStart, string NewEventEnd)
{
// EventStart comes ISO 8601 format, eg: "2000-01-10T10:00:00Z" - need to convert to DateTime
using (EventsP1Context ent = new EventsP1Context())
{
var rec = ent.CalendarEvents.FirstOrDefault(s => s.CalendarEventID == id);
if (rec != null)
{
DateTime DateTimeStart = DateTime.Parse(NewEventStart, null, System.Globalization.DateTimeStyles.RoundtripKind).ToLocalTime(); // and convert offset to localtime
rec.DateStart = DateTimeStart;
DateTime DateTimeEnd = DateTime.Parse(NewEventEnd, null, System.Globalization.DateTimeStyles.RoundtripKind).ToLocalTime(); // and convert offset to localtime
rec.DateFinish = DateTimeEnd;
ent.SaveChanges();
}
}
}