public int xoakhachhang(khachhang kh)
{
//string sqlstr = " delete Phong where MaPhong = '" + ph.getMaPhong + "' ";
//cmd.ExcuteNonQuery(sqlstr);
SqlConnection con = Config.getConnect();
DataTable dt = new DataTable();
if (con.State == ConnectionState.Closed)
{
con.Open();// mo ket noi sql
}
string sqlstr = "delete Khachhang where MaPhong = '" + kh.getMaPhong() + "' ";
SqlCommand cmd = new SqlCommand(sqlstr, con);
try
{
int rm = cmd.ExecuteNonQuery();
con.Close();
return(rm);
}
catch
{
throw;
}
}
public int suakhachhang(khachhang kh)
{
SqlConnection con = Config.getConnect();
DataTable dt = new DataTable();
if (con.State == ConnectionState.Closed)
{
con.Open();// mo ket noi sql
}
string sqlstr = "update KhachHang set DiaChi = '" + kh.getDiaChi() + "',SDT = " + kh.getSDT() + ",MaPhong = '" + kh.getMaPhong() + "',NgayThue = '" + kh.getNgayThue() + "',NgayTra = '" + kh.getNgayTra() + "' where HoTen = '" + kh.getHoTen() + "'";
SqlCommand cmd = new SqlCommand(sqlstr, con);
try
{
int sa = cmd.ExecuteNonQuery();
con.Close();
return(sa);
}
catch
{
throw;
}
}
public int themkhachhang(khachhang kh)
{
SqlConnection con = Config.getConnect();
DataTable dt = new DataTable();
if (con.State == ConnectionState.Closed)
{
con.Open();// mo ket noi sql
}
string sqlstr = "INSERT INTO KhachHang values ('" + kh.getHoTen() + "', '" + kh.getDiaChi() + "', '" + kh.getSDT() + "','" + kh.getMaPhong() + "','" + kh.getNgayThue() + "','" + kh.getNgayTra() + "')";
SqlCommand cmd = new SqlCommand(sqlstr, con);
try
{
int add = cmd.ExecuteNonQuery();
con.Close();
return(add);
}
catch
{
throw;
}
}
