private void btnAddMarks_Click(object sender, EventArgs e) { string mark = val.valMark(txtMarkAdd.Text); if (!(mark == "")) { MessageBox.Show(mark); } using (SchoolEntities db = new SchoolEntities()) { int sno = Convert.ToInt32(cboSIDAdd.Text); int cno = Convert.ToInt32(cboCIDAdd.Text); Student_Course course = (from c in db.Student_Course where sno == c.SID && cno == c.CID select c).FirstOrDefault(); if (course != null) { MessageBox.Show("Mark Exists Already. Cannot Add Marks."); } else { course = new Student_Course(); course.SID = sno; course.CID = cno; course.Mark = Convert.ToInt32(txtMarkAdd.Text); db.Student_Course.Add(course); db.SaveChanges(); MessageBox.Show("Mark Added."); } updateMarks(); } }
private void btnEdit_Click(object sender, EventArgs e) { using (SchoolEntities db = new SchoolEntities()) { int cno = Convert.ToInt32(cboCIDEdit.Text); int[] sid = (from c in db.Student_Course where c.CID == cno select c.SID).ToArray(); int sct = sid.Length; for (int i = 0; i < sct; i++) { int studentid = sid[i]; Student_Course cou = (from c in db.Student_Course where c.CID == cno && c.SID == studentid select c).FirstOrDefault(); string markInput = dGVMarks.Rows[i].Cells[MarkCol].Value.ToString(); string output = val.valMark(markInput); int markEd = Convert.ToInt32(markInput); if (!(output == "")) { MessageBox.Show(output); } cou.Mark = markEd; db.SaveChanges(); } } updateMarks(); }