public void sua(EC_tb_Khachhang q)
{
string sql = (@"UPDATE tb_Khachhang
SET tenkh =N'" + q.TENKH + "' where makh =N'" + q.MAKH + "'");
cn.ExcuteNonQuery(sql);
}
public void suakh(EC_tb_Khachhang kh)
{
string sql = (@"UPDATE tb_Khachhang
SET tenkh =N'" + kh.TENKH + "', diachi =N'" + kh.DIACHI + "', dienthoai =N'" + kh.DIENTHOAI + "' where makh=N'" + kh.MAKH + "'");
cn.ExcuteNonQuery(sql);
}
public void themoikh(EC_tb_Khachhang kh)
{
if (!khsql.kiemtrakh(kh.MAKH))
{
khsql.themmoikh(kh);
}
else
{
MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void xoakh(EC_tb_Khachhang kh)
{
khsql.xoakh(kh);
}
public void suakh(EC_tb_Khachhang kh)
{
khsql.suakh(kh);
}
public void xoa(EC_tb_Khachhang q)
{
cn.ExcuteNonQuery("DELETE FROM [tb_Khachhang] WHERE [makh] = N'" + q.MAKH + "'");
}
public void themmoi(EC_tb_Khachhang q)
{
cn.ExcuteNonQuery(@"INSERT INTO tb_Khachhang
(makh, tenkh) VALUES (N'" + q.MAKH + "',N'" + q.TENKH + "')");
}
public void xoakh(EC_tb_Khachhang kh)
{
cn.ExcuteNonQuery("DELETE FROM [tb_Khachhang] WHERE makh=N'" + kh.MAKH + "'");
}
public void themmoikh(EC_tb_Khachhang kh)
{
string str = (@"INSERT INTO tb_Khachhang ( makh, tenkh, diachi, dienthoai) VALUES (N'" + kh.MAKH + "',N'" + kh.TENKH + "',N'" + kh.DIACHI + "',N'" + kh.DIENTHOAI + "')");
cn.ExcuteNonQuery(str);
}
