public static void RemoveAppointment(CarScheduling appt)
{
SchedulingDataClassesDataContext db = new SchedulingDataClassesDataContext();
CarScheduling query = (CarScheduling)(from carSchedule in db.CarSchedulings where carSchedule.ID == appt.ID select carSchedule).SingleOrDefault();
db.CarSchedulings.DeleteOnSubmit(query);
db.SubmitChanges();
}
public static void InsertAppointment(CarScheduling appt)
{
if (appt == null)
{
return;
}
SchedulingDataClassesDataContext db = new SchedulingDataClassesDataContext();
appt.ID = appt.GetHashCode();
db.CarSchedulings.InsertOnSubmit(appt);
db.SubmitChanges();
}
public static IEnumerable GetResources(List <int> resourceIds)
{
if (resourceIds.Count == 0)
{
return(GetResources());
}
SchedulingDataClassesDataContext db = new SchedulingDataClassesDataContext();
return(from res in db.Cars
where resourceIds.Contains(res.ID)
select res);
}
public static void UpdateAppointment(CarScheduling appt)
{
if (appt == null)
{
return;
}
SchedulingDataClassesDataContext db = new SchedulingDataClassesDataContext();
CarScheduling query = (CarScheduling)(from carSchedule in db.CarSchedulings where carSchedule.ID == appt.ID select carSchedule).SingleOrDefault();
query.ID = appt.ID;
query.StartTime = appt.StartTime;
query.EndTime = appt.EndTime;
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.EventType = appt.EventType;
query.Label = appt.Label;
query.CarId = appt.CarId;
db.SubmitChanges();
}
public static IEnumerable GetAppointments()
{
SchedulingDataClassesDataContext db = new SchedulingDataClassesDataContext();
return(from apt in db.CarSchedulings select apt);
}
public static IEnumerable GetResources()
{
SchedulingDataClassesDataContext db = new SchedulingDataClassesDataContext();
return(from res in db.Cars select res);
}
