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();
}
}
