/// <summary> /// Created By :Ashwajit bansod /// Created Date : 17-Oct-2019 /// Created For : To get Employee Management List /// </summary> /// <param name="LocationId"></param> /// <param name="UserId"></param> /// <returns></returns> public List <UserModelList> GetEmployeeMgmList(long LocationId, long UserId) { var _ePeopleRepository = new ePeopleRepository(); var lst = new List <UserModelList>(); try { if (UserId > 0) { var userDetails = objworkorderEMSEntities.UserRegistrations.Where(x => x.UserId == UserId && x.IsEmailVerify == true && x.IsDeleted == false).FirstOrDefault(); if (userDetails != null) { lst = _ePeopleRepository.GetEmployeeManagementListData(LocationId, userDetails.EmployeeID).Select(x => new UserModelList() { id = Cryptography.GetEncryptedData(x.UserId.ToString(), true), UserId = x.UserId, UserEmail = x.EMP_Email, Name = x.EmployeeName, HiringDate = x.EMP_DateOfJoining, UserType = x.JBT_JobTitle, ProfileImage = x.EMP_Photo == null ? HostingPrefix + ProfilePicPath.Replace("~", "") + "no-profile-pic.jpg" : HostingPrefix + ProfilePicPath.Replace("~", "") + x.EMP_Photo, }).ToList(); } } return(lst); } catch (Exception ex) { Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public List<UserModelList> GetEmployeeMgmList(long LocationId, long UserId)", "Exception While getting employee Management List.", UserId); throw; } }
/// <summary> /// Created By : Ashwajit bansod /// Created Date : 21-Oct-2019 /// Created For : TO approve/ reject requisition /// </summary> /// <param name="Id"></param> /// <param name="Status"></param> /// <param name="UserId"></param> /// <returns></returns> public bool ApproveRejectAction(long Id, string Status, long UserId) { var _workorderEMS = new workorderEMSEntities(); bool IsApproveReject = false; try { var ePeopleRepository = new ePeopleRepository(); if (UserId > 0) { var getEmpDetails = _workorderEMS.UserRegistrations.Where(x => x.UserId == UserId && x.IsDeleted == false && x.IsEmailVerify == true).FirstOrDefault(); if (getEmpDetails != null) { if (Id > 0 && Status != null) { var Statusdata = ePeopleRepository.ApproveRejectRequisition(Id, Status, getEmpDetails.EmployeeID); IsApproveReject = true; } else { IsApproveReject = false; } } } } catch (Exception ex) { Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public bool ApprovalRequisition(AddChartModel Obj)", "Exception While Saving Vehicle seating chart.", Id); throw; } return(IsApproveReject); }
/// <summary> /// Created By : Ashwajit Bansod /// Created Date : 17-Oct-2019 /// Created For : To get VSC details by VSC Id /// </summary> /// <param name="VSCId"></param> /// <returns></returns> public AddChartModel GetVSCDetailsById(long VSCId) { var _ePeopleRepository = new ePeopleRepository(); try { var lst = _ePeopleRepository.GetVSCDetails(VSCId).Select(x => new AddChartModel() { DepartmentName = x.DPT_Name, EmploymentClassification = x.VST_IsExempt, EmploymentStatus = x.VST_EmploymentStatus, JobDescription = x.VST_JobDescription, SeatingName = x.VST_Title, RateOfPay = x.VST_RateOfPay, RolesAndResponsibility = x.VST_RolesAndResponsiblities, // x. }).FirstOrDefault(); return(lst); } catch (Exception ex) { Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public List<AddChartModel> GetVSCDetailsById(long VSCId)", "Exception While getting details VSC.", VSCId); throw; } }
/// <summary> /// Created By : Ashwajit Bansod /// Created Date : 04-Oct-2019 /// Created /// </summary> /// <param name="UserId"></param> /// <returns></returns> public UserListViewEmployeeManagementModel GetVCSPositionByUserId(long?UserId) { var _ePeopleRepository = new ePeopleRepository(); var getDetails = new UserListViewEmployeeManagementModel(); try { if (UserId > 0) { var getUserDetails = objworkorderEMSEntities.UserRegistrations.Where(x => x.UserId == UserId && x.IsEmailVerify == true && x.IsDeleted == false).FirstOrDefault(); if (getUserDetails != null) { var data = _ePeopleRepository.UserPositionVCS(getUserDetails.EmployeeID); if (data != null) { getDetails.JobTitleId = data.EMP_JobTitleId; getDetails.VSTId = data.JBT_VST_Id; getDetails.EmployeeId = data.EMP_EmployeeID; } } } return(getDetails); } catch (Exception ex) { Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public List<UserModelList> GetUserHeirarchyList(long? LocationId)", "Exception While getting list User.", UserId); throw; } }
public List <UserListViewEmployeeManagementModel> GetUserTreeViewListTesting(long UserId) { var _ePeopleRepository = new ePeopleRepository(); var lstDetails = new List <UserListViewEmployeeManagementModel>(); var UserModel = new UserListViewEmployeeManagementModel(); try { if (UserId > 0) { var getUserDetails = objworkorderEMSEntities.UserRegistrations.Where(x => x.UserId == UserId && x.IsEmailVerify == true && x.IsDeleted == false).FirstOrDefault(); if (getUserDetails != null) { lstDetails = _ePeopleRepository.UserTreeViewDetails(getUserDetails.EmployeeID).Select(x => new UserListViewEmployeeManagementModel() { EmployeeId = x.EMP_EmployeeID, EmployeeName = x.EmployeeName, JobTitle = x.JBT_JobTitle, LocationId = x.EMP_LocationId, JobTitleId = x.EMP_JobTitleId, ProfilePhoto = x.EMP_Photo == null ? HostingPrefix + ProfilePicPath.Replace("~", "") + "no-profile-pic.jpg" : HostingPrefix + ProfilePicPath.Replace("~", "") + x.EMP_Photo }).ToList(); } } } catch (Exception ex) { Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public List<UserModelList> GetUserHeirarchyList(long? LocationId)", "Exception While getting list User.", UserId); throw; } return(lstDetails); }
/// <summary> /// Created By : Ashwajit Bansod /// Created Date : 20-Oct-2019 /// Created For : To save for approval requisition /// </summary> /// <param name="Obj"></param> /// <returns></returns> public bool ApprovalRequisition(AddChartModel Obj) { var _workorderEMS = new workorderEMSEntities(); bool isSaved = false; try { var ePeopleRepository = new ePeopleRepository(); string Action = string.Empty; var getEmpDetails = _workorderEMS.UserRegistrations.Where(x => x.UserId == Obj.UserId && x.IsDeleted == false && x.IsEmailVerify == true).FirstOrDefault(); if (getEmpDetails != null) { Obj.EmployeeId = getEmpDetails.EmployeeID; if (Obj.IsDeleted == false) { if (Obj != null && Obj.SeatingName != null) { if (Obj.RequisitionId == 0) { Obj.Action = "I"; Obj.ActionStatus = "Y"; Obj.IsActive = "Y"; Obj.RequisitionType = "Add Seat"; isSaved = ePeopleRepository.SendForApproval(Obj); } else { Obj.Action = "U"; Obj.IsActive = "Y"; isSaved = ePeopleRepository.SendForApproval(Obj); } } } else { Obj.ActionStatus = "X"; Obj.RequisitionType = "Remove Seat"; isSaved = ePeopleRepository.SendForApproval(Obj); } isSaved = true; } else { isSaved = false; } } catch (Exception ex) { Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public bool ApprovalRequisition(AddChartModel Obj)", "Exception While Saving Vehicle seating chart.", Obj); throw; } return(isSaved); }
/// <summary> /// Created By : Ashwajit Bansod /// Created Date : 25-Oct-2019 /// Created For : To get uploaded files data /// </summary> /// <param name="EmployeeId"></param> /// <returns></returns> public List <UploadedFiles> GetUploadedFilesOfUser(string EmployeeId) { var lst = new List <UploadedFiles>(); try { var ePeopleRepository = new ePeopleRepository(); lst = ePeopleRepository.GetUploadFilesList(EmployeeId).Select(x => new UploadedFiles() { }).ToList(); return(null); } catch (Exception ex) { Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public UploadedFiles GetUploadedFilesOfUser(string EmployeeId)", "Exception While getting list of files by user id.", EmployeeId); throw; } }
/// <summary> /// Created By : Ashwajit bansod /// Created Date : 21-oct-2019 /// Created For : To get job title cout list /// </summary> /// <param name="Id"></param> /// <returns></returns> public List <AddChartModel> GetJobTitleCountForRequistion(long VSCId) { try { var ePeopleRepository = new ePeopleRepository(); var lst = ePeopleRepository.GetJobTitleCount(VSCId).Select(x => new AddChartModel() { JobTitleCount = x.JBT_JobCount, Id = x.JBT_Id, JobTitle = x.JBT_JobTitle }).ToList(); return(lst); } catch (Exception ex) { Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public List<AddChartModel> GetJobTitleCountForRequistion(long VSCId)", "Exception While getting lis of job tilte.", null); throw; } }
/// <summary> /// Created by : Ashwajit Bansod /// Created Date : 20-Oct-2019 /// Created For : To get Requsition list /// </summary> /// <returns></returns> public List <AddChartModel> GetRequisitionlist() { try { var ePeopleRepository = new ePeopleRepository(); var lst = ePeopleRepository.GetRequisitionlist().Select(x => new AddChartModel() { RequisitionId = x.RQS_Id, Id = x.RQS_ActivityId, RequisitionType = x.RQS_RequizationType, ActionStatus = x.RQS_ApprovalStatus == "W"?"Waiting": x.RQS_ApprovalStatus == "A"?"Approved":"Reject", SeatingName = x.Activity }).ToList(); return(lst); } catch (Exception ex) { Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public List<AddChartModel> GetRequisitionlist()", "Exception While getting lis of Requisition.", null); throw; } }
/// <summary> /// Created By :Ashwajit bansod /// Created Date : 22-Oct-2019 /// Created For : To send job title for approval /// </summary> /// <param name="model"></param> /// <returns></returns> public bool SendJobTitleForApproval(JobTitleModel model) { bool isSaved = false; var Obj = new AddChartModel(); try { var ePeopleRepository = new ePeopleRepository(); if (model != null) { Obj.JobTitleCount = model.JobTitleCount; Obj.Id = model.JobTitleId; if (model.JobTitleCount > model.JobTitleLastCount) { Obj.ActionStatus = "Y"; Obj.IsActive = "Y"; Obj.RequisitionType = "Add Head Count"; } else { Obj.ActionStatus = "Y"; Obj.IsActive = "Y"; Obj.RequisitionType = "Remove Head Count"; } isSaved = ePeopleRepository.SendForApproval(Obj); isSaved = true; } else { isSaved = false; } } catch (Exception ex) { Exception_B.Exception_B.exceptionHandel_Runtime(ex, " public bool SendJobTitleForApproval(JobTitleModel model)", "Exception While getting send job title for approval.", model); throw; } return(isSaved); }
/// <summary> /// Created By : Ashwajit bansod /// Created Date : 23-Sept-2019 /// Created For : To get User list by Location id /// </summary> /// <param name="LocationId"></param> /// <returns></returns> public List <UserModelList> GetUserHeirarchyList(long?LocationId, long?UserId) { var _ePeopleRepository = new ePeopleRepository(); try { var data = _ePeopleRepository.GetUserListByLocation(LocationId).Where(x => x.UserId == UserId).Select(x => new UserModelList() { Name = x.FirstName + " " + x.LastName, UserType = x.GlobalCode.CodeName, UserId = x.UserId, UserEmail = x.UserEmail, ProfileImage = x.ProfileImage, }).FirstOrDefault(); return(null); } catch (Exception ex) { Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public List<UserModelList> GetUserHeirarchyList(long? LocationId)", "Exception While getting list User.", LocationId); throw; } }
/// <summary> /// Created By :Ashwajit Bansod /// Created Date : 22-oct-2019 /// Created For : To get job details by job Id /// </summary> /// <param name="JobId"></param> /// <returns></returns> public JobTitleModel GetJobTitleCount(long JobId) { var details = new JobTitleModel(); try { var ePeopleRepository = new ePeopleRepository(); var data = ePeopleRepository.GetJobCount(JobId); if (data != null) { details.JobTitleCount = data.JBT_JobCount; details.JobTitleId = data.JBT_Id; details.JobTitle = data.JBT_JobTitle; details.JobTitleLastCount = data.JBT_JobCount; } return(details); } catch (Exception ex) { Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public JobTitleModel GetJobTitleCount(long JobId)", "Exception While getting details of job tilte.", JobId); throw; } }
/// <summary> /// Created By :Ashwajit Bansod /// Created Date : 04-Oct-2019 /// Created For : To get User Details By User id /// </summary> /// <param name="LocationId"></param> /// <param name="UserId"></param> /// <returns></returns> public List <UserListViewEmployeeManagementModel> GetUserListByUserId(long?LocationId, long?UserId) { var _ePeopleRepository = new ePeopleRepository(); var lstDetails = new List <UserListViewEmployeeManagementModel>(); var UserModel = new UserListViewEmployeeManagementModel(); try { if (UserId > 0) { var getUserDetails = objworkorderEMSEntities.UserRegistrations.Where(x => x.UserId == UserId && x.IsEmailVerify == true && x.IsDeleted == false).FirstOrDefault(); if (getUserDetails != null) { var selfData = _ePeopleRepository.GetUserSelfDetailsByUserId(getUserDetails.EmployeeID); if (selfData != null) { UserModel.DepartmentName = selfData.DepartmentName; UserModel.EmployeeId = selfData.EMP_EmployeeID; UserModel.EmployeeName = selfData.EmployeeName; UserModel.JobDesc = selfData.VST_JobDescription; UserModel.JobTitle = selfData.JBT_JobTitle; UserModel.LocationId = selfData.EMP_LocationId; UserModel.LocationName = selfData.LocationName; UserModel.JobTitleId = selfData.EMP_JobTitleId; UserModel.ProfilePhoto = selfData.EMP_Photo; string[] JobTitleList = UserModel.JobDesc.Split('|'); List <string> myCollection = new List <string>(); foreach (string title in JobTitleList) { if (title != " " && title != "") { myCollection.Add(title); } UserModel.JobDescList = myCollection; } lstDetails.Add(UserModel); //lstDetails.Add(item); } var data = _ePeopleRepository.GetUserListByUserId(getUserDetails.EmployeeID).Select(x => new UserListViewEmployeeManagementModel() { DepartmentName = x.DepartmentName, EmployeeId = x.EMP_EmployeeID, EmployeeName = x.EmployeeName, JobDesc = x.VST_JobDescription, JobTitle = x.JBT_JobTitle, LocationId = x.EMP_LocationId, LocationName = x.LocationName, JobTitleId = x.EMP_JobTitleId, ProfilePhoto = x.EMP_Photo }).ToList(); foreach (var item in data) { string[] JobTitleList = item.JobDesc.Split('|'); List <string> myCollection = new List <string>(); foreach (string title in JobTitleList) { if (title != " " && title != "") { myCollection.Add(title); } item.JobDescList = myCollection; } lstDetails.Add(item); } } return(lstDetails); } } catch (Exception ex) { Exception_B.Exception_B.exceptionHandel_Runtime(ex, "public List<UserListViewEmployeeManagementModel> GetUserList(long? LocationId, long? UserId)", "Exception While getting list User.", LocationId); throw; } return(lstDetails); }