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