/// <summary> /// </summary> /// <param name="id"></param> /// <returns></returns> public Tra_AddPointModel GetById(string id) { Tra_AddPointModel result = new Tra_AddPointModel(); List <Guid> SelectedIds = new List <Guid>(); if (!string.IsNullOrEmpty(id)) { SelectedIds = id.Split(',').Select(s => Guid.Parse(s)).ToList(); } if (SelectedIds != null && SelectedIds.Count > 0) { //Guid[] traineeID = null; var message = string.Empty; string status = string.Empty; List <Guid> lstClassID = new List <Guid>(); List <Guid> lstTraineeID = new List <Guid>(); #region load data var traineeServices = new Tra_TraineeServices(); var objTrainee = new List <object>(); objTrainee.AddRange(new object[15]); objTrainee[13] = 1; objTrainee[14] = int.MaxValue - 1; List <Tra_TraineeEntity> lstTrainee = traineeServices.GetData <Tra_TraineeEntity>(objTrainee, ConstantSql.hrm_tra_sp_get_Trainee, UserLogin, ref status); var courseSevices = new Tra_CourseServices(); var objCoures = new List <object>(); objCoures.AddRange(new object[11]); objCoures[9] = 1; objCoures[10] = int.MaxValue - 1; List <Tra_CourseEntity> lstCourse = courseSevices.GetData <Tra_CourseEntity>(objCoures, ConstantSql.hrm_tra_sp_get_Course, UserLogin, ref status); var classServices = new Tra_ClassServices(); var objClass = new List <object>(); objClass.Add(null); objClass.Add(null); objClass.Add(null); objClass.Add(null); objClass.Add(null); objClass.Add(null); objClass.Add(null); objClass.Add(null); objClass.Add(1); objClass.Add(int.MaxValue - 1); List <Tra_ClassEntity> lstClass = classServices.GetData <Tra_ClassEntity>(objClass, ConstantSql.hrm_tra_sp_get_Class, UserLogin, ref status); var traineeTopicServices = new Tra_TraineeTopicServices(); var objTraineeTopic = new List <object>(); objTraineeTopic.Add(1); objTraineeTopic.Add(int.MaxValue - 1); var lstTraineeTopic = traineeTopicServices.GetData <Tra_TraineeTopicEntity>(objTraineeTopic, ConstantSql.hrm_tra_sp_get_TraineeTopic, UserLogin, ref status).ToList(); var scoreTopicServices = new Tra_ScoreTopicServices(); var objScoreTopic = new List <object>(); objScoreTopic.Add(1); objScoreTopic.Add(int.MaxValue - 1); var lstScoreTopic = scoreTopicServices.GetData <Tra_ScoreTopicEntity>(objScoreTopic, ConstantSql.hrm_tra_sp_get_ScoreTopic, UserLogin, ref status).ToList(); var courseTopicServices = new Tra_TraineeTopicServices(); var objCourseTopic = new List <object>(); objCourseTopic.Add(1); objCourseTopic.Add(int.MaxValue - 1); List <Tra_CourseTopicEntity> lstCourseTopic = courseTopicServices.GetData <Tra_CourseTopicEntity>(objCourseTopic, ConstantSql.hrm_tra_sp_get_CourseTopic, UserLogin, ref status); var traineeScoreServices = new Tra_TraineeScoreServices(); var objTraineeScore = new List <object>(); objTraineeScore.Add(1); objTraineeScore.Add(int.MaxValue - 1); var lstTraineeScore = traineeScoreServices.GetData <Tra_TraineeScoreEntity>(objTraineeScore, ConstantSql.hrm_tra_sp_get_TraineeScore, UserLogin, ref status).ToList(); if (SelectedIds != null) { lstTrainee = lstTrainee.Where(s => SelectedIds.Contains(s.ID)).ToList(); lstTraineeID = lstTrainee.Select(s => s.ID).ToList(); lstClassID = lstTrainee.Select(s => s.ClassID).Distinct().ToList(); } if (lstClassID.Count > 1) { DataTable tb = new DataTable(); result.ActionStatus = ConstantMessages.PlsChooseTraineeSameClass.ToString(); result.Ids = id; result.Table = tb; return(result); } DataTable table = new DataTable(); table.Columns.Add(Tra_TraineeScoreEntity.FieldNames.ID); table.Columns.Add(Tra_TraineeScoreEntity.FieldNames.CodeEmp); table.Columns.Add(Tra_TraineeScoreEntity.FieldNames.ProfileName); if (lstClassID.Count == 1) { var isSimple = false; Guid firstClass = lstClassID[0]; var courseEntity = lstClass.Where(s => s.ID == firstClass).Select(s => new { s.CourseID, s.IsComplex }).FirstOrDefault(); if (courseEntity != null) { var lstCourseTopicByCourseID = lstCourseTopic.Where(s => courseEntity.CourseID == s.CourseID).ToList(); if (courseEntity.IsComplex == null || courseEntity.IsComplex == false) { isSimple = true; } if (lstCourseTopicByCourseID.Count == 0) { DataTable tb = new DataTable(); result.ActionStatus = ConstantMessages.CourseNoHaveTopic.ToString(); result.Ids = id; result.Table = tb; return(result); } if (isSimple == false) { foreach (var trainee in lstTrainee) { DataRow dr = table.NewRow(); dr[Tra_TraineeScoreEntity.FieldNames.ID] = trainee.ID != null ? trainee.ID : Guid.Empty; dr[Tra_TraineeScoreEntity.FieldNames.CodeEmp] = trainee.CodeEmp != null ? trainee.CodeEmp : string.Empty; dr[Tra_TraineeScoreEntity.FieldNames.ProfileName] = trainee.ProfileName != null ? trainee.ProfileName : string.Empty; var lstTopicbyCourseID = lstCourseTopic.Where(s => s.CourseID == courseEntity.CourseID).Select(s => new { s.CourseID, s.TopicID, s.IsComplex, s.Code }).ToList(); foreach (var item in lstTopicbyCourseID) { var traineeTopicEnity = lstTraineeTopic.Where(s => s.TraineeID == trainee.ID && item.TopicID == s.TopicID).FirstOrDefault(); var lstTraineeScoreByTraineeTopicID = lstTraineeScore.Where(s => traineeTopicEnity != null && s.TraineeTopicID == traineeTopicEnity.ID).ToList(); var classeEntity = lstClass.Where(s => s.ID == trainee.ClassID).FirstOrDefault(); Double value = 0; if (item.IsComplex == null || item.IsComplex == true) { isSimple = true; if (classeEntity != null) { var courseEntityByCourseID = lstCourse.Where(s => s.ID == classeEntity.CourseID).FirstOrDefault(); if (courseEntityByCourseID != null) { var lstScoreTopicByTopicID = lstScoreTopic.Where(s => item.TopicID == s.TopicID).OrderBy(s => s.DateCreate).ToList(); foreach (var scoreTopic in lstScoreTopicByTopicID) { var traineeScoreEntity = lstTraineeScore.Where(s => traineeTopicEnity != null && s.ScoreTypeID == scoreTopic.ScoreTypeID && traineeTopicEnity.ID == s.TraineeTopicID).FirstOrDefault(); if (!table.Columns.Contains(item.Code + "_" + scoreTopic.Code)) { table.Columns.Add(item.Code + "_" + scoreTopic.Code); } if (table.Columns.Contains(item.Code + "_" + scoreTopic.Code)) { if (traineeScoreEntity != null && traineeScoreEntity.Score != null) { dr[item.Code + "_" + scoreTopic.Code] = traineeScoreEntity != null ? traineeScoreEntity.Score.Value : 0; } else { dr[item.Code + "_" + scoreTopic.Code] = null; } } } } } } else { isSimple = false; break; } } table.Rows.Add(dr); } // var a = table; } } } result.Table = table; return(result); #endregion } return(null); }
/// <summary> /// </summary> /// <param name="id"></param> /// <returns></returns> public Tra_AddPointModel GetById(string id) { Tra_AddPointModel result = new Tra_AddPointModel(); List<Guid> SelectedIds = new List<Guid>(); if (!string.IsNullOrEmpty(id)) { SelectedIds = id.Split(',').Select(s => Guid.Parse(s)).ToList(); } if (SelectedIds != null && SelectedIds.Count > 0) { //Guid[] traineeID = null; var message = string.Empty; string status = string.Empty; List<Guid> lstClassID = new List<Guid>(); List<Guid> lstTraineeID = new List<Guid>(); #region load data var traineeServices = new Tra_TraineeServices(); var objTrainee = new List<object>(); objTrainee.AddRange(new object[15]); objTrainee[13] = 1; objTrainee[14] = int.MaxValue - 1; List<Tra_TraineeEntity> lstTrainee = traineeServices.GetData<Tra_TraineeEntity>(objTrainee, ConstantSql.hrm_tra_sp_get_Trainee, UserLogin, ref status); var courseSevices = new Tra_CourseServices(); var objCoures = new List<object>(); objCoures.AddRange(new object[11]); objCoures[9] = 1; objCoures[10] = int.MaxValue - 1; List<Tra_CourseEntity> lstCourse = courseSevices.GetData<Tra_CourseEntity>(objCoures, ConstantSql.hrm_tra_sp_get_Course, UserLogin, ref status); var classServices = new Tra_ClassServices(); var objClass = new List<object>(); objClass.Add(null); objClass.Add(null); objClass.Add(null); objClass.Add(null); objClass.Add(null); objClass.Add(null); objClass.Add(null); objClass.Add(null); objClass.Add(1); objClass.Add(int.MaxValue - 1); List<Tra_ClassEntity> lstClass = classServices.GetData<Tra_ClassEntity>(objClass, ConstantSql.hrm_tra_sp_get_Class, UserLogin, ref status); var traineeTopicServices = new Tra_TraineeTopicServices(); var objTraineeTopic = new List<object>(); objTraineeTopic.Add(1); objTraineeTopic.Add(int.MaxValue -1); var lstTraineeTopic = traineeTopicServices.GetData<Tra_TraineeTopicEntity>(objTraineeTopic, ConstantSql.hrm_tra_sp_get_TraineeTopic, UserLogin, ref status).ToList(); var scoreTopicServices = new Tra_ScoreTopicServices(); var objScoreTopic = new List<object>(); objScoreTopic.Add(1); objScoreTopic.Add(int.MaxValue - 1); var lstScoreTopic = scoreTopicServices.GetData<Tra_ScoreTopicEntity>(objScoreTopic, ConstantSql.hrm_tra_sp_get_ScoreTopic, UserLogin, ref status).ToList(); var courseTopicServices = new Tra_TraineeTopicServices(); var objCourseTopic = new List<object>(); objCourseTopic.Add(1); objCourseTopic.Add(int.MaxValue - 1); List<Tra_CourseTopicEntity> lstCourseTopic = courseTopicServices.GetData<Tra_CourseTopicEntity>(objCourseTopic, ConstantSql.hrm_tra_sp_get_CourseTopic, UserLogin, ref status); var traineeScoreServices = new Tra_TraineeScoreServices(); var objTraineeScore = new List<object>(); objTraineeScore.Add(1); objTraineeScore.Add(int.MaxValue - 1); var lstTraineeScore = traineeScoreServices.GetData<Tra_TraineeScoreEntity>(objTraineeScore, ConstantSql.hrm_tra_sp_get_TraineeScore, UserLogin, ref status).ToList(); if (SelectedIds != null) { lstTrainee = lstTrainee.Where(s => SelectedIds.Contains(s.ID)).ToList(); lstTraineeID = lstTrainee.Select(s => s.ID).ToList(); lstClassID = lstTrainee.Select(s => s.ClassID).Distinct().ToList(); } if (lstClassID.Count > 1) { DataTable tb = new DataTable(); result.ActionStatus = ConstantMessages.PlsChooseTraineeSameClass.ToString(); result.Ids = id; result.Table = tb; return result; } DataTable table = new DataTable(); table.Columns.Add(Tra_TraineeScoreEntity.FieldNames.ID); table.Columns.Add(Tra_TraineeScoreEntity.FieldNames.CodeEmp); table.Columns.Add(Tra_TraineeScoreEntity.FieldNames.ProfileName); if (lstClassID.Count == 1) { var isSimple = false; Guid firstClass = lstClassID[0]; var courseEntity = lstClass.Where(s => s.ID == firstClass).Select(s => new { s.CourseID, s.IsComplex }).FirstOrDefault(); if (courseEntity != null) { var lstCourseTopicByCourseID = lstCourseTopic.Where(s => courseEntity.CourseID == s.CourseID).ToList(); if (courseEntity.IsComplex == null || courseEntity.IsComplex == false) { isSimple = true; } if (lstCourseTopicByCourseID.Count == 0) { DataTable tb = new DataTable(); result.ActionStatus = ConstantMessages.CourseNoHaveTopic.ToString(); result.Ids = id; result.Table = tb; return result; } if (isSimple == false) { foreach (var trainee in lstTrainee) { DataRow dr = table.NewRow(); dr[Tra_TraineeScoreEntity.FieldNames.ID] = trainee.ID != null ? trainee.ID : Guid.Empty; dr[Tra_TraineeScoreEntity.FieldNames.CodeEmp] = trainee.CodeEmp != null ? trainee.CodeEmp : string.Empty; dr[Tra_TraineeScoreEntity.FieldNames.ProfileName] = trainee.ProfileName != null ? trainee.ProfileName : string.Empty; var lstTopicbyCourseID = lstCourseTopic.Where(s => s.CourseID == courseEntity.CourseID).Select(s => new { s.CourseID, s.TopicID, s.IsComplex, s.Code }).ToList(); foreach (var item in lstTopicbyCourseID) { var traineeTopicEnity = lstTraineeTopic.Where(s => s.TraineeID == trainee.ID && item.TopicID == s.TopicID).FirstOrDefault(); var lstTraineeScoreByTraineeTopicID = lstTraineeScore.Where(s => traineeTopicEnity != null && s.TraineeTopicID == traineeTopicEnity.ID).ToList(); var classeEntity = lstClass.Where(s => s.ID == trainee.ClassID).FirstOrDefault(); Double value = 0; if (item.IsComplex == null || item.IsComplex == true) { isSimple = true; if (classeEntity != null) { var courseEntityByCourseID = lstCourse.Where(s => s.ID == classeEntity.CourseID).FirstOrDefault(); if (courseEntityByCourseID != null) { var lstScoreTopicByTopicID = lstScoreTopic.Where(s => item.TopicID == s.TopicID).OrderBy(s => s.DateCreate).ToList(); foreach (var scoreTopic in lstScoreTopicByTopicID) { var traineeScoreEntity = lstTraineeScore.Where(s => traineeTopicEnity != null && s.ScoreTypeID == scoreTopic.ScoreTypeID && traineeTopicEnity.ID == s.TraineeTopicID).FirstOrDefault(); if (!table.Columns.Contains(item.Code + "_" + scoreTopic.Code)) { table.Columns.Add(item.Code + "_" + scoreTopic.Code); } if (table.Columns.Contains(item.Code + "_" + scoreTopic.Code)) { if (traineeScoreEntity != null && traineeScoreEntity.Score != null) { dr[item.Code + "_" + scoreTopic.Code] = traineeScoreEntity != null ? traineeScoreEntity.Score.Value : 0; } else { dr[item.Code + "_" + scoreTopic.Code] = null; } } } } } } else { isSimple = false; break; } } table.Rows.Add(dr); } // var a = table; } } } result.Table = table; return result; #endregion } return null; }
public DataTable GetReportTraineeResult(List<Tra_TraineeEntity> lstTrainee, bool IsCreateTemplate, string _ScoreTypeID, string UserLogin) { using (var context = new VnrHrmDataContext()) { string status = string.Empty; var ScoreTypeServices = new Tra_ScoreTypeServices(); Tra_ScoreTypeEntity objScoreTypeentity = new Tra_ScoreTypeEntity(); if (_ScoreTypeID != null) { _ScoreTypeID = Common.DotNetToOracle(_ScoreTypeID); objScoreTypeentity = ScoreTypeServices.GetData<Tra_ScoreTypeEntity>(_ScoreTypeID, ConstantSql.hrm_tra_sp_get_ScoreTypeByIds, UserLogin, ref status).FirstOrDefault(); } var unitOfWork = (IUnitOfWork)(new UnitOfWork(context)); DataTable table = CreateReportTraineeResult(); if (IsCreateTemplate) { return table; } if (lstTrainee == null) { return table; } List<Guid> lstTraineeIDs = lstTrainee.Select(s => s.ID).ToList(); var traineeTopicServices = new Tra_TraineeTopicServices(); var objTraineeTopic = new List<object>(); objTraineeTopic.Add(1); objTraineeTopic.Add(int.MaxValue - 1); var lstTraineeTopic = traineeTopicServices.GetData<Tra_TraineeTopicEntity>(objTraineeTopic, ConstantSql.hrm_tra_sp_get_TraineeTopic, UserLogin, ref status).ToList(); List<Guid> lstTraineeTopicIDs = null; List<Guid> lstTopicIDs = null; if (lstTraineeTopic.Count > 0) { lstTraineeTopic = lstTraineeTopic.Where(s => s.TraineeID != null && lstTraineeIDs.Contains(s.TraineeID.Value)).ToList(); if (lstTraineeTopic.Count > 0) { lstTraineeTopicIDs = lstTraineeTopic.Select(s => s.ID).ToList(); lstTopicIDs = lstTraineeTopic.Select(s => s.TopicID.Value).Distinct().ToList(); } } var scoreTopicServices = new Tra_ScoreTopicServices(); var objScoreTopic = new List<object>(); objScoreTopic.Add(1); objScoreTopic.Add(int.MaxValue - 1); var lstScoreTopic = scoreTopicServices.GetData<Tra_ScoreTopicEntity>(objScoreTopic, ConstantSql.hrm_tra_sp_get_ScoreTopic, UserLogin, ref status).ToList(); if (lstScoreTopic.Count > 0 && lstTopicIDs != null) { lstScoreTopic = lstScoreTopic.Where(s => s.TopicID != null && lstTopicIDs.Contains(s.TopicID.Value)).ToList(); } var traineeScoreServices = new Tra_TraineeScoreServices(); var objTraineeScore = new List<object>(); objTraineeScore.Add(1); objTraineeScore.Add(int.MaxValue - 1); var lstTraineeScore = traineeScoreServices.GetData<Tra_TraineeScoreEntity>(objTraineeScore, ConstantSql.hrm_tra_sp_get_TraineeScore, UserLogin, ref status).ToList(); if (lstTraineeScore.Count > 0 && lstTraineeTopicIDs != null) { lstTraineeScore = lstTraineeScore.Where(s => s.TraineeTopicID != null && lstTraineeTopicIDs.Contains(s.TraineeTopicID.Value)).ToList(); } //var traineeScoreTypeServices = new Tra_ScoreTypeServices(); //var objTraineeScoreType = new List<object>(); //objTraineeScoreType.AddRange(new object[4]); //objTraineeScoreType[2] = 1; //objTraineeScoreType[3] = int.MaxValue - 1; //var lstTraineeScoreType = traineeScoreTypeServices.GetData<Tra_ScoreTypeEntity>(objTraineeScoreType, ConstantSql.hrm_tra_sp_get_ScoreType, ref status).ToList(); foreach (var item in lstTrainee) { DataRow row = table.NewRow(); var flag = false; //diem if (lstTraineeTopic.Count > 0) { var objTraineeTopicByTrainId = lstTraineeTopic.Where(s => s.TraineeID == item.ID).ToList(); foreach (var traineeTopic in objTraineeTopicByTrainId) { var lstScoreTopicByTopicID = lstScoreTopic.Where(s => s.TopicID == traineeTopic.TopicID).Select(s => s.ScoreTypeID).ToList(); var lstTraineeScoreByTypeID = lstTraineeScore.Where(s => s.ScoreTypeID != null && lstScoreTopicByTopicID.Contains(s.ScoreTypeID) && s.Score != null && s.TraineeTopicID.Value == traineeTopic.ID).ToList(); if (lstTraineeScoreByTypeID.Count > 0) { var lstTraineeScoreByScore = lstTraineeScoreByTypeID.Where(s => s.Score != null).ToList(); if (lstTraineeScoreByScore.Count > 0) { if (objScoreTypeentity != null && objScoreTypeentity.NumOrder != null && lstTraineeScoreByTypeID.Count > 0) { var objTraineeScoreByNumOder = lstTraineeScoreByTypeID.Where(s => s.NumOrder.Value == objScoreTypeentity.NumOrder.Value + 1).FirstOrDefault(); if (objTraineeScoreByNumOder != null) break; } flag = true; if (item.CodeEmp != null) row[Tra_ReportTraineeResultEntity.FieldNames.CodeEmp] = item.CodeEmp; if (item.ProfileName != null) row[Tra_ReportTraineeResultEntity.FieldNames.ProfileName] = item.ProfileName; if (item.E_DEPARTMENT != null) row[Tra_ReportTraineeResultEntity.FieldNames.E_DEPARTMENT] = item.E_DEPARTMENT; if (item.E_DIVISION != null) row[Tra_ReportTraineeResultEntity.FieldNames.E_DIVISION] = item.E_DIVISION; if (item.E_SECTION != null) row[Tra_ReportTraineeResultEntity.FieldNames.E_SECTION] = item.E_SECTION; if (item.E_TEAM != null) row[Tra_ReportTraineeResultEntity.FieldNames.E_TEAM] = item.E_TEAM; if (item.E_UNIT != null) row[Tra_ReportTraineeResultEntity.FieldNames.E_UNIT] = item.E_UNIT; if (item.CourseCode != null) row[Tra_ReportTraineeResultEntity.FieldNames.CourseCode] = item.CourseCode; if (item.CourseName != null) row[Tra_ReportTraineeResultEntity.FieldNames.CourseName] = item.CourseName; if (item.ClassCode != null) row[Tra_ReportTraineeResultEntity.FieldNames.ClassCode] = item.ClassCode; if (item.ClassName != null) row[Tra_ReportTraineeResultEntity.FieldNames.ClassName] = item.ClassName; if (item.StartDate != null) row[Tra_ReportTraineeResultEntity.FieldNames.StartDate] = item.StartDate; if (item.StatusView != null) row[Tra_ReportTraineeResultEntity.FieldNames.StatusView] = item.StatusView; if (item.EndDate != null) row[Tra_ReportTraineeResultEntity.FieldNames.EndDate] = item.EndDate; if (item.Result != null) row[Tra_ReportTraineeResultEntity.FieldNames.Result] = item.Result; if (item.TrainLevelName != null) row[Tra_ReportTraineeResultEntity.FieldNames.TrainLevelName] = item.TrainLevelName; } foreach (var traineeScore in lstTraineeScoreByTypeID) { if (traineeScore.Score != null) { if (traineeScore.NumOrder == 1) { row[Tra_ReportTraineeResultEntity.FieldNames.Score1] = traineeScore.Score; } if (traineeScore.NumOrder == 2) { row[Tra_ReportTraineeResultEntity.FieldNames.Score2] = traineeScore.Score; } if (traineeScore.NumOrder == 3) { row[Tra_ReportTraineeResultEntity.FieldNames.Score3] = traineeScore.Score; } } } } } } if (flag) { table.Rows.Add(row); } } return table.ConfigTable(true); } }
public ActionResult AddScoreTypeToTopic(Guid ScoreTypeID, Guid TopicID) { var model = new Tra_ScoreTopicModel(); if (ScoreTypeID != Guid.Empty && TopicID != Guid.Empty) { model.ScoreTypeID = ScoreTypeID; model.TopicID = TopicID; } #region Validate string message = string.Empty; var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Tra_ScoreTopicModel>(model, "Tra_ScoreTopic", ref message); if (!checkValidate) { model.ActionStatus = ConstantMessages.ScoreTypeIsExistedInTopic.ToString(); return Json(model.ActionStatus, JsonRequestBehavior.AllowGet); } #endregion var courseTopicServices = new Tra_ScoreTopicServices(); var entity = new Tra_ScoreTopicEntity(); if (model != null) { entity = model.CopyData<Tra_ScoreTopicEntity>(); message = courseTopicServices.Add(entity); return Json(message, JsonRequestBehavior.AllowGet); } return null; }