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);
}
}
