private void gvGrid_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e)
{
idRowSelected = Convert.ToInt64(gvGrid.GetFocusedRowCellValue(colTH_CT_ID));
QL_HOATDONG_TAPHUAN_CHITIET item = gvGrid.GetFocusedRow() as QL_HOATDONG_TAPHUAN_CHITIET;
_bindingData(item);
}
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_TAPHUAN_CHITIET item;
switch (_formStatus)
{
case EnumFormStatus.ADD:
item = new QL_HOATDONG_TAPHUAN_CHITIET();
_setObjectEntities(ref item);
idRowSelected = _maxID();
item.TH_CT_ID = idRowSelected;
data.Add(item);
break;
case EnumFormStatus.MODIFY:
Int64 id = Convert.ToInt64(gvGrid.GetFocusedRowCellValue(colTH_CT_ID));
item = (from p in data where p.TH_CT_ID == id select p).FirstOrDefault();
if (item != null)
{
_setObjectEntities(ref item);
}
data.Where(p => p.TH_CT_ID == id).ToList().ForEach(p => p = item);
break;
case EnumFormStatus.DELETE:
Int64 deleteId = Convert.ToInt64(gvGrid.GetFocusedRowCellValue(colTH_CT_ID));
item = (from p in data where p.TH_CT_ID == deleteId select p).FirstOrDefault();
if (item != null)
{
if (item.TH_ID == null) //Nếu là dòng mới thì xóa luôn
{
data.Remove(item);
}
else
{
data.Where(p => p.TH_CT_ID == deleteId).ToList().ForEach(p => p.TH_ID = -1);
}
}
break;
default:
break;
}
_context.SaveChanges();
}
FormStatus = EnumFormStatus.VIEW;
_wait.Close();
}
}
void _selectData()
{
WaitDialogForm _wait = new WaitDialogForm("Đang tải dữ liệu ...", "Vui lòng đợi giây lát");
gcGrid.DataSource = data.Where(p => p.TH_ID != constIdDeleted);
_setFocusedRow();
QL_HOATDONG_TAPHUAN_CHITIET item = gvGrid.GetFocusedRow() as QL_HOATDONG_TAPHUAN_CHITIET;
_bindingData(item);
_wait.Close();
}
void _bindingData(QL_HOATDONG_TAPHUAN_CHITIET item)
{
_clearData();
if (item != null)
{
txtHo.Text = item.TH_CT_HO;
txtTen.Text = item.TH_CT_TEN;
txtChucVu.Text = item.TH_CT_CHUCVU;
lueGioiTinh.EditValue = item.TH_CT_GIOITINH;
txtEmail.Text = item.TH_CT_EMAIL;
txtFace.Text = item.TH_CT_FACEBOOK;
txtCMND.Text = item.TH_CT_CMND_SO;
if (item.TH_CT_CMND_NGAYCAP.HasValue)
{
deNgayCap_Ngay.EditValue = item.TH_CT_CMND_NGAYCAP.Value.Day;
deNgayCap_Thang.EditValue = item.TH_CT_CMND_NGAYCAP.Value.Month;
deNgayCap_Nam.EditValue = item.TH_CT_CMND_NGAYCAP.Value.Year;
}
lueDoiTuong.EditValue = item.TH_CT_DOITUONG;
lueDangTat.EditValue = item.TH_CT_DANGTAT + string.Empty;
lueDangTat.RefreshEditValue();
txtNoiCap.Text = item.TH_CT_CMND_NOICAP;
txtDiaChi.Text = item.TH_CT_DIACHI;
txtSoDienThoai.Text = item.TH_CT_SDT;
txtMaSoThue.Text = item.TH_CT_MASOTHUE;
txtSTK.Text = item.TH_CT_TK_SO;
txtTenNganHang.Text = item.TH_CT_TK_NGANHANG;
txtDiaChiNganHang.Text = item.TH_CT_TK_DIACHI;
txtDonVi_Ten.Text = item.TH_CT_DONVI_TEN;
txtDonVi_SDT.EditValue = item.TH_CT_DONVI_SDT;
txtDonVi_DiaChi.EditValue = item.TH_CT_DONVI_DIACHI;
txtLinkTOR.Text = item.TH_CT_LINK_TOR;
txtLinkCV.Text = item.TH_CT_LINK_CV;
txtLinkHopDong.EditValue = item.TH_CT_LINK_HOPDONG;
txtLinkBanCamKet.EditValue = item.TH_CT_LINK_BANCAMKET;
/*
* TH_CT_CHIPHI_1 : Chuẩn bị tài liệu
* TH_CT_CHIPHI_2 : Tổ chức tập huấn
* TH_CT_CHIPHI_3 : Báo cáo
* TH_CT_CHIPHI_4 : Sinh hoạt phí
*/
seThuLao_1.EditValue = item.TH_CT_CHIPHI_1;
seThuLao_2.EditValue = item.TH_CT_CHIPHI_2;
seThuLao_3.EditValue = item.TH_CT_CHIPHI_3;
seThuLao_4.EditValue = item.TH_CT_CHIPHI_4;
}
}
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 _setObjectEntities(ref QL_HOATDONG_TAPHUAN_CHITIET item)
{
item.TH_CT_LOAI = _loai_id;
item.TH_CT_HO = txtHo.Text;
item.TH_CT_TEN = txtTen.Text;
item.TH_CT_CHUCVU = txtChucVu.Text;
item.TH_CT_GIOITINH = lueGioiTinh.EditValue + string.Empty;
item.TH_CT_DOITUONG = lueDoiTuong.Ex_EditValueToInt();
item.TH_CT_DANGTAT = lueDangTat.EditValue + string.Empty;
item.TH_CT_EMAIL = txtEmail.Text;
item.TH_CT_FACEBOOK = txtFace.Text;
item.TH_CT_CMND_SO = txtCMND.Text;
if (deNgayCap_Nam.EditValue != null)
{
item.TH_CT_CMND_NGAYCAP = new DateTime(deNgayCap_Nam.Ex_EditValueToInt() ?? 1, deNgayCap_Thang.Ex_EditValueToInt() ?? 1, deNgayCap_Ngay.Ex_EditValueToInt() ?? 0);
}
item.TH_CT_CMND_NOICAP = txtNoiCap.Text;
item.TH_CT_DIACHI = txtDiaChi.Text;
item.TH_CT_MASOTHUE = txtMaSoThue.Text;
item.TH_CT_TK_SO = txtSTK.Text;
item.TH_CT_TK_NGANHANG = txtTenNganHang.Text;
item.TH_CT_TK_DIACHI = txtDiaChiNganHang.Text;
item.TH_CT_DONVI_TEN = txtDonVi_Ten.Text;
item.TH_CT_DONVI_DIACHI = txtDonVi_DiaChi.Text;
item.TH_CT_DONVI_SDT = txtDonVi_SDT.Text;
item.TH_CT_SDT = txtSoDienThoai.Text;
item.TH_CT_LINK_TOR = txtLinkTOR.Text;
item.TH_CT_LINK_CV = txtLinkCV.Text;
item.TH_CT_LINK_HOPDONG = txtLinkHopDong.Text;
item.TH_CT_LINK_BANCAMKET = txtLinkBanCamKet.Text;
/*
* TH_CT_CHIPHI_1 : Chuẩn bị tài liệu
* TH_CT_CHIPHI_2 : Tổ chức tập huấn
* TH_CT_CHIPHI_3 : Báo cáo
* TH_CT_CHIPHI_4 : Sinh hoạt phí
*/
item.TH_CT_CHIPHI_1 = seThuLao_1.Ex_EditValueToInt();
item.TH_CT_CHIPHI_2 = seThuLao_2.Ex_EditValueToInt();
item.TH_CT_CHIPHI_3 = seThuLao_3.Ex_EditValueToInt();
item.TH_CT_CHIPHI_4 = seThuLao_4.Ex_EditValueToInt();
}
