public int updateMarksEntry(Collection <MarksEntryCL> marksEntryCol, int classId) { IQueryable <MarksEntry> queryMarksDB = from x in dbcontext.MarksEntries where x.ClassSubjectMap.ClassId == classId select x; foreach (MarksEntry item in queryMarksDB) { item.IsDeleted = true; } dbcontext.SaveChanges(); int count = 0; foreach (MarksEntryCL item in marksEntryCol) { MarksEntry marksQuery = dbcontext.MarksEntries.Add(new MarksEntry() { ClassSubjectId = item.classSubjectId, DateCreated = DateTime.Now, DateModified = DateTime.Now, ExaminationId = item.examinationId, IsDeleted = false, Marks = item.marks, SessionId = item.sessionId, StudentId = item.studentId, }); count++; } dbcontext.SaveChanges(); return(count); }
public string viewMarksByStudentSubjectExam(int studentId, int subjectId, int examId) { MarksEntry queryMarksDB = (from x in dbcontext.MarksEntries where x.ClassSubjectMap.SubjectId == subjectId && x.ExaminationId == examId && x.StudentId == studentId && x.IsDeleted == false select x).FirstOrDefault(); if (queryMarksDB == null) { return(string.Empty); } else { return(queryMarksDB.Marks); } }
private void btnRegister_Click(object sender, EventArgs e) { if ((txtQuiz.Text == "" || int.Parse(txtQuiz.Text) > 5) || (txtAssignment.Text == "" || int.Parse(txtAssignment.Text) > 5) || (txtProject.Text == "" || int.Parse(txtProject.Text) > 20) || (txtMid.Text == "" || int.Parse(txtMid.Text) > 30) || (txtFinal.Text == "" || int.Parse(txtFinal.Text) > 40)) { MessageBox.Show("One or more field(s) empty OR Entered Marks are not correct!"); return; } try { var course = cbCourse.SelectedItem as Course; var student = cbStudent.SelectedItem as IStudent; var entry = new MarksEntry { CourseID = course.CourseId, StudentID = student.StudentId, Quizes = int.Parse(txtQuiz.Text), Assignments = int.Parse(txtAssignment.Text), Project = int.Parse(txtProject.Text), Mid = int.Parse(txtMid.Text), Final = int.Parse(txtFinal.Text) }; var added = marksEntryCRUD.AddMarksEntry(entry); if (added) { MessageBox.Show("Marks entered successfully"); ClearTextBoxes(); } else { MessageBox.Show("Failed to enter marks!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public int addMarksEntry(Collection <MarksEntryCL> marksEntryCol, int classId) { int count = 0; foreach (MarksEntryCL item in marksEntryCol) { MarksEntry marksQuery = dbcontext.MarksEntries.Add(new MarksEntry() { ClassSubjectId = item.classSubjectId, DateCreated = DateTime.Now, DateModified = DateTime.Now, ExaminationId = item.examinationId, IsDeleted = false, Marks = item.marks, SessionId = item.sessionId, StudentId = item.studentId, }); count++; } dbcontext.SaveChanges(); return(count); }
public bool AddMarksEntry(MarksEntry _marksEntry) { context.MarksEntries.Add(_marksEntry); context.SaveChanges(); return(true); }