public List<Sector> GetAllCategory()
 {
     List<Sector> sList = new List<Sector>();
     DataTable tbl = facade.GetAllCategory();
     foreach (DataRow r in tbl.Rows)
     {
         Sector s = new Sector(Convert.ToInt32(r[0].ToString()), r[1].ToString(), r[2].ToString(), Convert.ToInt32(r[3].ToString()));
         sList.Add(s);
     }
     return sList;
 }
 public List<Sector> GetFullCategory(int cateid)
 {
     List<Sector> seList = new List<Sector>();
     DataTable tbl = facade.GetFullCategory(cateid);
     foreach (DataRow r in tbl.Rows)
     {
         Sector se = new Sector(Convert.ToInt16(r[0].ToString()), r[1].ToString(), r[2].ToString(), Convert.ToInt16(r[3].ToString()));
         seList.Add(se);
     }
     return seList;
 }