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