public ActionResult Create([Bind(Include = "ID,FacultyType,EMP_ID,External_Name,PAN_No,ServiceTaxNo,Qualification,Contact,Email,Remark,IsActive,Empty")] HRMS_Faculty_MS hRMS_Faculty_MS)
{
if (ModelState.IsValid)
{
if (hRMS_Faculty_MS.FacultyType == "Internal" && hRMS_Faculty_MS.EMP_ID != null)
{
bool IsExist = db.HRMS_Faculty_MS.Any(x => x.EMP_ID == hRMS_Faculty_MS.EMP_ID);
if (IsExist)
{
ViewBag.error = "Faculty type already assigned to this Employee!";
ModelState.Clear();
return(View());
}
else
{
HRMS_Emp_Details obj = db.HRMS_Emp_Details.Where(x => x.EMP_ID == hRMS_Faculty_MS.EMP_ID).FirstOrDefault();
string name = obj.First_Name + " " + obj.Last_Name;
hRMS_Faculty_MS.External_Name = name;
db.HRMS_Faculty_MS.Add(hRMS_Faculty_MS);
db.SaveChanges();
ModelState.Clear();
ViewBag.success = "Successfully Faculty type assigned to this Employee!";
return(View());
}
}
db.HRMS_Faculty_MS.Add(hRMS_Faculty_MS);
db.SaveChanges();
ModelState.Clear();
ViewBag.success = "Successfully Faculty type assigned to this Employee!";
return(View());
}
return(View(hRMS_Faculty_MS));
}
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));
}
public ActionResult DeleteConfirmed(long id)
{
HRMS_Emp_Details hRMS_Emp_Details = db.HRMS_Emp_Details.Find(id);
db.HRMS_Emp_Details.Remove(hRMS_Emp_Details);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Details(long?id, string name)
{
long emp_id = Convert.ToInt64(Session["id"]);
string role = db.Accounts.Where(x => x.ID == emp_id).Select(x => x.role).FirstOrDefault();
if (role == "admin")
{
ViewBag.Role = "admin";
if (name != null)
{
bool isThere = db.HRMS_Emp_Details.Any(x => x.EMP_ID == id.Value);
if (!isThere)
{
return(RedirectToAction("Create", "EmployeeDetail", new { ID = id.Value }));
}
else
{
ViewBag.EditVisible = "No";
HRMS_Emp_Details employee_Personal_Detail = db.HRMS_Emp_Details.Where(x => x.EMP_ID == id.Value).FirstOrDefault();
return(View(employee_Personal_Detail));
}
}
}
//if no entry it will redirect to create
bool isExist = db.HRMS_Emp_Details.Any(x => x.EMP_ID == emp_id);
if (!isExist)
{
return(RedirectToAction("Create"));
}
else
{
//if (id == null)
//{
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
//}
if (role == "emp")
{
id = db.HRMS_Emp_Details.Where(x => x.EMP_ID == emp_id).Select(x => x.ID).FirstOrDefault();
}
HRMS_Emp_Details hRMS_Emp_Details = db.HRMS_Emp_Details.Find(id);
if (hRMS_Emp_Details == null)
{
return(HttpNotFound());
}
return(View(hRMS_Emp_Details));
}
}
// GET: EmployeeDetail/Details/5
public ActionResult Details(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HRMS_Emp_Details hRMS_Emp_Details = db.HRMS_Emp_Details.Find(id);
if (hRMS_Emp_Details == null)
{
return(HttpNotFound());
}
return(View(hRMS_Emp_Details));
}
public bool Delete(long id)
{
HRMS_Emp_Details hRMS_Emp_Details = db.HRMS_Emp_Details.Find(id);
if (hRMS_Emp_Details != null)
{
db.HRMS_Emp_Details.Remove(hRMS_Emp_Details);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public ActionResult Edit([Bind(Include = "Emp_ID,Emp_Cd,Old_Emp_Cd,Join_Date,Card_Id,salutation,First_Name,Middle_Name,Last_Name,Display_Name,Designation,Work_Location,Unit,Department,Cost_Center,UAN_No_")] HRMS_Emp_Details hRMS_Emp_Details)
{
if (ModelState.IsValid)
{
db.Entry(hRMS_Emp_Details).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Cost_Center = new SelectList(db.HRMS_COST_CENTER, "ID", "Cost_Cntr_Name", hRMS_Emp_Details.Cost_Center);
ViewBag.Department = new SelectList(db.HRMS_DEPT, "Dept_Id", "Dept_Name", hRMS_Emp_Details.Department);
ViewBag.Designation = new SelectList(db.HRMS_EMP_DESIGNATION_MS, "Designation_ID", "Designation_Parent", hRMS_Emp_Details.Designation);
ViewBag.salutation = new SelectList(db.HRMS_SALUTATION, "Salutation_ID", "Salutation_Name", hRMS_Emp_Details.salutation);
ViewBag.Unit = new SelectList(db.UnitMasters, "UnitCode", "UnitName", hRMS_Emp_Details.Unit);
ViewBag.Work_Location = new SelectList(db.WorkLocationMasters, "WorkID", "WorkLocationName", hRMS_Emp_Details.Work_Location);
return(View(hRMS_Emp_Details));
}
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));
}
// GET: EmployeeDetail/Edit/5
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HRMS_Emp_Details hRMS_Emp_Details = db.HRMS_Emp_Details.Find(id);
if (hRMS_Emp_Details == null)
{
return(HttpNotFound());
}
ViewBag.Cost_Center = new SelectList(db.HRMS_COST_CENTER, "ID", "Cost_Cntr_Name", hRMS_Emp_Details.Cost_Center);
ViewBag.Department = new SelectList(db.HRMS_DEPT, "Dept_Id", "Dept_Name", hRMS_Emp_Details.Department);
ViewBag.Designation = new SelectList(db.HRMS_EMP_DESIGNATION_MS, "Designation_ID", "Designation_Parent", hRMS_Emp_Details.Designation);
ViewBag.salutation = new SelectList(db.HRMS_SALUTATION, "Salutation_ID", "Salutation_Name", hRMS_Emp_Details.salutation);
ViewBag.Unit = new SelectList(db.UnitMasters, "UnitCode", "UnitName", hRMS_Emp_Details.Unit);
ViewBag.Work_Location = new SelectList(db.WorkLocationMasters, "WorkID", "WorkLocationName", hRMS_Emp_Details.Work_Location);
return(View(hRMS_Emp_Details));
}
public ActionResult Create(long?ID)
{
HRMS_Emp_Details obj = new HRMS_Emp_Details();
long emp_id = Convert.ToInt64(Session["id"]);
string role = db.Accounts.Where(x => x.ID == emp_id).Select(x => x.role).FirstOrDefault();
if (role == "admin")
{
ViewBag.Role = "admin";
obj.EMP_ID = ID.Value;
bool isExist = db.HRMS_Emp_Details.Any(x => x.EMP_ID == obj.EMP_ID);
if (isExist)
{
return(RedirectToAction("Create", "EmployeePersonalDetail", new { ID = obj.EMP_ID }));
}
}
//if attck by direct URL
if (role == "emp")
{
bool isExist = db.HRMS_Emp_Details.Any(x => x.EMP_ID == emp_id);
if (isExist)
{
long id = db.HRMS_Emp_Details.Where(x => x.EMP_ID == emp_id).Select(x => x.ID).FirstOrDefault();
return(RedirectToAction("Details", "EmployeeDetail", new { id }));
}
}
ViewBag.Cost_Center = db.HRMS_COST_CENTER;
ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
ViewBag.salutation = db.HRMS_SALUTATION;
ViewBag.Unit = db.UnitMaster;
ViewBag.Work_Location = db.WorkLocationMaster;
ViewBag.DivisionData = db.HRMS_DEPT.Where(rec => rec.Parent_ID == null && rec.IsActive == true);
// obj.Join_Date = ;
return(View(obj));
}
public ActionResult Edit(long?id)
{
long emp_id = Convert.ToInt64(Session["id"]);
string role = db.Accounts.Where(x => x.ID == emp_id).Select(x => x.role).FirstOrDefault();
if (role == "admin")
{
ViewBag.Role = "admin";
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//URL Attack
if (role == "emp")
{
id = db.HRMS_Emp_Details.Where(x => x.EMP_ID == emp_id).Select(x => x.ID).FirstOrDefault();
}
HRMS_Emp_Details hRMS_Emp_Details = db.HRMS_Emp_Details.Find(id);
if (hRMS_Emp_Details == null)
{
return(HttpNotFound());
}
ViewBag.Cost_Center = db.HRMS_COST_CENTER;
ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
ViewBag.salutation = db.HRMS_SALUTATION;
ViewBag.Unit = db.UnitMaster;
ViewBag.Work_Location = db.WorkLocationMaster;
ViewBag.DivisionData = db.HRMS_DEPT.Where(rec => rec.Parent_ID == null && rec.IsActive == true);
return(View(hRMS_Emp_Details));
}
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"));
}
public ActionResult Edit(HRMS_Emp_Details hRMS_Emp_Details)
{
long emp_id = Convert.ToInt64(Session["id"]);
string role = db.Accounts.Where(x => x.ID == emp_id).Select(x => x.role).FirstOrDefault();
if (role == "emp")
{
ModelState.Remove("EMP_ID");
hRMS_Emp_Details.EMP_ID = emp_id;
}
if (ModelState.IsValid)
{
//HRMS_Emp_Details AlreadyEmpCODE = db.HRMS_Emp_Details.Where(rec => rec.Emp_Cd == hRMS_Emp_Details.Emp_Cd).FirstOrDefault();
//if (AlreadyEmpCODE == null)
//{
HRMS_Emp_Details AlreadyCard_Id = db.HRMS_Emp_Details.Where(rec => rec.ID != hRMS_Emp_Details.ID && rec.EMP_ID == hRMS_Emp_Details.EMP_ID).FirstOrDefault();
if (AlreadyCard_Id == null)
{
db.Entry(hRMS_Emp_Details).State = EntityState.Modified;
db.SaveChanges();
ViewBag.EmpDetailStatus = "It is Updated successfully!";
if (role == "emp")
{
long id = db.HRMS_Emp_Details.Where(x => x.EMP_ID == emp_id).Select(x => x.ID).FirstOrDefault();
return(RedirectToAction("Details", "EmployeeDetail", new { id }));
}
ViewBag.Cost_Center = db.HRMS_COST_CENTER;
ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
ViewBag.salutation = db.HRMS_SALUTATION;
ViewBag.Unit = db.UnitMaster;
ViewBag.Work_Location = db.WorkLocationMaster;
ViewBag.DivisionData = db.HRMS_DEPT.Where(rec => rec.Parent_ID == null && rec.IsActive == true);
if (role == "admin")
{
ViewBag.Role = "admin";
}
return(View(hRMS_Emp_Details));
}
else
{
ViewBag.EmpDetailStatus = "The Employee ID is Already Exist for another employee!";
ViewBag.Cost_Center = db.HRMS_COST_CENTER;
ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
ViewBag.salutation = db.HRMS_SALUTATION;
ViewBag.Unit = db.UnitMaster;
ViewBag.Work_Location = db.WorkLocationMaster;
ViewBag.DivisionData = db.HRMS_DEPT.Where(rec => rec.Parent_ID == null && rec.IsActive == true);
if (role == "admin")
{
ViewBag.Role = "admin";
}
return(View(hRMS_Emp_Details));
}
//}
//else
//{
// ViewBag.EmpDetailStatus = "The Employee Code is Already Exist for another employee!";
// ViewBag.Cost_Center = db.HRMS_COST_CENTER;
// ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
// ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
// ViewBag.salutation = db.HRMS_SALUTATION;
// ViewBag.Unit = db.UnitMasters;
// ViewBag.Work_Location = db.WorkLocationMasters;
// ViewBag.DivisionData = db.HRMS_DEPT.Where(rec => rec.Parent_ID == null && rec.IsActive == true);
// return View();
//}
}
ViewBag.Cost_Center = db.HRMS_COST_CENTER;
ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
ViewBag.salutation = db.HRMS_SALUTATION;
ViewBag.Unit = db.UnitMaster;
ViewBag.Work_Location = db.WorkLocationMaster;
ViewBag.DivisionData = db.HRMS_DEPT.Where(rec => rec.Parent_ID == null && rec.IsActive == true);
if (role == "admin")
{
ViewBag.Role = "admin";
}
return(View(hRMS_Emp_Details));
}
public ActionResult Create(HRMS_Emp_Details hRMS_Emp_Details)
{
long emp_id = Convert.ToInt64(Session["id"]);
string role = db.Accounts.Where(x => x.ID == emp_id).Select(x => x.role).FirstOrDefault();
if (role == "emp")
{
ModelState.Remove("EMP_ID");
hRMS_Emp_Details.EMP_ID = emp_id;
}
if (ModelState.IsValid)
{
HRMS_Emp_Details AlreadyEmpId = db.HRMS_Emp_Details.Where(rec => rec.EMP_ID == hRMS_Emp_Details.EMP_ID).FirstOrDefault();
if (AlreadyEmpId == null)
{
//HRMS_Emp_Details AlreadyEmpCODE = db.HRMS_Emp_Details.Where(rec => rec.Emp_Cd == hRMS_Emp_Details.Emp_Cd).FirstOrDefault();
//if (AlreadyEmpCODE == null)
//{
bool AlreadyCard_Id = db.HRMS_Emp_Details.Any(rec => rec.Card_Id == hRMS_Emp_Details.Card_Id);
if (!AlreadyCard_Id || (AlreadyCard_Id && hRMS_Emp_Details.Card_Id == null))
{
db.HRMS_Emp_Details.Add(hRMS_Emp_Details);
db.SaveChanges();
ViewBag.EmpDetailStatus = "It is Created successfully!";
ModelState.Clear();
if (role == "emp")
{
long id = db.HRMS_Emp_Details.Where(x => x.EMP_ID == emp_id).Select(x => x.ID).FirstOrDefault();
return(RedirectToAction("Details", "EmployeeDetail", new { id }));
}
//ViewBag.Cost_Center = db.HRMS_COST_CENTER;
//ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
//ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
//ViewBag.salutation = db.HRMS_SALUTATION;
//ViewBag.Unit = db.UnitMaster;
//ViewBag.Work_Location = db.WorkLocationMaster;
//ViewBag.DivisionData = db.HRMS_DEPT.Where(rec => rec.Parent_ID == null && rec.IsActive == true);
if (role == "admin")
{
ViewBag.Role = "admin";
return(RedirectToAction("Create", "EmployeePersonalDetail", new { ID = hRMS_Emp_Details.EMP_ID }));
}
}
else if (AlreadyCard_Id && hRMS_Emp_Details.Card_Id != null)
{
ViewBag.EmpDetailStatus = "The Card ID is Already Exist for another employee!";
ViewBag.Cost_Center = db.HRMS_COST_CENTER;
ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
ViewBag.salutation = db.HRMS_SALUTATION;
ViewBag.Unit = db.UnitMaster;
ViewBag.Work_Location = db.WorkLocationMaster;
ViewBag.DivisionData = db.HRMS_DEPT.Where(rec => rec.Parent_ID == null && rec.IsActive == true);
if (role == "admin")
{
ViewBag.Role = "admin";
}
return(View(hRMS_Emp_Details));
}
}
else
{
ViewBag.EmpDetailStatus = "The Employee ID is Already Exist for another employee!";
ViewBag.Cost_Center = db.HRMS_COST_CENTER;
ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
ViewBag.salutation = db.HRMS_SALUTATION;
ViewBag.Unit = db.UnitMaster;
ViewBag.Work_Location = db.WorkLocationMaster;
ViewBag.DivisionData = db.HRMS_DEPT.Where(rec => rec.Parent_ID == null && rec.IsActive == true);
if (role == "admin")
{
ViewBag.Role = "admin";
}
return(View(hRMS_Emp_Details));
}
}
ViewBag.Cost_Center = db.HRMS_COST_CENTER;
ViewBag.Designation = db.HRMS_DESG_MS.Where(rec => rec.IsActive == true);
ViewBag.Department = db.HRMS_DEPT.Where(rec => rec.Parent_ID != null && rec.IsActive == true);
ViewBag.salutation = db.HRMS_SALUTATION;
ViewBag.Unit = db.UnitMaster;
ViewBag.Work_Location = db.WorkLocationMaster;
ViewBag.DivisionData = db.HRMS_DEPT.Where(rec => rec.Parent_ID == null && rec.IsActive == true);
if (role == "admin")
{
ViewBag.Role = "admin";
}
return(View(hRMS_Emp_Details));
}
//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));
}
