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()); }
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"); }
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)); }
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); } }
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); }
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 = "پرداخت شده"; } } } } }
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); } }
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 = "فایلی برای دانلود وجود ندارد"; } } }
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"); } }
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); }
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); }
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(); }
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; } } }