public IList <HREmployeeSupervisorMap_DetailedEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression, String filterExpression)
{
IList <HREmployeeSupervisorMap_DetailedEntity> hREmployeeSupervisorMap_DetailedEntityList = new List <HREmployeeSupervisorMap_DetailedEntity>();
try
{
if (String.IsNullOrEmpty(sortExpression))
{
sortExpression = "EmployeeSupervisorMapID";// +" " + SQLConstants.SORT_ORDER_DESCENDING;
}
Int32 currentPage = Convert.ToInt32(startRowIndex / pageSize) + 1;
//startRowIndex = Convert.ToInt32( startRowIndex / pageSize) + 1;
if (pageSize == -1)
{
pageSize = 1000000000;
}
hREmployeeSupervisorMap_DetailedEntityList = FCCHREmployeeSupervisorMap_Detailed.GetFacadeCreate().GetIL(pageSize, currentPage, sortExpression, filterExpression);
if (hREmployeeSupervisorMap_DetailedEntityList != null && hREmployeeSupervisorMap_DetailedEntityList.Count > 0)
{
totalRowCount = hREmployeeSupervisorMap_DetailedEntityList[0].TotalRowCount;
}
}
catch (Exception ex)
{
}
return(hREmployeeSupervisorMap_DetailedEntityList ?? new List <HREmployeeSupervisorMap_DetailedEntity>());
}
private void PrepareInitialView()
{
BuildDropDownList();
txtStartDate.Text = System.DateTime.Now.AddDays(-7).ToString(UIConstants.SHORT_DATE_FORMAT);
txtEndDate.Text = System.DateTime.Now.ToString(UIConstants.SHORT_DATE_FORMAT);
if (this.Page.User.Identity.IsAuthenticated == true)
{
//if (Roles.IsUserInRole(this.Page.User.Identity.Name, "1.466") == true ||
// Roles.IsUserInRole(this.Page.User.Identity.Name, "HR") == true ||
// Roles.IsUserInRole(this.Page.User.Identity.Name, "CRM") == true ||
// Roles.IsUserInRole(this.Page.User.Identity.Name, "Accounts") == true ||
// Roles.IsUserInRole(this.Page.User.Identity.Name, "Engineers") == true||
// Roles.IsUserInRole(this.Page.User.Identity.Name, "IS") == true)
if (this.Page.User.Identity.Name.Equals("17.466") == true ||
this.Page.User.Identity.Name.Equals("17.042") == true ||
this.Page.User.Identity.Name.Equals("17.1127") == true ||
this.Page.User.Identity.Name.Equals("17.605") == true ||
this.Page.User.Identity.Name.Equals("17.599") == true ||
this.Page.User.Identity.Name.Equals("17.1000") == true ||
this.Page.User.Identity.Name.Equals("17.979") == true ||
this.Page.User.Identity.Name.Equals("17.687") == true ||
this.Page.User.Identity.Name.Equals("17.788") == true ||
this.Page.User.Identity.Name.Equals("17.1116") == true ||
this.Page.User.Identity.Name.Equals("17.799") == true ||
this.Page.User.Identity.Name.Equals("17.780") == true)
{
String fe_session = SqlExpressionBuilder.PrepareFilterExpression(HRSessionEntity.FLD_NAME_EvaluationSessionStatusID, MasterDataConstants.MDEvaluationSessionStatus.OPEN.ToString(), SQLMatchType.Equal);
IList <HRSessionEntity> lstHRSessionEntity = FCCHRSession.GetFacadeCreate().GetIL(null, null, String.Empty, fe_session, DatabaseOperationType.LoadWithFilterExpression);
if (lstHRSessionEntity != null && lstHRSessionEntity.Count > 0)
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeSupervisorMap_DetailedEntity.FLD_NAME_SupervisorEmployeeID, MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember).ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression("HREmployeeSupervisorMap." + HREmployeeSupervisorMap_DetailedEntity.FLD_NAME_SessionCategoryID, lstHRSessionEntity[0].SessionID.ToString(), SQLMatchType.Equal);
String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);
IList <HREmployeeSupervisorMap_DetailedEntity> lst = FCCHREmployeeSupervisorMap_Detailed.GetFacadeCreate().GetIL(100000, 1, String.Empty, fe);
if (lst != null && lst.Count > 0)
{
ddlEmployeeID.Items.Clear();
foreach (HREmployeeSupervisorMap_DetailedEntity ent in lst)
{
ListItem lstItem = new ListItem();
lstItem.Text = ent.EmployeeCode + " - " + ent.EmployeeFullName + "(" + ent.SessionCategoryName.ToString() + ")";
lstItem.Value = ent.EmployeeID.ToString();
ddlEmployeeID.Items.Add(lstItem);
}
}
ddlEmployeeID.Enabled = true;
}
}
else
{
ddlEmployeeID.SelectedValue = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember).ToString();
ddlEmployeeID.Enabled = false;
}
}
}
