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();
}
}
public TBPostDetailImage InsertData(TBPostDetail TBPostDetail, int Urutan, string DefaultURL, string Judul, string Deskripsi, string Link, string Alt)
{
TBPostDetailImage Data = new TBPostDetailImage()
{
TBPostDetail = TBPostDetail,
Urutan = Urutan,
DefaultURL = DefaultURL,
Judul = Judul,
Deskripsi = Deskripsi,
Link = Link,
Alt = Alt
};
db.TBPostDetailImages.InsertOnSubmit(Data);
return(Data);
}
public TBPostDetail InsertData(int IDPost, int IDPengguna, int Urutan, DateTime Tanggal, string Nama, int Jenis, string Konten)
{
TBPostDetail Data = new TBPostDetail()
{
IDPost = IDPost,
IDPengguna = IDPengguna,
Urutan = Urutan,
Tanggal = Tanggal,
Nama = Nama,
Jenis = Jenis,
Konten = Konten
};
db.TBPostDetails.InsertOnSubmit(Data);
return(Data);
}
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";
}
}
public void DeleteData(TBPostDetail Data)
{
db.TBPostDetails.DeleteOnSubmit(Data);
}
public void InsertData(TBPostDetail Data)
{
db.TBPostDetails.InsertOnSubmit(Data);
}
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();
}
