GIF89;a
GIF89;a
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 BusinessLayer.Controllers;
using BusinessLayer.BOObjects;
using BusinessLayer.Entities;
using AjaxControlToolkit;


public partial class Keren : BasePage
{
    string m_kerenName = string.Empty;
    protected void Page_Load(object sender, EventArgs e)
    {
        int ID = 0;

        this.CurrentPage = Globals.CurrentPageId.Keren;

        if ( this.Request.QueryString[ "ID" ] != null ) {
            ID = int.Parse( this.Request.QueryString[ "ID" ].ToString() );
        }

        LabelUpdText.Text = GetGlobalResourceObject("Common", "Updatedate").ToString();
        LabelUpdDate.Text = PageUpdatedDate;

        int EmptyRowstTabl = 0;
        //int EmptyRowsttTablNOFEE = 0;
        ControllerKeren CtrlKeren = new ControllerKeren();
        BusinessLayer.Entities.KerenNeemanut KerenNeem = CtrlKeren.GetKeren(ID);
        if (KerenNeem.Id > 0)
        {
            m_kerenName = KerenNeem.Name;
            //table#1
            Label lab = new Label();
            HyperLink hrlMAnager = new HyperLink(); 
            lab.Text = KerenNeem.Name;
            tdCompanyName.Controls.Add(lab);
            lab = new Label();
            lab.Text = KerenNeem.Id.ToString();
            tdNumber.Controls.Add(lab);
            lab = new Label();
            hrlMAnager.Text = KerenNeem.Manager;
            Page.Session.Add("ToManager_ManagerName", KerenNeem.Manager);
            hrlMAnager.NavigateUrl = "~/Manager.aspx";
            tdManager.Controls.Add(hrlMAnager);

            //table#2
            lab = new Label();
            if (KerenNeem.INBEST_AVG < 0)
                lab.Text = (-1 * KerenNeem.INBEST_AVG).ToString("0") + "-";
            else
                lab.Text = KerenNeem.INBEST_AVG.ToString("0");
            lab.Font.Bold = true;
            lab.ForeColor = InbestColor(lab.Text);
            tdInBestAvarage.Controls.Add(lab);
            lab = new Label();
            lab.Text = KerenNeem.Specialization.ToString();
            tdSpecialization.Controls.Add(lab);
            
            ControllerArticle CtrlArticle = new ControllerArticle();
            BusinessLayer.Entities.Article article = new Article();
            article = CtrlArticle.Get((int)Globals.AJAXHelp.Keren_Commisions);
            HelpButtonAjax1.Text = "<div style='text-align:center;'>" + article.Title
                + "</div><br />" + article.ShortText;

            article = new Article();
            article = CtrlArticle.Get((int)Globals.AJAXHelp.Keren_Fee);
            HelpButtonAjax3.Text = "<div style='text-align:center;'>" + article.Title
                + "</div><br />" + article.ShortText;


            lab = new Label();
            lab.Text = KerenNeem.Fee.ToString("0.00") + "%";
            tdFee.Controls.Add(lab);
            lab = new Label();
            lab.Text = KerenNeem.Commision.ToString("0.00") + "%";
            tdCommisions.Controls.Add(lab);

            lab = new Label();
            if (KerenNeem.JustifiedFee > 0)
            {
                lab.Text = KerenNeem.JustifiedFee.ToString("0.00") + "%"; 
            }
            else
            {
                if (KerenNeem.JustifiedFee == -999) // SHARP < 0
                    lab.Text = "<b>-</b>";
                else
                    lab.Text = "0.00%";
            }
            tdJustifiedFee.Controls.Add(lab);
            article = new Article();
            article = CtrlArticle.Get((int)Globals.AJAXHelp.Keren_JustifiedFee);
            HelpButtonAjax12.Text = "<div style='text-align:center;'>" + article.Title
                + "</div><br />" + article.ShortText;

            //table#3
            if (KerenNeem.Madadim.Count > 0)
            {
                GridView1.DataSource = KerenNeem.Madadim;
                GridView1.DataBind();
                article = CtrlArticle.Get((int)Globals.AJAXHelp.Keren_Madad);
                HelpButtonAjax13.Text = "<div style='text-align:center;'>" + article.Title
                    + "</div><br />" + article.ShortText;
            }
            // Table #4,#5
            int RowtTabl = 0;

            Table tabl1 = new Table();
            TableRow trTable1 = new TableRow();
            TableCell tdTable1 = new TableCell();
            tabl1.Attributes.Add("width", "520px");
            tabl1.CssClass = "ViewTable";
            tabl1.Attributes.Add("style" , "border-collapse:collapse;  font-weight:bold;");


            Table tabl2 = new Table();
            tabl2.Attributes.Add("width", "520px");
            tabl2.CssClass = "ViewTable";
            tabl2.Attributes.Add("style", "border-collapse:collapse;  font-weight:bold;");


            //title Table1
            lab = new Label();
            
            lab.Text = (string)this.GetLocalResourceObject("COL_TEXT8");
            lab.CssClass = "TableTitle";

            tdTable1.CssClass = "TableTitl_r";
            tdTable1.Controls.Add(TitleTableAjax(HelpButtonAjax5, lab, ((int)Globals.AJAXHelp.Keren_Table1_col4)));
            trTable1.Controls.Add(tdTable1);
            tabl1.Controls.Add(trTable1);

            lab = new Label();
            lab.CssClass = "TableTitle";

            tdTable1 = new TableCell();
            lab.Text = (string)this.GetLocalResourceObject("COL_TEXT9"); 
            
            tdTable1.CssClass = "TableTitl";

            tdTable1.Controls.Add(TitleTableAjax(HelpButtonAjax6, lab, ((int)Globals.AJAXHelp.Keren_Table1_col3)));
            trTable1.Controls.Add(tdTable1);
            tabl1.Controls.Add(trTable1);

            lab = new Label();
            lab.Text = (string)this.GetLocalResourceObject("COL_TEXT10");
            lab.CssClass = "TableTitle";

            tdTable1 = new TableCell();
            tdTable1.CssClass = "TableTitl";
            tdTable1.Controls.Add(TitleTableAjax(HelpButtonAjax7, lab, ((int)Globals.AJAXHelp.Keren_Table1_col2)));
            trTable1.Controls.Add(tdTable1);
            tabl1.Controls.Add(trTable1);

            lab = new Label();
            lab.Text = (string)this.GetLocalResourceObject("COL_TEXT11");
            lab.CssClass = "TableTitle";

            tdTable1 = new TableCell();
            tdTable1.CssClass = "TableTitl_l";
            tdTable1.Controls.Add(TitleTableAjax(HelpButtonAjax8, lab, ((int)Globals.AJAXHelp.Keren_Table1_col1)));
            trTable1.Controls.Add(tdTable1);
            tabl1.Controls.Add(trTable1);


            //title Table2
            trTable1 = new TableRow();

            lab = new Label();
            lab.Text = (string)this.GetLocalResourceObject("COL_TEXT12");
            lab.CssClass = "TableTitle";

            tdTable1 = new TableCell();
            tdTable1.CssClass = "TableTitl_r";
            tdTable1.Controls.Add(TitleTableAjax(HelpButtonAjax9, lab, ((int)Globals.AJAXHelp.Keren_Table2_col3)));
            trTable1.Controls.Add(tdTable1);
            tabl2.Controls.Add(trTable1);

            lab = new Label();
            lab.Text = (string)this.GetLocalResourceObject("COL_TEXT13");
            lab.CssClass = "TableTitle";
            tdTable1 = new TableCell();
            tdTable1.CssClass = "TableTitl";
            tdTable1.Controls.Add(TitleTableAjax(HelpButtonAjax10, lab, ((int)Globals.AJAXHelp.Keren_Table2_col2)));
            trTable1.Controls.Add(tdTable1);
            tabl2.Controls.Add(trTable1);

            lab = new Label();
            lab.Text = (string)this.GetLocalResourceObject("COL_TEXT15");
            lab.CssClass = "TableTitle";

            tdTable1 = new TableCell();
            tdTable1.CssClass = "TableTitl_l";
            tdTable1.Controls.Add(TitleTableAjax(HelpButtonAjax11, lab, ((int)Globals.AJAXHelp.Keren_Table2_col1)));
            trTable1.Controls.Add(tdTable1);
            tabl2.Controls.Add(trTable1);

            decimal ResInbestNofee = 0;
            decimal ResAvarage = 0;
            decimal ResAVG = 0;
            int ResAVGCount = 0;
            int ResInbestNofeeCount = 0;
            int ResAvarageCount = 0;
            //table#1 row1
            trTable1 = new TableRow();
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column2R";
            lab = new Label();
            lab.Text = (string)this.GetLocalResourceObject("TEXT_YEAR3");
            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column1number";
            lab = new Label();
            if (KerenNeem.INBEST_36 != 0)
            {
                EmptyRowstTabl++;
                RowtTabl++;
                lab.Text = KerenNeem.INBEST_36.ToString("0");
                lab.Font.Bold = true;
                lab.ForeColor = InbestColor(lab.Text);
                ResInbestNofee+=KerenNeem.INBEST_36;
                ResInbestNofeeCount++;
            }
            else
            {
                lab.Text = "<b>-</b>";
            }
            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column2number";
            lab = new Label();

            EmptyRowstTabl++;
            RowtTabl++;
            if (KerenNeem.AVG36 != 0)
            {
                ResAvarage += KerenNeem.AVG36;
                ResAvarageCount++;
                lab.Text = KerenNeem.AVG36.ToString("0.0") + "%";
            }
            else
            {
                lab.Text = "<b>-</b>";
            }

            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column1number";
            lab = new Label();

            EmptyRowstTabl++;
            RowtTabl++;
            if (KerenNeem.AVG36_M != 0)
            {
                ResAVG += KerenNeem.AVG36_M;
                ResAVGCount++;
                lab.Text = KerenNeem.AVG36_M.ToString("0.0") + "%";
            }
            else
            {
                lab.Text = "<b>-</b>";
            }
            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            if(RowtTabl>0)
                tabl1.Controls.Add(trTable1);


            //table#1 row2
            trTable1 = new TableRow();
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column2R";
            lab = new Label();
            lab.Text = (string)this.GetLocalResourceObject("TEXT_YEAR2"); 
            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column1number";
            lab = new Label();
            if (KerenNeem.INBEST_24 != 0)
            {
                EmptyRowstTabl++;
                RowtTabl++;
                lab.Text = KerenNeem.INBEST_24.ToString("0");
                lab.Font.Bold = true;
                lab.ForeColor = InbestColor(lab.Text);
                ResInbestNofee += KerenNeem.INBEST_24;
                ResInbestNofeeCount++;
            }
            else
            {
                lab.Text = "<b>-</b>";
            }
            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column2number";
            lab = new Label();

            EmptyRowstTabl++;
            RowtTabl++;
            if (KerenNeem.AVG24 != 0)
            {
                ResAvarage += KerenNeem.AVG24;
                ResAvarageCount++;
                lab.Text = KerenNeem.AVG24.ToString("0.0") + "%";
            }
            else
            {
                lab.Text = "<b>-</b>";
            }

            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column1number";
            lab = new Label();

            EmptyRowstTabl++;
            RowtTabl++;
            if (KerenNeem.AVG24_M != 0)
            {
                lab.Text = KerenNeem.AVG24_M.ToString("0.0") + "%";
                ResAVG += KerenNeem.AVG24_M;
                ResAVGCount++;
            }
            else
            {
                lab.Text = "<b>-</b>";
            }
            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            if (RowtTabl > 0)
                tabl1.Controls.Add(trTable1);



            //table#1 row3
            trTable1 = new TableRow();
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column2R";
            lab = new Label();
            lab.Text = (string)this.GetLocalResourceObject("TEXT_YEAR1"); 
            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column1number";
            lab = new Label();
            if (KerenNeem.INBEST_12 != 0)
            {
                EmptyRowstTabl++;
                RowtTabl++;
                lab.Text = KerenNeem.INBEST_12.ToString("0");
                lab.Font.Bold = true;
                lab.ForeColor = InbestColor(lab.Text);
                ResInbestNofee += KerenNeem.INBEST_12;
                ResInbestNofeeCount++;
            }
            else
            {
                lab.Text = "<b>-</b>";
            }
            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column2number";
            lab = new Label();

            EmptyRowstTabl++;
            RowtTabl++;
            if (KerenNeem.AVG12 != 0)
            {
                ResAvarage += KerenNeem.AVG12;
                ResAvarageCount++;
                lab.Text = KerenNeem.AVG12.ToString("0.0") + "%";
            }
            else
            {
                lab.Text = "<b>-</b>";
            }

            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column1number";
            lab = new Label();

            EmptyRowstTabl++;
            RowtTabl++;
            if (KerenNeem.AVG12_M != 0)
            {
                lab.Text = KerenNeem.AVG12_M.ToString("0.0") + "%";
                ResAVG += KerenNeem.AVG12_M;
                ResAVGCount++;
            }
            else
            {
                lab.Text = "<b>-</b>";
            }

            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            if (RowtTabl > 0)
                tabl1.Controls.Add(trTable1);


            #region table#1 row4 (Commented AVR6)
            /*
            trTable1 = new TableRow();
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column2R";
            lab = new Label();
            lab.Text = (string)this.GetLocalResourceObject("TEXT_YEAR05"); 
            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column1number";
            lab = new Label();
            if (KerenNeem.INBEST_6 != 0)
            {
                EmptyRowstTabl++;
                RowtTabl++;
                lab.Text = KerenNeem.INBEST_6.ToString("0.00");
                ResInbestNofee += KerenNeem.INBEST_6;
                ResInbestNofeeCount++;
            }
            else
            {
                lab.Text = "<b>-</b>";
            }
            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column2number";
            lab = new Label();

            EmptyRowstTabl++;
            RowtTabl++;
            lab.Text = KerenNeem.AVG6.ToString("0.00") + "%";
            ResAvarage += KerenNeem.AVG6;
            ResAvarageCount++;

            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column1number";
            lab = new Label();

            EmptyRowstTabl++;
            RowtTabl++;
            lab.Text = KerenNeem.AVG6_M.ToString("0.00") + "%";
            ResAVG += KerenNeem.AVG6_M;
            ResAVGCount++;

            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            if (RowtTabl > 0)
                tabl1.Controls.Add(trTable1);
            */
            #endregion

            if (EmptyRowstTabl > 0)
            {
                divTable1.Controls.Add(tabl1);
            }
            
            /*
             decimal ResInbestNofee = 0;
            decimal ResAvarage = 0;
            decimal ResAVG = 0;
            int ResAVGCount = 0;
            int ResInbestNofeeCount = 0;
            int ResAvarageCount = 0;*/

            lab = new Label();
            if (ResInbestNofeeCount > 0)
            {
                lab.Text = "<b>" + (ResInbestNofee / ResInbestNofeeCount).ToString("0") + "</b>"; ;
                lab.Font.Bold = true;
                lab.ForeColor = InbestColor((ResInbestNofee / ResInbestNofeeCount).ToString("0"));
            }
            else
            {
                lab.Text = "<b>-</b>";
            }
            tdResInbestNofee1.Controls.Add(lab);

            lab = new Label();
            if (ResAvarageCount != 0)
            {
                lab.Text = "<b>" + (ResAvarage / ResAvarageCount).ToString("0.0") + "%</b>"; ;
            }
            else
            {
                lab.Text = "<b>-</b>";
            }
            tdResAvarage1.Controls.Add(lab);


            lab = new Label();
            if (ResAVGCount != 0)
            {
                lab.Text = "<b>" + (ResAVG / ResAVGCount).ToString("0.0") + "%</b>"; ;
            }
            else
            {
                lab.Text = "<b>-</b>";
            }
            tdResAVG1.Controls.Add(lab);


            //table#2 row1
            EmptyRowstTabl = 0;
            RowtTabl = 0;
            ResInbestNofee = 0;
            ResAvarage = 0;
            ResInbestNofeeCount = 0;
            ResAvarageCount = 0;
            trTable1 = new TableRow();
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column2R";
            lab = new Label();
            lab.Text = (string)this.GetLocalResourceObject("TEXT_YEAR3"); 
            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);

            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column1number";
            lab = new Label();
            if (KerenNeem.INBEST_36_NOFEE != 0)
            {
                EmptyRowstTabl++;
                RowtTabl++;
                lab.Text = KerenNeem.INBEST_36_NOFEE.ToString("0");
                lab.Font.Bold = true;
                lab.ForeColor = InbestColor(lab.Text);
                ResInbestNofeeCount++;
                ResInbestNofee += KerenNeem.INBEST_36_NOFEE;
            }
            else
            {
                lab.Text = "<b>-</b>";
            }
            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column2LeftNumber";
            lab = new Label();

            EmptyRowstTabl++;
            RowtTabl++;
            if (KerenNeem.AVG36_NOFEE != 0)
            {
                ResAvarageCount++;
                ResAvarage += KerenNeem.AVG36_NOFEE;
                lab.Text = KerenNeem.AVG36_NOFEE.ToString("0.0") + "%";
            }
            else
            {
                lab.Text = "<b>-</b>";
            }

            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);

