public static void registerMember(string ti, string fn, string ln, string a, string c, string p, string te, string ty) { try { OleDbConnection myConnection = DBConnectivity.GetConnection(); String myQuery = "INSERT INTO Member(Title, FirstName, Surname, Address, County, PostCode, Telephone, TypeOfMember) VALUES (@ti, @fn, @ln, @a, @c, @p, @te, @t)"; OleDbCommand myCommand = new OleDbCommand(myQuery, myConnection); myCommand.Parameters.Add("@ti", OleDbType.VarChar).Value = ti; myCommand.Parameters.Add("@fn", OleDbType.VarChar).Value = fn; myCommand.Parameters.Add("@ln", OleDbType.VarChar).Value = ln; myCommand.Parameters.Add("@a", OleDbType.VarChar).Value = a; myCommand.Parameters.Add("@c", OleDbType.VarChar).Value = c; myCommand.Parameters.Add("@p", OleDbType.VarChar).Value = p; myCommand.Parameters.Add("@te", OleDbType.VarChar).Value = te; myCommand.Parameters.Add("@ty", OleDbType.VarChar).Value = ty; try { myConnection.Open(); myCommand.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine("Exception in DBHandler", ex); } finally { myConnection.Close(); } } catch (Exception ex) { MessageBox.Show("Error connecting to database"); } }
//Aquire information to edit the Stock field in the database public void stock() { String DVDminus = cboLoanDVDID.Text; String DVDadd = cboReturnLoanID.Text; if (tabControl1.SelectedIndex == 1) { OleDbConnection myConnection = DBConnectivity.GetConnection(); String myQuery = "SELECT DVDID FROM DVD WHERE DVDID=" + DVDminus + ""; OleDbCommand myCommand = new OleDbCommand(myQuery, myConnection); int DVDID; String DVDIDStr; try { myConnection.Open(); OleDbDataReader reader = myCommand.ExecuteReader(); while (reader.Read()) { DVDID = Int32.Parse(reader["DVDID"].ToString()); DVDIDStr = DVDID.ToString(); Loan.stockMinus(DVDminus); } reader.Close(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } finally { myConnection.Close(); } } if (tabControl1.SelectedIndex == 2) { OleDbConnection myConnection = DBConnectivity.GetConnection(); String myQuery = "SELECT DVDID FROM Loan WHERE LoanID=" + DVDadd + ""; OleDbCommand myCommand = new OleDbCommand(myQuery, myConnection); String DVDIDStr; try { myConnection.Open(); OleDbDataReader reader = myCommand.ExecuteReader(); while (reader.Read()) { DVDIDStr = reader["DVDID"].ToString(); Loan.stockAdd(DVDIDStr); } reader.Close(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } finally { myConnection.Close(); } } refreshTable(); }
public void fillFilmTitle(string cS) { OleDbConnection myConnection = DBConnectivity.GetConnection(); DataTable dt = new DataTable(); String myQuery = "SELECT DVDTitle FROM DVD WHERE DVDID=" + cS + ""; }