public Models.Engine Add(Models.Engine item) { if (!_context.Engine.Any(q => q.vin.ToLower().Equals(item.vin.ToLower()))) { _context.Engine.Add(item); _context.SaveChanges(); } return(Get(item.vin)); }
private bool SaveChanges() { bool changesSaved = _dbContext.SaveChanges() > 0; CloseConnection(); return(changesSaved); }
public async Task <ActionResult <IEnumerable <Models.Order> > > GetOrders() { var res = await _context.Orders.Include(s => s.OrderRows).ToListAsync(); #region AddTestData if (res == null || res?.Count == 0) { res = new List <Order>(); res.Add(new Order()); res[0].OrderRows.Add(new OrderRow { OrderRowID = Guid.NewGuid(), Order = res[0], OrderID = res[0].OrderID, ProductName = "Product 1", ProductPrice = (decimal)23.0, ProductQuantity = 12 });; res[0].OrderRows.Add(new OrderRow { OrderRowID = Guid.NewGuid(), Order = res[0], OrderID = res[0].OrderID, ProductName = "Product 2", ProductPrice = (decimal)25.5, ProductQuantity = 16 }); res.Add(new Order()); res[1].OrderRows.Add(new OrderRow { OrderRowID = Guid.NewGuid(), Order = res[1], OrderID = res[1].OrderID, ProductName = "Product 2_1", ProductPrice = (decimal)0.3, ProductQuantity = 19 });; res[1].OrderRows.Add(new OrderRow { OrderRowID = Guid.NewGuid(), Order = res[1], OrderID = res[1].OrderID, ProductName = "Product 2_2", ProductPrice = (decimal)125.5, ProductQuantity = 3 }); _context.Orders.AddRange(res); _context.SaveChanges(); res = await _context.Orders.ToListAsync(); } #endregion return(res); }
public static void DeleteNewNetworkTest() { using (var db = new Data.DataContext()) { var removeNetwork = db.Networks.Find(NewNetworkID); db.Networks.Remove(removeNetwork); db.SaveChanges(); var deletedOrg = db.Networks.Find(NewNetworkID); Assert.IsTrue(deletedOrg.IsEmpty()); Logger.Debug(String.Format("Network {0} was successfully Deleted", removeNetwork.Name)); } }
public static void UpdateNewNetworkTest() { using (var db = new Data.DataContext()) { var network = db.Networks.Find(NewNetworkID); network.Name = network.Name + " Test Update"; db.SaveChanges(); var updated = db.Networks.Find(NewNetworkID); Assert.AreEqual(updated, network); Logger.Debug(String.Format("Network {0} was successfully Updated", network.Name)); } }
//public void UpdateQuantity(int id, int qty) //{ // ApplicationDbContext db = new ApplicationDbContext(); // var qytUpdate = db.Items.Find(id); // qytUpdate.QuantityInStock = qytUpdate.QuantityInStock - qty; //} public bool UpdateItem(Item item) { try { Data.DataContext db = new Data.DataContext(); db.Entry(item).State = EntityState.Modified; db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool UpdateDepartment(Department department) { try { Data.DataContext db = new Data.DataContext(); db.Entry(department).State = EntityState.Modified; db.SaveChanges(); //dataContext.Update(department); return(true); } catch (Exception) { return(false); } }
public Detalles Post(Detalles valor) { if (valor.Id == 0) { _context.Detalles.Add(valor); } else { _context.Detalles.Attach(valor); _context.Detalles.Update(valor); } _context.SaveChanges(); return(valor); }
//bætir kommenti hjá bók public void AddReview(ReviewInputModel r) { var review = new Review { BookId = r.BookId, CommentText = r.CommentText, Stars = r.Stars, UserId = r.UserId, UserName = r.UserName, time = DateTime.Now }; db.Add(review); db.SaveChanges(); }
public Tareas Post(Tareas valor) { if (valor.Id == 0) { _context.Tareas.Add(valor); } else { _context.Tareas.Attach(valor); _context.Tareas.Update(valor); } _context.SaveChanges(); return(valor); }
public Usuarios Post(Usuarios valor) { if (valor.Id == 0) { _context.Usuarios.Add(valor); } else { _context.Usuarios.Attach(valor); _context.Usuarios.Update(valor); } _context.SaveChanges(); return(valor); }
public Recursos Post(Recursos valor) { if (valor.Id == 0) { _context.Recursos.Add(valor); } else { _context.Recursos.Attach(valor); _context.Recursos.Update(valor); } _context.SaveChanges(); return(valor); }
//bætir order í cart public void AddToCart(OrderInputModel order) { var newOrder = new CartOrder() { amount = order.amount, UserId = order.UserId, ExpirationTime = order.ExpirationTime, BookId = order.BookId }; db.Carts.Add(newOrder); db.SaveChanges(); }
public void Add(Models.SensorData item) { _context.SensorData.Add(item); _context.SaveChanges(); }