public override void DataBind()
{
base.DataBind ();
string username = ConfigurationManager.AppSettings["fcsdk.clarifysession.username"];
// Show username to currect user
currentUserLabel.Text = String.Format( " <i>({0})</i>", username );
// Get session from Global.asax.cs
ClarifySessionWS session = Global.ClarifySessWS;
// Create ClarifyDataAccessWS
ClarifyDataAccessWS dataAccess = new ClarifyDataAccessWS( session );
// Create new DataQuery to query view "qry_case_view"
DataQuery caseQuery = dataAccess.CreateDataQuery("qry_case_view");
// Set fields to select
caseQuery.DataFields.AddRange(
new string[]{"id_number", "site_name", "title", "condition", "status", "creation_time", "owner"} );
// Append filters for query
caseQuery.AppendFilter( "owner", "Equals", username );
caseQuery.AppendFilter( "condition", "Like", "Open%" );
// Append sorting for query
caseQuery.AppendSort( "creation_time", false );
// Get Xml result
string result = caseQuery.Query(true);
// Create a string reader to read the result
System.IO.StringReader reader = new System.IO.StringReader(result);
// Create and load the DataSet with the result
DataSet ds = new DataSet();
ds.ReadXml( reader );
// Data bind DataGrid to result table in DataSet
this.openCasesGrid.DataSource = ds.Tables["qry_case_view"];
this.openCasesGrid.DataBind();
}
public override void DataBind()
{
base.DataBind ();
// Get session from Global.asax.cs
ClarifySessionWS session = Global.ClarifySessWS;
// Create ClarifyDataAccessWS
ClarifyDataAccessWS dataAccess = new ClarifyDataAccessWS( session );
// Create new DataQuery to query view "qry_case_view"
DataQuery caseQuery = dataAccess.CreateDataQuery("qry_case_view");
// Set fields to select
caseQuery.DataFields.AddRange(
new string[]{"id_number", "site_name", "title", "condition", "status", "creation_time", "owner"} );
// Append filters for query
caseQuery.AppendFilter( "creation_time", "MoreThanOrEqual", DateTime.Now.AddDays(DaysBack * -1).ToShortDateString() );
// Append sorting for query
caseQuery.AppendSort( "creation_time", false );
// Get Xml result
string result = caseQuery.Query(true);
// Create a string reader to read the result
System.IO.StringReader reader = new System.IO.StringReader(result);
// Create and load the DataSet with the result
DataSet ds = new DataSet();
ds.ReadXml( reader );
// Data bind DataGrid to result table in DataSet
this.casesCreatedGrid.DataSource = ds.Tables["qry_case_view"];
this.casesCreatedGrid.DataBind();
}