コード例 #1
0
        /// <summary>
        /// Returns the product in Json Format with specific Name
        /// </summary>
        /// <param name="productName">Name of the product</param>
        /// <returns></returns>
        public static string GetProductByName(string productName)
        {
            using (var db = new EHandel())
            {
                var query = (from p in db.Product
                             select new
                {
                    p.productId,
                    p.name,
                    p.description,
                    price = WithVAT ? p.price * VAT : p.price,
                    //p.price,
                    p.stock,
                    p.date,
                    p.isHidden
                }).AsEnumerable()
                            .Select(x => new Product()
                {
                    productId   = x.productId,
                    name        = x.name,
                    description = x.description,
                    price       = x.price,
                    stock       = x.stock,
                    date        = x.date,
                    isHidden    = x.isHidden
                }).ToList();

                return(ObjTooJson.ObjToJson(query));
            }
        }
コード例 #2
0
        /// <summary>
        /// Returns the USER if login is correct (email/password)
        /// </summary>
        /// <param name="email">Email of customer</param>
        /// <param name="password">Password of customer</param>
        /// <returns></returns>
        public static string ValidateLogin(string email, string password)
        {
            using (var db = new EHandel())
            {
                var query = db.Customer
                            .FirstOrDefault(c => c.email == email && c.password == password);

                //var query = from u in db.Customer
                //            where u.email == email &&
                //                  u.password == password
                //            select new
                //            {
                //                u.isAdmin,
                //                u.userId,
                //                u.email,
                //                u.firstname,
                //                u.lastname,
                //                u.Address
                //            };

                return(ObjTooJson.ObjToJson(new List <Customer> {
                    query
                }));
            }
        }
コード例 #3
0
        /// <summary>
        /// Returns ALL Catagory NAMES
        /// </summary>
        /// <returns></returns>
        public static string GetAllCategoryNames()
        {
            using (var db = new EHandel())
            {
                var query = from b in db.Category
                            select b.name;

                return(ObjTooJson.ObjToJson(query));
            }
        }
コード例 #4
0
 public static string GetAllOrders()
 {
     using (var db = new EHandel())
     {
         var query = from o in db.Orders
                     select new
         {
             o.orderId,
             o.date,
             o.status,
             o.userId,
         };
         return(ObjTooJson.ObjToJson(query));
     }
 }
コード例 #5
0
 /// <summary>
 /// returns all order by CUSTOMER ID
 /// </summary>
 /// <param name="userID">ID of CUSTOMER to get orders</param>
 /// <returns></returns>
 public static string GetAllOdersByCustomerID(int userID)
 {
     using (var db = new EHandel())
     {
         var query = from o in db.Orders
                     where o.userId == userID
                     select new
         {
             o.orderId,
             o.date,
             o.status
         };
         return(ObjTooJson.ObjToJson(query.ToList()));
     }
 }
コード例 #6
0
 public static string GetAllCustomers()
 {
     using (var db = new EHandel())
     {
         var query = from c in db.Customer
                     select new
         {
             c.userId,
             c.email,
             c.firstname,
             c.lastname,
             c.isAdmin,
             c.password,
         };
         return(ObjTooJson.ObjToJson(query));
     }
 }
コード例 #7
0
 /// <summary>
 /// Returns order by order id
 /// </summary>
 /// <param name="orderID">ID of the order</param>
 /// <returns></returns>
 public static string GetOrderByID(int orderID)
 {
     using (var db = new EHandel())
     {
         var query = from p in db.Product
                     join obp in db.OrdersByProduct on p.productId equals obp.productId
                     where obp.orderId == orderID
                     select new
         {
             p.productId,
             p.name,
             obp.count,
             price = WithVAT ? obp.price * VAT: obp.price
         };
         return(ObjTooJson.ObjToJson(query.ToList()));
     }
 }
コード例 #8
0
 /// <summary>
 /// Returns ALL products as JSON
 /// </summary>
 /// <returns></returns>
 public static string GetAllProducts()
 {
     using (var db = new EHandel())
     {
         var query = from p in db.Product
                     select new
         {
             p.productId,
             p.name,
             p.description,
             price = WithVAT ? p.price * VAT : p.price,
             //p.price,
             p.stock,
             p.date
         };
         return(ObjTooJson.ObjToJson(query));
     }
 }
コード例 #9
0
        public static string GetAdressByUserId(int userId)
        {
            using (var db = new EHandel())
            {
                var query = from a in db.Address
                            where a.userId == userId
                            select new
                {
                    a.addressId,
                    a.street,
                    a.zip,
                    a.city,
                    a.country,
                    a.userId,
                };

                return(ObjTooJson.ObjToJson(query));
            }
        }
コード例 #10
0
        /// <summary>
        /// Returns specific product in Json Format with specific ID
        /// </summary>
        /// <param name="productID">Name of the product</param>
        /// <returns></returns>
        public static string GetProductByID(int productID)
        {
            using (var db = new EHandel())
            {
                //Product prod = db.Product.FirstOrDefault(p => p.productId == productID);
                var query = from p in db.Product
                            where p.productId == productID
                            select new
                {
                    p.productId,
                    p.name,
                    p.description,
                    price = WithVAT ? p.price * VAT : p.price,
                    //p.price,
                    p.stock,
                    p.date
                };

                return(ObjTooJson.ObjToJson(query));
            }
        }
コード例 #11
0
        /// <summary>
        /// Returns ALL products from specific CATEGORY
        /// </summary>
        /// <param name="categoryID">CategoryID to get products from</param>
        /// <returns></returns>
        public static string GetAllProductsFromCategory(int categoryID)
        {
            using (var db = new EHandel())
            {
                var query = from p in db.Product
                            join ctp in db.CategoryToProduct on p.productId equals ctp.productId
                            join c in db.Category on ctp.categoryId equals c.categoryId
                            where c.categoryId == categoryID
                            select new
                {
                    p.productId,
                    p.name,
                    p.description,
                    price = WithVAT ? p.price * VAT : p.price,
                    //p.price,
                    p.stock,
                    p.date
                };

                return(ObjTooJson.ObjToJson(query.ToList()));
            }
        }