private GradebookViewModel()
{
GradebookModel _gradebook = GradebookDao.getGradebook();
this.SchoolYears = new List <SchoolYearViewModel>();
foreach (SchoolYear schoolYear in _gradebook.SchoolYears)
{
SchoolYearViewModel schoolYearVM = new SchoolYearViewModel(schoolYear);
this.SchoolYears.Add(schoolYearVM);
if (!schoolYearVM.isComplete)
{
this.SchoolYear = schoolYearVM;
}
}
if (this.SchoolYear == null)
{
this.SchoolYear = new SchoolYearViewModel();
this.SchoolYears.Add(this.SchoolYear);
}
if (SchoolYear.CurrentGradingPeriod == null)
{
SchoolYear.CreateGradingPeriod();
}
GradingPeriod = SchoolYear.CurrentGradingPeriod;
}
public void Save()
{
GradebookModel _gradebook = new GradebookModel(this);
GradebookDao.SaveGradebook(_gradebook);
StateManager.Clean();
}
public static void SaveGradebook(GradebookModel gradebook)
{
XmlSerializer serializer = new XmlSerializer(typeof(GradebookModel));
using (StreamWriter writer = new StreamWriter(PATH))
{
serializer.Serialize(writer, gradebook);
}
}
public static List <GradebookModel> GetGradebookDataRepo(int courseId)
{
var db = new SWC_LMSEntities();
var gradebookData = from a in db.Assignments
join ra in db.RosterAssignments
on a.AssignmentId equals ra.AssignmentId
join r in db.Rosters
on ra.RosterId equals r.RosterId
join l in db.LmsUsers
on r.UserId equals l.UserId
where a.CourseId == courseId
select new
{
l.FirstName,
l.LastName,
ra.Grade,
ra.Percentage,
l.UserId,
a.AssignmentId,
a.PossiblePoints,
ra.PointsEarned,
a.CourseId,
a.AssignmentName
};
var modelList = new List <GradebookModel>();
foreach (var x in gradebookData)
{
GradebookModel model = new GradebookModel
{
FirstName = x.FirstName,
LastName = x.LastName,
Grade = x.Grade,
Percentage = Convert.ToDecimal(x.Percentage),
PointsEarned = Convert.ToDecimal(x.PointsEarned),
PossiblePoints = Convert.ToDecimal(x.PossiblePoints),
CourseId = x.CourseId,
UserId = x.UserId,
AssignmentId = x.AssignmentId,
AssignmentName = x.AssignmentName
};
modelList.Add(model);
}
return(modelList);
}
public static GradebookModel getGradebook()
{
GradebookModel gradebook = new GradebookModel();
XmlSerializer deserializer = new XmlSerializer(typeof(GradebookModel));
try
{
using (StreamReader reader = new StreamReader(PATH))
{
gradebook = (GradebookModel)deserializer.Deserialize(reader);
}
}
catch (FileNotFoundException)
{
//TODO: Do Something
}
return(gradebook);
}
