1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53
|
public static int Get_last_id(string objet, string debut, string fin, string Duree, string Heure, string Description, string Lieu)
{
// Create Instance of Connection and Command Object
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = DA.DAConnexion.connectionString;
SqlCommand myCommand = new SqlCommand("SP_get_latest_id", myConnection);
myConnection.Open();
// Mark the Command as a SPROC
myCommand.CommandType = CommandType.StoredProcedure;
// Add Parameters to SPROC
SqlParameter parameterobjet = new SqlParameter("@objet", SqlDbType.Char, 50);
parameterobjet.Value = objet;
myCommand.Parameters.Add(parameterobjet);
SqlParameter parameterdebut = new SqlParameter("@debut", SqlDbType.Char, 20);
parameterdebut.Value = debut;
myCommand.Parameters.Add(parameterdebut);
SqlParameter parameterfin = new SqlParameter("@fin", SqlDbType.Char, 20);
parameterfin.Value = fin;
myCommand.Parameters.Add(parameterfin);
SqlParameter parameterduree = new SqlParameter("@duree", SqlDbType.Char, 5);
parameterduree.Value = Duree;
myCommand.Parameters.Add(parameterduree);
SqlParameter parameterheure = new SqlParameter("@heure", SqlDbType.Char, 5);
parameterheure.Value = Heure;
myCommand.Parameters.Add(parameterheure);
SqlParameter parameterdescription = new SqlParameter("@description", SqlDbType.Char, 200);
parameterdescription.Value = Description;
myCommand.Parameters.Add(parameterdescription);
SqlParameter parameterlieu = new SqlParameter("@lieu", SqlDbType.Char, 15);
parameterlieu.Value = Lieu;
myCommand.Parameters.Add(parameterlieu);
SqlParameter id = myCommand.Parameters.Add(new SqlParameter("@idRDV", SqlDbType.Int, 10));
id.Direction = ParameterDirection.Output;
myCommand.ExecuteNonQuery();
int ReturnMessage = int.Parse(myCommand.Parameters["@idRDV"].Value.ToString());
myConnection.Close();
return ReturnMessage;
} |
Partager