/// -----------------------------------------------------------------------------
/// <summary>
/// cmdExecute_Click runs when the Execute button is clicked
/// </summary>
/// <remarks>
/// </remarks>
/// <history>
/// [cnurse] 9/28/2004 Updated to reflect design changes for Help, 508 support
/// and localisation
/// </history>
/// -----------------------------------------------------------------------------
protected void OnExecuteClick(object sender, EventArgs e)
{
try
{
if (!String.IsNullOrEmpty(txtQuery.Text))
{
var connectionstring = Config.GetConnectionString(cboConnection.SelectedValue);
if (chkRunAsScript.Checked)
{
var strError = DataProvider.Instance().ExecuteScript(connectionstring, txtQuery.Text);
if (strError == Null.NullString)
{
UI.Skins.Skin.AddModuleMessage(this, Localization.GetString("QuerySuccess", LocalResourceFile), ModuleMessage.ModuleMessageType.GreenSuccess);
}
else
{
UI.Skins.Skin.AddModuleMessage(this, strError, ModuleMessage.ModuleMessageType.RedError);
}
}
else
{
try
{
var dr = DataProvider.Instance().ExecuteSQLTemp(connectionstring, txtQuery.Text);
if (dr != null)
{
var tables = new List <DataTable>();
do
{
var table = new DataTable {
Locale = CultureInfo.CurrentCulture
};
table.Load(dr);
tables.Add(table);
}while (!dr.IsClosed); // table.Load automatically moves to the next result and closes the reader once there are no more
ResultsRepeater.DataSource = tables;
ResultsRepeater.DataBind();
UI.Skins.Skin.AddModuleMessage(this, Localization.GetString("QuerySuccess", LocalResourceFile), ModuleMessage.ModuleMessageType.GreenSuccess);
}
else
{
UI.Skins.Skin.AddModuleMessage(this, Localization.GetString("QueryError", LocalResourceFile), ModuleMessage.ModuleMessageType.RedError);
}
}
catch (SqlException sqlException)
{
UI.Skins.Skin.AddModuleMessage(this, sqlException.Message, ModuleMessage.ModuleMessageType.RedError);
return;
}
}
RecordAuditEventLog(txtQuery.Text);
}
}
catch (Exception exc) //Module failed to load
{
Exceptions.ProcessModuleLoadException(this, exc);
}
}
protected void Page_Load(object sender, EventArgs e)
{
var segments = Request.GetFriendlyUrlSegments();
LibrarySystemDbContext data = new LibrarySystemDbContext();
if (segments.Count == 0)
{
var results = data.Books.ToList();
ResultsRepeater.DataSource = results;
ResultsRepeater.DataBind();
}
else
{
var query = segments[0];
if (query.Length > 100)
{
ErrorSuccessNotifier.AddErrorMessage("Search query cannot be more than 100 characters");
Response.Redirect("~/");
}
var results = data.Books
.Where(x => x.Title.Contains(query) || x.Authors.Contains(query))
.OrderBy(x => x.Title)
.ThenBy(x => x.Authors)
.ToList();
ResultsRepeater.DataSource = results;
ResultsRepeater.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
int currentPage = SearchResultsManager.CurrentPage();
bool hasNextPage = currentPage < TotalPages;
PreviousUrl = new PaginationEntry
{
ItemUrl = SearchResultsManager.SetPage(currentPage - 1)
};
FirstUrl = new PaginationEntry
{
ItemUrl = SearchResultsManager.SetPage(0)
};
LastUrl = new PaginationEntry
{
ItemUrl = SearchResultsManager.SetPage(TotalPages)
};
NextUrl = new PaginationEntry
{
ItemUrl = SearchResultsManager.SetPage(currentPage + 1)
};
if (currentPage == 0)
{
FirstUrl.CssClass = PreviousUrl.CssClass = "disabled";
FirstUrl.ItemUrl = PreviousUrl.ItemUrl = "#";
}
if (!hasNextPage)
{
LastUrl.CssClass = NextUrl.CssClass = "disabled";
LastUrl.ItemUrl = NextUrl.ItemUrl = "#";
}
List <PaginationEntry> entries = new List <PaginationEntry>();
for (int i = 0; i <= TotalPages; i++)
{
entries.Add(new PaginationEntry
{
ItemUrl = SearchResultsManager.SetPage(i),
Text = (i + 1).ToString(),
CssClass = i == currentPage ? "active" : ""
});
}
if (entries.Count > MaxPaginationEntries)
{
entries = CenterEntries(entries, currentPage).ToList();
}
ResultsRepeater.DataSource = entries;
ResultsRepeater.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ResultsRepeater.DataSource = SearchRecipies(5);
ResultsRepeater.DataBind();
}
}
private void WriteSearchModel(RecipeSearchResultModel model)
{
ResultsRepeater.DataSource = model.Items;
ResultsRepeater.DataBind();
NextBtn.Visible = model.NextPage.HasValue;
PreviousBtn.Visible = model.PrevPage.HasValue;
CurrentPage.Value = model.Page.ToString();
PageDisplay.Text = model.Page.ToString();
MaxPageDisplay.Text = model.MaxPages.ToString();
MaxPerPage.Value = model.ResultCount.ToString();
if (model.MaxResultCount > 0)
{
int a = (int)model.MaxResultCount;
int end = model.ResultEndIndex > a ? a : model.ResultEndIndex;
ResultsOfDisplay.Text = string.Format("({0}-{1} of {2})", model.ResultStartIndex, end, model.MaxResultCount);
}
else
{
ResultsOfDisplay.Text = "0 results";
}
}