public ActionResult Index()
{
using (var db = new QuesoContext())
{
board = db.Boards.OrderByDescending(x => x.BoardID).FirstOrDefault();
}
return Redirect("/Board/Show/" + board.BoardID);
}
public ActionResult Login(int UserID)
{
using (var db = new QuesoContext())
{
Session["UserID"] = db.Users.Find(UserID).UserID;
return Redirect("/Board");
}
}
public ActionResult Edit(int id)
{
Board board;
using (var db = new QuesoContext())
{
board = db.Boards.FirstOrDefault(x => x.BoardID == id);
}
return View(board);
}
public ActionResult Index()
{
List<User> users;
using (var db = new QuesoContext())
{
users = db.Users.ToList();
ViewBag.Users = users;
}
return View(users);
}
public static List<Task> Random(int count=24)
{
List<Task> tasks;
using (var db = new QuesoContext())
{
tasks = db.Tasks
.OrderBy(t => Guid.NewGuid())
.Where(t=>t.Active)
.Where(t=>!t.Challenge)
.Take(count).ToList();
}
return tasks;
}
public static List <Task> Random(int count = 24)
{
List <Task> tasks;
using (var db = new QuesoContext())
{
tasks = db.Tasks
.OrderBy(t => Guid.NewGuid())
.Where(t => t.Active)
.Where(t => !t.Challenge)
.Take(count).ToList();
}
return(tasks);
}
public ActionResult Answer(int UserID, int TaskID, string CaseNumber)
{
using (var db = new QuesoContext())
{
var task = db.Tasks.Where(x => x.TaskID == TaskID).FirstOrDefault();
var user = db.Users.Where(x => x.UserID == UserID).FirstOrDefault();
var answer = new Answer();
answer.Task = task;
answer.User = user;
answer.CreatedAt = System.DateTime.Now;
answer.CaseNumber = CaseNumber;
db.Answers.Add(answer);
db.SaveChanges();
}
return Redirect("/Board");
}
public static List<TaskPool> Random(int count = 25)
{
List<TaskPool> tasks;
using (var db = new QuesoContext())
{
tasks = db.TaskPool
.OrderBy(t => Guid.NewGuid())
.Where(t => t.Active)
.Where(t => !t.Challenge)
.Take(count-1).ToList();
var challenge = db.TaskPool
.OrderBy(t => Guid.NewGuid())
.Where(t => t.Active)
.Where(t => t.Challenge)
.Take(1).FirstOrDefault();
tasks.Add(challenge);
}
return tasks;
}
public static List <TaskPool> Random(int count = 25)
{
List <TaskPool> tasks;
using (var db = new QuesoContext())
{
tasks = db.TaskPool
.OrderBy(t => Guid.NewGuid())
.Where(t => t.Active)
.Where(t => !t.Challenge)
.Take(count - 1).ToList();
var challenge = db.TaskPool
.OrderBy(t => Guid.NewGuid())
.Where(t => t.Active)
.Where(t => t.Challenge)
.Take(1).FirstOrDefault();
tasks.Add(challenge);
}
return(tasks);
}
public ActionResult New()
{
using (var db = new QuesoContext())
{
board = new Board();
board.Active = true;
var poolTasks = TaskPool.Random();
foreach (var poolTask in poolTasks)
{
var task = new Task()
{
Name = poolTask.Name,
Challenge = poolTask.Challenge
};
board.Tasks.Add(task);
}
db.Boards.Add(board);
db.SaveChanges();
}
return View();
}
public ActionResult Show(int id)
{
using (var db = new QuesoContext())
{
//board = db.Boards.Find(id);
board = db.Boards.Include("Tasks").FirstOrDefault(x => x.BoardID == id);
if (board != null)
{
var temp = board.Tasks.ToList();
board.Tasks = new List<Task>();
board.Tasks.AddRange(temp.GetRange(0,12));
board.Tasks.Add(temp.Last());
board.Tasks.AddRange(temp.GetRange(12,12));
}
}
return View(board);
}
