/// <summary>AssignLocationToEmployeeUser
/// <CreatedOn>Sep-14-2016</CreatedOn>
/// <CreatedBy>Bhushan Dod</CreatedBy>
/// </summary>
/// <param name="LocationId"></param>
/// <param name="AdminUserId"></param>
public void AssignLocationToEmployeeUser(long locationId, long empUserId)
{
try
{
if (locationId > 0 && empUserId > 0)
{
objEmployeeLocationMappingRepository = new EmployeeLocationMappingRepository();
EmployeeLocationMapping ObjEmployeeLocationMapping;
ObjEmployeeLocationMapping = objEmployeeLocationMappingRepository.GetSingleOrDefault(mapp => mapp.LocationId == locationId && mapp.EmployeeUserId == empUserId && mapp.IsDeleted == false);
if (ObjEmployeeLocationMapping != null)
{
ObjEmployeeLocationMapping = new EmployeeLocationMapping();
ObjEmployeeLocationMapping.LocationId = locationId;
ObjEmployeeLocationMapping.EmployeeUserId = empUserId;
// ObjEmployeeLocationMapping. = empUserId;
ObjEmployeeLocationMapping.CreatedBy = empUserId;
ObjEmployeeLocationMapping.CreatedOn = DateTime.UtcNow;
objEmployeeLocationMappingRepository.Add(ObjEmployeeLocationMapping);
}
}
else
{
Exception_B.Exception_B.exceptionHandel_Runtime(new Exception("You are not allowed to assgin employee user to location 0. Means Location 0 is not allowed"), "public void AssignLocationToAdminUser(long locationId, long adminUserId)", "Exception from c#", "adminUserId:-" + empUserId + "," + "locationId:-" + locationId);
}
}
catch (Exception)
{ throw; }
}
/// <summary>
/// TO GET FULL DETAIL FULL DETAIL OF THE EMPLOYEE
/// </summary>
/// <CreatedBy>Manoj jaswal</CreatedBy>
/// <CreatedDate>2015-03-18</CreatedDate>
/// <param name="Loc_ID"></param>
/// <returns></returns>
public List <EmployeeModel> GetEmployeeByLocDetailed(long Loc_ID)
{
EmployeeLocationMappingRepository obj_EmployeeLocationMappingRepository = new EmployeeLocationMappingRepository();
return(obj_EmployeeLocationMappingRepository.GetEmployeeByLocDetailed(Loc_ID).Select(x => new EmployeeModel()
{
UserId = Convert.ToInt64(x.UserId),
Password = x.Password,
UserEmail = x.UserEmail,
AlternateEmail = x.AlternateEmail,
SubscriptionEmail = x.SubscriptionEmail,
UserType = Convert.ToInt64(x.UserType),
ProjectID = x.ProjectID,
FirstName = x.FirstName,
LastName = x.LastName,
Gender = x.Gender,
DOB = Convert.ToDateTime(x.DOB).ToString("MM/dd/yy"),
ProfileImage = x.ProfileImage,
IsLoginActive = Convert.ToBoolean(x.IsLoginActive),
IsEmailVerify = Convert.ToBoolean(x.IsEmailVerify),
TimeZoneId = x.TimeZoneId,
VendorID = x.VendorID,
BloodGroup = x.BloodGroup,
HiringDate = x.HiringDate,
EmployeeCategory = x.EmployeeCategory,
QRCID = x.QRCID,
EmployeeID = x.EmployeeID,
JobTitle = x.JobTitle,
DeviceId = x.DeviceId,
DeviceType = x.DeviceType,
ServiceAuthKey = x.ServiceAuthKey,
EmployeeLocationMappingId = x.EmployeeLocationMappingId,
EmployeeUserId = x.EmployeeUserId,
LocationId = x.LocationId,
AddressMasterId = x.AddressMasterId,
Address1 = x.Address1,
Address2 = x.Address2,
City = x.City,
StateId = x.StateId,
CountryId = x.CountryId,
Mobile = x.Mobile,
Phone = x.Phone,
ZipCode = x.ZipCode,
IsCurrentAddress = x.IsCurrentAddress,
IsPermanent = x.IsPermanent,
}).ToList());
}
/// <summary>
/// Created By: Ashwajit Bansod
/// Created Date: Aug-13-2018
/// Created For : To fetch Employee Data from User Registration Table
/// </summary>
/// <param name="objManagerAppModel"></param>
/// <returns></returns>
public List <EmployeeListModel> EmployeeList(ManagerAppModel objManagerAppModel)
{
workorderEMSEntities _workorderEMSEntities = new workorderEMSEntities();
var listEmployee = new List <EmployeeListModel>();
try
{
long UnAssignedId = Convert.ToInt64(DashboardWidget.UnAssignedWorkOrder);
long PriorityLevel = Convert.ToInt64(WorkRequestPriority.Level1Urgent);
var empManager = new EmployeeManager();
var userData = _workorderEMSEntities.UserRegistrations.Where(x => x.ServiceAuthKey == objManagerAppModel.ServiceAuthKey &&
x.IsDeleted == false).FirstOrDefault();
if (userData != null)
{
//var UserInRole = _workorderEMSEntities.UserRegistrations.
//Join(_workorderEMSEntities.AdminLocationMappings, u => u.UserId, uir => uir.AdminUserId,
//(u, uir) => new { u, uir }).
//Join(_workorderEMSEntities.LoginLogs, r => r.uir.AdminUserId, ro => ro.UserID, (r, ro) => new { r, ro })
//.Where(m => m.r.u.UserType == 3
// && m.r.u.IsEmailVerify == true
// && m.r.u.IsDeleted == false
// && m.r.u.IsLoginActive == true
// && m.r.uir.LocationId == objManagerAppModel.LocationId
// && m.ro.IsActive == true)
//.Select(ls => new EmployeeListModel()
//{
// EmployeeId = ls.r.u.EmployeeID,
// LocationId = ls.r.uir.LocationId,
// ProfileImage = ls.r.u.ProfileImage,
// UserId = ls.r.u.UserId,
// UserName = ls.r.u.FirstName + " " + ls.r.u.LastName
//}).ToList();
EmployeeLocationMappingRepository obj_EmployeeLocationMappingRepository = new EmployeeLocationMappingRepository();
listEmployee = obj_EmployeeLocationMappingRepository.GetActiveEmployeeByLocDetailed(objManagerAppModel.LocationId)
.Select(ls => new EmployeeListModel()
{
EmployeeId = ls.EmployeeID,
LocationId = objManagerAppModel.LocationId,
ProfileImage = ls.ProfileImage == null ? HostingPrefix + ProfileImagePath.Replace("~", "") + "no-profile-pic.jpg" : HostingPrefix + ProfileImagePath.Replace("~", "") + ls.ProfileImage,
UserId = ls.UserId,
UserName = ls.FirstName + " " + ls.LastName
}).ToList();
// listEmployee = empManager.GetEmployeeByLocDetailed(objManagerAppModel.LocationId)
//.Select( ls => new EmployeeListModel()
//{
// EmployeeId = ls.EmployeeID,
// LocationId = ls.LocationId,
// ProfileImage = ls.ProfileImage,
// UserId = ls.UserId,
// UserName = ls.FirstName + " " + ls.LastName
//}).ToList();
}
}
catch (Exception ex)
{
Exception_B.Exception_B.exceptionHandel_Runtime(ex, "List<EmployeeListModel> EmployeeList(ManagerAppModel objManagerAppModel)", "Exception While Listing Employee For Assigning Work order.", objManagerAppModel.LocationId);
throw;
}
return(listEmployee);
}
