// 14. bang nhan phong
public string InsertNhanPhong(NhanPhong ttNhanPhong)
{
string Message;
SqlConnection con = new SqlConnection(strQuery);
con.Open();
SqlCommand cmd = new SqlCommand("insert into NhanPhong(MaNP,TenKH,NgayNhan,GioNhan,MaPH,SoLuongNguoi,SoDienThoai) values(@maNP,@tenKH,@ngayNhan,@gioNhan,@maPH,@soLuongNguoi,@soDienThoai)", con);
cmd.Parameters.AddWithValue("@maNP", ttNhanPhong.maNP);
cmd.Parameters.AddWithValue("@tenKH", ttNhanPhong.tenKH);
cmd.Parameters.AddWithValue("@ngayNhan", ttNhanPhong.ngayNhan);
cmd.Parameters.AddWithValue("@gioNhan", ttNhanPhong.gioNhan);
cmd.Parameters.AddWithValue("@maPH", ttNhanPhong.maPH);
cmd.Parameters.AddWithValue("@soLuongNguoi", ttNhanPhong.soLuongNguoi);
cmd.Parameters.AddWithValue("@soDienThoai", ttNhanPhong.soDienThoai);
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
Message = "nhan phong thanh cong";
}
else
{
Message = "nhan phong khong thanh cong";
}
con.Close();
return(Message);
}
public bool DeleteNhanPhong(NhanPhong ttNhanPhong)
{
SqlConnection con = new SqlConnection(strQuery);
con.Open();
SqlCommand cmd = new SqlCommand("delete from NhanPhong where MaNP=@idNP", con);
cmd.Parameters.AddWithValue("@idNP", ttNhanPhong.maNP);
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
public void UpdateNhanPhong(NhanPhong ttNhanPhong)
{
SqlConnection con = new SqlConnection(strQuery);
con.Open();
SqlCommand cmd = new SqlCommand("update NhanPhong set TenKH=@tenKH, NgayNhan=@ngayNhan, GioNhan=@gioNhan, MaPH=@maPH, SoLuongNguoi=@soLuongNguoi, SoDienThoai=@soDienThoai where MaNP=@maNP", con);
cmd.Parameters.AddWithValue("@maNP", ttNhanPhong.maNP);
cmd.Parameters.AddWithValue("@tenKH", ttNhanPhong.tenKH);
cmd.Parameters.AddWithValue("@ngayNhan", ttNhanPhong.ngayNhan);
cmd.Parameters.AddWithValue("@gioNhan", ttNhanPhong.gioNhan);
cmd.Parameters.AddWithValue("@maPH", ttNhanPhong.maPH);
cmd.Parameters.AddWithValue("@soLuongNguoi", ttNhanPhong.soLuongNguoi);
cmd.Parameters.AddWithValue("@soDienThoai", ttNhanPhong.soDienThoai);
cmd.ExecuteNonQuery();
con.Close();
}