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; }