public static int Insert(Aisle aisle)
{
using (GroceryGetterEntities dc = new GroceryGetterEntities())
{
tblAisle tblaisle = new tblAisle();
tblaisle.Id = Guid.NewGuid();
tblaisle.LayoutId = aisle.LayoutId;
tblaisle.Number = aisle.Number;
tblaisle.Lineup = aisle.Lineup;
aisle.Id = tblaisle.Id;
dc.tblAisles.Add(tblaisle);
return(dc.SaveChanges());
}
}
public static int Update(Aisle aisle)
{
using (GroceryGetterEntities dc = new GroceryGetterEntities())
{
tblAisle tblaisle = dc.tblAisles.FirstOrDefault(a => a.Id == aisle.Id);
if (tblaisle != null)
{
tblaisle.LayoutId = aisle.LayoutId;
tblaisle.Number = aisle.Number;
tblaisle.Lineup = aisle.Lineup;
return(dc.SaveChanges());
}
else
{
return(0);
}
}
}
public static int Delete(Guid id)
{
try
{
using (GroceryGetterEntities dc = new GroceryGetterEntities())
{
tblAisle deletedrow = dc.tblAisles.FirstOrDefault(a => a.Id == id);
if (deletedrow != null)
{
dc.tblAisles.Remove(deletedrow);
return(dc.SaveChanges());
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int Delete(Aisle aisle)
{
try
{
using (GroceryGetterEntities dc = new GroceryGetterEntities())
{
tblAisle tblaisle = dc.tblAisles.FirstOrDefault(a => a.Id == aisle.Id);
if (tblaisle != null)
{
dc.tblAisles.Remove(tblaisle);
return(dc.SaveChanges());
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
