Example #1
0
        /// <summary>
        /// Method to get one recoder by primary key
        /// </summary>
        public Johnny.CMS.OM.SeH.Website GetModel(int websiteid)
        {
            //Set up a return value
            Johnny.CMS.OM.SeH.Website model = null;

            StringBuilder strSql = new StringBuilder();

            strSql.Append("SELECT [WebsiteId], [WebsiteName], [WebsiteCategoryId], [Description], [URL], [Hits], [IsDisplay], [CreatedTime], [CreatedById], [CreatedByName], [UpdatedTime], [UpdatedById], [UpdatedByName], [Sequence] ");
            strSql.Append(" FROM [seh_website] ");
            strSql.Append(" WHERE [WebsiteId]=@websiteid");
            SqlParameter[] parameters =
            {
                new SqlParameter("@websiteid", SqlDbType.Int, 4)
            };
            parameters[0].Value = websiteid;
            using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters))
            {
                if (sdr.Read())
                {
                    model = new Johnny.CMS.OM.SeH.Website(sdr.GetInt32(0), sdr.GetString(1), sdr.GetInt32(2), sdr.GetString(3), sdr.GetString(4), sdr.GetInt32(5), sdr.GetBoolean(6), sdr.GetDateTime(7), sdr.GetInt32(8), sdr.GetString(9), sdr.GetDateTime(10), sdr.GetInt32(11), sdr.GetString(12), sdr.GetInt32(13));
                }
                else
                {
                    model = new Johnny.CMS.OM.SeH.Website();
                }
            }
            return(model);
        }
Example #2
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            foreach (GridViewRow row in myManageGridView.Rows)
            {
                string strId = ((Label)row.FindControl(STR_LABEL_ID)).Text;
                TextBox updWebsiteName = (TextBox)row.FindControl("txtUptWebsiteName");
                DropDownList updWebsiteCategoryId = (DropDownList)row.FindControl("ddlCategory");

                //check website name
                if (!CheckInputEmptyAndLength(updWebsiteName, "E01301", "E01302", false))
                    return;

                //update
                Johnny.CMS.OM.SeH.Website model = new Johnny.CMS.OM.SeH.Website();
                model.WebsiteId = DataConvert.GetInt32(strId);
                model.WebsiteName = updWebsiteName.Text;
                model.WebsiteCategoryId = DataConvert.GetInt32(updWebsiteCategoryId.SelectedValue);

                Johnny.CMS.BLL.SeH.Website bll = new Johnny.CMS.BLL.SeH.Website();
                bll.Update(model);
            }

            SetMessage(GetMessage("C00003"));

            //update grid
            getData();
        }
Example #3
0
        /// <summary>
        /// Method to get recoders with condition
        /// </summary>
        public IList <Johnny.CMS.OM.SeH.Website> GetListByCategoryId(int categoryid)
        {
            IList <Johnny.CMS.OM.SeH.Website> list = new List <Johnny.CMS.OM.SeH.Website>();

            StringBuilder strSql = new StringBuilder();

            strSql.Append("SELECT [WebsiteId], [WebsiteName], [seh_website].[WebsiteCategoryId],  [seh_websitecategory].[WebsiteCategoryName], [Description], [URL], [Hits], [IsDisplay], [CreatedTime], [CreatedById], [CreatedByName], [UpdatedTime], [UpdatedById], [UpdatedByName], [seh_website].[Sequence] ");
            strSql.Append(" FROM [seh_website] ");
            strSql.Append(" LEFT OUTER JOIN [seh_websitecategory] ");
            strSql.Append(" ON [seh_website].[WebsiteCategoryId] = [seh_websitecategory].[WebsiteCategoryId] ");
            strSql.Append(" WHERE [seh_website].[WebsiteCategoryId]=@categoryid");
            strSql.Append(" ORDER BY [seh_websitecategory].[Sequence], [seh_website].[Sequence]");
            SqlParameter[] parameters =
            {
                new SqlParameter("@categoryid", SqlDbType.Int, 4)
            };
            parameters[0].Value = categoryid;

            using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters))
            {
                while (sdr.Read())
                {
                    Johnny.CMS.OM.SeH.Website item = new Johnny.CMS.OM.SeH.Website(sdr.GetInt32(0), sdr.GetString(1), sdr.GetInt32(2), sdr.GetString(3), sdr.GetString(4), sdr.GetString(5), sdr.GetInt32(6), sdr.GetBoolean(7), sdr.GetDateTime(8), sdr.GetInt32(9), sdr.GetString(10), sdr.GetDateTime(11), sdr.GetInt32(12), sdr.GetString(13), sdr.GetInt32(14));
                    list.Add(item);
                }
            }
            return(list);
        }
