public ChairList GetChairListById(Int64 Id)
        {
            Hashtable lstItems = new Hashtable();
            lstItems.Add("@Id", Id);

            DataTable dt = dal.GetAllChairListById(lstItems);
            ChairList objChairList = new ChairList();
            DataRow dr = dt.Rows[0];
            return GetObject(dr);
        }
        private static ChairList GetObject(DataRow dr)
        {
            ChairList objChairList = new ChairList
            {
                 Id = (Int64)dr["Id"],
                 ChairCode = (String)dr["ChairCode"],
                 IsReserved = (Int64)dr["IsReserved"],
            };

            return objChairList;
        }