Example #1
0
        public ActionResult Depositmore(Deposits deposit)
        {
            DataBase db = new DataBase(Settings.Default.ConStr);

            db.Deposit(deposit);
            return(Redirect("/"));
        }
        public void applyDeposit(HttpRequestMessage request)
        {
            string   ss = request.Content.ReadAsStringAsync().Result;
            Deposits ds = JsonConvert.DeserializeObject <Deposits>(ss);

            userservice.applyDeposit(ds);
        }
Example #3
0
        public IActionResult MakeDeposit(MondeyViewModel model)
        {
            if (ModelState.IsValid)
            {
                Deposits newDeposit = new Deposits
                {
                    amount     = double.Parse(model.amount, System.Globalization.CultureInfo.InvariantCulture),
                    created_at = DateTime.Now,
                    updated_at = DateTime.Now
                };
                Accounts currentAccount = _context.Accounts.SingleOrDefault(account => account.id == (int)HttpContext.Session.GetInt32("CurrentAccount"));
                currentAccount.Balance += newDeposit.amount;
                currentAccount.Deposits.Add(newDeposit);
                Users currentUser = _context.Users.SingleOrDefault(user => user.id == (int)HttpContext.Session.GetInt32("CurrUserId"));
                currentUser.Deposits.Add(newDeposit);
                _context.SaveChanges();
                return(RedirectToAction("goToDepositPage"));
            }
            List <string> errors = ModelState.Select(x => x.Value.Errors)
                                   .Where(y => y.Count > 0)
                                   .Select(z => z[0].ErrorMessage.ToString())
                                   .ToList();

            TempData["error_list"] = errors;
            return(RedirectToAction("goToDepositPage"));
        }
Example #4
0
 public void FillTestData(int n)
 {
     for (int i = 0; i < n; ++i)
     {
         var noImage = new Bitmap(Path.GetFullPath("image.png"));
         var rnd     = new Random();
         var dep     = new List <Product>();
         for (int j = 0; j < 3; ++j)
         {
             var     weight = rnd.Next(1000, 5000);
             Product A      = new Product()
             {
                 Name   = $"Product{j}",
                 Price  = (i + 1) * 10,
                 Type   = (j % 2 == 0) ? "золото" : "серебро",
                 Weight = weight,
                 Sample = 999,
                 Image  = noImage
             };
             Products.Add(A);
             dep.Add(A);
         }
         Client B = new Client()
         {
             Rank     = (i % 2 == 0) ? -6 : 7,
             Name     = $"Client{i}",
             Password = "******",
             Age      = rnd.Next(18, 60),
             Email    = $"Client{i}@gmail.com"
         };
         Clients.Add(B);
         Deposits.Add(new Deposit(dep, B, DateTime.Now + TimeSpan.FromDays(i), true));
         Deposits[i].Name = $"Deposit{i}";
     }
 }
Example #5
0
 private void btnSave_Click(object sender, EventArgs e)
 {
     if (txtName.Text.Trim() != string.Empty || txtAmount.Text.Trim() != string.Empty)
     {
         Deposits deposit = new Deposits()
         {
             Id          = expenseService.GetLastIdDeposits() + 1,
             Name        = txtName.Text.Trim(),
             Amount      = txtAmount.Text.Trim(),
             DepositedOn = DateTime.Now.ToShortDateString()
         };
         bool result = expenseService.AddNewDeposits(deposit);
         //save it to database
         if (result)
         {
             dgvResult.DataSource = expenseService.GetDeposits();
             dgvResult.Refresh();
             txtName.Text = txtAmount.Text = "";
         }
     }
     else
     {
         MessageBox.Show("Please check the Name and Amount", "Alert");
     }
 }
Example #6
0
        public void UpdateTables(Accounts model, int type, int change)
        {
            Transactions updateTransactions = new Transactions();

            updateTransactions.TransactionType = type;
            updateTransactions.AccountID       = model.AccountID;
            db.Transactions.Add(updateTransactions);

            if (type == 1)
            {
                Deposits updateDeposits = new Deposits();
                updateDeposits.TransactionID = updateTransactions.TransactionID;
                updateDeposits.Amount        = change;
                db.Deposits.Add(updateDeposits);
            }

            else
            {
                Withdrawls updateWithdrawals = new Withdrawls();
                updateWithdrawals.TransactionID = updateTransactions.TransactionID;
                updateWithdrawals.Amount        = change;
                db.Withdrawls.Add(updateWithdrawals);
            }

            db.SaveChanges();
        }
        public ActionResult Deposit(Deposits model)
        {
            TransactionService svc = new TransactionService();
            var account            = svc.MakeDeposit((Accounts)Session["CurrentUser"], (int)model.Amount);

            return(RedirectToAction("Details", account));
        }
