public static void Insert(VillageBO village)
 {
     try
     {
         VillageDAL dalVillage = new VillageDAL(CUtil.GetConnexion());
         dalVillage.VillageBO_Insert(village.name);
     }
     catch (Exception)
     {
         throw;
     }
 }
 public static VillageBO Search(string villageName)
 {
     try
     {
         List<VillageBO> listVillage = new List<VillageBO>();
         VillageBO result = new VillageBO();
         VillageDAL dal = new VillageDAL(CUtil.GetConnexion());
         listVillage = dal.VillageBO_Search(villageName).ToList();
         result = listVillage.FirstOrDefault();
         return result;
     }
     catch (Exception)
     {
         throw;
     }
 }