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