public static object FetchAppointmentsHelperMethod(FetchAppointmentsEventArgs args)
{
args.ForceReloadAppointments = true;
SchedulingDataClassesDataContext db = new SchedulingDataClassesDataContext();
return(db.DBAppointments.Where(e => e.StartDate > args.Interval.Start && e.EndDate < args.Interval.End));
}
public static void RemoveAppointment(DBAppointment appt)
{
SchedulingDataClassesDataContext db = new SchedulingDataClassesDataContext();
DBAppointment query = (DBAppointment)(from carSchedule in db.DBAppointments where carSchedule.UniqueID == appt.UniqueID select carSchedule).SingleOrDefault();
db.DBAppointments.DeleteOnSubmit(query);
db.SubmitChanges();
}
public static IEnumerable GetAppointmentsFilteredByResources(List <int> resourceIds)
{
SchedulingDataClassesDataContext db = new SchedulingDataClassesDataContext();
return(from apt in db.DBAppointments
where resourceIds.Contains(apt.ResourceID.Value)
select apt);
}
public static void InsertAppointment(DBAppointment appt)
{
if (appt == null)
{
return;
}
SchedulingDataClassesDataContext db = new SchedulingDataClassesDataContext();
appt.UniqueID = appt.GetHashCode();
db.DBAppointments.InsertOnSubmit(appt);
db.SubmitChanges();
}
public static void UpdateAppointment(DBAppointment appt)
{
if (appt == null)
{
return;
}
SchedulingDataClassesDataContext db = new SchedulingDataClassesDataContext();
DBAppointment query = (DBAppointment)(from carSchedule in db.DBAppointments where carSchedule.UniqueID == appt.UniqueID select carSchedule).SingleOrDefault();
query.UniqueID = appt.UniqueID;
query.StartDate = appt.StartDate;
query.EndDate = appt.EndDate;
query.AllDay = appt.AllDay;
query.Subject = appt.Subject;
query.Description = appt.Description;
query.Location = appt.Location;
query.RecurrenceInfo = appt.RecurrenceInfo;
query.ReminderInfo = appt.ReminderInfo;
query.Status = appt.Status;
query.Type = appt.Type;
query.Label = appt.Label;
query.ResourceID = appt.ResourceID;
db.SubmitChanges();
}
public static IEnumerable GetAppointments()
{
SchedulingDataClassesDataContext db = new SchedulingDataClassesDataContext();
return(from apt in db.DBAppointments select apt);
}
public static IEnumerable GetResources()
{
SchedulingDataClassesDataContext db = new SchedulingDataClassesDataContext();
return(from res in db.DBResources select res);
}
