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