public bool ThemChiTietLoaiPhong(ChiTietLoaiPhong chiTietLoaiPhong) { SqlConnection con = new SqlConnection(db.Connection.ConnectionString); SqlCommand command = new SqlCommand("insert into ChiTietLoaiPhong values(@maTienNghi, @maLoai, @soLuong)", con); command.Parameters.AddWithValue("@maTienNghi", chiTietLoaiPhong.MaTienNghi); command.Parameters.AddWithValue("@maLoai", chiTietLoaiPhong.MaLoai); command.Parameters.AddWithValue("@maLoai", chiTietLoaiPhong.SoLuong); con.Open(); int result = command.ExecuteNonQuery(); con.Close(); if (result <= 0) { return(false); } else { return(true); }; }
public bool CapNhatChiTietLoaiPhong(ChiTietLoaiPhong chiTietLoaiPhong) { XoaChiTietLoaiPhong(chiTietLoaiPhong.MaTienNghi, chiTietLoaiPhong.MaLoai); ThemChiTietLoaiPhong(chiTietLoaiPhong); return(true); }