Example #8
0
        public bool AddNewDeposits(Deposits deposit)
        {
            using (OleDbCommand oleDbCommand = new OleDbCommand())
            {
                // Set the command object properties
                oleDbCommand.Connection  = new OleDbConnection(this.ExpenseConnection);
                oleDbCommand.CommandType = CommandType.Text;
                oleDbCommand.CommandText = "Insert Into" +
                                           " [DepositDB$] (Id, Name, Amount, Deposited_On)" +
                                           " Values (@id, @name, @amount, @depositon)";// Scripts.sqlInsertExpense;

                // Add the input parameters to the parameter collection
                oleDbCommand.Parameters.AddWithValue("@id", deposit.Id);
                oleDbCommand.Parameters.AddWithValue("@name", deposit.Name);
                oleDbCommand.Parameters.AddWithValue("@amount", deposit.Amount);
                oleDbCommand.Parameters.AddWithValue("@depositon", deposit.DepositedOn);

                // Open the connection, execute the query and close the connection
                oleDbCommand.Connection.Open();
                var rowsAffected = oleDbCommand.ExecuteNonQuery();
                oleDbCommand.Connection.Close();

                return(rowsAffected > 0);
            }
        }
Example #9
0
        public ActionResult Deposit(Deposits deposit)
        {
            var mgr = new SimchaFundManager(Properties.Settings.Default.ConStr);

            mgr.AddDeposit(deposit);
            TempData["message"] = "Deposit successfully recorded";
            return(RedirectToAction("Index"));
        }
Example #10
0
 private void LoadTables()
 {
     Sales.Load();
     Deposits.Load();
     Referents.Load();
     Categories.Load();
     Articles.Load();
     Manufacturers.Load();
 }
Example #11
0
        private float _totalDeposits()
        {
            float total = 0.0f;

            if (Deposits != null)
            {
                Deposits.ToList().ForEach(x => total += x.Value);
            }
            return(total);
        }
Example #12
0
        public void FillTestData(int n)
        {
            Random rnd = new Random();

            // Clients
            for (int i = 1; i <= n; ++i)
            {
                Clients.Add(new Client
                {
                    Name     = $"Client{i}",
                    Password = "******",
                    Age      = rnd.Next(18, 60),
                    Email    = $"Client{i}@gmail.com"
                });
            }
            // Deposits
            for (int i = 0; i < n - 5; ++i)
            {
                var dep = new List <Product>();
                for (int j = 0; j < 5; ++j)
                {
                    var id     = rnd.Next(1, 1000);
                    var weight = rnd.Next(1000, 5000);
                    Products.Add(new Product()
                    {
                        Id     = id,
                        Name   = $"Product{j}",
                        Price  = i * 10,
                        Unit   = "g",
                        Type   = (j % 2 == 0) ? "gold" : "silver",
                        Weight = weight,
                        Sample = 999
                    });
                    dep.Add(new Product()
                    {
                        Id     = id,
                        Name   = $"Product{j}",
                        Price  = i * 10,
                        Unit   = "g",
                        Type   = (j % 2 == 0) ? "gold" : "silver",
                        Weight = weight,
                        Sample = 999
                    });
                }
                Deposits.Add(new Deposit(dep, Clients[i], DateTime.Now + TimeSpan.FromDays(i)));
            }
            // ForSale
            foreach (var dep in Deposits)
            {
                if (dep.DateTime.Day % 2 == 0)
                {
                    ForSales.Add(new ForSale(dep));
                }
            }
        }
        public async Task <PagedResult <DepositDetails> > BrowseAsync(GetDeposits query)
        {
            if (query is null)
            {
                return(PagedResult <DepositDetails> .Empty);
            }

            var deposits = Deposits.AsQueryable();

            if (query.OnlyPending || query.OnlyUnconfirmed || query.OnlyNotRejected || query.EligibleToRefund)
            {
                //MongoDB unsupported predicate: (d.Confirmations < d.RequiredConfirmations) - maybe due to uint type?
                var allDeposits = await deposits.ToListAsync();

                var filteredDeposits = allDeposits.AsEnumerable();
                if (query.OnlyPending)
                {
                    filteredDeposits = filteredDeposits.Where(d => !d.Rejected && !d.RefundClaimed &&
                                                              (d.Transaction?.State == TransactionState.Pending ||
                                                               d.ClaimedRefundTransaction?.State ==
                                                               TransactionState.Pending));
                }

                if (query.OnlyUnconfirmed)
                {
                    filteredDeposits = filteredDeposits.Where(d => d.ConfirmationTimestamp == 0 ||
                                                              d.Confirmations < d.RequiredConfirmations);
                }

                if (query.OnlyNotRejected)
                {
                    filteredDeposits = filteredDeposits.Where(d => !d.Rejected);
                }

                if (query.EligibleToRefund)
                {
                    foreach (var deposit in deposits)
                    {
                        uint consumedUnits = await _depositUnitsCalculator.GetConsumedAsync(deposit);

                        deposit.SetConsumedUnits(consumedUnits);
                    }

                    filteredDeposits = filteredDeposits.Where(d => !d.RefundClaimed && (d.ConsumedUnits < d.Deposit.Units) &&
                                                              (!(d.EarlyRefundTicket is null) ||
                                                               query.CurrentBlockTimestamp >= d.Deposit.ExpiryTime
                                                              ));
                }

                return(filteredDeposits.OrderByDescending(d => d.Timestamp).ToArray().Paginate(query));
            }

            return(await deposits.OrderByDescending(d => d.Timestamp).PaginateAsync(query));
        }
