/// <summary></summary> /// <param name="sender">The sender.</param> /// <param name="e">The e.</param> private void button1_Click(object sender, EventArgs e) { ReadingModel readingModel = new ReadingModel(0, Convert.ToInt32(nudReadingReading.Value), dtpReading.Value, Convert.ToInt32(nudReadingX.Value), Convert.ToInt32(nudReadingY.Value), missionModel.Id); ReadingModel newReadingModel = missionManager.AddReading(readingModel); if (newReadingModel != null) { MessageBox.Show("Reading toegevoegd"); this.AddStuff(); return; } MessageBox.Show("Oeps er ging iets mis"); }
/// <summary></summary> /// <param name="readingModel">The reading model.</param> /// <returns>The <see cref="ReadingModel"/>.</returns> public ReadingModel AddReading(ReadingModel readingModel) { string query = string.Format( "INSERT INTO READING (ID, READING, CAPTUREDATE, X, Y, MISSIONID) VALUES (seq_reading.nextval, '{0}', TO_TIMESTAMP('{1} 13:25:44.356000000', 'YYYY-MM-DD HH24:MI:SS.FF'), '{2}', '{3}', '{4}')", readingModel.Reading, readingModel.CaptureDate.ToShortDateString(), readingModel.X, readingModel.Y, readingModel.MissionID); OracleCommand command = new OracleCommand(query, DatabaseSettings.Connection); command.ExecuteNonQuery(); DatabaseSettings.Commit(); return readingModel; }
/// <summary></summary> /// <param name="id">The id.</param> /// <returns>The <see cref="List"/>.</returns> public List<ReadingModel> GetReadingsForMission(int id) { List<ReadingModel> readings = new List<ReadingModel>(); ReadingModel readingModel = null; try { string query = string.Format("select * from reading where missionid ={0}", id); OracleCommand command = new OracleCommand(query, DatabaseSettings.Connection); OracleDataReader reader = command.ExecuteReader(); while (reader.Read()) { readingModel = new ReadingModel(Convert.ToInt32(reader[0]), Convert.ToInt32(reader[1]), Convert.ToDateTime(reader[2]), Convert.ToInt32(reader[3]), Convert.ToInt32(reader[4]), Convert.ToInt32(reader[5])); readings.Add(readingModel); } return readings; } catch (Exception ex) { return null; } }