public string Info()
{
var userId = GetUserId();
var groupId = Convert.ToInt32(Context.Parameters["GroupId"]);
var paymentId = Context.Parameters["Id"];
string uID = userId.ToString();
string gID = Convert.ToString(Context.Parameters["GroupId"]);
string date = DateTime.Today.ToString();
string description = Data.Description;
string currency = Data.Currency;
string text = EmailService.Text(Payers.ToList(), Debtors.ToList(), uID, gID, date, description, currency);
return(text);
}
public List <Loan> GetLoans(string userID)
{
List <Loan> loans = null;
try
{
using (var context = new DebtyDBContext())
{
var loanss = (from loan in context.Loans
join creditor in context.Persons on loan.Creditor.Id equals creditor.Id
where loan.Creditor.Id == userID
select new
{
loanID = loan.LoanID,
loanName = loan.LoanName,
loanDesc = loan.LoanDesc,
loanDate = loan.LoanDate,
deadline = loan.Deadline,
loanAmount = loan.LoanAmount,
Creditor = new Creditor {
PersonID = loan.Creditor.Id, FirstName = creditor.FirstName, LastName = creditor.LastName
},
}).ToList();
var debtors = (from dl in context.DebtorLoans
join debtor in context.Persons on dl.DebtorID equals debtor.Id
select new
{
loanID = dl.LoanID,
debtor = new Debtor {
FirstName = debtor.FirstName, LastName = debtor.LastName
}
} into D
group D by D.loanID into Debtors
select new
{
loanID = Debtors.Key,
Debtors = Debtors.ToList()
}).ToList();
loans = (from loan in loanss
join debtor in debtors on loan.loanID equals debtor.loanID
select new Loan
{
LoanID = loan.loanID,
LoanName = loan.loanName,
LoanDesc = loan.loanDesc,
LoanDate = loan.loanDate,
Deadline = loan.deadline,
LoanAmount = loan.loanAmount,
Creditor = loan.Creditor,
Debtors = debtor.Debtors.Select(x => x.debtor).ToList()
}).ToList();
return(loans);
}
}
catch (Exception ex)
{
return(loans.DefaultIfEmpty().ToList());
}
}