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