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); }