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 = ""; }
}