Example #4
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            foreach (GridViewRow row in myManageGridView.Rows)
            {
                string       strId                = ((Label)row.FindControl(STR_LABEL_ID)).Text;
                TextBox      updWebsiteName       = (TextBox)row.FindControl("txtUptWebsiteName");
                DropDownList updWebsiteCategoryId = (DropDownList)row.FindControl("ddlCategory");

                //check website name
                if (!CheckInputEmptyAndLength(updWebsiteName, "E01301", "E01302", false))
                {
                    return;
                }

                //update
                Johnny.CMS.OM.SeH.Website model = new Johnny.CMS.OM.SeH.Website();
                model.WebsiteId         = DataConvert.GetInt32(strId);
                model.WebsiteName       = updWebsiteName.Text;
                model.WebsiteCategoryId = DataConvert.GetInt32(updWebsiteCategoryId.SelectedValue);

                Johnny.CMS.BLL.SeH.Website bll = new Johnny.CMS.BLL.SeH.Website();
                bll.Update(model);
            }

            SetMessage(GetMessage("C00003"));

            //update grid
            getData();
        }
Example #5
0
        /// <summary>
        /// Method to get recoders with condition
        /// </summary>    	 
        public IList<Johnny.CMS.OM.SeH.Website> GetList()
        {
            IList<Johnny.CMS.OM.SeH.Website> list = new List<Johnny.CMS.OM.SeH.Website>();

            StringBuilder strSql = new StringBuilder();
            //strSql.Append("SELECT [WebsiteId], [WebsiteName], [WebsiteCategoryId], [Description], [URL], [Hits], [IsDisplay], [CreatedTime], [CreatedById], [CreatedByName], [UpdatedTime], [UpdatedById], [UpdatedByName], [Sequence] ");
            //strSql.Append(" FROM [seh_website] ");
            //strSql.Append(" ORDER BY [Sequence]");

            strSql.Append("SELECT [WebsiteId], [WebsiteName], [seh_website].[WebsiteCategoryId],  [seh_websitecategory].[WebsiteCategoryName], [Description], [URL], [Hits], [IsDisplay], [CreatedTime], [CreatedById], [CreatedByName], [UpdatedTime], [UpdatedById], [UpdatedByName], [seh_website].[Sequence] ");
            strSql.Append(" FROM [seh_website] ");
            strSql.Append(" LEFT OUTER JOIN [seh_websitecategory] ");
            strSql.Append(" ON [seh_website].[WebsiteCategoryId] = [seh_websitecategory].[WebsiteCategoryId] ");
            strSql.Append(" ORDER BY [seh_websitecategory].[Sequence], [seh_website].[Sequence]");

            using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString()))
            {
                while (sdr.Read())
                {
                    Johnny.CMS.OM.SeH.Website item = new Johnny.CMS.OM.SeH.Website(sdr.GetInt32(0), sdr.GetString(1), sdr.GetInt32(2), sdr.GetString(3), sdr.GetString(4), sdr.GetString(5), sdr.GetInt32(6), sdr.GetBoolean(7), sdr.GetDateTime(8), sdr.GetInt32(9), sdr.GetString(10), sdr.GetDateTime(11), sdr.GetInt32(12), sdr.GetString(13), sdr.GetInt32(14));
                    list.Add(item);
                }
            }
            return list;
        }
