// POST api/macroData
public HttpResponseMessage Post(dynamic obj)
{
string indexCode = Convert.ToString(obj.indexCode);
string indexName = Convert.ToString(obj.indexName);
string tradeName = Convert.ToString(obj.tradeName);
string informationSource = Convert.ToString(obj.informationSource);
string unit = Convert.ToString(obj.unit);
double indexData = Convert.ToDouble(obj.indexData);
string frequency = Convert.ToString(obj.frequency);
DateTime relaseDate = DateTime.Now;
MySqlConnection conn = MysqlConnect.Conn();
MySqlCommand command = MysqlConnect.getSqlCommand("insert into tb_sample_macrodata(indexCode, indexName, tradeName, informationSource, unit, indexData, frequency, relaseDate) values('" + indexCode + "'," + indexName + ", '" + tradeName + "', '" + informationSource + "', '" + unit + "', '" + indexData + "', '" + frequency + "', '" + relaseDate + "')", conn);
conn.Open();
string msg = "success";
try
{
command.ExecuteNonQuery();
}
catch (Exception e)
{
msg = e.Message;
}
if (msg == "success")
{
var response = Request.CreateResponse(HttpStatusCode.OK);
response.StatusCode = HttpStatusCode.OK;
response.Content = new StringContent(msg);
return(response);
}
else
{
var response = Request.CreateResponse(HttpStatusCode.Forbidden);
response.StatusCode = HttpStatusCode.Forbidden;
response.Content = new StringContent(msg);
return(response);
}
}
public IEnumerable <SampleData> getAll()
{
//return newss;
List <SampleData> listData = new List <SampleData>();
MySqlConnection conn = MysqlConnect.Conn();
MySqlCommand command = MysqlConnect.getSqlCommand("select * from tb_sample_data", conn);
conn.Open();
MySqlDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
if (reader.HasRows)
{
SampleData sample = new SampleData {
id = reader.GetInt32(0), date = reader.GetDateTime(1), open = reader.GetDouble(2), close = reader.GetDouble(3), lowest = reader.GetDouble(4), highest = reader.GetDouble(5)
};
listData.Add(sample);
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
finally
{
reader.Close();
}
conn.Close();
return(listData);
}
public IEnumerable <User> getAll()
{
//return newss;
List <User> listUser = new List <User>();
MySqlConnection conn = MysqlConnect.Conn();
MySqlCommand command = MysqlConnect.getSqlCommand("select * from user", conn);
conn.Open();
MySqlDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
if (reader.HasRows)
{
User user = new User {
id = reader.GetInt32(0), name = reader.GetString(1), age = reader.GetInt32(2), column1 = reader.GetString(3), column2 = reader.GetString(4), column3 = reader.GetString(5)
};
listUser.Add(user);
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
finally
{
reader.Close();
}
conn.Close();
return(listUser);
}
public IEnumerable <News> getAllNews()
{
//return newss;
List <News> listNews = new List <News>();
MySqlConnection conn = MysqlConnect.Conn();
MySqlCommand command = MysqlConnect.getSqlCommand("select * from tb_news", conn);
conn.Open();
MySqlDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
if (reader.HasRows)
{
News news = new News {
ID = reader.GetInt32(0), NewsTitle = reader.GetString(1), NaviContent = reader.GetString(2), Content = reader.GetString(3), Author = reader.GetString(4), Date = reader.GetDateTime(5)
};
listNews.Add(news);
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
finally
{
reader.Close();
}
conn.Close();
return(listNews);
}
public IEnumerable <MacroData> GetAll()
{
List <MacroData> listData = new List <MacroData>();
MySqlConnection conn = MysqlConnect.Conn();
MySqlCommand command = MysqlConnect.getSqlCommand("select * from tb_sample_macrodata", conn);
conn.Open();
MySqlDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
if (reader.HasRows)
{
MacroData data = new MacroData {
id = reader.GetInt32(0), indexCode = reader.GetString(1), indexName = reader.GetString(2), tradeName = reader.GetString(3), informationSource = reader.GetString(4), unit = reader.GetString(5), indexData = reader.GetDouble(6), frequency = reader.GetString(7), relaseDate = reader.GetDateTime(8)
};
listData.Add(data);
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
finally
{
reader.Close();
}
conn.Close();
return(listData);
}
