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);
}
