public int getVacationHouseId(VacationHouse v) { int id = 0; string sql = "SELECT id FROM vacationhouse WHERE description='" + v.Description + "'"; SqlCommand cmd = new SqlCommand(sql, con); try { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { int line = (int)reader["id"]; id = line; } } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message.ToString()); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return(id); }
// VacationHouse public void createVacationHouse(VacationHouse v, string destination) { string sql = ""; sql += "INSERT INTO"; sql += " vacationhouse(description,maxpersons,distancetoshopping,distancetobeach,destination)"; sql += " VALUES ('" + v.Description + "'," + v.MaxPersons + "," + v.DistanceToShopping + "," + v.DistanceToBeach + ",'" + destination + "')"; SqlCommand cmd = new SqlCommand(sql, con); executeQuery(cmd); }
public void updateVacationHouse(VacationHouse vacationHouse, int id) { string sql = ""; sql += "UPDATE vacationhouse"; sql += " SET description='" + vacationHouse.Description; sql += "' , maxpersons=" + vacationHouse.MaxPersons; sql += " , distancetoshopping=" + vacationHouse.DistanceToShopping; sql += " , distancetobeach=" + vacationHouse.DistanceToBeach; sql += " WHERE id=" + id; SqlCommand cmd = new SqlCommand(sql, con); executeQuery(cmd); }
public List <VacationHouse> getVacationHouses(string destination) { List <VacationHouse> vacationHouses = new List <VacationHouse>(); string sql = "SELECT description,maxpersons,distancetoshopping,distancetobeach FROM vacationhouse WHERE destination='" + destination + "'"; SqlCommand cmd = new SqlCommand(sql, con); try { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string desc = reader["description"] as string; int persons = (int)reader["maxpersons"]; int shopping = (int)reader["distancetoshopping"]; int beach = (int)reader["distancetobeach"]; VacationHouse vacationHouse = new VacationHouse(desc, persons, shopping, beach); if (!vacationHouses.Contains(vacationHouse)) { vacationHouses.Add(vacationHouse); } } } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message.ToString()); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return(vacationHouses); }