public IList <HREmployeeEvaluationResultEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression) { IList <HREmployeeEvaluationResultEntity> hREmployeeEvaluationResultEntityList = new List <HREmployeeEvaluationResultEntity>(); try { if (pageSize == -1) { pageSize = 1000000000; } if (String.IsNullOrEmpty(sortExpression)) { sortExpression = HREmployeeEvaluationResultEntity.FLD_NAME_EmployeeEvaluationResultID + " " + SQLConstants.SORT_ORDER_DESCENDING; } startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1; hREmployeeEvaluationResultEntityList = FCCHREmployeeEvaluationResult.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression); if (hREmployeeEvaluationResultEntityList != null && hREmployeeEvaluationResultEntityList.Count > 0) { totalRowCount = hREmployeeEvaluationResultEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(hREmployeeEvaluationResultEntityList ?? new List <HREmployeeEvaluationResultEntity>()); }
private void SaveHREmployeeEvaluationResultEntity() { if (IsValid) { try { HREmployeeEvaluationResultEntity hREmployeeEvaluationResultEntity = BuildHREmployeeEvaluationResultEntity(); Int64 result = -1; if (hREmployeeEvaluationResultEntity.IsNew) { result = FCCHREmployeeEvaluationResult.GetFacadeCreate().Add(hREmployeeEvaluationResultEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEvaluationResultEntity.FLD_NAME_EmployeeEvaluationResultID, hREmployeeEvaluationResultEntity.EmployeeEvaluationResultID.ToString(), SQLMatchType.Equal); result = FCCHREmployeeEvaluationResult.GetFacadeCreate().Update(hREmployeeEvaluationResultEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { _EmployeeEvaluationResultID = 0; _HREmployeeEvaluationResultEntity = new HREmployeeEvaluationResultEntity(); PrepareInitialView(); BindHREmployeeEvaluationResultList(); if (hREmployeeEvaluationResultEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Employee Evaluation Result Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "Employee Evaluation Result Information has been updated successfully.", false); } } else { if (hREmployeeEvaluationResultEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Employee Evaluation Result Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Employee Evaluation Result Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
protected void lvHREmployeeEvaluationResult_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 EmployeeEvaluationResultID; Int64.TryParse(e.CommandArgument.ToString(), out EmployeeEvaluationResultID); if (EmployeeEvaluationResultID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _EmployeeEvaluationResultID = EmployeeEvaluationResultID; PrepareEditView(); cpeEditor.Collapsed = false; cpeEditor.ClientState = "false"; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEvaluationResultEntity.FLD_NAME_EmployeeEvaluationResultID, EmployeeEvaluationResultID.ToString(), SQLMatchType.Equal); HREmployeeEvaluationResultEntity hREmployeeEvaluationResultEntity = new HREmployeeEvaluationResultEntity(); result = FCCHREmployeeEvaluationResult.GetFacadeCreate().Delete(hREmployeeEvaluationResultEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _EmployeeEvaluationResultID = 0; _HREmployeeEvaluationResultEntity = new HREmployeeEvaluationResultEntity(); PrepareInitialView(); BindHREmployeeEvaluationResultList(); MiscUtil.ShowMessage(lblMessage, "Employee Evaluation Result has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete Employee Evaluation Result.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
public IList <HREmployeeEvaluationResultEntity> GetData() { IList <HREmployeeEvaluationResultEntity> hREmployeeEvaluationResultEntityList = new List <HREmployeeEvaluationResultEntity>(); try { hREmployeeEvaluationResultEntityList = FCCHREmployeeEvaluationResult.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load); if (hREmployeeEvaluationResultEntityList != null && hREmployeeEvaluationResultEntityList.Count > 0) { totalRowCount = hREmployeeEvaluationResultEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(hREmployeeEvaluationResultEntityList ?? new List <HREmployeeEvaluationResultEntity>()); }
private void UpdateEvaluationInfo() { if (SubmittedAction == "UnLocked") { try { IList <ListViewDataItem> list = lvMDEvaluationCriteria.Items; if (list != null && list.Count > 0) { Int32 tempDataItemIndex = 0; foreach (ListViewDataItem lvdi in list) { //DataKey currentDataKey = lvPRMBOQDetail.DataKeys[tempDataItemIndex++]; //Int64 intPreBOQDetailID = (Int64)currentDataKey["BOQDetailID"]; // TextBox txtRemarksLV = (TextBox)lvdi.FindControl("txtRemarksLV"); TextBox txtEmployeeResultLV = (TextBox)lvdi.FindControl("txtEmployeeResultLV"); TextBox txtSupervisorResultLV = (TextBox)lvdi.FindControl("txtSupervisorResultLV"); Label lblQuestionLV = (Label)lvdi.FindControl("lblQuestionLV"); Label lblDescriptionLV = (Label)lvdi.FindControl("lblDescriptionLV"); DropDownList ddlAnswerScaleID = (DropDownList)lvdi.FindControl("ddlAnswerScaleID"); Label lblPointInThisQuestionLV = (Label)lvdi.FindControl("lblPointInThisQuestionLV"); Label lblEvaluationCriteriaCategoryIDLV = (Label)lvdi.FindControl("lblEvaluationCriteriaCategoryIDLV"); Label lblEmployeeEvaluationResultIDLV = (Label)lvdi.FindControl("lblEmployeeEvaluationResultIDLV"); Label lblEmployeeEvaluationIDLV = (Label)lvdi.FindControl("lblEmployeeEvaluationIDLV"); Label lblEvaluationCriteriaIDLV = (Label)lvdi.FindControl("lblEvaluationCriteriaIDLV"); Int64 resultID = 0; Int64.TryParse(lblEmployeeEvaluationResultIDLV.Text.ToString(), out resultID); HREmployeeEvaluationResultEntity hREmployeeEvaluationResultEntity = new HREmployeeEvaluationResultEntity(); if (resultID > 0) { hREmployeeEvaluationResultEntity = FCCHREmployeeEvaluationResult.GetFacadeCreate().GetByID(resultID); } hREmployeeEvaluationResultEntity.EvaluationCriteriaCategoryID = Int64.Parse(lblEvaluationCriteriaCategoryIDLV.Text); // should come from Session hREmployeeEvaluationResultEntity.Question = lblQuestionLV.Text.Trim(); hREmployeeEvaluationResultEntity.Description = lblDescriptionLV.Text.Trim(); hREmployeeEvaluationResultEntity.EmployeeEvaluationID = Int64.Parse(lblEmployeeEvaluationIDLV.Text); _EmployeeEvaluationID = Int64.Parse(hREmployeeEvaluationResultEntity.EmployeeEvaluationID.ToString()); hREmployeeEvaluationResultEntity.EmployeeEvaluationCriteriaID = Int64.Parse(lblEvaluationCriteriaCategoryIDLV.Text); hREmployeeEvaluationResultEntity.AnswerGivenByEmployeeDepartmentName = ""; hREmployeeEvaluationResultEntity.EmployeeFullName = ""; hREmployeeEvaluationResultEntity.EmployeeCode = ""; hREmployeeEvaluationResultEntity.EmployeeEvaluationCriteriaID = Int64.Parse(lblEvaluationCriteriaIDLV.Text); //hREmployeeEvaluationResultEntity.SupervisorEvaluationCriteriaID = Int64.Parse(ddlSupervisorEvaluationCriteriaID.SelectedValue); //hREmployeeEvaluationResultEntity.SupervisorDepartmentName = txtSupervisorDepartmentName.Text.Trim(); //hREmployeeEvaluationResultEntity.AnswerGivenBySupervisorEmployeeFullName = txtAnswerGivenBySupervisorEmployeeFullName.Text.Trim(); //hREmployeeEvaluationResultEntity.SupervisorEmployeeCode = txtSupervisorEmployeeCode.Text.Trim(); //if (!txtEmployeeResultLV.Text.Trim().IsNullOrEmpty()) //{ // hREmployeeEvaluationResultEntity.EmployeeResult = Int32.Parse(txtEmployeeResultLV.Text.Trim()); //} //else //{ // hREmployeeEvaluationResultEntity.EmployeeResult = null; //} if (Action == "Employee") { if (ddlAnswerScaleID != null && ddlAnswerScaleID.Items.Count > 0) { hREmployeeEvaluationResultEntity.EmployeeResult = Int32.Parse(ddlAnswerScaleID.SelectedValue.Trim()); } else { hREmployeeEvaluationResultEntity.EmployeeResult = null; } hREmployeeEvaluationResultEntity.Remarks = txtRemarksLV.Text.Trim().ToString(); } if (Action == "Supervisor") { if (ddlAnswerScaleID != null && ddlAnswerScaleID.Items.Count > 0) { hREmployeeEvaluationResultEntity.Result = Int32.Parse(ddlAnswerScaleID.SelectedValue.Trim()); } else { hREmployeeEvaluationResultEntity.Result = null; } hREmployeeEvaluationResultEntity.Extra1 = txtRemarksLV.Text.Trim().ToString(); } //if (!lblPointInThisQuestionLV.Text.Trim().IsNullOrEmpty()) //{ // hREmployeeEvaluationResultEntity.PointInThisQuestion = Int32.Parse(lblPointInThisQuestionLV.Text.Trim()); //} //else //{ // hREmployeeEvaluationResultEntity.PointInThisQuestion = null; //} hREmployeeEvaluationResultEntity.Extra2 = ""; if (resultID > 0) { String fe = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEvaluationResultEntity.FLD_NAME_EmployeeEvaluationResultID, resultID.ToString(), SQLMatchType.Equal); FCCHREmployeeEvaluationResult.GetFacadeCreate().Update(hREmployeeEvaluationResultEntity, fe, DatabaseOperationType.Update, TransactionRequired.No); } else { FCCHREmployeeEvaluationResult.GetFacadeCreate().Add(hREmployeeEvaluationResultEntity, DatabaseOperationType.Add, TransactionRequired.No); } MiscUtil.ShowMessage(lblMessage, "Evaluation Information has been saved successfully.", false); } BindMDEvaluationCriteriaList(); BindLabel(); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, "Failed to Save Evaluation Information.", true); } } }