public List <Products> GetProducts(int pageIndex, int pageSize)
{
ProductList ProductList = new ProductList();
List <Products> listPrd = new List <Products>();
ObjectResult <GetProducts_Result> queryResults = null;
using (var context = new ProductDbEntities())
{
try
{
queryResults = context.GetProducts(pageIndex, pageSize);
foreach (var product in queryResults)
{
listPrd.Add(new Products
{
description = product.description, productId = product.productId, productCode = product.productCode, price = (float)product.price, productName = product.productName, starRating = (float)product.starRating, imageUrl = product.imageUrl, releaseDate = product.releaseDate
});
}
//dr.NextResult();
//while (dr.Read())
//{
// ProductList.totalCount = dr["totalCount"].ToString();
//}
//ProductList.products = listPrd;
}
catch (Exception ex)
{
throw;
}
return(listPrd);
}
}
public void deleteProduct(int productid)
{
using (var context = new ProductDbEntities())
{
var prd = new Product {
productId = productid
};
context.Products.Attach(prd);
context.Products.Remove(prd);
context.SaveChanges();
}
}
public Products getProduct(int ID)
{
using (var context = new ProductDbEntities())
{
ObjectResult <GetProduct_Result> prd = context.GetProduct(ID);
Products result = new Products();
foreach (var product in prd)
{
result = new Products {
description = product.description, productId = product.productId, productCode = product.productCode, price = (float)product.price, productName = product.productName, starRating = (float)product.starRating, imageUrl = product.imageUrl, releaseDate = product.releaseDate
};
}
return(result);
}
}
public string SaveProduct(Products product)
{
using (var context = new ProductDbEntities())
{
var result = context.Products.Add(
new Product {
productName = product.productName,
productCode = product.productCode,
releaseDate = product.releaseDate,
description = product.description,
starRating = product.starRating,
imageUrl = product.imageUrl,
price = product.price
});
context.SaveChanges();
if (result.productId != 0)
{
return("Success");
}
return("Error");
}
}
static DatabaseAccessor()
{
entities = new ProductDbEntities();
entities.Database.Connection.Open();
}