public string SaveListTraineeScore(List <Tra_TraineeScoreImport> lstTraineeScore, out List <Tra_TraineeScoreImport> DataReviewOutput)
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoTra_Class = new CustomBaseRepository <Tra_Class>(unitOfWork);
var repoTra_Trainee = new CustomBaseRepository <Tra_Trainee>(unitOfWork);
var repoTra_TraineeTopic = new CustomBaseRepository <Tra_TraineeTopic>(unitOfWork);
var repoTra_TraineeScore = new CustomBaseRepository <Tra_TraineeScore>(unitOfWork);
var repoTra_ScoreType = new CustomBaseRepository <Tra_ScoreType>(unitOfWork);
var traineeScoreServices = new Tra_TraineeScoreServices();
string message = string.Empty;
List <Tra_TraineeScoreEntity> entityNew = new List <Tra_TraineeScoreEntity>();
List <Tra_TraineeScore> entityUpdate = new List <Tra_TraineeScore>();
List <Tra_TraineeScore> resultNew = new List <Tra_TraineeScore>();
List <Tra_TraineeScore> resultUpdate = new List <Tra_TraineeScore>();
DataReviewOutput = new List <Tra_TraineeScoreImport>();
List <string> ClassCode = lstTraineeScore.Select(m => m.ClassCode).Distinct().ToList();
//Lấy DS ClassID
List <Guid> ClassID = repoTra_Class.GetAll().Where(m => m.IsDelete == null && ClassCode.Contains(m.Code)).Select(m => m.ID).ToList <Guid>();
//Lấy DS TraineeID
List <Guid> TraineeID = repoTra_Trainee.GetAll().Where(m => m.IsDelete == null && ClassID.Contains(m.ClassID)).Select(m => m.ID).ToList <Guid>();
//Lấy DS TraineetopicID
List <Guid> lstTraineeTopicID = repoTra_TraineeTopic.GetAll().Where(m => m.IsDelete == null && TraineeID.Contains(m.TraineeID ?? Guid.Empty)).Select(m => m.ID).ToList <Guid>();
//Lấy DS TraineeTopic
var TraineeTopicAll = repoTra_TraineeTopic.GetAll().Where(m => m.IsDelete == null && lstTraineeTopicID.Contains(m.ID))
.Select(m => new { m.ID, TopicCode = m.Cat_Topic.Code, CodeEmp = m.Tra_Trainee.Hre_Profile.CodeEmp, ClassCode = m.Tra_Trainee.Tra_Class.Code });
//Lấy DS TraineeScore
List <Tra_TraineeScore> LstTraineeScoreAll = repoTra_TraineeScore.GetAll().Where(m => m.IsDelete == null && lstTraineeTopicID.Contains(m.TraineeTopicID ?? Guid.Empty)).ToList <Tra_TraineeScore>();
List <string> ScoreTypeCode = lstTraineeScore.Select(m => m.TypeScore).Distinct().ToList <string>();
List <Tra_ScoreType> lstTypeScoreAll = repoTra_ScoreType.GetAll().Where(m => m.IsDelete == null && ScoreTypeCode.Contains(m.Code)).ToList <Tra_ScoreType>();
var stt = 1;
foreach (var TraineeScore in lstTraineeScore)
{
var TraineeTopic = TraineeTopicAll.Where(m => m.CodeEmp == TraineeScore.CodeEmp && m.TopicCode == TraineeScore.TopicCode).FirstOrDefault();
Tra_ScoreType ScoreType = lstTypeScoreAll.Where(m => m.Code == TraineeScore.TypeScore).FirstOrDefault();
if (TraineeTopic == null) //Loi import
{
TraineeScore.Stt = stt++;
TraineeScore.TypeError = "Không Có Môn Học Của Học Viên";
DataReviewOutput.Add(TraineeScore);
}
else if (ScoreType == null)
{
TraineeScore.Stt = stt++;
TraineeScore.TypeError = "Không Có Loại Điểm Của Môn Học";
DataReviewOutput.Add(TraineeScore);
}
else
{
TraineeScore.Stt = stt++;
DataReviewOutput.Add(TraineeScore);
//Kiem tra diem da co trong DB chua
//neu co roi thi update neu chua thi tao moi
Guid TraineeTopicID = TraineeTopic.ID;
Tra_TraineeScore TraineeScore_Current = LstTraineeScoreAll.Where(m => m.TraineeTopicID == TraineeTopicID && m.ScoreTypeID == ScoreType.ID).FirstOrDefault();
bool isNew = false;
if (TraineeScore_Current == null)
{
isNew = true;
TraineeScore_Current = new Tra_TraineeScore();
TraineeScore_Current.ID = Guid.NewGuid();
}
TraineeScore_Current.TraineeTopicID = TraineeTopicID;
TraineeScore_Current.ScoreTypeID = ScoreType.ID;
TraineeScore_Current.Score = TraineeScore.Score;
if (isNew)
{
resultNew.Add(TraineeScore_Current);
}
else
{
var entityEdit = new Tra_TraineeScoreEntity
{
ID = TraineeScore_Current.ID,
TraineeTopicID = TraineeScore_Current.TraineeTopicID,
ScoreTypeID = ScoreType.ID,
Score = TraineeScore.Score
};
resultUpdate.Add(TraineeScore_Current);
message = traineeScoreServices.Edit(entityEdit);
}
}
}
entityNew = resultNew.Translate <Tra_TraineeScoreEntity>();
entityUpdate = resultUpdate.Translate <Tra_TraineeScore>();
if (entityNew.Count > 0)
{
message += traineeScoreServices.Add(entityNew);
}
return(message);
}
}
public string SaveListTraineeScore(List<Tra_TraineeScoreImport> lstTraineeScore, out List<Tra_TraineeScoreImport> DataReviewOutput)
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoTra_Class = new CustomBaseRepository<Tra_Class>(unitOfWork);
var repoTra_Trainee = new CustomBaseRepository<Tra_Trainee>(unitOfWork);
var repoTra_TraineeTopic = new CustomBaseRepository<Tra_TraineeTopic>(unitOfWork);
var repoTra_TraineeScore = new CustomBaseRepository<Tra_TraineeScore>(unitOfWork);
var repoTra_ScoreType = new CustomBaseRepository<Tra_ScoreType>(unitOfWork);
var traineeScoreServices = new Tra_TraineeScoreServices();
string message = string.Empty;
List<Tra_TraineeScoreEntity> entityNew = new List<Tra_TraineeScoreEntity>();
List<Tra_TraineeScore> entityUpdate = new List<Tra_TraineeScore>();
List<Tra_TraineeScore> resultNew = new List<Tra_TraineeScore>();
List<Tra_TraineeScore> resultUpdate= new List<Tra_TraineeScore>();
DataReviewOutput = new List<Tra_TraineeScoreImport>();
List<string> ClassCode = lstTraineeScore.Select(m => m.ClassCode).Distinct().ToList();
//Lấy DS ClassID
List<Guid> ClassID = repoTra_Class.GetAll().Where(m => m.IsDelete == null && ClassCode.Contains(m.Code)).Select(m => m.ID).ToList<Guid>();
//Lấy DS TraineeID
List<Guid> TraineeID = repoTra_Trainee.GetAll().Where(m => m.IsDelete == null && ClassID.Contains(m.ClassID)).Select(m => m.ID).ToList<Guid>();
//Lấy DS TraineetopicID
List<Guid> lstTraineeTopicID = repoTra_TraineeTopic.GetAll().Where(m => m.IsDelete == null && TraineeID.Contains(m.TraineeID ?? Guid.Empty)).Select(m => m.ID).ToList<Guid>();
//Lấy DS TraineeTopic
var TraineeTopicAll = repoTra_TraineeTopic.GetAll().Where(m => m.IsDelete == null && lstTraineeTopicID.Contains(m.ID))
.Select(m => new { m.ID, TopicCode = m.Cat_Topic.Code, CodeEmp = m.Tra_Trainee.Hre_Profile.CodeEmp, ClassCode = m.Tra_Trainee.Tra_Class.Code });
//Lấy DS TraineeScore
List<Tra_TraineeScore> LstTraineeScoreAll = repoTra_TraineeScore.GetAll().Where(m => m.IsDelete == null && lstTraineeTopicID.Contains(m.TraineeTopicID ?? Guid.Empty)).ToList<Tra_TraineeScore>();
List<string> ScoreTypeCode = lstTraineeScore.Select(m => m.TypeScore).Distinct().ToList<string>();
List<Tra_ScoreType> lstTypeScoreAll = repoTra_ScoreType.GetAll().Where(m => m.IsDelete == null && ScoreTypeCode.Contains(m.Code)).ToList<Tra_ScoreType>();
var stt = 1;
foreach (var TraineeScore in lstTraineeScore)
{
var TraineeTopic = TraineeTopicAll.Where(m => m.CodeEmp == TraineeScore.CodeEmp && m.TopicCode == TraineeScore.TopicCode).FirstOrDefault();
Tra_ScoreType ScoreType = lstTypeScoreAll.Where(m => m.Code == TraineeScore.TypeScore).FirstOrDefault();
if (TraineeTopic == null) //Loi import
{
TraineeScore.Stt = stt++;
TraineeScore.TypeError = "Không Có Môn Học Của Học Viên";
DataReviewOutput.Add(TraineeScore);
}
else if (ScoreType == null)
{
TraineeScore.Stt = stt++;
TraineeScore.TypeError = "Không Có Loại Điểm Của Môn Học";
DataReviewOutput.Add(TraineeScore);
}
else
{
TraineeScore.Stt = stt++;
DataReviewOutput.Add(TraineeScore);
//Kiem tra diem da co trong DB chua
//neu co roi thi update neu chua thi tao moi
Guid TraineeTopicID = TraineeTopic.ID;
Tra_TraineeScore TraineeScore_Current = LstTraineeScoreAll.Where(m => m.TraineeTopicID == TraineeTopicID && m.ScoreTypeID == ScoreType.ID).FirstOrDefault();
bool isNew = false;
if (TraineeScore_Current == null)
{
isNew = true;
TraineeScore_Current = new Tra_TraineeScore();
TraineeScore_Current.ID = Guid.NewGuid();
}
TraineeScore_Current.TraineeTopicID = TraineeTopicID;
TraineeScore_Current.ScoreTypeID = ScoreType.ID;
TraineeScore_Current.Score = TraineeScore.Score;
if (isNew)
{
resultNew.Add(TraineeScore_Current);
}
else
{
var entityEdit = new Tra_TraineeScoreEntity
{
ID = TraineeScore_Current.ID,
TraineeTopicID = TraineeScore_Current.TraineeTopicID,
ScoreTypeID = ScoreType.ID,
Score = TraineeScore.Score
};
resultUpdate.Add(TraineeScore_Current);
message = traineeScoreServices.Edit(entityEdit);
}
}
}
entityNew = resultNew.Translate<Tra_TraineeScoreEntity>();
entityUpdate = resultUpdate.Translate<Tra_TraineeScore>();
if (entityNew.Count > 0)
{
message += traineeScoreServices.Add(entityNew);
}
return message;
}
}
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 DataTable GetReportTraineeUnAttend(string codeEmp, string profileName, string orgStructureID, Guid[] courseID, Guid[] classID, DateTime? _StartDate, DateTime? _EndDate, bool IsCreateTemplate, Guid[] RequirementTrainIDs, string UserLogin)
{
string status = string.Empty;
DataTable table = CreateReportTraineeUnAttendSchema();
if (IsCreateTemplate)
{
return table;
}
var traineeServices = new Tra_TraineeServices();
var objTrainee = new List<object>();
objTrainee.AddRange(new object[15]);
objTrainee[9] = profileName;
objTrainee[1] = codeEmp;
objTrainee[8] = orgStructureID;
objTrainee[3] = DateTime.Now;
objTrainee[4] = DateTime.MaxValue;
objTrainee[13] = 1;
objTrainee[14] = int.MaxValue - 1;
var lstTrainee = traineeServices.GetData<Tra_TraineeEntity>(objTrainee, ConstantSql.hrm_tra_sp_get_Trainee, UserLogin, ref status).ToList();
if (lstTrainee.Count > 0)
lstTrainee = lstTrainee.Where(s => s.EndDate != null && s.EndDate.Value > DateTime.Now).ToList();
if (_StartDate != null)
lstTrainee = lstTrainee.Where(s => s.StartDate != null && s.StartDate.Value <= _StartDate.Value).ToList();
if (_EndDate != null)
lstTrainee = lstTrainee.Where(s => s.EndDate != null && s.EndDate.Value >= _EndDate.Value).ToList();
if (courseID != null)
{
lstTrainee = lstTrainee.Where(s => courseID.Contains(s.CourseID)).ToList();
}
if (classID != null)
{
lstTrainee = lstTrainee.Where(s => classID.Contains(s.ClassID)).ToList();
}
var lisRequirementDetailByprofileID = new List<Guid>();
var requirmentDetailServices = new Tra_RequirementTrainDetailServices();
var objRequirementDetail = new List<object>();
objRequirementDetail.Add(null);
objRequirementDetail.Add(1);
objRequirementDetail.Add(int.MaxValue - 1);
var lstRequirementDetail = requirmentDetailServices.GetData<Tra_RequirementTrainDetailEntity>(objRequirementDetail, ConstantSql.hrm_tra_sp_get_RequirementDetail, UserLogin, ref status).ToList();
var lstClassIDByTrainee = lstTrainee.Select(s => s.ClassID).ToList();
var lstCourseId = lstTrainee.Select(s => s.CourseID).ToList();
if (RequirementTrainIDs != null)
{
lstRequirementDetail = lstRequirementDetail.Where(s => s.RequirementTrainID != null && RequirementTrainIDs.Contains(s.RequirementTrainID.Value)).ToList();
// lstRequirementDetail = lstRequirementDetail.Where(s => s.CourseID != null && s.ClassID != null && s.ProfileID != null && lisRequirementDetailByprofileID.Contains(s.ProfileID.Value) && lstClassIDByTrainee.Contains(s.ClassID.Value) && lstCourseId.Contains(s.CourseID.Value)).ToList();
if (lstRequirementDetail.Count > 0)
{
lisRequirementDetailByprofileID = lstRequirementDetail.Where(s => s.ProfileID != null).Select(s => (Guid)s.ProfileID).ToList();
}
}
if(lisRequirementDetailByprofileID.Count > 0)
{
// lstTrainee = lstTrainee.Where(s => lisRequirementDetailByprofileID.Contains(s.ProfileID)).ToList();
lisRequirementDetailByprofileID = lstRequirementDetail.Where(s => s.CourseID != null && s.ClassID != null && s.ProfileID != null && lisRequirementDetailByprofileID.Contains(s.ProfileID.Value) && lstClassIDByTrainee.Contains(s.ClassID.Value) && lstCourseId.Contains(s.CourseID.Value)).Select(s => (Guid)s.ProfileID).ToList();
}
var lstTraineeID = 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();
lstTraineeTopic = lstTraineeTopic.Where(s => s.TraineeID != null && lstTraineeID.Contains(s.TraineeID.Value)).ToList();
var lstTraineeTopicID = lstTraineeTopic.Select(s => s.ID).ToList();
var traineeScoreService = new Tra_TraineeScoreServices();
var objTraineeScore = new List<object>();
objTraineeScore.Add(1);
objTraineeScore.Add(int.MaxValue);
var lstTraineeScore = traineeScoreService.GetData<Tra_TraineeScoreEntity>(objTraineeScore, ConstantSql.hrm_tra_sp_get_TraineeScore, UserLogin, ref status).ToList();
lstTraineeScore = lstTraineeScore.Where(s => s.TraineeTopicID != null && lstTraineeTopicID.Contains(s.TraineeTopicID.Value) && s.TraineeID != null && s.Score != null).ToList();
foreach (var item in lstTrainee)
{
DataRow dr = table.NewRow();
var lstTraineeScoreByTraineeID = lstTraineeScore.Where(s => item.ID == s.TraineeID.Value).ToList();
if (lstTraineeScoreByTraineeID.Count == 0)
{
dr[Tra_ReportTraineeUnAttendEntity.FieldNames.CodeEmp] = item.CodeEmp;
dr[Tra_ReportTraineeUnAttendEntity.FieldNames.ProfileName] = item.ProfileName;
dr[Tra_ReportTraineeUnAttendEntity.FieldNames.E_DEPARTMENT] = item.E_DEPARTMENT;
dr[Tra_ReportTraineeUnAttendEntity.FieldNames.E_DIVISION] = item.E_DIVISION;
dr[Tra_ReportTraineeUnAttendEntity.FieldNames.E_SECTION] = item.E_SECTION;
dr[Tra_ReportTraineeUnAttendEntity.FieldNames.E_TEAM] = item.E_TEAM;
dr[Tra_ReportTraineeUnAttendEntity.FieldNames.E_UNIT] = item.E_UNIT;
dr[Tra_ReportTraineeUnAttendEntity.FieldNames.ClassName] = item.ClassName;
dr[Tra_ReportTraineeUnAttendEntity.FieldNames.CourseName] = item.CourseName;
dr[Tra_ReportTraineeUnAttendEntity.FieldNames.WorkPlace] = item.WorkPlaceName;
dr[Tra_ReportTraineeUnAttendEntity.FieldNames.RequirementTrainName] = item.RequirementTrainName;
table.Rows.Add(dr);
}
}
return table;
}
/// <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 JsonResult SaveImortScore([DataSourceRequest] DataSourceRequest request, CatImportModel model)
{
var services = new Tra_TraineeScoreServices();
List<Tra_TraineeScoreImport> lstTraineeScore = new List<Tra_TraineeScoreImport>();
List<Tra_TraineeScoreImport> lstTraineeScoreTranslate = new List<Tra_TraineeScoreImport>();
List<Tra_TraineeScoreImport> DataError = new List<Tra_TraineeScoreImport>();
var _fileName = Common.GetPath(Common.TemplateURL) + model.TemplateFile;
_fileName = _fileName.Replace("/", "\\");
ImportService = new ImportService
{
//FileName = Common.GetPath(model.TemplateFile),
FileName = _fileName,
DateTimeFormat = model.FormatDate,
ImportTemplateID = model.ID,
};
try
{
var table = ImportService.ImportNew(_fileName, model.TemplateFile, model.ID);
lstTraineeScore = table.Translate<Tra_TraineeScoreImport>();
foreach (var item in lstTraineeScore)
{
var entity = new Tra_TraineeScoreImport
{
ClassCode = item.Column2,
CodeEmp = item.Column3,
TopicCode = item.Column4,
TypeScore = item.Column5,
Score = item.Column6,
TypeError = item.Column7,
};
lstTraineeScoreTranslate.Add(entity);
}
var message = services.SaveListTraineeScore(lstTraineeScoreTranslate, out DataError);
if (message == NotificationType.Success.ToString())
{
return Json(message, JsonRequestBehavior.AllowGet);
}
}
catch (Exception ex)
{
model.Description = ex.Message;
}
return Json(DataError.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
}
public ActionResult UpdateScoreInTraineeTopic(Dictionary<string, object> model)
{
string status = string.Empty;
string message = string.Empty;
var DictraineeID = model.ElementAt(0);
string[] traineeID = (string[])DictraineeID.Value;
// var entity = new Tra_TraineeTopicEntity();
var lstEntity = new List<Tra_TraineeTopicEntity>();
var topicServices = new ActionService(UserLogin);
var objTopic = new List<object>();
objTopic.Add(null);
objTopic.Add(null);
objTopic.Add(null);
objTopic.Add(null);
objTopic.Add(1);
objTopic.Add(int.MaxValue - 1);
var lstTopic = topicServices.GetData<Cat_TopicEntity>(objTopic, ConstantSql.hrm_cat_sp_get_Topic, ref status).ToList();
var traineeScoreServices = new Tra_TraineeScoreServices();
var objTraineeScore = new List<object>();
objTraineeScore.Add(1);
objTraineeScore.Add(int.MaxValue - 1);
var lstTraineeScore = topicServices.GetData<Tra_TraineeScoreEntity>(objTraineeScore, ConstantSql.hrm_tra_sp_get_TraineeScore, ref status).ToList();
var scoreTopicServices = new ActionService(UserLogin);
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, ref status).ToList();
var traineeTopicServices = new Tra_TraineeTopicServices();
var objTraineeTopic = new List<object>();
objTraineeTopic.Add(1);
objTraineeTopic.Add(int.MaxValue - 1);
var lstTraineeTopic = topicServices.GetData<Tra_TraineeTopicEntity>(objTraineeTopic, ConstantSql.hrm_tra_sp_get_TraineeTopic, ref status).ToList();
if (model.Count > 0)
{
for (int i = 3; i < model.Count; i++)
{
var entity = new Tra_TraineeTopicEntity();
var item = model.ElementAt(i);
var strTitle = item.Key.Split('_');
string[] score = (string[])item.Value;
var topicEnity = lstTopic.Where(s => item.Key.Contains(s.Code)).FirstOrDefault();
if (topicEnity != null)
{
var scoreTopicEntity = lstScoreTopic.Where(s => topicEnity.ID == s.TopicID && strTitle[1] == s.Code).FirstOrDefault();
var traineeTopicEntity = lstTraineeTopic.Where(s => s.TraineeID != null && topicEnity.ID == s.TopicID && Guid.Parse(traineeID[0]) == s.TraineeID.Value).FirstOrDefault();
if (traineeTopicEntity != null)
{
//Edit cột score trong bảng traineeTopic
if (!string.IsNullOrEmpty(score[0]))
{
traineeTopicEntity.Score = double.Parse(score[0]);
}
else {
traineeTopicEntity.Score = null;
}
message = traineeTopicServices.Edit(traineeTopicEntity);
//Kiểm tra trong bảng TraineeScoree. Nếu chưa có record thì tạo mới nguoc lai thì edit record
var traineeScoreEntity = lstTraineeScore.Where(s => s.TraineeTopicID == traineeTopicEntity.ID && scoreTopicEntity.ScoreTypeID == s.ScoreTypeID).FirstOrDefault();
if (traineeScoreEntity == null)
{
Tra_TraineeScoreEntity newTraineeScoreEntity = new Tra_TraineeScoreEntity();
newTraineeScoreEntity.ScoreTypeID = scoreTopicEntity.ScoreTypeID;
newTraineeScoreEntity.TraineeTopicID = traineeTopicEntity.ID;
newTraineeScoreEntity.Score = traineeTopicEntity.Score;
message = traineeScoreServices.Add(newTraineeScoreEntity);
}
else
{
traineeScoreEntity.Score = traineeTopicEntity.Score;
message = traineeScoreServices.Edit(traineeScoreEntity);
}
// lstEntity.Add(traineeTopicEntity);
}
}
}
//message = traineeTopicServices.Edit(lstEntity);
}
return null;
}