protected void gvUserType_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.Header)
        {
            if (ViewState["SORTBYCOLOUMN"] != null)
            {
                HtmlImage img = (HtmlImage)e.Row.FindControl(ViewState["SORTBYCOLOUMN"].ToString());
                if (img != null)
                {
                    if (ViewState["SORTDIRECTION"] == null || ViewState["SORTDIRECTION"].ToString() == "0")
                    {
                        img.Src = "~/purchase/Image/arrowUp.png";
                    }
                    else
                    {
                        img.Src = "~/purchase/Image/arrowDown.png";
                    }

                    img.Visible = true;
                }
            }
            MergeGridviewHeader.SetProperty(objChangeReqstMerge);

            e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
        }

        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Attributes["onmouseover"] = "this.style.cursor='hand';this.style.backgroundColor='#FEECEC';";
            e.Row.Attributes["onmouseout"]  = "this.style.textDecoration='none';this.style.color='black';this.style.backgroundColor=''";
        }
    }
    protected void gvInvoice_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.Header)
        {
            MergeGridviewHeader.SetProperty(objChangeReqstMerge);
            e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
        }

        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            Label  lblUSD_Amount = (Label)e.Row.FindControl("lblUSD_Amount");
            double qty           = Convert.ToDouble(lblUSD_Amount.Text);
            Label  lblDispute    = (Label)e.Row.FindControl("lblDispute_Flag");
            intotal = intotal + qty;
            if (DataBinder.Eval(e.Row.DataItem, "Dispute_Flag").ToString() == "YES")
            {
                e.Row.Cells[13].BackColor = System.Drawing.Color.Red;
                lblDispute.ForeColor      = System.Drawing.Color.White;
            }
        }
        if (e.Row.RowType == DataControlRowType.Footer)
        {
            e.Row.Cells[9].Text  = "Total: ";
            e.Row.Cells[10].Text = intotal.ToString();;
        }
    }
    protected void gvPurchase_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.Header)
        {
            MergeGridviewHeader.SetProperty(objChangeReqstMerge);
            e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
        }

        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            TotPOUSDValue  += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "PO_USD_Value"));
            TotInvUSDAmt   += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Invoice_USD_Amount"));
            TotPaidUSDAmt  += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Paid_USD_Amount"));
            TotOutPOCurAmt += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "OutStanding_USD_Amount"));
        }
        if (e.Row.RowType == DataControlRowType.Footer)
        {
            Label lblTotPOUSDValue   = (Label)e.Row.FindControl("lblTotPOUSDValue");
            Label lblTotInvUSDAmt    = (Label)e.Row.FindControl("lblTotInvUSDAmt");
            Label lblTotPaidUSDAmt   = (Label)e.Row.FindControl("lblTotPaidUSDAmt");
            Label lblTotOutPOCurAmt  = (Label)e.Row.FindControl("lblTotOutPOCurAmt");
            Label lblTotOutPOCurAmt1 = (Label)e.Row.FindControl("lblTotOutPOCurAmt1");
            Label lblTotPOUSDValue1  = (Label)e.Row.FindControl("lblTotPOUSDValue1");
            Label lblTotInvUSDAmt1   = (Label)e.Row.FindControl("lblTotInvUSDAmt1");
            Label lblTotPaidUSDAmt1  = (Label)e.Row.FindControl("lblTotPaidUSDAmt1");
            lblTotPOUSDValue.Text   = TotPOUSDValue.ToString();
            lblTotInvUSDAmt.Text    = TotInvUSDAmt.ToString();
            lblTotPaidUSDAmt.Text   = TotPaidUSDAmt.ToString();
            lblTotOutPOCurAmt.Text  = TotOutPOCurAmt.ToString();
            lblTotOutPOCurAmt1.Text = TotOutPOCurAmt.ToString();
            lblTotPOUSDValue1.Text  = TotPOUSDValue.ToString();
            lblTotInvUSDAmt1.Text   = TotInvUSDAmt.ToString();
            lblTotPaidUSDAmt1.Text  = TotOutPOCurAmt.ToString();
        }
    }
예제 #4
0
 protected void gvLimit_RowDataBound(object sender, GridViewRowEventArgs e)
 {
     if (e.Row.RowType == DataControlRowType.Header)
     {
         MergeGridviewHeader.SetProperty(objChangeReqstMerge);
         e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
     }
 }
 protected void rgdQuatationInfo_ItemCreated(object sender, GridViewRowEventArgs e)
 {
     if (e.Row.RowType == DataControlRowType.Header)
     {
         MergeGridviewHeader.SetProperty(objItemColumn);
         e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
     }
 }
예제 #6
0
 protected void gvWelfareDetails_RowCreated(object sender, GridViewRowEventArgs e)
 {
     if (e.Row.RowType == DataControlRowType.Header)
     {
         MergeGridviewHeader.SetProperty(objItemColumn);
         e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
     }
 }
예제 #7
0
 protected void gvOrtg_RowDataBound(object sender, GridViewRowEventArgs e)
 {
     if (e.Row.RowType == DataControlRowType.Header)
     {
         MergeGridviewHeader.SetProperty(mergeheadgvOrtg);
         e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
     }
 }
예제 #8
0
    //protected void gvEvaluation_RowCommand(object sender, GridViewCommandEventArgs e)
    //{
    //    if (e.CommandName == "Select")
    //    {
    //        string[] arg = e.CommandArgument.ToString().Split(',');
    //        Session["EvalID"] = UDFLib.ConvertToInteger(arg[1]);
    //        Session["Supp_ID"] = UDFLib.ConvertToInteger(arg[0]);
    //        string EvalID = UDFLib.ConvertStringToNull(arg[1]);
    //        string Supp_ID = UDFLib.ConvertStringToNull(arg[0]);
    //        string Type = "1";
    //        ScriptManager.RegisterStartupScript(Page, typeof(Page), "OpenWindow", "window.open('../ASL/ASL_General_Data.aspx?Supp_ID=" + Supp_ID + "&Type=" + Type + "&EvalID=" + EvalID + "', '_blank');", true);

    //    }
    //}


    //protected void gvChangeRequest_RowCommand(object sender, GridViewCommandEventArgs e)
    //{
    //    if (e.CommandName == "Select")
    //    {
    //        string[] arg = e.CommandArgument.ToString().Split(',');
    //        Session["Supplier_Code"] = UDFLib.ConvertToInteger(arg[0]);
    //        string Supplier_Code = UDFLib.ConvertStringToNull(arg[0]);
    //        string Type = "0";
    //        ScriptManager.RegisterStartupScript(Page, typeof(Page), "OpenWindow", "window.open('../ASL/ASL_General_Data.aspx?Supp_ID=" + Supplier_Code + "&Type=" + Type + "', '_blank');", true);

    //    }
    //}

    protected void gvSupplier_RowCreated(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.Header)
        {
            MergeGridviewHeader.SetProperty(objContractList);

            e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
            ViewState["DynamicHeaderCSS"] = "HeaderStyle-css-2";
        }
    }
    protected void gvVictuallingRate_RowCreated(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.Header)
        {
            MergeGridviewHeader.SetProperty(objVicRate);

            e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
            ViewState["DynamicHeaderCSS"] = "HeaderStyle-css";
        }
    }
예제 #10
0
    protected void gvApprovalHistory_RowCreated(object sender, GridViewRowEventArgs e)            //call the method for custom rendering the columns headers	on row created event
    {
        if (e.Row.RowType == DataControlRowType.Header)
        {
            MergeGridviewHeader.SetProperty(objApprovalHist);

            e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);

            ViewState["DynamicHeaderCSS"] = "HeaderStyle-css";
        }
    }
    protected void gvOnlineInvoice_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.Header)
        {
            MergeGridviewHeader.SetProperty(objChangeReqstMerge);
            e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
        }
        //if (e.Row.RowType == DataControlRowType.DataRow)
        //{
        //    if (gvOnlineInvoice.Rows.Count > 0) gvOnlineInvoice.Rows[0].RowState = DataControlRowState.Selected;

        //}
    }
