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