示例#1
0
    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();
        }
    }
示例#2
0
文件: Class_Post.cs 项目: vaxtra/Toms
    public ReturnData AJAX_Updates(int idPost, string postTitle, string postShortContent, string postContent)
    {
        try
        {
            DataClassesDataContext db = new DataClassesDataContext();
            TBPost post = db.TBPosts.Where(x => !x.Deflag && x.IDPost == idPost).FirstOrDefault();
            if (post == null)
            {
                return(ReturnData.MessageFailed("Post not found", null));
            }
            post.Post_Title        = postTitle;
            post.Post_ShortContent = postShortContent;
            post.Post_Content      = postContent;
            post.DateLastUpdate    = DateTime.Now;
            db.SubmitChanges();

            return(ReturnData.MessageSuccess("Data updated successfully", null));
        }
        catch (Exception ex)
        {
            Class_Log_Error log = new Class_Log_Error();
            log.Insert(ex.Message, ex.StackTrace);

            return(ReturnData.MessageFailed(ex.Message, null));
        }
    }
示例#3
0
    protected void ButtonSimpan_Click(object sender, EventArgs e)
    {
        using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
        {
            PenggunaLogin PenggunaLogin = (PenggunaLogin)Session["PenggunaLogin"];

            Page_Class Page_Class = new Page_Class(db);
            TBPage     Halaman    = Page_Class.GetData(Request.QueryString["idPage"].ToInt());

            Post_Class Post_Class = new Post_Class(db);
            TBPost     Post       = Post_Class.GetData(Request.QueryString["id"].ToInt());
            if (Post == null)
            {
                Post = Post_Class.InsertData(Request.QueryString["idPage"].ToInt(), PenggunaLogin.IDPengguna, Halaman.TBPosts.Count + 1, DateTime.Now, TextBoxJudul.Text, TextBoxDeskripsi.Text, DropDownListAlign.SelectedValue, TextBoxTags.Text);
            }
            else
            {
                Post.IDPengguna = PenggunaLogin.IDPengguna;
                Post.Urutan     = Post.Urutan;
                Post.Tanggal    = DateTime.Now;
                Post.Judul      = TextBoxJudul.Text;
                Post.Deskripsi  = TextBoxDeskripsi.Text;
                Post.Align      = DropDownListAlign.SelectedValue;
                Post.Tags       = TextBoxTags.Text;
            }

            db.SubmitChanges();

            Response.Redirect("Pengaturan.aspx?idPage=" + Request.QueryString["idPage"] + "&id=" + Post.IDPost);
        }
    }
示例#4
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
            {
                MultiViewPage.SetActiveView(ViewPost);

                //PageTemplate_Class PageTemplate_Class = new PageTemplate_Class(db);
                //PageTemplate_Class.DropDownList(DropDownListTemplate, "-Pilih Template-");

                if (string.IsNullOrEmpty(Request.QueryString["id"]))
                {
                    LabelKeterangan.Text = "Tambah";
                }
                else
                {
                    TBPost Post = db.TBPosts.FirstOrDefault(item => item.IDPost == Request.QueryString["id"].ToInt());

                    TextBoxJudul.Text = Post.Judul;
                    DropDownListAlign.SelectedValue = Post.Align.ToString();
                    TextBoxDeskripsi.Text           = Post.Deskripsi;

                    DivDetail.Visible = true;

                    LoadPost();

                    LabelKeterangan.Text = "Ubah";
                }
            }
        }

        Page.Form.Attributes.Add("enctype", "multipart/form-data");
    }
示例#5
0
    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();
        }
    }
示例#6
0
    public TBPost InsertData(int IDPage, int IDPengguna, int Urutan, DateTime Tanggal, string Judul, string Deskripsi, string Align, string Tags)
    {
        TBPost Data = new TBPost()
        {
            IDPage     = IDPage,
            IDPengguna = IDPengguna,
            Urutan     = Urutan,
            Tanggal    = Tanggal,
            Judul      = Judul,
            Deskripsi  = Deskripsi,
            Align      = Align,
            Tags       = Tags
        };

        db.TBPosts.InsertOnSubmit(Data);

        return(Data);
    }
示例#7
0
文件: Class_Post.cs 项目: vaxtra/Toms
    public ReturnData AJAX_Insert(string postTitle, string postShortContent, string postContent, int idPage, bool active)
    {
        try
        {
            using (DataClassesDataContext db = new DataClassesDataContext())
            {
                if (!ValidationName_Insert(db, postTitle))
                {
                    return(ReturnData.MessageFailed(postTitle + " already exists.", null));
                }

                TBPost _newData = new TBPost
                {
                    Post_Title        = postTitle,
                    IDPage            = idPage,
                    Post_ShortContent = postShortContent,
                    Post_Content      = postContent,
                    Active            = active,
                    Deflag            = false,
                    DateInsert        = DateTime.Now,
                    DateLastUpdate    = DateTime.Now
                };

                db.TBPosts.InsertOnSubmit(_newData);
                db.SubmitChanges();

                if (_newData != null)
                {
                    return(ReturnData.MessageSuccess(postTitle + " has been successfully inserted.", _newData.IDPost));
                }
                else
                {
                    return(ReturnData.MessageFailed(postTitle + " failed to insert.", null));
                }
            }
        }
        catch (Exception ex)
        {
            Class_Log_Error log = new Class_Log_Error();
            log.Insert(ex.Message, ex.StackTrace);

            return(ReturnData.MessageFailed(ex.Message, null));
        }
    }
示例#8
0
    private string GetAllPostDetail(TBPost Post)
    {
        string hasil = string.Empty;
        bool   awal  = true;

        foreach (var item in Post.TBPostDetails)
        {
            if (awal)
            {
                hasil += item.Nama;
                awal   = false;
            }
            else
            {
                hasil += ", " + item.Nama;
            }
        }
        return(hasil);
    }
示例#9
0
文件: Class_Post.cs 项目: vaxtra/Toms
    public ReturnData AJAX_Delete(int idPost)
    {
        try
        {
            DataClassesDataContext db = new DataClassesDataContext();
            TBPost post = db.TBPosts.Where(x => x.IDPost == idPost).FirstOrDefault();
            if (post == null)
            {
                return(ReturnData.MessageFailed("Post not found", null));
            }
            post.Deflag         = true;
            post.DateLastUpdate = DateTime.Now;
            db.SubmitChanges();

            return(ReturnData.MessageSuccess("Data deleted successfully", null));
        }
        catch (Exception ex)
        {
            Class_Log_Error log = new Class_Log_Error();
            log.Insert(ex.Message, ex.StackTrace);

            return(ReturnData.MessageFailed(ex.Message, null));
        }
    }
示例#10
0
 public void DeleteData(TBPost Data)
 {
     db.TBPosts.DeleteOnSubmit(Data);
 }
示例#11
0
 public void InsertData(TBPost Data)
 {
     db.TBPosts.InsertOnSubmit(Data);
 }
示例#12
0
    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();
    }