public ContentManagementModel GetContentsByType(ContentType type)
{
ContentManagementModel cm = new ContentManagementModel();
using (MySqlConnection conn = new MySqlConnection(constr))
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "SELECT * FROM contentmanagement WHERE Type = @Type ORDER BY Id ASC";
cmd.Parameters.AddWithValue("Type", Convert.ToInt32(type));
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
cm.Id = Convert.ToInt32(reader["id"]);
cm.Type = (ContentType)Convert.ToInt32(reader["type"]);
cm.Contents = reader["contents"].ToString();
}
}
conn.Close();
}
}
return(cm);
}
public List <ContentManagementModel> GetPopUp()
{
ContentManagementModel cm;
List <ContentManagementModel> lcm = new List <ContentManagementModel>();
using (MySqlConnection conn = new MySqlConnection(constr))
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "SELECT * FROM contentmanagement WHERE Id IN (33, 34) ORDER BY Id ASC";
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
cm = new ContentManagementModel();
cm.Id = Convert.ToInt32(reader["id"]);
cm.Type = (ContentType)Convert.ToInt32(reader["type"]);
cm.Contents = reader["contents"].ToString();
lcm.Add(cm);
}
}
conn.Close();
}
}
return(lcm);
}
