public IActionResult XoaCTHD(int IdHoaDon, int IdLoaiMonAn, int IdBanAn, int IdMonAn, int pageIndex = 1)
{
if (KiemTraDangNhap() == false)
{
return(View("../Login/Index"));
}
ServeVM sv = null;
_services.DeleteCTHD(IdHoaDon, IdMonAn);
BanAnDTO baDTO = _services.GetBanAn(IdBanAn);
HoaDonDTO HoaDon = _services.CapNhatThanhTien(IdHoaDon);
SaveHoaDonDTO saveHoaDonDTO = _mapper.Map <HoaDonDTO, SaveHoaDonDTO>(HoaDon);
IEnumerable <CTHDMD> list = _services.GetListCTHDMD(HoaDon.Id);
sv = new ServeVM
{
BanAn = baDTO,
HoaDon = saveHoaDonDTO,
LoaiMonAns = _services.GetListLoaiMonAn(),
ThucDons = _services.GetListMonAn(IdLoaiMonAn, pageIndex),
ChiTietHoaDons = list
};
return(PartialView("_BanAnPartialView/_CTHDPartial", sv));
}
public BanAnDTO FindBanAn(int IdHoaDon)
{
BanAn ba = _unitOfWork.HoaDons.FindBanAn(IdHoaDon);
BanAnDTO banAnDTO = _mapper.Map <BanAn, BanAnDTO>(ba);
return(banAnDTO);
}
public IActionResult Serve(int?IdBanAn, int?IdLoaiMonAn, int?IdPhieuDatBan, int pageIndex = 1)
{
if (KiemTraDangNhap() == false)
{
return(View("../Login/Index"));
}
ServeVM sv = null;
if (IdBanAn == null)
{
return(RedirectToAction("Index"));
}
BanAnDTO baDTO = _services.GetBanAn(IdBanAn.Value);
if (baDTO == null)
{
RedirectToAction("Index");
}
if (IdPhieuDatBan == null)
{
IdPhieuDatBan = 0;
}
if ((baDTO.TrangThai.Equals("Trống") || baDTO.TrangThai.Equals("Được đặt trước")))
{
System.DateTime day = DateTime.Now;
sv = new ServeVM
{
BanAn = baDTO,
IdPhieuDatBan = IdPhieuDatBan.Value,
HoaDon = new SaveHoaDonDTO
{
IdBanAn = IdBanAn.Value,
IdUser = Convert.ToInt32(HttpContext.Session.GetString("IdCurrentUser")),
ThoiGianLap = Convert.ToDateTime(day),
ThoiGianThanhToan = null,
ThanhTien = 0,
TrangThai = "Trống",
}
};
}
else
{
// if(HoaDon.TrangThai=="Chưa thanh toán")
HoaDonDTO HoaDonDTO = _services.FindHD(baDTO.Id);
SaveHoaDonDTO saveHoaDonDTO = _mapper.Map <HoaDonDTO, SaveHoaDonDTO>(HoaDonDTO);
IEnumerable <CTHDMD> list = _services.GetListCTHDMD(HoaDonDTO.Id);
saveHoaDonDTO.IdUser = Convert.ToInt32(HttpContext.Session.GetString("IdCurrentUser"));
sv = new ServeVM
{
BanAn = baDTO,
HoaDon = saveHoaDonDTO,
LoaiMonAns = _services.GetListLoaiMonAn(),
ThucDons = _services.GetListMonAn(IdLoaiMonAn, pageIndex),
ChiTietHoaDons = list
};
}
return(View(sv));
}
public BanAnDTO GetListBanAn(DataRow row)
{
BanAnDTO ban = new BanAnDTO
{
MABAN = row["MABAN"].ToString().Trim(),
SOCHONGOI = int.Parse((row["SOCHONGOI"]).ToString()),
MAPYC = row["MAPYC"].ToString().Trim()
};
return(ban);
}
public List <BanAnDTO> loadBanList()
{
List <BanAnDTO> tableList = new List <BanAnDTO>();
DataTable data = DataProvider.Instance.executeQuery("select * from BanAn");
foreach (DataRow item in data.Rows)
{
BanAnDTO table = new BanAnDTO(item);
tableList.Add(table);
}
return(tableList);
}
public List <BanAnDTO> LoadTableList3()
{
List <BanAnDTO> tableList = new List <BanAnDTO>();
DataTable data = DataProvider.Instance.ExecuteQuery("select * from BANAN where MAKV = 3");
foreach (DataRow item in data.Rows)
{
BanAnDTO table = new BanAnDTO(item);
tableList.Add(table);
}
return(tableList);
}
public List <BanAnDTO> GetTableList()
{
List <BanAnDTO> TableList = new List <BanAnDTO>();
string query = "select * from BANAN where status = 0 ";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
BanAnDTO food = new BanAnDTO(item);
TableList.Add(food);
}
return(TableList);
}
public IActionResult Edit(int?id)
{
if (KiemTraDangNhap() == false)
{
return(View("../Login/Index"));
}
if (id == null)
{
return(RedirectToAction("Index"));
}
BanAnDTO banAnDTO = _services.GetBanAn(id.Value);
SaveBanAnDTO saveBanAnDTO = _mapper.Map <BanAnDTO, SaveBanAnDTO>(banAnDTO);
return(View(saveBanAnDTO));
}
private void btnThemMon_Click(object sender, EventArgs e)
{
BanAnDTO table = lsvShowBill.Tag as BanAnDTO;
int MAHD = HoaDonDAO.Instance.GetUncheckBillIDByTableID(table.MABA);
if (MAHD == -1)
{
HoaDonDAO.Instance.InsertHoaDon(table.MABA);
}
else
{
// CTHDDAO.Instance.InsertBillInfo(MAHD, , count);
}
ShowBill(table.MABA);
}
public BanAnDTO[] GetListBanAn()
{
DataTable table = Da1.Query("select * from BANAN");
int n = table.Rows.Count;
int i;
if (n == 0)
{
return(null);
}
BanAnDTO[] list = new BanAnDTO[n];
for (i = 0; i < n; i++)
{
list[i] = GetListBanAn(table.Rows[i]);
}
return(list);
}
public static List <BanAnDTO> DanhSachBanAnList()
{
DataTable ans = new DataTable();
string query = "SELECT * FROM BANAN";
ans = SqlServerHelper.ExecuteQuery(query);
List <BanAnDTO> ketqua = new List <BanAnDTO>();
ketqua.Clear();
foreach (DataRow row in ans.Rows)
{
BanAnDTO banan = new BanAnDTO(row);
ketqua.Add(banan);
}
return(ketqua);
}
public IActionResult Deleted(int?id)
{
if (KiemTraDangNhap() == false)
{
return(View("../Login/Index"));
}
if (id == null)
{
return(RedirectToAction("Index"));
}
int i = _services.Delete(id.Value);
if (i == 0)
{
ViewBag.MessageDelBanAn = "Không thể xóa bàn này, bàn này đang được phục vụ hoặc đã được đặt trước";
BanAnDTO banAnDTO = _services.GetBanAn(id.Value);
SaveBanAnDTO saveBanAnDTO = _mapper.Map <BanAnDTO, SaveBanAnDTO>(banAnDTO);
return(View(saveBanAnDTO));
}
return(RedirectToAction("Index"));
}
public List <BanAnDTO> LayDSBanAn()
{
string query = "SELECT * FROM [Table]";
DataProvider provider = new DataProvider();
DataTable table = provider.ExecuteQuery(query);
List <BanAnDTO> dsBanAn = new List <BanAnDTO>();
foreach (DataRow row in table.Rows)
{
int id = Convert.ToInt32(row["ID"]);
string name = row["Name"].ToString();
int status = Convert.ToInt32(row["Status"]);
int capacity = Convert.ToInt32(row["Capacity"]);
var banAnMoi = new BanAnDTO(id, name, status, capacity);
dsBanAn.Add(banAnMoi);
}
return(dsBanAn);
}
public bool ThemBA(BanAnDTO ban)
{
Da1.NonQuery("proc_insertBA '" + ban.MABAN + "', '" + ban.SOCHONGOI + "',null");
return(true);
}
/*create proc[dbo].[updateBA] (@ma varchar(10), @sochongoi int, @MaPYC varchar(10) )
* as
* begin
* if(@MaPYC like '') SET @MaPYC = 'null'
* if(@sochongoi = '') set @sochongoi = 7
* update BANAN set SOCHONGOI = @sochongoi, MAPYC = @MaPYC where MABAN = @ma
* end*/
public bool XoaBA(BanAnDTO ban)
{
Da1.NonQuery("delete BANAN where MABAN='" + ban.MABAN + "'");
return(true);
}
public bool Update_ban(BanAnDTO ban)
{
Da1.NonQuery("update BanAn set sochongoi =" + ban.SOCHONGOI + "where maban= '" + ban.MABAN + "'");
return(true);
}
