public int ThemDuLieu(EC_tblNhaCungCap et)
{
return(sql.ThemDuLieu(et));
}
public int XoaDuLieu(EC_tblNhaCungCap et)
{
return(sql.XoaDuLieu(et));
}
public void suadulieu(EC_tblNhaCungCap et)
{
this.cn.thucthicaulenh("UPDATE DMNhaCungCap SET tenncc =N'" + et.Tenncc + "', sdtncc =N'" + et.Sdtncc + "', emailncc =N'" + et.Emailncc + "', diachincc =N'" + et.Diachincc + "' Where mancc=N'" + et.Mancc + "' ");
}
public void xoadulieu(EC_tblNhaCungCap et)
{
this.cn.thucthicaulenh("DELETE FROM DMNhacCungCap Where mancc=N'" + et.Mancc + "'");
}
public void xoadulieu(EC_tblNhaCungCap et)
{
this.sql.xoadulieu(et);
}
public void themdulieu(EC_tblNhaCungCap et)
{
this.cn.thucthicaulenh("INSERT INTO DMNhaCungCap (mancc, tenncc, emailncc, sdtncc, diachincc) VALUES ('" + et.Mancc + "','" + et.Tenncc + "','" + et.Sdtncc + "','" + et.Emailncc + "','" + et.Diachincc + "')");
}
public void suadulieu(EC_tblNhaCungCap et)
{
this.sql.suadulieu(et);
}
public void themdulieu(EC_tblNhaCungCap et)
{
this.sql.themdulieu(et);
}
public int XoaDuLieu(EC_tblNhaCungCap et)
{
return(cn.ThucThiCauLenhSQL(@"DELETE FROM tblNhaCungCap where MaNCC=N'" + et.MaNCC + "'"));
}
public int SuaDuLieu(EC_tblNhaCungCap et)
{
return(cn.ThucThiCauLenhSQL(@"UPDATE tblNhaCungCap SET TenNCC =N'" + et.TenNCC + "', DiaChi =N'" + et.DiaChi + "', SDT ='" + et.SDT + "' where MaNCC= '" + et.MaNCC + "'"));
}
public int ThemDuLieu(EC_tblNhaCungCap et)
{
return(cn.ThucThiCauLenhSQL(@"INSERT INTO tblNhaCungCap (MaNCC,TenNCC,DiaChi,SDT)
VALUES('" + et.MaNCC + "', N'" + et.TenNCC + "',N'" + et.DiaChi + "', " + et.SDT + ")"));
}
