C# (CSharp) WebAPIData OrderTrackEntities Examples

Example #1

File: Category.cs Project: RowenNaidoo/OrderTrackAngular

 //Retrieve List
 public List<Category> GetList()
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return ctx.Category.ToList<Category>();
     }
 }

Example #2

 //Retrieve By ID
 public Category GetByID(long Id)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return(ctx.Category.First(x => x.CategoryID == Id));
     }
 }

Example #3

File: CartItem.cs Project: RowenNaidoo/OrderTrackAngular

 //Retrieve By ID
 public CartItem GetByID(long Id)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return ctx.CartItem.First(x => x.CartItemID == Id);
     }
 }

Example #4

 //Retrieve List
 public List <CartItem> GetList()
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return(ctx.CartItem.ToList <CartItem>());
     }
 }

Example #5

 //Retrieve By ID
 public AppUser GetByID(long Id)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return(ctx.AppUser.First(x => x.AppUserID == Id));
     }
 }

Example #6

 //Retrieve By AppUserID
 public List <Order> GetByAppUserID(long AppUserId)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return(ctx.Order.Where(x => x.AppUserID == AppUserId).ToList());
     }
 }

Example #7

 //Retrieve List
 public List <AppUser> GetList()
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return(ctx.AppUser.ToList <AppUser>());
     }
 }

Example #8

File: CartItem.cs Project: RowenNaidoo/OrderTrackAngular

 //Retrieve By OrderID
 public List<CartItem> GetByOrderID(long orderId)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return ctx.CartItem.Include("Item").Where(x => x.OrderID == orderId).ToList();
     }
 }

Example #9

File: Order.cs Project: RowenNaidoo/OrderTrackAngular

 //Retrieve By AppUserID
 public List<Order> GetByAppUserID(long AppUserId)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return ctx.Order.Where(x => x.AppUserID == AppUserId).ToList();
     }
 }

Example #10

File: CartItem.cs Project: RowenNaidoo/OrderTrackAngular

 //Retrieve List
 public List<CartItem> GetList()
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return ctx.CartItem.ToList<CartItem>();
     }
 }

Example #11

File: Item.cs Project: RowenNaidoo/OrderTrackAngular

 //Retreive by categoryId
 public List<Item> GetByCategoryId(long categoryId)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return ctx.Item.Where(x => x.CategoryID == categoryId).ToList();
     }
 }

Example #12

 //Retreive by categoryId
 public List <Item> GetByCategoryId(long categoryId)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return(ctx.Item.Where(x => x.CategoryID == categoryId).ToList());
     }
 }

Example #13

File: Order.cs Project: RowenNaidoo/OrderTrackAngular

 //Retrieve By ID
 public Order GetByID(long Id)
 {
     using(OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return ctx.Order.First(x=>x.OrderID == Id);
     }
 }

Example #14

File: CPAStage.cs Project: RowenNaidoo/OrderTrackAngular

 //Retrieve List
 public List<CPAStage> GetList()
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return ctx.CPAStage.ToList<CPAStage>();
     }
 }

Example #15

File: AppUser.cs Project: RowenNaidoo/OrderTrackAngular

 //public AppUser Login(AppUser appuser)
 //Login
 public AppUser Login(string Username, string Password)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return ctx.AppUser.FirstOrDefault(x => x.Username == Username && x.Password == Password);
     }
 }

Example #16

 //Retrieve List
 public List <Category> GetList()
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return(ctx.Category.ToList <Category>());
     }
 }

Example #17

File: Category.cs Project: RowenNaidoo/OrderTrackAngular

 //Retrieve By ID
 public Category GetByID(long Id)
 {
     using(OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return ctx.Category.First(x=>x.CategoryID == Id);
     }
 }

Example #18

 //Retrieve By OrderID
 public List <CartItem> GetByOrderID(long orderId)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return(ctx.CartItem.Include("Item").Where(x => x.OrderID == orderId).ToList());
     }
 }

Example #19

