private void RefreshEverything()
{
// ----- Refresh most of the fields on the three main tabs.
string sqlText;
SqlConnection linkToDB;
SqlDataReader stateReader;
// ----- Initialize.
ActiveStateID = -1L;
// ----- Open a database connection.
linkToDB = General.OpenConnection();
if (linkToDB == null)
{
return;
}
// ----- See if a custom state already exists.
// ----- Adjust the display.
if (ActiveStateID == -1L)
{
// ----- Set up the display for a new entry.
AddName.Enabled = true;
AddAbbreviation.Enabled = true;
ActAdd.Enabled = true;
EditID.Text = "N/A";
EditName.Clear();
EditAbbreviation.Clear();
EditName.Enabled = false;
EditAbbreviation.Enabled = false;
ActEdit.Enabled = false;
DeleteID.Text = "N/A";
DeleteName.Text = "N/A";
DeleteAbbreviation.Text = "N/A";
ActDelete.Enabled = false;
}
else
{
// ----- Set up the display for an existing item.
AddName.Enabled = false;
AddAbbreviation.Enabled = false;
ActAdd.Enabled = false;
EditID.Text = ActiveStateID.ToString();
EditName.Text = AddName.Text;
EditAbbreviation.Text = AddAbbreviation.Text;
EditName.Enabled = true;
EditAbbreviation.Enabled = true;
ActEdit.Enabled = true;
DeleteID.Text = ActiveStateID.ToString();
DeleteName.Text = AddName.Text;
DeleteAbbreviation.Text = AddAbbreviation.Text;
ActDelete.Enabled = true;
}
// ----- Refresh the SQL statement previews.
RefreshAddPreview();
RefreshEditPreview();
RefreshDeletePreview();
}
private void RefreshEverything()
{
// ----- Refresh most of the fields on the three main tabs.
string sqlText;
SqlConnection linkToDB;
SqlDataReader stateReader;
// ----- Initialize.
ActiveStateID = -1L;
// ----- Open a database connection.
linkToDB = General.OpenConnection();
if (linkToDB == null)
{
return;
}
// ----- See if a custom state already exists.
sqlText = "SELECT * FROM StateRegion WHERE RegionType = 99";
stateReader = General.OpenReader(sqlText, linkToDB);
if ((stateReader != null) && (stateReader.HasRows == true))
{
// ----- Existing custom state record.
stateReader.Read();
ActiveStateID = (long)(int)stateReader["ID"];
AddName.Text = (string)stateReader["FullName"];
AddAbbreviation.Text = (string)stateReader["Abbreviation"];
}
else
{
// ----- No custom state record.
AddName.Clear();
AddAbbreviation.Clear();
}
if (stateReader != null)
{
stateReader.Close();
}
// ----- Adjust the display.
if (ActiveStateID == -1L)
{
// ----- Set up the display for a new entry.
AddName.Enabled = true;
AddAbbreviation.Enabled = true;
ActAdd.Enabled = true;
EditID.Text = "N/A";
EditName.Clear();
EditAbbreviation.Clear();
EditName.Enabled = false;
EditAbbreviation.Enabled = false;
ActEdit.Enabled = false;
DeleteID.Text = "N/A";
DeleteName.Text = "N/A";
DeleteAbbreviation.Text = "N/A";
ActDelete.Enabled = false;
}
else
{
// ----- Set up the display for an existing item.
AddName.Enabled = false;
AddAbbreviation.Enabled = false;
ActAdd.Enabled = false;
EditID.Text = ActiveStateID.ToString();
EditName.Text = AddName.Text;
EditAbbreviation.Text = AddAbbreviation.Text;
EditName.Enabled = true;
EditAbbreviation.Enabled = true;
ActEdit.Enabled = true;
DeleteID.Text = ActiveStateID.ToString();
DeleteName.Text = AddName.Text;
DeleteAbbreviation.Text = AddAbbreviation.Text;
ActDelete.Enabled = true;
}
// ----- Refresh the SQL statement previews.
RefreshAddPreview();
RefreshEditPreview();
RefreshDeletePreview();
}
