public Media insertMedia(MediaInsertSdi mediaInsertSdi) { con = SqlServerConnection.getConnnection(); con.Open(); StringBuilder sql = new StringBuilder(); sql.Append("insert into Media values(@isbn,@title,@year,@publisher,@type,@subject)"); SqlCommand command = new SqlCommand(sql.ToString(), con); command.Parameters.AddWithValue("isbn", mediaInsertSdi.Isbn); command.Parameters.AddWithValue("title", mediaInsertSdi.Title); command.Parameters.AddWithValue("year", DateTime.Parse(mediaInsertSdi.Year)); command.Parameters.AddWithValue("publisher", mediaInsertSdi.Publisher); command.Parameters.AddWithValue("type", mediaInsertSdi.Type); command.Parameters.AddWithValue("subject", mediaInsertSdi.Subject); command.ExecuteNonQuery(); con.Close(); return(this.getMediaByIsbn(mediaInsertSdi.Isbn)); }
private void insertCustom_Click(object sender, EventArgs e) { if (this.isNumber(isbnTextBox.Text)) { MediaInsertSdi mediaInsertSdi = new MediaInsertSdi(); mediaInsertSdi.Isbn = Convert.ToInt32(isbnTextBox.Text); mediaInsertSdi.Title = titleTextBox.Text; mediaInsertSdi.Year = yearTextBox.Text; mediaInsertSdi.Publisher = publisherTextBox.Text; mediaInsertSdi.Subject = subjectTextBox.Text; mediaInsertSdi.Type = typeTextBox.Text; Media media = mediaService.insertMedia(mediaInsertSdi); if (media != null) { this.Close(); mediaForm.addDataToTable(media); } } else { MessageBox.Show("isbn is not valid", "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }