private void btnReserve_Click(object sender, RoutedEventArgs e) { Stand currentStand = (Stand)this.listBoxStaende.SelectedItem; currentStand.name = this.txtNameReserve.Text; this.db.updateStand(currentStand); this.refresh(); }
public void updateStand(Stand stand) { List <Stand> staende = new List <Stand>(); OracleCommand cmd = new OracleCommand(); cmd.CommandText = "UPDATE stand SET name = '" + stand.name + "' WHERE nr = " + stand.nr; cmd.Connection = conn; cmd.ExecuteNonQuery(); }
public List <Stand> selectStaendeUmkreis(Stand stand, int radius) { List <Stand> listStaende = new List <Stand>(); OracleCommand cmd = new OracleCommand(); cmd.CommandText = "select nr, name from stand WHERE SDO_WITHIN_DISTANCE(stand.position,SDO_GEOMETRY(2001,NULL,SDO_POINT_TYPE(" + stand.position.X + ", " + stand.position.Y + ", NULL),NULL,NULL),'distance= " + radius + "') = 'TRUE'"; cmd.Connection = conn; OracleDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { listStaende.Add(new Stand(Convert.ToInt32(dr["nr"]), new Point(0, 0), Convert.ToString(dr["name"]))); } } return(listStaende); }