public ActionResult leaveProject(int id)//\\\\\\\\\\UPDATED
{
if (!homeController.Authenticated)
{
return(RedirectToAction("Index", "home"));
}
if (Session["id"] != null)
{
int mtlid = Convert.ToInt32(Session["id"]);
Employee_Request req = db.Employee_Request.FirstOrDefault(u => u.Project_ID == id && u.Reciever_ID == mtlid);
db.Database.ExecuteSqlCommand("delete from WorksOn Where WorksOn.Emp_ID = @mtl_id and WorksOn.ProjectID = @pid", new SqlParameter("@mtl_id", mtlid), new SqlParameter("@pid", req.Project_ID));
//Employee_Request newreq = new Employee_Request();
//newreq.Sender_ID = mtlid;
//newreq.Reciever_ID = req.Sender_ID;
//newreq.Project_ID = id;
//newreq.Status_ID = 1;
//db.Employee_Request.Add(newreq);
//db.SaveChanges();
db.Employee_Request.Remove(req);
db.SaveChanges();
Response.Write("<script>alert('You Leaved Project Successfully .');</script>");
TempData["msg10"] = "<script>alert('You Leaved Project Successfully !');</script>";
}
return(RedirectToAction("Index"));
}
public ActionResult leaveProject(int id)
{
if (!homeController.Authenticated)
{
return(RedirectToAction("Index", "home"));
}
if (Session["id"] != null)
{
int mtid = Convert.ToInt32(Session["id"]);
Employee_Request req = db.Employee_Request.FirstOrDefault(u => u.Project_ID == id && u.Reciever_ID == mtid);
Employee_Request newreq = new Employee_Request();
newreq.Sender_ID = mtid;
newreq.Reciever_ID = req.Sender_ID;
newreq.Project_ID = id;
newreq.Status_ID = 1;
Debug.WriteLine("dddd" + newreq.ToString());
db.Employee_Request.Add(newreq);
db.SaveChanges();
Response.Write("<script>alert('Request To Director Sent Successfully .');</script>");
TempData["msg10"] = "<script>alert('Request To Director Sent Successfully !');</script>";
}
return(RedirectToAction("Index"));
}
public ActionResult Send_EMP_MD_Request(int?id)
{
if (!homeController.Authenticated)
{
return(RedirectToAction("Index", "home"));
}
int proid = Convert.ToInt32(Session["project_Id"]);
if (id != null)
{
//Debug.WriteLine(pro.ID + pro.ProjectTitle + pro.Description + "ana project fe Send_EMP_MD_Request");
//Debug.WriteLine(emp.FirstName + emp.ID+ "ana emp fe Send_EMP_MD_Request");
//Debug.WriteLine(Convert.ToInt32(Session["id"])+"ana MD ID");
Employee_Request emp_Request = new Employee_Request();
emp_Request.Sender_ID = Convert.ToInt32(Session["id"]);
emp_Request.Reciever_ID = (int)id;
emp_Request.Status_ID = 1;
emp_Request.Project_ID = proid;
db.Employee_Request.Add(emp_Request);
db.SaveChanges();
Response.Write("<script>alert('Request Has Been Sent Successfully .');</script>");
Session["msg10"] = "<script>alert('Request Has Been Sent Successfully !');</script>";
return(RedirectToAction("Create_Team_Module", new { id = proid }));
}
else
{
return(RedirectToAction("Index"));
}
}
public static void AddReq()
{
requestid = getRequestId() + 1;
Employee_Request req = new Employee_Request();
req.Department_ID = "CMC";
req.Employee_ID = "CMC003";
req.Date_of_Request = System.DateTime.Now;
entities.Employee_Request.Add(req);
entities.SaveChanges();
}
public ActionResult approveMemberLeaving(int id)////////////////////////////////////////////
{
if (!homeController.Authenticated)
{
return(RedirectToAction("Index", "home"));
}
Employee_Request req = db.Employee_Request.Find(id);
db.Database.ExecuteSqlCommand("delete from WorksOn where WorksOn.Emp_ID =@id AND WorksOn.ProjectID =@pid ", new SqlParameter("@pid", req.Project_ID), new SqlParameter("@id", req.Sender_ID));
db.Database.ExecuteSqlCommand("delete from Employee_Request where Reciever_ID = @memid and Project_ID = @pid ", new SqlParameter("@pid", req.Project_ID), new SqlParameter("@memid", req.Sender_ID));
db.Database.ExecuteSqlCommand("delete from Employee_Request where Sender_ID = @memid and Project_ID = @pid ", new SqlParameter("@pid", req.Project_ID), new SqlParameter("@memid", req.Sender_ID));
Response.Write("<script>alert('Member Removed Successfully .');</script>");
Session["msg10"] = "<script>alert('Member Removed Successfully !');</script>";
return(RedirectToAction("Index"));
}
public ActionResult sendRequest(int tid)
{
if (!homeController.Authenticated)
{
return(RedirectToAction("Index", "home"));
}
int ID = Convert.ToInt32(Session["id"]);
Employee_Request Request = new Employee_Request();
Request.Sender_ID = ID;
Request.Reciever_ID = tid;
Request.Status_ID = 1;
Request.Project_ID = Convert.ToInt32(Session["pmid"]);
db.Employee_Request.Add(Request);
db.SaveChanges();
Response.Write("<script>alert('Request sent Successfully .');</script>");
TempData["msg10"] = "<script>alert('Request sent Successfully !');</script>";
return(RedirectToAction("LISTALLTRAINEES", new { pmID = Request.Project_ID }));
}
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"));
}
protected void btn_Submitrequest_Click(object sender, EventArgs e)
{
List <EmployeeMakeReq> employeeMakes = new List <EmployeeMakeReq>();
int count = Requestdetails.Rows.Count;
for (int i = 0; i < count; i++)
{
GridViewRow r = Requestdetails.Rows[i];
DropDownList description = (DropDownList)r.Cells[1].FindControl("DropDownList2");
TextBox b = (TextBox)r.Cells[2].FindControl("TextBox1");
string desc = description.Text.ToString();
int quantity = Convert.ToInt32(b.Text);
employeeMakes.Add(new EmployeeMakeReq(desc, quantity));
}
try
{
Employee user = (Employee)Session["user"];
using (Logic_University_Entity entities = new Logic_University_Entity())
{
Employee_Request request = new Employee_Request();
request.Department_ID = user.Department_ID;
request.Employee_ID = user.Employee_ID;
request.Date_of_Request = System.DateTime.Now;
request.Status = "Pending";
entities.Employee_Request.Add(request);
entities.SaveChanges();
Employee_Request Requestid = entities.Employee_Request.OrderByDescending(x => x.Request_ID).Take(1).FirstOrDefault();
foreach (var v in employeeMakes)
{
var xy = (from z in entities.Inventories where z.Description == v.Description select z.Item_Number).SingleOrDefault();
string itemnumber = xy.ToString();
Emp_Request_items item = new Emp_Request_items();
item.Request_ID = Requestid.Request_ID;
item.Item_Number = itemnumber;
item.Quantity = v.Quantity;
item.Status = "Pending";
entities.Emp_Request_items.Add(item);
entities.SaveChanges();
}
btn_Submitrequest.Enabled = false;
}
MailMessage mail = new MailMessage();
mail.IsBodyHtml = false;
string empid = user.Employee_ID;
string mv = sm.Employees.Where(x => x.Employee_ID == empid).FirstOrDefault <Employee>().Email;
mail.To.Add(mv);
mail.Subject = "Application for Stationary requests";
string name = user.Employee_Name;
mail.Body = "Hi HOD," + Environment.NewLine + "I've applied for stationary." + Environment.NewLine + "Best Regards," + Environment.NewLine + name;
SmtpClient smtp = new SmtpClient();
mail.From = new MailAddress("*****@*****.**", "Surendran");
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = false;
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "littleflower");
smtp.EnableSsl = true;
smtp.Send(mail);
Response.Write(@"<script language='javascript'>alert('Request Sent successfully');window.location.href='RepHome.aspx'</script>");
}
catch (Exception)
{
}
}
