public new List <Class_HoaDonNhap> Select()
{
string sql = "Select * from HoaDonNhap";
List <Class_HoaDonNhap> list = new List <Class_HoaDonNhap>();
query.ketnoiSQL();
using (DbDataReader reader = query.Reader(sql))
{
if (reader.HasRows)
{
while (reader.Read())
{
String MaHoaDonNhap = reader.GetString(0);
DateTime NgayNhap = reader.GetDateTime(1);
String MaNhanVien = reader.GetString(2);
String MaNhaCungCap = reader.GetString(3);
double TongTien = (double)reader.GetValue(4);
Class_HoaDonNhap hoaDonNhap1 = new Class_HoaDonNhap(MaHoaDonNhap, NgayNhap, MaHoaDonNhap, MaNhaCungCap, TongTien);
list.Add(hoaDonNhap1);
}
}
}
query.DongketnoiSQL();
return(list);
}
public new List <Class_HoaDonNhap> Select()
{
string sql = "Select * from HoaDonNhap";
List <Class_HoaDonNhap> list = new List <Class_HoaDonNhap>();
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 MaHoaDonNhap = reader.GetString(0);
DateTime NgayNhap = reader.GetDateTime(1);
String MaNhanVien = reader.GetString(2);
String MaNhaCungCap = reader.GetString(3);
double TongTien = (double)reader.GetValue(4);
Class_HoaDonNhap hoaDonNhap1 = new Class_HoaDonNhap(MaHoaDonNhap, NgayNhap, MaHoaDonNhap, MaNhaCungCap, TongTien);
list.Add(hoaDonNhap1);
}
}
}
con.Close();
return(list);
}
public void update(Class_HoaDonNhap HDN)
{
string sql = "UPDATE HoaDonNhap WHERE SET MaHoaDonNhap=" + HDN.MaHoaDonNhap1 + ",NgayNhap=N'" +
HDN.NgayNhap1 + "', MaNhanVien=N'" + HDN.MaNhanVien1 + "', MaNhaCungCap='" + HDN.MaNhaCungCap1 + ",TongTien=N'" + HDN.TongTien1 + "')";
query.insert(sql);
}
public void insert(Class_HoaDonNhap HDN)
{
string sql = "INSERT INTO KhachHang(MaHoaDonNhap,NgayNhap,MaNhanVien,MaNhaCungCap,TongTien) VALUES(";
sql += HDN.MaHoaDonNhap1 + ",N'" + HDN.NgayNhap1 + "',N'" + HDN.MaNhanVien1 + "',N'" + HDN.MaNhaCungCap1 + "',N'" + HDN.TongTien1 + "')";
query.insert(sql);
}
public void delete(Class_HoaDonNhap HDN)
{
string sql = "DELETE FROM HoaDonNhap WHERE MaHoaDonNhap = " + HDN.MaHoaDonNhap1;
query.insert(sql);
}
