// Method to insert 'InsertReferenceParty' public void InsertInsertReferenceParty(InsertReferencePartyModel newInsertReferenceParty) { // Calls the InsertReferencePartyDataAccess 'InsertInsertReferenceParty' function. InsertReferencePartyDataAccess da = new InsertReferencePartyDataAccess(SqlConConnectionString); da.InsertInsertReferenceParty(newInsertReferenceParty); }
protected void bAdd_Click(object sender, EventArgs e) { // Instance that populates the properties in that instance from the text in the textboxes. InsertReferencePartyModel newInsertReferenceParty = new InsertReferencePartyModel(); // Calls the InsertReferenceParty function in the InsertReferencePartyController. InsertReferencePartyController con = new InsertReferencePartyController(ConfigurationManager.ConnectionStrings["DBInformation"].ToString()); newInsertReferenceParty.ReferenceFirstName = tbFirstName.Text; newInsertReferenceParty.ReferenceLastName = tbLastName.Text; newInsertReferenceParty.ReferenceCompanyName = tbCompanyName.Text; newInsertReferenceParty.ReferenceAddress = tbRefAddress.Text; newInsertReferenceParty.ReferenceCity = tbRefCity.Text; newInsertReferenceParty.ReferenceState = tbRefState.Text; newInsertReferenceParty.ReferenceZIP = tbRefZip.Text; newInsertReferenceParty.ReferenceEmail = tbEmail.Text; newInsertReferenceParty.ReferencePhoneNumber = tbTelephone.Text; newInsertReferenceParty.ReferencePhoneNumber = tbTelephone2.Text; newInsertReferenceParty.ReferenceFaxNumber = tbFax.Text; con.InsertInsertReferenceParty(newInsertReferenceParty); //string sql = "INSERT into InsertReferencePartyID (FisrtName, LastName, Email, Password, PhoneNumber"; //CreateUserController dbs = new CreateUserController(ConfigurationManager.ConnectionStrings["DBInformation"].ToString()); // dbs.InsertUser(newUser); // Causes the Default page to load. Response.Redirect("Default.aspx", false); }
// A function that inserts a User into the database. public void InsertInsertReferenceParty(InsertReferencePartyModel newInsertReferenceParty) { // Declare a new variable. Variable name is ‘sSQL’. Datatype is ‘string’. string sSQL = ""; // Define the value for the ‘sSQL’ string variable. // Notice that this text is a SQL Query. sSQL += " INSERT [Reference Party] "; // More columns will need to be added, depending on how many columns you have in your User table. // In this line, you need ALL the columns from your User table. // The word ‘Password’ is in brackets because it is a reserved word in SQL. // We are hijacking that word and using it for our own purposes, so we need to put it in brackets. // Normally, SQL would try to interpret the word 'Password' differently than how we're using it. sSQL += " (ReferenceFirstName, LastNameReferenceLastName, ReferenceCompanyName, ReferenceAddress, ReferenceCity, ReferenceState, ReferenceZIP, ReferenceEmail, ReferencePhoneNumber, ReferenceFaxNumber ) "; sSQL += " Values "; // The ‘@’ sign is a SQL Variable. It is connected to a SqlParameter (below). // This line needs to exactly match the list of columns in the User table. sSQL += " (@ReferenceFirstName, @LastNameReferenceLastName, @ReferenceCompanyName, @ReferenceAddress, @ReferenceCity, @ReferenceState, @ReferenceZIP, @ReferenceEmail, @ReferencePhoneNumber, @ReferenceFaxNumber) "; // Declare a new variable. Variable name is ‘sqlcomm’. Datatype is ‘SqlCommand’. SqlCommand sqlcomm = new SqlCommand(); // Assign a value to the CommandText property. sqlcomm.CommandText = sSQL; // This SqlParameter constructor takes two arguments as input values. // Argument One: SQL Variable Name // Argument Two: Variable Value // The SqlParameter handles the declaration of the actual SQL Parameter in the T-SQL. SqlParameter sqlparam = new SqlParameter("FirstName", newInsertReferenceParty.ReferenceFirstName); sqlcomm.Parameters.Add(sqlparam); // Notice that there is one ‘SqlParameter’ variable for each variable used in the SQL Query // More SqlParameter variables will need to be added for additional SQL variables. sqlparam = new SqlParameter("ReferenceLastName", newInsertReferenceParty.ReferenceLastName); sqlcomm.Parameters.Add(sqlparam); sqlparam = new SqlParameter("ReferenceCompanyName", newInsertReferenceParty.ReferenceCompanyName); sqlcomm.Parameters.Add(sqlparam); sqlparam = new SqlParameter("ReferenceAddress", newInsertReferenceParty.ReferenceAddress); sqlcomm.Parameters.Add(sqlparam); sqlparam = new SqlParameter("ReferenceCity", newInsertReferenceParty.ReferenceCity); sqlcomm.Parameters.Add(sqlparam); sqlparam = new SqlParameter("ReferenceState", newInsertReferenceParty.ReferenceState); sqlcomm.Parameters.Add(sqlparam); sqlparam = new SqlParameter("ReferenceZIP", newInsertReferenceParty.ReferenceZIP); sqlcomm.Parameters.Add(sqlparam); sqlparam = new SqlParameter("ReferencEmail", newInsertReferenceParty.ReferenceEmail); sqlcomm.Parameters.Add(sqlparam); sqlparam = new SqlParameter("ReferencePhoneNumber", newInsertReferenceParty.ReferencePhoneNumber); sqlcomm.Parameters.Add(sqlparam); sqlparam = new SqlParameter("ReferenceFaxNumber", newInsertReferenceParty.ReferenceFaxNumber); sqlcomm.Parameters.Add(sqlparam); // Execute the query. ExecNonQuery(sqlcomm); }