示例#1
0
        public async void GetTasksForUser()
        {
            var adduser = new UserAdd()
            {
                Email = Guid.NewGuid().ToString()
            };


            var userTrans = new UserTransactions();
            var userView  = new UserViews();


            var user = await userTrans.Add(adduser);

            for (int i = 0; i < 10; i++)
            {
                var taskTrans = new TaskTransactions();
                await taskTrans.Add(new TaskAdd()
                {
                    Name = Guid.NewGuid().ToString(), UserUserId = user.UserId, CompletedDate = new DateTime(1900, 1, 1), DueDate = DateTime.Now.AddDays(30), StartedDate = DateTime.Now
                });
            }

            var taskviews = new TaskViews();

            var tasks = await taskviews.GetTasksForUser(user.UserId);

            tasks.Should().HaveCount(10);
            user.Tasks.Should().HaveCount(10);

            var first = user.Tasks.First();

            user.Tasks.First().User.UserId.Should().Be(user.UserId);
        }
        // GET /api/transactions/0.023
        /// <summary>
        /// API that verifies a deposit
        /// </summary>
        /// <param name="amount">Amount of Transaction</param>
        /// <returns>A Message</returns>
        public string GetTransactions(string amount)
        {
            // Create a Transaction Object
            UserTransactions transaction = new UserTransactions(amount);

            return(transaction.getResponseString());
        }
示例#3
0
        public async void UpdateUserTest()
        {
            var adduser = new UserAdd()
            {
                Email = Guid.NewGuid().ToString()
            };


            var userTrans = new UserTransactions();
            var userView  = new UserViews();


            var user = await userTrans.Add(adduser);

            var updateuser = new UserUpdate()
            {
                UserId = user.UserId, Email = user.Email, FirstName = "Daniel"
            };

            await userTrans.Update(updateuser);

            var userview = await userView.Get(user.UserId);

            user.UserId.Should().Be(userview.UserId);
            user.Email.Should().Be(userview.Email);
            userview.FirstName.Should().Be("Daniel");
        }
示例#4
0
        public IActionResult Transact([Bind] UserTransactions usrTrans, [FromQuery(Name = "type")] string type)
        {
            if (type == "deposit")
            {
                usrTrans.TransType = "Deposit";
            }
            else if (type == "withdrawal")
            {
                usrTrans.TransType = "Withdrawal";
            }
            else if (type == "fundtransfer")
            {
                usrTrans.TransType = "Fund Transfer";
            }
            else
            {
                usrTrans.TransType = "";
                return(StatusCode(404));
            }
            usrTrans.AccountNumber = _userManager.GetCurrentUser(this.HttpContext).AccountNumber;
            usrTrans.TransBy       = _userManager.GetCurrentUser(this.HttpContext).AccountNumber;
            //usrTrans.TransType = "Deposit";
            usrTrans.TransDate = DateTime.Now;
            usrTrans.ID        = _userManager.GetCurrentUser(this.HttpContext).ID;
            usrTrans.Balance   = _userManager.GetCurrentUser(this.HttpContext).Balance;

            if (ModelState.IsValid)
            {
                _repo.InsertUserTransactions(usrTrans);
                return(RedirectToAction("Index", "UserTransactions", new { id = usrTrans.ID }));
            }
            return(View(usrTrans));
        }
