private void ChiTietHoaDon_Load(object sender, EventArgs e)
{
HoaDon.model.Load load = new model.Load();
DataTable dt = new DataTable();
if (check == 2)
{
DataTable dtHoaDonNhapHang = load.LoadHoaDonNhapHangTheoMaHoaDon(ID);
string ThoiGian = dtHoaDonNhapHang.Rows[0][1].ToString();
// string ViTri = dtHoaDon.Rows[0][2].ToString();
// string Khach = dtHoaDon.Rows[0][13].ToString();
// string MaKhach = dtHoaDon.Rows[0][12].ToString();
int ThanhToan = Convert.ToInt32(dtHoaDonNhapHang.Rows[0][2].ToString());
dt = load.LoadChiTietHoaDonNhapHang(ID);
lblNgay.Text = ThoiGian;
lblBan.Visible = false;
lblKhachHang.Visible = false;
lblTongTien.Text = ThanhToan.ToString();
}
else if(check ==1)
{
DataTable dtHoaDon = load.LoadHoaDonTheoMaHoaDon(ID);
string ThoiGian = dtHoaDon.Rows[0][1].ToString();
string ViTri = dtHoaDon.Rows[0][11].ToString();
string Khach = dtHoaDon.Rows[0][13].ToString();
string MaKhach = dtHoaDon.Rows[0][12].ToString();
int ThanhToan = Convert.ToInt32( dtHoaDon.Rows[0][8].ToString());
dt = load.LoadChiTietHoaDonTheoMaHoaDon(ID);
lblNgay.Text = ThoiGian;
lblBan.Text = ViTri;
lblKhachHang.Text = Khach;
lblTongTien.Text = ThanhToan.ToString();
if (MaKhach!=""&& Convert.ToInt32(MaKhach)!=0)
{
MaKhachHang = Convert.ToInt32(MaKhach);
groupPanel1.Visible = true;
BanHang.Model.Load load1 = new BanHang.Model.Load();
DataTable dtKhach = load1.LoadKhachHangTheoMaKhach(MaKhachHang);
labelXSDT.Text = dtKhach.Rows[0][2].ToString();
richTextBoxExDiaChi.Text = dtKhach.Rows[0][1].ToString();
}
}
dgvChiTietHoaDon.DataSource = dt;
dgvChiTietHoaDon.AllowUserToResizeRows = false;
for (int i = 0; i < dt.Rows.Count; i++)
{
dgvChiTietHoaDon.Rows[i].Cells["ST"].Value = i + 1;
}
}
private void btnThongKeChiPhiTheoTuan_Click(object sender, EventArgs e)
{
HoaDon.model.Load load = new HoaDon.model.Load();
DataTable dt = new DataTable();
dt = load.LoadHoaDonNhapHangThongKe(dateTimeInputThongKeTuNgay.Value, dateTimeInputThongKeDenNgay.Value);
ThongKe.CrystalReportThongKeChiPhiTheoTuan cry = new ThongKe.CrystalReportThongKeChiPhiTheoTuan();
cry.SetDataSource(dt);
crystalReportViewer1.ReportSource = cry;
crystalReportViewer1.Refresh();
}
private void btnOk_Click(object sender, EventArgs e)
{
//nho them try catch
try
{
int ID = Convert.ToInt32(lblMaMon.Text);
string Ten = lblName.Text;
float SoLuong = float.Parse(txtSoLuong.Value.ToString());
string DonVi = dgvThucDon.SelectedRows[0].Cells[2].Value.ToString();
float Gia = float.Parse(dgvThucDon.SelectedRows[0].Cells[3].Value.ToString()) ;
checkso(richTextBoxExGiamGia);
float GiamGia = a;
float TongTien = Gia* SoLuong - GiamGia;
if (MaHoaDon != 0)
{
//neu chua co mon thi insert con neu khong thi update
//Kiem tra mon an co cung maMonAn va MaHoaDon
HoaDon.model.Load load = new HoaDon.model.Load();
DataTable dt = load.LoadMonAn(MaHoaDon, ID);
if (dt.Rows.Count == 0)
{
//InsertMonAn
BanHang.Model.Insert insert = new BanHang.Model.Insert();
insert.InsertHoaDonChiTiet(MaHoaDon, ID, Ten, SoLuong, DonVi, Gia, GiamGia, TongTien);
LoadChiTietHoaDon(MaHoaDon);
}
else
{
//Update
int MaChiTietHoaDon = Convert.ToInt32(dt.Rows[0][0].ToString());
BanHang.Model.Update update = new BanHang.Model.Update();
update.UpdateChiTietHoaDon(MaChiTietHoaDon, SoLuong, GiamGia);
LoadChiTietHoaDon(MaHoaDon);
}
resetThucDon();
LayHangTrongKho(ID, SoLuong);
LoadSoLuongSanPham();
loadThucDon();
}
else
{
MessageBox.Show("Bạn chưa chọn bàn");
}
}
catch (Exception)
{
}
}
private void btnHuy_Click(object sender, EventArgs e)
{
try
{
if(MaHoaDon!=0)
{
DialogResult dialog = MessageBox.Show("Bạn có muốn hủy bàn", "Hủy", MessageBoxButtons.YesNo);
if (dialog == DialogResult.Yes)
{
for (int i = 0; i < dataGridViewXListMonAn.Rows.Count; i++)
{
int MaChiTiet = Convert.ToInt32(dataGridViewXListMonAn.Rows[i].Cells[1].Value.ToString());
int SoLuong = Convert.ToInt32(dataGridViewXListMonAn.Rows[i].Cells[4].Value.ToString());
BanHang.Model.Update update = new BanHang.Model.Update();
HoaDon.model.Load load = new HoaDon.model.Load();
DataTable dt = load.LoadChiTietHoaDonTheoMaChiTietHoaDon(MaChiTiet);
int MaMonAn = Convert.ToInt32(dt.Rows[0][1].ToString());
update.TraHangTrongKho(MaMonAn, SoLuong);
}
////BanHang.Model.Delete delete = new BanHang.Model.Delete();
////delete.DeleteMonAn(MaChiTiet);
BanHang.Model.Delete delete = new BanHang.Model.Delete();
delete.DeleteHoaDon(MaHoaDon);
LoadChiTietHoaDon(MaHoaDon);
LoadSoLuongSanPham();
loadThucDon();
ResetBanHang();
MaHoaDon = 0;
}
}
else
{
MessageBox.Show("Bạn chưa chọn hóa đơn");
}
}
catch (Exception)
{
}
}
public void LoadHoaDonNhapHang()
{
KiemTraHoaDon = 2;
HoaDon.model.Load load = new HoaDon.model.Load();
DataTable dt = load.LoadHoaDonNhapHang(dateTimeInput1.Value, dateTimeInput2.Value);
loadDataHoaDon(dt);
lblHoaDon.Text = dt.Rows.Count.ToString();
int Tong = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
Tong = Convert.ToInt32(dt.Rows[i][2].ToString()) + Tong;
}
txtTongTien.Text = Tong.ToString();
}
public void LoadHoaDonChuaThanhToanDangChon()
{
try
{
int MaBan = Convert.ToInt32(listViewExKhuVuc.SelectedItems[0].Name.ToString());
HoaDon.model.Load load = new HoaDon.model.Load();
DataTable HoaDon = load.LoadHoaDonChuaThanhToanCanChon(MaBan);
lblThoiGian.Text = HoaDon.Rows[0][1].ToString();
lblViTri.Text = HoaDon.Rows[0][11].ToString();
richtxtTongTien.Text = HoaDon.Rows[0][6].ToString();
MaHoaDon = Convert.ToInt32(HoaDon.Rows[0][0].ToString());
LoadChiTietHoaDon(MaHoaDon);
labelXID.Text = "";
textBoxXKhachHang.Text = "";
textBoxXSDT.Text = "";
richTextBoxExDiaChi.Text = "";
checkBoxX1.Checked = false;
}
catch (Exception)
{
MaHoaDon = 0;
DataTable dt = new DataTable();
dataGridViewXListMonAn.DataSource = dt;
lblThoiGian.Text = "";
lblViTri.Text = "";
richtxtTongTien.Text = "";
richtxtThanhToan.Text = "";
numericUpDownGiamGia.Value = 0;
numericUpDownVAT.Value = 0;
labelXID.Text = "";
textBoxXKhachHang.Text = "";
textBoxXSDT.Text = "";
richTextBoxExDiaChi.Text = "";
checkBoxX1.Checked = false;
}
}
private void toolStripMenuItemXoaBan_Click(object sender, EventArgs e)
{
try
{
//check khu vuc
int MaBanAn = Convert.ToInt32(listViewExKhuVuc.SelectedItems[0].Name.ToString());
HoaDon.model.Load load = new HoaDon.model.Load();
DataTable HoaDon = load.LoadHoaDonChuaThanhToanCanChon(MaBanAn);
if (HoaDon.Rows.Count == 0)
{
DialogResult dialogResult = MessageBox.Show("Bạn có chắc chắn không", "Xóa", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
BanHang.Model.Delete delete = new BanHang.Model.Delete();
delete.DeleteBanAn(MaBanAn);
}
LoadKhuVuc();
}
else
{
MessageBox.Show("Hóa đơn chưa thanh toán");
}
}
catch (Exception)
{
}
}
private void toolStripMenuItemHuyMon_Click(object sender, EventArgs e)
{
try
{
if (dataGridViewXListMonAn.SelectedRows[0].Cells[1].Value.ToString() != null)
{
DialogResult dialogResult = MessageBox.Show("Bạn có chắc chắn muốn xóa", "Xóa", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
int MaChiTiet = Convert.ToInt32(dataGridViewXListMonAn.SelectedRows[0].Cells[1].Value.ToString());
int SoLuong = Convert.ToInt32(dataGridViewXListMonAn.SelectedRows[0].Cells[4].Value.ToString());
BanHang.Model.Update update = new BanHang.Model.Update();
HoaDon.model.Load load = new HoaDon.model.Load();
DataTable dt = load.LoadChiTietHoaDonTheoMaChiTietHoaDon(MaChiTiet);
int MaMonAn = Convert.ToInt32(dt.Rows[0][1].ToString());
update.TraHangTrongKho(MaMonAn, SoLuong);
BanHang.Model.Delete delete = new BanHang.Model.Delete();
delete.DeleteMonAn(MaChiTiet);
LoadChiTietHoaDon(MaHoaDon);
LoadSoLuongSanPham();
loadThucDon();
}
}
}
catch (Exception)
{
}
}
private void toolStripMenuItemChuyenBan_Click(object sender, EventArgs e)
{
try
{
int MaBanAn = Convert.ToInt32(listViewExKhuVuc.SelectedItems[0].Name.ToString());
HoaDon.model.Load load = new HoaDon.model.Load();
DataTable HoaDon = load.LoadHoaDonChuaThanhToanCanChon(MaBanAn);
if (HoaDon.Rows.Count > 0)
{
BanHang.ChuyenBan chuyen = new BanHang.ChuyenBan(MaBanAn,HoaDon.Rows[0][11].ToString());
chuyen.ShowDialog();
LoadKhuVuc();
}
}
catch
{
}
}
private DataTable loadHoaDon()
{
HoaDon.model.Load load = new HoaDon.model.Load();
return load.LoadHoaDonChuaThanhToan();
}
public void LoadChiTietHoaDon(int MaHoaDon)
{
try
{
HoaDon.model.Load load = new HoaDon.model.Load();
dataGridViewXListMonAn.DataSource = load.LoadChiTietHoaDonChuaThanhToanCanChon(MaHoaDon);
dataGridViewXListMonAn.AllowUserToResizeRows = false;
dataGridViewXListMonAn.Columns[1].Visible = false;
dataGridViewXListMonAn.Columns[2].Visible = false;
dataGridViewXListMonAn.Columns[3].Width = 200;
for (int i = 0; i < dataGridViewXListMonAn.Rows.Count; i++)
{
dataGridViewXListMonAn.Rows[i].Cells["STT1"].Value = i + 1;
}
TinhToanHoaDon();
}
catch (Exception)
{
}
}
private void dgvThucDon_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
int ID = Convert.ToInt32(dgvThucDon.SelectedRows[0].Cells[0].Value.ToString());
string Ten = dgvThucDon.SelectedRows[0].Cells[1].Value.ToString();
float SoLuong = 1;
string DonVi = dgvThucDon.SelectedRows[0].Cells[2].Value.ToString();
float Gia = float.Parse(dgvThucDon.SelectedRows[0].Cells[3].Value.ToString());
float GiamGia = 0;
float TongTien = Gia * SoLuong - GiamGia;
if (LayHangTrongKho(ID, SoLuong) == 1)
{
if (MaHoaDon != 0)
{
//neu chua co mon thi insert con neu khong thi update
//Kiem tra mon an co cung maMonAn va MaHoaDon
HoaDon.model.Load load = new HoaDon.model.Load();
DataTable dt = load.LoadMonAn(MaHoaDon, ID);
if (dt.Rows.Count == 0)
{
//InsertMonAn
BanHang.Model.Insert insert = new BanHang.Model.Insert();
insert.InsertHoaDonChiTiet(MaHoaDon, ID, Ten, SoLuong, DonVi, Gia, GiamGia, TongTien);
LoadChiTietHoaDon(MaHoaDon);
}
else
{
//Update
int MaChiTietHoaDon = Convert.ToInt32(dt.Rows[0][0].ToString());
BanHang.Model.Update update = new BanHang.Model.Update();
update.UpdateChiTietHoaDon(MaChiTietHoaDon, SoLuong, GiamGia);
LoadChiTietHoaDon(MaHoaDon);
}
}
}
else
{
MessageBox.Show("Bạn chưa chọn hàng hoặc hết đồ");
}
}
catch (Exception)
{
}
LoadSoLuongSanPham();
loadThucDon();
resetThucDon();
}