public static void AllowRequests(Classes.Request request)
{
Test dataBase = new Test();
MySqlDataAdapter adapter = new MySqlDataAdapter();
DataTable table = new DataTable();
MySqlCommand command = new MySqlCommand("SELECT * FROM `sklad` WHERE `Articule` = @aR", dataBase.getConnection());
dataBase.connection.Open();
command.Parameters.Add("@aR", MySqlDbType.Int32).Value = request.articule;
int countInSklad;
adapter.SelectCommand = command;
adapter.Fill(table);
countInSklad = Convert.ToInt32(table.Rows[0][1]);
command = new MySqlCommand("UPDATE `sklad` SET `Count` = @cO WHERE `Articule` = @aR", dataBase.getConnection());
command.Parameters.Add("@cO", MySqlDbType.Int32).Value = countInSklad - request.count;
command.Parameters.Add("@aR", MySqlDbType.Int32).Value = request.articule;
command.ExecuteNonQuery();
command = new MySqlCommand("INSERT INTO `transit`(`MagId`, `Articule`, `Count`, `reqId`) VALUES (@mI, @aR, @cO, @rI)", dataBase.getConnection());
command.Parameters.Add("@mI", MySqlDbType.Int32).Value = request.magId;
command.Parameters.Add("@aR", MySqlDbType.Int32).Value = request.articule;
command.Parameters.Add("@cO", MySqlDbType.Int32).Value = request.count;
command.Parameters.Add("@rI", MySqlDbType.Int32).Value = request.reqId;
command.ExecuteNonQuery();
command = new MySqlCommand("DELETE FROM `requests` WHERE `reqId` = @rI", dataBase.getConnection());
command.Parameters.Add("rI", MySqlDbType.Int32).Value = request.reqId;
command.ExecuteNonQuery();
dataBase.connection.Close();
MessageBox.Show("Complite");
}
public void vibratePreset(int preset = 2, bool resume = false)
{
this.on = true;
Request request = new Classes.Request();
request.PresetToy(this, preset).ConfigureAwait(true);
}
public void vibrate(int time, bool hit = true)
{
this.on = true;
Request request = new Classes.Request();
this.lastLevel = this.getIntense(hit);
request.UseToy(this, time, this.lastLevel).ConfigureAwait(true);
}
public void vibrate(int time, int level)
{
this.on = true;
Request request = new Classes.Request();
this.lastLevel = level;
request.UseToy(this, time, level).ConfigureAwait(true);
}
public void stop(bool resetLastLevel = false)
{
if (resetLastLevel)
{
this.lastLevel = 0;
}
this.on = false;
Request request = new Classes.Request();
request.StopToy(this).ConfigureAwait(true);
}
public static void ReceaveTransit(Classes.Request request)
{
List <string> str = new List <string>();
Test dataBase = new Test();
MySqlCommand command = new MySqlCommand("DELETE FROM `transit` WHERE `reqId` = @rI", dataBase.getConnection());
command.Parameters.Add("@rI", MySqlDbType.Int32).Value = request.reqId;
dataBase.openConnection();
command.ExecuteNonQuery();
dataBase.closeConnection();
command = new MySqlCommand("SELECT * FROM `productsinmagazines` WHERE `MagId` = @mI AND `Articule` = @aR", dataBase.getConnection());
command.Parameters.Clear();
command.Parameters.Add("@mI", MySqlDbType.Int32).Value = request.magId;
command.Parameters.Add("@aR", MySqlDbType.Int32).Value = request.articule;
MySqlDataAdapter adapter = new MySqlDataAdapter();
DataTable table = new DataTable();
adapter.SelectCommand = command;
adapter.Fill(table);
for (int i = 0; i < table.Rows.Count; i++)
{
for (int j = 0; j < table.Columns.Count; j++)
{
str.Add(table.Rows[i][j].ToString());
}
request.count = request.count + Convert.ToInt32(str[2]);
str.Clear();
}
command = new MySqlCommand("UPDATE `productsinmagazines` SET `Count` = @cO WHERE `MagId` = @mI AND `Articule` = @aR", dataBase.getConnection());
command.Parameters.Clear();
command.Parameters.Add("@mI", MySqlDbType.Int32).Value = request.magId;
command.Parameters.Add("@aR", MySqlDbType.Int32).Value = request.articule;
command.Parameters.Add("@cO", MySqlDbType.Int32).Value = request.count;
dataBase.openConnection();
command.ExecuteNonQuery();
dataBase.closeConnection();
}
public void resume()
{
Request request = new Classes.Request();
request.UseToy(this, 0, this.lastLevel).ConfigureAwait(true);
}
public Control()
{
this.Request = new Classes.Request();
this.LoadModes();
this.SetMode();
}
