コード例 #1
0
        private void loadData()
        {
            ListQuestionBSO listQuestionBSO_ = new ListQuestionBSO();
            string RolesName_ = listQuestionBSO_.RolesNameByUserName(Session["Admin_UserName"].ToString());
            if (Page.RouteData.Values["dll"] != null)
            {
                btn_delall.Visible = false;
                strParam = Page.RouteData.Values["p"].ToString(); //p = parameter:
                switch (strParam)
                {
                    case "0":
                        Label1.Text = "Yêu cầu mới gửi";
                        listQuestionStatus(int.Parse(strParam), RolesName_);
                        break;
                    case "1":
                        Label1.Text = "Yêu cầu đang xử lý";
                        listQuestionStatus(int.Parse(strParam), RolesName_);
                        break;
                    case "2":
                        Label1.Text = "Yêu cầu đã được trả lời";
                        listQuestionStatus(int.Parse(strParam), RolesName_);
                        break;
                    case "3":
                        Label1.Text = "Yêu cầu đã kết thúc";
                        listQuestionStatus(int.Parse(strParam), RolesName_);
                        break;
                    case "all":
                        Label1.Text = "Tất các câu hỏi đã gửi";
                        listAllQuestionOfRoom(RolesName_);
                        break;
                    default:
                        Label1.Text = "";
                        listAllQuestionOfRoom(RolesName_);
                        break;
                }
            }
            //AdminBSO adminBSO = new AdminBSO();
            //Admin admin = new Admin();
            //admin = adminBSO.GetAdminById(Session["Admin_UserName"].ToString());
            //RolesBSO roleBSO = new RolesBSO();
            //IRoles iRole = new IRoles();



            //iRole = roleBSO.GetRolesById(admin.RolesID);
            if (RolesName_ == "Guest")
            {
                iconForUser();
            }
        }
コード例 #2
0
 private void initControl(int Id)
 {
     AdminBSO adminBSO = new AdminBSO();
     ETO.Admin admin = new ETO.Admin();
     if (Id > 0)
     {
         //if (!Session["Admin_UserName"].ToString().Equals("administrator"))
         //{
         //    ddlCateNews.Enabled = false;
         //}
         ListQuestion listQuestion = new ListQuestion();
         ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
         listQuestion = listQuestionBSO.GetListQuestionByID(Id);
         txtTitle.Text = listQuestion.Question_Title;
         HiddenField_FileAttach.Value = listQuestion.Question_FileAttach;
         HiddenField_ImageAttach.Value = listQuestion.Question_Image;
         HiddenField_QuestionID.Value = Id.ToString();
         HiddenField_QuestionStatus.Value = listQuestion.QuestionStatus.ToString();
         HiddenField_CreateUserName.Value = listQuestion.CreateUserName;
         HiddenField_CreateDate.Value = listQuestion.CreateDate.ToString();
         txtRadShort.Html = listQuestion.Question_Content;
         ddlCateNews.SelectedValue = Convert.ToString(listQuestion.CateNewsID);
     }
 }
コード例 #3
0
        protected void btn_enable_approval_Click(object sender, EventArgs e)
        {
            if (PagesID() != "")
            {
                ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
                //listQuestionBSO.UpdateQuestionStatus(PagesID(), 1);

                //PagesBSO pagesBSO = new PagesBSO();
                //pagesBSO.PagesUpdate(PagesID(), "1", Session["Admin_UserName"].ToString(), DateTime.Now);
            }

            //PagesView(hddGroup.Value);

        }
コード例 #4
0
        protected void btn_disable_Click(object sender, EventArgs e)
        {
            if (PagesID() != "")
            {
                //PagesBSO pagesBSO = new PagesBSO();
                //pagesBSO.PagesUpdate(PagesID(), "0");
                ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
                listQuestionBSO.UpdateQuestionStatus(PagesID(), 3);
                listQuestionStatus(int.Parse(strParam));
                Response.Redirect("~/Admin/p/listQuestion/all/Default.aspx");
            }

            //PagesView(hddGroup.Value);
        }
