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; }