            if (RowtTabl > 0)
                tabl2.Controls.Add(trTable1);


            //table#2 row2
            trTable1 = new TableRow();
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column2R";
            lab = new Label();
            lab.Text = (string)this.GetLocalResourceObject("TEXT_YEAR2");
            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column1number";
            lab = new Label();
            //if (KerenNeem.INBEST_24_NOFEE > 0)
            if (KerenNeem.INBEST_24_NOFEE != 0)
            {
                EmptyRowstTabl++;
                RowtTabl++;
                lab.Text = KerenNeem.INBEST_24_NOFEE.ToString("0");
                lab.Font.Bold = true;
                lab.ForeColor = InbestColor(lab.Text);
                ResInbestNofeeCount++;
                ResInbestNofee += KerenNeem.INBEST_24_NOFEE;
            }
            else
            {
                lab.Text = "<b>-</b>";
            }
            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column2LeftNumber";
            lab = new Label();

            EmptyRowstTabl++;
            RowtTabl++;
            if (KerenNeem.AVG24_NOFEE != 0)
            {
                ResAvarageCount++;
                ResAvarage += KerenNeem.AVG24_NOFEE;
                lab.Text = KerenNeem.AVG24_NOFEE.ToString("0.0") + "%";
            }
            else
            {
                lab.Text = "<b>-</b>";
            }

            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            if (RowtTabl > 0)
                tabl2.Controls.Add(trTable1);



