public void DeleteQuery(SqlQuery query) { using (IDataContext ctx = DataContext.Instance()) { var rep = ctx.GetRepository<SqlQuery>(); rep.Delete(query); } }
private void lnkSave_Click(object sender, EventArgs e) { try { SqlQueryController ctl = new SqlQueryController(); SqlQuery query = ctl.GetQuery(txtName.Text); if (query == null) { query = new SqlQuery(); query.CreatedByUserId = UserId; query.CreatedOnDate = DateTime.Now; } query.Name = txtName.Text; query.Query = txtQuery.Text; query.ConnectionStringName = ddlConnection.SelectedValue; query.LastModifiedByUserId = UserId; query.LastModifiedOnDate = DateTime.Now; if (query.QueryId == 0) { ctl.AddQuery(query); } else { ctl.UpdateQuery(query); } LoadSavedQueries(); ddlSavedQuery.SelectedValue = query.QueryId.ToString(); btDelete.Visible = true; DotNetNuke.UI.Skins.Skin.AddModuleMessage(this, LocalizeString("Saved"), ModuleMessage.ModuleMessageType.GreenSuccess); } catch (Exception exc) { Exceptions.ProcessModuleLoadException(this, exc); } }