public ActionResult Send_Cu_MD_Request(int?id) { if (!homeController.Authenticated) { return(RedirectToAction("Index", "home")); } if (id != null) { Project pro = db.Project.Find(id); // Debug.WriteLine(id); MD_Cust_Request Pro_Request = new MD_Cust_Request(); Pro_Request.MD_ID = Convert.ToInt32(Session["id"]); Pro_Request.Customer_ID = pro.Customer_ID; Pro_Request.Status_ID = 1; Pro_Request.Project_ID = pro.ID; db.MD_Cust_Request.Add(Pro_Request); db.SaveChanges(); Response.Write("<script>alert('Request Has Been Sent Successfully .');</script>"); TempData["msg10"] = "<script>alert('Request Has Been Sent Successfully !');</script>"; // TempData["msg"] = "<script>alert('Request Has Been Sent Successfully .');</script>"; return(RedirectToAction("Index")); } else { return(RedirectToAction("Index")); } }
public ActionResult AssignProjectToMD(int?id) { if (!homeController.Authenticated) { return(RedirectToAction("Index", "home")); } if (id != null) { MD_Cust_Request mD_Cust_Request = db.MD_Cust_Request.Find(id); db.Database.ExecuteSqlCommand("update MD_Cust_Request set Status_ID = 2 where ID = @rid", new SqlParameter("@rid", mD_Cust_Request.ID)); db.Database.ExecuteSqlCommand("delete from MD_Cust_Request where ID != @rid and Project_ID = @pid", new SqlParameter("@rid", mD_Cust_Request.ID), new SqlParameter("@pid", mD_Cust_Request.Project_ID)); db.SaveChanges(); Response.Write("<script>alert('Project Assigned To Director Successfully .');</script>"); TempData["msg10"] = "<script>alert('Project Assigned To Director Successfully !');</script>"; } return(RedirectToAction("Index", "Customer")); }