private void Cmb_brand_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmb_brand.SelectedIndex < 0)
{
return;
}
Vehicle_group_ds.sp_select_vehicle_brand_n_groupDataTable dttable =
Vehicle_group_ds.Select_vehicle_brand_n_group(int.Parse(cmb_brand.SelectedValue.ToString()));
txt_country.Text = dttable.Rows[0]["country_name"].ToString();
DataTable dttable_group = new DataTable();
dttable_group.Columns.Add("value");
dttable_group.Columns.Add("display");
foreach (var i in dttable.Select(i => new { i.vehicle_group, i.vehicle_group_name }).OrderBy(i => i.vehicle_group_name))
{
dttable_group.Rows.Add(i.vehicle_group, i.vehicle_group_name);
}
cmb_group.DataSource = null;
cmb_group.DisplayMember = "display";
cmb_group.ValueMember = "value";
cmb_group.DataSource = dttable_group;
if (cmb_group.Items.Count > 0)
{
cmb_group.SelectedIndex = 0;
}
}
private void Setup_tv_vehicle()
{
Cursor.Current = Cursors.WaitCursor;
tv_vehicle.Nodes.Clear();
Vehicle_group_ds.sp_select_vehicle_brand_n_groupDataTable dttable = Vehicle_group_ds.Select_vehicle_brand_n_group();
// country node
foreach (var i in dttable.Select(i => new { i.country, i.country_name }).Distinct().OrderBy(i => i.country_name))
{
tv_vehicle.Nodes.Add(i.country.ToString(), i.country_name);
}
// vehicle brand node
foreach (var i in dttable.Select(i => new { i.country, i.vehicle_brand, i.vehicle_brand_name }).Distinct().OrderBy(i => i.vehicle_brand_name))
{
tv_vehicle.Nodes[i.country.ToString()].Nodes.Add(i.vehicle_brand.ToString(), i.vehicle_brand_name);
}
// vehicle group name node
foreach (var i in dttable.Select(i => new { i.country, i.vehicle_brand, i.vehicle_group, i.vehicle_group_name }).OrderBy(i => i.vehicle_group_name))
{
tv_vehicle.Nodes[i.country.ToString()].Nodes[i.vehicle_brand.ToString()].Nodes.Add(i.vehicle_group.ToString(), i.vehicle_group_name);
}
Format_brand_group_buttons();
tv_vehicle.ExpandAll();
Cursor.Current = Cursors.Default;
}
private void Form_edit_vehicle_brand_Shown(object sender, EventArgs e)
{
Vehicle_group_ds.sp_select_vehicle_group_for_editDataTable dttable_group = Vehicle_group_ds.Select_vehicle_group_for_edit(_int_brand_id);
grd_main.DataSource = null;
grd_main.DataSource = dttable_group;
grd_main.Columns["vehicle_group"].Visible = false;
if (_int_brand_id == 0)
{
return;
}
Vehicle_group_ds.sp_select_vehicle_brand_n_groupDataTable dttable = Vehicle_group_ds.Select_vehicle_brand_n_group(_int_brand_id);
if (dttable.Rows.Count == 0)
{
return;
}
txt_name.Text = dttable.Rows[0]["vehicle_brand_name"].ToString();
cmb1.SelectedValue = dttable.Rows[0]["country"];
}
