public Form_edit_vehicle_model(int int_group = 0, int int_model = 0) { InitializeComponent(); cmb_brand.DisplayMember = "display"; cmb_brand.ValueMember = "value"; cmb_brand.DataSource = Combobox_options_ds.Option_vehicle_brand(); cmb_fuel_type.DisplayMember = "display"; cmb_fuel_type.ValueMember = "value"; cmb_fuel_type.DataSource = Combobox_options_ds.Select_fuel_type(); cmb_transmission.DisplayMember = "display"; cmb_transmission.ValueMember = "value"; cmb_transmission.DataSource = Combobox_options_ds.Select_transmission(); if (int_group != 0) { Vehicle_brand_ds.vehicle_brandDataTable dttable_brand = Vehicle_brand_ds.Select_veh_brand_by_veh_group(int_group); if (dttable_brand.Rows.Count > 0) { cmb_brand.SelectedValue = dttable_brand.Rows[0]["vehicle_brand"]; } cmb_group.SelectedValue = int_group; } if (int_model != 0) { Model_id = int_model; Vehicle_model_ds.sp_select_vehicle_modelDataTable dttable = Vehicle_model_ds. Select_vehicle_model(-1, -1, -1, int_model); if (dttable.Rows.Count > 0) { _str_ori_edit_model_name = dttable.Rows[0]["vehicle_model_name"].ToString(); txt_model_name.Text = dttable.Rows[0]["vehicle_model_name"].ToString(); cmb_brand.SelectedValue = dttable.Rows[0]["vehicle_brand"].ToString(); txt_country.Text = dttable.Rows[0]["country_name"].ToString(); cmb_group.SelectedValue = dttable.Rows[0]["vehicle_group"].ToString(); num_engine.Value = int.Parse(dttable.Rows[0]["engine_capacity"].ToString()); num_no_of_door.Value = int.Parse(dttable.Rows[0]["no_of_door"].ToString()); num_seat_capacity.Value = int.Parse(dttable.Rows[0]["seat_capacity"].ToString()); cmb_fuel_type.SelectedValue = int.Parse(dttable.Rows[0]["fuel_type"].ToString()); cmb_transmission.SelectedValue = int.Parse(dttable.Rows[0]["transmission"].ToString()); txt_remarks.Text = dttable.Rows[0]["Remarks"].ToString(); } } this.tabControl1.SelectedIndexChanged += new System.EventHandler(this.Initilise_grd_img); }
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(); }