private void dgv_liste__CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (dgv_liste_.CurrentRow.Cells["_id_"].Value != null) { Int32 id = Convert.ToInt32(dgv_liste_.CurrentRow.Cells["_id_"].Value); if (id > 0) { Marque f = MarqueBLL.One(id); if (e.ColumnIndex == 4) { if (DialogResult.Yes == Messages.Confirmation(Mots.Supprimer.ToLower())) { if (MarqueBLL.Delete(f)) { DeleteRow_(f); Reset_(); Messages.Succes(); } } } else { Populate_(f); } } } } catch (Exception ex) { Messages.Exception(ex); } }
private void btn_save__Click(object sender, EventArgs e) { Recopie_(); if (current_.Control()) { if (!current_.Update) { Marque f = MarqueBLL.Save(current_); if (f != null ? f.Id > 0 : false) { current_.Id = f.Id; current_.Update = true; AddRow_(f); Messages.Succes(); } } else { if (MarqueBLL.Update(current_)) { UpdateRow_(current_); Messages.Succes(); } } Reset_(); } }
private void btn_save_Click(object sender, EventArgs e) { Marque f = new Marque(); f.Reference = txt_reference.Text.Trim(); f.Designation = txt_designation.Text.Trim(); if (f.Control()) { f = MarqueBLL.Save(f); if (f != null ? f.Id > 0 : false) { current.marques.Add(f); if (current.current != null ? current.current.Id > 0 : false) { current.current.Marque = f; } current.com_marque.Refresh(); current.com_marque.DisplayMember = "Designation"; current.com_marque.ValueMember = "Id"; current.com_marque.DataSource = new BindingSource(current.marques, null); current.com_marque.Text = f.Designation; current.com_marque.AutoCompleteCustomSource.Add(f.Designation); this.Close(); } } }
private void LoadGrille_() { dgv_liste_.Rows.Clear(); string query = "select * from marque order by id"; List <Marque> l = MarqueBLL.List(query); foreach (Marque f in l) { AddRow_(f); } Reset_(); }
private void txt_search__TextChanged(object sender, EventArgs e) { string search = txt_search_.Text.Trim(); dgv_liste_.Rows.Clear(); string query = "select * from marque where reference like '" + search + "%' or designation like '" + search + "%' or description like '" + search + "%'"; List <Marque> l = MarqueBLL.List(query); foreach (Marque f in l) { AddRow_(f); } Reset_(); }
private void btn_delete__Click(object sender, EventArgs e) { if (current_ != null ? current_.Id > 0 : false) { if (DialogResult.Yes == Messages.Confirmation(Mots.Supprimer.ToLower())) { if (MarqueBLL.Delete(current_)) { DeleteRow_(current_); Reset_(); Messages.Succes(); } } } }
private void LoadAllMarques() { marques.Clear(); string query = "select * from marque order by id"; marques = MarqueBLL.List(query); com_marque.DisplayMember = "Designation"; com_marque.ValueMember = "Id"; com_marque.DataSource = new BindingSource(marques, null); foreach (Marque f in marques) { com_marque.AutoCompleteCustomSource.Add(f.Designation); } com_marque.AutoCompleteMode = AutoCompleteMode.SuggestAppend; com_marque.AutoCompleteSource = AutoCompleteSource.CustomSource; if (current != null ? current.Id > 0 : false) { com_marque.ResetText(); } }
private void dgv_liste__SelectionChanged(object sender, EventArgs e) { try { if (dgv_liste_.Rows.Count > 0) { if (dgv_liste_.CurrentRow.Cells["_id_"].Value != null) { Int32 id = (Int32)dgv_liste_.CurrentRow.Cells["_id_"].Value; if (id > 0) { Marque f = MarqueBLL.One(id); Populate_(f); } } } } catch (Exception ex) { Messages.Exception(ex); } }