public static List<Category> RetrieveAll() { SqlConnection conn = DB.DbConnect(); conn.Open(); string queryString = "SELECT * FROM CMS_Categories WHERE pageWorkFlowState != 4"; SqlCommand getCategories = new SqlCommand(queryString, conn); SqlDataReader categoryReader = getCategories.ExecuteReader(); List<Category> m_Categories = new List<Category>(); while (categoryReader.Read()) { Category tempCategory = new Category(); tempCategory.Id = categoryReader.GetInt32(0); tempCategory.CategoryTitle = categoryReader.GetString(1); tempCategory.PageWorkFlowState = categoryReader.GetInt32(2); m_Categories.Add(tempCategory); } conn.Close(); return m_Categories; }
public static void Create(Category m_Category) { SqlConnection conn = DB.DbConnect(); conn.Open(); string queryString = "INSERT INTO CMS_Categories(categoryName, pageWorkFlowState) VALUES(@categoryName, 1)"; SqlCommand insertCategory = new SqlCommand(queryString, conn); insertCategory.Parameters.AddWithValue("categoryName", m_Category.CategoryTitle); insertCategory.ExecuteNonQuery(); conn.Close(); }
public ActionResult EditCategory(Category m_Category) { if (ModelState.IsValid) { CategoryRepository.Update(m_Category); return RedirectToAction("Index", "Category"); } else { return View("EditCategory", m_Category); } }
public static List<Category> getCategories() { SqlConnection conn = DB.DbConnect(); conn.Open(); string queryString = "SELECT * FROM CMS_Categories"; SqlCommand getCategories = new SqlCommand(queryString, conn); SqlDataReader categoryReader = getCategories.ExecuteReader(); List<Category> m_Categories = new List<Category>(); while (categoryReader.Read()) { Category tempCat = new Category(); tempCat.Id = categoryReader.GetInt32(0); tempCat.CategoryTitle = categoryReader.GetString(1); m_Categories.Add(tempCat); } conn.Close(); return m_Categories; }
public void Update(Category m_Category) { DBCategory.Update(m_Category); }
public void Create(Category m_Category) { DBCategory.Create(m_Category); }
public static Category RetrieveOne(int id) { SqlConnection conn = DB.DbConnect(); conn.Open(); string queryString = "SELECT * FROM CMS_Categories WHERE id = @id AND pageWorkFlowState != 4"; SqlCommand getCategory = new SqlCommand(queryString, conn); getCategory.Parameters.AddWithValue("id", id); SqlDataReader categoryReader = getCategory.ExecuteReader(); Category m_Category = new Category(); if (categoryReader.Read()) { m_Category.Id = categoryReader.GetInt32(0); m_Category.CategoryTitle = categoryReader.GetString(1); m_Category.PageWorkFlowState = categoryReader.GetInt32(2); } conn.Close(); return m_Category; }
public static void Update(Category m_Category) { SqlConnection conn = DB.DbConnect(); conn.Open(); string queryString = "UPDATE CMS_Categories SET categoryName = @categoryName WHERE id = @id"; SqlCommand updateCategory = new SqlCommand(queryString, conn); updateCategory.Parameters.AddWithValue("categoryName", m_Category.CategoryTitle); updateCategory.Parameters.AddWithValue("id", m_Category.Id); updateCategory.ExecuteNonQuery(); conn.Close(); }
public ActionResult AddCategory() { Category m_Category = new Category(); return View("AddCategory", m_Category); }