public ActionResult Edit(int id) { MyAppEntities myAppEntities = new MyAppEntities(); var model = myAppEntities.Users.Where(a => a.id == id).FirstOrDefault(); return(View("~/Views/appdashboard/adminsystem/User/Edit.cshtml", model)); }
public ActionResult Edit(int id) { MyAppEntities myAppEntities = new MyAppEntities(); var model = myAppEntities.Groups.Where(a => a.id == id).FirstOrDefault(); return(View("~/Views/appdashboard/masterdata/Group/Edit.cshtml", model)); }
public ActionResult Index() { MyAppEntities myAppEntities = new MyAppEntities(); var model = myAppEntities.Users.ToList(); return(View("~/Views/appdashboard/adminsystem/User/Index.cshtml", model)); }
public String Edit(int iduser, int id, FormCollection collection) { try { TryUpdateModel(collection); using (var myAppEntities = new MyAppEntities()) { var key = collection.GetValue("key").AttemptedValue; var val = collection.GetValue("val").AttemptedValue; if (myAppEntities.UserRole.Where(a => a.id_role == id).Where(a => a.id_user == iduser).Count() > 0) { string query = "update UserRole set " + key + " = '" + val + "' where id_role = '" + id + "' and id_user = '******' "; myAppEntities.UserRole.SqlQuery(query).FirstOrDefault(); } else { string query = "insert UserRole (" + key + ",id_role,id_user) values ('" + val + "','" + id + "','" + iduser + "')"; myAppEntities.UserRole.SqlQuery(query).FirstOrDefault(); } } return("Success"); } catch (Exception e) { return(e.Message); } }
//[HttpPost] //[ValidateAntiForgeryToken] public String Edit(int iduser, int id, FormCollection collection) { try { TryUpdateModel(collection); using (var myAppEntities = new MyAppEntities()) { Int64 is_checked = Convert.ToInt64(collection.GetValue("is_checked").AttemptedValue); if (is_checked == 0) { string query = "delete from UserGroupLevel where id_user = '******' and id_group_level = '" + id + "'"; myAppEntities.UserGroupLevel.SqlQuery(query).FirstOrDefault(); } else { string query = "delete from UserGroupLevel where id_user = '******' and id_group_level = '" + id + "';insert into UserGroupLevel (id_user,id_group_level) values('" + iduser + "','" + id + "');"; myAppEntities.RoleGroupLevel.SqlQuery(query).FirstOrDefault(); } } return("Success"); } catch (Exception e) { return(e.Message); } }
public MyAppApiResult <MemberShip> Regist(MemberShip user) { var res = new MyAppApiResult <MemberShip>(); try { using (var db = new MyAppEntities()) { #region if (db.MemberShip.Any(o => o.LoginName == user.LoginName)) { res.AddError("用户已存在"); return(res); } #endregion user.Id = Guid.NewGuid(); db.MemberShip.Add(user); db.SaveChanges(); res.Data = user; } } catch (Exception e) { res.AddError(e.Message); } return(res); }
public ActionResult Delete(int id) { MyAppEntities myAppEntities = new MyAppEntities(); var model = myAppEntities.Roles.Where(a => a.id == id).FirstOrDefault(); return(View("~/Views/appdashboard/masterdata/Role/Delete.cshtml", model)); }
public ActionResult Edit(int id, FormCollection collection) { try { TryUpdateModel(collection); using (var myAppEntities = new MyAppEntities()) { if (collection.AllKeys.Contains("key")) { var key = collection.GetValue("key").AttemptedValue; var val = collection.GetValue("val").AttemptedValue; string query = "update Roles set " + key + " = '" + val + "' where id = '" + id + "'"; myAppEntities.UserRole.SqlQuery(query).FirstOrDefault(); } else { var m = myAppEntities.Roles.Where(a => a.id == id).FirstOrDefault(); TryUpdateModel(m); myAppEntities.SaveChanges(); } } return(RedirectToAction("Index")); } catch { MyAppEntities myAppEntities = new MyAppEntities(); var model = myAppEntities.Roles.Where(a => a.id == id).FirstOrDefault(); return(View("~/Views/appdashboard/masterdata/Role/Edit.cshtml", model)); } }
public ActionResult Index() { MyAppEntities myAppEntities = new MyAppEntities(); var model = myAppEntities.Groups.ToList(); return(View("~/Views/appdashboard/masterdata/Group/Index.cshtml", model)); }
public MyAppApiResult <bool> AddArticle(MyApp_Article article) { var result = new MyAppApiResult <bool>(); try { #region if (String.IsNullOrEmpty(article.AritcleName) || String.IsNullOrEmpty(article.SimpleText) || article.Type == null) { result.AddError("数据不全,请确认后提交"); return(result); } #endregion var db = new MyAppEntities(); article.Id = Guid.NewGuid(); article.WriteTime = DateTime.Now; article.AritcleAuthorId = Guid.NewGuid(); db.MyApp_Article.Add(article); db.SaveChanges(); } catch (Exception e) { result.AddError(e.Message); } return(result); }
public MyAppApiResult <MyApp_Article> GetArticalById(Guid Id, MemberShip CurrentUser) { var result = new MyAppApiResult <MyApp_Article>(); try { using (var db = new MyAppEntities()) { result.Data = db.MyApp_Article.FirstOrDefault(o => o.Id == Id); if (!db.MyApp_LookLog.Any(o => o.MemberShipId == CurrentUser.Id && o.ArticleId == Id)) { db.MyApp_LookLog.Add(new MyApp_LookLog() { Id = Guid.NewGuid(), MemberShipId = CurrentUser.Id, ArticleId = Id }); } db.SaveChanges(); } } catch (Exception e) { } return(result); }
public ActionResult Index() { MyAppEntities myAppEntities = new MyAppEntities(); var model = myAppEntities.Roles.OrderBy(a => a.url).ToList(); return(View("~/Views/appdashboard/masterdata/Role/Index.cshtml", model)); }
public ActionResult Index() { ViewBag.Message = "Dashboard"; MyAppEntities myAppEntities = new MyAppEntities(); var menu = myAppEntities.MenuApp.Where(a => a.IDParentMenu == null).OrderBy(a => a.OrderSort).ToList(); Session["Menu"] = menu; return(View("~/Views/appdashboard/Index.cshtml")); }
protected override bool AuthorizeCore(HttpContextBase httpContext) { var isAuthorized = base.AuthorizeCore(httpContext); if (!isAuthorized) { return(false); } var myAppEntities = new MyAppEntities(); var userRoles = new UserRole(); var rd = httpContext.Request.RequestContext.RouteData; if (Access == null) { Access = rd.GetRequiredString("action"); } string controllerName = rd.GetRequiredString("controller"); var UserID = MyAppHelper.GetUserIdentityValue(httpContext.User, ClaimTypes.NameIdentifier); var access = myAppEntities.UserRole.Where(a => a.Users.userid == UserID).Where(a => a.Roles.controller == controllerName).FirstOrDefault(); httpContext.Items["Access"] = access; if (Access == AuthorizeUserType.View || Access == "Details") { return(access.allow_view); } else if (Access == AuthorizeUserType.Add) { return(access.allow_add); } else if (Access == AuthorizeUserType.Edit) { return(access.allow_edit); } else if (Access == AuthorizeUserType.Delete) { return(access.allow_delete); } else if (Access == AuthorizeUserType.Print) { return(access.allow_print); } else if (Access == AuthorizeUserType.Custom) { return(access.allow_custom); } else { return(false); } }
// GET: Login public ActionResult Login(Users user) { if (AuthenticationManager.User.Identity.IsAuthenticated) { return(RedirectToAction("Index", "Home")); } if (user.userid == null) { return(View()); } MyAppEntities myAppEntities = new MyAppEntities(); var pass = MyAppHelper.GetHashMD5(user.password); var usr = myAppEntities.Users.Where(a => a.userid == user.userid).FirstOrDefault(); if (usr != null) { bool verify = false; try{ verify = BCrypt.Net.BCrypt.Verify(user.password, usr.password); } catch { verify = MyAppHelper.GetHashMD5(user.password) == user.password; } if (verify) { var claims = new List <Claim>(); claims.Add(new Claim(ClaimTypes.NameIdentifier, usr.userid)); claims.Add(new Claim(ClaimTypes.Name, usr.name)); claims.Add(new Claim(ClaimTypes.Email, usr.email)); var identity = new ClaimsIdentity(claims, DefaultAuthenticationTypes.ApplicationCookie); AuthenticationManager.SignIn(new AuthenticationProperties() { AllowRefresh = true, IsPersistent = false, ExpiresUtc = DateTime.UtcNow.AddDays(7) }, identity); return(RedirectToAction("Index", "Home")); } else { TempData["Message"] = "Login Failed, Password wrong!"; return(View()); } } else { TempData["Message"] = "Login Failed, Email not found!"; return(View()); } }
public List <v_ArticleList> getArticalListByType(int type) { var result = new List <v_ArticleList>(); try { using (var db = new MyAppEntities()) { result = db.v_ArticleList.Where(o => o.Type == type).OrderByDescending(o => o.WriteTime).ToList(); } } catch (Exception e) { } return(result); }
public ActionResult Create(Roles collection) { try { TryUpdateModel(collection); using (var myAppEntities = new MyAppEntities()) { myAppEntities.Roles.Add(collection); myAppEntities.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View("~/Views/appdashboard/masterdata/Role/Add.cshtml")); } }
public ActionResult Create(Users collection) { try { collection.password = BCrypt.Net.BCrypt.HashPassword(collection.password); TryUpdateModel(collection); using (var myAppEntities = new MyAppEntities()) { myAppEntities.Users.Add(collection); myAppEntities.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View("~/Views/appdashboard/adminsystem/User/Add.cshtml")); } }
public ActionResult Edit(int id, Groups collection) { try { TryUpdateModel(collection); using (var myAppEntities = new MyAppEntities()) { var m = myAppEntities.Groups.Where(a => a.id == id).FirstOrDefault(); TryUpdateModel(m); myAppEntities.SaveChanges(); } return(RedirectToAction("Index")); } catch { MyAppEntities myAppEntities = new MyAppEntities(); var model = myAppEntities.Groups.Where(a => a.id == id).FirstOrDefault(); return(View("~/Views/appdashboard/masterdata/Group/Edit.cshtml", model)); } }
public ActionResult Delete(int id, FormCollection collection) { try { TryUpdateModel(collection); using (var myAppEntities = new MyAppEntities()) { var m = myAppEntities.Roles.Remove(myAppEntities.Roles.FirstOrDefault(x => x.id == id)); TryUpdateModel(m); myAppEntities.SaveChanges(); } return(RedirectToAction("Index")); } catch { MyAppEntities myAppEntities = new MyAppEntities(); var model = myAppEntities.Roles.Where(a => a.id == id).FirstOrDefault(); return(View("~/Views/appdashboard/masterdata/Role/Delete.cshtml", model)); } }
public List <v_ArticleList> getArticalList() { PagingOptions a = new PagingOptions(); a.PageIndex = 1; a.PageSize = 5; var result = new List <v_ArticleList>(); try { using (var db = new MyAppEntities()) { var aa = db.v_ArticleList.OrderByDescending(o => o.WriteTime).AsQueryable(); result = aa.AsPaging(a).ToList(); }; } catch (Exception e) { } return(result); }
public MyAppApiResult <MemberShip> Login(MemberShip user) { var res = new MyAppApiResult <MemberShip>(); try { using (var db = new MyAppEntities()) { var member = db.MemberShip.FirstOrDefault(o => o.LoginName == user.LoginName && o.PassWord == user.PassWord); if (member != null) { res.Data = member; } else { res.AddError("用户名或密码不正确"); return(res); } } } catch (Exception e) { res.AddError(e.Message); } return(res); }
public MyAppApiResult <bool> AddLike(Guid ArticleId, MemberShip User) { var result = new MyAppApiResult <bool>(); try { using (var db = new MyAppEntities()) { var log = db.MyApp_LookLog.FirstOrDefault(o => o.MemberShipId == User.Id && o.ArticleId == ArticleId); if (log != null) { if (log.IsLike == true) { result.AddError("已喜欢过"); return(result); } log.IsLike = true; } else { db.MyApp_LookLog.Add(new MyApp_LookLog() { Id = Guid.NewGuid(), MemberShipId = User.Id, ArticleId = ArticleId, IsLike = true }); } db.SaveChanges(); } } catch (Exception e) { result.AddError(e.Message); } return(result); }
public static void RegisterRoutes(RouteCollection routes) { routes.IgnoreRoute("{resource}.axd/{*pathInfo}"); routes.MapRoute( name: "Default", url: "", defaults: new { controller = "Home", action = "Index", id = UrlParameter.Optional } ); routes.MapRoute( name: "Logout", url: "Authorize/Logout", defaults: new { controller = "Authorize", action = "Logout", id = UrlParameter.Optional } ); routes.MapRoute( name: "Login", url: "Authorize/Login", defaults: new { controller = "Authorize", action = "Login", id = UrlParameter.Optional } ); var myAppEntities = new MyAppEntities(); var UserRoles = myAppEntities.Roles.Where(a => a.url != "").ToList(); foreach (var userrole in UserRoles) { if (userrole.AccessView == true) { routes.MapRoute( name: userrole.id.ToString() + "view", url: (userrole.url + "").Replace("//", "/"), defaults: new { controller = userrole.controller, action = "Index", id = UrlParameter.Optional } ); routes.MapRoute( name: userrole.id.ToString() + "details", url: (userrole.url + "/Details/{id}").Replace("//", "/"), defaults: new { controller = userrole.controller, action = "Details", id = UrlParameter.Optional } ); } if (userrole.AccessAdd == true) { routes.MapRoute( name: userrole.id.ToString() + "add", url: (userrole.url + "/add").Replace("//", "/"), defaults: new { controller = userrole.controller, action = "Create", id = UrlParameter.Optional } ); } if (userrole.AccessEdit == true) { routes.MapRoute( name: userrole.id.ToString() + "edit", url: (userrole.url + "/edit/{id}").Replace("//", "/"), defaults: new { controller = userrole.controller, action = "Edit", id = UrlParameter.Optional } ); } if (userrole.AccessDelete == true) { routes.MapRoute( name: userrole.id.ToString() + "delete", url: (userrole.url + "/delete/{id}").Replace("//", "/"), defaults: new { controller = userrole.controller, action = "Delete", id = UrlParameter.Optional } ); } if (userrole.AccessPrint == true) { routes.MapRoute( name: userrole.id.ToString() + "print", url: (userrole.url + "/print").Replace("//", "/"), defaults: new { controller = userrole.controller, action = "Print", id = UrlParameter.Optional } ); } if (userrole.AccessCustom == true) { routes.MapRoute( name: userrole.id.ToString() + "custom", url: (userrole.url + "/custom").Replace("//", "/"), defaults: new { controller = userrole.controller, action = "Custom", id = UrlParameter.Optional } ); } } }