public async Task <IHttpActionResult> HieuChinh(HoaDonDTO input)
{
try
{
HoaDon entity = await db.HoaDons.FindAsync(input.ID);
if (entity == null)
{
return(BadRequest($"Hóa đơn ID ={input.ID} không tồn tại"));
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
entity.HoTenKhach = input.HoTenKhach;
entity.DiaChi = input.DiaChi;
entity.DienThoai = input.DienThoai;
entity.Email = input.Email;
await db.SaveChangesAsync();
return(Ok($"Sửa hóa đơn thành công"));
}
catch (Exception ex)
{
return(BadRequest($"Hiệu chỉnh không thành công {ex.Message}"));
}
}
protected void grvHoaDon_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "ChonHD")
{
string maHD = e.CommandArgument.ToString();
HoaDonDTO hd = HoaDonBUS.LayThongTinHoaDon(maHD);
if (hd != null)
{
txtMaHD.Text = hd.MaHD;
txtTenTaiKhoan.Text = hd.TenTaiKhoan;
txtNgayMua.Text = Convert.ToString(hd.NgayMua);
txtDiaChiGiaoHang.Text = hd.DiaChiGiaoHang;
txtSDTGiaoHang.Text = hd.SDTGiaoHang;
txtTongTien.Text = Convert.ToString(hd.TongTien);
chkTrangThai.Checked = hd.TrangThai;
GiaoDienThem(false);
}
}
if (e.CommandName == "XoaHD")
{
string maHD = e.CommandArgument.ToString();
if (HoaDonBUS.XoaHoaDon(maHD))
{
XoaForm();
LoadHoaDon();
}
else
{
Response.Write("<script>alert('Xóa sản phẩm thất bại');</script>");
}
}
}
private void btnLapHoaDon_Click(object sender, EventArgs e)
{
if (dgvDanhSachPhongThanhToan.Rows.Count > 0)
{
HoaDonDTO hd = new HoaDonDTO();
List <ChiTietHoaDonDTO> dscthd = new List <ChiTietHoaDonDTO>();
for (int i = 0; i < dgvDanhSachPhongThanhToan.Rows.Count; i++)
{
ChiTietHoaDonDTO cthd = new ChiTietHoaDonDTO();
cthd.MaPhong = dgvDanhSachPhongThanhToan.Rows[i].Cells[1].Value.ToString();
cthd.SoNgayThue = int.Parse(dgvDanhSachPhongThanhToan.Rows[i].Cells[4].Value.ToString());
cthd.DonGia = double.Parse(dgvDanhSachPhongThanhToan.Rows[i].Cells[5].Value.ToString());
cthd.ThanhTien = double.Parse(dgvDanhSachPhongThanhToan.Rows[i].Cells[6].Value.ToString());
dscthd.Add(cthd);
}
hd.MaKhachHang = cbKhachHang.SelectedValue.ToString();
hd.NgayThanhToan = ngayThanhToan.Value.Date.ToString("yyyy-MM-dd");
hd.TriGia = double.Parse(txtTongGiaTri.Text);
BLL.ThemThanhToan(hd, dscthd);
MessageBox.Show("Thêm thành công");
dgvDanhSachPhongThanhToan.Rows.Clear();
txtTongGiaTri.Text = "0";
index = 0;
}
else
{
MessageBox.Show("Chưa Nhập Phòng Thanh Toán");
}
}
/// <summary>
/// load dử liệu vào hóa đơn. thông tin hóa đơn
/// </summary>
/// <param name="list"></param>
void loadDtgvBills(string MAKH, string MAHD)
{
listHOADON = cthdDAO.Instance.getListItemPreByMAKHandMAHD(MAKH, MAHD);
TotalPrice = 0;
dtgvBills.DataSource = null;
dtgvBills.DataSource = listHOADON;
dtgvBills.Columns[1].HeaderText = "Tên món ăn";
dtgvBills.Columns[2].HeaderText = "Giá";
dtgvBills.Columns[3].HeaderText = "Số lượng";
dtgvBills.Columns[4].HeaderText = "Thành tiền";
dtgvBills.Columns[5].Visible = false;
dtgvBills.Columns["MABA"].Visible = false;
dtgvBills.Columns[7].Visible = false;
dtgvBills.Columns["MAHD"].Visible = false;
foreach (ThongTinHoaDonDTO item in listHOADON)
{
TotalPrice += item.GIA * item.SoLuongMA;
}
PrePrice = 0;
HoaDonDTO hoaDon = HoaDonDAO.Instance.getHoaDonbyMaHD(MAHD);
if (hoaDon != null)
{
PrePrice = (TotalPrice * ThamSo.PrePersen / 100) - hoaDon.TIENDATHANHTOAN;
}
loadLblMoney(TotalPrice, PrePrice);
}
public static HoaDonDTO SelectHoaDonById(String hoadonID)
{
HoaDonDTO hoadon = new HoaDonDTO();
try
{
// Create List Sql Parameter
List <MySqlParameter> parameters = new List <MySqlParameter>();
parameters.Add(new MySqlParameter("@MaHD", hoadonID));
DataTable dt = MySqlDataAccessHelper.ExecuteQuery("SELECT * FROM hoadon WHERE MaHD = @MaHD", parameters);
DataRow dr = dt.Rows[0];
hoadon.MaHD = dr["MaHD"].ToString();
hoadon.NgayLapHD = DateTime.Parse(dr["NgayLapHD"].ToString());
hoadon.TongTien = int.Parse(dr["TongTien"].ToString());
hoadon.MaKH = dr["FK_MaKH"].ToString();
hoadon.GiamGia = int.Parse(dr["GiamGia"].ToString());
hoadon.ThanhTien = int.Parse(dr["ThanhTien"].ToString());
}
catch (Exception ex)
{
throw ex;
}
return(hoadon);
}
public static bool InsertHoaDon(HoaDonDTO hoadon)
{
bool result = false;
try
{
//create a list parameter
List <MySqlParameter> parameters = new List <MySqlParameter>();
//parameters.Add(new MySqlParameter("@MaTK", taikhoan.MaTK));
parameters.Add(new MySqlParameter("@MaHD", hoadon.MaHD));
parameters.Add(new MySqlParameter("@NgayLapHD", hoadon.NgayLapHD));
parameters.Add(new MySqlParameter("@TongTien", hoadon.TongTien));
parameters.Add(new MySqlParameter("@MaKH", hoadon.MaKH));
parameters.Add(new MySqlParameter("@ThanhTien", hoadon.ThanhTien));
parameters.Add(new MySqlParameter("@GiamGia", hoadon.GiamGia));
//call store Procedure
int n = MySqlDataAccessHelper.ExecuteNonQuery("INSERT INTO hoadon (MaHD, NgayLapHD, TongTien, FK_MaKH, GiamGia, ThanhTien) VALUES(@MaHD, @NgayLapHD, @TongTien, @MaKH, @GiamGia, @ThanhTien)", parameters);
if (n == 1)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public static List <HoaDonDTO> LayHoaDonTheoTuKhoa(string tukhoa)
{
List <HoaDonDTO> lhd = new List <HoaDonDTO>();
try
{
SqlDataReader reader = DataProvider.TimHoaDonTheoTuKhoa("TimHoaDonTheoTuKhoa", tukhoa);
while (reader.Read())
{
HoaDonDTO hd = new HoaDonDTO();
hd.SoHD = reader.GetInt32(0);
hd.MaKH = reader.GetString(1);
hd.MaNV = reader.GetString(2);
hd.NgayHoaDon = reader.GetDateTime(3);
hd.TriGia = (int)reader.GetDecimal(4);
lhd.Add(hd);
}
reader.Close();
}
catch
{
}
return(lhd);
}
private void btn_thanhtoan_Click(object sender, EventArgs e)
{
FrmXemBaoCao f = new FrmXemBaoCao();
HoaDonBUS hdBUS = new HoaDonBUS();
try
{
bool ktThanhToan = hdBUS.ThanhToan(hdHienHanh);
if (ktThanhToan)
{
FrmChinh frmmain = (FrmChinh)this.MdiParent;
frmmain.lsNDDTO = new LichSuNguoiDungDTO()
{
MAND = frmmain.nvDangNhap.MAND,
MANV = frmmain.nvDangNhap.MANV,
THOIGIAN = DateTime.Parse(DateTime.Now.ToString("dd/MM/yyy HH:mm")),
SUKIEN = "Hóa đơn " + hdHienHanh.MAHD + "được thanh toán"
};
bool ktls = frmmain.lsNDBUS.ThemLichSuNguoiDung(frmmain.lsNDDTO);
hdHienHanh = hdBUS.DanhSachHoaDon().Find(o => o.MAHD.Trim() == hdHienHanh.MAHD.Trim());
f.XemHoaDon(hdHienHanh);
loaddata();
}
}
catch
{
MessageBox.Show("Chưa chọn hóa đơn");
}
hdHienHanh = null;
f.Show();
}
public string insert(HoaDonDTO obj)
{
string query = string.Empty;
query += "INSERT INTO [tblkhachhang] ([makh])";
query += "VALUES (@makh)";
query += "INSERT INTO [tblhoadon] ([mahd],[makh],[masach],[ngaylap],[soluong])";
query += "VALUES (@mahd,@makh,@masach,@ngaylap,@soluong)";
using (SqlConnection conn = new SqlConnection(connectionString))
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = conn;
comm.CommandType = CommandType.Text;
comm.CommandText = query;
comm.Parameters.AddWithValue("@mahd", obj.MaHoaDon);
comm.Parameters.AddWithValue("@makh", obj.MaKhachHang);
comm.Parameters.AddWithValue("@masach", obj.MaSach);
comm.Parameters.AddWithValue("@ngaylap", obj.NgayLapHoaDon);
comm.Parameters.AddWithValue("@soluong", obj.SoLuong);
try
{
conn.Open();
comm.ExecuteNonQuery();
}
catch (Exception ex)
{
conn.Close();
return("Thêm hóa đơn thất bại\n" + ex.Message + "\n");
}
}
}
return("0");
}
public static List <HoaDonDTO> LayDanhSachHoaDon()
{
List <HoaDonDTO> lhd = new List <HoaDonDTO>();
try
{
SqlDataReader reader = DataProvider.TruyVanSqlDataReader("LayDanhSachHoaDon");
while (reader.Read())
{
HoaDonDTO hd = new HoaDonDTO();
hd.SoHD = reader.GetInt32(0);
hd.MaKH = reader.GetString(1);
hd.MaNV = reader.GetString(2);
hd.NgayHoaDon = reader.GetDateTime(3);
hd.TriGia = (int)reader.GetDecimal(4);
lhd.Add(hd);
}
reader.Close();
}
catch
{
}
return(lhd);
}
public static int AddBill(HoaDonDTO bill)
{
string querry1 = @"INSERT INTO HoaDon (Ngay, ThanhTien, SoTienThanhToan) VALUES
('" + bill.Ngay + "', '" + bill.ThanhTien + "', '" + bill.SoTienThanhToan + "')";
int result = DataProvider.ExecuteNonQuerry(querry1);
if (result <= 0)
{
return(0);
}
string querry2 = @"SELECT IDENT_CURRENT('HoaDon') AS Id";
string id = DataProvider.ExecuteQuerry(querry2).Rows[0]["Id"].ToString();
foreach (SachDTO item in bill.Sach)
{
string querry = @"INSERT INTO Sach_HoaDon (SoLuong, HoaDon, Sach) VALUES (" + item.LuongTon + "," + id +
"," + item.Id + ")";
int res = DataProvider.ExecuteNonQuerry(querry);
if (result <= 0)
{
return(0);
}
}
return(1);
}
public string delete(HoaDonDTO obj)
{
string query = string.Empty;
query += " DELETE FROM [HOADON] ";
query += " WHERE ";
query += " [MaHoaDon] = @MaHoaDon ";
using (SqlConnection conn = new SqlConnection(connectionString))
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = conn;
comm.CommandType = CommandType.Text;
comm.CommandText = query;
comm.Parameters.AddWithValue("@MaHoaDon", obj.MaHD);
try
{
conn.Open();
comm.ExecuteNonQuery();
}
catch (Exception ex)
{
conn.Close();
//' xóa that bai!!!
return("Xóa hóa đơn thất bại\n" + ex.Message + "\n" + ex.StackTrace);
}
}
}
return("0");
}
public string insert(HoaDonDTO obj)
{
string query = string.Empty;
query += "INSERT INTO [HOADON] ([MaHoaDon], [MaKhachHang], [NgayLapHoaDon], [TongThanhTien])";
query += "VALUES (@MaHoaDon,@MaKhachHang,@NgayLapHoaDon,@TongThanhTien)";
using (SqlConnection conn = new SqlConnection(connectionString))
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = conn;
comm.CommandType = CommandType.Text;
comm.CommandText = query;
comm.Parameters.AddWithValue("@MaHoaDon", obj.MaHD);
comm.Parameters.AddWithValue("@MaKhachHang", obj.MaKH);
comm.Parameters.AddWithValue("@NgayLapHoaDon", obj.NgayLap);
comm.Parameters.AddWithValue("@TongThanhTien", obj.TongThanhTien);
try
{
conn.Open();
comm.ExecuteNonQuery();
}
catch (Exception ex)
{
conn.Close();
// them that bai!!!
return("Thêm ngày nhập phiếu thất bại\n" + ex.Message + "\n" + ex.StackTrace);
}
}
}
return("0");
}
private void btnXoa_Click(object sender, EventArgs e)
{
int currentRowIndex = this.dgvDanhSachHoaDon.CurrentCellAddress.Y; //'current row selected
//Verify that indexing OK
if (-1 < currentRowIndex && currentRowIndex < dgvDanhSachHoaDon.RowCount)
{
HoaDonDTO obj = (HoaDonDTO)dgvDanhSachHoaDon.Rows[currentRowIndex].DataBoundItem;
this.txtMaHD.Text = obj.MaHD;
this.txtMaKH.Text = obj.MaKH;
this.dtpNgayLap.Text = obj.NgayLap;
this.txtTongTien.Text = obj.TongThanhTien.ToString();
string result = this.bus.delete(obj);
if (result == "0")
{
MessageBox.Show("Xóa hóa đơn thành công", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.buildDanhSach();
return;
}
else
{
MessageBox.Show("Xóa hóa đơn thất bại.\n" + result, "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
else
{
MessageBox.Show("Chưa chọn phiếu nhập trên lưới.", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
private void btnThem_HD_Click(object sender, EventArgs e)
{
try
{
TongTien = 0;
HoaDonDTO hd = new HoaDonDTO();
hd.year = dtpNgayLapHD.Value.Year;
hd.month = dtpNgayLapHD.Value.Month;
hd.day = dtpNgayLapHD.Value.Day;
hd.ma_hd = txtMHD.Text;
string ma = txtTenKHHD.Text;
KhachHangDTO kHang = new KhachHangDTO();
kHang = KhachHangBUS.Search_KH(ma);
hd.ma_kh = kHang.ma_kh;
hd.ma_nv = cbxNVLHD.SelectedValue.ToString();
HoaDonBUS.insert_HD(hd);
MessageBox.Show("Thêm thành công!", "Thông báo", MessageBoxButtons.OK);
load_data();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public bool UpdateRow(HoaDonDTO obj)
{
try
{
if (_connection.State != ConnectionState.Open)
{
_connection.Open();
}
const string sql = "UPDATE [dbo].[HoaDon]\n"
+ " SET [MaKhachHang] = @MaKhachHang\n"
+ " ,[MaNhanVien] = @MaNhanVien\n"
+ " ,[NgayHoaDon] = @NgayHoaDon\n"
+ " ,[GiamGia] = @GiamGia\n"
+ " ,[TienKhachDua] = @TienKhachDua\n"
+ " ,[TienKhachDaTra]=@TienKhachDaTra\n"
+ " WHERE [MaHoaDon] = @MaHoaDon";
SqlCommand cmd = new SqlCommand(sql, _connection);
cmd.Parameters.Add("@MaHoaDon", SqlDbType.Char).Value = obj.MaHoaDon;
cmd.Parameters.Add("@MaKhachHang", SqlDbType.Char).Value = obj.MaKhachHang;
cmd.Parameters.Add("@MaNhanVien", SqlDbType.Char).Value = obj.MaNhanVien;
cmd.Parameters.Add("@NgayHoaDon", SqlDbType.Date).Value = obj.NgayHoaDon;
cmd.Parameters.Add("@GiamGia", SqlDbType.Money).Value = obj.GiamGia;
cmd.Parameters.Add("@TienKhachDaTra", SqlDbType.Money).Value = obj.TienKhachDaTra;
cmd.Parameters.Add("@TienKhachDua", SqlDbType.Money).Value = obj.TienKhachDua;
cmd.ExecuteNonQuery();
_connection.Close();
return(true);
}
catch (Exception ex)
{
_connection.Close();
Console.WriteLine(ex.Message);
}
return(false);
}
public bool them(HoaDonDTO hd)
{
string query = string.Empty;
query += "INSERT INTO HOADON (mahd,mapk,ngaylap,tienthuoc,tongtien) VALUES (@mahd,@mapk,@ngaylap,@tienthuoc,@tongtien)";
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
{
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@mahd", hd.MaHD1);
cmd.Parameters.AddWithValue("@mapk", hd.MaPK1);
cmd.Parameters.AddWithValue("@ngaylap", hd.NgayLap1);
cmd.Parameters.AddWithValue("@tienthuoc", hd.TienThuoc1);
cmd.Parameters.AddWithValue("@tongtien", hd.TongTien1);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return(true);
con.Dispose();
}
catch (Exception ex)
{
con.Close();
}
}
}
return(false);
}
public int MsNVTTGet([PexAssumeUnderTest] HoaDonDTO target)
{
int result = target.MsNVTT;
return(result);
// TODO: add assertions to method HoaDonDTOTest.MsNVTTGet(HoaDonDTO)
}
private void btnGhiHoaDon_Click(object sender, EventArgs e)
{
// Tạo mã vạch QR
MessagingToolkit.QRCode.Codec.QRCodeEncoder encoder = new MessagingToolkit.QRCode.Codec.QRCodeEncoder();
encoder.QRCodeScale = 3;
Bitmap bmp = encoder.Encode(txtSoHD.Text);
// Chuyển hình ảnh ra dạng nhị phân
MemoryStream ms = new MemoryStream();
bmp.Save(ms, ImageFormat.Jpeg);
byte[] bmpBytes = ms.GetBuffer();
bmp.Dispose();
ms.Close();
HoaDonDTO HD = new HoaDonDTO();
HD.SoHD = txtSoHD.Text;
HD.NgayBan = dtkNgayBan.Value;
HD.HinhAnh = bmpBytes;
if (HoaDonBUS.ThemHD(HD) == true)
{
btnLapHoaDonMoi.Enabled = true;
btnThemSach.Enabled = true;
btnGhiHoaDon.Enabled = false;
btnInHoaDon.Enabled = true;
}
else
{
MessageBox.Show("Thêm hóa đơn thất bại.", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public List <HoaDonDTO> getAllItem(Connection conn)
{
List <HoaDonDTO> result = new List <HoaDonDTO>();
string queryString = "select* from hoadon";
conn.cmd.CommandText = queryString;
using (DbDataReader reader = conn.cmd.ExecuteReader())
{
if (!reader.HasRows)
{
return(null);
}
else
{
while (reader.Read())
{
HoaDonDTO temp = new HoaDonDTO(
reader.GetInt32(0),
reader.GetString(1),
reader.GetString(2),
reader.GetDateTime(3),
reader.GetString(4),
reader.GetInt32(5));
result.Add(temp);
}
}
}
return(result);
}
public static bool LuuHoaDon(HoaDonDTO hoaDon)
{
SqlConnection connection = DataProvider.GetConnection();
string query = "INSERT INTO HoaDon (nhan_vien_lap, ngay_lap, tong_tien, tien_mat, tien_thua, trang_thai) VALUES (@nhanVienLap, @ngayLap, @tongTien, @tienMat, @tienThua, @trangThai)";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.Add("@nhanVienLap", System.Data.SqlDbType.Int, 0).Value = hoaDon.NhanVienLap;
command.Parameters.Add("@ngayLap", System.Data.SqlDbType.DateTime, 0).Value = hoaDon.NgayLap;
command.Parameters.Add("@tongTien", System.Data.SqlDbType.Float, 0).Value = hoaDon.TongTien;
command.Parameters.Add("@tienMat", System.Data.SqlDbType.Float, 0).Value = hoaDon.TienMat;
command.Parameters.Add("@tienThua", System.Data.SqlDbType.Float, 0).Value = hoaDon.TienThua;
command.Parameters.Add("@trangThai", System.Data.SqlDbType.Bit, 0).Value = hoaDon.TrangThai;
connection.Open();
int reader = command.ExecuteNonQuery();
connection.Close();
if (reader > 0)
{
return(true);
}
return(false);
}
public void SoKhachGet523()
{
int i;
HoaDonDTO s0 = new HoaDonDTO(0, default(DateTime), 0, 0, 0, 0, 0);
i = this.SoKhachGet(s0);
Assert.AreEqual <int>(0, i);
Assert.IsNotNull((object)s0);
Assert.AreEqual <int>(0, s0.SoHD);
Assert.AreEqual <int>(1, s0.TimeLapHD.Day);
Assert.AreEqual <DayOfWeek>(DayOfWeek.Monday, s0.TimeLapHD.DayOfWeek);
Assert.AreEqual <int>(1, s0.TimeLapHD.DayOfYear);
Assert.AreEqual <int>(0, s0.TimeLapHD.Hour);
Assert.AreEqual <DateTimeKind>(DateTimeKind.Unspecified, s0.TimeLapHD.Kind);
Assert.AreEqual <int>(0, s0.TimeLapHD.Millisecond);
Assert.AreEqual <int>(0, s0.TimeLapHD.Minute);
Assert.AreEqual <int>(1, s0.TimeLapHD.Month);
Assert.AreEqual <int>(0, s0.TimeLapHD.Second);
Assert.AreEqual <int>(1, s0.TimeLapHD.Year);
Assert.AreEqual <int>(0, s0.MsBan);
Assert.AreEqual <int>(0, s0.SoKhach);
Assert.AreEqual <int>(0, s0.MsNVLap);
Assert.AreEqual <int>(0, s0.MsNVTT);
Assert.AreEqual <double>(0, s0.TongTien);
}
// Lấy danh sách theo khoảng thời gian
public static List <HoaDonDTO> GetListBillByTime(DateTime dateFrom, DateTime dateEnd)
{
SqlConnection connection = DataProvider.GetConnection();
string query = "SELECT ma_hoa_don, nhan_vien_lap, ngay_lap, tong_tien, tien_mat, tien_thua, trang_thai FROM HoaDon WHERE ngay_lap BETWEEN @dateFrom AND @dateEnd";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.Add("@dateFrom", System.Data.SqlDbType.DateTime, 0).Value = dateFrom;
command.Parameters.Add("@dateEnd", System.Data.SqlDbType.DateTime, 0).Value = dateEnd;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <HoaDonDTO> result = new List <HoaDonDTO>();
if (reader.HasRows)
{
while (reader.Read())
{
HoaDonDTO hd = new HoaDonDTO();
hd.MaHoaDon = reader.GetInt32(0);
hd.NhanVienLap = reader.GetInt32(1);
hd.NgayLap = reader.GetDateTime(2);
hd.TongTien = reader.GetDouble(3);
hd.TienMat = reader.GetDouble(4);
hd.TienThua = reader.GetDouble(5);
hd.TrangThai = reader.GetBoolean(6);
result.Add(hd);
}
}
connection.Close();
return(result);
}
// Lấy hóa đơn một ngày cụ thể
public static List <HoaDonDTO> GetListBillTimeline(DateTime timeLine)
{
SqlConnection connection = DataProvider.GetConnection();
string query = "SELECT ma_hoa_don, nhan_vien_lap, ngay_lap, tong_tien, tien_mat, tien_thua, trang_thai FROM HoaDon WHERE DATEPART(YYYY, ngay_lap) = YEAR(@timeLine) AND DATEPART(MM, ngay_lap) = MONTH(@timeLine) AND DATEPART(DD, ngay_lap) = DAY(@timeLine)";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.Add("@timeLine", System.Data.SqlDbType.DateTime, 0).Value = timeLine;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <HoaDonDTO> result = new List <HoaDonDTO>();
if (reader.HasRows)
{
while (reader.Read())
{
HoaDonDTO hd = new HoaDonDTO();
hd.MaHoaDon = reader.GetInt32(0);
hd.NhanVienLap = reader.GetInt32(1);
hd.NgayLap = reader.GetDateTime(2);
hd.TongTien = reader.GetDouble(3);
hd.TienMat = reader.GetDouble(4);
hd.TienThua = reader.GetDouble(5);
hd.TrangThai = reader.GetBoolean(6);
result.Add(hd);
}
}
connection.Close();
return(result);
}
public bool CapNhatHD(HoaDonDTO hd)
{
DateTime aDateTime = DateTime.Now;
//MessageBox.Show(aDateTime.ToString("dd/MM/yyyy HH:mm:ss.fff"));
DateTime y2K = hd.THOIGIANBATDAU;
TimeSpan interval = aDateTime.Subtract(y2K);
SqlConnection con = DataProvider.TaoKetNoi();
int gio = interval.Hours;
if (gio == 1)
{
gio = 0; // hat chua den 1h
}
MessageBox.Show(gio.ToString());
string capnhatphong = "UPDATE PHONG SET TINHTRANG = 2 where MAPHONG = '" + hd.MAPHONG + "'";
bool thucthip = DataProvider.ThucThi(capnhatphong, con);
string updateHD = "UPDATE HOADON SET TONGTHANHTOAN = TONGTHANHTOAN + (GIAPHONG * " + gio + "),THOIGIANKETTHUC = '" + DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss") + "', TINHTRANG = 1 where MAHD = '" + hd.MAHD.Trim() + "'";
bool thucthi = DataProvider.ThucThi(updateHD, con);
return(thucthi);
}
private void btnthem_Click(object sender, EventArgs e)
{
int dem = dshoadon.Rows.Count;
HoaDonDTO hd = new HoaDonDTO();
try
{
hd.MaKhachHang = int.Parse(txtmakh.Text);
}
catch (FormatException)
{
MessageBox.Show("Phải chọn Khách Hàng từ danh sách");
btnmakh_Click(sender, e);
return;
}
hd.NgayLapHoaDon = dtngaylaphoadon.Value;
if (HoaDonBUS.ThemHoaDon(hd) == false)
{
MessageBox.Show("Thêm thất bại");
return;
}
hienthidshoadon();
txtmahdct.Text = dshoadon.Rows[dem].Cells[0].Value.ToString();
txtmakhct.Text = dshoadon.Rows[dem].Cells[2].Value.ToString();
phongto();
}
public List <HoaDonDTO> dsHoaDon()
{
List <HoaDonDTO> ds = new List <HoaDonDTO>();
SqlConnection conn = DataProvider.TaoKetNoi();
string sql = "select * from HOADON";
SqlDataReader sdr = DataProvider.TruyVanDuLieu(sql, conn);
while (sdr.Read())
{
HoaDonDTO a = new HoaDonDTO()
{
MAHD = sdr.GetString(0),
MAPHONG = sdr.GetString(1),
MANV = sdr.GetString(2),
MAKH = sdr.GetString(3),
THOIGIANBATDAU = DateTime.Parse(sdr.GetDateTime(4).ToString("dd/MM/yyyy HH:mm")),
THOIGIANKETTHUC = DateTime.Parse(sdr.GetDateTime(5).ToString("dd/MM/yyyy HH:mm")),
TONGTHANHTOAN = sdr.GetDecimal(6).ToString("0,00"),
TINHTRANG = sdr.GetBoolean(7),
GIAPHONG = sdr.GetDecimal(8).ToString("0,00"),
};
ds.Add(a);
}
return(ds);
}
private void ganDuLieu(HoaDonDTO hd)
{
hd.MaHD = txtMaHD.Text;
hd.MaKH = cboMaKH.Text;
hd.MaNV = cboMaNV.Text;
hd.NgayLap = dateNgayLap.Value.ToString("yyyy-MM-dd");
}
public static void Delete_KH(KhachHangDTO kh)
{
try
{
HoaDonDTO hd = new HoaDonDTO();
PhieuDatHangDTO pdh = new PhieuDatHangDTO();
List <string> ds = new List <string>();
string delete_kh = string.Format("DELETE FROM db_khach_hang WHERE ma_kh='{0}'", kh.ma_kh);
string delete_hd_in_kh = string.Format("SELECT ma_hd FROM db_hoa_don WHERE ma_kh = '{0}'", kh.ma_kh);
string delete_pdh_in_kh = string.Format("SELECT ma_pdh FROM db_phieu_dat_hang WHERE ma_kh = '{0}'", kh.ma_kh);
ds = Xoa_thong_tin(delete_hd_in_kh);
for (int i = 0; i < ds.Count; i++)
{
hd.ma_hd = ds[0];
ChiTietHoaDonDAO.delete_SPHD(hd);
HoaDonDAO.Delete_HD(hd);
}
ds = Xoa_thong_tin(delete_pdh_in_kh);
for (int i = 0; i < ds.Count; i++)
{
pdh.ma_pdh = ds[0];
ChiTietPhieuDatHangDAO.delete_SPPDH(pdh);
PhieuDatHangDAO.Delete_PDH(pdh);
}
cnn = DataProvider.ConnectData();
DataProvider.Execute(cnn, delete_kh);
cnn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
public HoaDonDTO GetRow(string maHoaDon)
{
try
{
var hoaDon = new HoaDonDTO();
if (_connection.State != ConnectionState.Open)
{
_connection.Open();
}
SqlCommand command = new SqlCommand("SELECT * FROM HoaDon WHERE MaHoaDon = @mahoadon", _connection);
command.Parameters.Add("@mahoadon", SqlDbType.Char).Value = maHoaDon;
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
hoaDon.MaHoaDon = reader["MaHoaDon"].ToString();
hoaDon.MaKhachHang = reader["MaKhachHang"].ToString();
hoaDon.NgayHoaDon = (DateTime)reader["NgayHoaDon"];
hoaDon.MaNhanVien = reader["MaNhanVien"].ToString();
hoaDon.TienKhachDaTra = (decimal)reader["TienKhachDaTra"];
hoaDon.GiamGia = (decimal)reader["GiamGia"];
hoaDon.TienKhachDua = (decimal)reader["TienKhachDaTra"];
reader.Close();
}
return(hoaDon);
}
catch (Exception ex)
{
_connection.Close();
Console.WriteLine(ex.Message);
}
return(null);
}
public bool LapHoaDon(HoaDonDTO dtoHD)
{
return ws.LapHoaDon(dtoHD);
}
private DataTable ConvertHoaDonDTOArrayToDataTable(HoaDonDTO[] hDTOArr)
{
DataTable dt = new DataTable();
dt.Columns.Add("MaHoaDon", typeof(string));
dt.Columns.Add("NgayLap", typeof(DateTime));
dt.Columns.Add("TriGia", typeof(float));
dt.Columns.Add("ThanhToan", typeof(string));
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows.Add(hDTOArr[i].DiaChi, hDTOArr[i].MaHoaDon, hDTOArr[i].NgayLap, hDTOArr[i].TriGia, hDTOArr[i].ThanhToan);
}
return dt;
}
private void btnTinhTien_Click(object sender, EventArgs e)
{
if (kiemtra())
{
labTPT.Text = Math.Round(decimal.Parse(labTP.Text) + decimal.Parse(labTDV.Text), 0).ToString("0,0");
hdDTO = new HoaDonDTO();
PhieuThuePhongDTO ptp = pthueph.getPhieuThuePhongByID(cmbMaPT.Text);
PhieuDatPhongDTO pdp = pdatph.getPhieuDatPhongByID(ptp.Maphieudat);
hdDTO.Mahoadon = labMaHD.Text;
hdDTO.Ngaythanhtoan = dtpNgay.Value;
hdDTO.Tongtien = decimal.Parse(labTPT.Text);
hdDTO.Maphieuthue = cmbMaPT.Text;
hdDTO.Makhachhang = pdp.Makhachhang;
hdDTO.Username = frmMain.m_username;
if (hoadon.insertHoaDon(hdDTO) == 1)
{
pdpDTO = new PhieuDatPhongDTO();
pdpDTO.Maphieudat = pdp.Maphieudat;
pdpDTO.Makhachhang = pdp.Makhachhang;
pdpDTO.Ngayden = pdp.Ngayden;
pdpDTO.Ngaydi = pdp.Ngaydi;
pdpDTO.Sotiendatcoc = pdp.Sotiendatcoc;
pdpDTO.Username = pdp.Username;
pdpDTO.Tinhtrang = "finish";
pdpDTO.Songuoi = pdp.Songuoi;
if (pdatph.updatePhieuDatPhong(pdpDTO) == 1)
{
IList<ChiTietDatPhongDTO> listctdp = ctdatph.getChiTietDatPhongByID(pdp.Maphieudat);
foreach (ChiTietDatPhongDTO ctdp in listctdp)
{
pDTO = new PhongDTO();
PhongDTO p = phong.getPhongByID(ctdp.Maphong);
pDTO.Maphong = p.Maphong;
pDTO.Maloai = p.Maloai;
pDTO.Dadat = false;
pDTO.Danhan = false;
if (phong.updatePhong(pDTO) == 1)
{
}
else
{
MessageBox.Show("Lỗi sửa phòng!");
}
}
}
else
{
MessageBox.Show("Lỗi sửa phiếu đặt phòng!");
}
flagtinhtien = true;
show_KH();
show_Phong();
show_DV();
//show_MaPT();
frmMain.capnhatphong();
MessageBox.Show("Đã tính tiền!");
btnInhoadon.Visible = true;
}
else
{
MessageBox.Show("Lỗi dữ liệu!");
}
}
}
