protected void bind_order_titles()
{
//get order number from querystrings
Int32 _orderno = wwi_func.vint(wwi_security.DecryptString(get_token("pno"), "publiship")); //999909; //Request.QueryString["pid"] != null ? wwi_func.vint(Request.QueryString["pid"].ToString()) : 0;
//query item table
SubSonic.Query _q = new SubSonic.Query(DAL.Logistics.Tables.ItemTable, "WWIProv").WHERE("OrderNumber", Comparison.Equals, _orderno);
DataSet _ds = _q.ExecuteDataSet();
this.dxgridTitles.KeyFieldName = "TitleID";
this.dxgridTitles.DataSource = _ds;
this.dxgridTitles.DataBind();
}
/// </summary>
/// <param name="companyID"></param>
protected void bind_contacts(int companyid)
{
ASPxGridView _grid = (ASPxGridView)this.fmvAddressBook.FindControl("dxgridCompanyContacts");
//ASPxGridView _grid = (ASPxGridView)this.dxpnlContacts.FindControl("dxgridCompanyContacts");
if (_grid != null)
{
SubSonic.Query _q = new SubSonic.Query(Tables.ContactTable, "WWIProv").WHERE("CompanyID", Comparison.Equals, companyid);
DataSet _ds = _q.ExecuteDataSet();
//IDataReader _dr = _q.ExecuteReader(); can't use datareder it's a read only structure!
_grid.KeyFieldName = "ContactID";
_grid.DataSource = _ds;
_grid.DataBind();
}
}
/// </summary>
/// <param name="companyID"></param>
protected void bind_contacts(int companyid)
{
ASPxGridView _grid = (ASPxGridView)this.fmvAddressBook.FindControl("dxgridCompanyContacts");
//ASPxGridView _grid = (ASPxGridView)this.dxpnlContacts.FindControl("dxgridCompanyContacts");
if (_grid != null)
{
SubSonic.Query _q = new SubSonic.Query(Tables.ContactTable, "WWIProv").WHERE("CompanyID", Comparison.Equals, companyid);
DataSet _ds = _q.ExecuteDataSet();
//IDataReader _dr = _q.ExecuteReader(); can't use datareder it's a read only structure!
_grid.KeyFieldName = "ContactID";
_grid.DataSource = _ds;
_grid.DataBind();
}
}
protected void bind_gridview()
{
//string _orderno = wwi_security.DecryptString(get_token("pno"), "publiship");
//CourierDetailsSubTableCollection _c = new CourierDetailsSubTableCollection().Where("OrderNumber", Comparison.Equals, _orderno);
int _orderno = wwi_func.vint(wwi_security.DecryptString(get_token("pno"), "publiship")); //999909; //Request.QueryString["pid"] != null ? wwi_func.vint(Request.QueryString["pid"].ToString()) : 0;
try
{
//query courier details table
SubSonic.Query _q = new SubSonic.Query(Tables.CourierDetailsSubTable, "WWIProv").WHERE("OrderNumber", Comparison.Equals, _orderno);
DataSet _ds = _q.ExecuteDataSet();
this.dxgrdCourier.KeyFieldName = "CourierDetailID";
this.dxgrdCourier.DataSource = _ds;
this.dxgrdCourier.DataBind();
}
catch (Exception ex)
{
string _ex = ex.Message.ToString();
this.dxlblErr.Text = string.Format("Order Number {0}. Error: {1}", _orderno, _ex);
this.dxpnlErr.ClientVisible = true;
}//end try
}
protected void bind_gridview()
{
//string _orderno = wwi_security.DecryptString(get_token("pno"), "publiship");
//CourierDetailsSubTableCollection _c = new CourierDetailsSubTableCollection().Where("OrderNumber", Comparison.Equals, _orderno);
int _orderno = wwi_func.vint(wwi_security.DecryptString(get_token("pno"), "publiship")); //999909; //Request.QueryString["pid"] != null ? wwi_func.vint(Request.QueryString["pid"].ToString()) : 0;
try
{
//query courier details table
SubSonic.Query _q = new SubSonic.Query(Tables.CourierDetailsSubTable, "WWIProv").WHERE("OrderNumber", Comparison.Equals, _orderno);
DataSet _ds = _q.ExecuteDataSet();
this.dxgrdCourier.KeyFieldName = "CourierDetailID";
this.dxgrdCourier.DataSource = _ds;
this.dxgrdCourier.DataBind();
}
catch (Exception ex)
{
string _ex = ex.Message.ToString();
this.dxlblErr.Text = string.Format("Order Number {0}. Error: {1}", _orderno, _ex);
this.dxpnlErr.ClientVisible = true;
}//end try
}
protected void bind_order_titles()
{
//get order number from querystrings
Int32 _orderno = wwi_func.vint(wwi_security.DecryptString(get_token("pno"),"publiship")); //999909; //Request.QueryString["pid"] != null ? wwi_func.vint(Request.QueryString["pid"].ToString()) : 0;
//query item table
SubSonic.Query _q = new SubSonic.Query(DAL.Logistics.Tables.ItemTable, "WWIProv").WHERE("OrderNumber", Comparison.Equals, _orderno);
DataSet _ds = _q.ExecuteDataSet();
this.dxgridTitles.KeyFieldName = "TitleID";
this.dxgridTitles.DataSource = _ds;
this.dxgridTitles.DataBind();
}
/// <summary>
/// binding titles in child grid
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void dxgridTitles_BeforePerformDataSelect(object sender, EventArgs e)
{
try
{
ASPxGridView _detail = (ASPxGridView)sender;
String[] _keys = { "DeliveryID" };
int _deliveryid = (int)_detail.GetMasterRowFieldValues(_keys);
SubSonic.Query _q = new SubSonic.Query(DAL.Logistics.Tables.DeliverySubSubTable, "WWIProv").WHERE("DeliveryID", Comparison.Equals, _deliveryid);
DataSet _ds = _q.ExecuteDataSet();
_detail.KeyFieldName = "SubDeliveryID";
_detail.DataSource = _ds;
//DO NOT CALL DATABIND during BeforePerformDataSelect as it causes an infinite loop
//_detail.DataBind();
//deprecated we are binding in code behind
//this.odsDeliveryTitles.SelectParameters["DeliveryID"].DefaultValue = _deliveryid.ToString();
}
catch (Exception ex)
{
string _ex = ex.Message.ToString();
this.dxlblErr.Text = _ex;
this.dxpnlErr.ClientVisible = true;
}
//end try
}
//end bind summary
protected void bind_deliveries()
{
try
{
int _orderno = wwi_func.vint(wwi_security.DecryptString(get_token("pno"), "publiship"));
//query delivefries table
SubSonic.Query _q = new SubSonic.Query(DAL.Logistics.Tables.DeliverySubTable, "WWIProv").WHERE("OrderNumber", Comparison.Equals, _orderno);
DataSet _ds = _q.ExecuteDataSet();
this.dxgridDeliveries.KeyFieldName = "DeliveryID";
this.dxgridDeliveries.DataSource = _ds;
this.dxgridDeliveries.DataBind();
}
catch (Exception ex)
{
string _ex = ex.Message.ToString();
this.dxlblErr.Text = _ex;
this.dxpnlErr.ClientVisible = true;
}
}
