//check all columns for a matching word
public static List <adv_order> find(string word)
{
SqlConnection cn = connection.getConnection();
SqlCommand cmd = new SqlCommand();
SqlDataReader dr;
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
cmd.Connection = cn;
cmd.CommandText = "select * from adv_order where id_adv_order like @word or type_adv_order like @word or cin like @word or nom like @word or representant_legal like @word or registre_commerce like @word or adresse like @word";
cmd.Parameters.Add("@word", word);
dr = cmd.ExecuteReader();
List <adv_order> listCl = new List <adv_order>();
while (dr.Read())
{
adv_order cl = new adv_order();
cl.id_adv_order = (int)dr["id_adv_order"];
cl.type_adv_order = (string)dr["type_adv_order"];
cl.cin = (string)dr["cin"];
cl.nom = (string)dr["nom"];
cl.representant_legal = (string)dr["representant_legal"];
cl.registre_commerce = (string)dr["registre_commerce"];
cl.adresse = (string)dr["adresse"];
listCl.Add(cl);
}
dr.Close();
cn.Close();
return(listCl);
}
//find a record by it's id
public static adv_order findById(int id)
{
SqlConnection cn = connection.getConnection();
SqlCommand cmd = new SqlCommand();
SqlDataReader dr;
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
cmd.Connection = cn;
cmd.CommandText = "select * from adv_order where id_adv_order = @id";
cmd.Parameters.Add("@id", id);
dr = cmd.ExecuteReader();
dr.Read();
adv_order advOrd = new adv_order();
advOrd.id_adv_order = id;
advOrd.type_adv_order = (string)dr["type_adv_order"];
advOrd.cin = (string)dr["cin"];
advOrd.nom = (string)dr["nom"];
advOrd.representant_legal = (string)dr["representant_legal"];
advOrd.registre_commerce = (string)dr["registre_commerce"];
advOrd.adresse = (string)dr["adresse"];
cn.Close();
dr.Close();
return(advOrd);
}
private void btn_remove_Click(object sender, EventArgs e)
{
if (dataGridView1.Rows.Count == 0)
{
MessageBox.Show("الجدول غير ممتلئ");
}
else
{
MessageBoxManager.Yes = "نعم";
MessageBoxManager.No = "لا";
MessageBoxManager.Register();
DialogResult dr = MessageBox.Show("هل أنت متأكد من الحدف ؟؟", "تنبيه", MessageBoxButtons.YesNo);
MessageBoxManager.Unregister();
if (dr == DialogResult.Yes)
{
adv_order ad = adv_order.findById((int)dataGridView1.CurrentRow.Cells[0].Value);
ad.delete();
history.AddHistory("خصوم الأمر", "حذف", dataGridView1.CurrentRow.Cells[0].Value.ToString());
MessageBox.Show("تم الحذف بنجاح");
refresh();
}
else
{
}
}
}
private void btn_ajouter_Click(object sender, EventArgs e)
{
adv_order adv = new adv_order();
if (CB_genre_Adv.Text != "" && txb_name.Text != "")
{
adv.type_adv_order = CB_genre_Adv.Text;
adv.cin = txb_cin.Text;
adv.nom = txb_name.Text;
adv.representant_legal = txb_juridique.Text;
adv.registre_commerce = txb_num_societe.Text;
adv.adresse = txb_adresse.Text;
int id = adv.save();
history.AddHistory("خصوم الأمر", "إضافة", id.ToString());
MessageBox.Show("تمت الإضافة بنجاح");
refresh();
btn_ajouter.Enabled = false;
}
else
{
MessageBox.Show("يجب ادخال البيانات");
}
}
private void btn_edit_Click(object sender, EventArgs e)
{
adv_order cl = new adv_order();
if (dataGridView1.Rows.Count > 0 && TxB_ident.Text != "")
{
cl.id_adv_order = int.Parse(TxB_ident.Text);
cl.type_adv_order = CB_genre_Adv.Text;
cl.registre_commerce = txb_num_societe.Text;
cl.nom = txb_name.Text;
cl.representant_legal = txb_juridique.Text;
cl.cin = txb_cin.Text;
cl.adresse = txb_adresse.Text;
cl.update();
history.AddHistory("خصوم الأمر", "تحديث", cl.id_adv_order.ToString());
MessageBox.Show("تم تحديث الملومات");
refresh();
}
else
{
MessageBox.Show("المرجو تحديد الحقل المراد تعديله");
}
}