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()); }