private void BindLabel()
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("HREmployeeEvaluation.EmployeeID", _CurrentEmployeeEvaluatedID.ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression("HRSession.SessionID", _CurrentSessionID.ToString(), 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.Count > 0)
{
var resultMyScore = (from s in lst
select s.EmployeeResult).Sum(val => val);
var resultSupervisor = (from s in lst
select s.Result).Sum(val => val);
lblMyMarks.Text = resultMyScore.ToString();
lblSupervisorMarks.Text = resultSupervisor.ToString();
}
else
{
lblMyMarks.Text = "0";
lblSupervisorMarks.Text = "0";
}
}
public IList <HREmployeeEvaluationSession_CustomEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression, String filterExpression)
{
IList <HREmployeeEvaluationSession_CustomEntity> hREmployeeEvaluationSession_CustomEntityList = new List <HREmployeeEvaluationSession_CustomEntity>();
try
{
if (String.IsNullOrEmpty(sortExpression))
{
sortExpression = "SessionID";
}
Int32 currentPage = Convert.ToInt32(startRowIndex / pageSize) + 1;
//startRowIndex = Convert.ToInt32( startRowIndex / pageSize) + 1;
if (pageSize == -1)
{
pageSize = 1000000000;
}
hREmployeeEvaluationSession_CustomEntityList = FCCHREmployeeEvaluationSession_Custom.GetFacadeCreate().GetIL(pageSize, currentPage, sortExpression, filterExpression);
if (hREmployeeEvaluationSession_CustomEntityList != null && hREmployeeEvaluationSession_CustomEntityList.Count > 0)
{
totalRowCount = hREmployeeEvaluationSession_CustomEntityList[0].TotalRowCount;
}
}
catch (Exception ex)
{
}
return(hREmployeeEvaluationSession_CustomEntityList ?? new List <HREmployeeEvaluationSession_CustomEntity>());
}
protected void odsMDEvaluationCriteria_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
if (e.ExecutingSelectCount == false && e.Arguments.SortExpression == String.Empty)
{
UpdateEvaluationInfo();
}
String fe = String.Empty;
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("HREmployeeEvaluation.EmployeeID", _CurrentEmployeeEvaluatedID.ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression("HRSession.SessionID", _CurrentSessionID.ToString(), SQLMatchType.Equal);
#region Submit Button
if (Action == "Employee")
{
String fe11 = SqlExpressionBuilder.PrepareFilterExpression("HREmployeeEvaluation.EmployeeID", _CurrentEmployeeEvaluatedID.ToString(), SQLMatchType.Equal);
String fe22 = SqlExpressionBuilder.PrepareFilterExpression("HRSession.SessionID", _CurrentSessionID.ToString(), SQLMatchType.Equal);
String fe33 = "HREmployeeEvaluationResult.EmployeeResult is not null";
String fe_employeenew = SqlExpressionBuilder.PrepareFilterExpression("MDEvaluationCriteria.SupervisorWillAnswer", "0".ToString(), SQLMatchType.Equal);
String fefe = SqlExpressionBuilder.PrepareFilterExpression(fe11, SQLJoinType.AND, fe22);
String fe4 = SqlExpressionBuilder.PrepareFilterExpression(fe_employeenew, SQLJoinType.AND, fe33);
fefe = SqlExpressionBuilder.PrepareFilterExpression(fefe, SQLJoinType.AND, fe4);
fe = fe_employeenew;
IList <HREmployeeEvaluationSession_CustomEntity> lst = FCCHREmployeeEvaluationSession_Custom.GetFacadeCreate().GetIL(10000, 1, String.Empty, fefe);
if (lst != null && lst.Count > 0)
{
if (lst[0].SessionCategoryID == MasterDataConstants.MDEvaluationSessionCategory.QUARTERLY_EVALUATIONS)
{
if (lst != null && lst.Count == 6)
{
btnSubmit.Visible = true;
}
if (lblFormLock.Visible == true)
{
btnSubmit.Visible = false;
}
}
else if (lst[0].SessionCategoryID == MasterDataConstants.MDEvaluationSessionCategory.HEALTH_CHECKUP)
{
if (lst != null && lst.Count == 32)
{
btnSubmit.Visible = true;
}
if (lblFormLock.Visible == true)
{
btnSubmit.Visible = false;
}
}
else if (lst[0].SessionCategoryID == MasterDataConstants.MDEvaluationSessionCategory.PBR)
{
if (lst != null && lst.Count == 5)
{
btnSubmit.Visible = true;
}
if (lblFormLock.Visible == true)
{
btnSubmit.Visible = false;
}
}
}
}
if (Action == "Supervisor")
{
String fe11 = SqlExpressionBuilder.PrepareFilterExpression("HREmployeeEvaluation.SupervisorEmployeeID", _SupervisorEmployeeID.ToString(), SQLMatchType.Equal);
String fe22 = SqlExpressionBuilder.PrepareFilterExpression("HRSession.SessionID", _CurrentSessionID.ToString(), SQLMatchType.Equal);
String fe_employee = SqlExpressionBuilder.PrepareFilterExpression("HREmployeeEvaluation.EmployeeID", _CurrentEmployeeEvaluatedID.ToString(), SQLMatchType.Equal);
String fe33 = "HREmployeeEvaluationResult.Result is not null";
String fefe = SqlExpressionBuilder.PrepareFilterExpression(fe11, SQLJoinType.AND, fe22);
String fe4 = SqlExpressionBuilder.PrepareFilterExpression(fe33, SQLJoinType.AND, fe_employee);
fefe = SqlExpressionBuilder.PrepareFilterExpression(fefe, SQLJoinType.AND, fe4);
IList <HREmployeeEvaluationSession_CustomEntity> lst = FCCHREmployeeEvaluationSession_Custom.GetFacadeCreate().GetIL(10000, 1, String.Empty, fefe);
if (lst != null && lst.Count > 0)
{
if (lst[0].SessionCategoryID == MasterDataConstants.MDEvaluationSessionCategory.QUARTERLY_EVALUATIONS)
{
if (lst.Count == 6)
{
btnSubmit.Visible = true;
}
if (lblFormLock.Visible == true)
{
btnSubmit.Visible = false;
}
}
else if (lst[0].SessionCategoryID == MasterDataConstants.MDEvaluationSessionCategory.HEALTH_CHECKUP)
{
if (lst != null && lst.Count < 32)
{
btnSubmit.Visible = true;
}
if (lblFormLock.Visible == true)
{
btnSubmit.Visible = false;
}
}
else if (lst[0].SessionCategoryID == MasterDataConstants.MDEvaluationSessionCategory.PBR)
{
if (lst != null && lst.Count == 5)
{
btnSubmit.Visible = true;
}
if (lblFormLock.Visible == true)
{
btnSubmit.Visible = false;
}
}
}
}
#endregion
fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);
if (Action == "Employee")
{
String fe_employeenew = SqlExpressionBuilder.PrepareFilterExpression("MDEvaluationCriteria.SupervisorWillAnswer", "0".ToString(), SQLMatchType.Equal);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe_employeenew);
}
e.InputParameters["filterExpression"] = fe;
}
