void Login_Show()
{
// Login Show begin
// Login Open Event begin
// Login Open Event end
// Login BeforeShow Event begin
// Login BeforeShow Event end
if (Login_logged)
{
// User logged in
Login_login.Text = "Logout";
Login_trpassword.Visible = false;
Login_trname.Visible = false;
Login_labelname.Visible = true;
Login_labelname.Text = Utility.Dlookup("members", "member_login", "member_id=" + Session["UserID"]) + " ";
}
else
{
// User is not logged in
Login_login.Text = "Login";
Login_trpassword.Visible = true;
Login_trname.Visible = true;
Login_labelname.Visible = false;
}
// Login Close Event begin
// Login Close Event end
// Login Show end
}
/*===============================
* Display Record Form
* -------------------------------*/
void ShoppingCartRecord_Show()
{
// ShoppingCartRecord Show begin
bool ActionInsert = true;
if (p_ShoppingCartRecord_order_id.Value.Length > 0)
{
string sWhere = "";
sWhere += "order_id=" + CCUtility.ToSQL(p_ShoppingCartRecord_order_id.Value, FieldTypes.Number);
// ShoppingCartRecord Open Event begin
// ShoppingCartRecord Open Event end
string sSQL = "select * from orders where " + sWhere;
OleDbDataAdapter dsCommand = new OleDbDataAdapter(sSQL, Utility.Connection);
DataSet ds = new DataSet();
DataRow row;
if (dsCommand.Fill(ds, 0, 1, "ShoppingCartRecord") > 0)
{
row = ds.Tables[0].Rows[0];
ShoppingCartRecord_order_id.Value = CCUtility.GetValue(row, "order_id");
ShoppingCartRecord_member_id.Value = CCUtility.GetValue(row, "member_id");
ShoppingCartRecord_item_id.Text = Server.HtmlEncode(Utility.Dlookup("items", "name", "item_id=" + CCUtility.ToSQL(CCUtility.GetValue(row, "item_id"), FieldTypes.Number)).ToString());
ShoppingCartRecord_quantity.Text = CCUtility.GetValue(row, "quantity");
ActionInsert = false;
// ShoppingCartRecord ShowEdit Event begin
// ShoppingCartRecord ShowEdit Event end
}
}
if (ActionInsert)
{
String pValue;
if (Session["UserID"] != null)
{
pValue = Session["UserID"].ToString();
}
else
{
pValue = "";
} ShoppingCartRecord_member_id.Value = pValue; ShoppingCartRecord_delete.Visible = false;
ShoppingCartRecord_update.Visible = false;
// ShoppingCartRecord ShowInsert Event begin
// ShoppingCartRecord ShowInsert Event end
}
// ShoppingCartRecord Open Event begin
// ShoppingCartRecord Open Event end
// ShoppingCartRecord Show Event begin
// ShoppingCartRecord Show Event end
// ShoppingCartRecord Show end
// ShoppingCartRecord Close Event begin
// ShoppingCartRecord Close Event end
}
/*===============================
* Display Record Form
* -------------------------------*/
void Detail_Show()
{
// Detail Show begin
bool ActionInsert = true;
if (p_Detail_item_id.Value.Length > 0)
{
string sWhere = "";
sWhere += "item_id=" + CCUtility.ToSQL(p_Detail_item_id.Value, FieldTypes.Number);
// Detail Open Event begin
// Detail Open Event end
string sSQL = "select * from items where " + sWhere;
OleDbDataAdapter dsCommand = new OleDbDataAdapter(sSQL, Utility.Connection);
DataSet ds = new DataSet();
DataRow row;
if (dsCommand.Fill(ds, 0, 1, "Detail") > 0)
{
row = ds.Tables[0].Rows[0];
Detail_item_id.Value = CCUtility.GetValue(row, "item_id");
Detail_name.Text = Server.HtmlEncode(CCUtility.GetValue(row, "name").ToString());
Detail_author.Text = Server.HtmlEncode(CCUtility.GetValue(row, "author").ToString());
Detail_category_id.Text = Server.HtmlEncode(Utility.Dlookup("categories", "name", "category_id=" + CCUtility.ToSQL(CCUtility.GetValue(row, "category_id"), FieldTypes.Number)).ToString());
Detail_price.Text = Server.HtmlEncode(CCUtility.GetValue(row, "price").ToString());
Detail_image_url.Text = CCUtility.GetValue(row, "image_url");
Detail_image_url.NavigateUrl = CCUtility.GetValue(row, "product_url") + "";
Detail_notes.Text = CCUtility.GetValue(row, "notes");
Detail_product_url.Text = Server.HtmlEncode(CCUtility.GetValue(row, "product_url").ToString());
Detail_product_url.NavigateUrl = CCUtility.GetValue(row, "product_url") + "";
ActionInsert = false;
// Detail ShowEdit Event begin
// Detail ShowEdit Event end
}
}
if (ActionInsert)
{
String pValue;
pValue = Utility.GetParam("item_id"); Detail_item_id.Value = pValue;
// Detail ShowInsert Event begin
// Detail ShowInsert Event end
}
// Detail Open Event begin
// Detail Open Event end
// Detail Show Event begin
Detail_image_url.ImageUrl = Detail_image_url.Text;
Detail_product_url.Text = "Review this book on Amazon.com";
// Detail Show Event end
// Detail Show end
// Detail Close Event begin
// Detail Close Event end
}
public void What_Repeater_ItemDataBound(Object Sender, RepeaterItemEventArgs e)
{
// What Show Event begin
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
((HyperLink)e.Item.FindControl("What_article_title")).Text = "<b>" + ((DataRowView)e.Item.DataItem)["e_article_title"].ToString() + "<b>";
((Label)e.Item.FindControl("What_article_desc")).Text = "<img align=\"left\" border=\"0\" src=\"" + Utility.Dlookup("items", "image_url", "item_id=" + ((DataRowView)e.Item.DataItem)["e_item_id"].ToString()) + "\">" + ((DataRowView)e.Item.DataItem)["e_article_desc"].ToString();
}
// What Show Event end
}