public void OnOkButton(object obj)
{
var ContDest = bancaEntities.Conturis.Where(u => u.IBAN == IBAN).FirstOrDefault();
var ContSursa = bancaEntities.Conturis.Where(u => u.Client == _clientID).FirstOrDefault();
if (ContDest != null)
{
var TransactionRequest = new Tranzactii_Requests();
Random rand = new Random();
int toSkip = rand.Next(0, bancaEntities.Angajatis.Count());
var Angajat = bancaEntities.Angajatis.OrderBy(r => Guid.NewGuid()).Skip(toSkip).Take(1).First();
TransactionRequest.CodAngajat = Angajat.CodAngajat;
TransactionRequest.CodContSursa = ContSursa.CodCont;
TransactionRequest.CodContDestinatie = ContDest.CodCont;
TransactionRequest.Suma = Suma;
TransactionRequest.Data = Data;
bancaEntities.Tranzactii_Requests.Add(TransactionRequest);
bancaEntities.SaveChanges();
MessageBox.Show("Tranzactie in curs de procesare!", "Stockdock", MessageBoxButton.OK, MessageBoxImage.Information, MessageBoxResult.OK);
}
else
{
MessageBox.Show("IBAN-ul clientului nu exista", "Stockdock", MessageBoxButton.OK, MessageBoxImage.Warning, MessageBoxResult.OK);
}
}
public void Save(object sender)
{
//insert into Conturi Request1
Random rand = new Random();
int toSkip = rand.Next(0, BancaEntities.Angajatis.Count());
var Angajat = BancaEntities.Angajatis.OrderBy(r => Guid.NewGuid()).Skip(toSkip).Take(1).First();
BancaEntities.Conturi_Requests.Add(new Conturi_Requests {
Adresa = Adresa, Nume = Nume, CNP = CNP, Prenume = Prenume, CodAngajat = Angajat.CodAngajat
});
BancaEntities.SaveChanges();
}
public void OnConfirmButton(object obj)
{
Credite_Requests request = new Credite_Requests();
Random rand = new Random();
int toSkip = rand.Next(0, bancaEntities.Angajatis.Count());
var Angajat = bancaEntities.Angajatis.OrderBy(r => Guid.NewGuid()).Skip(toSkip).Take(1).First();
request.CodClient = _clientID;
request.CodOferta = CodOferta;
request.DataInceperii = DataInceperii;
request.DataFinalizarii = DataFinalizarii;
request.CodAngajat = Angajat.CodAngajat;
bancaEntities.Credite_Requests.Add(request);
bancaEntities.SaveChanges();
MessageBox.Show("Operatiune in curs de procesare!", "Stockdock", MessageBoxButton.OK, MessageBoxImage.Information, MessageBoxResult.OK);
}
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();
}
}
}
}
public void Register(object obj)
{
if (Password1 != Password2)
{
MessageBox.Show("Parolele nu coincid", "Stockdock", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
}
else
{
int id = BancaEntities.Clientis.OrderByDescending(q => q.CodClient).FirstOrDefault().CodClient;
var Pass = Hasher.Generate(Password1);
BancaEntities.Utilizatoris.Add(new Utilizatori {
email = Email, clientID = id, password = Pass
});
BancaEntities.SaveChanges();
}
}
void OnConfirmButton(object obj)
{
Depozit_Requests request = new Depozit_Requests();
Random rand = new Random();
int toSkip = rand.Next(0, bancaEntities.Angajatis.Count());
var Angajat = bancaEntities.Angajatis.OrderBy(r => Guid.NewGuid()).Skip(toSkip).Take(1).First();
request.CodAngajat = Angajat.CodAngajat;
request.CodClient = _clientID;
request.DataDepunerii = DataDepunerii;
request.Suma = Suma;
if (DateTime.Compare(DataDepunerii, DateTime.Today) < 0)
{
MessageBox.Show("Data este din trecut", "Stockdock", MessageBoxButton.OK, MessageBoxImage.Warning, MessageBoxResult.OK);
return;
}
bancaEntities.Depozit_Requests.Add(request);
bancaEntities.SaveChanges();
MessageBox.Show("Operatiune in curs de procesare!", "Stockdock", MessageBoxButton.OK, MessageBoxImage.Information, MessageBoxResult.OK);
}
