private void btnThanhtoan_Click(object sender, EventArgs e) { int sum = 0; for (int i = 0; i < dgvThongtin.Rows.Count; i++) { sum += int.Parse(dgvThongtin.Rows[i].Cells["Gia"].Value.ToString()); } _Gia = int.Parse(cn.GetValue(@"select DonGiaHT from tblHoaDon where MaHD = '" + cmbMahd.Text + "'")); sum += getCost(dtpNgayVao.Value, dtpNgayra.Value, _Gia); MessageBox.Show("Tổng số tiền thanh toán: " + sum.ToString()); //update hoa don ecHD.ThanhTien = sum.ToString(); ecHD.MaHD = cmbMahd.Text; dalHD.ThanhToan(ecHD); //thay doi thong tin phong EC_Phong ph = new EC_Phong(); ph.MaPh = cn.GetValue(@"select MaPh from tblPhieuThue where MaPhieu = '" + cmbMahd.Text + "'"); ph.TrangThai = "Tốt"; dalPh.TraPhong(ph); cmbKhachhang.ResetText(); cmbMahd.ResetText(); dgvThongtin.DataSource = null; }
private void btnThue_Click(object sender, EventArgs e) { for (int i = 0; i < dgvThongtin.RowCount; i++) { if (Convert.ToBoolean(dgvThongtin.Rows[i].Cells["Thue"].Value) == true) { if (dgvThongtin.Rows[i].Cells["TrangThai"].Value.ToString() == "Đã thuê") { MessageBox.Show("Phòng " + dgvThongtin.Rows[i].Cells["SoPhong"].Value.ToString() + " đã được thuê rồi. Chọn phòng khác!"); dgvThongtin.Rows[i].Cells["Thue"].Value = false; return; } if (dgvThongtin.Rows[i].Cells["TrangThai"].Value.ToString() == "Hỏng") { MessageBox.Show("Phòng " + dgvThongtin.Rows[i].Cells["SoPhong"].Value.ToString() + " đang hỏng. Chọn phòng khác!"); dgvThongtin.Rows[i].Cells["Thue"].Value = false; return; } ecPT.MaPh = dgvThongtin.Rows[i].Cells["MaPh"].Value.ToString(); ecPT.MaKH = txtMaKH.Text; ecPT.MaPT = txtMaPT.Text; DateTime date = DateTime.Now; ecPT.MaPhieu = date.Day.ToString() + date.Month.ToString() + date.Hour.ToString() + date.Minute.ToString() + date.Second.ToString() + dgvThongtin.Rows[i].Cells["SoPhong"].Value.ToString(); DAL_PhieuThue dalPhieuthue = new DAL_PhieuThue(); dalPhieuthue.ThemThongTin(ecPT); EC_Phong ecPh = new EC_Phong(); ecPh.MaPh = dgvThongtin.Rows[i].Cells["MaPh"].Value.ToString(); ecPh.SoPhong = dgvThongtin.Rows[i].Cells["SoPhong"].Value.ToString(); ecPh.TrangThai = "Đã thuê"; dalPh.SuaThongTin(ecPh); ecHD.MaHD = ecPT.MaPhieu; ecHD.MaPhieuThue = ecPT.MaPhieu; ecHD.ThanhTien = "0"; ecHD.Gia = _Gia; ecHD.NgayRa = dtpNgayra.Value; dalHD.ThemThongTin(ecHD); } } MessageBox.Show("Thuê OK!"); DataTable tb = dalPh.ThongTinPhong(""); dgvThongtin.DataSource = tb; //for (int i = 0; i < dgvThongtin.RowCount; i++) //{ // dgvThongtin.Rows[i].Cells["STT"].Value = i + 1; // if (dgvThongtin.Rows[i].Cells["TrangThai"].Value.ToString() == "Tốt") dgvThongtin.Rows[i].DefaultCellStyle.BackColor = Color.Lime; // else // if (dgvThongtin.Rows[i].Cells["TrangThai"].Value.ToString() == "Đã thuê") dgvThongtin.Rows[i].DefaultCellStyle.BackColor = Color.LightSkyBlue; // else // if (dgvThongtin.Rows[i].Cells["TrangThai"].Value.ToString() == "Hỏng") dgvThongtin.Rows[i].DefaultCellStyle.BackColor = Color.Red; //} }
public int UpDate_TrangThaiTrong(EC_Phong et) { return(sql.UpDate_TrangThaiTrong(et)); }
public void HuyBan(EC_Phong et) { SQL.HuyBan(et); }
public string MaPhong(EC_Phong et) { return(SQL.MaPhong(et)); }
//-------- update data public void SuaDuLieu(EC_Phong et) { SQL.SuaDuLieu(et); }
//xóa dữ liệu public void XoaDuLieu(EC_Phong et) { cn.ThucThiCauLenhSQL(@"DELETE from Phong where SoPhong=N'" + et.SoPhong + "'"); }
//sửa dữ liệu public int SuaDuLieu(EC_Phong et) { return(cn.ThucThiCauLenhSQL(@"UPDATE Phong SET LoaiPhong =N'" + et.LoaiPhong + "', Gia =N'" + et.Gia + "', MaNV =N'" + et.MaNV + "',TrangThai=N'" + et.TrangThai + "' where SoPhong=N'" + et.SoPhong + "'")); }
public void ThemDuLieu(EC_Phong ec) { cn.ThucHienCauLenh("INSERT INTO Phong1 (MaPhong, TenPhong, LoaiPhong, Gia, TinhTrang ) VALUES('" + ec.Maphong + "',N'" + ec.Tenphong + "',N'" + ec.Loaiphong + "',N'" + ec.Gia + "',N'" + ec.Tinhtrang + "')"); }
public void TraPhong(EC_Phong EC_Ph) { connect.ThucHienLenh("update tblPhong set TrangThai = N'" + EC_Ph.TrangThai + "' where MaPh = '" + EC_Ph.MaPh + "'"); }
public int XoaTTPhong(EC_Phong EC_Ph) { return(connect.ThucHienLenh("delete from tblPhong where MaPh = '" + EC_Ph.MaPh + "'")); }
public int SuaThongTin(EC_Phong EC_Ph) { return(connect.ThucHienLenh("update tblPhong set SoPhong = N'" + EC_Ph.SoPhong + "', TrangThai = N'" + EC_Ph.TrangThai + "' where MaPh = '" + EC_Ph.MaPh + "'")); }
public int ThemThongTin(EC_Phong EC_Ph) { return(connect.ThucHienLenh("insert into tblPhong(MaPh,SoPhong,TrangThai) values(N'" + EC_Ph.MaPh + "', N'" + EC_Ph.SoPhong + "', N'" + EC_Ph.TrangThai + "') ")); }
public string TrangThai(EC_Phong et) { return(sql.TrangThai(et)); }
public int UpDate_TrangThaiDangO(EC_Phong et) { return(sql.UpDate_TrangThaiDangO(et)); }
public void DangKy(EC_Phong ec) { sql.DangKy(ec); }
//Hàm thêm dữ liệu public int ThemDuLieu(EC_Phong et) { return(cn.ThucThiCauLenhSQL(@"INSERT INTO Phong(LoaiPhong, Gia, MaNV, TrangThai) VALUES (N'" + et.LoaiPhong + "',N'" + et.Gia + "',N'" + et.MaNV + "',N'" + et.TrangThai + "')")); }
public int XoaDulieu(EC_Phong ec) { return(this.cn.Query("delete from Phong1 where MaPhong = '" + ec.Maphong + "'")); }
public int UpDate_TrangThaiDangO(EC_Phong et) { return(cn.ThucThiCauLenhSQL(@"UPDATE Phong SET TrangThai = N'Đang Ở' where SoPhong=N'" + et.SoPhong + "'")); }
public void SuaDuLieu(EC_Phong ec) { cn.ThucHienCauLenh("UPDATE Phong1 SET TenPhong = '" + ec.Tenphong + "', LoaiPhong = '" + ec.Loaiphong + "', Gia = '" + ec.Gia + "',TinhTrang='" + ec.Tinhtrang + "' WHERE MaPhong = '" + ec.Maphong + "'"); }
public string TrangThai(EC_Phong et) { return(cn.GetValue("SELECT TrangThai FROM Phong where SoPhong=N'" + et.SoPhong + "'")); }
public void DangKy(EC_Phong ec) { cn.ThucHienCauLenh("UPDATE Phong1 SET TinhTrang='" + ec.Tinhtrang + "' ,status ='" + ec.Status + "' WHERE MaPhong = '" + ec.Maphong + "'"); }
public void ThemDuLieu(EC_Phong et) { SQL.ThemDuLieu(et); }
public void ThemDuLieu(EC_Phong ec) { sql.ThemDuLieu(ec); }
// delete data public void XoaDuLieu(EC_Phong et) { SQL.XoaDuLieu(et); }
public int XoaduLieu(EC_Phong ec) { return(this.sql.XoaDulieu(ec)); }
public string LoadTrangThai(EC_Phong et) { return(SQL.LoadTrangThai(et)); }
public void SuaDuLieu(EC_Phong ec) { sql.SuaDuLieu(ec); }
public void ThanhToanBan(EC_Phong et) { SQL.ThanhToanBan(et); }
//xóa dữ liệu public void XoaDuLieu(EC_Phong et) { sql.XoaDuLieu(et); }