public Eva_EvaluatorEntity DeleteListEvaluator(string ID) { var result = new Eva_EvaluatorEntity(); using (var context = new VnrHrmDataContext()) { var status = string.Empty; var unitOfWork = (IUnitOfWork)(new UnitOfWork(context)); var repo = new Eva_EvaluatorRepository(unitOfWork); List <Guid> listID = new List <Guid>(); var list = ID.Split(','); foreach (var x in list) { try { var a = Guid.Parse(x).TryGetValue <Guid>(); if (a != Guid.Empty) { listID.Add(a); } } catch { } } foreach (var mainID in listID) { var Eva_Evaluator = repo.GetById(mainID); var ilEva_Evaluator = repo.FindBy(x => x.ProfileID == Eva_Evaluator.ProfileID && x.PerformanceTypeID == Eva_Evaluator.PerformanceTypeID && x.IsDelete == null).ToList(); if (ilEva_Evaluator == null || ilEva_Evaluator.Count == 0) { continue; } if (CheckEvaluatorHasUse(ilEva_Evaluator.Select(x => x.ProfileID ?? Guid.Empty).ToList(), Eva_Evaluator.PerformanceTypeID ?? Guid.Empty) == true) { continue; } else { foreach (var item in ilEva_Evaluator) { item.IsDelete = true; } repo.SaveChanges(); result = ilEva_Evaluator.FirstOrDefault().CopyData <Eva_EvaluatorEntity>(); } } } return(result); }
// kiểm tra người đánh giá đã đánh giá public bool CheckEvaluatorHasUse(List <Guid> list, Guid PerformanceTypeID) { using (var context = new VnrHrmDataContext()) { var status = string.Empty; var unitOfWork = (IUnitOfWork)(new UnitOfWork(context)); var repo = new Eva_EvaluatorRepository(unitOfWork); var repoPE = new Eva_PerformanceEvaRepository(unitOfWork); var ilPerformanceEva = repoPE.FindBy(x => list.Contains(x.Eva_Performance.ProfileID ?? Guid.Empty) && x.IsDelete == null && x.Eva_Performance.Eva_PerformanceTemplate.PerformanceTypeID == PerformanceTypeID).ToList(); if (ilPerformanceEva != null && ilPerformanceEva.Count != 0) { return(true); } } return(false); }
public Eva_EvaluatorEntity AddEvaluator360s(Eva_EvaluatorEntity model) { var result = new Eva_EvaluatorEntity(); using (var context = new VnrHrmDataContext()) { var status = string.Empty; var unitOfWork = (IUnitOfWork)(new UnitOfWork(context)); var repo = new Eva_EvaluatorRepository(unitOfWork); //lay ds evaluator theo profileId var profileId = Common.DotNetToOracle(string.Empty.ToString()); if (model != null && model.ProfileID != null) { profileId = Common.DotNetToOracle(model.ProfileID.ToString()); } //var lstEvaluatorentities = GetData<Eva_EvaluatorEntity>(profileId, ConstantSql.hrm_eva_sp_get_EvaluatorByProfileId, ref status); if (model != null && model.ID == Guid.Empty) { var lstEvaluators = model.EvaluatorIDs == null ? new List <Guid>() : model.EvaluatorIDs; foreach (var evaluator in lstEvaluators) { result = model.CopyData <Eva_EvaluatorEntity>(); result.EvaluatorID = evaluator; result.Rate = 1; result.OrderNo = 0; Add(result); } } else { var evaluator = unitOfWork.CreateQueryable <Eva_Evaluator>(Guid.Empty, m => m.ID == model.ID).FirstOrDefault(); if (evaluator != null) { result = evaluator.CopyData <Eva_EvaluatorEntity>(); result.Rate = model.Rate; Edit(result); } } }//end context return(result); }
public Eva_EvaluatorEntity AddEvaluator360s(Eva_EvaluatorEntity model) { var result = new Eva_EvaluatorEntity(); using (var context = new VnrHrmDataContext()) { var status = string.Empty; var unitOfWork = (IUnitOfWork)(new UnitOfWork(context)); var repo = new Eva_EvaluatorRepository(unitOfWork); //lay ds evaluator theo profileId var profileId = Common.DotNetToOracle(string.Empty.ToString()); if (model != null && model.ProfileID != null) { profileId = Common.DotNetToOracle(model.ProfileID.ToString()); } //var lstEvaluatorentities = GetData<Eva_EvaluatorEntity>(profileId, ConstantSql.hrm_eva_sp_get_EvaluatorByProfileId, ref status); if (model != null && model.ID == Guid.Empty) { var lstEvaluators = model.EvaluatorIDs == null ? new List<Guid>() : model.EvaluatorIDs; foreach (var evaluator in lstEvaluators) { result = model.CopyData<Eva_EvaluatorEntity>(); result.EvaluatorID = evaluator; result.Rate = 1; result.OrderNo = 0; Add(result); } } else { var evaluator = unitOfWork.CreateQueryable<Eva_Evaluator>(Guid.Empty, m => m.ID == model.ID).FirstOrDefault(); if (evaluator != null) { result = evaluator.CopyData<Eva_EvaluatorEntity>(); result.Rate = model.Rate; Edit(result); } } }//end context return result; }
// kiểm tra người đánh giá đã đánh giá public bool CheckEvaluatorHasUse(List<Guid> list, Guid PerformanceTypeID) { using (var context = new VnrHrmDataContext()) { var status = string.Empty; var unitOfWork = (IUnitOfWork)(new UnitOfWork(context)); var repo = new Eva_EvaluatorRepository(unitOfWork); var repoPE = new Eva_PerformanceEvaRepository(unitOfWork); var ilPerformanceEva = repoPE.FindBy(x => list.Contains(x.Eva_Performance.ProfileID ?? Guid.Empty) && x.IsDelete == null && x.Eva_Performance.Eva_PerformanceTemplate.PerformanceTypeID == PerformanceTypeID).ToList(); if (ilPerformanceEva != null && ilPerformanceEva.Count != 0) return true; } return false; }
public Eva_EvaluatorEntity DeleteListEvaluator(string ID) { var result = new Eva_EvaluatorEntity(); using (var context = new VnrHrmDataContext()) { var status = string.Empty; var unitOfWork = (IUnitOfWork)(new UnitOfWork(context)); var repo = new Eva_EvaluatorRepository(unitOfWork); List<Guid> listID = new List<Guid>(); var list = ID.Split(','); foreach (var x in list) { try { var a = Guid.Parse(x).TryGetValue<Guid>(); if (a != Guid.Empty) listID.Add(a); } catch { } } foreach (var mainID in listID) { var Eva_Evaluator = repo.GetById(mainID); var ilEva_Evaluator = repo.FindBy(x => x.ProfileID == Eva_Evaluator.ProfileID && x.PerformanceTypeID == Eva_Evaluator.PerformanceTypeID && x.IsDelete == null).ToList(); if (ilEva_Evaluator == null || ilEva_Evaluator.Count == 0) { continue; } if (CheckEvaluatorHasUse(ilEva_Evaluator.Select(x => x.ProfileID ?? Guid.Empty).ToList(), Eva_Evaluator.PerformanceTypeID ?? Guid.Empty) == true) { continue; } else { foreach (var item in ilEva_Evaluator) { item.IsDelete = true; } repo.SaveChanges(); result = ilEva_Evaluator.FirstOrDefault().CopyData<Eva_EvaluatorEntity>(); } } } return result; }
public Eva_PerformanceEntity AddPerfomance360(Eva_PerformanceEntity model, bool isSelft) { /* * Goal(Luu đánh giá nhân viên) * Steps : * Step1 : Insert Eva_Performance * Step2 : Tự động insert xuống table Eva_PerformanceForDetail * Step3 : Tự động insert xuống table Eva_PerformanceEva &Eva_PerformanceEvaDetail * - Tự Đánh Giá : orderNo =0 (Ngoai ra orderNo >0) */ var evaluationStatus = PerformaceEvaStatus.E_WAITING.ToString(); var result = new Eva_PerformanceEntity(); var performanceForDetail = new Eva_PerformanceForDetail(); var performanceEva = new Eva_PerformanceEva(); var performanceEvaDetail = new Eva_PerformanceEvaDetail(); using (var context = new VnrHrmDataContext()) { var unitOfWork = (IUnitOfWork)(new UnitOfWork(context)); var repoPerformance = new Eva_PerformanceRepository(unitOfWork); var repoEvaluator = new Eva_EvaluatorRepository(unitOfWork); var repoPerformanceForDetail = new Eva_PerformanceForDetailRepository(unitOfWork); var repoPerformanceEva = new Eva_PerformanceEvaRepository(unitOfWork); var repoPerformanceEvaDetail = new Eva_PerformanceEvaDetailRepository(unitOfWork); #region step1 : thêm Eva_Performance result = model; if (result != null && result.ID == Guid.Empty) { result.Status = evaluationStatus; } Add(result); #endregion #region Step2 : Tự động insert xuống table Eva_PerformanceForDetail dựa vào các KPI tương ứng //lay ds KPIs (kèm theo Marks và Evaluation) - lay dữ liệu từ edit trên lưới var kpis = model.KPIs;//cac tieu chi danh gia var kpiByTempalateIds = kpis; var lstPerformanceForDetails = new List<Eva_PerformanceForDetail>(); foreach (var kpiByTempalateId in kpiByTempalateIds) { performanceForDetail = new Eva_PerformanceForDetail(); performanceForDetail.ID = Guid.NewGuid(); if (result != null) { performanceForDetail.PerformanceID = result.ID; } performanceForDetail.KPIID = kpiByTempalateId.ID; performanceForDetail.KPIName = kpiByTempalateId.KPIName; performanceForDetail.OrderKPI = kpiByTempalateId.OrderNumber; performanceForDetail.OrderNumber = kpiByTempalateId.OrderNumber; performanceForDetail.Rate = kpiByTempalateId.Rate; lstPerformanceForDetails.Add(performanceForDetail); repoPerformanceForDetail.Add(performanceForDetail);//add vao repo } repoPerformanceForDetail.SaveChanges(); #endregion #region Step3 : Tự động insert xuống table Eva_PerformanceEva &Eva_PerformanceEvaDetail #region Luu bảng Eva_PerformanceEva (cho từng người đánh giá) var lstPerformanceEvaIDs = new List<Guid>(); int orderNo = 1; var performanceEvaSeftId = Guid.Empty;//ID cua bang Eva_PerformanceEva #region Tự đánh giá : tự động add 1 người đánh giá là chính bảng thân người tạo bảng đánh giá if (isSelft && result != null && model != null && model.ProfileID != Guid.Empty) { //tu tao nguoi danh gia la ban than performanceEva = new Eva_PerformanceEva(); performanceEva.ID = Guid.NewGuid(); performanceEvaSeftId = performanceEva.ID; lstPerformanceEvaIDs.Add(performanceEva.ID); performanceEva.PerformanceID = result.ID; performanceEva.EvaluatorID = model.ProfileID; performanceEva.Status = PerformaceEvaStatus.E_SEFT.ToString();//evaluationStatus; performanceEva.OrderEva = 0; repoPerformanceEva.Add(performanceEva); //cap nhat lai status cua Eva_Performance var performanceEntity = repoPerformance.GetById(result.ID); if (performanceEntity != null) { performanceEntity.Status = PerformaceEvaStatus.E_SEFT.ToString(); repoPerformance.SaveChanges(); } } #endregion //Lấy ds người đánh giá theo NV và loại đánh giá var evaluatorIds = model.EvaluatorIDs; var evaluatorObjs = repoEvaluator.FindBy(p => p.IsDelete == null && evaluatorIds.Contains(p.EvaluatorID ?? Guid.Empty) && p.ProfileID == model.ProfileID && p.PerformanceTypeID == model.PerformanceTypeID).ToList(); evaluatorObjs = evaluatorObjs.OrderBy(p => p.OrderNo).ToList(); foreach (var evaluator in evaluatorObjs) { performanceEva = new Eva_PerformanceEva(); performanceEva.ID = Guid.NewGuid(); lstPerformanceEvaIDs.Add(performanceEva.ID); if (result != null) { performanceEva.PerformanceID = result.ID; } performanceEva.EvaluatorID = evaluator.EvaluatorID; performanceEva.Status = evaluationStatus; performanceEva.OrderEva = orderNo++; repoPerformanceEva.Add(performanceEva); } repoPerformanceEva.SaveChanges(); #endregion #region comment Luu Eva_PerformanceEvaDetail (lưu chi tiết cho bảng đánh giá) //var isSeft = false; ////khởi tạo chi tiet đánh giá cho từng người đánh giá //foreach (var performanceEvaID in lstPerformanceEvaIDs) //{ // //ds cac tieu chí // foreach (var performanceForDetailItem in lstPerformanceForDetails) // { // performanceEvaDetail = new Eva_PerformanceEvaDetail // { // ID = Guid.NewGuid(), // PerfomanceEvaID = performanceEvaID, // PerfomanceDetailID = performanceForDetailItem.ID, // KPIName = performanceForDetailItem.KPIName // }; // #region Dành Cho Tự Đánh Giá // if (performanceEvaSeftId != Guid.Empty && performanceEvaSeftId == performanceEvaID) // { // /*Add Mark va Evaluation cho nguoi danh gia la ban than*/ // //lay kpi theo name tu model de set data cho Mark va Evaluation // var kpi = kpiByTempalateIds.FirstOrDefault(p => p.KPIName == performanceEvaDetail.KPIName); // if (kpi != null) // { // performanceEvaDetail.Mark = kpi.Mark; // performanceEvaDetail.Evaluation = kpi.Evaluation; // } // //đặt flag là tự đánh giá // isSeft = true; // } // repoPerformanceEvaDetail.Add(performanceEvaDetail); // #endregion // } // if (isSeft) // { // performanceEvaSeftId = Guid.Empty; // } //} //repoPerformanceEvaDetail.SaveChanges(); #endregion #endregion } return result; }
public string ApproveKPIforPerformance(Guid PerformanceID, List<Eva_KPIEntity> list) { string rs = null; using (var context = new VnrHrmDataContext()) { var status = string.Empty; var unitOfWork = (IUnitOfWork)(new UnitOfWork(context)); var repoPerformance = new Eva_PerformanceRepository(unitOfWork); var repoPerformanceForDetail = new Eva_PerformanceForDetailRepository(unitOfWork); var repoPerformanceEvaDetail = new Eva_PerformanceEvaDetailRepository(unitOfWork); var repoPerformanceEva = new Eva_PerformanceEvaRepository(unitOfWork); var repoEvaluator = new Eva_EvaluatorRepository(unitOfWork); var lstPerformanceForDetail = repoPerformanceForDetail.FindBy(x => x.PerformanceID == PerformanceID).ToList(); var Performance = repoPerformance.GetById(PerformanceID); if (lstPerformanceForDetail == null && lstPerformanceForDetail.Count == 0) return null; foreach (var item in lstPerformanceForDetail) { var obj = list.FirstOrDefault(x => x.PerformanceForDetailID.HasValue && x.PerformanceForDetailID == item.ID); if (obj != null) { item.DescriptionKP = obj.DescriptionKP; } } repoPerformanceForDetail.SaveChanges(); Performance.Status = "Approve"; repoPerformance.SaveChanges(); rs = Performance.Status; } return rs; }
public bool DeletePerformance(Guid performanceId) { using (var context = new VnrHrmDataContext()) { var unitOfWork = (IUnitOfWork)(new UnitOfWork(context)); var repoPerformance = new Eva_PerformanceRepository(unitOfWork); var repoEvaluator = new Eva_EvaluatorRepository(unitOfWork); var repoPerformanceForDetail = new Eva_PerformanceForDetailRepository(unitOfWork); var repoPerformanceEva = new Eva_PerformanceEvaRepository(unitOfWork); var repoPerformanceEvaDetail = new Eva_PerformanceEvaDetailRepository(unitOfWork); // var evaluatorObjs = repoEvaluator.FindBy(p => evaluators.Contains(p.EvaluatorID ?? Guid.Empty) && p.ProfileID == model.ProfileID && p.PerformanceTypeID == model.PerformanceTypeID).ToList(); //get performance var performanceDelete = repoPerformance.FindBy(p => p.ID == performanceId).FirstOrDefault(); if (performanceDelete != null) { performanceDelete.IsDelete = true; repoPerformance.SaveChanges(); #region xoa performanceForDetail var performanceForDetailDelete = repoPerformanceForDetail.FindBy(p => p.PerformanceID == performanceDelete.ID).ToList(); foreach (var performanceForDetail in performanceForDetailDelete) { performanceForDetail.IsDelete = true; } if (performanceForDetailDelete.Any()) { repoPerformanceForDetail.SaveChanges(); } #endregion #region xoa eva_performanceEva var performanceEvaDelete = repoPerformanceEva.FindBy(p => p.PerformanceID == performanceDelete.ID).ToList(); foreach (var evaPerformanceEva in performanceEvaDelete) { evaPerformanceEva.IsDelete = true; } if (performanceEvaDelete.Any()) { repoPerformanceEva.SaveChanges(); } #endregion #region xoa eva_performanceEvaDetail if (performanceEvaDelete.Any()) { foreach (var evaPerformanceEva in performanceEvaDelete) { var performanceEvaDetailDelete = repoPerformanceEvaDetail.FindBy(p => p.PerfomanceEvaID == evaPerformanceEva.ID) .FirstOrDefault(); if (performanceEvaDetailDelete != null) { performanceEvaDetailDelete.IsDelete = true; } } repoPerformanceEvaDetail.SaveChanges(); } #endregion } } return true; }
/// <summary> /// truoc khi vào màn hình chờ đánh giá , sẽ thêm vào bảng eva_performanceEvaDetail nếu bảng này chưa có data ứng với performanceID /// </summary> /// <param name="performanceEvaID"></param> /// <returns></returns> public bool AddPerformanceEvaDetail360(Guid performanceEvaID) { using (var context = new VnrHrmDataContext()) { var unitOfWork = (IUnitOfWork)(new UnitOfWork(context)); var repoPerformance = new Eva_PerformanceRepository(unitOfWork); var repoEvaluator = new Eva_EvaluatorRepository(unitOfWork); var repoPerformanceForDetail = new Eva_PerformanceForDetailRepository(unitOfWork); var repoPerformanceEva = new Eva_PerformanceEvaRepository(unitOfWork); var repoPerformanceEvaDetail = new Eva_PerformanceEvaDetailRepository(unitOfWork); var performanceEvaDetail = new Eva_PerformanceEvaDetail(); #region Lay DS EvaPerformanceEvaDetail //neu co du lieu => khong tao moi var lstPerformanceEvaDetail = unitOfWork.CreateQueryable<Eva_PerformanceEvaDetail>(Guid.Empty, m => m.PerfomanceEvaID == performanceEvaID).ToList(); if (lstPerformanceEvaDetail.Any()) { return false; } #endregion //lay performanceID var performanceEva = unitOfWork.CreateQueryable<Eva_PerformanceEva>(Guid.Empty, m => m.ID == performanceEvaID).FirstOrDefault(); var performanceID = Guid.Empty; if (performanceEva != null && performanceEva.PerformanceID.HasValue) { performanceID = performanceEva.PerformanceID.Value; } else { return false; } #region lay ds eva_performancefordetail theo performanceID var lstPerformanceForDetails = unitOfWork.CreateQueryable<Eva_PerformanceForDetail>(Guid.Empty, m => m.PerformanceID == performanceID).ToList(); #endregion #region comment Luu Eva_PerformanceEvaDetail (lưu chi tiết cho bảng đánh giá) //khởi tạo chi tiet đánh giá cho người đánh giá if (performanceEvaID != Guid.Empty) { //ds cac tieu chí foreach (var performanceForDetailItem in lstPerformanceForDetails) { performanceEvaDetail = new Eva_PerformanceEvaDetail { ID = Guid.NewGuid(), PerfomanceEvaID = performanceEvaID, PerfomanceDetailID = performanceForDetailItem.ID, KPIName = performanceForDetailItem.KPIName }; repoPerformanceEvaDetail.Add(performanceEvaDetail); } } repoPerformanceEvaDetail.SaveChanges(); #endregion } return false; }