Example #6
0
        /// <summary>
        /// Add one record
        /// </summary>
        public int Add(Johnny.CMS.OM.SeH.Website model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("DECLARE @Sequence int");
            strSql.Append(" SELECT @Sequence=(max(Sequence)+1) FROM [seh_website]");
            strSql.Append(" if @Sequence is NULL");
            strSql.Append(" Set @Sequence=1");
            strSql.Append("INSERT INTO [seh_website](");
            strSql.Append("[WebsiteName],[WebsiteCategoryId],[Description],[URL],[Hits],[IsDisplay],[CreatedTime], [CreatedById], [CreatedByName], [UpdatedTime], [UpdatedById], [UpdatedByName], [Sequence]");
            strSql.Append(")");
            strSql.Append(" VALUES (");
            strSql.Append("@websitename,@websitecategoryid,@description,@url,@hits,@isdisplay,@createdtime,@createdbyid,@createdbyname,@updatedtime,@updatedbyid,@updatedbyname,@sequence");
            strSql.Append(")");
            strSql.Append(";SELECT @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@websitename",       SqlDbType.NVarChar,   50),
                new SqlParameter("@websitecategoryid", SqlDbType.Int,         4),
                new SqlParameter("@description",       SqlDbType.NVarChar,  100),
                new SqlParameter("@url",               SqlDbType.VarChar,   200),
                new SqlParameter("@hits",              SqlDbType.Int,         4),
                new SqlParameter("@isdisplay",         SqlDbType.Bit),
                new SqlParameter("@createdtime",       SqlDbType.DateTime),
                new SqlParameter("@createdbyid",       SqlDbType.Int,         4),
                new SqlParameter("@createdbyname",     SqlDbType.VarChar,    50),
                new SqlParameter("@updatedtime",       SqlDbType.DateTime),
                new SqlParameter("@updatedbyid",       SqlDbType.Int,         4),
                new SqlParameter("@updatedbyname",     SqlDbType.VarChar, 50)
            };
            parameters[0].Value  = model.WebsiteName;
            parameters[1].Value  = model.WebsiteCategoryId;
            parameters[2].Value  = model.Description;
            parameters[3].Value  = model.URL;
            parameters[4].Value  = model.Hits;
            parameters[5].Value  = model.IsDisplay;
            parameters[6].Value  = model.CreatedTime;
            parameters[7].Value  = model.CreatedById;
            parameters[8].Value  = model.CreatedByName;
            parameters[9].Value  = model.UpdatedTime;
            parameters[10].Value = model.UpdatedById;
            parameters[11].Value = model.UpdatedByName;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(1);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Example #7