コード例 #5
0
        protected void btn_enable_Click(object sender, EventArgs e)
        {
            if (PagesID() != "")
            {
                //PagesBSO pagesBSO = new PagesBSO();
                //pagesBSO.PagesUpdate(PagesID(), "1");
                ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
                listQuestionBSO.UpdateQuestionStatus(PagesID(), 1);

                if (Page.RouteData.Values["p"] == "all") //p = parameter:
                    listAllQuestionOfRoom();
                else
                    listQuestionStatus(int.Parse(strParam));
            }
            //PagesView(hddGroup.Value);
        }
コード例 #6
0
 private void ViewCateNews()
 {
     ListQuestionBSO listQuestionBSO_ = new ListQuestionBSO();
     string RolesName_ = listQuestionBSO_.RolesNameByUserName(Session["Admin_UserName"].ToString());
     if (Page.RouteData.Values["dll"] != null)
     {
         strParam = Page.RouteData.Values["Id"].ToString(); //p = parameter:
         if (!string.IsNullOrEmpty(strParam))
         {
             listParentQuestionByID(int.Parse(strParam), RolesName_);
             listChildQuestionByParentID(int.Parse(strParam), RolesName_);
             bindingContentQuestion(int.Parse(strParam), RolesName_);
         }
     }
 }
