private void UpsertAccount(AccountViewModel viewModel)
{
using (var tran = db.Database.BeginTransaction())
{
try
{
var exist = viewModel.Id != 0;
var now = DateTime.Now;
var account = exist ? db.Accounts.Find(viewModel.Id) : new Account();
account.Title = viewModel.Title;
account.ModifiedDate = now;
account.ClientId = viewModel.ClientId;
account.Balance = viewModel.Balance;
account.CurrencyId = viewModel.CurrencyId;
if (!exist)
{
account.AccountNumber = GetNextAccountNumber() + 1;
account.CreatedDate = now;
db.Accounts.Add(account);
}
db.SaveChanges();
tran.Commit();
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
tran.Rollback();
}
}
}
internal void UpsertClient(ClientViewModel viewModel)
{
using (var tran = db.Database.BeginTransaction())
{
try
{
var exist = viewModel.ClientId != 0;
var now = DateTime.Now;
var client = exist ? db.Clients.Find(viewModel.ClientId) : new Client();
client.Name = viewModel.ClientName;
client.ModifiedDate = now;
if (!exist)
{
client.CreatedDate = now;
db.Clients.Add(client);
}
db.SaveChanges();
tran.Commit();
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
tran.Rollback();
}
}
}
private void CreateGiroKonto()
{
try
{
if (PinNummerTexbox.Password == "" || StartbetragTexbox.Text == "" || ZinssSatzTexbox.Text == "")
{
throw new NoTextException();
}
var kunde = DataGrid.SelectedItem as Kunde.Kunde;
if (kunde == null)
{
throw new IsEmptyException();
}
var betrag = Convert.ToDouble(StartbetragTexbox.Text);
var zins = Convert.ToDouble(ZinssSatzTexbox.Text);
var konto = new GiroKonto(KontoNummerTextBox.Text, PinNummerTexbox.Password, betrag, zins, kunde);
_context.Add(konto);
_context.SaveChanges();
MessageBox.Show("Girokonto angelegt!");
ResetForms();
}
catch (NoTextException)
{
MessageBox.Show("Es wurde nicht alle Angaben ausgefüllt!");
}
catch (IsEmptyException)
{
MessageBox.Show("Es wurde kein Kunden ausgewählt!");
}
}
public ActionResult Create([Bind(Include = "CustomerID,FirstName,LastName,UserName,UserPassword")] Customer customer)
{
if (ModelState.IsValid)
{
db.Customers.Add(customer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult Create([Bind(Include = "Id,numeroCC,descricao,valor,numeroDestino,data")] Movimentacao movimentacao)
{
if (ModelState.IsValid)
{
db.Movimentacaos.Add(movimentacao);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(movimentacao));
}
public ActionResult Create([Bind(Include = "cnpj,nome")] Banco banco)
{
if (ModelState.IsValid)
{
db.Bancoes.Add(banco);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(banco));
}
public ActionResult Create([Bind(Include = "Id,numeroAgencia,numeroConta,senha,limite")] ContaCorrente contaCorrente)
{
if (ModelState.IsValid)
{
db.ContaCorrentes.Add(contaCorrente);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contaCorrente));
}
public ActionResult Create([Bind(Include = "customerID,fName,lName,address,city,state,zip,DOB,tele,email,locked")] Customer customer)
{
if (ModelState.IsValid)
{
db.Customers.Add(customer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult Create([Bind(Include = "Id,dataPagamento,dataEmprestimo,valor,formaPagamento,tipoTaxa")] Emprestimo emprestimo)
{
if (ModelState.IsValid)
{
db.Emprestimoes.Add(emprestimo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(emprestimo));
}
public ActionResult Create([Bind(Include = "Id")] ContaContabilInvestimento contaContabilInvestimento)
{
if (ModelState.IsValid)
{
db.ContaContabilInvestimentoes.Add(contaContabilInvestimento);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contaContabilInvestimento));
}
public ActionResult Create([Bind(Include = "CPF,Nome,RG")] Pessoa pessoa)
{
if (ModelState.IsValid)
{
db.Pessoas.Add(pessoa);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(pessoa));
}
public ActionResult Create([Bind(Include = "Id,tipoTaxa,valor,dataEntrada,dataResgate")] Investimento investimento)
{
if (ModelState.IsValid)
{
db.Investimentoes.Add(investimento);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(investimento));
}
public ActionResult Create([Bind(Include = "TransID,date,customerID,type,amount,employee")] TransHist transHist)
{
if (ModelState.IsValid)
{
db.TransactionHistory.Add(transHist);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.customerID = new SelectList(db.Customers, "customerID", "fName", transHist.customerID);
return(View(transHist));
}
public ActionResult Create([Bind(Include = "AccountID,Amount,Discriminator")] Account account)
{
if (ModelState.IsValid)
{
account.CustomerID = db.Customers.Single(c => c.UserName == User.Identity.Name).CustomerID;
db.Accounts.Add(account);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "FirstName", account.CustomerID);
return(View(account));
}
public ActionResult Create([Bind(Include = "TransactionID,TransactionDate,SignedCredit,AccountID,LoanID,TransactionDesc")] Transaction transaction)
{
if (ModelState.IsValid)
{
db.Transactions.Add(transaction);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AccountID = new SelectList(db.Accounts, "AccountID", "Discriminator", transaction.AccountID);
ViewBag.LoanID = new SelectList(db.Loans, "LoanID", "LoanID", transaction.LoanID);
return(View(transaction));
}
public async Task <IHttpActionResult> Deposit(int accountNumber, decimal amount, string currency)
{
var account = await db.Accounts.Where(a => a.AccountNumber == accountNumber).FirstOrDefaultAsync();
var result = new BankResponseViewModel()
{
AccountNumber = accountNumber,
Successful = false
};
if (account == null)
{
result.Message = "Account not found.";
}
else if (amount <= 0)
{
result.Message = "Invalid ammount.";
}
else
{
try
{
var defaultCurrency = await db.Currencies.Where(c => c.CurrencyCode == "USD").Select(r => r.CurrencyCode).FirstOrDefaultAsync();
var accountCurrency = account.Currency.CurrencyCode;
var targetCurrency = currency;
var balance = account.Currency.CurrencyCode == defaultCurrency ? account.Balance :
ConvertToUSD(account.Currency.CurrencyCode, account.Balance);
var targetAmount = currency == defaultCurrency ? amount :
ConvertToUSD(currency, amount);
balance += targetAmount;
account.Balance = account.Currency.CurrencyCode == defaultCurrency ? balance :
ConvertBackFromUSD(account.Currency.CurrencyCode, balance);
db.SaveChanges();
result.Successful = true;
result.Balance = account.Balance;
result.Currency = account.Currency.CurrencyCode;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
}
return(Ok(result));
}
public ActionResult Create([Bind(Include = "LoanID,Debt,InterestRate,CustomerID")] Loan loan)
{
if (ModelState.IsValid)
{
loan.CustomerID = db.Customers.Single(c => c.UserName == User.Identity.Name).CustomerID;
loan.DateCreated = DateTime.Now;
db.Loans.Add(loan);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "FirstName", loan.CustomerID);
return(View(loan));
}
public virtual void Update(T entity)
{
try
{
if (entity == null)
{
throw new ArgumentNullException(nameof(entity));
}
_context.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
throw new Exception(GetValidations(dbEx));
}
}
public ReturnObjValueBackEnd DeleteAccount(List <TaiKhoan> lstID)
{
retObjValueBackEnd = new ReturnObjValueBackEnd();
try
{
var ctx = new BankingContext();
List <TaiKhoan> lst = new List <TaiKhoan>();
for (int i = 0; i < lstID.Count; i++)
{
lst.Add(new TaiKhoan {
MaKH = lstID[i].MaKH,
MaNV = lstID[i].MaNV,
MaCN = lstID[i].MaCN
});
ctx.Entry(lst[i]).State = System.Data.Entity.EntityState.Deleted;
}
ctx.SaveChanges();
retObjValueBackEnd.Success = true;
return(retObjValueBackEnd);
}
catch (Exception ex)
{
retObjValueBackEnd.Success = false;
retObjValueBackEnd.Message = ex.ToString();
return(retObjValueBackEnd);
throw ex;
}
}
public ReturnObjValueBackEnd DeleteStaff(List <string> lstMaNV)
{
retObjValueBackEnd = new ReturnObjValueBackEnd();
try
{
var ctx = new BankingContext();
List <NhanVien> lstNV = new List <NhanVien>();
for (int i = 0; i < lstMaNV.Count; i++)
{
lstNV.Add(new NhanVien {
MaNV = lstMaNV[i]
});
ctx.Entry(lstNV[i]).State = System.Data.Entity.EntityState.Deleted;
}
ctx.SaveChanges();
retObjValueBackEnd.Success = true;
return(retObjValueBackEnd);
}
catch (Exception ex)
{
retObjValueBackEnd.Success = false;
retObjValueBackEnd.Message = ex.ToString();
return(retObjValueBackEnd);
throw ex;
}
}
public ReturnObjValueBackEnd InsertStaff(NhanVien staff)
{
retObjValueBackEnd = new ReturnObjValueBackEnd();
try
{
string maxId = "";
var ctx = new BankingContext();
maxId = (from c in ctx.NhanVien select c.MaNV).Max();
if (!string.IsNullOrEmpty(maxId))
{
int maxCurrent = Convert.ToInt16(maxId.Substring(2, maxId.Length - 2));
int maxNext = maxCurrent + 1;
string manv = maxNext.ToString().PadLeft(4, '0');
staff.MaNV = "NV" + manv;
}
else
{
staff.MaNV = "NV0001";
}
ctx.NhanVien.Add(staff);
ctx.SaveChanges();
retObjValueBackEnd.Success = true;
return(retObjValueBackEnd);
}
catch (Exception ex)
{
retObjValueBackEnd.Success = false;
retObjValueBackEnd.Message = ex.ToString();
return(retObjValueBackEnd);
throw ex;
}
}
public ReturnObjValueBackEnd DeleteCustomer(List <string> lstKH)
{
retObjValueBackEnd = new ReturnObjValueBackEnd();
try
{
var ctx = new BankingContext();
List <KhachHang> lstKhachHang = new List <KhachHang>();
for (int i = 0; i < lstKH.Count; i++)
{
lstKhachHang.Add(new KhachHang {
MaKH = lstKH[i]
});
ctx.Entry(lstKhachHang[i]).State = System.Data.Entity.EntityState.Deleted;
}
ctx.SaveChanges();
retObjValueBackEnd.Success = true;
return(retObjValueBackEnd);
}
catch (Exception ex)
{
retObjValueBackEnd.Success = false;
retObjValueBackEnd.Message = ex.ToString();
return(retObjValueBackEnd);
throw ex;
}
}
public ReturnObjValueBackEnd InsertSaveMoney(SoTietKiem objInsert)
{
retObjValueBackEnd = new ReturnObjValueBackEnd();
try
{
var ctx = new BankingContext();
string maxId = "";
maxId = (from c in ctx.SoTietKiem select c.MaSTK).Max();
if (!string.IsNullOrEmpty(maxId))
{
int maxCurrent = Convert.ToInt16(maxId.Substring(3, maxId.Length - 2));
int maxNext = maxCurrent + 1;
string mastkaddnew = maxNext.ToString().PadLeft(4, '0');
objInsert.MaSTK = "STK" + mastkaddnew;
}
else
{
objInsert.MaSTK = "STK0001";
}
ctx.SoTietKiem.Add(objInsert);
ctx.SaveChanges();
retObjValueBackEnd.Success = true;
return(retObjValueBackEnd);
}
catch (Exception ex)
{
retObjValueBackEnd.Success = false;
retObjValueBackEnd.Message = ex.ToString();
return(retObjValueBackEnd);
throw ex;
}
}
public ReturnObjValueBackEnd DeleteBanking(List <string> lstID)
{
retObjValueBackEnd = new ReturnObjValueBackEnd();
try
{
var ctx = new BankingContext();
List <CreditManagement.Models.NganHang> lst = new List <CreditManagement.Models.NganHang>();
for (int i = 0; i < lstID.Count; i++)
{
lst.Add(new CreditManagement.Models.NganHang {
MaNH = lstID[i]
});
ctx.Entry(lst[i]).State = System.Data.Entity.EntityState.Deleted;
}
ctx.SaveChanges();
retObjValueBackEnd.Success = true;
return(retObjValueBackEnd);
}
catch (Exception ex)
{
retObjValueBackEnd.Success = false;
retObjValueBackEnd.Message = ex.ToString();
return(retObjValueBackEnd);
throw ex;
}
}
public CommandResult Handle(RegisterUserCommand request)
{
try
{
var checkUser = context.User.Any(us => us.Email == request.Email);
if (checkUser)
{
return(new CommandResult(false, "User exists"));
}
var user = new User(request.FirstName, request.LastName, request.Gender, request.UniqueNumber,
request.BirthDay, request.Address, request.Email, request.Phone);
var branch = context.Branches.SingleOrDefault(br => br.Id == request.BranchId);
user.Branches = branch;
//ToRefactor
user.Role = context.Role.SingleOrDefault(role => role.Name == "Registered");
branch.Users.Add(user);
context.SaveChanges();
return(new CommandResult(true, "", user.Id));
}
catch (Exception exception)
{
return(new CommandResult(false, exception.Message));
}
}
private void AddButton_OnClick(object sender, RoutedEventArgs e)
{
using (var db = new BankingContext())
{
try
{
if (VornameTextBox.Text == "" || NachnameTextBox.Text == "" || AdresseTextBox.Text == "" ||
PlzTextBox.Text == "" || OrtTextBox.Text == "" || DatenschutzCheckbox.IsChecked == false)
{
throw new IsEmptyException();
}
var plz = Convert.ToInt32(PlzTextBox.Text);
var datenschutz = DatenschutzCheckbox.IsChecked == true;
db.Add(new Kunde.Kunde(VornameTextBox.Text, NachnameTextBox.Text, AdresseTextBox.Text, plz,
OrtTextBox.Text, TelefonNummerTextBox.Text,
datenschutz)); //TODO:Ueberpruefung ob bereits ein Kunde mit den Werten vorhanden ist
db.SaveChanges();
MessageBox.Show("Kunde angelegt!");
}
catch (IsEmptyException)
{
MessageBox.Show("Alle Felder müssen ausgefüllt sein!");
}
finally
{
db.Dispose();
}
}
}
public ReturnObjValueBackEnd DeleteDealDetail(List <ChiTietGiaoDich> lstID)
{
retObjValueBackEnd = new ReturnObjValueBackEnd();
try
{
var ctx = new BankingContext();
List <ChiTietGiaoDich> lst = new List <ChiTietGiaoDich>();
for (int i = 0; i < lstID.Count; i++)
{
lst.Add(new ChiTietGiaoDich {
MaKH = lstID[i].MaKH, NgayGD = lstID[i].NgayGD
});
ctx.Entry(lst[i]).State = System.Data.Entity.EntityState.Deleted;
}
ctx.SaveChanges();
retObjValueBackEnd.Success = true;
return(retObjValueBackEnd);
}
catch (Exception ex)
{
retObjValueBackEnd.Success = false;
retObjValueBackEnd.Message = ex.ToString();
return(retObjValueBackEnd);
throw ex;
}
}
public DbInitializer(BankingContext context)
{
_context = context;
_context.Database.EnsureCreated();
if (context.Customers.Any())
{
return;
}
int n = 100;
for (int i = 1; i < n; i++)
{
var newCustomer = new Customer {
FirstName = "Name" + i, LastName = "Ape" + i, DocumentNumber = i.ToString().PadLeft(9, '0'), IsActive = true, Password = "******" + i, Id_Rol = 1, User = "******" + i
};
_context.Customers.Add(newCustomer);
_context.BankAccounts.Add(new BankAccount {
CustomerId = newCustomer.Id, Customer = newCustomer, Balance = 100, IsLocked = false, Number = i.ToString().PadLeft(9, '0')
});
}
//_context.BankAccounts.Add(new BankAccount { Customer = newCustomer, Balance = 1500, IsLocked = false, Number = "123-456-001" });
//_context.BankAccounts.Add(new BankAccount { Customer = newCustomer, Balance = 1800, IsLocked = false, Number = "123-456-002" });
_context.Roles.Add(new Role {
Id = 1, IsActive = true, Role_Name = "Cliente"
});
_context.SaveChanges();
}
public override string ToString()
{
db.Entry(this).State = EntityState.Modified;
db.SaveChanges();
return("Nome: " + Nome +
"CPF" + CPF +
"RG" + RG);
}
private void DeleteButton_OnClick(object sender, RoutedEventArgs e)
{
var result = MessageBox.Show("Wollen Sie dieses Konto wirklich Löschen ?", "Löschen",
MessageBoxButton.YesNo);
var error = false;
switch (result)
{
case MessageBoxResult.Yes:
using (var db = new BankingContext())
{
var kontoList = db.KontoSet.Where(s => s.KontoNummer == KontoNummerTextbox.Text);
foreach (var giro in kontoList)
{
if (Crypto.DecryptPin(giro.Pin) == PinTextbox.Password)
{
var transactionlist = db.TransaktionsSet
.Where(s => s.Empfaenger == KontoNummerTextbox.Text)
.ToList();
foreach (var transaction in transactionlist)
{
db.TransaktionsSet.Remove(transaction);
}
db.Remove(giro);
error = false;
}
else
{
MessageBox.Show("Pin Falsch!");
error = true;
break;
}
}
//TODO: Fehler im Löschprotokoll Beheben FOREIGN-Key kann nicht gelöscht werden solange objekt noch besteht (Transaktionen werden deswegen nicht gelöscht sonderen besitzen keinen key mehr)
try
{
db.SaveChanges();
}
catch (Exception)
{
MessageBox.Show("Currently not working :D ! I work on a fix for this.");
}
}
if (error == false)
{
MessageBox.Show("Gelöscht!!");
ResetForm();
}
break;
case MessageBoxResult.No:
ResetForm();
break;
}
}
