public Item GetProduct(int id) { using (var _itemEntity = new ShopBridgeDBEntities()) { return(_itemEntity.Items.FirstOrDefault(x => x.ItemID == id)); } }
public bool DeleteProduct(int id) { using (var _prodEntity = new ShopBridgeDBEntities()) { var _prod = _prodEntity.Items.Where(x => x.ItemID == id).FirstOrDefault(); if (_prod != null) { _prodEntity.Entry(_prod).State = EntityState.Deleted; _prodEntity.SaveChanges(); } } return(true); }
public int DeleteItem(int id) { using (var context = new ShopBridgeDBEntities()) { ItemMaster item = context.ItemMasters.Where(x => x.Id == id).FirstOrDefault(); if (item != null) { context.ItemMasters.Remove(item); context.SaveChanges(); return(item.Id); } return(0); } }
public void Delete() { //Arrange HomeController controller = new HomeController(); using (var context = new ShopBridgeDBEntities()) { TestID = context.ItemMasters.Where(x => x.Name == "Test" && x.Description == null). Select(x => x.Id).FirstOrDefault(); } //Act ViewResult view = controller.Delete(TestID) as ViewResult; //Assert Assert.IsNotNull(view); }
public bool AddProduct(Item _item) { using (var _itemEntity = new ShopBridgeDBEntities()) { if (_item != null) { _itemEntity.Items.Add(_item); _itemEntity.SaveChanges(); return(true); } else { return(false); } } }
public int UpdateItem(ItemModel model) { using (var context = new ShopBridgeDBEntities()) { ItemMaster item = context.ItemMasters.Where(x => x.Id == model.Id).FirstOrDefault(); item.Id = model.Id; item.Name = model.Name; item.Description = model.Description; item.Price = model.Price; item.Photo = model.Photo; context.SaveChanges(); return(item.Id); } }
public List <Items> GetProductList() { using (var _itemEntity = new ShopBridgeDBEntities()) { var _list = (from p in _itemEntity.Items select new Items { Id = p.ItemID, Name = p.Name, Price = (int)p.Price, Description = p.Description, ImageName = p.ImageName, Base64Content = p.Base64Content }).ToList(); return(_list); } }
public int AddItem(ItemModel model) { using (var context = new ShopBridgeDBEntities()) { ItemMaster item = new ItemMaster() { Id = model.Id, Name = model.Name, Description = model.Description, Price = model.Price, Photo = model.Photo }; context.ItemMasters.Add(item); context.SaveChanges(); return(item.Id); } }
public bool UpdateProduct(Item _item) { using (var _prodEntity = new ShopBridgeDBEntities()) { var _prod = _prodEntity.Items.Where(x => x.ItemID == _item.ItemID).FirstOrDefault(); if (_prod != null) { _prod.Name = _item.Name; _prod.Price = _item.Price; _prod.Description = _item.Description; _prod.ImageName = _item.ImageName; _prod.Base64Content = _item.Base64Content; _prodEntity.SaveChanges(); } } return(true); }
public ItemModel GetItem(int id) { ItemModel model = new ItemModel(); using (var context = new ShopBridgeDBEntities()) { model = context.ItemMasters.Where(x => x.Id == id).Select(x => new ItemModel() { Id = x.Id, Name = x.Name, Description = x.Description, Photo = x.Photo, Price = x.Price } ).FirstOrDefault(); } return(model); }
public List <ItemModel> GetAllItems() { List <ItemModel> models = new List <ItemModel>(); using (var context = new ShopBridgeDBEntities()) { models = context.ItemMasters.Select(x => new ItemModel() { Id = x.Id, Name = x.Name, Description = x.Description, Photo = x.Photo, Price = x.Price } ).ToList(); } return(models); }
public void EditItem() { //Arrange HomeController controller = new HomeController(); ItemModel itemModel = new ItemModel(); using (var context = new ShopBridgeDBEntities()) { TestID = context.ItemMasters.Where(x => x.Name == "Test" && x.Description == null). Select(x => x.Id).FirstOrDefault(); } itemModel.Id = TestID; itemModel.Name = "Test"; //Act ViewResult view = controller.Edit(itemModel) as ViewResult; TestID = view.ViewBag.Id; //Assert Assert.AreNotEqual(0, TestID); }
public List <Items> SearchProductList(string searchTerm) { using (var _prodEntity = new ShopBridgeDBEntities()) { if (searchTerm.Trim() != null) { var list = _prodEntity.SearchItem(searchTerm).ToList <SearchItem_Result>(); var result = list.Select(x => new Items() { Name = x.Name, Price = (int)x.Price, Description = x.Description, ImageName = x.ImageName, Base64Content = x.Base64Content }).ToList <Items>(); return(result); } } return(null); }