示例#5
0
        public IActionResult Transact(string ID, string type)
        {
            string transType = "";

            if (type == "deposit")
            {
                transType = "Deposit";
            }
            else if (type == "withdrawal")
            {
                transType = "Withdrawal";
            }
            else if (type == "fundtransfer")
            {
                transType = "Fund Transfer";
            }
            else
            {
                transType = "";
                return(StatusCode(404));
            }
            var model = new UserTransactions
            {
                ID        = _userManager.GetCurrentUser(this.HttpContext).ID,
                Balance   = _userManager.GetCurrentUser(this.HttpContext).Balance,
                TransType = transType
            };

            return(View(model));
        }
    protected void DoSave(object sender, EventArgs e)
    {
        try
        {
            BOLUserBuys UserBuysBOL = new BOLUserBuys(1);
            UserBuys    CurUserBuy  = ((IBaseBOL <UserBuys>)UserBuysBOL).GetDetails((int)Code);

            BOLUserTransactions UserTransactionsBOL = new BOLUserTransactions(1);
            UserTransactions    CurTransaction      = ((IBaseBOL <UserTransactions>)UserTransactionsBOL).GetDetails(CurUserBuy.TransactionCode);

            string Authority        = txtAuthority.Text;
            string BankName         = txtBankName.Text;
            string BankState        = txtBankState.Text;
            string Comment          = txtComment.Text;
            string DigitalSignature = txtDigitalSignature.Text;
            string FishNo           = txtFishNo.Text;
            string UserIP           = txtUserIP.Text;
            int?   NullVal          = null;

            int?BankCode          = cboBankCode.SelectedValue == "" ? NullVal : Convert.ToInt32(cboBankCode.SelectedValue);
            int?ChargeTypeCode    = cboChargeTypeCode.SelectedValue == "" ? NullVal : Convert.ToInt32(cboChargeTypeCode.SelectedValue);
            int?HCTransStatusCode = cboHCTransStatusCode.SelectedValue == "" ? NullVal : Convert.ToInt32(cboHCTransStatusCode.SelectedValue);

            DateTime?ChargeDate = dteChargeDate.SelectedDateChristian;
            DateTime?PayDate    = dtePayDate.SelectedDateChristian;

            UserTransactionsBOL.UpdateTrans(CurUserBuy.TransactionCode, Authority, BankName, BankState, Comment, DigitalSignature,
                                            FishNo, UserIP, BankCode, ChargeTypeCode, HCTransStatusCode, ChargeDate, PayDate);

            //Tools.CloseWin(Page, Master, BaseID, ViewState["InstanceName"].ToString());
        }
        catch
        {
        }
    }
        // GET /api/transactions/
        /// <summary>
        /// API that verifies a deposit. FOR TEST ONLY
        /// </summary>
        /// <returns></returns>
        public string GetTransactions()
        {
            // Create a Transaction Object
            UserTransactions transaction = new UserTransactions();

            // Return data
            return(transaction.getResponseString());
        }
        public ReturnData GetTransactions(string email)
        {
            ReturnData rd = new ReturnData();

            try
            {
                var user_Transaction_Master = (from s in db.User_Transaction_Master.Include(u => u.Rate_Card)
                                               .Include(u => u.User_Profile).Where(u => u.User_Profile.EmailAddress == email)
                                               .Where(s => s.Status == "Active")
                                               select s).ToList();

                if (user_Transaction_Master.Count <= 0)
                {
                    rd.Status     = "Failure";
                    rd.Message    = "No Transaction Found";
                    rd.Requestkey = "GetTransactions";
                    return(rd);
                }

                List <UserTransactions> transactionList = new List <UserTransactions>();

                for (int i = 0; i < user_Transaction_Master.Count; i++)
                {
                    UserTransactions cm = new UserTransactions();
                    cm.Id             = Convert.ToDecimal(user_Transaction_Master[i].Id);
                    cm.FirstName      = user_Transaction_Master[i].User_Profile.FirstName;
                    cm.LastName       = user_Transaction_Master[i].User_Profile.LastName;
                    cm.Rate_ID        = user_Transaction_Master[i].Rate_ID;
                    cm.PlanID         = user_Transaction_Master[i].PlanID;
                    cm.PlanName       = user_Transaction_Master[i].Plan_Master.Plan;
                    cm.User_ID        = user_Transaction_Master[i].User_ID;
                    cm.Amount         = user_Transaction_Master[i].Amount;
                    cm.Start_Date     = user_Transaction_Master[i].Start_Date;
                    cm.End_Date       = user_Transaction_Master[i].End_Date;
                    cm.Payment_Status = user_Transaction_Master[i].Payment_Status;
                    cm.Transection_ID = user_Transaction_Master[i].Transection_ID;
                    cm.Status         = user_Transaction_Master[i].Status;
                    cm.Payment_Date   = user_Transaction_Master[i].Payment_Date;
                    cm.Invoice_No     = user_Transaction_Master[i].Invoice_No;
                    cm.Payment_Method = user_Transaction_Master[i].Payment_Method;
                    transactionList.Add(cm);
                    rd.Transactions = transactionList;
                }

                rd.Status     = "Success";
                rd.Message    = "Transaction List";
                rd.Requestkey = "GetTransactions";
                return(rd);
            }
            catch (Exception)
            {
                rd.Status     = "Failure";
                rd.Message    = "Something went wrong. Please try after some time.";
                rd.Requestkey = "GetTransactions";
                return(rd);
            }
        }
