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