Пример #1
0
        private void trailBal()
        {
            try
            {
                tbl_AccGroup  grp  = new tbl_AccGroup();
                tbl_AccLedger ledg = new tbl_AccLedger();

                acc_list               = new Acc_list();
                acc_list.group         = grp.ToString();
                acc_list.ledger        = ledg.ToString();
                acc_list.only_opening  = false;
                acc_list.start_date    = null;
                acc_list.end_date      = null;
                acc_list.affects_gross = -1;
                acc_list.start(0);

                decimal dr = acc_list.dr_total;
                decimal cr = acc_list.cr_total;

                print_account_chart(acc_list, -1, this);

                ReportDataSource datasource = new ReportDataSource("DataSet1", dmList);

                this.reportViewer1.LocalReport.DataSources.Clear();
                this.reportViewer1.LocalReport.DataSources.Add(datasource);

                dmList = new List <DummyList>();
                dm     = new DummyList();

                dm.date = DateTime.Now.Date.ToString("dd-MM-yyyy");

                dm.TotaldrAmt = toCurr.toCurrenc("D", dr);
                dm.TotalcrAmt = toCurr.toCurrenc("D", dr);

                dmList.Add(dm);

                ReportDataSource datasource1 = new ReportDataSource("DataSet2", dmList);
                this.reportViewer1.LocalReport.DataSources.Add(datasource1);
            }
            catch (Exception x)
            {
            }
        }
Пример #2
0
        private void btnCreate_Click(object sender, EventArgs e)
        {
            try
            {
                if (txtGroupName.Text == string.Empty)
                {
                    errorProvider1.Clear();
                    errorProvider1.SetError(txtGroupName, "Enter Group Name");
                    txtGroupName.Focus();
                    panel3.Visible = true;
                    lblError.Text  = "Enter Group Name.";
                }
                else
                {
                    if (btnCreate.Text == "Create")
                    {
                        _entities = new MicroAccountsEntities1();

                        var data = _entities.tbl_AccGroup;

                        foreach (var item in data)
                        {
                            if (item.groupName == txtGroupName.Text.Trim())
                            {
                                errorProvider1.Clear();
                                errorProvider1.SetError(txtGroupName, "Group Name already exists!");
                                txtGroupName.Focus();
                                panel3.Visible = true;
                                lblError.Text  = "Group Name already exists!";
                                return;
                            }
                        }

                        _entities = new MicroAccountsEntities1();
                        tbl_AccGroup accGroup = new tbl_AccGroup();

                        var max_id = _entities.tbl_AccGroup.OrderByDescending(x => x.id).FirstOrDefault().id;

                        accGroup.id = max_id + 1;

                        accGroup.groupName   = txtGroupName.Text.Trim().ToString();
                        accGroup.parentId    = Convert.ToInt32(cmbParentGroup.SelectedValue);
                        accGroup.createdDate = DateTime.Now;
                        accGroup.updateDate  = DateTime.Now;

                        long ggId = Convert.ToInt32(cmbParentGroup.SelectedValue);

                        var affGross = _entities.tbl_AccGroup.Where(x => x.groupId == ggId).FirstOrDefault().affects_gross;

                        if (affGross == 1)
                        {
                            accGroup.affects_gross = 1;
                        }

                        else
                        {
                            accGroup.affects_gross = 0;
                        }

                        _entities.tbl_AccGroup.Add(accGroup);
                        _entities.SaveChanges();
                        MessageBox.Show("Record Saved Successfully!");
                    }
                    else
                    {
                        _entities = new MicroAccountsEntities1();

                        var data = _entities.tbl_AccGroup;

                        foreach (var item in data)
                        {
                            if (item.groupName == txtGroupName.Text.Trim() && txtGroupName.Text != lblhiddenGName.Text)
                            {
                                errorProvider1.Clear();
                                errorProvider1.SetError(txtGroupName, "Group Name already exists!");
                                txtGroupName.Focus();
                                panel3.Visible = true;
                                lblError.Text  = "Group Name already exists!";
                                return;
                            }
                        }

                        _entities = new MicroAccountsEntities1();
                        var gId          = Convert.ToInt32(lblHiddenId.Text);
                        var dataToUpdate = _entities.tbl_AccGroup.Where(x => x.groupId == gId).FirstOrDefault();

                        dataToUpdate.groupName  = txtGroupName.Text.Trim().ToString();
                        dataToUpdate.parentId   = Convert.ToInt32(cmbParentGroup.SelectedValue);
                        dataToUpdate.updateDate = DateTime.Now;

                        _entities.SaveChanges();
                        MessageBox.Show("Record Updated Successfully!");
                    }
                    DataGridSource();
                    ClearTextBox();
                }
            }
            catch (Exception c)
            {
                MessageBox.Show("Something went wrong. Contact your system administrator");
            }
        }
