public void Post([FromBody] RetrieveDataClass value) { string sqlstring = "server=; port= ; user id =;Password=;Database=;"; MySqlConnection conn = new MySqlConnection(sqlstring); try { conn.Open(); } catch (MySqlException ex) { throw ex; } string Query = "INSERT INTO test.blogtable (id,Telephone,CreatedSaved,Topic,Summary,Category,Body1,Body2,Body3,Body4)values('" + value.TopicSaved1 + "','" + Value.Telephone + "','" + Value.Created/Saved + "','" + value.TopicSaved1 + "','" +value.SummarySaved1 +"','" +value.CategoriesSaved1 +"','" +value.Body1 +"','" +value.Body2 +"','" +value.Body3 +"','" +value.Body4 +"');"; MySqlCommand cmd = new MySqlCommand(Query, conn); cmd.ExecuteReader(); conn.Close(); }
public IEnumerable <string> Get(int id) { IDbConnection dbConnection = System.Data.Common.DbProviderFactories.GetFactory("MySql.Data.MySqlClient"); RetrieveDataClass dal = new RetrieveDataClass(dbConnection); EventDataModel data = dal.GetDataEvent(id); if (data != null) { // Using Newtonsoft library to convert the object to JSON data string output = Newtonsoft.Json.JsonConvert.SerializeObject(data); // TODO : Not sure if you need IEnumerable<string> as return type return(new List <string>() { output }); } else { // TODO : handle a record not found - usually raises a 404 } }