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 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()); }
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()); }
//[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)); }