//piece joint with id
public List <PJ_cause> getPJ_cause(string id)
{
List <PJ_cause> p = new List <PJ_cause>();
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlCommand sqlCommand = new SqlCommand("SELECT * FROM PJ_cause where id_cause like'" + id + "%'", cn);
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
PJ_cause c = new PJ_cause();
c.Id_cause = (string)reader["id_cause"];
c.Photo = (byte[])reader["photo"];
c.Titre = (string)reader["titre"];
c.Date_enregistrement = (DateTime)reader["date_enregistrement"];
c.Id_pj_cause = (int)reader["id_pj"];
p.Add(c);
}
reader.Close();
cn.Close();
return(p);
}
//
//
//piece jointe cause
//
//add piece jointe cause
public void add_piece_jointe_cause(PJ_cause p)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlTransaction tx = cn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand("insert into PJ_cause(photo,titre,date_enregistrement,id_cause)values(@b,@z,@e,@r)", cn);
SqlParameter p1 = new SqlParameter("@b", p.Photo);
SqlParameter p2 = new SqlParameter("@z", p.Titre);
SqlParameter p3 = new SqlParameter("@e", p.Date_enregistrement);
SqlParameter p4 = new SqlParameter("@r", p.Id_cause);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Parameters.Add(p4);
cmd.Transaction = tx;
cmd.ExecuteNonQuery();
tx.Commit();
cn.Close();
//MessageBox.Show("تمت الإضافة بنجاح");
}
catch (Exception e)
{
tx.Rollback();
MessageBox.Show(e.Message);
}
}
private void simpleButton4_Click(object sender, EventArgs e)
{
//MessageBox.Show(DateTime.Today.ToString("d"));
if (u == 1 && cb_num_cause.Text != "")
{
foreach (string fileName in of.FileNames)
{
try
{
FileInfo fi = new FileInfo(fileName);
PJ_cause pjCause = new PJ_cause();
byte[] img = null;
FileStream f = new FileStream(of.FileName, FileMode.Open);
BinaryReader br = new BinaryReader(f);
img = br.ReadBytes((int)f.Length);
f.Close();
pjCause.Id_cause = cb_num_cause.Text;
pjCause.Photo = img;
pjCause.Titre = Path.GetFileName(of.FileName);
pjCause.Date_enregistrement = DateTime.Parse(DateTime.Today.ToString("d"));
co.add_piece_jointe_cause(pjCause);
MessageBoxManager.OK = "حسنا";
MessageBoxManager.Register();
DialogResult dr = MessageBox.Show("تمت الاضافة بنجاح", "", MessageBoxButtons.OK);
history.AddHistory("وثائق القضية", "الاضافة", cb_num_cause.Text);
MessageBoxManager.Unregister();
label4.Visible = false;
label5.Visible = true;
getdata();
}
catch (Exception ex)
{
MessageBox.Show("Error: Could not read file from disk. Original error: " + ex.Message);
}
}
u = 0;
}
else
{
MessageBoxManager.OK = "حسنا";
MessageBoxManager.Register();
DialogResult dr = MessageBox.Show("المرجو ملئ الحقول", "تنبيه", MessageBoxButtons.OK);
MessageBoxManager.Unregister();
}
}
private void simpleButtonAjouterCause_Click(object sender, EventArgs e)
{
bool x = IsNumeric(txt_duree.Text);
co = new Cause_Operations();
if (txtMarjiaCause1.Text == "" || comboBoxTypeTribunal.Text == "" || comboBoxVilleCause.Text == "" || textBoxNomClient.Text == "" || textBoxNomAdv.Text == "")
{
MessageBoxManager.OK = "حسنا";
MessageBoxManager.Register();
DialogResult dr = MessageBox.Show("يجب ادخال المعلومات الضرورية", "", MessageBoxButtons.OK);
MessageBoxManager.Unregister();
}
else
{
try
{
//MessageBox.Show( txt_duree.Value.ToString());
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
cause ca = new cause();
Session se = new Session();
ca.Id_client = int.Parse(dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
ca.Id_adv = int.Parse(dataGridView2.SelectedRows[0].Cells[0].Value.ToString());
ca.Id_cause = txtMarjiaCause1.Text;
ca.Date_session = dateTimePickeDateCause.Value;
ca.Nom_avocat = textBoxCauseProfMoukalaf.Text;
ca.Signe_cause = txt_signe_cause.Text;
ca.Type_cause = txt_type_cause.Text;
ca.Juge = txt_juge.Text;
ca.Avocat_adversaire = txt_avocat_adversaire.Text;
ca.Type_tribunal = comboBoxTypeTribunal.Text;
ca.Ville = comboBoxVilleCause.Text;
ca.Num_cause_tribunal = txtNumCause.Text;
ca.Poursuite = cb_porsuit.Text;
ca.Commisaire_judiciaire = txt_commisaire_judiciaire.Text;
ca.Appel = cb_appel.Text;
ca.Duree = int.Parse(txt_duree.Text);
if (txt_montant.Text != "")
{
ca.Montant = float.Parse(txt_montant.Text);
}
else
{
}
se.Date_session = dateTimePickeDateCause.Value;
se.Id_cause = txtMarjiaCause1.Text;
se.Decision = "اول جلسة";
co.add_cause(ca, se);
if (u == 1)
{
foreach (string fileName in of.FileNames)
{
try
{
FileInfo fi = new FileInfo(fileName);
PJ_cause pjCause = new PJ_cause();
byte[] img = null;
FileStream f = new FileStream(of.FileName, FileMode.Open);
BinaryReader br = new BinaryReader(f);
img = br.ReadBytes((int)f.Length);
f.Close();
pjCause.Id_cause = ca.Id_cause;
pjCause.Photo = img;
pjCause.Titre = Path.GetFileName(of.FileName);
pjCause.Date_enregistrement = dateTimePickeDateCause.Value;
// listBox1.Items.Add(pjCause.Titre);
co.add_piece_jointe_cause(pjCause);
}
catch (Exception ex)
{
MessageBox.Show("Error: Could not read file from disk. Original error: " + ex.Message);
}
}
u = 0;
}
history.AddHistory(" الموضوع", "الاضافة", txtMarjiaCause1.Text);
//
cn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
