コード例 #1
0
    protected void Repeater17_ItemCreated(object sender, RepeaterItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            DataRowView dr = (DataRowView)e.Item.DataItem;
            if (dr == null || dr.Row == null)
            {
                return;
            }
            DataRow row     = dr.Row;
            Invoice invoice = InvoiceDB.LoadAll(row);


            // get controls
            Repeater           lstRefunds       = (Repeater)e.Item.FindControl("lstRefunds");
            HtmlGenericControl div_refunds_list = (HtmlGenericControl)e.Item.FindControl("div_refunds_list");
            HtmlGenericControl span_refunds_trailing_space_row = (HtmlGenericControl)e.Item.FindControl("span_refunds_trailing_space_row");
            Label      lnkAddRefund        = (Label)e.Item.FindControl("lnkAddRefund");
            LinkButton showHideRefundsList = (LinkButton)e.Item.FindControl("showHideRefundsList");


            // get refunds
            DataTable tblRefunds = RefundDB.GetDataTableByInvoice(invoice.InvoiceID);
            lstRefunds.Visible = tblRefunds.Rows.Count > 0;
            span_refunds_trailing_space_row.Visible = tblRefunds.Rows.Count > 0;
            if (tblRefunds.Rows.Count > 0)
            {
                tblRefunds.Columns.Add("refund_url", typeof(string));
                for (int i = 0; i < tblRefunds.Rows.Count; i++)
                {
                    Refund refund = RefundDB.LoadAll(tblRefunds.Rows[i]);
                    tblRefunds.Rows[i]["refund_url"] = refund.GetViewPopupLinkV2();
                }

                lstRefunds.DataSource = tblRefunds;
                lstRefunds.DataBind();
            }

            lnkAddRefund.Visible = tblRefunds.Rows.Count == 0;
            //if (!invoice.IsPaID) // can add items
            if (tblRefunds.Rows.Count == 0) // can add items
            {
                lnkAddRefund.Text = Refund.GetAddPopupLinkV2(invoice.InvoiceID, "window.location.href = window.location.href;");
            }
            else
            {
                lnkAddRefund.Text = tblRefunds.Rows.Count > 0 ? string.Empty : "No Refunds";
            }
            //span_add_refunds_row.Style["text-align"] = (tblRefunds.Rows.Count > 0) ? "center" : null;  // if have table, center add link, else left align
            lnkAddRefund.Visible = lnkAddRefund.Text.Length > 0 && invoice.ReceiptsTotal > 0;
            showHideRefundsList.OnClientClick   = "javascript:show_hide_byname('div_refunds_list_" + invoice.InvoiceID + "'); return false;";
            showHideRefundsList.Visible         = tblRefunds.Rows.Count > 0;
            div_refunds_list.Attributes["name"] = "div_refunds_list_" + invoice.InvoiceID;
        }
    }
コード例 #2
0
    private void FillEditViewForm(bool isEditMode)
    {
        lblHeading.Text = isEditMode ? "Edit Refund" : "View Refund";
        Page.Title      = isEditMode ? "Edit Refund" : "View Refund";


        Refund refund = RefundDB.GetByID(GetFormID());

        if (refund == null)
        {
            HideTableAndSetErrorMessage("Invalid Refund ID");
            return;
        }


        lblId.Text         = refund.RefundID.ToString();
        lblInvoiceId.Text  = refund.Invoice.InvoiceID.ToString();
        lblRefundDate.Text = refund.RefundDateAdded.ToString("d MMM, yyyy");
        lblAddedBy.Text    = refund.Staff.Person.FullnameWithoutMiddlename;
        lblTotal.Font.Bold = !isEditMode;


        if (isEditMode)
        {
            txtTotal.Text = refund.Total.ToString();
            ddlRefundReason.SelectedValue = refund.RefundReason.ID.ToString();
            lblAmountReceipted.Text       = (InvoiceDB.GetByID(refund.Invoice.InvoiceID).ReceiptsTotal).ToString();
            lblTotal.Visible   = false;
            lblReason.Visible  = false;
            lblComment.Visible = false;
        }
        else
        {
            lblTotal.Text              = refund.Total.ToString();
            lblReason.Text             = refund.RefundReason.Descr;
            lblComment.Text            = refund.Comment;
            amountReceiptedRow.Visible = false;
            txtTotal.Visible           = false;
            ddlRefundReason.Visible    = false;
            txtComment.Visible         = false;
        }



        if (isEditMode)
        {
            btnSubmit.Text = "Update Details";
        }
        else // is view mode
        {
            btnSubmit.Visible = false;
            btnCancel.Text    = "Close";
        }
    }