0
        /// <summary>
        /// Update one record
        /// </summary>
        public void Update(Johnny.CMS.OM.SeH.Website model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("UPDATE [seh_website] SET ");
            strSql.Append("[WebsiteName]=@websitename,");
            strSql.Append("[WebsiteCategoryId]=@websitecategoryid,");
            strSql.Append("[Description]=@description,");
            strSql.Append("[URL]=@url,");
            strSql.Append("[Hits]=@hits,");
            strSql.Append("[IsDisplay]=@isdisplay,");
            //strSql.Append("[CreatedTime]=@createdtime,");
            //strSql.Append("[CreatedById]=@createdbyid,");
            //strSql.Append("[CreatedByName]=@createdbyname,");
            strSql.Append("[UpdatedTime]=@updatedtime,");
            strSql.Append("[UpdatedById]=@updatedbyid,");
            strSql.Append("[UpdatedByName]=@updatedbyname,");
            strSql.Append(" WHERE [WebsiteId]=@websiteid ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@websiteid",         SqlDbType.Int,         4),
                new SqlParameter("@websitename",       SqlDbType.NVarChar,   50),
                new SqlParameter("@websitecategoryid", SqlDbType.Int,         4),
                new SqlParameter("@description",       SqlDbType.NVarChar,  100),
                new SqlParameter("@url",               SqlDbType.VarChar,   200),
                new SqlParameter("@hits",              SqlDbType.Int,         4),
                new SqlParameter("@isdisplay",         SqlDbType.Bit),
                //new SqlParameter("@createdtime", SqlDbType.DateTime),
                //new SqlParameter("@createdbyid", SqlDbType.Int,4),
                //new SqlParameter("@createdbyname", SqlDbType.VarChar,50),
                new SqlParameter("@updatedtime",       SqlDbType.DateTime),
                new SqlParameter("@updatedbyid",       SqlDbType.Int,         4),
                new SqlParameter("@updatedbyname",     SqlDbType.VarChar,    50),
            };
            parameters[0].Value = model.WebsiteId;
            parameters[1].Value = model.WebsiteName;
            parameters[2].Value = model.WebsiteCategoryId;
            parameters[3].Value = model.Description;
            parameters[4].Value = model.URL;
            parameters[5].Value = model.Hits;
            parameters[6].Value = model.IsDisplay;
            //parameters[7].Value = model.CreatedTime;
            //parameters[8].Value = model.CreatedById;
            //parameters[9].Value = model.CreatedByName;
            parameters[7].Value = model.UpdatedTime;
            parameters[8].Value = model.UpdatedById;
            parameters[9].Value = model.UpdatedByName;

            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
Example #8
0
        protected override void Page_Load(object sender, EventArgs e)
        {
            base.Page_Load(sender, e);

            Johnny.CMS.OM.SeH.Website model = new Johnny.CMS.OM.SeH.Website();
            base.ManageTable = model.TableName;
            base.ManageKey = model.PrimaryKey;
            base.IsDesc = model.IsDesc;

            if (!IsPostBack)
            {
                myManageGridView.Columns[2].HeaderText = GetLabelText("Website_WebsiteCategoryId");
                myManageGridView.Columns[3].HeaderText = GetLabelText("Website_WebsiteName");
                myManageGridView.Columns[4].HeaderText = GetLabelText("Website_Description");
                getData();                
            }
        }
Example #9
0
        protected override void Page_Load(object sender, EventArgs e)
        {
            base.Page_Load(sender, e);

            Johnny.CMS.OM.SeH.Website model = new Johnny.CMS.OM.SeH.Website();
            base.ManageTable = model.TableName;
            base.ManageKey   = model.PrimaryKey;
            base.IsDesc      = model.IsDesc;

            if (!IsPostBack)
            {
                myManageGridView.Columns[2].HeaderText = GetLabelText("Website_WebsiteCategoryId");
                myManageGridView.Columns[3].HeaderText = GetLabelText("Website_WebsiteName");
                myManageGridView.Columns[4].HeaderText = GetLabelText("Website_Description");
                getData();
            }
        }
Example #10
0
        /// <summary>
        /// Method to get recoders with condition
        /// </summary>
        public IList <Johnny.CMS.OM.SeH.Website> GetList(int top)
        {
            IList <Johnny.CMS.OM.SeH.Website> list = new List <Johnny.CMS.OM.SeH.Website>();

            StringBuilder strSql = new StringBuilder();

            strSql.Append(string.Format("SELECT Top {0} [WebsiteId], [WebsiteName], [WebsiteCategoryId], [Description], [URL], [Hits], [IsDisplay], [CreatedTime], [CreatedById], [CreatedByName], [UpdatedTime], [UpdatedById], [UpdatedByName], [Sequence] ", top));
            strSql.Append(" FROM [seh_website] ");
            strSql.Append(" ORDER BY [Sequence] DESC");

            using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString()))
            {
                while (sdr.Read())
                {
                    Johnny.CMS.OM.SeH.Website item = new Johnny.CMS.OM.SeH.Website(sdr.GetInt32(0), sdr.GetString(1), sdr.GetInt32(2), sdr.GetString(3), sdr.GetString(4), sdr.GetInt32(5), sdr.GetBoolean(6), sdr.GetDateTime(7), sdr.GetInt32(8), sdr.GetString(9), sdr.GetDateTime(10), sdr.GetInt32(11), sdr.GetString(12), sdr.GetInt32(13));
                    list.Add(item);
                }
            }
            return(list);
        }
