public IActionResult NewLeader(string id)
{
var viewmodel = new NewLeaderViewModel();
// string Sql = "select Id,FirstName,LastName,PhoneNumber from AspNetUsers";
// var temp = _context.ApplicationUser.FromSql(Sql).ToList();
var temp = _context.ApplicationUser.Select(a => new { a.Id, a.FirstName, a.LastName, a.PhoneNumber }).ToList();
var Leaderlist = new List <Leader>();
TempData["Teamid"] = id;
foreach (var item in temp)
{
var sm = new Leader();
sm.LeaderId = item.Id;
sm.FirstName = item.FirstName;
sm.LastName = item.LastName;
sm.Contact = item.PhoneNumber;
Leaderlist.Add(sm);
}
viewmodel.TeamId = id;
viewmodel.Leaders = Leaderlist;
return(View("NewLeader", viewmodel));
}
public ActionResult ConfirmLeader(NewLeaderViewModel NewLeader)
{
_context.Teams.Where(a => a.TeamId == NewLeader.TeamId).First().TeamLeaderID = NewLeader.LeaderId;
_context.SaveChanges();
return(RedirectToAction("Details", new { id = NewLeader.TeamId }));
}