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