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; } }