public List <ProductToSupllier> GetSuplliersAndProductsbyname(string SupllierName, string productname, int productprice) { List <ProductToSupllier> PTSList = new List <ProductToSupllier>(); ProductsToSupllier PSTS = new ProductsToSupllier(); //ProductsToSupllier PTS = new ProductsToSupllier(); using (mydbEntities db = new mydbEntities()) { var query = from p in db.Products join su in db.Suplliers on p.SupllierID equals su.SupllierID select new { PID = p.product_id, PNAME = p.product_name, PPRICE = p.product_price, SID = su.SupllierID, SNAME = su.SupllierName, SAD = su.SupllierAddress, }; if (!query.Any() || SupllierName == null || productname == null || productprice == 0) { return(PTSList); } //query.GroupBy(SNAME); var a = query.ToList(); for (int i = 0; i < a.Count; i++) { if (a[i].PNAME.Contains(productname) && a[i].SNAME.Contains(SupllierName) && a[i].PPRICE < productprice) { ProductToSupllier PTS = new ProductToSupllier(); PTS.PID = a[i].PID; PTS.PNAME = a[i].PNAME; PTS.PPRICE = a[i].PPRICE; PTS.SID = a[i].SID; PTS.SNAME = a[i].SNAME; PTS.SAD = a[i].SAD; PTSList.Add(PTS); } } } PSTS.PTSList = PTSList; return(PTSList); }
public ProductsToSupllier GetSuplliersAndProducts() { List <ProductToSupllier> PTSList = new List <ProductToSupllier>(); ProductsToSupllier PSTS = new ProductsToSupllier(); //ProductsToSupllier PTS = new ProductsToSupllier(); using (mydbEntities db = new mydbEntities()) { var query = from p in db.Products join su in db.Suplliers on p.SupllierID equals su.SupllierID select new { PID = p.product_id, PNAME = p.product_name, PPRICE = p.product_price, SID = su.SupllierID, SNAME = su.SupllierName, SAD = su.SupllierAddress, }; //query.GroupBy(SNAME); var a = query.ToList(); for (int i = 0; i < a.Count; i++) { ProductToSupllier PTS = new ProductToSupllier(); PTS.PID = a[i].PID; PTS.PNAME = a[i].PNAME; PTS.PPRICE = a[i].PPRICE; PTS.SID = a[i].SID; PTS.SNAME = a[i].SNAME; PTS.SAD = a[i].SAD; PTSList.Add(PTS); } } PSTS.PTSList = PTSList; return(PSTS); }