public incomeExpense getIncomeExpenseForCase(string caseNumber)
{
incomeExpense result = null;
try
{
dbDataContext dbDataContext = new dbDataContext();
IQueryable<incomeExpense> queryable =
from a in dbDataContext.GetTable<incomeExpense>()
where a.caseId.Equals(caseNumber)
select a;
using (IEnumerator<incomeExpense> enumerator = queryable.GetEnumerator())
{
if (enumerator.MoveNext())
{
incomeExpense current = enumerator.Current;
result = current;
}
}
}
catch (Exception ex)
{
string message = ex.Message;
}
return result;
}
public assetAndLiability getAssetLiabilityForCase(string caseNumber)
{
assetAndLiability result = null;
try
{
dbDataContext dbDataContext = new dbDataContext();
IQueryable<assetAndLiability> queryable =
from a in dbDataContext.GetTable<assetAndLiability>()
where a.caseId.Equals(caseNumber)
select a;
using (IEnumerator<assetAndLiability> enumerator = queryable.GetEnumerator())
{
if (enumerator.MoveNext())
{
assetAndLiability current = enumerator.Current;
result = current;
}
}
}
catch (Exception ex)
{
string message = ex.Message;
}
return result;
}
public CkaAssessment getCkaProfile(string caseId)
{
CkaAssessment result = null;
try
{
dbDataContext dbDataContext = new dbDataContext();
IQueryable<CkaAssessment> queryable =
from a in dbDataContext.GetTable<CkaAssessment>()
where a.caseId.Equals(caseId)
select a;
using (IEnumerator<CkaAssessment> enumerator = queryable.GetEnumerator())
{
if (enumerator.MoveNext())
{
CkaAssessment current = enumerator.Current;
result = current;
}
}
}
catch (Exception ex)
{
string message = ex.Message;
}
return result;
}
public RiskProfileAnalysis getRiskProfileForCase(string caseNumber)
{
RiskProfileAnalysis result = null;
try
{
dbDataContext dbDataContext = new dbDataContext();
IQueryable<RiskProfileAnalysis> queryable =
from a in dbDataContext.GetTable<RiskProfileAnalysis>()
where a.caseId.Equals(caseNumber)
select a;
using (IEnumerator<RiskProfileAnalysis> enumerator = queryable.GetEnumerator())
{
if (enumerator.MoveNext())
{
RiskProfileAnalysis current = enumerator.Current;
result = current;
}
}
}
catch (Exception ex)
{
string message = ex.Message;
}
return result;
}
