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