// Get all category names public static List<Category> GetAllCategoryNames() { int id; SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["globaldb"].ConnectionString); string q1 = "select * from categories"; SqlCommand com1 = new SqlCommand(q1, con1); SqlDataReader rdr; List<Category> list = new List<Category>(); Category category; con1.Open(); rdr = com1.ExecuteReader(); while (rdr.Read()) { category = new Category(); category.categoryID = Convert.ToInt32(rdr[0]); category.categoryName = rdr[1].ToString(); category.parentName = rdr[2].ToString(); list.Add(category); } con1.Close(); return list; }
public PostCategory(int _postid,Category _category) { postid = _postid; category = _category; }
//assign categories public static void Categories(int postid, List<string> lstCategories) { PostCategory.DeleteCatecoriesofPost(postid); foreach (string item in lstCategories) { Category category = new Category(); category.GetCategoryId(item); PostCategory postcategory = new PostCategory(postid, category); postcategory.PostCategorySave(); } }