public void Save(ITiers tiers)
{
if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed)
{
ImplementeConnexion.Instance.Conn.Open();
}
using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand())
{
cmd.CommandText = "INSERT_TIER";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(Parametres.Instance.AjouterParametre(cmd, "@code", 5, DbType.Int32, Id));
cmd.Parameters.Add(Parametres.Instance.AjouterParametre(cmd, "@nom", 50, DbType.String, Nom));
cmd.Parameters.Add(Parametres.Instance.AjouterParametre(cmd, "@postnom", 50, DbType.String, Postnom));
cmd.Parameters.Add(Parametres.Instance.AjouterParametre(cmd, "@prenom", 50, DbType.String, Prenom));
cmd.Parameters.Add(Parametres.Instance.AjouterParametre(cmd, "@contact", 50, DbType.String, Contact));
cmd.Parameters.Add(Parametres.Instance.AjouterParametre(cmd, "@email", 50, DbType.String, Mail));
cmd.Parameters.Add(Parametres.Instance.AjouterParametre(cmd, "@adresse", 100, DbType.String, Addresse));
cmd.ExecuteNonQuery();
MessageBox.Show("Saved successfully !!!", "Message...", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public static void MoveTier(ITiers h0, int ix0, ITiers h1, int ix1)
{
if (h0 == h1)
{
if (ix0 != ix1)
h0.Tiers.Move(ix0, ix1);
}
else
{
var told = h0[ix0];
h0.RemoveAt(ix0);
(told.TiersHost = h1).Insert(ix1, told);
IHostedItem hi;
if (h0.Count == 0 && (hi = h0 as IHostedItem) != null)
{
Debug.Print("drag removing {0} from {1}", hi.GetType().Name, hi.Host.GetType().Name);
hi.Host.GetList().Remove(hi);
}
}
}