コード例 #7
0
        protected void btnSend_Click(object sender, EventArgs e)
        {

            if (!string.IsNullOrEmpty(Page.RouteData.Values["subid"].ToString())) //Update record
            {
                ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
                if (!string.IsNullOrEmpty(txtRadShort.Html))
                {
                    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);
                    ListQuestion listQuestionUpdate = new ListQuestion();

                    commonBSO commonBSO = new commonBSO();
                    string path_thumb = Request.PhysicalApplicationPath.Replace(@"\", "/") + "/Upload/Question/Images/";
                    string image_thumb = commonBSO.UploadImage(image_Attach, path_thumb, thumb_w, thumb_h);

                    string path = Request.PhysicalApplicationPath.Replace(@"\", "/") + "/Upload/Question/Files/";
                    string file_upload = commonBSO.UploadFile(file_Attach, path, 18000000000);
                    string strFile = (file_upload != "") ? file_upload : HiddenField_FileAttach.Value;
                    string strImage = (image_thumb != "") ? image_thumb : HiddenField_ImageAttach.Value;

                    listQuestionBSO.UpdateSubQuestion(Convert.ToInt32(Page.RouteData.Values["subid"]), txtRadShort.Html, strImage, strFile);
                    txtRadShort.Html = "";
                    //clientview.Text = strFile;
                }
                clientview.Text = String.Format(Resources.StringAdmin.AddNewsSuccessful);
                Response.Redirect("~/Admin/listdetailquestion/" + HiddenField_QuestionID.Value.ToString() + "/Default.aspx");
                //initControl(Id);
            }
            else //Addnew record
            {
                ListQuestion listQuestion = ReceiveHtml_();
                ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
                if (!string.IsNullOrEmpty(listQuestion.Question_Content))
                {
                    listQuestionBSO.CreateListQuestion(listQuestion);
                }
                else
                {
                    //hien thong bao yeu cau nhap noi dung
                }
                //clientview.Text = String.Format(Resources.StringAdmin.AddNewsSuccessful);         

                string strID = HiddenField_QuestionID.Value.ToString() + ",";
                //Cap nhat lai trang thai cau hoi doi voi cau hoi parent
                //Kiem tra user_Name login ? user_name CreateQuestion
                if (Session["Admin_UserName"].ToString() != HiddenField_CreateUserName.Value)
                {
                    //Cap nhat status = 2: Da xu ly
                    listQuestionBSO.UpdateQuestionStatus(strID, 2);
                    //----Gui mail thong bao den khach hang khi co cau tra loi
                    //------Lay userName
                    sendMailToUser(listQuestion);
                }
                else
                {
                    //Cap nhat status = 0: cau hoi moi
                    listQuestionBSO.UpdateQuestionStatus(strID, 0);
                    //Gui mail den nhom support khi khach hang reply
                    sendMailToGroup(listQuestion);
                    //------------ Gui email thong bao den nhom nhom support cua tung san pham              
                }
                Response.Redirect("~/Admin/listdetailquestion/" + HiddenField_QuestionID.Value.ToString() + "/Default.aspx");
            }

        }
コード例 #8
0
        protected void btn_enable_Click(object sender, EventArgs e)
        {
            ListQuestionBSO listQuestionBSO_ = new ListQuestionBSO();
            string RolesName_ = listQuestionBSO_.RolesNameByUserName(Session["Admin_UserName"].ToString());
            if (PagesID() != "")
            {

                ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
                listQuestionBSO.UpdateQuestionStatus(PagesID(), 1);

                if (Page.RouteData.Values["p"].ToString() == "all") //p = parameter:
                    listAllQuestionOfRoom(RolesName_);
                else
                    listQuestionStatus(int.Parse(strParam), RolesName_);
            }
        }
コード例 #9
0
        protected void btnSend_Click(object sender, EventArgs e)
        {
            ListQuestion listQuestion = ReceiveHtml_();
            ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
            if (Page.RouteData.Values["Id"] != null) //Update record
            {
                if (!string.IsNullOrEmpty(listQuestion.Question_Content) && !string.IsNullOrEmpty(listQuestion.Question_Title))
                {
                    listQuestionBSO.UpdatelistQuestion(listQuestion);
                    clientview.Text = "Cập nhật thành công";
                    ViewCateNews();
                    initControl(Id);
                }
            }
            else //Addnew record
            {
                //ListQuestion listQuestion = ReceiveHtml_();
                //ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
                if (!string.IsNullOrEmpty(listQuestion.Question_Content) && !string.IsNullOrEmpty(listQuestion.Question_Title))
                {
                    listQuestionBSO.CreateListQuestion(listQuestion);
                    clientview.Text = String.Format(Resources.StringAdmin.AddNewsSuccessful);

                    //------------ Gui email thong bao den nhom nhom support cua tung san pham

                    sendMailToGroup(listQuestion);

                    //-------------Gui email thong bao toi nguoi gui
                    sendMailToUser(listQuestion);
                    //Response.Redirect("Homepage.aspx?dll=listquestion&p=0");
                }
            }
        }
コード例 #10
0
        protected void Page_Load(object sender, EventArgs e)
        {
            AdminBSO adminBSO = new AdminBSO();
            //Admin admin = new Admin();

            //admin = adminBSO.GetAdminById(Session["Admin_UserName"].ToString());
            //RolesBSO roleBSO = new RolesBSO();
            //IRoles iRole = new IRoles();
            //btn_delall.Visible = false;
            //iRole = roleBSO.GetRolesById(admin.RolesID); //Thiet lap icon action cho nhom guest
            ListQuestionBSO listQuestionBSO_ = new ListQuestionBSO();
            string RolesName_ = listQuestionBSO_.RolesNameByUserName(Session["Admin_UserName"].ToString());
            if (RolesName_ == "Guest")
            {
                iconForUser();
            }

            if (Page.RouteData.Values["dll"] != null)
            {
                strParam = Page.RouteData.Values["Id"].ToString(); //p = parameter:
                int outValue;
                if (!int.TryParse(strParam, out outValue))
                    Response.Redirect("~/Admin/listquestion/Default.aspx");
                if (!string.IsNullOrEmpty(strParam))
                {
                    //-------------Kiem tra su ton tai cua User

                    listParentQuestionByID(int.Parse(strParam), RolesName_);
                    bindingContentQuestion(int.Parse(strParam), RolesName_);
                    listChildQuestionByParentID(int.Parse(strParam), RolesName_);
                    Label1.Text = "Xem câu trả lời";
                    //------------------------- Edit subQuestion
                    if (!string.IsNullOrEmpty(Page.RouteData.Values["subid"].ToString()))
                    {
                        int outCheck;
                        if (!int.TryParse(Page.RouteData.Values["subid"].ToString(), out outCheck))
                            Response.Redirect("~/Admin/listquestion/Default.aspx");
                        ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
                        DataTable dt = new DataTable();
                        int subID = Convert.ToInt32(Page.RouteData.Values["subid"]);
                        //int subID = int.Parse(Page.RouteData.Values["subid"]);
                        dt = listQuestionBSO.GetQuestionByID(subID);
                        if (dt.Rows.Count > 0)
                        {
                            txtRadShort.Html = dt.Rows[0]["Question_Content"].ToString();
                            if (!string.IsNullOrEmpty(dt.Rows[0]["Question_FileAttach"].ToString()))
                                HiddenField_FileAttach.Value = dt.Rows[0]["Question_FileAttach"].ToString();
                            if (!string.IsNullOrEmpty(dt.Rows[0]["Question_Image"].ToString()))
                                HiddenField_ImageAttach.Value = dt.Rows[0]["Question_Image"].ToString();
                            txtRadShort.Focus();
                        }
                    }
                }
            }
            else
            {
                lbContentQuestion.Text = "Chưa có dữ liệu";
                lbDatePostQuestion.Text = "";
                lbQuestionTitle.Text = "";
                btnSend.Enabled = false;
                Label1.Text = "";
                txtRadShort.Enabled = false;
            }


        }
コード例 #11
0
        private void listParentQuestionByID(int parentID, string RolesName_)
        {
            ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
            DataTable dt = new DataTable();
            dt = listQuestionBSO.listParentQuestionByID(parentID);

            DataView view1 = new DataView(dt);

            string strCate = GetCateParentIDArrayByID();

            if (RolesName_ == "Guest")
            {
                view1.RowFilter = "CreateUserName ='******'";
                grvListQuestion.Columns[6].Visible = false;  //Hide column publish
                grvListQuestion.Columns[7].Visible = false;  //Hide column Action
                iconForUser(); //Hide icon for Guest
                //------------------Neu la khach && chu de bi khoa => hide textRadHtml va btn
                if (view1[0]["QuestionStatus"].ToString() == "3")
                {
                    txtRadShort.Visible = false;
                    btnSend.Visible = false;
                    btnCancel.Visible = false;
                    image_Attach.Visible = false;
                    file_Attach.Visible = false;
                    Label11.Visible = false;
                    Label6.Visible = false;
                    Label4.Visible = false;
                }
            }
            else
                if (!string.IsNullOrEmpty(strCate))
                {
                    string restr = strCate.Remove(strCate.LastIndexOf(",")).Replace(",", "','");
                    //view1.RowFilter = "CateNewsID in('" + restr + "')";
                    view1.RowFilter = "CateNewsID in('" + restr + "') or CreateUserName ='******'";
                }
            //else
            //{
            //    if (RolesName_ == "Guest")
            //    {
            //        view1.RowFilter = "CreateUserName ='******'";
            //        grvListQuestion.Columns[6].Visible = false;  //Hide column Action
            //        iconForUser(); //Hide icon for Guest
            //        //------------------Neu la khach && chu de bi khoa => hide textRadHtml va btn
            //        if (view1[0]["QuestionStatus"].ToString() == "3")
            //        {
            //            txtRadShort.Visible = false;
            //            btnSend.Visible = false;
            //            btnCancel.Visible = false;
            //            image_Attach.Visible = false;
            //            file_Attach.Visible = false;
            //            Label11.Visible = false;
            //            Label6.Visible = false;
            //            Label4.Visible = false;
            //        }
            //    }
            //}
            grvListQuestion.DataSource = view1;
            grvListQuestion.DataBind();
            //-----------------------Luu thong tin ve cau hoi
            HiddenField_CreateDate.Value = view1[0]["CreateDate"].ToString();
            HiddenField_CreateUserName.Value = view1[0]["CreateUserName"].ToString();
            HiddenField_QuestionStatus.Value = view1[0]["QuestionStatus"].ToString();
            HiddenField_CateNewsID.Value = view1[0]["CateNewsID"].ToString();
            HiddenField_Question_Title.Value = view1[0]["Question_Title"].ToString();
            HiddenField_QuestionID.Value = view1[0]["Question_ID"].ToString();
        }
コード例 #12
0
        private void bindingContentQuestion(int parentID, string RolesName_)
        {
            ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
            DataTable dt = new DataTable();
            dt = listQuestionBSO.listParentQuestionByID(parentID);

            DataView view1 = new DataView(dt);

            string strCate = GetCateParentIDArrayByID();
            ////-------------------Lay nhom Role
            AdminBSO adminBSO = new AdminBSO();
            if (RolesName_ == "Guest")
            {
                view1.RowFilter = "CreateUserName ='******'";
            }
            else
                if (!string.IsNullOrEmpty(strCate))
                {
                    string restr = strCate.Remove(strCate.LastIndexOf(",")).Replace(",", "','");
                    //view1.RowFilter = "CateNewsID in('" + restr + "')";
                    view1.RowFilter = "CateNewsID in('" + restr + "') or CreateUserName ='******'";
                }

            ETO.Admin userPostQuestion = new ETO.Admin();
            if (adminBSO.CheckExist(view1[0]["CreateUserName"].ToString()))
            {
                userPostQuestion = adminBSO.GetAdminById(view1[0]["CreateUserName"].ToString());
                lbContentQuestion.Text = view1[0]["Question_Content"].ToString();
                lbDatePostQuestion.Text = " gửi ngày: " + view1[0]["CreateDate"].ToString();
                lbQuestionTitle.Text = "Tiêu đề: <b>" + view1[0]["Question_Title"].ToString() + "</b>";
                lbUserPost.Text = "Người gửi: <b>" + userPostQuestion.AdminFullName.ToString() + "</b>, ";
                if (!string.IsNullOrEmpty(view1[0]["Question_Image"].ToString()))
                {
                    string strImgName = view1[0]["Question_Image"].ToString();
                    Literal_images.Text = "<span style='display: block;'>Hình đính kèm:</span>";
                    Literal_images.Text = "<a href='" + ResolveUrl("~/") + "Upload/Question/Images/" + strImgName + "' rel='lightbox' ><img src='" + ResolveUrl("~/") + "Upload/Question/Images/" + strImgName + "' class='image_album' width='120' align='left'  hspace='1' /></a>";
                }
                if (!string.IsNullOrEmpty(view1[0]["Question_fileAttach"].ToString()))
                {
                    string strFileAttch = view1[0]["Question_fileAttach"].ToString();
                    Literal_file.Text = "<span style='display: block;'>Tệp tin đính kèm:</span>";
                    Literal_file.Text += "<a href='" + ResolveUrl("~/") + "Upload/Question/Files/" + strFileAttch + "'  ><img src='" + ResolveUrl("~/") + "Images/icon_file.png' class='icon' width='30' hspace='1' /> Tải tệp tin đính kèm </a>";
                }
            }
            else
            {
                lbContentQuestion.Text = "";
                lbDatePostQuestion.Text = "";
                lbQuestionTitle.Text = "";
                lbUserPost.Text = "Người gửi câu hỏi không tồn tại!";

            }


        }
コード例 #13
0
        private void listAllQuestionOfRoom(string RolesName_)
        {
            ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
            DataTable dt = new DataTable();
            dt = listQuestionBSO.GetListQuestionAll();

            DataView view1 = new DataView(dt);

            string strCate = GetCateParentIDArrayByID(); //Lay danh sach ID cua cac san pham        
            if (RolesName_ == "Guest")
            {
                view1.RowFilter = "CreateUserName ='******'";
                grvListQuestion.Columns[6].Visible = false;
                iconForUser();
            }
            else
                if (!string.IsNullOrEmpty(strCate))
                {
                    string restr = strCate.Remove(strCate.LastIndexOf(",")).Replace(",", "','");
                    if (RolesName_ == "mod") //Nguoi quan ly nhom san pham
                    {
                        view1.RowFilter = "CateNewsID in('" + restr + "') or CreateUserName ='******'";
                    }
                }
            //else
            //{
            //    if (RolesName_ == "Guest")
            //    {
            //        view1.RowFilter = "CreateUserName ='******'";
            //        grvListQuestion.Columns[6].Visible = false;
            //        iconForUser();
            //    }
            //}
            grvListQuestion.DataSource = view1;
            grvListQuestion.DataBind();

        }
コード例 #14
0
        protected void grvListQuestion_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            int Id = Convert.ToInt32(e.CommandArgument.ToString());
            string cName = e.CommandName.ToLower();
            AdminBSO adminBSO = new AdminBSO();
            ETO.Admin admin = new ETO.Admin();
            switch (cName)
            {
                case "_view":
                    break;
                case "_edit":
                    admin = adminBSO.GetAdminById(Session["Admin_UserName"].ToString());

                    //if (Session["Admin_UserName"].ToString().Equals("administrator") || adminBSO.CheckPermission(Session["Admin_UserName"].ToString(), "Edit") || adminBSO.CheckPermission(Session["Admin_UserName"].ToString(), "Write"))
                    {
                        Response.Redirect("~/Admin/editquestion/" + Id + "/Default.aspx");
                    }
                    //else
                    {
                        //  Response.Redirect("~/Homepage.aspx?dll=listnews");
                    }

                    break;
                case "_lockquestion": //Cap nhat status = 3 => cau hoi da ket thuc
                    {
                        ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
                        string strID = Id.ToString() + ",";
                        listQuestionBSO.UpdateQuestionStatus(strID, 3);
                        loadData();
                        break;
                    }

                case "_unlockquestion": //Cap nhat status = 1 => Dang xu ly
                    {
                        ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
                        string strID = Id.ToString() + ",";
                        listQuestionBSO.UpdateQuestionStatus(strID, 1);
                        loadData();
                        Label1.Text = "unlock";
                        break;
                    }
                case "_delete":
                    {
                        ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
                        listQuestionBSO.deleteQuestionByID(Id);
                        loadData();
                    }
                    break;
            }
        }
