public ActionResult GetIndividualMappingDetails(Int64 EmpId, Int64 AppraisalProcessId)
{
MTSHRDataLayer.Appraisal data = new MTSHRDataLayer.Appraisal();
var Mapping_Detail = data.GetIndividualMappingDetails(EmpId, AppraisalProcessId);
return(Json(new { success = true, result1 = JsonConvert.SerializeObject(Mapping_Detail.Tables[0]), result2 = JsonConvert.SerializeObject(Mapping_Detail.Tables[1]) }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetEvaluatorsList()
{
DataSet ds = new DataSet();
MTSHRDataLayer.Appraisal data = new MTSHRDataLayer.Appraisal();
try
{
ds = data.GetEvaluatorsList();
if (ds != null)
{
return(Json(new
{
success = true,
result = JsonConvert.SerializeObject(ds.Tables[0]),
result1 = JsonConvert.SerializeObject(ds.Tables[1])
}, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false }));
}
}
catch (Exception ex)
{
BaseExceptionHandler.HandleException(ref ex);
}
return(Json(new { success = false }));
}
public ActionResult RemoveEmployeeMappingDetails(Int64 status, Int64 weightage, Int64 rowID)
{
//Int64 result = 0;
//MTSHRDataLayer.Appraisal data = new MTSHRDataLayer.Appraisal();
//var Mapping_Detail = data.RemoveEmployeeMappingDetails(EmpId);
//return Json(new { success = true, result1 = JsonConvert.SerializeObject(Mapping_Detail) }, JsonRequestBehavior.AllowGet);
Int64 result = 0;
MTSHRDataLayer.Appraisal data = new MTSHRDataLayer.Appraisal();
try
{
result = data.RemoveEmployeeMappingDetails(status, weightage, rowID);
if (status == 1)
{
result = 1;
}
else if (status == 2)
{
result = 2;
}
else
{
result = 0;
}
}
catch (Exception e)
{
BaseExceptionHandler.HandleException(ref e);
}
return(Json(new { result = result }));
}
public ActionResult Get_Appraisal_Mapping_Table_Details()
{
MTSHRDataLayer.Appraisal data = new MTSHRDataLayer.Appraisal();
var Mapping_Details = data.Get_Appraisal_Mapping_Table_Details();
return(Json(new { success = true, result1 = JsonConvert.SerializeObject(Mapping_Details.Tables[0]), result2 = JsonConvert.SerializeObject(Mapping_Details.Tables[1]) }, JsonRequestBehavior.AllowGet));
}
public ActionResult Get_Appraisal_Count()
{
MTSHRDataLayer.Appraisal data = new MTSHRDataLayer.Appraisal();
DataSet Appraisal_Counts = new DataSet();
Appraisal_Counts = data.Get_Appraisal_Count(Convert.ToInt64(Session["UserID"]));
DataTable dt1 = Appraisal_Counts.Tables[0];
DataTable dt2 = Appraisal_Counts.Tables[1];
DataTable dt3 = Appraisal_Counts.Tables[2];
int Appraisal_Count1 = Convert.ToInt32(string.IsNullOrEmpty(dt1.Compute("SUM(Pending)", string.Empty).ToString()) ? 0 : dt1.Compute("SUM(Pending)", string.Empty));
int Appraisal_Count2 = Convert.ToInt32(string.IsNullOrEmpty(dt2.Compute("SUM(Pending)", string.Empty).ToString()) ? 0 : dt2.Compute("SUM(Pending)", string.Empty));
int Appraisal_Count3 = Convert.ToInt32(string.IsNullOrEmpty(dt3.Compute("SUM(Pending)", string.Empty).ToString()) ? 0 : dt3.Compute("SUM(Pending)", string.Empty));
//int Appraisal_Active_Stage= Convert.ToInt32(string.IsNullOrEmpty(dt3.Compute("APPRAISAL_ACTIVE_STAGE", string.Empty).ToString()) ? 0 : dt3.Compute("APPRAISAL_ACTIVE_STAGE", string.Empty));
Session["SelfAppraisalPendingCount"] = Appraisal_Count3;
return(Json(new
{
success = true,
result = Appraisal_Count1,
result1 = Appraisal_Count2,
result2 = Appraisal_Count3,
result3 = JsonConvert.SerializeObject(Appraisal_Counts.Tables[2])
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetManagersList(Int64 EmpId)
{
// DataTable dt = new DataTable();
MTSHRDataLayer.Appraisal data = new MTSHRDataLayer.Appraisal();
var dt = data.GetManagersList(EmpId);
return(Json(JsonConvert.SerializeObject(dt), JsonRequestBehavior.AllowGet));
}
public ActionResult AddAppraisalProcessDetails(string appraisalPeriod, string fromdate, string todate, string untilDate, string evaluator, string maxRating)
{
Int64 result = 0;
MTSHRDataLayer.Appraisal data = new MTSHRDataLayer.Appraisal();
try
{
result = data.AddAppraisalProcessDetails(appraisalPeriod, fromdate == "" ? (DateTime?)null : Convert.ToDateTime(fromdate), todate == "" ? (DateTime?)null : Convert.ToDateTime(todate), untilDate == "" ? (DateTime?)null : Convert.ToDateTime(untilDate), Convert.ToInt64(evaluator), Convert.ToInt64(maxRating));
}
catch (Exception e)
{
BaseExceptionHandler.HandleException(ref e);
}
return(Json(new { result = result }));
}
public ActionResult RemoveAppraisalEmployeeMapping(Int64 EMP_ID, Int64 AppraisalProcessId)
{
Int64 result = 0;
MTSHRDataLayer.Appraisal data = new MTSHRDataLayer.Appraisal();
try
{
result = data.RemoveAppraisalEmployeeMapping(EMP_ID, AppraisalProcessId);
}
catch (Exception e)
{
BaseExceptionHandler.HandleException(ref e);
}
return(Json(new { result = result }));
}
public ActionResult ClosingAppraisalProcess(Int64 AppraisalProcessId)
{
Int64 result = 0;
MTSHRDataLayer.Appraisal data = new MTSHRDataLayer.Appraisal();
try
{
result = data.ClosingAppraisalProcess(AppraisalProcessId);
if (result > 0)
{
result = 1;
}
else
{
result = 0;
}
}
catch (Exception e)
{
BaseExceptionHandler.HandleException(ref e);
}
return(Json(new { result = result }));
}
public ActionResult AssignManagerToEmployee(Int64 id, Int64 managerId, string AppraisalProcessId)
{
Int64 result = 0;
MTSHRDataLayer.Appraisal data = new MTSHRDataLayer.Appraisal();
try
{
result = data.AssignManagerToEmployee(id, managerId, Convert.ToInt64(AppraisalProcessId));
if (result > 0)
{
result = 1;
}
else
{
result = 0;
}
}
catch (Exception e)
{
BaseExceptionHandler.HandleException(ref e);
}
return(Json(new { result = result }));
}
public ActionResult Add_Appraisal_Designation_Mapping(string type, string description, string weightage, string designation)
{
Int64 result = 0;
Decimal Weightage = 0;
MTSHRDataLayer.Appraisal data = new MTSHRDataLayer.Appraisal();
if (weightage == "")
{
Weightage = 0;
}
else
{
Weightage = Convert.ToDecimal(weightage);
}
try
{
string[] DescriptionList = description.Split(',');
if (DescriptionList != null && DescriptionList.Length > 0)
{
for (int int_i = 0; int_i < DescriptionList.Length; int_i++)
{
result = data.Add_Appraisal_Designation_Mapping(Convert.ToInt64(type), Convert.ToInt64(DescriptionList[int_i]), Weightage, Convert.ToInt64(designation));
}
}
if (result > 0)
{
result = 1;
}
}
catch (Exception e)
{
BaseExceptionHandler.HandleException(ref e);
}
return(Json(new { result = result }));
}
