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