Nawigacja

Zbiór zmian 779 dla branches

Data:

2009-07-24 16:51:43 (17 years ago)

Autor:

marek

Opis:

re #195 - dodano liste wszystkich dzialow i rozdzialow

Lokalizacja:

branches/Emisje/BazaReklam

Pliki:

r732	r779
13	13	{
14	14	_connectionString = connectionString;
	15	}
	16
	17	public override List<NavigationColumn> FindAll()
	18	{
	19	const string query = "SELECT Id, Name FROM dbo.Dzial ORDER BY SortOrder";
	20
	21	List<NavigationColumn> navigationColumns = new List<NavigationColumn>();
	22
	23	SqlConnection conn = null;
	24	SqlCommand cmd = null;
	25	SqlDataReader reader = null;
	26	try
	27	{
	28	conn = new SqlConnection(_connectionString);
	29	conn.Open();
	30	cmd = new SqlCommand(query, conn);
	31	reader = cmd.ExecuteReader();
	32	if (reader != null)
	33	{
	34	while (reader.Read())
	35	navigationColumns.Add(new NavigationColumn(reader.GetInt32(0), reader.GetString(1)));
	36	}
	37	}
	38	finally
	39	{
	40	if (reader != null)
	41	{
	42	reader.Close();
	43	reader.Dispose();
	44	}
	45	if (cmd != null) cmd.Dispose();
	46	if (conn != null)
	47	{
	48	conn.Close();
	49	conn.Dispose();
	50	}
	51	}
	52	return navigationColumns;
15	53	}
16	54

r732	r779
14	14	}
15	15
	16	public override List<NavigationSubColumn> FindAll()
	17	{
	18	const string query = "SELECT Id, Name FROM Rozdzial ORDER BY SortOrder";
	19
	20	List<NavigationSubColumn> navigationSubColumns = new List<NavigationSubColumn>();
	21
	22	SqlConnection conn = null;
	23	SqlCommand cmd = null;
	24	SqlDataReader reader = null;
	25	try
	26	{
	27	conn = new SqlConnection(_connectionString);
	28	conn.Open();
	29	cmd = new SqlCommand(query, conn);
	30	reader = cmd.ExecuteReader();
	31	if (reader != null)
	32	{
	33	while (reader.Read())
	34	{
	35	NavigationSubColumn navigationSubColumn = new NavigationSubColumn(reader.GetInt32(0), reader.GetString(1));
	36	navigationSubColumns.Add(navigationSubColumn);
	37	}
	38	}
	39	}
	40	finally
	41	{
	42	if (reader != null)
	43	{
	44	reader.Close();
	45	reader.Dispose();
	46	}
	47	if (cmd != null) cmd.Dispose();
	48	if (conn != null)
	49	{
	50	conn.Close();
	51	conn.Dispose();
	52	}
	53
	54	}
	55	return navigationSubColumns;
	56	}
	57
16	58	public List<NavigationSubColumn> FindAllActiveByNavigationColumn(NavigationColumn navigationColumn)
17	59	{
18		string query = "SELECT Id, Name FROM Rozdzial WHERE ~~Active=1 AND DzialId={0}~~";
	60	string query = "SELECT Id, Name FROM Rozdzial WHERE Active=1 AND DzialId={0} ORDER BY SortOrder";
19	61	query = string.Format(query, navigationColumn.Id);
20	62

r778	r779
19	19
20	20	private readonly List<Title> _titles = new List<Title>();
	21	public readonly List<NavigationColumn> _dzialy = new List<NavigationColumn>();
	22	public readonly List<NavigationSubColumn> _rozdzialy = new List<NavigationSubColumn>();
21	23	//numery reklam dla nowych zamówieñ
22	24	readonly StringDictionary numeryReklam = new StringDictionary();
…	…
130	132	TitleRepository titleRepository = new TitleRepository(ConnString.getConnString().Value);
131	133	_titles = titleRepository.FindAllActive();
	134
	135	NavigationColumnRepository navigationColumnRepository = new NavigationColumnRepository(ConnString.getConnString().Value);
	136	_dzialy = navigationColumnRepository.FindAll();
	137
	138	NavigationSubColumnRepository navigationSubColumnRepository = new NavigationSubColumnRepository(ConnString.getConnString().Value);
	139	_rozdzialy = navigationSubColumnRepository.FindAll();
132	140
133	141	AdLocationRepository adPlacementRepository = new AdLocationRepository(ConnString.getConnString().Value);