public void InsertPieceOfFurniture(PieceOfFurniture pieceoffurniture) { using (SqlConnection connection = CreateConnection()) { try { SqlCommand command = new SqlCommand("appSchema.usp_NyMöbel", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@Beskrivning", SqlDbType.VarChar, 50).Value = pieceoffurniture.Description; command.Parameters.Add("@Pris", SqlDbType.Decimal, 6).Value = pieceoffurniture.Price; command.Parameters.Add("@Inköpspris", SqlDbType.Decimal, 6).Value = pieceoffurniture.BuyingPrice; command.Parameters.Add("@Antal", SqlDbType.Int, 4).Value = pieceoffurniture.Quantity; command.Parameters.Add("@MöbelID", SqlDbType.Int, 4).Direction = ParameterDirection.Output; connection.Open(); command.ExecuteNonQuery(); pieceoffurniture.PieceOfFurnitureID = (int)command.Parameters["@MöbelID"].Value; } catch { throw new ApplicationException("Ett fel uppstod i dataåtkomstlagret."); } } }
public void FurnitureListView_InsertItem(PieceOfFurniture pieceoffurniture) { if (ModelState.IsValid) { try { Service.SavePieceOfFurniture(pieceoffurniture); Label1.Visible = true; } catch (Exception) { ModelState.AddModelError(String.Empty, "Ett oväntat fel inträffade då möbeluppgift skulle läggas till."); } } }