private bool IsAssociateAllocateToMSID(AdminDashBoardDTO _adminDashBoardDTO)
{
try
{
_serviceTypeId = GetServiceTypeId(_adminDashBoardDTO.ServiceType);
_roleId = GetRoleId(_adminDashBoardDTO.Role);
var jobStatusId = _manuscriptLoginDBRepositoryReadSide.GetStatusMaster().Where(x => x.Description.ToLower() == "open").Select(x => x.ID).FirstOrDefault();
var jobProcessStatusId = _manuscriptLoginDBRepositoryReadSide.GetStatusMaster().Where(x => x.Description.ToLower() == "assigned").Select(x => x.ID).FirstOrDefault();
var MSIDAssociateToUser = (from MSD in manuscriptDataContextRead.ManuscriptLoginDetails
where MSD.CrestId == _adminDashBoardDTO.CrestId &&
MSD.RoleId == _roleId &&
MSD.ServiceTypeStatusId == _serviceTypeId &&
MSD.JobStatusId == jobStatusId &&
MSD.JobProcessStatusId == jobProcessStatusId
//&& MSD.UserRoleId == null
select MSD.UserRoleId).SingleOrDefault();
if (Convert.ToString(MSIDAssociateToUser) == "")
{
return(false);
}
else
{
return(true);
}
}
catch (Exception)
{
return(false);
}
}
private int IsJobOpenMSID(AdminDashBoardDTO _adminDashBoardDTO)
{
try
{
_serviceTypeId = GetServiceTypeId(_adminDashBoardDTO.ServiceType);
_roleId = GetRoleId(_adminDashBoardDTO.Role);
var jobStatusId = _manuscriptLoginDBRepositoryReadSide.GetStatusMaster().Where(x => x.Description.ToLower() == "open").Select(x => x.ID).FirstOrDefault();
// var jobProcessStatusId = _manuscriptLoginDBRepositoryReadSide.GetStatusMaster().Where(x => x.Description.ToLower() == "open" || x.Description.ToLower() == "fetch" || x.Description.ToLower() == "assigned").Select(x => x.ID).FirstOrDefault();
var IsJobOpen = (from MSD in manuscriptDataContextRead.ManuscriptLoginDetails
where MSD.CrestId == _adminDashBoardDTO.CrestId &&
MSD.RoleId == _roleId &&
MSD.ServiceTypeStatusId == _serviceTypeId &&
MSD.JobStatusId == jobStatusId
select MSD.JobProcessStatusId).SingleOrDefault();
if ((Convert.ToInt32(IsJobOpen)) == 7 || (Convert.ToInt32(IsJobOpen)) == 11 || (Convert.ToInt32(IsJobOpen)) == 13)
{
return(Convert.ToInt32(IsJobOpen));
}
else
{
return(0);
}
}
catch (Exception)
{
return(0);
}
}
public bool AllocateAssociateToMSID(AdminDashBoardDTO _adminDashBoardDTO)
{
if (IsAssociateAllocatedToMSID(_adminDashBoardDTO))
{
var prGetAssociateInfoResult = _manuscriptDBRepositoryReadSide.GetAssociateName(_adminDashBoardDTO.AssociateName).FirstOrDefault();
var jobProcessStatusId = _manuscriptLoginDBRepositoryReadSide.GetStatusMaster().Where(x => x.Description.ToLower() == "open").Select(x => x.ID).FirstOrDefault();
var jobStatusId = _manuscriptLoginDBRepositoryReadSide.GetStatusMaster().Where(x => x.Description.ToLower() == "open").Select(x => x.ID).FirstOrDefault();
var _updatemanuscriptLoginDetails = (from loginDetails in manuscriptDataContextRead.ManuscriptLoginDetails
where loginDetails.CrestId == _adminDashBoardDTO.CrestId &&
loginDetails.RoleId == _roleId &&
loginDetails.ServiceTypeStatusId == _serviceTypeId &&
loginDetails.JobProcessStatusId == jobProcessStatusId &&
loginDetails.JobStatusId == jobStatusId
select loginDetails).SingleOrDefault();
_updatemanuscriptLoginDetails.UserRoleId = prGetAssociateInfoResult.ID;
_updatemanuscriptLoginDetails.JobProcessStatusId = _manuscriptLoginDBRepositoryReadSide.GetStatusMaster().Where(x => x.Description.ToLower() == "assigned").Select(x => x.ID).FirstOrDefault();
_updatemanuscriptLoginDetails.AssignedDate = DateTime.Now;
_adminDashBoardDTO.manuscriptLoginDetails.Add(_updatemanuscriptLoginDetails);
SaveManuscriptLoginDetails(_adminDashBoardDTO);
return(true);
}
else
{
return(false);
}
}
public bool updateManuscriptLoginDeatilsForHold(AdminDashBoardDTO adminDashBoardDTO)
{
if (_adminDashBoardDBReadSide.HoldMSIDForJob(adminDashBoardDTO))
{
return(true);
}
else
{
return(false);
}
}
public bool updateManuscriptLoginDeatils(AdminDashBoardDTO adminDashBoardDTO)
{
if (_adminDashBoardDBReadSide.UnallocateAssociateUser(adminDashBoardDTO))
{
return(true);
}
else
{
return(false);
}
}
public void SaveManuscriptLoginDetails(AdminDashBoardDTO _adminDashBoardDTO)
{
foreach (var item in _adminDashBoardDTO.manuscriptLoginDetails)
{
if (item.Id == 0 || item.Id == null)
{
_manuscriptLoginDetailsRepository.AddManuscriptLoginDetails(item);
}
else
{
_manuscriptLoginDetailsRepository.UpdateManuscriptLoginDetails(item);
}
}
_manuscriptLoginDetailsRepository.SaveChanges();
}
public bool UnallocateAssociateUser(AdminDashBoardDTO _adminDashBoardDTO)
{
if (IsAssociateAllocateToMSID(_adminDashBoardDTO))
{
var jobProcessStatusId = _manuscriptLoginDBRepositoryReadSide.GetStatusMaster().Where(x => x.Description.ToLower() == "assigned").Select(x => x.ID).FirstOrDefault();
var jobStatusId = _manuscriptLoginDBRepositoryReadSide.GetStatusMaster().Where(x => x.Description.ToLower() == "open").Select(x => x.ID).FirstOrDefault();
var _updatemanuscriptLoginDetails = (from loginDetails in manuscriptDataContextRead.ManuscriptLoginDetails
where loginDetails.CrestId == _adminDashBoardDTO.CrestId &&
loginDetails.RoleId == _roleId &&
loginDetails.ServiceTypeStatusId == _serviceTypeId &&
loginDetails.JobProcessStatusId == jobProcessStatusId &&
loginDetails.JobStatusId == jobStatusId
select loginDetails).FirstOrDefault();
var manuscriptLoginDetails = new ManuscriptLoginDetails
{
CrestId = _updatemanuscriptLoginDetails.CrestId,
JobStatusId = _updatemanuscriptLoginDetails.JobStatusId,
ServiceTypeStatusId = _updatemanuscriptLoginDetails.ServiceTypeStatusId,
RoleId = _updatemanuscriptLoginDetails.RoleId,
JobProcessStatusId = _updatemanuscriptLoginDetails.JobStatusId,
};
_adminDashBoardDTO.manuscriptLoginDetails.Add(manuscriptLoginDetails);
_updatemanuscriptLoginDetails.JobProcessStatusId = _manuscriptLoginDBRepositoryReadSide.GetStatusMaster().Where(x => x.Description.ToLower() == "unallocate").Select(x => x.ID).FirstOrDefault();
_updatemanuscriptLoginDetails.FetchedDate = DateTime.Now;
_updatemanuscriptLoginDetails.SubmitedDate = DateTime.Now;
_updatemanuscriptLoginDetails.JobStatusId = _manuscriptLoginDBRepositoryReadSide.GetStatusMaster().Where(x => x.Description.ToLower() == "close").Select(x => x.ID).FirstOrDefault();
_adminDashBoardDTO.manuscriptLoginDetails.Add(_updatemanuscriptLoginDetails);
SaveManuscriptLoginDetails(_adminDashBoardDTO);
return(true);
}
else
{
return(false);
}
}
public bool IsAssociateAllocatedToMSID(AdminDashBoardDTO adminDashBoardDTO)
{
_serviceTypeId = GetServiceTypeId(adminDashBoardDTO.ServiceType);
_roleId = GetRoleId(adminDashBoardDTO.Role);
var jobProcessStatusId = _manuscriptLoginDBRepositoryReadSide.GetStatusMaster().Where(x => x.Description.ToLower() == "assigned").Select(x => x.ID).FirstOrDefault();
var jobStatusId = _manuscriptLoginDBRepositoryReadSide.GetStatusMaster().Where(x => x.Description.ToLower() == "open").Select(x => x.ID).FirstOrDefault();
var userRoleId = (from loginDetails in manuscriptDataContextRead.ManuscriptLoginDetails
where loginDetails.CrestId == adminDashBoardDTO.CrestId &&
loginDetails.ServiceTypeStatusId == _serviceTypeId &&
loginDetails.RoleId == _roleId &&
loginDetails.JobProcessStatusId == jobProcessStatusId &&
loginDetails.JobStatusId == jobStatusId
select loginDetails.UserRoleId).FirstOrDefault();
if (Convert.ToInt32(userRoleId) == 0 || userRoleId.ToString().Trim() == "")
{
return(true);
}
else
{
//dataErrors.Add("Error:", "MSID is already alloacted.");
return(false);
}
}
public bool SaveManuscriptLoginDeatils(AdminDashBoardDTO adminDashBoardDTO)
{
return(_adminDashBoardDBReadSide.AllocateAssociateToMSID(adminDashBoardDTO));
}
public bool HoldMSIDForJob(AdminDashBoardDTO _adminDashBoardDTO)
{
int jobProcessStatusId = IsJobOpenMSID(_adminDashBoardDTO);
//assigned
if (jobProcessStatusId == 13 || jobProcessStatusId == 11)
{
var jobStatusIDvalue =
_manuscriptLoginDBRepositoryReadSide.GetStatusMaster().Where(x => x.Description.ToLower() == "open").Select(x => x.ID).FirstOrDefault();
var _updatemanuscriptLoginDetailsForAssigned = (from loginDetails in manuscriptDataContextRead.ManuscriptLoginDetails
where loginDetails.CrestId == _adminDashBoardDTO.CrestId &&
loginDetails.RoleId == _roleId &&
loginDetails.ServiceTypeStatusId == _serviceTypeId &&
loginDetails.JobStatusId == jobStatusIDvalue &&
loginDetails.JobProcessStatusId == jobProcessStatusId
select loginDetails).FirstOrDefault();
var jobProcessStatusIdOfHold = _manuscriptLoginDBRepositoryReadSide.GetStatusMaster().Where(x => x.Description.ToLower() == "on hold").Select(x => x.ID).FirstOrDefault();
var manuscriptLoginDetails = new ManuscriptLoginDetails
{
CrestId = _adminDashBoardDTO.CrestId,
JobStatusId = _updatemanuscriptLoginDetailsForAssigned.JobStatusId,
ServiceTypeStatusId = _serviceTypeId,
RoleId = _updatemanuscriptLoginDetailsForAssigned.RoleId,
JobProcessStatusId = jobProcessStatusIdOfHold,
};
_adminDashBoardDTO.manuscriptLoginDetails.Add(manuscriptLoginDetails);
_updatemanuscriptLoginDetailsForAssigned.JobProcessStatusId = _manuscriptLoginDBRepositoryReadSide.GetStatusMaster().Where(x => x.Description.ToLower() == "unallocate").Select(x => x.ID).FirstOrDefault();
_updatemanuscriptLoginDetailsForAssigned.FetchedDate = DateTime.Now;
_updatemanuscriptLoginDetailsForAssigned.SubmitedDate = DateTime.Now;
_updatemanuscriptLoginDetailsForAssigned.JobStatusId = _manuscriptLoginDBRepositoryReadSide.GetStatusMaster().Where(x => x.Description.ToLower() == "close").Select(x => x.ID).FirstOrDefault();
_adminDashBoardDTO.manuscriptLoginDetails.Add(_updatemanuscriptLoginDetailsForAssigned);
SaveManuscriptLoginDetails(_adminDashBoardDTO);
return(true);
}
else if (jobProcessStatusId == 7)
{
var jobStatusIDvalue = _manuscriptLoginDBRepositoryReadSide.GetStatusMaster().Where(x => x.Description.ToLower() == "open").Select(x => x.ID).FirstOrDefault();
var _updatemanuscriptLoginDetailsForOpen = (from loginDetails in manuscriptDataContextRead.ManuscriptLoginDetails
where loginDetails.CrestId == _adminDashBoardDTO.CrestId &&
loginDetails.RoleId == _roleId &&
loginDetails.ServiceTypeStatusId == _serviceTypeId &&
loginDetails.JobStatusId == jobStatusIDvalue &&
loginDetails.JobProcessStatusId == jobProcessStatusId
select loginDetails).FirstOrDefault();
_updatemanuscriptLoginDetailsForOpen.JobProcessStatusId = _manuscriptLoginDBRepositoryReadSide.GetStatusMaster().Where(x => x.Description.ToLower() == "on hold").Select(x => x.ID).FirstOrDefault();
_updatemanuscriptLoginDetailsForOpen.ModifiedDate = DateTime.Now;
_updatemanuscriptLoginDetailsForOpen.JobStatusId = _updatemanuscriptLoginDetailsForOpen.JobStatusId;
_adminDashBoardDTO.manuscriptLoginDetails.Add(_updatemanuscriptLoginDetailsForOpen);
SaveManuscriptLoginDetails(_adminDashBoardDTO);
return(true);
}
else
{
return(false);
}
return(false);
}
public AdminDashBoardService(String conString)
{
adminDashBoardDTO = new AdminDashBoardDTO();
adminDashBoardBL = new AdminDashBoardBL(conString);
}
