public static string Serializzo()
{
dbInteraction DBI = new dbInteraction();
JSONObject jObj = new JSONObject();
DataTable dt = DBI.RetrievePiloti("Pilota");
for (int i = 0; i < dt.Rows.Count; i++)
{
jObj.pilsAli.Add(new Pilota(dt.Rows[i][1].ToString(), dt.Rows[i][2].ToString()));
}
dt = DBI.RetrievePiloti("Trainatore");
for (int i = 0; i < dt.Rows.Count; i++)
{
jObj.pils.Add(new Pilota(dt.Rows[i][1].ToString(), dt.Rows[i][2].ToString()));
}
dt = DBI.RetrievePiloti("Istruttore");
for (int i = 0; i < dt.Rows.Count; i++)
{
jObj.instructors.Add(new Pilota(dt.Rows[i][1].ToString(), dt.Rows[i][2].ToString()));
}
dt = DBI.RetrieveAereo("ModelloAliante");
for (int i = 0; i < dt.Rows.Count; i++)
{
jObj.alianti.Add(new ModelloAereo(dt.Rows[i][0].ToString(), dt.Rows[i][1].ToString()));
}
dt = DBI.RetrieveAereo("ModelloTrainatore");
for (int i = 0; i < dt.Rows.Count; i++)
{
jObj.aereiTrainanti.Add(new ModelloAereo(dt.Rows[i][0].ToString(), dt.Rows[i][1].ToString()));
}
return(JsonConvert.SerializeObject(jObj));
}
public static void ElaboraTraini(dbInteraction DBI, JSONObject coop)
{
foreach (Traini tr in coop.trainiEff)
{
DBI.AddTraino(tr);
}
}
protected void lgnButt_Click(object sender, EventArgs e)
{
dbInteraction DBI = new dbInteraction();
Session["Login"] = DBI.ExecuteLogin(usrName.Text, usrPass.Text);
Response.Redirect("~/index.aspx");
}
protected void RetrieveTraini(int idTraino)
{
dbInteraction DBI = new dbInteraction();
DataTable dt = DBI.RetrieveTraini(idTraino);
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DropDownList1.Items.Clear();
dbInteraction DBI = new dbInteraction();
DataTable dt = DBI.RetrievePiloti("Trainatore");
for (int i = 0; i < dt.Rows.Count; i++)
{
DropDownList1.Items.Add(new ListItem(string.Format("{0} {1}", dt.Rows[i][1], dt.Rows[i][2]), dt.Rows[i][0].ToString()));
}
}
}
public void LoadAppropriatedata()
{
DefaultSetting();
Helper.ClassName = null;
dbInteractionObject = new dbInteraction();
storedclasses = dbInteractionObject.FetchAllStoredClasses();
if (storedclasses != null)
{
classCount = storedclasses.Count;
}
//Assembly view disabled for java db. I don't know any other way
ICollection keysCollection = storedclasses.Keys;
foreach (string str in keysCollection)
{
if (!str.Contains(","))
{
toolStripButtonAssemblyView.Enabled = false;
break;
}
}
//Populate the TreeView
dbtreeviewObject.AddFavouritFolderFromDatabase();
dbtreeviewObject.AddTreeNode(storedclasses, null);
SelectFirstClassNode();
propertiesTab = PropertiesTab.Instance;
if (classCount == 0)
{
propertiesTab.ShowClassProperties = false;
toolStripButtonAssemblyView.Enabled = toolStripButtonFlatView.Enabled = false;
}
recConnection = dbInteraction.GetCurrentRecentConnection();
PopulateSearchStrings();
dbtreeviewObject.Focus();
dbtreeviewObject.Refresh();
OMETrace.WriteFunctionEnd();
instance = this;
}
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;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["logIn"] == null)
{
Label1.Text = "Accesso non consentito!";
Label2.Text = "Eseguire il login";
}
else
{
try
{
int scelta = Convert.ToInt32(Request.QueryString["tblInd"]);
dbInteraction DBI = new dbInteraction();
DataTable dt = new DataTable();
switch (scelta)
{
case 0: Label1.Text = "Piloti Trainatori"; Label2.Text = "Lista dei pilota trainatori"; Label3.Text = "Aggiungi Trainatore";
dt = DBI.RetrievePiloti("Trainatore");; break;
case 1: Label1.Text = "Piloti Alianti"; Label2.Text = "Lista dei piloti degli alianti"; Label3.Text = "Aggiungi Pilota aliante";
dt = DBI.RetrievePiloti("Pilota"); break;
case 2: Label1.Text = "Istruttori"; Label2.Text = "Lista dei piloti istruttori"; Label3.Text = "Aggiungi Istruttore";
dt = DBI.RetrievePiloti("Istruttore"); break;
case 3: Label1.Text = "Modelli aerei trainanti"; Label2.Text = "Lista dei modelli degli aerei trainanti registrati"; Label3.Text = "Aggiungi Aereo da traino";
dt = DBI.RetrieveAereo("ModelloTrainatore"); break;
case 4: Label1.Text = "Modelli Alianti"; Label2.Text = "Lista dei modelli degli alianti registrati"; Label3.Text = "Aggiungi Aliante";
dt = DBI.RetrieveAereo("ModelloAliante"); break;
default: throw new FormatException(); break;
}
GridView1.DataSource = dt;
GridView1.DataBind();
}
catch (FormatException)
{
Label1.Text = "Scelta errata";
Label1.ForeColor = Color.Red;
Label2.Text = "Si prega di selezionare una voce corretta";
}
}
}
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;
}
}
}
}
}
public static void ElaboraAereiDaTraino(dbInteraction DBI, JSONObject coop)
{
bool[] sessione = new bool[coop.sessioni.Count];
foreach (ModelloAereo ma in coop.aereiTrainanti)
{
int idAereo = DBI.AddModTrainatore(ma);
if (idAereo == -1)
{
for (int i = 0; i < coop.sessioni.Count; i++)
{
if (!sessione[i] && ma.id == coop.sessioni[i].IDModTrainatore)
{
SessioneGiorno sg = coop.sessioni[i];
sg.IDModTrainatore = idAereo;
coop.sessioni[i] = sg;
sessione[i] = true;
}
}
}
}
}
public static void ElaboraTrainatori(dbInteraction DBI, JSONObject coop)
{
bool[] sessioni = new bool[coop.sessioni.Count];
foreach (Pilota p in coop.pils)
{
int idPilot = DBI.AddPilot(p);
if (idPilot != -1)
{
for (int i = 0; i < coop.sessioni.Count; i++)
{
if (!sessioni[i] && coop.sessioni[i].IDTrainatore == p.id)
{
SessioneGiorno sg = coop.sessioni[i];
sg.IDTrainatore = idPilot;
coop.sessioni[i] = sg;
sessioni[i] = true;
}
}
}
}
}
protected void RetrieveSessioni(int idPilota)
{
dbInteraction DBI = new dbInteraction();
DropDownList2.Items.Clear();
DataTable dt = DBI.RetrieveSessioni(idPilota);
for (int i = 0; i < dt.Rows.Count; i++)
{
string data = dt.Rows[i][1].ToString().Split(' ')[0];
DropDownList2.Items.Add(new ListItem(data, dt.Rows[i][0].ToString()));
}
if (DropDownList2.Items.Count > 0)
{
RetrieveTraini(Convert.ToInt32(DropDownList2.Items[0].Value));
}
else
{
GridView1.DataSource = null;
GridView1.DataBind();
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
dbInteraction DBI = new dbInteraction();
if (txtPara1.Text != "" && txtpara2.Text != "")
{
switch (c)
{
case 0: Session["result"] = DBI.AddPilot(new Pilota(txtPara1.Text, txtpara2.Text)); break;
case 1: Session["result"] = DBI.AddPilotAliante(new Pilota(txtPara1.Text, txtpara2.Text)); break;
case 2: Session["result"] = DBI.AddInstructor(new Pilota(txtPara1.Text, txtpara2.Text)); break;
case 3: Session["result"] = DBI.AddModTrainatore(new ModelloAereo(txtPara1.Text, txtpara2.Text)); break;
case 4: Session["result"] = DBI.AddModAliante(new ModelloAereo(txtPara1.Text, txtpara2.Text)); break;
default: break;
}
}
Response.Redirect("~/aggiungiElemento.aspx");
}
public List <ProxyTreeGridRenderer> ExpandTreeGidNode(bool readOnly, object id, bool activate)
{
List <TreeGridViewRenderer> list = new dbInteraction().ExpandTreeGidNode(readOnly, id, activate);
return(ConvertToProxyTreeGridRendererList(list));
}
