// GET: HRMS_TRAINING_EFFECTIVENESS_REMARKS/Edit/5 // POST: HRMS_TRAINING_EFFECTIVENESS_REMARKS/Edit/5 // To protect from overposting attacks, please enable the specific properties you want to bind to, for // more details see https://go.microsoft.com/fwlink/?LinkId=317598. public bool Delete(long id) { HRMS_TRAINING_EFFECTIVENESS_REMARKS hRMS_TRAINING_EFFECTIVENESS_REMARKS = db.HRMS_TRAINING_EFFECTIVENESS_REMARKS.Find(id); if (hRMS_TRAINING_EFFECTIVENESS_REMARKS != null) { //long P_id = hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID; db.HRMS_TRAINING_EFFECTIVENESS_REMARKS.Remove(hRMS_TRAINING_EFFECTIVENESS_REMARKS); db.SaveChanges(); var c = db.HRMS_TrainingApproval.Where(x => x.EMP_ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Emp_ID && x.Program_ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID && x.Status == 2).Select(x => x.ID).FirstOrDefault(); HRMS_TrainingApproval hRMS_TrainingApproval = db.HRMS_TrainingApproval.Find(c); if (hRMS_TrainingApproval.Remark != false) { hRMS_TrainingApproval.Remark = false; db.Entry(hRMS_TrainingApproval).State = EntityState.Modified; db.SaveChanges(); } return(true); } else { return(false); } }
public ActionResult Vieww(HRMS_TrainingApproval obj) { obj.Status = 1; //pending request db.HRMS_TrainingApproval.Add(obj); db.SaveChanges(); return(RedirectToAction("Index")); }
//Cancel public ActionResult Reject(long id) { HRMS_TrainingApproval obj = db.HRMS_TrainingApproval.Where(x => x.ID == id).FirstOrDefault(); obj.Status = 3;//Reject db.Entry(obj).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("RequestList", new { id = obj.Program_ID })); }
public ActionResult Revieww(IEnumerable <string> Answer, IEnumerable <long> Question, IEnumerable <string> flag, String Textt, string Check) { //Answer.Zip(Question, Tuple.Create) //a:answer //b:question //c:flag long ProID = Convert.ToInt64(TempData["ProgramID"]); if (Textt == "") { TempData["Error"] = "Please!Fill the Rating!"; return(RedirectToAction("Review", new { id = ProID })); } long empid = Convert.ToInt64(Session["id"]); // long ProID =Convert.ToInt64(TempData["ProgramID"]); var results = Answer.ZipThree(Question, flag, (a, b, c) => new { a, b, c }); foreach (var item in results) { HRMS_TrainingReview obj = new HRMS_TrainingReview(); obj.Emp_ID = empid; obj.ProgramID = ProID; obj.QuestionID = item.b; obj.Date = DateTime.Now; obj.OtherComments = Textt; if (Check != null) { obj.IsWorthy = true; } else { obj.IsWorthy = false; } if (item.c == "False") //dropdown { obj.NonDescriptive = Convert.ToInt32(item.a); } else { obj.Descriptive = item.a; } db.HRMS_TrainingReview.Add(obj); db.SaveChanges(); } //flag insert in trainingApproval HRMS_TrainingApproval TA = db.HRMS_TrainingApproval.Where(x => x.Program_ID == ProID && x.EMP_ID == empid).FirstOrDefault(); TA.IsReviewDone = 1; //Review Done db.Entry(TA).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
//approve public ActionResult Approve(long id) { HRMS_TrainingApproval obj = db.HRMS_TrainingApproval.Where(x => x.ID == id).FirstOrDefault(); obj.ApproveBy = Convert.ToInt64(Session["id"]); obj.ApproveDate = DateTime.Now; obj.Status = 2;//approved db.Entry(obj).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("RequestList", new { id = obj.Program_ID })); }
public ActionResult EditEmployeeSelection(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } //TrainingEmployeeSelection trainingEmployeeSelection = new TrainingEmployeeSelection(); HRMS_ProgramDetail programDetail = db.HRMS_ProgramDetail.Find(id); //List< HRMS_TrainingApproval> employeeList = db.HRMS_TrainingApproval.Where(rec=>rec.Program_ID == id).ToList(); if (programDetail == null) { return(HttpNotFound()); } //trainingEmployeeSelection.programDetail = programDetail; ViewBag.ID = programDetail.ID; ViewBag.ProgramName = programDetail.ProgramName; ViewBag.ProgramType = programDetail.ProgramType; ViewBag.TrainingType = programDetail.TrainingType; ViewBag.FromDate = programDetail.FromDate; ViewBag.ToDate = programDetail.ToDate; ViewBag.FromTime = programDetail.FromTime; ViewBag.ToTime = programDetail.ToTime; ViewBag.TransactionDate = programDetail.TransactionDate; HRMS_TrainingApproval TrainingApproval = new HRMS_TrainingApproval(); TrainingApproval.FromDate = programDetail.FromDate; TrainingApproval.ToDate = programDetail.ToDate; TrainingApproval.Program_ID = programDetail.ID; TrainingApproval.FromTime = programDetail.FromTime; TrainingApproval.ToTime = programDetail.ToTime; //trainingEmployeeSelection.employeeSelection = TrainingApproval; //if (employeeList != null) //{ // trainingEmployeeSelection.employeeDataList = employeeList; //} return(View(TrainingApproval)); }
public bool deleteEmployee(long id) { HRMS_TrainingApproval Employee = db.HRMS_TrainingApproval.Find(id); if (Employee != null) { Employee.Status = 3; db.Entry(Employee).State = EntityState.Modified; db.SaveChanges(); ModelState.Clear(); return(true); } else { return(false); } }
public ActionResult EmployeeAttandance(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HRMS_TrainingApproval Program = db.HRMS_TrainingApproval.Where(rec => rec.Program_ID == id).FirstOrDefault(); if (Program == null) { return(HttpNotFound()); } ViewBag.FromDate = Program.FromDate; ViewBag.ToDate = Program.ToDate; ViewBag.ProgramID = Program.Program_ID; return(View()); }
public JsonResult EditEmployeeSelectiondata(HRMS_TrainingApproval hRMS_TrainingApproval) { //HRMS_TrainingApproval hRMS_TrainingApproval = employeeSelection.employeeSelection; var EmpDetails = db.HRMS_Emp_Details.Where(rec => rec.EMP_ID == hRMS_TrainingApproval.EMP_ID).FirstOrDefault(); hRMS_TrainingApproval.Designation = EmpDetails.Designation; hRMS_TrainingApproval.EmpDept = EmpDetails.Department; hRMS_TrainingApproval.EmpName = EmpDetails.Display_Name; hRMS_TrainingApproval.Status = 2; hRMS_TrainingApproval.ApproveBy = Convert.ToInt64(Session["id"]); hRMS_TrainingApproval.ApproveDate = DateTime.Now.Date; var exist = db.HRMS_TrainingApproval.Where(rec => rec.EMP_ID == hRMS_TrainingApproval.EMP_ID && rec.Program_ID == hRMS_TrainingApproval.Program_ID && rec.Status == 2).FirstOrDefault(); if (exist == null) { var existsameEmp = db.HRMS_TrainingApproval.Where(rec => rec.EMP_ID == hRMS_TrainingApproval.EMP_ID && rec.Program_ID == hRMS_TrainingApproval.Program_ID).FirstOrDefault(); if (existsameEmp == null) { db.HRMS_TrainingApproval.Add(hRMS_TrainingApproval); db.SaveChanges(); ModelState.Clear(); var status = "Employee Added successfullly."; return(Json(status, JsonRequestBehavior.AllowGet)); } else { existsameEmp.Status = 2; existsameEmp.FromTime = hRMS_TrainingApproval.FromTime; existsameEmp.ToTime = hRMS_TrainingApproval.ToTime; db.Entry(existsameEmp).State = EntityState.Modified; db.SaveChanges(); ModelState.Clear(); var status = "Employee Added successfullly."; return(Json(status, JsonRequestBehavior.AllowGet)); } } else { var status = "Employee is already exist for this program!"; return(Json(status, JsonRequestBehavior.AllowGet)); } }
public ActionResult View(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HRMS_ProgramDetail programDetail = db.HRMS_ProgramDetail.Find(id); if (programDetail == null) { return(HttpNotFound()); } ViewBag.ID = programDetail.ID; ViewBag.ProgramName = programDetail.ProgramName; ViewBag.ProgramType = programDetail.ProgramType; ViewBag.TrainingType = programDetail.TrainingType; ViewBag.FromDate = programDetail.FromDate; ViewBag.ToDate = programDetail.ToDate; ViewBag.FromTime = programDetail.FromTime; ViewBag.ToTime = programDetail.ToTime; ViewBag.TransactionDate = programDetail.TransactionDate; HRMS_TrainingApproval TrainingApproval = new HRMS_TrainingApproval(); TrainingApproval.FromDate = programDetail.FromDate; TrainingApproval.ToDate = programDetail.ToDate; TrainingApproval.Program_ID = programDetail.ID; TrainingApproval.FromTime = programDetail.FromTime; TrainingApproval.ToTime = programDetail.ToTime; return(View(TrainingApproval)); }
public ActionResult EmailNotification(IEnumerable <string> ListOfEmp) { long programID = Convert.ToInt64(TempData["Pro_ID"]); if (ListOfEmp == null) { TempData["Error"] = "Please!Select atleast one employee!"; return(RedirectToAction("Index", new { id = programID })); } else { HRMS_ProgramDetail objj = db.HRMS_ProgramDetail.Where(x => x.ID == programID).FirstOrDefault(); string ProgramName = objj.ProgramName; string address; if (objj.Venue == "Internal") { address = "On Company Location"; } else { address = objj.Address; } foreach (var item in ListOfEmp.ToList()) { //time and date long EmpID = db.Accounts.Where(x => x.UserName == item).Select(x => x.ID).FirstOrDefault(); HRMS_TrainingApproval obj = db.HRMS_TrainingApproval.Where(x => x.Program_ID == programID && x.EMP_ID == EmpID).FirstOrDefault(); //sending Email MailMessage mail = new MailMessage(); //mail.To = accounts.UserName; mail.To.Add(item); mail.From = new MailAddress("*****@*****.**"); mail.Subject = "Training Schedule"; string htmlString = @"<html> <body> <br><br><br> <p><i>Regards,</i><br><b>Team HRMS<b></p> </body> </html> "; //mail.Body = "password:"******"<html> <b>Program Name : <b> </html> " + ProgramName + @"<html> <br> <b>From Date : <b> </html> " + obj.FromDate?.ToShortDateString() + @"<html> <br> <b>To Date : <b> </html> " + obj.ToDate?.ToShortDateString() + @"<html> <br> <b>From Time : <b> </html> " + obj.FromTime + @"<html> <br> <b>To Time : <b> </html> " + obj.ToTime + @"<html> <br> <b>Venue : <b> </html> " + address + htmlString; mail.IsBodyHtml = true; SmtpClient smtp = new SmtpClient(); smtp.Host = "smtp.gmail.com"; smtp.Port = 587; // smtp.UseDefaultCredentials = false; smtp.UseDefaultCredentials = true; smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Aniket@Vikalp"); // Enter seders User name and password smtp.EnableSsl = true; smtp.Send(mail); //update email flag obj.IsEmailSent = 1; //email sent db.Entry(obj).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("Index", "TrainingApproval")); } }
//View Program public ActionResult View(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HRMS_ProgramDetail obj = db.HRMS_ProgramDetail.Find(id.Value); HRMS_TrainingApproval obj1 = new HRMS_TrainingApproval(); obj1.EMP_ID = Convert.ToInt64(Session["id"]); HRMS_Emp_Details Detail = db.HRMS_Emp_Details.Where(x => x.EMP_ID == obj1.EMP_ID).FirstOrDefault(); obj1.Designation = Detail.Designation; obj1.EmpDept = Detail.Department; obj1.Program_ID = id.Value; obj1.EmpName = Detail.First_Name + " " + Detail.Last_Name; // obj1.HRMS_ProgramDetail.FromDate = obj.FromDate; //readonly dropdown ViewBag.Designation = new SelectList(db.HRMS_DESG_MS.Where(x => x.Desg_Id == obj1.Designation), "Desg_Id", "Desg_Name"); ViewBag.EmpDept = new SelectList(db.HRMS_DEPT.Where(x => x.Dept_Id == obj1.EmpDept), "Dept_Id", "Dept_Name"); ViewBag.Program_ID = new SelectList(db.HRMS_ProgramDetail.Where(x => x.ID == obj1.Program_ID), "ID", "ProgramName"); // ViewBag.xyz = new SelectList(db.HRMS_ProgramDetail.Where(x => x.ID == obj1.Program_ID), "FromDate", "FromDate"); obj1.FromDate = obj.FromDate; obj1.ToDate = obj.ToDate; obj1.FromTime = obj.FromTime; obj1.ToTime = obj.ToTime; //NoOfDays TimeSpan?difference = obj.ToDate - obj.FromDate; ViewBag.NoOfDays = difference.Value.TotalDays; ViewBag.remarks = obj.Remarks; //already Exist or completed if (User.IsInRole("emp")) { bool IsExist = db.HRMS_TrainingApproval.Any(x => x.EMP_ID == obj1.EMP_ID && x.Program_ID == id.Value); bool IsExist1 = db.HRMS_ProgramDetail.Any(x => x.ID == id.Value && x.TrainingStatus == "Completed"); if (IsExist || IsExist1) { ViewBag.exist = "Exist"; } HRMS_TrainingApproval status = db.HRMS_TrainingApproval.Where(x => x.EMP_ID == obj1.EMP_ID && x.Program_ID == id.Value).FirstOrDefault(); if (status != null) { if (status.Status == 1) { ViewBag.msg = "Your Request is in Pending!"; } else if (status.Status == 2) { ViewBag.msg = "Your Request is Approved!"; } else if (status.Status == 3) { ViewBag.msg = "Your Request is Cancelled!"; } } } return(View(obj1)); }
public ActionResult Create([Bind(Include = "Remark_ID,Program_Det_ID,Emp_ID,HOD_ID,HOD_Remarks,Trainee_Remarks,HOD_View,Remark_Date")] HRMS_TRAINING_EFFECTIVENESS_REMARKS hRMS_TRAINING_EFFECTIVENESS_REMARKS) { ViewBag.Program_Det_ID = db.HRMS_ProgramDetail.Where(x => x.ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID).FirstOrDefault(); var a = db.HRMS_ProgramDetail.Where(x => x.ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID).Select(x => x.TrainingID).FirstOrDefault(); var b = db.HRMS_Training_Request_Application.Where(x => x.ApplicationId == a).Select(x => x.EmpID).FirstOrDefault(); ViewBag.HOD_Detail = db.Accounts.Where(x => x.ID == b).FirstOrDefault(); ViewBag.EMP_List = db.HRMS_TrainingApproval.Where(x => x.Remark == false && x.Status == 2 && x.Program_ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID).ToList(); if (ModelState.IsValid) { if (!db.HRMS_TRAINING_EFFECTIVENESS_REMARKS.Where(x => x.Program_Det_ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID && x.Emp_ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Emp_ID).Any() && hRMS_TRAINING_EFFECTIVENESS_REMARKS.Emp_ID != 0) { db.HRMS_TRAINING_EFFECTIVENESS_REMARKS.Add(hRMS_TRAINING_EFFECTIVENESS_REMARKS); db.SaveChanges(); var c = db.HRMS_TrainingApproval.Where(x => x.EMP_ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Emp_ID && x.Program_ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID && x.Status == 2).Select(x => x.ID).FirstOrDefault(); HRMS_TrainingApproval hRMS_TrainingApproval = db.HRMS_TrainingApproval.Find(c); if (hRMS_TrainingApproval.Remark != true) { hRMS_TrainingApproval.Remark = true; db.Entry(hRMS_TrainingApproval).State = EntityState.Modified; db.SaveChanges(); ModelState.Clear(); } ViewBag.Program_Det_ID = db.HRMS_ProgramDetail.Where(x => x.ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID).FirstOrDefault(); var b3 = db.HRMS_ProgramDetail.Where(x => x.ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID).Select(x => x.TrainingID).FirstOrDefault(); var z1 = db.HRMS_Training_Request_Application.Where(x => x.ApplicationId == b3).Select(x => x.EmpID).FirstOrDefault(); ViewBag.HOD_Detail = db.Accounts.Where(x => x.ID == z1).FirstOrDefault(); ViewBag.EMP_List = db.HRMS_TrainingApproval.Where(x => x.Remark == false && x.Status == 2 && x.Program_ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID).ToList(); return(View()); //return RedirectToAction("Index1"); } } else if (hRMS_TRAINING_EFFECTIVENESS_REMARKS.Emp_ID == 0 && hRMS_TRAINING_EFFECTIVENESS_REMARKS.HOD_Remarks != null && hRMS_TRAINING_EFFECTIVENESS_REMARKS.Trainee_Remarks != null && hRMS_TRAINING_EFFECTIVENESS_REMARKS.HOD_View != null && hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID != 0 && hRMS_TRAINING_EFFECTIVENESS_REMARKS.HOD_ID != 0 && hRMS_TRAINING_EFFECTIVENESS_REMARKS.Remark_Date != null) { var a1 = db.HRMS_TrainingApproval.Where(x => x.Remark != true && x.Program_ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID && x.Status == 2).Select(x => x.EMP_ID).ToList(); if (a1 != null) { foreach (var item in a1) { hRMS_TRAINING_EFFECTIVENESS_REMARKS.Emp_ID = item; db.HRMS_TRAINING_EFFECTIVENESS_REMARKS.Add(hRMS_TRAINING_EFFECTIVENESS_REMARKS); db.SaveChanges(); var c = db.HRMS_TrainingApproval.Where(x => x.EMP_ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Emp_ID && x.Program_ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID && x.Status == 2).Select(x => x.ID).FirstOrDefault(); HRMS_TrainingApproval hRMS_TrainingApproval = db.HRMS_TrainingApproval.Find(c); if (hRMS_TrainingApproval.Remark != true) { hRMS_TrainingApproval.Remark = true; db.Entry(hRMS_TrainingApproval).State = EntityState.Modified; db.SaveChanges(); } } } ViewBag.Program_Det_ID = db.HRMS_ProgramDetail.Where(x => x.ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID).FirstOrDefault(); var b1 = db.HRMS_ProgramDetail.Where(x => x.ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID).Select(x => x.TrainingID).FirstOrDefault(); var z2 = db.HRMS_Training_Request_Application.Where(x => x.ApplicationId == b1).Select(x => x.EmpID).FirstOrDefault(); ViewBag.HOD_Detail = db.Accounts.Where(x => x.ID == z2).FirstOrDefault(); ViewBag.EMP_List = db.HRMS_TrainingApproval.Where(x => x.Remark == false && x.Status == 2 && x.Program_ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID).ToList(); return(View()); } else { ViewBag.Program_Det_ID = db.HRMS_ProgramDetail.Where(x => x.ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID).FirstOrDefault(); var b2 = db.HRMS_ProgramDetail.Where(x => x.ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID).Select(x => x.TrainingID).FirstOrDefault(); var z3 = db.HRMS_Training_Request_Application.Where(x => x.ApplicationId == b2).Select(x => x.EmpID).FirstOrDefault(); ViewBag.HOD_Detail = db.Accounts.Where(x => x.ID == z3).FirstOrDefault(); ViewBag.EMP_List = db.HRMS_TrainingApproval.Where(x => x.Remark == false && x.Status == 2 && x.Program_ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID).ToList(); return(View()); } //ViewBag.Program_Det_ID = new SelectList(db.HRMS_ProgramDetail, "ID", "ProgramName", hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID); ViewBag.Program_Det_ID = db.HRMS_ProgramDetail.Where(x => x.ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID).FirstOrDefault(); var z4 = db.HRMS_ProgramDetail.Where(x => x.ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID).Select(x => x.TrainingID).FirstOrDefault(); var z5 = db.HRMS_Training_Request_Application.Where(x => x.ApplicationId == z4).Select(x => x.EmpID).FirstOrDefault(); ViewBag.HOD_Detail = db.Accounts.Where(x => x.ID == z5).FirstOrDefault(); ViewBag.EMP_List = db.HRMS_TrainingApproval.Where(x => x.Remark == false && x.Status == 2 && x.Program_ID == hRMS_TRAINING_EFFECTIVENESS_REMARKS.Program_Det_ID).ToList(); return(View()); }