public void UpdatePaymentPlan(string AppID)
    {
        SqlCommand cmd = new SqlCommand();
        SqlCommand cmd2;
        SqlConnection conn = new SqlConnection(Utility.connectionString);
        byte cmtype = 3;

        cmd.CommandText = "delete tblBLPaymentPlan where accountid=" + AppID + "";
        cmd.Connection = conn;
        cmd.CommandType = CommandType.Text;
        SqlTransaction tran = null;


        try
        {

            conn.Open();

            tran = conn.BeginTransaction();
            cmd.Transaction = tran;



            cmd.ExecuteNonQuery();


            int i = 0;

            foreach (HtmlTableRow row in this.TABLE1.Rows)
            {

                string labelstring = "lblMonth";

                string newlbl = labelstring + i.ToString();
                Control ctrl = null;


                if (i > 1)
                {
                    if (row.Cells.Count > 0)
                        ctrl = row.Cells[1].Controls[0];
                }
                if (ctrl != null)
                {
                    if (i > 1)
                    {


                        #region obsolete

                        //datarow.AccountID = accountid;
                        //datarow.MonthName = ((Label)row.Cells[0].Controls[0]).Text;
                        //datarow.MonthIndex = Convert.ToByte(i - 1);
                        //datarow.Repayment = Utility.ConvertToDouble(((TextBox)row.Cells[4].Controls[0]).Text).ToString();
                        //datarow.AmountOutstanding = Utility.ConvertToDouble(((TextBox)row.Cells[5].Controls[0]).Text).ToString();
                        //datarow.Ir = Utility.ConvertToDecimal(((TextBox)row.Cells[2].Controls[0]).Text);
                        //datarow.BalanceBF = Utility.ConvertToDecimal(((TextBox)row.Cells[1].Controls[0]).Text);
                        //datarow.Loan_Interest = Utility.ConvertToDecimal(((TextBox)row.Cells[3].Controls[0]).Text);
                        //datarow.RType = cmtype; 
                        #endregion

                        LoanDSTableAdapters.PaymentPlanTableAdapter plan = new LoanDSTableAdapters.PaymentPlanTableAdapter();
                        plan.InsertPaymentPlan(Convert.ToDateTime(((Label)row.Cells[0].Controls[0]).Text),
                                               Convert.ToDecimal(Utility.ConvertToDecimal(((TextBox)row.Cells[1].Controls[0]).Text)),
                                               Utility.ConvertToDecimal(((TextBox)row.Cells[2].Controls[0]).Text),
                                               Utility.ConvertToDecimal(((TextBox)row.Cells[2].Controls[0]).Text),
                                               Convert.ToDecimal ("0"),
                                               Utility.ConvertToDecimal(((TextBox)row.Cells[3].Controls[0]).Text),
                                               Utility.ConvertToDecimal(((TextBox)row.Cells[5].Controls[0]).Text),
                                               MySessionManager.AppID,
                                               Convert.ToInt32(((Label)row.Cells[0].Controls[0]).Text)
                                               );








                    }
                }

                i++;
            }

        }
        catch (Exception ex)
        {
            tran.Rollback();
        }
        finally
        {
            conn.Close();
        }



    }
    public void UpdatePaymentPlan(string AppID)
    {
        SqlCommand    cmd = new SqlCommand();
        SqlCommand    cmd2;
        SqlConnection conn   = new SqlConnection(Utility.connectionString);
        byte          cmtype = 3;

        cmd.CommandText = "delete tblBLPaymentPlan where accountid=" + AppID + "";
        cmd.Connection  = conn;
        cmd.CommandType = CommandType.Text;
        SqlTransaction tran = null;


        try
        {
            conn.Open();

            tran            = conn.BeginTransaction();
            cmd.Transaction = tran;



            cmd.ExecuteNonQuery();


            int i = 0;

            foreach (HtmlTableRow row in this.TABLE1.Rows)
            {
                string labelstring = "lblMonth";

                string  newlbl = labelstring + i.ToString();
                Control ctrl   = null;


                if (i > 1)
                {
                    if (row.Cells.Count > 0)
                    {
                        ctrl = row.Cells[1].Controls[0];
                    }
                }
                if (ctrl != null)
                {
                    if (i > 1)
                    {
                        #region obsolete

                        //datarow.AccountID = accountid;
                        //datarow.MonthName = ((Label)row.Cells[0].Controls[0]).Text;
                        //datarow.MonthIndex = Convert.ToByte(i - 1);
                        //datarow.Repayment = Utility.ConvertToDouble(((TextBox)row.Cells[4].Controls[0]).Text).ToString();
                        //datarow.AmountOutstanding = Utility.ConvertToDouble(((TextBox)row.Cells[5].Controls[0]).Text).ToString();
                        //datarow.Ir = Utility.ConvertToDecimal(((TextBox)row.Cells[2].Controls[0]).Text);
                        //datarow.BalanceBF = Utility.ConvertToDecimal(((TextBox)row.Cells[1].Controls[0]).Text);
                        //datarow.Loan_Interest = Utility.ConvertToDecimal(((TextBox)row.Cells[3].Controls[0]).Text);
                        //datarow.RType = cmtype;
                        #endregion

                        LoanDSTableAdapters.PaymentPlanTableAdapter plan = new LoanDSTableAdapters.PaymentPlanTableAdapter();
                        plan.InsertPaymentPlan(Convert.ToDateTime(((Label)row.Cells[0].Controls[0]).Text),
                                               Convert.ToDecimal(Utility.ConvertToDecimal(((TextBox)row.Cells[1].Controls[0]).Text)),
                                               Utility.ConvertToDecimal(((TextBox)row.Cells[2].Controls[0]).Text),
                                               Utility.ConvertToDecimal(((TextBox)row.Cells[2].Controls[0]).Text),
                                               Convert.ToDecimal("0"),
                                               Utility.ConvertToDecimal(((TextBox)row.Cells[3].Controls[0]).Text),
                                               Utility.ConvertToDecimal(((TextBox)row.Cells[5].Controls[0]).Text),
                                               MySessionManager.AppID,
                                               Convert.ToInt32(((Label)row.Cells[0].Controls[0]).Text)
                                               );
                    }
                }

                i++;
            }
        }
        catch (Exception ex)
        {
            tran.Rollback();
        }
        finally
        {
            conn.Close();
        }
    }
    public void AddPaymentPlan()
    {
        LoanDSTableAdapters.PaymentPlanTableAdapter plan = new LoanDSTableAdapters.PaymentPlanTableAdapter();

        LoanDS.PaymentPlanDataTable tbl = new LoanDS.PaymentPlanDataTable();

        LoanDS.PaymentPlanRow datarow;


        long AppID = MySessionManager.AppID;



        int i = 0;

        DeletePaymentPlan();

        foreach (HtmlTableRow row in this.TABLE1.Rows)
        {

            string labelstring = "lblMonth";

            string newlbl = labelstring + i.ToString();
            Control ctrl = null;


            if (i > 1)
            {
                if (row.Cells.Count > 0)
                    ctrl = row.Cells[1].Controls[0];
            }
            if (ctrl != null)
            {
                if (i > 1)
                {

                   datarow = tbl.NewPaymentPlanRow();



                    datarow.datApplicationID  = MySessionManager .AppID;
                    datarow.datMonth = Convert.ToDateTime(((Label)row.Cells[0].Controls[0]).Text);
                    datarow.datMonthIndex = Convert.ToInt32(i - 1);
                    datarow.datMonthlyPayment = Utility.ConvertToDecimal(((TextBox)row.Cells[5].Controls[0]).Text);
                    datarow.datOutstanding = Utility.ConvertToDecimal(((TextBox)row.Cells[6].Controls[0]).Text);
                    datarow.datInterest1 = Utility.ConvertToDecimal(((TextBox)row.Cells[3].Controls[0]).Text);
                    datarow.datBalanceBF = Utility.ConvertToDecimal(((TextBox)row.Cells[1].Controls[0]).Text);
                    datarow.datPrincipalComponent = Utility.ConvertToDecimal(((TextBox)row.Cells[5].Controls[0]).Text) - Utility.ConvertToDecimal(((TextBox)row.Cells[3].Controls[0]).Text);
                    tbl.Rows.Add(datarow);

                    plan.InsertPaymentPlan( Convert.ToDateTime(datarow.datMonth),
                                            Convert.ToDecimal(datarow.datBalanceBF),
                                            Convert.ToDecimal(datarow.datInterest1),
                                            Convert.ToDecimal(datarow.datMonthlyPayment),
                                            Convert.ToDecimal("0.0"),
                                            Convert.ToDecimal(datarow.datPrincipalComponent.ToString()),
                                            Convert.ToDecimal(datarow.datOutstanding.ToString()),
                                            MySessionManager.AppID,
                                            Convert.ToInt32(datarow.datMonthIndex.ToString()));


                }
            }

            i++;

            
        }



    }
    public void AddPaymentPlan()
    {
        LoanDSTableAdapters.PaymentPlanTableAdapter plan = new LoanDSTableAdapters.PaymentPlanTableAdapter();

        LoanDS.PaymentPlanDataTable tbl = new LoanDS.PaymentPlanDataTable();

        LoanDS.PaymentPlanRow datarow;


        long AppID = MySessionManager.AppID;



        int i = 0;

        DeletePaymentPlan();

        foreach (HtmlTableRow row in this.TABLE1.Rows)
        {
            string labelstring = "lblMonth";

            string  newlbl = labelstring + i.ToString();
            Control ctrl   = null;


            if (i > 1)
            {
                if (row.Cells.Count > 0)
                {
                    ctrl = row.Cells[1].Controls[0];
                }
            }
            if (ctrl != null)
            {
                if (i > 1)
                {
                    datarow = tbl.NewPaymentPlanRow();



                    datarow.datApplicationID      = MySessionManager.AppID;
                    datarow.datMonth              = Convert.ToDateTime(((Label)row.Cells[0].Controls[0]).Text);
                    datarow.datMonthIndex         = Convert.ToInt32(i - 1);
                    datarow.datMonthlyPayment     = Utility.ConvertToDecimal(((TextBox)row.Cells[5].Controls[0]).Text);
                    datarow.datOutstanding        = Utility.ConvertToDecimal(((TextBox)row.Cells[6].Controls[0]).Text);
                    datarow.datInterest1          = Utility.ConvertToDecimal(((TextBox)row.Cells[3].Controls[0]).Text);
                    datarow.datBalanceBF          = Utility.ConvertToDecimal(((TextBox)row.Cells[1].Controls[0]).Text);
                    datarow.datPrincipalComponent = Utility.ConvertToDecimal(((TextBox)row.Cells[5].Controls[0]).Text) - Utility.ConvertToDecimal(((TextBox)row.Cells[3].Controls[0]).Text);
                    tbl.Rows.Add(datarow);

                    plan.InsertPaymentPlan(Convert.ToDateTime(datarow.datMonth),
                                           Convert.ToDecimal(datarow.datBalanceBF),
                                           Convert.ToDecimal(datarow.datInterest1),
                                           Convert.ToDecimal(datarow.datMonthlyPayment),
                                           Convert.ToDecimal("0.0"),
                                           Convert.ToDecimal(datarow.datPrincipalComponent.ToString()),
                                           Convert.ToDecimal(datarow.datOutstanding.ToString()),
                                           MySessionManager.AppID,
                                           Convert.ToInt32(datarow.datMonthIndex.ToString()));
                }
            }

            i++;
        }
    }