public ActionResult Delete(int?id) { if (id != 0) { if ((Convert.ToInt32(Session["usertype"]) == 3)) { var x = db.ApprovedProjects.Where(y => y.project_id == id).Select(y => y.ApprovedProjectID).SingleOrDefault(); approve = db.ApprovedProjects.Find(x); if (approve == null) { return(HttpNotFound()); } return(View(approve)); } else { return(RedirectToAction("../ProjectManager/Project")); } } else { return(RedirectToAction("../ProjectManager/Project")); } }
public ActionResult Delete(int id) { try { var x = db.ApprovedProjects.Where(y => y.project_id == id).Select(y => y.ApprovedProjectID).SingleOrDefault(); approve = db.ApprovedProjects.Find(x); db.ApprovedProjects.Remove(approve); // ViewBag.Error = "ImageDeleted"; db.SaveChanges(); Con = new SqlConnection(@"Data source=DESKTOP-OJT395D;initial catalog=projectMSys;integrated security=True;multipleactiveresultsets=True;application name=EntityFramework"); Con.Open(); // UpdateStatment = new SqlCommand("Update Requests set R_status = '" + 0 + "' Where Project_ID = '" + pro.Project_ID + "' ", Con); Update = new SqlCommand("Update projects set Post_Status = '" + 0 + "' Where PostID = '" + approve.project_id + "'", Con); Update.ExecuteNonQuery(); return(RedirectToAction("Project")); } catch { return(View()); } }
public ActionResult ApprovedRequest(ApprovedProject approve, Request request) { if (ModelState.IsValid) { int id = Convert.ToInt32(Session["ID"]); var writer = db.users.Where(model => model.Id == id).FirstOrDefault(); approve.Cust_id = writer.Id; approve.project_id = request.Project_ID; approve.ProjectMang_id = request.PM_ID; db.ApprovedProjects.Add(approve); db.SaveChanges(); Con = new SqlConnection(@"Data source=DESKTOP-OJT395D;initial catalog=projectMSys;integrated security=True;multipleactiveresultsets=True;application name=EntityFramework"); Con.Open(); UpdateStatment = new SqlCommand("Update Requests set R_status = '" + 1 + "' Where Project_ID = '" + request.Project_ID + "' ", Con); Update = new SqlCommand("Update projects set Post_Status = '" + 1 + "' ", Con); UpdateStatment.ExecuteNonQuery(); return(RedirectToAction("Allrequest")); } return(View()); }
public ActionResult SendRequestTL(TLRequest tLrequest, ApprovedProject approve, user user) { if (ModelState.IsValid) { int id = Convert.ToInt32(Session["ID"]); var writer = db.users.Where(model => model.user_Type == 4).FirstOrDefault(); tLrequest.TL_ID = writer.Id; tLrequest.Project_ID = approve.project_id; tLrequest.R_Status = 0; db.TLRequests.Add(tLrequest); db.SaveChanges(); return(RedirectToAction("TeamLeader")); } var PrjList = from prj in db.ApprovedProjects join Pr in db.projects on prj.project_id equals Pr.PostID select new { Project_ID = prj.project_id, Project_name = Pr.Title }; //produces flat sequence ViewBag.Projects = new SelectList(PrjList, "Project_ID", "Project_name", approve.project_id); return(View()); }
public ActionResult SendRequestJD(JDRequest jdreq, ApprovedProject approve, user user) { if (ModelState.IsValid) { int id = Convert.ToInt32(Session["ID"]); var writer = db.users.Where(model => model.user_Type == 5).FirstOrDefault(); jdreq.User_ID = writer.Id; jdreq.proj_ID = approve.project_id; jdreq.Rj_status = 0; db.JDRequests.Add(jdreq); db.SaveChanges(); return(RedirectToAction("JuniorDeveloper")); } var PrjList = from prj in db.ApprovedProjects join Pr in db.projects on prj.project_id equals Pr.PostID select new { Project_ID = prj.project_id, Project_name = Pr.Title }; //produces flat sequence ViewBag.Projects = new SelectList(PrjList, "Project_ID", "Project_name", approve.project_id); return(View()); }