public static void UpdateAppointment(CarScheduling appt) { if (appt == null) { return; } CarsDataContext db = new CarsDataContext(); 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; query.ContactInfo = appt.ContactInfo; query.Price = appt.Price; db.SubmitChanges(); }
public static XtraReportsDemos.AnchorVertical.Report Fill(this XtraReportsDemos.AnchorVertical.Report report) { CarsDataContext dataContext = new CarsDataContext(); dataContext.Cars.CopyToDataTable(report.dsCars1.Cars); return(report); }
public static void RemoveAppointment(CarScheduling appt) { CarsDataContext db = new CarsDataContext(); 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; } CarsDataContext db = new CarsDataContext(); appt.ID = appt.GetHashCode(); db.CarSchedulings.InsertOnSubmit(appt); db.SubmitChanges(); }
public CarController(CarsDataContext context) { _context = context; }
public static IEnumerable GetAppointments() { CarsDataContext db = new CarsDataContext(); return(from apt in db.CarSchedulings select apt); }
public static IEnumerable GetResources() { CarsDataContext db = new CarsDataContext(); return(from res in db.Cars select res); }