Example #14
0
 public void DateCheck()
 {
     for (int i = 0; i < Deposits.Count; ++i)
     {
         if (DateTime.Now >= Deposits[i].DateTimeBuyOut)
         {
             Warehouse.AddRange(Deposits[i].Products);
             Deposits[i].Client.Rank--;
             Deposits.RemoveAt(i);
         }
     }
     IsDirty = true;
 }
        public void ProcessFile(FileStream f, StreamReader sr)
        {
            string temp;

            Iban      = sr.ReadLine();
            StartTime = DateTime.ParseExact(sr.ReadLine(), "yyyy/MM/dd HH:mm:ss", CultureInfo.InvariantCulture);
            EndTime   = DateTime.ParseExact(sr.ReadLine(), "yyyy/MM/dd HH:mm:ss", CultureInfo.InvariantCulture);

            NumberOfDeposits = int.Parse(sr.ReadLine());
            for (int i = 0; i < NumberOfDeposits; i++)
            {
                temp = sr.ReadLine();
                Deposits.Add(new Tuple <int, string>(int.Parse(temp.Split(' ')[0]), temp.Split(' ')[1].Replace(',', '.')));
            }
        }
Example #16
0
        public ActionResult AddContributor(Contributors contributor, Deposits deposit)
        {
            DataBase db = new DataBase(Settings.Default.ConStr);

            db.AddContributor(contributor);
            Deposits d = new Deposits
            {
                ContributorsId = contributor.Id,
                Amount         = deposit.Amount,
                Date           = contributor.Date
            };

            db.Deposit(d);
            return(Redirect("/"));
        }
        public async Task <PagedResult <DepositDetails> > BrowseAsync(GetDeposits query)
        {
            if (query is null)
            {
                return(PagedResult <DepositDetails> .Empty);
            }

            var deposits = Deposits.AsQueryable();

            if (query.OnlyUnverified)
            {
                deposits = deposits.Where(d => d.VerificationTimestamp == 0);
            }

            return(await deposits.OrderByDescending(d => d.Timestamp).PaginateAsync(query));
        }
