private void Change_client_button_Click(object sender, EventArgs e)
{
DB dB = new DB();
int id = int.Parse(str[0]);
string name = FIO_client.Text;
string birthdate = dateTimePicker2.Text;
string gender = gender_client.Text;
string mp = Mob_phone_client.Text;
string adress = Adress_client.Text;
string contracter = Contracter.SelectedItem.ToString();
string typeLoan = type_loan.SelectedItem.ToString();
string data = dateTimePicker1.Text;
string wages = wages_clients.Text;
dB.openConnection();
MySqlCommand command = new MySqlCommand($"SELECT DISTINCT EMPLOYEE_ID FROM employes WHERE `EMPLOYEE_NAME` = '{contracter}'", dB.getConnection());
MySqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
object ID = reader.GetValue(0);
contracter = ID.ToString();
}
}
reader.Close();
command.CommandText = $"SELECT DISTINCT LOAN_ID FROM type_loan WHERE `LOAN_NAME` = '{typeLoan}'";
reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
object ID = reader.GetValue(0);
typeLoan = ID.ToString();
}
}
reader.Close();
command.CommandText = "UPDATE `client` SET `CLIENT_NAME` = @name, `BIRTHDATE` = @bd, `GENDER` = @gend," +
" `MOBILE_PHONE` = @mobphone, `ADDRESS` = @adress, `CONTRACTER` = @cont, `TYPE_LOAN` = @loan," +
" `DATA_AGR` = @dagr, `WAGES` = @wages WHERE `client`.`CLIENT_ID` = @id ";
command.Parameters.Add("@name", MySqlDbType.VarChar).Value = name;
command.Parameters.Add("@bd", MySqlDbType.Date).Value = birthdate;
command.Parameters.Add("@gend", MySqlDbType.VarChar).Value = gender;
command.Parameters.Add("@mobphone", MySqlDbType.VarChar).Value = mp;
command.Parameters.Add("@adress", MySqlDbType.VarChar).Value = adress;
command.Parameters.Add("@cont", MySqlDbType.Int32).Value = contracter;
command.Parameters.Add("@loan", MySqlDbType.Int32).Value = typeLoan;
command.Parameters.Add("@dagr", MySqlDbType.Date).Value = data;
command.Parameters.Add("@wages", MySqlDbType.Int32).Value = wages;
command.Parameters.Add("@id", MySqlDbType.Int32).Value = id;
if (command.ExecuteNonQuery() == 1)
{
MessageBox.Show("Изменения внесенЫ в базу!");
this.Close();
}
else
{
MessageBox.Show("Произошла ошибка!");
}
dB.closeConnection();
}
