public static string WriteEventTransactionDataNoCharge(LouACH.Events.Registration registration) { string queryString = "insert into EVENT_REGISTRATION (RegistrationID,EventID,PersonID,RegistrationDate) values(1,:EV_ID,:P_ID,CURRENT_TIMESTAMP)"; using (OracleConnection connection = new OracleConnection(connectionString)) using (OracleCommand command = new OracleCommand(queryString, connection)) { //command.Parameters.Add("REG_NO", EventTransaction.routingNumber); //command.Parameters.Add("EV_ID", EventTransaction.EventID); //command.Parameters.Add("P_ID", EventTransaction.AttendeeID); //command.Parameters.Add("AMT", EventTransaction.AmountPaid); //command.Parameters.Add("REG_NO", 5); command.Parameters.Add("EV_ID", registration.EventID); command.Parameters.Add("P_ID", registration.PersonID); command.Connection.Open(); command.ExecuteNonQuery(); command.Connection.Close(); } return("Success"); }
public static string GetRegistrationID(LouACH.Events.Registration registration) { string queryString = "insert into EVENT_REGISTRATION values(1,:R_EVID,:R_PID,CURRENT_TIMESTAMP,:R_AMT) RETURNING RegistrationID INTO :id"; string Response = ""; using (OracleConnection connection = new OracleConnection(connectionString)) using (OracleCommand command = new OracleCommand(queryString, connection)) { command.Parameters.Add("R_EVID", registration.EventID); command.Parameters.Add("R_PID", registration.PersonID); command.Parameters.Add("R_AMT", registration.Amount); command.Parameters.Add(new OracleParameter ( ":id", OracleDbType.Int32, ParameterDirection.Output )); command.Connection.Open(); command.ExecuteNonQuery(); Response = command.Parameters[":id"].Value.ToString(); command.Connection.Close(); } return(Response); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { person = new Events.Person { PersonfName = Request.Form["txtFName"], PersonlName = Request.Form["txtLName"], PersonEMail = Request.Form["txtEMail"], }; person.PersonID = Convert.ToInt32(LouACH.DataBaseTransactions.DataBase.GetPersonID(person)); registration = new Events.Registration { EventID = 1, PersonID = person.PersonID, Amount = 0.00m, LineItems = "Meal:" + Request.Form["rMeal"] }; registration.RegistrationID = Convert.ToInt32(LouACH.DataBaseTransactions.DataBase.GetRegistrationID(registration)); if (Request.Form["txtGuestName"] != "") { registration.LineItems = registration.LineItems + ",GuestName:" + Request.Form["txtGuestName"] + ",Guest Meal:" + Request.Form["gMeal"]; gName = Request.Form["txtGuestName"]; gMeal = Request.Form["gMeal"]; sgName = " and " + Request.Form["txtGuestName"]; sgMeal = " and " + Request.Form["gMeal"]; gAmount = 200.00m; AmountDue = 200.00m; registration.Amount = AmountDue; } ; //foreach (string s in Request.Form.Keys) //{ // if (s == "txtFName") // { // fName = Request.Form["txtFName"]; // } // else if (s == "txtLName") // { // lName = Request.Form["txtLName"]; // } // else if (s == "txtGuestName" && Request.Form["txtGuestName"] != "") // { // gName = Request.Form["txtGuestName"]; // gMeal =Request.Form["gMeal"]; // sgName = " and " + Request.Form["txtGuestName"]; // sgMeal = " and " + Request.Form["gMeal"]; // gAmount = 200.00m; // AmountDue = 200.00m; // } // else if (s == "rMeal") // { // sMeal = "Selected meal: " + Request.Form["rMeal"]; // Meal = Request.Form["rMeal"]; // } //For Test Response.Write(s.ToString() + ":" + Request.Form[s] + " "); } }