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