예제 #1
0
        void grdLister_ContextMenuOpening(object sender, ContextMenuOpeningEventArgs e)
        {
            try
            {
                GridDataCellElement cell = e.ContextMenuProvider as GridDataCellElement;
                if (cell == null)
                {
                    return;
                }

                else if (cell.GridControl.Name == "grdLister")
                {
                    if (menu_Job == null)
                    {
                        menu_Job = new RadDropDownMenu();


                        RadMenuItem viewJobItem1 = new RadMenuItem("View Job");
                        viewJobItem1.ForeColor = Color.DarkBlue;
                        viewJobItem1.BackColor = Color.Orange;
                        viewJobItem1.Font      = new Font("Tahoma", 10, FontStyle.Bold);

                        viewJobItem1.Click += new EventHandler(viewJobItem1_Click);
                        menu_Job.Items.Add(viewJobItem1);
                    }

                    e.ContextMenu = menu_Job;
                    return;
                }
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
예제 #2
0
        void grdLister_ContextMenuOpening(object sender, ContextMenuOpeningEventArgs e)
        {
            try
            {
                GridDataCellElement cell = e.ContextMenuProvider as GridDataCellElement;
                if (cell == null)
                {
                    return;
                }

                if (statsContextMenu == null)
                {
                    statsContextMenu = new RadDropDownMenu();

                    RadMenuItem menu_showJobs = new RadMenuItem("Show Bookings");
                    menu_showJobs.ForeColor = Color.Blue;
                    menu_showJobs.BackColor = Color.Blue;
                    menu_showJobs.Font      = new Font("Tahoma", 10, FontStyle.Bold);
                    menu_showJobs.Click    += new EventHandler(menu_showJobs_Click);
                    statsContextMenu.Items.Add(menu_showJobs);
                }

                e.ContextMenu = statsContextMenu;
            }
            catch (Exception ex)
            {
                //   ENUtils.ShowMessage(ex.Message);
            }
        }
예제 #3
0
        private void radGridView1_ToolTipTextNeeded(object sender, ToolTipTextNeededEventArgs e)
        {
            GridDataCellElement dataCell = sender as GridDataCellElement;

            if (dataCell != null)
            {
                e.ToolTipText = string.Format("Column: {0}, Row: {1}", dataCell.ColumnIndex, dataCell.RowIndex);
            }
        }
예제 #4
0
        private void radTextBoxCellContent_TextChanged(object sender, EventArgs e)
        {
            GridDataCellElement cell = gridView.CurrentCell;

            if (cell != null)
            {
                cell.Value = this.radTextBoxCellContent.Text;
            }
        }
예제 #5
0
        private void radGridView1_ScreenTipNeeded(object sender, Telerik.WinControls.ScreenTipNeededEventArgs e)
        {
            GridDataCellElement cell = e.Item as GridDataCellElement;

            if (cell != null)
            {
                this.ShowScreenTipForCell(cell);
            }
        }
예제 #6
0
        void closeButton_Click(object sender, EventArgs e)
        {
            ClosePopup();
            GridDataCellElement cell = this.Parent as GridDataCellElement;

            if (cell != null)
            {
                cell.GridViewElement.EndEdit();
            }
        }
예제 #7
0
        private void radGridView1_CellMouseMove(object sender, MouseEventArgs e)
        {
            GridDataCellElement cell = sender as GridDataCellElement;

            if (cell == null)
            {
                return;
            }
            radLabel3.Text = string.Format("CellMouseMove: {0} [{1}, btn: {2}]", cell.Value, e.Location, e.Button);
        }
예제 #8
0
        private void OnPreviewDragDrop(object sender, Telerik.WinControls.RadDropEventArgs e)
        {
            GridDataCellElement dataCell = e.HitTarget as GridDataCellElement;

            if (dataCell != null)
            {
                TreeNodeElement element = e.DragInstance as TreeNodeElement;
                dataCell.Value = element.Data.Name;
                e.Handled      = true;
            }
        }
 private void RadExtendedGridViewController_MouseDown(object sender, MouseEventArgs e)
 {
     if (e.Button == MouseButtons.Right)
     {
         var element = this.ElementTree.GetElementAtPoint(e.Location);
         GridDataCellElement cell = element as GridDataCellElement;
         if (cell?.RowElement is GridDataRowElement)
         {
             Rows[cell.RowIndex].IsSelected = true;
         }
     }
 }
예제 #10
0
        private void OnPreviewDragOver(object sender, Telerik.WinControls.RadDragOverEventArgs e)
        {
            GridDataCellElement dataCell = e.HitTarget as GridDataCellElement;

            if (dataCell != null)
            {
                TreeNodeElement element = e.DragInstance as TreeNodeElement;

                object value = null;
                e.CanDrop = RadDataConverter.Instance.TryParse(dataCell as IDataConversionInfoProvider,
                                                               element.Data.Name, out value) == null;
            }
        }
        void grdSelectedPostCodes_ContextMenuOpening(object sender, ContextMenuOpeningEventArgs e)
        {
            try
            {
                GridDataCellElement cell = e.ContextMenuProvider as GridDataCellElement;
                if (cell == null)
                {
                    e.Cancel = true;
                    return;
                }
                else if (cell.GridControl.Name == "grdSelectedPostCodes")
                {
                    if (Update == null)
                    {
                        Update           = new RadDropDownMenu();
                        Update.BackColor = Color.Orange;

                        RadMenuItem UpdateCurrent = new RadMenuItem("Update Coordinates");
                        UpdateCurrent.ForeColor = Color.DarkBlue;
                        UpdateCurrent.BackColor = Color.Orange;
                        UpdateCurrent.Font      = new Font("Tahoma", 10, FontStyle.Bold);

                        UpdateCurrent.Click += new EventHandler(UpdateCurrent_Click);
                        Update.Items.Add(UpdateCurrent);


                        RadMenuItem UpdateUp = new RadMenuItem("Move Up");
                        UpdateUp.ForeColor = Color.DarkBlue;
                        UpdateUp.BackColor = Color.Orange;
                        UpdateUp.Font      = new Font("Tahoma", 10, FontStyle.Bold);
                        UpdateUp.Click    += new EventHandler(UpdateUp_Click);
                        Update.Items.Add(UpdateUp);


                        RadMenuItem UpdateDown = new RadMenuItem("Move Down");
                        UpdateDown.ForeColor = Color.DarkBlue;
                        UpdateDown.BackColor = Color.Orange;
                        UpdateDown.Font      = new Font("Tahoma", 10, FontStyle.Bold);
                        UpdateDown.Click    += new EventHandler(UpdateDown_Click);
                        Update.Items.Add(UpdateDown);
                    }

                    e.ContextMenu = Update;
                    return;
                }
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
예제 #12
0
        private void gridMyCollection_ScreenTipNeeded(object sender, ScreenTipNeededEventArgs e)
        {
            e.Delay = 1;
            GridDataCellElement cell = e.Item as GridDataCellElement;

            Card card = (Card)cell?.RowInfo.DataBoundItem;

            if (card?.Img == null)
            {
                return;
            }

            cell.ScreenTip = GetScreenTip(card);
        }
예제 #13
0
        private void gridCardValuation_ScreenTipNeeded(object sender, ScreenTipNeededEventArgs e)
        {
            e.Delay = 1;
            GridDataCellElement cell = e.Item as GridDataCellElement;

            Valuation valuation = (Valuation)cell?.RowInfo.DataBoundItem;

            if (valuation?.Card.Img == null)
            {
                return;
            }

            cell.ScreenTip = GetScreenTip(valuation.Card);
        }
예제 #14
0
        private void gvDailyMeasures_ToolTipTextNeeded(object sender, ToolTipTextNeededEventArgs e)
        {
            GridDataCellElement cell = sender as GridDataCellElement;

            if (cell != null)
            {
                var measure = cell.RowElement.Data.DataBoundItem as DailyStandardMeasure;

                if (!CanEditMeasure(measure))
                {
                    e.ToolTipText =
                        Resources.MeasureNotEditable;
                }
            }
        }
예제 #15
0
        private void radGridView2_ContextMenuOpening(object sender, Telerik.WinControls.UI.ContextMenuOpeningEventArgs e)
        {
            GridDataCellElement cell = e.ContextMenuProvider as GridDataCellElement;

            if ((bool)radGridView2.Rows[cell.RowIndex].Cells["IsCheckOut"].Value)
            {
                menu.Items[2].Enabled = true;
                menu.Items[1].Enabled = false;
            }
            else
            {
                menu.Items[2].Enabled = false;
                menu.Items[1].Enabled = true;
            }
            e.ContextMenu = menu.DropDown;
        }
예제 #16
0
        private void grid_CellFormatting(object sender, CellFormattingEventArgs e)
        {
            GridDataCellElement dataCell = e.CellElement as GridDataCellElement;

            if (dataCell != null && dataCell.ColumnInfo.Name == "Name" && dataCell.RowElement is GridDataRowElement)
            {
                if (boldFont == null)
                {
                    boldFont = new Font(dataCell.Font, FontStyle.Bold);
                }

                dataCell.Font = boldFont;
            }
            else
            {
                e.CellElement.ResetValue(LightVisualElement.FontProperty, ValueResetFlags.Local);
            }
        }
예제 #17
0
        private void radGridView1_CellFormatting(object sender, CellFormattingEventArgs e)
        {
            GridDataCellElement cell = e.CellElement as GridDataCellElement;

            if (cell != null)
            {
                if (cell.ColumnInfo.Name == "Notes")
                {
                    cell.Font    = italicFont;
                    cell.Padding = new Padding(4);
                }
                else
                {
                    cell.ResetValue(LightVisualElement.FontProperty, ValueResetFlags.Local);
                    cell.ResetValue(LightVisualElement.PaddingProperty, ValueResetFlags.Local);
                }
            }
        }
        void grdLister_ContextMenuOpening(object sender, ContextMenuOpeningEventArgs e)
        {
            try
            {
                GridDataCellElement cell = e.ContextMenuProvider as GridDataCellElement;
                if (cell == null)
                {
                    return;
                }

                else if (cell.GridControl.Name == "grdLister")
                {
                    e.ContextMenu = menu;
                    return;
                }
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
예제 #19
0
        private void radGridView1_ScreenTipNeeded(object sender, ScreenTipNeededEventArgs e)
        {
            e.Delay = 1;
            GridDataCellElement cell = e.Item as GridDataCellElement;

            KeyValuePair <Card, int>?card = (KeyValuePair <Card, int>?)cell?.RowInfo.DataBoundItem;

            if (card?.Key.Img == null)
            {
                return;
            }

            byte[]       bytes = _wc.DownloadData(card.Value.Key.Img);
            MemoryStream ms    = new MemoryStream(bytes);

            _screenTip.MainTextLabel.Image  = Image.FromStream(ms);
            _screenTip.MainTextLabel.Text   = "";
            _screenTip.CaptionVisible       = false;
            _screenTip.FooterVisible        = false;
            _screenTip.MainTextLabel.Margin = new Padding(-5, -35, -15, -20);

            _screenTip.AutoSize = true;
            cell.ScreenTip      = _screenTip;
        }
        private int GetTargetCellIndex(GridDataCellElement cell, Point dropLocation)
        {
            int halfHeight = cell.Size.Height / 2;
            int index = cell.RowInfo.Index;
            if (dropLocation.Y > halfHeight)
            {
                index++;
            }

            return index;
        }
예제 #21
0
        private void dgvProducts_ContextMenuOpening(object sender, Telerik.WinControls.UI.ContextMenuOpeningEventArgs e)
        {
            GridDataCellElement cell = e.ContextMenuProvider as GridDataCellElement;

            productID = cell.RowInfo.Cells["ProductID"].Value.ToInt();
        }
        void grdLister_ContextMenuOpening(object sender, ContextMenuOpeningEventArgs e)
        {
            try
            {
                GridDataCellElement cell = e.ContextMenuProvider as GridDataCellElement;
                if (cell == null)
                {
                    return;
                }

                else if (cell.GridControl.Name == "grdLister")
                {
                    if (EditFare == null)
                    {
                        EditFare           = new RadDropDownMenu();
                        EditFare.BackColor = Color.Orange;

                        RadMenuItem EditFareItem1 = new RadMenuItem("Edit Fare");
                        EditFareItem1.ForeColor = Color.DarkBlue;
                        EditFareItem1.BackColor = Color.Orange;
                        EditFareItem1.Font      = new Font("Tahoma", 10, FontStyle.Bold);

                        EditFareItem1.Click += new EventHandler(EditFareItem1_Click);
                        EditFare.Items.Add(EditFareItem1);


                        //RadMenuItem EditFareItem2 = new RadMenuItem("Arrival Text");
                        //EditFareItem2.ForeColor = Color.DarkBlue;
                        //EditFareItem2.BackColor = Color.Orange;
                        //EditFareItem2.Font = new Font("Tahoma", 10, FontStyle.Bold);
                        //EditFareItem2.Click += new EventHandler(EditFareItem2_Click);
                        //EditFare.Items.Add(EditFareItem2);


                        //EditFareItem2 = new RadMenuItem("SMS Job Details");
                        //EditFareItem2.ForeColor = Color.DarkBlue;
                        //EditFareItem2.BackColor = Color.Orange;
                        //EditFareItem2.Font = new Font("Tahoma", 10, FontStyle.Bold);
                        //EditFareItem2.Click += new EventHandler(SMSJob_Click);
                        //EditFare.Items.Add(EditFareItem2);


                        //EditFareItem1 = new RadMenuItem("Complete Job");
                        //EditFareItem1.ForeColor = Color.Black;
                        //EditFareItem1.Font = new Font("Tahoma", 10, FontStyle.Bold);
                        //EditFareItem1.Click += new EventHandler(ForceCompleteJob_Click);
                        //EditFare.Items.Add(EditFareItem1);


                        RadMenuItem EditFareItem3 = new RadMenuItem("View Job");
                        EditFareItem3.ForeColor = Color.DarkBlue;
                        EditFareItem3.BackColor = Color.Orange;
                        EditFareItem3.Font      = new Font("Tahoma", 10, FontStyle.Bold);
                        EditFareItem3.Click    += new EventHandler(EditFareItem3_Click);
                        EditFare.Items.Add(EditFareItem3);
                    }

                    e.ContextMenu = EditFare;
                    return;
                }
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
예제 #23
0
        private void radGridView1_ContextMenuOpening(object sender, ContextMenuOpeningEventArgs e)
        {
            GridDataCellElement cell = e.ContextMenuProvider as GridDataCellElement;

            e.ContextMenu = menuParent.DropDown;
        }
        void grdLister_ContextMenuOpening(object sender, ContextMenuOpeningEventArgs e)
        {
            try
            {
                GridDataCellElement cell = e.ContextMenuProvider as GridDataCellElement;
                if (cell == null)
                {
                    return;
                }

                else if (cell.ColumnInfo.Name == "BackupPlot1" || cell.ColumnInfo.Name == "BackupPlot2")
                {
                    if (contextMenu == null)
                    {
                        contextMenu           = new RadDropDownMenu();
                        contextMenu.BackColor = Color.Orange;

                        RadMenuItem item1 = new RadMenuItem("High Priority");
                        item1.ForeColor = Color.DarkBlue;
                        item1.BackColor = Color.Orange;
                        item1.Font      = new Font("Tahoma", 10, FontStyle.Bold);

                        item1.Click += new EventHandler(item1_Click);
                        contextMenu.Items.Add(item1);


                        RadMenuItem item2 = new RadMenuItem("Mark All Bidding");
                        item2.ForeColor = Color.DarkBlue;
                        item2.BackColor = Color.Orange;
                        item2.Font      = new Font("Tahoma", 10, FontStyle.Bold);

                        item2.Click += new EventHandler(item2_Click);
                        contextMenu.Items.Add(item2);


                        RadMenuItem item3 = new RadMenuItem("UnMark All Bidding");
                        item3.ForeColor = Color.DarkBlue;
                        item3.BackColor = Color.Orange;
                        item3.Font      = new Font("Tahoma", 10, FontStyle.Bold);
                        item3.Click    += new EventHandler(item3_Click);
                        contextMenu.Items.Add(item3);



                        RadMenuItem item4 = new RadMenuItem("Mark All AutoDespatch");
                        item4.ForeColor = Color.DarkBlue;
                        item4.BackColor = Color.Orange;
                        item4.Font      = new Font("Tahoma", 10, FontStyle.Bold);

                        item4.Click += new EventHandler(item4_Click);
                        contextMenu.Items.Add(item4);


                        RadMenuItem item5 = new RadMenuItem("UnMark All AutoDespatch");
                        item5.ForeColor = Color.DarkBlue;
                        item5.BackColor = Color.Orange;
                        item5.Font      = new Font("Tahoma", 10, FontStyle.Bold);
                        item5.Click    += new EventHandler(item5_Click);
                        contextMenu.Items.Add(item5);
                    }

                    e.ContextMenu = contextMenu;
                    return;
                }
            }
            catch (Exception ex)
            {
                ENUtils.ShowMessage(ex.Message);
            }
        }
예제 #25
0
        private void ShowScreenTipForCellStats(GridDataCellElement cell)
        {
            if (cell == null)
            {
                return;
            }

            try
            {
                GridViewRowInfo row = cell.RowElement.RowInfo;

                if (row != null && row is GridViewDataRowInfo)
                {
                    int Id                 = row.Cells["Id"].Value.ToInt();
                    int companyId          = row.Cells[COLS.CompanyId].Value.ToInt();
                    List <vu_Invoice> list = null;

                    using (TaxiDataContext db = new TaxiDataContext())
                    {
                        list = db.vu_Invoices.Where(c => c.Id == Id).ToList();


                        if (TemplateName == "0")
                        {
                            TemplateName = db.UM_Form_Templates.FirstOrDefault(c => c.UM_Form.FormName == "frmInvoiceReport" && c.IsDefault == true).DefaultIfEmpty().TemplateName.ToStr();
                        }
                    }

                    if (list.Count > 0)
                    {
                        var data = list.FirstOrDefault().DefaultIfEmpty();



                        decimal netAmount = 0.00m;

                        decimal invoiceGrandTotal = netAmount + data.AdminFees.ToDecimal();

                        //NC
                        //Changes Area for VAT start here.
                        decimal invoiceGrandTotal2 = 0.00m;//= (netAmount + data.AdminFees.ToDecimal());
                        decimal NetCharges         = 0.0m;



                        decimal DriverCostNonVAT    = 0.0m;
                        decimal BusinessCharge      = 0.0m;
                        decimal VatOnBusinessCharge = 0.0m;
                        decimal TotalGPB            = 0.0m;
                        //

                        if (TemplateName.ToStr() == "Template13" || TemplateName.ToStr() == "Template14" || TemplateName.ToStr() == "Template24")
                        {
                            if (TemplateName.ToStr() == "Template13" || TemplateName.ToStr() == "Template24")
                            {
                                netAmount = list.Where(c => c.PaymentTypeId.ToInt() != 6)
                                            .Sum(c => c.Charges.ToDecimal() + c.WaitingCharges.ToDecimal());
                                //  NetCharges = list.Where(c => c.VehicleType != "Saloon" && c.PaymentTypeId.ToInt() != 6).Sum(c => c.Charges.ToDecimal() + c.WaitingCharges.ToDecimal());
                            }
                            else if (TemplateName.ToStr() == "Template14")
                            {
                                netAmount = list.Where(c => c.PaymentTypeId.ToInt() != 6)
                                            .Sum(c => c.Charges.ToDecimal() + c.WaitingCharges.ToDecimal() + c.ParkingCharges.ToDecimal() + c.ExtraDropCharges.ToDecimal());

                                //  NetCharges = list.Where(c => c.VehicleType != "Saloon" && c.PaymentTypeId.ToInt() != 6).Sum(c => c.Charges.ToDecimal() + c.WaitingCharges.ToDecimal() + c.ParkingCharges.ToDecimal() + c.ExtraDropCharges.ToDecimal());
                            }

                            invoiceGrandTotal = netAmount;
                        }
                        else if (TemplateName.ToStr() == "Template17")
                        {
                            NetCharges = list.Where(c => c.VehicleType != "Coach" && c.PaymentTypeId.ToInt() != 6).Sum(c => c.Charges.ToDecimal() + c.WaitingCharges.ToDecimal() + c.ParkingCharges.ToDecimal() + c.ExtraDropCharges.ToDecimal());
                            netAmount  = list.Where(c => c.PaymentTypeId.ToInt() != 6)
                                         .Sum(c => c.Charges.ToDecimal() + c.ExtraDropCharges.ToDecimal() + c.ParkingCharges.ToDecimal() + c.WaitingCharges.ToDecimal() + c.MeetAndGreetCharges.ToDecimal() + c.CongtionCharges.ToDecimal());

                            // NetCharges = list.Where(c => c.VehicleType != "Coach" && c.PaymentTypeId.ToInt() != 6).Sum(c => c.Charges.ToDecimal() + c.ExtraDropCharges.ToDecimal() + c.ParkingCharges.ToDecimal() + c.WaitingCharges.ToDecimal() + c.MeetAndGreetCharges.ToDecimal() + c.CongtionCharges.ToDecimal());

                            invoiceGrandTotal = NetCharges + data.AdminFees.ToDecimal();
                            //  invoiceGrandTotal = netAmount + data.AdminFees.ToDecimal();
                            invoiceGrandTotal2 = netAmount + data.AdminFees.ToDecimal();
                        }
                        //else if(&& this.ExportFileType.ToStr().ToLower() == "excel")
                        else if (TemplateName.ToStr() == "Template18")
                        {
                            netAmount = list.Where(c => c.PaymentTypeId.ToInt() != 6)
                                        .Sum(c => c.Charges.ToDecimal() + c.ExtraDropCharges.ToDecimal() + c.ParkingCharges.ToDecimal() + c.WaitingCharges.ToDecimal());
                            invoiceGrandTotal = netAmount + data.AdminFees.ToDecimal();
                            //NC
                            //valueAddedTax = (invoiceGrandTotal * 20) / 100;
                            DriverCostNonVAT = ((invoiceGrandTotal * 80) / 100);
                            BusinessCharge   = ((invoiceGrandTotal * 20) / 100);

                            VatOnBusinessCharge = ((BusinessCharge) * 20 / 100);
                            TotalGPB            = (DriverCostNonVAT + BusinessCharge + VatOnBusinessCharge);
                            // valueAddedTax
                        }
                        else if (TemplateName.ToStr() == "Template10" || TemplateName.ToStr() == "Template25" ||
                                 TemplateName.ToStr() == "Template27")
                        {
                            netAmount = list.Where(c => c.PaymentTypeId.ToInt() != 6)
                                        .Sum(c => c.Charges.ToDecimal() + c.ParkingCharges.ToDecimal() + c.WaitingCharges.ToDecimal());


                            invoiceGrandTotal = netAmount + data.AdminFees.ToDecimal();
                        }
                        else if (TemplateName.ToStr() == "Template21")
                        {
                            netAmount = list.Where(c => c.PaymentTypeId.ToInt() != 6)
                                        .Sum(c => c.Charges.ToDecimal());


                            invoiceGrandTotal = netAmount + data.AdminFees.ToDecimal();
                        }


                        else
                        {
                            netAmount = list.Where(c => c.PaymentTypeId.ToInt() != 6)
                                        .Sum(c => c.Charges.ToDecimal() + c.ExtraDropCharges.ToDecimal() + c.ParkingCharges.ToDecimal() + c.WaitingCharges.ToDecimal());


                            invoiceGrandTotal = netAmount + data.AdminFees.ToDecimal();
                        }


                        string  vat              = "0";
                        decimal discountAmount   = 0.00m;
                        decimal DiscountPercent  = 0.00m;
                        decimal valueAddedTax    = 0.0m;
                        decimal AdminFeesPercent = 0.00m;
                        decimal AdminFees        = 0.00m;
                        string  HasAdminFees     = string.Empty;
                        string  HasDiscount      = "0";
                        string  CompanyAccountNo = string.Empty;


                        if (companyId != 0)
                        {
                            Gen_Company objCompany = General.GetObject <Gen_Company>(c => c.Id == companyId);

                            if (objCompany != null)
                            {
                                if (objCompany.HasVat.ToBool())
                                {
                                    valueAddedTax = (invoiceGrandTotal * 20) / 100;
                                    vat           = "1";
                                    if (objCompany.VatOnlyOnAdminFees.ToBool())
                                    {
                                        valueAddedTax = (data.AdminFees.ToDecimal() * 20) / 100;
                                        vat           = "1";
                                    }
                                }

                                if (objCompany.DiscountPercentage.ToDecimal() > 0)
                                {
                                    discountAmount  = (invoiceGrandTotal * objCompany.DiscountPercentage.ToDecimal()) / 100;
                                    DiscountPercent = objCompany.DiscountPercentage.ToDecimal();
                                    HasDiscount     = "1";
                                }
                                if (objCompany.AdminFees > 0)
                                {
                                    decimal GrandAmount = (invoiceGrandTotal - discountAmount);
                                    AdminFees        = (invoiceGrandTotal * objCompany.AdminFees.ToDecimal()) / 100;
                                    AdminFeesPercent = objCompany.AdminFees.ToDecimal();
                                    HasAdminFees     = "1";
                                }


                                CompanyAccountNo = objCompany.AccountNo.ToStr().Trim();
                            }
                        }

                        if (TemplateName.ToStr() == "Template17")
                        {
                            invoiceGrandTotal = (invoiceGrandTotal2 + valueAddedTax) - discountAmount;
                        }
                        else
                        {
                            invoiceGrandTotal = (invoiceGrandTotal + valueAddedTax) - discountAmount;
                        }



                        StringBuilder text = new StringBuilder();

                        text.Append("<html>");


                        text.Append("<b>" + " Invoice # : " + list[0].InvoiceNo.ToStr() + " @ <color=Red>" + string.Format("{0:dd/MM/yy HH:mm}", list[0].InvoiceDate) + "</b>");
                        text.Append("<br><br>");
                        text.Append("<br><b><color=Black>Company : " + list[0].CompanyName.ToStr() + "</b>");
                        text.Append("<br>Address : " + list[0].CompanyAddress.ToStr());
                        text.Append("<br><br>");
                        text.Append("<br><b>Gross Total : </b>" + Math.Round(netAmount.ToDecimal(), 2));

                        if (valueAddedTax.ToDecimal() > 0)
                        {
                            text.Append("<br><b>Vat : </b>" + Math.Round(valueAddedTax.ToDecimal(), 2));
                        }


                        if (AdminFees.ToDecimal() > 0)
                        {
                            text.Append("<br><b>Admin Fees : </b>" + Math.Round(AdminFees.ToDecimal(), 2));
                        }

                        text.Append("<br><b>Total Due : </b>" + Math.Round(invoiceGrandTotal + AdminFees, 2));
                        text.Append("<br><br>");


                        RadOffice2007ScreenTipElement screenTip = new RadOffice2007ScreenTipElement();
                        screenTip.CaptionLabel.Margin = new Padding(3);

                        screenTip.CaptionLabel.Text = text.ToStr();
                        //   screenTip.CaptionLabel.Text = text.ToStr();
                        screenTip.MainTextLabel.Text = string.Empty;
                        screenTip.EnableCustomSize   = false;


                        cell.ScreenTip = screenTip;
                    }
                }
            }
            catch (Exception ex)
            {
            }
        }