using System;
using System.Data;
using System.Data.SqlClient;
using Wrox.WebModules.Data;

namespace Wrox.WebModules.AdsManager.Data
{
	/// <summary>
	/// Summary description for AdMaster.
	/// </summary>
	public class AdMaster : Wrox.WebModules.Data.DbObject
	{
		public AdMaster(string newConnectionString): base(newConnectionString)
		{	}
		
		public DataSet GetCompanyList()
		{
			DataSet companies = RunProcedure( "sp_AdsManager_GetCompanyList",
											   new SqlParameter[]{}, "Users" );
			return companies;			
		}

		public DataSet GetAdList()
		{
			DataSet ads = RunProcedure( "sp_AdsManager_GetAdList",
				new SqlParameter[]{}, "Advertisements" );
			return ads;
		}
		
		public void CreateCompany(string companyName)
		{
			int rowsAffected;

			SqlParameter[] parameters = { new SqlParameter("@CompanyName", SqlDbType.VarChar, 255) };
			parameters[0].Value = companyName;
			RunProcedure("sp_AdsManager_CreateCompany", parameters, out rowsAffected );
		}
	}
}