コード例 #3
0
    protected void Update()
    {
        string tyro_transaction_id      = UrlTyroTransactionID;
        string out_result               = UrlOutResult;
        string out_cardType             = UrlOutCardType;
        string out_transactionReference = UrlOutTransactionReference;
        string out_authorisationCode    = UrlOutAuthorisationCode;
        string out_issuerActionCode     = UrlOutIssuerActionCode;

        if (tyro_transaction_id == null)
        {
            throw new Exception("Invalid url field tyro_transaction_id");
        }
        if (out_result == null)
        {
            throw new Exception("Invalid url field out_result");
        }
        if (out_cardType == null)
        {
            throw new Exception("Invalid url field out_cardType");
        }
        if (out_transactionReference == null)
        {
            throw new Exception("Invalid url field out_transactionReference");
        }
        if (out_authorisationCode == null)
        {
            throw new Exception("Invalid url field out_authorisationCode");
        }
        if (out_issuerActionCode == null)
        {
            throw new Exception("Invalid url field out_issuerActionCode");
        }

        TyroPaymentPendingDB.UpdateByTyroTransactionID(null, tyro_transaction_id, out_result, out_cardType, out_transactionReference, out_authorisationCode, out_issuerActionCode, DateTime.Now);

        if (out_result == "APPROVED")
        {
            TyroPaymentPending tyroPaymentPending = TyroPaymentPendingDB.GetByByTyroTransactionID(null, tyro_transaction_id);

            Invoice invoice = InvoiceDB.GetByID(tyroPaymentPending.InvoiceID);

            int staffID = Session == null || Session["StaffID"] == null ? -8 : Convert.ToInt32(Session["StaffID"]);

            if (tyroPaymentPending.TyroPaymentTypeID == 1) // payment
            {
                decimal totalOwed  = invoice.TotalDue - tyroPaymentPending.Amount;
                bool    isOverPaid = totalOwed < 0;
                bool    isPaid     = totalOwed <= 0;

                ReceiptDB.Insert(null, 364, tyroPaymentPending.InvoiceID, tyroPaymentPending.Amount, 0, false, isOverPaid, DateTime.MaxValue, staffID);

                if (tyroPaymentPending.Cashout > 0)
                {
                    CreditDB.Insert_Cashout(tyroPaymentPending.Cashout, tyroPaymentPending.TyroPaymentPendingID, staffID);
                }

                if (isPaid)
                {
                    InvoiceDB.UpdateIsPaid(null, invoice.InvoiceID, true);
                }

                if (isOverPaid)
                {
                    // send email to someone .. to fix up the overpayment....
                    Emailer.SimpleAlertEmail(
                        "Invoice tyro payment added and is overpaid.<br />tyro_payment_pending_id: " + tyroPaymentPending.TyroPaymentPendingID + "<br />Invoice: " + invoice.InvoiceID + "<br />DB: " + (Session == null || Session["DB"] == null ? "" : Session["DB"]),
                        "Tyro Invoice OverPaid: " + invoice.InvoiceID,
                        true);
                }
            }
            if (tyroPaymentPending.TyroPaymentTypeID == 2) // refund
            {
                decimal totalOwed = invoice.TotalDue + tyroPaymentPending.Amount;
                bool    isPaid    = totalOwed <= 0;

                RefundDB.Insert(tyroPaymentPending.InvoiceID, tyroPaymentPending.Amount, 308, "", staffID);

                if (totalOwed > 0)
                {
                    InvoiceDB.UpdateIsPaid(null, tyroPaymentPending.InvoiceID, false);
                }
            }
        }

        Response.Write("1"); // to indicate it was successful
    }
