public void AddTicket(Ticket t)
{
using (CaisseContext db = new CaisseContext())
{
db.Tickets.Add(t);
db.SaveChanges();
}
}
public bool RemoveProductDB(Product p)
{
using (CaisseContext db = new CaisseContext())
{
var user = db.Products.Remove(p);
db.SaveChanges();
}
return(true);
}
public User GetUserfromCredentials(string username, string password)
{
using (CaisseContext db = new CaisseContext())
{
var userSelected = db.Users.SingleOrDefault(user => user.Username == username && user.Md5password == password);
db.SaveChanges();
return(userSelected);
}
}
public Collection <Ticket> GetTicketsDB()
{
using (CaisseContext db = new CaisseContext())
{
var ticketList = new Collection <Ticket>(db.Tickets.ToList());
db.SaveChanges();
return(ticketList);
}
}
public Collection <Product> GetProductList()
{
using (CaisseContext db = new CaisseContext())
{
var productList = new Collection <Product>(db.Products.ToList());
db.SaveChanges();
return(productList);
}
}
public Product GetProductByID(int id)
{
using (CaisseContext db = new CaisseContext())
{
var product = db.Products.SingleOrDefault(p => p.ID == id);
db.SaveChanges();
return(product);
}
}
public Collection <BDE> GetBDEList()
{
using (CaisseContext db = new CaisseContext())
{
var bdeSelected = new Collection <BDE>(db.BDEs.ToList());
db.SaveChanges();
return(bdeSelected);
}
}
public BDE GetBDEByID(int id)
{
using (CaisseContext db = new CaisseContext())
{
var bdeSelected = db.BDEs.SingleOrDefault(bde => bde.ID == id);
db.SaveChanges();
return(bdeSelected);
}
}
public void ChangeStyle(User u, string theme, string style)
{
using (CaisseContext db = new CaisseContext())
{
var user = u;
user.Accent = style;
user.Theme = theme;
db.SaveChanges();
}
}
public bool UpdateProductDB(Product p)
{
using (CaisseContext db = new CaisseContext())
{
var itemToRemove = db.Products.SingleOrDefault(x => x.ID == p.ID);
db.Products.Remove(p);
db.Products.Add(p);
db.SaveChanges();
}
return(true);
}
