private void DeleteButton_Click(object sender, EventArgs e)
{
if (RscriptNameText.Text == null)
{
return;
}
RManager.DB.deleteScriptFromDB(RscriptNameText.Text);
RManager.syncScriptList();
RscriptList.DataSource = null;
RscriptList.DataSource = RManager.scriptList;
RscriptList.Refresh();
}
public void insertNewScript()
{
string SQL = @"INSERT INTO metainfo.rscript (name, filterdesc, rankdesc, script) values (@Name, @Filter, @Rank, @Script)";
Dictionary <string, object[]> param = new Dictionary <string, object[]>();
param.Add("Name", new object[] { NpgsqlDbType.Text, RscriptNameText.Text });
param.Add("Filter", new object[] { NpgsqlDbType.Text, RscriptFilterText.Text });
param.Add("Rank", new object[] { NpgsqlDbType.Text, RscriptRankText.Text });
param.Add("Script", new object[] { NpgsqlDbType.Text, Rscript.Text });
RManager.DB.writeToDB(SQL, param);
RManager.syncScriptList();
RscriptList.DataSource = null;
RscriptList.DataSource = RManager.scriptList;
RscriptList.Refresh();
}
public void updateCurrentScript()
{
string SQL = @"UPDATE metainfo.rscript SET name=@Name, filterdesc=@Filter, rankdesc=@Rank, script=@Script
WHERE name=@OLDName";
Dictionary <string, object[]> param = new Dictionary <string, object[]>();
param.Add("Filter", new object[] { NpgsqlDbType.Text, RscriptFilterText.Text });
param.Add("Rank", new object[] { NpgsqlDbType.Text, RscriptRankText.Text });
param.Add("Script", new object[] { NpgsqlDbType.Text, Rscript.Text });
param.Add("Name", new object[] { NpgsqlDbType.Text, RscriptNameText.Text });
param.Add("OLDName", new object[] { NpgsqlDbType.Text, RscriptList.SelectedRows[0].Cells[0].Value.ToString() });
RManager.DB.writeToDB(SQL, param);
RManager.syncScriptList();
RscriptList.DataSource = null;
RscriptList.DataSource = RManager.scriptList;
RscriptList.Refresh();
}
private void AddNewButton_Click(object sender, EventArgs e)
{
RManager.scriptList.Rows.Add(new object[] { });
RscriptList.Refresh();
RscriptList.Rows[RscriptList.Rows.Count - 1].Selected = true;
}
