Ejemplo n.º 1
0
 public void CreateNewsGroup(NewsGroup newsGroup)
 {
     using (SqlConnection connection = base.GetConnection())
     {
         SqlCommand command = new SqlCommand("_NewsGroupUpdate", connection) {
             CommandType = CommandType.StoredProcedure
         };
         command.Parameters.AddWithValue("@Type", 0);
         command.Parameters.AddWithValue("@NewsGroupID", 0);
         command.Parameters.AddWithValue("@CateNewsID", newsGroup.CateNewsID);
         command.Parameters.AddWithValue("@ParentNewsID", newsGroup.ParentNewsID);
         command.Parameters.AddWithValue("@GroupCate", newsGroup.GroupCate);
         command.Parameters.AddWithValue("@Title", newsGroup.Title);
         command.Parameters.AddWithValue("@ShortDescribe", newsGroup.ShortDescribe);
         command.Parameters.AddWithValue("@FullDescribe", newsGroup.FullDescribe);
         command.Parameters.AddWithValue("@ImageThumb", newsGroup.ImageThumb);
         command.Parameters.AddWithValue("@ImageLarge", newsGroup.ImageLarge);
         command.Parameters.AddWithValue("@FileName", newsGroup.FileName);
         command.Parameters.AddWithValue("@Author", newsGroup.Author);
         command.Parameters.AddWithValue("@PostDate", newsGroup.PostDate);
         command.Parameters.AddWithValue("@RelationTotal", newsGroup.RelationTotal);
         command.Parameters.AddWithValue("@Status", newsGroup.Status);
         command.Parameters.AddWithValue("@Language", newsGroup.Language);
         command.Parameters.AddWithValue("@Ishot", newsGroup.Ishot);
         command.Parameters.AddWithValue("@Isview", newsGroup.Isview);
         command.Parameters.AddWithValue("@Ishome", newsGroup.Ishome);
         command.Parameters.AddWithValue("@TypeNews", newsGroup.TypeNews);
         command.Parameters.AddWithValue("@IsComment", newsGroup.IsComment);
         command.Parameters.AddWithValue("@ApprovalDate", newsGroup.ApprovalDate);
         command.Parameters.AddWithValue("@ApprovalUserName", newsGroup.ApprovalUserName);
         command.Parameters.AddWithValue("@IsApproval", newsGroup.IsApproval);
         command.Parameters.AddWithValue("@CreatedUserName", newsGroup.CreatedUserName);
         command.Parameters.AddWithValue("@CommentTotal", newsGroup.CommentTotal);
         connection.Open();
         if (command.ExecuteNonQuery() <= 0)
         {
             throw new DataAccessException("Kh\x00f4ng thể th\x00eam mới tin");
         }
         command.Dispose();
     }
 }
        //#region ViewCateNews
        //private void ViewCateNews(int group)
        //{

        //    ddlCateNews.Items.Clear();
        //    CateNewsBSO catenewsBSO = new CateNewsBSO();
        //    DataTable table = catenewsBSO.GetCateGroupRoles(Language.language, group, Session["Admin_UserName"].ToString());
        //    commonBSO commonBSO = new commonBSO();
        //    commonBSO.FillToDropDown(ddlCateNews, table, "", "", "CateNewsName", "CateNewsID", "");
        //}
        //#endregion

        #region initControl
        private void initControl(int Id)
        {
            AdminBSO adminBSO = new AdminBSO();
            ETO.Admin admin = new ETO.Admin();
            if (Id > 0)
            {
                btn_add.Visible = false;
                btn_edit.Visible = true;
                try
                {
                    NewsGroup newsgroup = new NewsGroup();
                    NewsGroupBSO newsgroupBSO = new NewsGroupBSO();
                    newsgroup = newsgroupBSO.GetNewsGroupById(Id);
                    hddNewsGroupID.Value = Convert.ToString(newsgroup.NewsGroupID);
                    ddlCateNews.SelectedValue = Convert.ToString(newsgroup.CateNewsID);
                    hddParentNewsID.Value = Convert.ToString(newsgroup.ParentNewsID);

                    //rdbGroupCate.SelectedValue = Convert.ToString(newsgroup.GroupCate); //Thêm

                    txtTitle.Text = newsgroup.Title;
                    txtRadShort.Html = newsgroup.ShortDescribe;
                    txtRadFull.Html = newsgroup.FullDescribe;
                    hddImageThumb.Value = newsgroup.ImageThumb;
                    hddImageLarge.Value = newsgroup.ImageLarge;
                    hddFileName.Value = newsgroup.FileName;

                    txtAuthor.Text = newsgroup.Author;
                    txtRadDate.SelectedDate = newsgroup.PostDate;
                    hddRelationTotal.Value = Convert.ToString(newsgroup.RelationTotal);
                    rdbStatus.SelectedValue = Convert.ToString(newsgroup.Status);
                    rdbIshot.SelectedValue = Convert.ToString(newsgroup.Ishot);
                    rdbIshome.SelectedValue = Convert.ToString(newsgroup.Ishome);


                    hddCommentTotal.Value = Convert.ToString(newsgroup.CommentTotal);
                    hddIsView.Value = Convert.ToString(newsgroup.Isview);
                    hddCreateUserName.Value = newsgroup.CreatedUserName;
                    hddApprovalUserName.Value = newsgroup.ApprovalUserName;
                    hddApprovalDate.Value = Convert.ToString(newsgroup.ApprovalDate);


                    rdbComment.SelectedValue = Convert.ToString(newsgroup.IsComment);

                    admin = adminBSO.GetAdminById(Session["Admin_UserName"].ToString());

                    if (Session["Admin_UserName"].ToString().Equals("administrator") || adminBSO.CheckPermission(Session["Admin_UserName"].ToString(), "Approval"))
                    {
                        rdbApproval.SelectedValue = Convert.ToString(newsgroup.IsApproval);
                        rdbApproval.Enabled = true;
                    }
                    else
                    {
                        rdbApproval.SelectedValue = Convert.ToString(newsgroup.IsApproval);
                        rdbApproval.Enabled = false;
                    }

                    hddGroup.Value = newsgroup.GroupCate.ToString();
                    BindToCateNews(newsgroup.GroupCate);
                    ddlCateNewsGroup.SelectedValue = hddGroup.Value;
                    ddlCateNews.SelectedValue = Convert.ToString(newsgroup.CateNewsID);

                    rdbTypeNews.SelectedValue = Convert.ToString(newsgroup.TypeNews);

                }
                catch (Exception ex)
                {
                    clientview.Text = ex.Message.ToString();
                }
            }
            else
            {
                txtRadDate.SelectedDate = DateTime.Now;
                btn_add.Visible = true;
                btn_edit.Visible = false;
                if (Session["Admin_UserName"].ToString().Equals("administrator") || adminBSO.CheckPermission(Session["Admin_UserName"].ToString(), "Approval"))
                {

                    rdbApproval.Enabled = true;
                }
                else
                {

                    rdbApproval.Enabled = false;
                }

            }
        }
