/*
* // since we do not need edit the messages, we will not need a put request (we don't need to push anything)
* [HttpPut] // put request
* [ActionName("UpdateMessage")]
* public Message ChangeMessage(Message message)
* {
*
* MySqlConnection mySqlConnection = new MySqlConnection(connectionString);
*
* ListDictionary paramsList = new ListDictionary();
*
* try
* {
* mySqlConnection.Open();
*
* paramsList.Add("@id", message.Id);
* paramsList.Add("@message", message.Message1);
* paramsList.Add("@message", message.Rating);
* int status = ExecSPWithParams("dbo.update_message", paramsList);
*
* if (status > 0)
* {
* message.IsDbChangeSuccessful = true;
* }
* else
* {
* message.IsDbChangeSuccessful = false;
* }
*
* mySqlConnection.Close();
* return message;
* }
*
* catch (MySqlException MySqlException)
* {
* message.IsDbChangeSuccessful = false;
* message.ExcptnMsg = MySqlException.Message;
* return message;
* }
* catch (Exception err)
* {
* message.IsDbChangeSuccessful = false;
* message.ExcptnMsg = err.Message;
* return message;
* }
* finally
* {
* {
* mySqlConnection.Dispose();
* }
* }
* }
*/
/*
* WARNING: DO NOT DELETE THE XML CODE BELOW!
*/
// we use 3 foward slashes for programmign xml in visual c# (asp.net)
/// <!-- define our summary -->
/// <summary>
/// Executes given Stored Procedure and returns integer
/// </summary>
/// <param name="spName">Stored procedure</param> <!-- define our stored procedure parameter -->
/// <param name="paramsList">Parameter List</param> <!-- define our parameter list parameter tag -->
/// <returns>Integer</returns> <!-- this is what we will return -->
private int ExecSPWithParams(string spName, ListDictionary paramsList) // define new private integer passing in the stored procedure name string and a list dictionary named paramsList
{
MySqlConnection con = new MySqlConnection(connectionString); // define mysql connection
con.Open(); // open the mysql connection
int status = ServerCommon.ExecuteNonQuery(con, spName, paramsList); // define the integer status
con.Close(); // close the mysql connection
return(status); // return the integer status
}
/*
* WARNING: DO NOT DELETE XML CODE BELOW!
*/
/// <summary>
/// Executes given Stored Procedue and returns integer
/// </summary>
/// <param name="spName">Stored procedure</param>
/// <param name="paramsList">Parameter List</param>
/// <returns>Integer</returns>
private int ExecSPWithParams(string spName, ListDictionary paramsList)
{
MySqlConnection con = new MySqlConnection(connectionString);
con.Open();
int status = ServerCommon.ExecuteNonQuery(con, spName, paramsList);
con.Close();
return(status);
}