//Retrieve List public List<Category> GetList() { using (Entities ctx = new Entities()) { return ctx.Category.ToList<Category>(); } }
//Retrieve List public List<CPA> GetList() { using (Entities ctx = new Entities()) { return ctx.CPA.ToList<CPA>(); } }
//Retrieve List public List<Item> GetList() { using (Entities ctx = new Entities()) { return ctx.Item.ToList<Item>(); } }
//Retrieve By ID public Category GetByID(long Id) { using(Entities ctx = new Entities()) { return ctx.Category.First(x=>x.CategoryID == Id); } }
//Get by OrderID public List<CartItem> GetByOrderId(long OrderID) { using (Entities ctx = new Entities()) { return ctx.CartItem.Include("Item").Where(x => x.OrderID == OrderID).ToList(); } }
//Retrieve By ID public Item GetByID(long Id) { using(Entities ctx = new Entities()) { return ctx.Item.First(x=>x.ItemID == Id); } }
//Retrieve By ID public Order GetByID(long Id) { using(Entities ctx = new Entities()) { return ctx.Order.First(x=>x.OrderID == Id); } }
//Retrieve By ID public CPA GetByID(long Id) { using(Entities ctx = new Entities()) { return ctx.CPA.First(x=>x.CPAID == Id); } }
//get by username,password public AppUser GetByUsernamePassword(string username, string password) { using(Entities ctx = new Entities()) { return ctx.AppUser.FirstOrDefault(x => x.Username == username && x.Password == password); } }
//get by userID public List<Order> GetByUserID(long AppUserID) { using(Entities ctx = new Entities()) { return ctx.Order.Where(x => x.AppUserID == AppUserID).ToList<Order>(); } }
//Retrieve List public List<Order> GetList() { using (Entities ctx = new Entities()) { return ctx.Order.ToList<Order>(); } }
//get by categoryid public List<Item> GetByCategoryId(long CategoryID) { using(Entities ctx = new Entities()) { ctx.Configuration.LazyLoadingEnabled = false; return ctx.Item.Where(x => x.CategoryID == CategoryID).ToList(); } }
//Create public AppUser Insert() { using (Entities ctx = new Entities()) { ctx.AppUser.Add(this); ctx.SaveChanges(); return this; } }
//Create public CPA Insert() { using (Entities ctx = new Entities()) { ctx.CPA.Add(this); ctx.SaveChanges(); return this; } }
//Create public Item Insert() { using (Entities ctx = new Entities()) { ctx.Item.Add(this); ctx.SaveChanges(); return this; } }
//Create public Order Insert(Order order) { using (Entities ctx = new Entities()) { ctx.Order.Add(order); ctx.SaveChanges(); return order; } }
//Update public Category Update() { using (Entities ctx = new Entities()) { Category Category = ctx.Category.First(x => x.CategoryID == this.CategoryID); Category = this; ctx.SaveChanges(); return Category; } }
//Update public CartItem Update() { using (Entities ctx = new Entities()) { CartItem CartItem = ctx.CartItem.First(x => x.CartItemID == this.CartItemID); CartItem = this; ctx.SaveChanges(); return CartItem; } }
//Update public CPAStage Update() { using (Entities ctx = new Entities()) { CPAStage CPAStage = ctx.CPAStage.First(x => x.CPAStageID == this.CPAStageID); CPAStage = this; ctx.SaveChanges(); return CPAStage; } }
//Update public AppUser Update() { using (Entities ctx = new Entities()) { AppUser AppUser = ctx.AppUser.First(x => x.AppUserID == this.AppUserID); AppUser = this; ctx.SaveChanges(); return AppUser; } }
//Update public Order Update() { using (Entities ctx = new Entities()) { Order Order = ctx.Order.First(x => x.OrderID == this.OrderID); Order = this; ctx.SaveChanges(); return Order; } }
//Update public Item Update() { using (Entities ctx = new Entities()) { Item Item = ctx.Item.First(x => x.ItemID == this.ItemID); Item = this; ctx.SaveChanges(); return Item; } }
//Update public CPA Update() { using (Entities ctx = new Entities()) { CPA CPA = ctx.CPA.First(x => x.CPAID == this.CPAID); CPA = this; ctx.SaveChanges(); return CPA; } }
//Create public CartItem Insert(CartItem CartItem) { using (Entities ctx = new Entities()) { try { ctx.CartItem.Add(CartItem); ctx.SaveChanges(); return this; } catch (Exception exception) { return this; } } }
//Delete By ID public Boolean Delete() { using(Entities ctx= new Entities()) { try { Category Category = ctx.Category.First(x => x.CategoryID == this.CategoryID); ctx.Category.Remove(Category); ctx.SaveChanges(); return true; } catch (Exception ex) { return false; } } }
//Delete By ID public Boolean Delete() { using(Entities ctx= new Entities()) { try { Order Order = ctx.Order.First(x => x.OrderID == this.OrderID); ctx.Order.Remove(Order); ctx.SaveChanges(); return true; } catch (Exception ex) { return false; } } }
//Delete By ID public Boolean Delete() { using(Entities ctx= new Entities()) { try { Item Item = ctx.Item.First(x => x.ItemID == this.ItemID); ctx.Item.Remove(Item); ctx.SaveChanges(); return true; } catch (Exception ex) { return false; } } }
//Delete By ID public Boolean Delete() { using(Entities ctx= new Entities()) { try { CPA CPA = ctx.CPA.First(x => x.CPAID == this.CPAID); ctx.CPA.Remove(CPA); ctx.SaveChanges(); return true; } catch (Exception ex) { return false; } } }