// GET: SongAssignment
public ActionResult Index()
{
SongAssignmentViewModel songAssignmentVM = new SongAssignmentViewModel();
songAssignmentVM.SongsDetails = SqlDatabaseConnection.getSongsDetails();
songAssignmentVM.Users = SqlDatabaseConnection.getStudents();
return(View(songAssignmentVM));
}
public ActionResult DisplayAssignments(SongAssignmentViewModel songAssignmentVM)
{
//TO DO!
songAssignmentVM = new SongAssignmentViewModel();
songAssignmentVM.SongsDetails = SqlDatabaseConnection.getSongsDetails();
songAssignmentVM.Users = SqlDatabaseConnection.getStudents();
songAssignmentVM.SongAssignments = SqlDatabaseConnection.getSongAssignments();
string chosenStudent = songAssignmentVM.ChosenStudent;
string[] fullName;
string firstName = null;
string lastName = null;
//if (string.IsNullOrEmpty(chosenStudent))
//{
// fullName = chosenStudent.Split();
// firstName = fullName[0];
// lastName = fullName[1];
//}
//int chosenStudentId = int.Parse(songAssignmentVM.Users
// .Where(user => user.FirstName == firstName && user.LastName == lastName)
// .Select(user => user.Id)
// .ToList().FirstOrDefault().ToString());
int chosenStudentId = 2;
List <SongAssingnmentModel> assignmentsToDisplay = songAssignmentVM.SongAssignments
.Where(a => a.UserId == chosenStudentId)
.Select(a => a)
.ToList();
List <SongDetailsModel> detailsToDisplay = new List <SongDetailsModel>();
foreach (var assignment in assignmentsToDisplay)
{
detailsToDisplay.Add(songAssignmentVM.SongsDetails
.Where(det => det.Id == assignment.SongDetailsId)
.Select(a => a)
.ToList().First());
}
List <SongAssignmentDisplay> result = new List <SongAssignmentDisplay>();
if (assignmentsToDisplay.Count == detailsToDisplay.Count)
{
for (int i = 0; i < assignmentsToDisplay.Count; i++)
{
result.Add(new SongAssignmentDisplay()
{
Title = detailsToDisplay[i].Title,
Author = detailsToDisplay[i].Author,
OrginalTempo = detailsToDisplay[i].OrginalTempo,
StartTempo = assignmentsToDisplay[i].StartTempo,
DestinationTempo = assignmentsToDisplay[i].DestinationTempo
});
}
}
songAssignmentVM.SongAssignmentsDisplay = result;
return(View("~/Views/SongAssignment/Index.cshtml", songAssignmentVM));
}