public void getbeveragerepeater() { string nameEn = ""; string nameCH = ""; int Category = int.Parse(Request.QueryString["Category"]); DataTable dt = new DataTable(); dt.Columns.Add("IDProduct"); dt.Columns.Add("Name"); dt.Columns.Add("ImageURL"); dt.Columns.Add("Detail"); dt.Columns.Add("Price"); dt.Columns.Add("PromotionPrice"); dt.Columns.Add("NameEn"); CommonClassLibrary.CommonDataSet.ProductCateDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.ProductCateTableAdapter().GetDataByCategory(Category); foreach (CommonClassLibrary.CommonDataSet.ProductCateRow item in collection) { string name = ""; string imageUrl = "Image/no_image_available.jpg"; string detail = ""; string price = ""; string promotion = ""; CommonClassLibrary.CommonDataSet.ProductDetailDataTable collection2 = new CommonClassLibrary.CommonDataSetTableAdapters.ProductDetailTableAdapter().GetDataByProduct(item.Product); foreach (CommonClassLibrary.CommonDataSet.ProductDetailRow item2 in collection2) { if (item2.KeyName == "Name") { name = item2.KeyValue; CommonClassLibrary.CommonDataSet.TextContentDataTable collection3 = new CommonClassLibrary.CommonDataSetTableAdapters.TextContentTableAdapter().GetDataById(long.Parse(item2.KeyValue)); foreach (CommonClassLibrary.CommonDataSet.TextContentRow item3 in collection3) { name = item3.Thai; nameEn = item3.English; } } else if (item2.KeyName == "Picture") { if (item2.KeyValue == "") { imageUrl = "no_image_available.jpg"; } else { imageUrl = item2.KeyValue; } } else if (item2.KeyName == "Detail") { detail = item2.KeyValue; } else if (item2.KeyName == "Price") { price = double.Parse(item2.KeyValue).ToString("#.###") + ".-"; } else if (item2.KeyName == "PromotionPrice") { if (item2.KeyValue == "-") { promotion = (item2.KeyValue); } else { promotion = double.Parse(item2.KeyValue).ToString("#.###") + ".-"; } } } dt.Rows.Add(item.Product, name, imageUrl, detail, price, promotion, nameEn); } this.BeverageRepeater.DataSource = dt; this.BeverageRepeater.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { System.Web.UI.HtmlControls.HtmlGenericControl Services = (System.Web.UI.HtmlControls.HtmlGenericControl)Master.FindControl("Li1"); Services.Attributes.Add("class", "active"); int IDProduct = int.Parse(Request.QueryString["IDProduct"]); getcategorycheckbox(); CommonClassLibrary.CommonDataSet.ProductDetailDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.ProductDetailTableAdapter().GetDataByProductShowName(IDProduct); foreach (CommonClassLibrary.CommonDataSet.ProductDetailRow item in collection) { Label4.Text = item.KeyValue; CommonClassLibrary.CommonDataSet.TextContentDataTable collection111 = new CommonClassLibrary.CommonDataSetTableAdapters.TextContentTableAdapter().GetDataById(long.Parse(item.KeyValue)); foreach (CommonClassLibrary.CommonDataSet.TextContentRow item111 in collection111) { this.Name_TextBox.Text = item111.Thai; this.NameEN_TextBox.Text = item111.English; } } CommonClassLibrary.CommonDataSet.ProductDetailDataTable collection2 = new CommonClassLibrary.CommonDataSetTableAdapters.ProductDetailTableAdapter().GetDataByProductShowDetail(IDProduct); foreach (CommonClassLibrary.CommonDataSet.ProductDetailRow item2 in collection2) { Label5.Text = item2.KeyValue; CommonClassLibrary.CommonDataSet.TextContentDataTable collection222 = new CommonClassLibrary.CommonDataSetTableAdapters.TextContentTableAdapter().GetDataById(long.Parse(item2.KeyValue)); foreach (CommonClassLibrary.CommonDataSet.TextContentRow item222 in collection222) { this.Detail_TextBox.Text = item222.Thai; this.DetailEN_TextBox.Text = item222.English; } } CommonClassLibrary.CommonDataSet.ProductDetailDataTable collection3 = new CommonClassLibrary.CommonDataSetTableAdapters.ProductDetailTableAdapter().GetDataByProductShowPrice(IDProduct); foreach (CommonClassLibrary.CommonDataSet.ProductDetailRow item3 in collection3) { this.Price_TextBox.Text = item3.KeyValue; } CommonClassLibrary.CommonDataSet.ProductDetailDataTable collection4 = new CommonClassLibrary.CommonDataSetTableAdapters.ProductDetailTableAdapter().GetDataByProductShowPromotionPrice(IDProduct); foreach (CommonClassLibrary.CommonDataSet.ProductDetailRow item4 in collection4) { if (item4.KeyValue != "-") { this.PromotionPrice_TextBox.Text = item4.KeyValue; } } CommonClassLibrary.CommonDataSet.ProductCateDataTable collection6 = new CommonClassLibrary.CommonDataSetTableAdapters.ProductCateTableAdapter().GetDataByProduct(IDProduct); foreach (CommonClassLibrary.CommonDataSet.ProductCateRow item6 in collection6) { radiobutton.SelectedValue = Request.QueryString["Category"]; //setselect } getImage(); getMenu(); } }