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