public static List <MonAn_DTO> LocNhomMonAn(string tenNhomMon)
{
string chuoiTruyVan = "Select * From MonAn where MaNhomMon like '%" + tenNhomMon + "%'";
conn = DataProvider.OpenConnection();
DataTable dt = DataProvider.LayDataTable(chuoiTruyVan, conn);
if (dt.Rows.Count == 0)
{
return(null);
}
List <MonAn_DTO> lstMonAn = new List <MonAn_DTO>();
for (int i = 0; i < dt.Rows.Count; i++)
{
MonAn_DTO monAn = new MonAn_DTO();
monAn.ID = int.Parse(dt.Rows[i]["ID"].ToString());
monAn.TenNhomMon = NhomMonAn_DAO.layTenNhomMonAn(dt.Rows[i]["MaNhomMon"].ToString());
monAn.TenMonAn = dt.Rows[i]["TenMonAn"].ToString();
monAn.DonViTinh = dt.Rows[i]["DonViTinh"].ToString();
monAn.Gia = int.Parse(dt.Rows[i]["Gia"].ToString());
monAn.IMAGE = DataProvider.LoadImage(conn, $"select Image from MonAn where ID='{monAn.ID}'");
lstMonAn.Add(monAn);
}
DataProvider.CloseConnection(conn);
return(lstMonAn);
}
// ------------------------ thêm món ăn -----------------------
public static bool ThemMonAn(MonAn_DTO monAn)
{
string maNHOM = NhomMonAn_DAO.layIDNhomMonAn(monAn.TenNhomMon);;
string QueryString = string.Format("insert into MonAn(MaNhomMon,TenMonAn,DonViTinh,Gia,Image) values('{0}','{1}','{2}','{3}',@0)", maNHOM, monAn.TenMonAn, monAn.DonViTinh, monAn.Gia, monAn.IMAGE);
conn = DataProvider.OpenConnection();
try
{
DataProvider.SaveImage(DataProvider.ImageToByte(monAn.IMAGE, System.Drawing.Imaging.ImageFormat.Jpeg), conn, QueryString);
DataProvider.CloseConnection(conn);
return(true);
}
catch (Exception)
{
DataProvider.CloseConnection(conn);
return(false);
}
}
//------------------------ sửa món ăn ---------------------------------
public static bool SuaMonAn(MonAn_DTO monAn)
{
// chuỗi truy vấn sửa món ăn
string maNHOM = NhomMonAn_DAO.layIDNhomMonAn(monAn.TenNhomMon);
string QueryString = string.Format("UPDATE MonAn set MaNhomMon = '{0}', TenMonAn = '{1}', DonViTinh = '{2}', Gia = {3}, Image = @0 where ID = " + monAn.ID + "", maNHOM, monAn.TenMonAn, monAn.DonViTinh, monAn.Gia, monAn.IMAGE);
conn = DataProvider.OpenConnection();
try
{
DataProvider.SaveImage(DataProvider.ImageToByte(monAn.IMAGE, System.Drawing.Imaging.ImageFormat.Jpeg), conn, QueryString);
DataProvider.CloseConnection(conn);
return(true);
}
catch (Exception)
{
DataProvider.CloseConnection(conn);
return(false);
}
}
