/*

* Copyright (c) 2010 Nokia Corporation and/or its subsidiary(-ies).

* All rights reserved.

*

* Redistribution and use in source and binary forms, with or without

* modification, are permitted provided that the following conditions are met:

*

* - Redistributions of source code must retain the above copyright notice,

*   this list of conditions and the following disclaimer.

* - Redistributions in binary form must reproduce the above copyright notice,

*   this list of conditions and the following disclaimer in the documentation

*   and/or other materials provided with the distribution.

* - Neither the name of Nokia Corporation nor the names of its contributors

*   may be used to endorse or promote products derived from this software

*   without specific prior written permission.

*

* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"

* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE

* IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE

* ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE

* LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR

* CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF

* SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS

* INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN

* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)

* ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE

* POSSIBILITY OF SUCH DAMAGE.

* 

* Initial Contributors:

* Nokia Corporation - initial contribution.

*

* Contributors:

*

* Description: 

*

*/

using System;

using System.Runtime.InteropServices;

using Microsoft.Office.Interop.Excel;

using SymbianExcelUtils;

namespace HeapComparisonLib.CSV.Comparers

{

    internal class Fragmentation : ComparerBase

	{

		#region Constructors & destructor

		public Fragmentation( Worksheet aSheet, string aFileName1, string aFileName2 )

		:	base( aSheet, aFileName1, aFileName2 )

		{

		}

		#endregion

		#region API

		public override string DeltaFormula( int aIndex )

		{

			int column = 4;

			return Utils.MakeSummationFormula( 3, Row - 2, column, Sheet );

		}

		public override void PrepareWorksheetReadyForData()

		{

			Sheet.Name = "Fragmentation";

			//

			Range r = null;

			//

			Utils.SetValue( Row, 1, Sheet, "Thread" );

			r = Utils.SetValue( Row, 2, Sheet, "Fragmentation" );

			r.AddComment( FileName1 );

			r = Utils.SetValue( Row, 3, Sheet, "Fragmentation" );

			r.AddComment( FileName2 );

			Utils.SetValue( Row, 4, Sheet, "Delta" );

			//

			Utils.MakeBoxedTitleRow( Row, 4, Sheet, 0xFF0000 );

			//

			NextRow();

			NextRow();

		}

		public override void FinaliseWorksheet()

		{

			// Make totals

			NextRow();

			Utils.SetValue( Row, 1, Sheet, "Totals:" );

			Utils.SetValue( Row, 2, Sheet, "=SUM(" + Utils.ColumnAndRowAsExcelIdentifier( 3, 2) + ":" + Utils.ColumnAndRowAsExcelIdentifier( Row - 2, 2) + ")" );

			Utils.SetValue( Row, 3, Sheet, "=SUM(" + Utils.ColumnAndRowAsExcelIdentifier( 3, 3) + ":" + Utils.ColumnAndRowAsExcelIdentifier( Row - 2, 3) + ")" );

			Utils.SetValue( Row, 4, Sheet, DeltaFormula( 0 ) );

			Utils.BoldRow( Row, Sheet );

			// Format cells as percentages

			Range r = Utils.GetRangeByColumnAndRow( 3, 2, Row, 4, Sheet );

			r.NumberFormat = "0.00%";

			// Calculate column sizes

			Utils.AutoFitColumn( 1, Sheet, 70.0 );

			Utils.AutoFitColumn( 2, Sheet );

			Utils.AutoFitColumn( 3, Sheet );

			Utils.AutoFitColumn( 4, Sheet );

		}

        public override void Compare( CSVThread aMaster, CSVThread aOther )

		{

            Utils.SetValue( Row, 1, Sheet, aMaster.FullName );

			//

			float frag1Value = (float) aMaster.FreeSpaceTotal / (float) aMaster.SizeCurrent;

			string frag1 = "=" + aMaster.FreeSpaceTotal.ToString() + " / " + aMaster.SizeCurrent.ToString();

			if	( aMaster.SizeCurrent == 0 )

			{

				frag1Value = 0.0F;

				frag1 = "=0";

			}

			if	( !aMaster.IsDefault )

				Utils.SetValue( Row, 2, Sheet, frag1 );

			//

			float frag2Value = (float) aOther.FreeSpaceTotal / (float) aOther.SizeCurrent;

			string frag2 = "=" + aOther.FreeSpaceTotal.ToString() + " / " + aOther.SizeCurrent.ToString();

			if	( aOther.SizeCurrent == 0 )

			{

				frag2Value = 0.0F;

				frag2 = "=0";

			}

			if	( !aOther.IsDefault )

				Utils.SetValue( Row, 3, Sheet, frag2 );

			if	( aMaster.IsDefault || aOther.IsDefault )

			{

				Utils.GetRangeByColumnAndRow( Row, 1, Row, 1, Sheet ).Font.Bold = true;

			}

			// Delta

			float delta = frag1Value - frag2Value;

			Utils.SetValue( Row, 4, Sheet, ( delta * -1.0).ToString() );

			// Colourise line according to difference

			int colour = 0x000000; // black

			if	( frag2Value > frag1Value )

			{

				// Original size was smaller than new size => heap has grown

				colour = 0x0000FF; // red

			}

			else if ( frag2Value < frag1Value )

			{

				// Original size was bigger than new size => heap has shrunk

				colour = 0xFF0000; // blue

			}

			Utils.SetRangeFontColour( Row, 4, Row, 4, Sheet, colour );

			//

			NextRow();

		}

		#endregion

	}

}