public static async Task InsertNewOfferBankAsync(Offer offer, Bank bank)
{
using (var context = new BankLoansEntities())
{
//add instances to context
context.Banks.Add(bank);
context.Offers.Add(offer);
// add instance to navigation property
offer.Banks.Add(bank);
//call SaveChanges from context to confirm inserts
await context.SaveChangesAsync();
}
}
public static async Task InsertExistingOfferBankAsync(int offerId, int bankId)
{
using (var context = new BankLoansEntities())
{
var offer = new Offer {
PK_OfferId = offerId
};
context.Offers.Add(offer);
context.Offers.Attach(offer);
var bank = new Bank {
PK_RegNumber = bankId
};
context.Banks.Add(bank);
context.Banks.Attach(bank);
offer.Banks.Add(bank);
await context.SaveChangesAsync();
}
}
public static List <BankOffersViewModel> GetOffersByBankId(int bankId)
{
using (var context = new BankLoansEntities())
{
var result = (
// состояние из контекста
from a in context.Banks
// состояние из свойства навигации
from b in a.Offers
//подключаем полезные данные таблицы
join c in context.Offers on b.PK_OfferId equals c.PK_OfferId
where a.PK_RegNumber == bankId
select new BankOffersViewModel
{
ID = c.PK_OfferId,
BankName = a.Name,
InterestRate = c.Interest
}).ToList();
return(result);
}
}
