private void button11_Click(object sender, System.EventArgs e)
{
List<Attack> attacks = new List<Attack>();
foreach (Attack attack in attacksListBox.SelectedItems)
{
attacks.Add(attack);
}
Sign sign = new Sign()
{
SingText = singTextBox.Text,
};
if (signPicture.Image == null)
{
sign.SignImage = null;
}
else
{
ImageConverter converter = new ImageConverter();
sign.SignImage = (byte[])converter.ConvertTo(signPicture.Image, typeof(byte[]));
}
_baseWorker.AddNewSign(sign, attacks);
RefreshSigns();
}
public List<Attack> Attacks(Sign sign)
{
List<Attack> attacks = new List<Attack>();
using (SqlCommand sqlCommand = new SqlCommand(AttackFromSign, _sqlConnection))
{
sqlCommand.Parameters.AddWithValue("@id", sign.Id);
using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader())
{
while (sqlDataReader.Read())
{
attacks.Add(new Attack()
{
Id = int.Parse(sqlDataReader["Id"].ToString()),
AttackName = sqlDataReader["Attack_Name"].ToString(),
AttackClass = int.Parse(sqlDataReader["Attack_Class"].ToString())
});
}
}
}
return attacks;
}
public void DeleteSign(Sign sign)
{
using (SqlCommand sqlCommand = new SqlCommand(RemoveSign, _sqlConnection))
{
sqlCommand.Parameters.AddWithValue("@signId", sign.Id);
if (sqlCommand.ExecuteNonQuery() > 0)
{
MessageBox.Show("Признак удален");
}
else
{
MessageBox.Show("Ошибка при удалении");
}
}
}
public void AddNewSign(Sign sign, List<Attack> attacks)
{
using (SqlCommand sqlCommand = new SqlCommand(InsertSign, _sqlConnection))
{
sqlCommand.Parameters.AddWithValue("@signText", sign.SingText);
if (sign.SignImage != null)
{
sqlCommand.Parameters.AddWithValue("@signImage", sign.SignImage);
}
else
{
sqlCommand.Parameters.AddWithValue("@signImage", new byte[0]);
}
if (sqlCommand.ExecuteNonQuery() > 0)
{
foreach (Attack attack in attacks)
{
using (SqlCommand command = new SqlCommand(InsertAttackSign, _sqlConnection))
{
command.Parameters.AddWithValue("@attackId", attack.Id);
command.ExecuteNonQuery();
}
}
// MessageBox.Show("Добвленно");
}
else
{
MessageBox.Show("Ошибка при добавлении");
}
}
}