Пример #3
0
        private void BalanceSheetData()
        {
            tbl_AccGroup  grp  = new tbl_AccGroup();
            tbl_AccLedger ledg = new tbl_AccLedger();

            acc = new MicroAccountsEntities1();

            var acc_group_id = (from c in acc.tbl_AccGroup
                                where c.groupName == "Incomes"
                                select c.id).FirstOrDefault();


            assets = new Acc_list();

            //Income
            income = new Acc_list();

            income.group        = grp.ToString();
            income.ledger       = ledg.ToString();
            income.only_opening = only_opening;
            // income.start_date = txtStartDate.Text;
            //income.end_date = txtEndDate.Text;
            income.affects_gross = -1;

            income.start(Convert.ToInt32(acc_group_id));

            //Expenses

            acc          = new MicroAccountsEntities1();
            acc_group_id = (from c in acc.tbl_AccGroup
                            where c.groupName == "Expenses"
                            select c.id).FirstOrDefault();

            assets  = new Acc_list();
            expense = new Acc_list();

            expense.group        = grp.ToString();
            expense.ledger       = ledg.ToString();
            expense.only_opening = only_opening;
            // expense.start_date = txtStartDate.Text;
            // expense.end_date = txtEndDate.Text;
            expense.affects_gross = -1;
            expense.start(Convert.ToInt32(acc_group_id));

            if (income.cl_total_dc == "C")
            {
                income_total = income.cl_total;
            }
            else
            {
                income_total = Convert.ToDecimal(income.cl_total);
            }
            if (expense.cl_total_dc == "D")
            {
                expense_total = expense.cl_total;
            }
            else
            {
                expense_total = Convert.ToDecimal(expense.cl_total);
            }

            pandl = income_total - expense_total;

            op_diff = new string[] { };
            op_diff = opening_diff();
            if (Convert.ToDecimal(op_diff[1]) == 0)
            {
                is_diff = false;
            }
            else
            {
                is_diff = true;
            }

            //------------------------------------------------------------------------


            ListViewGroup Assets = new ListViewGroup("Assets", HorizontalAlignment.Left);

            acc          = new MicroAccountsEntities1();
            acc_group_id = (from c in acc.tbl_AccGroup
                            where c.groupName == "Assets"
                            select c.id).FirstOrDefault();

            assets = new Acc_list();

            assets.group        = grp.ToString();
            assets.ledger       = ledg.ToString();
            assets.only_opening = only_opening;
            //assets.start_date = txtStartDate.Text;
            // assets.end_date = txtEndDate.Text;
            assets.affects_gross = -1;
            assets.start(Convert.ToInt32(acc_group_id));

            Account_st_short(assets, -1, "D", this, 1);

            //  dataGridView2.DataSource = dmList;

            labels = new Label[dmList.Count + 1];

            int k = 35;

            // create array elements in a loop
            for (int i = 0; i < dmList.Count; i++)
            {
                Font FNT = new Font("Century Gothic", 10.0f, FontStyle.Bold);

                labels[i] = new Label();

                labels[i].Top  = k * (i + 1);
                labels[i].Left = 546;
                labels[i].Font = FNT;
                labels[i].Size = new Size(200, 19);

                if (dmList[i].ledger == "1")
                {
                    labels[i].Text      = "    " + dmList[i].group.ToString();
                    labels[i].ForeColor = Color.Blue;
                }
                else
                {
                    labels[i].ForeColor = Color.Black;
                    labels[i].Text      = dmList[i].group.ToString();
                }

                assetsLabelTop = k * (i + 1);
            }

            this.Controls.AddRange(labels);

            labels = new Label[dmList.Count + 1];
            k      = 36;
            for (int i = 0; i < dmList.Count; i++)
            {
                Font FNT = new Font("Century Gothic", 10.0f, FontStyle.Bold);

                labels[i] = new Label();

                labels[i].Top  = k * (i + 1);
                labels[i].Left = 800;
                labels[i].Font = FNT;
                labels[i].Size = new Size(200, 19);

                labels[i].ForeColor = Color.Black;
                labels[i].Text      = dmList[i].amt.ToString();
            }

            this.Controls.AddRange(labels);


            dmList = new List <DummyList>();

            ListViewGroup LiabilitiesandOwnersEquity = new ListViewGroup("Liabilities and Owners Equity", HorizontalAlignment.Left);

            acc          = new MicroAccountsEntities1();
            acc_group_id = (from c in acc.tbl_AccGroup
                            where c.groupName == "Liabilities and Owners Equity"
                            select c.id).FirstOrDefault();

            liabilities = new Acc_list();

            liabilities.group        = grp.ToString();
            liabilities.ledger       = ledg.ToString();
            liabilities.only_opening = only_opening;
            //liabilities.start_date = txtStartDate.Text;
            //liabilities.end_date = txtEndDate.Text;
            liabilities.affects_gross = -1;
            liabilities.start(Convert.ToInt32(acc_group_id));

            Account_st_short(liabilities, -1, "C", this, 2);

            k      = 35;
            labels = new Label[dmList.Count + 1];
            // create array elements in a loop
            for (int i = 0; i < dmList.Count; i++)
            {
                Font FNT = new Font("Century Gothic", 10.0f, FontStyle.Bold);

                labels[i] = new Label();

                labels[i].Top  = k * (i + 1);
                labels[i].Left = 43;
                labels[i].Font = FNT;

                if (dmList[i].ledger == "1")
                {
                    labels[i].Text      = "    " + dmList[i].group.ToString();
                    labels[i].ForeColor = Color.Blue;
                    labels[i].Size      = new Size(200, 19);
                }
                else
                {
                    labels[i].ForeColor = Color.Black;
                    labels[i].Text      = dmList[i].group.ToString();
                    labels[i].Size      = new Size(200, 19);
                }

                libLabelTop = k * (i + 1);
            }
            this.Controls.AddRange(labels);

            k      = 36;
            labels = new Label[dmList.Count + 1];
            for (int i = 0; i < dmList.Count; i++)
            {
                FNT = new Font("Century Gothic", 10.0f, FontStyle.Bold);

                labels[i] = new Label();

                labels[i].Top  = k * (i + 1);
                labels[i].Left = 293;
                labels[i].Font = FNT;
                labels[i].Size = new Size(200, 19);

                labels[i].ForeColor = Color.Black;
                labels[i].Text      = dmList[i].amt.ToString();
            }
            this.Controls.AddRange(labels);

            if (liabilities.cl_total_dc == "C")
            {
                liabilities_total = liabilities.cl_total;
            }
            else
            {
                liabilities_total = Convert.ToDecimal(liabilities.cl_total * -1);
            }

            if (assets.cl_total_dc == "D")
            {
                assets_total = assets.cl_total;
            }
            else
            {
                assets_total = Convert.ToDecimal(assets.cl_total * -1);
            }

            /**** Final balancesheet total ****/

            final_liabilities_total = liabilities_total;
            final_assets_total      = assets_total;

            /* If net profit add to liabilities, if net loss add to assets */

            if (pandl >= 0)
            {
                final_liabilities_total = final_liabilities_total + pandl;
            }
            else
            {
                positive_pandl     = pandl * -1;
                final_assets_total = final_assets_total + positive_pandl;
            }

            /**
             * If difference in opening balance is Dr then subtract from
             * assets else subtract from liabilities
             */

            if (is_diff)
            {
                if (op_diff[0] == "D")
                {
                    final_assets_total = Convert.ToDecimal(final_assets_total + Convert.ToDecimal(op_diff[1]));
                }

                else
                {
                    final_liabilities_total = Convert.ToDecimal(final_liabilities_total + Convert.ToDecimal(op_diff[1]));
                }
            }


            panel4.Visible = true;
            panel4.Top     = assetsLabelTop + 35;


            /* Difference in opening balance */

            /* Total */

            dmList = new List <DummyList>();

            DummyList dm = new DummyList();

            if (assets_total >= 0)
            {
                Label lb = new Label();
                this.Controls.Add(lb);
                lb.Text = "Total Assets";
                lb.Top  = assetsLabelTop + 50;
                lb.Left = 549;
                lb.Font = FNT;
                lb.Size = new Size(200, 19);

                lb = new Label();
                this.Controls.Add(lb);
                lb.Text = toCurr.toCurrenc("D", assets_total);
                lb.Top  = assetsLabelTop + 50;
                lb.Left = 800;
                lb.Font = FNT;
                lb.Size = new Size(200, 19);
            }
            else
            {
                lb = new Label();
                this.Controls.Add(lb);
                lb.Text      = "Total Assets";
                lb.Top       = assetsLabelTop + 50;
                lb.Left      = 549;
                lb.Font      = FNT;
                lb.Size      = new Size(200, 19);
                lb.ForeColor = Color.Red;

                lb = new Label();
                this.Controls.Add(lb);
                lb.Text = "(Expecting positive Dr Balance)";
                lb.Top  = assetsLabelTop + 65;
                lb.Left = 549;
                Font FNTs = new Font("Century Gothic", 8.0f, FontStyle.Bold);
                lb.Font      = FNTs;
                lb.Size      = new Size(250, 19);
                lb.ForeColor = Color.Red;

                lb = new Label();
                this.Controls.Add(lb);
                lb.Text      = toCurr.toCurrenc("D", assets_total);
                lb.Top       = assetsLabelTop + 50;
                lb.Left      = 800;
                lb.Font      = FNT;
                lb.ForeColor = Color.Red;

                lb.Size = new Size(200, 19);
            }
            dmList.Add(dm);
            dm = new DummyList();

            html.Append("<tr style='font-weight:bold'>");

            if (pandl >= 0)
            {
                lb = new Label();
                this.Controls.Add(lb);
                lb.Text = "";
                lb.Top  = assetsLabelTop + 100;
                lb.Left = 549;
                lb.Font = FNT;
                lb.Size = new Size(200, 19);

                lb = new Label();
                this.Controls.Add(lb);
                lb.Text = "";
                lb.Top  = assetsLabelTop + 100;
                lb.Left = 800;
                lb.Font = FNT;
                lb.Size = new Size(200, 19);
            }
            else
            {
                lb = new Label();
                this.Controls.Add(lb);
                lb.Text = "Profit & Loss Account (Net Loss)";
                lb.Top  = assetsLabelTop + 100;
                lb.Left = 549;
                lb.Font = FNT;
                lb.Size = new Size(250, 19);

                positive_pandl = pandl * -1;

                lb = new Label();
                this.Controls.Add(lb);
                lb.Text = toCurr.toCurrenc("D", positive_pandl);
                lb.Top  = assetsLabelTop + 100;
                lb.Left = 800;
                lb.Font = FNT;
                lb.Size = new Size(200, 19);
            }



            if (is_diff)
            {
                /* If diff in opening balance is Dr */
                if (op_diff[0] == "D")
                {
                    lb = new Label();
                    this.Controls.Add(lb);
                    lb.Text = "Diff in O/P Balance";
                    lb.Top  = assetsLabelTop + 130;
                    lb.Left = 549;
                    lb.Font = FNT;
                    lb.Size = new Size(200, 19);

                    positive_pandl = pandl * -1;

                    lb = new Label();
                    this.Controls.Add(lb);
                    lb.Text = toCurr.toCurrenc("D", Convert.ToDecimal(op_diff[1]));
                    lb.Top  = assetsLabelTop + 130;
                    lb.Left = 800;
                    lb.Font = FNT;
                    lb.Size = new Size(200, 19);
                }
                else
                {
                    lb = new Label();
                    this.Controls.Add(lb);
                    lb.Text = "";
                    lb.Top  = assetsLabelTop + 130;
                    lb.Left = 549;
                    lb.Font = FNT;
                    lb.Size = new Size(200, 19);

                    positive_pandl = pandl * -1;

                    lb = new Label();
                    this.Controls.Add(lb);
                    lb.Text = "";
                    lb.Top  = assetsLabelTop + 130;
                    lb.Left = 800;
                    lb.Font = FNT;
                    lb.Size = new Size(200, 19);
                }
            }

            if (final_liabilities_total == final_assets_total)
            {
                lb = new Label();
                this.Controls.Add(lb);
                lb.Text = "Total";
                lb.Top  = assetsLabelTop + 150;
                lb.Left = 549;
                lb.Font = FNT;
                lb.Size = new Size(200, 19);

                positive_pandl = pandl * -1;

                lb = new Label();
                this.Controls.Add(lb);
                lb.Text = toCurr.toCurrenc("D", Convert.ToDecimal(final_assets_total));
                lb.Top  = assetsLabelTop + 150;
                lb.Left = 800;
                lb.Font = FNT;
                lb.Size = new Size(200, 19);
            }
            else
            {
                lb = new Label();
                this.Controls.Add(lb);
                lb.Text        = "Total";
                lb.Top         = assetsLabelTop + 150;
                lb.Left        = 549;
                lb.Font        = FNT;
                lb.ForeColor   = Color.Red;
                positive_pandl = pandl * -1;
                lb.Size        = new Size(200, 19);

                lb = new Label();
                this.Controls.Add(lb);
                lb.Text      = toCurr.toCurrenc("D", Convert.ToDecimal(final_assets_total));
                lb.Top       = assetsLabelTop + 150;
                lb.Left      = 800;
                lb.Font      = FNT;
                lb.ForeColor = Color.Red;
                lb.Size      = new Size(200, 19);
            }


            //Liablities bottom total

            panel6.Visible = true;
            panel6.Top     = libLabelTop + 35;

            if (liabilities_total >= 0)
            {
                lb = new Label();
                this.Controls.Add(lb);
                lb.Text = "Total Liability and Owners Equity";
                lb.Size = new Size(200, 19);
                lb.Top  = libLabelTop + 50;
                lb.Left = 42;
                lb.Font = FNT;

                lb = new Label();
                this.Controls.Add(lb);
                lb.Text = (toCurr.toCurrenc("C", liabilities_total));
                lb.Top  = libLabelTop + 55;
                lb.Left = 293;
                lb.Font = FNT;
                lb.Size = new Size(200, 19);
            }
            else
            {
                lb = new Label();
                this.Controls.Add(lb);
                lb.Text      = "Total Liability and Owners Equity";
                lb.Top       = libLabelTop + 50;
                lb.Left      = 42;
                lb.Font      = FNT;
                lb.Size      = new Size(200, 19);
                lb.ForeColor = Color.Red;

                lb = new Label();
                this.Controls.Add(lb);
                lb.Text      = (toCurr.toCurrenc("C", liabilities_total));
                lb.Top       = libLabelTop + 55;
                lb.Left      = 293;
                lb.Font      = FNT;
                lb.Size      = new Size(200, 19);
                lb.ForeColor = Color.Red;

                lb = new Label();
                this.Controls.Add(lb);
                lb.Text = "(Expecting positive Cr Balance)";
                lb.Top  = libLabelTop + 70;
                lb.Left = 42;
                Font FNTss = new Font("Century Gothic", 8.0f, FontStyle.Bold);
                lb.Font      = FNTss;
                lb.Size      = new Size(250, 19);
                lb.ForeColor = Color.Red;
            }

            if (pandl >= 0)
            {
                lb = new Label();
                this.Controls.Add(lb);
                lb.Text = "Profit & Loss Account (Net Loss)";
                lb.Top  = libLabelTop + 100;
                lb.Left = 42;
                lb.Font = FNT;
                lb.Size = new Size(250, 19);

                positive_pandl = pandl * -1;

                lb = new Label();
                this.Controls.Add(lb);
                lb.Text = toCurr.toCurrenc("C", pandl);
                lb.Top  = libLabelTop + 100;
                lb.Left = 293;
                lb.Font = FNT;
                lb.Size = new Size(250, 19);
            }
            else
            {
                lb = new Label();
                this.Controls.Add(lb);
                lb.Text = " ";
                lb.Top  = libLabelTop + 100;
                lb.Left = 42;
                lb.Font = FNT;
                lb.Size = new Size(250, 19);

                lb = new Label();
                this.Controls.Add(lb);
                lb.Text = "  ";
                lb.Top  = libLabelTop + 100;
                lb.Left = 293;
                lb.Font = FNT;
                lb.Size = new Size(250, 19);
            }

            if (is_diff)
            {
                html.Append("<tr style='font-weight:bold;color:red'>");
                /* If diff in opening balance is Cr */
                if (op_diff[0] == "C")
                {
                    lb = new Label();
                    this.Controls.Add(lb);
                    lb.Text      = "Diff in O/P Balance";
                    lb.Top       = libLabelTop + 130;
                    lb.Left      = 42;
                    lb.Font      = FNT;
                    lb.Size      = new Size(250, 19);
                    lb.ForeColor = Color.Red;

                    lb = new Label();
                    this.Controls.Add(lb);
                    lb.Text      = toCurr.toCurrenc("C", Convert.ToDecimal(op_diff[1]));
                    lb.Top       = libLabelTop + 130;
                    lb.Left      = 293;
                    lb.Font      = FNT;
                    lb.Size      = new Size(250, 19);
                    lb.ForeColor = Color.Red;
                }
                else
                {
                    lb = new Label();
                    this.Controls.Add(lb);
                    lb.Text = " ";
                    lb.Top  = libLabelTop + 130;
                    lb.Left = 42;
                    lb.Font = FNT;
                    lb.Size = new Size(250, 19);

                    lb = new Label();
                    this.Controls.Add(lb);
                    lb.Text = "  ";
                    lb.Top  = libLabelTop + 130;
                    lb.Left = 293;
                    lb.Font = FNT;
                    lb.Size = new Size(250, 19);
                }
            }



            if (final_liabilities_total == final_assets_total)
            {
                lb = new Label();
                this.Controls.Add(lb);
                lb.Text = "Total";
                lb.Top  = libLabelTop + 150;
                lb.Left = 42;
                lb.Font = FNT;
                lb.Size = new Size(200, 19);

                positive_pandl = pandl * -1;

                lb = new Label();
                this.Controls.Add(lb);
                lb.Text = toCurr.toCurrenc("c", Convert.ToDecimal(final_assets_total));
                lb.Top  = libLabelTop + 150;
                lb.Left = 293;
                lb.Font = FNT;
                lb.Size = new Size(200, 19);
            }
            else
            {
                lb = new Label();
                this.Controls.Add(lb);
                lb.Text        = "Total";
                lb.Top         = libLabelTop + 150;
                lb.Left        = 42;
                lb.Font        = FNT;
                lb.ForeColor   = Color.Red;
                positive_pandl = pandl * -1;
                lb.Size        = new Size(200, 19);

                lb = new Label();
                this.Controls.Add(lb);
                lb.Text      = toCurr.toCurrenc("c", Convert.ToDecimal(final_assets_total));
                lb.Top       = libLabelTop + 150;
                lb.Left      = 293;
                lb.Font      = FNT;
                lb.ForeColor = Color.Red;
                lb.Size      = new Size(200, 19);
            }
        }
