//plainteParPlaignant
public void addPlainteParPlaignant(PlainteParPlaignant ppp)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlTransaction tx = cn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand("insert into plainte_par_plaignant(id_plainte,id_par_plaignant)values(@a,@b)", cn);
SqlParameter p1 = new SqlParameter("@a", ppp.IdPlainte);
SqlParameter p2 = new SqlParameter("@b", ppp.IdParPlaignant);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Transaction = tx;
cmd.ExecuteNonQuery();
tx.Commit();
cn.Close();
// MessageBox.Show("تمت الإضافة بنجاح");
}
catch (Exception e)
{
tx.Rollback();
MessageBox.Show(e.Message);
//Console.WriteLine(e.Message);
}
}
private void btnModif_Click(object sender, EventArgs e)
{
if (isvalidate())
{
PlaintesOperations op = new PlaintesOperations();
Plainte p = new Plainte();
p.IdPlainte = txb_num_pl.Text;
p.DateCreation = date_plai.Value;
//p.Decision = txtdecision.Text;
p.IdPlaignant = int.Parse(textBoxNumClient.Text);
p.Ville = cb_ville.Text;
p.SignePlainte = txb_symbole.Text;
p.TypeTribunal = comboBox_tribunal.Text;
p.TypePlaint = txb_genre_pl.Text;
//Console.WriteLine("Test1: "+p.DateCreation+" "+p.TypeTribunal);
// MessageBox.Show("Test1: " + p.DateCreation + " " + p.TypeTribunal);
op.updatePlainte(p);
op.deleteplainteParpLainte(p.IdPlainte);
foreach (Par_plaignant item in listBox1.Items)
{
PlainteParPlaignant ppp = new PlainteParPlaignant();
ppp.IdParPlaignant = item.IdParPlaignant;
ppp.IdPlainte = p.IdPlainte;
op.addPlainteParPlaignant(ppp);
}
history.AddHistory("شكاية", "تعديل", txb_num_pl.Text);
}
}
public List <PlainteParPlaignant> getPlainteParPlaintes(String idplainte)
{
List <PlainteParPlaignant> parplaignants = new List <PlainteParPlaignant>();
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlCommand sqlCommand = new SqlCommand("SELECT * FROM plainte_par_plaignant where id_plainte like @x", cn);
sqlCommand.Parameters.Add("@x", "%" + idplainte + "%");
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
PlainteParPlaignant ppp = new PlainteParPlaignant();
ppp.IdParPlaignant = (int)reader["id_par_plaignant"];
ppp.IdPlainte = (String)reader["id_plainte"];
parplaignants.Add(ppp);
}
cn.Close();
return(parplaignants);
}
private void btn_ajouter_Click(object sender, EventArgs e)
{
if (isvalidate())
{
PlaintesOperations op = new PlaintesOperations();
Plainte p = new Plainte();
p.IdPlainte = txb_num_pl.Text;
p.DateCreation = date_plai.Value;
p.DateDepotPlainte = date_depot_plainte.Value;
//p.Decision = txtdecision.Text;
p.IdPlaignant = int.Parse(textBoxNumClient.Text);
p.Ville = cb_ville.Text;
p.SignePlainte = txb_symbole.Text;
p.TypeTribunal = comboBox_tribunal.Text;
p.TypePlaint = txb_genre_pl.Text;
//Console.WriteLine("Test1: "+p.DateCreation+" "+p.TypeTribunal);
// MessageBox.Show("Test1: " + p.DateCreation + " " + p.TypeTribunal);
op.addPlainte(p);
Decision d = new Decision();
d.Decision1 = "فتح الملف";
d.Id_plainte = p.IdPlainte;
op.addDecisionPlainte(d);
foreach (Par_plaignant item in listBox1.Items)
{
PlainteParPlaignant ppp = new PlainteParPlaignant();
ppp.IdParPlaignant = item.IdParPlaignant;
ppp.IdPlainte = p.IdPlainte;
op.addPlainteParPlaignant(ppp);
}
//save PJ setup
if (u == 1)
{
foreach (string fileName in of.FileNames)
{
try
{
FileInfo fi = new FileInfo(fileName);
PjPlainte pjplaint = new PjPlainte();
byte[] img = null;
FileStream f = new FileStream(of.FileName, FileMode.Open);
BinaryReader br = new BinaryReader(f);
img = br.ReadBytes((int)f.Length);
f.Close();
pjplaint.Id_plainte = p.IdPlainte;
pjplaint.Photo = img;
pjplaint.Titre = Path.GetFileName(of.FileName);
pjplaint.Date_enregistrement = date_plai.Value;
// pjOrder1.id_order = ord.id_order;
op.addPjPalainte(pjplaint);
history.AddHistory("شكاية", "اضافة", txb_num_pl.Text);
}
catch (Exception ex)
{
MessageBox.Show("Error: Could not read file from disk. Original error: " + ex.Message);
}
}
u = 0;
}
}
else
{
MessageBox.Show("أحد الحقول فارغة أو المعلومات خاطئة");
}
}
