public async Task <IActionResult> UpdateHocVien(int id, [FromBody] HocVienDTO hocVienDTO) { var hocVien = hocVienDTO.ToEntity(); await _hocVienService.UpdateHocVien(hocVien); return(Ok(hocVien)); }
public static List<HocVienDTO> LayDanhSachHocVien_TenHocVien(string tenHocVien) { List<HocVienDTO> list = new List<HocVienDTO>(); try { List<SqlParameter> sqlParams = new List<SqlParameter>(); sqlParams.Add(new SqlParameter("@tenHocVien", tenHocVien)); DataTable dt = SqlDataAccessHelper.ExecuteQuery("spChonHocVienBangTenHocVien", sqlParams); foreach (DataRow dr in dt.Rows) { HocVienDTO emp = new HocVienDTO(); emp.maHocVien = dr["maHocVien"].ToString(); emp.tenHocVien = dr["tenHocVien"].ToString(); emp.ngaySinh = DateTime.Parse(dr["ngaySinh"].ToString()); emp.diaChi = dr["diaChi"].ToString(); emp.dienThoai = dr["dienThoai"].ToString(); emp.CMND = dr["CMND"].ToString(); list.Add(emp); } } catch (Exception ex) { throw ex; } return list; }
public async Task <IActionResult> CreateHocVien(HocVienDTO hocVienDTO) { var hocVien = hocVienDTO.ToEntity(); await _hocVienService.CreateHocVien(hocVien); return(Ok(hocVien)); }
public async Task <IActionResult> GetHocVienById(int id) { var hocVien = await _hocVienService.GetHocVienById(id); var result = HocVienDTO.FromEntity(hocVien); return(Ok(result)); }
private void btn_Check_Click(object sender, EventArgs e) { if (frmTimHV != null) { _TimChonHocVien = frmTimHV.HocVienDaChon; txt_MaHV.Text = _TimChonHocVien.MaHV; txt_HoTen.Text = _TimChonHocVien.HoTen; } }
public static bool GhiDanh(HocVienDTO hv, DangKyDTO dk) { try { return DangKyDAO.GhiDanh(hv, dk); } catch (Exception ex) { throw ex; } }
private void dgv_HocVien_SelectionChanged(object sender, EventArgs e) { if (dgv_HocVien.SelectedRows.Count > 0) { _HocVienDaChon = (HocVienDTO)dgv_HocVien.SelectedRows[0].DataBoundItem; } else { _HocVienDaChon = null; } BindingChiTietHocVien(); }
private void dgv_HocVien_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e) { DialogResult r = MessageBox.Show("Bạn muốn chọn học viên này?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (r == DialogResult.Yes) { _hvDaChon = (HocVienDTO)dgv_HocVien.SelectedRows[0].DataBoundItem; this.Dispose(); } else { _hvDaChon = null; } }
public List <HocVienDTO> tim_HocVienDAO(string HoTen) { List <HocVienDTO> lst_HocVien = new List <HocVienDTO>(); SqlConnection conn = DataProvider.TaoKetNoi(); string query = "Select * From HocVien HV Where HV.HoTen like '%" + HoTen + "%'"; SqlDataReader sdr = DataProvider.ThucHienTruyVan(query, conn); while (sdr.Read()) { HocVienDTO hv = new HocVienDTO(); hv.MaHV = sdr["MaHV"].ToString(); hv.HoTen = sdr["HoTen"].ToString(); hv.GioiTinh = (int)sdr["GioiTinh"]; hv.NgaySinh = (DateTime)sdr["NgaySinh"]; hv.Email = sdr["Email"].ToString(); hv.SDT = sdr["SDT"].ToString(); hv.DiaChi = sdr["DiaChi"].ToString(); hv.STT = (int)sdr["STT"]; lst_HocVien.Add(hv); } sdr.Close(); conn.Close(); return(lst_HocVien); }
public static bool GhiDanh(HocVienDTO hv, DangKyDTO dk) { bool result = false; try { List<SqlParameter> sqlParams = new List<SqlParameter>(); sqlParams.Add(new SqlParameter("@tenHocVien", hv.tenHocVien)); sqlParams.Add(new SqlParameter("@ngaySinh", hv.ngaySinh)); sqlParams.Add(new SqlParameter("@diaChi", hv.diaChi)); sqlParams.Add(new SqlParameter("@dienThoai", hv.dienThoai)); sqlParams.Add(new SqlParameter("@CMND", hv.CMND)); sqlParams.Add(new SqlParameter("@maLopMo", dk.maLopMo)); sqlParams.Add(new SqlParameter("@dongTien", dk.dongTien)); // Call Store Procedure int n = SqlDataAccessHelper.ExecuteNoneQuery("sp_GhiDanh", sqlParams); if (n == 1) result = true; } catch (Exception ex) { throw ex; } return result; }
private void btn_Luu_Click(object sender, EventArgs e) { switch (_chucnang) { case 1: #region Thêm Biên lai if (txt_MaBL.Text.Trim() == "" || txt_MaHV.Text.Trim() == "" || txt_TongTien.Text.Trim() == "") { MessageBox.Show("Vui lòng nhập đầy đủ dữ liệu", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { int r1, r2, r3; r1 = 0; r2 = 0; r3 = 0; r1 = _bienlaiBUS.insert_BienLaiBUS(txt_MaBL.Text, txt_MaHV.Text, double.Parse(txt_TongTien.Text), ucNhanVienKT.NhanVien, dtp_Ngaylap.Value); if (cbb_KhoaHoc1.SelectedValue.ToString() == cbb_KhoaHoc2.SelectedValue.ToString()) { MessageBox.Show("Vui lòng chọn 2 khóa học khác nhau", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Question); } else { if (cbb_KhoaHoc1.SelectedValue.ToString() != "0") { r2 = _bienlaiBUS.insert_ChiTietBienLaiBUS(txt_MaBL.Text, cbb_KhoaHoc1.SelectedValue.ToString(), _KhoaHocBUS.get_HocPhi(cbb_KhoaHoc1.SelectedValue.ToString())); } if (cbb_KhoaHoc2.SelectedValue.ToString() != "0") { r3 = _bienlaiBUS.insert_ChiTietBienLaiBUS(txt_MaBL.Text, cbb_KhoaHoc2.SelectedValue.ToString(), _KhoaHocBUS.get_HocPhi(cbb_KhoaHoc2.SelectedValue.ToString())); } if ((r1 > 0 && r2 > 0) || (r1 > 0 && r3 > 0)) { MessageBox.Show("Thêm thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); loadBienlai(); _TimChonHocVien = null; txt_MaBL.Enabled = false; txt_MaHV.Enabled = false; btn_OK.Enabled = false; txt_TongTien.Enabled = false; ucNhanVienKT.Enabled = false; dtp_Ngaylap.Enabled = false; cbb_KhoaHoc1.Enabled = false; cbb_KhoaHoc2.Enabled = false; } else { MessageBox.Show("Thêm thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } //_chucnang = 0; break; #endregion case 2: //_chucnang = 0; break; default: MessageBox.Show("Vui lòng chọn chức năng", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); break; } }