예제 #12
0
    protected void gvInspecrionSchedule_RowCreated(object sender, GridViewRowEventArgs e)
    {
        try
        {
            if (e.Row.RowType == DataControlRowType.Header)
            {
                MergeGridviewHeader.SetProperty(objMegeHead);

                e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
                ViewState["DynamicHeaderCSS"] = "HeaderStyle-css-2";
            }
        }
        catch { }
    }
    protected void gvNotification_RowCreated(object sender, GridViewRowEventArgs e)
    {
        try
        {
            if (e.Row.RowType == DataControlRowType.Header)
            {
                MergeGridviewHeader.SetProperty(objContractList);

                e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
                ViewState["DynamicHeaderCSS"] = "PMSGridItemStyle-css";
            }
        }
        catch { }
    }
    protected void rgdReqAllStage_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.Header)
        {
            MergeGridviewHeader.SetProperty(objChangeReqstMerge);

            e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
        }
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.CssClass = "PMSGridItemStyle-css";

            Label lbldocument_code = (Label)e.Row.FindControl("lblInfo");
            Label lblRFQSend       = ((Label)e.Row.FindControl("lblRFQSend"));
            Label lblQuotReceived  = ((Label)e.Row.FindControl("lblQuotReceived"));

            lblRFQSend.Attributes.Add("onmouseover", "Get_ToopTipsForQtnSent('" + lbldocument_code.Text.ToString() + "',event,this)");
            lblQuotReceived.Attributes.Add("onmouseover", "Get_ToopTipsForQtnRecve('" + lbldocument_code.Text.ToString() + "',event,this)");
            string Received = BindToolTipsSuppNameOnQtnRecvd("", ((Label)e.Row.FindControl("lblInfo")).ToolTip.Split(new char[] { ',' })[0], ((Label)e.Row.FindControl("lblInfo")).ToolTip.Split(new char[] { ',' })[1]);
            string Sent     = BindToolTipsSuppNameOnQtnSent("", ((Label)e.Row.FindControl("lblInfo")).ToolTip.Split(new char[] { ',' })[0], ((Label)e.Row.FindControl("lblInfo")).ToolTip.Split(new char[] { ',' })[1]);
            //string[] st = Sent.Split(')');
            //string[] rcvd = Received.Split(')');
            lblQuotReceived.Text = Received; //(rcvd.Length - 1) >= 0 ? (rcvd.Length - 1).ToString() : "0";
            lblRFQSend.Text      = Sent;     //(st.Length - 1) >= 0 ? (st.Length - 1).ToString() : "0";
            if (Convert.ToInt32(lblQuotReceived.Text) > 0)
            {
                lblQuotReceived.Style.Add("text-decoration", "underline");
            }
            if (Convert.ToInt32(lblRFQSend.Text) > 0)
            {
                lblRFQSend.Style.Add("text-decoration", "underline");
            }


            //lblRFQSend.Attributes.Add("onclick", "Get_ToopTipsForQtnSent('" + lbldocument_code.Text.Split(new char[] { ',' })[0] + "',event,this)");
            //lblQuotReceived.Attributes.Add("onclick", "Get_ToopTipsForQtnRecve('" + lbldocument_code.Text.Split(new char[] { ',' })[0] + "',event,this)");

            //string Received = BindToolTipsSuppNameOnQtnRecvd("", ((Label)e.Row.FindControl("lblInfo")).ToolTip.Split(new char[] { ',' })[0], ((Label)e.Row.FindControl("lblInfo")).ToolTip.Split(new char[] { ',' })[1]);
            //string Sent = BindToolTipsSuppNameOnQtnSent("", ((Label)e.Row.FindControl("lblInfo")).ToolTip.Split(new char[] { ',' })[0], ((Label)e.Row.FindControl("lblInfo")).ToolTip.Split(new char[] { ',' })[1]);
            //Label lblsent = ((Label)e.Row.FindControl("lblRFQSend"));
            //Label lblrecvd = ((Label)e.Row.FindControl("lblQuotReceived"));
            //string[] st = Sent.Split(')');
            //string[] rcvd = Received.Split(')');
            //lblrecvd.Text = (rcvd.Length - 1) >= 0 ? (rcvd.Length - 1).ToString() : "0";
            //lblsent.Text = (st.Length - 1) >= 0 ? (st.Length - 1).ToString() : "0";
            //lblsent.Attributes.Add("Title", "cssbody=[dvbdy1] cssheader=[dvhdr1] header=[Quotation Sent To :] body=[" + Sent + "]");
            //lblrecvd.Attributes.Add("Title", "cssbody=[dvbdy1] cssheader=[dvhdr1] header=[Quotation Received From :] body=[" + Received + "]");
        }
    }
예제 #15
0
    protected void GridView_Tanker_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.Header)
        {
            MergeGridviewHeader.SetProperty(objChangeReqstMerge);

            e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
        }
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            if (e.Row.DataItemIndex == 22)
            {
                e.Row.Cells[0].ForeColor = System.Drawing.Color.Red;
                e.Row.Cells[1].ForeColor = System.Drawing.Color.Red;
            }
        }
    }
예제 #16
0
    protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
    {
        try
        {
            if (e.Row.RowType == DataControlRowType.Header)
            {
                MergeGridviewHeader.SetProperty(objContractList);

                e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
                ViewState["DynamicHeaderCSS"] = "HeaderStyle-css-2";
            }
        }
        catch (Exception ex)
        {
            UDFLib.WriteExceptionLog(ex);
        }
    }
    protected void gvInvoiceWithhold_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.Header)
        {
            MergeGridviewHeader.SetProperty(objChangeReqstMerge);
            e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
        }
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            string Supply_ID = DataBinder.Eval(e.Row.DataItem, "Supply_ID").ToString();

            if (DataBinder.Eval(e.Row.DataItem, "Invoice_Type").ToString() == "WITHHOLD")
            {
                e.Row.BackColor = System.Drawing.Color.Yellow;
            }
        }
    }
예제 #18
0
 protected void gvPurchase_RowDataBound(object sender, GridViewRowEventArgs e)
 {
     if (e.Row.RowType == DataControlRowType.Header)
     {
         MergeGridviewHeader.SetProperty(objChangeReqstMerge);
         e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
     }
     if (e.Row.RowType == DataControlRowType.DataRow)
     {
         TotReportUSDValue += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Report_USD_Value"));
     }
     if (e.Row.RowType == DataControlRowType.Footer)
     {
         Label lblReportUSDValue = (Label)e.Row.FindControl("lblReportUSDValue");
         lblReportUSDValue.Text = TotReportUSDValue.ToString();
     }
 }
예제 #19
0
    protected void GridView_CYL_RowCreated(object sender, GridViewRowEventArgs e)
    {
        try
        {
            if (Session["UTYPE"].ToString() != "MANNING AGENT")
            {
                if (e.Row.RowType == DataControlRowType.Header)
                {
                    MergeGridviewHeader.SetProperty(objMergeList);

                    e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
                    ViewState["DynamicHeaderCSS"] = "HeaderStyle-css-2";
                }
            }
        }
        catch { }
    }
예제 #20
0
 protected void gvVettingIndex_RowCreated(object sender, GridViewRowEventArgs e)
 {
     try
     {
         MergeGridviewHeader_Info objVetMerge = new MergeGridviewHeader_Info();
         if (e.Row.RowType == DataControlRowType.Header)
         {
             MergeGridviewHeader.SetProperty(objVetMerge);
             e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
         }
     }
     catch (Exception ex)
     {
         UDFLib.WriteExceptionLog(ex);
         string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');";
         ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true);
     }
 }
 protected void gvPurchase_RowDataBound(object sender, GridViewRowEventArgs e)
 {
     if (e.Row.RowType == DataControlRowType.Header)
     {
         MergeGridviewHeader.SetProperty(objChangeReqstMerge);
         e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
     }
     if (e.Row.RowType == DataControlRowType.DataRow)
     {
         Label Line_Date    = (Label)e.Row.FindControl("lblLine_Date");
         Label Ref_Code     = (Label)e.Row.FindControl("lblOffice_Ref_Code");
         Label Display_Name = (Label)e.Row.FindControl("lblSupplier_Display_Name");
         Label Line_Amount  = (Label)e.Row.FindControl("lblLine_Amount");
         Label Invoice_Ref  = (Label)e.Row.FindControl("lblInvoice_Ref");
         Label USD_Amount   = (Label)e.Row.FindControl("lblPO_USD_Amount");
         TotInvoiceUSDValue += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Invoice_Book_Value"));
         string SupplyID = Convert.ToString(DataBinder.Eval(e.Row.DataItem, "Supply_ID"));
         if (SupplyID == ViewState["SupplyID"].ToString())
         {
             Line_Date.Visible    = false;
             Ref_Code.Visible     = false;
             Display_Name.Visible = false;
             Line_Amount.Visible  = false;
             Invoice_Ref.Visible  = false;
             USD_Amount.Visible   = false;
         }
         else
         {
             TotPOUSDValue += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "PO_USD_Amount"));
         }
         ViewState["SupplyID"] = Convert.ToString(DataBinder.Eval(e.Row.DataItem, "Supply_ID"));
     }
     if (e.Row.RowType == DataControlRowType.Footer)
     {
         //MergeGridviewHeader.SetProperty(objChangeReqstMerge);
         //e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
         Label lblPOUSDAmount = (Label)e.Row.FindControl("lblPOUSDAmount");
         lblPOUSDAmount.Text = TotPOUSDValue.ToString();
         Label lblInvBookValue = (Label)e.Row.FindControl("lblInvBookValue");
         lblInvBookValue.Text = TotInvoiceUSDValue.ToString();
     }
 }
