protected void FrmDillenSQLManagementStudio_Load(object sender, EventArgs e)
{
this.Opacity = 0;
//Show Splash
FrmSplash frmSplash = new FrmSplash();
frmSplash.Show();
frmSplash.FormClosed += (s, args) => this.AuxSplashClosed(frmSplash);
this.TryConnWithMyDtbs(true);
//mySQLConnection
this.mySqlCon = new MySqlConnection(this.user);
//INICIALIZE RICHTEXT BOX
this.sqlRchtxtbx = new SqlRichTextBox(ref this.rchtxtCode, this, this.mySqlCon, false);
this.sqlRchtxtbx.SetNewEvents(new System.EventHandler(this.newRchtxtCode_TextChanged),
new System.Windows.Forms.PreviewKeyDownEventHandler(this.newRchtxtCode_PreviewKeyDown));
this.sqlRchtxtbx.SQLRichTextBox.KeyPress += new KeyPressEventHandler(this.newRchtxtCode_KeyPress);
//opacity to darken the rest of the Form except the Menu
this.opaquePanel.BringToFront();
//panel in first place
this.pnlFile.BringToFront();
this.pnlEdit.BringToFront();
this.pnlExecuteAs.BringToFront();
this.pnlVPNConfiguration.BringToFront();
//splash can close
frmSplash.CanClose(this.user != null);
}
//INICIALIZE
public FrmCommandExplanation(int codCmd, User user, MySqlConnection mySqlCon)
{
InitializeComponent();
//set font to TableName's Cell in grvSelect
this.grvSelectTry.TopLeftHeaderCell.Style.Font = new Font(new FontFamily("Modern No. 20"), 10.0F, FontStyle.Bold);
if (!user.IsConnected())
{
throw new Exception("Unicamp VPN was disconnected! This resource is not available anymore!");
}
this.mySqlConn = mySqlCon;
this.codCmd = codCmd;
//name
this.command = new CultureInfo("en-US", false).TextInfo.ToTitleCase(user.CommandFromCod(codCmd));
//fisrt letters of all words in upper case
this.Text = this.command;
//explanation
user.GetExplanationSqlCommand(codCmd, ref this.titles, ref this.cmdExplanations,
ref this.textsUserTry);
//INICIALIZE RICHTEXT BOX
this.sqlRchtxtbx = new SqlRichTextBox(ref this.rchtxtTryCode, this, mySqlCon);
//Inicialize MulticolorLabel
this.multicolorLabel = new MulticolorLabel(new Point(0, 0), 0, 0, this, new Font(new FontFamily("Courier New"), 12.0F),
Color.Black, SystemColors.Control);
}
public static string AllCodes(SqlRichTextBox sqlRchtxtbx, ref Queue <int> linesNoEvenQuotMarks)
{
RichTextBox rchtxtCode = sqlRchtxtbx.SQLRichTextBox;
//or this.rchtxtCode
//put txtCode.Items in a String (with spaces between each line)
string allCodes = "";
//if there's nothing selected
if (rchtxtCode.SelectionLength <= 0)
{
for (int i = 0; i < rchtxtCode.Lines.Length; i++)
{
string currLine = rchtxtCode.Lines[i];
//if there're even
if (SqlExecuteProcedures.RealCodeLine(ref currLine))
{
allCodes += " " + currLine;
}
else
{
linesNoEvenQuotMarks.Enqueue(i);
}
}
}
else
//there's something selected
{
int qtdOtherChars1 = 0;
int indexFirstLine = sqlRchtxtbx.IndexOfLine(rchtxtCode.SelectionStart, ref qtdOtherChars1);
int qtdOtherChars2 = 0;
int indexLastLine = sqlRchtxtbx.IndexOfLine(rchtxtCode.SelectionStart + rchtxtCode.SelectionLength,
ref qtdOtherChars2);
for (int i = indexFirstLine; i <= indexLastLine; i++)
{
string line;
if (i == indexFirstLine)
{
int final;
if (indexFirstLine == indexLastLine)
{
final = rchtxtCode.SelectionStart + rchtxtCode.SelectionLength - qtdOtherChars1;
}
else
{
final = rchtxtCode.Lines[i].Length;
}
int start = rchtxtCode.SelectionStart - qtdOtherChars1;
line = rchtxtCode.Lines[i].Substring(start, final - start);
}
else
if (i == indexLastLine)
{
line = rchtxtCode.Lines[i].Substring(0, rchtxtCode.SelectionStart + rchtxtCode.SelectionLength - qtdOtherChars2);
}
else
if (i < indexLastLine)
{
line = rchtxtCode.Lines[i];
}
else
{
break;
}
//if there're even
if (SqlExecuteProcedures.RealCodeLine(ref line))
{
allCodes += " " + line;
}
else
{
linesNoEvenQuotMarks.Enqueue(i);
}
}
}
return(allCodes);
}