/// <summary>
        /// Gets the content.
        /// </summary>
        /// <param name="name">The name.</param>
        /// <returns>Gets the content</returns>
        public string GetContent(string name)
        {
            using (var data = new Entities())
            {
                try
                {
                    C_WebInfo c_gen = null;
                    //// First, check the cache
                    ////C_WebInfo c_gen = Cache.Get(name) as C_WebInfo;

                    if (c_gen == null)
                    {
                        c_gen = data.C_WebInfo.Where(p => p.GeneralName == name).FirstOrDefault();

                        ////if (c_gen != null)
                        ////{
                        ////    //// Put this data into the cache for 10 minutes
                        ////    Cache.Set(name, c_gen, int.Parse(Util.getConfigValue(CommonGlobal.TIME_CACHE, "0")));
                        ////}
                    }

                    return(c_gen.GeneralContent);
                }
                catch (Exception)
                {
                    return(string.Empty);
                }
            }
        }
        /// <summary>
        /// Updates the specified it.
        /// </summary>
        /// <param name="webInformation">web Information.</param>
        /// <returns>Updates the specified</returns>
        public bool Update(C_WebInfo webInformation)
        {
            using (var data = new Entities())
            {
                bool rt;
                try
                {
                    data.f_WebInfo_Update(webInformation.GeneralName, webInformation.GeneralContent, webInformation.Datemodified);
                    data.SaveChanges();
                    rt = true;
                }
                catch (Exception)
                {
                    rt = false;
                }

                return(rt);
            }
        }
        /// <summary>
        /// Adds the specified it.
        /// </summary>
        /// <param name="webInformation">web Information.</param>
        /// <returns>Add Cache</returns>
        public bool Add(C_WebInfo webInformation)
        {
            using (var data = new Entities())
            {
                bool rt;
                try
                {
                    data.C_WebInfo.Add(webInformation);
                    data.SaveChanges();

                    rt = true;
                }
                catch (Exception)
                {
                    rt = false;
                }

                return(rt);
            }
        }
        /// <summary>
        /// Edits the specified it.
        /// </summary>
        /// <param name="webInformation">web Information.</param>
        /// <returns>Edit Cache</returns>
        public bool Edit(C_WebInfo webInformation)
        {
            using (var data = new Entities())
            {
                bool rt;
                try
                {
                    var c_gen = data.C_WebInfo.Where(p => p.GeneralID == webInformation.GeneralID).FirstOrDefault();
                    c_gen.GeneralName    = webInformation.GeneralName;
                    c_gen.GeneralContent = webInformation.GeneralContent;
                    c_gen.Datemodified   = webInformation.Datemodified;
                    data.SaveChanges();

                    rt = true;
                }
                catch (Exception)
                {
                    rt = false;
                }

                return(rt);
            }
        }
        public ActionResult System_email(FormCollection collection)
        {
            WebInfoModels webInfoModels = new WebInfoModels();
            var           email_view    = new Web.Areas.Admin.ViewModels.Email_view();

            this.TryUpdateModel(email_view);

            ////action
            email_view.Parent_action     = HttpContext.Request.RequestContext.RouteData.Values["action"].ToString();
            email_view.Parent_controller = HttpContext.Request.RequestContext.RouteData.Values["controller"].ToString();
            ////end action

            ////Link tab
            StringBuilder sb = new StringBuilder();

            sb.Append("<li><a href=\"" + Url.Action("index", "dashboard", new { act = "system_config", ctrl = "adminGeneral", type_act = CommonGlobal.Edit }) + "\"><span>Cấu hình chung</span></a></li>");
            sb.Append("<li class=\"active\"><a href=\"#\"><span>Cấu hình email</span></a></li>");
            sb.Append("<li><a href=\"" + Url.Action("index", "dashboard", new { act = "footer", ctrl = "adminGeneral", type_act = CommonGlobal.Edit }) + "\"><span>Footer</span></a></li>");
            email_view.Html_link_tab = sb.ToString();

            if (string.IsNullOrEmpty(email_view.SmtpHost))
            {
                email_view.Message = "Bạn cần nhập Smtp Host";
                return(this.PartialView("../control/system_email", email_view));
            }

            if (string.IsNullOrEmpty(email_view.SmtpPort))
            {
                email_view.Message = "Bạn cần nhập Smtp Port";
                return(this.PartialView("../control/system_email", email_view));
            }

            if (string.IsNullOrEmpty(email_view.SmtpUser))
            {
                email_view.Message = "Bạn cần nhập Smtp User";
                return(this.PartialView("../control/system_email", email_view));
            }

            if (string.IsNullOrEmpty(email_view.SmtpPass))
            {
                email_view.Message = "Bạn cần nhập Smtp Pass";
                return(this.PartialView("../control/system_email", email_view));
            }

            if (string.IsNullOrEmpty(email_view.Email))
            {
                email_view.Message = "Bạn cần nhập Email";
                return(this.PartialView("../control/system_email", email_view));
            }

            try
            {
                if (email_view.Type_act == CommonGlobal.Edit)
                {
                    ////SMTP Host
                    C_WebInfo objSMTPHost = new C_WebInfo();
                    objSMTPHost.GeneralName    = CommonGlobal.SmtpHost;
                    objSMTPHost.GeneralContent = email_view.SmtpHost;
                    objSMTPHost.Datemodified   = DateTime.Now;
                    webInfoModels.Update(objSMTPHost);

                    ////SMTP Port
                    C_WebInfo objSMTPPort = new C_WebInfo();
                    objSMTPPort.GeneralName    = CommonGlobal.SmtpPort;
                    objSMTPPort.GeneralContent = email_view.SmtpPort;
                    objSMTPPort.Datemodified   = DateTime.Now;
                    webInfoModels.Update(objSMTPPort);

                    ////SMTP User
                    C_WebInfo objSMTPUser = new C_WebInfo();
                    objSMTPUser.GeneralName    = CommonGlobal.SmtpUser;
                    objSMTPUser.GeneralContent = email_view.SmtpUser;
                    objSMTPUser.Datemodified   = DateTime.Now;
                    webInfoModels.Update(objSMTPUser);

                    ////SMTP Pass
                    C_WebInfo objSMTPPass = new C_WebInfo();
                    objSMTPPass.GeneralName    = CommonGlobal.SmtpPass;
                    objSMTPPass.GeneralContent = email_view.SmtpPass;
                    objSMTPPass.Datemodified   = DateTime.Now;
                    webInfoModels.Update(objSMTPPass);

                    ////Email
                    C_WebInfo objEmail = new C_WebInfo();
                    objEmail.GeneralName    = CommonGlobal.Email;
                    objEmail.GeneralContent = email_view.Email;
                    objEmail.Datemodified   = DateTime.Now;
                    webInfoModels.Update(objEmail);
                }
            }
            catch (Exception)
            {
                email_view.Message = "Đã xảy ra lỗi cập nhật dữ liệu.";
            }

            email_view.Message = "Cập nhật thành công.";

            return(this.PartialView("../control/system_email", email_view));
        }
        public ActionResult System_config(FormCollection collection, string lang, string act, string ctrl, string type_act, string type, HttpPostedFileBase file_img)
        {
            var           system_config_view = new Web.Areas.Admin.ViewModels.System_config_view();
            GeneralModels generalModel       = new GeneralModels();
            WebInfoModels webInfoModels      = new WebInfoModels();

            this.TryUpdateModel(system_config_view);

            if (string.IsNullOrEmpty(lang))
            {
                lang = LanguageModels.ActiveLanguage().LangCultureName;
            }

            if (string.IsNullOrEmpty(act))
            {
                act = Request.QueryString["act"] != null ? Request.QueryString["act"].ToString() : "system_config";
            }

            if (string.IsNullOrEmpty(ctrl))
            {
                ctrl = Request.QueryString["ctrl"] != null ? Request.QueryString["ctrl"].ToString() : "adminGeneral";
            }

            if (string.IsNullOrEmpty(type_act))
            {
                type_act = Request.QueryString["type_act"] != null ? Request.QueryString["type_act"].ToString() : CommonGlobal.Edit;
            }

            system_config_view.Type_act = type_act;

            ////Update data
            if (system_config_view.Is_update > 0 && system_config_view.Type_act == CommonGlobal.Edit)
            {
                ////Pagename
                C_General pagename = new C_General();
                pagename.GeneralName    = CommonGlobal.PageName;
                pagename.GeneralContent = system_config_view.Page_name;
                pagename.Show           = true;
                pagename.Lang           = system_config_view.Lang;
                pagename.Datemodified   = DateTime.Now;
                generalModel.Update(pagename);

                ////Keyword
                C_General keyword = new C_General();
                keyword.GeneralName    = CommonGlobal.Keyword;
                keyword.GeneralContent = system_config_view.Keywords;
                keyword.Show           = true;
                keyword.Lang           = system_config_view.Lang;
                keyword.Datemodified   = DateTime.Now;
                generalModel.Update(keyword);

                ////Description
                C_General description = new C_General();
                description.GeneralName    = CommonGlobal.Description;
                description.GeneralContent = system_config_view.Description;
                description.Show           = true;
                description.Lang           = system_config_view.Lang;
                description.Datemodified   = DateTime.Now;
                generalModel.Update(description);

                ////Support
                C_General support = new C_General();
                support.GeneralName    = CommonGlobal.Support;
                support.GeneralContent = system_config_view.Support;
                support.Show           = true;
                support.Lang           = system_config_view.Lang;
                support.Datemodified   = DateTime.Now;
                generalModel.Update(support);

                ////Address
                C_General address = new C_General();
                address.GeneralName    = CommonGlobal.Address;
                address.GeneralContent = system_config_view.Address;
                address.Show           = true;
                address.Lang           = system_config_view.Lang;
                address.Datemodified   = DateTime.Now;
                generalModel.Update(address);

                ////Hotline
                C_WebInfo hotline = new C_WebInfo();
                hotline.GeneralName    = CommonGlobal.Hotline;
                hotline.GeneralContent = system_config_view.Hotline;
                hotline.Datemodified   = DateTime.Now;
                webInfoModels.Update(hotline);

                ////Skyper
                C_WebInfo skyper = new C_WebInfo();
                skyper.GeneralName    = CommonGlobal.Skyper;
                skyper.GeneralContent = system_config_view.Skype;
                skyper.Datemodified   = DateTime.Now;
                webInfoModels.Update(skyper);

                ////Slogan
                C_General slogan = new C_General();
                slogan.GeneralName    = CommonGlobal.Slogan;
                slogan.GeneralContent = system_config_view.Slogan;
                slogan.Show           = true;
                slogan.Datemodified   = DateTime.Now;
                slogan.Lang           = system_config_view.Lang;
                generalModel.Update(slogan);

                ////facebook
                C_WebInfo facebook = new C_WebInfo();
                facebook.GeneralName    = CommonGlobal.Facebook;
                facebook.GeneralContent = system_config_view.Facebook;
                facebook.Datemodified   = DateTime.Now;
                webInfoModels.Update(facebook);

                ////Fees
                C_WebInfo fees = new C_WebInfo();
                fees.GeneralName    = CommonGlobal.Fees;
                fees.GeneralContent = system_config_view.Fees;
                fees.Datemodified   = DateTime.Now;
                webInfoModels.Update(fees);

                ////Fees
                C_WebInfo min_fees = new C_WebInfo();
                min_fees.GeneralName    = CommonGlobal.MinFees;
                min_fees.GeneralContent = system_config_view.Min_fees;
                min_fees.Datemodified   = DateTime.Now;
                webInfoModels.Update(min_fees);

                ////Fees
                C_WebInfo tax = new C_WebInfo();
                tax.GeneralName    = CommonGlobal.Tax;
                tax.GeneralContent = system_config_view.Tax;
                tax.Datemodified   = DateTime.Now;
                webInfoModels.Update(tax);

                ////google_analysis
                C_WebInfo google_analysis = new C_WebInfo();
                google_analysis.GeneralName    = CommonGlobal.GoogleAnalysis;
                google_analysis.GeneralContent = system_config_view.Google_analysis;
                google_analysis.Datemodified   = DateTime.Now;
                webInfoModels.Update(google_analysis);

                ////app_extend_one
                C_WebInfo app_extend_one = new C_WebInfo();
                app_extend_one.GeneralName    = CommonGlobal.AppExtendOne;
                app_extend_one.GeneralContent = system_config_view.App_extend_one;
                app_extend_one.Datemodified   = DateTime.Now;
                webInfoModels.Update(app_extend_one);

                ////app_extend_two
                C_WebInfo app_extend_two = new C_WebInfo();
                app_extend_two.GeneralName    = CommonGlobal.AppExtendTwo;
                app_extend_two.GeneralContent = system_config_view.App_extend_two;
                app_extend_two.Datemodified   = DateTime.Now;
                webInfoModels.Update(app_extend_two);

                ////latitude
                C_WebInfo latitude = new C_WebInfo();
                latitude.GeneralName    = CommonGlobal.Latitude;
                latitude.GeneralContent = system_config_view.Latitude;
                latitude.Datemodified   = DateTime.Now;
                webInfoModels.Update(latitude);

                ////latitude
                C_WebInfo longitude = new C_WebInfo();
                longitude.GeneralName    = CommonGlobal.Longitude;
                longitude.GeneralContent = system_config_view.Longitude;
                longitude.Datemodified   = DateTime.Now;
                webInfoModels.Update(longitude);

                ////image
                C_WebInfo imgmap = new C_WebInfo();
                imgmap.GeneralName = CommonGlobal.ImageMap;
                //// imgmap. = system_config_view.imgmap;
                imgmap.Datemodified = DateTime.Now;

                var imgPathTemp = "images/icon/"; ////+ DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString() + "/";
                var name_time   = DateTime.Now.Day + DateTime.Now.Month + DateTime.Now.Year + DateTime.Now.Hour + DateTime.Now.Minute + string.Empty;
                if (file_img != null && file_img.ContentLength > 0 && CommonGlobal.IsImage(file_img) == true)
                {
                    string image_name = imgPathTemp + "sc_original_" + name_time + "_" + CommonGlobal.CompleteNamefileImages(file_img.FileName);

                    ////save image and delete old file
                    this.SavephotoOriginal(imgmap.GeneralContent, file_img, imgPathTemp, image_name);

                    ////set image thumb to link catalog
                    imgmap.GeneralContent        = "/" + image_name;
                    system_config_view.Image_map = "/" + image_name;
                }
                else if (string.IsNullOrEmpty(imgmap.GeneralContent))
                {
                    imgmap.GeneralContent = "0";
                }
                else
                {
                    imgmap.GeneralContent = system_config_view.Image_map;
                }

                webInfoModels.Update(imgmap);

                system_config_view.Message = "Cập nhật thành công.";
            }

            ////list language
            system_config_view.List_language = this.List_select_language(lang);
            try
            {
                ////General
                system_config_view.Page_name   = GeneralModels.GetContent(CommonGlobal.PageName, lang);
                system_config_view.Keywords    = GeneralModels.GetContent(CommonGlobal.Keyword, lang);
                system_config_view.Description = GeneralModels.GetContent(CommonGlobal.Description, lang);
                system_config_view.Support     = GeneralModels.GetContent(CommonGlobal.Support, lang);
                system_config_view.Address     = GeneralModels.GetContent(CommonGlobal.Address, lang);
                system_config_view.Slogan      = GeneralModels.GetContent(CommonGlobal.Slogan, lang);
                ////webinfo
                system_config_view.Hotline         = webInfoModels.GetContent(CommonGlobal.Hotline);
                system_config_view.Facebook        = webInfoModels.GetContent(CommonGlobal.Facebook);
                system_config_view.Skype           = webInfoModels.GetContent(CommonGlobal.Skyper);
                system_config_view.Fees            = webInfoModels.GetContent(CommonGlobal.Fees);
                system_config_view.Min_fees        = webInfoModels.GetContent(CommonGlobal.MinFees);
                system_config_view.Tax             = webInfoModels.GetContent(CommonGlobal.Tax);
                system_config_view.Google_analysis = webInfoModels.GetContent(CommonGlobal.GoogleAnalysis);
                system_config_view.App_extend_one  = webInfoModels.GetContent(CommonGlobal.AppExtendOne);
                system_config_view.App_extend_two  = webInfoModels.GetContent(CommonGlobal.AppExtendTwo);
                system_config_view.Latitude        = webInfoModels.GetContent(CommonGlobal.Latitude);
                system_config_view.Longitude       = webInfoModels.GetContent(CommonGlobal.Longitude);
                system_config_view.Image_map       = webInfoModels.GetContent(CommonGlobal.ImageMap);
            }
            catch (Exception)
            {
                system_config_view.Message = "Đã xảy ra lỗi trong quá trình lấy dữ liệu.";
            }

            ////Link tab
            StringBuilder sb = new StringBuilder();

            sb.Append("<li class=\"active\"><a href=\"#\"><span>Cấu hình chung</span></a></li>");
            sb.Append("<li><a href=\"" + Url.Action("index", "dashboard", new { act = "system_email", ctrl = "adminGeneral", type_act = CommonGlobal.Edit }) + "\"><span>Cấu hình email</span></a></li>");
            sb.Append("<li><a href=\"" + Url.Action("index", "dashboard", new { act = "footer", ctrl = "adminGeneral", type_act = CommonGlobal.Edit }) + "\"><span>Footer</span></a></li>");

            system_config_view.Html_link_tab = sb.ToString();
            system_config_view.Type_act      = type_act;
            system_config_view.Type          = type;
            ////action
            system_config_view.Act               = act;
            system_config_view.Ctrl              = ctrl;
            system_config_view.Parent_action     = HttpContext.Request.RequestContext.RouteData.Values["action"].ToString();
            system_config_view.Parent_controller = HttpContext.Request.RequestContext.RouteData.Values["controller"].ToString();
            ////end action

            return(this.PartialView("../control/system_config", system_config_view));
        }