public Tuple <Product, Sector> GetProductByIdOnSectorByID(int productId, int sectorId)
{
string getSectorProduct = "Select * from sectorProducts";
getSectorProduct = getSectorProduct + " where product_Id=" + productId.ToString();
getSectorProduct = getSectorProduct + " and sector_Id=" + sectorId.ToString();
string getProduct = "Select * from products where Id=";
string getSector = "Select * from sectors where Id=";
using (var con = new SQLiteConnection(_conStr))
{
SectorProduct sectorProduct = con.QueryFirstOrDefault <SectorProduct>(getSectorProduct);
if (sectorProduct == null)
{
return(null);
}
getProduct = getProduct + sectorProduct.Product_Id.ToString();
getSector = getSector + sectorProduct.Sector_Id.ToString();
Product product = con.QueryFirst <Product>(getProduct);
Sector sector = con.QueryFirst <Sector>(getSector);
return(new Tuple <Product, Sector>(product, sector));
}
}
public Tuple <Product, Sector> GetProductByIdOnSectorByID(int productId, int sectorId)
{
using (var ctx = new ProjectDbContext())
{
SectorProduct sectorProduct = ctx.sectorProducts.Include(x => x.Product)
.Include(x => x.Sector)
.Where(x => x.Product_Id == productId && x.Sector_Id == sectorId)
.FirstOrDefault();
if (sectorProduct == null)
{
return(null);
}
return(new Tuple <Product, Sector>(sectorProduct.Product, sectorProduct.Sector));
}
}
