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;
}
}
}
