public void Deleting(int ID) { using (var db = new LitteJohnsDBContext()) { var Removing = db.Users.SingleOrDefault(X => X.Id == ID); //Deleting function was provided by StackOverFlow in this link: https://stackoverflow.com/questions/17723276/delete-a-single-record-from-entity-framework db.Users.Remove(Removing); db.SaveChanges(); } }
public void MakeingPizzas(string NP, string crust, string s, Orders orders) { var Pie = new Pizza { NameofPizza = NP, Crust = crust, Sauce = s, Order = orders }; using (var db = new LitteJohnsDBContext()) { db.Update(Pie); db.SaveChanges(); } }
public void RegisterUser(string FN, string LN, string UN, int loc) { var User = new Users { FirstName = FN, LastName = LN, UserName = UN, LocationId = loc }; using (var db = new LitteJohnsDBContext()) { db.Update(User); db.SaveChanges(); } }
public void Ordering(DateTime OD, int PC, Locations loc, Users users, decimal P) { var order = new Orders { OrderDate = OD, PizzaCount = PC, Price = P, User = users, Location = loc }; using (var db = new LitteJohnsDBContext()) { db.Update(order); db.SaveChanges(); } }
public void AddLocation(string AL1, string AL2, string ZC) { var Local = new Locations { AdressLine1 = AL1, AdressLine2 = AL2, ZipCode = ZC }; using (var db = new LitteJohnsDBContext()) { db.Update(Local); db.SaveChanges(); } }
public void AddIventory(string NP, int Q, Locations loc) { var Inv = new Inventory { NameOfProduct = NP, Quantity = Q, Location = loc }; using (var db = new LitteJohnsDBContext()) { db.Update(Inv); db.SaveChanges(); } }
public void UpdateUser(int ID, string FN, string LN, string UN, Locations loc) { var User = new Users { Id = ID, FirstName = FN, LastName = LN, UserName = UN, Location = loc }; using (var db = new LitteJohnsDBContext()) { db.Update(User); db.SaveChanges(); } }
public Repository(LitteJohnsDBContext db) { _db = db ?? throw new ArgumentNullException(nameof(db)); }