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)); } }