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 Delete(Guid aisleId, Guid productId)
{
try
{
using (GroceryGetterEntities dc = new GroceryGetterEntities())
{
tblAisleProduct deletedrow = dc.tblAisleProducts
.FirstOrDefault(u => u.AisleId == aisleId &&
u.ProductId == productId);
if (deletedrow != null)
{
dc.tblAisleProducts.Remove(deletedrow);
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;
}
}
