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