protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Master.PageTitle = "Monitor Details List";
Master.ShowPageSubTitle = true;
Master.PageSubtitle = "Monitor Details List";
Master.ShowPageLastUpdated = false;
this.Title = "Monitors Details List";
//string localInstance = "";
if (Request.QueryString["app"] != null)
{
application = Request.QueryString["app"];
}
if (Request.QueryString["inst"] != null)
{
instance = Request.QueryString["inst"];
//localInstance = sqlHelper.getInstanceFullName(instance);
}
Master.PageSubtitle = "For Application " + application + " and Instance " + instance;
MonitorDataAccess monitorData = new MonitorDataAccess();
DataSet ds = new DataSet();
ds = monitorData.getMonitorDetailsList("id", dbConnection, application, instance, priority, monitor);
this.GridView1.DataSource = ds.Tables["DATA"].DefaultView.ToTable();
this.GridView1.DataBind();
//GridView1.DataSource = MonitorDataAccessLayer.GetMonitors("id", dbConnection, application, instance, "", "");
// GridView1.DataBind();
}
}
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
//Response.Write("Sort Expression = " + e.SortExpression);
//Response.Write("<br/>");
//Response.Write("Sort Direction = " + e.SortDirection.ToString());
SortDirection sortDirection = SortDirection.Ascending;
string sortField = string.Empty;
SortGridview((GridView)sender, e, out sortDirection, out sortField);
string strSortDirection = sortDirection == SortDirection.Ascending ? "ASC" : "DESC";
MonitorDataAccess monitorData = new MonitorDataAccess();
DataSet ds = new DataSet();
ds = monitorData.getMonitorDetailsList(e.SortExpression + " " + strSortDirection, dbConnection, application, instance, priority, monitor);
this.GridView1.DataSource = ds.Tables["DATA"].DefaultView.ToTable();
this.GridView1.DataBind();
//GridView1.DataSource = MonitorDataAccessLayer.GetMonitors(e.SortExpression + " " + strSortDirection, dbConnection, application, instance, "", "");
// GridView1.DataBind();
}
