private void load()
{
connectDBEntity mod = new connectDBEntity();
List <TAIKHOAN> tAIKHOANs = mod.TAIKHOAN.ToList();
dgvAccount.DataSource = tAIKHOANs;
bsiRecordsCount.Caption = "Số tài khoản :" + dgvAccount.Rows.Count;
}
private void loadRoom()
{
connectDBEntity mod1 = new connectDBEntity();
List <PHONGTRO> pHONGTROs = mod1.PHONGTRO.Where(a => a.MaTrangThai != 3 && a.MaTrangThai != 4).ToList();
cboRoomName.DataSource = pHONGTROs;
cboRoomName.DisplayMember = "TenPhong";
cboRoomName.ValueMember = "MaPhong";
}
private void loadRoom()
{
connectDBEntity mod1 = new connectDBEntity();
var Tenancy = mod.HOPDONG.FirstOrDefault(a => a.MaHopDong == ID);
List <PHONGTRO> pHONGTROs = mod1.PHONGTRO.Where(a => a.MaTrangThai != 4 || a.MaPhong == Tenancy.MaPhong).ToList();
cboRoomName.DataSource = pHONGTROs;
cboRoomName.DisplayMember = "TenPhong";
cboRoomName.ValueMember = "MaPhong";
}
private void loadService()
{
connectDBEntity mod1 = new connectDBEntity();
List <DICHVU> dICHVUs = mod1.DICHVU.ToList();
cboService.DataSource = dICHVUs;
cboService.ValueMember = "MaDichVu";
cboService.DisplayMember = "TenDichVu";
DICHVUs = dICHVUs;
}
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
connectDBEntity mod1 = new connectDBEntity();
frmForgot frmForgot = new frmForgot();
frmForgot.ShowDialog();
if (frmForgot.IsDisposed == false)
{
tAIKHOANs = mod1.TAIKHOAN.ToList();
}
}
private void loadService(int id)
{
if (id != 6 && id != 7)
{
connectDBEntity mod = new connectDBEntity();
var Service = mod.DICHVU.FirstOrDefault(a => a.MaDichVu == id);
ListViewItem item = lsvService.Items.Add(Service.TenDichVu);
item.SubItems.Add(Service.DonGia.ToString());
item.SubItems.Add(Service.DonViTinh);
}
}
private void loadRoom()
{
connectDBEntity mod = new connectDBEntity();
var pHONGTROs = mod.PHONGTRO.Select(a => new { a.MaPhong, a.TenPhong }).ToList();
foreach (var item in pHONGTROs)
{
Comboboxitem it = new Comboboxitem();
it.Text = item.TenPhong;
it.Value = item.MaPhong;
cboRoom.Items.Add(it);
}
}
private void updateTenancy()
{
string listIDservice = getIDservice();
connectDBEntity mod1 = new connectDBEntity();
var Tenancy = mod1.HOPDONG.FirstOrDefault(a => a.MaHopDong == txtTenacyID.Text);
Tenancy.MaHopDong = txtTenacyID.Text;
Tenancy.MaPhong = cboRoomName.SelectedValue.ToString();
Tenancy.MaNhanVien = txtIDofStaff.Text;
Tenancy.MaDichVu = listIDservice;
Tenancy.MaKhachHang = txtIDofCus.Text;
mod1.SaveChanges();
}
private void btnSave_Click(object sender, EventArgs e)
{
connectDBEntity mod = new connectDBEntity();
TAIKHOAN tAIKHOAN = new TAIKHOAN
{
TenTaiKhoan = txtUsername.Text,
MatKhau = txtnewPass.Text,
Email = txtMail.Text
};
mod.TAIKHOAN.Add(tAIKHOAN);
mod.SaveChanges();
Close();
}
private string getRoomname()
{
string Result = "";
connectDBEntity mod = new connectDBEntity();
List <PHONGTRO> pHONGTROs = mod.PHONGTRO.ToList();
foreach (var item in pHONGTROs)
{
if (cboRoomName.SelectedValue.ToString() == item.MaPhong)
{
Result = item.TenPhong;
}
}
return(Result.ToString());
}
private void bbiDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (txtUsername.Text != "")
{
if (MessageBox.Show("Bạn muốn xoá tài khoản này ?", "Cảnh Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
connectDBEntity mod = new connectDBEntity();
var Acc = mod.TAIKHOAN.FirstOrDefault(p => p.TenTaiKhoan == txtUsername.Text);
mod.TAIKHOAN.Remove(Acc);
mod.SaveChanges();
dgvAccount.DataSource = null;
load();
}
}
}
private void EditEW()
{
connectDBEntity mod = new connectDBEntity();
var dIENNUOC = mod.DIENNUOC.FirstOrDefault(a => a.MaDienNuoc == ID);
dIENNUOC.MaDienNuoc = ID;
dIENNUOC.MaPhong = (cboRoom.SelectedItem as Comboboxitem).Value.ToString();
dIENNUOC.ThoiGian = dtpDate.Value;
dIENNUOC.SoDienCu = int.Parse(txtENumberO.Text);
dIENNUOC.SoDienMoi = int.Parse(txtEnumberN.Text);
dIENNUOC.SoNuocCu = int.Parse(txtWNumberN.Text);
dIENNUOC.SoNuocMoi = int.Parse(txtWNumberN.Text);
dIENNUOC.TienDienNuoc = double.Parse(txtSum.Text);
mod.SaveChanges();
}
private void load()
{
connectDBEntity mod = new connectDBEntity();
var dIENNUOC = mod.DIENNUOC.FirstOrDefault(a => a.MaDienNuoc == ID);
txtEWID.Text = ID;
idRoom = dIENNUOC.MaPhong.ToString();
dtpDate.Enabled = false;
dtpDate.Value = dIENNUOC.ThoiGian.Value;
txtENumberO.Text = dIENNUOC.SoDienCu.Value.ToString();
txtEnumberN.Text = dIENNUOC.SoDienMoi.Value.ToString();
txtWNumberO.Text = dIENNUOC.SoNuocCu.Value.ToString();
txtWNumberN.Text = dIENNUOC.SoNuocMoi.Value.ToString();
MessageBox.Show(dIENNUOC.MaPhong.ToString());
}
//private string getID()
//{
// string result = "";
// List<HOPDONG> ps = mod.HOPDONG.ToList();
// if (ps.Any() == false)
// {
// result = "HD00000001";
// }
// else
// {
// var R = ps.Last();
// int i = R.MaHopDong.IndexOf("0");
// string first = "HD";
// int last = int.Parse(R.MaHopDong.Substring(i + 1)) + 1;
// result = first + last.ToString().PadLeft(8, '0');
// }
// return result;
//}
private void updateRoom()
{
connectDBEntity mod1 = new connectDBEntity();
DateTime now = DateTime.Now;
PHONGTRO pHONGTRO = mod1.PHONGTRO.FirstOrDefault(p => p.MaPhong == cboRoomName.SelectedValue.ToString());
if (dtpStart.Value <= now)
{
pHONGTRO.MaTrangThai = 3;
}
else
{
pHONGTRO.MaTrangThai = 2;
}
mod1.SaveChanges();
}
private void AddTenancy()
{
string listIDservice = getIDservice();
connectDBEntity mod1 = new connectDBEntity();
var Tenancy = new HOPDONG
{
MaHopDong = txtTenacyID.Text,
MaPhong = cboRoomName.SelectedValue.ToString(),
MaNhanVien = txtIDofStaff.Text,
MaDichVu = listIDservice,
MaKhachHang = txtIDofCus.Text
};
mod1.HOPDONG.Add(Tenancy);
mod1.SaveChanges();
}
private void load()
{
lsvService.Items.Clear();
connectDBEntity mod1 = new connectDBEntity();
List <HOPDONG> hOPDONGs = mod1.HOPDONG.ToList();
foreach (var item in hOPDONGs)
{
int index = dgvTenacylist.Rows.Add();
dgvTenacylist.Rows[index].Cells[0].Value = item.MaHopDong;
dgvTenacylist.Rows[index].Cells[1].Value = item.MaPhong;
dgvTenacylist.Rows[index].Cells[3].Value = item.MaNhanVien;
dgvTenacylist.Rows[index].Cells[2].Value = item.MaKhachHang;
}
bsiRecordsCount.Caption = "Số Hợp Đồng:" + dgvTenacylist.Rows.Count;
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
dgvTenacylist.Rows.Clear();
connectDBEntity mod1 = new connectDBEntity();
List <HOPDONG> hOPDONGs = mod1.HOPDONG.Where(a => a.MaHopDong == txtSearch.Text).ToList();
foreach (var item in hOPDONGs)
{
int index = dgvTenacylist.Rows.Add();
dgvTenacylist.Rows[index].Cells[0].Value = item.MaHopDong;
dgvTenacylist.Rows[index].Cells[1].Value = item.MaPhong;
dgvTenacylist.Rows[index].Cells[2].Value = item.MaNhanVien;
dgvTenacylist.Rows[index].Cells[3].Value = item.MaKhachHang;
}
bsiRecordsCount.Caption = "Số Hợp Đồng:" + dgvTenacylist.Rows.Count;
}
private void Load()
{
connectDBEntity mod = new connectDBEntity();
var Tenancy = mod.HOPDONG.FirstOrDefault(a => a.MaHopDong == ID);
var Tenancyinfo = mod.CHITIETHOPDONG.FirstOrDefault(a => a.MaHopDong == ID);
var Staff = mod.NHANVIEN.FirstOrDefault(a => a.MaNhanVien == Tenancy.MaNhanVien);
var Customer = mod.KHACHHANG.FirstOrDefault(a => a.MaKhachHang == Tenancy.MaKhachHang);
List <DICHVU> service = mod.DICHVU.ToList();
dateDay.Text = Tenancyinfo.NgayLapHopDong.ToString().Substring(0, 2);
dateMonth.Text = Tenancyinfo.NgayLapHopDong.ToString().Substring(3, 2);
dateYear.Text = Tenancyinfo.NgayLapHopDong.ToString().Substring(6, 4);
staffName.Text = Staff.HoNhanVien + " " + Staff.TenNhanVien;
staffBirth.Text = Staff.NgaySinh.ToString().Substring(0, 9);
staffID.Text = Staff.CMND.ToString();
staffNumber.Text = Staff.SoDienThoai.ToString();
staffAddress.Text = Staff.DiaChi.ToString();
customerName.Text = Customer.HoKhachHang + " " + Customer.TenKhachHang;
customerBirth.Text = Customer.NgaySinh.ToString().Substring(0, 9);
customerId.Text = Customer.CMND.ToString();
customerNumber.Text = Customer.SoDienThoai.ToString();
customerAddress.Text = Customer.DiaChi.ToString();
roomName.Text = Tenancyinfo.TenPhong.ToString();
foreach (var item in service)
{
if (item.TenDichVu == "Tiền Phòng")
{
roomPrice.Text = item.DonGia.ToString();
}
if (item.TenDichVu == "Điện")
{
serviceElectric.Text = item.DonGia.ToString();
}
if (item.TenDichVu == "Nước")
{
serviceWater.Text = item.DonGia.ToString();
}
}
roomDeposit.Text = Tenancyinfo.TienDatCoc.ToString();
dateDayStart.Text = Tenancyinfo.NgayBatDau.ToString().Substring(0, 2);
dateMonthStart.Text = Tenancyinfo.NgayBatDau.ToString().Substring(3, 2);
dateYearStart.Text = Tenancyinfo.NgayBatDau.ToString().Substring(6, 4);
dateDayEnd.Text = Tenancyinfo.NgayKetThuc.ToString().Substring(0, 2);
dateMonthEnd.Text = Tenancyinfo.NgayKetThuc.ToString().Substring(3, 2);
dateYearEnd.Text = Tenancyinfo.NgayKetThuc.ToString().Substring(6, 4);
}
private void load()
{
connectDBEntity mod = new connectDBEntity();
string roomID = (cboRoom.SelectedItem as Comboboxitem).Value.ToString();
var dIENNUOCs = mod.DIENNUOC.OrderByDescending(a => a.SoDienMoi).FirstOrDefault(a => a.MaPhong.Equals(roomID));
if (dIENNUOCs != null)
{
txtENumberO.Text = dIENNUOCs.SoDienMoi.ToString();
txtWNumberO.Text = dIENNUOCs.SoNuocMoi.ToString();
}
else
{
txtWNumberO.Text = "0";
txtENumberO.Text = "0";
}
}
private void AddEW()
{
connectDBEntity mod = new connectDBEntity();
var ElectricWater = new DIENNUOC
{
MaDienNuoc = getID(),
MaPhong = (cboRoom.SelectedItem as Comboboxitem).Value.ToString(),
ThoiGian = DateTime.Now,
SoDienCu = int.Parse(txtENumberO.Text),
SoDienMoi = int.Parse(txtEnumberN.Text),
SoNuocMoi = int.Parse(txtWNumberN.Text),
SoNuocCu = int.Parse(txtWNumberO.Text),
TienDienNuoc = double.Parse(txtSum.Text)
};
mod.DIENNUOC.Add(ElectricWater);
mod.SaveChanges();
}
private void load()
{
dgvStaffinfo.Rows.Clear();
connectDBEntity mod1 = new connectDBEntity();
List <NHANVIEN> nHANVIENs = mod1.NHANVIEN.ToList();
foreach (var item in nHANVIENs)
{
int index = dgvStaffinfo.Rows.Add();
dgvStaffinfo.Rows[index].Cells[0].Value = item.MaNhanVien;
dgvStaffinfo.Rows[index].Cells[1].Value = item.HoNhanVien;
dgvStaffinfo.Rows[index].Cells[2].Value = item.TenNhanVien;
dgvStaffinfo.Rows[index].Cells[3].Value = item.NgaySinh;
dgvStaffinfo.Rows[index].Cells[4].Value = item.GioiTinh;
dgvStaffinfo.Rows[index].Cells[5].Value = item.CMND;
dgvStaffinfo.Rows[index].Cells[6].Value = item.SoDienThoai;
dgvStaffinfo.Rows[index].Cells[7].Value = item.ThuDienTu;
dgvStaffinfo.Rows[index].Cells[8].Value = item.DiaChi;
}
bsiRecordsCount.Caption = "Số Nhân Viên: " + dgvStaffinfo.Rows.Count;
}
private void addTenancyinfo()
{
try
{
connectDBEntity mod1 = new connectDBEntity();
double deposit = double.Parse(txtDeposits.Text);
var Tenancyinfo = new CHITIETHOPDONG
{
MaHopDong = txtTenacyID.Text,
NgayLapHopDong = dtpDate.Value,
TenPhong = getRoomname(),
TenDichVu = getSer(lsvService, 1),
GiaDichVu = getSer(lsvService, 2),
DonViTinh = getSer(lsvService, 3),
TienDatCoc = deposit,
NgayBatDau = dtpStart.Value,
NgayKetThuc = dtpEnd.Value
};
mod1.CHITIETHOPDONG.Add(Tenancyinfo);
mod1.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
private void load()
{
dgvCustomerinfo.Rows.Clear();
connectDBEntity mod1 = new connectDBEntity();
List <KHACHHANG> kHACHHANGs = mod1.KHACHHANG.ToList();
foreach (var item in kHACHHANGs)
{
int index = dgvCustomerinfo.Rows.Add();
dgvCustomerinfo.Rows[index].Cells[0].Value = item.MaKhachHang;
dgvCustomerinfo.Rows[index].Cells[1].Value = item.HoKhachHang;
dgvCustomerinfo.Rows[index].Cells[2].Value = item.TenKhachHang;
dgvCustomerinfo.Rows[index].Cells[3].Value = item.NgaySinh;
dgvCustomerinfo.Rows[index].Cells[4].Value = item.GioiTinh;
dgvCustomerinfo.Rows[index].Cells[5].Value = item.CMND;
dgvCustomerinfo.Rows[index].Cells[6].Value = item.SoDienThoai;
dgvCustomerinfo.Rows[index].Cells[7].Value = item.ThuDienTu;
dgvCustomerinfo.Rows[index].Cells[8].Value = item.DiaChi;
dgvCustomerinfo.Rows[index].Cells[9].Value = item.MaPhong;
}
bsiRecordsCount.Caption = "Số Khách Hàng: " + dgvCustomerinfo.Rows.Count;
}
private void LoadRoom()
{
connectDBEntity mod1 = new connectDBEntity();
List <PHONGTRO> pHONGTROs = mod1.PHONGTRO.ToList();
foreach (var it in pHONGTROs)
{
ListViewItem item = new ListViewItem(it.TenPhong.ToString());
ListViewItem.ListViewSubItem subItem = new ListViewItem.ListViewSubItem(item, it.MaPhong.ToString());
int status = int.Parse(it.MaTrangThai.ToString());
switch (status)
{
case 1:
item.ImageIndex = 0;
break;
case 2:
item.ImageIndex = 1;
break;
case 3:
item.ImageIndex = 2;
break;
case 4:
item.ImageIndex = 3;
break;
default:
item.ImageIndex = 0;
break;
}
bsiRecordsCount.Caption = "Tổng Số Phòng: " + pHONGTROs.Count;
item.SubItems.Add(subItem);
lsvRoom.Items.Add(item);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
string idInvoice = getID();
connectDBEntity mod = new connectDBEntity();
string id = (cboRoom.SelectedItem as Comboboxitem).Value.ToString();
var Tenancy = mod.HOPDONG.Select(a => new { a.MaHopDong, a.MaKhachHang, a.MaPhong }).FirstOrDefault(a => a.MaPhong == id);
if (lsvService.Items.Count > 0)
{
if (MessageBox.Show("Bạn muốn lưu hoá đơn này ?", "Cảnh Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int index = dgvEW.CurrentRow.Index;
connectDBEntity HD = new connectDBEntity();
HOADON hOADON = new HOADON
{
MaHoaDon = idInvoice,
MaNhanVien = cboStaff.SelectedValue.ToString(),
MaPhong = (cboRoom.SelectedItem as Comboboxitem).Value.ToString(),
MaDienNuoc = dgvEW.Rows[index].Cells[0].Value.ToString()
};
HD.HOADON.Add(hOADON);
HD.SaveChanges();
CHITIETHOADON cHITIETHOADON = new CHITIETHOADON
{
MaHoaDon = idInvoice,
MaKhachHang = Tenancy.MaKhachHang,
NgayLap = DateTime.Now,
TongCong = float.Parse(txtTotal.Text),
TrangThai = false,
};
HD.CHITIETHOADON.Add(cHITIETHOADON);
HD.SaveChanges();
MessageBox.Show("Lưu thành công!");
Close();
}
}
}
private void lsvRoom_Click(object sender, EventArgs e)
{
bbiDelete.Enabled = true;
connectDBEntity mod2 = new connectDBEntity();
pHONGTROs = mod2.PHONGTRO.ToList();
List <TRANGTHAIPHONG> tRANGTHAIPHONGs = mod.TRANGTHAIPHONG.ToList();
if (lsvRoom.SelectedItems.Count > 0)
{
string st = lsvRoom.SelectedItems[0].SubItems[1].Text;
foreach (var it in pHONGTROs)
{
if (st == it.MaPhong.ToString())
{
txtRoomID.Text = it.MaPhong.ToString();
txtStatusid.Text = it.MaTrangThai.ToString();
if (txtStatusid.Text == "2" || txtStatusid.Text == "3")
{
bbiDelete.Enabled = false;
}
foreach (var tt in tRANGTHAIPHONGs)
{
if (it.MaTrangThai == tt.MaTrangThai)
{
txtStatus.Text = tt.TenTrangThai.ToString();
}
}
txtRoomName.Text = it.TenPhong.ToString();
txtDescription.Text = it.MoTa;
txtAcreage.Text = it.DienTich.ToString();
txtCapacity.Text = it.SoNguoiO.ToString();
}
}
}
}
