public ORDER GetOrder(int orderId)
{
using (var _db = new SiriusIQEntities2())
{
return(_db.ORDERs.ToList().FirstOrDefault(p => p.ORDERID == orderId));
}
}
public IEnumerable <ORDER> GetAll()
{
using (var _db = new SiriusIQEntities2())
{
return(_db.ORDERs.ToList());
}
}
public IEnumerable <PRODUCT> GetAll()
{
using (var _db = new SiriusIQEntities2())
{
return(_db.PRODUCTs.ToList());
}
}
public PRODUCT GetProduct(int productId)
{
using (var _db = new SiriusIQEntities2())
{
return(_db.PRODUCTs.ToList().FirstOrDefault(p => p.PRODUCTID == productId));
}
}
public bool UpdateOrder(ORDER order)
{
using (var _db = new SiriusIQEntities2())
{
_db.Entry(order);
int state = _db.SaveChanges();
return(state == 0 ? false : true);
}
}
public bool AddOrder(ORDER orderBusiness)
{
using (var _db = new SiriusIQEntities2())
{
_db.ORDERs.Add(orderBusiness);
int state = _db.SaveChanges();
return(state == 0 ? false : true);
}
}
public bool UpdateProduct(PRODUCT product)
{
using (var _db = new SiriusIQEntities2())
{
_db.Entry(product);
int state = _db.SaveChanges();
return(state == 0 ? false : true);
}
}
public bool DeleteOrder(int orderId)
{
using (var _db = new SiriusIQEntities2())
{
_db.ORDERs.Remove(new ORDER {
ORDERID = orderId
});
int state = _db.SaveChanges();
return(state == 0 ? false : true);
}
}
public bool DeleteProduct(int productId)
{
using (var _db = new SiriusIQEntities2())
{
_db.PRODUCTs.Remove(new PRODUCT {
PRODUCTID = productId
});
int state = _db.SaveChanges();
return(state == 0 ? false : true);
}
}
