public void setCollectionView()
{
bancaEntities.Dispose();
bancaEntities = new BancaEntities();
List<LoanRequestDisplayable> offers = new List<LoanRequestDisplayable>();
var query = (from oferta in bancaEntities.Credite_Oferta
join moneda in bancaEntities.Monedes
on oferta.CodMoneda equals moneda.CodMoneda
select new
{
oferta.CodOferta,
oferta.Suma,
oferta.RataLunara,
oferta.Dobanda,
Moneda = moneda.Nume
}).ToList();
foreach(var item in query)
{
offers.Add(new LoanRequestDisplayable()
{
CodOferta = item.CodOferta,
Suma = item.Suma,
RataLunara = item.RataLunara,
Dobanda = item.Dobanda,
Moneda = item.Moneda
});
}
_loansView = CollectionViewSource.GetDefaultView(offers);
}
public void setCollectionView()
{
bancaEntities.Dispose();
bancaEntities = new BancaEntities();
var Deposits = bancaEntities.Depozits.Where(u => u.CodClient == _clientID);
_depositsView = CollectionViewSource.GetDefaultView(Deposits.ToList());
}
public void setCollectionView()
{
bancaEntities.Dispose();
bancaEntities = new BancaEntities();
var Cont = bancaEntities.Conturis.Where(c => c.Client == _clientID).FirstOrDefault();
var Plati = bancaEntities.Platis.Where(u => u.CodCard == Cont.CodCard);
_paymentsView = CollectionViewSource.GetDefaultView(Plati.ToList());
}
public void OnPayButton(object obj)
{
var query = (from loan in bancaEntities.Credites
join monede in bancaEntities.Monedes
on loan.CodMoneda equals monede.CodMoneda
where loan.CodClient == _clientID
select new
{
loan.Suma,
loan.RataLunara,
loan.Penalizari,
loan.Dobanda,
loan.DataInceperii,
loan.DataFinalizarii,
Moneda = monede.Nume,
loan.SumaPlatita
}).ToList();
var Client = bancaEntities.Clientis.Where(u => u.CodClient == _clientID).FirstOrDefault();
if (SelectedItem == null)
{
MessageBox.Show("Nu ati selectat un imprumut", "Stockdock", MessageBoxButton.OK, MessageBoxImage.Warning, MessageBoxResult.OK);
return;
}
foreach (var item in query)
{
if ((item.DataInceperii == SelectedItem.DataInceperii) && (item.DataFinalizarii == SelectedItem.DataFinalizarii))
{
var Cont = bancaEntities.Conturis.Where(u => u.Client == _clientID).FirstOrDefault();
var Credit = bancaEntities.Credites.Where(u => (u.DataInceperii == SelectedItem.DataInceperii) && (u.DataFinalizarii == SelectedItem.DataFinalizarii)).FirstOrDefault();
var suma = Credit.RataLunara + Credit.Penalizari + ((Credit.Dobanda / 100) * Credit.Suma);
Cont.Sold -= suma;
Credit.SumaPlatita += suma;
if (suma < Credit.Suma)
{
bancaEntities.SaveChanges();
MessageBox.Show("Din contul dumneavoastra a fost retrasa rata lunara + dobanda + penalizarile", "Stockdock", MessageBoxButton.OK, MessageBoxImage.Information, MessageBoxResult.OK);
bancaEntities.Dispose();
bancaEntities = new BancaEntities();
}
}
}
}
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
using (BancaEntities context = new BancaEntities())
{
var ReportSource = new ReportDocument();
ReportSource.Load("X:\\proiecte\\C#\\banca\\BancaApp\\DepositReports.rpt");
var Depozite = context.Depozits.Where(u => u.CodClient == 30);
var Depo = from depo in Depozite
select new
{
depo.CodClient,
depo.CodDepozit,
depo.DataDepunerii,
depo.Suma
};
var list = Depozite.ToList();
ReportSource.SetDataSource(Depo);
raport.ViewerCore.ReportSource = ReportSource;
}
}
public void setCollectionView()
{
bancaEntities.Dispose();
bancaEntities = new BancaEntities();
List <LoanDisplayable> credite = new List <LoanDisplayable>();
var query = (from loan in bancaEntities.Credites
join monede in bancaEntities.Monedes
on loan.CodMoneda equals monede.CodMoneda
where loan.CodClient == _clientID
select new
{
loan.Suma,
loan.RataLunara,
loan.Penalizari,
loan.Dobanda,
loan.DataInceperii,
loan.DataFinalizarii,
loan.SumaPlatita,
Moneda = monede.Nume
}).ToList();
foreach (var item in query)
{
credite.Add(new LoanDisplayable()
{
Suma = item.Suma,
RataLunara = item.RataLunara,
Penalizari = item.Penalizari,
Dobanda = item.Dobanda,
DataFinalizarii = item.DataFinalizarii,
DataInceperii = item.DataInceperii,
Moneda = item.Moneda,
SumaPlatita = item.SumaPlatita
});
}
SelectedItem = credite.FirstOrDefault();
_loansView = CollectionViewSource.GetDefaultView(credite);
}
public void setCollectionView()
{
bancaEntities.Dispose();
bancaEntities = new BancaEntities();
var Cont = bancaEntities.Conturis.Where(u => u.Client == _clientID).FirstOrDefault();
var Data = bancaEntities.Tranzactiis.Where(u => (u.CodContDestinatie == Cont.CodCont) || (u.CodContSursa == Cont.CodCont)).ToList();
var Transactions = bancaEntities.Tranzactiis.ToList();
//var Query = from tranzactie in bancaEntities.Tranzactiis
// join cont in bancaEntities.Conturis
// on tranzactie.CodContDestinatie equals cont.CodCont
// where tranzactie.CodContDestinatie == Cont.CodCont
// join cont2 in bancaEntities.Conturis
// on tranzactie.CodContSursa equals cont2.CodCont
// where cont2.CodCont == Cont.CodCont
// join client in bancaEntities.Clientis
// on cont.Client equals client.CodClient
// join client2 in bancaEntities.Clientis
// on cont2.Client equals client2.CodClient
// select new { Sursa = client.Nume + client.Prenume, Destinatie = client2.Nume + client2.Prenume, Suma = tranzactie.Suma, Data = tranzactie.Data };
_transactionsView = CollectionViewSource.GetDefaultView(Data.ToList());
}
public void setCollectionView()
{
bancaEntities.Dispose();
bancaEntities = new BancaEntities();
LoadInfo();
}
