private void initComboboxSoHieuDoi(int vChungChiID)
{
int sCap = -1;
boCcc = new BO_CAP_CHUNGCHI();
if (lookKhoaHoc_InGCN.ItemIndex < 0)
{
MessageBox.Show("Chưa chọn chứng chỉ", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
if (radCapQ.SelectedIndex == 1)
{
sCap = 2;
}
else if (radCapQ.SelectedIndex == 2)
{
sCap = 3;
}
lookUpSoHieuDoi.Properties.DataSource = boCcc.get_SoHieuDoi_Cc(vChungChiID, sCap);
lookUpSoHieuDoi.Properties.ValueMember = "CCC_SoHieuDoi";
lookUpSoHieuDoi.Properties.DisplayMember = "CCC_SoHieuDoi";
}
}
private void updateIdDoiChungChiHocVien()
{
BO_CAP_CHUNGCHI bo = new BO_CAP_CHUNGCHI();
//1. Load list need update
DataTable vtb = new DataTable();
vtb = bo.ListNeedUpdate();
//2. Load list ID for update
DataTable vtb2 = new DataTable();
vtb2 = bo.ListForUpdate();
for (int i = 0; i < vtb.Rows.Count; i++)
{
for (int j = 0; j < vtb2.Rows.Count; j++)
{
if (int.Parse(vtb.Rows[i]["CCC_ID"].ToString()) == int.Parse(vtb2.Rows[j]["CCC_ID"].ToString()))
{
//3. Execute update
//string c = string.Empty;
bo.updateChungChiDoiIDToCapChungChi(int.Parse(vtb2.Rows[j]["DOI_ID"].ToString()));
}
}
}
}
private DataSet vDsDanhSachHocVienCapGCN()
{
tb = new DataTable();
boCcc = new BO_CAP_CHUNGCHI();
vDsBieuMau = new DsInBieuMau();
object vDateCapChungChi;
int vChungChiID = int.Parse(lookKhoaHoc_InGCN.GetColumnValue("CHC_ID").ToString());
int vLopID = int.Parse(lookLop_InGCN.GetColumnValue("LOP_ID").ToString());
tb = boCcc.ExportExcel_DsHV_DuocCapCC(vChungChiID, vLopID);
if (tb.Rows.Count > 0)
{
for (int i = 0; i < tb.Rows.Count; i++)
{
vRow = vDsBieuMau.DsHvDuocCapGCN.NewRow();
vRow["STT"] = i + 1;
vRow["HOV_FirstName"] = tb.Rows[i]["HOV_FirstName"].ToString();
vRow["HOV_LastName"] = tb.Rows[i]["HOV_LastName"].ToString();
vRow["HOV_BirthDay"] = tb.Rows[i]["HOV_BirthDay"].ToString();
vRow["TIN_Name"] = tb.Rows[i]["TIN_Name"].ToString();
vRow["DON_Name"] = tb.Rows[i]["DON_Name"].ToString();
vRow["CCC_SoCC"] = tb.Rows[i]["CCC_SoCC"].ToString();
vDateCapChungChi = DateTime.Parse(tb.Rows[i]["CCC_NgayCap"].ToString());
vRow["CCC_NgayCap"] = string.Format("{0:dd/MM/yyyy}", vDateCapChungChi).ToString().Substring(0, 10);
vRow["vLopName"] = lookLop_InGCN.GetColumnValue("LOP_Name").ToString();
vDsBieuMau.DsHvDuocCapGCN.Rows.Add(vRow);
}
}
return(vDsBieuMau);
}
private DataTable loadDataToGrid()
{
boCapcc = new BO_CAP_CHUNGCHI();
mtbl = new DataTable();
if (vCheckLopDaCapCC())
{
mtbl = boCapcc.vCheckLopDaCapCcByLopMonID(sLopID, sMonID, sLanThi);
gridEntryCoures.DataSource = mtbl;
ArrayList aDiem = new ArrayList();
for (int i = 0; i < mtbl.Rows.Count; i++)
{
aDiem.Add(mtbl.Rows[i]["DIE_Diem"]);
mAraayDiem.Add(aDiem);
}
}
else
{
mtbl = boDiem.select_Diem_by_Lop_Mon(sLopID, sMonID, sLanThi);
gridEntryCoures.DataSource = mtbl;
ArrayList aDiem = new ArrayList();
for (int i = 0; i < mtbl.Rows.Count; i++)
{
aDiem.Add(mtbl.Rows[i]["DIE_Diem"]);
mAraayDiem.Add(aDiem);
}
}
return(mtbl);
}
private DataSet vDsThongKeCapGCN()
{
boCapChungChi = new BO_CAP_CHUNGCHI();
tbl = new DataTable();
_vDsThongKeCapGCN = new BcChungChi();
object vDateCapChungChi;
if (lookKhoaHoc_InGCN.ItemIndex > -1 && lookKhoaHoc_InGCN.Enabled == true)
{
vChcID = int.Parse(lookKhoaHoc_InGCN.GetColumnValue("CHC_ID").ToString());
tbl = boCapChungChi.vLoadDataCapChungChiByCHCID(vChcID, dateFrom.DateTime, dateEnd.DateTime);
}
else
{
tbl = boCapChungChi.vLoadDataCapChungChiByDate(dateFrom.DateTime, dateEnd.DateTime);
}
if (tbl.Rows.Count > 0)
{
for (int i = 0; i < tbl.Rows.Count; i++)
{
vRow = _vDsThongKeCapGCN.TkCapGCN.NewRow();
vRow["STT"] = i + 1;
vRow["CHC_Name"] = tbl.Rows[i]["CHC_Name"];
vRow["HOV_FirstName"] = tbl.Rows[i]["HOV_FullName"];
vRow["HOV_LastName"] = tbl.Rows[i]["HOV_LastName"];
vRow["HOV_BirthDay"] = tbl.Rows[i]["HOV_BirthDay"];
vRow["TIN_Name"] = tbl.Rows[i]["TIN_Name"];
vRow["CCC_SoCC"] = tbl.Rows[i]["CCC_SoCC"];
vRow["IMG_Image"] = tbl.Rows[i]["IMG_Image"];
if (int.Parse(tbl.Rows[i]["CCC_LOPID"].ToString()) > -1)
{
vRow["LOP_ShortName"] = tbl.Rows[i]["LOP_ShortName"];
}
else
{
vRow["LOP_ShortName"] = tbl.Rows[i]["CCC_SoHieuDoi"];
}
if (int.Parse(tbl.Rows[i]["CCC_Status"].ToString()) == 1)
{
vRow["CCC_StatusCap"] = "Cấp mới";
}
else if (int.Parse(tbl.Rows[i]["CCC_Status"].ToString()) == 2)
{
vRow["CCC_StatusCap"] = "Cấp lại";
}
else
{
vRow["CCC_StatusCap"] = "Cấp đổi";
}
vDateCapChungChi = DateTime.Parse(tbl.Rows[i]["CCC_NgayCap"].ToString());
vRow["CCC_NgayCap"] = string.Format("{0:dd/MM/yyyy}", vDateCapChungChi).ToString().Substring(0, 10);
vRow["fromDate"] = dateFrom.DateTime.ToShortDateString();
vRow["toDate"] = dateEnd.DateTime.ToShortDateString();
_vDsThongKeCapGCN.TkCapGCN.Rows.Add(vRow);
}
}
return(_vDsThongKeCapGCN);
}
private void initThongKe()
{
int _nhomCcID = 0;
string _nhomCcName = string.Empty;
DataTable tblChungChi = new DataTable();
lop = new BO_LOP();
boCapChungChi = new BO_CAP_CHUNGCHI();
_vDsThongKeCapGCN = new BcChungChi();
int _ChcID = -1;
if (lookupNhomCc.ItemIndex > -1 && lookupNhomCc.Enabled == true)
{
_nhomCcID = int.Parse(lookupNhomCc.GetColumnValue("LOA_ID").ToString());
_nhomCcName = lookupNhomCc.Text;
if (lookChungChiTK.ItemIndex > -1 && lookChungChiTK.Enabled == true)
{
_ChcID = int.Parse(lookChungChiTK.GetColumnValue("CHC_ID").ToString());
tblChungChi = lop.getChungChiThongKeWithCcID(dateFrom.DateTime, dateEnd.DateTime, _nhomCcID, _ChcID);
initDataSetThongKeCapGCN(tblChungChi, _nhomCcName);
}
else
{
tblChungChi = lop.getChungChiThongKe(dateFrom.DateTime, dateEnd.DateTime, _nhomCcID);
initDataSetThongKeCapGCN(tblChungChi, _nhomCcName);
}
}
else
{
for (int iNhomCc = 0; iNhomCc < tblNhomChungChi.Rows.Count; iNhomCc++)
{
_nhomCcID = int.Parse(tblNhomChungChi.Rows[iNhomCc]["LOA_ID"].ToString());
_nhomCcName = tblNhomChungChi.Rows[iNhomCc]["LOA_Name"].ToString();
tblChungChi = lop.getChungChiThongKe(dateFrom.DateTime, dateEnd.DateTime, _nhomCcID);
initDataSetThongKeCapGCN(tblChungChi, _nhomCcName);
}
}
rpThongKeCapGCN rpt = new rpThongKeCapGCN();
rpt.SetDataSource(_vDsThongKeCapGCN.Tables["ThongKeCapChungChi"]);
rpt.SetParameterValue("_fromDate", dateFrom.Text);
rpt.SetParameterValue("_toDate", dateEnd.Text);
rpt.SetParameterValue("_SumCapDoi", _SumCapDoi.ToString("#,##0"));
rpt.SetParameterValue("_SumCapMoi", _SumCapMoi.ToString("#,##0"));
rpt.SetParameterValue("_SumCapLai", _SumCapLai.ToString("#,##0"));
rpt.SetParameterValue("_SumTotal", _SumTotal.ToString("#,##0"));
crytalThongKe.ReportSource = rpt;
crytalThongKe.ToolPanelView = ToolPanelViewType.None;
_SumCapDoi = 0;
_SumCapMoi = 0;
_SumCapLai = 0;
_SumTotal = 0;
}
private void vLoadDataThongKeWithRadCap(int vStatusCap)
{
boCapChungChi = new BO_CAP_CHUNGCHI();
tbl = new DataTable();
if (lookKhoaHoc_InGCN.ItemIndex > -1)
{
vChcID = int.Parse(lookKhoaHoc_InGCN.GetColumnValue("CHC_ID").ToString());
tbl = boCapChungChi.vLoadDataCapChungChiByChcIDWithStatus(vStatusCap, vChcID, dateFrom.DateTime, dateEnd.DateTime);
}
else
{
tbl = boCapChungChi.vLoadDataCapChungChiByDateWithStatus(vStatusCap, dateFrom.DateTime, dateEnd.DateTime);
}
}
private DataSet vDsSoTheoDoiCapGCN()
{
tb = new DataTable();
boCcc = new BO_CAP_CHUNGCHI();
vDsBieuMau = new DsInBieuMau();
object vDateCapChungChi;
int vLopID = int.Parse(lookLop_InGCN.GetColumnValue("LOP_ID").ToString());
int vChungChiID = int.Parse(lookKhoaHoc_InGCN.GetColumnValue("CHC_ID").ToString());
tb = boCcc.ExportExcel_Phat_CHUNGCHI(vChungChiID, vLopID);
if (tb.Rows.Count > 0)
{
for (int i = 0; i < tb.Rows.Count; i++)
{
vRow = vDsBieuMau.SoTheoDoiCapGCN.NewRow();
vRow["STT"] = i + 1;
//vRow["HOV_FirstName"] = tb.Rows[i]["HOV_FirstName"].ToString();
vRow["HOV_FirstName"] = tb.Rows[i]["HOV_FullName"].ToString();
vRow["HOV_LastName"] = tb.Rows[i]["HOV_LastName"].ToString();
vRow["HOV_BirthDay"] = tb.Rows[i]["HOV_BirthDay"].ToString();
vRow["IMG_Image"] = tb.Rows[i]["IMG_Image"];
//vRow["DON_Name"] = tb.Rows[i]["DON_Name"].ToString();
vRow["CCC_SoCC"] = tb.Rows[i]["CCC_SoCC"].ToString();
vDateCapChungChi = DateTime.Parse(tb.Rows[i]["CCC_NgayCap"].ToString());
vRow["CCC_NgayCap"] = string.Format("{0:dd/MM/yyyy}", vDateCapChungChi).ToString().Substring(0, 10);
//int status = int.Parse(tb.Rows[i]["CCC_Status"].ToString());
//if (status == 1)
//{
// vRow["CCC_Status"] = "Cấp mới";// "Khóa " + tb.Rows[i]["LOP_Khoa"].ToString();
//}
//else if (status == 2)
//{
// vRow["CCC_Status"] = " Gia hạn";
//}
//else if (status == 3)
//{
// vRow["CCC_Status"] = " Đổi";
//}
vRow["CCC_Status"] = "Cấp mới";
vRow["vChungChiName"] = lookKhoaHoc_InGCN.GetColumnValue("CHC_Name").ToString() + " - Khóa: " + tb.Rows[i]["LOP_Khoa"].ToString();;
vDsBieuMau.SoTheoDoiCapGCN.Rows.Add(vRow);
}
}
return(vDsBieuMau);
}
private void gridStudentContent_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e)
{
//MessageBox.Show(e.RowHandle.ToString());
//int Ma_HocVien = Convert.ToInt32(gridStudentContent.GetRowCellValue(e.RowHandle, "HOV_ID"));
if (table_cap_chung_chi.Rows.Count > 0)
{
int Ma_HocVien = Convert.ToInt32(table_cap_chung_chi.Rows[e.RowHandle]["HOV_ID"]);
BO_DANG_KI_HOC bo_dangki_hoc = new BO_DANG_KI_HOC();
gridMarks.DataSource = bo_dangki_hoc.getDANG_KI_HOC_By_HocVien_ID(Ma_HocVien);
BO_CAP_CHUNGCHI bo_cap_chungchi = new BO_CAP_CHUNGCHI();
gridTeached.DataSource = bo_cap_chungchi.getCAP_CHUNG_CHI_By_HocVienID(Ma_HocVien);
#region left panel info
txtStudentName.Text = table_cap_chung_chi.Rows[e.RowHandle]["FirstName"].ToString() + table_cap_chung_chi.Rows[e.RowHandle]["LastName"].ToString();
dateBirthDay.DateTime = Convert.ToDateTime(table_cap_chung_chi.Rows[e.RowHandle]["BirthDay"].ToString());
txtCerNumber.Text = table_cap_chung_chi.Rows[e.RowHandle]["SoCC"].ToString();
//dateAllocate.DateTime = Convert.ToDateTime(table_cap_chung_chi.Rows[e.RowHandle]["BirthDay"].ToString());
//dateExpire.DateTime = Convert.ToDateTime(table_cap_chung_chi.Rows[e.RowHandle]["BirthDay"].ToString());
checkDate();
#endregion
}
}
/// <summary>
/// Creates the data table with some dummy data.
/// </summary>
/// <returns>DataTable</returns>
private static DataTable CreateDataTable()
{
DataTable dt = new DataTable();
//for (int i = 0; i < 10; i++)
//{
// dt.Columns.Add(i.ToString());
//}
//for (int i = 0; i < 10; i++)
//{
// DataRow dr = dt.NewRow();
// foreach (DataColumn dc in dt.Columns)
// {
// dr[dc.ToString()] = i;
// }
// dt.Rows.Add(dr);
//}
BO_CAP_CHUNGCHI ccc = new BO_CAP_CHUNGCHI();
return(dt = ccc.getCAP_CHUNGCHI_WithName());
}
private DataSet vDsSanhSachHocVienCapGCNDoi()
{
tb = new DataTable();
boCcc = new BO_CAP_CHUNGCHI();
vDsBieuMau = new DsInBieuMau();
object vDateCapChungChi;
int vChungChiID = int.Parse(lookKhoaHoc_InGCN.GetColumnValue("CHC_ID").ToString());
int sCap = -1;
if (radCapQ.SelectedIndex == 1)
{
sCap = 2;
}
else
if (radCapQ.SelectedIndex == 2)
{
sCap = 3;
}
tb = boCcc.ExportExcel_DsHV_DuocCapCC_Doi(vChungChiID, sCap, lookUpSoHieuDoi.Text);
if (tb.Rows.Count > 0)
{
for (int i = 0; i < tb.Rows.Count; i++)
{
vRow = vDsBieuMau.DsHvDuocCapGCN.NewRow();
vRow["STT"] = i + 1;
vRow["HOV_FirstName"] = tb.Rows[i]["HOV_FirstName"].ToString();
vRow["HOV_LastName"] = tb.Rows[i]["HOV_LastName"].ToString();
vRow["HOV_BirthDay"] = tb.Rows[i]["HOV_BirthDay"].ToString();
vRow["TIN_Name"] = tb.Rows[i]["TIN_Name"].ToString();
vRow["DON_Name"] = tb.Rows[i]["DON_Name"].ToString();
vRow["CCC_SoCC"] = tb.Rows[i]["CCC_SoCC"].ToString();
vDateCapChungChi = DateTime.Parse(tb.Rows[i]["CCC_NgayCap"].ToString());
vRow["CCC_NgayCap"] = string.Format("{0:dd/MM/yyyy}", vDateCapChungChi).ToString().Substring(0, 10);
vRow["vLopName"] = lookKhoaHoc_InGCN.GetColumnValue("CHC_Name").ToString();
vDsBieuMau.DsHvDuocCapGCN.Rows.Add(vRow);
}
}
return(vDsBieuMau);
}
private DataSet vDsSoTheoDoiCapGCNDoi()
{
tb = new DataTable();
boCcc = new BO_CAP_CHUNGCHI();
vDsBieuMau = new DsInBieuMau();
object vDateCapChungChi;
string vSoHieuDoi = lookUpSoHieuDoi.Text;
int vChungChiID = int.Parse(lookKhoaHoc_InGCN.GetColumnValue("CHC_ID").ToString());
int sCap = -1;
if (radCapQ.SelectedIndex == 1)
{
sCap = 2;
}
else if (radCapQ.SelectedIndex == 2)
{
sCap = 3;
}
tb = boCcc.ExportExcel_Phat_Doi_CHUNGCHI(vChungChiID, sCap, vSoHieuDoi);
if (tb.Rows.Count > 0)
{
for (int i = 0; i < tb.Rows.Count; i++)
{
vRow = vDsBieuMau.SoTheoDoiCapGCN.NewRow();
vRow["STT"] = i + 1;
vRow["HOV_FirstName"] = tb.Rows[i]["HOV_FullName"].ToString();
vRow["HOV_LastName"] = tb.Rows[i]["HOV_LastName"].ToString();
vRow["HOV_BirthDay"] = tb.Rows[i]["HOV_BirthDay"].ToString();
vRow["IMG_Image"] = tb.Rows[i]["IMG_Image"];
vRow["CCC_SoCC"] = tb.Rows[i]["CCC_SoCC"].ToString();
vDateCapChungChi = DateTime.Parse(tb.Rows[i]["CCC_NgayCap"].ToString());
vRow["CCC_NgayCap"] = string.Format("{0:dd/MM/yyyy}", vDateCapChungChi).ToString().Substring(0, 10);
int status = int.Parse(tb.Rows[i]["CCC_Status"].ToString());
if (status == 2)
{
vRow["CCC_Status"] = " Gia hạn";
vSoHieuDoi = "Số hiệu gia hạn: " + vSoHieuDoi;
}
else if (status == 3)
{
vRow["CCC_Status"] = " Đổi";
vSoHieuDoi = "Số hiệu đổi: " + vSoHieuDoi;
}
//if (status == 1)
//{
// vRow["CCC_Status"] = "Khóa " + tb.Rows[i]["LOP_Khoa"].ToString();
//}
//else if (status == 2)
//{
// vRow["CCC_Status"] = " Gia hạn";
//}
//else if (status == 3)
//{
// vRow["CCC_Status"] = " Đổi";
//}
vRow["vChungChiName"] = lookKhoaHoc_InGCN.GetColumnValue("CHC_Name").ToString() + " - " + vSoHieuDoi;
vDsBieuMau.SoTheoDoiCapGCN.Rows.Add(vRow);
}
}
return(vDsBieuMau);
}
private void btnSave_Click(object sender, EventArgs e)
{
boCapcc = new BO_CAP_CHUNGCHI();
dtoCapCc = new CAP_CHUNGCHI();
boDiem = new BO_DIEM();
dtoDiem = new DIEM();
DataTable tb = new DataTable();
tb = (DataTable)gridEntryCoures.DataSource;
for (int i = 0; i < tb.Rows.Count; i++)
{
dtoDiem.DIE_ID = int.Parse(tb.Rows[i]["DIE_ID"].ToString());
// De phong khi chua nhap diem ma bam luu.
if (tb.Rows[i]["DIE_Diem"].ToString() == "")
{
dtoDiem.DIE_Diem = 0;
}
else
{
dtoDiem.DIE_Diem = int.Parse(tb.Rows[i]["DIE_Diem"].ToString());
}
dtoDiem.DIE_LanThi = int.Parse(lookLanThi.Text.ToString());
dtoDiem.DIE_NgayNhapDiem = dateEntryScores.DateTime;
if (dtoDiem.DIE_LanThi == 1)
{
if (dtoDiem.DIE_Diem > 4)
{
// Neu diem > 4 -> Hoc vien da vuot qua ki thi lan 1
boDiem.update_DiemThi_Into_DIEM(dtoDiem);
}
else
{
// Neu diem < 5 -> Hoc vien phai thi lai lan 2 -> Update lan thi moi cho hoc vien
dtoDiem.DIE_LanThi++;
boDiem.update_DiemThi_Into_DIEM(dtoDiem);
}
}
else
{
//Update diem lan thi thu n
if (dtoDiem.DIE_Diem > 4)
{
// Neu diem > 4 -> Hoc vien da vuot qua ki thi lan 1
boDiem.update_DiemThi_Into_DIEM(dtoDiem);
}
else
{
// Neu diem < 5 -> Hoc vien phai thi lai lan 2 -> Update lan thi moi cho hoc vien
dtoDiem.DIE_LanThi++;
boDiem.update_DiemThi_Into_DIEM(dtoDiem);
}
}
if (vCheckLopDaCapCC())
{
if (dtoDiem.DIE_Diem > 4)
{
// Neu diem > 4 -> Hoc vien da vuot qua ki thi lan 1
boDiem.update_DiemThi_Into_DIEM(dtoDiem);
}
else
{
// Neu diem < 5 -> Hoc vien phai thi lai lan 2 -> Update lan thi moi cho hoc vien
dtoDiem.DIE_LanThi++;
boDiem.update_DiemThi_Into_DIEM(dtoDiem);
//Trong truong hop da cap chung chi roi ma sua lai diem nho hon 5 cập nhật số chứng chỉ về null
// Sau khi nhap lai diem >5 thi cap lai so chung chi
dtoCapCc.CCC_ID = int.Parse(tb.Rows[i]["CCC_ID"].ToString());
dtoCapCc.CCC_HOVID = int.Parse(tb.Rows[i]["HOV_ID"].ToString());
dtoCapCc.CCC_LOPID = int.Parse(lookUpLop.GetColumnValue("LOP_ID").ToString());
dtoCapCc.CCC_SoCC = string.Empty;
dtoCapCc.CCC_NgayCap = null;
dtoCapCc.CCC_NgayHetHan = null;
boCapcc.update_SoCc(dtoCapCc);
}
}
}
MessageBox.Show("Nhập điểm thành công", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Information);
sLoadLanThi();
}