public int Delete(int ID) { tblAssignmentRoutine tb = _db.tblAssignmentRoutines.Where(a => a.Routine_Id == ID).FirstOrDefault(); _db.tblAssignmentRoutines.Remove(tb); return(_db.SaveChanges()); }
public int Add(AssignmentRoutineViewModel arvm) { tblAssignmentRoutine tb = new tblAssignmentRoutine(); tb.Assignment_Name = arvm.Assignment_Name; tb.Teacher_Id = arvm.Teacher_Id; tb.Assignment_Release_Date = arvm.Assignment_Release_Date; tb.Deadline = arvm.Deadline; tb.Section_Id = arvm.Section_Id; tb.Faculty_Id = arvm.Faculty_Id; tb.Semester_Id = arvm.Semester_Id; tb.YearBatchId = arvm.Year_Batch_Id; _db.tblAssignmentRoutines.Add(tb); _db.SaveChanges(); tblStudentRoutineRelation tsr = new tblStudentRoutineRelation(); var studnet = _db.tblStudents.Where(s => s.Faculty_Id == tb.Faculty_Id && s.Section_Id == tb.Section_Id && s.Semester_Id == tb.Semester_Id && s.YearBatchId == tb.YearBatchId).ToList(); foreach (var item in studnet) { tsr.RoutineId = tb.Routine_Id; tsr.StudentId = item.Student_Id; _db.tblStudentRoutineRelations.Add(tsr); _db.SaveChanges(); } return(0); }
public bool StudentAssignmentMatch(int?StudentId, int?RoutineId) { tblStudent ts = _db.tblStudents.Where(s => s.Student_Id == StudentId).FirstOrDefault(); tblAssignmentRoutine tr = _db.tblAssignmentRoutines.Where(r => r.Routine_Id == RoutineId).FirstOrDefault(); if (ts.Faculty_Id == tr.Faculty_Id && ts.YearBatchId == tr.YearBatchId /*&& ts.Section_Id == tr.Section_Id && ts.Semester_Id == tr.Semester_Id*/) { return(true); } else { return(false); } }
public int Update(AssignmentRoutineViewModel arvm) { bool fieldChange = false; tblAssignmentRoutine tb = _db.tblAssignmentRoutines.Where(a => a.Routine_Id == arvm.Id).FirstOrDefault(); if (tb.Section_Id == arvm.Section_Id && tb.Faculty_Id == arvm.Faculty_Id && tb.Semester_Id == arvm.Semester_Id && tb.YearBatchId == arvm.Year_Batch_Id) { fieldChange = false; } else { fieldChange = true; } tb.Assignment_Name = arvm.Assignment_Name; tb.Teacher_Id = arvm.Teacher_Id; tb.Assignment_Release_Date = arvm.Assignment_Release_Date; tb.Deadline = arvm.Deadline; tb.Section_Id = arvm.Section_Id; tb.Faculty_Id = arvm.Faculty_Id; tb.Semester_Id = arvm.Semester_Id; tb.YearBatchId = arvm.Year_Batch_Id; _db.SaveChanges(); //tblStudentRoutineRelation tsr = new tblStudentRoutineRelation(); //var studnet = _db.tblStudents.Where(s => s.Faculty_Id == tb.Faculty_Id && s.Section_Id == tb.Section_Id && s.Semester_Id == tb.Semester_Id && s.YearBatchId == tb.YearBatchId).ToList(); if (fieldChange) { var studentlist = _db.tblStudentRoutineRelations.Where(s => s.RoutineId == tb.Routine_Id).ToList(); foreach (var item in studentlist) { _db.tblStudentRoutineRelations.Remove(item); } tblStudentRoutineRelation tsr = new tblStudentRoutineRelation(); var studnet = _db.tblStudents.Where(s => s.Faculty_Id == tb.Faculty_Id && s.Section_Id == tb.Section_Id && s.Semester_Id == tb.Semester_Id && s.YearBatchId == tb.YearBatchId).ToList(); foreach (var item in studnet) { tsr.RoutineId = tb.Routine_Id; tsr.StudentId = item.Student_Id; _db.tblStudentRoutineRelations.Add(tsr); _db.SaveChanges(); } } return(0); }