/*=============================== * Display Record Form * -------------------------------*/ void Order_Show() { // Order Show begin bool ActionInsert = true; if (p_Order_order_id.Value.Length > 0) { string sWhere = ""; sWhere += "order_id=" + CCUtility.ToSQL(p_Order_order_id.Value, FieldTypes.Number); // Order Open Event begin // Order 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, "Order") > 0) { row = ds.Tables[0].Rows[0]; Order_order_id.Value = CCUtility.GetValue(row, "order_id"); Order_quantity.Text = CCUtility.GetValue(row, "quantity"); Order_item_id.Value = CCUtility.GetValue(row, "item_id"); Order_insert.Visible = false; ActionInsert = false; // Order ShowEdit Event begin // Order ShowEdit Event end } } if (ActionInsert) { String pValue; pValue = Utility.GetParam("item_id"); Order_item_id.Value = pValue; // Order ShowInsert Event begin // Order ShowInsert Event end } // Order Open Event begin // Order Open Event end // Order Show Event begin // Order Show Event end // Order Show end // Order Close Event begin // Order Close Event end }
bool Categories_delete_Click(Object Src, EventArgs E) { string sWhere = ""; if (p_Categories_category_id.Value.Length > 0) { sWhere += "category_id=" + CCUtility.ToSQL(p_Categories_category_id.Value, FieldTypes.Number); } string sSQL = "delete from categories where " + sWhere; // Categories Delete Event begin // Categories Delete Event end Categories_BeforeSQLExecute(sSQL, "Delete"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Categories_ValidationSummary.Text += e.Message; Categories_ValidationSummary.Visible = true; return(false); } // Categories AfterDelete Event begin // Categories AfterDelete Event end return(true); }
bool ShoppingCartRecord_delete_Click(Object Src, EventArgs E) { string sWhere = ""; if (p_ShoppingCartRecord_order_id.Value.Length > 0) { sWhere += "order_id=" + CCUtility.ToSQL(p_ShoppingCartRecord_order_id.Value, FieldTypes.Number); } string sSQL = "delete from orders where " + sWhere; // ShoppingCartRecord Delete Event begin // ShoppingCartRecord Delete Event end ShoppingCartRecord_BeforeSQLExecute(sSQL, "Delete"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { ShoppingCartRecord_ValidationSummary.Text += e.Message; ShoppingCartRecord_ValidationSummary.Visible = true; return(false); } // ShoppingCartRecord AfterDelete Event begin // ShoppingCartRecord AfterDelete Event end return(true); }
// Book Action begin bool Book_insert_Click(Object Src, EventArgs E) { string sSQL = ""; bool bResult = Book_Validate(); // Book Check Event begin // Book Check Event end string p2_name = CCUtility.ToSQL(Utility.GetParam("Book_name"), FieldTypes.Text); string p2_author = CCUtility.ToSQL(Utility.GetParam("Book_author"), FieldTypes.Text); string p2_category_id = CCUtility.ToSQL(Utility.GetParam("Book_category_id"), FieldTypes.Number); string p2_price = CCUtility.ToSQL(Utility.GetParam("Book_price"), FieldTypes.Number); string p2_product_url = CCUtility.ToSQL(Utility.GetParam("Book_product_url"), FieldTypes.Text); string p2_image_url = CCUtility.ToSQL(Utility.GetParam("Book_image_url"), FieldTypes.Text); string p2_notes = CCUtility.ToSQL(Utility.GetParam("Book_notes"), FieldTypes.Text); string c1_is_recommended = CCUtility.getCheckBoxValue(Utility.GetParam("Book_is_recommended"), "1", "0", FieldTypes.Number); // Book Insert Event begin // Book Insert Event end if (bResult) { if (sSQL.Length == 0) { sSQL = "insert into items (" + "name," + "author," + "category_id," + "price," + "product_url," + "image_url," + "notes," + "is_recommended)" + " values (" + p2_name + "," + p2_author + "," + p2_category_id + "," + p2_price + "," + p2_product_url + "," + p2_image_url + "," + p2_notes + "," + c1_is_recommended + ")"; } Book_BeforeSQLExecute(sSQL, "Insert"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Book_ValidationSummary.Text += e.Message; Book_ValidationSummary.Visible = true; return(false); } // Book AfterInsert Event begin // Book AfterInsert Event end } return(bResult); }
/*=============================== * Display Record Form * -------------------------------*/ void Categories_Show() { // Categories Show begin bool ActionInsert = true; if (p_Categories_category_id.Value.Length > 0) { string sWhere = ""; sWhere += "category_id=" + CCUtility.ToSQL(p_Categories_category_id.Value, FieldTypes.Number); // Categories Open Event begin // Categories Open Event end string sSQL = "select * from categories where " + sWhere; OleDbDataAdapter dsCommand = new OleDbDataAdapter(sSQL, Utility.Connection); DataSet ds = new DataSet(); DataRow row; if (dsCommand.Fill(ds, 0, 1, "Categories") > 0) { row = ds.Tables[0].Rows[0]; Categories_category_id.Value = CCUtility.GetValue(row, "category_id"); Categories_name.Text = CCUtility.GetValue(row, "name"); Categories_insert.Visible = false; ActionInsert = false; // Categories ShowEdit Event begin // Categories ShowEdit Event end } } if (ActionInsert) { String pValue; pValue = Utility.GetParam("category_id"); Categories_category_id.Value = pValue; Categories_delete.Visible = false; Categories_update.Visible = false; // Categories ShowInsert Event begin // Categories ShowInsert Event end } // Categories Open Event begin // Categories Open Event end // Categories Show Event begin // Categories Show Event end // Categories Show end // Categories Close Event begin // Categories Close Event end }
bool Form_update_Click(Object Src, EventArgs E) { string sWhere = ""; string sSQL = ""; bool bResult = Form_Validate(); if (bResult) { if (p_Form_member_id.Value.Length > 0) { sWhere = sWhere + "member_id=" + CCUtility.ToSQL(p_Form_member_id.Value, FieldTypes.Number); } // Form Check Event begin // Form Check Event end if (bResult) { sSQL = "update members set " + "[member_password]=" + CCUtility.ToSQL(Utility.GetParam("Form_member_password"), FieldTypes.Text) + ",[first_name]=" + CCUtility.ToSQL(Utility.GetParam("Form_name"), FieldTypes.Text) + ",[last_name]=" + CCUtility.ToSQL(Utility.GetParam("Form_last_name"), FieldTypes.Text) + ",[email]=" + CCUtility.ToSQL(Utility.GetParam("Form_email"), FieldTypes.Text) + ",[address]=" + CCUtility.ToSQL(Utility.GetParam("Form_address"), FieldTypes.Text) + ",[phone]=" + CCUtility.ToSQL(Utility.GetParam("Form_phone"), FieldTypes.Text) + ",[notes]=" + CCUtility.ToSQL(Utility.GetParam("Form_notes"), FieldTypes.Text) + ",[card_type_id]=" + CCUtility.ToSQL(Utility.GetParam("Form_card_type_id"), FieldTypes.Number) + ",[card_number]=" + CCUtility.ToSQL(Utility.GetParam("Form_card_number"), FieldTypes.Text); sSQL = sSQL + " where " + sWhere; // Form Update Event begin // Form Update Event end Form_BeforeSQLExecute(sSQL, "Update"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Form_ValidationSummary.Text += e.Message; Form_ValidationSummary.Visible = true; return(false); } } if (bResult) { // Form AfterUpdate Event begin // Form AfterUpdate Event end } } return(bResult); }
bool Book_update_Click(Object Src, EventArgs E) { string sWhere = ""; string sSQL = ""; bool bResult = Book_Validate(); if (bResult) { if (p_Book_item_id.Value.Length > 0) { sWhere = sWhere + "item_id=" + CCUtility.ToSQL(p_Book_item_id.Value, FieldTypes.Number); } // Book Check Event begin // Book Check Event end if (bResult) { sSQL = "update items set " + "[name]=" + CCUtility.ToSQL(Utility.GetParam("Book_name"), FieldTypes.Text) + ",[author]=" + CCUtility.ToSQL(Utility.GetParam("Book_author"), FieldTypes.Text) + ",[category_id]=" + CCUtility.ToSQL(Utility.GetParam("Book_category_id"), FieldTypes.Number) + ",[price]=" + CCUtility.ToSQL(Utility.GetParam("Book_price"), FieldTypes.Number) + ",[product_url]=" + CCUtility.ToSQL(Utility.GetParam("Book_product_url"), FieldTypes.Text) + ",[image_url]=" + CCUtility.ToSQL(Utility.GetParam("Book_image_url"), FieldTypes.Text) + ",[notes]=" + CCUtility.ToSQL(Utility.GetParam("Book_notes"), FieldTypes.Text) + ",[is_recommended]=" + CCUtility.getCheckBoxValue(Utility.GetParam("Book_is_recommended"), "1", "0", FieldTypes.Number); sSQL = sSQL + " where " + sWhere; // Book Update Event begin // Book Update Event end Book_BeforeSQLExecute(sSQL, "Update"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Book_ValidationSummary.Text += e.Message; Book_ValidationSummary.Visible = true; return(false); } } if (bResult) { // Book AfterUpdate Event begin // Book AfterUpdate Event end } } return(bResult); }
bool editorials_update_Click(Object Src, EventArgs E) { string sWhere = ""; string sSQL = ""; bool bResult = editorials_Validate(); if (bResult) { if (p_editorials_article_id.Value.Length > 0) { sWhere = sWhere + "article_id=" + CCUtility.ToSQL(p_editorials_article_id.Value, FieldTypes.Number); } // editorials Check Event begin // editorials Check Event end if (bResult) { sSQL = "update editorials set " + "[article_desc]=" + CCUtility.ToSQL(Utility.GetParam("editorials_article_desc"), FieldTypes.Text) + ",[article_title]=" + CCUtility.ToSQL(Utility.GetParam("editorials_article_title"), FieldTypes.Text) + ",[editorial_cat_id]=" + CCUtility.ToSQL(Utility.GetParam("editorials_editorial_cat_id"), FieldTypes.Number) + ",[item_id]=" + CCUtility.ToSQL(Utility.GetParam("editorials_item_id"), FieldTypes.Number); sSQL = sSQL + " where " + sWhere; // editorials Update Event begin // editorials Update Event end editorials_BeforeSQLExecute(sSQL, "Update"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { editorials_ValidationSummary.Text += e.Message; editorials_ValidationSummary.Visible = true; return(false); } } if (bResult) { // editorials AfterUpdate Event begin // editorials AfterUpdate Event end } } return(bResult); }
bool Rating_update_Click(Object Src, EventArgs E) { string sWhere = ""; string sSQL = ""; bool bResult = Rating_Validate(); if (bResult) { if (p_Rating_item_id.Value.Length > 0) { sWhere = sWhere + "item_id=" + CCUtility.ToSQL(p_Rating_item_id.Value, FieldTypes.Number); } // Rating Check Event begin // Rating Check Event end if (bResult) { sSQL = "update items set " + "[rating]=" + CCUtility.ToSQL(Utility.GetParam("Rating_rating"), FieldTypes.Number) + ",[rating_count]=" + CCUtility.ToSQL(Utility.GetParam("Rating_rating_count"), FieldTypes.Number); sSQL = sSQL + " where " + sWhere; // Rating Update Event begin sSQL = "update items set rating=rating+" + Rating_rating.SelectedItem.Value + ", rating_count=rating_count+1 where item_id=" + Rating_item_id.Value; // Rating Update Event end Rating_BeforeSQLExecute(sSQL, "Update"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Rating_ValidationSummary.Text += e.Message; Rating_ValidationSummary.Visible = true; return(false); } } if (bResult) { // Rating AfterUpdate Event begin // Rating AfterUpdate Event end } } return(bResult); }
bool Orders_update_Click(Object Src, EventArgs E) { string sWhere = ""; string sSQL = ""; bool bResult = Orders_Validate(); if (bResult) { if (p_Orders_order_id.Value.Length > 0) { sWhere = sWhere + "order_id=" + CCUtility.ToSQL(p_Orders_order_id.Value, FieldTypes.Number); } // Orders Check Event begin // Orders Check Event end if (bResult) { sSQL = "update orders set " + "[member_id]=" + CCUtility.ToSQL(Utility.GetParam("Orders_member_id"), FieldTypes.Number) + ",[item_id]=" + CCUtility.ToSQL(Utility.GetParam("Orders_item_id"), FieldTypes.Number) + ",[quantity]=" + CCUtility.ToSQL(Utility.GetParam("Orders_quantity"), FieldTypes.Number); sSQL = sSQL + " where " + sWhere; // Orders Update Event begin // Orders Update Event end Orders_BeforeSQLExecute(sSQL, "Update"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Orders_ValidationSummary.Text += e.Message; Orders_ValidationSummary.Visible = true; return(false); } } if (bResult) { // Orders AfterUpdate Event begin // Orders AfterUpdate Event end } } return(bResult); }
// editorials Action begin bool editorials_insert_Click(Object Src, EventArgs E) { string sSQL = ""; bool bResult = editorials_Validate(); // editorials Check Event begin // editorials Check Event end string p2_article_desc = CCUtility.ToSQL(Utility.GetParam("editorials_article_desc"), FieldTypes.Text); string p2_article_title = CCUtility.ToSQL(Utility.GetParam("editorials_article_title"), FieldTypes.Text); string p2_editorial_cat_id = CCUtility.ToSQL(Utility.GetParam("editorials_editorial_cat_id"), FieldTypes.Number); string p2_item_id = CCUtility.ToSQL(Utility.GetParam("editorials_item_id"), FieldTypes.Number); // editorials Insert Event begin // editorials Insert Event end if (bResult) { if (sSQL.Length == 0) { sSQL = "insert into editorials (" + "article_desc," + "article_title," + "editorial_cat_id," + "item_id)" + " values (" + p2_article_desc + "," + p2_article_title + "," + p2_editorial_cat_id + "," + p2_item_id + ")"; } editorials_BeforeSQLExecute(sSQL, "Insert"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { editorials_ValidationSummary.Text += e.Message; editorials_ValidationSummary.Visible = true; return(false); } // editorials AfterInsert Event begin // editorials AfterInsert Event end } return(bResult); }
bool Categories_update_Click(Object Src, EventArgs E) { string sWhere = ""; string sSQL = ""; bool bResult = Categories_Validate(); if (bResult) { if (p_Categories_category_id.Value.Length > 0) { sWhere = sWhere + "category_id=" + CCUtility.ToSQL(p_Categories_category_id.Value, FieldTypes.Number); } // Categories Check Event begin // Categories Check Event end if (bResult) { sSQL = "update categories set " + "[name]=" + CCUtility.ToSQL(Utility.GetParam("Categories_name"), FieldTypes.Text); sSQL = sSQL + " where " + sWhere; // Categories Update Event begin // Categories Update Event end Categories_BeforeSQLExecute(sSQL, "Update"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Categories_ValidationSummary.Text += e.Message; Categories_ValidationSummary.Visible = true; return(false); } } if (bResult) { // Categories AfterUpdate Event begin // Categories AfterUpdate Event end } } return(bResult); }
// Orders Action begin bool Orders_insert_Click(Object Src, EventArgs E) { string sSQL = ""; bool bResult = Orders_Validate(); // Orders Check Event begin // Orders Check Event end string p2_member_id = CCUtility.ToSQL(Utility.GetParam("Orders_member_id"), FieldTypes.Number); string p2_item_id = CCUtility.ToSQL(Utility.GetParam("Orders_item_id"), FieldTypes.Number); string p2_quantity = CCUtility.ToSQL(Utility.GetParam("Orders_quantity"), FieldTypes.Number); // Orders Insert Event begin // Orders Insert Event end if (bResult) { if (sSQL.Length == 0) { sSQL = "insert into orders (" + "member_id," + "item_id," + "quantity)" + " values (" + p2_member_id + "," + p2_item_id + "," + p2_quantity + ")"; } Orders_BeforeSQLExecute(sSQL, "Insert"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Orders_ValidationSummary.Text += e.Message; Orders_ValidationSummary.Visible = true; return(false); } // Orders AfterInsert Event begin // Orders AfterInsert Event end } return(bResult); }
// Categories Action begin bool Categories_insert_Click(Object Src, EventArgs E) { string sSQL = ""; bool bResult = Categories_Validate(); // Categories Check Event begin // Categories Check Event end string p2_name = CCUtility.ToSQL(Utility.GetParam("Categories_name"), FieldTypes.Text); // Categories Insert Event begin // Categories Insert Event end if (bResult) { if (sSQL.Length == 0) { sSQL = "insert into categories (" + "name)" + " values (" + p2_name + ")"; } Categories_BeforeSQLExecute(sSQL, "Insert"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Categories_ValidationSummary.Text += e.Message; Categories_ValidationSummary.Visible = true; return(false); } // Categories AfterInsert Event begin // Categories AfterInsert Event end } return(bResult); }
/*=============================== * Display Record Form * -------------------------------*/ void Member_Show() { // Member Show begin bool ActionInsert = true; if (p_Member_member_id.Value.Length > 0) { string sWhere = ""; sWhere += "member_id=" + CCUtility.ToSQL(p_Member_member_id.Value, FieldTypes.Number); // Member Open Event begin // Member Open Event end string sSQL = "select * from members where " + sWhere; OleDbDataAdapter dsCommand = new OleDbDataAdapter(sSQL, Utility.Connection); DataSet ds = new DataSet(); DataRow row; if (dsCommand.Fill(ds, 0, 1, "Member") > 0) { row = ds.Tables[0].Rows[0]; Member_member_id.Value = CCUtility.GetValue(row, "member_id"); Member_member_login.Text = Server.HtmlEncode(CCUtility.GetValue(row, "member_login").ToString()); Member_member_login.NavigateUrl = "MyInfo.aspx" + "?" + ""; Member_name.Text = Server.HtmlEncode(CCUtility.GetValue(row, "first_name").ToString()); Member_last_name.Text = Server.HtmlEncode(CCUtility.GetValue(row, "last_name").ToString()); Member_address.Text = Server.HtmlEncode(CCUtility.GetValue(row, "address").ToString()); Member_email.Text = Server.HtmlEncode(CCUtility.GetValue(row, "email").ToString()); Member_phone.Text = Server.HtmlEncode(CCUtility.GetValue(row, "phone").ToString()); ActionInsert = false; // Member ShowEdit Event begin // Member ShowEdit Event end } } if (ActionInsert) { String pValue; if (Session["UserID"] != null) { pValue = Session["UserID"].ToString(); } else { pValue = ""; } Member_member_id.Value = pValue; // Member ShowInsert Event begin // Member ShowInsert Event end } // Member Open Event begin // Member Open Event end // Member Show Event begin // Member Show Event end // Member Show end // Member Close Event begin // Member Close Event end }
/*=============================== * Display Record Form * -------------------------------*/ void Orders_Show() { // Orders Show begin Utility.buildListBox(Orders_member_id.Items, "select member_id,member_login from members order by 2", "member_id", "member_login", null, ""); Utility.buildListBox(Orders_item_id.Items, "select item_id,name from items order by 2", "item_id", "name", null, ""); bool ActionInsert = true; if (p_Orders_order_id.Value.Length > 0) { string sWhere = ""; sWhere += "order_id=" + CCUtility.ToSQL(p_Orders_order_id.Value, FieldTypes.Number); // Orders Open Event begin // Orders 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, "Orders") > 0) { row = ds.Tables[0].Rows[0]; Orders_order_id.Text = Server.HtmlEncode(CCUtility.GetValue(row, "order_id").ToString()); { string s; s = CCUtility.GetValue(row, "member_id"); try { Orders_member_id.SelectedIndex = Orders_member_id.Items.IndexOf(Orders_member_id.Items.FindByValue(s)); }catch {} } { string s; s = CCUtility.GetValue(row, "item_id"); try { Orders_item_id.SelectedIndex = Orders_item_id.Items.IndexOf(Orders_item_id.Items.FindByValue(s)); }catch {} } Orders_quantity.Text = CCUtility.GetValue(row, "quantity"); Orders_insert.Visible = false; ActionInsert = false; // Orders ShowEdit Event begin // Orders ShowEdit Event end } } if (ActionInsert) { String pValue; pValue = Utility.GetParam("order_id"); Orders_order_id.Text = pValue; pValue = Utility.GetParam("member_id"); try { Orders_member_id.SelectedIndex = Orders_member_id.Items.IndexOf(Orders_member_id.Items.FindByValue(pValue)); }catch {} pValue = Utility.GetParam("item_id"); try { Orders_item_id.SelectedIndex = Orders_item_id.Items.IndexOf(Orders_item_id.Items.FindByValue(pValue)); }catch {} Orders_delete.Visible = false; Orders_update.Visible = false; // Orders ShowInsert Event begin // Orders ShowInsert Event end } // Orders Open Event begin // Orders Open Event end // Orders Show Event begin // Orders Show Event end // Orders Show end // Orders Close Event begin // Orders Close Event end }
/*=============================== * Display Record Form * -------------------------------*/ void Form_Show() { // Form Show begin Utility.buildListBox(Form_card_type_id.Items, "select card_type_id,name from card_types order by 2", "card_type_id", "name", "", ""); bool ActionInsert = true; if (p_Form_member_id.Value.Length > 0) { string sWhere = ""; sWhere += "member_id=" + CCUtility.ToSQL(p_Form_member_id.Value, FieldTypes.Number); // Form Open Event begin // Form Open Event end string sSQL = "select * from members where " + sWhere; OleDbDataAdapter dsCommand = new OleDbDataAdapter(sSQL, Utility.Connection); DataSet ds = new DataSet(); DataRow row; if (dsCommand.Fill(ds, 0, 1, "Form") > 0) { row = ds.Tables[0].Rows[0]; Form_member_id.Value = CCUtility.GetValue(row, "member_id"); Form_member_login.Text = Server.HtmlEncode(CCUtility.GetValue(row, "member_login").ToString()); Form_member_password.Text = CCUtility.GetValue(row, "member_password"); Form_name.Text = CCUtility.GetValue(row, "first_name"); Form_last_name.Text = CCUtility.GetValue(row, "last_name"); Form_email.Text = CCUtility.GetValue(row, "email"); Form_address.Text = CCUtility.GetValue(row, "address"); Form_phone.Text = CCUtility.GetValue(row, "phone"); Form_notes.Text = CCUtility.GetValue(row, "notes"); { string s; s = CCUtility.GetValue(row, "card_type_id"); try { Form_card_type_id.SelectedIndex = Form_card_type_id.Items.IndexOf(Form_card_type_id.Items.FindByValue(s)); }catch {} } Form_card_number.Text = CCUtility.GetValue(row, "card_number"); ActionInsert = false; // Form ShowEdit Event begin // Form ShowEdit Event end } } if (ActionInsert) { String pValue; if (Session["UserID"] != null) { pValue = Session["UserID"].ToString(); } else { pValue = ""; } Form_member_id.Value = pValue; Form_update.Visible = false; // Form ShowInsert Event begin // Form ShowInsert Event end } // Form Open Event begin // Form Open Event end // Form Show Event begin // Form Show Event end // Form Show end // Form Close Event begin // Form Close Event end }
/*=============================== * Display Record Form * -------------------------------*/ void Record_Show() { // Record Show begin bool ActionInsert = true; if (p_Record_member_id.Value.Length > 0) { string sWhere = ""; sWhere += "member_id=" + CCUtility.ToSQL(p_Record_member_id.Value, FieldTypes.Number); // Record Open Event begin // Record Open Event end string sSQL = "select * from members where " + sWhere; OleDbDataAdapter dsCommand = new OleDbDataAdapter(sSQL, Utility.Connection); DataSet ds = new DataSet(); DataRow row; if (dsCommand.Fill(ds, 0, 1, "Record") > 0) { row = ds.Tables[0].Rows[0]; Record_member_id.Value = CCUtility.GetValue(row, "member_id"); Record_member_login.Text = Server.HtmlEncode(CCUtility.GetValue(row, "member_login").ToString()); Record_member_login.NavigateUrl = "MembersRecord.aspx" + "?" + "member_id=" + Server.UrlEncode(CCUtility.GetValue(row, "member_id").ToString()) + "&" + ""; Record_member_level.Text = Server.HtmlEncode(CCUtility.GetValue(row, "member_level").ToString()); Record_name.Text = Server.HtmlEncode(CCUtility.GetValue(row, "first_name").ToString()); Record_last_name.Text = Server.HtmlEncode(CCUtility.GetValue(row, "last_name").ToString()); Record_email.Text = Server.HtmlEncode(CCUtility.GetValue(row, "email").ToString()); Record_phone.Text = Server.HtmlEncode(CCUtility.GetValue(row, "phone").ToString()); Record_address.Text = Server.HtmlEncode(CCUtility.GetValue(row, "address").ToString()); Record_notes.Text = Server.HtmlEncode(CCUtility.GetValue(row, "notes").ToString()); ActionInsert = false; // Record ShowEdit Event begin // Record ShowEdit Event end } } if (ActionInsert) { // Record ShowInsert Event begin // Record ShowInsert Event end } // Record Open Event begin // Record Open Event end // Record Show Event begin // Record Show Event end // Record Show end // Record Close Event begin // Record Close Event end }
/*=============================== * Display Record Form * -------------------------------*/ void Rating_Show() { // Rating Show begin Utility.buildListBox(Rating_rating.Items, Rating_rating_lov, null, ""); bool ActionInsert = true; if (p_Rating_item_id.Value.Length > 0) { string sWhere = ""; sWhere += "item_id=" + CCUtility.ToSQL(p_Rating_item_id.Value, FieldTypes.Number); // Rating Open Event begin // Rating 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, "Rating") > 0) { row = ds.Tables[0].Rows[0]; Rating_item_id.Value = CCUtility.GetValue(row, "item_id"); Rating_rating_view.Text = CCUtility.GetValue(row, "rating"); Rating_rating_count_view.Text = Server.HtmlEncode(CCUtility.GetValue(row, "rating_count").ToString()); { string s; s = CCUtility.GetValue(row, "rating"); try { Rating_rating.SelectedIndex = Rating_rating.Items.IndexOf(Rating_rating.Items.FindByValue(s)); }catch {} } Rating_rating_count.Value = CCUtility.GetValue(row, "rating_count"); ActionInsert = false; // Rating ShowEdit Event begin // Rating ShowEdit Event end } } if (ActionInsert) { String pValue; pValue = Utility.GetParam("item_id"); Rating_item_id.Value = pValue; Rating_update.Visible = false; // Rating ShowInsert Event begin // Rating ShowInsert Event end } // Rating Open Event begin // Rating Open Event end // Rating Show Event begin if (Int16.Parse(Rating_rating_view.Text) == 0) { Rating_rating_view.Text = "Not rated yet"; Rating_rating_count_view.Text = ""; } else { Rating_rating_view.Text = "<img src=images/" + System.Math.Round(Double.Parse(Rating_rating.SelectedItem.Value) / Double.Parse(Rating_rating_count.Value)) + "stars.gif>"; } // Rating Show Event end // Rating Show end // Rating Close Event begin // Rating Close Event end }
/*=============================== * Display Record Form * -------------------------------*/ void editorials_Show() { // editorials Show begin Utility.buildListBox(editorials_editorial_cat_id.Items, "select editorial_cat_id,editorial_cat_name from editorial_categories order by 2", "editorial_cat_id", "editorial_cat_name", null, ""); Utility.buildListBox(editorials_item_id.Items, "select item_id,name from items order by 2", "item_id", "name", "", ""); bool ActionInsert = true; if (p_editorials_article_id.Value.Length > 0) { string sWhere = ""; sWhere += "article_id=" + CCUtility.ToSQL(p_editorials_article_id.Value, FieldTypes.Number); // editorials Open Event begin // editorials Open Event end string sSQL = "select * from editorials where " + sWhere; OleDbDataAdapter dsCommand = new OleDbDataAdapter(sSQL, Utility.Connection); DataSet ds = new DataSet(); DataRow row; if (dsCommand.Fill(ds, 0, 1, "editorials") > 0) { row = ds.Tables[0].Rows[0]; editorials_article_id.Value = CCUtility.GetValue(row, "article_id"); editorials_article_desc.Text = CCUtility.GetValue(row, "article_desc"); editorials_article_title.Text = CCUtility.GetValue(row, "article_title"); { string s; s = CCUtility.GetValue(row, "editorial_cat_id"); try { editorials_editorial_cat_id.SelectedIndex = editorials_editorial_cat_id.Items.IndexOf(editorials_editorial_cat_id.Items.FindByValue(s)); }catch {} } { string s; s = CCUtility.GetValue(row, "item_id"); try { editorials_item_id.SelectedIndex = editorials_item_id.Items.IndexOf(editorials_item_id.Items.FindByValue(s)); }catch {} } editorials_insert.Visible = false; ActionInsert = false; // editorials ShowEdit Event begin // editorials ShowEdit Event end } } if (ActionInsert) { String pValue; pValue = Utility.GetParam("article_id"); editorials_article_id.Value = pValue; editorials_delete.Visible = false; editorials_update.Visible = false; // editorials ShowInsert Event begin // editorials ShowInsert Event end } // editorials Open Event begin // editorials Open Event end // editorials Show Event begin // editorials Show Event end // editorials Show end // editorials Close Event begin // editorials 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 }
ICollection Orders_CreateDataSource() { // Orders Show begin Orders_sSQL = ""; Orders_sCountSQL = ""; string sWhere = "", sOrder = ""; bool bReq = true; bool HasParam = false; //------------------------------- // Build ORDER BY statement //------------------------------- if (Utility.GetParam("FormOrders_Sorting").Length > 0 && !IsPostBack) { ViewState["SortColumn"] = Utility.GetParam("FormOrders_Sorting"); ViewState["SortDir"] = "ASC"; } if (ViewState["SortColumn"] != null) { sOrder = " ORDER BY " + ViewState["SortColumn"].ToString() + " " + ViewState["SortDir"].ToString(); } //------------------------------- // Build WHERE statement //------------------------------- System.Collections.Specialized.StringDictionary Params = new System.Collections.Specialized.StringDictionary(); if (!Params.ContainsKey("member_id")) { string temp = Utility.GetParam("member_id"); if (Utility.IsNumeric(null, temp) && temp.Length > 0) { temp = CCUtility.ToSQL(temp, FieldTypes.Number); } else { temp = ""; } Params.Add("member_id", temp); } if (Params["member_id"].Length > 0) { HasParam = true; sWhere += "o.[member_id]=" + Params["member_id"]; } else { bReq = false; } if (HasParam) { sWhere = " AND (" + sWhere + ")"; } //------------------------------- // Build base SQL statement //------------------------------- Orders_sSQL = "select [o].[item_id] as o_item_id, " + "[o].[member_id] as o_member_id, " + "[o].[order_id] as o_order_id, " + "[o].[quantity] as o_quantity, " + "[i].[item_id] as i_item_id, " + "[i].[name] as i_name " + " from [orders] o, [items] i" + " where [i].[item_id]=o.[item_id] "; //------------------------------- //------------------------------- //------------------------------- //------------------------------- // Assemble full SQL statement //------------------------------- Orders_sSQL = Orders_sSQL + sWhere + sOrder; //------------------------------- if (!bReq) { Orders_no_records.Visible = true; return(null); } OleDbDataAdapter command = new OleDbDataAdapter(Orders_sSQL, Utility.Connection); DataSet ds = new DataSet(); command.Fill(ds, 0, Orders_PAGENUM, "Orders"); DataView Source; Source = new DataView(ds.Tables[0]); if (ds.Tables[0].Rows.Count == 0) { Orders_no_records.Visible = true; } else { Orders_no_records.Visible = false; } return(Source); // Orders Show end }
// Members Action begin bool Members_insert_Click(Object Src, EventArgs E) { string sSQL = ""; bool bResult = Members_Validate(); { int iCount = Utility.DlookupInt("members", "count(*)", "member_login="******"Members_member_login"), FieldTypes.Text)); if (iCount != 0) { Members_ValidationSummary.Visible = true; Members_ValidationSummary.Text += "The value in field Login* is already in database." + "<br>"; bResult = false; } } // Members Check Event begin // Members Check Event end string p2_member_login = CCUtility.ToSQL(Utility.GetParam("Members_member_login"), FieldTypes.Text); string p2_member_password = CCUtility.ToSQL(Utility.GetParam("Members_member_password"), FieldTypes.Text); string p2_member_level = CCUtility.ToSQL(Utility.GetParam("Members_member_level"), FieldTypes.Number); string p2_name = CCUtility.ToSQL(Utility.GetParam("Members_name"), FieldTypes.Text); string p2_last_name = CCUtility.ToSQL(Utility.GetParam("Members_last_name"), FieldTypes.Text); string p2_email = CCUtility.ToSQL(Utility.GetParam("Members_email"), FieldTypes.Text); string p2_phone = CCUtility.ToSQL(Utility.GetParam("Members_phone"), FieldTypes.Text); string p2_address = CCUtility.ToSQL(Utility.GetParam("Members_address"), FieldTypes.Text); string p2_notes = CCUtility.ToSQL(Utility.GetParam("Members_notes"), FieldTypes.Text); string p2_card_type_id = CCUtility.ToSQL(Utility.GetParam("Members_card_type_id"), FieldTypes.Number); string p2_card_number = CCUtility.ToSQL(Utility.GetParam("Members_card_number"), FieldTypes.Text); // Members Insert Event begin // Members Insert Event end if (bResult) { if (sSQL.Length == 0) { sSQL = "insert into members (" + "member_login," + "member_password," + "member_level," + "first_name," + "last_name," + "email," + "phone," + "address," + "notes," + "card_type_id," + "card_number)" + " values (" + p2_member_login + "," + p2_member_password + "," + p2_member_level + "," + p2_name + "," + p2_last_name + "," + p2_email + "," + p2_phone + "," + p2_address + "," + p2_notes + "," + p2_card_type_id + "," + p2_card_number + ")"; } Members_BeforeSQLExecute(sSQL, "Insert"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Members_ValidationSummary.Text += e.Message; Members_ValidationSummary.Visible = true; return(false); } // Members AfterInsert Event begin // Members AfterInsert Event end } return(bResult); }
/*=============================== * Display Record Form * -------------------------------*/ void Book_Show() { // Book Show begin Utility.buildListBox(Book_category_id.Items, "select category_id,name from categories order by 2", "category_id", "name", null, ""); bool ActionInsert = true; if (p_Book_item_id.Value.Length > 0) { string sWhere = ""; sWhere += "item_id=" + CCUtility.ToSQL(p_Book_item_id.Value, FieldTypes.Number); // Book Open Event begin // Book 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, "Book") > 0) { row = ds.Tables[0].Rows[0]; Book_item_id.Value = CCUtility.GetValue(row, "item_id"); Book_name.Text = CCUtility.GetValue(row, "name"); Book_author.Text = CCUtility.GetValue(row, "author"); { string s; s = CCUtility.GetValue(row, "category_id"); try { Book_category_id.SelectedIndex = Book_category_id.Items.IndexOf(Book_category_id.Items.FindByValue(s)); }catch {} } Book_price.Text = CCUtility.GetValue(row, "price"); Book_product_url.Text = CCUtility.GetValue(row, "product_url"); Book_image_url.Text = CCUtility.GetValue(row, "image_url"); Book_notes.Text = CCUtility.GetValue(row, "notes"); Book_is_recommended.Checked = CCUtility.GetValue(row, "is_recommended").ToLower().Equals("1".ToLower()); Book_insert.Visible = false; ActionInsert = false; // Book ShowEdit Event begin // Book ShowEdit Event end } } if (ActionInsert) { String pValue; pValue = Utility.GetParam("item_id"); Book_item_id.Value = pValue; pValue = Utility.GetParam("category_id"); try { Book_category_id.SelectedIndex = Book_category_id.Items.IndexOf(Book_category_id.Items.FindByValue(pValue)); }catch {} Book_delete.Visible = false; Book_update.Visible = false; // Book ShowInsert Event begin // Book ShowInsert Event end } // Book Open Event begin // Book Open Event end // Book Show Event begin // Book Show Event end // Book Show end // Book Close Event begin // Book Close Event 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 Members_Show() { // Members Show begin Utility.buildListBox(Members_member_level.Items, Members_member_level_lov, null, ""); Utility.buildListBox(Members_card_type_id.Items, "select card_type_id,name from card_types order by 2", "card_type_id", "name", "", ""); bool ActionInsert = true; if (p_Members_member_id.Value.Length > 0) { string sWhere = ""; sWhere += "member_id=" + CCUtility.ToSQL(p_Members_member_id.Value, FieldTypes.Number); // Members Open Event begin // Members Open Event end string sSQL = "select * from members where " + sWhere; OleDbDataAdapter dsCommand = new OleDbDataAdapter(sSQL, Utility.Connection); DataSet ds = new DataSet(); DataRow row; if (dsCommand.Fill(ds, 0, 1, "Members") > 0) { row = ds.Tables[0].Rows[0]; Members_member_id.Value = CCUtility.GetValue(row, "member_id"); Members_member_login.Text = CCUtility.GetValue(row, "member_login"); Members_member_password.Text = CCUtility.GetValue(row, "member_password"); { string s; s = CCUtility.GetValue(row, "member_level"); try { Members_member_level.SelectedIndex = Members_member_level.Items.IndexOf(Members_member_level.Items.FindByValue(s)); }catch {} } Members_name.Text = CCUtility.GetValue(row, "first_name"); Members_last_name.Text = CCUtility.GetValue(row, "last_name"); Members_email.Text = CCUtility.GetValue(row, "email"); Members_phone.Text = CCUtility.GetValue(row, "phone"); Members_address.Text = CCUtility.GetValue(row, "address"); Members_notes.Text = CCUtility.GetValue(row, "notes"); { string s; s = CCUtility.GetValue(row, "card_type_id"); try { Members_card_type_id.SelectedIndex = Members_card_type_id.Items.IndexOf(Members_card_type_id.Items.FindByValue(s)); }catch {} } Members_card_number.Text = CCUtility.GetValue(row, "card_number"); Members_insert.Visible = false; ActionInsert = false; // Members ShowEdit Event begin // Members ShowEdit Event end } } if (ActionInsert) { String pValue; pValue = Utility.GetParam("member_id"); Members_member_id.Value = pValue; pValue = Utility.GetParam("member_login"); Members_member_login.Text = pValue; Members_delete.Visible = false; Members_update.Visible = false; // Members ShowInsert Event begin // Members ShowInsert Event end } // Members Open Event begin // Members Open Event end // Members Show Event begin // Members Show Event end // Members Show end // Members Close Event begin // Members Close Event end }
ICollection Orders_CreateDataSource() { // Orders Show begin Orders_sSQL = ""; Orders_sCountSQL = ""; string sWhere = "", sOrder = ""; bool HasParam = false; //------------------------------- // Build ORDER BY statement //------------------------------- sOrder = " order by o.order_id Asc"; if (Utility.GetParam("FormOrders_Sorting").Length > 0 && !IsPostBack) { ViewState["SortColumn"] = Utility.GetParam("FormOrders_Sorting"); ViewState["SortDir"] = "ASC"; } if (ViewState["SortColumn"] != null) { sOrder = "ORDER BY @SortColumn @SortDir"; } //------------------------------- // Build WHERE statement //------------------------------- System.Collections.Specialized.StringDictionary Params = new System.Collections.Specialized.StringDictionary(); if (!Params.ContainsKey("item_id")) { string temp = Utility.GetParam("item_id"); if (Utility.IsNumeric(null, temp) && temp.Length > 0) { temp = CCUtility.ToSQL(temp, FieldTypes.Number); } else { temp = ""; } Params.Add("item_id", temp); } if (!Params.ContainsKey("member_id")) { string temp = Utility.GetParam("member_id"); if (Utility.IsNumeric(null, temp) && temp.Length > 0) { temp = CCUtility.ToSQL(temp, FieldTypes.Number); } else { temp = ""; } Params.Add("member_id", temp); } if (Params["item_id"].Length > 0) { HasParam = true; sWhere += "o.[item_id]=" + Params["item_id"]; } if (Params["member_id"].Length > 0) { if (sWhere.Length > 0) { sWhere += " and "; } HasParam = true; sWhere += "o.[member_id]=" + Params["member_id"]; } if (HasParam) { sWhere = " AND (" + sWhere + ")"; } //------------------------------- // Build base SQL statement //------------------------------- Orders_sSQL = "select [o].[item_id] as o_item_id, " + "[o].[member_id] as o_member_id, " + "[o].[order_id] as o_order_id, " + "[o].[quantity] as o_quantity, " + "[i].[item_id] as i_item_id, " + "[i].[name] as i_name, " + "[m].[member_id] as m_member_id, " + "[m].[member_login] as m_member_login " + " from [orders] o, [items] i, [members] m" + " where [i].[item_id]=o.[item_id] and [m].[member_id]=o.[member_id] "; //------------------------------- //------------------------------- //------------------------------- //------------------------------- // Assemble full SQL statement //------------------------------- Orders_sSQL = Orders_sSQL + sWhere + sOrder; if (Orders_sCountSQL.Length == 0) { int iTmpI = Orders_sSQL.ToLower().IndexOf("select "); int iTmpJ = Orders_sSQL.ToLower().LastIndexOf(" from ") - 1; Orders_sCountSQL = Orders_sSQL.Replace(Orders_sSQL.Substring(iTmpI + 7, iTmpJ - 6), " count(*) "); iTmpI = Orders_sCountSQL.ToLower().IndexOf(" order by"); if (iTmpI > 1) { Orders_sCountSQL = Orders_sCountSQL.Substring(0, iTmpI); } } //------------------------------- OleDbDataAdapter command = new OleDbDataAdapter(Orders_sSQL, Utility.Connection); command.SelectCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("@SortColumn", viewstate["SortColumn"])); command.SelectCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("@SortDir", viewstate["SortDir"])); DataSet ds = new DataSet(); command.Fill(ds, (i_Orders_curpage - 1) * Orders_PAGENUM, Orders_PAGENUM, "Orders"); OleDbCommand ccommand = new OleDbCommand(Orders_sCountSQL, Utility.Connection); int PageTemp = (int)ccommand.ExecuteScalar(); Orders_Pager.MaxPage = (PageTemp % Orders_PAGENUM) > 0?(int)(PageTemp / Orders_PAGENUM) + 1:(int)(PageTemp / Orders_PAGENUM); bool AllowScroller = Orders_Pager.MaxPage == 1?false:true; DataView Source; Source = new DataView(ds.Tables[0]); if (ds.Tables[0].Rows.Count == 0) { Orders_no_records.Visible = true; AllowScroller = false; } else { Orders_no_records.Visible = false; AllowScroller = AllowScroller && true; } Orders_Pager.Visible = AllowScroller; return(Source); // Orders Show end }
bool Members_update_Click(Object Src, EventArgs E) { string sWhere = ""; string sSQL = ""; bool bResult = Members_Validate(); if (bResult) { if (p_Members_member_id.Value.Length > 0) { sWhere = sWhere + "member_id=" + CCUtility.ToSQL(p_Members_member_id.Value, FieldTypes.Number); } { int iCount = Utility.DlookupInt("members", "count(*)", "member_login="******"Members_member_login"), FieldTypes.Text) + " and not(" + sWhere + ")"); if (iCount != 0) { Members_ValidationSummary.Visible = true; Members_ValidationSummary.Text += "The value in field Login* is already in database." + "<br>"; bResult = false; } } // Members Check Event begin // Members Check Event end if (bResult) { sSQL = "update members set " + "[member_login]=" + CCUtility.ToSQL(Utility.GetParam("Members_member_login"), FieldTypes.Text) + ",[member_password]=" + CCUtility.ToSQL(Utility.GetParam("Members_member_password"), FieldTypes.Text) + ",[member_level]=" + CCUtility.ToSQL(Utility.GetParam("Members_member_level"), FieldTypes.Number) + ",[first_name]=" + CCUtility.ToSQL(Utility.GetParam("Members_name"), FieldTypes.Text) + ",[last_name]=" + CCUtility.ToSQL(Utility.GetParam("Members_last_name"), FieldTypes.Text) + ",[email]=" + CCUtility.ToSQL(Utility.GetParam("Members_email"), FieldTypes.Text) + ",[phone]=" + CCUtility.ToSQL(Utility.GetParam("Members_phone"), FieldTypes.Text) + ",[address]=" + CCUtility.ToSQL(Utility.GetParam("Members_address"), FieldTypes.Text) + ",[notes]=" + CCUtility.ToSQL(Utility.GetParam("Members_notes"), FieldTypes.Text) + ",[card_type_id]=" + CCUtility.ToSQL(Utility.GetParam("Members_card_type_id"), FieldTypes.Number) + ",[card_number]=" + CCUtility.ToSQL(Utility.GetParam("Members_card_number"), FieldTypes.Text); sSQL = sSQL + " where " + sWhere; // Members Update Event begin // Members Update Event end Members_BeforeSQLExecute(sSQL, "Update"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Members_ValidationSummary.Text += e.Message; Members_ValidationSummary.Visible = true; return(false); } } if (bResult) { // Members AfterUpdate Event begin // Members AfterUpdate Event end } } return(bResult); }
ICollection Total_CreateDataSource() { // Total Show begin Total_sSQL = ""; Total_sCountSQL = ""; string sWhere = "", sOrder = ""; bool bReq = true; bool HasParam = false; //------------------------------- // Build WHERE statement //------------------------------- System.Collections.Specialized.StringDictionary Params = new System.Collections.Specialized.StringDictionary(); if (!Params.ContainsKey("UserID")) { object Temp = Session["UserID"]; string temp; if (Temp == null) { temp = ""; } else { temp = Temp.ToString(); } if (Utility.IsNumeric(null, temp) && temp.Length > 0) { temp = CCUtility.ToSQL(temp, FieldTypes.Number); } else { temp = ""; } Params.Add("UserID", temp); } if (Params["UserID"].Length > 0) { HasParam = true; sWhere += "[member_id]=" + Params["UserID"]; } else { bReq = false; } if (HasParam) { sWhere = " AND (" + sWhere + ")"; } //------------------------------- // Build base SQL statement //------------------------------- Total_sSQL = "SELECT member_id, sum(quantity*price) as sub_total FROM items, orders WHERE orders.item_id=items.item_id"; sOrder = " GROUP BY member_id"; //------------------------------- //------------------------------- //------------------------------- //------------------------------- // Assemble full SQL statement //------------------------------- Total_sSQL = Total_sSQL + sWhere + sOrder; //------------------------------- if (!bReq) { Total_no_records.Visible = true; return(null); } OleDbDataAdapter command = new OleDbDataAdapter(Total_sSQL, Utility.Connection); DataSet ds = new DataSet(); command.Fill(ds, 0, Total_PAGENUM, "Total"); DataView Source; Source = new DataView(ds.Tables[0]); if (ds.Tables[0].Rows.Count == 0) { Total_no_records.Visible = true; } else { Total_no_records.Visible = false; } return(Source); // Total Show end }
ICollection Items_CreateDataSource() { // Items Show begin Items_sSQL = ""; Items_sCountSQL = ""; string sWhere = "", sOrder = ""; bool HasParam = false; //------------------------------- // Build ORDER BY statement //------------------------------- if (Utility.GetParam("FormItems_Sorting").Length > 0 && !IsPostBack) { ViewState["SortColumn"] = Utility.GetParam("FormItems_Sorting"); ViewState["SortDir"] = "ASC"; } if (ViewState["SortColumn"] != null) { sOrder = ""; } //------------------------------- // Build WHERE statement //------------------------------- System.Collections.Specialized.StringDictionary Params = new System.Collections.Specialized.StringDictionary(); if (!Params.ContainsKey("category_id")) { string temp = Utility.GetParam("category_id"); if (Utility.IsNumeric(null, temp) && temp.Length > 0) { temp = CCUtility.ToSQL(temp, FieldTypes.Number); } else { temp = ""; } Params.Add("category_id", temp); } if (!Params.ContainsKey("is_recommended")) { string temp = Utility.GetParam("is_recommended"); if (Utility.IsNumeric(null, temp) && temp.Length > 0) { temp = CCUtility.ToSQL(temp, FieldTypes.Number); } else { temp = ""; } Params.Add("is_recommended", temp); } if (Params["category_id"].Length > 0) { HasParam = true; sWhere += "i.[category_id]=" + Params["category_id"]; } if (Params["is_recommended"].Length > 0) { if (sWhere.Length > 0) { sWhere += " and "; } HasParam = true; sWhere += "i.[is_recommended]=" + Params["is_recommended"]; } if (HasParam) { sWhere = " AND (" + sWhere + ")"; } //------------------------------- // Build base SQL statement //------------------------------- Items_sSQL = "select [i].[author] as i_author, " + "[i].[category_id] as i_category_id, " + "[i].[is_recommended] as i_is_recommended, " + "[i].[item_id] as i_item_id, " + "[i].[name] as i_name, " + "[i].[price] as i_price, " + "[c].[category_id] as c_category_id, " + "[c].[name] as c_name " + " from [items] i, [categories] c" + " where [c].[category_id]=i.[category_id] "; //------------------------------- //------------------------------- //------------------------------- //------------------------------- // Assemble full SQL statement //------------------------------- Items_sSQL = Items_sSQL + sWhere + sOrder; if (Items_sCountSQL.Length == 0) { int iTmpI = Items_sSQL.ToLower().IndexOf("select "); int iTmpJ = Items_sSQL.ToLower().LastIndexOf(" from ") - 1; Items_sCountSQL = Items_sSQL.Replace(Items_sSQL.Substring(iTmpI + 7, iTmpJ - 6), " count(*) "); iTmpI = Items_sCountSQL.ToLower().IndexOf(" order by"); if (iTmpI > 1) { Items_sCountSQL = Items_sCountSQL.Substring(0, iTmpI); } } //------------------------------- OleDbDataAdapter command = new OleDbDataAdapter(Items_sSQL, Utility.Connection); DataSet ds = new DataSet(); command.Fill(ds, (i_Items_curpage - 1) * Items_PAGENUM, Items_PAGENUM, "Items"); OleDbCommand ccommand = new OleDbCommand(Items_sCountSQL, Utility.Connection); int PageTemp = (int)ccommand.ExecuteScalar(); Items_Pager.MaxPage = (PageTemp % Items_PAGENUM) > 0?(int)(PageTemp / Items_PAGENUM) + 1:(int)(PageTemp / Items_PAGENUM); bool AllowScroller = Items_Pager.MaxPage == 1?false:true; DataView Source; Source = new DataView(ds.Tables[0]); if (ds.Tables[0].Rows.Count == 0) { Items_no_records.Visible = true; AllowScroller = false; } else { Items_no_records.Visible = false; AllowScroller = AllowScroller && true; } Items_Pager.Visible = AllowScroller; return(Source); // Items Show end }