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