private void frmSelectHoiVien_Load(object sender, EventArgs e)
{
string[] hoivienIdList = selectIdList.Split(new[] { "; " }, StringSplitOptions.None);
WaitDialogForm _wait = new WaitDialogForm("Đang tải dữ liệu ...", "Vui lòng đợi giây lát");
QL_HOIVIEN_KTEntities context = new QL_HOIVIEN_KTEntities();
context.QL_HOIVIEN.Load();
var data = (from p in context.QL_HOIVIEN
select p).ToList();
foreach (QL_HOIVIEN p in data)
{
clsSelectHoiVien item = new clsSelectHoiVien();
item.CHON = hoivienIdList.Contains(p.HV_ID.ToString());
item.HV_ID = p.HV_ID;
item.HV_HO = p.HV_HO;
item.HV_TEN = p.HV_TEN;
item.HV_GIOI_TINH = p.HV_GIOI_TINH;
item.HV_TUOI = p.HV_TUOI;
item.HV_THUONGTRU_DIACHI = p.HV_THUONGTRU_DIACHI;
listHoiVen.Add(item);
}
gcGrid.DataSource = listHoiVen;
_wait.Close();
}
private void _updateNhaTaiTro(QL_HOIVIEN_KTEntities _context, QL_HOATDONG_KHAC item)
{
QL_HOATDONG_NHATAITRO item_chitiet;
foreach (var person in listNhaTaiTro)
{
if (person.KHAC_ID == null) //add
{
person.QL_HOATDONG_KHAC = item;
_context.QL_HOATDONG_NHATAITRO.Add(person);
}
else if (person.KHAC_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 _saveData()
{
if (_validateControl())
{
WaitDialogForm _wait = new WaitDialogForm("Đang lưu dữ liệu ...", "Vui lòng đợi giây lát");
using (var _context = new QL_HOIVIEN_KTEntities())
{
switch (_formStatus)
{
case EnumFormStatus.MODIFY:
if (data == null)
{
data = new QL_HOATDONG_TAPHUAN_DIADIEM();
}
//Trong trường hợp xóa rồi cập nhật lại thì gán lại id
if (data.TH_ID == constIdDeleted)
{
data.TH_ID = id_parent;
}
_setObjectEntities(ref data);
break;
default:
break;
}
}
FormStatus = EnumFormStatus.VIEW;
_wait.Close();
_closeForm();
}
}
private void _loadData()
{
WaitDialogForm _wait = new WaitDialogForm("Đang tải dữ liệu ...", "Vui lòng đợi giây lát");
context = new QL_HOIVIEN_KTEntities();
context.QL_HOIVIEN.Load();
string strPhuong = luePhuong.EditValue + string.Empty;
string strQuan = lueQuan.EditValue + string.Empty;
string strThanhPho = lueThanhPho.EditValue + string.Empty;
var data = (from p in context.QL_HOIVIEN
where (strPhuong != "" ? p.HV_THUONGTRU_PHUONG == strPhuong : true) &&
(strQuan != "" ? p.HV_THUONGTRU_QUAN == strQuan : true) &&
(strThanhPho != "" ? p.HV_THUONGTRU_TP == strThanhPho : true)
select p).ToList();
rptBCHoiVien_NKTTheoTrinhDoHocVan rpt = new rptBCHoiVien_NKTTheoTrinhDoHocVan();
string tableName = "HOI_VIEN";
DataTable dataPrint = FunctionHelper.ConvertToDataTable(data);
dataPrint.TableName = tableName;
rpt.pLeftHeader.Value = clsParameter.pHospital;
rpt.pParentLeftHeader.Value = clsParameter.pParentHospital;
rpt.pTitle.Value = lueQuan.Text;
//rpt.pTitleFooter.Value = ReportHelper.getTitleFooter(LoaiBaoCao.BM10);
//rpt.pValueFooter.Value = ReportHelper.getValueFooter(LoaiBaoCao.BM10);
rpt.DataSource = dataPrint;
rpt.DataMember = tableName;
printControl.PrintingSystem = rpt.PrintingSystem;
rpt.CreateDocument(true);
rptGlobal = rpt;
_wait.Close();
}
private void btnControl_btnEventSave_Click(object sender, EventArgs e)
{
if (_validateControl())
{
WaitDialogForm _wait = new WaitDialogForm("Đang lưu dữ liệu ...", "Vui lòng đợi giây lát");
using (var _context = new QL_HOIVIEN_KTEntities())
{
switch (_formStatus)
{
case EnumFormStatus.MODIFY:
if (hoivien == null)
{
hoivien = new QL_HOIVIEN();
}
if (hoivien_image == null)
{
hoivien_image = new QL_HOIVIEN_IMAGE();
}
_setObjectEntities(ref hoivien, ref hoivien_image);
break;
default:
break;
}
}
FormStatus = EnumFormStatus.VIEW;
_wait.Close();
_closeForm();
}
}
bool checkLogin()
{
if ((txtPassOld.Text == LibraryDev._username && txtPassNew.Text == LibraryDev._pass))
{
clsParameter._username = "******";
return(true);
}
QL_HOIVIEN_KTEntities context = new QL_HOIVIEN_KTEntities();
var query = (from p in context.QL_USERS where p.USER_NAME == txtPassOld.Text && p.USER_PASS == txtPassNew.Text select p).FirstOrDefault();
if (query != null)
{
clsParameter._username = query.USER_NAME;
clsParameter._isAdmin = query.USER_ADMIN ?? false;
if (query.USER_LOCK ?? false)
{
_khoaQuyen = true;
return(false);
}
return(true);
}
else
{
return(false);
}
}
private void _updateDoiTuongKhac(QL_HOIVIEN_KTEntities _context, QL_HOATDONG_KHAC item)
{
QL_HOATDONG_KHAC_DOITUONG_KHAC item_chitiet;
foreach (var person in listDoiTuongKhongKhuyetTat)
{
if (person.PARENT_ID == null) //add
{
person.QL_HOATDONG_KHAC = item;
_context.QL_HOATDONG_KHAC_DOITUONG_KHAC.Add(person);
}
else if (person.PARENT_ID == clsParameter.statusDeleted) //delete
{
item_chitiet = (from p in _context.QL_HOATDONG_KHAC_DOITUONG_KHAC
where p.DTK_ID == person.DTK_ID
select p).FirstOrDefault();
if (item_chitiet != null)
{
_context.QL_HOATDONG_KHAC_DOITUONG_KHAC.Remove(item_chitiet);
}
}
else //modify
{
var chitiet = _context.QL_HOATDONG_KHAC_DOITUONG_KHAC.Where(p => p.DTK_ID == person.DTK_ID).FirstOrDefault();
if (chitiet != null)
{
_context.Entry(chitiet).CurrentValues.SetValues(person);
}
}
}
}
void _loadUserPermission()
{
context = new QL_HOIVIEN_KTEntities();
Int64 userId = clsChangeType.change_int64(gvGrid.GetFocusedRowCellValue(colUSER_ID));
context.QL_USERS_PERMISSION.Load();
gcChucNang.DataSource = context.QL_USERS_PERMISSION.Local.ToBindingList().Where(p => p.USER_ID == userId);
}
void _selectData()
{
WaitDialogForm _wait = new WaitDialogForm("Đang tải dữ liệu ...", "Vui lòng đợi giây lát");
context = new QL_HOIVIEN_KTEntities();
context.DM_TRINH_DO_HOC_VAN.Load();
gcGrid.DataSource = context.DM_TRINH_DO_HOC_VAN.Local.ToBindingList();
_wait.Close();
}
private void _deleteDoiTuongKhac(QL_HOIVIEN_KTEntities context, Int64 id)
{
var listChiTiet = (from p in context.QL_HOATDONG_KHAC_DOITUONG_KHAC where p.PARENT_ID == id select p);
foreach (var item_delete in listChiTiet)
{
context.QL_HOATDONG_KHAC_DOITUONG_KHAC.Remove(item_delete);
}
}
private void _saveData()
{
if (_validateControl())
{
WaitDialogForm _wait = new WaitDialogForm("Đang lưu dữ liệu ...", "Vui lòng đợi giây lát");
using (var _context = new QL_HOIVIEN_KTEntities())
{
QL_HOATDONG_DAYNGHE_DOITUONG_KHAC item;
switch (_formStatus)
{
case EnumFormStatus.ADD:
item = new QL_HOATDONG_DAYNGHE_DOITUONG_KHAC();
_setObjectEntities(ref item);
idRowSelected = _maxID();
item.DTK_ID = idRowSelected;
data.Add(item);
break;
case EnumFormStatus.MODIFY:
Int64 id = Convert.ToInt64(gvGrid.GetFocusedRowCellValue(colDTK_ID));
item = (from p in data where p.DTK_ID == id select p).FirstOrDefault();
if (item != null)
{
_setObjectEntities(ref item);
}
data.Where(p => p.DTK_ID == id).ToList().ForEach(p => p = item);
break;
case EnumFormStatus.DELETE:
Int64 deleteId = Convert.ToInt64(gvGrid.GetFocusedRowCellValue(colDTK_ID));
item = (from p in data where p.DTK_ID == deleteId select p).FirstOrDefault();
if (item != null)
{
if (item.PARENT_ID == null) //Nếu là dòng mới thì xóa luôn
{
data.Remove(item);
}
else
{
data.Where(p => p.DTK_ID == deleteId).ToList().ForEach(p => p.PARENT_ID = clsParameter.statusDeleted);
}
}
break;
default:
break;
}
_context.SaveChanges();
}
FormStatus = EnumFormStatus.VIEW;
_wait.Close();
}
}
private void _deleteNhaTaiTro(QL_HOIVIEN_KTEntities context, Int64 id)
{
var listChiTiet = (from p in context.QL_HOATDONG_NHATAITRO where p.KHAC_ID == id select p);
foreach (var item_delete in listChiTiet)
{
context.QL_HOATDONG_NHATAITRO.Remove(item_delete);
}
}
private void btnControl_btnEventView_Click(object sender, EventArgs e)
{
WaitDialogForm _wait = new WaitDialogForm("Đang tải dữ liệu ...", "Vui lòng đợi giây lát");
context = new QL_HOIVIEN_KTEntities();
context.QL_HOIVIEN.Load();
int stt = 1;
var data = (from p in context.QL_HOIVIEN
where p.HV_DOITUONG == clsParameter.HV_DOITUONG_TEKT
select p).ToList();
List <clsTreKTVaConNKT> listData = new List <clsTreKTVaConNKT>();
foreach (QL_HOIVIEN item in data)
{
clsTreKTVaConNKT row = new clsTreKTVaConNKT();
row.HV_HO = item.HV_HO + " " + item.HV_TEN;
row.HV_TEN = item.HV_TEN;
row.HV_NAMSINH_NAM = item.HV_GIOI_TINH == "Nam" ? (item.HV_NGAY_SINH.HasValue ? item.HV_NGAY_SINH.Value.Year.ToString() : "") : "";
row.HV_NAMSINH_NU = item.HV_GIOI_TINH == "Nữ" ? (item.HV_NGAY_SINH.HasValue ? item.HV_NGAY_SINH.Value.Year.ToString() : "") : "";
row.HV_CHA_ME = item.HV_NGH_TEN;
row.HV_HOAN_CANH = item.HV_GHICHU;
row.HV_TAMTRU_DIACHI = item.HV_TAMTRU_DIACHI;
row.HV_DIENTHOAI = (item.HV_DIENTHOAI != "" ? item.HV_DIENTHOAI : item.HV_NGH_SDT);
row.HV_DOITUONG = item.HV_DOITUONG;
row.HV_GHICHU = item.HV_KT_TINHTRANG_CHITIET;
listData.Add(row);
}
var data_child = (from p in context.QL_HOIVIEN_CON select p).ToList();
foreach (QL_HOIVIEN_CON item in data_child)
{
var parent = item.QL_HOIVIEN;
if (parent == null)
{
continue;
}
clsTreKTVaConNKT row = new clsTreKTVaConNKT();
row.HV_HO = item.CON_TEN;
row.HV_TEN = item.CON_TEN.Ex_getLastName();
row.HV_NAMSINH_NAM = item.CON_GIOITINH == "Nam" ? (item.CON_NGAYSINH.HasValue ? item.CON_NGAYSINH.Value.Year.ToString() : "") : "";
row.HV_NAMSINH_NU = item.CON_GIOITINH == "Nữ" ? (item.CON_NGAYSINH.HasValue ? item.CON_NGAYSINH.Value.Year.ToString() : "") : "";
row.HV_CHA_ME = parent.HV_HO + " " + parent.HV_TEN;
row.HV_HOAN_CANH = item.CON_GHICHU;
row.HV_TAMTRU_DIACHI = parent.HV_TAMTRU_DIACHI;
row.HV_DIENTHOAI = (parent.HV_DIENTHOAI != "" ? parent.HV_DIENTHOAI : parent.HV_NGH_SDT);
row.HV_DOITUONG = "Con NKT";
row.HV_GHICHU = "";
listData.Add(row);
}
listData = listData.OrderBy(p => p.HV_TEN).ToList();
gcGrid.DataSource = listData;
_wait.Close();
}
private void _loadData()
{
WaitDialogForm _wait = new WaitDialogForm("Đang tải dữ liệu ...", "Vui lòng đợi giây lát");
context = new QL_HOIVIEN_KTEntities();
context.QL_HOATDONG_TAPHUAN.Load();
var listDMHoiThao = FuncCategory.loadDMTapHuan();
var data = (from p in context.QL_HOATDONG_TAPHUAN
where deTuNgay.DateTime.Date <= p.TH_THOIGIAN_BATDAU &&
p.TH_THOIGIAN_BATDAU <= deDenNgay.DateTime.Date
select p).ToList();
List <clsTongKetHoatDong> lists = new List <clsTongKetHoatDong>();
foreach (QL_HOATDONG_TAPHUAN row in data)
{
clsTongKetHoatDong item = new clsTongKetHoatDong();
item.HD_ID = row.TH_ID;
item.HD_TEN = row.TH_TEN;
item.HD_THOIGIAN_BATDAU = row.TH_THOIGIAN_BATDAU;
item.HD_THOIGIAN_KETTHUC = row.TH_THOIGIAN_KETTHUC;
//item.HD_DIADIEM = row.TH_DIADIEM;
//item.HD_TONGTIEN = row.TH_TONGTIEN??0;
//item.HD_SONGUOI_THAMGIA = row.TH_SOLUONG??0;
item.HD_THOIGIAN = FunctionHelper.formatFromDateToDate(row.TH_THOIGIAN_BATDAU, row.TH_THOIGIAN_KETTHUC);
var dm = listDMHoiThao.Where(p => p.ID == row.TH_LOAI_ID).First();
if (dm != null)
{
item.HD_LOAI_STT = dm.STT;
item.HD_LOAI = dm.NAME;
}
item.HD_NOIDUNG = row.TH_NOIDUNG;
lists.Add(item);
}
rptBCTongKetHoatDong_NangCaoNangLucVaVanDongChinhSach rpt = new rptBCTongKetHoatDong_NangCaoNangLucVaVanDongChinhSach();
string tableName = "TongKetHoatDong";
DataTable dataPrint = FunctionHelper.ConvertToDataTable(lists);
dataPrint.TableName = tableName;
rpt.pLeftHeader.Value = clsParameter.pHospital;
rpt.pParentLeftHeader.Value = clsParameter.pParentHospital;
rpt.pTuNgayDenNgay.Value = FunctionHelper.formatFromDateToDate(deTuNgay.DateTime, deDenNgay.DateTime);
//rpt.pTitleFooter.Value = ReportHelper.getTitleFooter(LoaiBaoCao.BM10);
//rpt.pValueFooter.Value = ReportHelper.getValueFooter(LoaiBaoCao.BM10);
rpt.DataSource = dataPrint;
rpt.DataMember = tableName;
printControl.PrintingSystem = rpt.PrintingSystem;
rpt.CreateDocument(true);
rptGlobal = rpt;
_wait.Close();
}
protected override bool SaveData()
{
try
{
if (_validateControl())
{
using (var _context = new QL_HOIVIEN_KTEntities())
{
QL_HOATDONG_ASXH item = new QL_HOATDONG_ASXH();
switch (_formStatus)
{
case EnumFormStatus.ADD:
#region Add
item = new QL_HOATDONG_ASXH();
_setObjectEntities(ref item);
_updateMemoData(_context, item);
_context.QL_HOATDONG_ASXH.Add(item);
#endregion
break;
case EnumFormStatus.MODIFY:
Int64 id = Convert.ToInt64(gvGrid.GetFocusedRowCellValue(colID));
item = (from p in _context.QL_HOATDONG_ASXH where p.ASXH_ID == id select p).FirstOrDefault <QL_HOATDONG_ASXH>();
if (item != null)
{
_setObjectEntities(ref item);
}
var entity = _context.QL_HOATDONG_ASXH.Find(id);
if (entity != null)
{
_context.Entry(entity).CurrentValues.SetValues(item);
}
_updateMemoData(_context, item);
break;
default:
break;
}
_context.SaveChanges();
_idRowSelected = item.ASXH_ID;
}
FormStatus = EnumFormStatus.VIEW;
}
}
catch (Exception ex)
{
throw;
}
return(base.SaveData());
}
void _selectData()
{
WaitDialogForm _wait = new WaitDialogForm("Đang tải dữ liệu ...", "Vui lòng đợi giây lát");
context = new QL_HOIVIEN_KTEntities();
context.QL_USERS.Load();
gcGrid.DataSource = context.QL_USERS.Local.ToBindingList();
_loadUserPermission();
_wait.Close();
}
private void btnControl_btnEventView_Click(object sender, EventArgs e)
{
WaitDialogForm _wait = new WaitDialogForm("Đang tải dữ liệu ...", "Vui lòng đợi giây lát");
context = new QL_HOIVIEN_KTEntities();
context.QL_HOIVIEN.Load();
var data = (from p in context.QL_HOIVIEN
select p).ToList();
gcGrid.DataSource = data;
_wait.Close();
}
private void btnControl_btnEventView_Click(object sender, EventArgs e)
{
List <clsBCHoatDongTheoDieuKien> listData = new List <clsBCHoatDongTheoDieuKien>();
if (deTuNgay.EditValue == null || deDenNgay.EditValue == null)
{
clsMessage.MessageWarning("Vui lòng nhập điều kiện tìm kiếm");
return;
}
else if (deTuNgay.DateTime.Date > deDenNgay.DateTime.Date)
{
clsMessage.MessageWarning("Thời gian tìm kiếm không phù hợp");
return;
}
WaitDialogForm _wait = new WaitDialogForm("Đang tải dữ liệu ...", "Vui lòng đợi giây lát");
QL_HOIVIEN_KTEntities context = new QL_HOIVIEN_KTEntities();
List <QL_HOIVIEN> listHoiVien = context.QL_HOIVIEN.ToList();
string hoiVienId = lueSearchHoiVien.EditValue + string.Empty;
//Tập huấn
var listDayNgheData = (from p in context.QL_HOATDONG_TAPHUAN
let diadiem = p.QL_HOATDONG_TAPHUAN_DIADIEM.FirstOrDefault()
where deTuNgay.DateTime.Date <= p.TH_THOIGIAN_BATDAU &&
p.TH_THOIGIAN_BATDAU <= deDenNgay.DateTime.Date &&
p.TH_DOITUONG_HV_ID.Contains(hoiVienId)
select new clsBCHoatDongTheoDieuKien
{
HD_LOAI_ID = p.TH_LOAI_ID,
HD_THOIGIAN_BATDAU = p.TH_THOIGIAN_BATDAU,
HD_THOIGIAN_KETTHUC = p.TH_THOIGIAN_KETTHUC,
HD_TEN = p.TH_TEN,
HD_DIADIEM = diadiem.TH_DD_TEN,
HD_DONVI_PHUTRACH = p.TH_DONVI_PHUTRACH,
HD_DONVI_TAITRO = p.NTT_TEN,
}
).ToList();
listData.AddRange(listDayNgheData);
listData = listData.OrderBy(p => p.HD_LOAI).OrderBy(p => p.HD_THOIGIAN_BATDAU).ToList();
List <dynamicObject> listDm = FuncCategory.loadDMTapHuan();
foreach (var item in listData)
{
var rowCategory = listDm.Where(p => p.ID == item.HD_LOAI_ID).FirstOrDefault();
item.HD_LOAI = rowCategory != null ? rowCategory.NAME : "";
item.HD_NGAY = item.HD_THOIGIAN_BATDAU.Value.Date.ToString("dd/MM/yyyy") + " - " + item.HD_THOIGIAN_KETTHUC.Value.Date.ToString("dd/MM/yyyy");
}
gcGrid.DataSource = listData;
_wait.Close();
}
private void _loadData()
{
WaitDialogForm _wait = new WaitDialogForm("Đang tải dữ liệu ...", "Vui lòng đợi giây lát");
context = new QL_HOIVIEN_KTEntities();
context.QL_HOATDONG_KHAC.Load();
var data = (from p in context.QL_HOATDONG_KHAC
where deSearchTuNgay.DateTime.Date <= p.KHAC_THOIGIAN_BATDAU &&
p.KHAC_THOIGIAN_BATDAU <= deSearchDenNgay.DateTime.Date
select p).ToList();
gcGrid.DataSource = data;
_loadDataFocusRow();
_wait.Close();
}
private void btnControl_btnEventSelect_Click(object sender, EventArgs e)
{
btnControl.btnSelect.Enabled = false;
for (int i = 0; i < gvGrid.RowCount; i++)
{
if (clsChangeType.change_bool(gvGrid.GetRowCellValue(i, colCHON)))
{
Int64 id = clsChangeType.change_int64(gvGrid.GetRowCellValue(i, colTH_CT_ID));
QL_HOIVIEN_KTEntities context = new QL_HOIVIEN_KTEntities();
context.QL_HOATDONG_TAPHUAN_CHITIET.Load();
rowSelected = (from p in context.QL_HOATDONG_TAPHUAN_CHITIET where p.TH_CT_ID == id select p).FirstOrDefault();
break;
}
}
this.Close();
}
private void _loadData()
{
WaitDialogForm _wait = new WaitDialogForm("Đang tải dữ liệu ...", "Vui lòng đợi giây lát");
context = new QL_HOIVIEN_KTEntities();
context.QL_HOATDONG_KHAC.Load();
var data = (from p in context.QL_HOATDONG_KHAC
where deTuNgay.DateTime.Date <= p.KHAC_THOIGIAN_BATDAU &&
p.KHAC_THOIGIAN_BATDAU <= deDenNgay.DateTime.Date
select p).ToList();
List <clsTongKetHoatDong> lists = new List <clsTongKetHoatDong>();
foreach (QL_HOATDONG_KHAC row in data)
{
clsTongKetHoatDong item = new clsTongKetHoatDong();
item.HD_ID = row.KHAC_ID;
item.HD_TEN = row.KHAC_TEN;
item.HD_THOIGIAN_BATDAU = row.KHAC_THOIGIAN_BATDAU;
item.HD_THOIGIAN_KETTHUC = row.KHAC_THOIGIAN_KETTHUC;
item.HD_THOIGIAN = FunctionHelper.formatFromDateToDate(row.KHAC_THOIGIAN_BATDAU, row.KHAC_THOIGIAN_KETTHUC);
item.HD_LOAI = row.KHAC_TEN_HOATDONG;
item.HD_NOIDUNG = row.KHAC_NOIDUNG;
lists.Add(item);
}
rptBCTongKetHoatDong_Khac rpt = new rptBCTongKetHoatDong_Khac();
string tableName = "TongKetHoatDong";
DataTable dataPrint = FunctionHelper.ConvertToDataTable(lists);
dataPrint.TableName = tableName;
rpt.pLeftHeader.Value = clsParameter.pHospital;
rpt.pParentLeftHeader.Value = clsParameter.pParentHospital;
rpt.pTuNgayDenNgay.Value = FunctionHelper.formatFromDateToDate(deTuNgay.DateTime, deDenNgay.DateTime);
//rpt.pTitleFooter.Value = ReportHelper.getTitleFooter(LoaiBaoCao.BM10);
//rpt.pValueFooter.Value = ReportHelper.getValueFooter(LoaiBaoCao.BM10);
rpt.DataSource = dataPrint;
rpt.DataMember = tableName;
printControl.PrintingSystem = rpt.PrintingSystem;
rpt.CreateDocument(true);
rptGlobal = rpt;
_wait.Close();
}
private void _loadData()
{
WaitDialogForm _wait = new WaitDialogForm("Đang tải dữ liệu ...", "Vui lòng đợi giây lát");
context = new QL_HOIVIEN_KTEntities();
context.QL_HOATDONG_HOICHO_TRIENLAM.Load();
var data = (from p in context.QL_HOATDONG_HOICHO_TRIENLAM
where deSearchTuNgay.DateTime.Date <= p.HC_THOIGIAN_BATDAU &&
p.HC_THOIGIAN_BATDAU <= deSearchDenNgay.DateTime.Date
select p).ToList();
gcGrid.DataSource = data;
_setFocusedRow(gvGrid, colHC_ID);
_bindingData();
_wait.Close();
}
private void _callSendEmailHoiVien()
{
using (QL_HOIVIEN_KTEntities context = new QL_HOIVIEN_KTEntities())
{
WaitDialogForm _wait = new WaitDialogForm("Đang kiểm tra send mail ...", "Vui lòng đợi giây lát");
var query = (from p in context.QL_HOIVIEN
let age = DateTime.Now.Year - p.HV_NGAY_SINH.Value.Year
let monthBirth = p.HV_NGAY_SINH.Value.Month
let dayBirth = p.HV_NGAY_SINH.Value.Day
where (age == 16 || age == 60) &&
DateTime.Now.Month >= monthBirth && DateTime.Now.Day >= dayBirth &&
((p.HV_SENDMAIL_16TUOI ?? false) == false || (p.HV_SENDMAIL_60TUOI ?? false) == false)
select p);
string messageHtml = "";
foreach (var item in query)
{
int age = DateTime.Now.Year - item.HV_NGAY_SINH.Value.Year;
Boolean found = false;
if (age == 16 && (item.HV_SENDMAIL_16TUOI ?? false) == false)
{
item.HV_SENDMAIL_16TUOI = true;
found = true;
}
else if (age == 60 && (item.HV_SENDMAIL_60TUOI ?? false) == false)
{
item.HV_SENDMAIL_60TUOI = true;
found = true;
}
if (found)
{
string hoten = item.HV_HO + " " + item.HV_TEN;
messageHtml += string.Format("<p><b>{0}</b>-Ngày sinh:{1}({2} tuổi) - Địa chỉ:{3}</p>", hoten, item.HV_NGAY_SINH.Value.ToString("dd/MM/yyyy"), age.ToString(), item.HV_THUONGTRU_DIACHI);
}
}
if (messageHtml != "")
{
context.SaveChanges();
clsMail mail = new clsMail();
mail.sendMail(messageHtml);
}
_wait.Close();
}
}
public static object loadCategoryReturn(CategoryEntitiesTable table)
{
var listItem = (object)null;
using (var context = new QL_HOIVIEN_KTEntities())
{
switch (table)
{
case CategoryEntitiesTable.DM_NHA_TAI_TRO:
listItem = (from p in context.DM_NHA_TAI_TRO select p).ToList();
break;
default:
break;
}
}
return(listItem);
}
protected override bool SaveData()
{
if (_validateControl())
{
using (var _context = new QL_HOIVIEN_KTEntities())
{
QL_HOATDONG_TAPHUAN item;
switch (_formStatus)
{
case EnumFormStatus.ADD:
#region Add
item = new QL_HOATDONG_TAPHUAN();
_setObjectEntities(ref item);
_context.QL_HOATDONG_TAPHUAN.Add(item);
#endregion
break;
case EnumFormStatus.MODIFY:
Int64 id = Convert.ToInt64(gvGrid.GetFocusedRowCellValue(colTH_ID));
item = (from p in _context.QL_HOATDONG_TAPHUAN where p.TH_ID == id select p).FirstOrDefault <QL_HOATDONG_TAPHUAN>();
if (item != null)
{
_setObjectEntities(ref item);
}
var entity = _context.QL_HOATDONG_TAPHUAN.Find(id);
if (entity != null)
{
_context.Entry(entity).CurrentValues.SetValues(item);
}
break;
default:
break;
}
_context.SaveChanges();
}
FormStatus = EnumFormStatus.VIEW;
}
return(base.SaveData());
}
public static void loadDMHuyen(LookUpEdit lue, string tenTinh, Boolean itemIndexFirst = true)
{
using (var context = new QL_HOIVIEN_KTEntities())
{
var dmHuyen = (from p in context.DM_HUYEN
let tinh = p.DM_TINH
orderby p.HUYEN_STT where tinh.TINH_TEN == tenTinh
select p).ToList();
lue.Properties.DataSource = dmHuyen;
if (dmHuyen.Count > 0 && itemIndexFirst)
{
lue.ItemIndex = 0;
}
else
{
lue.EditValue = null;
}
}
}
public static void loadDMXa(LookUpEdit lue, string tenHuyen, Boolean itemIndexFirst = true)
{
using (var context = new QL_HOIVIEN_KTEntities())
{
var dm = (from p in context.DM_XA
let huyen = p.DM_HUYEN
orderby p.XA_STT where huyen.HUYEN_TEN == tenHuyen
select p).ToList();
lue.Properties.DataSource = dm;
if (dm.Count > 0 && itemIndexFirst)
{
lue.ItemIndex = 0;
}
else
{
lue.EditValue = null;
}
}
}
private void _loadData()
{
WaitDialogForm _wait = new WaitDialogForm("Đang tải dữ liệu ...", "Vui lòng đợi giây lát");
context = new QL_HOIVIEN_KTEntities();
context.QL_HOIVIEN.Load();
int tuTuoi = Convert.ToInt32(seTuTuoi.EditValue);
int denTuoi = Convert.ToInt32(seDenTuoi.EditValue);
string strPhuong = luePhuong.EditValue + string.Empty;
string strQuan = lueQuan.EditValue + string.Empty;
string strThanhPho = lueThanhPho.EditValue + string.Empty;
var data = (from p in context.QL_HOIVIEN
where (strPhuong != "" ? p.HV_THUONGTRU_PHUONG == strPhuong : true) &&
(strQuan != "" ? p.HV_THUONGTRU_QUAN == strQuan : true) &&
(strThanhPho != "" ? p.HV_THUONGTRU_TP == strThanhPho : true) &&
tuTuoi <= p.HV_TUOI && p.HV_TUOI <= denTuoi &&
p.HV_TRE_DIHOC == chkLaTreDiHoc.Checked
select p).ToList();
rptBCHoiVien_NKTTheoTuoi rpt = new rptBCHoiVien_NKTTheoTuoi();
string tableName = "HOI_VIEN";
DataTable dataPrint = FunctionHelper.ConvertToDataTable(data);
dataPrint.TableName = tableName;
rpt.pLeftHeader.Value = clsParameter.pHospital;
rpt.pParentLeftHeader.Value = clsParameter.pParentHospital;
rpt.pTitleParent.Value = String.Format("TRẺ KHUYẾT TẬT TỪ {0} - {1} TUỔI ĐANG ĐI HỌC", seTuTuoi.Text, seDenTuoi.Text);
rpt.pTitle.Value = lueQuan.Text;
//rpt.pTitleFooter.Value = ReportHelper.getTitleFooter(LoaiBaoCao.BM10);
//rpt.pValueFooter.Value = ReportHelper.getValueFooter(LoaiBaoCao.BM10);
rpt.DataSource = dataPrint;
rpt.DataMember = tableName;
printControl.PrintingSystem = rpt.PrintingSystem;
rpt.CreateDocument(true);
rptGlobal = rpt;
_wait.Close();
}
private void frmTapHuanChonDiaDiem_Load(object sender, EventArgs e)
{
string[] hoivienIdList = selectIdList.Split(new[] { "; " }, StringSplitOptions.None);
WaitDialogForm _wait = new WaitDialogForm("Đang tải dữ liệu ...", "Vui lòng đợi giây lát");
QL_HOIVIEN_KTEntities context = new QL_HOIVIEN_KTEntities();
context.QL_HOATDONG_TAPHUAN_DIADIEM.Load();
var data = (from p in context.QL_HOATDONG_TAPHUAN_DIADIEM
group p by new { p.TH_DD_TEN, p.TH_DD_NGUOI_DAIDIEN, p.TH_DD_DIACHI } into g
select new clsSelectList
{
TH_DD_ID = g.Max(k => k.TH_DD_ID),
TH_DD_TEN = g.Key.TH_DD_TEN,
TH_DD_NGUOI_DAIDIEN = g.Key.TH_DD_NGUOI_DAIDIEN,
TH_DD_DIACHI = g.Key.TH_DD_DIACHI
}
).ToList();
gcGrid.DataSource = data;
_wait.Close();
}
private void btDangNhap_Click(object sender, EventArgs e)
{
_khoaQuyen = false;
if (txtPassOld.Text.Trim().Length == 0)
{
XtraMessageBox.Show("Vui lòng nhập mật khẩu cũ!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtPassOld.Focus();
return;
}
else if (txtPassNew.Text.Trim().Length == 0)
{
XtraMessageBox.Show("Vui lòng nhập mật khẩu mới!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtPassNew.Focus();
return;
}
else if (txtPassConfirm.Text != txtPassNew.Text)
{
XtraMessageBox.Show("Vui lòng xác nhận lại mật khẩu!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtPassConfirm.Focus();
return;
}
QL_HOIVIEN_KTEntities context = new QL_HOIVIEN_KTEntities();
var query = (from p in context.QL_USERS where p.USER_NAME == clsParameter._username && p.USER_PASS == txtPassOld.Text select p).FirstOrDefault();
if (query == null)
{
XtraMessageBox.Show("Mật khẩu cũ không chính xác!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtPassOld.Focus();
return;
}
query.USER_PASS = txtPassNew.Text;
context.SaveChanges();
XtraMessageBox.Show("Thay đổi mật khẩu thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
