Tuesday, 26 March 2013

Repeter row and column color in item data bind time

 protected void rptVoucherPostingsAgainstLedger_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            HtmlTableRow itemRow = (HtmlTableRow)e.Item.FindControl("itemDataRow");
            if (DataBinder.Eval(e.Item.DataItem, "LedgerName").ToString() == lblLedgerName.Text)
            {
                itemRow.BgColor = "LightGray";
                HtmlTableCell htDebitCell = (HtmlTableCell)e.Item.FindControl("itemDebitCell");
                HtmlTableCell htCreditCell = (HtmlTableCell)e.Item.FindControl("itemCreditCell");

                if (DataBinder.Eval(e.Item.DataItem, "LedgerTotalDebitAmount").ToString() != "0.00")
                    htDebitCell.BgColor = "LightGreen";

                if (DataBinder.Eval(e.Item.DataItem, "LedgerTotalCreditAmount").ToString() != "0.00")
                    htCreditCell.BgColor = "Orange";
            }
            else
            {
                itemRow.BgColor = "White";
            }
        }
    }

Monday, 25 March 2013

Repeater row color at data bind time

protected void rptVoucherPostingsAgainstLedger_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            if (DataBinder.Eval(e.Item.DataItem, "LedgerName").ToString() == lblLedgerName.Text)
            {
                HtmlTableRow row1 = (HtmlTableRow)e.Item.FindControl("tRow");
                row1.BgColor = "Gray";
            }
            else
            {
                HtmlTableRow row1 = (HtmlTableRow)e.Item.FindControl("tRow");
                row1.BgColor = "White";
            }
        }

    }

Friday, 22 March 2013

Grid View Data Binder

 if (((GridViewRow)e.Row).RowType == DataControlRowType.Header) return;
        if (((GridViewRow)e.Row).RowType == DataControlRowType.Footer)
        {
            ((Label)((GridViewRow)e.Row).FindControl("lblDebit")).Text = viewStateLedgerBook.GroupBy(ledgerName => ledgerName.LedgerName).Select(ledgerName => ledgerName.First()).Sum(totalDebitAmount => totalDebitAmount.LedgerTotalDebitAmount).ToString();//1 Total Debit Amount
            ((Label)((GridViewRow)e.Row).FindControl("lblCredit")).Text = viewStateLedgerBook.GroupBy(ledgerName => ledgerName.LedgerName).Select(ledgerName => ledgerName.First()).Sum(totalCreditAmount => totalCreditAmount.LedgerTotalCreditAmount).ToString();//2 Total Credit Amount          
        }