Example #11
0
        /// <summary>
        /// Method to get recoders with condition
        /// </summary>    	 
        public IList<Johnny.CMS.OM.SeH.Website> GetList(int top)
        {
            IList<Johnny.CMS.OM.SeH.Website> list = new List<Johnny.CMS.OM.SeH.Website>();

            StringBuilder strSql = new StringBuilder();

            strSql.Append(string.Format("SELECT Top {0} [WebsiteId], [WebsiteName], [WebsiteCategoryId], [Description], [URL], [Hits], [IsDisplay], [CreatedTime], [CreatedById], [CreatedByName], [UpdatedTime], [UpdatedById], [UpdatedByName], [Sequence] ", top));
            strSql.Append(" FROM [seh_website] ");
            strSql.Append(" ORDER BY [Sequence] DESC");

            using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString()))
            {
                while (sdr.Read())
                {
                    Johnny.CMS.OM.SeH.Website item = new Johnny.CMS.OM.SeH.Website(sdr.GetInt32(0), sdr.GetString(1), sdr.GetInt32(2), sdr.GetString(3), sdr.GetString(4), sdr.GetInt32(5), sdr.GetBoolean(6), sdr.GetDateTime(7), sdr.GetInt32(8), sdr.GetString(9), sdr.GetDateTime(10), sdr.GetInt32(11), sdr.GetString(12), sdr.GetInt32(13));
                    list.Add(item);
                }
            }
            return list;
        }
Example #12
0
        /// <summary>
        /// Method to get one recoder by primary key
        /// </summary>    	 
        public Johnny.CMS.OM.SeH.Website GetModel(int websiteid)
        {
            //Set up a return value
            Johnny.CMS.OM.SeH.Website model = null;

            StringBuilder strSql = new StringBuilder();
            strSql.Append("SELECT [WebsiteId], [WebsiteName], [WebsiteCategoryId], [Description], [URL], [Hits], [IsDisplay], [CreatedTime], [CreatedById], [CreatedByName], [UpdatedTime], [UpdatedById], [UpdatedByName], [Sequence] ");
            strSql.Append(" FROM [seh_website] ");
            strSql.Append(" WHERE [WebsiteId]=@websiteid");
            SqlParameter[] parameters = {
					new SqlParameter("@websiteid", SqlDbType.Int,4)};
            parameters[0].Value = websiteid;
            using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters))
            {
                if (sdr.Read())
                    model = new Johnny.CMS.OM.SeH.Website(sdr.GetInt32(0), sdr.GetString(1), sdr.GetInt32(2), sdr.GetString(3), sdr.GetString(4), sdr.GetInt32(5), sdr.GetBoolean(6), sdr.GetDateTime(7), sdr.GetInt32(8), sdr.GetString(9), sdr.GetDateTime(10), sdr.GetInt32(11), sdr.GetString(12), sdr.GetInt32(13));
                else
                    model = new Johnny.CMS.OM.SeH.Website();
            }
            return model;
        }
Example #13
0
 /// <summary>
 /// Update one record
 /// </summary>
 public void Update(Johnny.CMS.OM.SeH.Website model)
 {
     dal.Update(model);
 }
Example #14
0
 /// <summary>
 /// Add one record
 /// </summary>
 public int Add(Johnny.CMS.OM.SeH.Website model)
 {
     return(dal.Add(model));
 }
