//Insert statement
public static long?Insert(S_Contact contact)
{
long?lastInsertedId = null;
try
{
DatabaseConnection databaseconnection = new DatabaseConnection();
//open connection
if (databaseconnection.OpenConnection())
{
//create command and assign the query and connection from the constructor
MySqlCommand command = new MySqlCommand();
command.Connection = databaseconnection.getConnection();
command.CommandText = "INSERT INTO contact (email, message) VALUES (@email, @message)";
command.Parameters.AddWithValue("@email", Conversion.StringToSql(contact.email));
command.Parameters.AddWithValue("@message", Conversion.StringToSql(contact.message));
//Execute command
command.ExecuteNonQuery();
lastInsertedId = command.LastInsertedId;
//close connection
databaseconnection.CloseConnection();
}
}
catch (Exception ex)
{
logger.Error(string.Format("Insert, Error inserting contact data: {0}", ex.Message));
throw;
}
return(lastInsertedId);
}
private static S_Contact DataToObject(MySqlDataReader dataReader)
{
S_Contact contact = new S_Contact();
contact.id = Conversion.SqlToLongOrNull(dataReader["id"]).Value;
contact.email = Conversion.SqlToString(dataReader["email"]);
contact.message = Conversion.SqlToString(dataReader["message"]);
return(contact);
}
protected void buttonSubmitForm_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Page.MaintainScrollPositionOnPostBack = true;
bool validContact = false;
string result = string.Empty;
try
{
S_Contact contact = new S_Contact();
contact.email = contactEmail.Text;
contact.message = contactMessage.Text;
ContactManager.Insert(contact);
validContact = true;
Mail.SendContactMailToNBF(Settings.MailNBF, contactNaam.Text, contact.email, contact.message);
result = "Het bericht is verstuurd naar de NBF, u kunt spoedig een reactie te gemoed zien.";
contactNaam.Visible = false;
contactEmail.Visible = false;
contactMessage.Visible = false;
}
catch (Exception ex)
{
result = "Er is een fout opgetreden, probeer het nogmaals";
}
if (!validContact)
{
meldSuccess.Attributes.Add("style", "color:red");
}
else
{
meldSuccess.Attributes.Add("style", "color:black");
}
meldSuccess.InnerHtml = result;
}
}
