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