コード例 #15
0
        protected void btn_disable_Click(object sender, EventArgs e)
        {
            if (PagesID() != "")
            {
                ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
                listQuestionBSO.UpdateQuestionStatus(PagesID(), 3);
                loadData();
                //listQuestionStatus(3); //Cac cau hoi bi khoa
            }


        }
コード例 #16
0
        protected void grvListQuestion_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            int Id = Convert.ToInt32(e.CommandArgument.ToString());
            string cName = e.CommandName.ToLower();
            AdminBSO adminBSO = new AdminBSO();
            ETO.Admin admin = new ETO.Admin();
            ListQuestionBSO listQuestionBSO = new ListQuestionBSO();

            switch (cName)
            {
                case "_view":
                    break;
                case "_publish":
                    listQuestionBSO.updateStatusPublishQuestion(Id, 1);
                    Response.Redirect("~/Admin/listdetailquestion/" + Id + "/Default.aspx");
                    break;
                case "_unpublish":
                    listQuestionBSO.updateStatusPublishQuestion(Id, 0);
                    Response.Redirect("~/Admin/listdetailquestion/" + Id + "/Default.aspx");

                    break;
                case "_edit":
                    admin = adminBSO.GetAdminById(Session["Admin_UserName"].ToString());
                    //if (Session["Admin_UserName"].ToString().Equals("administrator") || adminBSO.CheckPermission(Session["Admin_UserName"].ToString(), "Edit") || adminBSO.CheckPermission(Session["Admin_UserName"].ToString(), "Write"))
                    {
                        Response.Redirect("~/Admin/editquestion/" + Id + "/Default.aspx");
                    }

                    break;
                case "_delete":
                    listQuestionBSO.deleteQuestionByID(Id);
                    Response.Redirect("~/Admin/p/listquestion/0/Default.aspx");
                    break;
            }
        }
