private void updateCustom_Click(object sender, EventArgs e)
{
ExchangeUpdateSdi exchangeUpdateSdi = new ExchangeUpdateSdi();
exchangeUpdateSdi.Isbn = Convert.ToInt32(isbnTextBox.Text);
exchangeUpdateSdi.Grade = gradeTextBox.Text;
exchangeUpdateSdi.CheckedInDate = cidTextBox.Value;
exchangeUpdateSdi.LibraryCardNumber = lcnTextBox.Text;
Exchange exchange = exchangeService.updateExchange(exchangeUpdateSdi);
if (exchange != null)
{
this.Close();
exchangeForm.updateDataToTable(exchange);
}
}
public Exchange updateExchange(ExchangeUpdateSdi exchangeUpdateSdi)
{
con = SqlServerConnection.getConnnection();
con.Open();
StringBuilder sql = new StringBuilder();
sql.Append(" update Exchange set " +
" checkedInDate = @checkedindate ");
sql.Append(" where isbn = @isbn and grade = @grade and libraryCardNumber = @librarycardnumber");
SqlCommand command = new SqlCommand(sql.ToString(), con);
command.Parameters.AddWithValue("checkedindate", exchangeUpdateSdi.CheckedInDate);
command.Parameters.AddWithValue("isbn", exchangeUpdateSdi.Isbn);
command.Parameters.AddWithValue("grade", exchangeUpdateSdi.Grade);
command.Parameters.AddWithValue("librarycardnumber", exchangeUpdateSdi.LibraryCardNumber);
command.ExecuteNonQuery();
con.Close();
return(this.getExchangeByKey(exchangeUpdateSdi.LibraryCardNumber, exchangeUpdateSdi.Isbn, exchangeUpdateSdi.Grade));
}
public Exchange updateExchange(ExchangeUpdateSdi exchangeUpdateSdi)
{
return(exchangeRepoService.updateExchange(exchangeUpdateSdi));
}
