private List <Class_NguyenLieu_MonAn> test1()
{
string sql = "SELECT * FROM NguyenLieu_MonAn";
List <Class_NguyenLieu_MonAn> list = new List <Class_NguyenLieu_MonAn>();
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 MaMonAn = reader.GetString(0);
string MaNguyenLieu = reader.GetString(1);
double SoLuong = reader.GetDouble(1);
Class_NguyenLieu_MonAn Test = new Class_NguyenLieu_MonAn(MaMonAn, MaNguyenLieu, SoLuong);
list.Add(Test);
}
}
}
con.Close();
return(list);
}
public void delete(Class_NguyenLieu_MonAn NL_MA)
{
string sql = "DELETE FROM NguyenLieu_MonAn WHERE MaMonAn = " + NL_MA.MaMonAn1 + " and MaNguyenLieu = " + NL_MA.MaNguyenLieu1;
query.insert(sql);
query.insert(sql);
}
public void update(Class_NguyenLieu_MonAn NL_MA)
{
string sql = "UPDATE NguyenLieu_MonAn WHERE SET MaMonAn=" + NL_MA.MaMonAn1 + ",MaNguyenLieu=N'" +
NL_MA.MaNguyenLieu1 + "', SoLuong=N'" + NL_MA.SoLuong1 + "')";
query.insert(sql);
}
public void insert(Class_NguyenLieu_MonAn NL_MA)
{
string sql = "INSERT INTO NguyenLieu_MonAn(MaMonAn,MaNguyenLieu,SoLuong) VALUES(";
sql += NL_MA.MaMonAn1 + ",N'" + NL_MA.MaNguyenLieu1 + "',N'" + NL_MA.SoLuong1 + "')";
query.insert(sql);
}
private List <Class_NguyenLieu_MonAn> test1()
{
string sql = "SELECT * FROM NguyenLieu_MonAn";
List <Class_NguyenLieu_MonAn> list = new List <Class_NguyenLieu_MonAn>();
query.ketnoiSQL();
using (DbDataReader reader = query.Reader(sql))
{
if (reader.HasRows)
{
while (reader.Read())
{
string MaMonAn = reader.GetString(0);
string MaNguyenLieu = reader.GetString(1);
double SoLuong = reader.GetDouble(1);
Class_NguyenLieu_MonAn Test = new Class_NguyenLieu_MonAn(MaMonAn, MaNguyenLieu, SoLuong);
list.Add(Test);
}
}
}
query.DongketnoiSQL();
return(list);
}
