public List<ActionPerso> getAllActionsByTrader(int numTrader)
{
List<MetierTrader.Action> LesActionsPerso = new List<MetierTrader.Action>();
cmd = new MySqlCommand("select idAction, nomAction, prixAchat, (acheter.prixAchat * acheter.quantite) from action INNER JOIN acheter ON action.idAction = acheter.numAction INNER JOIN trader ON acheter.numTrader = trader.idTrader where idTrader = " + numTrader, cnx);
dr = cmd.ExecuteReader();
while (dr.Read())
{
ActionPerso uneActionPerso = new ActionPerso(Convert.ToInt16(dr[0].ToString()), dr[1].ToString(), dr[2].ToString(), dr[3].ToString());
lesActionsPerso.Add(uneActionPerso);
}
dr.Close();
return lesActionsPerso;
}
public List <ActionPerso> getAllActionsByTrader(int numTrader)
{
List <ActionPerso> mesActionPerso = new List <ActionPerso>();
cmd = new MySqlCommand("SELECT numAction, action.nomAction, prixAchat, quantite, SUM(prixAchat * quantite) AS total FROM acheter inner join action on acheter.numAction = action.idAction WHERE acheter.numTrader =" + numTrader, cnx);
dr = cmd.ExecuteReader();
while (dr.Read())
{
ActionPerso uneAction = new ActionPerso(Convert.ToInt16(dr[0]), dr[1].ToString(), Convert.ToDouble(dr[2]), Convert.ToInt16(dr[3]), Convert.ToInt32(dr[4]));
mesActionPerso.Add(uneAction);
}
dr.Close();
return(mesActionPerso);
}
public List <ActionPerso> getAllActionsByTrader(int numTrader)
{
List <ActionPerso> lesActions = new List <ActionPerso>();
cmd = new MySqlCommand("SELECT idAction,nomAction, prixAchat, quantite, prixAchat*quantite FROM action INNER JOIN acheter ON action.idAction = acheter.numAction WHERE acheter.numTrader =" + numTrader, cnx);
dr = cmd.ExecuteReader();
while (dr.Read())
{
MetierTrader.ActionPerso uneAction = new ActionPerso(Convert.ToInt16(dr[0].ToString()), dr[1].ToString(), Convert.ToDouble(dr[2].ToString()), Convert.ToInt16(dr[3].ToString()), Convert.ToDouble(dr[4].ToString()));
lesActions.Add(uneAction);
}
dr.Close();
return(lesActions);
}
public List <ActionPerso> getAllActionsByTrader(int numTrader)
{
List <ActionPerso> lesActionsPerso = new List <ActionPerso>();
cmd = new MySqlCommand("select numAction, nomAction, prixAchat, quantite from acheter ar join action an on ar.numAction = an.idAction where numTrader=" + numTrader + ";", cnx);
dr = cmd.ExecuteReader();
while (dr.Read())
{
ActionPerso uneActionPerso = new ActionPerso(Convert.ToInt16(dr[0]), dr[1].ToString(), Convert.ToDouble(dr[2]), Convert.ToInt16(dr[3]));
lesActionsPerso.Add(uneActionPerso);
}
dr.Close();
return(lesActionsPerso);
}
public List <ActionPerso> getAllActionsByTrader(int numTrader)
{
List <ActionPerso> lesActions = new List <ActionPerso>();
cmd = new MySqlCommand("select numAction, nomAction, prixAchat, quantite, prixAchat*quantite from action a inner join acheter ac on a.IdAction = ac.numAction where numTrader = " + numTrader, cnx);
dr = cmd.ExecuteReader();
while (dr.Read())
{
ActionPerso uneActionPerso = new ActionPerso(Convert.ToInt32(dr[0].ToString()), (dr[1].ToString()), Convert.ToDouble(dr[2].ToString()), Convert.ToInt32(dr[3].ToString()), Convert.ToDouble(dr[4].ToString()));
lesActions.Add(uneActionPerso);
}
dr.Close();
return(lesActions);
}
public List <ActionPerso> getAllActionsByTrader(int numTrader)
{
List <ActionPerso> mesActionsPerso = new List <ActionPerso>();
cmd = new MySqlCommand("SELECT `numAction`, `numTrader`, nomAction, `prixAchat`, `quantite` FROM `acheter` INNER JOIN trader ON acheter.numTrader = trader.idTrader INNER JOIN action on acheter.numAction = action.idAction WHERE idtrader = " + numTrader, cnx);
dr = cmd.ExecuteReader();
while (dr.Read())
{
ActionPerso monActionPerso = new ActionPerso(Convert.ToInt16(dr[0].ToString()), Convert.ToInt16(dr[1].ToString()), dr[2].ToString(), Convert.ToDouble(dr[3].ToString()), Convert.ToInt16(dr[4].ToString()));
mesActionsPerso.Add(monActionPerso);
}
dr.Close();
return(mesActionsPerso);
}
public List <ActionPerso> getAllActionsByTrader(int numTrader)
{
List <ActionPerso> mesActions = new List <ActionPerso>();
cmd = new MySqlCommand("select numAction, prixAchat, quantite from acheter where numTrader = " + numTrader, cnx);
dr = cmd.ExecuteReader();
while (dr.Read())
{
ActionPerso monAction = new ActionPerso(Convert.ToInt16(dr[0].ToString()), dr[1].ToString());
mesActions.Add(monAction);
}
dr.Close();
return(mesActions);
}
public List <ActionPerso> getAllActionsByTrader(int numTrader)
{
List <ActionPerso> mesActionsPerso = new List <ActionPerso>();
cmd = new MySqlCommand("SELECT numAction, quantite FROM acheter INNER JOIN trader ON acheter.numAction = trader.idTrader;", cnx);
dr = cmd.ExecuteReader();
while (dr.Read())
{
ActionPerso uneActionPerso = new ActionPerso(Convert.ToInt16(dr[0].ToString()), dr[1].ToString());
mesActionsPerso.Add(uneActionPerso);
}
dr.Close();
return(mesActionsPerso);
}
public List <ActionPerso> getAllActionsByTrader(int numTrader)
{
List <ActionPerso> lesActionPerso = new List <ActionPerso>();
cmd = new MySqlCommand("SELECT numAction ,nomAction, prixAchat ,quantite , quantite*prixAchat from acheter a inner join action act on a.numAction = act.idAction where numTrader=" + numTrader, cnx);
dr = cmd.ExecuteReader();
while (dr.Read())
{
ActionPerso actionP = new ActionPerso(Convert.ToInt16(dr[0].ToString()), dr[1].ToString(), Convert.ToDouble(dr[2].ToString()), Convert.ToInt16(dr[3].ToString()), Convert.ToDouble(dr[4].ToString()));
lesActionPerso.Add(actionP);
}
dr.Close();
return(lesActionPerso);
}
public List <ActionPerso> getAllActionsByTrader(int numTrader)
{
List <ActionPerso> mesActionPerso = new List <ActionPerso>();
cmd = new MySqlCommand("select numAction, numTrader,prixAchat,quantite from acheter", cnx);
dr = cmd.ExecuteReader();
while (dr.Read())
{
ActionPerso uneActionPerso = new ActionPerso(Convert.ToInt16(dr[0].ToString()), Convert.ToInt16(dr[1].ToString()), Convert.ToInt16(dr[2].ToString()), Convert.ToInt16(dr[3].ToString()));//Convert.ToInt16(dr[4].ToString()), Convert.ToInt16(dr[5].ToString()));
mesActionPerso.Add(uneActionPerso);
}
dr.Close();
return(mesActionPerso);
}
public List <ActionPerso> getAllActionsByTrader(int numTrader)
{
List <ActionPerso> mesActionsPerso = new List <ActionPerso>();
cmd = new MySqlCommand("SELECT action.idAction, action.nomAction, acheter.prixAchat, acheter.quantite FROM action INNER JOIN acheter ON action.idAction = acheter.numAction WHERE acheter.numTrader =" + numTrader, cnx);
dr = cmd.ExecuteReader();
while (dr.Read())
{
ActionPerso uneActionPerso = new ActionPerso(Convert.ToInt32(dr[0].ToString()), dr[1].ToString(), Convert.ToDouble(dr[2].ToString()), Convert.ToInt32(dr[3].ToString()));
mesActionsPerso.Add(uneActionPerso);
}
dr.Close();
return(mesActionsPerso);
}
public List <ActionPerso> getAllActionsByTrader(int numTrader)
{
List <ActionPerso> lesActionsPersos = new List <ActionPerso>();
cmd = new MySqlCommand("select idAction, nomAction, prixAchat, quantite from action act " +
"INNER JOIN acheter a on act.idAction = a.numAction INNER JOIN trader t on a.numTrader = t.idTrader where t.idTrader = " + numTrader, cnx);
dr = cmd.ExecuteReader();
while (dr.Read())
{
ActionPerso uneActionPerso = new ActionPerso(Convert.ToInt16(dr[0].ToString()), dr[1].ToString(), Convert.ToDouble(dr[2].ToString()), Convert.ToInt16(dr[3].ToString()));
lesActionsPersos.Add(uneActionPerso);
}
dr.Close();
return(lesActionsPersos);
}
public List <ActionPerso> getAllActionsByTrader(int numTrader)
{
List <ActionPerso> mesActionsPersos = new List <ActionPerso>();
cmd = new MySqlCommand("SELECT numAction, nomAction, prixAchat, quantite, prixAchat*quantite as TOTAL from action a INNER JOIN acheter ac ON ac.numAction = a.idAction where numTrader =" + numTrader, cnx);
dr = cmd.ExecuteReader();
while (dr.Read())
{
ActionPerso uneActionPerso = new ActionPerso(Convert.ToInt16(dr[0].ToString()), dr[1].ToString(), Convert.ToDouble(dr[2].ToString()), Convert.ToInt16(dr[3].ToString()), Convert.ToDouble(dr[4].ToString()));
mesActionsPersos.Add(uneActionPerso);
}
dr.Close();
return(mesActionsPersos);
}
public List <ActionPerso> getAllActionsByTrader(int numTrader)
{
List <ActionPerso> mesActionsPerso = new List <ActionPerso>();
cmd = new MySqlCommand("Select a.idAction,a.nomAction,prixAchat,quantite,ach.prixAchat * ach.quantite as total from Action a inner join acheter ach ON a.idAction = ach.numAction inner join trader t ON ach.numTrader = t.idTrader where idTrader = " + "'" + numTrader + "';", cnx);
dr = cmd.ExecuteReader();
while (dr.Read())
{
ActionPerso aP = new ActionPerso(Convert.ToInt16(dr[0]), dr[1].ToString(), Convert.ToDouble(dr[2]), Convert.ToInt16(dr[3]), Convert.ToDouble(dr[4]));
mesActionsPerso.Add(aP);
}
dr.Close();
return(mesActionsPerso);
}
public List <ActionPerso> getAllActionsByTrader(int numTrader)
{
List <ActionPerso> lesActionsPerso = new List <ActionPerso>();
cmd = new MySqlCommand("SELECT action.idAction , action.nomAction ,acheter.prixAchat , acheter.quantite from acheter INNER JOIN action ON action.idAction = acheter.numAction WHERE acheter.numTrader = " + numTrader + ";", cnx);
dr = cmd.ExecuteReader();
while (dr.Read())
{
MetierTrader.Action unAction = new MetierTrader.Action(Convert.ToInt16(dr[0].ToString()), dr[1].ToString());
double prixAchat = Convert.ToDouble(dr[2].ToString());
int quantite = Convert.ToInt16(dr[3].ToString());
double total = prixAchat * quantite;
ActionPerso unActionPerso = new ActionPerso(unAction, prixAchat, quantite, total);
lesActionsPerso.Add(unActionPerso);
}
dr.Close();
return(lesActionsPerso);
}