Example #18
0
        public ActionResult New(Contributors contributor, decimal initialDeposit)
        {
            var mgr = new SimchaFundManager(Properties.Settings.Default.ConStr);

            mgr.AddContributor(contributor);
            var deposit = new Deposits
            {
                Amount        = initialDeposit,
                ContributorId = contributor.Id,
                Date          = contributor.Date
            };

            mgr.AddDeposit(deposit);
            TempData["Message"] = $"New Contributor Created! Id: {contributor.Id}";
            return(RedirectToAction("index"));
        }
        private static readonly string conName = "BankDB";      //Имя подключения


        /// <summary>
        /// Создает экземпляр класса BankDBContext
        /// </summary>
        /// <param name="connection">Строка подключения</param>
        public BankDbContext(string connection = null) : base(connection == null? conName : connection)
        {
            Departaments.Load();

            if (Departaments == null || Departaments.Count() == 0)
            {
                BaseFill();
            }

            Clients.Load();
            Credits.Load();
            Deposits.Load();
            Logs.Load();
            Organisations.Load();
            CreditHistories.Load();
        }
        public void applyDeposit(Deposits ds)
        {
            SqlConnection con = new SqlConnection();

            try
            {
                con.ConnectionString = ConfigurationManager.ConnectionStrings["BankManagmentConn"].ConnectionString;
                con.Open();
                SqlCommand cmd1 = new SqlCommand("insert into deposits(accountno,deposit_amount,duration,approved) values('" + ds.AccountNumber + "','" + ds.DepositAmount + "','" + ds.Duration + "','no')", con);
                cmd1.ExecuteNonQuery();
            }
            finally
            {
                con.Close();
            }
        }
Example #21
0
        public void applyDeposit(Deposits ds)
        {
            MySqlConnection conn = new MySqlConnection("Server=127.0.0.1; Port=3306; Database=mybank; Uid=aeo; Pwd=@300;");

            //SqlConnection con = new SqlConnection();
            try
            {
                //con.ConnectionString = ConfigurationManager.ConnectionStrings["BankManagmentConn"].ConnectionString;
                conn.Open();
                MySqlCommand cmd1 = new MySqlCommand("insert into deposits(accountno,deposit_amount,duration,approved) values('" + ds.AccountNumber + "','" + ds.DepositAmount + "','" + ds.Duration + "','no')", conn);
                cmd1.ExecuteNonQuery();
            }
            finally
            {
                conn.Close();
            }
        }
Example #22
0
        public IList <Deposits> depositDetails(Int64 accno)
        {
            DataSet          ds          = repo.depositDetails(accno);
            IList <Deposits> depositlist = new List <Deposits>();

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                Deposits detail = new Deposits();
                detail.AccountNumber = Convert.ToInt64(row["accountno"]);
                detail.DepositId     = Convert.ToInt32(row["deposit_id"]);
                detail.Approved      = Convert.ToString(row["approved"]);
                detail.DepositTime   = Convert.ToDateTime(row["approved_time"]);
                detail.DepositAmount = Convert.ToInt32(row["deposit_amount"]);
                detail.Duration      = Convert.ToInt32(row["duration"]);
                depositlist.Add(detail);
            }
            return(depositlist);
        }
Example #23
0
        public IList <Deposits> GetDeposits()
        {
            DataSet          ds           = repo.GetDeposits();
            IList <Deposits> depositsList = new List <Deposits>();

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                Deposits dep = new Deposits();
                dep.DepositId     = Convert.ToInt32(row["deposit_id"]);
                dep.AccountNumber = Convert.ToInt64(row["accountno"]);
                dep.DepositAmount = Convert.ToInt32(row["deposit_amount"]);
                dep.Duration      = Convert.ToInt32(row["duration"]);
                dep.DepositTime   = row["approved_time"] != DBNull.Value ? (DateTime)row["approved_time"] : (DateTime?)null;
                dep.Approved      = Convert.ToString(row["approved"]);
                depositsList.Add(dep);
            }

            return(depositsList);
        }
Example #24
0
 public DepositListDialog(int MID)
 {
     InitializeComponent();
     InitializeComponent();
     data = new Deposits();
     data.GetData(MID);
     if (data.DepositsAddress[0] != 0)
     {
         Deposit1.IsEnabled = true;
     }
     if (data.DepositsAddress[1] != 0)
     {
         Deposit2.IsEnabled = true;
     }
     if (data.DepositsAddress[2] != 0)
     {
         Deposit3.IsEnabled = true;
     }
 }
Example #25
0
        public bool CreateDeposit(AccountModel account, Nullable <decimal> amount, int transactionId)
        {
            var acctService = new AccountService();

            using (var context = new Bank_LibraryEntities())
            {
                var newDeposit =
                    new Deposits
                {
                    Amount        = amount,
                    TransactionID = transactionId
                };
                context.Deposits.Add(newDeposit);

                acctService.DepositToAccount(context, account, amount);

                return(context.SaveChanges() == 1);
            }
        }
