/*
* --------------------------------------------------------------------------------------------
* 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);
}
/*Creates a student and sets all the instance variables in Student*/
private void createStudent()
{
student = new DBLab.Student();
student.Setfirstname(firstnameBox.Text);
student.setLastname(lastnameBox.Text);
student.setID(studentIDBox.Text);
student.setGender(genderComboBox.Text);
student.setCity(cityBox.Text);
student.Setbirthdate(dateTimePicker1.Value.ToString());
student.setType(StudentTypeComboBox.Text);
student.setStreetAddress(streetAdressBox.Text);
student.setCountry(countryBox.Text);
student.setZipcode(zipcodeBox.Text);
student.setPhoneNumber(phoneNumbers);
student.setPhoneTypes(phoneTypes);
}
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);
}
