public override bool Delete(Product obj)
{
using (RequestItEntities db = new RequestItEntities())
{
Product product = (from p in db.Products
where p.id == obj.id
select p).FirstOrDefault();
db.Products.Remove(product);
return(db.SaveChanges() > 0);
}
}
public override bool Delete(RequestsItem obj)
{
using (RequestItEntities db = new RequestItEntities())
{
RequestsItem requestItem = (from ri in db.RequestsItems
where ri.id == obj.id
select ri).FirstOrDefault();
db.RequestsItems.Remove(requestItem);
return(db.SaveChanges() > 0);
}
}
public override bool Delete(CompoundProduct obj)
{
using (RequestItEntities db = new RequestItEntities())
{
CompoundProduct compoundProduct = (from cp in db.CompoundProducts
where cp.id == obj.id
select cp).FirstOrDefault();
db.CompoundProducts.Remove(compoundProduct);
return(db.SaveChanges() > 0);
}
}
public bool DeleteByRequestId(int requestId)
{
using (RequestItEntities db = new RequestItEntities())
{
List <RequestsItem> requestItems = (from ri in db.RequestsItems
where ri.requestId == requestId
select ri).ToList();
foreach (RequestsItem requestItem in requestItems)
{
db.RequestsItems.Remove(requestItem);
}
return(db.SaveChanges() > 0);
}
}
public override bool Save(bool Insert, RequestsItem obj)
{
using (RequestItEntities db = new RequestItEntities())
{
if (Insert)
{
db.RequestsItems.Add(obj);
}
else
{
db.RequestsItems.Attach(obj);
db.Entry(obj).State = EntityState.Modified;
}
return(db.SaveChanges() > 0);
}
}