public MainPage()
{
this.InitializeComponent();
// Register with the Loaded event, and focus
// the departure city box to make it so the user
// can immediately type in their departure city.
this.Loaded += (_, __) =>
{
DepartureCityBox.Focus(FocusState.Programmatic);
};
// We cap out the min/max dates, as users can only book
// flights starting from today's date and ending six
// months in advance.
DepartureDatePicker.MinDate = DateTime.Now;
DepartureDatePicker.MaxDate = DateTime.Now.AddMonths(6);
ReturnDatePicker.MinDate = DateTime.Now;
ReturnDatePicker.MaxDate = DateTime.Now.AddMonths(6);
}
public void showMore()
{
ClientBox.Items.Clear();
CarrierBox.Items.Clear();
DestinationCityBox.Items.Clear();
DepartureCityBox.Items.Clear();
string record_id = this.dataGridView1.CurrentRow.Cells["order_id"].Value.ToString();
//MessageBox.Show(record_id);
//Получение списка клиентов
if (record_id != "")
{
using (SqlConnection con = new SqlConnection(MainForm.connectionString))
{
con.Open();
string command = "select company_name from Clients";
SqlCommand cmd = new SqlCommand(command, con);
SqlDataReader reader = cmd.ExecuteReader();
string[] arr = new string[5];
while (reader.Read())
{
ClientBox.Items.Add(reader["company_name"].ToString());
}
string company_name = this.dataGridView1.CurrentRow.Cells["client_name"].Value.ToString();
ClientBox.SelectedIndex = ClientBox.FindString(company_name);
con.Close();
}
//Получени списка перевозщиков
using (SqlConnection con = new SqlConnection(MainForm.connectionString))
{
con.Open();
string command = "select carrier_name from Carriers";
SqlCommand cmd = new SqlCommand(command, con);
SqlDataReader reader = cmd.ExecuteReader();
string[] arr = new string[5];
while (reader.Read())
{
CarrierBox.Items.Add(reader["carrier_name"].ToString());
}
string carrier_name = this.dataGridView1.CurrentRow.Cells["carrier_name"].Value.ToString();
CarrierBox.SelectedIndex = CarrierBox.FindString(carrier_name);
con.Close();
}
//Получение списка городов
using (SqlConnection con = new SqlConnection(MainForm.connectionString))
{
con.Open();
string command = "select city_name from Cities";
SqlCommand cmd = new SqlCommand(command, con);
SqlDataReader reader = cmd.ExecuteReader();
string[] arr = new string[5];
while (reader.Read())
{
DepartureCityBox.Items.Add(reader["city_name"].ToString());
DestinationCityBox.Items.Add(reader["city_name"].ToString());
}
string destination_city = this.dataGridView1.CurrentRow.Cells["destination_city"].Value.ToString();
DestinationCityBox.SelectedIndex = DestinationCityBox.FindString(destination_city);
string departure_city = this.dataGridView1.CurrentRow.Cells["departure_city"].Value.ToString();
DepartureCityBox.SelectedIndex = DepartureCityBox.FindString(departure_city);
con.Close();
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
string order_status = this.dataGridView1.CurrentRow.Cells["order_status"].Value.ToString();
statusBox.SelectedIndex = statusBox.FindString(order_status);
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
string load_type = this.dataGridView1.CurrentRow.Cells["load_type"].Value.ToString();
loadTypeBox.SelectedIndex = loadTypeBox.FindString(load_type);
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
string carriage_type = this.dataGridView1.CurrentRow.Cells["carriage_type"].Value.ToString();
carriageTypeBox.SelectedIndex = carriageTypeBox.FindString(carriage_type);
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
loadWeightBox.Text = this.dataGridView1.CurrentRow.Cells["load_weight"].Value.ToString();
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
loadVolumeBox.Text = this.dataGridView1.CurrentRow.Cells["load_volume"].Value.ToString();
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
loadNameBox.Text = this.dataGridView1.CurrentRow.Cells["load_name"].Value.ToString();
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
costBox.Text = this.dataGridView1.CurrentRow.Cells["cost"].Value.ToString();
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
DateTime order_date = Convert.ToDateTime(this.dataGridView1.CurrentRow.Cells["order_date"].Value.ToString());
dateTimePicker1.Value = order_date;
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
orderId = Convert.ToInt32(this.dataGridView1.CurrentRow.Cells["order_id"].Value.ToString());
}
}
