public ActionResult locDetails(devViewModel model, string usID) { int uID = Convert.ToInt16(usID); var query = from user in db.tbUsers where user.userID == uID select user; foreach (tbUser u in query) { u.country = model.tbUser.country; u.state = model.tbUser.state; u.city = model.tbUser.city; u.postalCode = model.tbUser.postalCode; u.contactNumber = model.tbUser.contactNumber; u.address = model.tbUser.address; } db.SaveChanges(); var action = from dev in db.tbClients where dev.userID == uID select dev; string actionUpdated = action.FirstOrDefault().actionCont; foreach (tbClient d in action) { d.actionCont = "profileDev"; actionUpdated = d.actionCont; } db.SaveChanges(); return(RedirectToAction(actionUpdated, "Developer")); }
public ActionResult skillEnquiry(string id) { var uName = Session["dev"].ToString(); var queryU = from a in db.tbUserCredentials where a.username.Contains(uName) select a.userID; var cUserID = queryU.FirstOrDefault(); devViewModel model = new devViewModel(); model.tbUser = db.tbUsers.Where(i => i.userID == cUserID).FirstOrDefault(); return(View(model)); }
public ActionResult evalRes(string id) { int skid = Convert.ToInt16(id); devViewModel model = new devViewModel(); model.tbSkill = db.tbSkills.Where(s => s.skillID.Equals(skid)).Single(); model.tbUser = model.tbSkill.tbDeveloper.tbClient.tbUser; List <tbEvaluation> evals = db.tbEvaluations.Where(e => e.devID.Equals(model.tbSkill.devID) && e.skill.Equals(model.tbSkill.name)).ToList(); model.tbEvaluation = evals[evals.Count - 1]; return(View(model)); }
public ActionResult Home() { var uName = Session["dev"].ToString(); var dId = Convert.ToInt32(Session["devID"]); tbUserCredential user = db.tbUserCredentials.Where(uc => uc.username.Equals(uName)).Single(); devViewModel model = new devViewModel(); model.tbUser = user.tbUser; model.tbDeveloper = db.tbDevelopers.Where(d => d.tbClient.tbUser.userID == user.userID).FirstOrDefault(); model.Proposals = model.tbDeveloper.tbProposals.ToList(); model.tbAwardedModules = db.tbAwardedModules.Where(aw => aw.devID == dId).ToList(); return(View(model)); }