using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Generic;

public partial class DesignFix_Main : System.Web.UI.Page
{
	private int DesignFix_CountPerPage;
    private int PagePrevNext_PageCount;

	// ========================================================================
	protected void Page_Load( object sender, EventArgs e )
	{
		LoadSettings();

		LoadDesignFixes();
	}

	// ========================================================================
	private void LoadSettings()
	{
		AVSIDB.Managers.SettingManager SettingManager = FCache.GetSettingsCache( Page.Cache );

        if ( SettingManager.ContainsSettingName( "DesignFix_CountPerPage" ) )
            DesignFix_CountPerPage = Convert.ToInt32( SettingManager.GetSettingName( "DesignFix_CountPerPage" ).Data.SettingValue );
		else
			DesignFix_CountPerPage = 10;

        
        if ( SettingManager.ContainsSettingName( "PagePrevNext_PageCount" ) )
            PagePrevNext_PageCount = Convert.ToInt32( SettingManager.GetSettingName( "PagePrevNext_PageCount" ).Data.SettingValue );
        else
            PagePrevNext_PageCount = 4;

	}

	// ========================================================================
	private void LoadDesignFixes()
	{
		AVSIDB.Enums.DBResults Results;
		AVSIDB.Managers.DesignFixManager DesignFixManager = new AVSIDB.Managers.DesignFixManager();

		try
		{
			int CurrentPage;
			CurrentPage = Convert.ToInt32( Request.QueryString["Page"] );
			if ( CurrentPage <= 0 )
				CurrentPage = 1;



			// Calculate pages
			List<string[]> data = DesignFixManager.ExecuteCommand(
				"COUNT(" + AVSIDB.Tables.DesignFixTable.sDesignFixID + ") ",
				AVSIDB.Tables.DesignFixTable.TableName + " ",
                AVSIDB.Tables.DesignFixTable.sLiveDate + "<='" + DateTime.Now.ToString( "yyyy-MM-dd HH:mm:ss" ) + "'",
				"",
				"",
				"" );

			int PageCount;
			if ( data != null )
			{
                if ( data.Count > 0 )
                {
                    int cnt = Convert.ToInt32( data[0][0] );
                    PageCount = cnt / DesignFix_CountPerPage;

                    if ( cnt % DesignFix_CountPerPage != 0 )
                        PageCount++;


                    // create the list of pages
                    string pages = "";
                    string pagenumber;
                    for ( int i = 1; i <= PageCount; i++ )
                    {
                        if ( i < 10 )
                            pagenumber = "0" + i.ToString( );
                        else
                            pagenumber = i.ToString( );

                        if ( i == CurrentPage )
                            pages += " &nbsp; <B>" + pagenumber + "</B>";
                        else
                            pages += " &nbsp; <a href=\"/designfix/" + pagenumber + "\"><U>" + pagenumber + "</U></a>";
                    }


                    string strPrevNext = "";
                    if ( PageCount >= PagePrevNext_PageCount )
                    {
                        if ( CurrentPage == 1 )
                        {
                            strPrevNext = "<span style=\"color:#AAAAAA;\">Prev</span>";
                        }
                        else
                        {
                            int prevPageNumber = CurrentPage - 1;
                            if ( prevPageNumber < 10 )
                                strPrevNext = "<a href=\"/designfix/0" + prevPageNumber + "\"><U>Prev</U></a>";
                            else
                                strPrevNext = "<a href=\"/designfix/" + prevPageNumber + "\"><U>Prev</U></a>";
                        }

                        strPrevNext += "&nbsp;&nbsp;";

                        if ( CurrentPage == PageCount )
                        {
                            strPrevNext += "<span style=\"color:#AAAAAA;\">Next</span>";
                        }
                        else
                        {
                            int nextPageNumber = CurrentPage + 1;
                            if ( nextPageNumber < 10 )
                                strPrevNext += "<a href=\"/designfix/0" + nextPageNumber + "\"><U>Next</U></a>";
                            else
                                strPrevNext += "<a href=\"/designfix/" + nextPageNumber + "\"><U>Next</U></a>";
                        }
                    }


					if ( ( pages.Length > 8 ) && ( PageCount > 1 ) )
					{
						pages = pages.Substring( 8 );

                        litTopPageNumbers.Text =
                            "<TABLE WIDTH=\"566\" CELLPADDING=\"7\" CELLSPACING=\"0\" BORDER=\"0\">" +
                            "<TR>" +
                            "<TD WIDTH=\"40\" VALIGN=\"TOP\"><SPAN CLASS=\"MF\">PAGE &gt;</SPAN></TD>" +
                            "<TD VALIGN=\"TOP\"><SPAN CLASS=\"MF\">" + pages + "</TD>" +
                            "<TD WIDTH=\"40\" VALIGN=\"TOP\"><SPAN CLASS=\"MF\">" + strPrevNext + "</SPAN></TD></TR>" +
                            "</TABLE>";


                        litBottomPageNumbers.Text = litTopPageNumbers.Text;

                        //litBottomPageNumbers.Text =
                        //    "<TABLE WIDTH=\"610\" CELLPADDING=\"7\" CELLSPACING=\"0\" BORDER=\"0\" align=center>" +
                        //    "<TR>" +
                        //    "<TD VALIGN=\"TOP\"><SPAN CLASS=\"MF\">" + pages + "</TD>" +
                        //    "<TD WIDTH=\"40\" VALIGN=\"TOP\"><SPAN CLASS=\"MF\">" + strPrevNext + "</SPAN></TD>" +
                        //    "</TR></TABLE>";
					}

				}
			}


			DesignFixManager.UseFields.DesignFixIDField = true;
			DesignFixManager.UseFields.EnteredDateField = true;
			DesignFixManager.UseFields.LiveDateField = true;
			DesignFixManager.UseFields.TitleField = true;
			DesignFixManager.UseFields.DescriptionField = true;
			DesignFixManager.UseFields.ContentField = true;
            DesignFixManager.UseFields.ContentMoreField = true;
			DesignFixManager.UseFields.PostedByField = true;
            DesignFixManager.WhereClause = AVSIDB.Tables.DesignFixTable.sLiveDate + "<=?";
            DesignFixManager.WhereValues = new object[] { DateTime.Now };            
			DesignFixManager.OrderByClause = AVSIDB.Tables.DesignFixTable.sLiveDate + " DESC, " + AVSIDB.Tables.DesignFixTable.sDesignFixID + " DESC";
			DesignFixManager.LimitClause = ( CurrentPage - 1 ) * DesignFix_CountPerPage + "," + DesignFix_CountPerPage;

			Results = DesignFixManager.Fill();

			if ( Results == AVSIDB.Enums.DBResults.Passed )
			{
                string OriginalHTMLCode = ( ( System.Web.UI.LiteralControl )phHtml.Controls[0] ).Text;

				System.Text.StringBuilder c1 = new System.Text.StringBuilder();

				int i;
                string liveDateClass;
                string htmlCode;
                string moreText;
                string linkUrl;
				for ( i = 0; i < DesignFixManager.Count; i++ )
				{
                    if ( DesignFixManager[i].Data.LiveDate > DateTime.Now )
                    {
                        liveDateClass = "MR";
                    }
                    else
                    {
                        liveDateClass = "MF";
                    }

                    linkUrl = "/designfix/" + HelperFunctions.HF.CleanName( DesignFixManager[i].Data.Title );
                    
                    if ( DesignFixManager[i].Data.ContentMore.Length > 0 )
                    {
                        moreText = "<P><A HREF=\"" + linkUrl + "\" CLASS=\"L\">Read More &gt;</A>";
                    }
                    else
                    {
                        moreText = "";
                    }

          


                    htmlCode = OriginalHTMLCode
                        .Replace( "###ID###", DesignFixManager[i].Data.DesignFixID.ToString() )
                        .Replace( "###LINK###", linkUrl )
                        .Replace( "###TITLE###", DesignFixManager[i].Data.Title )
                        .Replace( "###LIVEDATE###", DesignFixManager[i].Data.LiveDate.ToString("MMM dd yyyy") )
                        .Replace( "###LIVEDATE2###", DesignFixManager[i].Data.LiveDate.ToString( "MM/dd/yy" ) )
                        .Replace( "###LIVEDATECLASS###", liveDateClass )                        
                        .Replace( "###POSTEDBY###", DesignFixManager[i].Data.PostedBy )
                        .Replace( "###DESCRIPTION###", DesignFixManager[i].Data.Content )
                        .Replace( "###MORE###", moreText );

                   
                    c1.Append( htmlCode );

				}

				if ( c1.Length > 0 )
				{
					litDesignFixesColumn1.Text = c1.ToString();
				}
			}
			else
			{
			//	Response.Write( "Failure " + Results.ToString() );
			}

		}
		catch ( Exception ex )
		{
			//Response.Write( ex.Message );
		}
	}
}