public RenderStateProvince(StateProvince sp) { StateProvinceID = sp.StateProvinceID; Name = Convert.ToString(sp.Name); Country = Convert.ToString(sp.Country); CurrencyCode = Convert.ToString(sp.CurrencyCode); TaxRatePercentage = Convert.ToDouble(sp.TaxRatePercentage); Modified = Convert.ToDateTime(sp.Modified); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //Populate States/Provinces dropdown list StateProvince sp = new StateProvince(); List<StateProvince> states = sp.GetAllStatesProvinces(); DropDownListStateProvince.DataSource = states; DropDownListStateProvince.DataTextField = "Name"; DropDownListStateProvince.DataValueField = "StateProvinceID"; DropDownListStateProvince.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //Obtain User ID from query string int userid = Convert.ToInt32(Request.QueryString["userid"]); //Get User by its code User user = new User(); user.GetUserByID(userid); //Populate States/Provinces dropdown list StateProvince sp = new StateProvince(); List<StateProvince> states = sp.GetAllStatesProvinces(); DropDownListStateProvince.DataSource = states; DropDownListStateProvince.DataTextField = "Name"; DropDownListStateProvince.DataValueField = "StateProvinceID"; DropDownListStateProvince.DataBind(); //Put user details into fields LabelUserID.Text = Request.QueryString["userid"].ToString(); TextBoxUsername.Text = Convert.ToString(user.Username); TextBoxPassword.Text = Convert.ToString(user.Password); TextBoxSalutation.Text = Convert.ToString(user.Salutation); TextBoxFirstName.Text = Convert.ToString(user.FirstName); TextBoxLastName.Text = Convert.ToString(user.LastName); TextBoxAddress1.Text = Convert.ToString(user.Address1); TextBoxAddress2.Text = Convert.ToString(user.Address2); TextBoxCity.Text = Convert.ToString(user.City); DropDownListStateProvince.SelectedValue = Convert.ToString(user.StateProvinceID); TextBoxZipPostalCode.Text = Convert.ToString(user.ZipCodePostal); TextBoxEmail.Text = Convert.ToString(user.Email); CheckBoxIsReceiveNewsletters.Checked = Convert.ToBoolean(user.IsReceiveNewsletters); LabelCreated.Text = Convert.ToDateTime(user.Created).ToShortDateString(); if (Convert.ToDateTime(user.Modified) > DateTime.MinValue) { LabelModified.Text = Convert.ToDateTime(user.Modified).ToShortDateString(); } else { LabelModified.Text = "N/A"; } } }
/// <summary> /// Purpose: Grabs all states/provinces /// Accepts: Nothing /// Returns: List<StateProvince> /// </summary> public List<StateProvince> GetAllStatesProvinces() { List<StateProvince> statesProvinces = new List<StateProvince>(); try { StateProvinceData data = new StateProvinceData(); List<QSRDataObjects.StatesProvince> dataStatesProvinces = data.GetAllStatesProvinces(); foreach (QSRDataObjects.StatesProvince sp in dataStatesProvinces) { StateProvince stateProvince = new StateProvince(); stateProvince.StateProvinceID = sp.StateProvinceID; stateProvince.Name = sp.Name; stateProvince.Country = sp.Country; stateProvince.CurrencyCode = sp.CurrencyCode; stateProvince.TaxRatePercentage = Convert.ToDouble(sp.TaxRatePercentage); stateProvince.Modified = sp.Modified; statesProvinces.Add(stateProvince); } } catch (Exception ex) { ErrorRoutine(ex, "StateProvince", "GetAllStateProvinces"); } return statesProvinces; }
protected void ButtonGoToPayInfo_Click(object sender, EventArgs e) { //Get a reference to the original datasource for the datalist (doesn't take into account DeliveryType changes) DataTable dt = new DataTable(); dt.Columns.Add("Prodcd"); dt.Columns.Add("Name"); dt.Columns.Add("Msrp", System.Type.GetType("System.Double")); dt.Columns.Add("Quantity"); dt.Columns.Add("DeliveryTypeID"); dt.Columns.Add("DeliveryTypeName"); dt.Columns.Add("DeliveryCost", System.Type.GetType("System.Double")); dt.Columns.Add("Taxes", System.Type.GetType("System.Double")); dt.Columns.Add("Total", System.Type.GetType("System.Double")); dt.Columns.Add("FirstName"); dt.Columns.Add("LastName"); dt.Columns.Add("Address1"); dt.Columns.Add("Address2"); dt.Columns.Add("City"); dt.Columns.Add("Country"); dt.Columns.Add("StateProvinceID"); dt.Columns.Add("StateProvinceName"); dt.Columns.Add("ZipPostalCode"); dt.Columns.Add("Email"); //For each data list item... for (int i = 0; i < DataListCheckout.Items.Count; i++) { //Get reference to this data list item DataListItem item = DataListCheckout.Items[i]; if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem) { //Get reference to original datarow for this datalist item DataRow dr = dt.NewRow(); //Get reference to the product for this datalist item Product prod = new Product(); prod.GetProductByCode(DataListCheckout.DataKeys[i].ToString()); dr["Prodcd"] = prod.ProductCode; dr["Name"] = prod.Name; dr["Msrp"] = prod.Msrp; dr["Quantity"] = ((Label)(item.FindControl("LabelQuantity"))).Text; dr["DeliveryTypeID"] = ((DropDownList)(item.FindControl("DropDownListDeliveryType"))).SelectedValue; //Get the delivery type name and cost DeliveryType dtype = new DeliveryType(); dtype.GetDeliveryTypeByID(Convert.ToInt32(dr["DeliveryTypeID"])); dr["DeliveryTypeName"] = dtype.Name; dr["DeliveryCost"] = dtype.Cost; if (((CheckBox)item.FindControl("CheckBoxUseUserAddress")).Checked == true) //use account delivery info { //Get the current user User user = new User(); user.GetUserByID(Convert.ToInt32(Session["UserID"])); dr["FirstName"] = user.FirstName; dr["LastName"] = user.LastName; dr["Address1"] = user.Address1; dr["Address2"] = user.Address2; dr["City"] = user.City; dr["StateProvinceID"] = user.StateProvinceID; //dr["Country"] = user. MUST DEAL WITH COUNTRY LATER dr["ZipPostalCode"] = user.ZipCodePostal; dr["Email"] = user.Email; } else //use customized delivery info { dr["FirstName"] = ((TextBox)(item.FindControl("txtFName"))).Text; dr["LastName"] = ((TextBox)(item.FindControl("txtLName"))).Text; dr["Address1"] = ((TextBox)(item.FindControl("txtAddress"))).Text; dr["Address2"] = ((TextBox)(item.FindControl("txtAddress2"))).Text; dr["City"] = ((TextBox)(item.FindControl("txtCity"))).Text; //dr["Country"] = ((DropDownList)(item.FindControl("dropCountry"))).SelectedValue; MUST DEAL WITH COUNTRY LATER dr["StateProvinceID"] = ((DropDownList)(item.FindControl("dropStateProv"))).SelectedValue; dr["ZipPostalCode"] = ((TextBox)(item.FindControl("txtZipPostal"))).Text; dr["Email"] = ((TextBox)(item.FindControl("txtEmail"))).Text; } //Get the state/province name and tax cost StateProvince sp = new StateProvince(); sp.GetStateProvinceByID(Convert.ToInt32(dr["StateProvinceID"])); dr["StateProvinceName"] = sp.Name; dr["Taxes"] = sp.TaxRatePercentage / 100 * Convert.ToDouble(dr["Msrp"]); //Calculate the total cost dr["Total"] = Convert.ToDouble(dr["Msrp"]) + Convert.ToDouble(dr["DeliveryCost"]) + Convert.ToDouble(dr["Taxes"]); //Add row to datatable dt.Rows.Add(dr); } } //Add checkout list to session Session.Add("CheckoutDataTable",dt); //Go to next page Response.Redirect("~/PaymentInfo.aspx"); }
protected void DataListCheckout_ItemDataBound(object sender, DataListItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { var item = e.Item.DataItem as DataRowView; if (item != null) { //Set the checkbox value attribute var chk = e.Item.FindControl("CheckBoxUseUserAddress") as CheckBox; if (chk != null) { chk.InputAttributes.Add("value", item["Prodcd"].ToString()); } //Set the dropdownlist datasource DropDownList spDDL = e.Item.FindControl("dropStateProv") as DropDownList; StateProvince sp = new StateProvince(); List<StateProvince> states = sp.GetAllStatesProvinces(); spDDL.DataSource = states; spDDL.DataTextField = "Name"; spDDL.DataValueField = "StateProvinceID"; spDDL.DataBind(); //Get all ProductDeliveryType objects for this prodcd ProductDeliveryType pdt = new ProductDeliveryType(); List<ProductDeliveryType> pdtypes = pdt.GetAllProductDeliveryTypesByProdCode(item["Prodcd"].ToString()); //For each ProductDeliveryType, add its associated DeliveryType object to the list List<DeliveryType> dTypes = new List<DeliveryType>(); foreach (ProductDeliveryType pdtype in pdtypes) { DeliveryType delType = new DeliveryType(); delType.GetDeliveryTypeByID(pdtype.DeliveryTypeID); dTypes.Add(delType); } //Assign list of DeliveryType to data list DropDownList delTypesDDL = e.Item.FindControl("DropDownListDeliveryType") as DropDownList; delTypesDDL.DataSource = dTypes; delTypesDDL.DataTextField = "Name"; delTypesDDL.DataValueField = "DeliveryTypeID"; delTypesDDL.DataBind(); } } }
private void reloadGridView() { if (DropDownListDBTables.SelectedValue == "Administrators") { //Get all objects Administrator obj = new Administrator(); List<Administrator> list = obj.GetAllAdministrators(false); //Fill a rendered object list List<RenderAdministrator> renderedList = new List<RenderAdministrator>(); foreach (Administrator x in list) { renderedList.Add(new RenderAdministrator(x)); } GridViewDBTable.DataSource = renderedList; } else if (DropDownListDBTables.SelectedValue == "Audits") { //Get all objects Audit obj = new Audit(); List<Audit> list = obj.GetAllAudits(); //Fill a rendered object list List<RenderAudit> renderedList = new List<RenderAudit>(); foreach (Audit x in list) { renderedList.Add(new RenderAudit(x)); } GridViewDBTable.DataSource = renderedList; } else if (DropDownListDBTables.SelectedValue == "AuditTypes") { //Get all objects AuditType obj = new AuditType(); List<AuditType> list = obj.GetAllAuditTypes(); //Fill a rendered object list List<RenderAuditType> renderedList = new List<RenderAuditType>(); foreach (AuditType x in list) { renderedList.Add(new RenderAuditType(x)); } GridViewDBTable.DataSource = renderedList; } if (DropDownListDBTables.SelectedValue == "Categories") { //Get all objects Category obj = new Category(); List<Category> list = obj.GetAllCategories(false); //Fill a rendered object list List<RenderCategory> renderedList = new List<RenderCategory>(); foreach (Category x in list) { renderedList.Add(new RenderCategory(x)); } GridViewDBTable.DataSource = renderedList; } else if (DropDownListDBTables.SelectedValue == "Configurations") { //Get all objects Configuration obj = new Configuration(); List<Configuration> list = obj.GetAllConfigurations(); //Fill a rendered object list List<RenderConfiguration> renderedList = new List<RenderConfiguration>(); foreach (Configuration x in list) { renderedList.Add(new RenderConfiguration(x)); } GridViewDBTable.DataSource = renderedList; } else if (DropDownListDBTables.SelectedValue == "DeliveryType") { //Get all objects DeliveryType obj = new DeliveryType(); List<DeliveryType> list = obj.GetAllDeliveryTypes(); //Fill a rendered object list List<RenderDeliveryType> renderedList = new List<RenderDeliveryType>(); foreach (DeliveryType x in list) { renderedList.Add(new RenderDeliveryType(x)); } GridViewDBTable.DataSource = renderedList; } else if (DropDownListDBTables.SelectedValue == "LangLabels") { //Get all objects LangLabel obj = new LangLabel(); List<LangLabel> list = obj.GetAllLangLabels(); //Fill a rendered object list List<RenderLangLabel> renderedList = new List<RenderLangLabel>(); foreach (LangLabel x in list) { renderedList.Add(new RenderLangLabel(x)); } GridViewDBTable.DataSource = renderedList; } else if (DropDownListDBTables.SelectedValue == "OrderItems") { //Get all objects OrderItem obj = new OrderItem(); List<OrderItem> list = obj.GetAllOrderItems(); //Fill a rendered object list List<RenderOrderItem> renderedList = new List<RenderOrderItem>(); foreach (OrderItem x in list) { renderedList.Add(new RenderOrderItem(x)); } GridViewDBTable.DataSource = renderedList; } else if (DropDownListDBTables.SelectedValue == "Orders") { //Get all objects Order obj = new Order(); List<Order> list = obj.GetAllOrders(); //Fill a rendered object list List<RenderOrder> renderedList = new List<RenderOrder>(); foreach (Order x in list) { renderedList.Add(new RenderOrder(x)); } GridViewDBTable.DataSource = renderedList; } else if (DropDownListDBTables.SelectedValue == "ProductDeliveryTypes") { //Get all objects ProductDeliveryType obj = new ProductDeliveryType(); List<ProductDeliveryType> list = obj.GetAllProductDeliveryTypes(); //Fill a rendered object list List<RenderProductDeliveryType> renderedList = new List<RenderProductDeliveryType>(); foreach (ProductDeliveryType x in list) { renderedList.Add(new RenderProductDeliveryType(x)); } GridViewDBTable.DataSource = renderedList; } else if (DropDownListDBTables.SelectedValue == "Products") { //Get all objects Product obj = new Product(); List<Product> list = obj.GetAllProducts(false); //Fill a rendered object list List<RenderProduct> renderedList = new List<RenderProduct>(); foreach(Product x in list) { renderedList.Add(new RenderProduct(x)); } GridViewDBTable.DataSource = renderedList; } else if (DropDownListDBTables.SelectedValue == "StatesProvinces") { //Get all objects StateProvince obj = new StateProvince(); List<StateProvince> list = obj.GetAllStatesProvinces(); //Fill a rendered object list List<RenderStateProvince> renderedList = new List<RenderStateProvince>(); foreach (StateProvince x in list) { renderedList.Add(new RenderStateProvince(x)); } GridViewDBTable.DataSource = renderedList; } else if (DropDownListDBTables.SelectedValue == "Users") { //Get all objects User obj = new User(); List<User> list = obj.GetAllUsers(); //Fill a rendered object list List<RenderUser> renderedList = new List<RenderUser>(); foreach (User x in list) { renderedList.Add(new RenderUser(x)); } GridViewDBTable.DataSource = renderedList; } //Databind the new datasource obtained above GridViewDBTable.DataBind(); }
protected void DataListCheckout_ItemDataBound(object sender, DataListItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { var item = e.Item.DataItem as CheckoutItem; if (item != null) { //Set the checkbox value attribute var chk = e.Item.FindControl("CheckBoxUseUserAddress") as CheckBox; if (chk != null) { chk.InputAttributes.Add("value", item.Prodcd.ToString()); } //Set the dropdownlist datasource DropDownList spDDL = e.Item.FindControl("dropStateProv") as DropDownList; StateProvince sp = new StateProvince(); List<StateProvince> states = sp.GetAllStatesProvinces(); spDDL.DataSource = states; spDDL.DataTextField = "Name"; spDDL.DataValueField = "StateProvinceID"; spDDL.DataBind(); } } }