Example #1
0
    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;
 }
Example #3
0
        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());
     }
 }
Example #5
0
        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"));
        }
Example #6
0
    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);
                }
            }
        }
    }
Example #7
0
        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();
        }
Example #10
0
        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);
        }
Example #12
0
    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()));
            }
        }
    }
Example #13
0
        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));
        }
Example #14
0
        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);
        }
Example #17
0
    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);
            // }
        }
Example #19
0
 public UserTransaction GetTransaction(UserTransaction transaction)
 {
     return(SendFunc <UserTransaction, ICommonNetReceiverForProxy>(
                api => api.GetTransaction(transaction),
                e => null,
                NetLogHelper.GetLog(transaction)));
 }
Example #20
0
        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);
        }
Example #21
0
        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"));
        }
Example #23
0
 public UserRecordsController()
 {
     this.userTransaction     = new UserTransaction();
     this._noteBO             = new NoteBusinessObject();
     this._weightMultiplierBO = new WeightMultiplierBusinessObject();
     this.model    = new UserTransactionViewModel();
     this.analysis = new AnalysisBusinessObject();
 }
Example #24
0
        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();
        }
Example #26
0
    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 = "";
            }
        }
    }
Example #27
0
 [HttpPost] // Добавление нового расхода
 public ActionResult <UserTransaction> Post(UserTransaction transaction)
 {
     transaction.Type = "cost";
     if (transaction == null)
     {
         return(BadRequest());
     }
     repos.AddTransaction(transaction);
     return(Ok(repos.GetLastCost()));
 }
Example #28
0
        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);
            }
        }
Example #29
0
 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();
 }