public IList <HREmployeeEvaluationEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression) { IList <HREmployeeEvaluationEntity> hREmployeeEvaluationEntityList = new List <HREmployeeEvaluationEntity>(); try { if (pageSize == -1) { pageSize = 1000000000; } if (String.IsNullOrEmpty(sortExpression)) { sortExpression = HREmployeeEvaluationEntity.FLD_NAME_EmployeeEvaluationID + " " + SQLConstants.SORT_ORDER_DESCENDING; } startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1; hREmployeeEvaluationEntityList = FCCHREmployeeEvaluation.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression); if (hREmployeeEvaluationEntityList != null && hREmployeeEvaluationEntityList.Count > 0) { totalRowCount = hREmployeeEvaluationEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(hREmployeeEvaluationEntityList ?? new List <HREmployeeEvaluationEntity>()); }
private void SaveHREmployeeEvaluationEntity() { if (IsValid) { try { HREmployeeEvaluationEntity hREmployeeEvaluationEntity = BuildHREmployeeEvaluationEntity(); Int64 result = -1; if (hREmployeeEvaluationEntity.IsNew) { result = FCCHREmployeeEvaluation.GetFacadeCreate().Add(hREmployeeEvaluationEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEvaluationEntity.FLD_NAME_EmployeeEvaluationID, hREmployeeEvaluationEntity.EmployeeEvaluationID.ToString(), SQLMatchType.Equal); result = FCCHREmployeeEvaluation.GetFacadeCreate().Update(hREmployeeEvaluationEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { _EmployeeEvaluationID = 0; _HREmployeeEvaluationEntity = new HREmployeeEvaluationEntity(); PrepareInitialView(); BindHREmployeeEvaluationList(); if (hREmployeeEvaluationEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Employee Evaluation Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Employee Evaluation Information has been updated successfully.", false); } } else { if (hREmployeeEvaluationEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Employee Evaluation Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Employee Evaluation Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
private void SubmitButtonEnable() { if (Action == "Supervisor") { String fe1 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEvaluationEntity.FLD_NAME_SessionID, _CurrentSessionID.ToString(), SQLMatchType.Equal); String fe2 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEvaluationEntity.FLD_NAME_SupervisorEmployeeID, _SupervisorEmployeeID.ToString(), SQLMatchType.Equal); String fe3 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEvaluationEntity.FLD_NAME_EmployeeID, _CurrentEmployeeEvaluatedID.ToString(), SQLMatchType.Equal); String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2); fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe3); IList <HREmployeeEvaluationEntity> lst = FCCHREmployeeEvaluation.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); if (lst != null && lst.Count > 0) { if (lst[0].SupervisorSubmitDate.HasValue) { btnSubmit.Visible = false; lblFormLock.Visible = true; SubmittedAction = "Locked"; } else { // btnSubmit.Visible = true; lblFormLock.Visible = false; SubmittedAction = "UnLocked"; } } } else if (Action == "Employee") { String fe1 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEvaluationEntity.FLD_NAME_SessionID, _CurrentSessionID.ToString(), SQLMatchType.Equal); String fe2 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEvaluationEntity.FLD_NAME_EmployeeID, _CurrentEmployeeEvaluatedID.ToString(), SQLMatchType.Equal); String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2); IList <HREmployeeEvaluationEntity> lst = FCCHREmployeeEvaluation.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); if (lst != null && lst.Count > 0) { if (lst[0].EmployeeSubmitDate.HasValue) { btnSubmit.Visible = false; lblFormLock.Visible = true; SubmittedAction = "Locked"; } else { // btnSubmit.Visible = true; lblFormLock.Visible = false; SubmittedAction = "UnLocked"; } } } }
protected void lvHREmployeeEvaluation_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 EmployeeEvaluationID; Int64.TryParse(e.CommandArgument.ToString(), out EmployeeEvaluationID); if (EmployeeEvaluationID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _EmployeeEvaluationID = EmployeeEvaluationID; PrepareEditView(); cpeEditor.Collapsed = false; cpeEditor.ClientState = "false"; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEvaluationEntity.FLD_NAME_EmployeeEvaluationID, EmployeeEvaluationID.ToString(), SQLMatchType.Equal); HREmployeeEvaluationEntity hREmployeeEvaluationEntity = new HREmployeeEvaluationEntity(); result = FCCHREmployeeEvaluation.GetFacadeCreate().Delete(hREmployeeEvaluationEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _EmployeeEvaluationID = 0; _HREmployeeEvaluationEntity = new HREmployeeEvaluationEntity(); PrepareInitialView(); BindHREmployeeEvaluationList(); MiscUtil.ShowMessage(lblMessage, "Employee Evaluation has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Employee Evaluation.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
protected void btnSubmit_Click(object sender, EventArgs e) { //String fe1 = SqlExpressionBuilder.PrepareFilterExpression("HREmployeeEvaluation.EmployeeID", MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember).ToString(), SQLMatchType.Equal); //String fe2 = SqlExpressionBuilder.PrepareFilterExpression("HRSession.SessionID", "1", SQLMatchType.Equal); //String fe3 = "HREmployeeEvaluationResult.EmployeeResult is not null"; //String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2); //fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe3); //IList<HREmployeeEvaluationSession_CustomEntity> lst = FCCHREmployeeEvaluationSession_Custom.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe); //if(lst!=null && lst.cou // UpdateEvaluationInfo(); if (_EmployeeEvaluationID > 0) { HREmployeeEvaluationEntity hREmployeeEvaluationEntity = FCCHREmployeeEvaluation.GetFacadeCreate().GetByID(_EmployeeEvaluationID); if (Action == "Supervisor") { hREmployeeEvaluationEntity.SupervisorSubmitDate = System.DateTime.Now; } if (Action == "Employee") { hREmployeeEvaluationEntity.EmployeeSubmitDate = System.DateTime.Now; } Int64 result = -1; String fe_update = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEvaluationEntity.FLD_NAME_EmployeeEvaluationID, _EmployeeEvaluationID.ToString(), SQLMatchType.Equal); result = FCCHREmployeeEvaluation.GetFacadeCreate().Update(hREmployeeEvaluationEntity, fe_update, DatabaseOperationType.Update, TransactionRequired.No); if (result > 0) { MiscUtil.ShowMessage(lblMessage, "Submitted Successfully.", false); SubmitButtonEnable(); } else { MiscUtil.ShowMessage(lblMessage, "Some Error Occoured.", false); } } }
public IList <HREmployeeEvaluationEntity> GetData() { IList <HREmployeeEvaluationEntity> hREmployeeEvaluationEntityList = new List <HREmployeeEvaluationEntity>(); try { hREmployeeEvaluationEntityList = FCCHREmployeeEvaluation.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load); if (hREmployeeEvaluationEntityList != null && hREmployeeEvaluationEntityList.Count > 0) { totalRowCount = hREmployeeEvaluationEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(hREmployeeEvaluationEntityList ?? new List <HREmployeeEvaluationEntity>()); }
protected void lvHRSession_ItemDataBound(object sender, ListViewItemEventArgs e) { if (e.Item.ItemType == ListViewItemType.DataItem) { ListViewDataItem dataItem = (ListViewDataItem)e.Item; HRSession_DetailedEntity ent = (HRSession_DetailedEntity)dataItem.DataItem; String fe = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEvaluationEntity.FLD_NAME_SessionID, ent.SessionID.ToString(), SQLMatchType.Equal); IList <HREmployeeEvaluationEntity> lst = FCCHREmployeeEvaluation.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression); LinkButton lnkbtnGenerateSession = (LinkButton)e.Item.FindControl("lnkbtnGenerateSession"); HyperLink hypHRReport = (HyperLink)e.Item.FindControl("hypHRReport"); hypHRReport.Visible = false; if (lst != null && lst.Count > 0) { lnkbtnGenerateSession.Visible = false; } if (ent.EvaluationSessionStatusID != MasterDataConstants.MDEvaluationSessionStatus.OPEN) { lnkbtnGenerateSession.Visible = false; } #region SupervisorSubmited or not if (ent.SessionCategoryID == MasterDataConstants.MDEvaluationSessionCategory.PBR && (CurrentMember.MemberID == 25 || CurrentMember.MemberID == 182 || CurrentMember.MemberID == 317 || CurrentMember.MemberID == 20520 || CurrentMember.MemberID == 27 || CurrentMember.MemberID == 181)) { hypHRReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.HR_EMPLOYEE_EVALUATIONREPORT_REPORT_FOR_ALL_EMPLOYEE, UrlConstants.OVERVIEW_EVALUATION_SESSION_ID, ent.SessionID.ToString()).ToString(); hypHRReport.Visible = true; hypHRReport.Target = "_blank"; } #endregion } }