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