public ActionResult Home() { var uName = Session["PM"].ToString(); var queryU = from a in db.tbUserCredentials where a.username.Contains(uName) select a.userID; var cUserID = queryU.FirstOrDefault(); var query = from a in db.tbPMs where a.userID.Equals(cUserID) select a.pmID; var qpmID = query.FirstOrDefault(); var queryM = from a in db.tbProjects where a.pmID.Equals(qpmID) select a.projID; var prID = queryM.FirstOrDefault(); projViewModel model = new projViewModel(); model.tbProjects = db.tbProjects.Where(i => i.pmID == qpmID).ToList(); model.tbModules = db.tbModules.Where(i => i.projID == prID).ToList(); model.tbUser = db.tbUsers.Where(i => i.userID == cUserID).FirstOrDefault(); model.tbPM = db.tbPMs.Where(i => i.pmID == qpmID).FirstOrDefault(); TempData["fName"] = model.tbUser.firstName; TempData["lName"] = model.tbUser.lastName; TempData["page"] = "Home"; return(View(model)); }
public ActionResult editMod(int id, int wrID) { int modID = Convert.ToInt32(id); projViewModel model = new projViewModel(); model.tbModule = db.tbModules.Find(modID); ViewBag.wrID = wrID; TempData["page"] = "Submission"; return(View(model)); }
public ActionResult initiateProj(projViewModel model) { try{ if (HttpContext.Request.Files.AllKeys.Any()) { // Get the uploaded image from the Files collection var httpPostedFile = HttpContext.Request.Files[0]; if (httpPostedFile != null) { // Validate the uploaded image(optional) // Get the complete file path var fileSavePath = Path.Combine(Server.MapPath("~/App_Data/ProjectFiles"), model.file.FileName + model.tbPM.pmID); // Save the uploaded file to "UploadedFiles" folder httpPostedFile.SaveAs(fileSavePath); model.tbProject.fileName = model.file.FileName + model.tbPM.pmID; } } } catch { model.tbProject.fileName = ""; } var uName = Session["PM"].ToString(); var queryU = from a in db.tbUserCredentials where a.username.Contains(uName) select a.userID; var cUserID = queryU.FirstOrDefault(); var query = from a in db.tbPMs where a.userID.Equals(cUserID) select a.pmID; var qpmID = query.FirstOrDefault(); model.tbProject.pmID = Convert.ToInt16(qpmID); model.tbProject.moduleNo = "0"; model.tbProject.postDate = DateTime.Today.ToString("dd-MM-yyyy"); model.tbProject.status = "Open"; db.tbProjects.Add(model.tbProject); TempData["noOfMod"] = model.tbProject.moduleNo; TempData["fName"] = ViewBag.fname; TempData["lName"] = ViewBag.lname; db.SaveChanges(); int id = model.tbProject.projID; string sPID = Convert.ToString(id); TempData["projID"] = id; TempData["message"] = "Project Created Succesfully !"; // return RedirectToAction("project", "PM", new { id = sPID }); TempData["page"] = "initiateProj"; return(View()); //Failed to initiate project }
public ActionResult Submission(string id) { int pID = Convert.ToInt16(id); tbProjWorkroom wroom = db.tbProjWorkrooms.Find(pID); projViewModel model = new projViewModel(); model.tbProject = wroom.tbAwardedProj.tbProject; ViewBag.wroomID = pID; TempData["page"] = "Submission"; return(View(model)); }
public ActionResult project(string id) { int prjID = Convert.ToInt16(id); ViewBag.prjID = prjID; projViewModel model = new projViewModel(); model.tbProject = db.tbProjects.Where(i => i.projID == prjID).FirstOrDefault(); TempData["page"] = "projects"; return(View(model)); }
public ActionResult projects() { var uName = Session["PM"].ToString(); var user = db.tbUserCredentials.Where(u => u.username.Equals(uName)).FirstOrDefault(); var pm = user.tbUser.tbPMs.FirstOrDefault(); projViewModel model = new projViewModel(); model.tbProjects = db.tbProjects.Where(i => i.pmID == pm.pmID).OrderByDescending(x => x.postDate).ToList(); TempData["page"] = "projects"; return(View(model)); }
public ActionResult modulesBreak(string id) { //ViewBag.no = Request.QueryString["no"]; //ViewBag.projID = pr; //ViewBag.projID = Convert.ToInt16(id); int wrID = Convert.ToInt16(id); ViewBag.wrID = wrID; projViewModel model = new projViewModel(); tbProjWorkroom wroom = db.tbProjWorkrooms.Find(wrID); model.tbProject = wroom.tbAwardedProj.tbProject; TempData["page"] = "modulesBreak"; return(View(model)); }
public ActionResult editMod(int id, int wrID, projViewModel model) { tbModule module = db.tbModules.Find(id); module.description = model.tbModule.description; module.closeDate = model.tbModule.closeDate; module.devSkillLevel = model.tbModule.devSkillLevel; module.devType = model.tbModule.devType; module.category = model.tbModule.category; module.budget = model.tbModule.budget; module.skillReq = model.tbModule.skillReq; if (model.file != null) { foreach (HttpPostedFileBase file in model.files) { if (file == null) { continue; } else { if (HttpContext.Request.Files.AllKeys.Any()) { var httpPostedFile = HttpContext.Request.Files[0]; if (httpPostedFile != null) { var fileSavePath = Path.Combine(Server.MapPath("~/App_Data/ModuleFiles"), file.FileName); httpPostedFile.SaveAs(fileSavePath); module.filename = file.FileName; } } } } } db.SaveChanges(); return(RedirectToAction("Submission", "RequirementEngineer", new { id = wrID })); }
public ActionResult Submission(string id) { string mess; try { mess = TempData["message"].ToString(); TempData["message"] = mess; } catch { mess = ""; } ViewBag.wrID = id; int wrID = Convert.ToInt16(id); tbProjWorkroom wroom = db.tbProjWorkrooms.Find(wrID); projViewModel model = new projViewModel(); model.tbProject = wroom.tbAwardedProj.tbProject; TempData["page"] = "Submission"; return(View(model)); }
public ActionResult modulesBreak(projViewModel model, string count, string prj) { int no; int fileNo; try { no = model.tbModules.Count; fileNo = model.files.Count; } catch { no = 1; } int projID = Convert.ToInt16(prj); foreach (HttpPostedFileBase file in model.files) { if (HttpContext.Request.Files.AllKeys.Any()) { // Get the uploaded image from the Files collection var httpPostedFile = HttpContext.Request.Files[0]; if (httpPostedFile != null) { // Validate the uploaded image(optional) // Get the complete file path var fileSavePath = Path.Combine(Server.MapPath("~/App_Data/ModuleFiles"), model.file.FileName); // Save the uploaded file to "UploadedFiles" folder httpPostedFile.SaveAs(fileSavePath); } } } for (int i = 0; i < no; i++) { model.tbModules[i].projID = Convert.ToInt16(projID); model.tbModules[i].filename = model.files[i].FileName; db.tbModules.Add(model.tbModules[i]); db.SaveChanges(); } var queryM = from mod in db.tbModules where mod.projID == projID select mod; int noMod = 0; foreach (tbModule module in queryM) { noMod++; } var query = from proj in db.tbProjects where proj.projID == projID select proj; foreach (tbProject project in query) { project.moduleNo = Convert.ToString(noMod); } db.SaveChanges(); return(RedirectToAction("project", "PM", new { id = prj })); }
public ActionResult submitModules(projViewModel model, string count, string prj, string wr) { int no; int fileNo; try { no = model.tbModules.Count; fileNo = model.files.Count; } catch { no = 1; } int projID = Convert.ToInt16(prj); if (model.files.Count > 0) { foreach (HttpPostedFileBase file in model.files) { if (file == null) { continue; } else { if (HttpContext.Request.Files.AllKeys.Any()) { var httpPostedFile = HttpContext.Request.Files[0]; if (httpPostedFile != null) { var fileSavePath = Path.Combine(Server.MapPath("~/App_Data/ModuleFiles"), file.FileName); httpPostedFile.SaveAs(fileSavePath); } } } } } for (int i = 0; i < no; i++) { model.tbModules[i].projID = Convert.ToInt16(projID); if (model.files.Count > 0) { if (model.files[i] != null) { model.tbModules[i].filename = model.files[i].FileName; } else { model.tbModules[i].filename = "N/A"; } } model.tbModules[i].status = "Analysis"; db.tbModules.Add(model.tbModules[i]); db.SaveChanges(); } var queryM = from mod in db.tbModules where mod.projID == projID select mod; int noMod = 0; foreach (tbModule module in queryM) { noMod++; } var query = from proj in db.tbProjects where proj.projID == projID select proj; foreach (tbProject project in query) { project.moduleNo = Convert.ToString(noMod); } db.SaveChanges(); TempData["prjID"] = projID; return(RedirectToAction("modulesBreak", "RequirementEngineer", new { id = wr })); }