public bool ThemNhaCungCap(Businessobject.NhaCungCap obj) { try { SqlCommand cmd = new SqlCommand("insert into NhaCungCap values (N'" + obj.MaNCC + "',N'" + obj.TenNCC + "','" + obj.Diachi + "','" + obj.Dienthoai + "','" + obj.Email + "')"); m_ds.ExecuteNoneQuery(cmd); return(true); } catch { } return(false); }
public bool XoaNCC(Businessobject.NhaCungCap obj) { try { SqlCommand cmd = new SqlCommand("delete from NhaCungCap where MANHACUNGCAP=N'" + obj.MaNCC + "'"); m_ds.Load(cmd); return(true); } catch { return(false); } }
public bool CapNhatNCC(Businessobject.NhaCungCap objec) { try { SqlCommand cmd = new SqlCommand("update NhaCungCap set TENNHACUNGCAP=N'" + objec.TenNCC + "',DIACHI=N'" + objec.Diachi + "',DIENTHOAI='" + objec.Dienthoai + "',EMAIL=N'" + objec.Email + "' where MANHACUNGCAP=N'" + objec.MaNCC + "'"); m_ds.ExecuteNoneQuery(cmd); return(true); } catch { } return(false); }