//Update a forum
public void update(ForumModel forum)
{
connection.Connect();
SqlCommand sqlCommand = new SqlCommand("update forum set name = @name, description = @description where id = @id", connection.getConnection());
sqlCommand.Parameters.AddWithValue("@name", forum.name);
sqlCommand.Parameters.AddWithValue("@description", forum.description);
sqlCommand.Parameters.AddWithValue("@id", forum.id);
sqlCommand.ExecuteNonQuery();
connection.disConnect();
}
//Store a forum
public int store(ForumModel forum)
{
SqlCommand sqlCommand = new SqlCommand("insert into forum (name, description) VALUES (@name, @description) select scope_identity()", connection.getConnection());
connection.Connect();
sqlCommand.Parameters.AddWithValue("@name", forum.name);
sqlCommand.Parameters.AddWithValue("@description", forum.description);
sqlCommand.Connection = connection.getConnection();
int id = (int)(decimal)sqlCommand.ExecuteScalar();
connection.disConnect();
return(id);
}
//Find a forum
public ForumModel find(int id)
{
ForumModel forum = new ForumModel();
connection.Connect();
SqlCommand sqlCommand = new SqlCommand("select * from forum where id=@id", connection.getConnection());
sqlCommand.Parameters.AddWithValue("@id", id);
SqlDataReader reader = sqlCommand.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
forum.id = Convert.ToInt32(reader["id"]);
forum.name = reader["name"].ToString();
forum.description = reader["description"].ToString();
}
}
connection.disConnect();
return(forum);
}
//Return all forums
public List <ForumModel> index()
{
ForumModel forum;
List <ForumModel> forums = new List <ForumModel>();
connection.Connect();
SqlCommand sqlCommand = new SqlCommand("select * from forum", connection.getConnection());
SqlDataReader reader = sqlCommand.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
forum = new ForumModel();
forum.id = Convert.ToInt32(reader["id"]);
forum.name = reader["name"].ToString();
forum.description = reader["description"].ToString();
forums.Add(forum);
}
}
connection.disConnect();
return(forums);
}