private void btnSua_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = KetNoi.str;
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
double DiemThi;
DiemThi = Convert.ToDouble(txtDiemThi.Text);
double TongKet;
TongKet = Convert.ToDouble(txtDiemTongKet.Text);
cmd.CommandText = "UPDATE KetQua SET DiemThi=" + DiemThi + ",DiemTongKet=" + TongKet + " WHERE ID_SinhVien='" + SinhVien_ID + "' AND ID_MonHoc='" + MonHoc_ID + "' AND LanThi=" + LanThi + "";
DialogResult result;
result = MessageBox.Show("BẠN CÓ MUỐN THAY ĐỔI THÔNG TIN KHÔNG?", "THÔNG BÁO", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("CẬP NHẬT THÀNH CÔNG", "THÔNG BÁO");
}
this.Close();
frmKetQuaHocTap frm = new frmKetQuaHocTap(SinhVien_ID);
frm.Show();
}
private void btnThoat_Click(object sender, EventArgs e)
{
this.Close();
frmKetQuaHocTap frm = new frmKetQuaHocTap(SinhVien_ID);
frm.Show();
}
private void btnXoa_Click(object sender, EventArgs e)
{
int LanThi;
string MonHoc_ID;
string TenMonHoc;
int row;
row = this.listView1.SelectedItems[0].Index;
LanThi = Convert.ToInt16(this.listView1.Items[row].SubItems[2].Text);
TenMonHoc = this.listView1.Items[row].SubItems[0].Text;
SqlConnection con = new SqlConnection();
con.ConnectionString = KetNoi.str;
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "SELECT MonHoc_ID FROM MonHoc WHERE TenMonHoc='" + TenMonHoc + "' ";
SqlDataReader rd;
rd = cmd.ExecuteReader();
DataTable td = new DataTable();
td.Load(rd);
MonHoc_ID = td.Rows[0][0].ToString();
cmd.CommandText = "DELETE FROM KetQua WHERE ID_SinhVien='" + SinhVien_ID + "' AND ID_MonHoc='" + MonHoc_ID + "' AND LanThi=" + LanThi + " ";
DialogResult result;
result = MessageBox.Show("BẠN CÓ MUỐN XOÁ KẾT QUẢ KHÔNG?", "THÔNG BÁO", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("XÓA THÀNH CÔNG", "THÔNG BÁO");
this.Close();
frmKetQuaHocTap frm = new frmKetQuaHocTap(SinhVien_ID);
frm.Show();
}
}
private void btnThem_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = KetNoi.str;
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
string TenMonHoc;
TenMonHoc = cboMonHoc.SelectedItem.ToString();
cmd.CommandText = "select* from MonHoc where TenMonHoc ='" + TenMonHoc + "'";
SqlDataReader rd;
rd = cmd.ExecuteReader();
DataTable td = new DataTable();
td.Load(rd);
string MaMonHoc = td.Rows[0][0].ToString();
int LanThi;
LanThi = Convert.ToInt16(txtLanThi.Text);
double DiemThi;
DiemThi = Convert.ToDouble(txtDiemThi.Text);
double TongKet;
TongKet = Convert.ToDouble(txtDiemTongKet.Text);
cmd.CommandText = "INSERT INTO KetQua VALUES('" + MaMonHoc + "','" + SinhVien_ID + "'," + LanThi + "," + DiemThi + "," + TongKet + ")";
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Thêm Dữ Liệu Thành Công!");
this.Close();
frmKetQuaHocTap frm = new frmKetQuaHocTap(SinhVien_ID);
frm.Show();
}
private void button1_Click(object sender, EventArgs e)
{
frmKetQuaHocTap frm = new frmKetQuaHocTap(SinhVien_ID);
frm.Show();
}
