private void LoadDataFoto() { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { PostDetail_Class PostDetail_Class = new PostDetail_Class(db); TBPostDetail PostDetail = PostDetail_Class.GetData(HiddenFieldIDPostDetail.Value.ToInt()); if (DropDownListDetailJenis.SelectedValue.ToInt() == (int)EnumJenisPostDetail.SingleImage) { ImagePhotoProfile.ImageUrl = PostDetail.TBPostDetailImages.FirstOrDefault().DefaultURL + "?w=250"; } else { RepeaterImageMultiple.DataSource = PostDetail.TBPostDetailImages .Select(item => new { item.IDPostDetailImage, item.Urutan, item.DefaultURL, item.Judul, item.Link, item.Alt, item.Deskripsi }).OrderBy(item => item.Urutan); RepeaterImageMultiple.DataBind(); } } }
protected void ButtonDetailSimpan_Click(object sender, EventArgs e) { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { PenggunaLogin PenggunaLogin = (PenggunaLogin)Session["PenggunaLogin"]; Post_Class Post_Class = new Post_Class(db); TBPost Post = Post_Class.GetData(Request.QueryString["id"].ToInt()); PostDetail_Class PostDetail_Class = new PostDetail_Class(db); if (string.IsNullOrEmpty(HiddenFieldIDPostDetail.Value)) { PostDetail_Class.InsertData(Post.IDPost, PenggunaLogin.IDPengguna, Post.TBPostDetails.Count + 1, DateTime.Now, TextBoxDetailNama.Text, DropDownListDetailJenis.SelectedValue.ToInt(), (DropDownListDetailJenis.SelectedValue.ToInt() == (int)EnumJenisPostDetail.Text ? TextBoxDetailKonten.Text : null)); } else { TBPostDetail PostDetail = PostDetail_Class.GetData(HiddenFieldIDPostDetail.Value.ToInt()); PostDetail.Nama = TextBoxDetailNama.Text; if (DropDownListDetailJenis.SelectedValue.ToInt() == (int)EnumJenisPostDetail.Text) { PostDetail.Konten = HttpUtility.HtmlDecode(TextBoxDetailKonten.Text); } } db.SubmitChanges(); MultiViewPage.SetActiveView(ViewPost); LoadPost(); } }
protected void ButtonUploadSingleImage_Click(object sender, EventArgs e) { if (FileUploadSingleImage.HasFile) { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { PenggunaLogin PenggunaLogin = (PenggunaLogin)Session["PenggunaLogin"]; string Folder = Server.MapPath("/images/PostDetail/"); if (!Directory.Exists(Folder)) { Directory.CreateDirectory(Folder); } Post_Class Post_Class = new Post_Class(db); TBPost Post = Post_Class.GetData(Request.QueryString["id"].ToInt()); PostDetail_Class PostDetail_Class = new PostDetail_Class(db); TBPostDetail PostDetail = null; if (string.IsNullOrEmpty(HiddenFieldIDPostDetail.Value)) { PostDetail = PostDetail_Class.InsertData(Post.IDPost, PenggunaLogin.IDPengguna, Post.TBPostDetails.Count + 1, DateTime.Now, TextBoxDetailNama.Text, DropDownListDetailJenis.SelectedValue.ToInt(), (DropDownListDetailJenis.SelectedValue.ToInt() == (int)EnumJenisPostDetail.Text ? TextBoxDetailKonten.Text : null)); db.SubmitChanges(); } else { PostDetail = PostDetail_Class.GetData(HiddenFieldIDPostDetail.Value.ToInt()); } PostDetailImage_Class PostDetailImage_Class = new PostDetailImage_Class(db); TBPostDetailImage PostDetailImage = PostDetail.TBPostDetailImages.FirstOrDefault(); if (PostDetailImage == null) { PostDetailImage = PostDetailImage_Class.InsertData(PostDetail.IDPostDetail, 0, string.Empty, null, null, null, null); db.SubmitChanges(); } FileUploadSingleImage.SaveAs(Folder + (PostDetailImage.IDPostDetail + "-" + PostDetailImage.IDPostDetailImage) + ".jpg"); PostDetailImage.DefaultURL = "/images/PostDetail/" + (PostDetailImage.IDPostDetail + "-" + PostDetailImage.IDPostDetailImage) + ".jpg"; db.SubmitChanges(); HiddenFieldIDPostDetail.Value = PostDetail.IDPostDetail.ToString(); DropDownListDetailJenis.Enabled = false; } LoadDataFoto(); } }
protected void RepeaterBody_ItemCommand(object source, RepeaterCommandEventArgs e) { if (string.IsNullOrEmpty(HiddenFieldIDPostDetail.Value)) { HiddenFieldIDPostDetail.Value = e.CommandArgument.ToString(); DivAlertSwap.Attributes.Add("class", "alert alert-warning"); LabelAlert.Text = "Pilih post yang akan di swap"; } else { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { int urutan = 0, idPost = 0; PostDetail_Class PostDetail_Class = new PostDetail_Class(db); TBPostDetail PostDetailSource = PostDetail_Class.GetData(HiddenFieldIDPostDetail.Value.ToInt()); TBPostDetail PostDetailTarget = PostDetail_Class.GetData(e.CommandArgument.ToInt()); //GANTI ID POST idPost = PostDetailSource.IDPost; PostDetailSource.IDPost = PostDetailTarget.IDPost; PostDetailTarget.IDPost = idPost; //GANTI URUTAN urutan = PostDetailSource.Urutan; PostDetailSource.Urutan = PostDetailTarget.Urutan; PostDetailTarget.Urutan = urutan; db.SubmitChanges(); LoadPost(); } HiddenFieldIDPostDetail.Value = string.Empty; DivAlertSwap.Attributes.Add("class", "alert alert-primary"); LabelAlert.Text = "Pilih post yang akan di swap"; } }
protected void RepeaterPostDetail_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "Ubah") { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { MultiViewPage.SetActiveView(ViewPostDetail); HiddenFieldIDPostDetail.Value = e.CommandArgument.ToString(); PostDetail_Class PostDetail_Class = new PostDetail_Class(db); TBPostDetail PostDetail = PostDetail_Class.GetData(HiddenFieldIDPostDetail.Value.ToInt()); TextBoxDetailNama.Text = PostDetail.Nama; DropDownListDetailJenis.SelectedValue = PostDetail.Jenis.ToString(); TextBoxDetailKonten.Text = PostDetail.Konten; if (DropDownListDetailJenis.SelectedValue.ToInt() == (int)EnumJenisPostDetail.Text) { DivKonten.Visible = true; DivSingleImage.Visible = false; DivMultipleImage.Visible = false; } else if (DropDownListDetailJenis.SelectedValue.ToInt() == (int)EnumJenisPostDetail.SingleImage) { DivKonten.Visible = false; DivSingleImage.Visible = true; DivMultipleImage.Visible = false; LoadDataFoto(); } else { DivKonten.Visible = false; DivSingleImage.Visible = false; DivMultipleImage.Visible = true; LoadDataFoto(); } DropDownListDetailJenis.Enabled = false; } } else { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { PostDetail_Class PostDetail_Class = new PostDetail_Class(db); TBPostDetail PostDetail = PostDetail_Class.GetData(e.CommandArgument.ToInt()); if (PostDetail.Jenis == (int)EnumJenisPostDetail.Text) { PostDetail_Class.DeleteData(PostDetail); } else { PostDetailImage_Class PostDetailImage_Class = new PostDetailImage_Class(db); TBPostDetailImage[] ListPostDetailImage = PostDetailImage_Class.GetAll().Where(item => item.IDPostDetail == e.CommandArgument.ToInt()).ToArray(); foreach (var item in ListPostDetailImage) { FileInfo file = new FileInfo(Server.MapPath("/images/PostDetail/") + (item.IDPostDetail + "-" + item.IDPostDetailImage) + ".jpg"); if (file.Exists) { file.Delete(); } } PostDetailImage_Class.DeleteAllData(ListPostDetailImage); PostDetail_Class.DeleteData(e.CommandArgument.ToInt()); } db.SubmitChanges(); } LoadPost(); } }
protected void ButtonUploadMultipleImage_Click(object sender, EventArgs e) { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { PenggunaLogin PenggunaLogin = (PenggunaLogin)Session["PenggunaLogin"]; string Folder = Server.MapPath("/images/PostDetail/"); if (!Directory.Exists(Folder)) { Directory.CreateDirectory(Folder); } Post_Class Post_Class = new Post_Class(db); TBPost Post = Post_Class.GetData(Request.QueryString["id"].ToInt()); PostDetail_Class PostDetail_Class = new PostDetail_Class(db); TBPostDetail PostDetail = null; if (string.IsNullOrEmpty(HiddenFieldIDPostDetail.Value)) { PostDetail = PostDetail_Class.InsertData(Post.IDPost, PenggunaLogin.IDPengguna, Post.TBPostDetails.Count + 1, DateTime.Now, TextBoxDetailNama.Text, DropDownListDetailJenis.SelectedValue.ToInt(), (DropDownListDetailJenis.SelectedValue.ToInt() == (int)EnumJenisPostDetail.Text ? TextBoxDetailKonten.Text : null)); db.SubmitChanges(); } else { PostDetail = PostDetail_Class.GetData(HiddenFieldIDPostDetail.Value.ToInt()); } PostDetailImage_Class PostDetailImage_Class = new PostDetailImage_Class(db); TBPostDetailImage PostDetailImage = null; if (ButtonUploadMultipleImage.Text == "Tambah") { PostDetailImage = PostDetailImage_Class.InsertData(PostDetail.IDPostDetail, PostDetail.TBPostDetailImages.Count + 1, string.Empty, TextBoxImageJudul.Text, HttpUtility.HtmlDecode(TextBoxImageDeskripsi.Text), TextBoxImageLink.Text, TextBoxImageAlt.Text); } else { PostDetailImage = PostDetailImage_Class.GetData(HiddenFieldPostDetailImage.Value.ToInt()); PostDetailImage.Judul = TextBoxImageJudul.Text; PostDetailImage.Deskripsi = HttpUtility.HtmlDecode(TextBoxImageDeskripsi.Text); PostDetailImage.Link = TextBoxImageLink.Text; PostDetailImage.Alt = TextBoxImageAlt.Text; } db.SubmitChanges(); if (FileUploadMultipleImage.HasFile) { FileUploadMultipleImage.SaveAs(Folder + (PostDetailImage.IDPostDetail + "-" + PostDetailImage.IDPostDetailImage) + ".jpg"); } PostDetailImage.DefaultURL = "/images/PostDetail/" + (PostDetailImage.IDPostDetail + "-" + PostDetailImage.IDPostDetailImage) + ".jpg"; db.SubmitChanges(); HiddenFieldIDPostDetail.Value = PostDetail.IDPostDetail.ToString(); HiddenFieldPostDetailImage.Value = string.Empty; DropDownListDetailJenis.Enabled = false; TextBoxImageJudul.Text = string.Empty; TextBoxImageLink.Text = string.Empty; TextBoxImageAlt.Text = string.Empty; TextBoxImageDeskripsi.Text = string.Empty; ButtonUploadMultipleImage.Text = "Tambah"; } LoadDataFoto(); }