private void button1_Click(object sender, EventArgs e)
{
SqlConnection conect = ClassSQL.GetConect();
conect.Open();
try
{
EnterToSystem(conect);
}
catch
{
MessageBox.Show("Ошибка системы. ", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
conect.Close();
conect.Dispose();
}
}
private void button1_Click(object sender, EventArgs e)
{
string sc_writepers = "insert into Personal (ID_Kinoteatr, ID_Dolj, Gorod, Ulitsa, Dom, Kvartira, Fam, Nam, Otc, Login, Parol, Num_Tel, Email, Pass_Dan) values ('" + id_kin.ToString() + "', '" + id_dolj.ToString() + "', '" + textBox_go.Text + "', '" + textBox_ul.Text + "', '" + textBox_dom.Text + "', '" + textBox_kv.Text + "', '" + textBox_fam.Text + "', '" + textBox_nam.Text + "', '" + textBox_otc.Text + "', '" + textBox_log.Text + "', '" + textBox_pass.Text + "', '" + textBox_mob.Text + "', '" + textBox_mail.Text + "', '" + textBox_pasp.Text + "');";
SqlConnection conection = ClassSQL.GetConect();
conection.Open();
try
{
scom = new SqlCommand(sc_writepers, conection);
scom.ExecuteNonQuery();
MessageBox.Show("Добавление прошло успешно!", "Уведомление", MessageBoxButtons.OK);
}
catch (Exception ex)
{
MessageBox.Show("не записалось!" + ex.Message);
}
conection.Close();
conection.Dispose();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conect = ClassSQL.GetConect();
conect.Open();
try
{
EnterToSystem(conect);
}
catch
{
MessageBox.Show("Что-то пошло не так(");
}
finally
{
conect.Close();
conect.Dispose();
}
}
private void LoadData_prem()
{
SqlConnection conection = ClassSQL.GetConect();
conection.Open();
string cs_dat_prem = "select f.Data_end_premier from Film f join Seans s on s.ID_Film = f.ID_Film where ID_Seans = " + go + ";";
sclCom = new SqlCommand(cs_dat_prem, conection);
string DatePrem = sclCom.ExecuteScalar().ToString();
string data = DatePrem.Split(' ')[0];
string[] a1 = new string[3];
a1 = data.Split('.').ToArray();
god_pr = a1[2];
mes_pr = a1[1];
day_pr = a1[0];
conection.Close();
conection.Dispose();
}
private void button2_Click(object sender, EventArgs e)
{
string cmdText;
string cmdText2;
SqlConnection conection = ClassSQL.GetConect();
SqlConnection conectionn = ClassSQL.GetConect();
conectionn.Open();
conection.Open();
cmdText = "insert into BIlet (ID_Mesto, ID_Pokup, Stoim, ID_Oplati, Bilet_Opl,Data_time_pokup) values ('" + vib_mesto + "', '" + PokupForm.id_pokupatel + "', '" + label3.Text + "', '2', '0', getdate())";
cmdText2 = "update Mesto set Zan_Mesto = 1 where Num_mesto = " + vib_mesto + " and ID_Seans = " + ViborSeans.idha + ";";
try
{
sclCom = new SqlCommand(cmdText, conection);
sclCom.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("Проблема с бронированием" + ex.Message);
}
finally
{
try
{
sclCom = new SqlCommand(cmdText2, conectionn);
sclCom.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("проблема с местом" + ex.Message);
}
finally
{
conection.Close();
conection.Dispose();
conectionn.Close();
conectionn.Dispose();
MessageBox.Show("Бронирование успешно завершено", "Уведомление", MessageBoxButtons.OK);
MessageBox.Show("Ваше забронированое место: " + vib_mesto + " ", "Уведомление", MessageBoxButtons.OK);
}
}
}
private void button3_Click(object sender, EventArgs e)
{
SqlConnection conection = ClassSQL.GetConect();
conection.Open();
string sc_insert = "insert into mesto (ID_Zal, Num_ryad, Num_mesto, Zan_Mesto, Kom_Mesto, ID_Seans) values (" + Zal + ", '" + textBox1.Text + "', '" + textBox2.Text + "', '0', '" + textBox3.Text + "', " + Seans + ")";
if (textBox3.Text == "0" | textBox3.Text == "1")
{
scom = new SqlCommand(sc_insert, conection);
scom.ExecuteNonQuery();
MessageBox.Show("Место успешно добавлено", "Уведомление", MessageBoxButtons.OK);
conection.Close();
conection.Dispose();
}
else
{
MessageBox.Show("Комфортность места определяется 1 или 0", "Уведомление", MessageBoxButtons.OK);
}
}
private void LoadKolvo()
{
listBox1.Items.Clear();
SqlConnection conection = ClassSQL.GetConect();
conection.Open();
string cs_date = "select * from Mesto where Zan_Mesto = 0 and ID_Seans = " + id_s + " and Num_ryad = " + num_ryad.ToString() + ";";
sclCom = new SqlCommand(cs_date, conection);
DataSet datset = new DataSet("mesta");
SqlDataAdapter dat = new SqlDataAdapter(sclCom);
dat.Fill(datset, "mesto");
foreach (DataRow row in datset.Tables["mesto"].Rows)
{
listBox1.Items.Add(row["Num_mesto"]);
}
conection.Close();
conection.Dispose();
}
public AddUser()
{
InitializeComponent();
SqlConnection conection = ClassSQL.GetConect();
conection.Open();
try
{
Filldgv(conection);
}
catch (Exception ex)
{
MessageBox.Show("Ошибка системы. ", "Ошибка" + ex.Message, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
conection.Close();
conection.Dispose();
}
}
private void button2_Click(object sender, EventArgs e)
{
con = ClassSQL.GetConect();
string sc_insert = "insert into Seans (ID_Kinoteatr, ID_Zal, ID_Film, Data_time_Seans) values ('" + Kinoteatr + "', '" + Zal + "', '" + Film + "', '" + convDat(maskedTextBox1.Text) + "');";
SqlConnection conection3 = ClassSQL.GetConect();
con.Open();
try
{
scom3 = new SqlCommand(sc_insert, con);
scom3.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("Не удалось внести сеанс" + ex.Message);
}
finally
{
con.Close();
con.Dispose();
MessageBox.Show("Добавление прошло успешно!", "Уведомление", MessageBoxButtons.OK);
}
string convDat(string oldDate)
{
string newdate;
string data = oldDate.Split(' ')[0];
string vreme = oldDate.Split(' ')[1];
string[] a1 = new string[3];
a1 = data.Split('-').ToArray();
string god = a1[2];
string mes = a1[1];
string day = a1[0];
newdate = god + "-" + mes + "-" + day + " " + vreme;
return(newdate);
}
}
public AddSeans()
{
InitializeComponent();
con = ClassSQL.GetConect();
con.Open();
try
{
Filldgv();
Fill1com();
Fill2com();
Fill3com();
}
catch (Exception ex)
{
MessageBox.Show("Что-то пошло не так(" + ex.Message);
}
finally
{
con.Close();
con.Dispose();
}
}
private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
{
listBox2.Items.Clear();
SqlConnection conection3 = ClassSQL.GetConect();
conection3.Open();
string cs_film = "Select ID_Film from Film where Naz_Film = '" + listBox1.SelectedItem.ToString() + "';";
sclCom = new SqlCommand(cs_film, conection3);
Filmc = sclCom.ExecuteScalar().ToString();
conection3.Close();
conection3.Dispose();
string sc_getDate = "Select Data_time_Seans from Seans where Data_time_Seans >= getdate() and ID_Kinoteatr = " + gorod.ToString() + " and ID_Film = " + Filmc.ToString() + " ; ";
conection = ClassSQL.GetConect();
conection.Open();
try
{
sclCom = new SqlCommand(sc_getDate, conection);
DataSet datset = new DataSet("dates");
SqlDataAdapter dat = new SqlDataAdapter(sclCom);
dat.Fill(datset, "Date");
foreach (DataRow row in datset.Tables["Date"].Rows)
{
listBox2.Items.Add(row["Data_time_Seans"]);
}
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.Message);
}
finally
{
conection.Close();
conection.Dispose();
}
listBox2.Visible = true;
label3.Visible = true;
}
private void LoadKolvo()
{
listBox2.Items.Clear();
SqlConnection conection = ClassSQL.GetConect();
conection.Open();
string cs_date = "select * from place where free=0 and row_place=" + num_ryad.ToString() + " and session_id=" + ViborSeans.idha + ";";
sclCom = new SqlCommand(cs_date, conection);
DataSet datset = new DataSet("place");
SqlDataAdapter dat = new SqlDataAdapter(sclCom);
dat.Fill(datset, "place");
foreach (DataRow row in datset.Tables["place"].Rows)
{
listBox2.Items.Add(row["place"]);
}
conection.Close();
conection.Dispose();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection connect = ClassSQL.GetConect();
connect.Open();
try
{
EnterToSystem(connect);
}
catch
{
if (textBox_Card.Text == "")
{
MessageBox.Show("Для авторизации нужно ввести номер карты");
}
}
finally
{
connect.Close();
connect.Dispose();
}
}
public AddPrav()
{
InitializeComponent();
SqlConnection conection = ClassSQL.GetConect();
conection.Open();
try
{
Filldgv(conection);
}
catch (Exception ex)
{
MessageBox.Show("Что-то пошло не так(" + ex.Message);
}
finally
{
conection.Close();
conection.Dispose();
}
}
public Oplata(string vib_mesto)
{
InitializeComponent();
id_pok = PokupForm.id_pokupatel;
mestechko = vib_mesto;
if (id_pok == 0)
{
label_info.Text = "Покупатель неизвестен";
label9.Visible = false;
label10.Visible = false;
label7.Visible = false;
}
else if (id_pok == -1)
{
label_Name.Text += "admin";
label_Fam.Text += "admin";
label_Otc.Text += "admin";
label_numcard.Text += "999";
label_Bal.Text += "99999";
}
SqlConnection conection = ClassSQL.GetConect();
conection.Open();
try
{
GetName(conection);
}
catch (Exception ex)
{
MessageBox.Show("Что-то пошло не так!!!" + ex.Message);
}
finally
{
conection.Close();
conection.Dispose();
}
textBox_sum.Text = Mesto.itog_cena;
}
public PokupForm(string Num_card, string Balance, int id_Goroda)
{
InitializeComponent();
id_k = id_Goroda;
id_c = Int32.Parse(Num_card);
id_b = Int32.Parse(Balance);
con = ClassSQL.GetConect();
con.Open();
try
{
if (Num_card != "0")
{
FullName();
button2.Visible = true;
}
EnterToSys();
LoadSeans();
}
catch (Exception ex)
{
MessageBox.Show("Что-то пошло не так" + ex.Message);
}
finally
{
con.Close();
con.Dispose();
}
SqlConnection conection4 = ClassSQL.GetConect();
conection4.Open();
string sc_getimg = "Select Img_kinoteatra from kinoteatr where ID_KInoteatr = " + id_k + " ";
scom = new SqlCommand(sc_getimg, conection4);
pathimg = scom.ExecuteScalar().ToString();
pictureBox1.Image = Image.FromFile(pathimg);
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conection = ClassSQL.GetConect();
conection.Open();
string sc_delMesto = "Delete from Mesto where ID_Mesto = " + textBox4.Text.ToString() + ";";
try
{
scom = new SqlCommand(sc_delMesto, conection);
scom.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("Проблема с удалением" + ex.Message);
}
finally
{
conection.Close();
conection.Dispose();
MessageBox.Show("Место удалено", "Уведомление", MessageBoxButtons.OK);
}
}
private void button1_Click(object sender, EventArgs e)
{
prav += comboBox2.SelectedIndex;
janr += comboBox1.SelectedIndex;
string sc_writefilm = "insert into Film (Data_Prem, Naz_Film, ID_Janr, Prodol_Film, Vozrast_ogran,ID_Pravoob, Data_end_premier) values ('" + convDat(maskedTextBox1.Text) + "', '" + textBox1.Text + "', '" + janr.ToString() + "', '" + textBox2.Text.ToString() + "', '" + textBox3.Text.ToString() + "', '" + prav.ToString() + "', '" + convDat(maskedTextBox2.Text) + "');";
SqlConnection conection = ClassSQL.GetConect();
conection.Open();
try
{
scom = new SqlCommand(sc_writefilm, conection);
scom.ExecuteNonQuery();
MessageBox.Show("Добавление прошло успешно!", "Уведомление", MessageBoxButtons.OK);
}
catch (Exception ex)
{
MessageBox.Show("не записалось!" + ex.Message);
}
conection.Close();
conection.Dispose();
prav = 1;
janr = 1;
}
private void LoadCard()
{
string sc_getBal = "select * from cinema_card where card_id=" + num_card.ToString() + " ";
SqlConnection conection2 = ClassSQL.GetConect();
conection2.Open();
sclCom2 = new SqlCommand(sc_getBal, conection2);
using (DbDataReader reader = sclCom2.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
if ((num_card) == reader.GetInt32(0))
{
label_Bal.Text = reader.GetValue(5).ToString();
}
}
}
}
conection2.Close();
conection2.Dispose();
}
private void button_Vibor_Click(object sender, EventArgs e)
{
SqlConnection conection = ClassSQL.GetConect();
conection.Open();
try
{
string cmdText;
cmdText = "select hall_id from film_session where session_id = " + idha + " "; //id_hall
sclCom4 = new SqlCommand(cmdText, conection);
og = sclCom4.ExecuteScalar().ToString();
}
catch (Exception ex)
{
MessageBox.Show("Ошибка системы. ", "Ошибка" + ex.Message, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
conection.Close();
conection.Dispose();
Form Mesto = new Mesto(id_p);
Mesto.Show();
this.Hide();
}
private void button_Vibor_Click(object sender, EventArgs e)
{
SqlConnection conection = ClassSQL.GetConect();
conection.Open();
try
{
string cmdText;
cmdText = "set language english;select ID_Zal from Seans where ID_Seans = " + idha + " ";
sclCom = new SqlCommand(cmdText, conection);
og = sclCom.ExecuteScalar().ToString();
}
catch (Exception ex)
{
MessageBox.Show("Ошибка в залах" + ex.Message);
}
conection.Close();
conection.Dispose();
Form Mesto = new Mesto(go, og);
Mesto.Show();
this.Hide();
}
public PokupForm(int Num_card, int Balance)
{
InitializeComponent();
id_c = Num_card;
id_b = Balance;
SqlConnection conection = ClassSQL.GetConect();
SqlConnection conection2 = ClassSQL.GetConect();
SqlConnection conection3 = ClassSQL.GetConect();
conection.Open();
conection2.Open();
conection3.Open();
try
{
if (Num_card != 0)
{
FullName(conection2);
}
EnterToSys(conection);
LoadSeans(conection3);
}
catch (Exception ex)
{
MessageBox.Show("Ошибка системы. ", "Ошибка" + ex.Message, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
conection.Close();
conection.Dispose();
conection2.Close();
conection2.Dispose();
conection3.Close();
conection3.Dispose();
}
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conection = ClassSQL.GetConect();
conection.Open();
if (znach != " ")
{
try
{
Filldgv(conection);
}
catch (Exception ex)
{
MessageBox.Show("Что-то пошло не так(" + ex.Message);
}
finally
{
conection.Close();
conection.Dispose();
dataGridView1.Refresh();
}
}
}
private void button1_Click(object sender, EventArgs e)
{
janr += comboBox1.SelectedIndex;
string sc_writefilm = "insert into film(film_name, producer, genre_id, film_time, release_date, end_of_premiere, start_price, poster, plot) values ('" + textBox1.Text + "', '" + textBox4.Text + "', '" + janr.ToString() + "', '" + textBox2.Text + "', '" + convDat(maskedTextBox1.Text) + "', '" + convDat(maskedTextBox2.Text) + "', '" + textBox5.Text.ToString() + "', '" + textBox6.Text + "', '" + textBox7.Text + "');";
SqlConnection conection = ClassSQL.GetConect();
MessageBox.Show(maskedTextBox1.Text);
conection.Open();
try
{
scom = new SqlCommand(sc_writefilm, conection);
scom.ExecuteNonQuery();
MessageBox.Show("Добавление прошло успешно!", "Уведомление", MessageBoxButtons.OK, MessageBoxIcon.Information);
SqlConnection conection2 = ClassSQL.GetConect();
conection2.Open();
Filldgv(conection2);
}
catch (Exception ex)
{
MessageBox.Show("Ошибка системы. ", "Ошибка" + ex.Message, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
conection.Close();
conection.Dispose();
}
private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
{
vib_mesto = listBox1.SelectedItem.ToString();
button1.Visible = true;
button2.Visible = true;
string sc_getBal = "Select Kom_Mesto from Mesto where ID_Seans = " + ViborSeans.idha + " and Num_mesto = " + vib_mesto + " ";
SqlConnection conection2 = ClassSQL.GetConect();
conection2.Open();
sclCom = new SqlCommand(sc_getBal, conection2);
cena = sclCom.ExecuteScalar().ToString();
var date = new DateTime(g, m, d);
if (cena == "True" && (DateTime.Today <= date))
{
label3.Text = "500";
}
else if (cena == "False" && (DateTime.Today <= date))
{
label3.Text = "300";
}
else if (cena == "True" && (DateTime.Today > date))
{
label3.Text = "150";
label_mes.Visible = true;
label_mes.Text = "Цена билета снижена \nв связи с окончанием \nпремьеры";
}
else if (cena == "False" && (DateTime.Today > date))
{
label3.Text = "100";
label_mes.Visible = true;
label_mes.Text = "Цена билета снижена \nв связи с окончанием \nпремьеры";
}
itog_cena = label3.Text;
}
private void button2_Click(object sender, EventArgs e)
{
string sc_writepokup = "insert into Pokup (Fam, Nam, Otc, Tel_num, Email) values ('" + textBox1.Text + "', '" + textBox2.Text + "', '" + textBox3.Text + "', '" + textBox4.Text + "', '" + textBox5.Text + "');";
SqlConnection conection = ClassSQL.GetConect();
conection.Open();
try
{
scom = new SqlCommand(sc_writepokup, conection);
scom.ExecuteNonQuery();
conection.Close();
conection.Dispose();
}
catch (Exception ex)
{
MessageBox.Show("Не записался покупатель" + ex.Message);
}
finally
{
try
{
string sc_selectID = "select id_pokup from Pokup where Fam = '" + textBox1.Text + "' and Nam = '" + textBox2.Text + "' and Otc = '" + textBox3.Text + "';";
SqlConnection conection2 = ClassSQL.GetConect();
conection2.Open();
scom = new SqlCommand(sc_selectID, conection2);
go = scom.ExecuteScalar().ToString();
conection2.Close();
conection2.Dispose();
}
catch (Exception ex)
{
MessageBox.Show("Не нашелся айди" + ex.Message);
}
finally
{
try
{
string sc_writecard = "insert into card(Num_Card, Balance) values(' " + go + " ', '0');";
SqlConnection conection3 = ClassSQL.GetConect();
conection3.Open();
scom = new SqlCommand(sc_writecard, conection3);
scom.ExecuteNonQuery();
conection3.Close();
conection3.Dispose();
}
catch (Exception ex)
{
MessageBox.Show("Не создалась карта " + ex.Message);
}
finally
{
try
{
string sc_UpCard = "update Pokup set ID_Card = " + go + " where ID_Pokup = " + go + ";";
SqlConnection conection4 = ClassSQL.GetConect();
conection4.Open();
scom = new SqlCommand(sc_UpCard, conection4);
scom.ExecuteNonQuery();
conection4.Close();
conection4.Dispose();
}
catch (Exception ex)
{
MessageBox.Show("Не создалась карта " + ex.Message);
}
finally
{
MessageBox.Show("Добавление прошло успешно!", "Уведомление", MessageBoxButtons.OK);
MessageBox.Show("Номер покупателя в системе: " + go + "", "Уведомление", MessageBoxButtons.OK);
}
}
}
}
}
private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
{
vib_mesto = listBox2.SelectedItem.ToString();
button1.Visible = true;
button2.Visible = true;
label5.Visible = true;
label6.Visible = true;
label4.Visible = true;
label3.Visible = true;
//ПРОВЕРЯЕМ КОМФОРТ
string sc_getBal = " select comfort from place where session_id=" + ViborSeans.idha + " and row_place=" + num_ryad + " and place=" + vib_mesto + ";";
SqlConnection conection2 = ClassSQL.GetConect();
conection2.Open();
sclCom3 = new SqlCommand(sc_getBal, conection2);
test = sclCom3.ExecuteScalar().ToString();
comfort = Int32.Parse(test);
if (comfort != 1)
{
label6.Text = "Нет";
}
else
{
label6.Text = "Да";
price = 100;
}
//ПРОВЕРЯЕМ НАЧ ЦЕНУ ОТ ФИЛЬМА
string sc_getStart = "select start_price from film f join film_session s on f.film_id=s.film_id and s.session_id=" + ViborSeans.idha + ";";
SqlConnection conection3 = ClassSQL.GetConect();
conection3.Open();
sclCom4 = new SqlCommand(sc_getStart, conection2);
test = sclCom4.ExecuteScalar().ToString();
startprice = int.Parse(test);
price += startprice;
//ПРОВЕРЯЕМ ВРЕМЯ СЕАНСА
string sc_getTime = "set language english;select case when ((select convert(varchar(8),date_session,108) from film_session where session_id=" + ViborSeans.idha + ") between '18:00:00' and '5:00:00') then 1 else 0 end ";
SqlConnection conection7 = ClassSQL.GetConect();
conection7.Open();
sclCom6 = new SqlCommand(sc_getTime, conection7);
string w = sclCom6.ExecuteScalar().ToString();
if (w == "1")
{
price += 70;
}
//ПРОВЕРЯЕМ ЕСТЬ ПРЕМЬЕРА
string sc_getPrem = "SELECT case when (select f.end_of_premiere from film_session s join film f on f.film_id=s.film_id and s.session_id=" + ViborSeans.idha + ")> getdate() or (select f.release_date from film_session s join film f on f.film_id=s.film_id and s.session_id=" + ViborSeans.idha + ")= getdate() then 1 else 0 end";
SqlConnection conection4 = ClassSQL.GetConect();
conection4.Open();
sclCom5 = new SqlCommand(sc_getPrem, conection4);
string a = sclCom5.ExecuteScalar().ToString();
if (a == "1")
{
price += 115;
}
//ФОРМИРУЕМ ЦЕНУ
label3.Text = price.ToString();
price2 = price;
price = 0;
}
private void button1_Click(object sender, EventArgs e)
{
string cmdText;
string cmdText2;
string cmdText3;
SqlConnection conection = ClassSQL.GetConect();
SqlConnection conectionn = ClassSQL.GetConect();
SqlConnection conection3 = ClassSQL.GetConect();
conectionn.Open();
conection.Open();
conection3.Open();
cmdText = "insert into BIlet (ID_Mesto, ID_Pokup, Stoim, ID_Oplati, Bilet_Opl,Data_time_pokup) values ( '" + mestechko + "', '" + id_pok + "', '" + skidka.ToString() + "', '2', '1', getdate())";
cmdText2 = "update Mesto set Zan_Mesto = 1 where Num_mesto = " + mestechko + " and ID_Seans = " + ViborSeans.idha + ";";
cmdText3 = "update Card set Balance = '" + skidka2.ToString() + "' where ID_Card = " + id_pok.ToString() + ";";
try
{
sclCom = new SqlCommand(cmdText, conection);
sclCom.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("упс" + ex.Message);
}
finally
{
try
{
sclCom = new SqlCommand(cmdText2, conectionn);
sclCom.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("упс" + ex.Message);
}
finally
{
if (id_pok != 0)
{
try
{
if (skid_get == false)
{
skidka2 = Int32.Parse(textBox_sum.Text) * 1.3;
}
sclCom = new SqlCommand(cmdText3, conection3);
sclCom.ExecuteNonQuery();
conection3.Close();
conection3.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(" упс " + ex.Message);
}
}
else
{
conection.Close();
}
conection.Dispose();
conectionn.Close();
conectionn.Dispose();
MessageBox.Show("Оплата прошла успешно!", "Уведомление", MessageBoxButtons.OK);
MessageBox.Show("Ваше купленое место: " + mestechko + " ", "Уведомление", MessageBoxButtons.OK);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (!maskedTextBox_card.MaskFull)
{
MessageBox.Show("Данные введенны некорректно.");
this.Hide();
}
if (!maskedTextBox_srok.MaskFull)
{
MessageBox.Show("Данные введенны некорректно. ");
this.Hide();
}
if (!maskedTextBox_cvv.MaskFull)
{
MessageBox.Show("Данные введенны некорректно.");
this.Hide();
}
string cmdText;
string cmdText2;
string cmdText3;
SqlConnection conection = ClassSQL.GetConect();
SqlConnection conectionn = ClassSQL.GetConect();
SqlConnection conection3 = ClassSQL.GetConect();
conectionn.Open();
conection.Open();
conection3.Open();
cmdText = "insert into ticket(session_id,place_id,card_id,date_ticket,time_ticket,price,payment) values ('" + ViborSeans.idha + "', '" + mestechko + "', '" + id_pok + "',convert(varchar(10),getdate(),102),convert(varchar(8),getdate(),108)," + price + ",1);";
cmdText2 = "update place set free = 1 where place = " + mestechko + " and session_id = " + ViborSeans.idha + ";";
cmdText3 = "update cinema_card set points = '" + skidka2.ToString() + "' where card_id = " + id_pok.ToString() + ";";
if ((maskedTextBox_card.Text != String.Empty) && (maskedTextBox_srok.Text != String.Empty) && (maskedTextBox_cvv.Text != String.Empty) && (textBox_mail.Text != String.Empty))
{
try
{
sclCom4 = new SqlCommand(cmdText, conection);
sclCom4.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("Ошибка системы. ", "Ошибка" + ex.Message, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
try
{
sclCom5 = new SqlCommand(cmdText2, conectionn);
sclCom5.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("Ошибка системы. " + ex.Message);
}
finally
{
if (id_pok != 0)
{
try
{
if (skid_get == false)
{
skidka2 += Int32.Parse(textBox_sum.Text) * 0.3;
}
sclCom6 = new SqlCommand(cmdText3, conection3);
sclCom6.ExecuteNonQuery();
conection3.Close();
conection3.Dispose();
}
catch (Exception ex)
{
MessageBox.Show("Ошибка системы. " + ex.Message);
}
}
else
{
conection.Close();
conection.Dispose();
conectionn.Close();
conectionn.Dispose();
MessageBox.Show("Оплата прошла успешно!", "Уведомление", MessageBoxButtons.OK);
MessageBox.Show("Ваше купленое место: " + mestechko + " Ряд: " + ryad + "\nНа указанную почту отправлен билет. ", "Уведомление", MessageBoxButtons.OK);
string sc_getSes = "select c.cinema_name,CONVERT(varchar(16),date_session,120), f.film_name, h.hall_name from film_session s join cinema c on c.cinema_id=s.cinema_id and session_id=" + ViborSeans.idha + " join film f on f.film_id=s.film_id join hall h on h.hall_id=s.hall_id";
SqlConnection conection7 = ClassSQL.GetConect();
conection7.Open();
sclCom3 = new SqlCommand(sc_getSes, conection7);
using (DbDataReader reader = sclCom3.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
kinoteatr = reader.GetString(0);
hall = reader.GetString(3);
date_ses = reader.GetString(1);
film = reader.GetString(2);
}
}
}
//@@@ОТПРАВКА ПИСЬМА@@@
MailAddress From = new MailAddress("*****@*****.**", "Кинотеатр");
string otpr = textBox_mail.ToString();
MailAddress To = new MailAddress(otpr);
MailMessage msg = new MailMessage(From, To);
msg.Subject = "Ваш билет.";
msg.Body = "<h2>Здравствуй, дорогой друг!<h2><br><h3><b>Мы очень ценим то, что вы выбрали наш кинотеатр.<br>Желаем хорошо провести время и приятного просмотра.<b><h3><br><h4><i>Ниже представленна информация по купленному вами билету. Покажите это письмо на кассе.<i><h4><br><h5> Кинотеатр: " + kinoteatr + "<br>Зал: " + hall + "<br>Ряд: " + ryad + "<br>Место: " + mestechko + "<br>Дата: " + date_ses + "<br>Фильм: " + film + "<h5><br><h6><i>С уважением, ваш любимый кинотеатр :)<i><h6>";
msg.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient("smtp.mail.ru", 587);
smtp.Credentials = new NetworkCredential("*****@*****.**", "Kino321654");
smtp.EnableSsl = true;
smtp.Send(msg);
this.Hide();
}
}
}
}
else
{
MessageBox.Show("Введите корректные данные. ", "Уведомление", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}