private void btn_AddAuthor_Click(object sender, EventArgs e) { this.Hide(); AddAuthor form2 = new AddAuthor(); form2.ShowDialog(); this.Show(); }
private void btnFindAuthor_Click(object sender, EventArgs e) { int count; string firstName = txtFirstName.Text; string lastName = txtLastName.Text; using (conn = new SqlConnection(connectionString)) using (SqlCommand comd = new SqlCommand( "select count(a.AuthorID) AS aID from LibraryDB.dbo.Author a " + "where a.AuthorFirstName = @firstName and a.AuthorLastName = @lastName", conn)) using (SqlDataAdapter adapter = new SqlDataAdapter(comd)) { comd.Parameters.AddWithValue("@firstName", firstName); comd.Parameters.AddWithValue("@lastName", lastName); DataTable AuthorTable = new DataTable(); adapter.Fill(AuthorTable); DataRow dr = AuthorTable.Rows[0]; count = int.Parse(dr["aID"].ToString()); if (count == 0) { //open add author form AddAuthor form3 = new AddAuthor(); form3.SetFirstName = firstName; form3.SetLastName = lastName; form3.ShowDialog(); txt_AuthorID.Text = form3.ReturnNewID.ToString(); } else if (count == 1) { using (SqlCommand cmd = new SqlCommand( "select AuthorID from LibraryDB.dbo.Author " + "where AuthorFirstName = @firstName and AuthorLastName = @lastName", conn)) using (SqlDataAdapter adapter2 = new SqlDataAdapter(cmd)) { cmd.Parameters.AddWithValue("@firstName", firstName); cmd.Parameters.AddWithValue("@lastName", lastName); DataTable AuthorIDtable = new DataTable(); adapter2.Fill(AuthorIDtable); DataRow dr2 = AuthorIDtable.Rows[0]; txt_AuthorID.Text = dr2["AuthorID"].ToString(); } } else { //load form to select correct author AuthorSelect form_Author = new AuthorSelect(); form_Author.FirstName = txtFirstName.Text; form_Author.LastName = txtLastName.Text; form_Author.ShowDialog(); selectedID = form_Author.SelectedID; txt_AuthorID.Text = selectedID.ToString(); } } }