public List <MenuItem> GetMenuItems(Int32 id) { menuzRusDataContext db = new menuzRusDataContext(base.connectionString); return(db.MenuItems.Where(m => m.MenuId == id).ToList()); }
public String GetSettings(Int32 id, CommonUnit.Settings type) { menuzRusDataContext db = new menuzRusDataContext(base.connectionString); return(db.Settings.Where(m => m.CustomerId == id && m.Type == type.ToString()).Select(m => m.Value).FirstOrDefault()); }
public Dictionary <String, String> GetSettings(Int32 id) { menuzRusDataContext db = new menuzRusDataContext(base.connectionString); return(db.Settings.Where(m => m.CustomerId == id).ToDictionary(m => m.Type, m => m.Value)); }
public List <Floor> GetFloors(Int32 id) { menuzRusDataContext db = new menuzRusDataContext(base.connectionString); return(db.Floors.Where(m => m.CustomerId == id).ToList()); }
public Floor GetFloor(Int32 id) { menuzRusDataContext db = new menuzRusDataContext(base.connectionString); return(db.Floors.FirstOrDefault(m => m.id == id)); }
public List <Table> GetTables(Int32 id) { menuzRusDataContext db = new menuzRusDataContext(base.connectionString); return(db.Tables.Where(m => m.FloorId == id && m.Status == (Int32)CommonUnit.Status.Active).ToList()); }