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