public new List <Class_NhaCungCap> Select()
{
string sql = "SELECT * FROM NhaCungCap";
List <Class_NhaCungCap> list = new List <Class_NhaCungCap>();
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=DESKTOP-MFCIF4Q\SQLEXPRESS;Initial Catalog=QLNhaHang;Integrated Security=True";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
using (DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
string MaNhaCungCap = reader.GetString(0);
string TenNhaCungCap = reader.GetString(1);
string DiaChi = reader.GetString(2);
string DienThoai = reader.GetString(3);
Class_NhaCungCap ncc = new Class_NhaCungCap(MaNhaCungCap, TenNhaCungCap, DiaChi, DienThoai);
list.Add(ncc);
}
}
}
con.Close();
return(list);
}
public void update(Class_NhaCungCap ncc)
{
string sql = "UPDATE NhaCungCap WHERE SET MaNhaCungCap=" + ncc.MaNhaCungCap1 + ",TenNhaCungCap=N'" +
ncc.TenNhaCungCap1 + "', DiaChi=N'" + ncc.DiaChi1 + "', DienThoai='" + ncc.DienThoai1 + "')";
query.insert(sql);
}
public void insert(Class_NhaCungCap ncc)
{
string sql = "INSERT INTO NhaCungCap(MaNhaCungCap,TenNhaCungCap,DiaChi,DienThoai) VALUES(";
sql += ncc.MaNhaCungCap1 + ",N'" + ncc.TenNhaCungCap1 + "',N'" + ncc.DiaChi1 + "',N'" + ncc.DienThoai1 + "')";
query.insert(sql);
}
public new List <Class_NhaCungCap> Select()
{
string sql = "SELECT * FROM NhaCungCap";
List <Class_NhaCungCap> list = new List <Class_NhaCungCap>();
query.ketnoiSQL();
using (DbDataReader reader = query.Reader(sql))
{
if (reader.HasRows)
{
while (reader.Read())
{
string MaNhaCungCap = reader.GetString(0);
string TenNhaCungCap = reader.GetString(1);
string DiaChi = reader.GetString(2);
string DienThoai = reader.GetString(3);
Class_NhaCungCap ncc = new Class_NhaCungCap(MaNhaCungCap, TenNhaCungCap, DiaChi, DienThoai);
list.Add(ncc);
}
}
}
query.DongketnoiSQL();
return(list);
}
public void delete(Class_NhaCungCap ncc)
{
string sql = "DELETE FROM NhaCungCap WHERE MaNhaCungCap = " + ncc.MaNhaCungCap1;
query.insert(sql);
}