File: Order.cs Project: RowenNaidoo/OrderTrackAngular

 //Retrieve List
 public List<Order> GetList()
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return ctx.Order.ToList<Order>();
     }
 }

Example #20

 //Retrieve By ID
 public CartItem GetByID(long Id)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return(ctx.CartItem.First(x => x.CartItemID == Id));
     }
 }

Example #21

File: CPAStage.cs Project: RowenNaidoo/OrderTrackAngular

 //Retrieve By ID
 public CPAStage GetByID(long Id)
 {
     using(OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return ctx.CPAStage.First(x=>x.CPAStageID == Id);
     }
 }

Example #22

 //Retrieve By ID
 public CPAStage GetByID(long Id)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return(ctx.CPAStage.First(x => x.CPAStageID == Id));
     }
 }

Example #23

 //Retrieve List
 public List <CPAStage> GetList()
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return(ctx.CPAStage.ToList <CPAStage>());
     }
 }

Example #24

 //Login
 public AppUser Login(string Username, string Password)
 //public AppUser Login(AppUser appuser)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         return(ctx.AppUser.FirstOrDefault(x => x.Username == Username && x.Password == Password));
     }
 }

Example #25

 //Create
 public Order Insert(Order order)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         ctx.Order.Add(order);
         ctx.SaveChanges();
         return(this);
     }
 }

Example #26

 //Create
 public CPA Insert(CPA cpa)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         ctx.CPA.Add(cpa);
         ctx.SaveChanges();
         return(this);
     }
 }

Example #27

File: CPA.cs Project: RowenNaidoo/OrderTrackAngular

 //Create
 public CPA Insert(CPA cpa)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         ctx.CPA.Add(cpa);
         ctx.SaveChanges();
         return this;
     }
 }

Example #28

File: Item.cs Project: RowenNaidoo/OrderTrackAngular

 //Create
 public Item Insert(Item item)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         ctx.Item.Add(item);
         ctx.SaveChanges();
         return this;
     }
 }

Example #29

 //Create
 public AppUser Insert(AppUser appuser)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         ctx.AppUser.Add(appuser);
         ctx.SaveChanges();
         return(this);
     }
 }

Example #30

File: Order.cs Project: RowenNaidoo/OrderTrackAngular

 //Create
 public Order Insert(Order order)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         ctx.Order.Add(order);
         ctx.SaveChanges();
         return this;
     }
 }

Example #31

 //Create
 public Item Insert(Item item)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         ctx.Item.Add(item);
         ctx.SaveChanges();
         return(this);
     }
 }

Example #32

 //Create
 public CartItem Insert(CartItem cartitem)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         ctx.CartItem.Add(cartitem);
         ctx.SaveChanges();
         return(this);
     }
 }

Example #33

File: Category.cs Project: RowenNaidoo/OrderTrackAngular

 //Create
 public Category Insert(Category category)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         ctx.Category.Add(category);
         ctx.SaveChanges();
         return this;
     }
 }

Example #34

 //Create
 public CPAStage Insert(CPAStage cpastage)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         ctx.CPAStage.Add(cpastage);
         ctx.SaveChanges();
         return(this);
     }
 }

Example #35

 //Create
 public Category Insert(Category category)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         ctx.Category.Add(category);
         ctx.SaveChanges();
         return(this);
     }
 }

Example #36

File: CPAStage.cs Project: RowenNaidoo/OrderTrackAngular

 //Create
 public CPAStage Insert(CPAStage cpastage)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         ctx.CPAStage.Add(cpastage);
         ctx.SaveChanges();
         return this;
     }
 }

Example #37

File: AppUser.cs Project: RowenNaidoo/OrderTrackAngular

 //Create
 public AppUser Insert(AppUser appuser)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         ctx.AppUser.Add(appuser);
         ctx.SaveChanges();
         return this;
     }
 }

