public async Task <IHttpActionResult> isDuplicateNameCreate(DAL.Evaluation model)
{
Boolean result = false;
var nowEvaluation = _db.Evaluations.Where(p => p.evaluationName == model.evaluationName).FirstOrDefault();
if (nowEvaluation == null)
{
result = true;
}
return(Json(new { result = result }));
}
public async Task <IHttpActionResult> search(DAL.Evaluation model)
{
System.Web.HttpContext.Current.Application.Lock();
var evaluation = from m in _db.Evaluations
select
new
{
id = m.id,
evaluationName = m.evaluationName,
description = m.description
};
if (model.evaluationName != null)
{
evaluation = from m in evaluation where m.evaluationName.Contains(model.evaluationName) select m;
}
evaluation = from m in evaluation orderby m.evaluationName select m;
System.Web.HttpContext.Current.Application.UnLock();
return(Json(evaluation));
}
protected void GenerateReport()
{
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Employee/Report2.rdlc");
//Get selected evaluation id
int evaluationId = Convert.ToInt32(Session["EvaluationId"]);
DataSet dsEvaluation = TSI_PerformanceEval(evaluationId);
//get selected user
Guid UserId = Guid.Parse(hfUserId.Value);
//get user details
dt = new DataTable();
DataTable dtEvaluation = new DataTable();
DAL.Evaluation eval = new DAL.Evaluation();
dt = emp.GetProfileById(UserId);
dtEvaluation = eval.GetEvaluated(evaluationId);
//params
ReportParameter[] param = new ReportParameter[21];
//fill params
param[0] = new ReportParameter("lblName", emp.GetFullName(UserId));
param[1] = new ReportParameter("lblDateHired", emp.GetHiredDate(UserId));
param[2] = new ReportParameter("lblPosition", emp.GetPosition(UserId));
param[3] = new ReportParameter("lblRemarksName", dtEvaluation.Rows[0]["RemarksName"].ToString());
param[4] = new ReportParameter("lblUnacceptable", dtEvaluation.Rows[0]["ImpUnacceptable"].ToString());
param[5] = new ReportParameter("lblFallShort", dtEvaluation.Rows[0]["ImpFallShort"].ToString());
param[6] = new ReportParameter("lblEffective", dtEvaluation.Rows[0]["ImpEffective"].ToString());
param[7] = new ReportParameter("lblExceptional", dtEvaluation.Rows[0]["ImpExceptional"].ToString());
param[8] = new ReportParameter("lblRecommendation", dtEvaluation.Rows[0]["Recommendation"].ToString());
param[9] = new ReportParameter("lblNeedImrpo", dtEvaluation.Rows[0]["NeedImprovement"].ToString());
param[10] = new ReportParameter("lblDateEvaluated", dtEvaluation.Rows[0]["DateEvaluated"].ToString());
param[11] = new ReportParameter("TotalScore", dtEvaluation.Rows[0]["TotalScore"].ToString());
param[12] = new ReportParameter("lblHighlyEffective", dtEvaluation.Rows[0]["ImpHighlyEffective"].ToString());
param[13] = new ReportParameter("lblEvaluatedBy", emp.GetFullName(Guid.Parse(dtEvaluation.Rows[0]["EvaluatedById"].ToString())));
if (Guid.Parse(dtEvaluation.Rows[0]["ApprovedByManagerId"].ToString()).Equals(Guid.Empty))
{
param[14] = new ReportParameter("lblApprovedByManager", "");
}
else
{
param[14] = new ReportParameter("lblApprovedByManager", emp.GetFullName(Guid.Parse(dtEvaluation.Rows[0]["ApprovedByManagerId"].ToString())));
}
if (Guid.Parse(dtEvaluation.Rows[0]["ApprovedByHRId"].ToString()).Equals(Guid.Empty))
{
param[16] = new ReportParameter("lblApprovedByHR", "");
}
else
{
param[16] = new ReportParameter("lblApprovedByHR", emp.GetFullName(Guid.Parse(dtEvaluation.Rows[0]["ApprovedByHRId"].ToString())));
}
param[15] = new ReportParameter("lblAcknowledgedBy", emp.GetFullName(Guid.Parse(hfUserId.Value)));
param[17] = new ReportParameter("lblDepartment", emp.GetDepartment(Guid.Parse(hfUserId.Value)));
param[18] = new ReportParameter("lblEvaluationDate", dtEvaluation.Rows[0]["DateEvaluated"].ToString());
param[19] = new ReportParameter("lblLastEvaluationDate", emp.GetLastEvaluationDate(UserId));
param[20] = new ReportParameter("lblNextEvaluationDate", dtEvaluation.Rows[0]["NextEvaluationDate"].ToString());
ReportViewer1.LocalReport.SetParameters(param);
ReportViewer1.LocalReport.DataSources.Clear();
ReportDataSource datasource = new ReportDataSource("TSI_Performance_Evaluation", dsEvaluation.Tables[0]);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(datasource);
ReportViewer1.LocalReport.DisplayName = "TOPLIS_Performance_Evaluation";
ReportViewer1.LocalReport.Refresh();
}
