private void frmRecordPayment_Load(object sender, EventArgs e)
{
//determine next RenewalID
int nextRenewalID = Renewals.getNextRenewalID();
//Put next RenewalID Into textbox
txtRecPayRenewalID.Text = nextRenewalID.ToString();
//Fill grdRecordPayment DataGridView with useful information needed to easily record a payment.
grdRecordPayment.DataSource = Renewals.getRecordPaymentInformation().Tables[0];
//GET MEMBER IDs + FILL IN COMBOBOX
Array comboData = Utility.getMemberIDs();
foreach (var item in comboData)
{
cboRecPayMemberID.Items.Add(item.ToString());
}
//Get Member Type Prices + FILL IN COMBOBOX
Array comboPrice = Utility.getTypePrice();
foreach (var price in comboPrice)
{
cboRecPayAmount.Items.Add(price.ToString());
}
}
//ADD MEMBERS
public void addMember()
{
int RenewalID = Renewals.getNextRenewalID();
OracleConnection conn = new OracleConnection(DBConnect.oradb);
conn.Open();
//SQL Query
String strSQL = "INSERT INTO GOLFMEMBERSLOG (MEMBERID, FIRSTNAME, LASTNAME, STREET, TOWN, COUNTY, MOBILE, EMAIL, MEMBERSTATUS, SIGNUPDATE, TYPEID, PAID) VALUES (" +
this.memberID + ", '" + this.firstName + "', '" + this.lastName + "', '" + this.street + "', '" + this.town + "', '" + this.county + "', '" + this.mobile + "', '" +
this.email + "', '" + this.memberStatus + "', SYSDATE " + ", '" + this.typeID + "', 'n')";
//Make a blank payment to allow the renewals to work
String strSQL2 = "INSERT INTO RENEWALS(RENEWALID, MEMBERID, AMOUNTPAID, DATEPAID) VALUES('" + RenewalID + "','" + this.memberID + "'," + 0 + ",SYSDATE)";
OracleCommand cmd = new OracleCommand(strSQL, conn);
OracleCommand cmd2 = new OracleCommand(strSQL2, conn);
cmd.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
conn.Close();
}
