public Branches() { InitializeComponent(); cb_CarBrand.DataSource = city.SelectAll(); cb_CarBrand.DisplayMember = "CityName"; cb_CarBrand.ValueMember = "ID"; cb_CarBrand.SelectedIndex = -1; cb_area.DataSource = area.SelectAll(); cb_area.DisplayMember = "AreaName"; cb_area.ValueMember = "ID"; cb_area.SelectedIndex = -1; dataGridView1.DataSource = branch.SelectAll(); }
private void button1_Click(object sender, EventArgs e) { if (btn_save.Tag == null) { brands.Insert(txt_model.Text , int.Parse(cb_CarBrand.SelectedValue.ToString())); } else { brands.Update(txt_model.Text, int.Parse(cb_CarBrand.SelectedValue.ToString()), int.Parse(btn_save.Tag.ToString())); } dataGridView1.AutoGenerateColumns = false; dataGridView1.DataSource = brands.SelectAll(); txt_model.Text = ""; btn_save.Tag = null; cb_CarBrand.SelectedIndex = -1; }
private void Fill() { #region cars brand #endregion #region client Category // ComboBox cb_CarBrand = this.Owner.Controls.Find("cb_cat", true).First() as ComboBox; cb_cat.DataSource = cat.SelectAll(); cb_cat.DisplayMember = "Client_Category"; cb_cat.ValueMember = "ID"; cb_cat.SelectedIndex = -1; #endregion #region City cb_City.DataSource = city.SelectAll(); cb_City.DisplayMember = "CityName"; cb_City.ValueMember = "ID"; cb_City.SelectedIndex = -1; #endregion #region ads cmb_ads.DataSource = how.SelectAll(); cmb_ads.DisplayMember = "HowDidYouUS"; cmb_ads.ValueMember = "ID"; cmb_ads.SelectedIndex = -1; #endregion #region Area cb_area.DataSource = area.SelectAll(); cb_area.DisplayMember = "AreaName"; cb_area.ValueMember = "ID"; cb_area.SelectedIndex = -1; #endregion #region branches cb_branches.DataSource = branch.SelectAll(); cb_branches.DisplayMember = "BranchName"; cb_branches.ValueMember = "ID"; cb_branches.SelectedIndex = -1; #endregion }
private void Validation(out int?catID, out int?ads, out int?_areaID, out int?branchID) { if (cb_City.SelectedIndex == -1 && cb_City.Text != "") { city.Insert(cb_City.Text); #region City cb_City.DataSource = city.SelectAll(); cb_City.DisplayMember = "CityName"; cb_City.ValueMember = "ID"; cb_City.SelectedIndex = -1; #endregion cb_City.SelectedValue = (int)city.SelectAll().Last().ID; } if (cb_area.SelectedIndex == -1 && cb_area.Text != "") { area.Insert(cb_area.Text, int.Parse(cb_City.SelectedValue.ToString())); #region Area cb_area.DataSource = area.SelectAll(); cb_area.DisplayMember = "AreaName"; cb_area.ValueMember = "ID"; cb_area.SelectedIndex = -1; #endregion cb_area.SelectedValue = (int)area.SelectAll().Last().ID; } if (cb_cat.SelectedIndex == -1 && cb_cat.Text != "") { cat.Insert(cb_cat.Text); #region client Category // ComboBox cb_CarBrand = this.Owner.Controls.Find("cb_cat", true).First() as ComboBox; cb_cat.DataSource = cat.SelectAll(); cb_cat.DisplayMember = "Client_Category"; cb_cat.ValueMember = "ID"; cb_cat.SelectedIndex = -1; #endregion cb_cat.SelectedValue = (int)cat.SelectAll().Last().ID; } if (cb_branches.SelectedIndex == -1 && cb_branches.Text != "") { branch.Insert(cb_branches.Text, int.Parse(cb_City.SelectedValue.ToString())); #region branches cb_branches.DataSource = branch.SelectAllByCity(int.Parse(cb_City.SelectedValue.ToString())); cb_branches.DisplayMember = "BranchName"; cb_branches.ValueMember = "ID"; cb_branches.SelectedIndex = -1; #endregion cb_branches.SelectedValue = (int)branch.SelectAll().Last().ID; } if (cmb_ads.SelectedIndex == -1 && cmb_ads.Text != "") { how.Insert(cmb_ads.Text); #region ads cmb_ads.DataSource = how.SelectAll(); cmb_ads.DisplayMember = "HowDidYouUS"; cmb_ads.ValueMember = "ID"; cmb_ads.SelectedIndex = -1; #endregion cmb_ads.SelectedValue = (int)how.SelectAll().Last().ID; } if (cb_CarBrand.SelectedIndex == -1 && cb_CarBrand.Text != "") { brands.Insert(cb_CarBrand.Text); #region cars brand cb_CarBrand.DataSource = brands.SelectAll(); cb_CarBrand.DisplayMember = "BrandName"; cb_CarBrand.ValueMember = "ID"; cb_CarBrand.SelectedIndex = -1; #endregion cb_CarBrand.SelectedValue = (int)brands.SelectAll().Last().ID; } if (cb_model.SelectedIndex == -1 && cb_model.Text != "") { model.Insert(cb_model.Text, int.Parse(cb_CarBrand.SelectedValue.ToString()), "", ""); #region cars brand cb_CarBrand.DataSource = brands.SelectAll(); cb_CarBrand.DisplayMember = "BrandName"; cb_CarBrand.ValueMember = "ID"; cb_CarBrand.SelectedIndex = -1; #endregion cb_CarBrand.SelectedValue = (int)brands.SelectAll().Last().ID; } if (cb_colors.SelectedIndex == -1 && cb_colors.Text != "") { colors.Insert(cb_colors.Text); #region Colors cb_colors.DataSource = colors.SelectAll(); cb_colors.DisplayMember = "ColorName"; cb_colors.ValueMember = "ID"; cb_colors.SelectedIndex = -1; #endregion cb_colors.SelectedValue = (int)colors.SelectAll().Last().ID; } int?areaID; if (cb_area.SelectedIndex != -1) { areaID = int.Parse(cb_area.SelectedValue.ToString()); } int?CityID = null; if (cb_City.SelectedIndex != -1) { CityID = int.Parse(cb_City.SelectedValue.ToString()); } catID = null; if (cb_cat.SelectedIndex != -1) { catID = int.Parse(cb_cat.SelectedValue.ToString()); } ads = null; if (cmb_ads.SelectedIndex != -1) { ads = int.Parse(cmb_ads.SelectedValue.ToString()); } _areaID = null; if (cb_area.SelectedIndex != -1) { _areaID = int.Parse(cb_area.SelectedValue.ToString()); } branchID = null; if (cb_branches.SelectedIndex != -1) { branchID = int.Parse(cb_branches.SelectedValue.ToString()); } }