public List <productDetail> FindAll()
{
using (ProductEntities pre = new ProductEntities()) {
return(pre.productDetails.Select(pe => new productDetail
{
Id = pe.Id,
productName = pe.productName,
productPrice = pe.productPrice,
productQuantity = pe.productQuantity,
productExpDate = pe.productExpDate,
Category = pe.Category
}).ToList());
};
}
public productDetail Find(int id)
{
using (ProductEntities pre = new ProductEntities())
{
return(pre.productDetails.Where(pe => pe.Id == id).Select(pe => new productDetail
{
Id = pe.Id,
productName = pe.productName,
productPrice = pe.productPrice,
productQuantity = pe.productQuantity,
productExpDate = pe.productExpDate,
Category = pe.Category
}).First());
};
}
public bool Delete(productDetail Product)
{
using (ProductEntities pre = new ProductEntities())
{
try
{
int id = Convert.ToInt32(Product.Id);
productDetail pd = pre.productDetails.Single(p => p.Id == id);
pre.productDetails.Remove(pd);
pre.SaveChanges();
return(true);
}
catch
{
return(false);
}
};
}
public bool Edit(productDetail Product)
{
using (ProductEntities pre = new ProductEntities())
{
try
{
int id = Convert.ToInt32(Product.Id);
productDetail pd = pre.productDetails.Single(p => p.Id == id);
pd.productName = Product.productName;
pd.productPrice = Product.productPrice;
pd.productQuantity = Product.productQuantity;
pd.productExpDate = Product.productExpDate;
pd.Category = Product.Category;
pre.SaveChanges();
return(true);
}
catch
{
return(false);
}
};
}
public bool Create(productDetail Product)
{
using (ProductEntities pre = new ProductEntities())
{
try
{
productDetail pd = new productDetail();
pd.productName = Product.productName;
pd.productPrice = Product.productPrice;
pd.productQuantity = Product.productQuantity;
pd.productExpDate = Product.productExpDate;
pd.Category = Product.Category;
pre.productDetails.Add(pd);
pre.SaveChanges();
return(true);
}
catch
{
return(false);
}
};
}