//find an order files by it's ID
public static List <PjOrder> findOrderPj(string idOrder)
{
SqlConnection cn = connection.getConnection();
SqlCommand cmd = new SqlCommand();
SqlDataReader dr;
List <PjOrder> listPj = new List <PjOrder>();
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
cmd.Connection = cn;
cmd.CommandText = "select * from PJ_order where id_order like @order";
cmd.Parameters.Add("@order", idOrder);
dr = cmd.ExecuteReader();
while (dr.Read())
{
PjOrder pj = new PjOrder();
pj.id_pj = (int)dr["id_pj"];
pj.photo = (byte[])dr["photo"];
pj.titre = (string)dr["titre"];
DateTime d = new DateTime();
d = (DateTime)dr["date_enregistrement"];
pj.date_enregistrement = d.ToShortDateString();
pj.id_order = (string)dr["id_order"];
listPj.Add(pj);
}
dr.Close();
cn.Close();
return(listPj);
}
private void btn_ajouter_Click(object sender, EventArgs e)
{
try
{
//order setup
ord.id_order = txb_num_order.Text;
ord.type = (string)comboBox1.SelectedItem;
ord.type_tribuna = (string)cb_genre_trubinal.SelectedValue;
ord.signe_order = textBox1.Text;
ord.id_ville = (string)cb_ville.SelectedValue;
ord.commissaire_judicaire = txb_mofawed.Text;
ord.decision = txb_disesion.Text;
ord.date_order = DateTime.Parse(DateTime.Now.ToShortDateString());
if (textBox2.Text == "" || txb_ide_adv.Text == "")
{
MessageBox.Show("المرجو إعادة ملئ البيانات");
}
else
{
ord.id_client_order = int.Parse(textBox2.Text.ToString());
ord.id_adversaire_order = int.Parse(txb_ide_adv.Text.ToString());
ord.save();
//save PJ setup
if (u == 1)
{
foreach (string fileName in of.FileNames)
{
try
{
FileInfo fi = new FileInfo(fileName);
PjOrder pjOrder1 = new PjOrder();
byte[] img = null;
FileStream f = new FileStream(of.FileName, FileMode.Open);
BinaryReader br = new BinaryReader(f);
img = br.ReadBytes((int)f.Length);
f.Close();
pjOrder1.photo = img;
pjOrder1.titre = Path.GetFileName(of.FileName);
pjOrder1.date_enregistrement = DateTime.Now.ToShortDateString();
pjOrder1.id_order = ord.id_order;
pjOrder1.save();
}
catch (Exception ex)
{
MessageBox.Show("Error: Could not read file from disk. Original error: " + ex.Message);
}
}
u = 0;
}
history.AddHistory("الأمر", "إضافة", ord.id_order);
MessageBox.Show("تمت الإضافة بنجاح");
}
}
catch (Exception nn)
{
MessageBox.Show("المرجو إعادة ملئ البيانات" + nn.Message);
}
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
refresh();
}
else
{
string order = textBox1.Text;
List <PjOrder> list = PjOrder.findOrderPj(order);
dataGridView1.DataSource = list;
dataGridView1.Refresh();
}
}
//find a file by it's id
public PjOrder find(int id)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
cmd.Connection = cn;
cmd.CommandText = "select * from where id_pj = @id";
cmd.Parameters.Add("@id", id);
dr = cmd.ExecuteReader();
PjOrder pj = new PjOrder();
pj.id_pj = (int)dr["id_pj"];
pj.photo = (byte[])dr["photo"];
pj.titre = (string)dr["titre"];
pj.date_enregistrement = (string)dr["date_enregistrement"];
pj.id_order = (string)dr["id_order"];
dr.Close();
return(pj);
}
private void btn_add_Click(object sender, EventArgs e)
{
//save
if (u == 1 && cb_num_cause.Text != "")
{
foreach (string fileName in of.FileNames)
{
try
{
FileInfo fi = new FileInfo(fileName);
PjOrder pjOrder1 = new PjOrder();
byte[] img = null;
FileStream f = new FileStream(of.FileName, FileMode.Open);
BinaryReader br = new BinaryReader(f);
img = br.ReadBytes((int)f.Length);
f.Close();
pjOrder1.photo = img;
pjOrder1.titre = Path.GetFileName(of.FileName);
pjOrder1.date_enregistrement = DateTime.Now.ToShortDateString();
pjOrder1.id_order = (string)cb_num_cause.SelectedValue;
int id = pjOrder1.save();
history.AddHistory("وثائق الامر", "إضافة", id.ToString());
}
catch (Exception ex)
{
MessageBox.Show("Error: Could not read file from disk. Original error: " + ex.Message);
}
}
MessageBox.Show("تمت الإضافة بنجاح");
u = 0;
}
else
{
MessageBox.Show("يجب ملئ الخانات");
}
}