예제 #22
0
 protected void gvApprovedPaymentinvoice_RowDataBound(object sender, GridViewRowEventArgs e)
 {
     if (e.Row.RowType == DataControlRowType.Header)
     {
         MergeGridviewHeader.SetProperty(objChangeReqstMerge);
         e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
     }
     if (e.Row.RowType == DataControlRowType.DataRow)
     {
         DateTime Last_Payment_Date;
         // string ColorCode = DataBinder.Eval(e.Row.DataItem, "COLOR_CODE").ToString();
         //System.Drawing.Color col = System.Drawing.ColorTranslator.FromHtml(ColorCode);
         string PaymentDate         = DataBinder.Eval(e.Row.DataItem, "Last_Payment_Date").ToString();
         Label  lblLastPayment_Date = (Label)e.Row.FindControl("lblLPayment");
         if (PaymentDate != "" && PaymentDate != null)
         {
             Last_Payment_Date = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "Last_Payment_Date").ToString());
             int result = DateTime.Compare(Last_Payment_Date, System.DateTime.Now);
             if (result > 0)
             {
                 e.Row.Cells[2].BackColor      = System.Drawing.Color.Green;
                 lblLastPayment_Date.ForeColor = System.Drawing.Color.White;
             }
             else
             {
                 e.Row.Cells[2].BackColor      = System.Drawing.Color.Red;
                 lblLastPayment_Date.ForeColor = System.Drawing.Color.White;
             }
         }
         else
         {
             Last_Payment_Date = System.DateTime.Now;
         }
         //DateTime PO_Date = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "Last_Payment_Date").ToString());
         //Button ViewRemarks = (Button)e.Row.FindControl("btnViewRemarks");
     }
 }
예제 #23
0
    protected void gvJobChangeRqst_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.Header)
        {
            if (ViewState["SORTBYCOLOUMN"] != null)
            {
                HtmlImage img = (HtmlImage)e.Row.FindControl(ViewState["SORTBYCOLOUMN"].ToString());
                if (img != null)
                {
                    if (ViewState["SORTDIRECTION"] == null || ViewState["SORTDIRECTION"].ToString() == "0")
                    {
                        img.Src = "~/purchase/Image/arrowUp.png";
                    }
                    else
                    {
                        img.Src = "~/purchase/Image/arrowDown.png";
                    }

                    img.Visible = true;
                }
            }
        }
        if (e.Row.RowType == DataControlRowType.Header)
        {
            MergeGridviewHeader.SetProperty(objChangeReqstMerge);

            e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
        }
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            ImageButton ImgApprove = (ImageButton)e.Row.FindControl("ImgApprove");
            if (ImgApprove != null)
            {
                ImgApprove.Attributes.Add("onclick", "javascript:OpenRequestDetails(" + DataBinder.Eval(e.Row.DataItem, "Vessel_ID").ToString() + ", " + DataBinder.Eval(e.Row.DataItem, "ID").ToString() + " , '" + DataBinder.Eval(e.Row.DataItem, "Status").ToString() + "'); return false;");
            }
        }
    }
    protected void gvPendinginvoice_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.Header)
        {
            MergeGridviewHeader.SetProperty(objChangeReqstMerge);
            e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
        }
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            string ColorCode                      = DataBinder.Eval(e.Row.DataItem, "COLOR_CODE").ToString();
            System.Drawing.Color col              = System.Drawing.ColorTranslator.FromHtml(ColorCode);
            DateTime             Invoice_Date     = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "Invoice_Date").ToString());
            DateTime             PO_Date          = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "Created_Date").ToString());
            DateTime             Payment_Due_Date = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "Payment_Due_Date").ToString());
            Button      ViewRemarks               = (Button)e.Row.FindControl("btnViewRemarks");
            Label       lblUrgent                 = (Label)e.Row.FindControl("lblUrgent");
            Label       lblUrgentFlag             = (Label)e.Row.FindControl("lblUrgentFlag");
            LinkButton  lblSupplier               = (LinkButton)e.Row.FindControl("lbl_SupplierName");
            LinkButton  lblPO                     = (LinkButton)e.Row.FindControl("lblPOCode");
            Label       lblInvoiceStatus          = (Label)e.Row.FindControl("lblInvoice_Status");
            Button      btnApprove                = (Button)e.Row.FindControl("btnAprove");
            Button      btnunApprove              = (Button)e.Row.FindControl("btnUnApprove");
            Label       lblApproveMsg             = (Label)e.Row.FindControl("lblApproveMsg");
            ImageButton btnonHold                 = (ImageButton)e.Row.FindControl("btnOnHold");
            ImageButton btnHold                   = (ImageButton)e.Row.FindControl("btnhold");
            Label       lblDays                   = (Label)e.Row.FindControl("lblDays");
            Label       lblPaymentDate            = (Label)e.Row.FindControl("lblPaymentDate");
            Label       lblInvoice_Value          = (Label)e.Row.FindControl("lblInvoice_Value");
            Label       lblInvoice_Currency       = (Label)e.Row.FindControl("lblInvoice_Currency");
            if (Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Invoice_Value")) > Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "PO_Amount")))
            {
                lblInvoice_Value.ForeColor = System.Drawing.Color.Red;
            }
            else
            {
                lblInvoice_Value.ForeColor = System.Drawing.Color.Black;
            }
            if (DataBinder.Eval(e.Row.DataItem, "CURRENCY").ToString() != DataBinder.Eval(e.Row.DataItem, "Invoice_Currency").ToString())
            {
                e.Row.Cells[13].BackColor = System.Drawing.Color.Violet;
            }
            else
            {
                e.Row.Cells[13].BackColor = System.Drawing.Color.White;
            }
            if (DataBinder.Eval(e.Row.DataItem, "Supplier_Currency").ToString() != DataBinder.Eval(e.Row.DataItem, "CURRENCY").ToString())
            {
                if (DataBinder.Eval(e.Row.DataItem, "Supplier_Currency") != null)
                {
                    e.Row.Cells[4].BackColor = System.Drawing.Color.Violet;
                }
            }
            else
            {
                e.Row.Cells[4].BackColor = System.Drawing.Color.White;
            }
            if (DataBinder.Eval(e.Row.DataItem, "Urgent_Flag").ToString() == "URGENT")
            {
                lblUrgent.Visible     = true;
                lblUrgentFlag.Visible = true;
            }
            else
            {
                lblUrgent.Visible     = false;
                lblUrgentFlag.Visible = false;
            }
            int result = DateTime.Compare(PO_Date, Invoice_Date);
            if (result > 0)
            {
                e.Row.Cells[2].BackColor = System.Drawing.Color.Red;
                lblPO.ForeColor          = System.Drawing.Color.White;
            }
            else
            {
                e.Row.Cells[1].BackColor = col;
                //lblSupplier.ForeColor = System.Drawing.Color.White;
            }
            DateTime TDate = System.DateTime.Now;
            int      Diff  = DateTime.Compare(Payment_Due_Date, TDate);
            if (Diff > 0)
            {
                System.TimeSpan diffResult       = Payment_Due_Date - TDate;
                int             differenceInDays = diffResult.Days;
                lblDays.Text             = differenceInDays + " " + "Days";
                lblDays.ForeColor        = System.Drawing.Color.Black;
                lblPaymentDate.ForeColor = System.Drawing.Color.Black;
            }
            else
            {
                lblPaymentDate.ForeColor = System.Drawing.Color.Red;
            }
            if (DataBinder.Eval(e.Row.DataItem, "Invoice_Status").ToString() == "Approved")
            {
                e.Row.Cells[11].BackColor  = System.Drawing.Color.Green;
                lblInvoiceStatus.ForeColor = System.Drawing.Color.White;
                btnunApprove.Visible       = true;
                btnApprove.Visible         = false;
                lblApproveMsg.Text         = "No Dispute.";
                lblApproveMsg.ForeColor    = System.Drawing.Color.Green;
                btnHold.Visible            = false;
                btnonHold.Visible          = false;
            }
            else if (DataBinder.Eval(e.Row.DataItem, "Dispute_Flag").ToString() == "YES")
            {
                e.Row.Cells[11].BackColor  = System.Drawing.Color.White;
                lblInvoiceStatus.ForeColor = System.Drawing.Color.Black;
                btnApprove.Visible         = true;
                btnApprove.Enabled         = false;
                btnunApprove.Visible       = false;
                lblApproveMsg.Text         = "Cannot approve until Dispute status is removed.";
                lblApproveMsg.ForeColor    = System.Drawing.Color.Red;
            }
            else if (DataBinder.Eval(e.Row.DataItem, "Invoice_Status").ToString() == "Hold")
            {
                e.Row.Cells[11].BackColor  = System.Drawing.Color.White;
                lblInvoiceStatus.ForeColor = System.Drawing.Color.Black;
                btnApprove.Visible         = true;
                btnApprove.Enabled         = false;
                btnunApprove.Visible       = false;
                lblApproveMsg.Text         = "Cannot approve until Hold status is removed.";
                btnHold.Visible            = true;
                btnonHold.Visible          = false;
                lblApproveMsg.ForeColor    = System.Drawing.Color.Black;
            }
            else
            {
                e.Row.Cells[11].BackColor  = System.Drawing.Color.White;
                lblInvoiceStatus.ForeColor = System.Drawing.Color.Black;
                btnApprove.Visible         = true;
                btnApprove.Enabled         = true;
                btnunApprove.Visible       = false;
                lblApproveMsg.Text         = "No Dispute.";

                lblApproveMsg.ForeColor = System.Drawing.Color.Green;
                btnHold.Visible         = false;
                btnonHold.Visible       = true;
            }

            //e.Row.Cells[16].BackColor = System.Drawing.Color.Yellow;
            //string ID = UDFLib.ConvertStringToNull(gvPendinginvoice.DataKeys[e.Row.RowIndex].Value);

            //GridView gv = (GridView)e.Row.FindControl("gvRemarks");
            //DataSet ds = BLL_POLOG_Register.POLOG_Get_Remarks_ByInvoiceID(ID);
            //if (ds.Tables[0].Rows.Count > 0)
            //{
            //    //ViewRemarks.Visible = true;
            //    gv.DataSource = ds.Tables[0];
            //    gv.DataBind();
            //}
        }
    }