Example #38

 //Update
 public Category Update(Category category)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         Category Category = ctx.Category.First(x => x.CategoryID == this.CategoryID);
         Category = category;
         ctx.SaveChanges();
         return(Category);
     }
 }

Example #39

 //Update
 public Order Update(Order order)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         Order Order = ctx.Order.First(x => x.OrderID == this.OrderID);
         Order = order;
         ctx.SaveChanges();
         return(Order);
     }
 }

Example #40

File: AppUser.cs Project: RowenNaidoo/OrderTrackAngular

 //Update
 public AppUser Update(AppUser appuser)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         AppUser AppUser = ctx.AppUser.First(x => x.AppUserID == this.AppUserID);
         AppUser = appuser;
         ctx.SaveChanges();
         return AppUser;
     }
 }

Example #41

File: CPA.cs Project: RowenNaidoo/OrderTrackAngular

 //Update
 public CPA Update(CPA cpa)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         CPA CPA = ctx.CPA.First(x => x.CPAID == this.CPAID);
         CPA = cpa;
         ctx.SaveChanges();
         return CPA;
     }
 }

Example #42

File: CPAStage.cs Project: RowenNaidoo/OrderTrackAngular

 //Update
 public CPAStage Update(CPAStage cpastage)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         CPAStage CPAStage = ctx.CPAStage.First(x => x.CPAStageID == this.CPAStageID);
         CPAStage = cpastage;
         ctx.SaveChanges();
         return CPAStage;
     }
 }

Example #43

 //Update
 public CPA Update(CPA cpa)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         CPA CPA = ctx.CPA.First(x => x.CPAID == this.CPAID);
         CPA = cpa;
         ctx.SaveChanges();
         return(CPA);
     }
 }

Example #44

File: Item.cs Project: RowenNaidoo/OrderTrackAngular

 //Update
 public Item Update(Item item)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         Item Item = ctx.Item.First(x => x.ItemID == this.ItemID);
         Item = item;
         ctx.SaveChanges();
         return Item;
     }
 }

Example #45

 //Update
 public AppUser Update(AppUser appuser)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         AppUser AppUser = ctx.AppUser.First(x => x.AppUserID == this.AppUserID);
         AppUser = appuser;
         ctx.SaveChanges();
         return(AppUser);
     }
 }

Example #46

 //Update
 public Item Update(Item item)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         Item Item = ctx.Item.First(x => x.ItemID == this.ItemID);
         Item = item;
         ctx.SaveChanges();
         return(Item);
     }
 }

Example #47

File: Category.cs Project: RowenNaidoo/OrderTrackAngular

 //Update
 public Category Update(Category category)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         Category Category = ctx.Category.First(x => x.CategoryID == this.CategoryID);
         Category = category;
         ctx.SaveChanges();
         return Category;
     }
 }

Example #48

 //Update
 public CartItem Update(CartItem cartitem)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         CartItem CartItem = ctx.CartItem.First(x => x.CartItemID == this.CartItemID);
         CartItem = cartitem;
         ctx.SaveChanges();
         return(CartItem);
     }
 }

Example #49

File: Order.cs Project: RowenNaidoo/OrderTrackAngular

 //Update
 public Order Update(Order order)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         Order Order = ctx.Order.First(x => x.OrderID == this.OrderID);
         Order = order;
         ctx.SaveChanges();
         return Order;
     }
 }

Example #50

 //Update
 public CPAStage Update(CPAStage cpastage)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         CPAStage CPAStage = ctx.CPAStage.First(x => x.CPAStageID == this.CPAStageID);
         CPAStage = cpastage;
         ctx.SaveChanges();
         return(CPAStage);
     }
 }

Example #51

 //Delete By ID
 public Boolean Delete(long id)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         try
         {
             AppUser AppUser = ctx.AppUser.First(x => x.AppUserID == id);
             ctx.AppUser.Remove(AppUser);
             ctx.SaveChanges();
             return(true);
         }
         catch (Exception ex)
         {
             return(false);
         }
     }
 }

