public List <ArticleCategoryViewModel> Categories() { List <ArticleCategoryViewModel> l = new List <ArticleCategoryViewModel>(); using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString)) { using (SqlCommand cmd = new SqlCommand("SELECT ArticleCategorySerial, CategoryName, SortOrder FROM cms_ArticleCategory WHERE ModuleID = @ModuleID AND Locale = @Locale ORDER BY SortOrder, CategoryName", cn)) { cmd.CommandType = CommandType.Text; cmd.Parameters.Add("ModuleID", SqlDbType.UniqueIdentifier).Value = _ModuleID; cmd.Parameters.Add("Locale", SqlDbType.VarChar, 10).Value = _Locale; cmd.Connection.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ArticleCategoryViewModel cat = new ArticleCategoryViewModel(); cat.ArticleCategorySerial = dr.GetInt32(0); cat.ModuleID = _ModuleID; cat.CategoryName = dr.GetString(1); cat.SortOrder = dr.GetInt32(2); l.Add(cat); } cmd.Connection.Close(); } } return(l); }
public void Add(ArticleCategoryViewModel articleViewModel) { using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString)) { using (SqlCommand cmd = new SqlCommand("INSERT INTO cms_ArticleCategory (ModuleID, Locale, CategoryName, SortOrder) VALUES (@ModuleID, @Locale, @CategoryName, @SortOrder)", cn)) { cmd.CommandType = CommandType.Text; cmd.Parameters.Add("ModuleID", SqlDbType.UniqueIdentifier).Value = _ModuleID; cmd.Parameters.Add("Locale", SqlDbType.VarChar, 10).Value = _Locale; cmd.Parameters.Add("CategoryName", SqlDbType.NVarChar).Value = articleViewModel.CategoryName; cmd.Parameters.Add("SortOrder", SqlDbType.Int).Value = articleViewModel.SortOrder; cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); } } }