Example #15
0
        protected void btnAdd_Click(object sender, System.EventArgs e)
        {
            //check category name
            if (!CheckInputEmptyAndLength(txtWebsiteName, "E01301", "E01302", false))
                return;

            Johnny.CMS.BLL.SeH.Website bll = new Johnny.CMS.BLL.SeH.Website();
            Johnny.CMS.OM.SeH.Website model = new Johnny.CMS.OM.SeH.Website();

            if (Request.QueryString["action"] == "modify")
            {
                //update
                model.WebsiteId = Convert.ToInt32(Request.QueryString["id"]);
                model.WebsiteName = txtWebsiteName.Text;
                model.WebsiteCategoryId = DataConvert.GetInt32(ddlCategory.SelectedValue);
                model.Description = txtDescription.Text;
                model.URL = txtURL.Text;
                model.Hits = DataConvert.GetInt32(txtHits.Text);
                model.UpdatedTime = System.DateTime.Now;
                model.UpdatedById = DataConvert.GetInt32(Session["UserId"]);
                model.UpdatedByName = DataConvert.GetString(Session["UserName"]);

                bll.Update(model);
                SetMessage(GetMessage("C00003"));
            }
            else
            {
                //insert
                model.WebsiteName = txtWebsiteName.Text;
                model.WebsiteCategoryId = DataConvert.GetInt32(ddlCategory.SelectedValue);                
                model.Description = txtDescription.Text;
                model.URL = txtURL.Text;
                model.Hits = DataConvert.GetInt32(txtHits.Text);
                model.IsDisplay = rdbDisplay0.Checked;
                model.CreatedTime = System.DateTime.Now;
                model.CreatedById = DataConvert.GetInt32(Session["UserId"]);
                model.CreatedByName = DataConvert.GetString(Session["UserName"]);
                model.UpdatedTime = System.DateTime.Now;
                model.UpdatedById = DataConvert.GetInt32(Session["UserId"]);
                model.UpdatedByName = DataConvert.GetString(Session["UserName"]);
                                                
                if (bll.Add(model) > 0)
                {
                    SetMessage(GetMessage("C00001"));
                    ddlCategory.SelectedIndex = 0;
                    txtWebsiteName.Text = "";
                    txtDescription.Text = "";
                    txtURL.Text = "";
                    txtHits.Text = "0";
                    rdbDisplay1.Checked = false;
                    lblCreatedTime.Text = "";
                    lblCreatedByName.Text = "";
                    lblUpdatedTime.Text = "";
                    lblUpdatedByName.Text = "";
                }
                else
                    SetMessage(GetMessage("C00002"));
            }
        }
Example #16
0
        protected void btnAdd_Click(object sender, System.EventArgs e)
        {
            //check category name
            if (!CheckInputEmptyAndLength(txtWebsiteName, "E01301", "E01302", false))
            {
                return;
            }

            Johnny.CMS.BLL.SeH.Website bll   = new Johnny.CMS.BLL.SeH.Website();
            Johnny.CMS.OM.SeH.Website  model = new Johnny.CMS.OM.SeH.Website();

            if (Request.QueryString["action"] == "modify")
            {
                //update
                model.WebsiteId         = Convert.ToInt32(Request.QueryString["id"]);
                model.WebsiteName       = txtWebsiteName.Text;
                model.WebsiteCategoryId = DataConvert.GetInt32(ddlCategory.SelectedValue);
                model.Description       = txtDescription.Text;
                model.URL           = txtURL.Text;
                model.Hits          = DataConvert.GetInt32(txtHits.Text);
                model.UpdatedTime   = System.DateTime.Now;
                model.UpdatedById   = DataConvert.GetInt32(Session["UserId"]);
                model.UpdatedByName = DataConvert.GetString(Session["UserName"]);

                bll.Update(model);
                SetMessage(GetMessage("C00003"));
            }
            else
            {
                //insert
                model.WebsiteName       = txtWebsiteName.Text;
                model.WebsiteCategoryId = DataConvert.GetInt32(ddlCategory.SelectedValue);
                model.Description       = txtDescription.Text;
                model.URL           = txtURL.Text;
                model.Hits          = DataConvert.GetInt32(txtHits.Text);
                model.IsDisplay     = rdbDisplay0.Checked;
                model.CreatedTime   = System.DateTime.Now;
                model.CreatedById   = DataConvert.GetInt32(Session["UserId"]);
                model.CreatedByName = DataConvert.GetString(Session["UserName"]);
                model.UpdatedTime   = System.DateTime.Now;
                model.UpdatedById   = DataConvert.GetInt32(Session["UserId"]);
                model.UpdatedByName = DataConvert.GetString(Session["UserName"]);

                if (bll.Add(model) > 0)
                {
                    SetMessage(GetMessage("C00001"));
                    ddlCategory.SelectedIndex = 0;
                    txtWebsiteName.Text       = "";
                    txtDescription.Text       = "";
                    txtURL.Text           = "";
                    txtHits.Text          = "0";
                    rdbDisplay1.Checked   = false;
                    lblCreatedTime.Text   = "";
                    lblCreatedByName.Text = "";
                    lblUpdatedTime.Text   = "";
                    lblUpdatedByName.Text = "";
                }
                else
                {
                    SetMessage(GetMessage("C00002"));
                }
            }
        }