コード例 #17
0
        protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            int Id = Convert.ToInt32(e.CommandArgument.ToString()); //subID question
            string cName = e.CommandName.ToLower();
            //------------- Lay ParentID

            AdminBSO adminBSO = new AdminBSO();
            ETO.Admin admin = new ETO.Admin();
            ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
            DataTable dt = new DataTable();
            string strParentID = "";
            dt = listQuestionBSO.GetQuestionByID(Id);
            if (dt.Rows.Count > 0)
                strParentID = dt.Rows[0]["Question_ParentID"].ToString();

            switch (cName)
            {
                case "_view_sub":
                    break;
                case "_publish":
                    listQuestionBSO.updateStatusPublishQuestion(Id, 1);
                    Response.Redirect("~/Admin/listdetailquestion&Id=" + strParentID + "/Default.aspx");
                    break;
                case "_unpublish":
                    listQuestionBSO.updateStatusPublishQuestion(Id, 0);
                    Response.Redirect("~/Admin/listdetailquestion&Id=" + strParentID + "/Default.aspx");
                    break;
                case "_edit_sub":
                    {
                        Response.Redirect("~/Admin/s/listdetailquestion/" + strParentID + "/" + Id + "/Default.aspx");
                        break;
                    }
                case "_delete_sub":
                    {
                        listQuestionBSO.deleteQuestionByID(Id);
                        Response.Redirect("~/Admin/p/listquestion/0/Default.aspx");
                        break;
                    }
            }
        }
