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