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