Example #52

 //Delete By ID
 public Boolean Delete(long id)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         try
         {
             CartItem CartItem = ctx.CartItem.First(x => x.CartItemID == id);
             ctx.CartItem.Remove(CartItem);
             ctx.SaveChanges();
             return(true);
         }
         catch (Exception ex)
         {
             return(false);
         }
     }
 }

Example #53

File: Order.cs Project: RowenNaidoo/OrderTrackAngular

 //Delete By ID
 public Boolean Delete(long id)
 {
     using(OrderTrackEntities ctx= new OrderTrackEntities())
     {
         try
         {
             Order Order = ctx.Order.First(x => x.OrderID == id);
             ctx.Order.Remove(Order);
             ctx.SaveChanges();
             return true;
         }
         catch (Exception ex)
         {
             return false;
         }
     }
 }

Example #54

 //Delete By ID
 public Boolean Delete(long id)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         try
         {
             CPAStage CPAStage = ctx.CPAStage.First(x => x.CPAStageID == id);
             ctx.CPAStage.Remove(CPAStage);
             ctx.SaveChanges();
             return(true);
         }
         catch (Exception ex)
         {
             return(false);
         }
     }
 }

Example #55

File: CPAStage.cs Project: RowenNaidoo/OrderTrackAngular

 //Delete By ID
 public Boolean Delete(long id)
 {
     using(OrderTrackEntities ctx= new OrderTrackEntities())
     {
         try
         {
             CPAStage CPAStage = ctx.CPAStage.First(x => x.CPAStageID == id);
             ctx.CPAStage.Remove(CPAStage);
             ctx.SaveChanges();
             return true;
         }
         catch (Exception ex)
         {
             return false;
         }
     }
 }

Example #56

File: Category.cs Project: RowenNaidoo/OrderTrackAngular

 //Delete By ID
 public Boolean Delete(long id)
 {
     using(OrderTrackEntities ctx= new OrderTrackEntities())
     {
         try
         {
             Category Category = ctx.Category.First(x => x.CategoryID == id);
             ctx.Category.Remove(Category);
             ctx.SaveChanges();
             return true;
         }
         catch (Exception ex)
         {
             return false;
         }
     }
 }

Example #57

File: CartItem.cs Project: RowenNaidoo/OrderTrackAngular

        //checkout
        public Boolean Checkout(long OrderID)
        {
            try
            {
                using (OrderTrackEntities ctx = new OrderTrackEntities())
                {
                    var items = GetByOrderID(OrderID);
                    foreach (var item in items)
                    {
                        item.IsOrdered = true;
                        item.DateOrdered = DateTime.Now;
                        CartItem cartItem = new CartItem().Update(item);
                    }
                }

                return true;
            }
            catch (Exception)
            {
                return false;
            }
        }

Example #58

        //checkout
        public Boolean Checkout(long OrderID)
        {
            try
            {
                using (OrderTrackEntities ctx = new OrderTrackEntities())
                {
                    var items = GetByOrderID(OrderID);
                    foreach (var item in items)
                    {
                        item.IsOrdered   = true;
                        item.DateOrdered = DateTime.Now;
                        CartItem cartItem = new CartItem().Update(item);
                    }
                }

                return(true);
            }
            catch (Exception)
            {
                return(false);
            }
        }

Example #59

File: CartItem.cs Project: RowenNaidoo/OrderTrackAngular

 //Create
 public CartItem Insert(CartItem cartitem)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         ctx.CartItem.Add(cartitem);
         ctx.SaveChanges();
         return this;
     }
 }

Example #60

File: CartItem.cs Project: RowenNaidoo/OrderTrackAngular

 //Update
 public CartItem Update(CartItem cartitem)
 {
     using (OrderTrackEntities ctx = new OrderTrackEntities())
     {
         CartItem CartItem = ctx.CartItem.First(x => x.CartItemID == this.CartItemID);
         CartItem = cartitem;
         ctx.SaveChanges();
         return CartItem;
     }
 }