コード例 #4
0
    public static void Reconcile(string DB, DateTime date, string xml)
    {
        /*
         * string xmlString =
         *    @"<?xml version=""1.0"" encoding=""UTF-8""?>
         *      <reconciliation-detail mid=""200"" tid=""200"" terminal-business-day=""2015-04-14"" total=""1620.00"">
         *      <transaction type=""purchase"" card-type=""visa"" amount=""100.00"" tip=""10.00"" transaction-local-date-time=""2015-04-14 12:30:30"" tyro-reference=""870020"" merchant-reference=""071061048231306351219677"" settlement-date=""2015-04-16""/>
         *      <transaction type=""purchase"" card-type=""mastercard"" amount=""200.00"" transaction-local-date-time=""2015-04-14 12:31:20"" tyro-reference=""885214"" merchant-reference=""071061048231306351219678"" settlement-date=""2015-04-16""/>
         *      <transaction type=""purchase"" card-type=""jcb"" amount=""40.00"" transaction-local-date-time=""2015-04-14 12:33:23"" tyro-reference=""896534"" merchant-reference=""071061048231306351219679""/>
         *      <transaction type=""purchase"" card-type=""amex"" amount=""30.00"" transaction-local-date-time=""2015-04-14 12:36:35"" tyro-reference=""905845"" merchant-reference=""071061048231306351219680""/>
         *      <transaction type=""purchase"" card-type=""eftpos"" amount=""650.00"" cash-out=""50.00"" transaction-local-date-time=""2015-04-14 12:40:30"" tyro-reference=""912556"" merchant-reference=""071061048231306351219681"" settlement-date=""2015-04-16""/>
         *      <transaction type=""purchase"" card-type=""eftpos"" amount=""450.00"" transaction-local-date-time=""2015-04-14 12:50:30"" tyro-reference=""920187"" merchant-reference=""071061048231306351219682"" settlement-date=""2015-04-16""/>
         *      <transaction type=""purchase"" card-type=""diners"" amount=""70.00"" transaction-local-date-time=""2015-04-14 13:30:30"" tyro-reference=""935587"" merchant-reference=""071061048231306351219683""/>
         *      <transaction type=""void"" card-type=""mastercard"" amount=""-80.00"" transaction-local-date-time=""2015-04-14 13:50:30"" tyro-reference=""946585"" merchant-reference=""071061048231306351219684"" settlement-date=""2015-04-16""/>
         *      <transaction type=""purchase"" card-type=""visa"" amount=""170.00"" transaction-local-date-time=""2015-04-14 14:23:25"" tyro-reference=""953594"" merchant-reference=""071061048231306351219685"" settlement-date=""2015-04-16""/>
         *      <transaction type=""refund"" card-type=""visa"" amount=""-70.00"" transaction-local-date-time=""2015-04-14 15:41:12"" tyro-reference=""962548"" merchant-reference=""071061048231306351219685"" settlement-date=""2015-04-16""/>
         *      </reconciliation-detail>";
         */

        StringBuilder debutOutput = new StringBuilder();

        using (XmlReader reader = XmlReader.Create(new StringReader(xml)))
        {
            reader.ReadToFollowing("reconciliation-detail");

            string mid = reader.GetAttribute("mid");
            string tid = reader.GetAttribute("tid");
            string terminal_business_day = reader.GetAttribute("terminal-business-day");
            string total = reader.GetAttribute("total");

            debutOutput.AppendLine("reconciliation-detail :  " +
                                   " mid:" + mid +
                                   " tid:" + tid +
                                   " terminal_business_day:" + terminal_business_day +
                                   " total:" + total);

            while (reader.ReadToFollowing("transaction"))
            {
                string type      = reader.GetAttribute("type");
                string card_type = reader.GetAttribute("card-type");
                string _amount   = reader.GetAttribute("amount");
                string cash_out  = reader.GetAttribute("cash-out");
                string tip       = reader.GetAttribute("tip");
                string transaction_local_date_time = reader.GetAttribute("transaction-local-date-time");
                string tyro_reference     = reader.GetAttribute("tyro-reference");
                string merchant_reference = reader.GetAttribute("merchant-reference");                 // transactionId that we sent in = tyro_payment_pending_id
                string settlement_date    = reader.GetAttribute("settlement-date");

                debutOutput.AppendLine("transaction :  " +
                                       " type:" + type +
                                       " card_type:" + card_type +
                                       " amount:" + _amount +
                                       " cash_out:" + cash_out +
                                       " tip:" + tip +
                                       " transaction_local_date_time:" + transaction_local_date_time +
                                       " tyro_reference:" + tyro_reference +
                                       " merchant_reference:" + merchant_reference +
                                       " settlement_date:" + settlement_date
                                       );


                /*
                 * select * from TyroPaymentPending
                 *
                 * update TyroPaymentPending
                 * set
                 *      tyro_transaction_id = '071061048231306351219677',
                 *      amount = 101.00,
                 *      out_date_processed = NULL,
                 *      out_result = '',
                 *      out_cardType = '',
                 *      out_transactionReference = '',
                 *      out_authorisationCode = '',
                 *      out_issuerActionCode = ''
                 * WHERE tyro_payment_pending_id = 1
                 */


                TyroPaymentPending tyroPaymentPending = TyroPaymentPendingDB.GetByByTyroTransactionID(DB, merchant_reference);

                if (tyroPaymentPending == null)
                {
                    continue;
                }
                if (tyroPaymentPending.OutDateProcessed != DateTime.MinValue)
                {
                    continue;
                }

                int tyro_payment_type_id = -1;
                if (type == "purchase")
                {
                    tyro_payment_type_id = 1;
                }
                else if (type == "refund")
                {
                    tyro_payment_type_id = 2;
                }

                bool sucessfulTransaction = (tyro_payment_type_id == 1 || tyro_payment_type_id == 2);
                if (sucessfulTransaction)
                {
                    decimal amount;
                    if (!Decimal.TryParse(_amount, out amount))
                    {
                        Emailer.SimpleAlertEmail(
                            "Tyro invoice late payment added but amount is not decimal type (" + _amount + ")<br />tyro_payment_pending_id: " + tyroPaymentPending.TyroPaymentPendingID + "<br />Invoice: " + tyroPaymentPending.InvoiceID + "<br />DB: " + DB + "<br /><br />" + xml.Replace("<", "&lt;").Replace(">", "&gt;").Replace(Environment.NewLine, "<br />"),
                            "Tyro Reconcilliation Amount Not Decimal Type. Invoice : " + tyroPaymentPending.InvoiceID,
                            true);
                        continue;
                    }

                    DateTime transactionDateTime;
                    if (!DateTime.TryParseExact(transaction_local_date_time, "yyyy-dd-MM hh:mm:ss", CultureInfo.InvariantCulture, DateTimeStyles.None, out transactionDateTime))
                    {
                        Emailer.SimpleAlertEmail(
                            "Tyro invoice late payment added but transaction_local_date_time is not parsable (" + transaction_local_date_time + ")<br />tyro_payment_pending_id: " + tyroPaymentPending.TyroPaymentPendingID + "<br />Invoice: " + tyroPaymentPending.InvoiceID + "<br />DB: " + DB + "<br /><br />" + xml.Replace("<", "&lt;").Replace(">", "&gt;").Replace(Environment.NewLine, "<br />"),
                            "Tyro Reconcilliation Amount Not Decimal Type. Invoice : " + tyroPaymentPending.InvoiceID,
                            true);
                        continue;
                    }

                    TyroPaymentPendingDB.UpdateByTyroTransactionID(DB, merchant_reference, "APPROVED", card_type, tyro_reference, "", "", transactionDateTime);

                    if (amount != tyroPaymentPending.Amount)
                    {
                        Emailer.SimpleAlertEmail(
                            "Tyro invoice late payment added but initial payment amount and reconcilliation ammount differ (" + tyroPaymentPending.Amount + ", " + amount + ")<br />tyro_payment_pending_id: " + tyroPaymentPending.TyroPaymentPendingID + "<br />Invoice: " + tyroPaymentPending.InvoiceID + "<br />DB: " + DB,
                            "Tyro Reconcilliation Amounts Differ. Invoice : " + tyroPaymentPending.InvoiceID,
                            true);
                    }

                    if (tyroPaymentPending.TyroPaymentTypeID != tyro_payment_type_id)
                    {
                        Emailer.SimpleAlertEmail(
                            "Tyro invoice late payment added but payment types differ (" + tyroPaymentPending.TyroPaymentTypeID + ", " + tyro_payment_type_id + ")<br />tyro_payment_pending_id: " + tyroPaymentPending.TyroPaymentPendingID + "<br />Invoice: " + tyroPaymentPending.InvoiceID + "<br />DB: " + DB,
                            "Tyro Reconcilliation Types Differ. Invoice : " + tyroPaymentPending.InvoiceID,
                            true);
                    }


                    Invoice invoice = InvoiceDB.GetByID(tyroPaymentPending.InvoiceID, DB);

                    if (tyroPaymentPending.TyroPaymentTypeID == 1) // payment
                    {
                        decimal totalOwed  = invoice.TotalDue - tyroPaymentPending.Amount;
                        bool    isOverPaid = totalOwed < 0;
                        bool    isPaid     = totalOwed <= 0;

                        ReceiptDB.Insert(DB, 364, tyroPaymentPending.InvoiceID, tyroPaymentPending.Amount, 0, false, isOverPaid, DateTime.MaxValue, -8);

                        if (isPaid)
                        {
                            InvoiceDB.UpdateIsPaid(DB, invoice.InvoiceID, true);
                        }

                        if (isOverPaid)
                        {
                            // send email to someone .. to fix up the overpayment....
                            Emailer.SimpleAlertEmail(
                                "Tyro invoice late payment added and is overpaid.<br />tyro_payment_pending_id: " + tyroPaymentPending.TyroPaymentPendingID + "<br />Invoice: " + invoice.InvoiceID + "<br />DB: " + DB,
                                "Tyro Invoice OverPaid: " + invoice.InvoiceID,
                                true);
                        }
                    }
                    if (tyroPaymentPending.TyroPaymentTypeID == 2) // refund
                    {
                        amount = amount * -1;                      // reconcilliation report shows refund amount as negative amounts

                        decimal totalOwed = invoice.TotalDue + tyroPaymentPending.Amount;
                        bool    isPaid    = totalOwed <= 0;

                        RefundDB.Insert(tyroPaymentPending.InvoiceID, tyroPaymentPending.Amount, 308, "", -8, DB);

                        if (totalOwed > 0)
                        {
                            InvoiceDB.UpdateIsPaid(DB, tyroPaymentPending.InvoiceID, false);
                        }
                    }

                    Emailer.SimpleAlertEmail(
                        "Tyro Invoice Payment Updated Asynchonously (ie Late). <br />tyro_payment_pending_id: " + tyroPaymentPending.TyroPaymentPendingID + "<br />Invoice: " + invoice.InvoiceID + "<br />DB: " + DB,
                        "Tyro Invoice Payment Updated Asynchonously (ie Late). Invoice: " + invoice.InvoiceID,
                        true);
                }
            }
        }

        Logger.LogQuery(debutOutput.ToString());
    }
