public IActionResult Index()
{
if (!Request.Cookies.ContainsKey("CurrentProject"))
{
return(RedirectToAction("Index", "Project"));
}
PeopleIndexViewModel peopleIndexViewModel = new PeopleIndexViewModel();
// Select all users on the current project
peopleIndexViewModel.PeopleInProject = from up in _db.UserProject
join u in _db.Users
on up.UserId equals u.Id
where up.ProjectId == int.Parse(Request.Cookies["CurrentProject"])
select new ListPeopleViewModel
{
FirstName = u.FirstName,
LastName = u.LastName,
Email = u.Email,
UserProjectId = up.Id
};
// Get Join ID for the project
peopleIndexViewModel.JoinId = (from p in _db.Project
where p.Id == int.Parse(Request.Cookies["CurrentProject"])
select p.JoinId).FirstOrDefault();
return(View(peopleIndexViewModel));
}
public ActionResult Index()
{
var vm = new PeopleIndexViewModel()
{
People = _context.People.OrderBy(a => a.Name).ToList(),
Rabats = _context.Rabats.OrderBy(t => t.Name).ToList(),
Person = new Person(),
};
return(View(vm));
}
public ActionResult Index(PeopleIndexViewModel model)
{
if (ModelState.IsValid)
{
_context.People.Add(model.Person);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
model.People = _context.People.OrderBy(a => a.Name).ToList();
model.Rabats = _context.Rabats.OrderBy(t => t.Name).ToList();
return(View(model));
}
// GET: People
public ActionResult Index(string letter, int page = 1)
{
var model = new PeopleIndexViewModel();
List <Person> items;
if (letter == null)
{
items = _db.Persons.OrderBy(p => p.FullName).ToList();
}
else
{
items = _db.Persons.AsEnumerable()
.Where(p => p.FullName.First() == letter.First())
.OrderBy(p => p.FullName)
.ToList();
}
var pager = new Pager(items.Count, page, 8);
model.People = items.Skip((pager.CurrentPage - 1) * pager.PageSize).Take(pager.PageSize);
model.Pager = pager;
model.FirstLetters = _db.Persons.AsEnumerable().Select(p => p.FullName.First()).Distinct().OrderBy(c => c).ToArray();
model.Letter = letter;
return(View(model));
}
