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] + " ");
}
}
