public void loadfv()
 {
     LoanDSTableAdapters.FinalVoucherTableAdapter finalv = new LoanDSTableAdapters.FinalVoucherTableAdapter();
     LoanDS.FinalVoucherDataTable tblfinalv = finalv.GetFinalVoucher(MySessionManager.ClientID, MySessionManager.AppID);
     if (tblfinalv.Rows.Count > 0)
     {
         try
         {
             this.editskip1.Value = "2";
             FVID.Value           = tblfinalv[0].datID.ToString();
             txtVoucherNo.Value   = tblfinalv[0].datVoucherName.ToString();
             txtAmtWords.Value    = tblfinalv[0].datAmountInWords.ToString();
             txtDate.Text         = tblfinalv[0].datVoucherDate.ToShortDateString();
             txtTotalAmount.Text  = tblfinalv[0].datVoucherTotalAmount.ToString();
         }
         catch (Exception ex)
         { Console.Write(ex.Message); }
     }
 }
    protected void btnFinalVoucher_Click(object sender, EventArgs e)
    {
        // fetch the en-GB culture
        CultureInfo ukCulture = new CultureInfo("en-GB");
        // pass the DateTimeFormat information to DateTime.Parse
        DateTime myDateTime = DateTime.Parse(txtDate.Text, ukCulture.DateTimeFormat);

        //ShowMessageBox(myDateTime.ToShortDateString());

        LoanDSTableAdapters.FinalVoucherTableAdapter finalv = new LoanDSTableAdapters.FinalVoucherTableAdapter();
        LoanDS.FinalVoucherDataTable tblfinalv = finalv.GetFinalVoucher(MySessionManager.ClientID, MySessionManager.AppID);
        if (!(tblfinalv.Rows.Count > 0))
        {
            finalv.InsertFinalVoucher(MySessionManager.ClientID,
                                      MySessionManager.AppID,
                                      txtVoucherNo.Value,
                                      myDateTime,
                                      Convert.ToDecimal(txtTotalAmount.Text),
                                      txtAmtWords.Value.Trim(),
                                      MySessionManager.CurrentUser.UserID,
                                      DateTime.Now,
                                      MySessionManager.CurrentUser.UserID,
                                      DateTime.Now
                                      );
        }
        else
        {
            finalv.UpdateFinalVoucher(txtVoucherNo.Value,
                                      myDateTime,
                                      Convert.ToDecimal(txtTotalAmount.Text),
                                      txtAmtWords.Value.Trim(),
                                      MySessionManager.CurrentUser.UserID,
                                      DateTime.Now,
                                      MySessionManager.CurrentUser.UserID,
                                      DateTime.Now,
                                      Convert.ToInt32(FVID.Value));
            this.editskip1.Value = "1";
        }
    }
    public void loadfv()
    {
        LoanDSTableAdapters.FinalVoucherTableAdapter finalv = new LoanDSTableAdapters.FinalVoucherTableAdapter();
        LoanDS.FinalVoucherDataTable tblfinalv =finalv.GetFinalVoucher(MySessionManager.ClientID, MySessionManager.AppID );
        if(tblfinalv .Rows.Count>0)
        {
            try
            {
                this.editskip1.Value = "2";
                FVID.Value = tblfinalv[0].datID.ToString();
                txtVoucherNo.Value = tblfinalv[0].datVoucherName.ToString();
                txtAmtWords.Value = tblfinalv[0].datAmountInWords.ToString();
                txtDate.Text = tblfinalv[0].datVoucherDate.ToShortDateString();
                txtTotalAmount.Text = tblfinalv[0].datVoucherTotalAmount.ToString();
            }
            catch (Exception ex)
            { Console.Write(ex.Message); }

        }

    }
    protected void btnFinalVoucher_Click(object sender, EventArgs e)
    {
        // fetch the en-GB culture
        CultureInfo ukCulture = new CultureInfo("en-GB");
        // pass the DateTimeFormat information to DateTime.Parse
        DateTime myDateTime = DateTime.Parse(txtDate.Text, ukCulture.DateTimeFormat);
        //ShowMessageBox(myDateTime.ToShortDateString());

        LoanDSTableAdapters.FinalVoucherTableAdapter finalv = new LoanDSTableAdapters.FinalVoucherTableAdapter();
        LoanDS.FinalVoucherDataTable tblfinalv = finalv.GetFinalVoucher(MySessionManager.ClientID, MySessionManager.AppID);
        if (!(tblfinalv.Rows.Count > 0))
        {
            finalv.InsertFinalVoucher(MySessionManager.ClientID,
                                      MySessionManager.AppID,
                                      txtVoucherNo.Value,
                                      myDateTime,
                                      Convert.ToDecimal(txtTotalAmount.Text),
                                      txtAmtWords.Value.Trim(),
                                      MySessionManager.CurrentUser.UserID,
                                      DateTime.Now,
                                      MySessionManager.CurrentUser.UserID,
                                      DateTime.Now
                                      );
        }
        else 
        {
            finalv.UpdateFinalVoucher(txtVoucherNo.Value,
                                      myDateTime,
                                      Convert.ToDecimal(txtTotalAmount.Text),
                                      txtAmtWords.Value.Trim(),
                                      MySessionManager.CurrentUser.UserID,
                                      DateTime.Now,
                                      MySessionManager.CurrentUser.UserID,
                                      DateTime.Now,
                                      Convert.ToInt32(FVID.Value));
            this.editskip1.Value = "1";
   
        }
    }