protected void loadData()
{
string currentFilter ;
if (IsPostBack == false)
{
Session["ord_filter"] = "";
currentFilter = "";
}
else
currentFilter = (string)Session["ord_filter"];
//this.scriptLb.Text = currentFilter;
OrderParser newParser = new OrderParser();
this._dataModel = new OrderModel (this.gvOrders, @".\SQL2008",
1433, "TSQLFundamentals2008","sa", "123456", "Sales.Orders", "Sales.OrderDetails", newParser);
newParser.DataModel = this._dataModel;
try
{
this._dataModel.resetControl(currentFilter);
//if (this.IsPostBack == false)
// this.loadEmpIDS();
}
catch(Exception ex)
{
Session["current_error"] = ex.Message;
Response.Redirect("serverError.aspx");
}
custList = new List<object>();
empList = new List<object>();
shipperList = new List<object>();
custList.Add("");
empList.Add("");
shipperList.Add("");
custList.AddRange(_dataModel.getIDItemList("Sales.Customers", 0, 1, "").ToArray());
empList.AddRange(_dataModel.getIDItemList("HR.Employees", 0, 1, " jobStatus=1").ToArray());
shipperList.AddRange(_dataModel.getIDItemList("Sales.Shippers", 0, 1, " deactive=0").ToArray());
if (IsPostBack == false)
{
this.cbCustID.DataSource = custList;
this.cbEmpID.DataSource = empList;
this.cbShipper.DataSource = shipperList;
cbCustID.DataBind();
cbEmpID.DataBind();
cbShipper.DataBind();
}
}