public void AddProduct(Product newProduct)
{
using (var db = new WorkDbContext())
{
db.ProductTabel.Add(newProduct);
db.SaveChanges();
}
}
public void CreateStockTask(StockTask newItem)
{
using (var db = new WorkDbContext())
{
db.StockItemTable.Add(newItem);
db.SaveChanges();
}
}
public void AddDay(WorkDay newDay)
{
using (var db = new WorkDbContext())
{
db.WorkDayTable.Add(newDay);
db.SaveChanges();
}
}
public void DeleteProduct(int id)
{
using (var db = new WorkDbContext())
{
var product = db.ProductTabel.Find(id);
db.ProductTabel.Remove(product);
db.SaveChanges();
}
}
public void DeleteWorkDay(int id)
{
using (var db = new WorkDbContext())
{
var day = db.WorkDayTable.Find(id);
db.WorkDayTable.Remove(day);
db.SaveChanges();
}
}
public void DeleteStockTask(int id)
{
using (var db = new WorkDbContext())
{
var task = db.StockItemTable.Find(id);
db.StockItemTable.Remove(task);
db.SaveChanges();
}
}
public void EditProduct(Product updatedProduct)
{
using (var db = new WorkDbContext())
{
db.ProductTabel.Attach(updatedProduct);
var entry = db.Entry(updatedProduct);
entry.State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void EditWorkDay(WorkDay dayEdit)
{
using (var db = new WorkDbContext())
{
db.WorkDayTable.Attach(dayEdit);
var entry = db.Entry(dayEdit);
entry.State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void UpdateStockTask(StockTask updatedTask)
{
using (var db = new WorkDbContext())
{
db.StockItemTable.Attach(updatedTask);
var entry = db.Entry(updatedTask);
entry.State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}