public ActionResult Dashboard()
{
var entities = new db38bab79d27554b96b50aa57c010cd149Entities3();
var sessionUser = (string)Session["User"];
if (sessionUser != null && adminPasswordsByUsername.ContainsKey(sessionUser))
{
var viewModel = new DashboardViewModel(entities.Sessions);
return View("Dashboard", viewModel);
}
return Index();
}
public ActionResult EditSession(int? sessionID)
{
var entities = new db38bab79d27554b96b50aa57c010cd149Entities3();
var sessionUser = (string)Session["User"];
if (sessionUser != null && adminPasswordsByUsername.ContainsKey(sessionUser))
{
SessionViewModel viewModel;
if (sessionID == null)
{
viewModel = new SessionViewModel(entities.FeedbackConditions, entities.Profiles, entities.Participants);
}
else
{
var existingSession = entities.Sessions.Where(x => x.Id == sessionID).FirstOrDefault();
viewModel = new SessionViewModel(entities.FeedbackConditions, entities.Profiles, entities.Participants, existingSession);
}
return View(viewModel);
}
return Index();
}
public ActionResult ViewSessionData(int? sessionID)
{
var entities = new db38bab79d27554b96b50aa57c010cd149Entities3();
var sessionUser = (string)Session["User"];
if (sessionUser != null && adminPasswordsByUsername.ContainsKey(sessionUser) && sessionID != null)
{
var existingSession = entities.Sessions.Where(x => x.Id == sessionID).FirstOrDefault();
var viewModel = new CompletedSessionViewModel(existingSession, entities.Profiles);
return View(viewModel);
}
return Index();
}
//[HttpPost]
//[AllowAnonymous]
//public ActionResult ImportWords()
//{
// var entities = new db38bab79d27554b96b50aa57c010cd149Entities3();
// string pathToExcelFile = ""
//+ @"D:\Words.xls";
// string[] SheetNames = new string[] { "Session 1, 7", "Session 2, 8", "Session 3, 9", "Session 4, 10", "Session 5, 11", "Session 6, 12" };
// string[] stringSeparators = new string[] { ", " };
// var excelFile = new ExcelQueryFactory(pathToExcelFile);
// for (int i = 0; i < SheetNames.Length; i++ )
// {
// var sheetName = SheetNames[i];
// var rows = from a in excelFile.Worksheet(sheetName) select a;
// foreach (var r in rows)
// {
// var word = new Word();
// word.Arabic = r["Arabic"];
// word.English = r["English"];
// word.ListId = i;
// entities.Words.Add(word);
// entities.SaveChanges();
// }
// }
// AjaxResponse response = new AjaxResponse();
// response.Success = true;
// response.Message = "It worked.";
// return Json(response);
//}
public ActionResult UpdateSession(SessionViewModel form)
{
AjaxResponse response = new AjaxResponse();
response.Success = false;
response.Message = "Nothing happened.";
var entities = new db38bab79d27554b96b50aa57c010cd149Entities3();
Session newSession;
if (form.SessionID == null || form.SessionID == string.Empty)
{
newSession = new Session();
entities.Sessions.Add(newSession);
}
else
{
int parsedID = Int32.Parse(form.SessionID);
newSession = entities.Sessions.Where(x => x.Id == parsedID).FirstOrDefault();
}
newSession.Name = form.Name;
var part = entities.Participants.Where(x => x.Id == form.ParticipantID).FirstOrDefault();
var feedback = entities.FeedbackConditions.Where(x => x.Id == form.FeedbackModeID).FirstOrDefault();
newSession.FeedbackCondition = feedback;
newSession.Participant = part;
newSession.WordListId = form.WordListId;
entities.SaveChanges();
foreach(var block in form.TrialBlocks)
{
TrialBlock newTB;
if (block.ID == null)
{
newTB = new TrialBlock();
}
else
{
newTB = entities.TrialBlocks.Where(x => x.Id == block.ID).FirstOrDefault();
newTB.FailProfiles.Clear();
newTB.PassProfiles.Clear();
}
newTB.IndexInSession = block.IndexInSession;
foreach (var id in block.ProfilesIDsToFail)
{
var profile = entities.Profiles.Where(x => x.Id == id).FirstOrDefault();
newTB.FailProfiles.Add(profile);
}
foreach (var id in block.ProfilesIDsToPass)
{
var profile = entities.Profiles.Where(x => x.Id == id).FirstOrDefault();
newTB.PassProfiles.Add(profile);
}
if (block.ID == null)
{
newSession.TrialBlocks.Add(newTB);
}
}
entities.SaveChanges();
response.Success = true;
response.Message = "Changes saved to database";
return Json(response);
}
