public ActionResult ConfirmDelete(string soHdb, string maHanghoa)
{
ChiTietBan ctb = db.ChiTietBans.Find(soHdb, maHanghoa);
db.ChiTietBans.Remove(ctb);
db.SaveChanges();
return(RedirectToAction("Index"));
}
int HienThiHoaDon(int idtable)
{
DataTable data = ChiTietBan.HienThiHoaDon(idtable);
dgvChiTietNhapMain.DataSource = data;
TongTien((int)HoaDonBanDAO.LayHoaDonTheoBan(idtable));
return(data.Rows.Count);
}
void TongTien(int mahdb)
{
double tongtien = ChiTietBan.TongTien(mahdb);
CultureInfo culture = new CultureInfo("vi-VN");
//Thread.CurrentThread.CurrentCulture = culture;
txbTongTien.Text = tongtien.ToString("c", culture);
}
public ActionResult Edit(ChiTietBan ctb)
{
if (ModelState.IsValid)
{
db.Entry(ctb).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ctb));
}
public ActionResult Create(ChiTietBan ctb)
{
if (ModelState.IsValid)
{
db.ChiTietBans.Add(ctb);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
private void btnTraMon_Click(object sender, EventArgs e)
{
int idtable = (int)dgvChiTietNhapMain.Tag;
int mahdb = (int)HoaDonBanDAO.LayHoaDonTheoBan(idtable);
int mamh = (int)cboDanhSachMatHang.SelectedValue;
int soluong = (int)SpinEditSoLuong.Value;
try
{
mamh = (int)dgvChiTietNhap.GetFocusedRowCellValue("MAMH");
}
catch
{
MessageBox.Show("Hóa đơn đang trống", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (mahdb == -1)
{
MessageBox.Show("Không có món, không thể trả món", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
ChiTietBan.TraMon(mahdb, mamh, soluong);
}
QuanLyQuanCafeDBContext db = new QuanLyQuanCafeDBContext();
int cnt = (
from hd in db.HOADONBANs.Where(p => p.MABA == idtable && p.STATUS == 0).ToList()
from ctb in db.CHITIETBANs.Where(p => p.MAHDB == hd.MAHDB).ToList()
from mh in db.MATHANGs.Where(p => p.MAMH == ctb.MAMH).ToList()
select new
{
MatHang = mh.TENMH,
SoLuong = ctb.SOLUONG,
DonGia = mh.DONGIA,
ThanhTien = ctb.THANHTIEN
})
.ToList()
.Count;
if (cnt == 0)
{
db.BANANs.Where(p => p.MABA == idtable).FirstOrDefault().TRANGTHAI = 0;
db.SaveChanges();
LoadDanhSachBanAn();
}
HienThiHoaDon(idtable);
TongTien(mahdb);
}
private void btnThanhToan_Click(object sender, EventArgs e)
{
try
{
int idtable = (int)dgvChiTietNhapMain.Tag;
int mahdb = (int)HoaDonBanDAO.LayHoaDonTheoBan(idtable);
ChiTietBan.DeleteChiTietBan(mahdb);
HoaDonBanDAO.DeleteHoaDonBan(idtable);
MessageBox.Show("Thanh toán thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
HienThiHoaDon(idtable);
TongTien(mahdb);
ChangeImageTable(idtable, 0);
}
catch
{
}
}
private void btnDatMon_Click(object sender, EventArgs e)
{
int idtable;
try
{
idtable = (int)dgvChiTietNhapMain.Tag;
}
catch
{
MessageBox.Show("Bạn cần phải lựa chọn bàn ăn trước khi thêm món", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
int mamh = (int)cboDanhSachMatHang.SelectedValue;
int soluong = (int)SpinEditSoLuong.Value;
int mahdb = HoaDonBanDAO.LayHoaDonTheoBan(idtable);
if (MatHangDAO.CheckHangTonKho(mamh, soluong) == 1)
{
if (mahdb == -1)
{
HoaDonBanDAO.InsertHoaDonBan(idtable);
ChiTietBan.InsertChiTietBan(HoaDonBanDAO.LayHoaDonBanMax(), mamh, soluong);
mahdb = HoaDonBanDAO.LayHoaDonTheoBan(idtable);
ChangeImageTable(idtable, 1);
}
else
{
ChiTietBan.InsertChiTietBan(mahdb, mamh, soluong);
}
}
else
{
MessageBox.Show("Không đủ hàng", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
HienThiHoaDon(idtable);
TongTien(mahdb);
}
private void btnTraMon_Click(object sender, EventArgs e)
{
int idtable = (int)dgvChiTietNhapMain.Tag;
int mahdb = (int)HoaDonBanDAO.LayHoaDonTheoBan(idtable);
int mamh = (int)cboDanhSachMatHang.SelectedValue;
int soluong = (int)SpinEditSoLuong.Value;
if (mahdb == -1)
{
MessageBox.Show("Không có món, không thể trả món", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
ChiTietBan.TraMon(mahdb, mamh, soluong);
}
if (HienThiHoaDon(idtable) == 0)
{
HoaDonBanDAO.DeleteHoaDonBan(idtable);
ChangeImageTable(idtable, 0);
}
TongTien(mahdb);
}
private void btnDatMon_Click(object sender, EventArgs e)
{
int idtable = (int)dgvChiTietNhapMain.Tag;
int mamh = (int)cboDanhSachMatHang.SelectedValue;
int soluong = (int)SpinEditSoLuong.Value;
int mahdb = HoaDonBanDAO.LayHoaDonTheoBan(idtable);
if (mahdb == -1)
{
HoaDonBanDAO.InsertHoaDonBan(idtable);
ChiTietBan.InsertChiTietBan(HoaDonBanDAO.LayHoaDonBanMax(), mamh, soluong);
mahdb = HoaDonBanDAO.LayHoaDonTheoBan(idtable);
ChangeImageTable(idtable, 1);
}
else
{
ChiTietBan.InsertChiTietBan(mahdb, mamh, soluong);
}
HienThiHoaDon(idtable);
TongTien(mahdb);
}
public ActionResult Delete(string soHdb, string maHanghoa)
{
ChiTietBan ctb = db.ChiTietBans.Find(soHdb, maHanghoa);
return(View(ctb));
}