protected void _initModel()
{
Productions.Properties.Settings setting = new Productions.Properties.Settings();
ProductParser newParser = new ProductParser();
dataModel = new ProductModel(
this.gvProducts,
setting.DB_HOST,
setting.DB_PORT,
setting.DB_NAME,
setting.DB_USER,
setting.DB_PASS,
"Production.Products",
newParser);
dataModel = new ProductModel(this.gvProducts, ".\\SQL2008", setting.DB_PORT, setting.DB_NAME, setting.DB_USER, setting.DB_PASS, "Production.Products", newParser);
newParser.DataModel = dataModel;
dataModel.resetControl();
this.cbxCaID.Items.Add("");
this.cbxCaID.Items.AddRange(dataModel.getIDItemList("Production.Categories", 0, 1, " deactive=0").ToArray());
this.cbxSupID.Items.Add("");
this.cbxSupID.Items.AddRange(dataModel.getIDItemList("Production.Suppliers", 0, 1, " deactive=0").ToArray());
}
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["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();
}
}