private void UpdateGenerate()
{
mainUpdateQuery.Ignore = cbIgnoreUpdate.Checked;
mainUpdateQuery.Low = cbLowPriorityUpdate.Checked;
mainUpdateQuery.Limit = tbLimit.Text;
mainUpdateQuery.Where = tbWhereUpdate.Text;
try
{
mainUpdateQuery.Expression.Clear();
foreach (DataGridViewRow dgvr in dgvUpdateFields.Rows)
{
if (dgvr.Cells[0].Value != null && dgvr.Cells[2].Value != null)
{
mainUpdateQuery.Expression.Add(new List <string>()
{
dgvr.Cells[0].Value.ToString(), dgvr.Cells[1].Value.ToString(),
dgvr.Cells[2].Value.ToString(), dgvr.Cells[3].Value.ToString()
});
}
}
string generatedQuery = mainUpdateQuery.CreateUpdateQuery();
gbQueryConstructor.Navigate(loadHTML(generatedQuery));
ExecuteForm f = new ExecuteForm(loadHTML(generatedQuery), MySQL, generatedQuery);
f.ShowDialog();
}
catch { }
}
/// <summary>
/// apply the changes
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnApply_Click(object sender, EventArgs e)
{
if (myCmdMgr.SelectItems.Count + myCmdMgr.DelectItems.Count == 0)
{
return;
}
ExecuteForm exeForm = new ExecuteForm(myCmdMgr);
exeForm.ShowDialog();
//exeForm.Dispose();
btnApply.Enabled = false;
updateLvApp();
}
private void SelectGenerate()
{
if (mainSelectQuery.selectExpressions.Count > 0)
{
mainSelectQuery.generateConditions(dgvConditions);
mainSelectQuery.useTypesRelationships.Clear();
mainSelectQuery.alias.Clear();
for (int i = 0; i < dgvAlias.Rows.Count - 1; i++)
{
mainSelectQuery.alias.Add(dgvAlias.Rows[i].Cells[1].Value.ToString());
}
for (int i = 0; i < dgvJoin.Rows.Count - 1; i++)
{
mainSelectQuery.useTypesRelationships.Add(((DataGridViewComboBoxCell)dgvJoin.Rows[i].Cells[4]).Value.ToString());
}
mainSelectQuery.generatedLimitAndDistinct(tbLimit.Text, cbUsingDistinct.Checked);
string generatedQuery = mainSelectQuery.generateQuery();
gbQueryConstructor.Navigate(loadHTML(generatedQuery));
ExecuteForm f = new ExecuteForm(loadHTML(generatedQuery), MySQL, generatedQuery);
f.ShowDialog();
}
}
private void InsertGenerate()
{
try
{
mainInsertQuery.Expression.Clear();
foreach (DataGridViewRow dgvr in dgvInsertFields.Rows)
{
if (dgvr.Cells[0].Value != null && dgvr.Cells[1].Value != null)
{
mainInsertQuery.Expression.Add(new List <string>()
{
dgvr.Cells[0].Value.ToString(),
dgvr.Cells[1].Value.ToString()
});
}
}
string generatedQuery = mainInsertQuery.CreateInsertQuery();
gbQueryConstructor.Navigate(loadHTML(generatedQuery));
ExecuteForm f = new ExecuteForm(loadHTML(generatedQuery), MySQL, generatedQuery);
f.ShowDialog();
}
catch
{ }
}
private void DeleteGenerate()
{
mainDeleteQuery.Limit = tbDeleteLimit.Text;
mainDeleteQuery.LowPriotity = cbDeleteLow.Checked;
mainDeleteQuery.Quick = cbDeleteQuick.Checked;
mainDeleteQuery.Where = rtbDeleteWhere.Text;
string orderBy = "";
foreach (DataGridViewRow r in dgvDeleteFields.Rows)
{
if (r.Cells[0].Value != null)
{
if (((DataGridViewCheckBoxCell)r.Cells[2]).Value.ToString() == true.ToString())
{
orderBy += orderBy != "" ? "," + r.Cells[0].Value.ToString() : r.Cells[0].Value.ToString();
}
}
}
mainDeleteQuery.OrderBy = orderBy;
string generatedQuery = mainDeleteQuery.GenerateDeleteQuery();
ExecuteForm f = new ExecuteForm(loadHTML(generatedQuery), MySQL, generatedQuery);
f.ShowDialog();
}
/// <summary>
/// Executes the webhook object!
/// </summary>
/// <param name="id"></param>
/// <param name="token"></param>
public static void Execute(string id, string token, ExecuteForm data)
{
Extensions.PostMessage($"https://discord.com/api/webhooks/{id}/{token}", data);
}
