private void LoadData(bool isslidercall = false) { //get the values from sliders string strshape = string.Empty; var min_price = minprice.Value; var max_price = maxprice.Value; var min_carat = mincarat.Value; var max_carat = maxcarat.Value; var colorfilter = color[Convert.ToInt32(mincolor.Value)]; for (int i = Convert.ToInt32(mincolor.Value); i <= Convert.ToInt32(maxcolor.Value); ++i) { colorfilter += "," + color[i]; } var cutfilter = cut[Convert.ToInt32(mincut.Value)]; for (int i = Convert.ToInt32(mincut.Value); i <= Convert.ToInt32(maxcut.Value); ++i) { cutfilter += "," + cut[i]; } var clarityfilter = clarity[Convert.ToInt32(minclarity.Value)]; for (int i = Convert.ToInt32(minclarity.Value); i <= Convert.ToInt32(maxclarity.Value); ++i) { clarityfilter += "," + clarity[i]; } //We just need HtmlInputCheckBox IEnumerable <Control> _ctrls = from Control n in this.searchform.Controls where n as System.Web.UI.WebControls.CheckBox != null select n; if (_ctrls.Count() > 0) { foreach (System.Web.UI.WebControls.CheckBox item in _ctrls) { if (item.Checked) { strshape += item.ID + ","; } } } var calldb = GemDBAccess.GetPrices(min_price, max_price, colorfilter, cutfilter, clarityfilter, min_carat, max_carat, strshape); count.InnerText = calldb.Rows.Count.ToString() + " diamonds"; if (isslidercall == false) { gvResults.DataSource = calldb; gvResults.DataBind(); } else { gvResults.DataSource = null; gvResults.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { var stoneid = Request.QueryString["StoneId"]; DataTable stoneinfo = GemDBAccess.GetStoneInfo(stoneid); foreach (DataRow row in stoneinfo.Rows) { //diamond details lblstone.Text = row["StoneID"].ToString(); lbllab.Text = row["Lab"].ToString(); lblinscription.Text = row["Certificate"].ToString(); lblshape.Text = row["Shape"].ToString(); lblcolor.Text = row["Color"].ToString(); lblclarity.Text = row["Clarity"].ToString(); lblcut.Text = row["Cut"].ToString(); lblfeature.Text = row["Key To Symbols"].ToString(); //specs lbldepth.Text = row["Total Depth"].ToString(); lbllw.Text = row["Ratio"].ToString(); lbldepthper.Text = row["Depth"].ToString(); lbltable.Text = row["Table"].ToString(); lblculet.Text = row["Culet"].ToString(); lblgirdle.Text = row["Girdle Condition"].ToString(); lblcaratwgt.Text = row["Carats"].ToString(); lblpolish.Text = row["Polish"].ToString(); lblsymmetry.Text = row["Symm"].ToString(); lblflu.Text = row["Fluo Int"].ToString(); lblprcpercrt.Text = row["Price"].ToString(); lblamt.Text = row["Amount"].ToString(); //set heading heading.InnerText = row["Carats"].ToString() + " Carats " + row["Shape"].ToString() + " Shaped Diamond"; //set paragraph spcut.InnerText = row["Cut"].ToString(); spcarats.InnerText = row["Carats"].ToString(); spclarity.InnerText = row["Clarity"].ToString(); spcolor.InnerText = row["Color"].ToString(); spshape.InnerText = row["Shape"].ToString(); //set gia pdf link string certurl = row["CertificateURL"].ToString(); certurl = certurl.Replace("\\\\", "//"); certurl = certurl.Replace("\\", @"/"); certlink.Value = certurl; //select images var shape = row["Shape"].ToString(); switch (shape) { case "RBC": image1.Src = "Images/round_front.jpg"; image2.Src = "Images/round_top.jpg"; break; case "Cushion": image1.Src = "Images/cushion_front.jpg"; image2.Src = "Images/cushion_top.jpg"; break; case "Pear": image1.Src = "Images/pear_front.jpg"; image2.Src = "Images/pear_top.jpg"; break; case "Radiant": image1.Src = "Images/radiant_front.jpg"; image2.Src = "Images/radiant_top.jpg"; break; case "Emerald": image1.Src = "Images/emerald_front.jpg"; image2.Src = "Images/emerald_top.jpg"; break; case "Oval": image1.Src = "Images/oval_front.jpg"; image2.Src = "Images/oval_top.jpg"; break; case "Marquise": image1.Src = "Images/marquise_front.jpg"; image2.Src = "Images/marquise_top.jpg"; break; case "Princess": image1.Src = "Images/princess_front.jpg"; image2.Src = "Images/princess_top.jpg"; break; case "Heart": image1.Src = "Images/heart_front.jpg"; image2.Src = "Images/heart_top.jpg"; break; } } }