示例#9
0
        public static void VerifyUserTransactions(
            UserTransactions toVerify,
            ExchangeType source,
            TradingPair pair)
        {
            ResponseVerification.VerifyApiResult(toVerify, source);

            Assert.IsNotNull(toVerify.TransactionsCollection);

            CollectionAssert.IsNotEmpty(toVerify.TransactionsCollection);
            CollectionAssert.AllItemsAreNotNull(toVerify.TransactionsCollection);
            CollectionAssert.AllItemsAreInstancesOfType(toVerify.TransactionsCollection, typeof(UserTransaction));
            CollectionAssert.AllItemsAreUnique(toVerify.TransactionsCollection);
            CollectionAssert.DoesNotContain(toVerify.TransactionsCollection, default(UserTransaction));
            CollectionAssert.AreEqual(toVerify.TransactionsCollection,
                                      new List <UserTransaction>(toVerify.TransactionsCollection).OrderByDescending(x => x.UnixTimeStamp));

            foreach (var transaction in toVerify.TransactionsCollection)
            {
                ResponseVerification.VerifyApiResult(transaction, source);

                Assert.That(transaction.Pair == pair);

                Assert.That(transaction.CompletedTime.Kind == DateTimeKind.Utc);

                // Check that correct sign is used
                if (transaction.TransactionType == OrderType.Sell)
                {
                    Assert.Less(transaction.BaseCurrencyAmount, 0);
                    Assert.Greater(transaction.CounterCurrencyAmount, 0);
                }
                else
                {
                    Assert.Greater(transaction.BaseCurrencyAmount, 0);
                    Assert.Less(transaction.CounterCurrencyAmount, 0);
                }

                Assert.Greater(transaction.ExchangeRate, 0);

                // Check that transaction balances

                Assert.That(
                    Math.Round(
                        (transaction.BaseCurrencyAmount * transaction.ExchangeRate)
                        + transaction.CounterCurrencyAmount, 2) == 0);

                // Trade Fee Currency belongs to Trading Pair
                Assert.That((transaction.Pair.BaseCurrency == transaction.TradeFeeCurrency)
                            ||
                            (transaction.Pair.CounterCurrency == transaction.TradeFeeCurrency));

                Assert.That(!string.IsNullOrEmpty(transaction.OrderId));
                Assert.That(transaction.TransactionId > 0);
            }
        }
        public List <UserTransactions> GetUserTransactionsByID(string ID)
        {
            List <UserTransactions> lstTrans = new List <UserTransactions>();

            using (SqlConnection con = new SqlConnection(connectionString))
            {
                try
                {
                    SqlCommand cmd = new SqlCommand("spUserTransactionsGetAll", con);
                    cmd.CommandType = CommandType.StoredProcedure;

                    cmd.Parameters.AddWithValue("@ID", ID);

                    con.Open();
                    SqlDataReader rdr = cmd.ExecuteReader();

                    while (rdr.Read())
                    {
                        UserTransactions usr = new UserTransactions();

                        usr.ID             = Convert.ToInt32(rdr["ID"]);
                        usr.AccountNumber  = rdr["AccountNumber"].ToString();
                        usr.Amount         = double.Parse(rdr["Amount"].ToString());
                        usr.RunningBalance = double.Parse(rdr["RunningBalance"].ToString());
                        usr.TransType      = rdr["TransType"].ToString();
                        usr.TransDate      = DateTime.Parse(rdr["TransDate"].ToString());
                        usr.TransBy        = rdr["TransBy"].ToString();
                        usr.Balance        = double.Parse(string.Format("{0:N2}", rdr["Balance"].ToString()));

                        lstTrans.Add(usr);
                    }
                    //con.Close();
                }
                catch
                {
                    UserTransactions usr = new UserTransactions();

                    usr.ID             = 0;
                    usr.AccountNumber  = null;
                    usr.Amount         = 0;
                    usr.RunningBalance = 0;
                    usr.TransType      = null;
                    usr.TransDate      = DateTime.Now;
                    usr.TransBy        = null;
                    usr.Balance        = 0;

                    lstTrans.Add(usr);
                }
                finally
                {
                    con.Close();
                }
            }
            return(lstTrans);
        }
