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