Пример #4
0
        private void TrailBalance_Load(object sender, EventArgs e)
        {
            try
            {
                tbl_AccGroup  grp  = new tbl_AccGroup();
                tbl_AccLedger ledg = new tbl_AccLedger();

                acc_list               = new Acc_list();
                acc_list.group         = grp.ToString();
                acc_list.ledger        = ledg.ToString();
                acc_list.only_opening  = false;
                acc_list.start_date    = null;
                acc_list.end_date      = null;
                acc_list.affects_gross = -1;
                acc_list.start(0);

                decimal dr = acc_list.dr_total;
                decimal cr = acc_list.cr_total;

                print_account_chart(acc_list, -1, this);

                panel2.Top = top + 10;


                if (dr == cr)
                {
                    Label lb2 = new Label();
                    this.Controls.Add(lb2);
                    lb2.Text = "Total";
                    //lb.Top = assetsLabelTop + 50;
                    lb2.Top       = top + 25;
                    lb2.Left      = 42;
                    lb2.Font      = FNT;
                    lb2.ForeColor = Color.Green;
                    lb2.Size      = new Size(150, 19);

                    Label lb = new Label();
                    this.Controls.Add(lb);
                    lb.Text = toCurr.toCurrenc("D", dr);
                    //lb.Top = assetsLabelTop + 50;
                    lb.Top       = top + 25;
                    lb.Left      = 483;
                    lb.Font      = FNT;
                    lb.ForeColor = Color.Green;
                    lb.Size      = new Size(150, 19);

                    lb = new Label();
                    this.Controls.Add(lb);
                    lb.Text = toCurr.toCurrenc("C", cr);
                    //lb.Top = assetsLabelTop + 50;
                    lb.Top       = top + 25;
                    lb.Left      = 651;
                    lb.Font      = FNT;
                    lb.ForeColor = Color.Green;
                    lb.Size      = new Size(150, 19);
                }
                else
                {
                    Label lb1 = new Label();
                    this.Controls.Add(lb1);
                    lb1.Text = "Total";
                    //lb.Top = assetsLabelTop + 50;
                    lb1.Top       = top + 25;
                    lb1.Left      = 42;
                    lb1.Font      = FNT;
                    lb1.ForeColor = Color.Red;
                    lb1.Size      = new Size(150, 19);

                    Label lb = new Label();
                    this.Controls.Add(lb);
                    lb.Text = toCurr.toCurrenc("D", dr);
                    //lb.Top = assetsLabelTop + 50;
                    lb.Top       = top + 25;
                    lb.Left      = 483;
                    lb.Font      = FNT;
                    lb.ForeColor = Color.Red;
                    lb.Size      = new Size(150, 19);

                    lb = new Label();
                    this.Controls.Add(lb);
                    lb.Text = toCurr.toCurrenc("C", cr);
                    //lb.Top = assetsLabelTop + 50;
                    lb.Top       = top + 25;
                    lb.Left      = 651;
                    lb.Font      = FNT;
                    lb.ForeColor = Color.Red;
                    lb.Size      = new Size(150, 19);
                }
            }
            catch (Exception x)
            {
            }
        }