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