public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HRMS_Training_Request_Application hRMS_Training_Request_Application = db.HRMS_Training_Request_Application.Find(id);
var user = Convert.ToInt64(Session["id"]);
HRMS_Emp_Details employeedetail = db.HRMS_Emp_Details.Where(rec => rec.EMP_ID == hRMS_Training_Request_Application.EmpID).FirstOrDefault();
hRMS_Training_Request_Application.EmployeeName = employeedetail.Display_Name;
hRMS_Training_Request_Application.ApprovedBy_ID = user;
hRMS_Training_Request_Application.ApprovedDate = DateTime.Now;
if (hRMS_Training_Request_Application == null)
{
return(HttpNotFound());
}
ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
//ViewBag.Skill = new SelectList(db.HRMS_TRAINING_SKILL_MS, "Skill_ID", "Skill_Name");
//ViewBag.EmpID = new SelectList(db.Accounts, "ID", "UserName", hRMS_Training_Request_Application.EmpID);
//ViewBag.ApprovedBy_ID = new SelectList(db.Accounts, "ID", "UserName", hRMS_Training_Request_Application.ApprovedBy_ID);
//ViewBag.DepartmentId = new SelectList(db.HRMS_DEPT, "Dept_Id", "Dept_Name", hRMS_Training_Request_Application.DepartmentId);
//ViewBag.designationID = new SelectList(db.HRMS_DESG_MS, "Desg_Id", "Desg_Name", hRMS_Training_Request_Application.designationID);
ViewBag.Skill = new SelectList(db.HRMS_TRAINING_SKILL_MS, "Skill_ID", "Skill_Name", hRMS_Training_Request_Application.Skill);
return(View(hRMS_Training_Request_Application));
}
//[ValidateAntiForgeryToken]
public JsonResult Create(TrainingProgramCommon hRMS_ProgramDetail)
{
HRMS_ProgramDetail obj = hRMS_ProgramDetail.ProDetail;
if (obj.ToDate < obj.FromDate)
{
var msg = "ToDate must be greater than FromDate!";
return(Json(msg, JsonRequestBehavior.AllowGet));
}
else
{
db.HRMS_ProgramDetail.Add(obj);
db.SaveChanges();
ViewBag.msg = "Program Added Succesfully! Now Add Faculty!";
var ID = db.HRMS_ProgramDetail.Where(x => x.TrainingID == obj.TrainingID).Select(x => x.ID).FirstOrDefault();
//update in training request table (programFlag)
HRMS_Training_Request_Application req = db.HRMS_Training_Request_Application.Find(obj.TrainingID);
req.ProgramFlag = 1; //admin can only edit program detail
db.Entry(req).State = EntityState.Modified;
db.SaveChanges();
return(Json(ID, JsonRequestBehavior.AllowGet));
//return RedirectToAction("Index");
}
}
// GET: RequestApplication/Details/5
public ActionResult Details(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HRMS_Training_Request_Application hRMS_Training_Request_Application = db.HRMS_Training_Request_Application.Find(id);
if (hRMS_Training_Request_Application == null)
{
return(HttpNotFound());
}
return(View(hRMS_Training_Request_Application));
}
public ActionResult RemoveApplication(long id)
{
HRMS_Training_Request_Application hRMS_Training_Request_Application = db.HRMS_Training_Request_Application.Find(id);
if (hRMS_Training_Request_Application.Status == 0)
{
db.HRMS_Training_Request_Application.Remove(hRMS_Training_Request_Application);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ViewBag.RequestApplicationStatus = "You can only remove panding applications";
return(RedirectToAction("Index"));
}
}
public ActionResult Create([Bind(Include = "ApplicationId,request_date,EmpID,designationID,DepartmentId,Training_Name,TrainingDetails,ApprovedDate,Status,ApprovedBy_ID,Approved_Remarks,Skill")] HRMS_Training_Request_Application hRMS_Training_Request_Application)
{
long emp_id = Convert.ToInt64(Session["id"]);
HRMS_Emp_Details employeedetail = db.HRMS_Emp_Details.Where(rec => rec.EMP_ID == emp_id).FirstOrDefault();
hRMS_Training_Request_Application.EmployeeName = employeedetail.Display_Name;
hRMS_Training_Request_Application.designationID = employeedetail.Designation;
hRMS_Training_Request_Application.DepartmentId = employeedetail.Department;
if (ModelState.IsValid)
{
var existTrainingName = db.HRMS_Training_Request_Application.Where(rec => rec.Training_Name == hRMS_Training_Request_Application.Training_Name && rec.EmpID == hRMS_Training_Request_Application.EmpID).FirstOrDefault();
if (existTrainingName == null)
{
hRMS_Training_Request_Application.Status = 0;
db.HRMS_Training_Request_Application.Add(hRMS_Training_Request_Application);
db.SaveChanges();
ViewBag.RequestStatus = "Training Request is Added successfully.";
ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
ViewBag.Skill = new SelectList(db.HRMS_TRAINING_SKILL_MS, "Skill_ID", "Skill_Name");
return(View());
}
else
{
ViewBag.RequestStatus = "This Training Request is already exist!";
ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
ViewBag.Skill = new SelectList(db.HRMS_TRAINING_SKILL_MS, "Skill_ID", "Skill_Name");
return(View());
}
}
//ViewBag.EmpID = new SelectList(db.Accounts, "ID", "UserName", hRMS_Training_Request_Application.EmpID);
//ViewBag.ApprovedBy_ID = new SelectList(db.Accounts, "ID", "UserName", hRMS_Training_Request_Application.ApprovedBy_ID);
//ViewBag.DepartmentId = new SelectList(db.HRMS_DEPT, "Dept_Id", "Dept_Name", hRMS_Training_Request_Application.DepartmentId);
//ViewBag.designationID = new SelectList(db.HRMS_DESG_MS, "Desg_Id", "Desg_Name", hRMS_Training_Request_Application.designationID);
//ViewBag.Skill = new SelectList(db.HRMS_TRAINING_SKILL_MS, "Skill_ID", "Skill_Name", hRMS_Training_Request_Application.Skill);
ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
ViewBag.Skill = new SelectList(db.HRMS_TRAINING_SKILL_MS, "Skill_ID", "Skill_Name");
return(View(hRMS_Training_Request_Application));
}
public ActionResult Create()
{
long userId = Convert.ToInt64(Session["id"]);
HRMS_Training_Request_Application Request_Application = new HRMS_Training_Request_Application();
HRMS_Emp_Details Emp_Details = db.HRMS_Emp_Details.FirstOrDefault(rec => rec.EMP_ID == userId);
Request_Application.EmpID = userId;
Request_Application.DepartmentId = Emp_Details.Department;
Request_Application.designationID = Emp_Details.Designation;
Request_Application.request_date = DateTime.Now.Date;
Request_Application.EmployeeName = Emp_Details.Display_Name;
//ViewBag.EmpID = new SelectList(db.Accounts, "ID", "UserName");
//ViewBag.ApprovedBy_ID = new SelectList(db.Accounts, "ID", "UserName");
ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
ViewBag.Skill = new SelectList(db.HRMS_TRAINING_SKILL_MS, "Skill_ID", "Skill_Name");
return(View(Request_Application));
}
//[ValidateAntiForgeryToken]
public JsonResult Edit(TrainingProgramCommon hRMS_ProgramDetail)
{
HRMS_ProgramDetail obj = hRMS_ProgramDetail.ProDetail;
if (obj.Extra == "Hello")
{
var msg = "Sorry";
return(Json(msg, JsonRequestBehavior.AllowGet));
}
if (obj.ToDate < obj.FromDate)
{
var msg = "ToDate must be greater than FromDate!";
return(Json(msg, JsonRequestBehavior.AllowGet));
}
else
{
if (obj.TrainingStatus == "Completed")
{
HRMS_Training_Request_Application req = db.HRMS_Training_Request_Application.Where(x => x.ApplicationId == obj.TrainingID).FirstOrDefault();
req.ProgramFlag = 2; //completed
db.Entry(req).State = EntityState.Modified;
db.SaveChanges();
}
if (obj.TrainingStatus == "Cancel")
{
HRMS_Training_Request_Application req = db.HRMS_Training_Request_Application.Where(x => x.ApplicationId == obj.TrainingID).FirstOrDefault();
req.ProgramFlag = 3; //Cancel
db.Entry(req).State = EntityState.Modified;
db.SaveChanges();
}
db.Entry(obj).State = EntityState.Modified;
db.SaveChanges();
var msg = "Done";
return(Json(msg, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Edit([Bind(Include = "ApplicationId,request_date,EmpID,designationID,DepartmentId,Training_Name,TrainingDetails,ApprovedDate,Status,ApprovedBy_ID,Approved_Remarks,Skill")] HRMS_Training_Request_Application hRMS_Training_Request_Application)
{
HRMS_Emp_Details employeedetail = db.HRMS_Emp_Details.Where(rec => rec.EMP_ID == hRMS_Training_Request_Application.EmpID).FirstOrDefault();
hRMS_Training_Request_Application.EmployeeName = employeedetail.Display_Name;
hRMS_Training_Request_Application.designationID = employeedetail.Designation;
hRMS_Training_Request_Application.DepartmentId = employeedetail.Department;
if (ModelState.IsValid)
{
db.Entry(hRMS_Training_Request_Application).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
//ViewBag.EmpID = new SelectList(db.Accounts, "ID", "UserName", hRMS_Training_Request_Application.EmpID);
//ViewBag.ApprovedBy_ID = new SelectList(db.Accounts, "ID", "UserName", hRMS_Training_Request_Application.ApprovedBy_ID);
//ViewBag.DepartmentId = new SelectList(db.HRMS_DEPT, "Dept_Id", "Dept_Name", hRMS_Training_Request_Application.DepartmentId);
//ViewBag.designationID = new SelectList(db.HRMS_DESG_MS, "Desg_Id", "Desg_Name", hRMS_Training_Request_Application.designationID);
//ViewBag.Skill = new SelectList(db.HRMS_TRAINING_SKILL_MS, "Skill_ID", "Skill_Name", hRMS_Training_Request_Application.Skill);
// ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
// ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
//ViewBag.Skill = new SelectList(db.HRMS_TRAINING_SKILL_MS, "Skill_ID", "Skill_Name", hRMS_Training_Request_Application.Skill);
return(RedirectToAction("Index"));
}