public void InsertionUpdateDeleteAgent(ClsAgents ag, int choix) { switch (choix) { case 1: if (!ag.NomComplet.Equals("") || !ag.Sexe.Equals("") || !ag.Sexe.Equals("") || !ag.Mail.Equals("") || !ag.Tele1.Equals("") || !ag.Tele1.Equals("")) { ag.Code = code_s; if (dao.Executer("Exec [Ajouter_Agent] '" + ag.Code + "','" + (ag.NomComplet).ToUpper() + "','" + (ag.Sexe).ToUpper() + "','" + (ag.Mail).ToUpper() + "','" + (ag.Tele1).ToUpper() + "'") == true) { //code_s = dao.MaxId("Agent"); //dao.SavePhoto(ag.Photo,"Agent", code_s); fx.Message(choix); } else { fx.Erreur(choix); } } else { MessageBox.Show("Veillez completer les champs svp!"); } break; case 2: if (!ag.NomComplet.Equals("") || !ag.Sexe.Equals("") || !ag.Sexe.Equals("") || !ag.Mail.Equals("") || !ag.Tele1.Equals("") || !ag.Tele1.Equals("")) { cmd.CommandText = " update agent set NomComplet=@nom, sexe=@sexe, email=@mail, Phone=@phone, Profil=@Photo where Code=@code "; SetParametre(cmd, "@code", DbType.String, 50, pt.Code); SetParametre(cmd, "@nom", DbType.String, 50, pt.NomComplet); SetParametre(cmd, "@sexe", DbType.String, 50, pt.Sexe); SetParametre(cmd, "@mail", DbType.String, 50, pt.Mail); SetParametre(cmd, "@phone", DbType.String, 50, pt.Tele1); if (pt.Photo != null) { SetParametre(cmd, "@Photo", DbType.Binary, Int32.MaxValue, pt.Photo); } else { SetParametre(cmd, "@Photo", DbType.Binary, Int32.MaxValue, DBNull.Value); } cmd.ExecuteNonQuery(); } else { MessageBox.Show("Veillez completer les champs svp!"); } break; case 3: if (ag.Code.Equals("")) { if (dao.Executer("Delete from Agent where Code='" + ag.Code + "' ") == (true)) { fx.Message(choix); } else { fx.Erreur(choix); } } else { MessageBox.Show("Veillez completer le champs svp!"); } break; } }
public void InsertionUpdateDeleteAgent_avec_photo(ClsAgents pt, int choix) { try { InitialiserConnexion(); if (!conn.State.ToString().ToLower().Equals("open")) { conn.Open(); } cmd = conn.CreateCommand(); switch (choix) { case 1: cmd.CommandText = "insert into agent values () "; SetParametre(cmd, "@code_membre", DbType.String, 50, pt.Code.ToUpper()); if (pt.Photo != null) { SetParametre(cmd, "@Photo", DbType.Binary, Int32.MaxValue, pt.Photo); } else { SetParametre(cmd, "@Photo", DbType.Binary, Int32.MaxValue, DBNull.Value); } cmd.ExecuteNonQuery(); MessageBox.Show("Enregistrement reçu!", "", MessageBoxButtons.OK, MessageBoxIcon.Information); break; case 2: cmd.CommandText = " update agent set NomComplet=@nom, sexe=@sexe, email=@mail, Phone=@phone, Profil=@Photo where Code=@code "; SetParametre(cmd, "@code", DbType.String, 50, pt.Code); SetParametre(cmd, "@nom", DbType.String, 50, pt.NomComplet); SetParametre(cmd, "@sexe", DbType.String, 50, pt.Sexe); SetParametre(cmd, "@mail", DbType.String, 50, pt.Mail); SetParametre(cmd, "@phone", DbType.String, 50, pt.Tele1); if (pt.Photo != null) { SetParametre(cmd, "@Photo", DbType.Binary, Int32.MaxValue, pt.Photo); } else { SetParametre(cmd, "@Photo", DbType.Binary, Int32.MaxValue, DBNull.Value); } cmd.ExecuteNonQuery(); break; case 3: cmd.CommandText = "delete from agent where code=@code"; MessageBox.Show("Suppression reçu!", "", MessageBoxButtons.OK, MessageBoxIcon.Information); break; } cmd.Dispose(); conn.Close(); } catch (Exception exc) { MessageBox.Show(exc.Message); } finally { cmd.Dispose(); conn.Close(); } }