public TidalPrediction getTidalPredictionByID(int ID)
{
//GET Tidal Prediction by ID
TidalPrediction tp = new TidalPrediction();
MySql.Data.MySqlClient.MySqlDataReader mySqlReader = null;
String sqlString = "SELECT * FROM tidalprediction WHERE PredictionID = " + ID.ToString();
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, conn);
mySqlReader = cmd.ExecuteReader();
if (mySqlReader.Read())
{
tp.PredictionID = mySqlReader.GetInt32(0);
tp.Latitude = mySqlReader.GetDouble(1);
tp.Longitude = mySqlReader.GetDouble(2);
tp.StationLocation = mySqlReader.GetString(3);
tp.Date = mySqlReader.GetDateTime(4);
tp.Water_Level = mySqlReader.GetDouble(5);
tp.Water_Level_ODM = mySqlReader.GetDouble(6);
return(tp);
}
else
{
return(null);
}
}
public ArrayList getAllTidalPredictions()
{
//GET all Tidal Predictions
ArrayList tidalPredictionArray = new ArrayList();
MySql.Data.MySqlClient.MySqlDataReader mySqlReader = null;
String sqlString = "SELECT * FROM tidalprediction";
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, conn);
mySqlReader = cmd.ExecuteReader();
while (mySqlReader.Read())
{
TidalPrediction tp = new TidalPrediction();
tp.PredictionID = mySqlReader.GetInt32(0);
tp.Latitude = mySqlReader.GetDouble(1);
tp.Longitude = mySqlReader.GetDouble(2);
tp.StationLocation = mySqlReader.GetString(3);
tp.Date = mySqlReader.GetDateTime(4);
tp.Water_Level = mySqlReader.GetDouble(5);
tp.Water_Level_ODM = mySqlReader.GetDouble(6);
tidalPredictionArray.Add(tp);
}
return(tidalPredictionArray);
}
public TidalPrediction Get(string station)
{
TidalPredictionPersistance tpp = new TidalPredictionPersistance();
TidalPrediction tidalPrediction = tpp.getTidalPredictionByStation(station);
return(tidalPrediction);
}
public TidalPrediction Get(int id)
{
TidalPredictionPersistance tpp = new TidalPredictionPersistance();
TidalPrediction tidalPrediction = tpp.getTidalPredictionByID(id);
return(tidalPrediction);
}
public void Post([FromBody] TidalPrediction value)
{
TidalPredictionPersistance tpp = new TidalPredictionPersistance();
int id;
id = (int)tpp.saveTidalPrediction(value);
value.PredictionID = id;
//RETURN HTTP STATUS CODES
// //HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created);
// //response.Headers.Location = new Uri(Request.RequestUri, String.Format("TidalPrediction/{0}", id));
// //return response;
}
public long saveTidalPrediction(TidalPrediction tidalPredictionToSave)
{
// var date = tidalPredictionToSave.Date.ToString("yyyy-MM-dd");
//POST functionality
String sqlString = "INSERT INTO tidalprediction (Latitude, Longitude, StationLocation, Date, Water_Level, Water_Level_ODM) " +
"VALUES (" + tidalPredictionToSave.Longitude + "," + tidalPredictionToSave.Latitude + ",'" + tidalPredictionToSave.StationLocation
+ "','" + tidalPredictionToSave.Date + "'," + tidalPredictionToSave.Water_Level + "," + tidalPredictionToSave.Water_Level_ODM + ")";
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, conn);
cmd.ExecuteNonQuery();
long id = (int)cmd.LastInsertedId;
return(id);
}