Example #26
0
 private void frmBanking_Load(object sender, EventArgs e)
 {
     dgvCustomers.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
     dgvCustomers.MultiSelect   = false;
     try
     {
         withdrawls = new Withdrawls();
         deposits   = new Deposits();
         customers  = new Customers();
         customers.GetAll();
         deposits.GetAll();
         withdrawls.GetAll();
         Rebind();
     }
     catch (Exception ex)
     {
         lblStatus.Text      = ex.Message;
         lblStatus.ForeColor = Color.Red;
     }
 }
        private void GetDeposits(int index, SqlConnectionStringBuilder connectionStringBuilder, AClient holder, int entity = 0)
        {
            var sqlDepositQuery = $@"SELECT * FROM Deposits
                                        WHERE HolderId = {index} AND isEntity = {entity}";

            using (var connector = new SqlConnector(connectionStringBuilder))
            {
                using (var depositReader = connector.GetData(sqlDepositQuery))
                {
                    while (depositReader.Read())
                    {
                        var deposit = ConvertSqlData.ToDeposit(depositReader, holder);
                        if (deposit != null)
                        {
                            holder.Deposits.Add(deposit);
                            Deposits.Add(deposit);
                        }
                    }
                }
            }
        }
Example #28
0
        public async Task <PagedResult <DepositDetails> > BrowseAsync(GetDeposits query)
        {
            if (query is null)
            {
                return(PagedResult <DepositDetails> .Empty);
            }

            var deposits = Deposits.AsQueryable();

            if (query.OnlyUnconfirmed || query.OnlyNotRejected || query.EligibleToRefund)
            {
                //MongoDB unsupported predicate: (d.Confirmations < d.RequiredConfirmations) - maybe due to uint type?
                var allDeposits = await deposits.ToListAsync();

                var filteredDeposits = allDeposits.AsEnumerable();
                if (query.OnlyUnconfirmed)
                {
                    filteredDeposits = filteredDeposits.Where(d => d.ConfirmationTimestamp == 0 ||
                                                              d.Confirmations < d.RequiredConfirmations);
                }

                if (query.OnlyNotRejected)
                {
                    filteredDeposits = filteredDeposits.Where(d => !d.Rejected);
                }

                if (query.EligibleToRefund)
                {
                    filteredDeposits = filteredDeposits.Where(d => !d.RefundClaimed &&
                                                              (!(d.EarlyRefundTicket is null) ||
                                                               query.CurrentBlockTimestamp >= d.Deposit.ExpiryTime
                                                              ));
                }

                return(filteredDeposits.OrderByDescending(d => d.Timestamp).Paginate(query));
            }

            return(await deposits.OrderByDescending(d => d.Timestamp).PaginateAsync(query));
        }
Example #29
0
        public ObservableCollection <Deposit> CreateDeposits(int clientId)
        {
            OpenConnection();
            SqlCmd.CommandText = @"SELECT * FROM deposits WHERE client_id = @clientId and isconfirm = 1";
            SqlCmd.Parameters.Add(new SQLiteParameter("@clientId")
            {
                Value = clientId
            });
            SqlCmd.ExecuteNonQuery();
            SQLiteDataReader reader;

            reader = SqlCmd.ExecuteReader();
            while (reader.Read())
            {
                Deposit deposit = new Deposit(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetString(3),
                                              reader.GetString(4), reader.GetInt32(5), CheckConfirm(reader.GetInt32(6)), Convert.ToDateTime(reader.GetString(7), CultureInfo.CurrentCulture));
                Deposits.Add(deposit);
            }
            CloseConnection();

            Service.CountServiceClient client = new Service.CountServiceClient("NetTcpBinding_ICountService");
            foreach (Deposit deposit in Deposits)
            {
                double pay = client.CalcDeposit(deposit.Duration, deposit.Number, deposit.DateDeposit);
                if (pay != 0)
                {
                    Card card = new Card(1, deposit.CardNumber, "dffdsfwef", 2355, 544, "03.11.2023", "Visa Classic", 0, 2, true);
                    card = card.GetCurrentCard(card);
                    int newCardMoney = card.Money + (int)pay;
                    card.UpdateCardMoney(card, newCardMoney);
                }
            }
            client.Close();
            return(Deposits);
            //Credits.Remove(credit);
            //DeleteSelectedItem(credit.Id, "credit");
        }
 public void Standard(DepositOutput output)
 {
     Deposits.Add(output);
 }