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