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); } }
public List <Hotel> GetAll(Expression <Func <Hotel, bool> > filter = null) { List <Hotel> hotelList = new List <Hotel>(); SqlCommand cmd = new SqlCommand("Select * from Hotels"); SqlDataReader reader = VTYS.SqlExecuteReader(cmd); while (reader.Read()) { Hotel hotel = new Hotel { HotelId = Convert.ToInt32(reader[0]), HotelName = reader[1].ToString(), Stars = Convert.ToInt32(reader[2]), FeePerNight = Convert.ToDecimal(reader[3].ToString()) }; hotelList.Add(hotel); } return(filter == null ? hotelList : hotelList.Where(filter.Compile()).ToList()); }