protected void gridView_PageIndexChanging(object sender, GridViewPageEventArgs e) { UserTransaction commentDetails = new UserTransaction(); DataTable dtComments = null; DataView dvComments = null; if (ViewState[Constant.SESSION_COMMENT_TYPE] != null) { if (Int32.Parse(ViewState[Constant.SESSION_COMMENT_TYPE].ToString().Trim()) == 0) { if (ViewState[Constant.SESSION_BIDREFNO] != null) { dtComments = commentDetails.QueryItemCommentsbyRefNo(ViewState[Constant.SESSION_BIDREFNO].ToString().Trim(), false); dvComments = new DataView(dtComments); } } else { if (ViewState[Constant.SESSION_AUCTIONREFNO] != null) { dtComments = commentDetails.QueryItemCommentsbyRefNo(ViewState[Constant.SESSION_AUCTIONREFNO].ToString().Trim(), true); dvComments = new DataView(dtComments); } } } if (dvComments != null) { gvCommentArea.DataSource = dvComments; gvCommentArea.PageIndex = e.NewPageIndex; gvCommentArea.DataBind(); } }
internal RevisionDelta(RevisionDataType newRevision, RevisionDataType oldRevision, UserTransaction oldTransaction, UserType oldUser) { this.newRevision = newRevision; this.oldRevision = oldRevision; this.oldTransaction = oldTransaction; this.oldUser = oldUser; }
private void button1_Click(object sender, EventArgs e) { try { var a = new Dictionary <string, bool> { { "yw28", true }, { "aa", false } }; var b = JsonConvert.SerializeObject(a); richTextBox1.AppendText(Environment.NewLine + b); var c = new UserTransaction(); c.UserInfo = new PoliceUser(); c.UserInfo.Permission = a; var d = JsonConvert.SerializeObject(c); richTextBox1.AppendText(Environment.NewLine + d); Type type = Type.GetTypeFromProgID("SAPI.SpVoice"); dynamic spVoice = Activator.CreateInstance(type); spVoice.Speak("你好,欢迎使用!"); } catch (Exception ex) { richTextBox1.AppendText(Environment.NewLine + ex.Message); } _tCheckSignalr = new Thread(new ThreadStart(CheckSignalr)); _tCheckSignalr.Start(); }
public string AddNewTransaction(Guid CustomerId, UserTransaction TransactionToAdd) { try { var Context = new Central(); TransactionItem DBTrans = new TransactionItem(); DBTrans.TransactionItemId = Guid.NewGuid(); DBTrans.TransactionItemDate = TransactionToAdd.TransactionDate; DBTrans.TransactionItemName = TransactionToAdd.TransactionName; DBTrans.TransactionItemAmount = TransactionToAdd.TransactionAmount; DBTrans.TransactionItemMemo = TransactionToAdd.TransactionMemo; DBTrans.TransactionItemBudgetItem = TransactionToAdd.BudgetItemId; DBTrans.TransactionItemType = 2; DBTrans.CustomerId = CustomerId; DBTrans.CreationDate = DateTime.Now; DBTrans.UpdateDate = DateTime.Now; Context.TransactionItems.Add(DBTrans); Context.SaveChanges(); string status = "Success"; return(status); } catch (Exception e) { return(e.ToString()); } }
public IActionResult depositWithdraw(int UserId, Transaction transaction) { if (ModelState.IsValid) { User userInfo = dbContext.Users .Include(u => u.Transactions) .SingleOrDefault(u => u.UserId == UserId); double sum = 0; foreach (Transaction t in userInfo.Transactions) { sum += t.Amount; } if (transaction.Amount < 0 && transaction.Amount * -1 > sum) { ModelState.AddModelError("Amount", "You are not allowed to withdraw this value. The max you can " + sum + "only"); ViewBag.Email = HttpContext.Session.GetString("email"); ViewBag.userFlag = "true"; UserTransaction ut = new UserTransaction(); ut.user = userInfo; return(View("Success", ut)); } transaction.UserId = UserId; dbContext.Add(transaction); dbContext.SaveChanges(); } return(RedirectToAction("Success")); }
protected void gridView_PageIndexChanging(object sender, GridViewPageEventArgs e) { DataTable dtComments = null; DataView dvComments = null; if (ViewState[Constant.SESSION_COMMENT_TYPE] != null) { if (Int32.Parse(ViewState[Constant.SESSION_COMMENT_TYPE].ToString().Trim()) == 0) { if (ViewState[Constant.SESSION_BIDREFNO] != null) { dtComments = UserTransaction.QueryItemCommentsbyRefNo(connstring, ViewState[Constant.SESSION_BIDREFNO].ToString().Trim(), false); dvComments = new DataView(dtComments); } } else { if (ViewState[Constant.SESSION_AUCTIONREFNO] != null) { dtComments = UserTransaction.QueryItemCommentsbyRefNo(connstring, ViewState[Constant.SESSION_AUCTIONREFNO].ToString().Trim(), true); dvComments = new DataView(dtComments); } } } }
public RemoteResult GetTransaction(ServerId server, UserTransaction transaction, out UserTransaction result) { var connection = FindServer(server) as SingleConnectionToDistributor; result = null; if (connection == null) { ConnectToDistributor(server); connection = FindServer(server) as SingleConnectionToDistributor; } if (connection == null) { _distributor.ServerNotAvailable(server); return(new ServerNotFoundResult()); } result = connection.GetTransaction(transaction); if (result == null) { RemoveConnection(server); return(new ConnectionErrorResult()); } return(new SuccessResult()); }
public async void RecordTransaction(UserTransaction userTransaction, RechargeRequestResource rechargeRequestResource) { userTransaction.DateCreated = DateTime.Now; userTransaction.TransactionFee = 2 * transactionFee; userTransaction.UserPoint = PointFunctions.GetBonus(userTransaction.Amount); userTransaction.AdditionalInformation = rechargeRequestResource.AdditionalInformation(); if (userTransaction.User.RefererId != null) { RecordReferersTransaction(userTransaction); } userTransaction.Balance = userTransaction.UserPoint + await GetUsersPoint(userTransaction.User.Id.ToString()); _context.Add(userTransaction); // var Transaction = new UserTransaction() { // UserId = e.User.Id, // RefererId = e.User.RefererId, // Amount = e.Transaction.Amount, // // Points = Functions.GetBonus(e.Transaction.amount), // // RefererPoint = Functions.GetBonus(e.Transaction.amount, false), // // PaymentType = e.Transaction.PaymentType(), // AdditionalInformation = e.Transaction.AdditionalInformation(), // DateCreated = DateTime.Now, // TransactionFee = .015m * e.Transaction.Amount // }; // _context.Add(Transaction); // if(!await _context.SaveAll()){ // throw new Exception("Failed to save transaction"); // } // RecordPublicTransaction(_mapper.Map<UserTransaction, PublicPaymentTransaction>(Transaction), e.User); }
public void DeleteUserTransaction(UserTransactionDTO transaction) { UserTransaction t = db.UserTransactions.GetById(transaction.Id); db.UserTransactions.Delete(t); db.Save(); }
private void InsertUpdateDataAndSendMail(UserTransaction usertransaction, SupportDetail supportdetail, IEmailQueueService _emailservice) { supportdetail.SupportRequest.OrderDetail.OrderStatusID = (int)OrderStatus.REFUNDED; var _usertransaction = DependencyResolver.Current.GetService <IRepository <UserTransaction> >(); usertransaction.AuditDetails = new Audit(); usertransaction.AuditDetails = supportdetail.AuditDetails; usertransaction.OrderDetail = supportdetail.SupportRequest.OrderDetail; usertransaction.OrderDetailID = supportdetail.SupportRequest.OrderDetail.ID; usertransaction.RefundRequest = supportdetail.SupportRequest; usertransaction.RefundRequestID = supportdetail.SupportRequest.ID; usertransaction.SiteID = Site.ID; usertransaction.TransactionModeID = (int)TransactionMode.REFUND; usertransaction.UserID = supportdetail.SupportRequest.UserID; _usertransaction.Add(usertransaction); _service.Add(supportdetail); _unitOfWork.Commit(); usertransaction.OrderDetail.InvoiceNumber = InvoicePrefix + usertransaction.OrderDetail.OrderID; if (usertransaction.User.UserType == UserType.RESELLER) { _emailservice.PrepareEmailQueue(Site.ID, LangID, EmailType.RESELLER_REFUND_NOTIFICATION, SMTPID, usertransaction.User.Email, usertransaction); } else { _emailservice.PrepareEmailQueue(Site.ID, LangID, EmailType.CUSTOMER_REFUND_NOTIFICATION, SMTPID, usertransaction.User.Email, usertransaction); } _emailservice.PrepareEmailQueue(Site.ID, LangID, EmailType.ADMIN_REFUND_NOTIFICATION, SMTPID, SiteAdminEmail, supportdetail); _unitOfWork.Commit(); }
public async Task <HttpResponseMessage> AddCashIn(HttpRequestMessage reqObject) { _requestedDataObjectAsync = _IDataManipulation.GetRequestedDataObjectAsync(reqObject); string result = string.Empty; _UserTransaction = new UserTransaction(); _UserTransaction = await Task.Factory.StartNew(() => JsonConvert.DeserializeObject <UserTransaction>(_requestedDataObjectAsync.Result.BusinessData)); result = await _ICashInService.AddCashIn(_UserTransaction); // more code here... //return result; if (result != null) { _serviceResponse = await _IDataManipulation.SetResponseObjectAsync(1, "Cash In successfully. Your transaction id " + result); } else { _serviceResponse = await _IDataManipulation.SetResponseObjectAsync(0, "Data Not Found..."); } _response = await _IDataManipulation.CreateResponseAsync(_serviceResponse, reqObject); return(_response); }
protected void btnContinue_Click(object sender, EventArgs e) { if (IsValid) { int userid, usertype; string username = ViewState[Constant.SESSION_USERNAME].ToString(); int.TryParse(ViewState[Constant.SESSION_USERID].ToString(), out userid); int.TryParse(ViewState[Constant.SESSION_USERTYPE].ToString(), out usertype); // change password if (UserTransaction.ChangePasswordAndAuthenticate(connstring, userid, EncryptionHelper.Encrypt(txtConfirmPwd.Text.Trim()), true, username)) { // store session values Session[Constant.SESSION_USERID] = ViewState[Constant.SESSION_USERID]; Session[Constant.SESSION_USERNAME] = ViewState[Constant.SESSION_USERNAME]; Session[Constant.SESSION_USERTYPE] = ViewState[Constant.SESSION_USERTYPE]; Session[Constant.SESSION_USEREMAIL] = ViewState[Constant.SESSION_USEREMAIL]; Session[Constant.SESSION_USERFULLNAME] = ViewState[Constant.SESSION_USERFULLNAME]; UpdateUserLoginStatus(Session[Constant.SESSION_USERID].ToString(), 1, Session.SessionID.ToString()); Session["SesId"] = GetSessionId(); // redirect user RedirectUser(Session[Constant.SESSION_USERNAME].ToString(), int.Parse(Session[Constant.SESSION_USERTYPE].ToString())); } } }
public IActionResult Success() { string sessionUser = HttpContext.Session.GetString("email"); if (sessionUser is null) { return(RedirectToAction("Index")); } ViewBag.Email = HttpContext.Session.GetString("email"); ViewBag.userFlag = "true"; // get the list of users User userInfo = dbContext.Users .Include(u => u.Transactions) .SingleOrDefault(u => u.Email == HttpContext.Session.GetString("email")); // sort based on the child - transaction userInfo.Transactions = userInfo.Transactions .OrderByDescending(u => u.CreatedAt) .ToList(); UserTransaction ut = new UserTransaction(); ut.user = userInfo; return(View("Success", ut)); }
public async Task <bool> AddTransaction(User user, TransactionType type, int oldPoints, string promoCode, string catgoryId, string rewardRedeemed) { var transaction = new UserTransaction() { UserEmail = user.Email, Type = type.ToString(), UserId = user.Id, NewPointsBalance = user.Points, OldPointsBalance = oldPoints, Points = Math.Abs(user.Points - oldPoints), PromoCode = promoCode, CategoryId = catgoryId, RewardRedeemed = rewardRedeemed }; try { _context.Add(transaction); return(await _context.SaveChangesAsync() > 0); } catch (Exception ex) { return(false); } }
public void LoadRows() { using (MedicineDB db = new MedicineDB()) { UserTransaction trans1 = new UserTransaction { Quantity = 10, CreatedByDate = new DateTime(2018, 04, 20), // CreatedByUser = new AppUser { Name = "Person1" }, // ModifiedByUser = new AppUser { Name = "Person2" }, Med = new Medication { Description = "Description One", AlertThreshold = 5 } }; UserTransaction trans2 = new UserTransaction { Quantity = 10, CreatedByDate = new DateTime(2018, 06, 10), // CreatedByUser = new AppUser { Name = "Person3" }, // ModifiedByUser = new AppUser { Name = "Person4" }, Med = new Medication { Description = "Description Two", AlertThreshold = 6 } }; db.UserTransactions.Add(trans1); db.UserTransactions.Add(trans2); db.SaveChanges(); } }
public HttpResponseMessage DailyCashIn(HttpRequestMessage reqObject) { string walletaccNo = string.Empty; UserTransaction _UserTransaction = new UserTransaction(); //_businessData = _IDataManipulation.GetBusinessData(reqObject); _requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject); if (_requestedDataObject != null && _requestedDataObject.BusinessData != null) { _UserTransaction = JsonConvert.DeserializeObject <UserTransaction>(_requestedDataObject.BusinessData); walletaccNo = _UserTransaction.WalletAccountNo; } var result = _ICashInService.DailyCashIn(_UserTransaction); if (result != null) { _serviceResponse = _IDataManipulation.SetResponseObject(result, "information has been fetched successfully"); } else { _serviceResponse = _IDataManipulation.SetResponseObject(result, "Data Not Found..."); } _response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject); return(_response); }
protected void PostButton_Click(object sender, EventArgs e) { if (CommentBox.Text.Trim() != string.Empty) { DataTable dtComments = null; DataView dvComments = null; int userType = Int32.Parse(hdnUserType.Value.ToString().Trim()), bidRefno = Int32.Parse(hdnBidRefNo.Value.ToString().Trim()), tenderStat = Int32.Parse(hdnTenderStat.Value.Trim()), userID = Int32.Parse(hdnUserID.Value.Trim()); if (CommentBox.Text.Trim().Length > 0) { UserTransaction.InsertTenderComments(connstring, userType, userID, bidRefno, tenderStat, CommentBox.Text.Trim()); hdnIsPosted.Value = "1"; dtComments = UserTransaction.QueryTenderCommentsbyRefNoAndStatus(connstring, userType, bidRefno, tenderStat); dvComments = new DataView(dtComments); gvCommentArea.DataSource = dvComments; gvCommentArea.DataBind(); CommentBox.Text = ""; } } }
private async void RecordReferersTransaction(UserTransaction userTransaction) { var referTransaction = _mapper.Map <UserTransaction>(userTransaction); referTransaction.TransactionFee = 1 * transactionFee; referTransaction.UserPoint = PointFunctions.GetBonus(userTransaction.Amount, false); referTransaction.Amount = 0.0m; referTransaction.User = userTransaction.User.Referer; referTransaction.Transactions = new List <AppTransaction>(); referTransaction.AdditionalInformation = null; referTransaction.Balance = referTransaction.UserPoint + await GetUsersPoint(userTransaction.User.Id.ToString()); _context.Add(referTransaction); // _context.Add(transaction); // var publicTransactions = _repo.PublicPaymentTransactions.Where(u => u.UserId == user.Id); // var count = await publicTransactions.CountAsync(); // if(count > maxCount + 1) { // // var newPublicTransactions = publicTransactions.OrderByDescending(d => d.DateCreated).Take(maxCount); // var mergePublicTransactions = publicTransactions.OrderByDescending(d => d.DateCreated).TakeLast(count - maxCount); // var newPublicTransactions = new PublicPaymentTransaction(){ // DateCreated = DateTime.MinValue // }; // foreach (var trans in mergePublicTransactions) // { // newPublicTransactions.Points += trans.Points; // newPublicTransactions.RefererPoint += trans.RefererPoint; // newPublicTransactions.Amount += trans.Amount; // } // _context.Delete(mergePublicTransactions); // _context.Add(newPublicTransactions); // } }
public UserTransaction GetTransaction(UserTransaction transaction) { return(SendFunc <UserTransaction, ICommonNetReceiverForProxy>( api => api.GetTransaction(transaction), e => null, NetLogHelper.GetLog(transaction))); }
public bool UpdatePajakUserTransaction(string username, string nop, DateTime tanggal, double pajak) { bool result = true; using (var transaction = _dataManager.BeginTransaction()) { try { UserTransaction userTransaction = _dataManager.GetOne <UserTransaction>((e => e.Username == username && e.Nop == nop && e.Tanggal == tanggal && e.Is_Adjusment == false)); if (userTransaction == null) { return(false); } else { userTransaction.Pajak_Terutang = pajak; _dataManager.Update(userTransaction); _dataManager.Save(); transaction.Commit(); } } catch (Exception) { result = false; transaction.Rollback(); } } return(result); }
public IActionResult CreateOrder(LinkOrder linkOrder) { if (ModelState.IsValid) { if (signInManager.IsSignedIn(User) == true) { SignedUserName = User.Identity.Name; user = dbContext.CustomUsers.FirstOrDefault(x => x.UserName == SignedUserName); //===================== GETS THE BALANCE OF SIGNED USER var userBalance = dbContext.Balances.FirstOrDefault(x => x.DbPassportUserModelId == user.Id); userBalance.TLBalance -= linkOrder.ProductPrice; dbContext.SaveChanges(); //==================== ADDS TRANSACTION WHEN MONEY IS SPENT UserTransaction userTransaction = new UserTransaction() { TransactionType = 2, //================ 1 for medaxil, 2 for mexaric Amount = linkOrder.ProductPrice, CurrencyType = 2, //=================== 1 for azn, 2 for try, Date = DateTime.Now, DbPassportUserModel = user }; dbContext.Transactions.Add(userTransaction); dbContext.SaveChanges(); LinkOrder dbLinkOrder = new LinkOrder() { OrderLink = linkOrder.OrderLink, ProductPrice = linkOrder.ProductPrice, ProductAmount = linkOrder.ProductAmount, OrderComment = linkOrder.OrderComment, DeliveryAddress = linkOrder.DeliveryAddress, PaymentMethod = linkOrder.PaymentMethod, DbPassportUserModel = user, OrderDate = DateTime.Now, OrderStatus = 10 }; if (dbContext.Orders.Count() > 0) { dbLinkOrder.OrderNumber = dbContext.Orders.Max(x => x.OrderNumber) + 1; } else { dbLinkOrder.OrderNumber = 1; } dbContext.Orders.Add(dbLinkOrder); dbContext.SaveChanges(); return(Json(new { redirectUrl = Url.Action("Index", "PanelPage") })); } } return(RedirectToAction("Index", "MakeOrder")); }
public ActionResult DeleteConfirmed(int id) { UserTransaction userTransaction = db.UserTransactions.Find(id); db.UserTransactions.Remove(userTransaction); db.SaveChanges(); return(RedirectToAction("Index")); }
public UserRecordsController() { this.userTransaction = new UserTransaction(); this._noteBO = new NoteBusinessObject(); this._weightMultiplierBO = new WeightMultiplierBusinessObject(); this.model = new UserTransactionViewModel(); this.analysis = new AnalysisBusinessObject(); }
public int SaveUserTransaction(UserTransaction objsavetransation) { var rng = new Random(); var list = _BAO.SaveUserTransaction(objsavetransation.id, objsavetransation.UserId, objsavetransation.Templateid, objsavetransation.LastVersion, objsavetransation.CurrentVersion, objsavetransation.ModifiedDate); return(list); }
public void EditUserTransaction(UserTransactionDTO transaction) { UserTransaction utdb = db.UserTransactions.GetById(transaction.Id); utdb.Description = transaction.Description; utdb.Sum = transaction.Sum; db.UserTransactions.Update(utdb); db.Save(); }
protected void PostButton_Click(object sender, EventArgs e) { if (CommentBox.Text.Trim() != string.Empty) { UserTransaction commentDetails = new UserTransaction(); DataTable dtComments = null; DataView dvComments = null; if (ViewState[Constant.SESSION_COMMENT_TYPE] != null) { if (Int32.Parse(ViewState[Constant.SESSION_COMMENT_TYPE].ToString().Trim()) == 0) { if ((ViewState[Constant.SESSION_BIDREFNO] != null) && (ViewState[Constant.SESSION_USERID] != null) && (ViewState[Constant.SESSION_USERTYPE] != null) && (ViewState[Constant.SESSION_USERID].ToString() != "")) { if (ViewState[Constant.SESSION_BIDREFNO].ToString().Trim() != "") { commentDetails.InsertItemComments(ViewState[Constant.SESSION_BIDREFNO].ToString().Trim(), CommentBox.Text, ViewState[Constant.SESSION_USERID].ToString().Trim(), Int32.Parse(ViewState[Constant.SESSION_USERTYPE].ToString().Trim()), false); hdnIsPosted.Value = "1"; dtComments = commentDetails.QueryItemCommentsbyRefNo(ViewState[Constant.SESSION_BIDREFNO].ToString().Trim(), false); dvComments = new DataView(dtComments); } } } else { if ((ViewState[Constant.SESSION_AUCTIONREFNO] != null) && (ViewState[Constant.SESSION_USERID] != null) && (ViewState[Constant.SESSION_USERTYPE] != null) && (ViewState[Constant.SESSION_USERID].ToString() != "")) { if (ViewState[Constant.SESSION_AUCTIONREFNO].ToString().Trim() != "") { commentDetails.InsertItemComments(ViewState[Constant.SESSION_AUCTIONREFNO].ToString().Trim(), CommentBox.Text, ViewState[Constant.SESSION_USERID].ToString().Trim(), Int32.Parse(ViewState[Constant.SESSION_USERTYPE].ToString().Trim()), true); hdnIsPosted.Value = "1"; dtComments = commentDetails.QueryItemCommentsbyRefNo(Session[Constant.SESSION_AUCTIONREFNO].ToString().Trim(), true); dvComments = new DataView(dtComments); } } } } if (dvComments != null) { gvCommentArea.DataSource = dvComments; gvCommentArea.DataBind(); CommentBox.Text = ""; } } }
[HttpPost] // Добавление нового расхода public ActionResult <UserTransaction> Post(UserTransaction transaction) { transaction.Type = "cost"; if (transaction == null) { return(BadRequest()); } repos.AddTransaction(transaction); return(Ok(repos.GetLastCost())); }
public async Task InsertAsync(UserTransaction tran) { const string sql = @"INSERT INTO [dbo].[UserTransactions]([Id],[AccountId],[CryptoId],[CryptoCode],[Type],[DetailId],[Status],[Timestamp],[Amount],[OrderNo],[MerchantName]) VALUES (@Id,@AccountId,@CryptoId,@CryptoCode,@Type,@DetailId,@Status,@Timestamp,@Amount,@OrderNo,@MerchantName)"; using (var conn = await WriteConnectionAsync()) { await conn.ExecuteAsync(sql, tran); } }
protected virtual void OnTransactionMade(UserTransaction userTransaction) { if (transactionMade != null) { transactionMade(this, new CustomTransactionEventArgs() { UserTransaction = userTransaction }); } }
public async Task CheckTicket(AppUser user) { bool flag = false; string pendingFlag = ""; var check = await _context.UserBet.Where(x => x.User.Id == user.Id).FirstOrDefaultAsync(); var userBets = _context.UserBet.Where(t => t.Win == "Pending" && t.User == user).Include(x => x.BetMatches).ToList(); if (check != null) { if (userBets.Count > 0) { { foreach (var item in userBets) { pendingFlag = null; foreach (var match in item.BetMatches) { if (match.Win == "Lose") { item.Win = "Lose"; _context.Update(item); _context.SaveChanges(); break; } else if (match.Win == "Win") { flag = true; } else if (match.Win == "Pending") { pendingFlag = "Pending"; } } if (flag == true && String.IsNullOrEmpty(pendingFlag)) { item.Win = "Win"; _context.Update(item); var wallet = await _context.Wallet.Where(u => u.User.Id == user.Id).FirstOrDefaultAsync(); wallet.Saldo += item.CashOut; UserTransaction transaction = new UserTransaction(); transaction.UserId = wallet.User.Id; transaction.Payment = item.CashOut.ToString(); transaction.Transactions = "Isplata dobitka u iznosu od " + item.CashOut + " kn " + " " + DateTime.Now.ToString(); _context.Update(wallet); _context.Update(transaction); await _context.SaveChangesAsync(); } } } } } }
public void AddTransaction(string user, UserTransactionDTO ut) { UserTransaction utdb = new UserTransaction { Id = db.UserTransactions.GetLastUsedUserTransactionId() + 1, Date = ut.Date, User = db.Users.GetUserByLogin(user), Description = ut.Description, Sum = ut.Sum }; db.UserTransactions.Create(utdb); db.Save(); }