public static string GetPersonID(LouACH.Events.Person person) { string queryString = "insert into PERSON(PersonID,FirstName,LastName,EMail) values(1,:P_FN,:P_LN,:P_EM) RETURNING PersonID INTO :id"; string Response = ""; using (OracleConnection connection = new OracleConnection(connectionString)) using (OracleCommand command = new OracleCommand(queryString, connection)) { command.Parameters.Add("P_FN", person.PersonfName); command.Parameters.Add("P_LN", person.PersonlName); command.Parameters.Add("P_EM", person.PersonEMail); 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] + " "); } }