public HttpResponseMessage Result()
{
using (var db = new UmbracoApiEntities())
{
//var res = (from x in db.MemberProducts
// join y in db.Members on x.ID equals y.MemberID
// join z in db.Products on y.MemberID equals z.ProductID
// where y.MemberID == x.ID
// select new
// {
// Id = x.ID,
// MemberId = x.MemberID,
// ProductID = x.ProductID
// }
// ).ToList();
var res = (from t1 in db.MemberProducts
join t2 in db.Products on t1.ID equals t2.ProductID
join t3 in db.Members on t2.ProductID equals t3.MemberID
select new
{
t2.Name
}).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, res));
}
}
public HttpResponseMessage IDs()
{
using (var db = new UmbracoApiEntities())
{
var MembersIds = db.MemberProducts.Select(x => new
{
Id = x.ID
}).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, MembersIds));
};
}
public HttpResponseMessage GetAllMembersFromDb()
{
using (var db = new UmbracoApiEntities())
{
//var p = db.Products.Find();
var members = db.Members.Select(x => new
{
Id = x.MemberID,
Name = x.MemberName
//Name = x.P,
//Price = x.Price
}).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, members));
};
}
public HttpResponseMessage GetAllProducts()
{
using (var db = new UmbracoApiEntities())
{
//var p = db.Products.Find();
var products = db.Products.Select(x => new
{
ProductID = x.ProductID,
Name = x.Name,
Price = x.Price
//Name = x.P,
//Price = x.Price
}).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, products));
};
}
public HttpResponseMessage ProductForEachMember()
{
using (var db = new UmbracoApiEntities())
{
//var p = db.Products.Find();
//var mp = db.MemberProducts.FirstOrDefault(x => x.MemberID.Equals("EFEF789E-07E3-479D-9F45-A51A48C0923B"));
Guid id = Guid.Parse("EFEF789E-07E3-479D-9F45-A51A48C0923B");
var guids = (from i in db.MemberProducts
where i.ID.ToString().Contains("EFEF789E-07E3-479D-9F45-A51A48C0923B")
select i).ToList();
//Guid id2 = Guid.Parse("FBCAFA93-F3CE-47A1-838D-8532E88AC712");
//var MembersIds = db.MemberProducts.Select(x => x.ID).Max(3;
//var MembersId = db.MemberProducts.Select(x => new
//{
// Id = x.ID
//}).ToList();
//List<MemberProduct> MembersIds = new List<MemberProduct>()
//{
// new MemberProduct {ID = MembersIds}
//};
//var query = db.MemberProducts.Join(db.Members,
// Name => db.Members.Where(x => x.MemberID == id),
// product => db.Products.Where(x => x.ProductID == id),
// (Name, product) => new { Name = Name, Product = product });
//var res = db.MemberProducts.FirstOrDefault(x => x.ID == id);
//var member = db.Members.Where(x => x.MemberID == id).FirstOrDefault();
//var products = db.MemberProducts
// .Where(x => x.MemberID == id)
// .Select(x => x.Product.Name).ToList();
//var listOfProducts = db.MemberProducts.Select(x => new
//{
// product = x.Product.Name
//}).ToList();
//IQueryable<Guid> guids = db.MemberProducts.Select(r => r.ID);
//var ids = db.MemberProducts.Select(r => guids.Contains(r.ID));
var products = db.MemberProducts
.Where(x => x.MemberID == id)
.Select(y => new
{
Id = y.MemberID,
Name = y.Member.MemberName,
NumOfProduct = y.Product.Name.Length,
Price = y.Product.Price,
Products = db.MemberProducts.Where(x => x.MemberID == id)
.Select(x => new
{
Name = x.Product.Name
}).ToList()
}).ToList();
// Trying a strang way
//var products = db.MemberProducts
// .Where(x => x.MemberID.Equals(ids))
// .Select(y => new
// {
// Id = y.MemberID,
// Name = y.Member.MemberName,
// NumOfProduct = y.Product.Name.Length,
// Products = db.MemberProducts.Where(x => x.MemberID.Equals(ids))
// .Select(x => new
// {
// Name = x.Product.Name
// }).ToList()
// }).ToList();
//var response = new
//{
// Member = member,
// Products = product,
//};
return(Request.CreateResponse(HttpStatusCode.OK, products));
};
}
