private void Init()
{
#region Data for Test Student 1
var financialAidList = new FinancialAidList();
financialAidList.StudentName = "Alex";
string[] yearBeginList = { "10/22/2007", "10/22/2007", "5/5/2010", "5/5/2010", "5/5/2010", "12/10/2010" };
string[] yearEndList = { "5/29/2009", "5/29/2009", "12/1/2010", "12/1/2010", "12/1/2010", "5/20/2011" };
for (int i = 0; i < yearBeginList.Length; ++i)
{
var financialAidItem = new FinancialAidItem {
AidTitle = "Aid " + i, Amount = i * 100
};
string key = (i + 1) + " (" + yearBeginList[i] + " - " + yearEndList[i] + ")";
if (!financialAidList.AidDetails.ContainsKey(key))
{
financialAidList.AidDetails.Add(key, new List <FinancialAidItem>());
}
financialAidList.AidDetails[key].Add(financialAidItem);
}
_aidDetail.Add(1, financialAidList);
#endregion
#region Data for Test Student 2
financialAidList = new FinancialAidList();
financialAidList.StudentName = "Ben";
yearBeginList = new[] { "5/5/2010", "1/12/2011", "1/12/2011" };
yearEndList = new[] { "12/1/2010", "8/10/2011", "8/10/2011" };
for (int i = 0; i < yearBeginList.Length; ++i)
{
var financialAidItem = new FinancialAidItem {
AidTitle = "Aid " + i, Amount = i * 125
};
string key = (i + 1) + " (" + yearBeginList[i] + " - " + yearEndList[i] + ")";
if (!financialAidList.AidDetails.ContainsKey(key))
{
financialAidList.AidDetails.Add(key, new List <FinancialAidItem>());
}
financialAidList.AidDetails[key].Add(financialAidItem);
}
_aidDetail.Add(2, financialAidList);
#endregion
}
public FinancialAidList GetAidDetails(int studentNo)
{
var query = new StringBuilder();
query.AppendFormat("SELECT Student, LedgerDescription, StudentAwardAmount, AcademicYearBegin, AcademicYearEnd, AcademicYear ")
.AppendFormat(" FROM vWebAwards ")
.AppendFormat(" WHERE StudentNo = {0} ORDER BY AcademicYear ", studentNo);
var financialAidList = new FinancialAidList();
var aidDetails = financialAidList.AidDetails;
using (var reader = this.ExecuteReader(CommandType.Text, query.ToString()))
{
while (reader.Read())
{
int colIndex = -1;
financialAidList.StudentName = reader[++colIndex] as string;
var financialAidItem = new FinancialAidItem
{
AidTitle = reader[++colIndex] as string,
Amount = double.Parse(reader[++colIndex].ToString())
};
var academicYearBegin = reader[++colIndex] as DateTime?;
var academicYearEnd = reader[++colIndex] as DateTime?;
var academicYearNumber = reader[++colIndex] as string;
string strAcademicYear = "";
if (academicYearBegin.HasValue && academicYearEnd.HasValue)
{
// Formatting appropriately, e.g. 1 (9/3/2011 - 4/27/2012)
var cultureInfo = DateTimeFormatInfo.CurrentInfo;
strAcademicYear += " (" + academicYearBegin.Value.ToString("d", cultureInfo);
strAcademicYear += " - " + academicYearEnd.Value.ToString("d", cultureInfo) + ")";
}
strAcademicYear = academicYearNumber + strAcademicYear;
if (!aidDetails.ContainsKey(strAcademicYear))
{
aidDetails.Add(strAcademicYear, new List <FinancialAidItem>());
}
aidDetails[strAcademicYear].Add(financialAidItem);
//financialAidList.TotalAwards += financialAidItem.Amount;
}
}
return(financialAidList);
}
public FinancialAidList GetAidDetails(int studentNo)
{
FinancialAidList financialAidList = null;
try
{
financialAidList = _repository.GetAidDetails(studentNo);
}
catch (Exception ex)
{
throw new Exception(EnumUtils.GetStringValue(ErrorMessage.UserDefinedMessage), ex);
}
return(financialAidList);
}
