public ActionResult ConfigureParameterCategories()
{
try
{
ConfigureParameterCategory configParametercategory = new ConfigureParameterCategory();
string[] role = Roles.GetRolesForUser(Membership.GetUser().UserName);
configParametercategory.SearchedUserDetails = new SearchedUserDetails();
CommonMethodsDAL Commondal = new CommonMethodsDAL();
configParametercategory.SearchedUserDetails.UserRole = Commondal.GetMaxRoleForUser(role);
PersonalDetailsDAL personalDAL = new PersonalDetailsDAL();
EmployeeDAL dal = new EmployeeDAL();
int employeeID = dal.GetEmployeeID(Membership.GetUser().UserName);
configParametercategory.SearchedUserDetails.EmployeeId = employeeID;
configParametercategory.SearchedUserDetails.EmployeeCode = personalDAL.getEmployeeCode(employeeID);
ConfigurationDAL configDAL = new ConfigurationDAL();
List <Parametercompetency> parametercompetency = configDAL.GetParameterCategories();
configParametercategory.RecordsCount = parametercompetency.Count;
configParametercategory.Parametercompetencys = parametercompetency;
return(PartialView("_ConfigureParameterCompetency", configParametercategory));
}
catch
{
throw;
}
}
// Configure Separation Process Stackholder
public ActionResult ConfigureSeparationStackholder()
{
try
{
StackHolderVM stackHoldermodel = new StackHolderVM();
string employeeCode = Membership.GetUser().UserName;
string[] role = Roles.GetRolesForUser(employeeCode);
stackHoldermodel.SearchedUserDetails = new SearchedUserDetails();
CommonMethodsDAL Commondal = new CommonMethodsDAL();
stackHoldermodel.SearchedUserDetails.UserRole = Commondal.GetMaxRoleForUser(role);
PersonalDetailsDAL personalDAL = new PersonalDetailsDAL();
EmployeeDAL employeeDAL = new EmployeeDAL();
stackHoldermodel.SearchedUserDetails.EmployeeId = employeeDAL.GetEmployeeID(employeeCode);
stackHoldermodel.SearchedUserDetails.EmployeeCode = employeeCode;
ConfigurationDAL dal = new ConfigurationDAL();
List <StackHolderList> stackHolder = dal.getStackHolderDetails();
stackHoldermodel.CountRecord = stackHolder.Count;
stackHoldermodel.stackHolder = stackHolder;
return(PartialView("_SeparationStackholder", stackHoldermodel));
}
catch
{
throw;
}
}
public ActionResult Index()
{
try
{
Session["SearchEmpFullName"] = null; // to hide emp search
Session["SearchEmpCode"] = null;
Session["SearchEmpID"] = null;
ConfirmationViewModel confirmationmodel = new ConfirmationViewModel();
string EmployeeCode = Membership.GetUser().UserName;
string[] role = Roles.GetRolesForUser(EmployeeCode);
confirmationmodel.SearchedUserDetails = new SearchedUserDetails();
CommonMethodsDAL Commondal = new CommonMethodsDAL();
confirmationmodel.SearchedUserDetails.UserRole = Commondal.GetMaxRoleForUser(role);
PersonalDetailsDAL personalDAL = new PersonalDetailsDAL();
confirmationmodel.SearchedUserDetails.EmployeeCode = EmployeeCode;
EmployeeDAL DAL = new EmployeeDAL();
confirmationmodel.SearchedUserDetails.EmployeeId = DAL.GetEmployeeID(EmployeeCode);
return(View(confirmationmodel));
}
catch
{
throw;
}
}
public ActionResult ConfigureParameter()
{
try
{
Session["SearchEmpFullName"] = null; // to hide emp search
Session["SearchEmpCode"] = null;
Session["SearchEmpID"] = null;
ConfirmationViewModel confirmationmodel = new ConfirmationViewModel();
string EmployeeCode = Membership.GetUser().UserName;
string[] role = Roles.GetRolesForUser(EmployeeCode);
confirmationmodel.SearchedUserDetails = new SearchedUserDetails();
CommonMethodsDAL Commondal = new CommonMethodsDAL();
confirmationmodel.SearchedUserDetails.UserRole = Commondal.GetMaxRoleForUser(role);
PersonalDetailsDAL personalDAL = new PersonalDetailsDAL();
confirmationmodel.SearchedUserDetails.EmployeeCode = EmployeeCode;
EmployeeDAL DAL = new EmployeeDAL();
confirmationmodel.SearchedUserDetails.EmployeeId = DAL.GetEmployeeID(EmployeeCode);
ConfigurationDAL configDAL = new ConfigurationDAL();
List <CompetencyMaster> competencyMaster = configDAL.GetCompetencyMaster();
confirmationmodel.RecordsCount = competencyMaster.Count;
confirmationmodel.CompetencyMasters = competencyMaster;
return(PartialView("_ConfigureParameter", confirmationmodel));
}
catch
{
throw;
}
}
public ActionResult SaveApprovalStatus(EmployeeChangesApprovalViewModel model, FormCollection frmColl)
{
try
{
PersonalDetailsDAL dal = new PersonalDetailsDAL();
bool success = false;
string result = null;
if (model != null)
{
success = dal.saveApprovalStatus(model);
if (success)
{
result = "saved";
}
else
{
result = "error";
}
return(Json(new { status = success, resultmessage = result }, JsonRequestBehavior.AllowGet));
}
else
{
result = "ErrorInSave";
}
return(Json(new { status = success, resultmessage = result }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new { status = "Error" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult LoadSkillGrid(int?employeeId, string module, int page, int rows)
{
try
{
PersonalDetailsDAL dal = new PersonalDetailsDAL();
SkillDetailsViewModel model = new SkillDetailsViewModel();
int totalCount;
model.EmployeeSkillDetails = dal.GetEmpSkillDetailsAndHistory(page, rows, employeeId.GetValueOrDefault(), out totalCount, module);
if ((model.EmployeeSkillDetails == null || model.EmployeeSkillDetails.Count <= 0) && page - 1 > 0)
{
page = page - 1;
model.EmployeeSkillDetails = dal.GetEmployeeSkillHistoryDetails(page, rows, employeeId.GetValueOrDefault(), out totalCount);
}
var jsonData = new
{
total = (int)Math.Ceiling((double)totalCount / (double)rows),
page = page,
records = totalCount,
rows = model.EmployeeSkillDetails
};
return(Json(jsonData));
}
catch (Exception)
{
return(RedirectToAction("Index", "Error", new { errorCode = "There are some errors." }));
}
}
public ActionResult AdminApprovalQualificationsLoadGrid(int employeeId, string module, int page, int rows)
{
try
{
PersonalDetailsDAL dal = new PersonalDetailsDAL();
EmployeeQualificationsViewModel model = new EmployeeQualificationsViewModel();
int totalCount;
model.EmployeeQualificationsList = dal.GetAdminEmployeeQualificationsApprovalDetails(page, rows, employeeId, out totalCount, module);
if ((model.EmployeeQualificationsList == null || model.EmployeeQualificationsList.Count <= 0) && page - 1 > 0)
{
page = page - 1;
model.EmployeeQualificationsList = dal.GetAdminEmployeeQualificationsApprovalDetails(page, rows, employeeId, out totalCount, module);
}
var jsonData = new
{
total = (int)Math.Ceiling((double)totalCount / (double)rows),
page = page,
records = totalCount,
rows = model.EmployeeQualificationsList
};
return(Json(jsonData));
}
catch (Exception)
{
return(RedirectToAction("Index", "Error", new { errorCode = "There are some errors." }));
}
}
public ActionResult EmployeeApprovalsLoadGrid(int page, int rows, string term, string Module)
{
try
{
PersonalDetailsDAL dal = new PersonalDetailsDAL();
EmployeeDAL empdal = new EmployeeDAL();
EmployeeChangesApprovalViewModel objChangesApprovalModel = new Models.EmployeeChangesApprovalViewModel();
int totalCount;
int LoggedInEmployeeId = empdal.GetEmployeeID(Membership.GetUser().UserName);
List <EmployeeChangesApprovalViewModel> ChangesApprovalList = dal.GetEmployeeChangeDetails(page, rows, term, Module, LoggedInEmployeeId, out totalCount);
string[] role = Roles.GetRolesForUser(Membership.GetUser().UserName);
if ((ChangesApprovalList == null || ChangesApprovalList.Count <= 0) && page - 1 > 0)
{
page = page - 1;
ChangesApprovalList = dal.GetEmployeeChangeDetails(page, rows, term, Module, LoggedInEmployeeId, out totalCount);
}
var totalRecords = totalCount;
var totalPages = (int)Math.Ceiling((double)totalRecords / (double)rows);
var jsonData = new
{
total = totalPages,
page = page,
records = totalRecords,
rows = ChangesApprovalList,
};
return(Json(jsonData));
}
catch (Exception)
{
return(RedirectToAction("Index", "Error", new { errorCode = "There are some errors." }));
}
}
public ActionResult SelectedModuleDetails(int employeeId, string module, int page, int rows)
{
try
{
PersonalDetailsDAL dal = new PersonalDetailsDAL();
EmployeeChangesApprovalViewModel changesApprovalModel = new EmployeeChangesApprovalViewModel();
int totalCount;
changesApprovalModel.ChangeDetailsList = new List <EmployeeChangeDetails>();
changesApprovalModel.ChangeDetailsList = dal.SelectedModuleDetailsList(employeeId, module, page, rows, out totalCount);
if ((changesApprovalModel.ChangeDetailsList == null || changesApprovalModel.ChangeDetailsList.Count <= 0) && page - 1 > 0)
{
page = page - 1;
changesApprovalModel.ChangeDetailsList = dal.SelectedModuleDetailsList(employeeId, module, page, rows, out totalCount);
}
var totalRecords = totalCount;
var totalPages = (int)Math.Ceiling((double)totalRecords / (double)rows);
var jsonData = new
{
total = totalPages,
page = page,
records = totalRecords,
rows = changesApprovalModel.ChangeDetailsList,
};
return(Json(jsonData));
}
catch (Exception)
{
return(RedirectToAction("Index", "Error", new { errorCode = "There are some errors." }));
}
}
public ActionResult AddRatingScales(int?RatingID)
{
try
{
AddRatingScale addNewRating = new AddRatingScale();
string[] role = Roles.GetRolesForUser(Membership.GetUser().UserName);
addNewRating.SearchedUserDetails = new SearchedUserDetails();
CommonMethodsDAL Commondal = new CommonMethodsDAL();
addNewRating.SearchedUserDetails.UserRole = Commondal.GetMaxRoleForUser(role);
EmployeeDAL dal = new EmployeeDAL();
int employeeID = dal.GetEmployeeID(Membership.GetUser().UserName);
addNewRating.SearchedUserDetails.EmployeeId = employeeID;
PersonalDetailsDAL personalDAL = new PersonalDetailsDAL();
addNewRating.SearchedUserDetails.EmployeeCode = personalDAL.getEmployeeCode(employeeID);
ConfigurationDAL configDAL = new ConfigurationDAL();
if (RatingID != null)
{
tbl_PA_Rating_Master ratingScale = configDAL.getRatingScaleDetails(RatingID);
addNewRating.Percentage = ratingScale.Percentage;
addNewRating.Rating = ratingScale.Rating;
addNewRating.RatingID = ratingScale.RatingID;
addNewRating.Description = ratingScale.Description;
addNewRating.AdjustmentFactor = ratingScale.AdjustmentFactor;
addNewRating.SetAsMinimumLimit = ratingScale.SetAsMinimumLimit.HasValue ? ratingScale.SetAsMinimumLimit.Value : false;
}
return(PartialView("_addRatingScale", addNewRating));
}
catch
{
throw;
}
}
public ActionResult ConfigureParametersRoles(string searchstring)
{
try
{
ConfigureParametersforRoles parameterRoles = new ConfigureParametersforRoles();
string[] role = Roles.GetRolesForUser(Membership.GetUser().UserName);
parameterRoles.SearchedUserDetails = new SearchedUserDetails();
CommonMethodsDAL Commondal = new CommonMethodsDAL();
parameterRoles.SearchedUserDetails.UserRole = Commondal.GetMaxRoleForUser(role);
PersonalDetailsDAL personalDAL = new PersonalDetailsDAL();
EmployeeDAL dal = new EmployeeDAL();
int employeeID = dal.GetEmployeeID(Membership.GetUser().UserName);
parameterRoles.SearchedUserDetails.EmployeeId = employeeID;
parameterRoles.SearchedUserDetails.EmployeeCode = personalDAL.getEmployeeCode(employeeID);
ConfigurationDAL configDAL = new ConfigurationDAL();
List <RoleLists> roleList = configDAL.getAllRoles();
if (searchstring != null)
{
List <RoleLists> roleListwithsearch = roleList.FindAll(x => x.RoleDescription.ToLower().Contains(searchstring.ToLower()));
parameterRoles.RoleList = roleListwithsearch;
parameterRoles.RecordsCount = roleList.Count;
}
else
{
parameterRoles.RoleList = roleList;
parameterRoles.RecordsCount = roleList.Count;
}
return(PartialView("_ConfigureParameterRole", parameterRoles));
}
catch
{
throw;
}
}
//Configure Separation Reasons
public ActionResult ConfigureSeperationReason()
{
try
{
ExitViewModel Exitmodel = new ExitViewModel();
string employeeCode = Membership.GetUser().UserName;
string[] role = Roles.GetRolesForUser(employeeCode);
Exitmodel.SearchedUserDetails = new SearchedUserDetails();
CommonMethodsDAL Commondal = new CommonMethodsDAL();
Exitmodel.SearchedUserDetails.UserRole = Commondal.GetMaxRoleForUser(role);
PersonalDetailsDAL personalDAL = new PersonalDetailsDAL();
EmployeeDAL emmployeeDAL = new EmployeeDAL();
Exitmodel.SearchedUserDetails.EmployeeId = emmployeeDAL.GetEmployeeID(employeeCode);
Exitmodel.SearchedUserDetails.EmployeeCode = employeeCode;
ConfigurationDAL dal = new ConfigurationDAL();
List <SeperationReasons> seperationReason = dal.getSeperationReason();
Exitmodel.CountRecord = seperationReason.Count;
Exitmodel.seperationReason = seperationReason;
return(PartialView("_SeperationReasonDetails", Exitmodel));
}
catch
{
throw;
}
}
public ActionResult AddParameterCompetency(int?categoryID)
{
try
{
AddNewCategory addnewcategory = new AddNewCategory();
string[] role = Roles.GetRolesForUser(Membership.GetUser().UserName);
addnewcategory.SearchedUserDetails = new SearchedUserDetails();
CommonMethodsDAL Commondal = new CommonMethodsDAL();
addnewcategory.SearchedUserDetails.UserRole = Commondal.GetMaxRoleForUser(role);
EmployeeDAL dal = new EmployeeDAL();
int employeeID = dal.GetEmployeeID(Membership.GetUser().UserName);
addnewcategory.SearchedUserDetails.EmployeeId = employeeID;
PersonalDetailsDAL personalDAL = new PersonalDetailsDAL();
addnewcategory.SearchedUserDetails.EmployeeCode = personalDAL.getEmployeeCode(employeeID);
ConfigurationDAL configDAL = new ConfigurationDAL();
if (categoryID != null)
{
tbl_PA_CompetencyCategories parameterCategory = configDAL.getParametercategory(categoryID);
addnewcategory.CategoryID = parameterCategory.CategoryID;
addnewcategory.Category = parameterCategory.CategoryType;
addnewcategory.Description = parameterCategory.CategoryDescription;
}
return(PartialView("_addParameterCategory", addnewcategory));
}
catch
{
throw;
}
}
public ActionResult EditParameterRole(int RoleID)
{
try
{
Session["RoleID"] = RoleID;
AssocieteDriverAndComepetency driverAndComeptency = new AssocieteDriverAndComepetency();
string[] role = Roles.GetRolesForUser(Membership.GetUser().UserName);
driverAndComeptency.SearchedUserDetails = new SearchedUserDetails();
CommonMethodsDAL Commondal = new CommonMethodsDAL();
driverAndComeptency.SearchedUserDetails.UserRole = Commondal.GetMaxRoleForUser(role);
EmployeeDAL dal = new EmployeeDAL();
int employeeID = dal.GetEmployeeID(Membership.GetUser().UserName);
PersonalDetailsDAL personalDAL = new PersonalDetailsDAL();
driverAndComeptency.SearchedUserDetails.EmployeeId = employeeID;
driverAndComeptency.SearchedUserDetails.EmployeeCode = personalDAL.getEmployeeCode(employeeID);
ConfigurationDAL configDAL = new ConfigurationDAL();
List <Competencies> competency = configDAL.getCompetenciesForRole(RoleID);
driverAndComeptency.CompetencyList = competency;
driverAndComeptency.RecordsCount = competency.Count;
driverAndComeptency.RoleID = RoleID;
return(PartialView("_CompetenciesForRole", driverAndComeptency));
}
catch
{
throw;
}
}
public ActionResult SearchEmployeeAutoSuggest(string term)
{
PersonalDetailsDAL dal = new PersonalDetailsDAL();
List <ApprovalEmployeeDetails> searchResult = new List <ApprovalEmployeeDetails>();
searchResult = dal.SearchEmployeeNameModule(term, 1, 20);
return(Json(searchResult, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveEmployeeQualificationStatus(List <EmployeeQualifications> model, string comments)
{
try
{
PersonalDetailsDAL dal = new PersonalDetailsDAL();
var saveStatus = dal.SaveQualificationMatrixHistory(model, comments);
return(Json(new { status = saveStatus }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new { status = "Error" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult SaveSkillDetailStatus(List <SkillDetails> model, string SkillHrComment)
{
try
{
PersonalDetailsDAL dal = new PersonalDetailsDAL();
var saveStatus = dal.SaveEmployeeSkillMatrixHistory(model, SkillHrComment);
return(Json(new { status = saveStatus }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new { status = "Error" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult EmployeeApprovals(int?employeeId)
{
Session["SearchEmpFullName"] = null; // to hide emp search
Session["SearchEmpCode"] = null;
Session["SearchEmpID"] = null;
if (employeeId == null)
{
EmployeeDAL employeeDAL = new EmployeeDAL();
employeeId = employeeDAL.GetEmployeeID(Membership.GetUser().UserName);
}
if (!HttpContext.User.Identity.IsAuthenticated)
{
return(RedirectToAction("Index", "PersonalDetails"));
}
try
{
EmployeeChangesApprovalViewModel changesApprovalModel = new EmployeeChangesApprovalViewModel();
PersonalDetailsDAL dal = new PersonalDetailsDAL();
tbl_ApprovalChanges approvalChanges = dal.GetChangedFields(employeeId);
if (approvalChanges != null)
{
changesApprovalModel.EmployeeID = approvalChanges.EmployeeID;
changesApprovalModel.FieldDiscription = approvalChanges.FieldDiscription;
changesApprovalModel.Module = approvalChanges.Module;
changesApprovalModel.FieldDbColumnName = approvalChanges.FieldDbColumnName;
changesApprovalModel.OldValue = approvalChanges.OldValue;
changesApprovalModel.NewValue = approvalChanges.NewValue;
changesApprovalModel.ApprovalStatusMasterID = approvalChanges.ApprovalStatusMasterID;
changesApprovalModel.Comments = approvalChanges.Comments;
changesApprovalModel.CreatedBy = approvalChanges.CreatedBy;
changesApprovalModel.CreatedDateTime = approvalChanges.CreatedDateTime;
}
changesApprovalModel.ChangeDetailsList = new List <EmployeeChangeDetails>();
changesApprovalModel.Mail = new EmployeeMailTemplate();
changesApprovalModel.EmployeeID = employeeId;
return(PartialView("_EmployeeApprovals", changesApprovalModel));
}
catch (Exception)
{
return(RedirectToAction("Index", "Error", new { errorCode = "There are some errors." }));
}
}
public ActionResult GetUploadNameFromUploadById(string empcode)
{
try
{
PersonalDetailsDAL personalDAL = new PersonalDetailsDAL();
EmployeeDAL employeeDAL = new EmployeeDAL();
int employeeID = 0;
HRMS_tbl_PM_Employee employeeDetails = employeeDAL.GetEmployeeDetailsByEmployeeCode(empcode);
if (employeeDetails != null)
{
employeeID = employeeDetails.EmployeeID;
}
string EmpName = personalDAL.GetDisplayName(employeeID);
return(Json(EmpName, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
throw;
}
}
public ActionResult Index()
{
Session["SearchEmpFullName"] = null; // to hide emp search
Session["SearchEmpCode"] = null;
Session["SearchEmpID"] = null;
ExitViewModel Exitmodel = new ExitViewModel();
string employeeCode = Membership.GetUser().UserName;
string[] role = Roles.GetRolesForUser(employeeCode);
Exitmodel.SearchedUserDetails = new SearchedUserDetails();
CommonMethodsDAL Commondal = new CommonMethodsDAL();
Exitmodel.SearchedUserDetails.UserRole = Commondal.GetMaxRoleForUser(role);
PersonalDetailsDAL personalDAL = new PersonalDetailsDAL();
EmployeeDAL DAL = new EmployeeDAL();
Exitmodel.SearchedUserDetails.EmployeeId = DAL.GetEmployeeID(employeeCode);
Exitmodel.SearchedUserDetails.EmployeeCode = employeeCode;
return(View(Exitmodel));
}
public ActionResult ConfigureRatingScales()
{
ConfigureRatingScales configratingSale = new ConfigureRatingScales();
string[] role = Roles.GetRolesForUser(Membership.GetUser().UserName);
configratingSale.SearchedUserDetails = new SearchedUserDetails();
CommonMethodsDAL Commondal = new CommonMethodsDAL();
configratingSale.SearchedUserDetails.UserRole = Commondal.GetMaxRoleForUser(role);
PersonalDetailsDAL personalDAL = new PersonalDetailsDAL();
EmployeeDAL dal = new EmployeeDAL();
int employeeID = dal.GetEmployeeID(Membership.GetUser().UserName);
configratingSale.SearchedUserDetails.EmployeeId = employeeID;
configratingSale.SearchedUserDetails.EmployeeCode = personalDAL.getEmployeeCode(employeeID);
ConfigurationDAL configDAL = new ConfigurationDAL();
List <RatingScales> ratingScale = configDAL.GetRatingScales();
configratingSale.RecordsCount = ratingScale.Count;
configratingSale.RatingScale = ratingScale;
return(PartialView("_ConfigureRatingScales", configratingSale));
}
//Set Separation Stage Approvers
public ActionResult SetSeparationStageApprovers()
{
try
{
SeparationChecklist Separationmodel = new SeparationChecklist();
string employeeCode = Membership.GetUser().UserName;
string[] role = Roles.GetRolesForUser(employeeCode);
Separationmodel.SearchedUserDetails = new SearchedUserDetails();
CommonMethodsDAL Commondal = new CommonMethodsDAL();
Separationmodel.SearchedUserDetails.UserRole = Commondal.GetMaxRoleForUser(role);
PersonalDetailsDAL personalDAL = new PersonalDetailsDAL();
EmployeeDAL employeeDAL = new EmployeeDAL();
Separationmodel.SearchedUserDetails.EmployeeId = employeeDAL.GetEmployeeID(employeeCode);
Separationmodel.SearchedUserDetails.EmployeeCode = employeeCode;
ConfigurationDAL dal = new ConfigurationDAL();
List <SeperationChecklistRecord> seperationChecklist = dal.getSeperationChecklist();
Separationmodel.seperationChecklist = seperationChecklist;
return(PartialView("_SetSeparationStageApproversDetails", Separationmodel));
}
catch
{
throw;
}
}
