public object[] toSqlMap() { DateLivr = DateTime.Now; object[] res = new object[4]; res[0] = "Date_Com=" + "'" + DateCmd.ToString("yyyy-MM-dd HH:mm:ss") + "'"; res[1] = "Date_Liv=" + "'" + DateLivr.ToString("yyyy-MM-dd HH:mm:ss") + "'"; res[2] = "Prix_Com=" + Price; res[3] = "Taille_Piz=" + selectedTaille; res[3] = "Nom_Piz=" + selectedPizza; res[3] = "Immat_Veh=" + selectedVehicule; res[3] = "ID_Cli=" + selectedClient; res[3] = "ID_Liv=" + selectedLivreur; return(res); }
public object[] toSqlTab() { SqlConnector sql = SqlConnector.Instance(); object idLiv, idClient; DataTable dt; sql.Select("ID_CLI from client where Nom_Cli='" + selectedClient + "'", out dt); idClient = dt.Rows[0]["ID_CLI"]; sql.Select("ID_Liv from livreur where Nom_Liv='" + selectedLivreur + "'", out dt); idLiv = dt.Rows[0]["ID_Liv"]; object[] res = new object[8]; res[0] = "'" + DateCmd.ToString("yyyy-MM-dd HH:mm:ss") + "'"; res[1] = "'" + DateLivr.ToString("yyyy-MM-dd HH:mm:ss") + "'"; res[2] = Price as object; res[3] = "'" + selectedTaille + "'"; res[4] = "'" + selectedPizza + "'"; res[5] = "'" + selectedVehicule + "'"; res[6] = idClient; res[7] = idLiv; return(res); }