// ==============================================================================Phản hồi công thức
public ActionResult P_hoi(string noidung)
{
if (ModelState.IsValid)
{
PhanHoi phanhoi = new PhanHoi();
if (Session["ThanhVien"] != null)
{
if (noidung != null)
{
ThanhVien tv = Session["ThanhVien"] as ThanhVien;
CongThuc ct = Session["Ctiet"] as CongThuc;
phanhoi.ID_congthuc = ct.ID_congthuc;
phanhoi.ID_user = tv.ID_user;
phanhoi.NgayDang = DateTime.Now;
phanhoi.TieuDe = null;
phanhoi.NoiDung = noidung;
db.PhanHois.Add(phanhoi);
db.SaveChanges();
return(RedirectToAction("Chitietcongthuc", "Home", new { id = ct.ID_congthuc }));
}
else
{
ModelState.AddModelError("", "Bạn chưa nhập nội dung!");
}
}
else
{
ModelState.AddModelError("", "Bạn cần đăng nhập để gửi phản hồi!");
}
}
return(RedirectToAction("Login"));
}
//=========================================================================== trả lời phản hồi cong thuc
public ActionResult Traloi_ph_hoi_cthuc(int id, string noidung)
{
if (ModelState.IsValid)
{
TraLoi_PhanHoi trl = new TraLoi_PhanHoi();
if (Session["ThanhVien"] != null)
{
if (noidung != null)
{
ThanhVien tv = Session["ThanhVien"] as ThanhVien;
CongThuc ct = Session["Ctiet"] as CongThuc;
trl.MaThanhVien = tv.ID_user;
trl.NoiDung = noidung;
trl.MaPhanHoi = id;
trl.NgayDang = DateTime.Now;
db.TraLoi_PhanHoi.Add(trl);
db.SaveChanges();
return(RedirectToAction("Chitietcongthuc", "Home", new { id = ct.ID_congthuc }));
}
else
{
ModelState.AddModelError("", "Bạn chưa nhập nội dung!");
}
}
else
{
ModelState.AddModelError("", "Bạn cần đăng nhập để gửi phản hồi!");
}
}
return(RedirectToAction("Login"));
}
public ActionResult Recipe_add(CongThuc ct, string LoaiCongThuc, string[] NL, string[] SL, string[] NoiDung)
{
NguoiDung nd = (NguoiDung)Session["NguoiDung"];
var lct = db.LoaiCongThucs.FirstOrDefault(x => x.TenLoaiCT == LoaiCongThuc);
ct.Video.Trim();
ct.MaLoaiCongThuc = lct.MaLoaiCongThuc;
ct.MaNguoiTao = nd.UserID;
ct.NgayTao = DateTime.Now;
db.CongThucs.Add(ct);
db.SaveChanges();
for (int i = 0; i < NL.Count(); i++)
{
if (NL[i] != null)
{
NguyenLieu nl = new NguyenLieu();
nl.MaCongThuc = db.CongThucs.FirstOrDefault(x => x.TenCongThuc == ct.TenCongThuc).ID_congthuc;
nl.TenNguyenLieu = NL[i];
nl.SoLuong = SL[i];
db.NguyenLieux.Add(nl);
}
}
for (int i = 0; i < NoiDung.Count(); i++)
{
if (NoiDung[i] != null)
{
NoiDungCT ndct = new NoiDungCT();
ndct.MaCongThuc = db.CongThucs.FirstOrDefault(x => x.TenCongThuc == ct.TenCongThuc).ID_congthuc;
ndct.NoiDung = NoiDung[i];
db.NoiDungCTs.Add(ndct);
}
}
db.SaveChanges();
return(RedirectToAction("Recipe"));
}
private void btnLuu_Click(object sender, EventArgs e)
{
int maMon = Int32.Parse(cbMonAn.SelectedValue.ToString());
int maNguyenLieu = Int32.Parse(cbNguyenLieu.SelectedValue.ToString());
if (txtChiPhi.Text == "")
{
MessageBox.Show("Vui lòng nhập khối lượng nguyên liệu cần!");
}
else
{
CongThuc ct = model.CongThuc.FirstOrDefault(x => x.maMon == maMon && x.maNguyenLieu == maNguyenLieu);
if (ct == null)
{
CongThuc congThuc = new CongThuc();
congThuc.maMon = Int32.Parse(cbMonAn.SelectedValue.ToString());
congThuc.maNguyenLieu = Int32.Parse(cbNguyenLieu.SelectedValue.ToString());
congThuc.chiPhi = float.Parse(txtChiPhi.Text);
model.CongThuc.Add(congThuc);
}
else
{
ct.chiPhi = float.Parse(txtChiPhi.Text);
}
}
model.SaveChanges();
BilingListToDataGridView(model.CongThuc.ToList());
ButtonLock(false);
TB_CBLock(false);
TB_CBNull();
}
public async Task <IActionResult> PutCongThuc(int id, CongThuc congThuc)
{
if (id != congThuc.Id)
{
return(BadRequest());
}
_context.Entry(congThuc).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CongThucExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void DeleteCongThuc(string maDoUong, string maNguyenLieu)
{
CongThuc cts = qlcf.CongThucs.Where(c => c.MaDoUong == maDoUong && c.MaNguyenLieu == maNguyenLieu).FirstOrDefault();
if (cts != null)
{
qlcf.CongThucs.DeleteOnSubmit(cts);
qlcf.SubmitChanges();
}
}
public ActionResult Recipe_edit(int id)
{
CongThuc ct = new CongThuc();
ct = db.CongThucs.Find(id);
var model = db.LoaiCongThucs.Where(x => x.TenLoaiCT != null);
ViewBag.DS = model;
return(View(ct));
}
public bool KiemTraKhoaNgoaiNguyenLieu(string maNguyenLieu)
{
CongThuc ct = qlcf.CongThucs.Where(c => c.MaNguyenLieu == maNguyenLieu).FirstOrDefault();
ChiTietPhieuNhap ctpn = qlcf.ChiTietPhieuNhaps.Where(c => c.MaNguyenLieu == maNguyenLieu).FirstOrDefault();
if (ct == null && ctpn == null)
{
return(false);
}
else
{
return(true);
}
}
private void BilingListToDataGridView(List <CongThuc> listCongThuc)
{
DataTable dt = new DataTable();
dt.Columns.Add("STT");
dt.Columns.Add("Món ăn");
dt.Columns.Add("Nguyên liệu");
dt.Columns.Add("Tốn");
int STT = 1;
for (int i = 0; i < listCongThuc.Count; i++, STT++)
{
CongThuc ct = listCongThuc[i];
dt.Rows.Add(new string[] { STT.ToString(), ct.MonAn.ten, ct.NguyenLieu.ten, ct.chiPhi.ToString() });
}
dataCongThuc.DataSource = dt;
}
public async Task <ActionResult <CongThuc> > PostCongThuc(CongThuc congThuc)
{
var ct = await _context.CongThucs.Where(x => x.id_monan == congThuc.id_monan && x.id_nguyenlieu == congThuc.id_nguyenlieu).FirstOrDefaultAsync();
if (ct == null)
{
_context.CongThucs.Add(congThuc);
}
else
{
ct.soluong = congThuc.soluong;
_context.CongThucs.Update(ct);
}
await _context.SaveChangesAsync();
return(CreatedAtAction("GetCongThuc", new { id = congThuc.Id }, congThuc));
}
private void btnXoa_Click(object sender, EventArgs e)
{
int maMon = Int32.Parse(cbMonAn.SelectedValue.ToString());
int maNguyenLieu = Int32.Parse(cbNguyenLieu.SelectedValue.ToString());
CongThuc ct = model.CongThuc.FirstOrDefault(x => x.maMon == maMon && x.maNguyenLieu == maNguyenLieu);
if (ct == null)
{
MessageBox.Show("Không tìm thấy công thức cần xóa!");
}
else
{
model.CongThuc.Remove(ct);
model.SaveChanges();
}
TB_CBNull();
BilingListToDataGridView(model.CongThuc.ToList());
}
public void InsertCongThuc(string maDoUong, string maNguyenLieu, int soLuong)
{
CongThuc cts = qlcf.CongThucs.Where(c => c.MaDoUong == maDoUong && c.MaNguyenLieu == maNguyenLieu).FirstOrDefault();
if (cts == null)
{
CongThuc ct = new CongThuc();
ct.MaDoUong = maDoUong;
ct.MaNguyenLieu = maNguyenLieu;
ct.SoLuong = soLuong;
qlcf.CongThucs.InsertOnSubmit(ct);
qlcf.SubmitChanges();
}
else
{
cts.SoLuong += soLuong;
qlcf.SubmitChanges();
}
}
public ActionResult Boluu() //--------------------------------- Bỏ lưu công thức yêu thích
{
if (ModelState.IsValid)
{
Luu_tru save_ = new Luu_tru();
if (Session["ThanhVien"] != null)
{
ThanhVien tv = Session["ThanhVien"] as ThanhVien;
CongThuc ct = Session["Ctiet"] as CongThuc;
save_ = db.Luu_tru.Where(x => x.ID_congthuc == ct.ID_congthuc && x.ID_user == tv.ID_user).FirstOrDefault();
db.Luu_tru.Remove(save_);
db.SaveChanges();
return(RedirectToAction("Chitietcongthuc", "Home", new { id = ct.ID_congthuc }));
}
else
{
ModelState.AddModelError("", "Bạn chưa đăng nhập!");
}
}
return(RedirectToAction("Login"));
}
public ActionResult Luu() //------------------------------------------ Lưu công thức yêu thích
{
if (ModelState.IsValid)
{
Luu_tru save_ = new Luu_tru();
if (Session["ThanhVien"] != null)
{
ThanhVien tv = Session["ThanhVien"] as ThanhVien;
CongThuc ct = Session["Ctiet"] as CongThuc;
save_.ID_congthuc = ct.ID_congthuc;
save_.ID_blog = null;
save_.ID_user = tv.ID_user;
save_.Ngay_luu = DateTime.Now;
db.Luu_tru.Add(save_);
db.SaveChanges();
return(RedirectToAction("Chitietcongthuc", "Home", new { id = ct.ID_congthuc }));
}
else
{
ModelState.AddModelError("", "Bạn chưa đăng nhập!");
}
}
return(RedirectToAction("Login"));
}
public ActionResult Recipe_edit(CongThuc ct, long[] maNL, string[] NL, string[] SL, long[] maND, string[] NoiDung, string LoaiCongThuc)
{
CongThuc congthuc = new CongThuc();
congthuc = db.CongThucs.Find(ct.ID_congthuc);
congthuc.TenCongThuc = ct.TenCongThuc;
if (ct.AnhMinhHoa != null)
{
congthuc.AnhMinhHoa = ct.AnhMinhHoa;
}
congthuc.Video = ct.Video.Trim();
congthuc.DoKho = ct.DoKho;
congthuc.TieuDe = ct.TieuDe;
congthuc.ThoiGianCB = ct.ThoiGianCB;
congthuc.ThoiGianNau = ct.ThoiGianNau;
congthuc.MaLoaiCongThuc = db.LoaiCongThucs.FirstOrDefault(x => x.TenLoaiCT == LoaiCongThuc).MaLoaiCongThuc;
congthuc.TopHot = ct.TopHot;
congthuc.TrangThai = ct.TrangThai;
congthuc.NgayChinhSua = DateTime.Now;
NguoiDung nd = (NguoiDung)Session["NguoiDung"];
ct.MaNguoiChinhSua = nd.UserID;
db.SaveChanges();
for (int i = 0; i < maNL.Count(); i++)
{
if (maNL[i] != 0)
{
var nl = db.NguyenLieux.Find(maNL[i]);
nl.TenNguyenLieu = NL[i];
nl.SoLuong = SL[i];
db.SaveChanges();
}
else
{
var nl = new NguyenLieu();
nl.MaCongThuc = ct.ID_congthuc;
nl.SoLuong = SL[i];
nl.TenNguyenLieu = NL[i];
db.NguyenLieux.Add(nl);
db.SaveChanges();
}
}
for (int i = 0; i < NoiDung.Count(); i++)
{
if (maND[i] != 0)
{
var noidung = db.NoiDungCTs.Find(maND[i]);
noidung.NoiDung = NoiDung[i];
db.SaveChanges();
}
else
{
var noidung = new NoiDungCT();
noidung.MaCongThuc = ct.ID_congthuc;
noidung.NoiDung = NoiDung[i];
db.NoiDungCTs.Add(noidung);
db.SaveChanges();
}
}
return(RedirectToAction("Recipe"));
}
