static public StoneView getStoneDetails(string name)
{
DBServices dbs = new DBServices();
dbs = dbs.ReadFromDbView("DBConnectionString", "View_DDL", name);
StoneView sv = new StoneView();
//foreach (DataRow dr in dbs.dt.Rows)
//{
DataRow dr = dbs.dt.Rows[0];
sv.Name = (string)dr["Stone_Name"];
sv.Weight = (double)dr["Stone_Weight"];
sv.Shape = (string)dr["Shape_Name"];
sv.Color = (string)dr["Color_Name"];
sv.Clarity = (string)dr["Clarity_Name"];
sv.Cut = (string)dr["Cut_Name"];
sv.Polish = (string)dr["Polish_Name"];
sv.Symmetry = (string)dr["Symmetry_Name"];
sv.Cost_P_Discount = (double)dr["Stone_Cost_P_Discount"];
sv.T_Cost_Price = (double)dr["Stone_T_Cost_Price"];
sv.Sale_P_Discount = (double)dr["Stone_Sale_P_Discount"];
sv.T_Sale_Price = (double)dr["Stone_T_Sale_Price"];
sv.ImagePath = (string)dr["Stone_Image"];
sv.Status = (string)dr["Status_Name"];
//}
return(sv);
}
public string getStoneDetails(string id)
{
StoneView sv = StoneView.getStoneDetails(id);
JavaScriptSerializer js = new JavaScriptSerializer();
// serialize to string
string jsonStringStoneView = js.Serialize(sv);
return(jsonStringStoneView);
}
protected void addproducts_ByName(string name)
{
StoneView sv = s.getStone_Byname(name);
#region create HtmlGenericControl
HtmlGenericControl New_stone_div1 = new HtmlGenericControl("div");
HtmlGenericControl New_stone_div2 = new HtmlGenericControl("div");
HtmlGenericControl New_stone_div3 = new HtmlGenericControl("div");
HtmlImage img_for_stone = new HtmlImage();
HtmlGenericControl New_stone_div4 = new HtmlGenericControl("div");
HtmlGenericControl New_stone_div5_AddToCart = new HtmlGenericControl("div");
HtmlButton BTN_AddToCart = new HtmlButton();
HtmlGenericControl New_stone_div6_Price = new HtmlGenericControl("div");
HtmlGenericControl New_stone_span_Price = new HtmlGenericControl("span");
HtmlGenericControl a_stone = new HtmlGenericControl("a");
#endregion
#region class for HtmlGenericControl
New_stone_div1.Attributes["Class"] = "col-sm-12 col-md-6 col-lg-4 p-b-50";
New_stone_div2.Attributes["Class"] = "block2";
New_stone_div3.Attributes["Class"] = "block2-img wrap-pic-w of-hidden pos-relative";
New_stone_div4.Attributes["Class"] = "block2-overlay trans-0-4";
New_stone_div5_AddToCart.Attributes["Class"] = "block2-btn-addcart w-size1 trans-0-4";
BTN_AddToCart.Attributes["Class"] = "flex-c-m size1 bg4 bo-rad-23 hov1 s-text1 trans-0-4";
a_stone.Attributes["Class"] = "block2-name dis-block s-text3 p-b-5";
New_stone_div6_Price.Attributes["Class"] = "block2-txt p-t-20";
New_stone_span_Price.Attributes["Class"] = "block2-price m-text6 p-r-5";
#endregion
img_for_stone.Src = "../../" + sv.ImagePath;
img_for_stone.Alt = "IMG-PRODUCT";
New_stone_span_Price.InnerHtml = "Stone Weight: " + sv.Weight.ToString();
a_stone.InnerHtml = "Stone Name: " + sv.Name.ToString();
BTN_AddToCart.InnerHtml = "Add to Cart";
New_stone_div5_AddToCart.Controls.Add(BTN_AddToCart);
New_stone_div4.Controls.Add(New_stone_div5_AddToCart);
New_stone_div3.Controls.Add(img_for_stone);
New_stone_div3.Controls.Add(New_stone_div4);
New_stone_div6_Price.Controls.Add(a_stone);
New_stone_div6_Price.Controls.Add(New_stone_span_Price);
New_stone_div2.Controls.Add(New_stone_div3);
New_stone_div2.Controls.Add(New_stone_div6_Price);
New_stone_div1.Controls.Add(New_stone_div2);
stones_div_table.Controls.Add(New_stone_div1);
}
public string getAllStonesViews()
{
List <StoneView> lsv = StoneView.getAllStonesViews();
JavaScriptSerializer js = new JavaScriptSerializer();
// serialize to string
string jsonStringStone = js.Serialize(lsv);
//string jsonString = "{\"hi\":\"hello\"}";
//return jsonString;
return(jsonStringStone);
}
public List <StoneView> readfromyDS_f(string conString)
{
DBServices dbs = new DBServices();
dbs = dbs.ReadFromDataBase_Filter("DBConnectionString", conString);
List <StoneView> stones = new List <StoneView>();
foreach (DataRow dr in dbs.dt.Rows)
{
StoneView sv = new StoneView();
sv.Name = (string)dr["Stone_Name"];
sv.Weight = (double)dr["Stone_Weight"];
sv.Shape = (string)dr["Shape_Name"];
sv.Color = (string)dr["Color_Name"];
sv.Clarity = (string)dr["Clarity_Name"];
sv.M1 = (double)dr["Stone_M1"];
sv.M2 = (double)dr["Stone_M1"];
sv.M3 = (double)dr["Stone_M2"];
sv.Depth = (double)dr["Stone_Depth"];
sv.Table = (double)dr["Stone_Table"];
sv.Girdle = (string)dr["Girdle_Name"];
sv.Culet = (string)dr["Culet_Name"];
sv.Cut = (string)dr["Cut_Name"];
sv.Polish = (string)dr["Polish_Name"];
sv.Symmetry = (string)dr["Symmetry_Name"];
sv.Fluorescence = (string)dr["Fluorescence_Name"];
sv.Lab = (string)dr["Lab_Name"];
sv.Certificate = (long)dr["Stone_Certificate"];
sv.Cost_P_Discount = (double)dr["Stone_Cost_P_Discount"];
sv.Cost_Price_CT = (double)dr["Stone_Cost_Price_$_ct"];
sv.T_Cost_Price = (double)dr["Stone_T_Cost_Price"];
sv.Sale_P_Discount = (double)dr["Stone_Sale_P_Discount"];
sv.Sale_Price_CT = (double)dr["Stone_Sale_Price_$_ct"];
sv.T_Sale_Price = (double)dr["Stone_T_Sale_Price"];
sv.ImagePath = (string)dr["Stone_Image"];
sv.Status = (string)dr["Status_Name"];
stones.Add(sv);
}
return(stones);
}
public StoneView getStone_Byname(string name)
{
DBServices dbs = new DBServices();
dbs = dbs.ReadFromDbView("DBConnectionString", "View_DDL", name);
StoneView sv = new StoneView();
//foreach (DataRow dr in dbs.dt.Rows)
//{
DataRow dr = dbs.dt.Rows[0];
sv.Name = (string)dr["Stone_Name"];
sv.Weight = (double)dr["Stone_Weight"];
sv.Shape = (string)dr["Shape_Name"];
sv.Color = (string)dr["Color_Name"];
sv.Clarity = (string)dr["Clarity_Name"];
sv.m1 = (double)dr["Stone_M1"];
sv.M2 = (double)dr["Stone_M1"];
sv.M3 = (double)dr["Stone_M2"];
sv.Depth = (double)dr["Stone_Depth"];
sv.Table = (double)dr["Stone_Table"];
sv.Girdle = (string)dr["Girdle_Name"];
sv.Culet = (string)dr["Culet_Name"];
sv.Cut = (string)dr["Cut_Name"];
sv.Polish = (string)dr["Polish_Name"];
sv.Symmetry = (string)dr["Symmetry_Name"];
sv.Fluorescence = (string)dr["Fluorescence_Name"];
sv.Lab = (string)dr["Lab_Name"];
sv.Certificate = (long)dr["Stone_Certificate"];
sv.Cost_P_Discount = (double)dr["Stone_Cost_P_Discount"];
sv.Cost_Price_CT = (double)dr["Stone_Cost_Price_$_ct"];
sv.T_Cost_Price = (double)dr["Stone_T_Cost_Price"];
sv.Sale_P_Discount = (double)dr["Stone_Sale_P_Discount"];
sv.Sale_Price_CT = (double)dr["Stone_Sale_Price_$_ct"];
sv.T_Sale_Price = (double)dr["Stone_T_Sale_Price"];
sv.ImagePath = (string)dr["Stone_Image"];
sv.Status = (string)dr["Status_Name"];
//}
return(sv);
}
public Stone(StoneView view, Vector2 position)
{
View = view;
Position = position;
}
