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 = "";
}
}
}
public bool Delete(tblKET_QUA model)
{
tblKET_QUA dbEntry = context.tblKET_QUA.Find(model.MaSV, model.MaMon);
if (dbEntry == null)
{
return(false);
}
context.tblKET_QUA.Remove(dbEntry);
context.SaveChanges();
return(true);
}
public bool Insert(tblKET_QUA model)
{
tblKET_QUA dbEntry = context.tblKET_QUA.Find(model.MaSV, model.MaMon);
if (dbEntry != null)
{
return(false);
}
context.tblKET_QUA.Add(model);
context.SaveChanges();
return(true);
}
public bool Update(tblKET_QUA model)
{
tblKET_QUA dbEntry = context.tblKET_QUA.Find(model.MaSV, model.MaMon);
if (dbEntry == null)
{
return(false);
}
dbEntry.MaSV = model.MaSV;
dbEntry.MaMon = model.MaMon;
dbEntry.DiemTB = model.DiemTB;
dbEntry.DiemThiLan1 = model.DiemThiLan1;
dbEntry.DiemThiLan2 = model.DiemThiLan2;
dbEntry.DiemTongKet = model.DiemTongKet;
dbEntry.HanhKiem = model.HanhKiem;
dbEntry.HocKi = model.HocKi;
dbEntry.GhiChu = model.GhiChu;
context.SaveChanges();
return(true);
}
public tblKET_QUA FindEntity(string ID1, string ID2)
{
tblKET_QUA dbEntry = context.tblKET_QUA.Find(ID1, ID2);
return(dbEntry);
}
