public virtual JobOfferContainer JobOfferSelectAll()
{
TraceCallEnterEvent.Raise();
try
{
JobOfferContainer result;
DataSet entitySet = m_DataContext.ndihdJobOfferSelectAll();
result = new JobOfferContainer(entitySet.Tables[0]);
TraceCallReturnEvent.Raise();
return result;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public JobOfferContainer JobOfferSelectFiltered(JobOffer filter)
{
PrincipalPermission permReg = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Registered");
PrincipalPermission permAdmin = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permReg.Union(permAdmin).Demand();
TraceCallEnterEvent.Raise();
try
{
JobOfferContainer result = new JobOfferContainer();
DataSet entitySet = m_DataContext.ndihdJobOfferSelectFiltered(filter.FilterOnRefId, filter.ID, filter.Sender, filter.Description, filter.Message,
filter.Requirements,
filter.City,
filter.RegionRef, filter.QualificationMinRef, filter.Status,
filter.FilterOnActivityPrevention,
filter.FilterOnActivityResearch,
filter.FilterOnActivityRehabilitation,
filter.FilterOnActivityOther,
filter.FilterOnNotificationsent, filter.Expiredate, filter.NotificationDate, filter.ExpireDatexpired);
result = new JobOfferContainer(entitySet.Tables[0]);
TraceCallReturnEvent.Raise();
return result;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
/// <summary>
/// Shows the grid.
/// </summary>
/// <param name="dataGrid">The data grid.</param>
/// <param name="index">The index.</param>
/// <param name="sort">The sort.</param>
/// <param name="order">The order.</param>
protected void ShowGrid(DataGrid dataGrid,
int index, string sort, string order)
{
dataGrid.PageSize = Helpers.GetPageSize("PageSize.JobOfferList");
// Get query result from database
JobOffer filter = new JobOffer(Guid.Empty);
filter.Sender = Context.User.Identity.Name;
filter.Status = JobStatusEnum.ACT;
JobOfferContainer jobSelectedAll = m_JobSrv.JobOfferSelectFiltered(filter);
JobOfferContainer jobSelected = new JobOfferContainer();
if (cmbAll.SelectedValue != "" && cmbAll.SelectedValue != "0")
{
foreach (JobOffer job in jobSelectedAll.All)
{
int answerCount = 0;
foreach (JobAnswer answer in m_answers.All)
{
if (answer.JobRef == job.ID)
{
answerCount++;
}
}
if (cmbAll.SelectedValue == "1" && answerCount == 0) // nincs jelentkező
{
jobSelected.Add(job);
}
if (cmbAll.SelectedValue == "2" && answerCount > 0) //van
{
jobSelected.Add(job);
}
}
}
else
{
jobSelected = jobSelectedAll;
}
if (jobSelected.AllCount > 0)
{
gridJob.Visible = true;
lblNotFound.Visible = false;
}
else
{
gridJob.Visible = false;
lblNotFound.Visible = true;
}
ArrayList sortableList;
// Sort if necessary
if (sort == null)
{
sortableList = jobSelected.All.Items;
}
else
{
if (String.Compare(order, "Ascending", true) == 0)
{
sortableList = jobSelected.All.SortBy(sort, true);
}
else sortableList = String.Compare(order, "Descending", true) == 0 ? jobSelected.All.SortBy(sort, false) : jobSelected.All.SortBy(sort);
}
// Bind list to datagrid control
dataGrid.CurrentPageIndex = index;
dataGrid.CurrentPageIndex = jobSelected.AllCount <= dataGrid.PageSize*dataGrid.CurrentPageIndex ? 0 : index;
dataGrid.CurrentSortExpression = sort;
dataGrid.CurrentSortOrder = order;
dataGrid.DataSource = sortableList;
dataGrid.DataBind();
}
public JobOfferContainer JobOfferSelectBySubscriber(DBString SubscriberIDVal, DBString TypeIdRef)
{
PrincipalPermission permReg = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Registered");
PrincipalPermission permAdmin = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permReg.Union(permAdmin).Demand();
TraceCallEnterEvent.Raise();
try
{
JobOfferContainer result = new JobOfferContainer();
DataSet entitySet = m_DataContext.ndihdJobOfferSelectBySubscriber(SubscriberIDVal, TypeIdRef);
result = new JobOfferContainer(entitySet.Tables[0]);
TraceCallReturnEvent.Raise();
return result;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public virtual JobOfferContainer SelectChildrenBySenderOfJobOffer(DBString LoginNameVal)
{
TraceCallEnterEvent.Raise();
try
{
JobOfferContainer result;
DataSet entitySet = m_DataContext.ndihdSenderOfJobOfferSelectBy(LoginNameVal);
result = new JobOfferContainer(entitySet.Tables[0]);
TraceCallReturnEvent.Raise();
return result;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}