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