            //table#2 row3
            trTable1 = new TableRow();
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column2R";
            lab = new Label();
            lab.Text = (string)this.GetLocalResourceObject("TEXT_YEAR1");
            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column1number";
            lab = new Label();
            if (KerenNeem.INBEST_12_NOFEE != 0)
            {
                EmptyRowstTabl++;
                RowtTabl++;
                lab.Text = KerenNeem.INBEST_12_NOFEE.ToString("0");
                lab.Font.Bold = true;
                lab.ForeColor = InbestColor(lab.Text);
                ResInbestNofeeCount++;
                ResInbestNofee += KerenNeem.INBEST_12_NOFEE;
            }
            else
            {
                lab.Text = "<b>-</b>";
            }
            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column2LeftNumber";
            lab = new Label();

            EmptyRowstTabl++;
            RowtTabl++;
            lab.Text = KerenNeem.AVG12_NOFEE.ToString("0.0") + "%";
            if (KerenNeem.AVG12_NOFEE != 0)
            {
                ResAvarageCount++;
                ResAvarage += KerenNeem.AVG12_NOFEE;
                lab.Text = KerenNeem.AVG12_NOFEE.ToString("0.0") + "%";
            }
            else
            {
                lab.Text = "<b>-</b>";
            }

            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            if (RowtTabl > 0)
                tabl2.Controls.Add(trTable1);


