private void BindData()
        {
            //try
            //{
            // Load Setting Data
            var objSetting = new CMS.BLL.Setting();
            DataTable dtbSetting = objSetting.Search();
            int nSettingCount = dtbSetting.Rows.Count;
            int nSettingLastestId = ConvertData.ConvertToInt(dtbSetting.Rows[nSettingCount - 1]["SettingID"]);
            objSetting.LoadById(nSettingLastestId);
            txtMetaKeyword.Text = objSetting.Data.MetaKeyword1;
            txtMetaDescription.Text = objSetting.Data.MetaDescription1;

            var objCompany = new Company();
            objCompany.LoadById(1);
            //int nCompanyLastestID = ConvertData.ConvertToInt(dtbCompany.Rows[nCompanyCount - 1]["CompanyID"]);
            //objCompany.LoadById(nCompanyLastestID);

            txtAddress.Text = objCompany.Data.Address;
            txtCompanyName.Text = objCompany.Data.CompanyName;

            txtEmail.Text = objCompany.Data.Email;

            txtFooter.Text = objCompany.Data.Copyright;
            txtHotline.Text = objCompany.Data.Hotline;
            txtTel.Text = objCompany.Data.Tel;
            txtWebsite.Text = objCompany.Data.Website;

            txtYahoo1.Text = objCompany.Data.YahooAccount1;
            txtYahoo2.Text = objCompany.Data.YahooAccount2;
            txtYahoo3.Text = objCompany.Data.YahooAccount3;
            txtYahoo4.Text = objCompany.Data.YahooAccount4;

            txtYahooDescription1.Text = objCompany.Data.YahooDescription1;
            txtYahooDescription2.Text = objCompany.Data.YahooDescription2;
            txtYahooDescription3.Text = objCompany.Data.YahooDescription3;
            txtYahooDescription4.Text = objCompany.Data.YahooDescription4;

            txtSkypeName.Text = objCompany.Data.SkypeDescription1;
            txtUserSkype.Text = objCompany.Data.SkypeAccount1;
            //txtSkype3.Text = objCompany.Data.SkypeAccount3;
            //txtSkype4.Text = objCompany.Data.SkypeAccount4;
            txtGoogleMap.Text = objCompany.Data.GoogleMap;
            txtEmailForward1.Text = objCompany.Data.EmailFwd1;
            txtEmailForward2.Text = objCompany.Data.EmailFwd2;
            //}
            //catch
            //{
            //    string sURL = Constants.ROOT + Pages.BackEnds.ADMIN;
            //    Response.Redirect(sURL);
            //}
        }
        protected void lnkbtSave_Click(object sender, EventArgs e)
        {
            // Updating Setting Data
            var objSetting = new CMS.BLL.Setting();
            DataTable dtbSetting = objSetting.Search();
            int nSettingCount = dtbSetting.Rows.Count;
            int nSettingLastestId = ConvertData.ConvertToInt(dtbSetting.Rows[nSettingCount - 1]["SettingID"]);
            objSetting.Data.MetaKeyword1 = txtMetaKeyword.Text.Trim();
            objSetting.Data.MetaDescription1 = txtMetaDescription.Text.Trim();
            int nSettingResult = objSetting.Update(nSettingLastestId);

            // Updating Company Data
            var objCompany = new Company();
            DataTable dtbCompany = objCompany.Search();
            int nCompanyCount = dtbCompany.Rows.Count;
            int nCompanyLastestId = ConvertData.ConvertToInt(dtbCompany.Rows[nCompanyCount - 1]["CompanyID"]);

            objCompany.Data.Website = txtWebsite.Text.Trim();
            objCompany.Data.Tel = txtTel.Text.Trim();
            objCompany.Data.Hotline = txtHotline.Text.Trim();

            objCompany.Data.Email = txtEmail.Text.Trim();
            objCompany.Data.Copyright = txtFooter.Text.Trim();

            objCompany.Data.YahooAccount1 = txtYahoo1.Text.Trim();
            objCompany.Data.YahooAccount2 = txtYahoo2.Text.Trim();
            objCompany.Data.YahooAccount3 = txtYahoo3.Text.Trim();
            objCompany.Data.YahooAccount4 = txtYahoo4.Text.Trim();

            objCompany.Data.YahooDescription1 = txtYahooDescription1.Text.Trim();
            objCompany.Data.YahooDescription2 = txtYahooDescription2.Text.Trim();
            objCompany.Data.YahooDescription3 = txtYahooDescription3.Text.Trim();
            objCompany.Data.YahooDescription4 = txtYahooDescription4.Text.Trim();

            objCompany.Data.SkypeDescription1 = txtSkypeName.Text.Trim();
            objCompany.Data.SkypeAccount1 = txtUserSkype.Text.Trim();

            objCompany.Data.SkypeAccount3 = string.Empty;  // txtSkype3.Text.Trim();
            objCompany.Data.SkypeAccount4 = string.Empty;  // txtSkype4.Text.Trim();

            objCompany.Data.CompanyName = txtCompanyName.Text.Trim();
            objCompany.Data.Address = txtAddress.Text.Trim();
            objCompany.Data.GoogleMap = txtGoogleMap.Text.Trim();
            objCompany.Data.EmailFwd1 = txtEmailForward1.Text.Trim();
            objCompany.Data.EmailFwd2 = txtEmailForward2.Text.Trim();

            int nCompanyResult = objCompany.Update(nCompanyLastestId);

            int nResult = nCompanyResult * nSettingResult;
            if (nResult > 0)
            {
                MessageBoxss.Show(MessagesAlert.UPDATE_SUCCESSFUL);
                string sUrl = Constants.ROOT + Pages.BackEnds.ADMIN + "?" + Constants.PAGE + "=" + Pages.BackEnds.STR_SETTING + "&" + Constants.MESS_ID + "=" + Constants.MESSAGE_UPDATE;
                Response.Redirect(sUrl);
            }
            else
            {
                MessageBoxss.Show(MessagesAlert.UPDATE_UNSUCCESSFUL);

            }
        }