partial void UpdateNhaSanXuat(NhaSanXuat instance);
partial void DeleteNhaSanXuat(NhaSanXuat instance);
partial void InsertNhaSanXuat(NhaSanXuat instance);
// Search
public void TimKiem(NhaSanXuat ex)
{
KetNoi.ExecuteReader(@"Select * From NhaSanXuat Where TenNSX Like N'%" + ex.TenNSX + "'");
}
// XÓA DỮ LIỆU
public void DeleteData(NhaSanXuat ex)
{
KetNoi.ExecuteReader(@"DELETE FROM NhaSanXuat Where MaNSX=N'" + ex.MaNSX + "' ");
}
// SỬA DỮ LIỆU
public void EditData(NhaSanXuat ex)
{
KetNoi.ExecuteReader(@"update NhaSanXuat SET TenNSX=N'" + ex.TenNSX + "',DiaChi=N'" + ex.DiaChi + "',TrangThai=N'" + ex.TrangThai + "' Where MaNSX='" + ex.MaNSX + "'");
}
// THÊM DỮ LIỆU
public void AddData(NhaSanXuat ex)
{
KetNoi.ExecuteReader(@"INSERT INTO NhaSanXuat(MaNSX,TenNSX,DiaChi,TrangThai)
VALUES(N'" + ex.MaNSX + "',N'" + ex.TenNSX + "',N'" + ex.DiaChi + "',N'" + ex.TrangThai + "')");
}