public IEnumerable <T> GetById(int id)
{
using (var entity = new ModelDataEntities2())
{
return(entity.Set <T>().Where(x => x.Id == id).ToList());
}
}
public Product GetByTitle(string title)
{
using (var entity = new ModelDataEntities2())
{
return(entity.Product.FirstOrDefault(m => m.ProductName == title));
}
}
public IEnumerable <SaleInfo> GetSalesByManagerId(int id)
{
using (var context = new ModelDataEntities2())
{
return(context.Manager.FirstOrDefault(m => m.Id == id).SaleInfo.ToList());
}
}
public decimal GetSumById(int id)
{
using (var context = new ModelDataEntities2())
{
return(context.Manager.FirstOrDefault(m => m.Id == id).SaleInfo.Sum(x => x.Sum));
}
}
public Manager GetByName(string name)
{
using (var entity = new ModelDataEntities2())
{
return(entity.Manager.FirstOrDefault(m => m.ManagerName == name));
}
}
public Client GetByName(string name)
{
using (var entity = new ModelDataEntities2())
{
return(entity.Client.FirstOrDefault(m => m.ClientName == name));
}
}
public void Update(T item)
{
using (var context = new ModelDataEntities2())
{
context.Entry(item).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public IEnumerable <T> GetAll()
{
using (var context = new ModelDataEntities2())
{
var entity = context.Set <T>().ToList();
return(entity);
}
}
public int Insert(T item)
{
using (var context = new ModelDataEntities2())
{
var entity = context.Set <T>().Add(item);
context.SaveChanges();
return(item.Id);
}
}
