/// <summary>
/// Libera los recursos asignados para este contexto.
/// </summary>
protected override void DisposeCore()
{
if (dbContext != null)
{
dbContext.Dispose();
}
}
public void Dispose()
{
if (dbContext != null)
{
dbContext.Dispose();
}
}
protected override void Dispose(bool disposing)
{
if (disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
protected virtual void Dispose(bool disposing)
{
if (!this.disposed)
{
if (disposing)
{
context.Dispose();
}
}
this.disposed = true;
}
public Product GetSaleProductById(int productId)
{
StoreEntities db = new StoreEntities();
var item = db.SalesProducts.ToList().Where(x => x.Id == productId).FirstOrDefault();
Product product = new Product()
{
Id = item.Id,
ProductDescription = item.Product_Description,
ProductName = item.Product_Name,
ProductPrice = item.Product_Price,
ProductQuantity = item.Product_Quantity
};
db.Dispose();
return(product);
}
public List <Product> GetAllSalesProducts()
{
StoreEntities db = new StoreEntities();
var salesProductList = db.SalesProducts.ToList();
List <Product> productsList = new List <Product>();
foreach (var item in salesProductList)
{
Product product = new Product()
{
Id = item.Id,
ProductDescription = item.Product_Description,
ProductName = item.Product_Name,
ProductPrice = item.Product_Price,
ProductQuantity = item.Product_Quantity
};
productsList.Add(product);
}
db.Dispose();
return(productsList);
}