private List <Class_NguyenLieu> Select()
{
string sql = "SELECT * FROM NguyenLieu";
List <Class_NguyenLieu> list = new List <Class_NguyenLieu>();
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=DESKTOP-RPK6PAD\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 MaNguyenLieu = reader.GetString(0);
string TenNguyenLieu = reader.GetString(1);
string DonViTinh = reader.GetString(2);
double SoLuong = reader.GetDouble(3);
double DonGiaNhap = reader.GetDouble(4);
double DonGiaBan = reader.GetDouble(5);
string CongDung = reader.GetString(6);
string YeuCau = reader.GetString(7);
string ChongChiDinh = reader.GetString(8);
Class_NguyenLieu nl = new Class_NguyenLieu(MaNguyenLieu, TenNguyenLieu, DonViTinh, SoLuong, DonGiaNhap, DonGiaBan, CongDung, YeuCau, ChongChiDinh);
list.Add(nl);
}
}
}
con.Close();
return(list);
}
public new List <Class_NguyenLieu> Select()
{
string sql = "SELECT * FROM NguyenLieu";
List <Class_NguyenLieu> list = new List <Class_NguyenLieu>();
query.ketnoiSQL();
using (DbDataReader reader = query.Reader(sql))
{
if (reader.HasRows)
{
while (reader.Read())
{
string MaNguyenLieu = reader.GetString(0);
string TenNguyenLieu = reader.GetString(1);
string DonViTinh = reader.GetString(2);
double SoLuong = (double)reader.GetValue(3);
double DonGiaNhap = reader.GetDouble(4);
double DonGiaBan = reader.GetDouble(5);
string CongDung = reader.GetString(6);
string YeuCau = reader.GetString(7);
string ChongChiDinh = reader.GetString(8);
Class_NguyenLieu nl = new Class_NguyenLieu(MaNguyenLieu, TenNguyenLieu, DonViTinh, SoLuong, DonGiaNhap, DonGiaBan, CongDung, YeuCau, ChongChiDinh);
list.Add(nl);
}
}
}
query.DongketnoiSQL();
return(list);
}
public void update(Class_NguyenLieu NL)
{
string sql = "UPDATE NguyenLieu WHERE SET MaNguyenLieu=" + NL.MaNguyenLieu1 + ",TenNguyenLieu=N'" +
NL.TenNguyenLieu1 + "', DonViTinh=N'" + NL.DonViTinh1 + "', SoLuong='" + NL.SoLuong1 + ",DonGiaNhap=N'" + NL.DonGiaNhap1
+ ",DonGiaBan=N'" + NL.DonGiaBan1 + ",CongDung=N'" + NL.CongDung1 + ",YeuCau=N'" + NL.YeuCau1 + ",ChongChiDinh=N'" + NL.ChongChiDinh1 + "')";
query.insert(sql);
}
public void insert(Class_NguyenLieu NL)
{
string sql = "INSERT INTO NguyenLieu(MaNguyenLieu,TenNguyenLieu,DonViTinh,SoLuong,DonGiaNhap,DonGiaBan,CongDung,YeuCau,ChongChiDinh) VALUES(";
sql += NL.MaNguyenLieu1 + ",N'" + NL.TenNguyenLieu1 + "',N'" + NL.DonViTinh1 + "',N'" + NL.SoLuong1 + "',N'"
+ NL.DonGiaNhap1 + "',N'" + NL.DonGiaBan1 + "',N'" + NL.CongDung1 + NL.YeuCau1 + "',N'" + NL.ChongChiDinh1 + "')";
query.insert(sql);
}
public void delete(Class_NguyenLieu NL)
{
string sql = "DELETE FROM NguyenLieu WHERE MaNguyenLieu = " + NL.MaNguyenLieu1;
query.insert(sql);
}
