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