public static void CreateJobIndexPointWithValuesFromMatrix(KeyValuePair <JobPosition, Dictionary <string, List <string> > > jobPositionWithValue,
JobRepository jobRep, JobIndexRepository jobIndexRep, InquiryJobIndexPointRepository inquiryRep, JobPositionRepository jobPositionRepository)
{
var jobPosition = jobPositionRepository.GetBy(jobPositionWithValue.Key.Id);
foreach (var itm in jobPosition.ConfigurationItemList)
{
var job = jobRep.GetById(itm.JobPosition.JobId);
foreach (var jobIndexId in job.JobIndexList)
{
var jobIndex = (JobIndex)jobIndexRep.GetById(jobIndexId.JobIndexId);
PMSMigrationUtility.CreateJobIndexIndexPointWithValue(inquiryRep, jobIndex, itm,
jobPositionWithValue.Value[jobIndex.DictionaryName]);
}
}
}
public override void Up()
{
#region rule Engine
var uows = new MITD.Domain.Repository.UnitOfWorkScope(
new Data.NH.NHUnitOfWorkFactory(() =>
{
RuleEngineSession.sessionName = "PMSDBConnection";
return(RuleEngineSession.GetSession());
}));
using (var uow = uows.CurrentUnitOfWork as NHUnitOfWork)
{
var recRep = new REConfigeRepository(uow);
#region RuleEnginConfigurationItem
AdminMigrationUtility.CreateRuleEnginConfigurationItem(recRep, "RuleTextTemplate", @"
public class <#classname#> : IRule<CalculationData>
{
public void Execute(CalculationData data)
{
<#ruletext#>
}
}");
AdminMigrationUtility.CreateRuleEnginConfigurationItem(recRep, "ReferencedAssemblies",
@"System.Core.dll;MITD.Core.RuleEngine.dll;MITD.PMS.RuleContracts.dll");
AdminMigrationUtility.CreateRuleEnginConfigurationItem(recRep, "LibraryTextTemplate", @"
using System;
using System.Collections.Generic;
using MITD.Core;
using MITD.Core.RuleEngine;
using MITD.PMS.RuleContracts;
using System.Linq;
using System.Globalization;
namespace MITD.Core.RuleEngine
{
public static class Utils
{
public static RuleResult Res = new RuleResult();
<#functions#>
}
public class RuleResultHelper : IRuleResult<RuleResult>
{
public RuleResult GetResult()
{
return Utils.Res;
}
public void Clear()
{
Utils.Res = new RuleResult();
}
}
<#rules#>
}");
#endregion
#region Functions
var rfRep = new Core.RuleEngine.NH.RuleFunctionRepository(uow);
AdminMigrationUtility.CreateRuleFunction(rfRep, "توابع مورد نیاز", @"
public static RulePoint AddEmployeePoint(JobPosition job, KeyValuePair<JobIndex, Dictionary<Employee, List<Inquiry>>> index,
string name, decimal value, bool final = false)
{
var res = new RulePoint { Name = name, Value = value, Final = final };
if (!Utils.Res.JobResults.Any(j => j.Key == job.DictionaryName))
Utils.Res.JobResults.Add(job.DictionaryName, new JobPositionResult());
if (!Utils.Res.JobResults[job.DictionaryName].IndexResults.Any(j => j.Key == index.Key.DictionaryName))
Utils.Res.JobResults[job.DictionaryName].IndexResults.Add(index.Key.DictionaryName, new List<RulePoint>());
Utils.Res.JobResults[job.DictionaryName].IndexResults[index.Key.DictionaryName].Add(res);
return res;
}
public static List<decimal> GetSubordinatesInquiryPointBy(KeyValuePair<JobIndex, Dictionary<Employee, List<Inquiry>>> jobIndex)
{
try
{
var valueList =jobIndex.Value.SelectMany(j => j.Value)
.Where(x => x.JobPosition.JobPositionLevel == 3).ToList();
return valueList.Select(v => Convert.ToDecimal(v.Value)).ToList();
}
catch (Exception)
{
return new List<decimal>();
}
}
public static decimal GetParentInquiryPointBy(KeyValuePair<JobIndex, Dictionary<Employee, List<Inquiry>>> jobIndex)
{
try
{
var point=jobIndex.Value.SelectMany(j => j.Value).SingleOrDefault(x => x.JobPosition.JobPositionLevel == 1);
return point == null ? 0 : Convert.ToDecimal(point.Value);
}
catch (Exception)
{
return 0;
}
}
public static decimal GetSelfInquiryPointBy(KeyValuePair<JobIndex, Dictionary<Employee, List<Inquiry>>> jobIndex)
{
try
{
var point = jobIndex.Value.SelectMany(j => j.Value).SingleOrDefault(x => x.JobPosition.JobPositionLevel == 4);
return point == null ? 0 : Convert.ToDecimal(point.Value);
}
catch (Exception)
{
return 0;
}
}
public static decimal GetPoint(KeyValuePair<JobIndex, Dictionary<Employee, List<Inquiry>>> index)
{
var parentPoint = Utils.GetParentInquiryPointBy(index);
var selfPoint = Utils.GetSelfInquiryPointBy(index);
var subordinates = Utils.GetSubordinatesInquiryPointBy(index);
decimal subordinatesPoint = 0;
//point validation rule difference of 40
if (parentPoint != 0)
{
selfPoint = Math.Abs(selfPoint - parentPoint) < 40 ? selfPoint : 0;
if (subordinates.Count > 0)
{
decimal sumSubordinatePoint = 0;
decimal subordinateCount = 0;
foreach (var subordinatePoint in subordinates)
{
if (Math.Abs(subordinatePoint - parentPoint) < 40)
{
sumSubordinatePoint += subordinatePoint;
subordinateCount++;
}
}
subordinatesPoint = subordinateCount == 0 ? 0 : sumSubordinatePoint / subordinateCount;
}
}
else
{
subordinatesPoint = !subordinates.Any() ? 0 : subordinates.Sum() / subordinates.Count;
}
var point = (parentPoint * 4 + subordinatesPoint * 1 + selfPoint * 1) /
((parentPoint != 0 ? 1 : 0) * 4 + (subordinatesPoint != 0 ? 1 : 0) * 1 + (selfPoint != 0 ? 1 : 0) * 1);
return point;
}
public static RulePoint AddEmployeePoint(string name, decimal value, bool final = false)
{
var res = new RulePoint { Name = name, Value = value, Final = final };
Utils.Res.Results.Add(res);
return res;
}
public static RulePoint AddEmployeePoint(JobPosition job, string name, decimal value, bool final = false)
{
var res = new RulePoint { Name = name, Value = value, Final = final };
if (!Utils.Res.JobResults.Any(j => j.Key == job.DictionaryName))
Utils.Res.JobResults.Add(job.DictionaryName, new JobPositionResult());
Utils.Res.JobResults[job.DictionaryName].Results.Add(res);
return res;
}
public static RulePoint AddCalculationPoint(string name, decimal value, bool final = false)
{
try
{
var res = new RulePoint { Name = name, Value = value, Final = final };
Utils.Res.CalculationPoints.Add(res);
return res;
}
catch (Exception ex)
{
throw exceptionConvertor(ex, ""اضافه کردن مقدار محاسبه با عنوان "" + name);
}
}
public static Exception exceptionConvertor(Exception ex, string keyName)
{
var strkeyNotFound = string.Format(""خطا در دریافت اطلاعات مقدار محاسبه. مقداری با کلید {0} یافت نشد "", keyName) + ""\r\n"";
var strkeyOutOfRange = string.Format(""خطا در دریافت اطلاعات مقدار محاسبه.مقدار {0} در رنج قابل قبول نیست "", keyName) + ""\r\n"";
var strOtherExp = string.Format(""خطا در دریافت اطلاعات مقدار محاسبه با عنوان "" + keyName) + ""\r\n"";
if (ex is KeyNotFoundException)
return new KeyNotFoundException(strkeyNotFound + ex.Message);
if (ex is IndexOutOfRangeException)
return new IndexOutOfRangeException(strkeyOutOfRange + ex.Message);
return new Exception(strOtherExp + ex.Message);
}
public static void Update(this List<Tuple<long, long, decimal>> tuples,
Tuple<long, long, decimal> tuple, decimal value)
{
var index = tuples.FindIndex(c => c == tuple);
tuples.Insert(index, Tuple.Create(tuples[index].Item1, tuples[index].Item2, value));
tuples.RemoveAt(index + 1);
}
public static List<Tuple<long, long, decimal>> CalculatePoint(Tuple<long, long, decimal> tuple, List<Tuple<long, long, decimal>> tuples)
{
var childs = tuples.Where(c => c.Item1 == tuple.Item2).ToList();
foreach (var child in childs)
{
var sum = childs.Sum(c => c.Item3);
var average = sum / childs.Count();
var cof = tuple.Item3 / average;
var newValue = cof * child.Item3;
tuples.Update(child, newValue);
var tpl = tuples.Find(c => c.Item2 == child.Item2);
CalculatePoint(tpl, tuples);
}
return tuples;
}
public static RulePoint GetCalculationPoint(CalculationData data, string name)
{
try
{
return data.Points.CalculationPoints.SingleOrDefault(j => j.Name == name);
}
catch (Exception ex)
{
throw exceptionConvertor(ex, name);
}
}
");
#endregion
#region Rules
var ruleRep = new RuleRepository(uow);
AdminMigrationUtility.CreateRule(ruleRep, "محاسبه شاخص های کارمندان در دور اول", RuleType.PerCalculation, 1, @"
if (data.PathNo != 1) return;
decimal total = 0;
decimal performancePoint = 0;
decimal sumPerformanceGroupImportance = 0;
foreach (var position in data.JobPositions)
{
var x = 0m;
var y = 0m;
if (Utils.GetCalculationPoint(data, position.Unit.ParentId + "";"" + position.Unit.Id + ""/UnitPoint"") == null)
{
foreach (var index in position.Unit.Indices)
{
x += Convert.ToDecimal(index.Value.Item2) * Convert.ToDecimal(index.Key.CustomFields[""UnitIndexImportance""]);
y += Convert.ToDecimal(index.Key.CustomFields[""UnitIndexImportance""]);
}
var res = x / y;
Utils.AddCalculationPoint(position.Unit.ParentId + "";"" + position.Unit.Id + ""/UnitPoint"", res);
}
foreach (var index in position.Indices)
{
var point = Utils.GetPoint(index);
if (index.Key.Group.DictionaryName == ""PerformanceGroup"")
{
var jobindexImportance = Convert.ToDecimal(index.Key.CustomFields[""JobIndexImportance""]);
sumPerformanceGroupImportance += jobindexImportance;
performancePoint = performancePoint + point * jobindexImportance;
}
total = total + point;
Utils.AddEmployeePoint(position, index,
index.Key.Group.DictionaryName == ""PerformanceGroup"" ? ""Performance-gross"" : ""Behavioural-gross"",
point);
}
var finalPerformancePoint = 0m;
if (sumPerformanceGroupImportance != 0)
{
finalPerformancePoint = performancePoint / sumPerformanceGroupImportance;
}
Utils.AddEmployeePoint(position, ""PerformanceIndices"", finalPerformancePoint);
Utils.AddCalculationPoint(data.Employee.EmployeeNo + ""/"" + position.Unit.Id + ""/PerformanceIndex"", finalPerformancePoint);
}");
AdminMigrationUtility.CreateRule(ruleRep, "محاسبه واحد ها در دور دوم", RuleType.PerCalculation, 2, @"
if (data.PathNo != 2)
return;
var unitCalculationFlag = Utils.Res.CalculationPoints.SingleOrDefault(c => c.Name == ""UnitCalculationFlag"");
if (unitCalculationFlag != null)
return;
var allstringUnitPoints = data.Points.CalculationPoints.Where(c => c.Name.Contains(""UnitPoint"")).ToList();
var unitPoints = new List<Tuple<long, long, decimal>>();
allstringUnitPoints.ForEach(c =>
{
var ids = c.Name.Split('/')[0].Split(';');
unitPoints.Add(new Tuple<long, long, decimal>(Convert.ToInt64(ids[0]), Convert.ToInt64(ids[1]), c.Value));
});
var roots = unitPoints.Where(c => c.Item1 == 0).ToList();
roots.ForEach(r =>
{
Utils.CalculatePoint(r, unitPoints);
});
unitPoints.ForEach(c =>
{
Utils.AddCalculationPoint(c.Item1 + "";"" + c.Item2 + ""/TotalPointUnit"", c.Item3);
//data.Points.CalculationPoints.Where(f => f.Name.Contains(""TotalPointUnit"")).Single(d => d.Name.Contains(string.Concat(c.Item1, ';', c.Item2))).Value = c.Item3;
//data.Points.CalculationPoints.Where(f => f.Name.Contains(""TotalPointUnit"")).Single(d => d.Name.Contains(string.Concat(c.Item1, ';', c.Item2))).Value = 8;
});
Utils.AddCalculationPoint(""UnitCalculationFlag"", 1);
");
AdminMigrationUtility.CreateRule(ruleRep, "محاسبه شاخص های کارمندان در دور دوم", RuleType.PerCalculation, 3, @"
if (data.PathNo != 2) return;
decimal total = 0;
foreach (var position in data.JobPositions)
{
decimal sumBehaviralPoint = 0;
decimal sumIndexImportance = 0;
decimal sumPerformanceGroupImportance = 0;
decimal unitPerformanceAveragePoint = 0;
//////////////////////////////////////////////////////////////
var unitPerformancePoints =
data.Points.CalculationPoints.Where(c => c.Name.Contains(""/"" + position.Unit.Id + ""/"")).ToList();
//todo:clean
if (!unitPerformancePoints.Any())
throw new Exception(""unit performance points count is 0"");
var countForAvarage=unitPerformancePoints.Count(u => u.Value!=0);
if (countForAvarage != 0)
unitPerformanceAveragePoint = unitPerformancePoints.Sum(up => up.Value)/countForAvarage;
decimal unitPoint;
try
{
unitPoint = Utils.Res.CalculationPoints.Single(
c => c.Name == position.Unit.ParentId + "";"" + position.Unit.Id + ""/TotalPointUnit"").Value;
}
catch (Exception ex)
{
throw new Exception(""Total Unit Point is not calculated "" + position.Unit.ParentId + ""--"" + position.Unit.Id);
}
Utils.AddEmployeePoint(position, ""finalunitPoint"", unitPoint);
decimal totalPerformancePoint = 0;
try
{
if (unitPerformanceAveragePoint != 0)
totalPerformancePoint =
unitPerformancePoints.Single(up => up.Name.Contains(data.Employee.EmployeeNo)).Value * (unitPoint / unitPerformanceAveragePoint);
}
catch (Exception ex)
{
throw new Exception(""Total performance point is not calculated"");
}
Utils.AddEmployeePoint(position, ""finalPerformancePoint"", totalPerformancePoint);
foreach (var index in position.Indices)
{
var jobindexImportance = Convert.ToDecimal(index.Key.CustomFields[""JobIndexImportance""]);
sumIndexImportance += jobindexImportance;
if (index.Key.Group.DictionaryName == ""BehaviouralGroup"")
{
var point = Utils.GetPoint(index);
sumBehaviralPoint = sumBehaviralPoint + point * jobindexImportance;
}
if (index.Key.Group.DictionaryName == ""PerformanceGroup"")
{
sumPerformanceGroupImportance = sumPerformanceGroupImportance + jobindexImportance;
}
}
if (sumIndexImportance == 0)
throw new Exception(""sumIndexImportance is 0"");
total = total + ((sumBehaviralPoint + totalPerformancePoint * sumPerformanceGroupImportance) / sumIndexImportance);
Utils.AddEmployeePoint(position, ""finalJob"", (sumBehaviralPoint + totalPerformancePoint * sumPerformanceGroupImportance) / sumIndexImportance);
}
Utils.AddEmployeePoint(""final"", total / data.JobPositions.Count, true);
");
#endregion
uow.Commit();
}
#endregion
#region PMS Admin
uows = new MITD.Domain.Repository.UnitOfWorkScope(
new NHUnitOfWorkFactory(() =>
{
PMSAdmin.Persistence.NH.PMSAdminSession.sessionName = "PMSDBConnection";
return(PMSAdmin.Persistence.NH.PMSAdminSession.GetSession());
}));
using (var uow = uows.CurrentUnitOfWork as NHUnitOfWork)
{
var cftRep = new MITD.PMSAdmin.Persistence.NH.CustomFieldRepository(uow);
#region UnitIndex CustomFields Definition
AdminMigrationUtility.DefineCustomFieldType(cftRep, "اهمیت", "UnitIndexImportance", 0, 10,
MITD.PMSAdmin.Domain.Model.CustomFieldTypes.EntityTypeEnum.UnitIndex);
#endregion
#region JobIndex CustomFields Definition
AdminMigrationUtility.DefineCustomFieldType(cftRep, "اهمیت", "JobIndexImportance", 0, 10,
PMSAdmin.Domain.Model.CustomFieldTypes.EntityTypeEnum.JobIndex);
#endregion
#region Job CustomFields Definition
//var cft1 = new PMSAdmin.Domain.Model.CustomFieldTypes.CustomFieldType(cftRep.GetNextId(),
// "بودجه سالانه مصوب (U.S $)", "DeclaredAnnualBudget", 0, 1000000, EntityTypeEnum.Job, "string");
//cftRep.Add(cft1);
//jobCftList.Add(cft1);
//for (int i = 1; i < 7; i++)
//{
// var cft = new PMSAdmin.Domain.Model.CustomFieldTypes.CustomFieldType(cftRep.GetNextId(),
// "سن كشتی" + i, "ShipAge" + i, 0, 100, EntityTypeEnum.Job, "string");
// cftRep.Add(cft);
// jobCftList.Add(cft);
//}
#endregion
#region Employee CustomFields Definition
//for (int i = 0; i < 10; i++)
//{
// var cft = new PMSAdmin.Domain.Model.CustomFieldTypes.CustomFieldType(cftRep.GetNextId(),
// "فبلد دلخواه کارمند" + i, "EmployeeCft" + i, 0, 100, EntityTypeEnum.Employee, "string");
// cftRep.Add(cft);
// employeeCftList.Add(cft);
//}
#endregion
var unitIndexRep = new PMSAdmin.Persistence.NH.UnitIndexRepository(uow);
#region UnitIndexCategory Creation
AdminMigrationUtility.CreateUnitIndexCategory(unitIndexRep);
#endregion
var jobIndexRep = new PMSAdmin.Persistence.NH.JobIndexRepository(uow);
#region JobIndexCategory Creation
AdminMigrationUtility.CreateJobIndexCategory(jobIndexRep);
#endregion
var policyRep = new PMSAdmin.Persistence.NH.PolicyRepository(uow);
#region Policy Creation
AdminMigrationUtility.CreatePolicy(policyRep, "روش دفتر برنامه ها و روش ها", "MethodsAndPlanOfficePolicy");
#endregion
uow.Commit();
}
#endregion
#region PMS
uows = new MITD.Domain.Repository.UnitOfWorkScope(
new NHUnitOfWorkFactory(() => PMSSession.GetSession()));
using (var uow = uows.CurrentUnitOfWork as NHUnitOfWork)
{
var periodRep = new PeriodRepository(uow);
#region Period creation
PMSMigrationUtility.CreatePeriod(periodRep, "دوره خرداد 95", new DateTime(2016, 12, 21), new DateTime(2016, 6, 20));
#endregion
var jobIndexRep = new JobIndexRepository(uow);
#region JobIndexGroup Creation
var behaviouralGroup = PMSMigrationUtility.CreateJobIndexGroup(jobIndexRep, "گروه شاخص های رفتاری",
"BehaviouralGroup");
var performanceGroup = PMSMigrationUtility.CreateJobIndexGroup(jobIndexRep, "گروه شاخص های عملکردی",
"PerformanceGroup");
#endregion
var unitIndexRep = new UnitIndexRepository(uow);
#region UnitIndexGroup Creation
var unitGroup = PMSMigrationUtility.CreateUnitIndexGroup(unitIndexRep, "گروه شاخص های سازمانی", "OrganizationUnitGroup");
#endregion
uow.Commit();
}
#endregion
}