private void btnThem_Click(object sender, EventArgs e)
{
maMonHoc = cbbMonHoc.SelectedValue.ToString().Trim();
maSinhVien = cbbSinhVien.SelectedValue.ToString().Trim();
kiHoc = int.Parse(cbbKiHoc.SelectedItem.ToString().Trim());
diemLan1 = float.Parse(txtDiemL1.Text.Trim());
diemLan2 = float.Parse(txtDieml2.Text.Trim());
DTO_Diem Diem = new DTO_Diem(maMonHoc, maSinhVien, kiHoc, diemLan1, diemLan2);
if (busDien.KiemTraMaTrung(maMonHoc, maSinhVien) == 1)
{
MessageBox.Show("Đã tồn tại sinh viên với môn học! Mời bạn nhập lại");
}
else
{
try
{
MessageBox.Show("Bạn đã thêm thành công");
busDien.ThemDiem(Diem);
dataGridView1.DataSource = busDien.GetDiem();
Xoa();
}
catch (Exception A)
{
MessageBox.Show(A.Message);
}
}
}
private void btnThem_Click_1(object sender, EventArgs e)
{
DTO_Diem dto_Diem = new DTO_Diem(txtMaSV.Text, cbMaMH.SelectedValue.ToString(), txtHocKy.Text, txtDiemCC.Text, txtDiemTX.Text, txtDiemGK.Text, txtDiemCK.Text);
bus_Diem.themDiem(dto_Diem);
Diem_Load(sender, e);
}
// Sửa KT
public bool suaDiem(DTO_Diem pKT)
{
dbConn.Open();
string cmd = "UPDATE DIEM SET MAMH=N'" + pKT.MaMonHoc + "',HOCKY='" + pKT.HocKy + "', DIEMCC='" + pKT.DiemCC + "', DIEMTX= '" + pKT.DiemTX + "', DIEMGK= '" + pKT.DiemGK + "', DIEMTHI= '" + pKT.DiemCK + "' WHERE MASV='" + pKT.MaSinhVien + "'";
SqlCommand sqlCmd = new SqlCommand(cmd, dbConn);
sqlCmd.ExecuteNonQuery();
dbConn.Close();
return(true);
}
// thêm KT
public bool themDiem(DTO_Diem pKT)
{
dbConn.Open();
string cmd = "INSERT INTO DIEM VALUES(N'" + pKT.MaSinhVien + "','" + pKT.MaMonHoc + "', '" + pKT.HocKy + "', '" + pKT.DiemCC + "', '" + pKT.DiemTX + "', '" + pKT.DiemGK + "', '" + pKT.DiemCK + "')";
SqlCommand sqlCmd = new SqlCommand(cmd, dbConn);
sqlCmd.ExecuteNonQuery();
dbConn.Close();
return(true);
}
public void ThemDiem(DTO_Diem Diem)
{
try
{
sqlCon.Open();
string strQuery = string.Format(@"Insert Into dbo.Diem (maMonHoc,maSinhVien,kiHoc,diemlan1,diemlan2)
Values('{0}','{1}',{2},{3},{4})", Diem.MaMonHoc, Diem.MaSinhVien, Diem.KiHoc, Diem.DiemLan1, Diem.DiemLan2);
SqlCommand sqlCom = new SqlCommand(strQuery, sqlCon);
sqlCom.ExecuteNonQuery();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
sqlCon.Close();
}
}
public void SuaDiem(string maMonHoc, string maSinhVien, DTO_Diem Diem)
{
try
{
sqlCon.Open();
string strQuery = string.Format(@"Update dbo.Diem Set kiHoc={0},diemLan1={1},diemlan2={2}
Where maSinhVien ='{3}' and maMonHoc = '{4}'", Diem.KiHoc, Diem.DiemLan1, Diem.DiemLan2, maSinhVien, maMonHoc);
SqlCommand sqlCom = new SqlCommand(strQuery, sqlCon);
sqlCom.ExecuteNonQuery();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
sqlCon.Close();
}
}
private void btnSua_Click(object sender, EventArgs e)
{
maMonHoc = cbbMonHoc.SelectedValue.ToString().Trim();
maSinhVien = cbbSinhVien.SelectedValue.ToString().Trim();
kiHoc = int.Parse(cbbKiHoc.SelectedItem.ToString().Trim());
diemLan1 = float.Parse(txtDiemL1.Text.Trim());
diemLan2 = float.Parse(txtDieml2.Text.Trim());
DTO_Diem Diem = new DTO_Diem(maMonHoc, maSinhVien, kiHoc, diemLan1, diemLan2);
try
{
MessageBox.Show("Bạn đã sửa thành công");
busDien.SuaDiem(maSinhVien, maMonHoc, Diem);
dataGridView1.DataSource = busDien.GetDiem();
Xoa();
}
catch (Exception A)
{
MessageBox.Show(A.Message);
}
}
public void SuaDiem(string maSinhVien, string maMonHoc, DTO_Diem Diem)
{
dalDiem.SuaDiem(maMonHoc, maSinhVien, Diem);
}
public void ThemDiem(DTO_Diem Diem)
{
dalDiem.ThemDiem(Diem);
}
// Sửa KT
public bool suaDiem(DTO_Diem pKT)
{
return(dal_di.suaDiem(pKT));
}
//thêm KT
public bool themDiem(DTO_Diem pKT)
{
return(dal_di.themDiem(pKT));
}
