public int AddTraino(Traini tr) { Connect(); SqlCommand sqlComm = new SqlCommand("insertTraino", _sqlConn); Log("coop"); sqlComm.CommandType = System.Data.CommandType.StoredProcedure; sqlComm.Parameters.Add("idGiorno", tr.IDGiornata); sqlComm.Parameters.Add("idIstr", tr.IDIstruttore); sqlComm.Parameters.Add("idAlia", tr.IDAliante); sqlComm.Parameters.Add("idPilo", tr.IDPilota); sqlComm.Parameters.Add("tempo", tr.TempoOrametro); sqlComm.ExecuteNonQuery(); Close(); return(-1); }
public static void ElaboraSessioni(dbInteraction DBI, JSONObject coop) { bool[] trainiEff = new bool[coop.trainiEff.Count]; foreach (SessioneGiorno sg in coop.sessioni) { int idSessione = DBI.AddGiornata(sg); for (int i = 0; i < coop.trainiEff.Count; i++) { if (!trainiEff[i]) { Traini tr = coop.trainiEff[i]; tr.IDGiornata = idSessione; coop.trainiEff[i] = tr; trainiEff[i] = true; } } } }
public static void ElaboraPilotiAlianti(dbInteraction DBI, JSONObject coop) { bool[] trainiEff = new bool[coop.trainiEff.Count]; foreach (Pilota p in coop.pilsAli) { int idPilot = DBI.AddPilotAliante(p); if (idPilot != -1) { for (int i = 0; i < coop.trainiEff.Count; i++) { if (!trainiEff[i] && p.id == coop.trainiEff[i].IDPilota) { Traini tr = coop.trainiEff[i]; tr.IDPilota = idPilot; coop.trainiEff[i] = tr; trainiEff[i] = true; } } } } }
public static void ElaboraIstruttori(dbInteraction DBI, JSONObject coop) { bool[] trainiEff = new bool[coop.trainiEff.Count]; foreach (Pilota p in coop.instructors) { int idPilot = DBI.AddInstructor(p); if (idPilot != -1) { for (int i = 0; i < coop.trainiEff.Count; i++) { if (!trainiEff[i] && p.id == coop.trainiEff[i].IDIstruttore) { Traini tr = coop.trainiEff[i]; tr.IDIstruttore = idPilot; coop.trainiEff[i] = tr; trainiEff[i] = true; } } } } }
public static void ElaboraAlianti(dbInteraction DBI, JSONObject coop) { bool[] trainiEff = new bool[coop.trainiEff.Count]; foreach (ModelloAereo ma in coop.alianti) { int idAliante = DBI.AddModAliante(ma); if (idAliante != -1) { for (int i = 0; i < coop.trainiEff.Count; i++) { if (!trainiEff[i] && ma.id == coop.trainiEff[i].IDAliante) { Traini tr = coop.trainiEff[i]; tr.IDAliante = idAliante; coop.trainiEff[i] = tr; trainiEff[i] = true; } } } } }