public void Initialize()
{
db = new Data.CathedraDBDataContext();
plan = db.LoadInCoursePlan.Single(x => x.Id == 5460);
classTest = new EmployeeLinkType(db.Employee.First(), db, plan, 0);
saveData = false;
}
public EmployeeLinkType(Employee emp, CathedraDBDataContext db, LoadInCoursePlan lilcp, decimal sum)
{
_emp = emp;
_db = db;
_lilcp = lilcp;
_sum = sum;
}
int GetNoDistributionlLoad(LoadInCoursePlan sllt)
{
var s = from sllts in _db.SortLoadLinkType
join sll in _db.SortLoadLink on sllts.Id equals sll.SortLoadLinkTypeID
join sl in _db.SortLoad on sll.SortLoadID equals sl.Id
join lp in _db.LoadInCoursePlan on sl.Id equals lp.SortLoadID
join work in _db.CourseInWork on lp.CourseInWorkID equals work.ID
join fact in _db.LoadInCourseFact on lp.Id equals fact.LoadInCoursePlanID
where lp.Id == sllt.Id && work.SchoolYearID == Repository.SchoolYear
select new
{
count = fact.CountHours / sl.PerStudent,
};
var ss = (int)(s.Sum(x => x.count) ?? 0);
return(GetTotalLoad(sllt) - ss);
}
int GetTotalLoad(LoadInCoursePlan sllt)
{
return((int)(sllt.CountHours / sllt.SortLoad.PerStudent));
}
