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); }