private void btBatDau_Click(object sender, EventArgs e)
{
DTO_Ban Ban = busBan.curBan(lbViTriBan.Text);
if (MessageBox.Show("Mở bàn đã chọn?", "Confirm",
MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (busBan.UpdateTrangThaiBan(Ban, 1))
{
lbStartTime.Visible = true;
lbStartTime.Text = (DateTime.Now.Hour < 10 ? "0" + DateTime.Now.Hour.ToString() : DateTime.Now.Hour.ToString()) + ":" + (DateTime.Now.Minute < 10 ? "0" + DateTime.Now.Minute.ToString() : DateTime.Now.Minute.ToString()) + ":" + (DateTime.Now.Second < 10 ? "0" + DateTime.Now.Second.ToString() : DateTime.Now.Second.ToString());
lbEndTime.Visible = true;
lbMaHD.Text = "HD" + DateTime.Now.ToString("ddMMyyyy_") + (DateTime.Now.Hour < 10 ? "0" + DateTime.Now.Hour.ToString() : DateTime.Now.Hour.ToString()) + (DateTime.Now.Minute < 10 ? "0" + DateTime.Now.Minute.ToString() : DateTime.Now.Minute.ToString()) + (DateTime.Now.Second < 10 ? "0" + DateTime.Now.Second.ToString() : DateTime.Now.Second.ToString());;
btBatDau.Enabled = false;
(flpkvBan.Controls[IndexBan].Controls[0] as PictureBox).Image = Image.FromFile(startupPath + @"\image\banMo.png");
hd = new DTO_HoaDon(lbMaHD.Text, Ban.IdBan);
busBan.ThemHoaDonTam(hd);
dgvThucDon.Enabled = true;
btChuyenBan.Enabled = true;
ChkBKhachHang.Enabled = true;
btGopBan.Enabled = true;
btTimKiem.Enabled = true;
}
else
{
MessageBox.Show("Đã có lỗi xảy ra vui lòng kiểm tra lại");
}
}
}
private void btBill_Click(object sender, EventArgs e)
{
DTO_HoaDon HoaDonFinal = (from DataRow dr in busBan.dtHoaDonTam(busBan.curBan(lbViTriBan.Text)).Rows
where string.Compare(dr[0].ToString(), hd.MaHD, true) == 0
select new DTO_HoaDon(dr[0].ToString(), NV.MaNV, (int)dr[1], float.Parse(dr[3].ToString()), dr[4].ToString())).FirstOrDefault();
HoaDonFinal.ThanhTien = (busBan.TongTienHDTam(hd) - busBan.TongTienHDTam(hd) * hd.KhuyenMai / 100);
if (string.IsNullOrWhiteSpace(HoaDonFinal.SDT_KH))
{
busBan.ThemHDFinalNoneKH(HoaDonFinal);
}
else
{
busBan.ThemHoaDonFinal(HoaDonFinal);
}
foreach (DataRow dr in busBan.dtHDCTFinal(hd.MaHD).Rows)
{
DTO_CTHD cthd = new DTO_CTHD(dr[0].ToString(), dr[1].ToString(), int.Parse(dr[2].ToString()));
DTO_Ban Ban = busBan.curBan(lbViTriBan.Text);
if (busBan.ThemCTHDFinal(cthd))
{
busBan.UpdateTrangThaiBan(Ban, 0);
(flpkvBan.Controls[IndexBan].Controls[0] as PictureBox).Image = Image.FromFile(startupPath + @"\image\banDong.png");
}
}
crtBaoCao();
busBan.ClearTemp(hd.MaHD);
txtSDTKH.Text = null;
FormKhuVucBan_Load(sender, e);
}
private void btOK_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Gộp " + OldBan.TenBan + " vào " + cbBan.Text + "?", "Confirm",
MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
DTO_HoaDon oldHD = busBan.curhd(OldBan);
DTO_Ban NewBan = busBan.curBan(cbBan.Text);
DTO_HoaDon newHD = busBan.curhd(NewBan);
DataTable dtCTHDOld = busBan.CTHDtheoMaHD(oldHD.MaHD);
foreach (DataRow dr in dtCTHDOld.Rows)
{
DTO_CTHD cthd = new DTO_CTHD(newHD.MaHD, dr[1].ToString(), (int)dr[2]);
busBan.ThemCTHDTam(cthd).ToString();
busBan.DeleteCTHDSoluong(dr[0].ToString(), dr[1].ToString(), (int)dr[2]);
}
FormKhuVucBan.IndexBan = NewBan.IdBan - 1;
busBan.UpdateTrangThaiBan(OldBan, 0);
busBan.ClearTemp(oldHD.MaHD);
this.Close();
}
}
public FormChuyenBan(DTO_Ban Ban, string MaHD)
{
InitializeComponent();
lbOld.Text = Ban.TenBan;
BanOld = Ban;
MaHoaDon = MaHD;
}
public BindingList <DTO_Ban> GetBan(int id)
{
try
{
KetNoi kn = new KetNoi();
kn.LayThongTinTruyVan("sp_getBan");
kn.AddParameter("@ID", id);
DataSet ds = kn.ExecuteDataSet();
BindingList <DTO_Ban> _list = new BindingList <DTO_Ban>();
if (ds.Tables[0].Rows.Count > 0)
{
DTO_Ban dto = new DTO_Ban();
foreach (DataRow item in ds.Tables[0].Rows)
{
dto.ID = Convert.ToInt32(item["ID_Ban"].ToString());
dto.TenBan = item["TenBan"].ToString();
_list.Add(dto);
}
}
return(_list);
}
catch (Exception ex)
{
throw;
}
}
private void btOK_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Chuyển " + BanOld.TenBan + " sang " + cbBan.Text + "?", "Confirm",
MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
BanNew = busBan.curBan(cbBan.Text);
FormKhuVucBan.IndexBan = BanNew.IdBan - 1;
busBan.ChuyenBan(BanOld.IdBan, BanNew.IdBan, MaHoaDon);
this.Close();
}
}
public DTO_Ban curBan(string ViTriBan)
{
DTO_Ban curBan = (from DataRow dr in dtBan().Rows
where string.Compare(dr[1].ToString(), ViTriBan, true) == 0
select new DTO_Ban
{
IdBan = int.Parse(dr[0].ToString()),
TenBan = dr[1].ToString(),
TrangThai = int.Parse(dr[2].ToString()),
}).FirstOrDefault();
return(curBan);
}
public DTO_HoaDon curhd(DTO_Ban ban)
{
DTO_HoaDon hd = (from DataRow dr in dtHoaDonTam(ban).Rows
where int.Parse(dr[1].ToString()) == ban.IdBan
select new DTO_HoaDon
{
MaHD = dr[0].ToString(),
IdBan = (int)dr[1],
KhuyenMai = float.Parse(dr[3].ToString()),
SDT_KH = dr[4].ToString()
}).FirstOrDefault();
return(hd);
}
public void Xoa(DTO_Ban MaBan)
{
DAL_Ban DAL = new DAL_Ban();
DAL.Xoa(MaBan);
}
// chọn một bàn ở vị trí indexBan
private void SelectBan(int indexBan)
{
FlowLayoutPanel flp = (FlowLayoutPanel)flpkvBan.Controls[indexBan];
PictureBox image = (PictureBox)flp.Controls[0];
Label lbBan = (Label)flp.Controls[1];
lbViTriBan.Text = lbBan.Text;
DTO_Ban Ban = busBan.curBan(lbViTriBan.Text);
hd = busBan.curhd(Ban);
if (Ban.TrangThai == 1)
{
DataTable curHd = busBan.dtHoaDonTam(Ban);
DataRow drhd = curHd.Rows[0];
lbStartTime.Visible = true;
lbEndTime.Visible = true;
DateTime StartHD = (DateTime)drhd[2];
lbMaHD.Text = drhd[0].ToString();
dgvThucDon.Enabled = true;
dgvHDCT.Enabled = true;
btChuyenBan.Enabled = true;
btGopBan.Enabled = true;
btTimKiem.Enabled = true;
btThem.Enabled = true;
ChkBKhachHang.Enabled = true;
ChkBKhachHang.Checked = false;
btThemKhach.Enabled = false;
txtSDTKH.Enabled = false;
if (string.IsNullOrWhiteSpace(hd.SDT_KH))
{
txtSDTKH.Text = null;
}
else
{
txtSDTKH.Text = hd.SDT_KH;
}
lbKhuyenMai.Text = hd.KhuyenMai.ToString() + "%";
lbTongTien.Text = (busBan.TongTienHDTam(hd) - busBan.TongTienHDTam(hd) * hd.KhuyenMai / 100).ToString();
btKhuyenMai.Enabled = true;
lbStartTime.Text = (StartHD.Hour < 10 ? "0" + StartHD.Hour.ToString() : StartHD.Hour.ToString()) + ":" + (StartHD.Minute < 10 ? "0" + StartHD.Minute.ToString() : StartHD.Minute.ToString()) + ":" + (StartHD.Second < 10 ? "0" + StartHD.Second.ToString() : StartHD.Second.ToString());
}
else
{
lbStartTime.Visible = false;
lbEndTime.Visible = false;
lbMaHD.Text = "";
lbTongTien.Text = "0";
lbKhuyenMai.Text = "0%";
btKhuyenMai.Enabled = false;
ChkBKhachHang.Enabled = false;
dgvThucDon.Enabled = false;
dgvHDCT.Enabled = false;
btChuyenBan.Enabled = false;
btGopBan.Enabled = false;
btAdd1.Enabled = false;
btRemove1.Enabled = false;
btThem.Enabled = false;
}
LoadCTHD();
lbBan.BackColor = Color.Transparent;
for (int i = 0; i < flp.Parent.Controls.Count; i++)
{
if (flp.Parent.Controls[i] == flp.Parent.Controls[indexBan])
{
flp.Parent.Controls[i].BackColor = Color.FromArgb(128, 72, 145, 220);
}
else
{
flp.Parent.Controls[i].BackColor = Color.White;
}
}
if (Ban.TrangThai == 0)
{
btBatDau.Enabled = true;
}
else
{
btBatDau.Enabled = false;
}
}
public void Sua(DTO_Ban MaBan)
{
string strSQL = string.Format(@"UPDATE Ban set MaBan = '" + MaBan.MaBan + "', TenBan = N'" + MaBan.TenBan + "',SoLuongNguoi = " + MaBan.SoLuongNguoi + ",GhiChu = N'" + MaBan.GhiChu + "' where MaBan = '" + MaBan.MaBan_Sua + "'");
KetNoiSQL.ExecuteNonQuery(strSQL);
}
public void Xoa(DTO_Ban MaBan)
{
string strSQL = "DELETE Ban where MaBan = '" + MaBan.MaBan + "'";
KetNoiSQL.ExecuteNonQuery(strSQL);
}
public FormGopBan(DTO_Ban Ban)
{
InitializeComponent();
OldBan = Ban;
lbTenBan.Text = Ban.TenBan;
}
public bool UpdateTrangThaiBan(DTO_Ban ban, int TrangThai)
{
return(dalBan.UpdateTrangThaiBan(ban.IdBan, TrangThai));
}
public void Sua(DTO_Ban MaBan)
{
DAL_Ban DAL = new DAL_Ban();
DAL.Sua(MaBan);
}
public void Them(DTO_Ban MaBan)
{
string strSQL = "INSERT INTO Ban(MaBan,TenBan,SoLuongNguoi,GhiChu) VALUES ( '" + MaBan.MaBan + "',N'" + MaBan.TenBan + "'," + MaBan.SoLuongNguoi + ",N'" + MaBan.GhiChu + "')";
KetNoiSQL.ExecuteNonQuery(strSQL);
}
public void Them(DTO_Ban MaBan)
{
DAL_Ban DAL = new DAL_Ban();
DAL.Them(MaBan);
}
public DataTable dtHoaDonTam(DTO_Ban ban)
{
return(dalBan.HoaDonTam(ban.IdBan));
}
