public IEnumerable <dropdown_TermNo> dropdown_TermNo(long StaffId, long salaryYear)
{
var queryAll = _PayScalesRepo.GetAll().ToList();
var getPayScale = from p in queryAll
where p.StaffId == StaffId && p.SalaryYear.Year == salaryYear
select p.BasicSalaryTermNo;
var queryResult = new List <dropdown_TermNo>();
foreach (var item in getPayScale)
{
for (int j = 1; j <= item; j++)
{
var d = new dropdown_TermNo()
{
Id = j,
Number = j
};
queryResult.Add(d);
}
}
return(queryResult);
}
public IEnumerable <dropdown_TermNo> dropdown_TermNo(long feeTypeId, long classId)
{
var queryAll = _FeeStructuresRepo.GetAll().ToList();
var getFeeTypes = from p in queryAll
where p.ClassId == classId && p.FeeTypeId == feeTypeId && p.StartingYear.Value.Year <= DateTime.Now.Year && p.EndingYear.Value.Year >= DateTime.Now.Year
select p.YearlyTermNo;
var queryResult = new List <dropdown_TermNo>();
foreach (var item in getFeeTypes)
{
for (int j = 1; j <= item; j++)
{
var d = new dropdown_TermNo()
{
Id = j,
Number = j
};
queryResult.Add(d);
}
}
return(queryResult);
}
