private void insertCustom_Click(object sender, EventArgs e) { if (exchangeService.isExistExchange(lcnTextBox.Text, Convert.ToInt32(isbnTextBox.Text), gradeTextBox.Text)) { MessageBox.Show("Exchange already exists", "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (!exchangeService.isExistISBNInMedia(Convert.ToInt32(isbnTextBox.Text))) { MessageBox.Show("isbn does not exist", "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (!exchangeService.isExistGradeInCondition(gradeTextBox.Text)) { MessageBox.Show("grade does not exist", "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (!exchangeService.isExistLibraryCardNumberInPatron(lcnTextBox.Text)) { MessageBox.Show("library card number does not exist", "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { ExchangeInsertSdi exchangeInsertSdi = new ExchangeInsertSdi(); exchangeInsertSdi.LibraryCardNumber = lcnTextBox.Text; exchangeInsertSdi.Isbn = Convert.ToInt32(isbnTextBox.Text); exchangeInsertSdi.Grade = gradeTextBox.Text; exchangeInsertSdi.CheckedInDate = cidTextBox.Value; Exchange exchange = exchangeService.insertExchange(exchangeInsertSdi); if (exchange != null) { this.Close(); exchangeForm.addDataToTable(exchange); } } }
public Exchange insertExchange(ExchangeInsertSdi exchangeInsertSdi) { con = SqlServerConnection.getConnnection(); con.Open(); StringBuilder sql = new StringBuilder(); sql.Append("insert into Exchange (libraryCardNumber,isbn,grade,checkedInDate) values(@librarycardnumber,@isbn,@grade,@checkedindate)"); SqlCommand command = new SqlCommand(sql.ToString(), con); command.Parameters.AddWithValue("librarycardnumber", exchangeInsertSdi.LibraryCardNumber); command.Parameters.AddWithValue("isbn", exchangeInsertSdi.Isbn); command.Parameters.AddWithValue("grade", exchangeInsertSdi.Grade); command.Parameters.AddWithValue("checkedindate", exchangeInsertSdi.CheckedInDate); command.ExecuteNonQuery(); con.Close(); return(this.getExchangeByKey(exchangeInsertSdi.LibraryCardNumber, exchangeInsertSdi.Isbn, exchangeInsertSdi.Grade)); }
public Exchange insertExchange(ExchangeInsertSdi exchangeInsertSdi) { return(exchangeRepoService.insertExchange(exchangeInsertSdi)); }