public static void addPaymentRecord(PaymentMake obj)
        {
            string cs = ConfigurationManager.ConnectionStrings["BowlingConnectionString"].ConnectionString;

            using (SqlConnection con = new SqlConnection(cs))
            {
                SqlCommand cmd = new SqlCommand("insert into payment values (@cardName,@cardNumber,@secCode,@date)", con);
                con.Open();
                cmd.Parameters.AddWithValue("cardName", obj.cardName);
                cmd.Parameters.AddWithValue("cardNumber", obj.cardNumber);
                cmd.Parameters.AddWithValue("date", obj.date);
                cmd.Parameters.AddWithValue("secCode", obj.secCode);


                cmd.ExecuteNonQuery();
            }
        }
示例#2
0
        protected void Pay_Click(object sender, EventArgs e)
        {
            Customer   Cust           = (Customer)Session["Customer"];
            Receipt    PendingBooking = (Receipt)Session["PendingBooking"];
            LaneTicket LaneTick       = (LaneTicket)Session["LaneTick"];

            String      ExpDate = DropDownListExpMon.SelectedValue + "/" + DropDownListExpYear.SelectedValue;
            PaymentMake obj     = new PaymentMake
            {
                cardName   = txtCardName.Text,
                cardNumber = txtCardNum.Text,
                date       = ExpDate,
                secCode    = txtSecCode.Text
            };

            LaneStatusAccessLayer.addPaymentRecord(obj);
            LaneStatusAccessLayer.addRecord(Cust, PendingBooking, LaneTick);

            Response.Redirect("~/ConfirmForm.aspx");
        }