public IEnumerable <EmployeePerformance> EmployeePerformances(int period, int id)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "[dbo].[spEmployeePerformance]";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@SeasonId", period);
cmd.Parameters.AddWithValue("@EmployeeId", id);
DataTable dt = SCObjects.ExecGetData(cmd, UserConnectionString);
List <EmployeePerformance> items = new List <EmployeePerformance>();
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
var item = new EmployeePerformance
{
Id = int.Parse(dr["Id"].ToString()),
Name = dr["EmployeeName"].ToString(),
Period = dr["Period"].ToString(),
TotalScore = decimal.Parse(dr["TotalScore"].ToString()),
TotalWeight = decimal.Parse(dr["TotalWeight"].ToString()),
ConvertedScore = decimal.Parse(dr["ConvertedScore"].ToString()),
WeightedScore = decimal.Parse(dr["WeightedScore"].ToString()),
Percentage = decimal.Parse(dr["Percentage"].ToString()),
};
items.Add(item);
}
}
return(items);
}
public IActionResult Upsert([FromBody] EmployeePerformance performance)
{
JsonResult result = new JsonResult(new { });
if (performance.PerformanceId == 0)
{
_unitOfWork.Performance.Add(performance);
}
else
{
_unitOfWork.Performance.Update(performance);
}
_unitOfWork.Save();
result.Value = new { Data = true };
return(result);
}
public IActionResult Upsert(int?id = 0)
{
EmployeePerformance performance = new EmployeePerformance();
JsonResult result = new JsonResult(new { });
if (id == 0)
{
result.Value = new { Data = true, message = "Its Insert Call" };
return(result);
}
performance = _unitOfWork.Performance.Get(id);
if (performance == null)
{
result.Value = new { Data = "Not Found" };
return(result);
}
result.Value = new { Data = performance, message = "Its Update Call" };
return(result);
}
public bool deleteInviteEmployee(int EmployeID)
{
var EmployeeList = _db.EmployeePerformances.Where(x => x.EmployeeId == EmployeID).ToList();
var EmployeePerformnceData = _db.PerformanceEmployeeDetails.Where(x => x.EmployeeId == EmployeID && x.IsArchived == false).FirstOrDefault();
foreach (var item in EmployeeList)
{
EmployeePerformance delete = EmployeeList.Where(x => x.Id == item.Id).FirstOrDefault();
_db.EmployeePerformances.Remove(delete);
_db.SaveChanges();
var deleteJSON = _db.EmployeePerformanceCoreJSONDetails.Where(x => x.PerEmployeedetailId == EmployeePerformnceData.Id).ToList();
var delateJobRole = _db.EmployeePerformanceJobRoleSegmentJSONDetails.Where(x => x.PerEmployeedetailId == EmployeID && x.Archived == false).ToList();
foreach (var JSONitem in deleteJSON)
{
EmployeePerformanceCoreJSONDetail coreJSON = deleteJSON.Where(x => x.Id == JSONitem.Id).FirstOrDefault();
_db.EmployeePerformanceCoreJSONDetails.Remove(coreJSON);
}
foreach (var JSONitem in delateJobRole)
{
EmployeePerformanceJobRoleSegmentJSONDetail jobroleJSON = delateJobRole.Where(x => x.PerEmployeedetailId == EmployeID && x.Archived == false).FirstOrDefault();
}
}
return(true);
}
public bool SaveEmployeePerformace(EmployeePerformanceViewModel model)
{
var checkperfomance = _db.EmployeePerformances.Where(x => x.ReviewId == model.ReviewId && x.Archived == false && x.EmployeeId == model.EmployeeId).ToList();
var checkPerformanceSetting = _db.PerformanceSettings.Where(x => x.Id == model.ReviewId && x.Archived == false).FirstOrDefault();
if (checkPerformanceSetting.CompletionDate == null)
{
model.CompletionDateTime = model.CompletionDateTime.Replace("-", "/");
model.CompletionDate = DateTime.ParseExact(model.CompletionDateTime, "dd/MM/yyyy", System.Globalization.CultureInfo.CurrentUICulture.DateTimeFormat);
checkPerformanceSetting.CompletionDate = model.CompletionDate;
_db.Entry(checkPerformanceSetting).State = System.Data.Entity.EntityState.Modified;
_db.SaveChanges();
}
if (checkperfomance.Count > 0)
{
return(false);
}
else
{
EmployeePerformance EmpPer = new EmployeePerformance();
EmpPer.ProjectId = model.ProjectId;
EmpPer.EmployeeId = model.EmployeeId;
EmpPer.ReviewId = model.ReviewId;
EmpPer.ReviewDate = DateTime.Now;
EmpPer.RevviewByEmpID = SessionProxy.UserId;
EmpPer.ReviewStatus = "Open";
EmpPer.Archived = false;
EmpPer.UserIDCreatedBy = SessionProxy.UserId;
EmpPer.UserIDLastModifiedBy = SessionProxy.UserId;
EmpPer.CreatedDate = DateTime.Now;
EmpPer.LastModifiedDate = DateTime.Now;
_db.EmployeePerformances.Add(EmpPer);
_db.SaveChanges();
return(true);
}
}
