public object GetAllProducts()
{
PractiseEntities db = new PractiseEntities();
return((from prod in db.eProducts
select new {
Id = prod.Id,
Name = prod.Name
}).ToList());
//return lseProduct;
}
public int GetProductPrice(int nId)
{
PractiseEntities db = new PractiseEntities();
int nPrice = -1;
nPrice = (from prod in db.eProducts
where prod.Id == nId
select prod).Single().Price;
return(nPrice);
}
public List <Models.OrderDetV> GetOrderDets(long Id)
{
PractiseEntities db = new PractiseEntities();
List <Models.OrderDetV> lsOrderDetV;
lsOrderDetV = (from prod in db.eProducts
join ordt in db.eOrderDets on prod.Id equals ordt.ProductId
select new OrderDetV
{
Name = prod.Name,
Price = prod.Price,
Total = ordt.Total,
GrantTotal = prod.Price * ordt.Total,
}).ToList();
return(lsOrderDetV);
}
public bool SaveRec(eOrderMaster oeOrderMaster)
{
bool bOk = true;
PractiseEntities db = new PractiseEntities();
oeOrderMaster.CrtDt = DateTime.Now;
try
{
db.eOrderMasters.Add(oeOrderMaster);
db.SaveChanges();
return(bOk = true);
}
catch (Exception ex)
{
var msg = ex.Message;
return(bOk = false);
}
}
