public void TestGetAllItems()
{
var controller = new ItemsController();
IHttpActionResult actionResult = controller.GetItems();
var contentResult = actionResult as OkNegotiatedContentResult <List <ItemBO> >;
Assert.IsNotNull(contentResult);
List <Item> items;
using (ShopBridgeEntities db = new ShopBridgeEntities())
{
items = db.Items.ToList();
}
List <ItemBO> itemBOs = new List <ItemBO>();
foreach (var item in items)
{
itemBOs.Add(new ItemBO
{
Id = item.ItemId,
Name = item.Name,
Description = item.ItemDescription,
Price = item.Price.Value,
AddedOn = item.AddedOn.Value,
ItemImage = item.ImageData
});
}
Assert.AreEqual(itemBOs.Count, contentResult.Content.Count);
}
public ActionResult AddComponent(component model, HttpPostedFileBase Image1)
{
var db = new ShopBridgeEntities();
if (model.Discription != null && model.Name != null && model.Price != 0 && Image1 != null)
{
byte[] bytes;
using (BinaryReader br = new BinaryReader(Image1.InputStream))
{
bytes = br.ReadBytes(Image1.ContentLength);
}
db.components.Add(new component
{
Name = model.Name,
Price = model.Price,
Image = bytes,
Discription = model.Discription
});
db.SaveChanges();
return(RedirectToAction("CoponentHomePage"));
}
return(View());
}
public HttpResponseMessage CreateInventory(Inventory inventory)
{
HttpResponseMessage result = null;
try
{
if (ModelState.IsValid)
{
using (ShopBridgeEntities db = new ShopBridgeEntities())
{
db.Inventories.Add(inventory);
db.SaveChanges();
}
result = Request.CreateResponse(HttpStatusCode.Created, inventory);
}
else
{
result = Request.CreateResponse(HttpStatusCode.BadRequest, "Server failed to save data");
}
}
catch (Exception e)
{
}
return(result);
}
/// <summary>
/// Get inventory based on Id
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public Inventory GetInventory(int Id)
{
using (ShopBridgeEntities shopBridge = new ShopBridgeEntities())
{
return(shopBridge.Inventories.FirstOrDefault(x => x.Id == Id));
}
}
public ActionResult CoponentHomePage()
{
ShopBridgeEntities db = new ShopBridgeEntities();
var item = db.components.Select(u => u).ToList();
return(View(item));
}
/// <summary>
/// Get List of Inventory
/// </summary>
/// <returns></returns>
public IQueryable <Inventory> GetAllInventory()
{
using (ShopBridgeEntities shopBridge = new ShopBridgeEntities())
{
return(shopBridge.Inventories.ToList().AsQueryable());
}
}
public ActionResult Login(User user)
{
try
{
Custom cp = new Custom();
using (ShopBridgeEntities db = new ShopBridgeEntities())
{
user.Password = cp.Encrypt(user.Password);
var usr = db.Users.SingleOrDefault(u => u.Username == user.Username && u.Password == user.Password);
if (usr != null)
{
Session["UserId"] = usr.UserId.ToString();
Session["Username"] = usr.Username.ToString();
Session["RoleId"] = usr.RoleId.ToString();
return(RedirectToAction("Index", "Home"));
}
else
{
ModelState.AddModelError("", "Username or Password is wrong");
}
}
return(View());
}
catch (Exception ex)
{
throw ex;
}
}
public void TestGetItemById()
{
var controller = new ItemsController();
var actionResult = controller.GetItemById(1);
var contentResult = actionResult as OkNegotiatedContentResult <ShopBridge_API.Models.ItemBO>;
Assert.IsNotNull(contentResult);
Item item;
using (ShopBridgeEntities db = new ShopBridgeEntities())
{
item = db.Items.SingleOrDefault(x => x.ItemId.Equals(1));
}
ItemBO itemBO = new ItemBO
{
Name = item.Name,
Description = item.ItemDescription,
Price = item.Price.Value,
AddedOn = DateTime.Now,
ItemImage = item.ImageData
};
var product = contentResult.Content;
Assert.AreEqual(itemBO.Name, contentResult.Content.Name);
}
public async Task <HttpResponseMessage> DeletingProducts(int productId)
{
try
{
using (ShopBridgeEntities entities = new ShopBridgeEntities())
{
var prod = entities.Products.Where(x => x.ProductId == productId).FirstOrDefault();
if (prod != null)
{
entities.Products.Remove(prod);
await Task.FromResult(entities.SaveChanges());
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "The product " + productId + " was not found"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public async Task <HttpResponseMessage> UpdatingProducts(int productId, [FromBody] Product products)
{
try
{
using (ShopBridgeEntities entities = new ShopBridgeEntities())
{
var prod = entities.Products.FirstOrDefault(x => x.ProductId == productId);
if (prod != null)
{
prod.Name = products.Name;
prod.Description = products.Description;
prod.Price = products.Price;
prod.ProdAddedDate = products.ProdAddedDate;
prod.Availability = products.Availability;
prod.Brand = products.Brand;
await Task.FromResult(entities.SaveChanges());
return(Request.CreateResponse(HttpStatusCode.OK, products));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "The product " + productId + " was not found to update"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public async Task <HttpResponseMessage> AllProducts()
{
using (ShopBridgeEntities entities = new ShopBridgeEntities())
{
return(await Task.FromResult(Request.CreateResponse(HttpStatusCode.OK, entities.Products.ToList())));
}
}
/// <summary>
/// Deletes Inventory based on Id
/// </summary>
/// <param name="Id">Inventory Id</param>
public void DeleteInventory(int Id)
{
using (ShopBridgeEntities shopBridge = new ShopBridgeEntities())
{
var inv = shopBridge.Inventories.Find(Id);
shopBridge.Inventories.Remove(inv);
shopBridge.SaveChanges();
}
}
public async Task <HttpResponseMessage> GetSpecificProduct(int productId)
{
using (ShopBridgeEntities entities = new ShopBridgeEntities())
{
var prods = await Task.FromResult(entities.Products.FirstOrDefault(e => e.ProductId == productId));
if (prods != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, prods));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "The Product " + productId + " is not found in the inventory"));
}
}
}
/// <summary>
/// Insert or update Inventory
/// </summary>
/// <param name="inventory">Inventory object</param>
public void SaveInventory(Inventory inventory)
{
using (ShopBridgeEntities shopBridge = new ShopBridgeEntities())
{
if (inventory.Id == 0)
{
shopBridge.Inventories.Add(inventory);
shopBridge.SaveChanges();
}
else
{
var data = shopBridge.Inventories.FirstOrDefault(x => x.Id == inventory.Id);
data.Name = inventory.Name;
data.Description = inventory.Description;
data.Price = inventory.Price;
shopBridge.SaveChanges();
}
}
}
public HttpResponseMessage GetInventoryList()
{
HttpResponseMessage result = null;
try
{
List <Inventory> lstinventorie = new List <Inventory>();
using (ShopBridgeEntities db = new ShopBridgeEntities())
{
lstinventorie = db.Inventories.ToList();
}
result = Request.CreateResponse(HttpStatusCode.OK, lstinventorie);
}
catch (Exception e)
{
}
return(result);
}
public async Task <HttpResponseMessage> AddingProduct([FromBody] Product products)
{
try
{
using (ShopBridgeEntities entities = new ShopBridgeEntities())
{
entities.Products.Add(products);
await Task.FromResult(entities.SaveChanges());
var msg = Request.CreateResponse(HttpStatusCode.Created, products);
msg.Headers.Location = new Uri(Request.RequestUri + products.Name.ToString());
return(msg);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public IHttpActionResult GetInventoryById(dynamic id)
{
Inventory inventory = null;
int Id = Convert.ToInt32(id);
try
{
using (ShopBridgeEntities db = new ShopBridgeEntities())
{
inventory = db.Inventories.SingleOrDefault(m => m.Id.Equals(Id));
}
if (inventory == null)
{
return(NotFound());
}
}
catch (Exception e)
{
}
return(Ok(inventory));
}
public HttpResponseMessage RemoveInventory(int?Id)
{
int id = Convert.ToInt32(Id);
try
{
if (Id <= 0)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
using (ShopBridgeEntities db = new ShopBridgeEntities())
{
var Inventory = db.Inventories.SingleOrDefault(m => m.Id.Equals(id));
db.Inventories.Remove(Inventory);
db.SaveChanges();
}
}
catch (Exception e)
{
}
return(Request.CreateResponse(HttpStatusCode.OK, id));
}
public ActionResult Register(User user)
{
try
{
Custom cp = new Custom();
if (ModelState.IsValid)
{
using (ShopBridgeEntities db = new ShopBridgeEntities())
{
user.RoleId = 2;
user.Password = cp.Encrypt(user.Password);
db.Users.Add(user);
db.SaveChanges();
}
ModelState.Clear();
ViewBag.Message = user.Username + " successfully registered. You may now login with your credential";
}
return(RedirectToAction("Login"));
}
catch (Exception ex)
{
throw ex;
}
}
public InventoryRepository()
{
this._shopBridgeEntities = new ShopBridgeEntities();
}
public ReviewsController()
{
db = new ShopBridgeEntities();
}
public HomeController()
{
db = new ShopBridgeEntities();
}
