private void buttonRegistr_Click(object sender, EventArgs e)
{
//if (isUserExist())
// return;
string card_type;
string access_gum;
string access_swimming;
Int32 Price;
if (card_VIP_check.Checked)
{
cardPrice.Text = "22500 рублей";
card_type = "vip";
access_gum = "yes";
access_swimming = "yes";
Price = 22500;
}
else
{
cardPrice.Text = "15000 рублей";
card_type = "normal";
access_gum = "yes";
access_swimming = "no";
Price = 15000;
}
DataTable table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlDataAdapter adapter2 = new MySqlDataAdapter();
DB db = new DB();
MySqlCommand check = new MySqlCommand("SELECT phone FROM `customer` WHERE customer.phone= @phone ", db.getConnection());
check.Parameters.Add("@phone", MySqlDbType.VarChar).Value = customerPhoneField.Text;
//commandUp.Parameters.Add("@phone1", MySqlDbType.VarChar).Value = customerPhoneField.Text;
adapter.SelectCommand = check;
adapter.Fill(table);
db.openConnection();
if (table.Rows.Count > 0)
{
MySqlCommand command = new MySqlCommand("INSERT INTO `card`(`phone`, `price`, `card_type`, `validity`, `access_gum`, `access_swimming`) VALUES(@phone , @price ,@card_type ,CURDATE(), @access_gum, @access_swimming); UPDATE `card` SET `validity`= DATE_ADD(`validity`, INTERVAL 1 year) WHERE card.phone=@phone; ", db.getConnection());
command.Parameters.Add("@phone", MySqlDbType.VarChar).Value = customerPhoneField.Text;
command.Parameters.Add("@price", MySqlDbType.Int32).Value = Price;
command.Parameters.Add("@card_type", MySqlDbType.VarChar).Value = card_type;
command.Parameters.Add("@access_gum", MySqlDbType.VarChar).Value = access_gum;
command.Parameters.Add("@access_swimming", MySqlDbType.VarChar).Value = access_swimming;
adapter2.SelectCommand = command;
if (command.ExecuteNonQuery() == 2)
{
MessageBox.Show("Карта зарегистрированна");
curCard();
}
else
{
MessageBox.Show("Что то пошло не так");
}
}
else
{
MessageBox.Show("Карта не была привязана, проверьте правильность написания номера");
}
db.closeConnection();
}