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