/* * -------------------------------------------------------------------------------------------- * IMPLEMENTATION TO BE USED IN LAB 2. * -------------------------------------------------------------------------------------------- */ // Here you need to implement your own methods that call the stored procedures // addStudent and addStudentPhoneNo public int addStudentControl(DBLab.Student student) { connection = new SqlConnection(connectionString); connection.Open(); SqlCommand cmd = new SqlCommand("addStudent", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@StudentID", System.Data.SqlDbType.VarChar); cmd.Parameters["@StudentID"].Value = student.getID(); cmd.Parameters.Add("@FirstName", System.Data.SqlDbType.VarChar); cmd.Parameters["@Firstname"].Value = student.getFirstname(); cmd.Parameters.Add("@LastName", System.Data.SqlDbType.VarChar); cmd.Parameters["@LastName"].Value = student.getLastname(); cmd.Parameters.Add("@Zipcode", System.Data.SqlDbType.Int); cmd.Parameters["@Zipcode"].Value = Int32.Parse(student.getZipcode()); cmd.Parameters.Add("@Gender", System.Data.SqlDbType.VarChar); cmd.Parameters["@Gender"].Value = student.getGender(); cmd.Parameters.Add("@StreetAddress", System.Data.SqlDbType.VarChar); cmd.Parameters["@StreetAddress"].Value = student.getStreetAddress(); cmd.Parameters.Add("@City", System.Data.SqlDbType.VarChar); cmd.Parameters["@City"].Value = student.getCity(); cmd.Parameters.Add("@Country", System.Data.SqlDbType.VarChar); cmd.Parameters["@Country"].Value = student.getCountry(); cmd.Parameters.Add("@Birthdate", System.Data.SqlDbType.VarChar); cmd.Parameters["@Birthdate"].Value = student.getBirthDate(); cmd.Parameters.Add("@StudentType", System.Data.SqlDbType.VarChar); cmd.Parameters["@StudentType"].Value = student.getType(); try { int rowNr; rowNr = cmd.ExecuteNonQuery(); connection.Close(); return(rowNr); } catch (SqlException b) { //MessageBox.Show(b.Number.ToString()); MessageBox.Show(b.Message.ToString()); } return(0); }
public int addPhoneControl(DBLab.Student student) { int rownr = 0; // SqlDataReader rownr; for (int i = 0; i < student.getPhoneNumbers().Count; i++) { connection = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand("addStudentPhoneNo", connection); cmd.CommandType = CommandType.StoredProcedure; connection.Open(); cmd.Parameters.Add("@StudentID", System.Data.SqlDbType.VarChar); cmd.Parameters["@StudentID"].Value = student.getID(); cmd.Parameters.Add("@TelNo", System.Data.SqlDbType.Int); cmd.Parameters["@TelNo"].Value = Int32.Parse(student.getPhoneNumbers()[i]); cmd.Parameters.Add("@phoneType", System.Data.SqlDbType.VarChar); cmd.Parameters["@phoneType"].Value = student.getPhoneType()[i]; try { //rownr = cmd.ExecuteReader(); if (cmd.ExecuteNonQuery() == 1) { rownr++; } connection.Close(); } catch (SqlException d) { //MessageBox.Show(b.Number.ToString()); MessageBox.Show(d.Message.ToString()); } } connection.Close(); return(rownr); }