C# (CSharp) WebAPIData OrderTrackEntities示例

示例#1

文件： Category.cs 项目： RowenNaidoo/OrderTrackAngular

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

示例#2

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

示例#3

文件： CartItem.cs 项目： RowenNaidoo/OrderTrackAngular

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

示例#4

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

示例#5

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

示例#6

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

示例#7

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

示例#8

文件： CartItem.cs 项目： 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();
     }
 }

示例#9

文件： Order.cs 项目： 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();
     }
 }

示例#10

文件： CartItem.cs 项目： RowenNaidoo/OrderTrackAngular

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

示例#11

文件： Item.cs 项目： 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();
     }
 }

示例#12

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

示例#13

文件： Order.cs 项目： RowenNaidoo/OrderTrackAngular

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

示例#14

文件： CPAStage.cs 项目： RowenNaidoo/OrderTrackAngular

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

示例#15

文件： AppUser.cs 项目： 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);
     }
 }

示例#16

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

示例#17

文件： Category.cs 项目： RowenNaidoo/OrderTrackAngular

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

示例#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());
     }
 }

示例#19

文件： Order.cs 项目： RowenNaidoo/OrderTrackAngular

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

示例#20

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

示例#21

文件： CPAStage.cs 项目： RowenNaidoo/OrderTrackAngular

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

示例#22

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

示例#23

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

示例#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));
     }
 }

示例#25

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

示例#26

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

示例#27

文件： CPA.cs 项目： RowenNaidoo/OrderTrackAngular

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

示例#28

文件： Item.cs 项目： RowenNaidoo/OrderTrackAngular

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

示例#29

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

示例#30

文件： Order.cs 项目： RowenNaidoo/OrderTrackAngular

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

示例#31

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

示例#32

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

示例#33

文件： Category.cs 项目： RowenNaidoo/OrderTrackAngular

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

示例#34

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

示例#35

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

示例#36

文件： CPAStage.cs 项目： RowenNaidoo/OrderTrackAngular

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

示例#37

文件： AppUser.cs 项目： RowenNaidoo/OrderTrackAngular

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

示例#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);
     }
 }

示例#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);
     }
 }

示例#40

文件： AppUser.cs 项目： 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;
     }
 }

示例#41

文件： CPA.cs 项目： 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;
     }
 }

示例#42

文件： CPAStage.cs 项目： 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;
     }
 }

示例#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);
     }
 }

示例#44

文件： Item.cs 项目： 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;
     }
 }

示例#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);
     }
 }

示例#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);
     }
 }

示例#47

文件： Category.cs 项目： 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;
     }
 }

示例#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);
     }
 }

示例#49

文件： Order.cs 项目： 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;
     }
 }

示例#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);
     }
 }

示例#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);
         }
     }
 }

示例#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);
         }
     }
 }

示例#53

文件： Order.cs 项目： 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;
         }
     }
 }

示例#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);
         }
     }
 }

示例#55

文件： CPAStage.cs 项目： 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;
         }
     }
 }

示例#56

文件： Category.cs 项目： 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;
         }
     }
 }

示例#57

文件： CartItem.cs 项目： 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;
            }
        }

示例#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);
            }
        }

示例#59

文件： CartItem.cs 项目： RowenNaidoo/OrderTrackAngular

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

示例#60

文件： CartItem.cs 项目： 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;
     }
 }