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