public static void InsertData(Post.PostModel model)
{
using (var connection = new MySqlConnection("SERVER=remotemysql.com; DATABASE=Q9hz1aOZ3d; Uid=Q9hz1aOZ3d; Pwd=doh0BUmUlQ"))
{
connection.Open();
try
{
if (connection.State == System.Data.ConnectionState.Open)
{
var date = DateTime.Now;
var datetime = date.Year + "-" + date.Month + "-" + date.Day + " " + date.Hour + ":" + date.Minute;
// var cmd = $"";
using (var command = connection.CreateCommand())
{
command.CommandText = $"Insert into Posts (Meno, Titul, Telo, Vytvorene) values (@Meno,@Titul,@Telo,@Vytvorene)";
command.Parameters.AddWithValue("@Meno", model.Name);
command.Parameters.AddWithValue("@Titul", model.Title);
command.Parameters.AddWithValue("@Telo", model.Body);
command.Parameters.AddWithValue("@Vytvorene", datetime);
command.ExecuteNonQuery();
connection.Close();
}
}
}
catch (Exception ex)
{
}
}
}
public void OnPost()
{
Post.PostModel model = new Post.PostModel();
model.Body = Request.Form["Text"];
model.Title = Request.Form["Title"];
model.Name = Request.Form["Name"];
InsertData(model);
}
public void SelectData(Post.PostModel model)
{
using (var connection = new MySqlConnection("SERVER=remotemysql.com; DATABASE=Q9hz1aOZ3d; Uid=Q9hz1aOZ3d; Pwd=doh0BUmUlQ"))
{
connection.Open();
try
{
if (connection.State == System.Data.ConnectionState.Open)
{
var date = DateTime.Now;
var datetime = date.Year + "-" + date.Month + "-" + date.Day;
// var cmd = $"";
using (var command = connection.CreateCommand())
{
command.CommandText = $"Select Meno, Titul, Telo, Vytvorene from Posts order by Vytvorene desc";
using (MySqlDataReader rdr = command.ExecuteReader())
{
if (rdr.HasRows)
{
var count = rdr.FieldCount;
while (rdr.Read())
{
for (var i = 0; i < count; i++)
{
if (rdr.GetValue(i) != null)
{
list.Add(rdr.GetValue(i).ToString());
}
}
}
}
}
}
}
}
catch (Exception ex)
{
}
connection.Close();
ViewData["Results"] = list;
return;
}
}
public void OnGet()
{
Post.PostModel model = new Post.PostModel();
SelectData(model);
}