예제 #25
0
    protected void gvStatus_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            Label lblVesselCode           = (Label)e.Row.FindControl("lblVesselCode");
            Label lblCMS                  = (Label)e.Row.FindControl("lblCMS");
            Label lblCritical             = (Label)e.Row.FindControl("lblCritical");
            Label lblJobTitle             = (Label)e.Row.FindControl("lblJobTitle");
            Label lblLocationID           = (Label)e.Row.FindControl("lblLocationID");
            Label lblLocation             = (Label)e.Row.FindControl("lblLocation");
            Label lblOverDueFlage         = (Label)e.Row.FindControl("lblOverDueFlage");
            Label lblNext30dayFlage       = (Label)e.Row.FindControl("lblNext30dayFlage");
            Label lblJobDescription       = (Label)e.Row.FindControl("lblJobDescription");
            Label lblJobHistoryRemaks     = (Label)e.Row.FindControl("lblJobHistoryRemaks");
            Label lblFullJobHistoryRemaks = (Label)e.Row.FindControl("lblFullJobHistoryRemaks");
            Label lblJobHistoryID         = (Label)e.Row.FindControl("lblJobHistoryID");
            Label lblFreqType             = (Label)e.Row.FindControl("lblFrequencyType");
            Label lblJobCode              = (Label)e.Row.FindControl("lblJobCode");


            HyperLink ImgHistory = (HyperLink)e.Row.FindControl("ImgHistory");
            if (ViewState["Qflag"].ToString() == "H")
            {
                ImgHistory.Visible = false;
            }
            else
            {
                ImgHistory.NavigateUrl = "PMSJOBProcess.aspx?Qflag=H&JOB_ID=" + Convert.ToString(DataBinder.Eval(e.Row.DataItem, "JOB_ID") + "&VESSEL_ID=" + DataBinder.Eval(e.Row.DataItem, "Vessel_ID").ToString() + "&Function_ID=" + DataBinder.Eval(e.Row.DataItem, "FunctionID").ToString() + "&System_ID=" + DataBinder.Eval(e.Row.DataItem, "SysID").ToString() + "&SubSystem_ID=" + DataBinder.Eval(e.Row.DataItem, "SubSysID").ToString() + "&Fleet_ID=" + DataBinder.Eval(e.Row.DataItem, "FleetID").ToString());
            }

            if (lblJobHistoryID.Text == "")
            {
                lblJobHistoryID.Text = "0";
            }

            HyperLink hlnkJobCode  = (HyperLink)e.Row.FindControl("hlnkJobCode");
            HyperLink hlnkNextDone = (HyperLink)e.Row.FindControl("hlnkNextDone");
            if (UDFLib.ConvertToInteger(DataBinder.Eval(e.Row.DataItem, "JobHistoryID")) > 0)
            {
                hlnkJobCode.NavigateUrl  = "PMSAddAdhocJob.aspx?JOB_HISTORY_ID=" + DataBinder.Eval(e.Row.DataItem, "JobHistoryID").ToString() + "&VESSEL_ID=" + DataBinder.Eval(e.Row.DataItem, "Vessel_ID").ToString() + "&OFFICE_ID=" + DataBinder.Eval(e.Row.DataItem, "OFFICE_ID").ToString() + "&JOB_ID=" + DataBinder.Eval(e.Row.DataItem, "JOB_ID").ToString() + "&OD_DAYS=" + DataBinder.Eval(e.Row.DataItem, "OD_DAYS").ToString() + "&IsRAMandatory=" + DataBinder.Eval(e.Row.DataItem, "IsRAMandatory").ToString();
                hlnkNextDone.NavigateUrl = "PMSAddAdhocJob.aspx?JOB_HISTORY_ID=" + DataBinder.Eval(e.Row.DataItem, "JobHistoryID").ToString() + "&VESSEL_ID=" + DataBinder.Eval(e.Row.DataItem, "Vessel_ID").ToString() + "&OFFICE_ID=" + DataBinder.Eval(e.Row.DataItem, "OFFICE_ID").ToString() + "&JOB_ID=" + DataBinder.Eval(e.Row.DataItem, "JOB_ID").ToString() + "&OD_DAYS=" + DataBinder.Eval(e.Row.DataItem, "OD_DAYS").ToString() + "&IsRAMandatory=" + DataBinder.Eval(e.Row.DataItem, "IsRAMandatory").ToString();
            }
            else
            {
                hlnkJobCode.NavigateUrl  = "PMSJobIndividualDetails.aspx?JobHistoryID=" + DataBinder.Eval(e.Row.DataItem, "JobHistoryID").ToString() + "&VID=" + DataBinder.Eval(e.Row.DataItem, "Vessel_ID").ToString() + "&Qflag=S&JobID=" + DataBinder.Eval(e.Row.DataItem, "JOB_ID").ToString();
                hlnkNextDone.NavigateUrl = "PMSJobIndividualDetails.aspx?JobHistoryID=" + DataBinder.Eval(e.Row.DataItem, "JobHistoryID").ToString() + "&VID=" + DataBinder.Eval(e.Row.DataItem, "Vessel_ID").ToString() + "&Qflag=S&JobID=" + DataBinder.Eval(e.Row.DataItem, "JOB_ID").ToString();
            }


            ImageButton ImgSpareUsed = (ImageButton)e.Row.FindControl("ImgSpareUsed");
            ImgSpareUsed.Attributes.Add("onclick", "document.getElementById('iFrmJobsDetails').src ='../PMS/PMS_SparesUsed.aspx?JobID=" + DataBinder.Eval(e.Row.DataItem, "JOB_ID").ToString() + "&Vessel_ID=" + lblVesselCode.Text.Trim() + "';showModal('dvJobsDetails');return false;");

            ImageButton ImgRHours = (ImageButton)e.Row.FindControl("ImgRHours");
            if (lblFreqType.Text.ToString() == "2486")
            {
                ImgRHours.Visible = true;
                ImgRHours.Attributes.Add("onClick", "javascript:window.open('../PMS/PMSRunningHours.aspx?VESSEL_ID=" + DataBinder.Eval(e.Row.DataItem, "Vessel_ID").ToString() + "&Function_ID=" + DataBinder.Eval(e.Row.DataItem, "FunctionID").ToString() + "&System_ID=" + DataBinder.Eval(e.Row.DataItem, "SysID").ToString() + "&SubSystem_ID=" + DataBinder.Eval(e.Row.DataItem, "SubSysID").ToString() + "&Fleet_ID=" + DataBinder.Eval(e.Row.DataItem, "FleetID").ToString() + "','_blank');return false");
            }


            if (lblFullJobHistoryRemaks.Text.Length > 15)
            {
                lblJobHistoryRemaks.Text = lblJobHistoryRemaks.Text + "..";
            }


            if (lblJobDescription.Text != "")
            {
                lblJobTitle.Attributes.Add("Title", "cssbody=[dvbdy1] cssheader=[dvhdr1] header=[Job Description] body=[" + lblJobDescription.Text + "]");
            }


            if (lblFullJobHistoryRemaks.Text != "")
            {
                lblJobHistoryRemaks.Attributes.Add("Title", "cssbody=[dvbdy1] cssheader=[dvhdr1] header=[Remarks] body=[" + lblFullJobHistoryRemaks.Text + "]");
            }

            if (lblOverDueFlage.Text == "Y")
            {
                e.Row.Cells[12].BackColor = System.Drawing.Color.Red;
                e.Row.Cells[12].ForeColor = System.Drawing.Color.White;
                e.Row.Cells[12].Font.Bold = true;
            }
            if (lblNext30dayFlage.Text == "Y")
            {
                e.Row.Cells[12].BackColor = System.Drawing.Color.Orange;
                e.Row.Cells[12].ForeColor = System.Drawing.Color.Black;
                e.Row.Cells[12].Font.Bold = true;
            }
            if (lblCMS.Text == "Y")
            {
                e.Row.Cells[15].BackColor = System.Drawing.Color.Green;
                e.Row.Cells[15].ForeColor = System.Drawing.Color.White;
                e.Row.Cells[15].Font.Bold = true;
            }
            if (lblCritical.Text == "Y")
            {
                e.Row.Cells[16].BackColor = System.Drawing.Color.Red;
                e.Row.Cells[16].ForeColor = System.Drawing.Color.White;
                e.Row.Cells[16].Font.Bold = true;
            }
        }

        if (e.Row.RowType == DataControlRowType.DataRow)   //Reshma - Remaining Running Hours - when the remaining running hours are negative (meaning the job is overdue), this field (Rem. RHRS) should be painted red.
        {
            Label lblRemHrs = (Label)e.Row.FindControl("lblRemRHrsdone");
            if (lblRemHrs.Text != "")
            {
                if (Convert.ToInt32(lblRemHrs.Text.ToString()) < 0)
                {
                    e.Row.Cells[14].BackColor = System.Drawing.Color.Red;
                    e.Row.Cells[14].ForeColor = System.Drawing.Color.White;
                    e.Row.Cells[14].Font.Bold = true;
                }
            }
        }
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            Label       lblFilePathIfSingle = (Label)e.Row.FindControl("lblFilePathIfSingle");
            ImageButton ImgJobDoneAtt       = (ImageButton)e.Row.FindControl("ImgJobDoneAtt");

            if (lblFilePathIfSingle.Text != "")
            {
                ImgJobDoneAtt.Attributes.Add("onclick", "DocOpen('" + lblFilePathIfSingle.Text + "'); return false;");
            }
            else
            {
                ImgJobDoneAtt.Attributes.Add("onclick", "javascript:window.open('../PMS/PMSJobDone_Attachments.aspx?JobHistoryID=" + DataBinder.Eval(e.Row.DataItem, "JobHistoryID").ToString() + "&Vessel_ID=" + DataBinder.Eval(e.Row.DataItem, "VESSEL_ID").ToString() + "&OFFICE_ID=" + DataBinder.Eval(e.Row.DataItem, "OFFICE_ID").ToString() + "'); return false;");
            }
        }



        if (e.Row.RowType == DataControlRowType.Header)
        {
            MergeGridviewHeader.SetProperty(objPMSMerge);

            e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
            ViewState["DynamicHeaderCSS"] = "HeaderStyle-css";
        }


        if (e.Row.RowType == DataControlRowType.Header)
        {
            if (ViewState["SORTBYCOLOUMN"] != null)
            {
                HtmlImage img = (HtmlImage)e.Row.FindControl(ViewState["SORTBYCOLOUMN"].ToString());
                if (img != null)
                {
                    if (ViewState["SORTDIRECTION"] == null || ViewState["SORTDIRECTION"].ToString() == "0")
                    {
                        img.Src = "../../purchase/Image/arrowUp.png";
                    }

                    else
                    {
                        img.Src = "../../purchase/Image/arrowDown.png";
                    }

                    img.Visible = true;
                }
            }
        }
    }
