private void GetAllItem()
{
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var ListLinhVucBanHanh = quanLyCongViecEntities.GetAllLinhVucBanHanh().ToList();
var ListloaiVanBan = quanLyCongViecEntities.GetAllLoaiVanBan().ToList();
var ListDonViThamMuu = quanLyCongViecEntities.GetAllDonvi().ToList();
var ListLanhDaoPhuTrach = quanLyCongViecEntities.GetAllLanhDaoDonvi().ToList();
//search lĩnh vực
searchLinhVucBanHanh.Properties.DataSource = ListLinhVucBanHanh;
searchLinhVucBanHanh.Properties.DisplayMember = "NameLinhVuc";
searchLinhVucBanHanh.Properties.ValueMember = "Id";
// search đơn vị tham muu
searchDonViThamMuu.Properties.DataSource = ListDonViThamMuu;
searchDonViThamMuu.Properties.DisplayMember = "TenDonVi";
searchDonViThamMuu.Properties.ValueMember = "Id";
//search loại văn bản
searchLoaivanBan.Properties.DataSource = ListloaiVanBan;
searchLoaivanBan.Properties.DisplayMember = "NameVanBan";
searchLoaivanBan.Properties.ValueMember = "Id";
//search lãnh đạo phụ trách
searchLanhDaoPhuTrach.Properties.DataSource = ListLanhDaoPhuTrach;
searchLanhDaoPhuTrach.Properties.DisplayMember = "TenLanhDao";
searchLanhDaoPhuTrach.Properties.ValueMember = "Id";
}
}
catch (Exception)
{
throw;
}
}
private void AddLanhDaoDonVi()
{
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
if (radioActive.SelectedIndex == 0)
{
active = true;
}
if (radioActive.SelectedIndex == 1)
{
active = false;
}
if (edit == false)
{
guidId = Guid.NewGuid();
quanLyCongViecEntities.AddLanhDaoDonVi(guidId, txtTenLanhDao.Text, comboChucVu.Text, (Guid)searchDonVi.EditValue, DateTime.Now, active);
edit = false;
}
if (edit == true)
{
quanLyCongViecEntities.EditLanhDaoDonVi(guidId, txtTenLanhDao.Text, comboChucVu.Text, active);
edit = false;
}
}
}
catch (Exception)
{
XtraMessageBox.Show("Lỗi không kết nối được với cơ sở dữ liệu");
//throw;
}
}
private void AddCoQuanbanHanh()
{
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
if (radioInOrOut.SelectedIndex == 0)
{
active = true;
}
if (radioInOrOut.SelectedIndex == 1)
{
active = false;
}
if (edit == false)
{
Guid Id = Guid.NewGuid();
quanLyCongViecEntities.AddCoQuanBanHanhVanBan(Id, txtTenCoQuan.Text, txtSoHieu.Text, active, txt_PrintName.Text, DateTime.Now);
}
else
{
quanLyCongViecEntities.EditCoQuanBanHanhVanBan(guidEdit, txtTenCoQuan.Text, txtSoHieu.Text, active, txt_PrintName.Text);
}
}
}
catch (Exception)
{
//throw;
XtraMessageBox.Show("Lỗi kết nối với cơ sở dữ liệu");
}
}
private void GetOneGDKyBanHanh()
{
try
{
GetAllItem();
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var GetGDKyBanHanh = quanLyCongViecEntities.GetOneGDKyBanHanh(IdEdit).Single();
searchLinhVucBanHanh.EditValue = GetGDKyBanHanh.IdLinhVucBanHanh;
searchLoaivanBan.EditValue = GetGDKyBanHanh.IdLoaiVanBan;
searchDonViThamMuu.EditValue = GetGDKyBanHanh.IdDonViThamMuu;
searchLanhDaoPhuTrach.EditValue = GetGDKyBanHanh.IdLanhDaoPhuTrach;
txtCanBoThamMuu.Text = GetGDKyBanHanh.CanBoThamMuu;
dateNgayTrinhVanBan.EditValue = GetGDKyBanHanh.DateTrinhVanBan;
dateNgayKyVanBan.EditValue = GetGDKyBanHanh.DateKyVanBan;
txtSoVanBan.Text = GetGDKyBanHanh.NumberVanBan;
dateNgayVanBan.EditValue = GetGDKyBanHanh.DateVanBan;
memoTrichYeuVanBan.EditValue = GetGDKyBanHanh.TrichYeuVanBan;
string pathfile = GetGDKyBanHanh.Partitons + ":\\" + GetGDKyBanHanh.TaiLieuDinhKem;
if (pathfile == ":\\")
{
btnUpload.Text = "";
}
else
{
btnUpload.Text = pathfile;
}
}
}
catch (Exception)
{
throw;
}
}
private void GetOneGDVanBanDen()
{
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var _GetOne = quanLyCongViecEntities.GetOneGDVanBanDen(IdEdit).Single();
dateNgayNhanVanBan.EditValue = _GetOne.DateNgayNhan;
SearchCoQuanBanHanh.EditValue = _GetOne.IdCoQuanBanHanhVanBan;
SearchLoaiVanBan.EditValue = _GetOne.IdLoaiVanBan;
searchLinhVucVanBan.EditValue = _GetOne.IdLinhVucBanHanh;
txtSoVanBan.EditValue = _GetOne.SoVanBan;
dateNgayPhatHanh.EditValue = _GetOne.DateNgayPhatHanh;
txtSoGhiSoCongVan.EditValue = _GetOne.NumberSoCongVan;
memoTrichYeuVanBan.EditValue = _GetOne.TrichYeuVanBan;
memoCommentGD.EditValue = _GetOne.CommentGD;
SearchDonVi.EditValue = _GetOne.IDDonViChuTri;
SearchDonViPhoiHop.EditValue = _GetOne.IDDonVIPhoiHop;
dateNgayChiDao.EditValue = _GetOne.DateNgayChiDao;
dateNgayPhaiHoanThanh.EditValue = _GetOne.DateNgayPhaiHoanThanh;
radioPhaiBaoCao.EditValue = _GetOne.PhaiBaoCao;
txtNguoiNhanVanBan.EditValue = _GetOne.NguoiNhanVanBan;
dateNgayChuyenVanBan.EditValue = _GetOne.DateChuyenVanBanToiDonVi;
btnTaiLieuDinhKem.EditValue = _GetOne.Patition + ":\\" + _GetOne.TaiLIeuDinhKem;
DateHoanThanh.EditValue = _GetOne.DateHoanThanh;
if (_GetOne.HoanThanh != null)
{
checkHoanThanh.Checked = true;
}
if (_GetOne.ChuaHoanThanh != null)
{
checkChuaHoanThanh.Checked = true;
}
if (_GetOne.DangThucHien != null)
{
checkDangThucHien.Checked = true;
}
if (_GetOne.ChuaThucHien != null)
{
checkChuaThucHien.Checked = true;
}
if (_GetOne.ThucHienCham != null)
{
checkThucHienCham.Checked = true;
}
if (_GetOne.KetThucCongViec != null)
{
checkKetThucCongViec.Checked = true;
}
memoTomTatKetQua.EditValue = _GetOne.TomTatKetQua;
}
}
catch (Exception)
{
XtraMessageBox.Show("Lỗi kết nối với cơ sở dữ liệu");
}
}
private void SearchLanhDaoDonVi()
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var ListLanhDaoDonVi = quanLyCongViecEntities.searchlanhdaodonvi(IdSearch).ToList();
searchLanhDaoPhuTrach.Properties.DataSource = ListLanhDaoDonVi;
searchLanhDaoPhuTrach.Properties.DisplayMember = "TenLanhDao";
searchLanhDaoPhuTrach.Properties.ValueMember = "Id";
}
}
private void GetAllGDKyBanHanh()
{
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var getall = quanLyCongViecEntities.GetAllGDKyBanHanh().ToList();
}
}
catch (Exception)
{
throw;
}
}
private void GetOneYKienGD()
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var getone = quanLyCongViecEntities.GetOneTheoDoiVanBanDen(IdEdit).Single();
comboPGD.EditValue = getone.PGDPhuTrach;
searchDonVi.EditValue = getone.IdDonViChucNang;
searchLanhDao.EditValue = getone.IdLanhDaoPhuTrach;
txtCanBoThuLy.EditValue = getone.CanBoThuLy;
txtSoNgay.EditValue = getone.NumberDate;
btnUpload.EditValue = getone.TaiLieuDinhKem;
memoGhiChu.EditValue = getone.CommentGD;
}
}
private void GetAllLanhDaoDonVi()
{
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var _GetAllLanhDaoDonVi = quanLyCongViecEntities.GetAllLanhDaoDonvi().ToList();
grcLanhDaoDonVi.DataSource = _GetAllLanhDaoDonVi;
}
}
catch (Exception)
{
throw;
}
}
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
guidEdit = (Guid)grvLoaiVanBan.GetFocusedRowCellValue("Id");
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
quanLyCongViecEntities.DeleteLoaiVanBan(guidEdit);
}
GetAllLoaiVanBan();
}
catch (Exception)
{
XtraMessageBox.Show("Lỗi kết nối với cơ sở dữ liệu");
}
}
private void GetAllDonVi()
{
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var _GetAllDonVi = quanLyCongViecEntities.GetAllDonvi().ToList();
grcDonVi.DataSource = _GetAllDonVi;
}
}
catch (Exception)
{
//throw;
XtraMessageBox.Show("Lỗi kết nối với cơ sở dữ liệu");
}
}
private void btndelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
quanLyCongViecEntities.DeleteGDKyBanHanh(IdEdit);
}
XtraMessageBox.Show("Xóa thông tin thành công");
GetAllNull();
}
catch (Exception)
{
XtraMessageBox.Show("Lỗi kết nối đến cơ sở dữ liệu");
}
}
private void grcTienDoCongViec_Click(object sender, EventArgs e)
{
try
{
Guid guid = (Guid)grvTienDoCongViec.GetFocusedRowCellValue("Id");
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var GetAllTheoDoivanBan = quanLyCongViecEntities.GetAllTheoDoiVanBan(guid).ToList();
grcYKienGiamDoc.DataSource = GetAllTheoDoivanBan;
}
}
catch (Exception)
{
XtraMessageBox.Show("Lỗi kết nối đến cơ sở dữ liệu");
}
}
private void GetAllLinhVucBanHanh()
{
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var _GetAllLinhVucBanHanh = quanLyCongViecEntities.GetAllLinhVucBanHanh().ToList();
grcLinhVuc.DataSource = _GetAllLinhVucBanHanh;
}
}
catch (Exception)
{
//throw;
XtraMessageBox.Show("Lỗi kết nối với cơ sở dữ liệu");
}
}
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
quanLyCongViecEntities.DeleteGDVanBanDen(IdEdit);
XtraMessageBox.Show("Xóa thông tin thành công");
}
GetAllNull();
}
catch (Exception)
{
XtraMessageBox.Show("Thông tin không có trong cơ sở dữ liệu");
}
}
private void GetOneLinhVucBanHanh()
{
guidEdit = (Guid)grvLinhVuc.GetFocusedRowCellValue("Id");
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var edit = quanLyCongViecEntities.GetOneLinhVucBanHanh(guidEdit).Single();
txtCodeLinhVuc.EditValue = edit.CodeLinhVuc;
txtNameLinhVuc.EditValue = edit.NameLinhVuc;
}
}
catch (Exception)
{
XtraMessageBox.Show("Lỗi kết nối với cơ sở dữ liệu");
}
}
private void GetOneLoaiVanBan()
{
guidEdit = (Guid)grvLoaiVanBan.GetFocusedRowCellValue("Id");
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var edit = quanLyCongViecEntities.GetOneLoaiVanBan(guidEdit).Single();
txtMaVanBan.EditValue = edit.CodeVanBan;
txtTenLoaiVanBan.EditValue = edit.NameVanBan;
}
}
catch (Exception)
{
XtraMessageBox.Show("Lỗi kết nối với cơ sở dữ liệu");
}
}
private void FormExport_Load(object sender, EventArgs e)
{
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var _GetAllDonVi = quanLyCongViecEntities.GetAllCoQuanVaDonVi().ToList();
searchDonVi.Properties.DataSource = _GetAllDonVi;
searchDonVi.Properties.DisplayMember = "TenCoQuan";
searchDonVi.Properties.ValueMember = "Id";
}
}
catch (Exception)
{
XtraMessageBox.Show("Lỗi không thể kết nối được cơ sở dữ liệu");
}
}
private void GetAllDonVi()
{
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var _GetAllDonVi = quanLyCongViecEntities.GetDonViSearch().ToList();
searchDonVi.Properties.DataSource = _GetAllDonVi;
searchDonVi.Properties.DisplayMember = "TenDonVi";
searchDonVi.Properties.ValueMember = "Id";
}
}
catch (Exception)
{
XtraMessageBox.Show("Lỗi không thể kết nối được cơ sở dữ liệu");
}
}
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
Guid guid = (Guid)grvLanhDaoDonVi.GetFocusedRowCellValue("Id");
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
quanLyCongViecEntities.DeleteLanhDaoDonVi(guid);
}
GetAllLanhDaoDonVi();
}
catch (Exception)
{
throw;
}
}
private void barBtnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
Guid guid = (Guid)grvVanbanGDKy.GetFocusedRowCellValue("Id");
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
quanLyCongViecEntities.DeleteGDKyBanHanh(guid);
}
XtraMessageBox.Show("Xóa thông tin thành công");
GetAllGDKyBanHanh();
}
catch (Exception)
{
XtraMessageBox.Show("Lỗi kết nối đến cơ sở dữ liệu");
}
}
private void GetAllGDVanBanDen()
{
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var _GetAllGDVanBanDen = quanLyCongViecEntities.GetAllGDVanBanDen().ToList();
grcTienDoCongViec.DataSource = _GetAllGDVanBanDen;
//var _getall = quanLyCongViecEntities.GetAllTheoDoiVanBan1().ToList();
//grcYKienGiamDoc.DataSource = _getall;
}
}
catch (Exception)
{
XtraMessageBox.Show("Lỗi kết nối với cơ sở dữ liệu");
}
}
private void GetOneDonVi()
{
guidEdit = (Guid)grvDonVi.GetFocusedRowCellValue("Id");
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var edit = quanLyCongViecEntities.GetOneDonVi(guidEdit).Single();
txt_kyhieudonvi.EditValue = edit.MaDonVi;
txt_tendonvi.EditValue = edit.TenDonVi;
txt_PrintName.EditValue = edit.PrintName;
}
}
catch (Exception)
{
XtraMessageBox.Show("Lỗi kết nối với cơ sở dữ liệu");
}
}
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
Guid guid = (Guid)grvTienDoCongViec.GetFocusedRowCellValue("Id");
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
quanLyCongViecEntities.DeleteGDVanBanDen(guid);
XtraMessageBox.Show("Xóa thông tin thành công");
}
GetAllGDVanBanDen();
}
catch (Exception)
{
XtraMessageBox.Show("Vui lòng xóa ở bảng dưới trước khi xóa ở đây");
}
}
private void dateNgayPhatHanh_Leave(object sender, EventArgs e)
{
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var status = quanLyCongViecEntities.CheckExistVanBanDen(txtSoVanBan.Text, (DateTime?)dateNgayPhatHanh.EditValue).ToList();
if (status.Count() > 0)
{
XtraMessageBox.Show("Văn bản đến đã được nhận");
}
}
}
catch (Exception)
{
XtraMessageBox.Show("Lỗi kết nối đến cơ sở dữ liệu");
}
}
private void GetAllItem()
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var ListDonVi = quanLyCongViecEntities.GetAllDonvi().ToList();
var ListLanhDaoPhuTrach = quanLyCongViecEntities.GetAllLanhDaoDonvi().ToList();
var ListGDVanBanDen = quanLyCongViecEntities.GetOneGDVanBanDen(IdGDVanBanDen).Single();
searchDonVi.Properties.DataSource = ListDonVi;
searchDonVi.Properties.DisplayMember = "TenDonVi";
searchDonVi.Properties.ValueMember = "Id";
searchLanhDao.Properties.DataSource = ListLanhDaoPhuTrach;
searchLanhDao.Properties.DisplayMember = "TenLanhDao";
searchLanhDao.Properties.ValueMember = "Id";
memoGhiChu.Text = ListGDVanBanDen.CommentGD;
}
}
private void GetOneCoQuanBanHanh()
{
guidEdit = (Guid)grvCoQuanBanHanh.GetFocusedRowCellValue("Id");
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var edit = quanLyCongViecEntities.GetOneCoQuanbanHanhVanBan(guidEdit).Single();
txtSoHieu.EditValue = edit.KyHieu;
txtTenCoQuan.EditValue = edit.TenCoQuan;
radioInOrOut.EditValue = edit.InOrOut;
txt_PrintName.Text = edit.PrintName;
}
}
catch (Exception)
{
throw;
}
}
private void GetAllItem()
{
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var _GetAllCoQuanBanHanh = quanLyCongViecEntities.GetAllCoQuanVaDonVi().ToList();
var _GetAllLoaiVanBan = quanLyCongViecEntities.GetAllLoaiVanBan().ToList();
var _GetAllLinhVucVanBan = quanLyCongViecEntities.GetAllLinhVucBanHanh().ToList();
var _GetAllDonVi = quanLyCongViecEntities.GetAllDonvi().ToList();
SearchCoQuanBanHanh.Properties.DataSource = _GetAllCoQuanBanHanh;
SearchCoQuanBanHanh.Properties.DisplayMember = "TenCoQuan";
SearchCoQuanBanHanh.Properties.ValueMember = "Id";
//SearchCoQuanBanHanh.EditValue =Enum.IdCoQuanbanHanh;
SearchLoaiVanBan.Properties.DataSource = _GetAllLoaiVanBan;
SearchLoaiVanBan.Properties.DisplayMember = "NameVanBan";
SearchLoaiVanBan.Properties.ValueMember = "Id";
//SearchLoaiVanBan.EditValue = Enum.IdLoaiVanBan;
searchLinhVucVanBan.Properties.DataSource = _GetAllLinhVucVanBan;
searchLinhVucVanBan.Properties.DisplayMember = "NameLinhVuc";
searchLinhVucVanBan.Properties.ValueMember = "Id";
//searchLinhVucVanBan.EditValue = Enum.IdLinhVucBanHanh;
SearchDonVi.Properties.DataSource = _GetAllDonVi;
SearchDonVi.Properties.DisplayMember = "TenDonVi";
SearchDonVi.Properties.ValueMember = "Id";
//SearchDonVi.EditValue = Enum.IdDonVi;
SearchDonViPhoiHop.Properties.DataSource = _GetAllDonVi;
SearchDonViPhoiHop.Properties.DisplayMember = "TenDonVi";
SearchDonViPhoiHop.Properties.ValueMember = "Id";
//SearchDonViPhoiHop.EditValue = Enum.IdDonVi;
}
}
catch (Exception)
{
XtraMessageBox.Show("Lỗi kết nối đến cơ sở dữ liệu");
}
}
private void GetOneLanhDaoDonVi()
{
guidId = (Guid)grvLanhDaoDonVi.GetFocusedRowCellValue("Id");
GetAllDonVi();
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
var edit = quanLyCongViecEntities.GetOneLanhDaoDonVi(guidId).SingleOrDefault();
searchDonVi.EditValue = edit.IdDonVi;
txtTenLanhDao.EditValue = edit.TenLanhDao;
comboChucVu.EditValue = edit.ChucVu;
radioActive.EditValue = edit.Actived;
}
}
catch (Exception)
{
XtraMessageBox.Show("Lỗi không thể kết nối được cơ sở dữ liệu");
}
}
public void searchgridview()
{
try
{
using (quanLyCongViecEntities = new QuanLyCongViecEntities())
{
IdDonvi = (Guid)searchDonVi.EditValue;
var _getall = quanLyCongViecEntities.ExportVanBan(IdDonvi, DateTuNgay.DateTime, DateDenNgay.DateTime).ToList();
grcExport.DataSource = _getall;
gridColumn11.UnboundType = DevExpress.Data.UnboundColumnType.Integer;
gridColumn11.VisibleIndex = 0;
grvExport.CustomUnboundColumnData += grvExport_CustomUnboundColumnData;
}
}
catch (Exception)
{
XtraMessageBox.Show("Lỗi kết nối với cơ sở dữ liệu");
}
}