Example #17
0
        protected override void Page_Load(object sender, EventArgs e)
        {
            base.Page_Load(sender, e);

            if (!this.IsPostBack)
            {
                litPageTitle.Text = GetLabelText("Website_Title");
                litWebsiteCategory.Text = GetLabelText("Website_WebsiteCategoryId");
                ddlCategory.ToolTip = GetLabelText("Website_WebsiteCategoryId");
                litWebsiteName.Text = GetLabelText("Website_WebsiteName");
                txtWebsiteName.ToolTip = GetLabelText("Website_WebsiteName");
                litDescription.Text = GetLabelText("Website_Description");
                txtDescription.ToolTip = GetLabelText("Website_Description");
                litURL.Text = GetLabelText("Website_URL");
                txtURL.ToolTip = GetLabelText("Website_URL");
                litHits.Text = GetLabelText("Website_Hits");
                txtHits.ToolTip = GetLabelText("Website_Hits");
                litIsDisplay.Text = GetLabelText("Website_IsDisplay");
                rdbDisplay0.Text = GetLabelText("Common_Yes");
                rdbDisplay1.Text = GetLabelText("Common_No");
                litRdbDisplayTip.Text = GetLabelText("Website_IsDisplay");
                litCreatedTime.Text = GetLabelText("Common_CreatedTime");
                litCreatedByName.Text = GetLabelText("Common_CreatedByName");
                litUpdatedTime.Text = GetLabelText("Common_UpdatedTime");
                litUpdatedByName.Text = GetLabelText("Common_UpdatedByName");

                if (Request.QueryString["action"] == "modify")
                {
                    //get WebsiteId
                    int WebsiteId = Convert.ToInt32(Request.QueryString["id"]);

                    Johnny.CMS.BLL.SeH.Website bll = new Johnny.CMS.BLL.SeH.Website();
                    Johnny.CMS.OM.SeH.Website model = new Johnny.CMS.OM.SeH.Website();
                    model = bll.GetModel(WebsiteId);

                    CreateddlCategory();
                    foreach (ListItem item in ddlCategory.Items)
                    {
                        if (DataConvert.GetInt32(item.Value) == model.WebsiteCategoryId)
                        {
                            item.Selected = true;
                            break;
                        }
                    }
                    txtWebsiteName.Text = model.WebsiteName;
                    txtDescription.Text = model.Description;
                    txtURL.Text = model.URL;
                    txtHits.Text = DataConvert.GetString(model.Hits);
                    if (model.IsDisplay)
                        rdbDisplay0.Checked = true;
                    else
                        rdbDisplay1.Checked = true;

                    lblCreatedTime.Text = DataConvert.GetLongDateString(model.CreatedTime);
                    lblCreatedByName.Text = model.CreatedByName;
                    lblUpdatedTime.Text = DataConvert.GetLongDateString(model.UpdatedTime);
                    lblUpdatedByName.Text = model.UpdatedByName;

                    btnAdd.ButtonType = Johnny.Controls.Web.Button.Button.EnumButtonType.Save;
                    //btnAdd.Text = CONST_BUTTONTEXT_SAVE;
                }
                else
                {
                    CreateddlCategory();
                    rdbDisplay0.Checked = true;
                    txtHits.Text = "0";
                }

                //RFVldtPermissionName.ErrorMessage = GetMessage("E01301", txtPermissionName.MaxLength.ToString());
            }
        }
