private bool vSaveStudents(int vCheck)
{
boHocVien = new BO_HOCVIEN();
hocvien = new HOCVIEN();
hocvien.HOV_Code = txtStudentCode.Text;
hocvien.HOV_FirstName = txtFirstName.Text.Trim();
hocvien.HOV_LastName = txtLastName.Text.Trim();
hocvien.HOV_FullName = txtFirstName.Text.Trim() + " " + txtLastName.Text.Trim();
hocvien.HOV_BirthDay = txtBirthDay.Text;
hocvien.HOV_Address = txtAddress.Text;
hocvien.HOV_Phone = txtPhone.Text;
hocvien.HOV_GhiChu = memoRemarks.Text.Trim();
hocvien.HOV_QuocTich = txtQuocTich.Text.Trim();
hocvien.HOV_NoiSinh = lookUpBirthPlace.GetColumnValue("TIN_ID").ToString();
hocvien.HOV_DonVi = lookUpDonvi.GetColumnValue("DON_ID").ToString();
if (vCheck == 1)
{
gHocVienID = boHocVien.insert(hocvien);
flagSave = true;
}
else if (vCheck == 2)
{
//hocvien.HOV_ID = mIdStudents;
//boHocVien.update(hocvien);
////mIdStudents lấy lúc selectRow
//loadDataToGrid();
}
return(flagSave);
}
private DataSet vDsKetQuaHocTap()
{
tb = new DataTable();
boHv = new BO_HOCVIEN();
vDsBieuMau = new DsInBieuMau();
int vLopID = int.Parse(lookLop_InGCN.GetColumnValue("LOP_ID").ToString());
int vMonID = int.Parse(lookMonHoc.GetColumnValue("MON_ID").ToString());
int vLanThi = int.Parse(lookLanThi.GetColumnValue("DIE_LanThi").ToString());
tb = boHv.ExportExcel_DiemThi(vLopID, vMonID, vLanThi);
if (tb.Rows.Count > 0)
{
for (int i = 0; i < tb.Rows.Count; i++)
{
vRow = vDsBieuMau.DiemDanhHocVien.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["vLopName"] = lookLop_InGCN.GetColumnValue("LOP_Name").ToString();
vRow["vMonName"] = lookMonHoc.GetColumnValue("MON_Name").ToString();
vDsBieuMau.DiemDanhHocVien.Rows.Add(vRow);
}
}
return(vDsBieuMau);
}
private DataSet vDsDanhSachHocVien()
{
tb = new DataTable();
boHv = new BO_HOCVIEN();
vDsBieuMau = new DsInBieuMau();
int i;
tb = boHv.ExportExcel_DsHocVien_ByLopID(int.Parse(lookLop_InGCN.GetColumnValue("LOP_ID").ToString()));
if (tb.Rows.Count > 0)
{
for (i = 0; i < tb.Rows.Count; i++)
{
vRow = vDsBieuMau.DanhSachHocVien.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["HOV_Phone"] = tb.Rows[i]["HOV_Phone"].ToString();
vRow["HOV_ChucDanh"] = tb.Rows[i]["HOV_ChucDanh"].ToString();
vRow["DON_Name"] = tb.Rows[i]["DON_Name"].ToString();
vRow["DKH_BienLai"] = tb.Rows[i]["DKH_BienLai"].ToString();
vRow["HOV_GhiChu"] = tb.Rows[i]["HOV_GhiChu"].ToString();
vRow["vLopName"] = lookLop_InGCN.GetColumnValue("LOP_Name").ToString();
vDsBieuMau.DanhSachHocVien.Rows.Add(vRow);
}
}
return(vDsBieuMau);
}
private void loadDataByID()
{
boHv = new BO_HOCVIEN();
hocvien = new HOCVIEN();
hocvien.HOV_ID = sId = int.Parse(vRow["HOV_ID"].ToString());
try
{
boHv.getHocVienByID(hocvien);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void getHocVienCode()
{
boHv = new BO_HOCVIEN();
DataTable tb = new DataTable();
tb = boHv.get_HocCVien_LastCode();
string lCode = String.Empty;
string fCode = string.Empty;
lCode = tb.Rows[0]["HOV_Code"].ToString();
fCode = lCode.Substring(0, 7);
lCode = lCode.Substring(7, 1);
txtCode.Text = (fCode + (int.Parse(lCode.ToString()) + 1).ToString());
}
private void sResultSearchByFirstName()
{
boHv = new BO_HOCVIEN();
string fullName = string.Empty;
if (txtFirstName.Text != "")
{
fullName = txtFirstName.Text + " " + txtLastName.Text;
hvTable = boHv.searchHocVienByFullName(fullName);
gridStudents.DataSource = hvTable;
}
else
{
return;
}
}
private bool sSaveStudents(int sCheck)
{
hocvien = new HOCVIEN();
boHv = new BO_HOCVIEN();
hocvien.HOV_Code = txtStudentCode.Text;
hocvien.HOV_FirstName = txtFirstName.Text.Trim();
hocvien.HOV_LastName = txtLastName.Text.Trim();
hocvien.HOV_FullName = txtFirstName.Text.Trim() + " " + txtLastName.Text.Trim();
hocvien.HOV_BirthDay = txtBirthDay.Text;
hocvien.HOV_Address = txtAddress.Text;
hocvien.HOV_Phone = txtPhone.Text;
hocvien.HOV_GhiChu = memoRemarks.Text.Trim();
hocvien.HOV_QuocTich = txtQuocTich.Text.Trim();
if (lookUpBirthPlace.ItemIndex < 0)
{
MessageBox.Show("Chưa chọn nơi sinh", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
else
{
hocvien.HOV_NoiSinh = lookUpBirthPlace.GetColumnValue("TIN_ID").ToString();
}
if (lookUpDonvi.ItemIndex < 0)
{
MessageBox.Show("Chưa chọn đơn vị", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
else
{
hocvien.HOV_DonVi = lookUpDonvi.GetColumnValue("DON_ID").ToString();
}
if (sCheck == 1)
{
gIDHocVien = boHv.insert(hocvien);
flagSave = true;
}
else
if (sCheck == 2)
{
hocvien.HOV_ID = gIDHocVien;
boHv.update(hocvien);
loadDataToGrid();
}
return(flagSave);
}
private bool updateData()
{
hocvien = new HOCVIEN();
boHv = new BO_HOCVIEN();
hocvien.HOV_Code = txtCode.Text;
hocvien.HOV_FirstName = txtNameF.Text.Trim();
hocvien.HOV_LastName = txtNameL.Text.Trim();
hocvien.HOV_FullName = txtNameF.Text.Trim() + " " + txtNameL.Text.Trim();
hocvien.HOV_BirthDay = txtBirthDay.Text;
hocvien.HOV_Address = txtAddress.Text;
hocvien.HOV_Phone = txtFone.Text;
if (lookUpBirthPlace.ItemIndex < 0)
{
//sQueQuan = " ";
MessageBox.Show("Chưa chọn nơi sinh", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(vFlagSave);;
}
else
{
hocvien.HOV_NoiSinh = lookUpBirthPlace.GetColumnValue("TIN_ID").ToString();
}
if (lookUpDonvi.ItemIndex < 0)
{
MessageBox.Show("Chưa chọn đơn vị", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(vFlagSave);
}
else
{
hocvien.HOV_DonVi = lookUpDonvi.GetColumnValue("DON_ID").ToString();
}
hocvien.HOV_GhiChu = txtGhiChu.Text.Trim();
hocvien.HOV_QuocTich = txtQuocTich.Text.Trim();
hocvien.HOV_ID = sId;
try
{
boHv.update(hocvien);
vFlagSave = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
vFlagSave = false;
}
return(vFlagSave);
}
private void vCreateCode()
{
DataTable tb = new DataTable();
boHocVien = new BO_HOCVIEN();
tb = boHocVien.get_HocCVien_LastCode();
string hVCode = String.Empty;
if (tb.Rows.Count == 0)
{
hVCode = "000000";
}
else
{
hVCode = tb.Rows[0]["HOV_Code"].ToString();
hVCode = hVCode.Substring(3, 5);
}
txtStudentCode.Text = ("HOV" + Utilities.quydinh.LaySTT(int.Parse(hVCode.ToString()) + 1)).ToString();
}
private bool vCheckHocVienTonTai(string vString)
{
DataTable tbl = new DataTable();
boHocVien = new BO_HOCVIEN();
tbl = boHocVien.searchHocVienByFullName(vString);
if (tbl.Rows.Count > 0)
{
gridStudents.DataSource = tbl.DefaultView;
btnDangKiHvMoi.Enabled = false;
flagExitse = true;
}
else
{
gridStudents.DataSource = null;
btnDangKiHvMoi.Enabled = true;
flagExitse = false;
}
return(flagExitse);
}
