public C_BON_COMMANDE GetCommandeByID(int idCommande)
{
cnx.ConnectionString = Chemin_BDD;
C_BON_COMMANDE UnBon = new C_BON_COMMANDE();
try
{
cnx.Open();
SqlCommand query2 = new SqlCommand();
query2.Connection = cnx;
query2.CommandType = System.Data.CommandType.StoredProcedure;
query2.CommandText = "GetCommandeByID";
query2.Parameters.Add("@CommandeID", System.Data.SqlDbType.Int);
query2.Parameters["@CommandeID"].Value = idCommande;
var response = query2.ExecuteReader();
while (response.Read())
{
UnBon.NroCommande = (int)response["NroCommande"];
UnBon.Client = response["Client"].ToString();
UnBon.Telephone = response["Telephone"].ToString();
UnBon.Nomguitar = response["Nomguitar"].ToString();
UnBon.M_Pos_1 = response["M_Pos_1"].ToString();
UnBon.M_Pos_2 = response["M_Pos_2"].ToString();
UnBon.M_Pos_3 = response["M_Pos_3"].ToString();
UnBon.Bois_Corps = response["Bois_Corps"].ToString();
UnBon.Bois_Touche = response["Bois_Touche"].ToString();
UnBon.Bois_Manche = response["Bois_Manche"].ToString();
UnBon.DateCommande = response["DateCommande"].ToString();
UnBon.Montant = response["MontantCommande"].ToString();
}
}
catch (Exception Erreur)
{
throw new Exception(Erreur.Message);
}
cnx.Close();
return(UnBon);
}
public List <C_BON_COMMANDE> GetAllCommandesFaites()
{
cnx.ConnectionString = Chemin_BDD;
try
{
cnx.Open();
SqlCommand query = new SqlCommand();
query.Connection = cnx;
query.CommandType = System.Data.CommandType.StoredProcedure;
query.CommandText = "GetAllBons";
var response = query.ExecuteReader();
while (response.Read())
{
C_BON_COMMANDE UnBon = new C_BON_COMMANDE();
UnBon.NroCommande = (int)response["NroCommande"];
UnBon.Client = response["Client"].ToString();
UnBon.Telephone = response["Telephone"].ToString();
UnBon.Nomguitar = response["Nomguitar"].ToString();
UnBon.M_Pos_1 = response["M_Pos_1"].ToString();
UnBon.M_Pos_2 = response["M_Pos_2"].ToString();
UnBon.M_Pos_3 = response["M_Pos_3"].ToString();
UnBon.Bois_Corps = response["Bois_Corps"].ToString();
UnBon.Bois_Touche = response["Bois_Touche"].ToString();
UnBon.Bois_Manche = response["Bois_Manche"].ToString();
UnBon.DateCommande = response["DateCommande"].ToString();
UnBon.Montant = response["MontantCommande"].ToString();
les_Bons_de_Commandes.Add(UnBon);
}
}
catch (Exception Erreur)
{
throw new Exception(Erreur.Message);
}
return(les_Bons_de_Commandes);
}