示例#11
0
    protected void Page_Load(object sender, EventArgs e)
    {
        #region Tab Pages
        //if (!NewMode)
        //     ShowDetails();
        //else
        //{
        //     RadMultiPage1.SelectedIndex = 0;
        //     tsOrders.Tabs[0].Selected = true;
        //}
        #endregion
        BOLClass = new BOLOrders();
        //lblSysName.Text = BOLClass.PageLable;

        if ((Code == null) && (!NewMode))
        {
            return;
        }
        if (!Page.IsPostBack)
        {
            if (!NewMode)
            {
                ShowDetails();
            }


            #region Fill Combo
            cboHCGenderCode.DataSource      = new BOLHardCode().GetHCDataTable("HCGenders");
            cboHCSendTypeCode.DataSource    = new BOLHardCode().GetHCDataTable("HCSendTypes");
            cboHCOrderStatusCode.DataSource = new BOLHardCode().GetHCDataTable("HCOrderStatuses");
            cboHCPayMethodCode.DataSource   = new BOLHardCode().GetHCDataTable("HCPayMethods");

            #endregion
            if (!NewMode)
            {
                LoadData((int)Code);
                BOLOrders OrdersBOL           = new BOLOrders();
                Orders    CurOrder            = ((IBaseBOL <Orders>)OrdersBOL).GetDetails((int)Code);
                int?      UserTransactionCode = CurOrder.UserTransactionCode;
                if (UserTransactionCode != null)
                {
                    BOLUserTransactions UserTransactionsBOL = new BOLUserTransactions(1);
                    UserTransactions    CurTrans            = UserTransactionsBOL.GetDetails((int)UserTransactionCode);
                    if (CurTrans.HCTransStatusCode == 2)
                    {
                        lblPayStatus.Text = "پرداخت شده";
                    }
                }
            }
        }
    }
示例#12
0
    public int UpdateAuthority(int FactorNo, string Authority)
    {
        UserTransactions CurUserTrans = dataContext.UserTransactions.SingleOrDefault(p => p.Code.Equals(FactorNo));

        if (CurUserTrans != null)
        {
            CurUserTrans.Authority = Authority;
            dataContext.SubmitChanges();
            return(0);
        }
        else
        {
            return(-1);
        }
    }
示例#13
0
        protected void btnDownload_Click(object sender, EventArgs e)
        {
            if (ViewState["TransactionCode"] == null)
            {
                return;
            }

            int UserTransactionCode = Convert.ToInt32(ViewState["TransactionCode"]);

            BOLUserTransactions UserTransactionsBOL = new BOLUserTransactions(1);
            UserTransactions    CurTransaction      = UserTransactionsBOL.GetDetails(UserTransactionCode);

            if (CurTransaction.ItemType == "Booklet")
            {
                int         BookletCode = (int)CurTransaction.ItemCode;
                BOLBooklets BookletsBOL = new BOLBooklets();
                string      PDFFile     = BookletsBOL.GetPDFFile(BookletCode);
                if (!string.IsNullOrEmpty(PDFFile))
                {
                    StartDowload(CurTransaction.ItemType, PDFFile);
                }
                else
                {
                    msgBox.MessageTextMode = AKP.Web.Controls.Common.MessageMode.Error;
                    msgBox.Text            = "فایلی برای دانلود وجود ندارد";
                }
            }
            else if (CurTransaction.ItemType == "Exam")
            {
                int      ExamCode = (int)CurTransaction.ItemCode;
                BOLExams ExamsBOL = new BOLExams();
                string   PDFFile  = ExamsBOL.GetPDFFile(ExamCode);
                if (!string.IsNullOrEmpty(PDFFile))
                {
                    StartDowload(CurTransaction.ItemType, PDFFile);
                }
                else
                {
                    msgBox.MessageTextMode = AKP.Web.Controls.Common.MessageMode.Error;
                    msgBox.Text            = "فایلی برای دانلود وجود ندارد";
                }
            }
        }
