partial void BeforeDBDelete(int productVersionStatusID)
{
ProductVersionStatuses productVersionStatuses = new ProductVersionStatuses(LoginUser);
productVersionStatuses.LoadAllPositions(LoginUser.OrganizationID);
int id = -1;
foreach (ProductVersionStatus productVersionStatus in productVersionStatuses)
{
if (productVersionStatus.ProductVersionStatusID != productVersionStatusID)
{
id = productVersionStatus.ProductVersionStatusID;
break;
}
}
if (id < 0)
{
throw new Exception("You cannot delete the last product version.");
}
using (SqlCommand command = new SqlCommand())
{
command.CommandText = "UPDATE ProductVersions SET ProductVersionStatusID = @NewID WHERE (ProductVersionStatusID = @ProductVersionStatusID)";
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@ProductVersionStatusID", productVersionStatusID);
command.Parameters.AddWithValue("@NewID", id);
ExecuteNonQuery(command, "ProductVersions");
}
}
public void ValidatePositions(int organizationID)
{
ProductVersionStatuses productVersionStatuses = new ProductVersionStatuses(LoginUser);
productVersionStatuses.LoadAllPositions(organizationID);
int i = 0;
foreach (ProductVersionStatus productVersionStatus in productVersionStatuses)
{
productVersionStatus.Position = i;
i++;
}
productVersionStatuses.Save();
}
