private void Page_Load(object sender, System.EventArgs e)
{
int orderId = 0;
string verisignId = "";
string sql = "";
this.m_page = new ITCPage();
this.m_page.HideWest = true;;
this.m_page.CheckLogin();
try
{
orderId = Convert.ToInt32(Request.QueryString["OID"]);
sql = "spGetOTCSalesOrderDetails @OTCSalesOrderId = " + orderId;
}
catch(System.FormatException)
{
verisignId = Request.QueryString["OID"];
sql = "spGetOTCSalesOrderDetails @VerisignId = " + OTCDatabase.SqlFormat(verisignId) + ",@IsVerisign=1";
}
this.m_db.Open();
DataSet ds = this.m_db.GetDataset(sql);
this.m_db.ReleaseConnection();
this.m_page.OpenHeader();
this.m_page.CloseHeader();
this.m_page.Start();
Response.Write("<br><br>");
OTCGrid grid = new OTCGrid(ds.Tables[0]);
grid.RandomHTML = "<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tr><td class=\"tableFont\">Sales Order ID: " + (orderId > 0 ? orderId.ToString() : verisignId) + ": USER DETAIL</td><td align=\"right\" class=\"tableFont\"><a href=\"javascript:window.history.back(false)\"><< back</a></td></tr></table>";
grid.Draw();
Response.Write("<br>");
grid = new OTCGrid(ds.Tables[1]);
grid.RandomHTML = "<table cellpadding=\"0\" cellspacing=\"0\"><tr><td class=\"tableFont\">Sales Order ID: " + (orderId > 0 ? orderId.ToString() : verisignId)+ ": PRODUCT DETAILS</td></tr></table>";
grid.Draw();
Response.Write("<br>");
grid = new OTCGrid(ds.Tables[2]);
grid.RandomHTML = "<table cellpadding=\"0\" cellspacing=\"0\"><tr><td class=\"tableFont\">Sales Order ID: " + (orderId > 0 ? orderId.ToString() : verisignId) + ": SHIPPING DETAILS</td></tr></table>";
grid.Draw();
Response.Write("<br>");
grid = new OTCGrid(ds.Tables[3]);
grid.RandomHTML = "<table cellpadding=\"0\" cellspacing=\"0\"><tr><td class=\"tableFont\">Sales Order ID: " + (orderId > 0 ? orderId.ToString() : verisignId) + ": CREDIT CARD INFORMATION</td></tr></table>";
grid.Draw();
Response.Write("<br>");
grid = new OTCGrid(ds.Tables[4]);
grid.RandomHTML = "<table cellpadding=\"0\" cellspacing=\"0\"><tr><td class=\"tableFont\">Sales Order ID: " + (orderId > 0 ? orderId.ToString() : verisignId) + ": Marketing Information</td></tr></table>";
grid.Draw();
this.m_page.End();
}
/// <summary>
///
/// </summary>
public void ShowOrders()
{
this.m_db.Open();
DataTable dt = this.m_db.GetDataset("spGetOTCSalesOrders @startDate = '" + this.m_startDate.ToShortDateString() + "', @endDate = '" + this.m_endDate.ToShortDateString() + "'").Tables[0];
//this.m_db.ReleaseConnection();
OTCGrid grid = new OTCGrid(dt);
grid.HyperLink = "STD=" + this.m_startDate.ToShortDateString() + "&EDT=" + this.m_endDate.ToShortDateString();
OTCGridLink link = new OTCGridLink();
link.LinkKey = "OID";
link.ColumnName = "Dogz Togz Order Id";
link.LinkText = "Interceuticals Order Id";
link.LinkHref = "order.aspx";
grid.AddLinkColumn(link);
link = new OTCGridLink();
link.LinkKey = "OID";
link.ColumnName = "Verisign Order Id";
link.LinkText = "Verisign Order Id";
link.LinkHref = "order.aspx";
grid.AddLinkColumn(link);
grid.DisplayRecordCount = true;
grid.Draw();
}
//============================
//
//============================
public void DrawProducts()
{
OTCGrid grid;
ITC dz = new ITC();
DataTable dt = OTCProduct.GetProducts(dz.SiteId);
DataRow[] rows = dt.Select("NO_DISPLAY_ProductName LIKE '" + this.m_sortChar.ToString() + "*'");
if(rows.Length > 0)
grid = new OTCGrid(OTCGrid.GetDataTableFromArray(rows));
else
grid = new OTCGrid(dt);
grid.Draw();
}
