using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Globalization;

namespace AeroNet
{
	/// <summary>
	/// Summary description for news.
	/// </summary>
	/// 
	public class NewsList : Common
	{
		protected int t;
		protected int M;
		protected int y;
		protected string txtM;
		protected string txtDate;
		protected string d = "";
		protected string title;
		protected string NewsTitle;
		
		protected void PrintNewsTitle()
		{
				// Соединение с SQL-сервером
				SqlConnection connNews = new SqlConnection(connString);
				//Создать команду
				SqlCommand cmdNewsTitle = new SqlCommand(("SELECT ID, [Date], Type, Title, M, y FROM V_NewsTitle WHERE Type="+t.ToString()+"AND M="+M.ToString()+"AND y="+y.ToString()+" ORDER BY [Date] DESC, ID DESC"), connNews);
				//Открыть соединение
				connNews.Open();
				//Создать DataReader и считать данные
				SqlDataReader drNewsTitle;
				drNewsTitle = cmdNewsTitle.ExecuteReader();
			
			if (drNewsTitle.Read())
			{
				CultureInfo ci = new CultureInfo("ru-RU");
				d = ((DateTime)drNewsTitle["Date"]).ToString("dd.MM.yyyy",ci);
				Response.Write ("<br><div align='right'><H6>"+d+"</H6></div>");
				NewsTitle = (drNewsTitle["Title"]).ToString();
				Response.Write ("<h5><img src='../images/ball.gif' width='11' height='11'><a class='type' href='../News.aspx?id="+(drNewsTitle["ID"]).ToString()+"'>&nbsp;&nbsp;&nbsp;&nbsp"+NewsTitle+"</h5></a>");
				
				while (drNewsTitle.Read())
				{
					txtDate = ((DateTime)drNewsTitle["Date"]).ToString("dd.MM.yyyy",ci);

					if (txtDate == d)
					{
						NewsTitle = (drNewsTitle["Title"]).ToString();
						Response.Write ("<h5><img src='../images/ball.gif' width='11' height='11'><a class='type' href='../news.aspx?id="+(drNewsTitle["ID"]).ToString()+"'>&nbsp;&nbsp;&nbsp;&nbsp"+NewsTitle+"</h5></a>");
					}
					else	
					{
						d = txtDate;
						Response.Write ("<br><div align='right'><H6>"+d+"</H6></div>");
						NewsTitle = (drNewsTitle["Title"]).ToString();
						Response.Write ("<h5><img src='../images/ball.gif' width='11' height='11'><a class='type' href='../news.aspx?id="+(drNewsTitle["ID"]).ToString()+"'>&nbsp;&nbsp;&nbsp;&nbsp"+NewsTitle+"</a></h5>");
					}
				
				}
				
			}
			else
			{
				Response.Write ("<p><b><font color='red'>Пишут ...</font></b></p>");
			}

			//Закрываем DataReader и соединение
			drNewsTitle.Close();
			connNews.Close();
			
		}
		

		private void Page_Load(object sender, System.EventArgs e)
		{
			//Загрузить верхнее меню
			TopMenu();

			//Получить t, y и M из строки запроса
			  
			if (Request.QueryString["t"] == null)
			{
				t = 1;
			}
			else
			{
				t = Convert.ToInt32(Request.QueryString["t"]);
			}
			
			if (Request.QueryString["M"] == null)
				{
				M = Convert.ToInt32(today.Month);
				}
			else
				{
				M = Convert.ToInt32(Request.QueryString["M"]);
				}
			
			if (Request.QueryString["y"] == null)
			{
				y = Convert.ToInt32(today.Year);
			}
			else
			{
				y = Convert.ToInt32(Request.QueryString["y"]);
			}

			//Название месяца в txtM
			switch(M)
			{
				case 1:
				txtM = "Январь";
				break;
				case 2:
				txtM = "Февраль";
				break;
				case 3:
				txtM = "Март";
				break;
				case 4:
				txtM = "Апрель";
				break;
				case 5:
				txtM = "Май";
				break;
				case 6:
				txtM = "Июнь";
				break;
				case 7:
				txtM = "Июль";
				break;
				case 8:
				txtM = "Август";
				break;
				case 9:
				txtM = "Сентябрь";
				break;
				case 10:
				txtM = "Октябрь";
				break;
				case 11:
				txtM = "Ноябрь";
				break;
				case 12:
				txtM = "Декабрь";
				break;
				default:
				txtM = "Январь";
				break;
			}

			//Установка заголовка
			switch(t)
			{
				case 1:
					title = "Н&nbsp;о&nbsp;в&nbsp;о&nbsp;с&nbsp;т&nbsp;и:&nbsp;&nbsp;&nbsp;&nbsp;Г&nbsp;р&nbsp;а&nbsp;ж&nbsp;д&nbsp;а&nbsp;н&nbsp;с&nbsp;к&nbsp;а&nbsp;я&nbsp;&nbsp;&nbsp;а&nbsp;в&nbsp;и&nbsp;а&nbsp;ц&nbsp;и&nbsp;я";
					break;
				case 2:
					title = "Н&nbsp;о&nbsp;в&nbsp;о&nbsp;с&nbsp;т&nbsp;и:&nbsp;&nbsp;&nbsp;&nbsp;В&nbsp;о&nbsp;е&nbsp;н&nbsp;н&nbsp;а&nbsp;я&nbsp;&nbsp;&nbsp;а&nbsp;в&nbsp;и&nbsp;а&nbsp;ц&nbsp;и&nbsp;я";
					break;
				case 3:
					title = "Н&nbsp;о&nbsp;в&nbsp;о&nbsp;с&nbsp;т&nbsp;и:&nbsp;&nbsp;&nbsp;&nbsp;А&nbsp;в&nbsp;и&nbsp;а&nbsp;к&nbsp;о&nbsp;с&nbsp;м&nbsp;и&nbsp;ч&nbsp;е&nbsp;с&nbsp;к&nbsp;а&nbsp;я&nbsp;&nbsp;&nbsp;п&nbsp;р&nbsp;о&nbsp;м&nbsp;ы&nbsp;ш&nbsp;л&nbsp;е&nbsp;н&nbsp;н&nbsp;о&nbsp;с&nbsp;т&nbsp;ь";
					break;
				case 4:
					title = "Н&nbsp;о&nbsp;в&nbsp;о&nbsp;с&nbsp;т&nbsp;и:&nbsp;&nbsp;&nbsp;&nbsp;К&nbsp;о&nbsp;с&nbsp;м&nbsp;о&nbsp;с";
					break;
				case 5:
					title = "Н&nbsp;о&nbsp;в&nbsp;о&nbsp;с&nbsp;т&nbsp;и:&nbsp;&nbsp;&nbsp;&nbsp;К&nbsp;а&nbsp;т&nbsp;а&nbsp;с&nbsp;т&nbsp;р&nbsp;о&nbsp;ф&nbsp;ы&nbsp;&nbsp;&nbsp;и&nbsp;&nbsp;&nbsp;п&nbsp;р&nbsp;о&nbsp;и&nbsp;с&nbsp;ш&nbsp;е&nbsp;с&nbsp;т&nbsp;в&nbsp;и&nbsp;я";
					break;
				default:
					title = "Н&nbsp;о&nbsp;в&nbsp;о&nbsp;с&nbsp;т&nbsp;и";
					break;
			}


		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion


	}
}