protected void loadData()
{
ProductParser newParser = new ProductParser();
this.dataModel = new ProductModel(@".\SQL2008",
1433, "TSQLFundamentals2008", "sa", "123456", "Production.Products", newParser);
newParser.DataModel = this.dataModel;
try
{
this.dataModel.resetModel("");
}
catch (Exception ex)
{
Session["current_error"] = ex.Message;
Response.Redirect("serverError.aspx");
}
/*if (this.IsPostBack == false)
this.loadEmpIDS();*/
catList = new List<object>();
suppList = new List<object>();
catList.Add("");
suppList.Add("");
catList.AddRange(dataModel.getIDItemList("Production.Categories", 0, 1, " deactive=0").ToArray());
suppList.AddRange(dataModel.getIDItemList("Production.Suppliers", 0, 1, " deactive=0").ToArray());
if (IsPostBack == false)
{
this.cbCatID.DataSource = catList;
this.cbCatID.DataBind();
this.cbSupplierID.DataSource = suppList;
this.cbSupplierID.DataBind();
}
if ((Request.Params.Get("proid") != null))
{
this.proID = int.Parse(Request.Params.Get("proid").Trim());
this.newEmpMode = false;
if (this.IsPostBack == true)
return;
this.loadSuppData();
}
}
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();
}
}
protected void loadData()
{
string currentFilter ;
if (IsPostBack == false)
{
Session["pro_filter"] = "";
currentFilter = "";
}
else
currentFilter = (string)Session["pro_filter"];
//this.scriptLb.Text = currentFilter;
ProductParser newParser = new ProductParser();
this._dataModel = new ProductModel(this.gvProducts, @".\SQL2008",
1433, "TSQLFundamentals2008","sa", "123456", "Production.Products", 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");
}
catList = new List<object>();
suppList = new List<object>();
catList.Add("");
suppList.Add("");
catList.AddRange(_dataModel.getIDItemList("Production.Categories", 0, 1, " deactive=0").ToArray());
suppList.AddRange(_dataModel.getIDItemList("Production.Suppliers", 0, 1, " deactive=0").ToArray());
if (IsPostBack == false)
{
this.cbCatID.DataSource = catList;
this.cbCatID.DataBind();
this.cbSupplierID.DataSource = suppList;
this.cbSupplierID.DataBind();
}
}