public void getMenu() { int Category = int.Parse(Request.QueryString["Category"]); if (Category > 0) { CommonClassLibrary.CommonDataSet.CategoryDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.CategoryTableAdapter().GetDataByID(Category); foreach (CommonClassLibrary.CommonDataSet.CategoryRow item in collection) { CommonClassLibrary.CommonDataSet.TextContentDataTable collection3 = new CommonClassLibrary.CommonDataSetTableAdapters.TextContentTableAdapter().GetDataById(long.Parse(item.Name)); foreach (CommonClassLibrary.CommonDataSet.TextContentRow item3 in collection3) { this.Menu2_Label.Text = item3.Thai; this.BackMenu_HyperLink.Text = item3.English; } //this.Menu_Label.Text = item.Name; //this.Menu2_Label.Text = item.Name; //this.BackMenu_HyperLink.Text = item.Name; } } else { this.Menu2_Label.Text = "รายการอาหารเเละเครื่องดื่มทั้งหมด"; this.BackMenu_HyperLink.Text = "รายการอาหารเเละเครื่องดื่มทั้งหมด"; } }
public void getcategorycheckbox() { string nameEn = ""; string nameCH = ""; string name = ""; string imageUrl = "Image/no_image_available.jpg"; DataTable dt = new DataTable(); dt.Columns.Add("Id"); dt.Columns.Add("Name"); dt.Columns.Add("ImageURL"); dt.Columns.Add("NameEN"); dt.Columns.Add("NameCN"); CommonClassLibrary.CommonDataSet.CategoryDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.CategoryTableAdapter().GetDataByStatus(1); foreach (CommonClassLibrary.CommonDataSet.CategoryRow item in collection) { CommonClassLibrary.CommonDataSet.TextContentDataTable collection3 = new CommonClassLibrary.CommonDataSetTableAdapters.TextContentTableAdapter().GetDataById(long.Parse(item.Name)); foreach (CommonClassLibrary.CommonDataSet.TextContentRow item3 in collection3) { name = item3.Thai; nameEn = item3.English; } imageUrl = item.ImageURL; dt.Rows.Add(item.Id, name, imageUrl, nameEn, nameCH); } this.radiobutton.DataSource = dt; this.radiobutton.DataTextField = "Name"; this.radiobutton.DataValueField = "Id"; this.radiobutton.DataBind(); }
public void Showdata() { string nameEn = ""; string nameCH = ""; string name = ""; string imageUrl = "Image/no_image_available.jpg"; //string detail = ""; //string price = ""; //string promotion = ""; DataTable dt = new DataTable(); dt.Columns.Add("IDProduct"); dt.Columns.Add("Name"); dt.Columns.Add("ImageURL"); dt.Columns.Add("NameEN"); CommonClassLibrary.CommonDataSet.CategoryDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.CategoryTableAdapter().GetDataByStatus(1); foreach (CommonClassLibrary.CommonDataSet.CategoryRow item in collection) { CommonClassLibrary.CommonDataSet.TextContentDataTable collection3 = new CommonClassLibrary.CommonDataSetTableAdapters.TextContentTableAdapter().GetDataById(long.Parse(item.Name)); foreach (CommonClassLibrary.CommonDataSet.TextContentRow item3 in collection3) { name = item3.Thai; nameEn = item3.English; } imageUrl = item.ImageURL; dt.Rows.Add(item.Id, name, imageUrl, nameEn); } this.CategoryTa.DataSource = dt; this.CategoryTa.DataBind(); }
public void getMenu() { int Category = int.Parse(Request.QueryString["Category"]); string IDProduct = Request.QueryString["IDProduct"]; this.BackMenu_HyperLink.NavigateUrl = "~/MenuBeverage.aspx?IDProduct=" + IDProduct + "&Category=" + Category; CommonClassLibrary.CommonDataSet.CategoryDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.CategoryTableAdapter().GetDataByID(Category); foreach (CommonClassLibrary.CommonDataSet.CategoryRow item in collection) { CommonClassLibrary.CommonDataSet.TextContentDataTable collection222 = new CommonClassLibrary.CommonDataSetTableAdapters.TextContentTableAdapter().GetDataById(long.Parse(item.Name)); foreach (CommonClassLibrary.CommonDataSet.TextContentRow item222 in collection222) { this.Menu2_Label.Text = "แก้ไข " + item222.Thai; this.BackMenu_HyperLink.Text = item222.Thai; this.Menu1_Label.Text = "แก้ไข " + item222.Thai; } } }
protected void Button1_Click(object sender, EventArgs e) { string img = ""; CommonClassLibrary.CommonDataSet.CategoryDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.CategoryTableAdapter().GetDataByID(int.Parse(aaa_TextBox.Text)); foreach (CommonClassLibrary.CommonDataSet.CategoryRow item in collection) { this.nameimage_TextBox.Text = item.ImageURL; } if (this.EditFileUpload.HasFile) { HttpPostedFile UpFileProduct = EditFileUpload.PostedFile; string UpFilePro = System.IO.Path.GetExtension(UpFileProduct.FileName); if (UpFilePro == ".jpg" || UpFilePro == ".png" || UpFilePro == ".JPG" || UpFilePro == ".PNG" || UpFilePro == ".jpeg" || UpFilePro == ".JPEG") { string imageFileName = "IMF" + "_" + DateTime.Now.ToString("ddMMyyyy-HHmmss"); imageFileName += ".jpg"; img = imageFileName; string path = System.IO.Path.Combine(Server.MapPath("~/Image/"), imageFileName); // string path = System.IO.Path.Combine(Server.MapPath("D:/OWP/DigitalServicesRestaurant/ManagementWebSite/Image/"), imageFileName); UpFileProduct.SaveAs(path); new CommonClassLibrary.CommonDataSetTableAdapters.TextContentTableAdapter().UpdateQueryById(editName_TextBox.Text, editNameEN_TextBox.Text, "", DateTime.Now, 1, int.Parse(Labelidname.Text)); if (new CommonClassLibrary.CommonDataSetTableAdapters.CategoryTableAdapter().UpdateQueryimage(img, DateTime.Now, int.Parse(aaa_TextBox.Text)) == 1) { if (nameimage_TextBox.Text != "") { FileInfo DeleteImage = new FileInfo(@"C:/FTP/Imilk/Image/" + nameimage_TextBox.Text); DeleteImage.Delete(); this.SuccessLabel.Text = "แก้ไขข้อมูลสำเร็จ"; Response.Redirect("~/AddCategory.aspx"); } else { this.SuccessLabel.Text = "แก้ไขข้อมูลสำเร็จ"; Response.Redirect("~/AddCategory.aspx"); } } else { FileInfo DeleteImage = new FileInfo(@"C:/FTP/Imilk/Image/" + img); DeleteImage.Delete(); this.SuccessPanel.Visible = false; this.ErrorPanel.Visible = true; this.ErrorLabel.Text = "แก้ไขข้อมูลไม่สำเร็จ"; } } else { this.SuccessPanel.Visible = false; this.ErrorPanel.Visible = true; this.ErrorLabel.Text = "ไม่สามารถเพิ่มรูปภาพได้ ต้องเป็นไฟล์ .PNG , .JPG , .JPEG "; } } else { new CommonClassLibrary.CommonDataSetTableAdapters.TextContentTableAdapter().UpdateQueryById(editName_TextBox.Text, editNameEN_TextBox.Text, "", DateTime.Now, 1, int.Parse(Labelidname.Text)); img = nameimage_TextBox.Text; if (new CommonClassLibrary.CommonDataSetTableAdapters.CategoryTableAdapter().UpdateQueryimage(img, DateTime.Now, int.Parse(aaa_TextBox.Text)) == 1) { this.SuccessLabel.Text = "แก้ไขข้อมูลสำเร็จ"; Response.Redirect("~/AddCategory.aspx"); } else { this.SuccessPanel.Visible = false; this.ErrorPanel.Visible = true; this.ErrorLabel.Text = "แก้ไขข้อมูลไม่สำเร็จ"; } } }
protected void CategoryTa_ItemCommand(object source, RepeaterCommandEventArgs e) { Label idlabel = (Label)e.Item.FindControl("idLabel"); Label imagenamelabel = (Label)e.Item.FindControl("imagenameLabel"); this.aaa_TextBox.Text = idlabel.Text; string nameimageurl = ""; if (e.CommandName == "EditBtn") { //this.getImage(); CommonClassLibrary.CommonDataSet.CategoryDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.CategoryTableAdapter().GetDataByID(int.Parse(idlabel.Text)); foreach (CommonClassLibrary.CommonDataSet.CategoryRow item in collection) { this.Labelidname.Text = item.Name; this.Image_category.ImageUrl = "Image/" + item.ImageURL; } this.EditPanel.Visible = true; this.AddPanel.Visible = false; this.ShowPanel.Visible = false; CommonClassLibrary.CommonDataSet.TextContentDataTable collection1 = new CommonClassLibrary.CommonDataSetTableAdapters.TextContentTableAdapter().GetDataById(int.Parse(Labelidname.Text)); foreach (CommonClassLibrary.CommonDataSet.TextContentRow item1 in collection1) { editName_TextBox.Text = item1.Thai; editNameEN_TextBox.Text = item1.English; } this.EditPanel.Visible = true; this.AddPanel.Visible = false; this.ShowPanel.Visible = false; } else if (e.CommandName == "DeleteBtn") { try { CommonClassLibrary.CommonDataSet.CategoryDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.CategoryTableAdapter().GetDataByID(int.Parse(idlabel.Text)); foreach (CommonClassLibrary.CommonDataSet.CategoryRow item in collection) { nameimageurl = item.ImageURL; } if (new CommonClassLibrary.CommonDataSetTableAdapters.CategoryTableAdapter().UpdateQueryStatus(DateTime.Now, 0, int.Parse(aaa_TextBox.Text)) == 1) { this.SuccessPanel.Visible = true; this.ErrorPanel.Visible = false; this.SuccessLabel.Text = "ลบข้อมูลสำเร็จ"; } else { this.SuccessPanel.Visible = false; this.ErrorPanel.Visible = true; this.ErrorLabel.Text = "ลบข้อมูลไม่สำเร็จ"; } this.Showdata(); } catch (Exception) { } this.Showdata(); } }