public Brand GetBrandByID(int ID) { using (var context = new BrandShopContext()) { return(context.Brands.Find(ID)); } }
public MainMenu GetMainMenuByID(int ID) { using (var context = new BrandShopContext()) { return(context.MainMenus.Find(ID)); } }
public Product GetProductByID(int ID) { using (var context = new BrandShopContext()) { return(context.Products.Find(ID)); } }
public Tag GetTagByID(int ID) { using (var context = new BrandShopContext()) { return(context.Tags.Find(ID)); } }
public Supplier GetSupplierByID(int ID) { using (var context = new BrandShopContext()) { return(context.Suppliers.Find(ID)); } }
//public IEnumerable<User> SearchUsers(string SearchTerm) //{ // var context = new BrandShopContext(); // var user = context.Users.AsQueryable(); // if (!string.IsNullOrEmpty(SearchTerm)) // { // user = (from u in context.Users where u.UserName.Contains(SearchTerm) || u.Description.Contains(SearchTerm) select u); // } // return user.ToList(); //} public User GetUserByID(int ID) { using (var context = new BrandShopContext()) { return(context.Users.Find(ID)); } }
public bool SaveSubMenu(SubMenu subMenu) { var context = new BrandShopContext(); context.SubMenus.Add(subMenu); return(context.SaveChanges() > 0); }
public bool DeleteMenu(MainMenu mainMenu) { var context = new BrandShopContext(); context.Entry(mainMenu).State = System.Data.Entity.EntityState.Deleted; return(context.SaveChanges() > 0); }
public bool SaveMenu(MainMenu mainMenu) { var context = new BrandShopContext(); context.MainMenus.Add(mainMenu); return(context.SaveChanges() > 0); }
public bool DeleteSupplier(Supplier supplier) { var context = new BrandShopContext(); context.Entry(supplier).State = System.Data.Entity.EntityState.Deleted; return(context.SaveChanges() > 0); }
public bool DeleteBrand(Brand brand) { var context = new BrandShopContext(); context.Entry(brand).State = System.Data.Entity.EntityState.Deleted; return(context.SaveChanges() > 0); }
public bool DeleteRole(Role role) { var context = new BrandShopContext(); context.Entry(role).State = System.Data.Entity.EntityState.Deleted; return(context.SaveChanges() > 0); }
public bool DeleteProduct(Product product) { var context = new BrandShopContext(); context.Entry(product).State = System.Data.Entity.EntityState.Deleted; return(context.SaveChanges() > 0); }
public bool SaveProduct(Product product) { var context = new BrandShopContext(); context.Products.Add(product); return(context.SaveChanges() > 0); }
public bool SavePicture(Picture pictures) { var context = new BrandShopContext(); context.Pictures.Add(pictures); return(context.SaveChanges() > 0); }
public bool SaveUser(User user) { var context = new BrandShopContext(); context.Users.Add(user); return(context.SaveChanges() > 0); }
public bool UpdateUser(User user) { var context = new BrandShopContext(); context.Entry(user).State = System.Data.Entity.EntityState.Modified; return(context.SaveChanges() > 0); }
public bool SaveTag(Tag tag) { var context = new BrandShopContext(); context.Tags.Add(tag); return(context.SaveChanges() > 0); }
public bool SaveBrand(Brand brand) { var context = new BrandShopContext(); context.Brands.Add(brand); return(context.SaveChanges() > 0); }
public bool UpdateTag(Tag tag) { var context = new BrandShopContext(); context.Entry(tag).State = System.Data.Entity.EntityState.Modified; return(context.SaveChanges() > 0); }
public bool SaveSupplier(Supplier supplier) { var context = new BrandShopContext(); context.Suppliers.Add(supplier); return(context.SaveChanges() > 0); }
public bool SaveRole(Role role) { var context = new BrandShopContext(); context.Roles.Add(role); return(context.SaveChanges() > 0); }
public JsonResult GetSubMenuByMainMenu(int MainMenuID) { var context = new BrandShopContext(); context.Configuration.ProxyCreationEnabled = false; var SubMenuList = context.SubMenus.Where(x => x.MainMenuID == MainMenuID).ToList(); return(Json(SubMenuList, JsonRequestBehavior.AllowGet)); }
public IEnumerable <SubMenu> SearchSubMenus(string SearchTerm) { var context = new BrandShopContext(); var subMenus = context.SubMenus.AsQueryable(); if (!string.IsNullOrEmpty(SearchTerm)) { subMenus = (from s in context.SubMenus where s.SubMenuName.Contains(SearchTerm) || s.Description.Contains(SearchTerm) select s); } return(subMenus.ToList()); }
public IEnumerable <MainMenu> SearchMainMenus(string SearchTerm) { var context = new BrandShopContext(); var mainMenu = context.MainMenus.AsQueryable(); if (!string.IsNullOrEmpty(SearchTerm)) { mainMenu = (from u in context.MainMenus where u.MainMenuName.Contains(SearchTerm) || u.Description.Contains(SearchTerm) select u); } return(mainMenu.ToList()); }
public bool UpdateSubMenu(SubMenu subMenu) { var context = new BrandShopContext(); var exitingSubMenu = context.SubMenus.Find(subMenu.SubMenuID); context.SubMenuPictures.RemoveRange(exitingSubMenu.SubMenuPictures); context.Entry(exitingSubMenu).CurrentValues.SetValues(subMenu); context.SubMenuPictures.AddRange(subMenu.SubMenuPictures); //context.Entry(subMenu).State = System.Data.Entity.EntityState.Modified; return(context.SaveChanges() > 0); }
public ActionResult AddAndEdit(int?ID) { ProductsActionModel model = new ProductsActionModel(); if (ID.HasValue) { var product = productServices.GetProductByID(ID.Value); model.ProductID = product.ProductID; model.MainMenuID = product.MainMenuID; model.SubMenuID = product.SubMenuID; model.BrandID = product.BrandID; model.ProductName = product.ProductName; model.ProductCode = product.ProductCode; model.BuyingPrice = product.BuyingPrice; model.RegularPrice = product.RegularPrice; model.DiscountPrice = product.DiscountPrice; model.ProductQuantity = product.ProductQuantity; model.Color = product.Color; model.Config = product.Config; model.Description = product.Description; model.IsAvailable = product.IsAvailable; model.IsFeatured = product.IsFeatured; model.SupplierID = product.SupplierID; model.TagID = product.TagID; } var context = new BrandShopContext(); List <MainMenu> MainMenuList = context.MainMenus.ToList(); ViewBag.MainMenuList = new SelectList(MainMenuList, "MainMenuID", "MainMenuName"); model.MainMenus = mainServices.GetAllMainMenus(); model.SubMenus = subServices.GetSubMenuByMainMenu(model.MainMenuID); model.Brands = brandServices.GetAllBrands(); model.Tags = tagServices.GetAllTags(); model.Suppliers = supplierServices.GetAllSuppliers(); return(PartialView("_AddAndEdit", model)); }
public IEnumerable <Picture> GetPictureByIDs(List <int> pictureIDs) { var context = new BrandShopContext(); return(pictureIDs.Select(x => context.Pictures.Find(x)).ToList()); }
public Role GetRoleByID(int ID) { var context = new BrandShopContext(); return(context.Roles.Find(ID)); }
public IEnumerable <Role> GetAllRoles() { var context = new BrandShopContext(); return(context.Roles.ToList()); }