public ActionResult Assign_Pro_Emp_Confirmed(int id)///\\\\\\\\\\UPDATED--------------------------------
{
if (!homeController.Authenticated)
{
return(RedirectToAction("Index", "home"));
}
Employee_Request req = db.Employee_Request.Find(id);
WorksOn pro = new WorksOn();
pro.Emp_ID = req.Reciever_ID;
pro.ProjectID = req.Project_ID;
db.WorksOn.Add(pro);
db.SaveChanges();
db.Database.ExecuteSqlCommand("update Employee_Request set Employee_Request.Status_ID = 3 Where ID = @rid", new SqlParameter("@rid", id));
Response.Write("<script>alert('Member Added Successfully .');</script>");
Session["msg10"] = "<script>alert('Member Added Successfully !');</script>";
//db.Employee_Request.Remove(req);
//db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult EVALUATETRAINEE(int id, String textbox)
{
if (!homeController.Authenticated)
{
return(RedirectToAction("Index", "home"));
}
//if (Session["userName"] == null)
//{
// return RedirectToAction("Index", "home");
//}
Debug.WriteLine("string : " + textbox + " ID : " + id);
WorksOn mt = db.WorksOn.Find(id);
Debug.WriteLine("pro : " + mt.ProjectID + " ID : " + mt.Emp_ID);
var IsEvaluated = db.MT_Evaluation.FirstOrDefault(u => u.MT_ID == mt.Emp_ID && u.Project_ID == mt.ProjectID);
if (IsEvaluated != null)
{
db.Database.ExecuteSqlCommand("update MT_Evaluation set FeedBack = '" + textbox + "' where Project_ID = @pid and MT_ID = @mtid", new SqlParameter("@pid", mt.ProjectID), new SqlParameter("@mtid", mt.Emp_ID));
Response.Write("<script>alert('Evaluated Successfully .');</script>");
return(RedirectToAction("Index", "Marketing_Team_Leader"));
}
MT_Evaluation feedback = new MT_Evaluation();
feedback.MT_ID = mt.Emp_ID;
feedback.Project_ID = mt.ProjectID;
feedback.FeedBack = textbox;
db.MT_Evaluation.Add(feedback);
db.SaveChanges();
Response.Write("<script>alert('Evaluated Successfully .');</script>");
return(RedirectToAction("Index", "Marketing_Team_Leader"));
// ViewBag.UserType = new SelectList(db.EmployeeTypes.SqlQuery("select * from EmployeeType where ID = 4"), "ID", "UserType");
}
public ActionResult confirmDeletTrainee(int id)
{
if (!homeController.Authenticated)
{
return(RedirectToAction("Index", "home"));
}
//if (Session["userName"] == null)
//{
// return RedirectToAction("Index", "home");
//}
WorksOn employee = db.WorksOn.Find(id);
db.Database.ExecuteSqlCommand("delete from Employee_Request where Employee_Request.Reciever_ID = @tid and Employee_Request.Project_ID = @pid", new SqlParameter("@tid", employee.Emp_ID), new SqlParameter("@pid", employee.ProjectID));
db.WorksOn.Remove(employee);
db.SaveChanges();
TempData["msg10"] = "<script>alert('Trainee Removed Successfully .');</script>";
Response.Write("<script>alert('Trainee Removed Successfully .');</script>");
return(RedirectToAction("Index"));
}
