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());
}
