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