public void pictureBox8_Click(object sender, EventArgs e)
{
DTO_HoaDon dichvu = new DTO_HoaDon();
dichvu.TenDichVu = "Bánh Mì";
dichvu.MaHD = mahd;
dichvu.MaChiNhanh = machinhanh;
dichvu.MaPhong = maphong;
dichvu.SoDienThoai = sdt;
int DongCuoi = dgvHienThi.Rows.Count - 2;
int STT = int.Parse(dgvHienThi.Rows[DongCuoi].Cells["STT"].Value.ToString()) + 1;
dichvu.STT = STT;
dichvu.MaDV = "TA_BANHMI";
dichvu.SoLuong = soluong;
dichvu.ThanhTien = soluong * 20000;
dichvu.NgayDatPhong = DateTime.Now.ToShortDateString();
dichvu.NgayTraPhong = DateTime.Now.ToShortDateString();
dichvu.DapUng = "No";
dichvu.DatCoc = "Yes";
dichvu.ThoiGianThucHienHoaDon = DateTime.Now;
BO_ChiTietPhong them = new BO_ChiTietPhong();
them.ThemDV(dichvu);
HienThi();
}
public void pictureBox14_Click(object sender, EventArgs e)
{
SoLuong number = new SoLuong();
number.DonVi("Ngay");
number.ShowDialog();
number.soluong(ref soluong);
if (soluong == 0)
{
}
else
{
DTO_HoaDon dichvu = new DTO_HoaDon();
dichvu.TenDichVu = "LapTop";
dichvu.MaHD = mahd;
dichvu.MaChiNhanh = machinhanh;
dichvu.MaPhong = maphong;
dichvu.SoDienThoai = sdt;
int DongCuoi = dgvHienThi.Rows.Count - 2;
int STT = int.Parse(dgvHienThi.Rows[DongCuoi].Cells["STT"].Value.ToString()) + 1;
dichvu.STT = STT;
dichvu.MaDV = "DVP_LAPTOP";
dichvu.SoLuong = soluong;
dichvu.ThanhTien = soluong * 70000;
dichvu.NgayDatPhong = DateTime.Now.ToShortDateString();
dichvu.NgayTraPhong = DateTime.Now.ToShortDateString();
dichvu.DapUng = "No";
dichvu.DatCoc = "Yes";
dichvu.ThoiGianThucHienHoaDon = DateTime.Now;
BO_ChiTietPhong them = new BO_ChiTietPhong();
them.ThemDV(dichvu);
HienThi();
}
}
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();
}
}
void LuuHoaDon()
{
string maHD = bus_hoaDon.GetMaHoaDonNext();
string maPK = tbxMaPhieuKham.Text;
int tienKham = bus_thamSo.GetGiaTriThamSo("TienKham");
if (tienKham == -1)
{
MessageBox.Show("Lấy thông tin tiền khám thất bại!");
tienKham = 0;
}
int tienThuoc = 0;
DataTable dtTienThuocTmp = bus_donThuoc.GetThongTinTienThuocFromPhieuKham(tbxMaPhieuKham.Text);
foreach (DataRow r in dtTienThuocTmp.Rows)
{
tienThuoc += Int32.Parse(r.ItemArray[3].ToString());
}
//MessageBox.Show(tienThuoc.ToString());
DTO_HoaDon hoaDon = new DTO_HoaDon(maHD, maPK, tienKham, tienThuoc);
bus_hoaDon.Add(hoaDon);
//LuuNo vao dto
}
private void btnHuyTiec_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("BẠN CÓ CHẮC MUỐN HỦY TIỆC", "", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
if (busTiecCuoi.HuyTiecCuoi(MaTiecCuoi))
{
double TienCoc = busTiecCuoi.GetTiecCoc(MaTiecCuoi) * ((double)(100 - busTiecCuoi.getTienDo(MaTiecCuoi)) / 100);
var result = MessageBox.Show("Số tiền cọc còn lại là: " + /* busTiecCuoi.CapNhatHuyTiec(MaTiecCuoi)*/ TienCoc, null, MessageBoxButtons.OK);
if (result == DialogResult.OK)
{
DateTime dateTime = DateTime.UtcNow.Date;
DTO_HoaDon HD = new DTO_HoaDon(MaTiecCuoi, MaTiecCuoi, dateTime.ToString("dd/MM/yyyy"), 0, 0, (int)TienCoc, 0, 1);
BUS_HoaDon BHD = new BUS_HoaDon();
if (BHD.insertHoaDon(HD))
{
MessageBox.Show("Hủy Tiệc Thành Công");
this.dgvTC.DataSource = busTiecCuoi.getTiecCuoi();
}
}
}
else
{
MessageBox.Show("Hủy tiệc thất bạ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);
}
protected void btnThanhToan_Click(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["TenTK"];
if (cookie != null)
{
string tenTK = cookie.Value;
DTO_HoaDon hd = new DTO_HoaDon();
hd.TenTaiKhoan = tenTK;
hd.NgayMua = DateTime.Now;
hd.DiaChiGiaoHang = "Tp.HCM";
hd.SdtGiaoHang = "0905939947";
hd.TongTien = BUS_GioHang.TinhTongTienGH(tenTK);
hd.MaHD = BUS_HoaDon.ThemHD(hd);
DataTable dtbKetQua = BUS_GioHang.LayGH(tenTK);
foreach (DataRow dr in dtbKetQua.Rows)
{
DTO_CTHoaDon cthd = new DTO_CTHoaDon();
cthd.MaHD = hd.MaHD;
cthd.MaSP = dr["MaSP"].ToString();
cthd.SoLuong = Convert.ToInt32(dr["SoLuong"]);
cthd.DonGia = Convert.ToInt32(dr["GiaTien"]);
BUS_CTHoaDon.ThemCTHD(cthd);
}
}
}
public DTO_HoaDon[] _List_Hoa_Hon_Van_Chuyen(DTO_HoaDon hoadon)
{
string sql = "select * from dm_hoa_don where ma_khach_hang=@mkh and ma_hop_dong=@mhd order by ngay_xuat desc";
SqlParameter[] para =
{
new SqlParameter("@mkh", hoadon.ma_khach_hang.Trim()), new SqlParameter("@mhd", hoadon.ma_hop_dong.Trim())
};
DataTable dt = data.ExcuteDataTable(sql, para);
if (dt != null && dt.Rows.Count > 0)
{
DTO_HoaDon[] dto = new DTO_HoaDon[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
dto[i] = new DTO_HoaDon();
dto[i].ma_hoa_don = dt.Rows[i]["so_hoa_don"].ToString();
dto[i].ma_hop_dong = dt.Rows[i]["ma_hop_dong"].ToString();
dto[i].ma_khach_hang = dt.Rows[i]["ma_khach_hang"].ToString();
//dto[i].tong_khoi_luong = float.Parse(dt.Rows[i]["tongkhoiluong"].ToString());
dto[i].tong_cuot_van_chuyen = float.Parse(dt.Rows[i]["tongcuocvanchuyen"].ToString());
dto[i].theu = float.Parse(dt.Rows[i]["thue"].ToString());
dto[i].tong_cong = float.Parse(dt.Rows[i]["tong_cong"].ToString());
dto[i].ngay_Xuat_hoa_don = Convert.ToDateTime(dt.Rows[i]["ngay_xuat"].ToString());
}
return(dto);
}
return(null);
}
private void btnxoa_Click(object sender, EventArgs e)
{
if (txtmahoadon.Text.Trim() != "")
{
DialogResult kq = MessageBox.Show("Bạn Chắc Chắc Muốn Xóa Mã Hóa Đơn : " + txtmahoadon.Text.Trim() + " !", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (kq == DialogResult.Yes)
{
DTO_HoaDon hoadon = new DTO_HoaDon();
hoadon.ma_hoa_don = txtmahoadon.Text.Trim();
int i = new BLL_HoaDon()._Xoa_Hoa_Don_Van_Chuyen(hoadon);
if (i == 0)
{
MessageBox.Show("Xóa Hóa Đơn Thành Công !", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
_List_View_Hoa_Don();
lvchitiethoadon.Items.Clear();
}
else
{
MessageBox.Show("Xóa Hóa Đơn Thất Bại !", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
else
{
MessageBox.Show("Bạn Chưa Chọn Hóa Đơn Cần Xóa !", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btntim_Click(object sender, EventArgs e)
{
lvhoadon.Items.Clear();
DTO_HoaDon hoadon = new DTO_HoaDon();
hoadon.ma_khach_hang = txtmakhachhang.Text.Trim();
hoadon.ma_hop_dong = cbmahopdong.Text.Trim();
hoadon.ma_hoa_don = txtmahoadon.Text.Trim();
int STT = 1;
if (new BLL_HoaDon()._Tim_Hoa_Hon_Van_Chuyen(hoadon) != null && new BLL_HoaDon()._Tim_Hoa_Hon_Van_Chuyen(hoadon).Count() > 0)
{
foreach (DTO_HoaDon hd in new BLL_HoaDon()._Tim_Hoa_Hon_Van_Chuyen(hoadon))
{
ListViewItem list = new ListViewItem(STT.ToString());
ListViewItem.ListViewSubItem lv1 = new ListViewItem.ListViewSubItem(list, hd.ma_hoa_don.Trim());
list.SubItems.Add(lv1);
ListViewItem.ListViewSubItem lv2 = new ListViewItem.ListViewSubItem(list, hd.tong_cuot_van_chuyen.ToString("###,###,###"));
list.SubItems.Add(lv2);
ListViewItem.ListViewSubItem lv3 = new ListViewItem.ListViewSubItem(list, hd.theu.ToString("###,###,###"));
list.SubItems.Add(lv3);
ListViewItem.ListViewSubItem lv4 = new ListViewItem.ListViewSubItem(list, hd.tong_cong.ToString("###,###,###"));
list.SubItems.Add(lv4);
ListViewItem.ListViewSubItem lv5 = new ListViewItem.ListViewSubItem(list, hd.ngay_Xuat_hoa_don.ToShortDateString());
list.SubItems.Add(lv5);
lvhoadon.Items.Add(list);
STT++;
}
}
}
private void pictureBox1_Click(object sender, EventArgs e)
{
DialogResult answer = MessageBox.Show("Bạn có muốn xóa yêu cầu này không ?", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (answer == DialogResult.Yes)
{
DTO_HoaDon hoadon = new DTO_HoaDon();
hoadon.MaPhong = maphong;
hoadon.MaChiNhanh = machinhanh;
hoadon.STT = stt;
hoadon.MaHD = mahd;
BO_QuanLiChiNhanh yeucau = new BO_QuanLiChiNhanh();
int result = yeucau.XoaYeuCau(hoadon);
if (result != -1)
{
this.Hide();
YeuCauKhachHang dsyeucau = new YeuCauKhachHang();
dsyeucau.MANV = manv;
dsyeucau.MACHINHANH = machinhanh;
dsyeucau.TENNV = tennv;
dsyeucau.TENCHINHANH = tenchinhanh;
dsyeucau.ShowDialog();
this.Close();
}
else
{
MessageBox.Show("Đã xảy ra lỗi vui lòng thử lại", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public async Task <List <string> > AddHoaDonAsync(DTO_HoaDon hd)
{
using (var context = new SQLServerDBContext())
{
var returnCode = new SqlParameter();
returnCode.ParameterName = "@ReturnCode";
returnCode.SqlDbType = SqlDbType.Int;
returnCode.Direction = ParameterDirection.Output;
string res = null;
try
{
res = await context.Database.SqlQuery <string>("exec @ReturnCode = proc_HoaDon_insert @1, @2, @3, @4, @5, @6",
new SqlParameter[]
{
new SqlParameter("@1", hd.ChiTiet),
new SqlParameter("@2", hd.ThanhTien),
new SqlParameter("@3", hd.NgayLap),
new SqlParameter("@4", hd.LoaiHoaDon),
new SqlParameter("@5", hd.MaBenhNhan),
new SqlParameter("@6", hd.MaNhanVien),
returnCode
}).FirstOrDefaultAsync();
var code = ((int)returnCode.Value).ToString();
return(new List <string> {
code, res
});
}
catch (Exception e)
{
Debug.WriteLine("[ERROR ADD HoaDon] " + e.Message);
throw e;
}
}
}
public string Delete(DTO_HoaDon obj)
{
string query = string.Empty;
query += " DELETE FROM [TBL_HOADON] ";
query += " WHERE ";
query += " [MACTHD] = @MACTHD ";
using (SqlConnection conn = new SqlConnection(connectionSTR))
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = conn;
comm.CommandType = CommandType.Text;
comm.CommandText = query;
comm.Parameters.AddWithValue("@MACTHD", obj.MaCTHD);
try
{
conn.Open();
comm.ExecuteNonQuery();
}
catch (Exception ex)
{
conn.Close();
return("Deleting fails\n" + ex.Message + "\n" + ex.StackTrace);
}
}
}
return("0");
}
private void pbXacNhan_Click(object sender, EventArgs e)
{
DTO_HoaDon hoadon = new DTO_HoaDon();
hoadon.MaPhong = maphong;
hoadon.MaChiNhanh = machinhanh;
hoadon.STT = stt;
hoadon.MaHD = mahd;
BO_QuanLiChiNhanh yeucau = new BO_QuanLiChiNhanh();
int result = yeucau.ThucHienYeuCau(hoadon);
if (result != -1)
{
this.Hide();
YeuCauKhachHang dsyeucau = new YeuCauKhachHang();
dsyeucau.MANV = manv;
dsyeucau.MACHINHANH = machinhanh;
dsyeucau.TENNV = tennv;
dsyeucau.TENCHINHANH = tenchinhanh;
dsyeucau.ShowDialog();
this.Close();
}
else
{
MessageBox.Show("Đã xảy ra lỗi vui lòng thử lại", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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 load()
{
BO_DangNhap dangnhap = new BO_DangNhap();
DTO_KhachHang khachhang = new DTO_KhachHang();
khachhang.SDT = sdt;
DataSet result = new DataSet();
result = dangnhap.KT_SDT(khachhang, ref tenkh);
lb_Ten.Text = tenkh;
DTO_HoaDon hoadon = new DTO_HoaDon();
hoadon.MaHD = mahd;
BO_ChiTietPhong hienthi = new BO_ChiTietPhong();
DataSet table = hienthi.HienThi(hoadon);
if (table.Tables.Count > 0 && table != null)
{
dgvHienThi.DataSource = table.Tables[0];
}
total = 0;
if (dgvHienThi.Rows.Count != 0)
{
for (int i = 0; i < dgvHienThi.Rows.Count - 1; i++)
{
total += int.Parse(dgvHienThi.Rows[i].Cells["ThanhTien"].Value.ToString());
}
}
txtTong.Text = total.ToString();
txtTenphong.Text = tenphong;
}
public int _Them_Cong_No_Khach_Hang(DTO_HoaDon hoadon, DTO_CongNo congno)
{
int i = 0;
string sql = "select * from dm_hoa_don where so_hoa_don=@mhd ";
SqlParameter[] para = { new SqlParameter("@mhd", hoadon.ma_hoa_don.Trim()) };
DataTable dt = data.ExcuteDataTable(sql, para);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string insert = "insert into dm_cong_no(ma_cong_no,ma_khach_hang,so_hoa_don,so_tien_thanh_toan,ngay_xuat_hd)"
+ " values(@ma_cong_no,@ma_khach_hang,@so_hoa_don,@so_tien_thanh_toan,@ngay_xuat_hd)";
SqlParameter[] para2 =
{
new SqlParameter("@ma_cong_no", congno.ma_cong_no.Trim()),
new SqlParameter("@ma_khach_hang", dr["ma_khach_hang"].ToString()),
new SqlParameter("@so_hoa_don", dr["so_hoa_don"].ToString()),
new SqlParameter("@so_tien_thanh_toan", float.Parse(dr["tong_cong"].ToString())),
new SqlParameter("@ngay_xuat_hd", Convert.ToDateTime(dr["ngay_xuat"].ToString()))
};
bool kq = data.ExcuteNonQuery(insert, para2);
if (kq == false)
{
i = 1;
}
}
}
return(i);
}
private void btnHD_Sua_Click(object sender, EventArgs e)
{
DTO_HoaDon hd = new DTO_HoaDon();
hd.MaHoaDon = int.Parse(txtHD_MaHoaDon.Text);
hd.MaThuoc = cbbHD_MaThuoc.Text;
hd.NgayLap = dtpkHD_NgayLapHD.Value;
hd.SoLuong = int.Parse(txtHD_SoLuong.Text);
hd.LoaiHoaDon = cbbHD_LoaiHD.Text;
DTO_KhachHang kh = khBUS.getKhachHangTheoTen(cbbHD_KhachHang.Text);
hd.MaKhach = kh.MaKhachHang;
errorProvider1.Clear();
if (hdBUS.editHoaDon(hd))
{
MessageBox.Show("Sửa Thành Công!", "Thông Tin", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadData_HD();
khoaThongTinHD();
restTxtHD();
}
else
{
MessageBox.Show("Sửa Không Thành Công!", "Thông Tin", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public bool addHoaDon(DTO_HoaDon dtoHoaDon)
{
String SQLInsert = "INSERT INTO HOADON(HOADON.MAHOADON, HOADON.MANHANVIEN, HOADON.TENKHACHHANG, HOADON.NGAYLAPDON, HOADON.GIA) " +
"VALUES(@MAHOADON, @MANHANVIEN, @TENKHACHHANG, @NGAYLAPDON, @GIA)";
try
{
conn = new DBConnection().getConnection();
conn.Open();
SqlCommand sqlCommand = new SqlCommand(SQLInsert, conn);
sqlCommand.Parameters.AddWithValue("MAHOADON", dtoHoaDon.maHoaDon);
sqlCommand.Parameters.AddWithValue("MANHANVIEN", dtoHoaDon.maNhanVien);
sqlCommand.Parameters.AddWithValue("TENKHACHHANG", dtoHoaDon.tenKhachHang);
sqlCommand.Parameters.AddWithValue("NGAYLAPDON", dtoHoaDon.ngayLapDon);
sqlCommand.Parameters.AddWithValue("GIA", dtoHoaDon.gia);
sqlCommand.ExecuteNonQuery();
conn.Close();
return(true);
}
catch (Exception e)
{
e.ToString();
return(false);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!busHD.KiemTraHD(lbMHD.Text))
{
DTO_HoaDon hd = new DTO_HoaDon();
hd.Loaihd = lamangve ? 1 : 0;
hd.Machinhanh = barMaCN.Caption;
hd.Mahoadon = lbMHD.Text;
hd.Makhachhang = lbMKH.Text;
hd.Manhanvien = lbMNV.Text;
hd.Ngay = barTime.Caption;
hd.Tongtien = ChuyenVNDToDecimal(lbTongTien.Text);
hd.Trangthai = 0;
string macthd = "";
if (busHD.LuuHD(hd) && busHD.LuuQHHDCTHD(lbMHD.Text, ref macthd))
{
foreach (DTO_ItemBill it in lstDSMA)
{
busHD.LuuCTHD(macthd, it);
}
MessageBox.Show("Đã tạo đơn hàng mã " + hd.Mahoadon + " thành công !!!", "Thông báo");
}
}
pnHD.Controls.Clear();
lbMHD.Text = "___";
btnSave.Enabled = false;
txtKhachDua.Enabled = false;
}
private void picTaoHoaDon_Click(object sender, EventArgs e)
{
Stelia_BUS.Stelia_BUS bus = new Stelia_BUS.Stelia_BUS();
string str = bus.getThongTinHD(0, bus.getDataTable("HOADON").Rows.Count - 1);
str = str.Remove(0, 2);
str = (Convert.ToInt32(str) + 1).ToString();
string mahd = "HD0000000000";
mahd = mahd.Remove(mahd.Length - str.Length);
mahd += str;
DTO_HoaDon hd = new DTO_HoaDon(mahd, ThongTinDangNhap.Username, txtMaKH.Text, DateChange.ToString(dateNgHD.DateTime), lblTongTienHang.Text, txtGiamGia.Text, lblThanhTien.Text);
bus.themData(hd);
foreach (UserControlPanelSanPham sp in flowGioHang.Controls)
{
sp.ThemData(mahd);
}
Bill bill = new Bill();
bill.DataSource = new Stelia_BUS.Stelia_BUS().InHoaDon(mahd);
bill.ShowPreviewDialog();
bill.PrintDialog();
if (ThongTinDangNhap.Username == "admin")
{
return;
}
DTO_NhanVien[] nv = new Stelia_BUS.Stelia_BUS().search_NhanVien(ThongTinDangNhap.Username);
nv[0].DOANHTHU += ThanhTien;
nv[0].SLHD += 1;
bus.suaData(nv[0]);
}
public bool themHoaDon(DTO_HoaDon tv)// THẮNG
{
try
{
// Ket noi
connect.Open();
string SQL = string.Format("INSERT INTO HOADON(MAHD,MANV,MAKH,NGHD,TONGTIENHANG,GIAMGIA,THANHTIEN) " +
"VALUES ( '{0}', '{1}', '{2}' , '{3}' , {4} , '{5}' , {6} ) ",
tv.MAHD, tv.MANV, tv.MAKH, tv.NGHD, tv.TONGTIENHANG, tv.GIAMGIA, tv.THANHTIEN);// DỮ LIỆU NHẬP VÀO
// Command (mặc định command type = text nên chúng ta khỏi fải làm gì nhiều).
SqlCommand cmd = new SqlCommand(SQL, connect);
// Query và kiểm tra
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception e)
{
}
finally
{
// Dong ket noi
connect.Close();
}
return(false);
}
public bool ThemHoaDonTam(DTO_HoaDon hd)
{
try
{
_conn.Open();
SqlCommand cm = new SqlCommand();
cm.Connection = _conn;
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "sp_insertHDTemp";
cm.Parameters.AddWithValue("MaHD", hd.MaHD);
cm.Parameters.AddWithValue("IdBan", hd.IdBan);
DateTime date = DateTime.Now;
cm.Parameters.AddWithValue("NgayBatDau", date);
if (cm.ExecuteNonQuery() > 0)
{
return(true);
}
}
finally
{
_conn.Close();
}
return(false);
}
public bool suaHoaDon(DTO_HoaDon tv)
{
try
{
// Ket noi
connect.Open();
// Query string
string SQL = string.Format("UPDATE HOADON " +
"SET MANV= '{1}',MAKH='{2}',NGHD= '{3}' ,TONGTIENHANG={4} ,GIAMGIA='{5}',THANHTIEN={6} " +
"WHERE MAHD='{0}' ",
tv.MAHD, tv.MANV, tv.MAKH, tv.NGHD, tv.TONGTIENHANG, tv.GIAMGIA, tv.THANHTIEN);
// Command (mặc định command type = text nên chúng ta khỏi fải làm gì nhiều).
SqlCommand cmd = new SqlCommand(SQL, connect);
// Query và kiểm tra
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception e)
{
}
finally
{
// Dong ket noi
connect.Close();
}
return(false);
}
public bool ThemHoaDonFinalNoneKH(DTO_HoaDon hd)
{
try
{
_conn.Open();
SqlCommand cm = new SqlCommand();
cm.Connection = _conn;
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "Sp_ThemHD";
cm.Parameters.AddWithValue("MaHD", hd.MaHD);
cm.Parameters.AddWithValue("MaNV", hd.MaNV);
cm.Parameters.AddWithValue("sdtkh", DBNull.Value);
cm.Parameters.AddWithValue("IdBan", hd.IdBan);
cm.Parameters.AddWithValue("KhuyenMai", hd.KhuyenMai);
cm.Parameters.AddWithValue("thanhtien", hd.ThanhTien);
if (cm.ExecuteNonQuery() > 0)
{
return(true);
}
}
finally
{
_conn.Close();
}
return(false);
}
public string Insert(DTO_HoaDon obj)
{
string query = string.Empty;
query += "INSERT INTO [TBL_HOADON] ( [MAHD], [NGAYTHANHTOAN], [TRATRUOC], [MANV], [MACTHD] )";
query += "VALUES (@MAHD, @NGAYTHANHTOAN, @TRATRUOC, @MANV, @MACTHD)";
using (SqlConnection conn = new SqlConnection(connectionSTR))
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = conn;
comm.CommandType = CommandType.Text;
comm.CommandText = query;
comm.Parameters.AddWithValue("@MAHD", obj.Mahd);
comm.Parameters.AddWithValue("@NGAYTHANHTOAN", obj.Ngaythanhtoan);
comm.Parameters.AddWithValue("@TRATRUOC", obj.Tratruoc);
comm.Parameters.AddWithValue("@MANV", obj.Manv);
comm.Parameters.AddWithValue("@MACTHD", obj.MaCTHD);
try
{
conn.Open();
comm.ExecuteNonQuery();
}
catch (Exception ex)
{
conn.Close();
return("Adding fails\n" + ex.Message + "\n" + ex.StackTrace);
}
}
}
return("0");
}
public void Them(DTO_HoaDon HoaDon)
{
string strSQL = "INSERT INTO HoaDon(MaHD,MaBan,MaKH,MaTK_NV,NgayHoaDon,MaDo_Uong,DonGia,SoLuong,ThanhTien,TrangThai) VALUES ";
strSQL = strSQL + "('" + HoaDon.MaHD + "', '" + HoaDon.MaBan + "','" + HoaDon.MaKH + "','" + HoaDon.MaTK_NV + "',GETDATE(),'" + HoaDon.MaDo_Uong + "'," + HoaDon.DonGia + "," + HoaDon.SoLuong + "," + HoaDon.ThanhTien + ",'0')";
KetNoiSQL.ExecuteNonQuery(strSQL);
}
public GUI_NhapThietBi(Form p, DTO_HoaDon request)
{
InitializeComponent();
parent = p;
hoadonDTO = request;
nhapBUS = new BUS_NhapThietBi();
}
private void bt_Huy_Click(object sender, EventArgs e)
{
if (txb_MaKH.Text == "")
{
MessageBox.Show("Chưa nhập thông tin đơn đặt phòng cần hủy", "Erro");
return;
}
DTO_CTHD obj_cthd = new DTO_CTHD();
DTO_CTDV obj_ctdv = new DTO_CTDV();
DTO_HoaDon obj_hd = new DTO_HoaDon();
obj_hd.MaCTHD = get_MACTHD;
obj_ctdv.Macthd = get_MACTHD;
obj_cthd.Macthd = get_MACTHD;
if (bus_ctdv.DeleteAll(obj_ctdv) != "0")
{
MessageBox.Show("Huy phong that bai");
return;
}
if (bus_hd.Delete(obj_hd) != "0")
{
MessageBox.Show("Huy phong that bai");
return;
}
if (bus_cthd.Delete(obj_cthd) != "0")
{
MessageBox.Show("Huy phong that bai");
return;
}
List <DTO_LoaiPhong> lsobj_lp = new List <DTO_LoaiPhong>();
List <DTO_Phong> lsobj_p = new List <DTO_Phong>();
string result = bus_p.SelectAll(lsobj_p);
string result1 = bus_lp.SelectAll(lsobj_lp);
var Malp = from x in lsobj_p
join y in lsobj_lp on x.Malp equals y.Malp
where x.Sophong == txb_SoPhong.Text
select new
{
SoPhong = x.Sophong,
TrangThai = "EMPTY",
MaLP = x.Malp,
};
DTO_Phong objp = new DTO_Phong();
foreach (var x in Malp)
{
objp.Sophong = x.SoPhong;
objp.Malp = x.MaLP;
objp.Status = x.TrangThai;
}
bus_p.Update(objp);
MessageBox.Show("Huy phong thanh cong");
}
public void ChangeSelectedHoaDon(int id)
{
if (id < 0)
{
return;
}
listRequest.SelectedIndex = id;
selectedHoaDon = hoaDons[listRequest.SelectedIndex];
}
