public void SaveBook(Book book) { if (book.BookId == 0) { context.Books.Add(book); } else { Book dbEntry = context.Books.Find(book.BookId); if (dbEntry != null) { dbEntry.Name = book.Name; dbEntry.Author = book.Author; dbEntry.Description = book.Description; dbEntry.Genre = book.Genre; dbEntry.Price = book.Price; } } context.SaveChanges(); }
public void SaveUser(User user) { var context = new EFDbContext(); if (user.UserId == 0) { context.Users.Add(user); } else { User dbEntry = context.Users.Find(user.UserId); if (dbEntry != null) { dbEntry.UserName = user.UserName; dbEntry.UserMail = user.UserMail; dbEntry.UserPassword = user.UserPassword; dbEntry.IsAdmin = false; } } context.SaveChanges(); }
public void SaveDish(Dish dish) { if (dish.DishId == 0) { context.Dishes.Add(dish); } else { Dish dbEntry = context.Dishes.Find(dish.DishId); if (dbEntry != null) { dbEntry.Style = dish.Style; dbEntry.Producer = dish.Producer; dbEntry.Description = dish.Description; dbEntry.Type = dish.Type; dbEntry.Price = dish.Price; dbEntry.ImageUrl = dish.ImageUrl; } } context.SaveChanges(); }
public void SaveProduct(Product product) { if (product.ProductId == 0) { context.Products.Add(product); } else { Product dbEntry = context.Products.Find(product.ProductId); if (dbEntry != null) { dbEntry.Name = product.Name; dbEntry.Description = product.Description; dbEntry.Price = product.Price; dbEntry.Category = product.Category; dbEntry.ImageData = product.ImageData; dbEntry.ImageMimeType = product.ImageMimeType; } } context.SaveChanges(); }
public void SaveProduct(Product product) { if (string.IsNullOrEmpty(product.Guid)) { product.Guid = Guid.NewGuid().ToString(); context.Products.Add(product); } else { Product dbEntry = context.Products.Find(product.Guid); if (dbEntry != null) { dbEntry.Name = product.Name; dbEntry.Description = product.Description; dbEntry.Price = product.Price; dbEntry.IsActive = product.IsActive; dbEntry.Shop = product.Shop; } } context.SaveChanges(); }
public void SaveThing(Thing thing) { if (thing.ThingId == 0) { context.Things.Add(thing); } else { Thing dbEntry = context.Things.Find(thing.ThingId); if (dbEntry != null) { dbEntry.Name = thing.Name; dbEntry.Kind = thing.Kind; dbEntry.Material = thing.Material; dbEntry.Description = thing.Description; dbEntry.Producer = thing.Producer; dbEntry.Articul = thing.Articul; dbEntry.Price = thing.Price; } } context.SaveChanges(); }
public void SaveSweet(Sweet sweet) { if (sweet.SweetId == 0) { context.Sweets.Add(sweet); } else { Sweet dbEntry = context.Sweets.Find(sweet.SweetId); if (dbEntry != null) { dbEntry.Name = sweet.Name; dbEntry.Ingredients = sweet.Ingredients; dbEntry.Packing = sweet.Packing; dbEntry.Expiration_date = sweet.Expiration_date; dbEntry.Type = sweet.Type; dbEntry.Price = sweet.Price; dbEntry.ImageData = sweet.ImageData; dbEntry.ImageMimeType = sweet.ImageMimeType; } } context.SaveChanges(); }
public void ProcessOrder(Cart cart, Orders o, UserData ud, Characteristic ch) { UserData newUD = new UserData(); Orders newO = new Orders(); GamesInOrders newGIO = new GamesInOrders(); Purchase p = EF.FirstPrices .FirstOrDefault(g => g.PurchaseId == ch.CharacteristicId); //p.Count--; newGIO.CharacteristicsId = ch.CharacteristicId; newGIO.CountOfSoldGames = 1; newGIO.PriceOfSoldGame = 200; newUD.Addres = ud.Addres; newUD.FirstName = ud.FirstName; newUD.SecondName = ud.SecondName; newUD.MiddleName = ud.MiddleName; newO.UDId = newUD.UDId; newO.DateOfOrder = DateTime.Now; newO.StatusOfOrder = true; EF.GamesInOrders.Add(newGIO); EF.UserDatas.Add(newUD); EF.Orders.Add(newO); EF.SaveChanges(); }
public void SaveParams(EquationParameters equparams) { context.EquationParameters.Add(equparams); context.SaveChanges(); }
public void SaveRate(Rate rate) { context.Rates.Attach(rate); context.Entry(rate).State = EntityState.Modified; context.SaveChanges(); }
public void Update(Const @const) { context.Consts.Attach(@const); context.Entry(@const).State = EntityState.Modified; context.SaveChanges(); }
public void Register(Factura factura) { context.Facturas.Add(factura); context.SaveChanges(); }
public void register(Customer c) { context.QBCustomers.Add(c); context.SaveChanges(); }
public static void Initialize(EFDbContext context) { context.Database.EnsureCreated(); if (context.RequestsStore.Any()) { return; } var statuses = new List <Statuses> { new Statuses { Name = "Открыта" }, new Statuses { Name = "Решена" }, new Statuses { Name = "Возврат" }, new Statuses { Name = "Закрыта" } }; foreach (var item in statuses) { context.Statuses.Add(item); } context.SaveChanges(); var requestStore = new List <RequestsStore> { new RequestsStore { Date = DateTime.Now.AddDays(-10), StatusId = 1, Comments = "Заявка создана", Requests = new Requests { CreateDate = DateTime.Now.AddDays(-10), Name = "Что такое Lorem Ipsum?", Content = "<ul><li>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</li><li>Vivamus suscipit ante at urna efficitur blandit.</li><li>Nam venenatis tellus id velit rhoncus, in finibus augue malesuada.</li></ul></p>" } }, new RequestsStore { Date = DateTime.Now.AddDays(-9), StatusId = 1, Comments = "Заявка создана", Requests = new Requests { CreateDate = DateTime.Now.AddDays(-9), Name = "Откуда появился Lorem Ipsum?", Content = "<ul><li>Sed venenatis dui molestie libero elementum ultrices.</li><li>Vestibulum placerat risus eu odio accumsan viverra.</li><li>Nullam et sem ut purus egestas rutrum.</li><li>Praesent auctor tellus et mi rutrum, vel lacinia tortor luctus.</li><li>Nam at tortor euismod, gravida mi fringilla, laoreet magna.</li><li>Maecenas dictum ligula eu nibh mattis, eu pulvinar mi sodales.</li></ul>" } }, new RequestsStore { Date = DateTime.Now.AddDays(-8), StatusId = 1, Comments = "Заявка создана", Requests = new Requests { CreateDate = DateTime.Now.AddDays(-8), Name = "Почему он используется?", Content = "<ul><li>Sed venenatis dui molestie libero elementum ultrices.</li><li>Vestibulum placerat risus eu odio accumsan viverra.</li><li>Nullam et sem ut purus egestas rutrum.</li><li>Praesent auctor tellus et mi rutrum, vel lacinia tortor luctus.</li><li>Nam at tortor euismod, gravida mi fringilla, laoreet magna.</li><li>Maecenas dictum ligula eu nibh mattis, eu pulvinar mi sodales.</li></ul>" } }, new RequestsStore { Date = DateTime.Now.AddDays(-7), StatusId = 1, Comments = "Заявка создана", Requests = new Requests { CreateDate = DateTime.Now.AddDays(-7), Name = "Где взять Lorem Ipsum?", Content = "<ul><li>Sed venenatis dui molestie libero elementum ultrices.</li><li>Vestibulum placerat risus eu odio accumsan viverra.</li><li>Nullam et sem ut purus egestas rutrum.</li><li>Praesent auctor tellus et mi rutrum, vel lacinia tortor luctus.</li><li>Nam at tortor euismod, gravida mi fringilla, laoreet magna.</li><li>Maecenas dictum ligula eu nibh mattis, eu pulvinar mi sodales.</li></ul>" } }, new RequestsStore { Date = DateTime.Now.AddDays(-6), StatusId = 1, Comments = "Заявка создана", Requests = new Requests { CreateDate = DateTime.Now.AddDays(-6), Name = "Классический текст Lorem Ipsum, используемый с XVI века", Content = "<ul><li>Sed venenatis dui molestie libero elementum ultrices.</li><li>Vestibulum placerat risus eu odio accumsan viverra.</li><li>Nullam et sem ut purus egestas rutrum.</li><li>Praesent auctor tellus et mi rutrum, vel lacinia tortor luctus.</li><li>Nam at tortor euismod, gravida mi fringilla, laoreet magna.</li><li>Maecenas dictum ligula eu nibh mattis, eu pulvinar mi sodales.</li></ul>" } }, new RequestsStore { Date = DateTime.Now.AddDays(-5), StatusId = 1, Comments = "Заявка создана", Requests = new Requests { CreateDate = DateTime.Now.AddDays(-5), Name = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras.", Content = "<ul><li>Sed venenatis dui molestie libero elementum ultrices.</li><li>Vestibulum placerat risus eu odio accumsan viverra.</li><li>Nullam et sem ut purus egestas rutrum.</li><li>Praesent auctor tellus et mi rutrum, vel lacinia tortor luctus.</li><li>Nam at tortor euismod, gravida mi fringilla, laoreet magna.</li><li>Maecenas dictum ligula eu nibh mattis, eu pulvinar mi sodales.</li></ul>" } }, new RequestsStore { Date = DateTime.Now.AddDays(-4), StatusId = 1, Comments = "Заявка создана", Requests = new Requests { CreateDate = DateTime.Now.AddDays(-4), Name = "Lorem sit amet, adipiscing elit.", Content = "<ul><li>Sed venenatis dui molestie libero elementum ultrices.</li><li>Vestibulum placerat risus eu odio accumsan viverra.</li><li>Nullam et sem ut purus egestas rutrum.</li><li>Praesent auctor tellus et mi rutrum, vel lacinia tortor luctus.</li><li>Nam at tortor euismod, gravida mi fringilla, laoreet magna.</li><li>Maecenas dictum ligula eu nibh mattis, eu pulvinar mi sodales.</li></ul>" } }, new RequestsStore { Date = DateTime.Now.AddDays(-3), StatusId = 1, Comments = "Заявка создана", Requests = new Requests { CreateDate = DateTime.Now.AddDays(-3), Name = "What is Lorem Ipsum?", Content = "<ul><li>Sed venenatis dui molestie libero elementum ultrices.</li><li>Vestibulum placerat risus eu odio accumsan viverra.</li><li>Nullam et sem ut purus egestas rutrum.</li><li>Praesent auctor tellus et mi rutrum, vel lacinia tortor luctus.</li><li>Nam at tortor euismod, gravida mi fringilla, laoreet magna.</li><li>Maecenas dictum ligula eu nibh mattis, eu pulvinar mi sodales.</li></ul>" } }, new RequestsStore { Date = DateTime.Now.AddDays(-2), StatusId = 1, Comments = "Заявка создана", Requests = new Requests { CreateDate = DateTime.Now.AddDays(-2), Name = "Lorem ipsum dolor sit amet.", Content = "<ul><li>Sed venenatis dui molestie libero elementum ultrices.</li><li>Vestibulum placerat risus eu odio accumsan viverra.</li><li>Nullam et sem ut purus egestas rutrum.</li><li>Praesent auctor tellus et mi rutrum, vel lacinia tortor luctus.</li><li>Nam at tortor euismod, gravida mi fringilla, laoreet magna.</li><li>Maecenas dictum ligula eu nibh mattis, eu pulvinar mi sodales.</li></ul>" } }, new RequestsStore { Date = DateTime.Now.AddDays(-1), StatusId = 1, Comments = "Заявка создана", Requests = new Requests { CreateDate = DateTime.Now.AddDays(-1), Name = "Lorem ipsum dolor sit amet, consectetur adipiscing.", Content = "<ul><li>Sed venenatis dui molestie libero elementum ultrices.</li><li>Vestibulum placerat risus eu odio accumsan viverra.</li><li>Nullam et sem ut purus egestas rutrum.</li><li>Praesent auctor tellus et mi rutrum, vel lacinia tortor luctus.</li><li>Nam at tortor euismod, gravida mi fringilla, laoreet magna.</li><li>Maecenas dictum ligula eu nibh mattis, eu pulvinar mi sodales.</li></ul>" } }, }; foreach (var item in requestStore) { context.RequestsStore.Add(item); } context.SaveChanges(); }
public void Create(Payout payout) { context.Payouts.Add(payout); context.SaveChanges(); }
public void register(ItemQB i) { context.QBItems.Add(i); context.SaveChanges(); }
public void AddUser(User user) { contex.Users.Add(user); contex.SaveChanges(); }
public void AddCart(Cart cart) { _context.Carts.Add(cart); _context.SaveChanges(); }