private async Task LoadDuLieu()
{
_model = new QuanLyDoiModel();
await _model.XUAT_CANH_TRAI_PHEP.Where(p => p.NGAY_DI.HasValue && p.NGAY_DI.Value >= dateTuNgay.DateTime && p.NGAY_DI <= dateDenNgay.DateTime).LoadAsync();
xUAT_CANH_TRAI_PHEPBindingSource.DataSource = _model.XUAT_CANH_TRAI_PHEP.Local;
}
public FormXuatCanhTraiPhep()
{
InitializeComponent();
_model = new QuanLyDoiModel();
_modelTimKiem = new QuanLyDoiModel();
_khongCheckNhungNguoiNay = new List <NGUOI>();
LstXuatCanhTraiPhep = new List <XUAT_CANH_TRAI_PHEP>();
}
public FormDanhSachCanBoTrucTuan(int id_truc_tuan)
{
InitializeComponent();
_db = new QuanLyDoiModel();
_idTrucTuan = id_truc_tuan;
}
public FormChonXa(int thang, int nam, List <string> cac_xa_co_dau)
{
InitializeComponent();
_db = new QuanLyDoiModel();
_thang = thang;
_nam = nam;
_cacXaCoDau = cac_xa_co_dau;
txtThang.Text = _thang.ToString();
txtNam.Text = _nam.ToString();
}
public FormIntro()
{
InitializeComponent();
_db = new QuanLyDoiModel();
grvLichCongTac
.AddRowNumber()
.SetGridViewAppearance();
grvTrucTuan
.AddRowNumber()
.SetGridViewAppearance();
}
private void tRUC_TUANBindingSource_CurrentChanged(object sender, EventArgs e)
{
_dbCanBoTrucTuan.SaveChanges();
_dbCanBoTrucTuan = new QuanLyDoiModel();
TRUC_TUAN trucTuan = tRUC_TUANBindingSource.Current as TRUC_TUAN;
if (trucTuan != null)
{
_dbCanBoTrucTuan.TRUC_TUAN_CAN_BO.Where(p => p.IdTrucTuan == trucTuan.IdTrucTuan).Load();
tRUC_TUAN_CAN_BOBindingSource.DataSource = _dbCanBoTrucTuan.TRUC_TUAN_CAN_BO.Local;
}
}
private async void bAO_CAO_DINH_KYBindingSource_CurrentChanged(object sender, EventArgs e)
{
if (this.Current != null)
{
await _dbNgayBaoCao.SaveChangesAsync();
_dbNgayBaoCao = new QuanLyDoiModel();
lblTrangThai.ChangeTextAsync("Đang tải dữ liệu...", Color.Blue);
await _dbNgayBaoCao.BAO_CAO_DINH_KY_NGAY_BAO_CAO.Where(p => p.IdBaoCaoDinhKy == this.Current.IdBaoCaoDinhKy).LoadAsync();
nGAY_BAO_CAOBindingSource.DataSource = _dbNgayBaoCao.BAO_CAO_DINH_KY_NGAY_BAO_CAO.Local;
lblTrangThai.ChangeTextAsync("Sẵn sàng", Color.Black);
}
}
private async void btnTaiDuLieu_Click(object sender, EventArgs e)
{
await _db?.SaveChangesAsync();
btnTaiDuLieu.Enabled = false;
_db = new QuanLyDoiModel();
await _db.LICH_CONG_TAC.Where(p => (p.ThoiGian >= dateTuNgay.DateTime && p.ThoiGian <= dateDenNgay.DateTime) ||
(p.DenNgay >= dateTuNgay.DateTime && p.DenNgay <= dateDenNgay.DateTime)).LoadAsync();
lICH_CONG_TACBindingSource.DataSource = _db.LICH_CONG_TAC.Local;
btnTaiDuLieu.Enabled = true;
}
private async void btnAddNew_Click(object sender, EventArgs e)
{
if (_model.ChangeTracker.HasChanges() && ThongBao.XacNhan("Lưu trước khi nhập mới", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
if (!await this.LuuDuLieu())
{
return;
}
}
_model = new QuanLyDoiModel();
NguoiXuatCanh = new NGUOI();
nGUOIBindingSource.DataSource = NguoiXuatCanh;
xUAT_CANH_TRAI_PHEPBindingSource.DataSource = _model.XUAT_CANH_TRAI_PHEP.Local;
}
private async void cbbNam_SelectedIndexChanged(object sender, EventArgs e)
{
await _context.SaveChangesAsync();
_context = new QuanLyDoiModel();
_context = new QuanLyDoiModel();
cbbNam.Enabled = false;
cbbNam.SelectedValueChanged -= cbbNam_SelectedIndexChanged;
await _context.CONG_VAN
.Where(p => p.NgayNhan.HasValue && p.NgayNhan.Value.Year == (int)cbbNam.SelectedItem)
.LoadAsync();
cONG_VANBindingSource.DataSource = _context.CONG_VAN.Local;//.Where(p => p.NgayNhan.HasValue && p.NgayNhan.Value.Year == (int)cbbNam.SelectedItem);
cbbNam.SelectedValueChanged += cbbNam_SelectedIndexChanged;
cbbNam.Enabled = true;
}
public static async Task <List <LICH_CONG_TAC> > LichCongTacNhungNgayToiAsync(int so_nga_toi = 14)
{
QuanLyDoiModel _db = new QuanLyDoiModel();
List <LICH_CONG_TAC> res = new List <LICH_CONG_TAC>();
var moc14Ngay = DateTime.Now.AddDays(so_nga_toi);
var ngayHomNay = DateTime.Now.Date;
//tải dữ liệu lịch trình
var lichTrinh = await _db.LICH_CONG_TAC.Where(p => (p.ThoiGian >= ngayHomNay && p.ThoiGian <= moc14Ngay) ||
(p.DenNgay >= ngayHomNay && p.DenNgay <= moc14Ngay)).ToListAsync();
res.AddRange(lichTrinh);
//Thêm báo cáo định kỳ vào lịch trình công tác
int namNay = DateTime.Now.Year;
var baoCaoDinhKy = (await _db.BAO_CAO_DINH_KY_NGAY_BAO_CAO.ToListAsync()).Where(p => p.NgayBaoCaoNamNay >= ngayHomNay &&
p.NgayBaoCaoNamNay <= moc14Ngay);
foreach (var bcdk in baoCaoDinhKy)
{
res.Add(new LICH_CONG_TAC()
{
NoiDung = $"Báo cáo định kỳ {bcdk.BAO_CAO_DINH_KY.NoiDung} ({bcdk.GhiChu}) gửi {bcdk.BAO_CAO_DINH_KY.DonViNhanBaoCao}",
ThoiGian = new DateTime(namNay, bcdk.Thang, bcdk.Ngay),
});
}
//Thêm sinh nhật vào lịch trình công tác
var sinhNhat = await _db.CAN_BO.Where(p => p.NgayThangNamSinh.HasValue &&
p.NgayThangNamSinh.Value.Month == DateTime.Now.Month &&
p.NgayThangNamSinh.Value.Day >= ngayHomNay.Day).ToListAsync();
foreach (var cb in sinhNhat)
{
res.Add(new LICH_CONG_TAC()
{
NoiDung = $"Sinh nhật đồng chí {cb.HoVaTen}",
ThoiGian = cb.NgayThangNamSinh
});
}
return(res);
}
public static async Task LoadBangMaAsync(QuanLyDoiModel db)
{
await db.MA_CHUC_VU.LoadAsync();
await db.MA_CAP_BAC.LoadAsync();
await db.MA_DIA_BAN_XA.LoadAsync();
await db.MA_LOAI_CONG_VAN.LoadAsync();
await db.MA_DIA_BAN_XA.LoadAsync();
await db.MA_DIA_BAN_THON.LoadAsync();
await db.MA_DOI.LoadAsync();
await db.MA_LOAI_CONG_VAN.LoadAsync();
await db.MA_DAN_TOC.LoadAsync();
}
private async Task <bool> LuuDuLieu()
{
if (_khongLuu)
{
return(true);
}
hO_VA_TENTextBox.Focus();
gIOI_TINHComboBoxEdit.Focus();
xUAT_CANH_TRAI_PHEPBindingSource.EndEdit();
nGUOIBindingSource.EndEdit();
QuanLyDoiModel temp = new QuanLyDoiModel();
if (NguoiXuatCanh.ID == 0 && !string.IsNullOrEmpty(NguoiXuatCanh.HO_VA_TEN))
{
NguoiXuatCanh.ID = SequenceId.NGUOI();
temp.NGUOI.Add(NguoiXuatCanh);
await temp.SaveChangesAsync();
}
foreach (XUAT_CANH_TRAI_PHEP xc in xUAT_CANH_TRAI_PHEPBindingSource)
{
xc.ID_NGUOI = NguoiXuatCanh.ID;
}
try
{
await _model.SaveChangesAsync();
return(true);
}
catch
{
return(false);
}
}
public FormLichTrinhCongTac()
{
InitializeComponent();
_db = new QuanLyDoiModel();
}
public FormBaoCaoDinhKy()
{
InitializeComponent();
_db = new QuanLyDoiModel();
_dbNgayBaoCao = new QuanLyDoiModel();
}
public FormDanhSachCanBo()
{
InitializeComponent();
_db = new QuanLyDoiModel();
}
static Global()
{
DbBangMa = new QuanLyDoiModel();
}
private void linkRefresh_Click(object sender, EventArgs e)
{
_db = new QuanLyDoiModel();
this.FormIntro_Load(sender, e);
}
public FormTrucTuan()
{
InitializeComponent();
_dbTrucTuan = new QuanLyDoiModel();
_dbCanBoTrucTuan = new QuanLyDoiModel();
}
public FormNhapThongTinKhoiTao()
{
InitializeComponent();
_db = new QuanLyDoiModel();
}
public FormThongKeXuatCanhTraiPhep()
{
InitializeComponent();
_model = new QuanLyDoiModel();
}
public frmCongVanDen()
{
InitializeComponent();
_context = new QuanLyDoiModel();
_category = new QuanLyDoiModel();
}
public FormNhiemVuGiayDiDuong()
{
_context = new QuanLyDoiModel();
InitializeComponent();
}
