public IList <HRSessionEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression)
{
IList <HRSessionEntity> hRSessionEntityList = new List <HRSessionEntity>();
try
{
if (pageSize == -1)
{
pageSize = 1000000000;
}
if (String.IsNullOrEmpty(sortExpression))
{
sortExpression = HRSessionEntity.FLD_NAME_SessionID + " " + SQLConstants.SORT_ORDER_DESCENDING;
}
startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1;
hRSessionEntityList = FCCHRSession.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression);
if (hRSessionEntityList != null && hRSessionEntityList.Count > 0)
{
totalRowCount = hRSessionEntityList[0].TotalRowCount;
}
}
catch (Exception ex)
{
}
return(hRSessionEntityList ?? new List <HRSessionEntity>());
}
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;
}
}
}
protected void lvHRSession_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 SessionID;
Int64.TryParse(e.CommandArgument.ToString(), out SessionID);
if (SessionID > 0)
{
if (string.Equals(e.CommandName, "EditItem"))
{
_SessionID = SessionID;
PrepareEditView();
cpeEditor.Collapsed = false;
cpeEditor.ClientState = "false";
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(HRSessionEntity.FLD_NAME_SessionID, SessionID.ToString(), SQLMatchType.Equal);
HRSessionEntity hRSessionEntity = new HRSessionEntity();
result = FCCHRSession.GetFacadeCreate().Delete(hRSessionEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
_SessionID = 0;
_HRSessionEntity = new HRSessionEntity();
PrepareInitialView();
BindHRSessionList();
MiscUtil.ShowMessage(lblMessage, "Session has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete Session.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
else if (e.CommandName == "GenerateSession")
{
_SessionID = SessionID;
this.ModalPopupExtender2.Show();
}
}
}
private void SaveHRSessionEntity()
{
if (IsValid)
{
try
{
HRSessionEntity hRSessionEntity = BuildHRSessionEntity();
Int64 result = -1;
if (hRSessionEntity.IsNew)
{
result = FCCHRSession.GetFacadeCreate().Add(hRSessionEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(HRSessionEntity.FLD_NAME_SessionID, hRSessionEntity.SessionID.ToString(), SQLMatchType.Equal);
result = FCCHRSession.GetFacadeCreate().Update(hRSessionEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
if (result > 0)
{
_SessionID = 0;
_HRSessionEntity = new HRSessionEntity();
PrepareInitialView();
BindHRSessionList();
if (hRSessionEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Session Information has been added successfully.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Session Information has been updated successfully.", false);
}
}
else
{
if (hRSessionEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Session Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Session Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
private void PrepareInitialView()
{
BuildDropDownList();
BindLabel();
SubmitButtonEnable();
Int64 employeeID = _CurrentEmployeeEvaluatedID;
if (employeeID > 0)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(ResourceEmployee_CustomEntity.FLD_NAME_EmployeeID, employeeID.ToString(), SQLMatchType.Equal);
IList <ResourceEmployee_CustomEntity> lst = FCCResourceEmployee_Custom.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe);
if (lst != null && lst.Count > 0)
{
lblEmployeeName.Text = lst[0].MemberFullName.ToString();
lblEmployeeCode.Text = lst[0].EmployeeCode;
lblDepartment.Text = lst[0].DepartmentName;
lblDesignation.Text = lst[0].DesignationName;
lblConfirmDate.Text = lst[0].ConfirmDate.ToStringDefault();
lblJoinDate.Text = lst[0].JoinDate.ToStringDefault();
lblSessionEvaluatedBy.Text = CurrentMember.FirstName + " " + CurrentMember.MiddleName + " " + CurrentMember.LastName;
if (lst[0].EmployeeID == MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember))
{
lblSessionEvaluatedBy.Text += " (Self)";
}
else
{
lblSessionEvaluatedBy.Text += " (Supervisor)";
}
}
}
String fe_session = SqlExpressionBuilder.PrepareFilterExpression(HRSessionEntity.FLD_NAME_SessionID, _CurrentSessionID.ToString(), SQLMatchType.Equal);
HRSessionEntity hRSessionEntity = FCCHRSession.GetFacadeCreate().GetByID(_CurrentSessionID);
if (hRSessionEntity != null && hRSessionEntity.SessionID > 0)
{
lblSessionName.Text = hRSessionEntity.SessionName;
lblSessionStartDate.Text = hRSessionEntity.StartDate.ToStringDefault();
lblSessionEndDate.Text = hRSessionEntity.EndDate.ToStringDefault();
lblSessionEvaluationType.Text = "N/A";
}
}
public IList <HRSessionEntity> GetData()
{
IList <HRSessionEntity> hRSessionEntityList = new List <HRSessionEntity>();
try
{
hRSessionEntityList = FCCHRSession.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load);
if (hRSessionEntityList != null && hRSessionEntityList.Count > 0)
{
totalRowCount = hRSessionEntityList[0].TotalRowCount;
}
}
catch (Exception ex)
{
}
return(hRSessionEntityList ?? new List <HRSessionEntity>());
}