예제 #26
0
    //protected void btnNewPO_Click(object sender, EventArgs e)
    //{
    //    int POID = 0;
    //    string POType = ddlPOType.SelectedValue;
    //    Response.Redirect("../ASL/PO_LOG.aspx?PO_ID=" + POID + "'&POType=" + POType + "'");
    //}
    protected void gvPO_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.Header)
        {
            MergeGridviewHeader.SetProperty(objChangeReqstMerge);
            e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
        }
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            ImageButton ImageButton    = (ImageButton)e.Row.FindControl("ImgView");
            Button      InvoiceButton  = (Button)e.Row.FindControl("btnInvoice");
            Button      DeliveryButton = (Button)e.Row.FindControl("btnDelivery");
            Image       ImgStatus      = (Image)e.Row.FindControl("ImgStatus");
            //LinkButton lblOffice = (LinkButton)e.Row.FindControl("lblOffice");
            Button btnSType         = (Button)e.Row.FindControl("btnSType");
            Label  lblInvoice_Value = (Label)e.Row.FindControl("lblInvoice");
            Label  lblCurrency      = (Label)e.Row.FindControl("lblCurrency");
            if (Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Invoice_Amount")) > Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "TotalAmount")))
            {
                lblInvoice_Value.ForeColor = System.Drawing.Color.Red;
            }
            else
            {
                lblInvoice_Value.ForeColor = System.Drawing.Color.Black;
            }
            if (DataBinder.Eval(e.Row.DataItem, "Supplier_Currency").ToString() != DataBinder.Eval(e.Row.DataItem, "Line_Currency").ToString())
            {
                if (DataBinder.Eval(e.Row.DataItem, "Supplier_Currency") != null)
                {
                    e.Row.Cells[4].BackColor = System.Drawing.Color.Violet;
                }
            }
            else
            {
                e.Row.Cells[4].BackColor = System.Drawing.Color.White;
            }
            if (DataBinder.Eval(e.Row.DataItem, "SType").ToString() == "")
            {
                btnSType.Visible = false;
            }
            if (DataBinder.Eval(e.Row.DataItem, "Line_Status").ToString() == "APPROVED")
            {
                InvoiceButton.Visible  = true;
                DeliveryButton.Visible = true;
                ImgStatus.Visible      = true;
                ImgStatus.ImageUrl     = "~/Images/Green_Check.bmp";
            }
            else if (DataBinder.Eval(e.Row.DataItem, "Line_Status").ToString() == "CANCELLED")
            {
                ImgStatus.Visible  = true;
                ImgStatus.ImageUrl = "~/Images/Delete.png";
            }
            else if (DataBinder.Eval(e.Row.DataItem, "PO_Closed_By").ToString() != "")
            {
                ImgStatus.Visible  = true;
                ImgStatus.ImageUrl = "~/Images/locked.bmp";
            }
            else
            {
                ImgStatus.Visible = false;
            }

            string ColorCode         = DataBinder.Eval(e.Row.DataItem, "COLOR_CODE").ToString();
            System.Drawing.Color col = System.Drawing.ColorTranslator.FromHtml(ColorCode);
            if (col.Name == "White")
            {
                e.Row.Cells[1].BackColor = col;
            }
            else
            {
                e.Row.Cells[1].BackColor = col;
                //lblOffice.ForeColor = System.Drawing.Color.Black;
            }

            e.Row.Attributes["onclick"] = Page.ClientScript.GetPostBackClientHyperlink(gvPO, "Select$" + e.Row.RowIndex);
            e.Row.Attributes["style"]   = "cursor:pointer";
        }
    }