コード例 #18
0
        private void listChildQuestionByParentID(int ParentID, string RolesName_)
        {
            ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
            DataTable dt = new DataTable();
            dt = listQuestionBSO.listChildQuestionByParentID(ParentID);

            DataView view1 = new DataView(dt);

            string strCate = GetCateParentIDArrayByID();

            if (RolesName_ == "Guest")
            {
                view1.RowFilter = "CreateUserName ='******'";
                GridView1.Columns[1].Visible = false; //Hide column Action
                GridView1.Columns[2].Visible = false; //Hide column Action
            }
            else
                if (!string.IsNullOrEmpty(strCate))
                {
                    string restr = strCate.Remove(strCate.LastIndexOf(",")).Replace(",", "','");

                    view1.RowFilter = "CateNewsID in('" + restr + "')";
                }

            GridView1.DataSource = view1;
            GridView1.DataBind();

        }
コード例 #19
0
        private void listQuestionStatus(int opt)
        {
            ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
            DataTable dt = new DataTable();
            dt = listQuestionBSO.GetListQuestionStausID(int.Parse(strParam));

            DataView view1 = new DataView(dt);

            string strCate = GetCateParentIDArrayByID();
            if (!string.IsNullOrEmpty(strCate))
            {
                string restr = strCate.Remove(strCate.LastIndexOf(",")).Replace(",", "','");

                view1.RowFilter = "CateNewsID in('" + restr + "')";

                grvListQuestion.DataSource = view1;
                grvListQuestion.DataBind();
            }
        }
