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