예제 #27
0
 protected void gvApprovedInvoice_RowDataBound(object sender, GridViewRowEventArgs e)
 {
     if (e.Row.RowType == DataControlRowType.Header)
     {
         MergeGridviewHeader.SetProperty(objChangeReqstMerge);
         e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
     }
     if (e.Row.RowType == DataControlRowType.DataRow)
     {
         string ColorCode                  = DataBinder.Eval(e.Row.DataItem, "COLOR_CODE").ToString();
         System.Drawing.Color col          = System.Drawing.ColorTranslator.FromHtml(ColorCode);
         DateTime             Invoice_Date = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "Invoice_Date").ToString());
         DateTime             PO_Date      = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "Created_Date").ToString());
         //Button ViewRemarks = (Button)e.Row.FindControl("btnViewRemarks");
         LinkButton lblPO         = (LinkButton)e.Row.FindControl("lblPOCode");
         Label      lblUrgent     = (Label)e.Row.FindControl("lblUrgent");
         Label      lblUrgentFlag = (Label)e.Row.FindControl("lblUrgentFlag");
         Label      lblDispute    = (Label)e.Row.FindControl("lblDispute");
         Button     btnDispute    = (Button)e.Row.FindControl("btnApprovedDispute");
         int        result        = DateTime.Compare(PO_Date, Invoice_Date);
         if (result > 0)
         {
             e.Row.Cells[2].BackColor = System.Drawing.Color.Red;
             lblPO.ForeColor          = System.Drawing.Color.White;
         }
         else
         {
             e.Row.Cells[1].BackColor = col;
         }
         if (DataBinder.Eval(e.Row.DataItem, "Urgent_Flag").ToString() == "URGENT")
         {
             lblUrgent.Visible     = true;
             lblUrgentFlag.Visible = true;
         }
         else
         {
             lblUrgent.Visible     = false;
             lblUrgentFlag.Visible = false;
         }
         if (DataBinder.Eval(e.Row.DataItem, "Dispute_Flag").ToString() == "YES")
         {
             btnDispute.Text           = "Un-Dispute";
             lblDispute.Text           = DataBinder.Eval(e.Row.DataItem, "Dispute_Flag").ToString();
             lblDispute.ForeColor      = System.Drawing.Color.White;
             e.Row.Cells[19].BackColor = System.Drawing.Color.Red;
         }
         Label lblInvoice_Value    = (Label)e.Row.FindControl("lblInvoice_Value");
         Label lblInvoice_Currency = (Label)e.Row.FindControl("lblInvoice_Currency");
         if (Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Invoice_Value")) > Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "PO_Amount")))
         {
             lblInvoice_Value.ForeColor = System.Drawing.Color.Red;
         }
         else
         {
             lblInvoice_Value.ForeColor = System.Drawing.Color.Black;
         }
         if (DataBinder.Eval(e.Row.DataItem, "CURRENCY").ToString() != DataBinder.Eval(e.Row.DataItem, "Invoice_Currency").ToString())
         {
             e.Row.Cells[13].BackColor = System.Drawing.Color.Violet;
         }
         else
         {
             e.Row.Cells[13].BackColor = System.Drawing.Color.White;
         }
         if (DataBinder.Eval(e.Row.DataItem, "Supplier_Currency") != DataBinder.Eval(e.Row.DataItem, "CURRENCY"))
         {
             if (DataBinder.Eval(e.Row.DataItem, "Supplier_Currency") != null)
             {
                 e.Row.Cells[4].BackColor = System.Drawing.Color.Violet;
             }
         }
         else
         {
             e.Row.Cells[4].BackColor = System.Drawing.Color.White;
         }
     }
 }
예제 #28
0
    protected void gvPendingInvoice_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.Header)
        {
            MergeGridviewHeader.SetProperty(objChangeReqstMerge);
            e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
        }
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            string ColorCode         = DataBinder.Eval(e.Row.DataItem, "COLOR_CODE").ToString();
            System.Drawing.Color col = System.Drawing.ColorTranslator.FromHtml(ColorCode);

            DateTime   Invoice_Date        = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "Invoice_Date").ToString());
            DateTime   PO_Date             = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "Created_Date").ToString());
            DateTime   Payment_Due_Date    = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "Payment_Due_Date").ToString());
            Button     ViewRemarks         = (Button)e.Row.FindControl("btnViewRemarks");
            Label      lblUrgent           = (Label)e.Row.FindControl("lblUrgent");
            Label      lblUrgentFlag       = (Label)e.Row.FindControl("lblUrgentFlag");
            LinkButton lblSupplier         = (LinkButton)e.Row.FindControl("lbl_SupplierName");
            LinkButton lblPO               = (LinkButton)e.Row.FindControl("lblPOCode");
            Label      lblInvoiceStatus    = (Label)e.Row.FindControl("lblInvoice_Status");
            CheckBox   chkinvoice          = (CheckBox)e.Row.FindControl("chkInvoice");
            Label      lblDispute          = (Label)e.Row.FindControl("lblDispute");
            Button     btnDispute          = (Button)e.Row.FindControl("btnDispute");
            Label      lblDays             = (Label)e.Row.FindControl("lblDays");
            Label      lblPaymentDate      = (Label)e.Row.FindControl("lblPaymentDate");
            Label      lblInvoice_Value    = (Label)e.Row.FindControl("lblInvoice_Value");
            Label      lblInvoice_Currency = (Label)e.Row.FindControl("lblInvoice_Currency");
            if (Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Invoice_Value")) > Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "PO_Amount")))
            {
                lblInvoice_Value.ForeColor = System.Drawing.Color.Red;
            }
            else
            {
                lblInvoice_Value.ForeColor = System.Drawing.Color.Black;
            }
            if (DataBinder.Eval(e.Row.DataItem, "CURRENCY").ToString() != DataBinder.Eval(e.Row.DataItem, "Invoice_Currency").ToString())
            {
                e.Row.Cells[13].BackColor = System.Drawing.Color.Violet;
            }
            else
            {
                e.Row.Cells[13].BackColor = System.Drawing.Color.White;
            }
            if (DataBinder.Eval(e.Row.DataItem, "Supplier_Currency").ToString() != DataBinder.Eval(e.Row.DataItem, "CURRENCY").ToString())
            {
                if (DataBinder.Eval(e.Row.DataItem, "Supplier_Currency") != null)
                {
                    e.Row.Cells[4].BackColor = System.Drawing.Color.Violet;
                }
            }
            else
            {
                e.Row.Cells[4].BackColor = System.Drawing.Color.White;
            }
            if (DataBinder.Eval(e.Row.DataItem, "Urgent_Flag").ToString() == "URGENT")
            {
                lblUrgent.Visible     = true;
                lblUrgentFlag.Visible = true;
            }
            else
            {
                lblUrgent.Visible     = false;
                lblUrgentFlag.Visible = false;
            }
            int result = DateTime.Compare(PO_Date, Invoice_Date);
            if (result > 0)
            {
                e.Row.Cells[2].BackColor = System.Drawing.Color.Red;
                lblPO.ForeColor          = System.Drawing.Color.White;
            }
            else
            {
                e.Row.Cells[1].BackColor = col;
            }
            DateTime TDate = System.DateTime.Now;
            int      Diff  = DateTime.Compare(Payment_Due_Date, TDate);
            if (Diff > 0)
            {
                System.TimeSpan diffResult       = Payment_Due_Date - TDate;
                int             differenceInDays = diffResult.Days;
                lblDays.Text             = differenceInDays + " " + "Days";
                lblDays.ForeColor        = System.Drawing.Color.Black;
                lblPaymentDate.ForeColor = System.Drawing.Color.Black;
            }
            else
            {
                lblPaymentDate.ForeColor = System.Drawing.Color.Red;
            }
            if (DataBinder.Eval(e.Row.DataItem, "Invoice_Status").ToString() == "Approved")
            {
                e.Row.Cells[11].BackColor  = System.Drawing.Color.Green;
                lblInvoiceStatus.ForeColor = System.Drawing.Color.White;
                chkinvoice.Enabled         = true;
                lblDispute.Text            = "No Dispute";
                lblDispute.ForeColor       = System.Drawing.Color.Green;
            }
            else if (DataBinder.Eval(e.Row.DataItem, "Dispute_Flag").ToString() == "YES")
            {
                e.Row.Cells[11].BackColor  = System.Drawing.Color.White;
                lblInvoiceStatus.ForeColor = System.Drawing.Color.Black;
                chkinvoice.Enabled         = false;
                btnDispute.Text            = "Un-Dispute";
                lblDispute.Text            = DataBinder.Eval(e.Row.DataItem, "Dispute_Flag").ToString();
                lblDispute.ForeColor       = System.Drawing.Color.White;
                e.Row.Cells[19].BackColor  = System.Drawing.Color.Red;
                btnApprove.Enabled         = false;
            }
            else
            {
                e.Row.Cells[11].BackColor  = System.Drawing.Color.White;
                lblInvoiceStatus.ForeColor = System.Drawing.Color.Black;
                lblDispute.Text            = "No Dispute";
                lblDispute.ForeColor       = System.Drawing.Color.Green;
                btnDispute.Text            = "Dispute";
                chkinvoice.Enabled         = true;
            }
            if (DataBinder.Eval(e.Row.DataItem, "Dispute_Flag").ToString() == "YES")
            {
                chkinvoice.Enabled        = false;
                btnDispute.Text           = "Un-Dispute";
                lblDispute.Text           = DataBinder.Eval(e.Row.DataItem, "Dispute_Flag").ToString();
                lblDispute.ForeColor      = System.Drawing.Color.White;
                e.Row.Cells[19].BackColor = System.Drawing.Color.Red;
            }
        }
    }
