public async Task <IActionResult> Create([Bind("ContractID,OfferID,ClientID,SigningDate,FinishDate")] Contract contract, int oid, string sum, DateTime sgndate, DateTime fnshdate) { var max = (from c in _context.Offers where (c.OfferID == oid) select c.Condition.MaxSum).Max(); var min = (from c in _context.Offers where (c.OfferID == oid) select c.Condition.MinSum).Min(); contract.OfferID = oid; contract.FinishDate = fnshdate; contract.SigningDate = sgndate; float sumf = float.Parse(sum, CultureInfo.InvariantCulture.NumberFormat); contract.Sum = sumf; if ((ModelState.IsValid) && (int)sumf <= max && (int)sumf >= min && fnshdate > sgndate) { _context.Add(contract); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["ClientID"] = new SelectList(_context.Clients, "ClientID", "Name", contract.ClientID); ViewData["OfferID"] = new SelectList(_context.Offers, "OfferID", "Name", contract.OfferID); return(View(contract)); }
public async Task <IActionResult> Create([Bind("BankID,Name,Address")] Bank bank) { if (ModelState.IsValid) { _context.Add(bank); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(bank)); }
public async Task <IActionResult> Create([Bind("Id,Name,Balance")] Account account) { if (ModelState.IsValid) { _context.Add(account); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(account)); }
public async Task <IActionResult> Create([Bind("ClientID,Name,PhoneNumber,ClientType")] Client client) { if (ModelState.IsValid) { _context.Add(client); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(client)); }
public async Task <IActionResult> Create([Bind("OfferTypeID,Name,Description")] OfferType offerType) { if (ModelState.IsValid) { _context.Add(offerType); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(offerType)); }
public async Task <IActionResult> Create([Bind("UserId,UserName,UserLastname,UserPpNo,UserPass")] User user) { if (ModelState.IsValid) { _context.Add(user); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(user)); }
public async Task <IActionResult> Create([Bind("ConditionID,Mark,MaxSum,MinSum,Special")] Condition condition) { if (ModelState.IsValid) { _context.Add(condition); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(condition)); }
public async Task <IActionResult> Create([Bind("OfferID,BankID,ConditionID,OfferTypeID,Name,Percentage")] Offer offer) { if (ModelState.IsValid) { _context.Add(offer); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["BankID"] = new SelectList(_context.Banks, "BankID", "Address", offer.BankID); ViewData["ConditionID"] = new SelectList(_context.Conditions, "ConditionID", "Mark", offer.ConditionID); ViewData["OfferTypeID"] = new SelectList(_context.OfferTypes, "OfferTypeID", "Description", offer.OfferTypeID); return(View(offer)); }
public async Task <IActionResult> Create([Bind("Id,FromAccountId, FromAccount, ToAccountId, ToAccount,TransactionDate,TransactionAmount,FromBalance,ToBalance")] Transaction transaction) { if (ModelState.IsValid) { try { var transferAmount = transaction.TransactionAmount; var fromAcct = GetAccount(transaction.FromAccountId); if (fromAcct.Balance < transferAmount) { TempData["ErrorMessage"] = "Transfer amount cannot be greater than available balance. Please select a different amount."; return(RedirectToAction(nameof(Create))); } var toAcct = GetAccount(transaction.ToAccountId); if (fromAcct.Id == toAcct.Id) { TempData["ErrorMessage"] = "You cannot transfer to the same account. Please choose another account"; return(RedirectToAction(nameof(Create))); } transaction.FromAccount = fromAcct.Name; transaction.ToAccount = toAcct.Name; transaction.TransactionDate = DateTime.Now; transaction.FromBalance = fromAcct.Balance; transaction.ToBalance = toAcct.Balance; //do balance transfer if (fromAcct.Balance < transferAmount) { throw new ArgumentOutOfRangeException(); } fromAcct.Balance -= transferAmount; toAcct.Balance += transferAmount; //save transaction _context.UpdateRange(fromAcct, toAcct); _context.AddRange(transaction); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } catch (Exception ex) { Console.WriteLine("Error Occurred: {0} ", ex); } } return(View(transaction)); }
public async Task <IActionResult> Create([Bind("MoneyTransactionsId,UserId,AmountMoney,BalenceTipId,BalanceGrId,OpaoperationId,BalanceCont,TrDate")] MoneyTransactions moneyTransactions) { if (ModelState.IsValid) { _context.Add(moneyTransactions); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["BalanceGrId"] = new SelectList(_context.ExchangeRate, "ExchangeRateId", "ExchangeRateId", moneyTransactions.BalanceGrId); ViewData["BalenceTipId"] = new SelectList(_context.ExchangeRate, "ExchangeRateId", "ExchangeRateId", moneyTransactions.BalenceTipId); ViewData["OpaoperationId"] = new SelectList(_context.Operation, "OperationId", "OperationName", moneyTransactions.OpaoperationId); ViewData["UserId"] = new SelectList(_context.User, "UserId", "UserLastname", moneyTransactions.UserId); return(View(moneyTransactions)); }
public async Task SaveChanges() { await _context.SaveChangesAsync(); }