コード例 #5
0
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        if (GetUrlParamType() == UrlParamType.View)
        {
            Response.Redirect(UrlParamModifier.AddEdit(Request.RawUrl, "type", "edit"));
        }
        //else if (GetUrlParamType() == UrlParamType.Edit)
        //{
        //    if (!IsValidFormID())
        //    {
        //        HideTableAndSetErrorMessage();
        //        return;
        //    }
        //    Receipt receipt = ReceiptDB.GetByID(GetFormID());
        //    if (receipt == null)
        //    {
        //        HideTableAndSetErrorMessage("Invalid receipt ID");
        //        return;
        //    }

        //    ReceiptDB.Update(receipt.ReceiptID, Convert.ToInt32(ddlPaymentType.SelectedValue), Convert.ToDecimal(txtTotal.Text), Convert.ToDecimal(txtAmountReconciled.Text), chkFailedToClear.Checked, receipt.IsOverpaid, GetBankProcessedDateFromForm());

        //    Response.Redirect(UrlParamModifier.AddEdit(Request.RawUrl, "type", "view_only"));


        //    // close this window
        //    //Page.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script language=javascript>window.returnValue=false;self.close();</script>");
        //}
        else if (GetUrlParamType() == UrlParamType.Add)
        {
            if (!IsValidFormID())
            {
                HideTableAndSetErrorMessage();
                return;
            }
            Invoice invoice = InvoiceDB.GetByID(GetFormID());
            if (invoice == null)
            {
                HideTableAndSetErrorMessage("Invalid invoice ID");
                return;
            }

            decimal thisRefundAmount = Convert.ToDecimal(txtTotal.Text);
            if (thisRefundAmount > invoice.ReceiptsTotal)
            {
                SetErrorMessage("Can not be more than the amount receipted.");
                return;
            }


            if (!invoice.IsPaID)
            {
                int credit_note_id = CreditNoteDB.Insert(invoice.InvoiceID, invoice.TotalDue, "Auto credit noted to set inv as paid so can refund.", Convert.ToInt32(Session["StaffID"]));
                InvoiceDB.UpdateIsPaid(null, invoice.InvoiceID, true);
            }

            int refund_id = RefundDB.Insert(invoice.InvoiceID, thisRefundAmount, Convert.ToInt32(ddlRefundReason.SelectedValue), txtComment.Text, Convert.ToInt32(Session["StaffID"]));
            InvoiceDB.UpdateIsRefund(invoice.InvoiceID, true);


            // close this window
            Page.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script language=javascript>window.returnValue=false;self.close();</script>");
        }
        else
        {
            HideTableAndSetErrorMessage("", "Invalid URL Parameters");
        }
    }