public IEnumerable <ComboBoxList> GetJobWorkerHelpList(int Processid, string term)
{
int CurrentSiteId = (int)System.Web.HttpContext.Current.Session["SiteId"];
int CurrentDivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
string DivId = "|" + CurrentDivisionId.ToString() + "|";
string SiteId = "|" + CurrentSiteId.ToString() + "|";
var list = (from b in _unitOfWork.Repository <JobWorker>().Instance
join bus in _unitOfWork.Repository <BusinessEntity>().Instance on b.PersonID equals bus.PersonID into BusinessEntityTable
from BusinessEntityTab in BusinessEntityTable.DefaultIfEmpty()
join p in _unitOfWork.Repository <Person>().Instance on b.PersonID equals p.PersonID into PersonTable
from PersonTab in PersonTable.DefaultIfEmpty()
join pp in _unitOfWork.Repository <PersonProcess>().Instance on b.PersonID equals pp.PersonId into PersonProcessTable
from PersonProcessTab in PersonProcessTable.DefaultIfEmpty()
where PersonProcessTab.ProcessId == Processid &&
(string.IsNullOrEmpty(term) ? 1 == 1 : PersonTab.Name.ToLower().Contains(term.ToLower())) &&
BusinessEntityTab.DivisionIds.IndexOf(DivId) != -1 &&
BusinessEntityTab.SiteIds.IndexOf(SiteId) != -1
orderby PersonTab.Name
select new ComboBoxList
{
Id = b.PersonID,
PropFirst = PersonTab.Name
//PropSecond = BusinessEntityTab.SiteIds.IndexOf(SiteId).ToString()
}
).Take(20);
return(list.ToList());
}
public IQueryable <ComboBoxResult> GetCustomPerson(int Id, string term)
{
int DocTypeId = Id;
int SiteId = (int)System.Web.HttpContext.Current.Session["SiteId"];
int DivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
var settings = new ProdOrderSettingsService(_unitOfWork).GetProdOrderSettingsForDocument(DocTypeId, DivisionId, SiteId);
string[] PersonRoles = null;
if (!string.IsNullOrEmpty(settings.filterPersonRoles))
{
PersonRoles = settings.filterPersonRoles.Split(",".ToCharArray());
}
else
{
PersonRoles = new string[] { "NA" };
}
string DivIdStr = "|" + DivisionId.ToString() + "|";
string SiteIdStr = "|" + SiteId.ToString() + "|";
int ProcessId = new ProcessService(_unitOfWork).Find(ProcessConstants.Sales).ProcessId;
var list = (from p in db.Persons
join bus in db.BusinessEntity on p.PersonID equals bus.PersonID into BusinessEntityTable
from BusinessEntityTab in BusinessEntityTable.DefaultIfEmpty()
join pp in db.PersonProcess on p.PersonID equals pp.PersonId into PersonProcessTable
from PersonProcessTab in PersonProcessTable.DefaultIfEmpty()
join pr in db.PersonRole on p.PersonID equals pr.PersonId into PersonRoleTable
from PersonRoleTab in PersonRoleTable.DefaultIfEmpty()
where PersonProcessTab.ProcessId == ProcessId &&
(string.IsNullOrEmpty(term) ? 1 == 1 : (p.Name.ToLower().Contains(term.ToLower()) || p.Code.ToLower().Contains(term.ToLower()))) &&
(string.IsNullOrEmpty(settings.filterPersonRoles) ? 1 == 1 : PersonRoles.Contains(PersonRoleTab.RoleDocTypeId.ToString())) &&
BusinessEntityTab.DivisionIds.IndexOf(DivIdStr) != -1 &&
BusinessEntityTab.SiteIds.IndexOf(SiteIdStr) != -1 &&
(p.IsActive == null ? 1 == 1 : p.IsActive == true)
group new { p } by new { p.PersonID } into Result
orderby Result.Max(m => m.p.Name)
select new ComboBoxResult
{
id = Result.Key.PersonID.ToString(),
text = Result.Max(m => m.p.Name + ", " + m.p.Suffix + " [" + m.p.Code + "]"),
}
);
return(list);
}
public ComboBoxPagedResult GetListWithProcess(string searchTerm, int pageSize, int pageNum, int ProcessId)
{
int CurrentSiteId = (int)System.Web.HttpContext.Current.Session["SiteId"];
int CurrentDivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
string DivId = "|" + CurrentDivisionId.ToString() + "|";
string SiteId = "|" + CurrentSiteId.ToString() + "|";
var list = (from b in _JobworkerRepository.Instance
join bus in _unitOfWork.Repository <BusinessEntity>().Instance on b.PersonID equals bus.PersonID into BusinessEntityTable
from BusinessEntityTab in BusinessEntityTable.DefaultIfEmpty()
join p in _unitOfWork.Repository <Person>().Instance on b.PersonID equals p.PersonID into PersonTable
from PersonTab in PersonTable.DefaultIfEmpty()
join pp in _unitOfWork.Repository <PersonProcess>().Instance on b.PersonID equals pp.PersonId into PersonProcessTable
from PersonProcessTab in PersonProcessTable.DefaultIfEmpty()
where PersonProcessTab.ProcessId == ProcessId &&
(string.IsNullOrEmpty(searchTerm) ? 1 == 1 : (PersonTab.Name.ToLower().Contains(searchTerm.ToLower()) || PersonTab.Code.ToLower().Contains(searchTerm.ToLower()))) &&
BusinessEntityTab.DivisionIds.IndexOf(DivId) != -1 &&
(PersonTab.IsActive == null ? 1 == 1 : PersonTab.IsActive == true) &&
BusinessEntityTab.SiteIds.IndexOf(SiteId) != -1
orderby PersonTab.Name
select new ComboBoxResult
{
id = b.PersonID.ToString(),
text = PersonTab.Name + "|" + PersonTab.Code,
}
);
var temp = list
.Skip(pageSize * (pageNum - 1)).Take(pageSize).ToList();
var count = list.Count();
ComboBoxPagedResult Data = new ComboBoxPagedResult();
Data.Results = temp;
Data.Total = count;
return(Data);
}
