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