public List <DETHIDTO> LayDanhSachBoDeThi() { try { List <DETHIDTO> lstKQ = new List <DETHIDTO>(); SqlConnection connection = ConnectDB(); SqlCommand cmd = new SqlCommand("sp_LayDanhSachBoDeThi", connection); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { DETHIDTO d = new DETHIDTO(); d.MABDT = (long)rdr["MABDT"]; d.TENBDT = (string)rdr["TENBDT"]; d.HOCKY = (int)rdr["HOCKY"]; d.NAMHOC = (int)rdr["NAMHOC"]; d.MAGVTAO = (long)rdr["MAGVTAO"]; d.MAMH = (long)rdr["MAMH"]; d.TENMH = (string)rdr["TENMH"]; lstKQ.Add(d); } return(lstKQ); } catch (Exception e) { throw e; } }
public bool CapNhatBoDeThi(DETHIDTO d) { try { SqlConnection connection = ConnectDB(); SqlCommand cmd = new SqlCommand("sp_CapNhatBoDeThi", connection); cmd.CommandType = CommandType.StoredProcedure; SqlParameter sParam_maBoDeThi = cmd.Parameters.Add("@MaBDT", SqlDbType.BigInt); sParam_maBoDeThi.Direction = ParameterDirection.Input; sParam_maBoDeThi.Value = d.MABDT; SqlParameter sParam_tenBoDeThi = cmd.Parameters.Add("@TenBoDeThi", SqlDbType.NVarChar, 255); sParam_tenBoDeThi.Direction = ParameterDirection.Input; sParam_tenBoDeThi.Value = d.TENBDT; SqlParameter sParam_hocKy = cmd.Parameters.Add("@HocKy", SqlDbType.Int); sParam_hocKy.Direction = ParameterDirection.Input; sParam_hocKy.Value = d.HOCKY; SqlParameter sParam_namHoc = cmd.Parameters.Add("@NamHoc", SqlDbType.Int); sParam_namHoc.Direction = ParameterDirection.Input; sParam_namHoc.Value = d.NAMHOC; SqlParameter sParam_ketQua = cmd.Parameters.Add("@Return", SqlDbType.Bit); sParam_ketQua.Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); connection.Close(); if ((bool)sParam_ketQua.Value == true) { return(true); } else { return(false); } } catch (Exception e) { throw e; } }
private void btnTao_Click(object sender, EventArgs e) { long maMonHoc = ((MONHOCDTO)cboMonHoc.SelectedItem).MAMONHOC; DETHIDTO d = new DETHIDTO(0, txtTenDeThi.Text.TrimEnd(), Convert.ToInt32(txtHocKy.Value), Convert.ToInt32(txtNamHoc.Value), Common.MaNguoiDungDangNhap, maMonHoc, ""); int rs = DETHIBUS.ThemBoDeThi(d); if (rs == 1) { LayDanhSachBoDeThi(); } else if (rs == 2) { MessageBox.Show("Đã tồn tại tên bộ đề thi trong hệ thống. Thêm bộ đề thi thất bại"); } else { MessageBox.Show("Thêm bộ đề thi thất bại"); } }
public int ThemBoDeThi(DETHIDTO d) { try { SqlConnection connection = ConnectDB(); SqlCommand cmd = new SqlCommand("sp_TaoBoDeThi", connection); cmd.CommandType = CommandType.StoredProcedure; SqlParameter sParam_tenBoDeThi = cmd.Parameters.Add("@TenBoDeThi", SqlDbType.NVarChar, 255); sParam_tenBoDeThi.Direction = ParameterDirection.Input; sParam_tenBoDeThi.Value = d.TENBDT; SqlParameter sParam_hocKy = cmd.Parameters.Add("@HocKy", SqlDbType.Int); sParam_hocKy.Direction = ParameterDirection.Input; sParam_hocKy.Value = d.HOCKY; SqlParameter sParam_namHoc = cmd.Parameters.Add("@NamHoc", SqlDbType.Int); sParam_namHoc.Direction = ParameterDirection.Input; sParam_namHoc.Value = d.NAMHOC; SqlParameter sParam_magv = cmd.Parameters.Add("@MaGvTao", SqlDbType.BigInt); sParam_magv.Direction = ParameterDirection.Input; sParam_magv.Value = d.MAGVTAO; SqlParameter sParam_mamh = cmd.Parameters.Add("@MaMonHoc", SqlDbType.BigInt); sParam_mamh.Direction = ParameterDirection.Input; sParam_mamh.Value = d.MAMH; SqlParameter sParam_ketQua = cmd.Parameters.Add("@Return", SqlDbType.Int); sParam_ketQua.Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); connection.Close(); return((int)sParam_ketQua.Value); } catch (Exception e) { throw e; } }
private void btnCapNhat_Click(object sender, EventArgs e) { if (dgvDeThi.SelectedRows.Count < 1) { MessageBox.Show("Vui lòng chọn 1 đề thi cần cập nhật"); return; } int selectedIndex = dgvDeThi.SelectedRows[0].Index; long maDeThi = Convert.ToInt64(dgvDeThi.Rows[selectedIndex].Cells["MABDT"].Value); DETHIDTO d = new DETHIDTO(maDeThi, txtTenDeThi.Text.TrimEnd(), (int)txtHocKy.Value, (int)txtNamHoc.Value, 0, 0, ""); bool rs = DETHIBUS.CapNhatBoDeThi(d); if (rs) { LayDanhSachBoDeThi(); MessageBox.Show("Cập nhật thành công"); } else { MessageBox.Show("Cập nhật bộ đề thi thất bại"); } }
public static bool CapNhatBoDeThi(DETHIDTO d) { DETHIDAO dao = new DETHIDAO(); return(dao.CapNhatBoDeThi(d)); }
public static int ThemBoDeThi(DETHIDTO d) { DETHIDAO dao = new DETHIDAO(); return(dao.ThemBoDeThi(d)); }