public void AddDishDetail(Models.ChiTietMonAn a)
{
Database db = new Database();
DataTable dtma = db.Query("select MaKhauPhanAn from MonAn where TenKhauPhanAn = N'" + a.MonAn + "';");
DataTable dtnl = db.Query("select MaNguyenLieu from NguyenLieu where TenNguyenLieu = N'" + a.NguyenLieu + "';");
db.Insert("insert into ChiTietMonAn values (" + dtma.Rows[0]["MaKhauPhanAn"].ToString() + "," + dtnl.Rows[0]["MaNguyenLieu"].ToString() + ", " + a.SoLuong + ");");
}
public JsonResult DishDetailList()
{
List <Models.ChiTietMonAn> DishDetailList = new List <Models.ChiTietMonAn>();
Database db = new Database();
DataTable dt = db.Query("select STT, TenKhauPhanAn, TenNguyenLieu, ct.SoLuong as SoLuong from ChiTietMonAn as ct, MonAn as ma, NguyenLieu as nl where ct.MaKhauPhanAn = ma.MaKhauPhanAn and ct.MaNguyenLieu = nl.MaNguyenLieu;");
for (int i = 0; i < dt.Rows.Count; i++)
{
Models.ChiTietMonAn DishDetail = new Models.ChiTietMonAn();
DishDetail.STT = dt.Rows[i]["STT"].ToString();
DishDetail.MonAn = dt.Rows[i]["TenKhauPhanAn"].ToString();
DishDetail.NguyenLieu = dt.Rows[i]["TenNguyenLieu"].ToString();
DishDetail.SoLuong = dt.Rows[i]["SoLuong"].ToString();
DishDetailList.Add(DishDetail);
}
return(Json(DishDetailList));
}
