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(); }