            #region table#2 row4 (Commented)
            /*
            trTable1 = new TableRow();
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column2R";
            lab = new Label();
            lab.Text = (string)this.GetLocalResourceObject("TEXT_YEAR05");
            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column1number";
            lab = new Label();
            if (KerenNeem.INBEST_6_NOFEE != 0)
            {
                EmptyRowstTabl++;
                RowtTabl++;
                lab.Text = KerenNeem.INBEST_6_NOFEE.ToString("0.00");
                ResInbestNofeeCount++;
                ResInbestNofee += KerenNeem.INBEST_6_NOFEE;
            }
            else
            {
                lab.Text = "<b>-</b>";
            }
            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            tdTable1 = new TableCell();
            tdTable1.Attributes.Add("style", "width: 25%; height:40px;");
            tdTable1.CssClass = "Column2LeftNumber";
            lab = new Label();

            EmptyRowstTabl++;
            RowtTabl++;
            lab.Text = KerenNeem.AVG6_NOFEE.ToString("0.00") + "%";
            ResAvarageCount++;
            ResAvarage += KerenNeem.AVG6_NOFEE;

            tdTable1.Controls.Add(lab);
            trTable1.Controls.Add(tdTable1);
            if (RowtTabl > 0)
                tabl2.Controls.Add(trTable1);
            */
            #endregion

            if (EmptyRowstTabl > 0)
            {
                divTable2.Controls.Add(tabl2);


                //result
                /*int ResInbestNofee = 0;
                 int ResAvarage = 0;
                 int ResCompaing = 0;
                 int ResInbestNofeeCount = 0;
                 int ResAvarageCount = 0;
                 int ResCompaingCount = 0;*/
                lab = new Label();
                if (ResInbestNofeeCount > 0)
                {
                    lab.Text = "<b>" + (ResInbestNofee / ResInbestNofeeCount).ToString("0") + "</b>";
                    lab.Font.Bold = true;
                    lab.ForeColor = InbestColor((ResInbestNofee / ResInbestNofeeCount).ToString("0"));
                }
                else
                {
                    lab.Text = "<b>-</b>";
                }
                tdResInbestNofee.Controls.Add(lab);

                lab = new Label();
                if (ResAvarageCount > 0)
                {
                    lab.Text = "<b>" + (ResAvarage / ResAvarageCount).ToString("0.0") + "%</b>";
                }
                else
                {
                    lab.Text = "<b>-</b>";
                }
                tdResAvarage.Controls.Add(lab);

            }
        }
    }
    Table TitleTableAjax(Controls_HelpButtonAjax HelpAjaxBttn, Label lablText,int IdMsg)
    {
        Table Tabl = new Table();
        TableRow TablR = new TableRow();
        TableCell TablC = new TableCell();
        TablC.Controls.Add(lablText);
        TablC.HorizontalAlign = HorizontalAlign.Center; 
        TablR.Controls.Add(TablC);
        Tabl.Controls.Add(TablR);
        TablR = new TableRow();
        TablC = new TableCell();
        TablC.HorizontalAlign = HorizontalAlign.Center;
        Panel pnAjaxBttn = new Panel();
        ControllerArticle CtrlArticle = new ControllerArticle();
        String TitleHelp = CtrlArticle.Get(IdMsg).Title;
        HelpAjaxBttn.Text = "<div style='text-align:center;'>" + TitleHelp
            + "</div><br />" + CtrlArticle.Get(IdMsg).ShortText;
        pnAjaxBttn.Width = 25;
        pnAjaxBttn.Controls.Add(HelpAjaxBttn);
        HelpAjaxBttn.Visible = true;
        TablC.Controls.Add(pnAjaxBttn);
        TablR.Controls.Add(TablC);
        
        Tabl.Controls.Add(TablR);
        
        return Tabl;
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Page.Session.Add("ToLid_MSG", m_kerenName);
        Go("Lid.aspx");
    }

}