public async Task <IActionResult> PutTinhTrangMonAn(MonAn monAn, int idMon)
{
var a = await _context.MonAns.FindAsync(idMon);
if (a == null)
{
return(NotFound());
}
a.trangthai = monAn.trangthai;
_context.MonAns.Update(a);
await _context.SaveChangesAsync();
return(Ok(a));
}
public ActionResult Details(int?id)
{
if (!Manager.LoggedAsAdmin())
{
return(RedirectToAction("Login", "Admin"));
}
if (id == null)
{
return(RedirectToAction("Index"));
}
MonAn monAn = data.MonAns.SingleOrDefault(i => i.IDMonAn == id);
return(View(monAn));
}
// GET: MonAns/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MonAn monAn = db.MonAns.Find(id);
if (monAn == null)
{
return(HttpNotFound());
}
return(View(monAn));
}
public void ThemMonAn(string tenMonAn, string tenLoaiMon, int giaTien, string hinhAnh)
{
QuanLyQuanCaPheEntities qlcf = new QuanLyQuanCaPheEntities();
MonAn ma = new MonAn();
ma.TenMonAn = tenMonAn;
ma.MaLoaiMon = LayMaLoaiMon(tenLoaiMon);
ma.Gia = giaTien;
ma.HinhAnh = hinhAnh;
ma.xoa = false;
qlcf.MonAns.Add(ma);
qlcf.SaveChanges();
}
public static bool CapNhatMonAn(MonAn monAn, string listNguyenLieu)
{
//Thêm món ăn
string query = " EXEC uspThemMonAn @maMonAn,@listNguyenLieu,@mamon,@tenmon,@loaimon,@anhminhhoa,@dongia";
//truyền tham số vào câu truy vấn
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@maMonAn", SqlDbType.VarChar)
{
IsNullable = false, Value = monAn.Ma
},
new SqlParameter("@listNguyenLieu", SqlDbType.VarChar)
{
IsNullable = false, Value = listNguyenLieu
},
new SqlParameter("@tenmon", SqlDbType.NVarChar)
{
IsNullable = false, Value = monAn.Ten
},
new SqlParameter("@loaimon", SqlDbType.NVarChar)
{
IsNullable = false, Value = monAn.Loai
},
new SqlParameter("@anhminhhoa", SqlDbType.VarChar)
{
IsNullable = false, Value = monAn.TenHinhAnh
},
new SqlParameter("@dongia", SqlDbType.Decimal)
{
IsNullable = false, Value = monAn.Gia
},
};
try
{
Dataprovider.ExcuteNonQuery(query, parameters.ToArray());
}
catch (Exception ex)
{
Utility.Log(ex);
return(false);
}
return(true);
}
public MonAn LayMonAnTheoMa(int id)
{
using (DatBanAnMonAnDataContext context = new DatBanAnMonAnDataContext())
{
MonAn list = context.MonAns
.FirstOrDefault(x => x.MaMA == id);
if (list != null)
{
list.LoaiMonAn = null;
list.ChiTietPDs.Clear();
}
return(list);
}
}
public static void CapNhatMonAn(MonAn monAn)
{
DataAccessHelper db = new DataAccessHelper();
SqlCommand cmd = db.Command("CAP_NHAT_MON_AN");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaMonAn", monAn.MaMonAn);
cmd.Parameters.AddWithValue("@TenMonAn", monAn.TenMonAn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
db.dt = new DataTable();
da.Fill(db.dt);
}
// GET: MonAns/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MonAn monAn = db.MonAns.Find(id);
if (monAn == null)
{
return(HttpNotFound());
}
ViewBag.MaChuDe = new SelectList(db.ChuDes, "MaChuDe", "TenChuDe", monAn.MaChuDe);
return(View(monAn));
}
// GET: MonAns/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MonAn monAn = db.MonAns.Find(id);
if (monAn == null)
{
return(HttpNotFound());
}
ViewBag.MaCongDung = new SelectList(db.CongDungs, "MaCongDung", "TenCongDung", monAn.MaCongDung);
return(View(monAn));
}
private void btnXoa_Click(object sender, EventArgs e)
{
MonAn monAn = model.MonAn.FirstOrDefault(x => x.ma.ToString() == txtMaMonAn.Text);
if (monAn != null)
{
monAn.trangThai = false;
model.SaveChanges();
}
else
{
MessageBox.Show("Món ăn không tồn tại");
}
TB_CBNull();
BildingToDataGirdView(model.MonAn.Where(x => x.trangThai == true).ToList());
}
public static void CapNhatMonAn(MonAn monAn)
{
DataAccessHelper.GetInstance().Open();
SqlCommand cmd = DataAccessHelper.GetInstance().Command("CapNhatMonAn");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaMonAn", monAn.MaMonAn);
cmd.Parameters.AddWithValue("@TenMonAn", monAn.TenMonAn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataAccessHelper.GetInstance().SetDataTable(new DataTable());
da.Fill(DataAccessHelper.GetInstance().GetDataTable());
DataAccessHelper.GetInstance().Close();
}
// POST api/MonAn
public HttpResponseMessage PostMonAn(MonAn monan)
{
if (ModelState.IsValid)
{
db.MonAn.Add(monan);
db.SaveChanges();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, monan);
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = monan.MaMonAn }));
return(response);
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
public ActionResult Edit(FormCollection form, HttpPostedFileBase fileUpload)
{
string tenMonAn = form["TenMonAn"];
int id = Convert.ToInt32(form["IDMonAn"]);
decimal phiVanChuyen = Convert.ToDecimal(form["PhiVanChuyen"]);
MonAn monAn = data.MonAns.SingleOrDefault(i => i.IDMonAn == id);
ViewBag.MessageFail = string.Empty;
if (string.IsNullOrWhiteSpace(tenMonAn))
{
ViewBag.MessageFail += "Tên món ăn không hợp lệ. ";
}
if (Convert.ToInt32(phiVanChuyen) % 500 != 0)
{
ViewBag.MessageFail += "Phí vận chuyển không hợp lệ. ";
}
if (!string.IsNullOrEmpty(ViewBag.MessageFail))
{
return(View(monAn));
}
try
{
if (fileUpload.ContentLength > 0)
{
string _FileName = Path.GetFileName(fileUpload.FileName);
string _path = Path.Combine(Server.MapPath("~/Images/MonAn/"), _FileName);
if (!System.IO.File.Exists(_path))
{
fileUpload.SaveAs(_path);
}
monAn.HinhAnh = _FileName;
}
}
catch
{
}
if (ModelState.IsValid)
{
UpdateModel(monAn);
data.SubmitChanges();
}
ViewBag.MessageSuccess = "Đã thay đổi thông tin món ăn [" + tenMonAn + "] thành công";
return(RedirectToAction("Index"));
}
// GET: MonAns/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MonAn monAn = db.MonAns.Find(id);
if (monAn == null)
{
return(HttpNotFound());
}
List <MonAn> lstMonAn = db.MonAns.Where(n => n.MaChuDe == monAn.MaChuDe).OrderBy(n => n.TenMonAn).ToList();
ViewBag.ListSame = lstMonAn;
return(View(monAn));
}
private void btnXoa_Click(object sender, EventArgs e)
{
MonAn ma = GetDSMon();
if (MessageBox.Show("Bạn có chắc muốn xóa loại món này?", "Xác Nhận", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
if (monan.XoaMon(ma))
{
MessageBox.Show("Xóa thành công");
}
else
{
MessageBox.Show("Không thể xóa");
}
}
LoadMonAn();
}
private void EditMonAnHoa()
{
QLBanMonAnClassesDataContext db = new QLBanMonAnClassesDataContext();
MonAn hh = db.MonAns.Where(p => p.MaMonAn == txtMaHH.Text).SingleOrDefault();
hh.TenMonAn = txtTenHH.Text;
hh.Anh = txtAnhHH.Text;
hh.MaNguyenLieu = cbbTenNguyenLieuHH.SelectedValue.ToString();
hh.SoLuong = double.Parse(txtSoLuongHH.Text);
hh.DonGiaBan = double.Parse(txtDonGiaBanHH.Text);
hh.DonGiaNhap = double.Parse(txtDonGiaNhapHH.Text);
hh.GhiChu = txtGhiChuHH.Text;
db.SubmitChanges();
LoadDTGV_MonAn_Hoa();
}
public int insertMonAn(MonAn monan)
{
if (ktKhoachinh(monan.MaMonAn))
{
return(2);
}
try
{
db.MonAns.Add(monan);
db.SaveChanges();
return(1);
}
catch
{
return(0);
}
}
public ActionResult Delete_mon_an(MonAn mon)
{
try
{
// TODO: Add delete logic here
var obj = context.MonAns.SingleOrDefault(s => s.MaMonAn == mon.MaMonAn);
context.MonAns.Remove(obj);
context.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
private void btn_themdoan_Click(object sender, EventArgs e)
{
try
{
MonAn m = new MonAn();
m.Tenmonan = txt_tendoan.Text;
if (ma.themmonan(m))
{
MessageBox.Show("thêm món ăn thành công");
}
else
{
MessageBox.Show("thêm món ăn thất bại");
}
loaddoan();
}
catch { }
}
private void BildingToDataGirdView(List <MonAn> listMonAn)
{
int STT = 1;
DataTable dt = new DataTable();
dt.Columns.Add("STT");
dt.Columns.Add("Mã món ăn");
dt.Columns.Add("Tên món ăn");
dt.Columns.Add("Giá");
dt.Columns.Add("Loai Món ăn");
dt.Columns.Add("Đơn vị");
for (int i = 0; i < listMonAn.Count; i++, STT++)
{
MonAn m = listMonAn[i];
dt.Rows.Add(new string[] { STT.ToString(), m.ma.ToString(), m.ten, m.gia.ToString(), m.LoaiMonAn.ten, m.DonVi.ten });
}
dataMonAn.DataSource = dt;
}
public bool xoamonan(MonAn nl)
{
SqlCommand command = new SqlCommand("execute xoamonan @ma", db.GetConnection);
command.Parameters.Add("@ma", SqlDbType.Int).Value = nl.Mamonan;
command.Parameters.Add("@ten", SqlDbType.NVarChar).Value = nl.Tenmonan;
db.openConection();
if (command.ExecuteNonQuery() == 1)
{
db.closedConection();
return(true);
}
else
{
db.closedConection();
return(false);
}
}
public bool XoaMonAn(int mamaxoa)
{
try
{
using (DatBanAnMonAnDataContext context = new DatBanAnMonAnDataContext())
{
MonAn ma = context.MonAns.FirstOrDefault(x => x.MaMA == mamaxoa);
context.MonAns.DeleteOnSubmit(ma);
context.SubmitChanges();
return(true);
}
}
catch (Exception)
{
return(false);
throw;
}
}
private void InitDataBinding()
{
_obj = new MonAn();
Binding bind = new Binding("Text", _obj, "MonAnID", true, DataSourceUpdateMode.OnPropertyChanged);
Binding bind1 = new Binding("Text", _obj, "TenMonAn", true, DataSourceUpdateMode.OnPropertyChanged);
Binding bind5 = new Binding("Text", _obj, "DonViTinh", true, DataSourceUpdateMode.OnPropertyChanged);
Binding bind6 = new Binding("Text", _obj, "DonGia", true, DataSourceUpdateMode.OnPropertyChanged);
txtID.DataBindings.Add(bind);
txtTenmonan.DataBindings.Add(bind1);
txtDonvitinh.DataBindings.Add(bind5);
txtDongia.DataBindings.Add(bind6);
this.Loadloaimonan();
Binding bind3 = new Binding("Text", _sitem, "SearchType", true, DataSourceUpdateMode.OnPropertyChanged);
Binding bind4 = new Binding("Text", _sitem, "SearchContent", true, DataSourceUpdateMode.OnPropertyChanged);
txtLoaitimkiem.DataBindings.Add(bind3);
txtNoidungtimkiem.DataBindings.Add(bind4);
}
private void btn_suadoan_Click(object sender, EventArgs e)
{
try
{
MonAn m = new MonAn();
m.Tenmonan = txt_tendoan.Text;
m.Mamonan = id_doan;
if (ma.suamonan(m))
{
MessageBox.Show("sửa món ăn thành công");
}
else
{
MessageBox.Show("sửa món ăn thất bại");
}
loaddoan();
}
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
}
public ActionResult Edit(FormCollection form)
{
string tenMonAn = form["TenMonAn"];
int id = Convert.ToInt32(form["IDMonAn"]);
MonAn monAn = data.MonAns.SingleOrDefault(i => i.IDMonAn == id);
if (string.IsNullOrWhiteSpace(tenMonAn))
{
ViewBag.MessageFail = "Tên món ăn không hợp lệ";
return(View(monAn));
}
string tenCu = monAn.TenMonAn;
monAn.TenMonAn = tenMonAn;
UpdateModel(monAn);
data.SubmitChanges();
ViewBag.MessageSuccess = "Đã thay đổi tên món ăn: [" + tenCu + "] => [" + tenMonAn + "] thành công";
return(RedirectToAction("Index"));
}
public ActionResult XoaHoaDonChiTiet(int MaMonAn, string strURL)
{
//Nếu người dùng tự ý chỉnh URL truyền vào MaMonAn không có trong CSDL thì hiện ra trang báo lỗi.
MonAn MonAn = db.MonAn.SingleOrDefault(n => n.MaMon == MaMonAn);
if (MonAn == null)
{
Response.StatusCode = 404;
return(null);
}
List <HoaDonChiTiet> lstHoaDonChiTiet = LayHoaDonChiTiet();
HoaDonChiTiet sanpham = lstHoaDonChiTiet.SingleOrDefault(n => n.iMaMon == MaMonAn);
if (sanpham != null)
{
lstHoaDonChiTiet.RemoveAll(n => n.iMaMon == MaMonAn);
}
TongTien();
return(RedirectPermanent(strURL));
}
private bool LayMonAn(int maMon, int soLuong)
{
MonAn monAn = model.MonAn.FirstOrDefault(x => x.DonVi.ma == 1 && x.ma == maMon);
if (monAn != null)
{
if (LayNguyenLieu(maMon, soLuong))
{
return(true);
}
}
else
{
if (LayKho(maMon, soLuong))
{
return(true);
}
}
return(false);
}
public bool SuaMonAn(int mamasua, string tenmonan, int dongia, int maloai)
{
try
{
using (DatBanAnMonAnDataContext context = new DatBanAnMonAnDataContext())
{
MonAn ma = context.MonAns.FirstOrDefault(x => x.MaMA == mamasua);
ma.TenMonAn = tenmonan;
ma.DonGia = dongia;
ma.MaLoai = maloai;
context.SubmitChanges();
return(true);
}
}
catch (Exception)
{
return(false);
throw;
}
}
public List <MonAn> ListMonAnTrongPhieuDatTheoMaPD(int listmonmapd)
{
using (DatBanAnMonAnDataContext context = new DatBanAnMonAnDataContext())
{
List <MonAn> ma = new List <MonAn>();
List <ChiTietPD> list = context.ChiTietPDs
.Where(x => x.MaPD == listmonmapd)
.ToList();
list.ForEach(x =>
{
MonAn m = context.MonAns.FirstOrDefault(i => i.MaMA == x.MaMA);
ma.Add(m);
});
foreach (MonAn m in ma)
{
m.LoaiMonAn = null;
m.ChiTietPDs.Clear();
}
return(ma);
}
}
// DELETE api/MonAn/5
public HttpResponseMessage DeleteMonAn(int id)
{
MonAn monan = db.MonAn.Find(id);
if (monan == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
db.MonAn.Remove(monan);
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK, monan));
}
