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