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