Example #18
0
        protected override void Page_Load(object sender, EventArgs e)
        {
            base.Page_Load(sender, e);

            if (!this.IsPostBack)
            {
                litPageTitle.Text       = GetLabelText("Website_Title");
                litWebsiteCategory.Text = GetLabelText("Website_WebsiteCategoryId");
                ddlCategory.ToolTip     = GetLabelText("Website_WebsiteCategoryId");
                litWebsiteName.Text     = GetLabelText("Website_WebsiteName");
                txtWebsiteName.ToolTip  = GetLabelText("Website_WebsiteName");
                litDescription.Text     = GetLabelText("Website_Description");
                txtDescription.ToolTip  = GetLabelText("Website_Description");
                litURL.Text             = GetLabelText("Website_URL");
                txtURL.ToolTip          = GetLabelText("Website_URL");
                litHits.Text            = GetLabelText("Website_Hits");
                txtHits.ToolTip         = GetLabelText("Website_Hits");
                litIsDisplay.Text       = GetLabelText("Website_IsDisplay");
                rdbDisplay0.Text        = GetLabelText("Common_Yes");
                rdbDisplay1.Text        = GetLabelText("Common_No");
                litRdbDisplayTip.Text   = GetLabelText("Website_IsDisplay");
                litCreatedTime.Text     = GetLabelText("Common_CreatedTime");
                litCreatedByName.Text   = GetLabelText("Common_CreatedByName");
                litUpdatedTime.Text     = GetLabelText("Common_UpdatedTime");
                litUpdatedByName.Text   = GetLabelText("Common_UpdatedByName");

                if (Request.QueryString["action"] == "modify")
                {
                    //get WebsiteId
                    int WebsiteId = Convert.ToInt32(Request.QueryString["id"]);

                    Johnny.CMS.BLL.SeH.Website bll   = new Johnny.CMS.BLL.SeH.Website();
                    Johnny.CMS.OM.SeH.Website  model = new Johnny.CMS.OM.SeH.Website();
                    model = bll.GetModel(WebsiteId);

                    CreateddlCategory();
                    foreach (ListItem item in ddlCategory.Items)
                    {
                        if (DataConvert.GetInt32(item.Value) == model.WebsiteCategoryId)
                        {
                            item.Selected = true;
                            break;
                        }
                    }
                    txtWebsiteName.Text = model.WebsiteName;
                    txtDescription.Text = model.Description;
                    txtURL.Text         = model.URL;
                    txtHits.Text        = DataConvert.GetString(model.Hits);
                    if (model.IsDisplay)
                    {
                        rdbDisplay0.Checked = true;
                    }
                    else
                    {
                        rdbDisplay1.Checked = true;
                    }

                    lblCreatedTime.Text   = DataConvert.GetLongDateString(model.CreatedTime);
                    lblCreatedByName.Text = model.CreatedByName;
                    lblUpdatedTime.Text   = DataConvert.GetLongDateString(model.UpdatedTime);
                    lblUpdatedByName.Text = model.UpdatedByName;

                    btnAdd.ButtonType = Johnny.Controls.Web.Button.Button.EnumButtonType.Save;
                    //btnAdd.Text = CONST_BUTTONTEXT_SAVE;
                }
                else
                {
                    CreateddlCategory();
                    rdbDisplay0.Checked = true;
                    txtHits.Text        = "0";
                }

                //RFVldtPermissionName.ErrorMessage = GetMessage("E01301", txtPermissionName.MaxLength.ToString());
            }
        }