public ActionResult Admin(Bank_Admin admin) { BankEntities usersEntities = new BankEntities(); if (admin.b_admin_name == null) { ModelState.AddModelError(admin.b_admin_name, "The Username field cannot be empty"); } if (admin.b_admin_pin.ToString() == null) { ModelState.AddModelError(admin.b_admin_pin.ToString(), "The PIN field cannot be empty"); } int?userId = usersEntities.VALIDATE_ADMIN(admin.b_admin_name.ToString(), admin.b_admin_pin.ToString()).FirstOrDefault(); string message = string.Empty; switch (userId.Value) { case -1: message = "Username or password incorrect"; break; case 0: FormsAuthentication.SetAuthCookie(admin.b_admin_name, admin.RememberMe); return(RedirectToAction("Index", "Admin", admin)); } ViewBag.Message = message; return(View(admin)); }
/// <summary> /// 获取存款用户信息,并初始化余额 /// </summary> /// <param name="accountNumber"></param> /// <returns></returns> public static Custom GetCustom(string accountNumber) { Custom custom = null; BankEntities c = new BankEntities(); try { var q = (from t in c.AccountInfo where t.accountNo == accountNumber select t).Single(); custom = CreateCustom(q.accountType); custom.AccountInfo.accountNo = accountNumber; custom.AccountInfo.accountName = q.accountName; custom.AccountInfo.accountPass = q.accountPass; custom.AccountInfo.IdCard = q.IdCard; } catch { return(null); } var q1 = (from t in c.MoneyInfo where t.accountNo == accountNumber select t).Sum(x => x.dealMoney); //custom.AccountBalance = q1.Year; return(custom); }
public async Task <bool> WithdrawAsync(decimal amount) { using (BankEntities context = new BankEntities()) { Account query = await GetAccountAsync(context); var balance = query.Balance; var newBalance = balance - amount; var balanceDiff = amount * -1; if (newBalance <= 0) { Console.WriteLine("You don't have enough funds."); return(false); } var transaction = new Transaction() { AccountNumber = _accountNum, TransactionType = "Withdrawal", BalanceDifference = balanceDiff, TransactionDate = DateTime.Now }; query.Balance = newBalance; context.Transactions.Add(transaction); return(await context.SaveChangesAsync() == 1); } }
public async Task <Account> GetAccountAsync(BankEntities context) { return(await context .Accounts .Where(e => e.AccountNumber == _accountNum) .SingleOrDefaultAsync()); }
public async Task <ResponseModel> Transfer([FromBody] RequestModel requestModel) { //performs validation on request's data //get merchant account details from database var account = new Account(); using (BankEntities db = new BankEntities()) { account = await db.Accounts.FindAsync(requestModel.MerchantAccountID); } //check if account exists if (account == null) { return(new ResponseModel(ResponseStatuses.Error, "Invalid Merchant account ID")); } /* * contact issuing bank to request money transfer * check if response from issuing bank is as expected and return appropriate response to this caller */ //if everything is as expected: //update account balance using (BankEntities db = new BankEntities()) { account.Amount += requestModel.Amount; db.Entry(account).State = EntityState.Modified; await db.SaveChangesAsync(); } //return successful response return(new ResponseModel(ResponseStatuses.Successful, string.Empty)); }
//Get Customer from DB private Customer GetCustomerIdBySSN(BankEntities context, int ssn) { return (context .Customers .SingleOrDefault(c => c.SocialSecurityNumber == ssn)); }
private Account GetAccountByNumAndPin(BankEntities context, string accountNum, string pin) { return (context .Accounts .SingleOrDefault(a => a.AccountNumber == accountNum && a.Pin == pin)); }
public static async Task <HttpResponseMessage> Run([HttpTrigger(AuthorizationLevel.Function, "post", Route = null)] HttpRequestMessage req, TraceWriter log) { log.Info("Received new account request"); HttpResponseMessage response; try { var user = await req.Content.ReadAsAsync <User>(); if (user != null) { log.Info("Saving to database"); using (var db = new BankEntities()) { db.Users.Add(user); await db.SaveChangesAsync(); } response = req.CreateResponse(HttpStatusCode.OK); } else { var errorMessage = "Failed to parse user"; log.Error(errorMessage); response = req.CreateErrorResponse(HttpStatusCode.BadRequest, errorMessage); } } catch (Exception e) { log.Error(e.Message, e); response = req.CreateErrorResponse(HttpStatusCode.InternalServerError, e); } return(response); }
/// <summary> /// Gets all open accounts /// </summary> /// <returns>The enumeration of the account instance</returns> public IEnumerable <Interface.DTO.Account> GetAccounts() { List <Interface.DTO.Account> accounts = new List <Interface.DTO.Account>(); using (BankEntities bankEntities = new BankEntities()) { var dbAccounts = from account in bankEntities.Account where account.IsOpen select new { Number = account.Number, OwnerName = account.Owner.Name, OwnerSurname = account.Owner.Surname, AccountType = account.Type, CurrentAmount = account.Amount, BonusCount = account.BonusCount }; foreach (var account in dbAccounts) { accounts.Add(new Interface.DTO.Account(account.Number, new Interface.DTO.Owner(account.OwnerName, account.OwnerSurname), AccountTypeConverter.StringToAccountType(account.AccountType)) { CurrentAmount = account.CurrentAmount, BonusCount = account.BonusCount }); } } return(accounts); }
/// <summary> /// Opens new account /// </summary> /// <param name="account">New account</param> public void OpenAccount(Interface.DTO.Account account) { using (BankEntities bankEntities = new BankEntities()) { Owner accOwner = bankEntities.Owner.FirstOrDefault(owner => owner.Name == account.AccountOwner.FirstName && owner.Surname == account.AccountOwner.LastName); if (accOwner == null) { accOwner = bankEntities.Owner.Add(new Owner() { Name = account.AccountOwner.FirstName, Surname = account.AccountOwner.LastName }); } Account dbAccount = bankEntities.Account.Add(new Account() { Number = account.AccountNumber, Amount = account.CurrentAmount, BonusCount = account.BonusCount, IsOpen = true, Type = AccountTypeConverter.AccountTypeToString(account.AccountType), Owner = accOwner, OwnerId = accOwner.OwnerId }); bankEntities.SaveChanges(); } }
public ActionResult Simulator(CustomerBankList user) { BankEntities usersEntities = new BankEntities(); int? userId = usersEntities.VALIDATE_USER(user.Name.card_no.ToString(), user.Name.card_pin.ToString()).FirstOrDefault(); string card_number = user.Name.card_no; int branch = (int)user.Bnk.b_branch_id; string message = string.Empty; switch (userId.Value) { case -1: { message = "Card Number or PIN is incorrect"; user.BankList = db.Banks.ToList(); break; } case 0: FormsAuthentication.SetAuthCookie(user.Name.card_no, user.RememberMe); return(RedirectToAction("Welcome", "Simulator", new { card_no = user.Name.card_no, branch1 = user.Bnk.b_branch_id })); } ViewBag.Message = message; return(View(user)); }
public BankEntities[] DisplayAllDetails() { SqlConnection ConnectionObject = new SqlConnection("Data Source=TAVDESK001;initial catalog=BankDatabase;integrated security=true"); BankEntities[] EntityArray = new BankEntities[100]; string command = "select * from AccountDetails;"; SqlCommand cmd = new SqlCommand(command, ConnectionObject); ConnectionObject.Open(); SqlDataReader SqlReader = cmd.ExecuteReader(); int counter = 0; while (SqlReader.Read()) { BankEntities EntityObject = new BankEntities(); EntityObject.AccountNumber = Convert.ToInt32(SqlReader.GetValue(0)); EntityObject.AccountBalance = Convert.ToInt32(SqlReader.GetValue(1)); EntityObject.BranchName = SqlReader.GetValue(2).ToString(); EntityObject.AccountType = SqlReader.GetValue(3).ToString(); EntityArray[counter] = EntityObject; counter++; } ConnectionObject.Close(); return(EntityArray); }
public BankEntities getAccountDetail(int AccNum) { try { BankEntities EntityObject = new BankEntities(); SqlConnection ConnectionObject = new SqlConnection("Data Source=TAVDESK001;initial catalog=BankDatabase;integrated security=true"); BankEntities[] EntityArray = new BankEntities[100]; string command = "select * from AccountDetails;"; SqlCommand cmd = new SqlCommand(command, ConnectionObject); ConnectionObject.Open(); SqlDataReader SqlReader = cmd.ExecuteReader(); while (SqlReader.Read()) { if (Convert.ToInt32(SqlReader.GetValue(0)) == AccNum) { EntityObject.AccountNumber = Convert.ToInt32(SqlReader.GetValue(0)); EntityObject.AccountBalance = Convert.ToInt32(SqlReader.GetValue(1)); EntityObject.BranchName = SqlReader.GetValue(2).ToString(); EntityObject.AccountType = SqlReader.GetValue(3).ToString(); break; } } ConnectionObject.Close(); return(EntityObject); } catch (Exception e) { return(null); } }
private void button_Delete_Click(object sender, RoutedEventArgs e) { var item = dataGrid.SelectedItem as EmployeeInfo; if (item == null) { MessageBox.Show("请先选择要删除的职员信息!"); return; } MessageBoxResult result = MessageBox.Show("您确定要删除该职员的信息吗?", "删除确认", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result == MessageBoxResult.Yes) { context = new BankEntities(); var q = from t in context.EmployeeInfo where t.EmployeeNo == item.EmployeeNo select t; if (q != null) { try { context.EmployeeInfo.Remove(q.FirstOrDefault()); int i = context.SaveChanges(); MessageBox.Show(string.Format("成功删除{0}个职员信息", i)); } catch { MessageBox.Show("删除失败!"); } } } ShowResult(); }
/// <summary> /// Gets the account using it's number /// </summary> /// <param name="accountNumber">The number of the account</param> /// <returns>The account with given number</returns> public Interface.DTO.Account GetAccount(string accountNumber) { using (BankEntities bankEntities = new BankEntities()) { var dbAccount = (from account in bankEntities.Account where account.IsOpen && account.Number == accountNumber join owner in bankEntities.Owner on account.OwnerId equals owner.OwnerId select new { Number = account.Number, OwnerName = account.Owner.Name, OwnerSurname = account.Owner.Surname, AccountType = account.Type, CurrentAmount = account.Amount, BonusCount = account.BonusCount }).FirstOrDefault(); if (dbAccount != null) { return(new Interface.DTO.Account( dbAccount.Number, new Interface.DTO.Owner(dbAccount.OwnerName, dbAccount.OwnerSurname), AccountTypeConverter.StringToAccountType(dbAccount.AccountType)) { CurrentAmount = dbAccount.CurrentAmount, BonusCount = dbAccount.BonusCount }); } else { return(null); } } }
private void Button_Click_1(object sender, RoutedEventArgs e) { BankEntities Content = new BankEntities(); if (date1 != null) { DateTime date2 = DateTime.Now; if ((date2 - date1).TotalHours < 8) { MessageBox.Show("您未完成今日的工作任务"); } else { MessageBox.Show("你已经成功下班打卡"); WageInfo wg1 = new WageInfo(); wg1.worktime = this.date1; wg1.closingtime = this.date2; wg1.normaltime = 320; wg1.overtime = 0; if ((date2 - date1).TotalHours == 1) { wg1.overtime = 20; } if ((date2 - date1).TotalHours == 2) { wg1.overtime = 40; } } } }
public OperateRecord() { InitializeComponent(); BankEntities context = new BankEntities(); var query = from t in context.MoneyInfo select t; this.datagrid1.ItemsSource = query.ToList(); }
/// <summary> /// 获取指定类别的利率 /// </summary> /// <param name="rateType">利率类别</param> /// <returns>对应类别的利率值</returns> public static double GetRate(RateType rateType) { string type = rateType.ToString(); BankEntities c = new BankEntities(); var q = (from t in c.RateInfo where t.rationType == type select t.rationValue).Single(); return(q.Value); }
public void ShowResult() { using (BankEntities c = new BankEntities()) { var q = from t in c.EmployeeInfo select t; datagrid1.ItemsSource = q.ToList(); } }
public async Task <IEnumerable <Transaction> > GetAccountHistoryAsync() { using (BankEntities context = new BankEntities()) { return(await context .Transactions .Where(e => e.AccountNumber == _accountNum) .ToListAsync()); } }
/// <summary> /// 获取指定类别的利率 /// </summary> /// <param name="rateType">利率类别</param> /// <returns>对应类别的利率值</returns> public static double GetRate(RateType rateType) { bool mark = true; string type = rateType.ToString(); BankEntities context = new BankEntities(); var qq = from t in context.AccountInfo where t.accountNo == DataOperation.str select t; var m = qq.FirstOrDefault(); if (type == "零存整取1年" || type == "零存整取3年" || type == "零存整取5年") { if (type == "零存整取1年") { for (int i = 2; i <= 12; i++) { if (!m.accountMark.Contains(i.ToString())) { mark = false; } } } else if (type == "零存整取3年") { for (int i = 2; i <= 36; i++) { if (!m.accountMark.Contains(i.ToString())) { mark = false; } } } else { for (int i = 2; i <= 60; i++) { if (!m.accountMark.Contains(i.ToString())) { mark = false; } } } if (mark == false) { type = "零存整取违规"; } } BankEntities c = new BankEntities(); var q = (from t in c.RateInfo where t.rationType == type select t.rationValue).Single(); return(q.Value); }
public int GetAccountId(string accountNum) { BankEntities context = new BankEntities(); var query = from a in context.Accounts where a.AccountNumber == accountNum select a; foreach (var account in query) { return(account.AccountID); } return(0); }
public void AuthServiceVerifyTests() { string accountNum = "1111"; string pin = "1111"; BankEntities bank = new BankEntities(); AuthService authService = new AuthService(); //Act bool test = authService.VerifyUser(accountNum, pin); //Assert Assert.IsTrue(test); }
public async Task <decimal> GetBalanceAsync() { using (BankEntities context = new BankEntities()) { var query = await context .Accounts .Where(e => e.AccountNumber == _accountNum) .Select(e => e.Balance) .SingleOrDefaultAsync(); return(query); } }
public bool CreateDeposit(DepositCreateModel model) { using (var ctx = new BankEntities()) { var entity = new Deposit { TransactionID = model.TransactionID, Amount = model.Amount }; ctx.Deposits.Add(entity); return(ctx.SaveChanges() == 1); } }
public int AddingNewAccount(BankEntities EntityObject, int KeyValue) { int a; if (KeyValue == 1) { a = DataAccessObject.AddingAccount("AddingAccountDetails", EntityObject); } else { a = EntityDataAccessObject.AddingAccount(EntityObject); } return(a); }
public BankEntities DisplayAccountofParticularAccount(int AccNum, int KeyValue) { BankEntities EntityObject = new BankEntities(); if (KeyValue == 1) { EntityObject = DataAccessObject.getAccountDetail(AccNum); } else { EntityObject = EntityDataAccessObject.getAccountDetails(AccNum); } return(EntityObject); }
public bool CreateWithdrawal(WithdrawalCreateModel model) { using (var ctx = new BankEntities()) { var entity = new Withdrawal { TransactionID = model.TransactionID, Amount = model.Amount }; ctx.Withdrawals.Add(entity); return(ctx.SaveChanges() == 1); } }
private void ShowResult() { if (context != null) { context.Dispose(); context = new BankEntities(); } //step2 var q = from t in context.EmployeeInfo select t; //step 3 this.dataGrid.ItemsSource = q.ToList(); }
public bool SaveNewBalanceToDatabase(string acctNum, decimal newBalance) { using (var ctx = new BankEntities()) { var entity = ctx .Accounts .Single(a => a.AccountNumber == acctNum); entity.AccountNumber = acctNum; entity.Balance = newBalance; return(ctx.SaveChanges() == 1); } }
public int CreateTransaction(TransactionCreateModel model) { using (var ctx = new BankEntities()) { var entity = new Transaction { TransactionType = model.TransactionType, AccountID = model.AccountID }; ctx.Transactions.Add(entity); ctx.SaveChanges(); return(entity.TransactionID); } }
private void comboBoxAccountType_SelectionChanged(object sender, SelectionChangedEventArgs e) { string s = comboBoxAccountType.SelectedItem.ToString(); using(BankEntities c = new BankEntities()) { var q = from t in c.AccountInfo where t.accountType == s select t; if (q.Count() > 0) { this.txtAccountNo.Text = string.Format("{0}", int.Parse(q.Max(x => x.accountNo)) + 1); } else { txtAccountNo.Text = string.Format("{0}00001", comboBoxAccountType.SelectedIndex + 1); } } }