public List<ZoneClass> LoadAllZoneType()
        {
            SqlConnection connection = new SqlConnection(conString);

            string query = "SELECT zoneType FROM tbl_zoneType";

            SqlCommand command = new SqlCommand(query, connection);

            connection.Open();
            SqlDataReader reader = command.ExecuteReader();

            List<ZoneClass> aZoneClasses = new List<ZoneClass>();

            while (reader.Read())
            {
                ZoneClass aZoneClass = new ZoneClass();
                aZoneClass.zoneType = reader["zoneType"].ToString();

                aZoneClasses.Add(aZoneClass);
            }
            reader.Close();
            connection.Close();

            return aZoneClasses;
        }
 public string Save(ZoneClass aZoneClass)
 {
     if (aZoneTypeGateway.Save(aZoneClass) > 0)
     {
         return "Added Successfully!";
     }
     else
     {
         return "Could Not Added!";
     }
 }
        public int Save(ZoneClass aZoneClass)
        {
            SqlConnection connection = new SqlConnection(conString);

            string query = "INSERT INTO tbl_zoneType VALUES ('" + aZoneClass.visitorZoneId+"','"+ aZoneClass.zoneType+"')";

            SqlCommand command = new SqlCommand(query, connection);

            connection.Open();
            int rowAffected = command.ExecuteNonQuery();
            connection.Close();

            return rowAffected;
        }