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 }
);
}
}
}