Ejemplo n.º 3
0
 public void CreateNewsGroup(NewsGroup newsGroup)
 {
     new NewsGroupDAO().CreateNewsGroup(newsGroup);
 }
        private NewsGroup ReceiveHtml()
        {
            ConfigBSO configBSO = new ConfigBSO();
            Config config = configBSO.GetAllConfig(Language.language);
            int thumb_w = Convert.ToInt32(config.New_thumb_w);
            int thumb_h = Convert.ToInt32(config.New_thumb_h);

            commonBSO commonBSO = new commonBSO();
            string path_thumb = Request.PhysicalApplicationPath.Replace(@"\", "/") + "/Upload/NewsGroup/NewsGroupThumb/";
            string image_thumb = commonBSO.UploadImage(file_image_thumb, path_thumb, thumb_w, thumb_h);

            int large_w = Convert.ToInt32(config.New_large_w);
            int large_h = Convert.ToInt32(config.New_large_h);
            string path_large = Request.PhysicalApplicationPath.Replace(@"\", "/") + "/Upload/NewsGroup/NewsGroupLarge/";
            string image_large = commonBSO.UploadImage(file_image_thumb, path_large, large_w, large_h);

            string path = Request.PhysicalApplicationPath.Replace(@"\", "/") + "/Upload/NewsGroup/Files/";
            string file_upload = commonBSO.UploadFile(file_attached, path, 1800000000000);

            NewsGroup newsgroup = new NewsGroup();
            newsgroup.NewsGroupID = (hddNewsGroupID.Value != "") ? Convert.ToInt32(hddNewsGroupID.Value) : 0;
            newsgroup.CateNewsID = Convert.ToInt32(ddlCateNews.SelectedValue);
            newsgroup.ParentNewsID = (hddParentNewsID.Value != "") ? Convert.ToInt32(hddParentNewsID.Value) : 0;
            //newsgroup.GroupCate = Convert.ToInt32(hddGroup.Value);
            newsgroup.GroupCate = Convert.ToInt32(ddlCateNewsGroup.SelectedValue);

            newsgroup.Title = txtTitle.Text;
            newsgroup.ShortDescribe = txtRadShort.Html;
            newsgroup.FullDescribe = txtRadFull.Html;
            newsgroup.ImageThumb = (image_thumb != "") ? image_thumb : hddImageThumb.Value;
            newsgroup.ImageLarge = (image_large != "") ? image_large : hddImageLarge.Value;
            newsgroup.FileName = (file_upload != "") ? file_upload : hddFileName.Value;

            newsgroup.Author = txtAuthor.Text;
            newsgroup.PostDate = txtRadDate.SelectedDate.Value;
            newsgroup.RelationTotal = (hddRelationTotal.Value != "") ? Convert.ToInt32(hddRelationTotal.Value) : 0;
            newsgroup.Status = Convert.ToBoolean(rdbStatus.SelectedItem.Value);
            newsgroup.Language = Language.language;
            newsgroup.Ishot = Convert.ToBoolean(rdbIshot.SelectedValue);
            newsgroup.Ishome = Convert.ToBoolean(rdbIshome.SelectedValue);

            newsgroup.TypeNews = Convert.ToBoolean(rdbTypeNews.SelectedValue);

            newsgroup.IsComment = Convert.ToBoolean(rdbComment.SelectedValue);

            newsgroup.Isview = (hddIsView.Value != "") ? Convert.ToInt32(hddIsView.Value) : 0;
            newsgroup.CommentTotal = (hddCommentTotal.Value != "") ? Convert.ToInt32(hddCommentTotal.Value) : 0;

            newsgroup.CreatedUserName = (hddCreateUserName.Value != "") ? hddCreateUserName.Value : Session["Admin_UserName"].ToString();



            newsgroup.IsApproval = Convert.ToBoolean(rdbApproval.SelectedValue);
            if (hddApprovalUserName.Value != "")
            {
                newsgroup.ApprovalUserName = hddApprovalUserName.Value;
                newsgroup.ApprovalDate = Convert.ToDateTime(hddApprovalDate.Value);
            }
            else
                if (Convert.ToBoolean(rdbApproval.SelectedValue))
                {
                    newsgroup.ApprovalUserName = Session["Admin_UserName"].ToString();
                    newsgroup.ApprovalDate = DateTime.Now;
                }
                else
                {
                    newsgroup.ApprovalUserName = "";
                    newsgroup.ApprovalDate = DateTime.Now;
                }


            return newsgroup;

        }
Ejemplo n.º 5
0
 public void UpdateNewsGroup(NewsGroup newsGroup)
 {
     new NewsGroupDAO().UpdateNewsGroup(newsGroup);
 }