public static string SaveTransaction(LouACH.Events.EventTransaction transaction)
{
string queryString = "insert into EVENT_TRANSACTIONS values(1,:T_RGID,CURRENT_TIMESTAMP,:T_CD,:T_ST,:T_LN) RETURNING TransactionID INTO :id";
string Response = "";
using (OracleConnection connection = new OracleConnection(connectionString))
using (OracleCommand command = new OracleCommand(queryString, connection))
{
command.Parameters.Add("T_RGID", transaction.RegistrationID);
command.Parameters.Add("T_CD", transaction.TransactionCode);
command.Parameters.Add("T_ST", transaction.AmountPaid);
command.Parameters.Add("T_LN", transaction.LineItem);
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);
}
public static string UpdateTransaction(LouACH.Events.EventTransaction transaction)
{
string queryString = "UPDATE EVENT_TRANSACTIONS set TransactionCode =:T_CD) where TransactionID = :keyValue";
string Response = "";
using (OracleConnection connection = new OracleConnection(connectionString))
using (OracleCommand command = new OracleCommand(queryString, connection))
{
command.Parameters.Add("T_CD", transaction.TransactionCode);
command.Parameters.Add("keyValue", transaction.TransactionID);
command.Connection.Open();
command.ExecuteNonQuery();
command.Connection.Close();
}
return(Response);
}
protected void Page_Load(object sender, EventArgs e)
{
//customerAddress = new customerAddressType
//{
// firstName = "John",
// lastName = "Doe",
// address = "123 My St",
// city = "OurTown",
// zip = "98004"
//};
//creditCard = new creditCardType
//{
//cardNumber = "4111111111111111",
//expirationDate = "0718",
//cardCode = "123"
//};
fName = LouACH.RegistrationPay.person.PersonfName;
lName = LouACH.RegistrationPay.person.PersonlName;
Meal = LouACH.RegistrationPay.registration.LineItems;
AmountDue = LouACH.RegistrationPay.registration.Amount;
if (AmountDue == 0.00m)
{
Server.Transfer("EventReceiptNoCharge.aspx?fName=" + fName + "&lName=" + lName + "&Meal=" + Meal, true);
}
{
sAmountDue = AmountDue.ToString("0.##");
}
List <Events.EventTransaction> allTransactions = new List <Events.EventTransaction> ();
//foreach (transaction eTransaction in allTransactions)
//{
//}
if (Request.Form["gName"] != "")
{
Transaction1 = new Events.EventTransaction
{
RegistrationID = LouACH.RegistrationPay.registration.RegistrationID,
AmountPaid = 200.00m,
LineItem = "Guest " + Request.Form["gName"] + " meal(" + Request.Form["gMeal"] + ")",
AccountID = "1"
};
allTransactions.Add(Transaction1);
gName = Request.Form["gName"];
gMeal = Request.Form["gMeal"];
}
;
if (Request.Form["PIASCDonate"] != "0")
{
Transaction2 = new Events.EventTransaction
{
RegistrationID = LouACH.RegistrationPay.registration.RegistrationID,
AmountPaid = System.Convert.ToDecimal(Request.Form["PIASCDonate"]),
LineItem = "PIASC Donation",
AccountID = "2"
};
allTransactions.Add(Transaction2);
}
;
if (Request.Form["IPMDonate"] != "0")
{
Transaction3 = new Events.EventTransaction
{
RegistrationID = LouACH.RegistrationPay.registration.RegistrationID,
AmountPaid = System.Convert.ToDecimal(Request.Form["IPMDonate"]),
LineItem = "IPM Donatation",
AccountID = "2"
};
allTransactions.Add(Transaction3);
}
;
if (Request.Form["PPACDonate"] != "0")
{
Transaction4 = new Events.EventTransaction
{
RegistrationID = LouACH.RegistrationPay.registration.RegistrationID,
AmountPaid = System.Convert.ToDecimal(Request.Form["PPACDonate"]),
LineItem = "PPAC Donatation",
AccountID = "2"
};
allTransactions.Add(Transaction4);
}
;
foreach (Events.EventTransaction eTransaction in allTransactions)
{
//Response.Write(eTransaction.LineItem);
//Write to DB
eTransaction.TransactionID = Convert.ToInt32(LouACH.DataBaseTransactions.DataBase.SaveTransaction(eTransaction));
}
}
