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