public static string GetAssigmentSubjectName(int subjectId)
{
using (var db = new UniGuardDbContext())
{
var result = db.SubjectData.Where(x => x.Id == subjectId).First().SubjectCode;
return(result);
}
}
public static async Task <List <AssigmentData> > GetAllAssigmentsInSubjectAsync(int subjectId)
{
using (var db = new UniGuardDbContext())
{
var result = await db.AssigmentData.Where(x => x.SubjectId == subjectId).ToListAsync();
return(result);
}
}
public static async Task <List <SubjectData> > GetAllSubjectsInSemesterAsync(int semesterId)
{
using (var db = new UniGuardDbContext())
{
var result = await db.SubjectData.Where(x => x.SemesterId == semesterId).ToListAsync();
return(result);
}
}
public static async Task <List <SubjectData> > GetAllSubjectsAsync()
{
using (var db = new UniGuardDbContext())
{
var result = await db.SubjectData.ToListAsync();
return(result);
}
}
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 <List <AssigmentData> > GetAllAssigmentsAsync()
{
using (var db = new UniGuardDbContext())
{
var assigments = await db.AssigmentData.ToListAsync();
return(assigments);
}
}
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 <List <AssigmentData> > GetAllAssigmentsInSemesterAsync(int semesterId)
{
using (var db = new UniGuardDbContext())
{
var subjects = db.SubjectData.Where(x => x.SemesterId == semesterId);
var assigments = await db.AssigmentData
.Where(x => subjects.Select(y => y.Id).Contains(x.SubjectId)).ToListAsync();
return(assigments);
}
}
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();
}
}
