ASP.NET

try
{
    sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
    sql_connection.Open();
    sql_command = new MySqlCommand("sp_add_support_ticket", sql_connection);
    sql_command.CommandType = CommandType.StoredProcedure;
 
    sql_command.Parameters.AddWithValue("param_support_incident_title", txtSubject.Text);
    sql_command.Parameters.AddWithValue("param_email_address", txtEmailAddress.Text);
    sql_command.Parameters.AddWithValue("param_support_ticket_description", txtMessage.XHTML);
 
    int result_rows = sql_command.ExecuteNonQuery();
 
    Session["message_title"] = "Thank you";
    Session["message_title_Color"] = Color.Blue.ToArgb();
    Session["message_text"] = "We have recieved your feedback and we will get back to you as soon as possible.";
    Session["message_button_title"] = "Back";
    Session["message_button_url"] = "Home.aspx";
 
    Response.Redirect("Message.aspx", false);
}
catch (Exception exp)
{
    Session["message_title"] = "Error";
    Session["message_title_Color"] = Color.Red.ToArgb();
    Session["message_text"] = "Unable to send your message. Please try again later.";
    Session["message_button_title"] = "Back";
    Session["message_button_url"] = Request.UrlReferrer.ToString();
 
    Response.Redirect("Message.aspx", false);
}
finally
{
    if (sql_connection != null)
    {
        if (sql_connection.State == ConnectionState.Open)
            sql_connection.Close();
    }
}

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_add_support_ticket`(IN `param_support_incident_title` varchar(255),IN `param_email_address` varchar(255),IN `param_support_ticket_description` text)
BEGIN
	INSERT INTO support_incidents (support_incident_title, email_address) VALUES (param_support_incident_title, param_email_address);
	INSERT INTO support_tickets (support_incident_id, support_ticket_description) VALUES (LAST_INSERT_ID(), param_support_ticket_description);
END

in support_incodents table with "Thank you" in support_incident_title field

in support_tickets table with "We have recieved your feedback and we will get back to you as soon as possible." in support_ticket_description field