public FileResult Get(long id) { using (tskmContainer db = new tskmContainer()) { File file = db.Files.Find(id); return new FilePathResult(System.IO.Path.Combine(Server.MapPath("~/App_Data/uploads"), file.fileName), file.ContentType); } }
public static void RefreshCache() { using (tskmContainer db = new tskmContainer()) { if (HttpContext.Current.User != null) { _user = db.Users.SingleOrDefault(x => x.username == HttpContext.Current.User.Identity.Name); if (_user != null) { _user.Roles.ToList(); } } } }
public static Models.File Save(HttpPostedFileBase fileUpload, string targetPath) { using (tskmContainer db = new tskmContainer()) { Models.File file = new Models.File(); file.fileName = Guid.NewGuid().ToString(); file.ContentType = fileUpload.ContentType; fileUpload.SaveAs(Path.Combine(targetPath, file.fileName)); db.Files.Add(file); db.SaveChanges(); return file; } }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); PostAuthenticateRequest += Application_PostAuthenticateRequest; using (tskmContainer db = new tskmContainer()) { if (!db.Catagories.Any()) { db.Catagories.Add(new Catagory { catagoryName = "Hardware" }); db.Catagories.Add(new Catagory { catagoryName = "Software" }); db.Catagories.Add(new Catagory { catagoryName = "Others" }); } if (!db.Roles.Any()) { db.Roles.Add(new Role { Name = "Admin", Description = "ผู้ดูแลระบบ" }); db.Roles.Add(new Role { Name = "IT Manager", Description = "ผู้จัดการแผนก IT" }); db.Roles.Add(new Role { Name = "IT User", Description = "เจ้าหน้าที่ IT" }); db.Roles.Add(new Role { Name = "User", Description = "ผู้ใช้งาน" }); } if (!db.Departments.Any()) { db.Departments.Add(new Department { departmentName = "Admin" }); } if (!db.Status.Any()) { db.Status.Add(new Status { statusName = "Opened" }); db.Status.Add(new Status { statusName = "In Progress" }); db.Status.Add(new Status { statusName = "Waiting for closing" }); db.Status.Add(new Status { statusName = "Closed" }); } db.SaveChanges(); if (!db.Users.Any()) { User user = new User { userFname = "Admin", userLname = "Admin", username = "******", password = "******", userTel = "1111", userEmail = "*****@*****.**", Department = db.Departments.First(), userCode = "1111", userPosition = "Admin" }; user.Roles.Add(db.Roles.Single(x=>x.Name == "Admin")); db.Users.Add(user); } db.SaveChanges(); } }
protected void Application_PostAuthenticateRequest(object serder, EventArgs e) { if (User.Identity.IsAuthenticated) { using (tskmContainer db = new tskmContainer()) { var roles = (from us in db.Users where us.username == User.Identity.Name select us).SingleOrDefault().Roles.Select(x => x.Name); GenericIdentity Identity = new GenericIdentity(User.Identity.Name); GenericPrincipal Principal = new GenericPrincipal(Identity, roles.ToArray()); Context.User = Principal; System.Threading.Thread.CurrentPrincipal = Principal; } } // Udpate CurrentUser CurrentUser.RefreshCache(); }