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); } }