public async Task <IEnumerable <CoreServiceDevReference.AssessmentInventoryItem> > GetAssessmentListAsync()
{
var loggedInUserID = _userService.GetCurrentUserId();
CoreServiceDevReference.CoreServiceClient coreServiceClient = new CoreServiceDevReference.CoreServiceClient();
var assessments = await coreServiceClient.GetCurrentInventoryForUserAsync(int.Parse(loggedInUserID));
//var favorites = await coreServiceClient.GetFavoriteInventoryForCurrentUserAsync(int.Parse(loggedInUserID));
//var fav = favorites.Where(x=>x.)
var assessment = new Models.Assessment();
var assessmentInventoryItems = assessments.Select(x => new CoreServiceDevReference.AssessmentInventoryItem
{
AssessmentKey = x.AssessmentKey,
ProductFamily = x.ProductFamily,
Count = x.Count,
AssessmentForms = x.AssessmentForms
});
return(assessmentInventoryItems);
}
//Create DB if none exists and populate test data
public static void initializeDB()
{
SQLiteConnection con = new SQLiteConnection(dbPath);
DateTime now = DateTime.Now;
try
{
con.CreateTable <Models.Assessment>();
con.CreateTable <Models.Course>();
con.CreateTable <Models.Degree>();
con.CreateTable <Models.Enrollment>();
con.CreateTable <Models.Instructor>();
con.CreateTable <Models.Student>();
con.CreateTable <Models.Term>();
}
catch (Exception x)
{
Console.WriteLine("Error creating tables: " + x.Message);
}
try
{
if (con.Table <Models.Student>().Count() == 0)
{
//Get start and end dates for test data
DateTime start = new DateTime(now.Year, now.Month, 1);
DateTime end = start.AddMonths(6).AddHours(23).AddMinutes(59).AddSeconds(59);
DateTime courseStart = start.AddDays(7);
DateTime courseEnd = courseStart.AddDays(14);
DateTime paAssessmentStart = courseStart.AddDays(12).AddHours(15).AddMinutes(30);
DateTime paAssessmentEnd = paAssessmentStart.AddDays(1);
DateTime oaAssessmentStart = paAssessmentEnd.AddHours(2).AddMinutes(30);
DateTime oaAssessmentEnd = oaAssessmentStart.AddHours(2);
List <DateTime> dates = new List <DateTime> {
start, end, courseStart, courseEnd, paAssessmentStart, paAssessmentEnd, oaAssessmentStart, oaAssessmentEnd
};
List <string> sqlDates = convertDates(dates);
//Insert test student
Models.Student student = new Models.Student
{
Name = "test",
Username = "******",
Password = "******"
};
con.Insert(student);
int studentId = student.StudentId;
//Insert test degree
Models.Degree degree = new Models.Degree
{
StudentId = studentId,
Name = "My Degree",
Active = 1
};
con.Insert(degree);
int degreeId = degree.DegreeId;
//Insert test term
Models.Term term = new Models.Term
{
DegreeId = degreeId,
Name = "First Term",
Start = sqlDates[0],
End = sqlDates[1]
};
con.Insert(term);
int termId = term.TermId;
//Insert test instructor
Models.Instructor instructor = new Models.Instructor()
{
Name = "Reg Garrett",
Email = "*****@*****.**",
Phone = "801-623-8070"
};
con.Insert(instructor);
int instructorId = instructor.InstructorId;
//Insert test course
Models.Course course = new Models.Course()
{
InstructorId = instructorId,
Name = "Intro to Xamarin Forms",
Status = "Enrolled",
Notes = "",
Start = sqlDates[2],
End = sqlDates[3],
StartNotification = 0,
EndNotification = 0
};
con.Insert(course);
int courseId = course.CourseId;
//Insert Assessments
Models.Assessment pa = new Models.Assessment()
{
CourseId = courseId,
Type = "Performance Assessment",
Start = sqlDates[4],
End = sqlDates[5],
StartNotification = 0,
EndNotification = 0
};
con.Insert(pa);
Models.Assessment oa = new Models.Assessment()
{
CourseId = courseId,
Type = "Objective Assessment",
Start = sqlDates[6],
End = sqlDates[7],
StartNotification = 0,
EndNotification = 0
};
con.Insert(oa);
Models.Enrollment enrollment = new Models.Enrollment()
{
TermId = termId,
CourseId = courseId
};
con.Insert(enrollment);
}
}
catch (Exception x)
{
Console.WriteLine("Error populating test data: " + x.Message);
}
finally
{
con.Close();
}
}
private async void Remove(Models.Assessment assessment)
{
await DBService.RemoveAssessment(assessment.Id);
await Task.Run(() => Refresh());
}
