private void Form9_Load(object sender, EventArgs e) { try { string v = cm.GetCurrentMethod(); logger.Info(v); if (Program.fotoUser == false) { con = new SqlConnection(connectionString); con.Open(); string vyUserSelect = "SELECT FotoOfDriverLicense FROM Photos Where idUser ='******'"; SqlCommand vyUser = new SqlCommand(vyUserSelect, con); String vyUserString = (String)(vyUser).ExecuteScalar(); pictureBox1.Image = Image.FromFile(vyUserString); con.Close(); } if (Program.fotoUser == true) { con = new SqlConnection(connectionString); con.Open(); string vyUserSelect = "SELECT FotoOfPassport FROM Photos Where idUser ='******'"; SqlCommand vyUser = new SqlCommand(vyUserSelect, con); String vyUserString = (String)(vyUser).ExecuteScalar(); pictureBox1.Image = Image.FromFile(vyUserString); con.Close(); } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); string method = cm.GetCurrentMethod(); logger.Error(ex.ToString() + method); } }
private void GetData(string selectCommand) { try { string v = cm.GetCurrentMethod(); logger.Info(v); dataGridView1.AutoGenerateColumns = true; dataAdapter = new SqlDataAdapter(selectCommand, connectionString); // Create a command builder to generate SQL update, insert, and // delete commands based on selectCommand. SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter); // Populate a new data table and bind it to the BindingSource. DataTable table = new DataTable { Locale = CultureInfo.InvariantCulture }; dataAdapter.Fill(table); bindingSource1.DataSource = table; // Resize the DataGridView columns to fit the newly loaded content. } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); string method = cm.GetCurrentMethod(); logger.Error(ex.ToString() + method); } }
private void Form2_Load(object sender, EventArgs e) { bool isRole = IsRunAsAdmin(); if (isRole is false) { MessageBox.Show("В процессе работы данного приложения происходит чтение и запись файлов.\r Для корректной работы, пожалуйста запустите программу от имени администратора.\r Приложение будет закрыто.", "Не обнаружены права администратора", MessageBoxButtons.OK, MessageBoxIcon.Information); Application.Exit(); } string v = cm.GetCurrentMethod(); logger.Info(v); textBox1.Text = System.Net.Dns.GetHostName() + "\\SQLEXPRESS;"; textBox2.Text = "Diplom"; }
private void label4_Click(object sender, EventArgs e) { string v = cm.GetCurrentMethod(); logger.Info(v); this.Size = new Size(0, 0); this.CenterToScreen(); f4 = new Form4(); f4.ShowDialog(); this.Size = new Size(770, 415); this.CenterToScreen(); }
private void Form19_Load(object sender, EventArgs e) { try { string v = cm.GetCurrentMethod(); logger.Info(v); con = new SqlConnection(connectionString); con.Open(); string idUserSelect = "SELECT idUser FROM Poezdka Where idPoezdki = '" + Program.getIdTrip + " '"; SqlCommand idUser = new SqlCommand(idUserSelect, con); Int32 idUserInt = (Int32)(idUser).ExecuteScalar(); string fioUserSelect = "SELECT Fio FROM Polzovatel Where IdUser = '******'"; SqlCommand fioUser = new SqlCommand(fioUserSelect, con); String fioUserString = (String)(fioUser).ExecuteScalar(); label3.Text = fioUserString; string timeOfStartSelect = "SELECT TimeOfStart FROM Poezdka Where idPoezdki = '" + Program.getIdTrip + " '"; SqlCommand timeOfStart = new SqlCommand(timeOfStartSelect, con); DateTime timeOfStartString = (DateTime)(timeOfStart).ExecuteScalar(); label4.Text = timeOfStartString.ToString(); string timeOfEndSelect = "SELECT TimeOfEnd FROM Poezdka Where idPoezdki = '" + Program.getIdTrip + " '"; SqlCommand timeOfEnd = new SqlCommand(timeOfEndSelect, con); DateTime timeOfEndString = (DateTime)(timeOfEnd).ExecuteScalar(); label6.Text = timeOfEndString.ToString(); string timeOfTripSelect = "SELECT Dlitelnost FROM Poezdka Where idPoezdki = '" + Program.getIdTrip + " '"; SqlCommand timeOfTrip = new SqlCommand(timeOfTripSelect, con); Int32 timeOfTripInt = (Int32)(timeOfTrip).ExecuteScalar(); var ts = TimeSpan.FromMinutes(Convert.ToDouble(timeOfTripInt)); label8.Text = String.Format("{0} д. {1} ч. {2} м. ", ts.Days, ts.Hours, ts.Minutes); string costOfTripSelect = "SELECT Stoim FROM Poezdka Where idPoezdki = '" + Program.getIdTrip + " '"; SqlCommand costOfTrip = new SqlCommand(costOfTripSelect, con); Int32 costOfTripInt = (Int32)(costOfTrip).ExecuteScalar(); label10.Text = Convert.ToString(costOfTripInt) + " р."; string idAvtoSelect = "SELECT idAvto FROM Poezdka Where idPoezdki = '" + Program.getIdTrip + " '"; SqlCommand idAvto = new SqlCommand(idAvtoSelect, con); Int32 idAvtoInt = (Int32)(idAvto).ExecuteScalar(); string markaAvtoSelect = "SELECT Marka FROM Avto Where idAvto = '" + idAvtoInt + " '"; SqlCommand markaAvto = new SqlCommand(markaAvtoSelect, con); String markaAvtoString = (String)(markaAvto).ExecuteScalar(); string nameAvtoSelect = "SELECT Nazvanie FROM Avto Where idAvto = '" + idAvtoInt + " '"; SqlCommand nameAvto = new SqlCommand(nameAvtoSelect, con); String nameAvtoString = (String)(nameAvto).ExecuteScalar(); label12.Text = markaAvtoString + " " + nameAvtoString; string idTarifSelect = "SELECT idTarifa FROM Poezdka Where idPoezdki = '" + Program.getIdTrip + " '"; SqlCommand idTarif = new SqlCommand(idTarifSelect, con); Int32 idTarifInt = (Int32)(idTarif).ExecuteScalar(); string nameOfTarifSelect = "SELECT Nazvanie FROM Tarif Where idTarifa = '" + idTarifInt + " '"; SqlCommand nameOfTarif = new SqlCommand(nameOfTarifSelect, con); String nameOfTarifString = (String)(nameOfTarif).ExecuteScalar(); string typeOfTarifSelect = "SELECT TipTarifa FROM Tarif Where idTarifa = '" + idTarifInt + " '"; SqlCommand typeOfTarif = new SqlCommand(typeOfTarifSelect, con); String typeOfTarifString = (String)(typeOfTarif).ExecuteScalar(); label14.Text = nameOfTarifString + ", " + typeOfTarifString; try { string idProizSelect = "SELECT idProischestviya FROM Poezdka Where idPoezdki = '" + Program.getIdTrip + " '"; SqlCommand idProiz = new SqlCommand(idProizSelect, con); Int32 idProizInt = (Int32)(idProiz).ExecuteScalar(); string opicanieProizSelect = "SELECT Opicanie FROM Proishestviya Where idProischestviya = '" + idProizInt + " '"; SqlCommand opicanieProiz = new SqlCommand(opicanieProizSelect, con); String opicanieProizString = (String)(opicanieProiz).ExecuteScalar(); label16.Text = opicanieProizString; label16.ForeColor = Color.Red; } catch (Exception) { label16.Text = "Отсутствуют"; label16.ForeColor = Color.Green; } try { string otzyvSelect = "SELECT Otzyv FROM Poezdka Where idPoezdki = '" + Program.getIdTrip + " '"; SqlCommand otzyv = new SqlCommand(otzyvSelect, con); String otzyvString = (String)(otzyv).ExecuteScalar(); richTextBox1.Text = otzyvString; } catch (Exception) { richTextBox1.Text = "Пользователь не оставил отзыв на эту поездку"; } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); string method = cm.GetCurrentMethod(); logger.Error(ex.ToString() + method); } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { try { string v = cm.GetCurrentMethod(); logger.Info(v); con = new SqlConnection(connectionString); con.Open(); comboBox2.Enabled = true; string query; query = String.Format("SELECT Tip FROM KlassAvto Where Klass = '" + comboBox1.Text + " '", con); SqlCommand cmd1 = new SqlCommand(query, con); DataTable tbl1 = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd1); da.Fill(tbl1); this.comboBox2.DataSource = tbl1; this.comboBox2.DisplayMember = "Tip"; // столбец для отображения //this.comboBox2.ValueMember = idKlassa";//столбец с id // this.comboBox2.SelectedIndex = 1; con.Close(); } catch (Exception ex) { //MessageBox.Show(ex.ToString(), "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); string method = cm.GetCurrentMethod(); logger.Error(ex.ToString() + method); } }
private void Form8_Load(object sender, EventArgs e) { try { string v = cm.GetCurrentMethod(); logger.Info(v); con = new SqlConnection(connectionString); con.Open(); string vyUserSelect = "SELECT FotoOfFace FROM Photos Where idUser ='******'"; SqlCommand vyUser = new SqlCommand(vyUserSelect, con); String vyUserString = (String)(vyUser).ExecuteScalar(); pictureBox1.Image = Image.FromFile(vyUserString); string fioUserSelect = "SELECT Fio FROM Polzovatel Where IdUser = '******'"; SqlCommand fioUser = new SqlCommand(fioUserSelect, con); String fioUserString = (String)(fioUser).ExecuteScalar(); label3.Text = fioUserString; string numberOfPassportUserSelect = "SELECT NomerPassporta FROM Polzovatel Where IdUser = '******'"; SqlCommand numberOfPassportUser = new SqlCommand(numberOfPassportUserSelect, con); String numberOfPassportUserString = (String)(numberOfPassportUser).ExecuteScalar(); label4.Text = numberOfPassportUserString; string propiskaUserSelect = "SELECT Propiska FROM Polzovatel Where IdUser = '******'"; SqlCommand propiskaUser = new SqlCommand(propiskaUserSelect, con); String propiskaUserString = (String)(propiskaUser).ExecuteScalar(); label6.Text = propiskaUserString; string dayOfBirthdayUserSelect = "SELECT DataRozdeniya FROM Polzovatel Where IdUser = '******'"; SqlCommand dayOfBirthdayUser = new SqlCommand(dayOfBirthdayUserSelect, con); DateTime dayOfBirthdayUserString = (DateTime)(dayOfBirthdayUser).ExecuteScalar(); var date = dayOfBirthdayUserString.ToShortDateString(); label8.Text = Convert.ToString(date); string numberOfDriverLicenseUserSelect = "SELECT NomerVY FROM Polzovatel Where IdUser = '******'"; SqlCommand numberOfDriverLicenseUser = new SqlCommand(numberOfDriverLicenseUserSelect, con); String numberOfDriverLicenseUserString = (String)(numberOfDriverLicenseUser).ExecuteScalar(); label10.Text = numberOfDriverLicenseUserString; string statusUserSelect = "SELECT StatusPodtverzdeniya FROM Polzovatel Where IdUser = '******'"; SqlCommand statusUser = new SqlCommand(statusUserSelect, con); Boolean statusUserString = (Boolean)(statusUser).ExecuteScalar(); var status = statusUserString.ToString(); label12.Text = status; if (label12.Text == "False") { label12.Text = "Не подтвержден"; label18.Text = "-"; } else if (label12.Text == "True") { label12.Text = "Подтвержден"; } string emailUserSelect = "SELECT Email FROM Polzovatel Where IdUser = '******'"; SqlCommand emailUser = new SqlCommand(emailUserSelect, con); String emailUserString = (String)(emailUser).ExecuteScalar(); label14.Text = emailUserString; string mobilePhoneUserSelect = "SELECT MobilePhone FROM Polzovatel Where IdUser = '******'"; SqlCommand mobilePhoneUser = new SqlCommand(mobilePhoneUserSelect, con); String mobilePhoneUserString = (String)(mobilePhoneUser).ExecuteScalar(); label16.Text = mobilePhoneUserString; string countTripsUserSelect = "Select Count (*) From Poezdka WHERE idUser = '******'"; SqlCommand countTripsUser = new SqlCommand(countTripsUserSelect, con); Int32 countTripsUserString = (Int32)(countTripsUser).ExecuteScalar(); label18.Text = countTripsUserString.ToString(); if (label12.Text == "Не подтвержден") { label18.Text = "-"; } try { string sumOfTripsUserSelect = "Select SUM(Stoim) From Poezdka WHERE idUser = '******'"; SqlCommand sumOfTripsUser = new SqlCommand(sumOfTripsUserSelect, con); Int32 sumOfTripsUserString = (Int32)(sumOfTripsUser).ExecuteScalar(); label20.Text = sumOfTripsUserString.ToString() + "р."; } catch (Exception) { if (label12.Text == "Не подтвержден") { label20.Text = "-"; } else if (label12.Text == "Подтвержден") { label20.Text = "0"; } } string countProisUserSelect = "Select Count (idProischestviya) From Poezdka WHERE idUser = '******'"; SqlCommand countProisTripsUser = new SqlCommand(countProisUserSelect, con); Int32 countProisUserString = (Int32)(countProisTripsUser).ExecuteScalar(); label22.Text = countProisUserString.ToString(); if (label22.Text != "0") { label22.ForeColor = Color.Red; } if (label12.Text == "Не подтвержден") { label22.Text = "-"; } try { string sumOfTimeUserSelect = "Select SUM(Dlitelnost) From Poezdka WHERE idUser = '******'"; SqlCommand sumOfTimeUser = new SqlCommand(sumOfTimeUserSelect, con); Int32 sumOfTimeUserString = (Int32)(sumOfTimeUser).ExecuteScalar(); var ts = TimeSpan.FromMinutes(sumOfTimeUserString); label24.Text = String.Format("{0} д. {1} ч. {2} м. ", ts.Days, ts.Hours, ts.Minutes); } catch (Exception) { if (label12.Text == "Не подтвержден") { label24.Text = "-"; } else if (label12.Text == "Подтвержден") { label24.Text = "0"; } } if (label12.Text == "Не подтвержден") { button2.Visible = true; } else if (label12.Text == "Подтвержден") { button2.Visible = true; } SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM Messages Where IdUser = '******' ", con); DataTable dt = new DataTable(); sda.Fill(dt); for (int i = 0; i < dt.Rows.Count; i++) { if ((bool)dt.Rows[i]["StatusPolzv"] == true) { string who; who = "Пользователь: "; string name = dt.Rows[i]["Text"].ToString(); richTextBox1.Text = who + name + "\r\n" + richTextBox1.Text; } else { string who; who = "Вы: "; string name = dt.Rows[i]["Text"].ToString(); richTextBox1.Text = who + name + "\r\n" + richTextBox1.Text; } } con.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); string method = cm.GetCurrentMethod(); logger.Error(ex.ToString() + method); } }
private void Form16_Load(object sender, EventArgs e) { try { string v = cm.GetCurrentMethod(); logger.Info(v); con = new SqlConnection(connectionString); con.Open(); string fioUserSelect = "SELECT Fio FROM Polzovatel Where IdUser = '******'"; SqlCommand fioUser = new SqlCommand(fioUserSelect, con); String fioUserString = (String)(fioUser).ExecuteScalar(); label1.Text = "Спасибо за поездку " + fioUserString + "!"; } catch (Exception ex) { string method = cm.GetCurrentMethod(); logger.Error(ex.ToString() + method); } }
private void Form1_Load(object sender, EventArgs e) { try { String connectionString1 = @"Data Source=" + Program.serverName + "Initial Catalog=" + Program.bdName + ";" + "Integrated Security=True"; con1 = new SqlConnection(connectionString1); con1.Open(); CarSharing.Properties.Settings.Default.DiplomConnectionString = connectionString1; string firstNewSelect = "SELECT TOP (1) KratkoeOpicanie FROM News ORDER BY idNews DESC"; SqlCommand firstNew = new SqlCommand(firstNewSelect, con); String firstNewString = (String)(firstNew).ExecuteScalar(); label3.Text = firstNewString; string firstNewFullSelect = "SELECT TOP (1) PolnoeOpicanie FROM News ORDER BY idNews DESC"; SqlCommand firstNewFull = new SqlCommand(firstNewFullSelect, con); String firstNewFullString = (String)(firstNewFull).ExecuteScalar(); label2.Text = firstNewFullString; string newPicture = "SELECT TOP (1) Izobrazenie FROM News ORDER BY idNews DESC"; SqlCommand sqlnewPicture = new SqlCommand(newPicture, con); String pictureString = (String)(sqlnewPicture).ExecuteScalar(); pictureBox1.Image = Image.FromFile(pictureString); SqlDataAdapter sda1 = new SqlDataAdapter("select top(2) * from News order by idNews desc", con); DataTable dt1 = new DataTable(); sda1.Fill(dt1); label4.Text = dt1.Rows[1][1].ToString(); label5.Text = dt1.Rows[1][2].ToString(); pictureBox2.Image = Image.FromFile(dt1.Rows[1][3].ToString()); con1.Close(); string v = cm.GetCurrentMethod(); logger.Info(v); } catch (Exception ex) { string method = cm.GetCurrentMethod(); logger.Error(ex.ToString() + method); } }
private void button2_Click(object sender, EventArgs e) { try { string v = cm.GetCurrentMethod(); logger.Info(v); String insertValueName = textBox1.Text; String insertValueSurname = textBox2.Text; String insertValueSecondName = textBox3.Text; String insertValueFio = insertValueSurname + " " + insertValueName + " " + insertValueSecondName; String insertValueNumberOfPassport = maskedTextBox2.Text; String insertValuePlaceOfRegistration = richTextBox1.Text; String insertValueDateOfBirthday = dateTimePicker1.Value.ToString(); String insertValueNumberOfDriverLicense = maskedTextBox1.Text; String insertValueEmail = textBox6.Text; String insertValueMobilePhone = maskedTextBox3.Text; String insertValueStatus = "0"; if (maskedTextBox2.Text.Length != 10) { MessageBox.Show("Пожалуйста, заполните до конца номер паспорта", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Warning); maskedTextBox2.Focus(); return; } if (maskedTextBox1.Text.Length != 10) { MessageBox.Show("Пожалуйста, заполните до конца номер водительского удостоверения", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Warning); maskedTextBox1.Focus(); return; } if (maskedTextBox3.Text.Length != 18) { MessageBox.Show("Пожалуйста, заполните до конца номер телефона", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Warning); maskedTextBox3.Focus(); return; } con = new SqlConnection(connectionString); con.Open(); SqlDataAdapter sda = new SqlDataAdapter("Select Count (*) From Polzovatel WHERE Email = '" + insertValueEmail + " '", con); DataTable dt = new DataTable(); sda.Fill(dt); SqlDataAdapter sd1 = new SqlDataAdapter("Select Count (*) From Polzovatel WHERE NomerPassporta = '" + insertValueNumberOfPassport + " '", con); DataTable dt1 = new DataTable(); sd1.Fill(dt1); SqlDataAdapter sd2 = new SqlDataAdapter("Select Count (*) From Polzovatel WHERE NomerVY = '" + insertValueNumberOfDriverLicense + " '", con); DataTable dt2 = new DataTable(); sd2.Fill(dt2); SqlDataAdapter sd3 = new SqlDataAdapter("Select Count (*) From Polzovatel WHERE MobilePhone = '" + insertValueMobilePhone + " '", con); DataTable dt3 = new DataTable(); sd3.Fill(dt3); if (dt1.Rows[0][0].ToString() != "0") { MessageBox.Show("Данный номер паспорта уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (dt2.Rows[0][0].ToString() != "0") { MessageBox.Show("Данный номер Водительского Удостоверения уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (dt.Rows[0][0].ToString() != "0") { MessageBox.Show("Такой адрес электронной почты уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (dt3.Rows[0][0].ToString() != "0") { MessageBox.Show("Такой номер телефона уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { string sqlInsertNewUser = string.Format("INSERT INTO Polzovatel (Fio, NomerPassporta, Propiska, DataRozdeniya, NomerVY, StatusPodtverzdeniya, Email, MobilePhone) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', {5}, '{6}', '{7}')", insertValueFio, insertValueNumberOfPassport, insertValuePlaceOfRegistration, insertValueDateOfBirthday, insertValueNumberOfDriverLicense, insertValueStatus, insertValueEmail, insertValueMobilePhone); SqlCommand insNewUser = new SqlCommand(sqlInsertNewUser, con); insNewUser.ExecuteNonQuery(); textBox1.Enabled = false; textBox2.Enabled = false; textBox3.Enabled = false; maskedTextBox2.Enabled = false; maskedTextBox1.Enabled = false; richTextBox1.Enabled = false; dateTimePicker1.Enabled = false; textBox5.Enabled = false; textBox6.Enabled = false; maskedTextBox3.Enabled = false; button2.Enabled = false; textBox9.Enabled = true; textBox8.Enabled = true; button4.Enabled = true; textBox5.Enabled = true; checkInsert = false; closing = false; checkBox2.Enabled = true; } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); string method = cm.GetCurrentMethod(); logger.Error(ex.ToString() + method); } }
private void Form5_Load(object sender, EventArgs e) { try { string v = cm.GetCurrentMethod(); logger.Info(v); this.Name = "Администрирование"; con = new SqlConnection(connectionString); con.Open(); string countTripsSelect = "Select Count (idPoezdki) From Poezdka "; SqlCommand countTrips = new SqlCommand(countTripsSelect, con); Int32 countTripsString = (Int32)(countTrips).ExecuteScalar(); label3.Text = countTripsString.ToString(); try { string sumTripsSelect = "Select SUM (Stoim) From Poezdka "; SqlCommand sumTrips = new SqlCommand(sumTripsSelect, con); Int32 sumTripsString = (Int32)(sumTrips).ExecuteScalar(); label4.Text = sumTripsString.ToString() + " р."; } catch (Exception) { label4.Text = "0"; } string countProisSelect = "Select Count (idProischestviya) From Poezdka "; SqlCommand countProis = new SqlCommand(countProisSelect, con); Int32 countProisString = (Int32)(countProis).ExecuteScalar(); label6.Text = countProisString.ToString(); string countAvtoSelect = "Select Count (idAvto) From Avto "; SqlCommand countAvto = new SqlCommand(countAvtoSelect, con); Int32 countAvtoString = (Int32)(countAvto).ExecuteScalar(); label8.Text = countAvtoString.ToString(); string countAvtoRepairSelect = "Select Count (idAvto) From Avto WHERE StatusDostypa = 1 "; SqlCommand countAvtoRepair = new SqlCommand(countAvtoRepairSelect, con); Int32 countAvtoRepairString = (Int32)(countAvtoRepair).ExecuteScalar(); label11.Text = countAvtoRepairString.ToString(); string countUsersSelect = "Select Count (idUser) From AutDate "; SqlCommand countUsers = new SqlCommand(countUsersSelect, con); Int32 countUsersString = (Int32)(countUsers).ExecuteScalar(); label14.Text = countUsersString.ToString(); string countUsersPotrSelect = "Select Count (IdUser) From Polzovatel WHERE StatusPodtverzdeniya = 1 "; SqlCommand countUsersPotr = new SqlCommand(countUsersPotrSelect, con); Int32 countUsersPotrString = (Int32)(countUsersPotr).ExecuteScalar(); label12.Text = countUsersPotrString.ToString(); string timeOfTripSelect = "SELECT SUM(Dlitelnost) FROM Poezdka"; SqlCommand timeOfTrip = new SqlCommand(timeOfTripSelect, con); Int32 timeOfTripInt = (Int32)(timeOfTrip).ExecuteScalar(); Int32 medianTimeOfTrip = timeOfTripInt / countTripsString; var ts = TimeSpan.FromMinutes(Convert.ToDouble(timeOfTripInt)); label16.Text = String.Format("{0} д. {1} ч. {2} м. ", ts.Days, ts.Hours, ts.Minutes); var ts2 = TimeSpan.FromMinutes(Convert.ToDouble(medianTimeOfTrip)); label18.Text = String.Format("{0} д. {1} ч. {2} м. ", ts2.Days, ts2.Hours, ts2.Minutes); SqlDataAdapter sda = new SqlDataAdapter("select idAvto, count(*) as num from Poezdka group by idAvto order by count(*) desc", con); DataTable dt = new DataTable(); sda.Fill(dt); String idAvtoString = dt.Rows[0][0].ToString(); Int32 idAvto = Convert.ToInt32(idAvtoString); string markaAvtoSelect = "Select Marka From Avto WHERE idAvto = '" + idAvto + " ' "; SqlCommand markaAvto = new SqlCommand(markaAvtoSelect, con); string markaAvtoString = (string)(markaAvto).ExecuteScalar(); string nazvanieAvtoSelect = "Select Nazvanie From Avto WHERE idAvto = '" + idAvto + " ' "; SqlCommand nazvanieAvto = new SqlCommand(nazvanieAvtoSelect, con); string nazvanieAvtoString = (string)(nazvanieAvto).ExecuteScalar(); string gosNomerAvtoSelect = "Select GosNomer From Avto WHERE idAvto = '" + idAvto + " ' "; SqlCommand gosNomerAvto = new SqlCommand(gosNomerAvtoSelect, con); string gosNomerAvtoString = (string)(gosNomerAvto).ExecuteScalar(); label20.Text = markaAvtoString + ", " + nazvanieAvtoString + ", " + gosNomerAvtoString; String countOfTripsString = dt.Rows[0][1].ToString(); label22.Text = countOfTripsString; SqlDataAdapter sda1 = new SqlDataAdapter("select idTarifa, count(*) as num from Poezdka group by idTarifa order by count(*) desc", con); DataTable dt1 = new DataTable(); sda1.Fill(dt1); String idTarifaString = dt1.Rows[0][0].ToString(); Int32 idTarifa = Convert.ToInt32(idTarifaString); string nameOfTarifSelect = "Select Nazvanie From Tarif WHERE idTarifa = '" + idTarifa + " ' "; SqlCommand nameOfTarif = new SqlCommand(nameOfTarifSelect, con); string nameOfTarifString = (string)(nameOfTarif).ExecuteScalar(); string typeOfTarifSelect = "Select TipTarifa From Tarif WHERE idTarifa = '" + idTarifa + " ' "; SqlCommand typeOfTarif = new SqlCommand(typeOfTarifSelect, con); string typeOfTarifString = (string)(typeOfTarif).ExecuteScalar(); string timeOfTarifSelect = "Select VremyaTarifa From Tarif WHERE idTarifa = '" + idTarifa + " ' "; SqlCommand timeOfTarif = new SqlCommand(timeOfTarifSelect, con); string timeOfTarifString = (string)(timeOfTarif).ExecuteScalar(); label24.Text = typeOfTarifString + ", " + timeOfTarifString + ", " + nameOfTarifString; String countOfTripsTarifString = dt1.Rows[0][1].ToString(); label26.Text = countOfTripsTarifString; string countPovrSelect = "Select Count (idPovrezdeniya) From Povrezdeniya "; SqlCommand countPovr = new SqlCommand(countPovrSelect, con); Int32 countPovrString = (Int32)(countPovr).ExecuteScalar(); label28.Text = countPovrString.ToString(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); string method = cm.GetCurrentMethod(); logger.Error(ex.ToString() + method); } }