private void DeleteScheduleFromDb(ScheduleClass dataBaseSchedule) { using (var context = new EsterClassesDataContext()) { var dbSch = context.Schedules.Single(s => s.ObjectId == dataBaseSchedule.Id); context.Schedules.DeleteOnSubmit(dbSch); context.SubmitChanges(); } }
private void EditScheduleInDataBase(ScheduleClass controllerSchedule) { Schedule newDbSchedule = ConvertScheduleClassToDbSchedule(controllerSchedule); using (var context = new EsterClassesDataContext()) { var dbSchedule = context.Schedules.Single(s => s.ObjectId == newDbSchedule.ObjectId); dbSchedule.Title = newDbSchedule.Title; dbSchedule.OverrideController = newDbSchedule.OverrideController; dbSchedule.DeleteOnSync = newDbSchedule.DeleteOnSync; dbSchedule.SchedulesContents = newDbSchedule.SchedulesContents; dbSchedule.SchedulesControlledObjects = newDbSchedule.SchedulesControlledObjects; context.SubmitChanges(); } }
private void AddScheduleToDataBase(ScheduleClass controllerSchedule) { //добавление расписания в бд Schedule sch = ConvertScheduleClassToDbSchedule(controllerSchedule); using (var context = new EsterClassesDataContext()) { var dbSch = context.Schedules.FirstOrDefault(s => s.ObjectId == sch.ObjectId); if (dbSch != null) { context.Schedules.DeleteOnSubmit(dbSch); } context.Schedules.InsertOnSubmit(sch); context.SubmitChanges(); } }
public void DeleteSchedule(string id) { try { int intId = int.Parse(id); using (var context = new EsterClassesDataContext()) { var dbSchedule = context.Schedules.Single(s => s.ObjectId == intId); dbSchedule.DeleteOnSync = true; context.SubmitChanges(); } } catch { throw new BadRequestException(); } }
public void DeleteSchedule(string id) { try { int intId = int.Parse(id); using (var context = new EsterClassesDataContext()) { var dbSchedule = context.Schedules.Single(s => s.ObjectId == intId); dbSchedule.DeleteOnSync = true; context.SubmitChanges(); } } catch { throw new BadRequestException(); } }
private void DeleteScheduleFromDb(ScheduleClass dataBaseSchedule) { using (var context = new EsterClassesDataContext()) { var dbSch = context.Schedules.Single(s => s.ObjectId == dataBaseSchedule.Id); context.Schedules.DeleteOnSubmit(dbSch); context.SubmitChanges(); } }
private void EditScheduleInDataBase(ScheduleClass controllerSchedule) { Schedule newDbSchedule = ConvertScheduleClassToDbSchedule(controllerSchedule); using (var context = new EsterClassesDataContext()) { var dbSchedule = context.Schedules.Single(s => s.ObjectId == newDbSchedule.ObjectId); dbSchedule.Title = newDbSchedule.Title; dbSchedule.OverrideController = newDbSchedule.OverrideController; dbSchedule.DeleteOnSync = newDbSchedule.DeleteOnSync; dbSchedule.SchedulesContents = newDbSchedule.SchedulesContents; dbSchedule.SchedulesControlledObjects = newDbSchedule.SchedulesControlledObjects; context.SubmitChanges(); } }
private void AddScheduleToDataBase(ScheduleClass controllerSchedule) { //добавление расписания в бд Schedule sch = ConvertScheduleClassToDbSchedule(controllerSchedule); using (var context = new EsterClassesDataContext()) { var dbSch = context.Schedules.FirstOrDefault(s => s.ObjectId == sch.ObjectId); if (dbSch != null) context.Schedules.DeleteOnSubmit(dbSch); context.Schedules.InsertOnSubmit(sch); context.SubmitChanges(); } }