private void btn_ajouter_Click(object sender, EventArgs e)
{
if (txt_decision.Text == "" || cb_id_plainte.Text == "")
{
MessageBoxManager.OK = "حسنا";
MessageBoxManager.Register();
DialogResult dr = MessageBox.Show("المرجو ملئ جميع الحقول", "تنبيه", MessageBoxButtons.OK);
MessageBoxManager.Unregister();
}
else
{
try
{
//cn.Open();
Session_Plainte se = new Session_Plainte();
se.Date_session = dateTimePicker1.Value;
se.Decision = txt_decision.Text;
se.Id_plainte = cb_id_plainte.Text;
po.add_session(se);
getdata();
history.AddHistory("الجلسات", "الاضافة", cb_id_plainte.Text);
//cn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
// update session palinte
public void update_session(Session_Plainte sp)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlTransaction tx = cn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand("update session_plainte set decision=@d,date_session=@ds,id_plainte=@ip where id_session=@is", cn);
SqlParameter p0 = new SqlParameter("@d", sp.Decision);
SqlParameter p1 = new SqlParameter("@ds", sp.Date_session);
SqlParameter p2 = new SqlParameter("@ip", sp.Id_plainte);
SqlParameter p3 = new SqlParameter("@is", sp.Id_session);
cmd.Parameters.Add(p0);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Transaction = tx;
cmd.ExecuteNonQuery();
tx.Commit();
cn.Close();
MessageBox.Show("تم التعديل بنجاح ");
}
catch (Exception e)
{
tx.Rollback();
MessageBox.Show(e.Message);
//Console.WriteLine(e.Message);
}
}
//add session plainte
public void add_session(Session_Plainte c)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlTransaction tx = cn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand("insert into session_plainte(date_session,id_plainte,decision)values(@b,@z,@e)", cn);
SqlParameter p1 = new SqlParameter("@b", c.Date_session);
SqlParameter p2 = new SqlParameter("@z", c.Id_plainte);
SqlParameter p3 = new SqlParameter("@e", c.Decision);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Transaction = tx;
cmd.ExecuteNonQuery();
tx.Commit();
cn.Close();
MessageBoxManager.OK = "حسنا";
MessageBoxManager.Register();
DialogResult dr = MessageBox.Show("تمت الإضافة بنجاح", "", MessageBoxButtons.OK);
MessageBoxManager.Unregister();
//MessageBox.Show("تمت الإضافة بنجاح");
}
catch (Exception e)
{
tx.Rollback();
MessageBox.Show(e.Message);
}
}
private void simpleButtonModification_Click(object sender, EventArgs e)
{
PlaintesOperations op = new PlaintesOperations();
Session_Plainte p = new Session_Plainte();
p.Id_plainte = cb_id_plainte.Text;
p.Date_session = dateTimePicker1.Value;
p.Decision = txt_decision.Text;
p.Id_session = Convert.ToInt32(label4.Text);
op.update_session(p);
getdata();
history.AddHistory("شكاية", "تعديل", p.Id_session.ToString());
}
