void AddButtonNuoc(MONAN item, Point local, Size size, TabPage tab)
{
Button newButton = new Button();
Label newLabel = new Label();
tab.Controls.Add(newButton);
tab.Controls.Add(newLabel);
newButton.Name = "btn" + item.IDMonAn;
Image img;
try
{
img = Image.FromFile(@"../../Images/" + item.HinhMA);
}
catch
{
img = Image.FromFile(@"../../Images/default.jpg");
}
newButton.BackgroundImage = img;
newButton.BackgroundImageLayout = ImageLayout.Stretch;
newButton.Location = local;
newButton.Size = size;
newButton.MouseDown += btnMonNuoc_Click;
newButton.Tag = item.IDMonAn;
newLabel.Text = item.TenMon;
newLabel.Location = new Point(local.X, local.Y + 140);
newLabel.Size = new Size(size.Width, 20);
newLabel.TextAlign = ContentAlignment.MiddleCenter;
newLabel.Name = "lb" + item.IDMonAn;
}
public ActionResult Delete(int id, FormCollection collection, int?page)
{
MONAN ctv = data.MONANs.SingleOrDefault(i => i.ID_MonAn == id);
int countMonAn = data.DONHANGs.Count(i => i.ID_MonAn == id);
int coutKM = data.KhuyenMais.Count(i => i.ID_MonAn == id);
if (countMonAn > 0)
{
ViewBag.ErrorBody = string.Format("Không thể Xóa do [{0}] đang có [{1}] đơn hàng.", ctv.TenMonAn, countMonAn);
CONGTACVIEN tk = (CONGTACVIEN)Session["TenTK_CTV"];
var monan = from m in data.MONANs where m.MaTK_CTV == tk.MaTK_CTV select m;
return(View("Index", monan));
}
if (coutKM > 0)
{
ViewBag.ErrorKM = string.Format("Không thể Xóa do [{0}] đang được Khuyến Mại.", ctv.TenMonAn);
CONGTACVIEN tk = (CONGTACVIEN)Session["TenTK_CTV"];
var monan = from m in data.MONANs where m.MaTK_CTV == tk.MaTK_CTV select m;
return(View("Index", monan));
}
else
if (ModelState.IsValid)
{
data.MONANs.DeleteOnSubmit(ctv);
data.SubmitChanges();
}
return(RedirectToAction("Index", "CTVMonAn"));
}
public ActionResult Edit(FormCollection form, HttpPostedFileBase fileUpload)
{
int id = Convert.ToInt32(form["ID_MonAn"]);
string mota = form["GioiThieu"];
MONAN monan = data.MONANs.SingleOrDefault(i => i.ID_MonAn == id);
monan.NgayCapNhap = DateTime.Now;
String path = "";
String fileName = "";
if (fileUpload == null)
{
}
else
{
fileName = Path.GetFileName(fileUpload.FileName);
path = Path.Combine(Server.MapPath("~/images/MonAn"), fileName);
fileUpload.SaveAs(path);
monan.AnhBia = fileName;
}
if (ModelState.IsValid)
{
monan.MoTa = mota;
UpdateModel(monan);
data.SubmitChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Insert(MONAN monan)
{
if (ModelState.IsValid)
{
var dao = new AdminDao();
if (dao.CheckTenMonAn(monan.TenMonAn))
{
ModelState.AddModelError("", "Tên món ăn đã tồn tại");
}
else
{
int id = dao.InsertMonAn(monan);
if (id > 0)
{
return(Redirect("/dsmonan"));
}
else
{
ModelState.AddModelError("", "Thêm không thành công!");
}
}
}
SetViewBag();
return(View());
}
public ActionResult Create(MONAN monan)
{
try
{
List <LOAI> list = _db.LOAIs.ToList();
// TODO: Add insert logic here
if (monan.UploadImage != null)
{
string fileName = Path.GetFileNameWithoutExtension(monan.UploadImage.FileName);
string extension = Path.GetExtension(monan.UploadImage.FileName);
fileName = fileName + extension;
monan.HINHANH = "~/Assets/admin/img/" + fileName;
monan.UploadImage.SaveAs(Path.Combine(Server.MapPath("~/Assets/admin/img/"), fileName));
}
ViewBag.listLoai = new SelectList(list, "MaLoai", "TenLoai", 1);
_db.MONANs.Add(monan);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Update(MONAN monan)
{
if (ModelState.IsValid)
{
var dao = new AdminDao();
if (dao.CheckTenMonAnUpdate(monan.TenMonAn, monan.MaMonAn))
{
ModelState.AddModelError("", "Tên món ăn đã tồn tại!");
}
else
{
bool result = dao.UpdateMonAn(monan);
if (result)
{
return(Redirect("/dsmonan"));
}
else
{
ModelState.AddModelError("", "Chỉnh sửa không thành công!");
}
}
}
SetViewBag(monan.MaMonAn);
return(View());
}
public List <MONAN> LayDanhMucMonAn(int tab)
{
/* (EntityModels)
* var queryMA = from nu in ql.MONANs
* where nu.IDDanhMuc == tab && nu.TrangThai == false
* select nu;
*/
DBMain db = new DBMain();
List <MONAN> lstNuoc = new List <MONAN>();
string query = "Select * From MONAN Where IDDanhMuc = '"
+ tab + "' And TrangThai = 0";
var kq = db.ExecuteQueryDataSet(query, CommandType.Text);
foreach (DataRow item in kq.Rows)
{
MONAN nu = new MONAN();
nu.IDMonAn = item["IDMonAn"].ToString();
nu.IDDanhMuc = (int)item["IDDanhMuc"];
nu.GiaTien = (int)item["GiaTien"];
nu.TenMon = item["TenMon"].ToString();
nu.HinhMA = item["HinhMA"].ToString();
lstNuoc.Add(nu);
}
return(lstNuoc);
}
public ActionResult DeleteConfirmed(string id)
{
MONAN mONAN = db.MONANs.Find(id);
db.MONANs.Remove(mONAN);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//Thêm món ăn mới
public int InsertMonAn(MONAN entity)
{
entity.SoLuongBan = 0;
entity.NgayCapNhat = DateTime.Now;
db.MONANs.Add(entity);
db.SaveChanges();
return(entity.MaMonAn);
}
public static MONAN TimMon(int maMon)
{
QLNhaHangDataContext db = new QLNhaHangDataContext();
MONAN mon = new MONAN();
mon = db.MONANs.Single(r => r.MaMonAn == maMon && r.DaXoa == false);
return(mon);
}
// GET: Admin/MonAn/Create
public ActionResult Create()
{
List <LOAI> list = _db.LOAIs.ToList();
ViewBag.listLoai = new SelectList(list, "MaLoai", "TenLoai", "Select cate");
MONAN monan = new MONAN();
return(View(monan));
}
// GET: CTVMonAn/Details/5
public ActionResult Details(int id)
{
if (Session["TenTK_CTV"] == null)
{
return(RedirectToAction("DangNhap", "CTVTaiKhoan"));
}
MONAN ctv = data.MONANs.SingleOrDefault(i => i.ID_MonAn == id);
return(View(ctv));
}
protected void Button1_Click(object sender, EventArgs e)
{
//Xử lý khi người đặt món
TextBox t = (sender as Button).Parent.Controls[3] as TextBox;
HiddenField h = (sender as Button).Parent.Controls[9] as HiddenField;
int SoLuongMon = int.Parse(t.Text);
MONAN m = MonAnDAO.TimMon(int.Parse(h.Value));
if (Session["ChiTietPhieu"] != null)
{
ChiTietPhieus = (List <CHITIETPHIEU>)Session["ChiTietPhieu"];
}
else
{
ChiTietPhieus = new List <CHITIETPHIEU>();
}
//Tăng số lượng nếu đã có
bool bAddNew = true;
foreach (CHITIETPHIEU c in ChiTietPhieus)
{
if (c.MONAN.TenMonAn == m.TenMonAn)
{
c.SoLuong += SoLuongMon;
bAddNew = false;
break;
}
}
//Thêm món vào phiếu
if (bAddNew == true)
{
ChiTietPhieus.Add(new CHITIETPHIEU {
MONAN = m, SoLuong = SoLuongMon
});
}
//Tính tổng tiền
Label l = GridView1.Parent.Controls[3] as Label;
double TongTien = double.Parse(l.Text, NumberStyles.Number) + m.Gia.Value * SoLuongMon;
l.Text = TongTien.ToString("0,000");
//Gán phiếu lại cho session
Session["ChiTietPhieu"] = ChiTietPhieus;
bind();
if (TongTien == 0)
{
hpHoanTatDatMon.Visible = false;
}
else
{
hpHoanTatDatMon.Visible = true;
}
}
public ActionResult Edit([Bind(Include = "Mã_món,Tên_món_ăn,công_thức,Mã_tỉnh_thành")] MONAN mONAN)
{
if (ModelState.IsValid)
{
db.Entry(mONAN).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Mã_tỉnh_thành = new SelectList(db.TINH_THANH, "Mã_tỉnh_thành", "Tên_tỉnh_thành", mONAN.Mã_tỉnh_thành);
return(View(mONAN));
}
public List <MONAN> LoadFoodList()
{
List <MONAN> foodList = new List <MONAN>();
string query = "Select MaM, TenM, Gia from dbo.MONAN where TinhTrang = 'true'";
DataTable data = provider.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
MONAN ma = new MONAN(item);
foodList.Add(ma);
}
return(foodList);
}
public ActionResult Retrash(string id)
{
if (id == null)
{
return(RedirectToAction("Trash", "MonAn"));
}
MONAN monan = _db.MONANs.Find(id);
monan.STATUS = 2;
_db.Entry(monan).State = EntityState.Modified;
_db.SaveChanges();
return(RedirectToAction("Trash", "MonAn"));
}
public ActionResult ThucDonById(int?val)
{
if (val != null)
{
//Values are hard coded for demo. you may replae with values
// coming from your db/service based on the passed in value ( val.Value)
int id = val.Value;
MONAN thucDon = data.MONANs.SingleOrDefault(i => i.ID_MonAn == id);
string donGia = Convert.ToDecimal(thucDon.GiaBan).ToString("N0") + "đ";
return(Json(new { Success = "true", Data = new { DonGia = donGia } }));
}
return(Json(new { Success = "false" }));
}
// GET: MONANs/Details/5
public ActionResult Details(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 List <MONAN> TimMonAn(string noidung)
{
List <MONAN> foodList = new List <MONAN>();
string query = "Select MaM, TenM, Gia from dbo.MONAN where TinhTrang = 'true' AND MaM LIKE '%" + noidung + "%' " +
"OR TenM LIKE '%" + noidung + "%' OR Gia LIKE '%" + noidung + "%'";
DataTable data = provider.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
MONAN ma = new MONAN(item);
foodList.Add(ma);
}
return(foodList);
}
public void ThemMonAn(string tenMon, int danhMucMon, int giaMon, string pathHinh)
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
var m = ql.MONANs.OrderByDescending(x => x.IDMonAn).FirstOrDefault();
int idMonNuoc = int.Parse(m.IDMonAn.Split('A')[1]);
MONAN ma = new MONAN();
ma.IDMonAn = idMonNuoc >= 100 ? "MA" + (idMonNuoc + 1) : "MA0" + (idMonNuoc + 1);
ma.IDDanhMuc = danhMucMon;
ma.TenMon = tenMon;
ma.GiaTien = giaMon;
ma.HinhMA = pathHinh;
ql.MONANs.Add(ma);
ql.SaveChanges();
}
public ActionResult Delete(string id, MONAN monan)
{
try
{
// TODO: Add delete logic here
monan = _db.MONANs.Where(s => s.MAMONAN == id).FirstOrDefault();
_db.MONANs.Remove(monan);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
// 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.Mã_tỉnh_thành = new SelectList(db.TINH_THANH, "Mã_tỉnh_thành", "Tên_tỉnh_thành", mONAN.Mã_tỉnh_thành);
return(View(mONAN));
}
public ActionResult Delete(int id)
{
if (Session["TenTK_CTV"] == null)
{
return(RedirectToAction("DangNhap", "CTVTaiKhoan"));
}
MONAN km = data.MONANs.SingleOrDefault(n => n.ID_MonAn == id);
ViewBag.ID = km.ID_MonAn;
if (km == null)
{
return(RedirectToAction("Index", "CTVMonAn"));
}
return(View(km));
}
protected void Page_Load(object sender, EventArgs e)
{
MONAN mon = new MONAN();
if (!Page.IsPostBack)
{
if (Request.QueryString["id"] != null)
{
req = int.Parse(Request.QueryString["id"]);
}
//req = 1;
List <MONAN> dsMon = new List <MONAN>();
mon = MonAnDAO.TimMon(req);
dsMon.Add(mon);
dsBl = BinhLuanDAO.LayDanhSach(req);
if (isClick == false)
{
dsBl.Reverse();
LinkButton1.Enabled = false;
LinkButton1.ForeColor = Color.Black;
LinkButton1.ControlStyle.Font.Bold = true;
}
else
{
LinkButton2.Enabled = false;
LinkButton2.ForeColor = Color.Black;
LinkButton2.ControlStyle.Font.Bold = true;
}
yourvar = dsBl.Count;
//Response.Write("dem");
PagedDataSource pgitems = new PagedDataSource();
PagedDataSource pgitems1 = new PagedDataSource();
DataView dv = new DataView();
pgitems.DataSource = dsMon;
pgitems.AllowPaging = true;
pgitems1.DataSource = dsBl;
pgitems1.AllowPaging = true;
rptItems.DataSource = pgitems;
rptItems.DataBind();
rptItems2.DataSource = pgitems1;
rptItems2.DataBind();
}
}
//Sửa thông tin món ăn
public bool UpdateMonAn(MONAN entity)
{
try
{
var monan = db.MONANs.Find(entity.MaMonAn);
monan.TenMonAn = entity.TenMonAn;
monan.MaCD = entity.MaCD;
monan.MoTa = entity.MoTa;
monan.DonGia = entity.DonGia;
monan.HinhMinhHoa = entity.HinhMinhHoa;
monan.NgayCapNhat = DateTime.Now;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
//khoi tao gio hang theo ma thuc don duoc truyen vao
public GioHang(int ID_MonAn)
{
iIDMonAn = ID_MonAn;
MONAN td = data.MONANs.SingleOrDefault(n => n.ID_MonAn == iIDMonAn);
if (td.KhuyenMai != null)
{
dGiaKhuyenMai = Double.Parse(td.KhuyenMai.GiamGia.ToString());
}
else
{
dGiaKhuyenMai = 0;
}
sTenMonAN = td.TenMonAn;
sAnh = td.AnhBia;
dDonGia = double.Parse(td.GiaBan.ToString());
dPhiVanChuyen = decimal.Parse(td.PhiVanChuyen.ToString());
iSoLuong = 1;
}
public string AddMONAN(MONAN_ViewModel model)
{
try
{
using (var db = new RestaurantManagerDataEntities())
{
var check = db.MONANs.FirstOrDefault(x => x.idmon == model.idmon);
if (check == null)
{
var MONAN = new MONAN
{
temon = model.temon,
dongiamon = model.dongiamon,
dvt = model.dvt,
hinhanh = model.hinhanh,
iddmuc = model.iddmuc,
CreateBy = model.CreateBy,
CreateDate = DateTime.Now,
};
var result = db.MONANs.Add(MONAN);
db.SaveChanges();
return("Thêm món ăn thành công!");
}
else
{
check.temon = model.temon;
check.dongiamon = model.dongiamon;
check.dvt = model.dvt;
check.hinhanh = model.hinhanh;
check.iddmuc = model.iddmuc;
check.ModifyBy = model.ModifyBy;
check.ModifyDate = DateTime.Now;
db.SaveChanges();
return("Cập nhật món ăn thành công!");
}
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
// GET: Admin/MonAn/Details/5
public ActionResult Status(string id)
{
if (id == null)
{
return(RedirectToAction("Index"));
}
MONAN monan = _db.MONANs.Find(id);
if (monan.STATUS == 1)
{
monan.STATUS = 2;
}
else
{
monan.STATUS = 1;
}
_db.Entry(monan).State = EntityState.Modified;
_db.SaveChanges();
return(RedirectToAction("Index"));
}
public List <MONAN> LayDanhMucMonAn(int tab)
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
List <MONAN> lstNuoc = new List <MONAN>();
var queryMA = from nu in ql.MONANs
where nu.IDDanhMuc == tab && nu.TrangThai == false
select nu;
foreach (var item in queryMA.ToList())
{
MONAN nu = new MONAN();
nu.IDMonAn = item.IDMonAn;
nu.IDDanhMuc = item.IDDanhMuc;
nu.GiaTien = item.GiaTien;
nu.TenMon = item.TenMon;
nu.HinhMA = item.HinhMA;
lstNuoc.Add(nu);
}
return(lstNuoc);
}
protected void DatMon_Click(object sender, EventArgs e)
{
List <CHITIETPHIEU> ChiTietPhieus;
//Xử lý khi người đặt món
TextBox t = (sender as Button).Parent.Controls[1] as TextBox;
HiddenField h = (sender as Button).Parent.Controls[5] as HiddenField;
int SoLuongMon = int.Parse(t.Text);
MONAN m = MonAnDAO.TimMon(int.Parse(h.Value));
if (Session["ChiTietPhieu"] != null)
{
ChiTietPhieus = (List <CHITIETPHIEU>)Session["ChiTietPhieu"];
}
else
{
ChiTietPhieus = new List <CHITIETPHIEU>();
}
//Tăng số lượng nếu đã có
bool bAddNew = true;
foreach (CHITIETPHIEU c in ChiTietPhieus)
{
if (c.MONAN.TenMonAn == m.TenMonAn)
{
c.SoLuong += SoLuongMon;
bAddNew = false;
break;
}
}
//Thêm món vào phiếu
if (bAddNew == true)
{
ChiTietPhieus.Add(new CHITIETPHIEU {
MONAN = m, SoLuong = SoLuongMon
});
}
//Gán phiếu lại cho session
Session["ChiTietPhieu"] = ChiTietPhieus;
}
