public void Delete(Hotel entity)
{
using (SqlCommand cmd =
new SqlCommand("DELETE FROM Hotels WHERE HotelId = @HotelId"))
{
cmd.Parameters.AddWithValue("HotelId", entity.HotelId);
VTYS.SqlExecuteNonQuery(cmd);
}
}
public void Add(Hotel entity)
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO Hotels (HotelName,FeePerNight,Stars) " +
"VALUES(@HotelName,@FeePerNight,@Stars)"))
{
cmd.Parameters.AddWithValue("HotelName", entity.HotelName);
cmd.Parameters.AddWithValue("FeePerNight", entity.FeePerNight);
cmd.Parameters.AddWithValue("Stars", entity.Stars);
VTYS.SqlExecuteNonQuery(cmd);
}
}
public void Update(Hotel entity)
{
using (SqlCommand cmd = new SqlCommand("UPDATE Hotels set HotelName = @HotelName, FeePerNight=@FeePerNight, Stars=@Stars WHERE HotelId = @HotelId"))
{
cmd.Parameters.AddWithValue("@HotelId", entity.HotelId);
cmd.Parameters.AddWithValue("@HotelName", entity.HotelName);
cmd.Parameters.AddWithValue("@FeePerNight", entity.FeePerNight);
cmd.Parameters.AddWithValue("@Stars", entity.Stars);
VTYS.SqlExecuteNonQuery(cmd);
}
}