예제 #29
0
    protected void gvVettingIndex_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        try
        {
            MergeGridviewHeader_Info objVetMerge = new MergeGridviewHeader_Info();
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                Label lblVettingId          = (Label)e.Row.FindControl("lblVetting_Id");
                Label lblOverDueRespondDate = (Label)e.Row.FindControl("lblOverDueRespondDate");
                Label lblOverDueValidDate   = (Label)e.Row.FindControl("lblOverDueValidDate");
                Label lblVettingStatus      = (Label)e.Row.FindControl("lblVetStatus");
                Label lblOpenCloseResponse  = (Label)e.Row.FindControl("lblResponse");

                Label lblVettingDate = (Label)e.Row.FindControl("lblVetDate");
                Label lblRespondDate = (Label)e.Row.FindControl("lblRespondDate");
                Label lblValidDate   = (Label)e.Row.FindControl("lblValidDate");

                HyperLink hplinkPendingJob   = (HyperLink)e.Row.FindControl("hplnkJobPending");
                HyperLink hplinkJobCompleted = (HyperLink)e.Row.FindControl("hplnkJobCompleted");
                HyperLink hplinkJobVerified  = (HyperLink)e.Row.FindControl("hplnkJobVerified");
                HyperLink hplinkJobDeffered  = (HyperLink)e.Row.FindControl("hplnkJobDeffered");
                HyperLink hplinkOpenJob      = (HyperLink)e.Row.FindControl("hplnkOpenObs");
                HyperLink hplinkCloseJob     = (HyperLink)e.Row.FindControl("hplnkClosedObs");
                HyperLink hplinkNote         = (HyperLink)e.Row.FindControl("hplnkNote");


                if (lblOverDueRespondDate.Text == "Y")
                {
                    e.Row.Cells[5].BackColor = System.Drawing.Color.Red;
                    e.Row.Cells[5].ForeColor = System.Drawing.Color.White;
                    e.Row.Cells[5].Font.Bold = true;
                }
                if (lblOverDueValidDate.Text == "Y")
                {
                    e.Row.Cells[6].BackColor = System.Drawing.Color.Red;
                    e.Row.Cells[6].ForeColor = System.Drawing.Color.White;
                    e.Row.Cells[6].Font.Bold = true;
                }

                ImageButton ImgDelete = (ImageButton)e.Row.FindControl("ImgDelete");
                HyperLink   ImgReport = (HyperLink)e.Row.FindControl("ImgReport");

                if (lblVettingStatus.Text == "Planned")
                {
                    ImgDelete.Visible = true;
                    ImgReport.Visible = false;
                }
                else
                {
                    ImgDelete.Visible = false;
                    ImgReport.Visible = true;
                }

                ImageButton ImgRework = (ImageButton)e.Row.FindControl("ImgRework");
                if (lblVettingStatus.Text == "Completed" || lblVettingStatus.Text == "Failed")
                {
                    ImgRework.Visible = true;
                }
                else
                {
                    ImgRework.Visible = false;
                }

                HyperLink ImgDetail = (HyperLink)e.Row.FindControl("ImgDetails");
                ImgDetail.NavigateUrl = "../Vetting/Vetting_Details.aspx?Vetting_Id=" + DataBinder.Eval(e.Row.DataItem, "Vetting_ID").ToString();


                if (lblVettingDate.Text != "")
                {
                    lblVettingDate.Text = UDFLib.ConvertUserDateFormat(lblVettingDate.Text, UDFLib.GetDateFormat());
                }
                if (lblRespondDate.Text != "")
                {
                    lblRespondDate.Text = UDFLib.ConvertUserDateFormat(lblRespondDate.Text, UDFLib.GetDateFormat());
                }
                if (lblValidDate.Text != "")
                {
                    lblValidDate.Text = UDFLib.ConvertUserDateFormat(lblValidDate.Text, UDFLib.GetDateFormat());
                }
                // if extra column is added need to changed in this condition
                for (int j = 0; j < 9; j++)
                {
                    // Row should be clickable
                    e.Row.Cells[j].Attributes.Add("onclick", "window.open('Vetting_Details.aspx?Vetting_Id=" + DataBinder.Eval(e.Row.DataItem, "Vetting_ID").ToString() + "','_blank');");
                    e.Row.Cells[j].Attributes.Add("style", "cursor:pointer;");
                    e.Row.Cells[j].Attributes["onmousedown"] = ClientScript.GetPostBackClientHyperlink(this.gvVettingIndex, "Select$" + e.Row.RowIndex);
                }

                // added hyperlink for response column
                e.Row.Cells[12].Attributes.Add("onclick", "window.open('Vetting_Details.aspx?Vetting_Id=" + DataBinder.Eval(e.Row.DataItem, "Vetting_ID").ToString() + "','_blank');");
                e.Row.Cells[12].Attributes.Add("style", "cursor:pointer;");
                e.Row.Cells[12].Attributes["onmousedown"] = ClientScript.GetPostBackClientHyperlink(this.gvVettingIndex, "Select$" + e.Row.RowIndex);
                for (int i = 9; i < e.Row.Controls.Count; i++)
                {
                    string ObsOpenCount, ObsCloseCount, NotesCount, ResponseCount, PendJobCount, CompJobCount, VerifiedJobCount, DefferedJobCount;

                    DataTable dtObservationCount     = (DataTable)ViewState["dtObservationCount"];
                    string    filteropnobsexpression = " Observation_Type_ID=2 and Status='Open' and Vetting_ID=" + lblVettingId.Text;
                    DataRow[] drObsOpenCount         = dtObservationCount.Select(filteropnobsexpression);
                    if (drObsOpenCount.Length <= 0)
                    {
                        ObsOpenCount       = "0";
                        hplinkOpenJob.Text = ObsOpenCount;
                    }
                    else
                    {
                        ObsOpenCount       = drObsOpenCount[0][0].ToString();
                        hplinkOpenJob.Text = ObsOpenCount;
                    }
                    string    filterclosedobsexpression = " Observation_Type_ID=2 and Status='Closed' and Vetting_ID=" + lblVettingId.Text;
                    DataRow[] drObsCloseCount           = dtObservationCount.Select(filterclosedobsexpression);
                    if (drObsCloseCount.Length <= 0)
                    {
                        ObsCloseCount       = "0";
                        hplinkCloseJob.Text = ObsCloseCount;
                    }
                    else
                    {
                        ObsCloseCount       = drObsCloseCount[0][0].ToString();
                        hplinkCloseJob.Text = ObsCloseCount;
                    }
                    DataTable dtNotesCount         = (DataTable)ViewState["dtNotesCount"];
                    string    filternoteexpression = " Observation_Type_ID=1 and Vetting_ID=" + lblVettingId.Text;
                    DataRow[] drNotesCount         = dtNotesCount.Select(filternoteexpression);
                    if (drNotesCount.Length <= 0)
                    {
                        NotesCount      = "0";
                        hplinkNote.Text = NotesCount;
                    }
                    else
                    {
                        NotesCount      = drNotesCount[0][0].ToString();
                        hplinkNote.Text = NotesCount;
                    }
                    DataTable dtResponseCount          = (DataTable)ViewState["dtResponse"];
                    string    filterresponseexpression = "Vetting_ID=" + lblVettingId.Text;
                    DataRow[] drResponseCount          = dtResponseCount.Select(filterresponseexpression);
                    if (drResponseCount.Length <= 0)
                    {
                        ResponseCount             = "0";
                        lblOpenCloseResponse.Text = ResponseCount;
                    }
                    else
                    {
                        ResponseCount             = drResponseCount[0][0].ToString();
                        lblOpenCloseResponse.Text = ResponseCount;
                    }
                    DataTable dtJobCount = (DataTable)ViewState["dtJobsCount"];
                    string    filterpendjobexpression = " Vetting_ID=" + lblVettingId.Text + " and Job_Status='PENDING'";
                    DataRow[] drPendJobCount          = dtJobCount.Select(filterpendjobexpression);
                    if (drPendJobCount.Length <= 0)
                    {
                        PendJobCount          = "0";
                        hplinkPendingJob.Text = PendJobCount;
                    }
                    else
                    {
                        PendJobCount          = drPendJobCount[0][0].ToString();
                        hplinkPendingJob.Text = PendJobCount;
                    }
                    string    filtercompletedjobexpression = " Vetting_ID=" + lblVettingId.Text + " and Job_Status='COMPLETED'";
                    DataRow[] drComplJobCount = dtJobCount.Select(filtercompletedjobexpression);
                    if (drComplJobCount.Length <= 0)
                    {
                        CompJobCount            = "0";
                        hplinkJobCompleted.Text = CompJobCount;
                    }
                    else
                    {
                        CompJobCount            = drComplJobCount[0][0].ToString();
                        hplinkJobCompleted.Text = CompJobCount;
                    }
                    string    filterverifiedjobexpression = " Vetting_ID=" + lblVettingId.Text + " and Job_Status='VERIFY'";
                    DataRow[] drVerifiedJobCount          = dtJobCount.Select(filterverifiedjobexpression);
                    if (drVerifiedJobCount.Length <= 0)
                    {
                        VerifiedJobCount       = "0";
                        hplinkJobVerified.Text = VerifiedJobCount;
                    }
                    else
                    {
                        VerifiedJobCount       = drVerifiedJobCount[0][0].ToString();
                        hplinkJobVerified.Text = VerifiedJobCount;
                    }
                    string    filterdefferedjobexpression = " Vetting_ID=" + lblVettingId.Text + " and Job_Status='DEFERRED'";
                    DataRow[] drDefferedJobCount          = dtJobCount.Select(filterdefferedjobexpression);
                    if (drDefferedJobCount.Length <= 0)
                    {
                        DefferedJobCount       = "0";
                        hplinkJobDeffered.Text = DefferedJobCount;
                    }
                    else
                    {
                        DefferedJobCount       = drDefferedJobCount[0][0].ToString();
                        hplinkJobDeffered.Text = DefferedJobCount;
                    }
                }
            }
            if (e.Row.RowType == DataControlRowType.Header)
            {
                MergeGridviewHeader.SetProperty(objVetMerge);

                e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
                ViewState["DynamicHeaderCSS"] = "GroupHeaderStyle-css HeaderStyle-css";
            }
        }
        catch (Exception ex)
        {
            UDFLib.WriteExceptionLog(ex);
            string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');";
            ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true);
        }
    }