示例#14
0
        public async Task Save()
        {
            try
            {
                var uv = new UserTransactions();

                if (UserView.UserId > 0)
                {
                    UserView = await uv.UserUpdate(this.GetUserUpdate());
                }
                else
                {
                    UserView = await uv.UserAdd(this.GetUserAdd());
                }
            }
            catch (Exception ex)
            {
                MessagingCenter.Send(this, "Save error");
            }
        }
示例#15
0
        public void InsertTrans_ReturnsOkObjectResult_WhenSuccess()
        {
            // Arrange
            var controller   = new UserTransactionsController(new UserManager(new UsersRepository()), new UsersRepository());
            var newUserTrans = new UserTransactions
            {
                AccountNumber = "123456789123456",
                Amount        = 100,
                TransType     = "Deposit",
                TransBy       = "123456789123456"
            };

            // Act
            var result = controller.InsertTrans(newUserTrans);

            // Assert
            var okResult = Assert.IsType <OkObjectResult>(result);

            Assert.Equal(200, okResult.StatusCode);
        }
示例#16
0
        public async void AddUserTest()
        {
            var adduser = new UserAdd()
            {
                Email = Guid.NewGuid().ToString()
            };


            var userTrans = new UserTransactions();
            var userView  = new UserViews();


            var user = await userTrans.Add(adduser);

            var userview = await userView.Get(user.UserId);


            user.UserId.Should().Be(userview.UserId);

            user.Email.Should().Be(userview.Email);
        }
示例#17
0
        public async void DeleteUserTest()
        {
            var adduser = new UserAdd()
            {
                Email = Guid.NewGuid().ToString()
            };


            var userTrans = new UserTransactions();
            var userView  = new UserViews();


            var user = await userTrans.Add(adduser);

            await userTrans.Delete(new UserDelete()
            {
                UserId = user.UserId
            });

            var userview = await userView.Get(user.UserId);


            userview.Should().BeNull();
        }
