예제 #1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            CustomerOrderReceipt rpt = new CustomerOrderReceipt();

            rpt.Site = this.Site;
            return(rpt);
        }
        private void Customer_Payment_Receipt_Load(object sender, EventArgs e)
        {
            CustomerOrderReceipt receipt = new CustomerOrderReceipt();

            if (dB.IsConnect())
            {
                var cmd  = new MySqlCommand("SELECT `order_status_id` FROM `order_status` WHERE `order_status_name` = 'Ready'", dB.Connection);
                var read = cmd.ExecuteReader();
                read.Read();
                if (read.HasRows)
                {
                    status = Convert.ToInt32(read[0]);
                }
                read.Close();

                var cmdUpdateStatus = new MySqlCommand("UPDATE `order` SET `order_status_id` = '" + status + "' WHERE `order_id` = '" + Order_ID + "'", dB.Connection);
                var change          = cmdUpdateStatus.ExecuteReader();
                change.Close();

                var command = new MySqlCommand("SELECT `product_price`, `order_line_quantity`, `customer_phone`, `customer_email` FROM `product`, `order_line`, `customer`, `order` " +
                                               "WHERE `order_line`.`order_id` = '" + Order_ID + "' AND `product`.`product_id` = `order_line`.`product_id` AND `order`.`customer_id` = `customer`.`customer_id` AND `order`.`order_id` = `order_line`.`order_id`", dB.Connection);
                var reader = command.ExecuteReader();
                while (reader.Read())
                {
                    subTotal     += ((Convert.ToInt32(reader[1])) * (Convert.ToDecimal(reader[0])));
                    customerEmail = reader[3].ToString();
                    customerPhone = reader[2].ToString();
                    productQty   += 1;
                }
                reader.Close();
            }
            vatAmount = subTotal * Convert.ToDecimal(0.15);
            decimal sub = subTotal - vatAmount;

            receipt.SetParameterValue("pName", customerName);
            receipt.SetParameterValue("pPhone", customerPhone);
            receipt.SetParameterValue("pEmail", customerEmail);
            receipt.SetParameterValue("pOrderID", Order_ID);
            receipt.SetParameterValue("pPayDate", date.ToString("yyyy-M-dd"));
            receipt.SetParameterValue("pQty", productQty);
            receipt.SetParameterValue("pVat", "R" + vatAmount.ToString("0.##"));
            receipt.SetParameterValue("pSubTotal", "R" + sub.ToString("0.##"));
            receipt.SetParameterValue("pOrderTotal", "R" + subTotal.ToString("0.##"));
            customerOrderReceipt.ReportSource = receipt;
            customerOrderReceipt.Refresh();
            productQty = 0;
        }