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);
}
}
