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 Globals;
using BusinessLayer.Controllers;

public partial class Manager : BasePage
{
    static string Msg_ManagerName;
        protected void Page_Load(object sender, EventArgs e)
    {
            this.CurrentPage = CurrentPageId.Manager;
            LabelUpdText.Text = GetGlobalResourceObject("Common", "Updatedate").ToString();
            LabelUpdDate.Text = PageUpdatedDate;
        TitleControl2.Visible=false;
        if (Page.Session["ToManager_ManagerName"] != null)
        {
            Msg_ManagerName = Page.Session["ToManager_ManagerName"].ToString();
            Page.Session.Remove("ToManager_ManagerName");
        }
        this.TitleControl1.Text = this.TitleControl1.Text + " " + Msg_ManagerName;
        this.CurrentPage = Globals.CurrentPageId.Manager;
        Panel pan_Description = new Panel();
        pan_Description.Attributes.Add("id", "Description1");
        Label text_Description = new Label();
        text_Description.Text = (string)this.GetLocalResourceObject("Description1");
        pan_Description.Controls.Add(text_Description);
        pnSection1.Controls.Add(pan_Description);
        BusinessLayer.Controllers.ControllerManager controller = new BusinessLayer.Controllers.ControllerManager();
        DataSet ds1 = controller.GetManagerKerens(Msg_ManagerName);
        DataSet ds2 = new DataSet();
        DataTable dt = ds2.Tables.Add();
        Table tbl1 = GetTableOnType(((int)Globals.KerenType.ShareIsrael), ds1, TitleControl2, "1", HelpButtonAjax1, HelpButtonAjax2, HelpButtonAjax3);
        if (tbl1.Rows.Count > 1)
        {
            divSection1.Controls.Add(tbl1);
            tblRes1.Visible = true;
            tdResInbestAVG1.Controls.Add(Resul(1, tbl1, "1labChislINBEST_AVG", ""));
            tdResInbestAVGNoFee1.Controls.Add(Resul(2, tbl1, "1labChislINBEST_AVG_NOFEE", ""));
            tdResFee1.Controls.Add(Resul(3, tbl1, "1labChislJustifiedFee", "%"));
        }
        tbl1 = GetTableOnType(((int)Globals.KerenType.SolitIsrael), ds1, TitleControl3, "2", HelpButtonAjax4, HelpButtonAjax5, HelpButtonAjax6);
        if (tbl1.Rows.Count > 1)
        {
            divSection2.Controls.Add(tbl1);
            tblRes2.Visible = true;
            tdResInbestAVG2.Controls.Add(Resul(1, tbl1, "2labChislINBEST_AVG", ""));
            tdResInbestAVGNoFee2.Controls.Add(Resul(2, tbl1, "2labChislINBEST_AVG_NOFEE", ""));
            tdResFee2.Controls.Add(Resul(3, tbl1, "2labChislJustifiedFee", "%"));
        }
           tbl1 = GetTableOnType(((int)Globals.KerenType.International), ds1, TitleControl4,"3", HelpButtonAjax7, HelpButtonAjax8, HelpButtonAjax9);
           if (tbl1.Rows.Count > 1)
           {
               tblRes3.Visible = true;
               divSection3.Controls.Add(tbl1);
               tdResInbestAVG3.Controls.Add(Resul(1, tbl1, "3labChislINBEST_AVG", ""));
               tdResInbestAVGNoFee3.Controls.Add(Resul(2, tbl1, "3labChislINBEST_AVG_NOFEE", ""));
               tdResFee3.Controls.Add(Resul(3, tbl1, "3labChislJustifiedFee", "%"));
           }
    }
    Table GetTableOnType(int Type, DataSet ds1,TitleControl titlTabl,string prefix,Controls_HelpButtonAjax HlpButtAjx,
        Controls_HelpButtonAjax HlpButtAjx2, Controls_HelpButtonAjax HlpButtAjx3)
    {
        Table tbl = new Table();
        tbl.CssClass = "ViewTable";
        tbl.GridLines = GridLines.None;

        TableRow trowTitl = new TableRow();
        TableCell ttdTitl = new TableCell();
        Label lablTitl = new Label();
        ttdTitl.CssClass = "TableTitl_r";
        ttdTitl.Style.Add("width", "242px");
        lablTitl.Text = "<b>" + this.GetLocalResourceObject("Grid1.COL1").ToString() + "</b>";
        ttdTitl.Controls.Add(lablTitl);
        trowTitl.Controls.Add(ttdTitl);
        ttdTitl = new TableCell();
        lablTitl = new Label();
        ttdTitl.CssClass = "TableTitl";
        ttdTitl.Style.Add("width", "90px");
        lablTitl.Text = "<b>" + this.GetLocalResourceObject("Grid1.COL2").ToString() + "</b>";
        
        ttdTitl.Controls.Add(TitleTableAjax(HlpButtAjx,lablTitl,((int)Globals.AJAXHelp.Manager_Madad)));
        
        
        trowTitl.Controls.Add(ttdTitl);
        ttdTitl = new TableCell();
        lablTitl = new Label();
        ttdTitl.CssClass = "TableTitl";
        ttdTitl.Style.Add("width", "90px");
        lablTitl.Text = "<b>" + this.GetLocalResourceObject("Grid1.COL3").ToString() + "</b>";
        
        

        ttdTitl.Controls.Add(TitleTableAjax(HlpButtAjx2, lablTitl, (int)Globals.AJAXHelp.Manager_Avarage));
        trowTitl.Controls.Add(ttdTitl);
        ttdTitl = new TableCell();
        lablTitl = new Label();
        ttdTitl.CssClass = "TableTitl_l";
        ttdTitl.Style.Add("width", "90px");
        lablTitl.Text = "<b>" + this.GetLocalResourceObject("Grid1.COL4").ToString() + "</b>";
       
        


        ttdTitl.Controls.Add(TitleTableAjax(HlpButtAjx3, lablTitl, (int)Globals.AJAXHelp.Manager_Fee));
        trowTitl.Controls.Add(ttdTitl);
        tbl.Controls.Add(trowTitl);
        int qw = 0;
        foreach (DataRow drr in ds1.Tables[0].Rows)
        {
            if (((int)drr["Type"]) == Type)
            {
                if (!titlTabl.Visible)
                    titlTabl.Visible = true;
                TableRow trow = new TableRow();
                TableCell ttd = new TableCell();

                HyperLink linklabl = new HyperLink();
                ttd.CssClass = "Column2NoAlignExtreme";
                ttd.Style.Add("Text-align", "right");
                linklabl.Text = drr["Name"].ToString();
                linklabl.NavigateUrl = "Keren.aspx?Id=" + drr["Number"].ToString();
                ttd.Controls.Add(linklabl);
                trow.Controls.Add(ttd);



                ttd = new TableCell();
                Label labl1 = new Label();
                labl1.ID = prefix+"labChislINBEST_AVG" + qw.ToString();
                ttd.CssClass = "Column1number";
                if (drr["INBEST_AVG"].ToString() != "")
                {
                    labl1.Text = (decimal.Parse(drr["INBEST_AVG"].ToString())).ToString("0");
                    labl1.Font.Bold = true;
                    labl1.ForeColor = InbestColor(labl1.Text);
                }
                else
                {
                    labl1.Text = "<b>-</b>";
                }
                ttd.Controls.Add(labl1);
                trow.Controls.Add(ttd);


                ttd = new TableCell();
                labl1 = new Label();
                labl1.ID = prefix + "labChislINBEST_AVG_NOFEE" + qw.ToString();
                ttd.CssClass = "Column2number";
                if (drr["INBEST_AVG_NOFEE"].ToString() != "")
                {
                    labl1.Text = (decimal.Parse(drr["INBEST_AVG_NOFEE"].ToString())).ToString("0");
                    labl1.Font.Bold = true;
                    labl1.ForeColor = InbestColor(labl1.Text);
                }
                else
                {
                    labl1.Text = "<b>-</b>";
                }
                ttd.Controls.Add(labl1);
                trow.Controls.Add(ttd);



                ttd = new TableCell();
                labl1 = new Label();
                labl1.ID = prefix + "labChislJustifiedFee" + qw.ToString();
                ttd.CssClass = "Column1number";
                int justifiedType = JustifiedFeeType(drr);
                switch (justifiedType)
                {
                    case -1:
                        {
                            labl1.Text = "<b>-</b>";
                            ttd.Controls.Add(labl1);
                            break;
                        }
                    case 0:
                        {
                            labl1.Text = "0.00";
                            ttd.Controls.Add(labl1);
                            Label lablProcent = new Label();
                            lablProcent.Text = "%";
                            ttd.Controls.Add(lablProcent);
                            break;
                        }
                    case 1:
                        {
                            labl1.Text = (decimal.Parse(drr["JustifiedFee"].ToString())).ToString("0.00");
                            ttd.Controls.Add(labl1);
                            Label lablProcent = new Label();
                            lablProcent.Text = "%";
                            ttd.Controls.Add(lablProcent);
                            break;
                        }
                    default :
                        {
                            break;
                        }
                }

                
                trow.Controls.Add(ttd);

                tbl.Controls.Add(trow);
                qw++;
            }
        }
        tbl.CellSpacing = 0;
        return tbl;
    }
    Label Resul(int indexCell,Table tbl,string nameLabel, string AddString)
    {
        Label lblRez = new Label();
        decimal decRez = 0;
        int q = 0;
        if (tbl.Rows.Count > 1)
        {
            for (int i = 1; i < tbl.Rows.Count; i++)
            {
                    int temp = i - 1;
                    Label lblI = (Label)tbl.Rows[i].Cells[indexCell].FindControl(nameLabel + temp.ToString());
                    if (lblI != null)
                    {
                        if (lblI.Text != "<b>-</b>")
                        {
                            try
                            {
                                decimal decQ = Convert.ToDecimal(lblI.Text);
                                decRez += decQ;
                                q++;
                            }
                            catch
                            {

                            }
                        }
                    }
                
            }
        }

        #region Start Calc median
        decimal median = 0;
        decimal mid1 = 0;
        decimal mid2 = 0;
        int odd = 0;
        int mid = 0;

        ArrayList list = new ArrayList();
        
        if (tbl.Rows.Count > 1 && nameLabel.IndexOf("JustifiedFee") == -1)
        {
            if (tbl.Rows.Count == 2)
                median = Convert.ToDecimal(((Label)tbl.Rows[1].Cells[indexCell].FindControl(nameLabel + "0")).Text);
            else
            {
                //Fill list for sorting
                for (int counter = 1; counter < tbl.Rows.Count; counter++)
                {
                    int temp = counter - 1;
                    Label lblI = (Label)tbl.Rows[counter].Cells[indexCell].FindControl(nameLabel + temp.ToString());
                    if (lblI != null)
                    {
                        if (lblI.Text != "<b>-</b>") list.Add(Convert.ToDecimal(lblI.Text));
                    }
                }
                //sort list
                list.Sort();

                mid = list.Count / 2;
                odd = list.Count % 2;
                if (odd == 1)
                {
                    //Label lbl = (Label)tbl.Rows[mid + 1].Cells[indexCell].FindControl(nameLabel + mid.ToString());
                    median = Convert.ToDecimal(list[mid]);
                }
                else
                {
                    //mid1 = Convert.ToDecimal(((Label)tbl.Rows[mid].Cells[indexCell].FindControl(nameLabel + (mid - 1).ToString())).Text);
                    mid1 = Convert.ToDecimal(list[mid - 1]);
                    mid2 = Convert.ToDecimal(list[mid]);
                    //mid2 = Convert.ToDecimal(((Label)tbl.Rows[mid + 1].Cells[indexCell].FindControl(nameLabel + mid.ToString())).Text);
                    median = (mid1 + mid2) / 2;
                }
            }
        }
        #endregion

        if (q == 0)
        {
            lblRez.Text = "<b>-</b>";
        }
        else
        {
            decRez = decRez / q;
            if (indexCell == 1 || indexCell == 2)
            {
                //lblRez.Text = decRez.ToString("0") + AddString;
                lblRez.Text = median.ToString() + AddString;
                lblRez.Font.Bold = true;
                lblRez.ForeColor = InbestColor(lblRez.Text);
            }
            else
            {
                lblRez.Text = decRez.ToString("0.00") + AddString;
            }
        }
        return lblRez;
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            HyperLink hlKeren;
            HtmlInputHidden hiddenNumber;
            hiddenNumber = (HtmlInputHidden)e.Row.Cells[0].FindControl("Hidden1");
            hlKeren = (HyperLink)e.Row.Cells[0].FindControl("Link1");
            hlKeren.NavigateUrl = "Keren.aspx?Id=" + hiddenNumber.Value;
        }
    }
    Table TitleTableAjax(Controls_HelpButtonAjax HelpAjaxBttn, Label lablText, int IdMsg)
    {
        Table Tabl = new Table();
        TableRow TablR = new TableRow();
        TableCell TablC = new TableCell();
        TablC.HorizontalAlign = HorizontalAlign.Center;  
        TablC.Controls.Add(lablText);
        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 GridView2_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            HyperLink hlKeren;
            HtmlInputHidden hiddenNumber;
            hiddenNumber = (HtmlInputHidden)e.Row.Cells[0].FindControl("Hidden2");
            hlKeren = (HyperLink)e.Row.Cells[0].FindControl("Link2");
            hlKeren.NavigateUrl = "Keren.aspx?Id=" + hiddenNumber.Value;
        }
    }

    protected void GridView3_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            HyperLink hlKeren;
            HtmlInputHidden hiddenNumber;
            hiddenNumber = (HtmlInputHidden)e.Row.Cells[0].FindControl("Hidden3");
            hlKeren = (HyperLink)e.Row.Cells[0].FindControl("Link3");
            hlKeren.NavigateUrl = "Keren.aspx?Id=" + hiddenNumber.Value;
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Page.Session.Add("ToLid_MSG",Msg_ManagerName);
        Go("Lid.aspx");
    }

    /// <summary>
    /// 0 - 0.00
    /// 1 - value
    /// -1 - "-"
    /// </summary>
    /// <param name="p_row"></param>
    /// <returns></returns>
    private int JustifiedFeeType(DataRow p_row)
    {
        int result = 0;
        if (p_row["SHARP12_M"] != DBNull.Value)
            if (Convert.ToDecimal(p_row["SHARP12_M"]) < 0)
                result = -1;
        if (p_row["SHARP24_M"] != DBNull.Value)
            if (Convert.ToDecimal(p_row["SHARP24_M"]) < 0)
                result = -1;
        if (p_row["SHARP36_M"] != DBNull.Value)
            if (Convert.ToDecimal(p_row["SHARP36_M"]) < 0)
                result = -1;
        if (result != -1)
        {
            if (p_row["JustifiedFee"] != DBNull.Value)
                if (Convert.ToDecimal(p_row["JustifiedFee"]) > 0)
                    result = 1;
        }
        return result; 
    }

    void SetHelpAjaxText(Controls_HelpButtonAjax hlpButton, int IdMesg)
    {
        ControllerArticle CtrlArticle = new ControllerArticle();
        String TitleHelp = CtrlArticle.Get(IdMesg).Title;
        hlpButton.Text = "<div style='text-align:center;'>" + TitleHelp
            + "</div><br />" + CtrlArticle.Get(IdMesg).ShortText;
    }
}