private void attach_tblChiTietPhieus(tblChiTietPhieu entity) { this.SendPropertyChanging(); entity.tblDichVu = this; }
private void detach_tblChiTietPhieus(tblChiTietPhieu entity) { this.SendPropertyChanging(); entity.tblDoDung = null; }
partial void DeletetblChiTietPhieu(tblChiTietPhieu instance);
partial void UpdatetblChiTietPhieu(tblChiTietPhieu instance);
partial void InserttblChiTietPhieu(tblChiTietPhieu instance);
private void btnLuu2_Click(object sender, EventArgs e) { KhachHangDAO dao_kh = new KhachHangDAO(); ChiTietPhieuDAO dao_ctp = new ChiTietPhieuDAO(); PhieuThueDAO dao_pt = new PhieuThueDAO(); if (luu == choice_them) { DataGridViewRow dr = dgvDoDung.SelectedRows[0]; int id = int.Parse(dr.Cells["IDPhong"].Value.ToString()); // lay duoc idphong, lay soluong va sua vao phong DataGridViewRow dr2 = dgvKhachHang.SelectedRows[0]; int id2 = int.Parse(dr2.Cells["IDKhach"].Value.ToString()); /*********************(that bai) * // tim ra duoc chitietphieu ung voi phong co ID, sua so luong * var y = (from a in db.tblKhaches * join b in db.tblPhieuThues on a.IDKhach equals b.IDKhach * join c in db.tblChiTietPhieux on b.IDPhieuThue equals c.IDPhieuThue * where c.IDPhong == id && a.IDKhach == id2 * select new * { * IDPhieuThue = c.IDPhieuThue, * IDPhong = c.IDPhong, * IDDichVu = c.IDDichVu, * IDDoDung = c.IDDoDung, * SoLuong = c.SoLuong, * ThanhTien = c.ThanhTien, * IDChiTietPhieu = c.IDChiTietPhieu * }).AsEnumerable().Select(x => new tblChiTietPhieu * { * IDPhieuThue = x.IDPhieuThue, * IDPhong = x.IDPhong, * IDDichVu = x.IDDichVu, * IDDoDung = x.IDDoDung, * SoLuong = x.SoLuong, * ThanhTien = x.ThanhTien, * IDChiTietPhieu = x.IDChiTietPhieu * }); * * // x.toList() co the gan vao datasource * // sua so luong * * foreach ( tblChiTietPhieu ctp in y) * { * ctp.SoLuong = int.Parse(txtSoLuongDoDung.Text); * //co ten do dung, bh lay id do dung * var dodung = from a in db.tblDoDungs where a.TenDoDung == cbDoDung.Text select a; * * foreach ( var i in dodung) * { * ctp.IDDoDung = i.IDDoDung; * } * * dao_ctp.Edit(ctp, id); * } * //db.SaveChanges(); * //them mot ban ghi chitietphieuthue moi; **************************************/ // sinh ra chitietphieu, giu nguyen idphieu, var phieu = from u in db.tblPhieuThues join u1 in db.tblKhaches on u.IDKhach equals u1.IDKhach where u1.IDKhach == id2 select new { u.IDPhieuThue }; foreach (var y in phieu) { tblChiTietPhieu ctp = new tblChiTietPhieu(); if (db.tblChiTietPhieux.Count() == db.tblChiTietPhieux.Max(x => x.IDChiTietPhieu)) { var temp = db.tblChiTietPhieux.Max(x => x.IDChiTietPhieu) + 1; ctp.IDChiTietPhieu = temp; } if (db.tblChiTietPhieux.Count() != db.tblChiTietPhieux.Max(x => x.IDChiTietPhieu)) { while (true) { if (db.tblChiTietPhieux.Min(x => x.IDChiTietPhieu) > 1) { var temp1 = db.tblChiTietPhieux.Min(x => x.IDChiTietPhieu) - 1; ctp.IDChiTietPhieu = temp1; break; } for (int i = db.tblChiTietPhieux.Min(x => x.IDChiTietPhieu); i <= db.tblChiTietPhieux.Max(x => x.IDChiTietPhieu); i++) { if (db.tblChiTietPhieux.SingleOrDefault(x => x.IDChiTietPhieu == i) != null) { continue; } if (db.tblChiTietPhieux.SingleOrDefault(x => x.IDChiTietPhieu == i) == null) { ctp.IDChiTietPhieu = i; break; } } } break; } ctp.IDPhieuThue = y.IDPhieuThue; ctp.SoLuong = int.Parse(txtSoLuongDoDung.Text); var dodung = from a in db.tblDoDungs where a.TenDoDung == cbDoDung.Text select a; foreach (var i in dodung) { ctp.IDDoDung = i.IDDoDung; } var dichvu = from a in db.tblDichVus where a.TenDichVu == cbDichVu.Text select a; foreach (var i in dichvu) { ctp.IDDichVu = i.IDDichVu; } ctp.IDPhong = id; ctp.ThanhTien = ctp.SoLuong * int.Parse(txtGiaDoDung.Text) + int.Parse(txtGiaDichVu.Text); dao_ctp.Insert(ctp); luu = 0; LoadBangDichVu(); LoadBangDoDung(); } } if (luu == choice_sua) { } if (luu == choice_xoa) { if (DialogResult.Yes == MessageBox.Show("Bạn chắc không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { DataGridViewRow dr = dgvDoDung.SelectedRows[0]; int id = int.Parse(dr.Cells["IDChiTietPhieu"].Value.ToString()); var k = db.tblChiTietPhieux.Where(x => x.IDChiTietPhieu == id).First(); // so luong bao nhieu thanh tien tru di bay nhieu db.tblChiTietPhieux.Remove(k); // k.ThanhTien -= k.SoLuong * int.Parse(dr.Cells["DonGia"].Value.ToString()); // k.IDDoDung = 0; //k.SoLuong = 0; db.SaveChanges(); } luu = 0; LoadBangDichVu(); LoadBangDoDung(); MoKhoaAll(); } }
/* * private void lvPhong_MouseClick(object sender, MouseEventArgs e) * { * foreach (ListViewItem item in lvPhong.Items) * { * if(item.Checked== true) * { * int a = int.Parse(item.SubItems[1].Text); * txtTen.Text = a.ToString(); * } * } * } */ private void btnLuu_Click(object sender, EventArgs e) { /*foreach (ListViewItem item in lvPhong.Items) * { * if(item.Checked== true) * { * int a = int.Parse(item.SubItems[1].Text); * txtTen.Text = a.ToString(); * } * }*/ KhachHangDAO dao_kh = new KhachHangDAO(); ChiTietPhieuDAO dao_ctp = new ChiTietPhieuDAO(); PhieuThueDAO dao_pt = new PhieuThueDAO(); if (luu == choice_them) { // them khach hang tblKhach k = new tblKhach(); k.TenKhach = txtTen.Text; k.SDT = txtSDT.Text; k.DiaChi = txtDiaChi.Text; k.SoNguoi = int.Parse(txtSoLuongNguoi.Text); if (db.tblKhaches.Count() == db.tblKhaches.Max(x => x.IDKhach)) { var temp = db.tblKhaches.Max(x => x.IDKhach) + 1; k.IDKhach = temp; } if (db.tblKhaches.Count() != db.tblKhaches.Max(x => x.IDKhach)) { while (true) { if (db.tblKhaches.Min(x => x.IDKhach) > 1) { var temp1 = db.tblKhaches.Min(x => x.IDKhach) - 1; k.IDKhach = temp1; break; } for (int i = db.tblKhaches.Min(x => x.IDKhach); i <= db.tblKhaches.Max(x => x.IDKhach); i++) { if (db.tblKhaches.SingleOrDefault(x => x.IDKhach == i) != null) { continue; } if (db.tblKhaches.SingleOrDefault(x => x.IDKhach == i) == null) { k.IDKhach = i; break; } } break; } } dao_kh.Insert(k); // them vao trong phieuthue tblPhieuThue pt = new tblPhieuThue(); pt.IDKhach = k.IDKhach; pt.ThoiGianThue = DateTime.Now; pt.ThoiGianTra = DateTime.Now; pt.TongTien = 0; /*for( int i=1; i<db.tblPhieuThues.Max(x=>x.IDPhieuThue);i++) * { * if( db.tblPhieuThues.SingleOrDefault(x=>x.IDPhieuThue==i)==null) * { * pt.IDPhieuThue = i; * } * }*/ if (db.tblPhieuThues.Count() == db.tblPhieuThues.Max(x => x.IDPhieuThue)) { var temp = db.tblPhieuThues.Max(x => x.IDPhieuThue) + 1; pt.IDPhieuThue = temp; } if (db.tblPhieuThues.Count() != db.tblPhieuThues.Max(x => x.IDPhieuThue)) { while (true) { if (db.tblPhieuThues.Min(x => x.IDPhieuThue) > 1) { var temp1 = db.tblPhieuThues.Min(x => x.IDPhieuThue) - 1; pt.IDPhieuThue = temp1; break; } for (int i = db.tblPhieuThues.Min(x => x.IDPhieuThue); i <= db.tblPhieuThues.Max(x => x.IDPhieuThue); i++) { if (db.tblPhieuThues.SingleOrDefault(x => x.IDPhieuThue == i) != null) { continue; } if (db.tblPhieuThues.SingleOrDefault(x => x.IDPhieuThue == i) == null) { pt.IDPhieuThue = i; break; } } break; } } // dao_pt.Insert(pt); // them phong voi id khach da cho va them vao o tong tien // them vao chitietphieuthue foreach (ListViewItem item in lvPhong.Items) { if (item.Checked == true) { int i_room = int.Parse(item.SubItems[1].Text); tblChiTietPhieu ctp = new tblChiTietPhieu(); ctp.IDPhong = i_room; ctp.IDDichVu = 0; ctp.IDDoDung = 0; ctp.SoLuong = 0; ctp.ThanhTien = 0; ctp.IDPhieuThue = pt.IDPhieuThue; if (db.tblChiTietPhieux.Count() == db.tblChiTietPhieux.Max(x => x.IDChiTietPhieu)) { var temp = db.tblChiTietPhieux.Max(x => x.IDChiTietPhieu) + 1; ctp.IDChiTietPhieu = temp; } if (db.tblChiTietPhieux.Count() != db.tblChiTietPhieux.Max(x => x.IDChiTietPhieu)) { while (true) { if (db.tblChiTietPhieux.Min(x => x.IDChiTietPhieu) > 1) { var temp1 = db.tblChiTietPhieux.Min(x => x.IDChiTietPhieu) - 1; ctp.IDChiTietPhieu = temp1; break; } for (int i = db.tblChiTietPhieux.Min(x => x.IDChiTietPhieu); i <= db.tblChiTietPhieux.Max(x => x.IDChiTietPhieu); i++) { if (db.tblChiTietPhieux.SingleOrDefault(x => x.IDChiTietPhieu == i) != null) { continue; } if (db.tblChiTietPhieux.SingleOrDefault(x => x.IDChiTietPhieu == i) == null) { ctp.IDChiTietPhieu = i; break; } } } break; } dao_ctp.Insert(ctp); } } //luu xong luu = 0; MoKhoaAll(); KhoiTaoDataGridView(); ResetAll(); } if (luu == choice_sua) { // sua trong bang khachhang // sua trong bang co idphong, tuc la bang chitietphieuthue( ma muon co bang chi tiet phieu thue de sua thi lai // phai lay duoc idphieuthue co ma khach hang DataGridViewRow dr = dgvKhachHang.SelectedRows[0]; int id = int.Parse(dr.Cells["IDKhach"].Value.ToString()); tblKhach k = new tblKhach(); k.IDKhach = id; k.SDT = txtSDT.Text; k.SoNguoi = int.Parse(txtSoLuongNguoi.Text); k.TenKhach = txtTen.Text; k.DiaChi = txtDiaChi.Text; dao_kh.Edit(k); MessageBox.Show("Bạn sửa thành công!"); /* * // lay idphieu thue co makhach hang * var phieu = from u in db.tblPhieuThues * join u1 in db.tblKhaches on u.IDKhach equals u1.IDKhach * where u1.IDKhach == id * select new * { * u.IDPhieuThue * }; * foreach( var u in phieu) * { * int a = u.IDPhieuThue; * // sua trong bang chitietphieuthue co IDPhieuThue, IDPhong= * } */ luu = 0; MoKhoaAll(); KhoiTaoDataGridView(); ResetAll(); } if (luu == choice_xoa) { // xoa thi phai xoa o trong khach, phieu, chitietphieu DataGridViewRow dr = dgvKhachHang.SelectedRows[0]; int id = int.Parse(dr.Cells["IDKhach"].Value.ToString()); if (DialogResult.Yes == MessageBox.Show("Bạn chắc không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { //xoa kh dao_kh.Delete(id); //xoa phieu var phieu = from u in db.tblPhieuThues join u1 in db.tblKhaches on u.IDKhach equals u1.IDKhach where u1.IDKhach == id select new { u.IDPhieuThue }; foreach (var u in phieu) { int a = u.IDPhieuThue; // sua trong bang chitietphieuthue co IDPhieuThue, IDPhong= dao_pt.Delete(a); // xoa trong chi tiet phieu dao_ctp.Delete(a); } } luu = 0; MoKhoaAll(); KhoiTaoDataGridView(); ResetAll(); } }