public InputData(int numbersCount, eSort sortingType)
{
m_numbersCount = numbersCount;
m_sortingType = eSort.UNSORT;
/* fill array with random numbers */
fillArray();
/* sort array by user specified type */
sortArray();
}
public void SetOrder(eSort sort)
{
if (sort == eSort.ASC)
{
rbSQLAsc.Checked = true;
}
else if (sort == eSort.DESC)
{
rbSQLDesc.Checked = true;
}
else
{
rbSQLDesc.Checked = false;
rbSQLAsc.Checked = false;
}
}
public void EditToData()
{
if (_tableObject.primary_constraint == null)
{
_tableObject.primary_constraint = new PrimaryKeyClass();
}
_tableObject.primary_constraint.Name = txtPKName.Text;
_tableObject.primary_constraint.IndexName = txtIndexName.Text;
_tableObject.primary_constraint.FieldNames.Clear();
eSort es = (eSort)cbSorting.Items[cbSorting.SelectedIndex];
_tableObject.primary_constraint.Sorting = es;
foreach (ListViewItem lvi in lvFields.Items)
{
_tableObject.primary_constraint.FieldNames.Add(lvi.Text, lvi.Text);
}
}
private void cmsHistory_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
{
if (e.ClickedItem == tsmiSortASC)
{
if (_lastSort != eSort.ASC)
{
Sort();
_lastSort = eSort.ASC;
tabPageSucceeded.Text = "commands succeded ASC";
}
}
else if (e.ClickedItem == tsmiSortDESC)
{
if (_lastSort != eSort.DESC)
{
Sort();
_lastSort = eSort.DESC;
tabPageSucceeded.Text = "commands succeded DESC";
}
}
}
private int LoadHistory(eSort sort)
{
clbHISTORY.Items.Clear();
var fi = new FileInfo($@"{Application.StartupPath}\SQLHistory.txt");
if (fi.Exists)
{
var rt = new RichTextBox();
rt.LoadFile(fi.FullName, RichTextBoxStreamType.PlainText);
foreach (string str in rt.Lines)
{
if (str.Length <= 0)
{
continue;
}
if (sort == eSort.DESC)
{
clbHISTORY.Items.Insert(0, str);
}
else
{
clbHISTORY.Items.Add(str);
}
}
if (clbHISTORY.Items.Count > 0)
{
lastSuccessfulCommand = (sort == eSort.DESC)
? clbHISTORY.Items[0].ToString()
: clbHISTORY.Items[clbHISTORY.Items.Count - 1].ToString();
lastCommand = lastSuccessfulCommand;
}
return(clbHISTORY.Items.Count);
}
return(0);
}
