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 ManagerKranot : BasePage
{
    static string Msg_ManagerName;
    protected void Page_Load(object sender, EventArgs e)
    {
        this.CurrentPage = CurrentPageId.ManagerKupot;
        LabelUpdText.Text = GetGlobalResourceObject("Common", "Updatedate").ToString();
        LabelUpdDate.Text = PageUpdatedDate;
        Label2.Text = GetGlobalResourceObject("Common", "Updatedate").ToString();
        Label3.Text = PageUpdatedDate;

        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.GetKranotHishtalmutByManager(Msg_ManagerName);
        Table tbl1 = GetTableOnType(ds1, TitleControl2, "1", HelpButtonAjax1, HelpButtonAjax2, HelpButtonAjax3, "KerenEd.aspx");
        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", "%"));
        }
        else
        {
            title1.Visible = false;
            TitleControl2.Visible = false;
        }
        ds1 = controller.GetKupotGemelByManager(Msg_ManagerName);
        tbl1 = GetTableOnType(ds1, TitleControl3, "2", HelpButtonAjax4, HelpButtonAjax5, HelpButtonAjax6, "KerenG.aspx");
        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", "%"));
        }
        else
        {
            title2.Visible = false;
            TitleControl3.Visible = false;
        }
    }
    Table GetTableOnType(DataSet ds1, TitleControl titlTabl, string prefix, Controls_HelpButtonAjax HlpButtAjx,
        Controls_HelpButtonAjax HlpButtAjx2, Controls_HelpButtonAjax HlpButtAjx3, string p_link)
    {
        if (ds1.Tables[0].Rows.Count == 0)
        {
            HlpButtAjx.Visible = false; 
            HlpButtAjx2.Visible = false;
            HlpButtAjx3.Visible = false; 
            return new Table();
        }
        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", "250px");
        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", "60px");
        lablTitl.Text = "<b>" + this.GetLocalResourceObject("Grid1.COL2").ToString() + "</b>";

        ttdTitl.Controls.Add(TitleTableAjax(HlpButtAjx, lablTitl, ((int)Globals.AJAXHelp.ManagerK_Madad)));


        trowTitl.Controls.Add(ttdTitl);
        ttdTitl = new TableCell();
        lablTitl = new Label();
        ttdTitl.CssClass = "TableTitl";
        ttdTitl.Style.Add("width", "60px");
        lablTitl.Text = "<b>" + this.GetLocalResourceObject("Grid1.COL3").ToString() + "</b>";



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




        ttdTitl.Controls.Add(TitleTableAjax(HlpButtAjx3, lablTitl, (int)Globals.AJAXHelp.ManagerK_Fee));
        trowTitl.Controls.Add(ttdTitl);
        tbl.Controls.Add(trowTitl);
        int qw = 0;
        foreach (DataRow drr in ds1.Tables[0].Rows)
        {
            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 = p_link + "?kerenID=" + 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"].ToString() != "")
            {
                labl1.Text = (decimal.Parse(drr["INBEST"].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_NO_FEE"].ToString() != "")
            {
                labl1.Text = (decimal.Parse(drr["INBEST_NO_FEE"].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;

        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
            {
                mid = (tbl.Rows.Count - 1) / 2;
                odd = (tbl.Rows.Count - 1) % 2;
                if (odd == 1)
                {
                    Label lbl = (Label)tbl.Rows[mid + 1].Cells[indexCell].FindControl(nameLabel + mid.ToString());
                    if (lbl.Text != "-") median = Convert.ToDecimal(lbl.Text);
                }
                else
                {
                    mid1 = Convert.ToDecimal(((Label)tbl.Rows[mid].Cells[indexCell].FindControl(nameLabel + (mid - 1).ToString())).Text);
                    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["SHARP"] != DBNull.Value)
            if (Convert.ToDecimal(p_row["SHARP"]) < 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;
    }
}