コード例 #20
0
        private void listQuestionStatus(int opt, string RolesName_)
        {
            ListQuestionBSO listQuestionBSO = new ListQuestionBSO();
            DataTable dt = new DataTable();
            dt = listQuestionBSO.GetListQuestionStausID(int.Parse(strParam));

            DataView view1 = new DataView(dt);
            string strCate = GetCateParentIDArrayByID();

            AdminBSO adminBSO = new AdminBSO();
            ETO.Admin admin = new ETO.Admin();

            if (RolesName_ == "Guest")
            {
                view1.RowFilter = "CreateUserName ='******'";
                grvListQuestion.Columns[6].Visible = false;
                iconForUser();
            }
            else
                if (!string.IsNullOrEmpty(strCate))
                {
                    string restr = strCate.Remove(strCate.LastIndexOf(",")).Replace(",", "','");

                    if (RolesName_ != "Guest") //
                    {
                        //view1.RowFilter = "CateNewsID in('" + restr + "')";
                        view1.RowFilter = "CateNewsID in('" + restr + "') or CreateUserName ='******'";
                        //grvListQuestion.Columns[6].Visible = false;
                        //iconForUser();
                    }

                }
            //else
            //{
            //    if (RolesName_ == "Guest")
            //    {
            //        view1.RowFilter = "CreateUserName ='******'";
            //        grvListQuestion.Columns[6].Visible = false;
            //        iconForUser();
            //    }
            //}
            grvListQuestion.DataSource = view1;
            grvListQuestion.DataBind();
        }