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 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 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"];
}
private void Btn_ok_Click(object sender, EventArgs e)
{
// reset all grd_group rows back color
foreach (DataGridViewRow grd_row in grd_main.Rows)
{
if (!grd_row.IsNewRow)
{
grd_row.DefaultCellStyle.BackColor = Color.Empty;
}
}
string str_brand_name = txt_name.Text.Trim();
if (str_brand_name == "")
{
MessageBox.Show("Brand name is required!", "Invalid input", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (cmb1.SelectedIndex < 0)
{
MessageBox.Show("Please select a country.", "Invalid input", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
int int_country = int.Parse(cmb1.SelectedValue.ToString());
if (!Vehicle_brand_ds.Is_vehicle_brand_name_available(str_brand_name, _int_brand_id))
{
MessageBox.Show("Brand name already exists! Please input new brand name.",
"Invalid input", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DataTable dttable_vehicle_group = ((DataTable)grd_main.DataSource).Copy();
if (dttable_vehicle_group.Rows.Count == 0)
{
MessageBox.Show("At least one vehicle group is required.", "Invalid input",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
int distinct_group_name_count = (from DataRow row in dttable_vehicle_group.Rows
select row["vehicle_group_name"].ToString().ToUpper()).Distinct().ToList().Count;
if (distinct_group_name_count != dttable_vehicle_group.Rows.Count)
{
MessageBox.Show("Duplicate vehicle group found. Please check and retry.",
"Invalid input", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (_int_brand_id == 0)
{
_int_brand_id = Vehicle_brand_ds.Insert_vehicle_brand(str_brand_name, int_country);
}
else
{
Vehicle_brand_ds.Update_vehicle_brand(_int_brand_id, str_brand_name, int_country);
}
DataColumn dt_col1 = new DataColumn("Created_by", typeof(int))
{
DefaultValue = Program.System_user.UserID
};
dttable_vehicle_group.Columns.Add(dt_col1);
Bulkcopy_table_ds.Delete_by_user();
using (SqlConnection conn = new SqlConnection(Properties.Settings.Default.VehicleDealershipConnectionString))
{
conn.Open();
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(conn))
{
bulkCopy.DestinationTableName = "[misc].[bulkcopy_table]";
try
{
bulkCopy.ColumnMappings.Add("vehicle_group", "vehicle_group");
bulkCopy.ColumnMappings.Add("vehicle_group_name", "vehicle_group_name");
bulkCopy.ColumnMappings.Add("created_by", "created_by");
bulkCopy.WriteToServer(dttable_vehicle_group);
}
catch (Exception ex)
{
MessageBox.Show("An error has occurred. Vehicle groups cannot be updated. \n\n Message: " +
ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
conn.Close();
}
Vehicle_group_ds.Update_insert_vehicle_group(_int_brand_id);
this.DialogResult = DialogResult.OK;
this.Close();
}