예제 #30
0
    protected void gvMachinery_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        try
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                Label lblDiffSysDescFlag       = (Label)e.Row.FindControl("lblDiffSysDescFlag");
                Label lblDiffSysParticularFlag = (Label)e.Row.FindControl("lblDiffSysPartFlag");
                Label lblDiffSetInstalledFlag  = (Label)e.Row.FindControl("lblDiffSetInstalledFlag");
                Label lblDiffModelFlag         = (Label)e.Row.FindControl("lblDiffModelFlag");
                Label lblSystemParticular      = (Label)e.Row.FindControl("lblSystemParticular");
                Label lblCRSystemParticular    = (Label)e.Row.FindControl("lblCRSystemParticular");
                Label lblSystemName            = (Label)e.Row.FindControl("lblSystemName");
                Label lblCRSystemName          = (Label)e.Row.FindControl("lblCRSystemName");
                Label lblAddNewFlag            = (Label)e.Row.FindControl("lblAddNewFlag");
                Label lbl_CR_Actual            = (Label)e.Row.FindControl("lbl_CR_Actual");
                Label lblChangeReqstID         = (Label)e.Row.FindControl("lblChangeReqstID");
                Label lblVesselCode            = (Label)e.Row.FindControl("lblVesselCode");



                lblSystemName.Attributes.Add("Title", "cssbody=[dvbdy1] cssheader=[dvhdr1] header=[Particulars] body=[" + lblSystemParticular.Text + "]");
                if (lbl_CR_Actual.Text != "")
                {
                    lblCRSystemName.Attributes.Add("Title", "cssbody=[dvbdy1] cssheader=[dvhdr1] header=[Change Reqst Actual] body=[" + lbl_CR_Actual.Text + "]");
                }


                if (lblDiffSysDescFlag.Text == "N")
                {
                    e.Row.Cells[2].ForeColor = System.Drawing.Color.Blue;
                    e.Row.Cells[6].ForeColor = System.Drawing.Color.Blue;
                }
                if (lblDiffSetInstalledFlag.Text == "N")
                {
                    e.Row.Cells[4].ForeColor = System.Drawing.Color.Blue;
                    e.Row.Cells[8].ForeColor = System.Drawing.Color.Blue;
                }
                if (lblDiffModelFlag.Text == "N")
                {
                    e.Row.Cells[5].ForeColor = System.Drawing.Color.Blue;
                    e.Row.Cells[9].ForeColor = System.Drawing.Color.Blue;
                }

                if (lblAddNewFlag.Text == "Y")
                {
                }
            }

            if (e.Row.RowType == DataControlRowType.Header)
            {
                MergeGridviewHeader.SetProperty(objChangeReqstMerge);

                e.Row.SetRenderMethodDelegate(MergeGridviewHeader.RenderHeader);
            }


            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                ImageButton ImgApprove = (ImageButton)e.Row.FindControl("ImgApprove");
                if (ImgApprove != null)
                {
                    ImgApprove.Attributes.Add("onclick", "javascript:OpenRequestDetails(" + DataBinder.Eval(e.Row.DataItem, "Vessel_ID").ToString() + ", " + DataBinder.Eval(e.Row.DataItem, "ID").ToString() + " , '" + DataBinder.Eval(e.Row.DataItem, "Status").ToString() + "'); return false;");
                }
            }


            if (e.Row.RowType == DataControlRowType.Header)
            {
                if (ViewState["SORTBYCOLOUMN"] != null)
                {
                    HtmlImage img = (HtmlImage)e.Row.FindControl(ViewState["SORTBYCOLOUMN"].ToString());
                    if (img != null)
                    {
                        if (ViewState["SORTDIRECTION"] == null || ViewState["SORTDIRECTION"].ToString() == "0")
                        {
                            img.Src = "~/purchase/Image/arrowUp.png";
                        }
                        else
                        {
                            img.Src = "~/purchase/Image/arrowDown.png";
                        }

                        img.Visible = true;
                    }
                }
            }
        }
        catch (Exception ex)
        {
            UDFLib.WriteExceptionLog(ex);
            string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');";
            ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true);
        }
    }