public JsonResult GetData_Data()
        {
            var nguoidung = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession];

            using (Planner2Entities rrc_db = new Planner2.Models.Planner2Entities())
            {
                string     sql        = @" SELECT  T1.[ID]
      ,[TaskID]
      ,[NOIDUNG]
      ,[HoTen]
      ,[DienThoai]
      ,[DiaChi]
      ,[TieuDe]
      ,[MucDich]
      ,[DateCreate]
  
      ,[Email],t2.TaskName,t2.CreatedBy,t2.SeoUrl
         FROM  [CommentTask] as t1 inner join MainTask as t2 on t1.TaskID=t2.Id 
  where t2.CreatedBy=''  or  1 = " + nguoidung.SupperAdmin + @"
 order by t1.DateCreate desc
 ";
                var        data       = rrc_db.Database.SqlQuery <DsComment>(sql).ToList();
                JsonResult jsonResult = Json(data, JsonRequestBehavior.AllowGet);
                jsonResult.MaxJsonLength = 2147483647;
                return(jsonResult);
            }
        }
Ejemplo n.º 2
0
 public JsonResult GetData_Data()
 {
     using (Planner2Entities rrc_db = new Planner2.Models.Planner2Entities())
     {
         List <Category> data       = rrc_db.Categories.ToList();
         JsonResult      jsonResult = Json(data, JsonRequestBehavior.AllowGet);
         jsonResult.MaxJsonLength = 2147483647;
         return(jsonResult);
     }
 }
Ejemplo n.º 3
0
 public JsonResult GetData_Data()
 {
     using (Planner2Entities rrc_db = new Planner2.Models.Planner2Entities())
     {
         List <Models.SettingData> data = rrc_db.SettingDatas.Where(z => z.Type == "BANNER" || z.Type == "LOGO").ToList();
         JsonResult jsonResult          = Json(data, JsonRequestBehavior.AllowGet);
         jsonResult.MaxJsonLength = 2147483647;
         return(jsonResult);
     }
 }
 public JsonResult GetUserName()
 {
     using (Planner2Entities rrc_db = new Planner2.Models.Planner2Entities())
     {
         var        data       = rrc_db.Users.ToList();
         JsonResult jsonResult = Json(data, JsonRequestBehavior.AllowGet);
         jsonResult.MaxJsonLength = 2147483647;
         return(jsonResult);
     }
 }
Ejemplo n.º 5
0
 public JsonResult GetData_Data()
 {
     using (Planner2Entities rrc_db = new Planner2.Models.Planner2Entities())
     {
         var        nguoidung  = (Planner2.Models.User)Session[Planner2.Controllers.LoginAuth.NameSession];
         var        data       = rrc_db.User_Category.Where(v => (v.UserName + "").ToUpper() == nguoidung.UserName.ToUpper()).ToList();
         JsonResult jsonResult = Json(data, JsonRequestBehavior.AllowGet);
         jsonResult.MaxJsonLength = 2147483647;
         return(jsonResult);
     }
 }
Ejemplo n.º 6
0
 public JsonResult XoaAnh(string ID)
 {
     using (Planner2Entities rrc_db = new Planner2.Models.Planner2Entities())
     {
         var data = rrc_db.SettingDatas.Where(v => v.KeyID == ID).FirstOrDefault();
         data.Value = "";
         rrc_db.SaveChanges();
         MvcApplication.ReloadSetting();
         return(Json("", JsonRequestBehavior.AllowGet));
     }
 }
 protected void Application_Start()
 {
     AreaRegistration.RegisterAllAreas();
     FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
     RouteConfig.RegisterRoutes(RouteTable.Routes);
     BundleConfig.RegisterBundles(BundleTable.Bundles);
     ReloadSetting();
     using (Models.Planner2Entities db = new Models.Planner2Entities())
     {
         Application["Users"]          = db.Users.Where(z => z.Email != null).ToList();
         Common.SettingData.HeaderHTML = db.CustomPages.Where(v => v.NamePage == "HEADER").Select(z => z.ContentPage).FirstOrDefault();
     }
 }
Ejemplo n.º 8
0
 public ActionResult UploadFILEBanner(string BannerID, HttpPostedFileBase File_Banner = null)
 {
     using (Planner2Entities rrc_db = new Planner2.Models.Planner2Entities())
     {
         var file = SubmitFile(new List <HttpPostedFileBase> {
             File_Banner
         });
         var data = rrc_db.SettingDatas.Where(v => v.KeyID == BannerID).FirstOrDefault();
         data.Value = file.FirstOrDefault();
         rrc_db.SaveChanges();
         MvcApplication.ReloadSetting();
         return(RedirectToAction("index"));
     }
 }
 public static void ReloadSetting()
 {
     using (Models.Planner2Entities db = new Models.Planner2Entities())
     {
         Common.SettingData obj = new Common.SettingData();
         foreach (var item in db.SettingDatas)
         {
             PropertyInfo propertyInfo = obj.GetType().GetProperty(item.KeyID, BindingFlags.Public | BindingFlags.Static);
             if (propertyInfo != null)
             {
                 propertyInfo.SetValue(obj, item.Value, null);
             }
             var x = obj.GetType();
         }
     }
 }