private void updateCustom_Click(object sender, EventArgs e)
{
StockUpdateSdi stockUpdateSdi = new StockUpdateSdi();
stockUpdateSdi.Isbn = Convert.ToInt32(isbnTextBox.Text);
stockUpdateSdi.Grade = gradeTextBox.Text;
stockUpdateSdi.Amount = Convert.ToInt32(amountTextBox.Text);
stockUpdateSdi.OrderCost = Convert.ToInt32(orderCostTextBox.Text);
Stock stock = stockService.updateStock(stockUpdateSdi);
if (stock != null)
{
this.Close();
stockForm.updateDataToTable(stock);
}
}
public Stock updateStock(StockUpdateSdi stockUpdateSdi)
{
con = SqlServerConnection.getConnnection();
con.Open();
StringBuilder sql = new StringBuilder();
sql.Append(" update Stock set " +
" amount = @amount, " +
" ordercost = @ordercost ");
sql.Append(" where isbn = @isbn and grade = @grade");
SqlCommand command = new SqlCommand(sql.ToString(), con);
command.Parameters.AddWithValue("amount", stockUpdateSdi.Amount);
command.Parameters.AddWithValue("ordercost", stockUpdateSdi.OrderCost);
command.Parameters.AddWithValue("isbn", stockUpdateSdi.Isbn);
command.Parameters.AddWithValue("grade", stockUpdateSdi.Grade);
command.ExecuteNonQuery();
con.Close();
return(this.getStockByCode(stockUpdateSdi.Grade, stockUpdateSdi.Isbn));
}
public Stock updateStock(StockUpdateSdi stockUpdateSdi)
{
return(stockRepoService.updateStock(stockUpdateSdi));
}
