public ActionResult PendingExpertRequestDetails([Bind(Exclude = "OrcaUserName,FirstName,LastName,Email,PhoneNumber", Include = "OrcaUserID, ExpertStatus")] PendingExpertRequest pendingExpertRequest)
{
int oid = pendingExpertRequest.OrcaUserID;
if (ModelState.IsValid)
{
OrcaContext db = new OrcaContext();
ExpertConsultant expToUpdate = db.ExpertConsultants.Find(pendingExpertRequest.OrcaUserID);
expToUpdate.ExpertStatus = pendingExpertRequest.ExpertStatus;
db.Entry(expToUpdate).State = EntityState.Modified;
db.SaveChanges();
//OrcaUserType.Consultant
if (pendingExpertRequest.ExpertStatus == ExpertStatus.Approved)
{
OrcaUser requestingUser = db.OrcaUsers.Find(pendingExpertRequest.OrcaUserID);
requestingUser.UserType = OrcaUserType.Consultant;
db.Entry(requestingUser).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("PendingExpertRequests"));
}
return(View(pendingExpertRequest));
}
public ActionResult PendingExpertRequests()
{
OrcaContext db = new OrcaContext();
// List<PendingExpertRequest> pendingRequests
List <ExpertConsultant> pendingRequests = (from pen in db.ExpertConsultants
where pen.ExpertStatus == ExpertStatus.Requested
select pen).ToList();
List <PendingExpertRequest> pendingExpertRequests = new List <PendingExpertRequest>();
foreach (ExpertConsultant per in pendingRequests)
{
PendingExpertRequest userRequesting = new PendingExpertRequest();
int oid = per.OrcaUserID;
OrcaUser ou = db.OrcaUsers.Find(oid);
userRequesting.OrcaUserID = oid;
userRequesting.OrcaUserName = ou.OrcaUserName;
userRequesting.FirstName = ou.FirstName;
userRequesting.LastName = ou.LastName;
userRequesting.Email = ou.Email;
userRequesting.PhoneNumber = ou.PhoneNumber;
pendingExpertRequests.Add(userRequesting);
}
return(View(pendingExpertRequests));
}
public ActionResult PendingExpertRequestDetails(int?OrcaUserID)
{
OrcaContext db = new OrcaContext();
PendingExpertRequest pendingRequester = new PendingExpertRequest();
int oid = (int)OrcaUserID;
OrcaUser ou = db.OrcaUsers.Find(oid);
ExpertConsultant exp = db.ExpertConsultants.Find(oid);
ou = db.OrcaUsers.Find(oid);
pendingRequester.OrcaUserID = ou.OrcaUserID;
pendingRequester.ExpertStatus = exp.ExpertStatus;
pendingRequester.OrcaUserName = ou.OrcaUserName;
pendingRequester.FirstName = ou.FirstName;
pendingRequester.LastName = ou.LastName;
pendingRequester.Email = ou.Email;
pendingRequester.PhoneNumber = ou.PhoneNumber;
return(View(pendingRequester));
}