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