//POST METHOD
public void InsertEnvironmentConstant(EnvironmentConstant ev)
{
string queryString = string.Format("INSERT INTO environmentconstants VALUES({0}, '{1}', {2})",
ev.ConstantID, ev.A, ev.N);
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(queryString, connector.conn);
cmd.ExecuteNonQuery();
}
// POST: api/EnvironmentConstants
public void Post([FromBody] EnvironmentConstant value)
{
EnvironmentConstantsPersistence evp = new EnvironmentConstantsPersistence();
if (value != null)
{
evp.InsertEnvironmentConstant(value);
}
}
//GET ALL ENVIRONMENT CONSTANTS
public List<EnvironmentConstant> GetAllEnvironmentConstants()
{
List<EnvironmentConstant> environmentConstantList = new List<EnvironmentConstant>();
MySql.Data.MySqlClient.MySqlDataReader mySqlDataReader = null;
string sqlString = "SELECT * FROM EnvironmentConstants";
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, connector.conn);
mySqlDataReader = cmd.ExecuteReader();
while (mySqlDataReader.Read())
{
EnvironmentConstant res = new EnvironmentConstant();
res.ConstantID = mySqlDataReader.GetInt32(0);
res.A = mySqlDataReader.GetDouble(1);
res.N = mySqlDataReader.GetDouble(2);
environmentConstantList.Add(res);
}
return environmentConstantList;
}
private void InitializeData()
{
new EnvironmentConstantProvider().Provide(out EnvironmentConstant environmentConstantObject);
environmentConstant = environmentConstantObject;
}
