private void _setNhaTaiTro(QL_HOATDONG_HNXH item) { var queryNhaTaiTro = item.QL_HOATDONG_NHATAITRO.ToList(); listNhaTaiTro = new BindingList <QL_HOATDONG_NHATAITRO>(queryNhaTaiTro); memoDonViTaiTro.Text = _getNhaTaiTro(listNhaTaiTro); }
private void _updateDoiTuongKhac(QL_HOIVIEN_KTEntities _context, QL_HOATDONG_HNXH item) { QL_HOATDONG_HNXH_DOITUONG_KHAC item_chitiet; foreach (var person in listDoiTuongKhongKhuyetTat) { if (person.PARENT_ID == null) //add { person.QL_HOATDONG_HNXH = item; _context.QL_HOATDONG_HNXH_DOITUONG_KHAC.Add(person); } else if (person.PARENT_ID == clsParameter.statusDeleted) //delete { item_chitiet = (from p in _context.QL_HOATDONG_HNXH_DOITUONG_KHAC where p.DTK_ID == person.DTK_ID select p).FirstOrDefault(); if (item_chitiet != null) { _context.QL_HOATDONG_HNXH_DOITUONG_KHAC.Remove(item_chitiet); } } else //modify { var chitiet = _context.QL_HOATDONG_HNXH_DOITUONG_KHAC.Where(p => p.DTK_ID == person.DTK_ID).FirstOrDefault(); if (chitiet != null) { _context.Entry(chitiet).CurrentValues.SetValues(person); } } } }
private void _updateNhaTaiTro(QL_HOIVIEN_KTEntities _context, QL_HOATDONG_HNXH item) { QL_HOATDONG_NHATAITRO item_chitiet; foreach (var person in listNhaTaiTro) { if (person.HNXH_ID == null) //add { person.QL_HOATDONG_HNXH = item; _context.QL_HOATDONG_NHATAITRO.Add(person); } else if (person.HNXH_ID == clsParameter.statusDeleted) //delete { item_chitiet = (from p in _context.QL_HOATDONG_NHATAITRO where p.NTT_ID == person.NTT_ID select p).FirstOrDefault(); if (item_chitiet != null) { _context.QL_HOATDONG_NHATAITRO.Remove(item_chitiet); } } else //modify { var chitiet = _context.QL_HOATDONG_NHATAITRO.Where(p => p.NTT_ID == person.NTT_ID).FirstOrDefault(); if (chitiet != null) { _context.Entry(chitiet).CurrentValues.SetValues(person); } } } }
private void _bindingData() { _clearData(); QL_HOATDONG_HNXH item = gvGrid.GetFocusedRow() as QL_HOATDONG_HNXH; if (item != null) { _idRowSelected = item.HNXH_ID; deTuNgay.EditValue = item.HNXH_THOIGIAN_BATDAU; deDenNgay.EditValue = item.HNXH_THOIGIAN_KETTHUC; seTongSoNgay.EditValue = item.HNXH_TONGSO_NGAY; txtTenChuongTrinh.EditValue = item.HNXH_TEN; txtDiaDiem.EditValue = item.HNXH_DIADIEM; memoDonViTaiTro.EditValue = item.HNXH_DONVI_THUCHIEN; memoDoiTuong.EditValue = item.HNXH_DOITUONG_TEN; memoDoiTuongId.EditValue = item.HNXH_DOITUONG_ID; _setMemoData(item); seSoLuongNguoiThamGia.EditValue = item.HNXH_SOLUONG; seTongSoTien.EditValue = item.HNXH_TONGSO_TIEN; txtNoiDung.EditValue = item.HNXH_NOIDUNG; } }
private void _setDoiTuongKhac(QL_HOATDONG_HNXH item) { var query = item.QL_HOATDONG_HNXH_DOITUONG_KHAC.ToList(); listDoiTuongKhongKhuyetTat = new BindingList <QL_HOATDONG_HNXH_DOITUONG_KHAC>(query); memoDoiTuongKhac.Text = _getDoiTuongKhac(listDoiTuongKhongKhuyetTat); }
protected override bool SaveData() { if (_validateControl()) { using (var _context = new QL_HOIVIEN_KTEntities()) { QL_HOATDONG_HNXH item = new QL_HOATDONG_HNXH(); switch (_formStatus) { case EnumFormStatus.ADD: #region Add item = new QL_HOATDONG_HNXH(); _setObjectEntities(ref item); _updateMemoData(_context, item); _context.QL_HOATDONG_HNXH.Add(item); #endregion break; case EnumFormStatus.MODIFY: Int64 id = Convert.ToInt64(gvGrid.GetFocusedRowCellValue(colID)); item = (from p in _context.QL_HOATDONG_HNXH where p.HNXH_ID == id select p).FirstOrDefault <QL_HOATDONG_HNXH>(); if (item != null) { _setObjectEntities(ref item); } var entity = _context.QL_HOATDONG_HNXH.Find(id); if (entity != null) { _context.Entry(entity).CurrentValues.SetValues(item); } _updateMemoData(_context, item); break; default: break; } _context.SaveChanges(); _idRowSelected = item.HNXH_ID; } FormStatus = EnumFormStatus.VIEW; } return(base.SaveData()); }
private void _setObjectEntities(ref QL_HOATDONG_HNXH item) { item.HNXH_LOAI_ID = _id_loai; item.HNXH_THOIGIAN_BATDAU = deTuNgay.Ex_EditValueToDateTime(); item.HNXH_THOIGIAN_KETTHUC = deDenNgay.Ex_EditValueToDateTime(); item.HNXH_TONGSO_NGAY = seTongSoNgay.Ex_EditValueToInt(); item.HNXH_TONGSO_TIEN = seTongSoTien.Ex_EditValueToInt(); item.HNXH_TEN = txtTenChuongTrinh.Text; item.HNXH_DIADIEM = txtDiaDiem.Text; item.HNXH_DONVI_THUCHIEN = memoDonViTaiTro.Text; item.HNXH_SOLUONG = seSoLuongNguoiThamGia.Ex_EditValueToInt(); item.HNXH_DOITUONG_TEN = memoDoiTuong.Text; item.HNXH_DOITUONG_ID = memoDoiTuongId.Text; item.HNXH_DOITUONG_KHAC = memoDoiTuongKhac.Text; item.HNXH_NOIDUNG = txtNoiDung.Text; }
private void _deleteRow() { QL_HOATDONG_HNXH item = gvGrid.GetFocusedRow() as QL_HOATDONG_HNXH; if (item != null) { if (clsMessage.MessageYesNo(string.Format("Bạn có chắc muốn xóa: {0}", item.HNXH_TEN)) == DialogResult.Yes) { Int64 id = Convert.ToInt64(gvGrid.GetFocusedRowCellValue(colID)); _deleteMemoData(context, id); QL_HOATDONG_HNXH entities = (from p in context.QL_HOATDONG_HNXH where p.HNXH_ID == id select p).FirstOrDefault(); context.QL_HOATDONG_HNXH.Remove(entities); context.SaveChanges(); FormStatus = EnumFormStatus.VIEW; } } }
private void _setMemoData(QL_HOATDONG_HNXH item) { _setNhaTaiTro(item); _setDoiTuongKhac(item); }
private void _updateMemoData(QL_HOIVIEN_KTEntities _context, QL_HOATDONG_HNXH item) { _updateNhaTaiTro(_context, item); _updateDoiTuongKhac(_context, item); }