protected void UpdateShipButton_OnClick(object sender, EventArgs e) { var shipId = ShipIdTextBox.Text; var shipName = ShipNameTextBox.Text; var tonnage = decimal.Parse(TonnageTextBox.Text); SqlCommandExecutor.ExecuteSqlCommand(cmd => { cmd.CommandText = $"EXEC UpdateShip {shipId}, '{shipName}', {tonnage}"; cmd.ExecuteNonQuery(); }); }
protected void CreateShipButton_Click(object sender, EventArgs e) { var shipName = ShipNameTextBox.Text; var tonnage = decimal.Parse(TonnageTextBox.Text); var imoNumber = ImoNumberTextBox.Text; SqlCommandExecutor.ExecuteSqlCommand(cmd => { const int hasImoNumberBeenVerified = 0; const int isImoNumberValid = 0; cmd.CommandText = $"EXEC CreateShip '{shipName}', {tonnage}, '{imoNumber}', {hasImoNumberBeenVerified}, {isImoNumberValid}"; var shipId = (int)cmd.ExecuteScalar(); LastShipIdCreatedLabel.Text = $"{shipId}"; }); }
protected void CreateShipButton_Click(object sender, EventArgs e) { var shipName = ShipNameTextBox.Text; var tonnage = decimal.Parse(TonnageTextBox.Text); var imoNumber = ImoNumberTextBox.Text; var internationalMaritimeOrganizationVerifier = new InternationalMaritimeOrganizationVerifier(); var isImoNumberValid = internationalMaritimeOrganizationVerifier.IsImoNumberValid(imoNumber); SqlCommandExecutor.ExecuteSqlCommand(cmd => { const int hasImoNumberBeenVerified = 1; cmd.CommandText = $"EXEC CreateShip '{shipName}', {tonnage}, '{imoNumber}', {hasImoNumberBeenVerified}, {(isImoNumberValid ? 1 : 0)}"; var shipId = (int)cmd.ExecuteScalar(); LastShipIdCreatedLabel.Text = $"{shipId}"; }); }