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