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