public static AisleProduct LoadAisleByProductId(Guid productId)
{
try
{
using (GroceryGetterEntities dc = new GroceryGetterEntities())
{
var results = (from ap in dc.tblAisleProducts
join a in dc.tblAisles on ap.AisleId equals a.Id
join p in dc.tblProducts on ap.ProductId equals p.Id
join l in dc.tblLayouts on a.LayoutId equals l.Id
where ap.ProductId == productId
select new
{
Id = ap.Id,
AisleId = a.Id,
ProductId = p.Id,
AisleNumber = a.Number
}).FirstOrDefault();
// Create a new AisleProduct object based on returned values
AisleProduct aisleProduct = new AisleProduct();
aisleProduct.Id = results.Id;
aisleProduct.AisleId = results.AisleId;
aisleProduct.ProductId = results.ProductId;
aisleProduct.AisleNumber = results.AisleNumber;
return(aisleProduct);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int Update(AisleProduct aisleProduct)
{
try
{
using (GroceryGetterEntities dc = new GroceryGetterEntities())
{
tblAisleProduct updatedrow = dc.tblAisleProducts.FirstOrDefault(ap => ap.Id == aisleProduct.Id);
if (updatedrow != null)
{
updatedrow.Id = aisleProduct.Id;
updatedrow.AisleId = aisleProduct.AisleId;
updatedrow.ProductId = aisleProduct.ProductId;
return(dc.SaveChanges());
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int Insert(AisleProduct aisleProduct)
{
try
{
using (GroceryGetterEntities dc = new GroceryGetterEntities())
{
tblAisleProduct newrow = new tblAisleProduct();
newrow.Id = Guid.NewGuid();
newrow.AisleId = aisleProduct.AisleId;
newrow.ProductId = aisleProduct.ProductId;
dc.tblAisleProducts.Add(newrow);
return(dc.SaveChanges());
}
}
catch (Exception ex)
{
throw ex;
}
}