public WalletsC readWalletsC(int idUser, int idWalletC, int idCrypto) { WalletsC walletsC2 = new WalletsC(); string connectionString = @"Data Source=(localdb)\LocalDBKN;Initial Catalog=FinMarketsAppDB;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); string query = @"SELECT * FROM WalletsC WHERE idUser = "******" AND idWalletC = " + idWalletC + "AND idCrypto =" + idCrypto + ""; SqlCommand command = new SqlCommand(query, connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { walletsC2.idUser = Convert.ToInt32(reader["idUser"]); walletsC2.idWalletC = Convert.ToInt32(reader["idWalletC"]); walletsC2.idCrypto = Convert.ToInt32(reader["idCrypto"]); walletsC2.quantity = reader["quantity"].ToString(); walletsC2.sum = reader["sum"].ToString(); walletsC2.idAlert = Convert.ToInt32(reader["idAlert"]); } connection.Close(); return(walletsC2); }
public bool updateWalletsC(WalletsC walletsC, Users user) { float price = 0; float priceWhenAdded = 0; string connectionString = @"Data Source=(localdb)\LocalDBKN;Initial Catalog=FinMarketsAppDB;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); String query2 = @"SELECT price, priceWhenAdded FROM WalletsC,Cryptocurrencies WHERE Cryptocurrencies.idCrypto = WalletsC.idCrypto AND WalletsC.idUser = "******"AND WalletsC.idCrypto =" + walletsC.idCrypto + ""; // String query = @"SELECT sum FROM dbo.ViewWallet"; SqlCommand command2 = new SqlCommand(query2, connection); SqlDataReader reader = command2.ExecuteReader(); while (reader.Read()) { price = Convert.ToSingle(reader["price"].ToString()); priceWhenAdded = Convert.ToSingle(reader["priceWhenAdded"].ToString()); } connection.Close(); connection.Open(); if (price != priceWhenAdded) { // string query = @"UPDATE WalletsC SET idUser = "******",idWalletC=" + walletsC.idWalletC + ",idCrypto=" + walletsC.idCrypto + ",quantity=" + "'"+walletsC.quantity+"'" + ",sum=" + "'"+walletsC.sum+"'" + ",idAlert=" + walletsC.idAlert + "," + "priceWhenAdded=" + "'"+walletsC.priceWhenAdded + "'" + "," + "alertUp=" + "'"+walletsC.alertUp+"'" + "," + "alertDown=" + "'"+walletsC.alertDown+"'" + " WHERE idCrypto = " + walletsC.idCrypto + ""; string query = @"UPDATE WalletsC SET idUser = "******",idWalletC=" + walletsC.idWalletC + ",idCrypto=" + walletsC.idCrypto + ",quantity=" + "'" + walletsC.quantity + "'" + ",sum=" + "'" + walletsC.sum + "'" + ",idAlert=" + walletsC.idAlert + "," + "priceWhenAdded=" + "'" + priceWhenAdded + "'" + "," + "alertUp=" + "'" + walletsC.alertUp + "'" + "," + "alertDown=" + "'" + walletsC.alertDown + "'" + " WHERE idCrypto = " + walletsC.idCrypto + ""; //MessageBox.Show(query); SqlCommand command = new SqlCommand(query, connection); command.ExecuteNonQuery(); } connection.Close(); return(true); }
private void RemoveFromWalletBtn_Click(object sender, EventArgs e) { if (walletSymbolTextBox.Text != "" & walletNameTextBox.Text != "") { if (MessageBox.Show("Do you want remove this asset from your wallet?", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { Cryptocurrencies crypto = new Cryptocurrencies(); ConnectDB connectDb = new ConnectDB(); crypto = connectDb.Read(walletSymbolTextBox.Text); // to get crypto id from symbol Text Box WalletsC walletsC = new WalletsC(); WalletsC walletsC2 = new WalletsC(); Users user = new Users(); user = connectDb.checkLoggedUser(); walletsC.idUser = user.idUsers; walletsC.idWalletC = 1; // też sprzawdzam użytkonika a póżniej jego crytpo wallet walletsC.idCrypto = crypto.idCrypto; walletsC.quantity = walletQuantityTextBox.Text; walletsC.sum = 0.ToString(); walletsC.idAlert = 1; // bede pewnie z gui bral dla alertu wzrostoego 1 a dla malejacego 2 walletsC2 = connectDb.readWalletsC(walletsC.idUser, walletsC.idWalletC, walletsC.idCrypto); if (walletsC2.idCrypto != 0) { connectDb.deleteWalletsC(walletsC); this.viewWalletTableAdapter1.Fill(this.finMarketsAppDBDataSet21.ViewWallet); // this.viewWalletTableAdapter.Fill(this.finMarketsAppDBDataSet1.ViewWallet); calculateWalletbalance(); refreshWallet(); try { if (walletDataGridView.CurrentRow.Index != -1) { walletNameTextBox.Text = walletDataGridView.CurrentRow.Cells[0].Value.ToString(); walletSymbolTextBox.Text = walletDataGridView.CurrentRow.Cells[1].Value.ToString(); walletPriceTextBox.Text = walletDataGridView.CurrentRow.Cells[2].Value.ToString(); walletQuantityTextBox.Text = walletDataGridView.CurrentRow.Cells[3].Value.ToString(); } } catch (Exception) { } } else { MessageBox.Show("You do not have this asset in your wallet", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } else { MessageBox.Show("Select asset to remowe", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public bool deleteWalletsC(WalletsC walletsC) { string connectionString = @"Data Source=(localdb)\LocalDBKN;Initial Catalog=FinMarketsAppDB;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); string query = @"DELETE FROM WalletsC WHERE idCrypto = " + walletsC.idCrypto + ""; SqlCommand command = new SqlCommand(query, connection); command.ExecuteNonQuery(); connection.Close(); return(true); }
public bool saveWalletsC(WalletsC walletsC) { string connectionString = @"Data Source=(localdb)\LocalDBKN;Initial Catalog=FinMarketsAppDB;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); string query = @"INSERT INTO WalletsC VALUES (" + walletsC.idUser + "," + walletsC.idWalletC + "," + walletsC.idCrypto + "," + "'" + walletsC.quantity + "'" + "," + "'" + walletsC.sum + "'" + "," + walletsC.idAlert + "," + "'" + walletsC.priceWhenAdded + "'" + ", 0," + "'" + walletsC.alertUp + "'" + "," + "'" + walletsC.alertDown + "'" + ")"; SqlCommand command = new SqlCommand(query, connection); command.ExecuteNonQuery(); connection.Close(); return(true); }
private void AddToWalletBtn_Click(object sender, EventArgs e) { Cryptocurrencies crypto = new Cryptocurrencies(); ConnectDB connectDb = new ConnectDB(); if (walletSymbolTextBox.Text != "" & walletNameTextBox.Text != "") { crypto = connectDb.Read(walletSymbolTextBox.Text); // to get crypto id from symbol Text Box WalletsC walletsC = new WalletsC(); WalletsC walletsC2 = new WalletsC(); Users user = new Users(); user = connectDb.checkLoggedUser(); walletsC.idUser = user.idUsers; walletsC.idWalletC = 1; walletsC.idCrypto = crypto.idCrypto; walletsC.priceWhenAdded = crypto.Price; walletsC.price = crypto.Price; walletsC.quantity = walletQuantityTextBox.Text; float tempSum = Convert.ToSingle(walletsC.price) * Convert.ToSingle(walletsC.quantity); walletsC.sum = tempSum.ToString(); walletsC.idAlert = 1; walletsC.alertUp = alertUpTextBox.Text; walletsC.alertDown = alertDownTextBox.Text; walletsC2 = connectDb.readWalletsC(walletsC.idUser, walletsC.idWalletC, walletsC.idCrypto); if (walletsC2.idCrypto != 0) { connectDb.updateWalletsC(walletsC, user); } else { connectDb.saveWalletsC(walletsC); } this.viewWalletTableAdapter1.Fill(this.finMarketsAppDBDataSet21.ViewWallet); // this.viewWalletTableAdapter.Fill(this.finMarketsAppDBDataSet1.ViewWallet); calculateWalletbalance(); refreshWallet(); } }