protected void btnSave_Click(object sender, EventArgs e)
            {
                if (btnSave.Text.ToUpper() == "CREATE")
                    this.InsertInvoice();
                else if (btnSave.Text.ToUpper() == "SAVE CHANGES")
                    this.UpdateInvoice();
            }
 
 
private void InsertInvoice()
        {
            String  sqlCommand  = String.Empty;
            DataSet result      = null;
 
            //Create the command.
            sqlCommand = String.Format("EXEC nga_InsertPaymentInvoice {0}, '{1}', {2}, '{3}', '{4}', '{5}'", 
                                       1, ddVendors.Text, "0.14", txtReasonForPayment.Text, 
                                       txtAuthoriser.Text, DateTime.Now.ToLongDateString());
 
            //Execute the command and get the new invoice id.
            result = m_dbHandler.SmartGetDataSet(sqlCommand);
 
            //Redirect.
            base.Response.Redirect(String.Format("FulfillmentPayment.aspx?Command=Edit&InvoiceId={0}",
                                   result.Tables[0].Rows[0][0]));
        }

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
 
 
ALTER PROCEDURE [dbo].[nga_InsertPaymentInvoice] @invoiceType INT, @couplingEntity NVARCHAR(256), @taxRate FLOAT,
										  @reasonForPayment TEXT, @authoriser NVARCHAR(256), @dateCreated DATETIME
 
AS
 
	BEGIN
 
	INSERT INTO nga_PaymentInvoices VALUES (@invoiceType, @couplingEntity, @dateCreated, @taxRate, @reasonForPayment, 
										    @authoriser);
 
	SELECT InvoiceId FROM nga_PaymentInvoices 
 
	WHERE invoiceType=@invoiceType AND couplingEntity=@couplingEntity AND dateCreated=@dateCreated AND
		  AtTimeTaxRate=@taxRate AND Authoriser=@authoriser;
 
	END