/// <summary> /// Populates the database with the order details /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSend_Click(object sender, EventArgs e) { string notes = orderNotes.InnerText; string result = ""; Database obj = new Database(); try { obj.Connect(); obj.Insert("INSERT INTO Orders (OrderDetails, TotalPrice, Notes, OrderDate, Email) VALUES('" + odr.Details + "','" + odr.Price + "','" + notes + "', '" + DateTime.Now + "','"+txtEmail.Text+"');"); obj.Close(); result = "true"; } catch (Exception ex) { result = "false"; log.LogErrorMessage("Error creating order: " + ex); } finally { obj.Close(); } Response.Redirect("~/Project.aspx?LayoutID=" + (Request.QueryString["LayoutID"]), false); object refUrl = ViewState["RefUrl"]; if (refUrl != null) Response.Redirect((string)refUrl+"&Request="+result); }
/// <summary> /// Initial load of the screen - loads the differnet component types. /// </summary> private void LoadProjectTypes() { Database obj = new Database(); try { obj.Connect(); obj.Query("SELECT * FROM Projects ORDER BY seq"); if (obj.rdr.HasRows == true) { while (obj.rdr.Read()) { HtmlGenericControl li = new HtmlGenericControl("li"); tiles.Controls.Add(li); HtmlGenericControl anchor = new HtmlGenericControl("a"); if (Convert.ToString(obj.rdr["ProjectType"].ToString()) == "12") { //Hardcode link for walking closets anchor.Attributes.Add("href", "ClosetShape.htm"); } else { anchor.Attributes.Add("href", "Project.aspx?Type=" + Convert.ToString(obj.rdr["ProjectType"].ToString()) + "&Title=" + Convert.ToString(obj.rdr["ProjectName"].ToString())); } anchor.InnerHtml = "<p>" + Convert.ToString(obj.rdr["ProjectName"].ToString()) + "</p><img src=\"../Images/ProjectTypeThumbs/" + Convert.ToString(obj.rdr["ProjectThumbImage"].ToString()) + "\">"; li.Controls.Add(anchor); } } } catch (Exception ex) { log.LogErrorMessage("Load Project Types : " + ex); } finally { obj.Close(); } }
/// <summary> /// Initial load of the screen - loads the differnet component types. /// </summary> private void LoadLayout(int? ideas) { Database obj = new Database(); try { if (ideas == null) { obj.Connect(); obj.Query("SELECT Renders.Image,Layouts.LayoutThumbImage FROM Renders " + "INNER JOIN Layouts ON (Layouts.LayoutID = Renders.Layout) " + "WHERE Layout = " + Request.QueryString["LayoutID"].ToString() + ";"); } else { obj.Connect(); obj.Query("SELECT Renders.Image,Ideas.IdeaThumbImage FROM Renders " + "INNER JOIN Ideas ON (Ideas.IdeaID = Renders.Layout) " + "WHERE Layout = " + Request.QueryString["LayoutID"].ToString() + ";"); } if (obj.rdr.HasRows == true) { int i = 1; while (obj.rdr.Read()) { //Gallery HtmlGenericControl li = new HtmlGenericControl("li"); HtmlGenericControl liLarge = new HtmlGenericControl("li"); li.Attributes.Add("class", "item"); li.Attributes.Add("id", "gallery_small" + i); //used to give unique id for jquery. i++; liLarge.Attributes.Add("class", "item--big"); gallery.Controls.Add(li); gallery_large.Controls.Add(liLarge); HtmlGenericControl anchor = new HtmlGenericControl("a"); HtmlGenericControl anchorLarge = new HtmlGenericControl("a"); anchor.InnerHtml = "<img src=\"../Images/LayoutRenders/" + Convert.ToString(obj.rdr["Image"].ToString()) + "\">"; anchorLarge.InnerHtml = anchor.InnerHtml; li.Controls.Add(anchor); liLarge.Controls.Add(anchorLarge); } } } catch (Exception ex) { log.LogErrorMessage("Load Layout : " + ex); } finally { obj.Close(); } }
/// <summary> /// Initial load of the screen - loads the differnet component types. /// </summary> private void LoadProjectLayouts(int? layoutID, int? ideas) { bool hasDescription = false; Database obj = new Database(); try { obj.Connect(); if (layoutID != null && ideas == null) { obj.Query("SELECT * FROM Layouts " + "INNER JOIN Projects ON (Projects.ProjectType = Layouts.ProjectType) Where LayoutID = " + layoutID + " ORDER BY Layouts.LayoutID;"); } else if (layoutID != null && ideas != null) { obj.Query("SELECT * FROM Ideas " + "INNER JOIN Projects ON (Projects.ProjectType = Ideas.ProjectType) Where IdeaID = " + layoutID + " ORDER BY Ideas.IdeaID;"); } else { obj.Query("SELECT * FROM Layouts" + // Projects.Description FROM Layouts " + " INNER JOIN Projects ON (Projects.ProjectType = Layouts.ProjectType) " + " Where Layouts.ProjectType = " + Request.QueryString["Type"].ToString() + " ORDER BY LayoutID;"); hasDescription = true; } if (obj.rdr.HasRows == true) { while (obj.rdr.Read()) { if (hasDescription) { lblDescription.Text = Convert.ToString(obj.rdr["Description"].ToString()); } if (layoutID != null && ideas == null) { HtmlGenericControl li = new HtmlGenericControl("li"); layout.Controls.Add(li); HtmlGenericControl div = new HtmlGenericControl("div"); div.InnerHtml = "<p>" + Convert.ToString(obj.rdr["ProjectName"].ToString()) + " - " + Convert.ToString(obj.rdr["LayoutID"].ToString()) + "</p><img src=\"../Images/LayoutThumbs/" + Convert.ToString(obj.rdr["LayoutThumbImage"].ToString()) + "\">"; li.Controls.Add(div); this.Page.Title = Convert.ToString(obj.rdr["ProjectName"].ToString()) + " - " + Convert.ToString(obj.rdr["LayoutID"].ToString()); } else if (layoutID != null && ideas != null) { HtmlGenericControl li = new HtmlGenericControl("li"); layout.Controls.Add(li); HtmlGenericControl div = new HtmlGenericControl("div"); div.InnerHtml = "<p>" + Convert.ToString(obj.rdr["ProjectName"].ToString()) + " - " + Convert.ToString(obj.rdr["IdeaID"].ToString()) + "</p><img src=\"../Images/LayoutThumbs/" + Convert.ToString(obj.rdr["IdeaThumbImage"].ToString()) + "\">"; li.Controls.Add(div); this.Page.Title = Convert.ToString(obj.rdr["ProjectName"].ToString()) + " - " + Convert.ToString(obj.rdr["IdeaID"].ToString()); } else { layoutsDiv.Visible = true; HtmlGenericControl li = new HtmlGenericControl("li"); tiles_small.Controls.Add(li); HtmlGenericControl anchor = new HtmlGenericControl("a"); anchor.Attributes.Add("href", "Project.aspx?LayoutID=" + Convert.ToString(obj.rdr["LayoutID"].ToString())); anchor.InnerHtml = "<p>" + Convert.ToString(obj.rdr["LayoutID"].ToString()) + "</p><img src=\"../Images/LayoutThumbs/" + Convert.ToString(obj.rdr["LayoutThumbImage"].ToString()) + "\">"; li.Controls.Add(anchor); } } } else { //No Layouts - Hide div layoutsDiv.Visible = false; layoutsDivContent.Visible = false; } //Check to see if there are Ideas to Load if (layoutID == null) { LoadProjectIdeas(obj); } } catch (Exception ex) { log.LogErrorMessage("Load Project Layouts : " + ex); } finally { obj.Close(); } }
/// <summary> /// Initial load of the screen - loads the differnet component types. /// </summary> private void LoadComponents(int? ideas) { double price = 0; int i = 1; Database obj = new Database(); try { obj.Connect(); obj.Query("SELECT ComponentTypes.CompTypeName, ComponentTypes.CompTypeID, ComponentTypes.CompTypeThumbImage FROM Comp_Layout" + " INNER JOIN ComponentTypes ON (ComponentTypes.CompTypeID = Comp_Layout.ComponentType) " + " Where LayoutID = " + Request.QueryString["LayoutID"].ToString() + " ORDER BY SeqInDrawing;"); if (obj.rdr.HasRows == true) { while (obj.rdr.Read()) { //Add Place Holders for additional (up to 5) //This was a late requirement to add components for (int counter = 1 + (5 * (i - 1)); counter <= 5 * i; counter++) { string detailsDiv = ""; HtmlGenericControl li = new HtmlGenericControl("li"); comp_small.Controls.Add(li); li.Attributes.Add("id", "liAddComponent" + counter); //Hide li Place Holders if (counter != 1 + (5 * (i - 1)) && Session["Comp" + counter] == null) { li.Style.Add("display", "none"); } string link = ""; if (ideas != null) { link = "Component.aspx?Type=" + Convert.ToString(obj.rdr["CompTypeID"]) + "&Comp=Comp" + counter + "&LayoutID=" + Request.QueryString["LayoutID"].ToString() + "&Title=" + Convert.ToString(obj.rdr["CompTypeName"]) + "&Ideas=1"; } else { link = "Component.aspx?Type=" + Convert.ToString(obj.rdr["CompTypeID"]) + "&Comp=Comp" + counter + "&LayoutID=" + Request.QueryString["LayoutID"].ToString() + "&Title=" + Convert.ToString(obj.rdr["CompTypeName"]); } if (Session["Comp" + counter] != null) { detailsDiv = "<div class=\"customized-values configured\" id=\"Comp" + counter + "\"><a href=\"" + link + "\"\\><b>Component Type:</b> " + Convert.ToString(obj.rdr["CompTypeID"].ToString()); orderValues.InnerHtml = orderValues.InnerHtml + "<div class=\"customized-values\" style=\"font-size:16px!important;\" id=\"Comp" + counter + "\"><b>Component Type:</b> " + Convert.ToString(obj.rdr["CompTypeID"].ToString()); price = price + Convert.ToDouble(Session["Comp" + counter + "Price"].ToString()); orderValues.InnerHtml = orderValues.InnerHtml + Session["Comp" + counter].ToString() + "</div>"; detailsDiv = detailsDiv + Session["Comp" + counter].ToString() + "</div>"; } else { //Logic to hide additional place holders if (counter != 1 + (5 * (i - 1))) { //detailsDiv = "<div class=\"customized-values\" style=\"display:none;\" id=\"Comp" // + counter + "\"><a href=\"" + link + "\"\\>";//<b>Component Type:</b> " // // + Convert.ToString(obj.rdr["CompTypeID"].ToString()); //orderValues.InnerHtml = orderValues.InnerHtml + "<div class=\"customized-values\" style=\"display:none;\" id=\"Comp" // + counter + "\"><b>Component Type:</b> " // + Convert.ToString(obj.rdr["CompTypeID"].ToString()); } else { //detailsDiv = "<div class=\"customized-values\" id=\"Comp" // + counter + "\"><a href=\"" + link + "\"\\><b>Component Type:</b> " // + Convert.ToString(obj.rdr["CompTypeID"].ToString()); //orderValues.InnerHtml = orderValues.InnerHtml + "<div class=\"customized-values\" style=\"font-size:16px!important;\" id=\"Comp" // + counter + "\"><b>Component Type:</b> " // + Convert.ToString(obj.rdr["CompTypeID"].ToString()); } //detailsDiv = detailsDiv + " <b>ID :</b> n/a <b>W:</b> n/a <b>D:</b> n/a <b>H:</b> n/a <b>Doors:</b> n/a <b>Material:</b> n/a <b>Price:</b> n/a</div>"; //orderValues.InnerHtml = orderValues.InnerHtml + " <b>Component ID :</b> n/a <b>W:</b> n/a <b>D:</b> n/a <b>H:</b> n/a <b>Doors:</b> n/a <b>Material:</b> n/a <b>Price:</b> n/a</div>"; //values.InnerHtml.Style.Add("display", "none"); } HtmlGenericControl add = new HtmlGenericControl("div"); HtmlGenericControl remove = new HtmlGenericControl("Button"); HtmlGenericControl addDetailsDiv = new HtmlGenericControl("div"); HtmlGenericControl anchor = new HtmlGenericControl("a"); anchor.Attributes.Add("href", link); if (Session["Comp" + counter] != null) { anchor.InnerHtml = "<p>" + Convert.ToString(obj.rdr["CompTypeName"].ToString()) + "</p><img src=\"" + Session["Comp" + counter + "CompImagePath"].ToString() + "\">"; Session["ComponentImagePath"] = ""; } else { anchor.InnerHtml = "<p>" + Convert.ToString(obj.rdr["CompTypeName"].ToString()) + "</p><img src=\"../Images/CompTypeThumbs/" + Convert.ToString(obj.rdr["CompTypeThumbImage"].ToString()) + "\"></a>"; } //+ Convert.ToString(obj.rdr["CompTypeThumbImage"].ToString()) + "\"></a>"; // add.InnerHtml = "<div style=\"background-color: orange;width: 100%;\"id=AddComponent" + counter + ">+</div>"; if (counter != 1 + (5 * (i - 1))) { add.InnerHtml = "<Button style=\"padding:2 2 2 2px !important; background-color: orange;width: 40%;\"id=AddComponent" + counter + " onclick=\"return false;\">+</Button>" + "<Button style=\"padding:2 2 2 2px !important; background-color: red;width: 40%;\"id=RemoveComponent" + counter + " onclick=\"return false;\">-</Button>"; } else { add.InnerHtml = "<Button style=\"padding:2 2 2 2px !important; background-color: orange;width: 40%;\"id=AddComponent" + counter + " onclick=\"return false;\">+</Button>"; } remove.InnerHtml = "<Button style=\"padding:2 2 2 2px !important; background-color: red;width: 40%%;\"id=RemoveComponent" + counter + " onclick=\"return false;\">-</Button>"; addDetailsDiv.InnerHtml = detailsDiv; li.Controls.Add(add); // li.Controls.Add(remove); li.Controls.Add(anchor); if (counter % 5 != 0) //Causing extra anchor tags - don't know why. { li.Controls.Add(addDetailsDiv); } } i++; } lblTotalPrice.Text = "$" + price.ToString(); lblOrderPrice.Text = "$" + price.ToString(); } } catch (Exception ex) { log.LogErrorMessage("Load Component : " + ex); } finally { obj.Close(); } }
/// <summary> /// Populates the drop down size selector based on database values /// </summary> private void PopulateDropDowns() { int widthMin = 0; int widthMax = 0; int depthMin = 0; int depthMax = 0; int heightMin = 0; int heightMax = 0; int index = 0; //Clear Values compWidth.Items.Clear(); compDepth.Items.Clear(); compHeight.Items.Clear(); compMaterial.Items.Clear(); compDoors.Items.Clear(); Database db = new Database(); try { db.Connect(); db.Query("SELECT * FROM Components Where CompID = " + Request.QueryString["CompId"].ToString() + ";"); if (db.rdr.HasRows == true) { while (db.rdr.Read()) { widthMin = (Convert.ToString(db.rdr["Wmin"])) != null ? Convert.ToInt32(Convert.ToString(db.rdr["Wmin"])) : 0; widthMax = (Convert.ToString(db.rdr["Wmax"])) != null ? Convert.ToInt32(Convert.ToString(db.rdr["Wmax"])) : 0; heightMin = (Convert.ToString(db.rdr["Hmin"])) != null ? Convert.ToInt32(Convert.ToString(db.rdr["Hmin"])) : 0; heightMax = (Convert.ToString(db.rdr["Hmax"])) != null ? Convert.ToInt32(Convert.ToString(db.rdr["Hmax"])) : 0; depthMin = !string.IsNullOrEmpty((Convert.ToString(db.rdr["Dmin"]))) ? Convert.ToInt32(Convert.ToString(db.rdr["Dmin"])) : 0; depthMax = !string.IsNullOrEmpty((Convert.ToString(db.rdr["Dmax"]))) ? Convert.ToInt32(Convert.ToString(db.rdr["Dmax"])) : 0; numDoors.Text = (Convert.ToString(db.rdr["Ndoors"])); formula.Text = (Convert.ToString(db.rdr["Formula"])); numShelves.Text = (Convert.ToString(db.rdr["Nshelves"])); numDrawers.Text = (Convert.ToString(db.rdr["Ndrawers"])); numHandles.Text = (Convert.ToString(db.rdr["Nhandles"])); faceDoorCoverage.Text = (Convert.ToString(db.rdr["FaceDoorCoverage"])); } for (int i = widthMin; i <= widthMax; i++) { compWidth.Items.Insert(index, new ListItem(Convert.ToString(i) + " \"", Convert.ToString(i) + " \"")); index++; } index = 0; for (int i = depthMin; i <= depthMax; i++) { compDepth.Items.Insert(index, new ListItem(Convert.ToString(i) + " \"", Convert.ToString(i) + " \"")); index++; } index = 0; for (int i = heightMin; i <= heightMax; i++) { compHeight.Items.Insert(index, new ListItem(Convert.ToString(i) + " \"", Convert.ToString(i) + " \"")); index++; } //Doors if (numDoors.Text == "0" || numDoors.Text =="") { divDoors.Visible = false; } else { divDoors.Visible = true; compDoors.Items.Insert(0, new ListItem("Left", "Left")); compDoors.Items.Insert(1, new ListItem("Right", "Right")); } //Material compMaterial.Items.Insert(0, new ListItem("Veneer Maple", "Veneer Maple")); compMaterial.Items.Insert(1, new ListItem("Veneer Oak", "Veneer Oak")); compMaterial.Items.Insert(2, new ListItem("Veneer Cherry", "Veneer Cherry")); compMaterial.Items.Insert(3, new ListItem("Painted", "Painted")); } } catch (Exception ex) { // log.LogErrorMessage("Populate Drop Downs : " + ex); } finally { db.Close(); } }
/// <summary> /// Initial load of the screen - loads the differnet component types. /// </summary> private void LoadRender() { Database obj = new Database(); try { LoadComponents(Convert.ToInt32(Request.QueryString["CompId"].ToString()), null); obj.Connect(); obj.Query("SELECT * FROM Renders Where Component = " + Request.QueryString["CompId"].ToString() + ";"); if (obj.rdr.HasRows == true) { int i = 1; while (obj.rdr.Read()) { //Gallery HtmlGenericControl li = new HtmlGenericControl("li"); HtmlGenericControl liLarge = new HtmlGenericControl("li"); li.Attributes.Add("class", "item"); li.Attributes.Add("id", "gallery_small" + i); //used to give unique id for jquery. i++; liLarge.Attributes.Add("class", "item--big"); gallery.Controls.Add(li); gallery_large.Controls.Add(liLarge); HtmlGenericControl anchor = new HtmlGenericControl("a"); HtmlGenericControl anchorLarge = new HtmlGenericControl("a"); anchor.InnerHtml = "<img src=\"../Images/CompRenders/" + Convert.ToString(obj.rdr["Image"].ToString()) + "\">"; anchorLarge.InnerHtml = anchor.InnerHtml; li.Controls.Add(anchor); liLarge.Controls.Add(anchorLarge); } } } catch (Exception ex) { //log.LogErrorMessage("Load Render : " + ex); } finally { obj.Close(); } }
/// <summary> /// Initial load of the screen - loads the differnet component types. /// </summary> private void LoadComponentTypes() { Database obj = new Database(); try { obj.Connect(); obj.Query("SELECT * FROM ComponentTypes ORDER BY Seq"); if (obj.rdr.HasRows == true) { while (obj.rdr.Read()) { HtmlGenericControl li = new HtmlGenericControl("li"); tiles.Controls.Add(li); HtmlGenericControl anchor = new HtmlGenericControl("a"); anchor.Attributes.Add("href", "Component.aspx?Type=" + Convert.ToString(obj.rdr["CompTypeID"].ToString()) + "&Title=" + Convert.ToString(obj.rdr["CompTypeName"].ToString())); anchor.InnerHtml = "<p>" + Convert.ToString(obj.rdr["CompTypeName"]) + "</p><img src=\"../Images/CompTypeThumbs/" + Convert.ToString(obj.rdr["CompTypeThumbImage"].ToString()) + "\">"; li.Controls.Add(anchor); } } } catch (Exception ex) { //log.LogErrorMessage("Load Component Types : " + ex); } finally { obj.Close(); } }
/// <summary> /// Initial load of the screen - loads the differnet component types. /// </summary> private void LoadComponents(int? compID, int? ideas) { String queryString = ""; Database obj = new Database(); int currentStyle = 0; string prevStyle = ""; try { obj.Connect(); if (compID != null) { obj.Query("SELECT Components.Description, Components.CompID,Components.CompThumbImage,ComponentTypes.CompTypeName, ComponentTypes.CompTypeName, Components.CompID FROM Components " + "INNER JOIN ComponentTypes ON (componentTypes.CompTypeID = Components.CompType)" + "WHERE CompId =" + Request.QueryString["CompId"].ToString() + " ORDER BY Components.CompStyle,Components.CompID;"); } else { obj.Query("SELECT ComponentTypes.Description, Components.CompThumbImage,Components.CompID, Components.CompStyle " + "FROM Components INNER JOIN ComponentTypes ON (ComponentTypes.CompTypeID = Components.CompType) " + "Where CompType = " + Request.QueryString["Type"].ToString() + " ORDER BY Components.CompStyle,Components.CompID;"); } if (obj.rdr.HasRows == true) { while (obj.rdr.Read()) { lblDescription.Text = Convert.ToString(obj.rdr["Description"].ToString()); HtmlGenericControl li = new HtmlGenericControl("li"); if (compID != null) { comp.Controls.Add(li); this.Page.Title = Convert.ToString(obj.rdr["CompTypeName"]) + " - " + Convert.ToString(obj.rdr["CompID"]); HtmlGenericControl div = new HtmlGenericControl("div"); componentImagePath = "../Images/CompThumbs/" + Convert.ToString(obj.rdr["CompThumbImage"].ToString()); div.InnerHtml = "<p>" + Convert.ToString(obj.rdr["CompTypeName"]) + " - " + Convert.ToString(obj.rdr["CompID"]) + "</p><img src=\""+componentImagePath + "\">"; li.Controls.Add(div); } else { queryString = "Component.aspx?CompId=" + Convert.ToString(obj.rdr["CompID"]); if (Request.QueryString["Comp"] != null) { queryString = queryString + "&Comp=" + Request.QueryString["Comp"].ToString() + "&LayoutID=" + Request.QueryString["LayoutID"].ToString(); } if (ideas != null) { queryString = queryString + "&Ideas=1"; } //Find the Style and sort it into the right div. Currently allow for 5. string style = Convert.ToString(obj.rdr["CompStyle"]); if ((currentStyle == 0 && String.IsNullOrEmpty(prevStyle)) || (currentStyle == 1 && prevStyle == style)) { styleHeader.Text = "Style " + style; tiles_small.Controls.Add(li); prevStyle = style; currentStyle = 1; } else if ((currentStyle == 1 && prevStyle != style) || (currentStyle == 2 && prevStyle == style)) { styleHeader2.Text = "Style " + style; tiles_small2.Controls.Add(li); prevStyle = style; currentStyle = 2; } else if ((currentStyle == 2 && prevStyle != style) || (currentStyle == 3 && prevStyle == style)) { styleHeader3.Text = "Style " + style; tiles_small3.Controls.Add(li); prevStyle = style; currentStyle = 3; } else if ((currentStyle == 3 && prevStyle != style) || (currentStyle == 4 && prevStyle == style)) { styleHeader4.Text = "Style " + style; tiles_small4.Controls.Add(li); prevStyle = style; currentStyle = 4; } else if ((currentStyle == 4 && prevStyle != style) || (currentStyle == 5 && prevStyle == style)) { styleHeader5.Text = "Style " + style; tiles_small5.Controls.Add(li); prevStyle = style; currentStyle = 5; } HtmlGenericControl anchor = new HtmlGenericControl("a"); anchor.Attributes.Add("href", queryString); anchor.InnerHtml = "<p>" + Convert.ToString(obj.rdr["CompID"].ToString()) + "</p><img src=\"../Images/CompThumbs/" + Convert.ToString(obj.rdr["CompThumbImage"]) + "\">"; li.Controls.Add(anchor); } } } } catch (Exception ex) { //log.LogErrorMessage("Load Components : " + ex); } finally { obj.Close(); } }