OpenCollective -- The Requirements Management Wiki

/*
OpenCollective -  http://www.netbrick.net/ -- Version 0.73
Copyright (c) 2004
by Tyler Jensen ( tylerj@netbrick.net ) of NetBrick Inc. ( http://www.netbrick.net )

Permission is hereby granted, free of charge, to any person obtaining a copy 
of this software and associated documentation files (the "Software"), to deal 
in the Software without restriction, including without limitation the rights 
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies 
of the Software, and to permit persons to whom the Software is furnished to do 
so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all 
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, 
INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR 
PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE 
LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, 
TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE 
OR OTHER DEALINGS IN THE SOFTWARE.
*/
using System;
using System.Data;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;

namespace OpenCollective.Data
{
	/// <summary>
	/// Summary description for DataAccess.
	/// </summary>
	public class DataAccess
	{
		static DataAccess() {} //all static 

		public static SqlDataReader GetTopicList()
		{
			return SqlHelper.ExecuteReader(Config.ConnectionString, "GetTopicList");
		}

		public static DataSet GetTopicListDataSet()
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetTopicList");
		}

		public static DataSet GetTopicTalk(string WikiName, string TopicTitle)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetTopicTalk", WikiName, TopicTitle);
		}

		public static DataSet GetTopic(string WikiName, string TopicTitle)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetTopic", WikiName, TopicTitle);
		}

		public static int GetTopicID(string WikiName, string TopicTitle)
		{
			object res = SqlHelper.ExecuteScalar(Config.ConnectionString, "GetTopicID", WikiName, TopicTitle);
			int retval = Convert.ToInt32(res);
			return retval;
		}

		public static DataSet GetWikiWatchList(int WikiTopicID)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetWikiWatchList", WikiTopicID);
		}

		public static bool IsWikiWatched(int WikiTopicID, string Author)
		{
			object res = SqlHelper.ExecuteScalar(Config.ConnectionString, "IsWikiWatched", WikiTopicID, Author);
			if(res == null)
				return false;
			else
				return true;
		}

		public static DataSet GetTopic(int TopicID)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetTopicByID", TopicID);
		}

		public static DataSet GetOldTopic(int HistID)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetOldTopic", HistID);
		}

		public static DataSet GetOldTalkTopic(int HistID)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetOldTalkTopic", HistID);
		}

		public static DataSet GetTopicHistory(string WikiName, string TopicTitle)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetTopicHistory", WikiName, TopicTitle);
		}

		public static DataSet GetTopicHistoryText(int WikiHistID)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetTopicHistoryText", WikiHistID);
		}

		public static DataSet GetTalkHistory(string WikiName, string TopicTitle)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetTopicTalkHistory", WikiName, TopicTitle);
		}

		public static DataSet GetTalkHistoryText(int WikiHistID)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetTopicTalkHistoryText", WikiHistID);
		}

		public static DataSet GetWikis()
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetWikis");
		}

		public static DataSet GetRecent(int Days, string WikiName)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetRecent", Days, WikiName);
		}

		public static DataSet GetRecentAll(int Days)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetRecentAll", Days);
		}

		public static DataSet GetRecentTalk(int Days, string WikiName)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetRecentTalk", Days, WikiName);
		}

		public static DataSet GetRecentAllTalk(int Days)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetRecentAllTalk", Days);
		}

		public static DataSet GetWikiTopicLock(int WikiTopicID)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetWikiTopicLock", WikiTopicID);
		}

		public static void ToggleWikiTopicLock(int WikiTopicID, string Author)
		{
			SqlHelper.ExecuteNonQuery(Config.ConnectionString, "ToggleWikiTopicLock", WikiTopicID, Author);
		}

		public static int GetTopicHistoryCount(string WikiName, string TopicTitle)
		{
			object res = SqlHelper.ExecuteScalar(Config.ConnectionString, "GetTopicHistoryCount", WikiName, TopicTitle);
			int retval = Convert.ToInt32(res);
			return retval;
		}

		public static int GetTopicTalkHistoryCount(string WikiName, string TopicTitle)
		{
			object res = SqlHelper.ExecuteScalar(Config.ConnectionString, "GetTopicTalkHistoryCount", WikiName, TopicTitle);
			int retval = Convert.ToInt32(res);
			return retval;
		}

		public static int UpdateTopicTalk(string WikiName, string TopicTitle, string Author, bool IsMinor, string EditSummary, string TopicText)
		{
			object res = SqlHelper.ExecuteScalar(Config.ConnectionString, "UpdateTopicTalk", WikiName, TopicTitle, Author, IsMinor, EditSummary, TopicText);
			int retval = Convert.ToInt32(res);
			return retval;
		}

		public static int UpdateTopic(string WikiName, string TopicTitle, string Author, bool IsMinor, string EditSummary, string TopicText)
		{
			object res = SqlHelper.ExecuteScalar(Config.ConnectionString, "UpdateTopic", WikiName, TopicTitle, Author, IsMinor, EditSummary, TopicText);
			int retval = Convert.ToInt32(res);
			return retval;
		}

		public static void DeleteTopicByID(int TopicID)
		{
			SqlHelper.ExecuteNonQuery(Config.ConnectionString, "DeleteTopicByID", TopicID);
		}

		public static DataSet WordSearch()
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "WordSearch");
			//columns in order:
			//	WikiTopicID, TopicTitle, TopicRank, RankSum, HitCount, LastIndexed, Summary
		}

		public static DataSet WordSearch(string SearchTerms)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "WordSearch", SearchTerms);
		}

		public static DataSet GetTopicsStartLike(string WikiName, string Part)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetTopicsStartLike", WikiName, Part);
		}

		public static DataSet GetTopicsEndLike(string WikiName, string Part)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetTopicsEndLike", WikiName, Part);
		}

		//watch procedures
		public static DataSet GetWikiWatches(string Author)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetWikiWatches", Author);
		}

		public static void ToggleWikiWatch(int WikiTopicID, string Author)
		{
			SqlHelper.ExecuteNonQuery(Config.ConnectionString, "ToggleWikiWatch", WikiTopicID, Author);
		}

		public static DataSet GetWikiWatchAddress(string Author)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetWikiWatchAddress", Author);
		}

		public static void UpdateWikiWatchAddress(string Author, string Address)
		{
			SqlHelper.ExecuteNonQuery(Config.ConnectionString, "UpdateWikiWatchAddress", Author, Address);
		}


		//File procedures
		public static DataSet GetAllWikiFileNames()
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetAllWikiFileNames");
		}

		public static DataSet GetWikiFileNames(string WikiName)
		{
			return SqlHelper.ExecuteDataset(Config.ConnectionString, "GetWikiFileNames", WikiName);
		}

		public static object GetWikiFile(string WikiName, string FileName)
		{
			return SqlHelper.ExecuteScalar(Config.ConnectionString, "GetWikiFile", WikiName, FileName);
		}

		public static object RenameWikiFile(string WikiName, string OldFileName, string NewFileName)
		{
			return SqlHelper.ExecuteScalar(Config.ConnectionString, "RenameWikiFile", WikiName, OldFileName, NewFileName);
		}

		public static object AddWikiFile(string WikiName, string FileName, byte[] FileData, string Author)
		{
			int FileSize = FileData.Length;
			return SqlHelper.ExecuteScalar(Config.ConnectionString, "AddWikiFile", WikiName, FileName, FileSize, FileData, Author);
		}

		public static object DeleteWikiFile(string WikiName, string FileName)
		{
			return SqlHelper.ExecuteScalar(Config.ConnectionString, "DeleteWikiFile", WikiName, FileName);
		}

		// *************************************************************************************
		// *********************************** Data Access *************************************
		// *************************************************************************************

		public static SqlDataReader GetTopics()
		{
			return SqlHelper.ExecuteReader(Config.ConnectionString, "GetTopics");
		}

		public static SqlDataReader GetWords()
		{
			return SqlHelper.ExecuteReader(Config.ConnectionString, "GetWords");
		}

		public static int AddWord(string word)
		{
			object retval = SqlHelper.ExecuteScalar(Config.ConnectionString, "AddWord", word.ToLower());
			return Convert.ToInt32(retval);
		}

		public static SqlDataReader GetTopicAndRank(string WikiName, string TopicTitle)
		{
			return SqlHelper.ExecuteReader(Config.ConnectionString, "GetTopicAndRank", WikiName, TopicTitle);
		}

		public static SqlDataReader GetTopicIndex(int TopicID)
		{
			return SqlHelper.ExecuteReader(Config.ConnectionString, "GetTopicIndex", TopicID);
		}

		public static void AddWordIndexEntry(int WordID, int TopicID, int WordCount)
		{
			SqlHelper.ExecuteNonQuery(Config.ConnectionString, "WikiWordIndex_Add", WordID, TopicID, WordCount);
		}

		public static void UpdateWordIndexEntry(int WordID, int TopicID, int WordCount)
		{
			SqlHelper.ExecuteNonQuery(Config.ConnectionString, "WikiWordIndex_Update", WordID, TopicID, WordCount);
		}

		public static void DeleteWordIndexEntry(int WordID, int TopicID)
		{
			SqlHelper.ExecuteNonQuery(Config.ConnectionString, "WikiWordIndex_Delete", WordID, TopicID);
		}

		public static void AddUpdateSummary(int TopicID, string Summary)
		{
			SqlHelper.ExecuteNonQuery(Config.ConnectionString, "WikiSummary_AddUpdate", TopicID, Summary);
		}

		public static SqlDataReader GetTopicsIndexed()
		{
			return SqlHelper.ExecuteReader(Config.ConnectionString, "GetTopicsIndexed");
		}

		public static void RemoveIndexedTopic(int TopicID)
		{
			SqlHelper.ExecuteNonQuery(Config.ConnectionString, "RemoveIndexedTopic", TopicID);
		}

		public static void AddUpdateTopicRank(int TopicID, int TopicRank)
		{
			SqlHelper.ExecuteNonQuery(Config.ConnectionString, "WikiTopicRank_AddUpdate", TopicID, TopicRank);
		}


	}
}