public static Category ToCategory(this BsonDocument doc) { Category category = new Category(); category.CategoryFolder = doc["CategoryFolder"].ToString(); category.CategoryUUID = doc["CategoryUUID"].ToString(); category.ContentUUID = doc["ContentUUID"].ToString(); return category; }
public MySqlCommand AddCategory(Repository repository, Category category) { string sql = string.Format("INSERT INTO `{0}`(UUID,CategoryFolder,CategoryUUID) VALUES(?UUID,?CategoryFolder,?CategoryUUID)" , repository.GetCategoryTableName()); MySqlCommand command = new MySqlCommand(); command.CommandText = sql; command.Parameters.Add(new MySqlParameter("?UUID", category.ContentUUID)); command.Parameters.Add(new MySqlParameter("?CategoryFolder", category.CategoryFolder)); command.Parameters.Add(new MySqlParameter("?CategoryUUID", category.CategoryUUID)); return command; }
public SqlCeCommand AddCategory(Repository repository, Category category) { string sql = string.Format("INSERT INTO [{0}](UUID,CategoryFolder,CategoryUUID) VALUES(@UUID,@CategoryFolder,@CategoryUUID)" , repository.GetCategoryTableName()); SqlCeCommand command = new SqlCeCommand(); command.CommandText = sql; command.Parameters.Add(new SqlCeParameter("@UUID", category.ContentUUID)); command.Parameters.Add(new SqlCeParameter("@CategoryFolder", category.CategoryFolder)); command.Parameters.Add(new SqlCeParameter("@CategoryUUID", category.CategoryUUID)); return command; }
public void Export_Categories_Data() { TextContent news1 = new TextContent(repository.Name, newsSchema.Name, textFolder.FullName); news1["Title"] = "title1"; news1["body"] = "body1"; provider.Add(news1); TextContent category1 = new TextContent(repository.Name, "category", "category"); category1["Title"] = "category1"; provider.Add(category1); var categories = new Category[] { new Category() { ContentUUID = news1.UUID, CategoryFolder = category1.FolderName, CategoryUUID = category1.UUID } }; provider.AddCategories(news1, categories); var exportedCategories = provider.ExportCategoryData(repository); Assert.IsTrue(exportedCategories.Count() > 1); }
public SqlCommand DeleteCategory(Repository repository, Category category) { string sql = string.Format("DELETE FROM [{0}] WHERE UUID=@UUID AND CategoryFolder=@CategoryFolder AND CategoryUUID=@CategoryUUID" , repository.GetCategoryTableName()); SqlCommand command = new SqlCommand(); command.CommandText = sql; command.Parameters.Add(new SqlParameter("@UUID", category.ContentUUID)); command.Parameters.Add(new SqlParameter("@CategoryFolder", category.CategoryFolder)); command.Parameters.Add(new SqlParameter("@CategoryUUID", category.CategoryUUID)); return command; }
public IEnumerable<Category> QueryCategories(TextContent content) { List<Category> list = new List<Category>(); SqlCeConnection connection; using (var dataReader = SQLCeHelper.ExecuteReader(content.GetRepository().GetConnectionString(), dbCommands.QueryCategories(content), out connection)) { try { while (dataReader.Read()) { Category category = new Category() { CategoryFolder = dataReader.GetString(dataReader.GetOrdinal("CategoryFolder")), CategoryUUID = dataReader.GetString(dataReader.GetOrdinal("CategoryUUID")), ContentUUID = dataReader.GetString(dataReader.GetOrdinal("UUID")), }; list.Add(category); } } finally { dataReader.Close(); connection.Close(); } } return list; }
public IEnumerable<Category> ExportCategoryData(Repository repository) { var connectionString = repository.GetConnectionString(); string sql = string.Format("SELECT UUID,CategoryFolder,CategoryUUID FROM [{0}] ", repository.GetCategoryTableName()); List<Category> list = new List<Category>(); SqlCeConnection connection; using (var reader = SQLCeHelper.ExecuteReader(connectionString, new SqlCeCommand() { CommandText = sql }, out connection)) { try { while (reader.Read()) { Category category = new Category(); category.ContentUUID = reader.GetString(0); category.CategoryFolder = reader.GetString(1); category.CategoryUUID = reader.GetString(2); list.Add(category); } } finally { reader.Close(); connection.Close(); } } return list; }
public IEnumerable<Category> QueryCategories(TextContent content) { MongoCollection<BsonDocument> collection = content.GetRepository().GetCategoriesCollection(); var query = MongoDBHelper.EQIgnoreCase("ContentUUID", content.UUID); var documents = collection.Find(query); List<Category> list = new List<Category>(); foreach (var doc in documents) { Category category = new Category() { CategoryFolder = doc["CategoryFolder"].AsString, CategoryUUID = doc["CategoryUUID"].AsString, ContentUUID = doc["ContentUUID"].AsString }; list.Add(category); } return list; }
public void Insert_Delete_Category() { TextContent news1 = new TextContent(repository.Name, newsSchema.Name, textFolder.FullName); news1["Title"] = "title1"; news1["body"] = "body1"; provider.Add(news1); TextContent category1 = new TextContent(repository.Name, "category", "category"); category1["Title"] = "category1"; provider.Add(category1); var categories = new Category[] { new Category() { ContentUUID = news1.UUID, CategoryFolder = category1.FolderName, CategoryUUID = category1.UUID } }; provider.AddCategories(news1, categories); provider.DeleteCategories(news1, categories); provider.AddCategories(news1, categories); provider.ClearCategories(news1); provider.ClearCategories(news1); }
public IEnumerable<Category> ExportCategoryData(Repository repository) { string sql = string.Format("SELECT UUID,CategoryFolder,CategoryUUID FROM `{0}` ", repository.GetCategoryTableName()); List<Category> list = new List<Category>(); MySqlConnection connection; using (var reader = MysqlHelper.ExecuteReader(repository, new MySqlCommand() { CommandText = sql }, out connection)) { while (reader.Read()) { Category category = new Category(); category.ContentUUID = reader.GetString(0); category.CategoryFolder = reader.GetString(1); category.CategoryUUID = reader.GetString(2); list.Add(category); } connection.Close(); } return list; }
public static Category ToCategory(this IViewRow row) { Category category = new Category(); var dict = row.Info["value"] as Dictionary<string, object>; category.CategoryFolder = dict["CategoryFolder"] as string; category.CategoryUUID = dict["CategoryUUID"] as string; category.ContentUUID = dict["ContentUUID"] as string; return category; }