private void button3_Click(object sender, EventArgs e) { string id = txtMaSV.Text.Trim(); string id1 = txtMaMH.Text.Trim(); if (MessageBox.Show(string.Format("Xóa điểm môn {0} của sinh viên có mã '{1}'?", id1, id), "", MessageBoxButtons.OKCancel) == DialogResult.OK) { tblKET_QUA g = new tblKET_QUA(); g.MaMon = txtMaMH.Text; g.MaSV = txtMaSV.Text; g.DiemTB = Convert.ToDouble(txtDiemTB.Text); g.DiemThiLan1 = Convert.ToDouble(txtDiemThi1.Text); g.DiemThiLan2 = Convert.ToDouble(txtdiemthi2.Text); g.DiemTongKet = Convert.ToDouble(txtDiemTK.Text); g.HanhKiem = cboHanhKiem.Text; g.HocKi = Convert.ToInt32(txtHocKi.Text.ToString()); DIEMF f = new DIEMF(); f.Delete(g); context = new HSGVDbContext(); dgrDiem.DataSource = context.tblKET_QUA.ToList(); txtMaSV.Clear(); txtMaMH.Clear(); txtHocKi.Clear(); txtDiemTK.Clear(); txtDiemThi1.Clear(); txtdiemthi2.Clear(); txtDiemTB.Clear(); cboHanhKiem.Text = ""; } }
private void button1_Click(object sender, EventArgs e) { if (txtMaSV.Text.Trim() == "" || txtMaMH.Text.Trim() == "") { MessageBox.Show("Chưa nhập đủ thông tin", "Thông báo"); } else { if (context.tblKET_QUA.Where(x => x.MaMon == txtMaMH.Text.Trim() && x.MaSV == txtMaSV.Text.Trim()).SingleOrDefault() != null) { MessageBox.Show("Mã sinh viên và mã môn học đã tồn tại", "Thông báo"); } else { if (txtDiemTB.Text.Trim() == "") { txtDiemTB.Text = "-1"; } if (txtDiemThi1.Text.Trim() == "") { txtDiemThi1.Text = "-1"; } if (txtdiemthi2.Text.Trim() == "") { txtdiemthi2.Text = "-1"; } if (txtDiemTK.Text.Trim() == "") { txtDiemTK.Text = "-1"; } if (txtHocKi.Text.Trim() == "") { txtHocKi.Text = "-1"; } tblKET_QUA g = new tblKET_QUA(); g.MaMon = txtMaMH.Text; g.MaSV = txtMaSV.Text; g.DiemTB = Convert.ToDouble(txtDiemTB.Text); g.DiemThiLan1 = Convert.ToDouble(txtDiemThi1.Text); g.DiemThiLan2 = Convert.ToDouble(txtdiemthi2.Text); g.DiemTongKet = Convert.ToDouble(txtDiemTK.Text); g.HanhKiem = cboHanhKiem.Text; g.HocKi = Convert.ToInt32(txtHocKi.Text.ToString()); DIEMF f = new DIEMF(); f.Insert(g); context = new HSGVDbContext(); dgrDiem.DataSource = context.tblKET_QUA.ToList(); txtMaSV.Clear(); txtMaMH.Clear(); txtHocKi.Clear(); txtDiemTK.Clear(); txtDiemThi1.Clear(); txtDiemTB.Clear(); cboHanhKiem.Text = ""; } } }
private void btnXem_Click(object sender, EventArgs e) { try { int[] selRows = ((GridView)GridHS.MainView).GetSelectedRows(); HOCSINH hs = (HOCSINH)(((GridView)GridHS.MainView).GetRow(selRows[0])); DIEM result = new DIEMF().FindDiem(int.Parse(cbHK.Text), cbNamHoc.Text, hs.mahs, int.Parse(cbMonHoc.SelectedValue.ToString())); if (result != null) { txtDiem.Text = result.diemtb.ToString(); txtHanhKiem.Text = result.hanhkiem; } else { txtDiem.Text = txtHanhKiem.Text = ""; } } catch { txtDiem.Text = txtHanhKiem.Text = ""; } }