示例#18
0
        private void ComputeChartsDatapoints()
        {
            var globalGroups = BlockchainTransactions
                               .OrderBy(x => x.Timestamp.Date)
                               .GroupBy(x => x.Timestamp.Date);

            ChartValues <int>    dailyTransactions     = new ChartValues <int>();
            ChartValues <double> dailyCurrencyTraded   = new ChartValues <double>();
            ChartValues <double> dailyReceivedCurrency = new ChartValues <double>();
            ChartValues <double> dailySentCurrency     = new ChartValues <double>();

            Labels = new List <string>();

            foreach (var group in globalGroups)
            {
                dailyTransactions.Add(group.Count());

                double sum = 0;

                for (int i = 0; i < group.Count(); i++)
                {
                    Transaction t = group.ElementAt(i);

                    sum += t.Amount;
                }

                dailyCurrencyTraded.Add(Math.Round(sum, 4));

                Labels.Add(group.Key.ToString("yyyy.MM.dd"));
            }

            var dateGroups = UserTransactions
                             .OrderBy(x => Convert.ToDateTime(x.Timestamp).Date)
                             .GroupBy(x => Convert.ToDateTime(x.Timestamp).Date);

            foreach (var group in dateGroups)
            {
                double sumReceived = 0;
                double sumSent     = 0;

                for (int i = 0; i < group.Count(); i++)
                {
                    CustomTransaction ct = group.ElementAt(i);

                    if (ct.Recipient.Equals("You"))
                    {
                        sumReceived += ct.Amount;
                    }
                    else
                    {
                        sumSent += ct.Amount;
                    }
                }

                dailyReceivedCurrency.Add(Math.Round(sumReceived, 4));
                dailySentCurrency.Add(Math.Round(sumSent, 4));
            }

            DailyTransactions = new SeriesCollection()
            {
                new ColumnSeries()
                {
                    Title  = "Daily Global Transactions",
                    Values = dailyTransactions
                }
            };

            DailyCurrencyTraded = new SeriesCollection()
            {
                new ColumnSeries()
                {
                    Title  = "Daily Global BRC Traded",
                    Values = dailyCurrencyTraded
                }
            };

            DailyBalances = new SeriesCollection()
            {
                new StackedColumnSeries()
                {
                    Title  = "Received Currency",
                    Values = dailyReceivedCurrency
                },

                new StackedColumnSeries()
                {
                    Title  = "Sent Currency",
                    Values = dailySentCurrency
                }
            };
        }
        public void InsertUserTransactions(UserTransactions usrTrans)
        {
            using (SqlConnection con = new SqlConnection(connectionString))
            {
                try
                {
                    con.Open();
                    sqlTrans = con.BeginTransaction(IsolationLevel.RepeatableRead);
                    SqlCommand cmd = con.CreateCommand();
                    cmd.Transaction = sqlTrans;
                    //SqlCommand cmd = new SqlCommand("spUserTransactionsInsert", con, sqlTrans);
                    //cmd.CommandType = CommandType.StoredProcedure;

                    //cmd.Parameters.AddWithValue("@ID", usrTrans.ID.ToString());
                    //cmd.Parameters.AddWithValue("@AccountNumber", usrTrans.AccountNumber);
                    //cmd.Parameters.AddWithValue("@Amount", usrTrans.Amount);
                    //cmd.Parameters.AddWithValue("@TransType", usrTrans.TransType);
                    //cmd.Parameters.AddWithValue("@TransDate", usrTrans.TransDate);
                    //cmd.Parameters.AddWithValue("@TransBy", usrTrans.TransBy);
                    cmd.Parameters.AddWithValue("@AccountNumber", usrTrans.AccountNumber);

                    cmd.Parameters.AddWithValue("@TransType", usrTrans.TransType);
                    cmd.Parameters.AddWithValue("@TransDate", usrTrans.TransDate);
                    cmd.Parameters.AddWithValue("@TransBy", usrTrans.TransBy);
                    cmd.Parameters.AddWithValue("@ID", usrTrans.ID.ToString());
                    if (usrTrans.TransType == "Deposit")
                    {
                        cmd.Parameters.AddWithValue("@Amount", usrTrans.Amount);
                    }
                    else
                    {
                        cmd.Parameters.AddWithValue("@Amount", usrTrans.Amount * -1);
                    }

                    cmd.CommandText = "Insert into Transactions(AccountNumber,Amount, TransType, TransDate, TransBy)" +
                                      "Values (@AccountNumber,@Amount,@TransType, @TransDate,@TransBy)";
                    cmd.ExecuteNonQuery();

                    if (usrTrans.TransType == "Fund Transfer")
                    {
                        cmd.CommandText = "Insert into Transactions(AccountNumber,Amount, TransType, TransDate, TransBy)" +
                                          "Values (@AccountNumber,@Amount * -1,@TransType, @TransDate,@TransBy)";
                        cmd.ExecuteNonQuery();

                        cmd.CommandText = "Update Users set Balance = Balance + @Amount  where AccountNumber = @TransBy";
                        cmd.ExecuteNonQuery();

                        cmd.CommandText = "Update Users set Balance = Balance + (@Amount * -1)  where ID = @ID";
                        cmd.ExecuteNonQuery();
                    }
                    else
                    {
                        cmd.CommandText = "Update Users set Balance = Balance + @Amount where ID = @ID";
                        cmd.ExecuteNonQuery();
                    }
                    sqlTrans.Commit();
                }
                catch
                {
                    if (sqlTrans != null)
                    {
                        sqlTrans.Rollback();
                    }
                }
                finally
                {
                    con.Close();
                }
            }
        }
    protected void Page_Load(object sender, EventArgs e)
    {
        Code = Convert.ToInt32(Request["Code"]);
        //BOLClass = new BOLUserBuys(1);

        //MasterFieldName = "TransactionCode";
        //Label MasterPageTitle = (Label)Master.FindControl("lblTitle");
        //MasterPageTitle.Text = BOLClass.PageLable;

        //if (MasterCode == null)
        //    throw new Exception("No MasterCode Exception");
        //if ((Code == null) && (!NewMode)) return;
        //if (!Page.IsPostBack)
        //{
        //    ViewState["InstanceName"] = Request["InstanceName"];
        Tools.SetClientScript(this, "ActiveTab1", "BrowseObj1.ShowDetail('UserBuyProducts', '" + Code + "',true,'BrowseObj1')");
        if (!Page.IsPostBack)
        {
            cboHCTransStatusCode.DataSource = new BOLHardCode().GetHCDataTable("HCUserTransStatuses");
            cboChargeTypeCode.DataSource    = new BOLHardCode().GetHCDataTable("HCChargeTypes");
            cboHCTransStatusCode.DataSource = new BOLHardCode().GetHCDataTable("HCUserTransStatuses");
            cboBankCode.DataSource          = new BOLHardCode().GetHCDataTable("HCBanks");

            //LoadData((int)Code);
            BOLUserBuys UserBuysBOL = new BOLUserBuys(1);
            UserBuys    CurUserBuy  = ((IBaseBOL <UserBuys>)UserBuysBOL).GetDetails((int)Code);

            BOLUserTransactions UserTransactionsBOL = new BOLUserTransactions(1);
            UserTransactions    CurTransaction      = ((IBaseBOL <UserTransactions>)UserTransactionsBOL).GetDetails(CurUserBuy.TransactionCode);
            if (CurTransaction != null)
            {
                txtAuthority.Text        = CurTransaction.Authority;
                txtBankName.Text         = CurTransaction.BankName;
                txtBankState.Text        = CurTransaction.BankState;
                txtComment.Text          = CurTransaction.Comment;
                txtDigitalSignature.Text = CurTransaction.DigitalSignature;
                txtFishNo.Text           = CurTransaction.FishNo;
                txtUserIP.Text           = CurTransaction.UserIP;

                if (CurTransaction.BankCode != null)
                {
                    cboBankCode.SelectedValue = CurTransaction.BankCode.ToString();
                }
                if (CurTransaction.HCPayMethodCode != null)
                {
                    cboChargeTypeCode.SelectedValue = CurTransaction.HCPayMethodCode.ToString();
                }
                cboHCTransStatusCode.SelectedValue = CurTransaction.HCTransStatusCode.ToString();

                if (CurTransaction.ChargeDate != null)
                {
                    dteChargeDate.SelectedDateChristian = CurTransaction.ChargeDate;
                }
                if (CurTransaction.PayDate != null)
                {
                    dtePayDate.SelectedDateChristian = CurTransaction.PayDate;
                }

                BOLUserBuyProducts UserBuyProductsBOL = new BOLUserBuyProducts((int)Code);
                DataTable          dtBuyProducts      = ((IBaseBOL <UserBuyProducts>)UserBuyProductsBOL).GetDataSource(new SearchFilterCollection(), "Code", 100, 1);
                int TotalAmount = 0;
                for (int i = 0; i < dtBuyProducts.Rows.Count; i++)
                {
                    int Amount   = Convert.ToInt32(dtBuyProducts.Rows[i]["Amount"]);
                    int Quantity = Convert.ToInt32(dtBuyProducts.Rows[i]["Quantity"]);
                    TotalAmount += (Amount * Quantity);
                }
                lblTotalAmount.Text = Tools.FormatCurrency(TotalAmount.ToString());
            }


            if (CurTransaction.UserCode != null)
            {
                pnlGuestUser.Visible = false;
            }
            else
            {
                txtFirstName.Text = CurUserBuy.FirstName;
                txtLastName.Text  = CurUserBuy.LastName;
                txtEmail.Text     = CurUserBuy.Email;
                txtPhone.Text     = CurUserBuy.Phone;
            }
        }
    }