private void button9_Click(object sender, EventArgs e) { if (act_table == 1) // обработка таблицы "Билет" { Form4 f = new Form4(); if (f.ShowDialog() == DialogResult.OK) { // добавление данных в таблицу "Билеты" Add_Bilet(f.textBox1.Text, f.textBox2.Text, Convert.ToDateTime(f.dateTimePicker1.Text), f.textBox4.Text, f.textBox5.Text, f.checkBox1.Checked); Get_Bilets(); } } else if (act_table == 2) // обработка таблицы "Маршрут" { Form5 f = new Form5(); if (f.ShowDialog() == DialogResult.OK) { // добавление данных в таблицу "Маршрут" Add_Marshrut(f.textBox1.Text, f.textBox2.Text, f.textBox3.Text, f.textBox4.Text, Convert.ToDouble(f.textBox5.Text), Convert.ToDouble(f.textBox6.Text), f.dateTimePicker1.Value, f.dateTimePicker2.Value); Get_Marshruts(); } } else if (act_table == 3) // обработка таблицы "Автобус" { Form6 f = new Form6(); if (f.ShowDialog() == DialogResult.OK) { // добавление данных в таблицу "Автобус" Add_Avtobus(f.textBox1.Text, f.textBox2.Text, f.textBox3.Text, f.textBox4.Text); Get_Avtobus(); } } else if (act_table == 4) // обработка таблицы "Водитель" { Form7 f = new Form7(); if (f.ShowDialog() == DialogResult.OK) { // добавление данных в таблицу "Водитель" Add_Voditel(f.textBox1.Text, Convert.ToString(f.dateTimePicker1.Value), f.textBox2.Text); Get_Voditel(); } } else if (act_table == 5) // обрабатываем таблицу "Диспетчер" { Form8 f = new Form8(); if (f.ShowDialog() == DialogResult.OK) { // добавление данных в таблицу "Диспетчер" Add_Dispetcher(f.textBox1.Text, Convert.ToString(f.dateTimePicker1.Value), f.textBox2.Text); Get_Dispetcher(); } } }
private void button1_Click_1(object sender, EventArgs e) { Form7 f7 = new Form7(); if (f7.ShowDialog(this) == DialogResult.OK) { //timer2.Enabled = true; this.Close(); } }
private void button6_Click(object sender, EventArgs e) { int index, index_src, n; string SqlText = "UPDATE [Aviakompania] SET "; string Aviakompania_ID, Litak_ID, Nazva, NomerTelefony, EMail; string Name_Source; // перевірка, чи є взагалі записи в таблиці Emission n = dataGridView2.Rows.Count; if (n == 1) { return; } Form7 f = new Form7(); // заповнити форму даними перед відкриттям index = dataGridView2.CurrentRow.Index; Aviakompania_ID = dataGridView2[0, index].Value.ToString(); Litak_ID = dataGridView2[1, index].Value.ToString(); Nazva = dataGridView2[2, index].Value.ToString(); NomerTelefony = dataGridView2[3, index].Value.ToString(); EMail = dataGridView2[4, index].Value.ToString(); index_src = dataGridView1.CurrentRow.Index; Name_Source = dataGridView1[1, index_src].Value.ToString(); // f.label1.Text = Name_Source; f.textBox1.Text = Nazva; f.textBox2.Text = NomerTelefony; f.textBox3.Text = EMail; if (f.ShowDialog() == DialogResult.OK) { Nazva = f.textBox1.Text; NomerTelefony = f.textBox2.Text; EMail = f.textBox3.Text; SqlText += "Nazva = " + Nazva + ", NomerTelefony = \'" + NomerTelefony + "\', EMail = \'" + EMail + "\' "; SqlText += "WHERE [Aviakompania].Aviakompania_ID = " + Aviakompania_ID; MyExecuteNonQuery(SqlText); Aviakompania(); } }
private void button7_Click(object sender, EventArgs e) { form7.ShowDialog(); }
private void Form8_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e) { if (e.KeyCode == Keys.Escape) { button1.PerformClick(); } if (e.KeyCode == Keys.Oemplus || e.KeyCode == Keys.Add) { if (tabel == 1) { string html2 = string.Empty; int zi = DateTime.Today.Day; int an = DateTime.Today.Year; int luna = DateTime.Today.Month; string url2 = @"https://*****:*****@"https://localhost:8080/createproduct"; * // https://localhost:8080/createbill?zi=3&luna=14&an=2444 * * HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url2); * request.AutomaticDecompression = DecompressionMethods.GZip; * using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) * using (Stream stream = response.GetResponseStream()) * using (StreamReader reader = new StreamReader(stream)) * { * html2 = reader.ReadToEnd(); * } * * * if (html2 == "Executat") * { * populateDGV2(); * } * else if (html2 == "Baza de date offline") * { * MessageBox.Show("Baza de date offline", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error); * } */ } else if (tabel == 3) { } } if (e.KeyCode == Keys.Delete) { if (tabel == 1) { if (dataGridView1.SelectedRows.Count == 0) { } else { int counterr = 0; foreach (DataGridViewRow row in dataGridView1.SelectedRows) { int indexx = int.Parse(row.Index.ToString()); int id; id = int.Parse(dataGridView1.Rows[indexx].Cells["ID"].Value.ToString()); string html23 = string.Empty; string url23 = @"https://*****:*****@"https://localhost:8080/deletegridproduct?id=" + id + "&tip=" + ctip; // https://localhost:8080/deletegridu?id=14 Console.WriteLine(url23); HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url23); request.AutomaticDecompression = DecompressionMethods.GZip; using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) using (Stream stream = response.GetResponseStream()) using (StreamReader reader = new StreamReader(stream)) { html23 = reader.ReadToEnd(); } if (html23 == "Executat") { counterr = 1; } } if (counterr == 0) { MessageBox.Show("Baza de date offline", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { populateDGV2(); } } } else if (tabel == 3) { } } if (e.Control & e.KeyCode.ToString() == "S") { if (tabel != 0) { using (Form7 form7 = new Form7()) { if (form7.ShowDialog() == System.Windows.Forms.DialogResult.OK) { if (form7.SelectedText == "CSV") { if (tabel == 1) { SaveToCSV(dataGridView1); } else if (tabel == 2) { SaveToCSV(dataGridView2); } else if (tabel == 3) { SaveToCSV(dataGridView3); } else if (tabel == 4) { SaveToCSV(dataGridView4); } } else if (form7.SelectedText == "PDF") { if (tabel == 1) { SavePDF(dataGridView1, "Facturi"); } else if (tabel == 2) { SavePDF(dataGridView2, "Produse"); } else if (tabel == 3) { SavePDF(dataGridView3, "Calculatoare"); } else if (tabel == 4) { SavePDF(dataGridView4, "Telefoane"); } } } } } /* if (tabel == 1) { * SavePDF(dataGridView1); * * } if (tabel == 2) * { * SaveToCSV(dataGridView2); * }*/ } if (e.KeyCode == Keys.G) { if (tabel == 2) { if (dataGridView2.SelectedRows.Count == 0) { } else { int counterr = 0; foreach (DataGridViewRow row in dataGridView2.SelectedRows) { int indexx = int.Parse(row.Index.ToString()); int id; id = int.Parse(dataGridView2.Rows[indexx].Cells["ID"].Value.ToString()); string html23 = string.Empty; string url23 = @"https://localhost:8080/generatesale?produs=" + id; // https://localhost:8080/deletegridu?id=14 Console.WriteLine(url23); HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url23); request.AutomaticDecompression = DecompressionMethods.GZip; using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) using (Stream stream = response.GetResponseStream()) using (StreamReader reader = new StreamReader(stream)) { html23 = reader.ReadToEnd(); } if (html23 == "Executat") { counterr = 1; } } if (counterr == 0) { MessageBox.Show("Baza de date offline", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { populateDGV2(); } } } } if (e.KeyCode == Keys.R) { using (Form11 f8 = new Form11()) { f8.ShowDialog(this); } } }
private void аксToolStripMenuItem_Click(object sender, EventArgs e) { Form7 f7 = new Form7(); f7.ShowDialog(); }
private void button3_Click_2(object sender, EventArgs e) { Form7 hf = new Form7(); hf.ShowDialog(); }
private void toplamaToolStripMenuItem_Click(object sender, EventArgs e) { Form7 invert = new Form7(); invert.ShowDialog(); }
private void Form6_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e) { if (e.KeyCode == Keys.Escape) { //button2.PerformClick(); } if (e.KeyCode == Keys.Oemplus || e.KeyCode == Keys.Add) { if (tabel == 1) { string html2 = string.Empty; int zi = DateTime.Today.Day; int an = DateTime.Today.Year; int luna = DateTime.Today.Month; string url2 = @"https://*****:*****@"https://localhost:8080/createproduct"; // https://localhost:8080/createbill?zi=3&luna=14&an=2444 HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url2); request.AutomaticDecompression = DecompressionMethods.GZip; using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) using (Stream stream = response.GetResponseStream()) using (StreamReader reader = new StreamReader(stream)) { html2 = reader.ReadToEnd(); } if (html2 == "Executat") { populateDGV2(); } else if (html2 == "Baza de date offline") { MessageBox.Show("Baza de date offline", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else if (tabel == 3) { } } if (e.KeyCode == Keys.Delete) { if (tabel == 1) { if (dataGridView1.SelectedRows.Count == 0) { } else { int counterr = 0; foreach (DataGridViewRow row in dataGridView1.SelectedRows) { int indexx = int.Parse(row.Index.ToString()); int id; id = int.Parse(dataGridView1.Rows[indexx].Cells["ID"].Value.ToString()); string html23 = string.Empty; string url23 = @"https://*****:*****@"https://localhost:8080/deletegridproduct?id=" + id; // https://localhost:8080/deletegridu?id=14 HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url23); request.AutomaticDecompression = DecompressionMethods.GZip; using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) using (Stream stream = response.GetResponseStream()) using (StreamReader reader = new StreamReader(stream)) { html23 = reader.ReadToEnd(); } if (html23 == "Executat") { counterr = 1; } } if (counterr == 0) { MessageBox.Show("Baza de date offline", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { populateDGV2(); } } } else if (tabel == 3) { } } if (e.Control & e.KeyCode.ToString() == "S") { if (tabel != 0) { using (Form7 form7 = new Form7()) { if (form7.ShowDialog() == System.Windows.Forms.DialogResult.OK) { if (form7.SelectedText == "CSV") { if (tabel == 1) { SaveToCSV(dataGridView1); } else if (tabel == 2) { SaveToCSV(dataGridView2); } } else if (form7.SelectedText == "PDF") { if (tabel == 1) { SavePDF(dataGridView1, "Facturi"); } else if (tabel == 2) { SavePDF(dataGridView2, "Produse"); } } } } } /* if (tabel == 1) { * SavePDF(dataGridView1); * * } if (tabel == 2) * { * SaveToCSV(dataGridView2); * }*/ } }