public static void InsertProductsMovingToEntity(ProductsMoving prMove) { using (var db = new Shop_2Entities()) { db.ProductsMoving.Add(prMove); db.SaveChanges(); } }
public static void InsertUserRolesToEntity(UserRoles userRoles) { using (var db = new Shop_2Entities()) { db.UserRoles.Add(userRoles); db.SaveChanges(); } }
public static void InsertProductsToEntity(Products products) { using (var db = new Shop_2Entities()) { db.Products.Add(products); db.SaveChanges(); } }
public static void DeleteUserRolesToEntity(int id) { using (var db = new Shop_2Entities()) { db.UserRoles.Remove(db.UserRoles.First(it => it.id == id)); db.SaveChanges(); } }
public static void DeleteProductsMovingToEntity(int id) { using (var db = new Shop_2Entities()) { db.ProductsMoving.Remove(db.ProductsMoving.First(it => it.id == id)); db.SaveChanges(); } }
public static void UpdateUserRolesToEntity(UserRoles userRoles) { using (var db = new Shop_2Entities()) { db.UserRoles.First(it => it.id == userRoles.id).Role = userRoles.Role; db.SaveChanges(); } }
public static void UpdateUsersToEntity(Users users) { using (var db = new Shop_2Entities()) { var newusers = db.Users.First(it => it.id == users.id); newusers.Login = users.Login; newusers.Passwword = users.Passwword; newusers.idRole = users.idRole; db.SaveChanges(); } }
public static void UpdateProductsMovingToEntity(ProductsMoving prMove) { using (var db = new Shop_2Entities()) { var newproducts = db.ProductsMoving.First(it => it.id == prMove.id); newproducts.idProduct = prMove.idProduct; newproducts.CountShop = prMove.CountShop; newproducts.CountStore = prMove.CountStore; newproducts.Sold = prMove.Sold; db.SaveChanges(); } }
public static void UpdateProductsToEntity(Products products) { using (var db = new Shop_2Entities()) { var newproducts = db.Products.First(it => it.id == products.id); newproducts.Name = products.Name; newproducts.PriceBuy = products.PriceBuy; newproducts.PriceSell = products.PriceSell; newproducts.UoM = products.UoM; db.SaveChanges(); } }