private Route CreateModel(Route route, RouteBindingModel model, UrskiyPeriodDatabase context) { route = CreateModel(route, model); if (model.Id.HasValue) { var routeReserve = context.RouteReserves.Where(rec => rec.RouteId == model.Id.Value).ToList(); // удаляем те, которых нет в модели context.RouteReserves.RemoveRange(routeReserve.Where(rec => !model.RouteReverces.ContainsKey(rec.ReserveId)).ToList()); context.SaveChanges(); foreach (var Reserve in routeReserve) { model.RouteReverces.Remove(Reserve.ReserveId); } } foreach (var routeReserve in model.RouteReverces) { context.RouteReserves.Add(new RouteReserve { ReserveId = routeReserve.Key, RouteId = route.Id }); } context.SaveChanges(); return(route); }
private CostItem CreateModel(CostItem costItem, CostItemBindingModel model, UrskiyPeriodDatabase context) { costItem = CreateModel(costItem, model); if (model.Id.HasValue) { var routeCost = context.CostItemRoutes.Where(rec => rec.CostItemId == model.Id.Value).ToList(); // удаляем те, которых нет в модели context.CostItemRoutes.RemoveRange(routeCost.Where(rec => !model.CostItemRoute.ContainsKey(rec.RouteId)).ToList()); context.SaveChanges(); foreach (var Reserve in routeCost) { model.CostItemRoute.Remove(Reserve.RouteId); } } foreach (var cost in model.CostItemRoute) { context.CostItemRoutes.Add(new CostItemRoute { CostItemId = costItem.Id, RouteId = cost.Key }); } context.SaveChanges(); return(costItem); }
public void Update(CostItemBindingModel model) { using (var context = new UrskiyPeriodDatabase()) { using (var transaction = context.Database.BeginTransaction()) { try { var costItem = context.CostItem.FirstOrDefault(rec => rec.Id == model.Id); if (costItem == null) { throw new Exception("Не найдено"); } CreateModel(costItem, model, context); context.SaveChanges(); transaction.Commit(); } catch { transaction.Rollback(); throw; } } } }
public void Insert(RouteBindingModel model) { using (var context = new UrskiyPeriodDatabase()) { using (var transaction = context.Database.BeginTransaction()) { try { if (context.Routes.FirstOrDefault(rec => rec.Name == model.Name) != null) { return; } Route route = CreateModel(new Route(), model); context.Routes.Add(route); context.SaveChanges(); CreateModel(route, model, context); transaction.Commit(); } catch { transaction.Rollback(); throw; } } } }
public void Update(RouteBindingModel model) { using (var context = new UrskiyPeriodDatabase()) { using (var transaction = context.Database.BeginTransaction()) { try { var route = context.Routes.FirstOrDefault(rec => rec.Id == model.Id); if (route == null) { throw new Exception("Маршрут не найден"); } CreateModel(route, model, context); context.SaveChanges(); transaction.Commit(); } catch { transaction.Rollback(); throw; } } } }
public void Insert(PaymentBindingModel model) { using (var context = new UrskiyPeriodDatabase()) { context.Payment.Add(CreateModel(new Payment(), model)); context.SaveChanges(); } }
public void Insert(UserBindingModel model) { using (var context = new UrskiyPeriodDatabase()) { context.Users.Add(CreateModel(new User(), model)); context.SaveChanges(); } }
public void Insert(ReserveBindingModel model) { using (var context = new UrskiyPeriodDatabase()) { if (context.Reserves.FirstOrDefault(rec => rec.Name == model.Name) != null) { return; } context.Reserves.Add(CreateModel(new Reserve(), model)); context.SaveChanges(); } }
public void Delete(PaymentBindingModel model) { using (var context = new UrskiyPeriodDatabase()) { var user = context.Payment.FirstOrDefault(rec => rec.Id == model.Id); if (user == null) { throw new Exception("Не найдено"); } context.Payment.Remove(user); context.SaveChanges(); } }
public void Update(PaymentBindingModel model) { using (var context = new UrskiyPeriodDatabase()) { var payment = context.Payment.FirstOrDefault(rec => rec.Id == model.Id); if (payment == null) { throw new Exception("Не найдено"); } CreateModel(payment, model); context.SaveChanges(); } }
public void Delete(ReserveBindingModel model) { using (var context = new UrskiyPeriodDatabase()) { var user = context.Reserves.FirstOrDefault(rec => rec.Id == model.Id); if (user == null) { throw new Exception("Заповедник не найден"); } context.Reserves.Remove(user); context.SaveChanges(); } }
public void Update(UserBindingModel model) { using (var context = new UrskiyPeriodDatabase()) { var user = context.Users.FirstOrDefault(rec => rec.Id == model.Id); if (user == null) { throw new Exception("Клиент не найден"); } CreateModel(user, model); context.SaveChanges(); } }
public void Delete(RouteBindingModel model) { using (var context = new UrskiyPeriodDatabase()) { var route = context.Routes.FirstOrDefault(rec => rec.Id == model.Id); if (route == null) { throw new Exception("Маршрут не найден"); } context.Routes.Remove(route); context.SaveChanges(); } }
public void Insert(CostItemBindingModel model) { using (var context = new UrskiyPeriodDatabase()) { using (var transaction = context.Database.BeginTransaction()) { try { CostItem cost = CreateModel(new CostItem(), model); context.CostItem.Add(cost); context.SaveChanges(); CreateModel(cost, model, context); context.SaveChanges(); transaction.Commit(); } catch { transaction.Rollback(); throw; } } } }