public void setVivaResult(string mark, string teacherID, string stdID) { DataClassesLinqDataContext db = new DataClassesLinqDataContext (DataAccessClassLinq.connectionStringLinq); //var max = db.Admission_Exam_Results.OrderByDescending(i => i.Admission_Exam_ID).FirstOrDefault(); Admission_Exam_Result re = db.Admission_Exam_Results.FirstOrDefault(e => e.Admission_Student_ID.Equals(stdID)); if (re != null) { re.Viva_Examiner_ID = teacherID; re.Viva_Exam_Mark = mark; } db.SubmitChanges(); }
public void setWrittenResult(string mark, string teacherID, string stdID) { DataClassesLinqDataContext db = new DataClassesLinqDataContext (DataAccessClassLinq.connectionStringLinq); var max = db.Admission_Exam_Results.OrderByDescending(i => i.Admission_Exam_ID).FirstOrDefault(); Admission_Exam_Result re = db.Admission_Exam_Results.FirstOrDefault(e => e.Admission_Student_ID.Equals(stdID)); if (re == null) { string id = ""; foreach (char a in max.Admission_Exam_ID) { int val = (int)Char.GetNumericValue(a); id = (val + 1).ToString(); } Admission_Exam_Result rs = new Admission_Exam_Result(); rs.Admission_Exam_ID = id; rs.Written_Examiner_ID = teacherID; rs.Writtern_Exam_Mark = mark; rs.Admission_Student_ID = stdID; rs.Viva_Exam_Mark = "0"; rs.Viva_Examiner_ID = "0"; db.Admission_Exam_Results.InsertOnSubmit(rs); } else { re.Writtern_Exam_Mark = mark; re.Written_Examiner_ID = teacherID; } db.SubmitChanges(); }