public void GetPublishedCategoriesFromDb()
{
SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["globaldb"].ConnectionString);
string q1 = "SELECT * FROM f_category where Published=1 AND ForumId=" + this.ForumId;
SqlCommand com1 = new SqlCommand(q1, con1);
con1.Open();
SqlDataReader rdr = com1.ExecuteReader();
ForumCategory cat;
while (rdr.Read())
{
cat = new ForumCategory();
cat.CategoryId = Convert.ToInt32(rdr["CategoryId"]);
cat.CategoryTitle = rdr["CategoryTitle"].ToString();
cat.SectionCount = Convert.ToInt32(rdr["SectionCount"]);
cat.CreatorId = Convert.ToInt32(rdr["CreatorId"]);
if (!(rdr["DateCreated"] == DBNull.Value))
cat.DateCreated = Convert.ToDateTime(rdr["DateCreated"]);
if (!(rdr["DateModified"] == DBNull.Value))
cat.DateModified = Convert.ToDateTime(rdr["DateModified"]);
cat.ForumId = this.ForumId;
cat.published = 1;
if (!(rdr["DatePublished"] == DBNull.Value))
cat.DatePublished = Convert.ToDateTime(rdr["DatePublished"]);
cat.GetPublishedSectionsFromDb();
CategoryList.Add(cat);
}
con1.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
thread = 1;//starting threads
threads = new List<ForumThread>();
category = Request.QueryString["category"].ToString();
SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["globaldb"].ConnectionString);
string q1 = "select * from f_category where CategoryTitle='" + category + "' and ForumId=" + Session["forumid"];
SqlCommand com1 = new SqlCommand(q1, con1);
SqlDataReader rdr;
cat = new ForumCategory();
con1.Open();
rdr = com1.ExecuteReader();
while (rdr.Read())
{
cat.CategoryId = Convert.ToInt32(rdr["CategoryId"]);
cat.CategoryTitle = rdr["CategoryTitle"].ToString();
cat.SectionCount = Convert.ToInt32(rdr["SectionCount"]);
cat.CreatorId = Convert.ToInt32(rdr["CreatorId"]);
if (!(rdr["DateCreated"] == DBNull.Value))
cat.DateCreated = Convert.ToDateTime(rdr["DateCreated"]);
if (!(rdr["DateModified"] == DBNull.Value))
cat.DateModified = Convert.ToDateTime(rdr["DateModified"]);
cat.ForumId = Convert.ToInt32(Session["forumid"]);
cat.published = 1;
if (!(rdr["DatePublished"] == DBNull.Value))
cat.DatePublished = Convert.ToDateTime(rdr["DatePublished"]);
}
con1.Close();
cat.GetPublishedSectionsFromDb();
}
protected void Button1_Click(object sender, EventArgs e)
{
ForumCategory category;
int published;
if (drpPublish1.SelectedIndex == 0)
published = 1;
else
published = 0;
//Session["userid"] = 1;
//Session["forumid"] = 1;
if(!string.IsNullOrEmpty(txtDesc1.Text))
category = new ForumCategory(txtTitle1.Text,Convert.ToInt32(Session["userid"]),published,Convert.ToInt32(Session["forumid"]),txtDesc1.Text);
else
category = new ForumCategory(txtTitle1.Text, Convert.ToInt32(Session["userid"]), published, Convert.ToInt32(Session["forumid"]));
category.CreateCategoryintoDb();
}
public void GetPublishedCategoriesFromDb()
{
SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["globaldb"].ConnectionString);
string q1 = "SELECT * FROM f_category where Published=1 AND ForumId=" + this.ForumId;
SqlCommand com1 = new SqlCommand(q1, con1);
con1.Open();
SqlDataReader rdr = com1.ExecuteReader();
ForumCategory cat;
while (rdr.Read())
{
cat = new ForumCategory();
cat.CategoryId = Convert.ToInt32(rdr["CategoryId"]);
cat.CategoryTitle = rdr["CategoryTitle"].ToString();
cat.SectionCount = Convert.ToInt32(rdr["SectionCount"]);
cat.CreatorId = Convert.ToInt32(rdr["CreatorId"]);
if (!(rdr["DateCreated"] == DBNull.Value))
{
cat.DateCreated = Convert.ToDateTime(rdr["DateCreated"]);
}
if (!(rdr["DateModified"] == DBNull.Value))
{
cat.DateModified = Convert.ToDateTime(rdr["DateModified"]);
}
cat.ForumId = this.ForumId;
cat.published = 1;
if (!(rdr["DatePublished"] == DBNull.Value))
{
cat.DatePublished = Convert.ToDateTime(rdr["DatePublished"]);
}
cat.GetPublishedSectionsFromDb();
CategoryList.Add(cat);
}
con1.Close();
}
