private void buttonDoThieft_Click(object sender, EventArgs e)
{//tymczasowe zmienne, odczytywane z bazy, zanim nieaktualny stan użytkownika zostanie usunięty
string temporaryPass;
decimal temporaryWallet;
SqlConnection sqlConnection;
string connection = "Data Source=.\\SQLEXPRESS;database=Interest;Trusted_Connection=yes";
sqlConnection = new SqlConnection(connection);
SqlCommand sqlCommand = new SqlCommand("select * from LogReg where Username = '******'");
sqlCommand.Connection = sqlConnection;
sqlConnection.Open();
SqlDataReader dr = sqlCommand.ExecuteReader();
if (dr.Read())
{
temporaryPass = dr.GetString(1);
temporaryWallet = Convert.ToDecimal(dr.GetString(2));// trzeba takim sposobem niestety. nie da się bezpośrednio "GetDecimal" bo wyskakuje błąd rzutowania.
int temporaryAction = Convert.ToInt32(dr.GetString(3));
int temporaryDebenturesAmount = Convert.ToInt32(dr.GetString(6));
int temporaryBalancedMarketAmount = Convert.ToInt32(dr.GetString(5));
int temporaryMarketAmount = Convert.ToInt32(dr.GetString(4));
if (radioButtonAction.Checked)
{
SqlOperation.DeletePosition(textBoxUserToThieft.Text);
SqlOperation.Actualization(textBoxUserToThieft.Text, temporaryPass, temporaryWallet, 0, temporaryDebenturesAmount, temporaryBalancedMarketAmount, temporaryMarketAmount);
interest.actionAmount += temporaryAction;
}
else if (radioButtonBalancedMarket.Checked)
{
SqlOperation.DeletePosition(textBoxUserToThieft.Text);
SqlOperation.Actualization(textBoxUserToThieft.Text, temporaryPass, temporaryWallet, temporaryAction, temporaryDebenturesAmount, 0, temporaryMarketAmount);
interest.balancedMarketAmount += temporaryBalancedMarketAmount;
}
else if (radioButtonDebentures.Checked)
{
SqlOperation.DeletePosition(textBoxUserToThieft.Text);
SqlOperation.Actualization(textBoxUserToThieft.Text, temporaryPass, temporaryWallet, temporaryAction, 0, temporaryBalancedMarketAmount, temporaryMarketAmount);
interest.debenturesAmount += temporaryDebenturesAmount;
}
else if (radioButtonMoneyMarket.Checked)
{
SqlOperation.DeletePosition(textBoxUserToThieft.Text);
SqlOperation.Actualization(textBoxUserToThieft.Text, temporaryPass, temporaryWallet, temporaryAction, temporaryDebenturesAmount, temporaryBalancedMarketAmount, 0);
interest.moneyMarketAmount += temporaryMarketAmount;
}
MessageBox.Show("Okradłeś: " + textBoxUserToThieft.Text + ". \nŚledczy maja Cię na oku!");
sqlConnection.Close();
this.Close();
}
else
{
MessageBox.Show("nie ma takiego użytkownika");
}
}
private void timer1_Tick(object sender, EventArgs e)
{
if (thieftCounter == 5)
{
Comunicats.TooMuchThieft();
this.Close();
}
else
{
k++;
InterestContinue(k);
SqlOperation.SqlSave(interestList, k);
progressBarInterest.Value = 1;
SqlOperation.DeletePosition(username);//aktualizacja stanu zalogowanego użytkownika
SqlOperation.Actualization(username, password, valueWalletUser, actionAmount, debenturesAmount, balancedMarketAmount, moneyMarketAmount);
}
}
