public static async Task RemoveSubjectAsync(SubjectData subject) { using (var db = new UniGuardDbContext()) { db.Attach(subject); db.Remove(subject); await db.SaveChangesAsync(); } }
public static async Task RemoveAssigmentAsync(AssigmentData assigment) { using (var db = new UniGuardDbContext()) { db.Attach(assigment); db.Remove(assigment); await db.SaveChangesAsync(); } }
public static async Task RemoveSemesterAsync(SemesterData semesterData) { using (var db = new UniGuardDbContext()) { db.SemesterData.Attach(semesterData); db.SemesterData.Remove(semesterData); await db.SaveChangesAsync(); } }
public static async Task UpdateAssigmentAsync(int assigmentId, string newName, string newState, DateTime newDate) { using (var db = new UniGuardDbContext()) { var assigment = db.AssigmentData.Where(x => x.AssigmentId == assigmentId).First(); assigment.AssigmentName = newName; assigment.AssigmentState = newState; assigment.AssigmentEndDate = newDate; await db.SaveChangesAsync(); } }
public static async Task AddSemesterAsync(string semesterType, DateTime startDate, DateTime endDate) { using (var db = new UniGuardDbContext()) { var semester = new SemesterData { SemesterType = semesterType, StartDate = startDate, EndDate = endDate }; await db.SemesterData.AddAsync(semester); await db.SaveChangesAsync(); } }
public static async Task AddSubjectAsync(string subjectCode, string subjectName, string subjectFaculty, int semesterId) { using (var db = new UniGuardDbContext()) { var subject = new SubjectData { SubjectCode = subjectCode, SubjectName = subjectName, SubjectFaculty = subjectFaculty, SemesterId = semesterId }; await db.SubjectData.AddAsync(subject); await db.SaveChangesAsync(); } }
public static async Task AddAssigmentAsync(string assigmentName, string assigmentState, int subjectId, DateTime endDate) { using (var db = new UniGuardDbContext()) { var assigment = new AssigmentData { AssigmentName = assigmentName, AssigmentState = assigmentState, SubjectId = subjectId, AssigmentEndDate = endDate }; await db.AssigmentData.AddAsync(assigment); await db.SaveChangesAsync(); } }