public ActionResult Report2() { if (Session["Email"] == null || Session["Type"].ToString() != "Donner") { return(RedirectToAction("Login", "Home")); } var user = userInfoRepository.GetAll(); return(View(user)); }
public ICollection <UserInfo> GetAll() { try { return(_userInfoRepository.GetAll()); } catch (Exception exception) { throw; } }
private bool UsersExist() { UserInfoRepository repo = new UserInfoRepository(); return(repo.GetAll().Any()); }
public ActionResult Index() { UserInfoRepository r = new UserInfoRepository(); return(View("~/Views/Employees.cshtml", r.GetAll())); }
public ActionResult UserPanel() { return(View(usrepo.GetAll().Where(us => us.UserType.UserTypeName != "Admin"))); }
public void TextDapperContext() { DbEntityMap.InitMapCfgs(); IDbDatasource dbDatasource = new DbDataSource(); dbDatasource.Init(new NameValueCollection() { ["aa.dataSource.master_AaCenter.connectionString"] = "Data Source =.; Initial Catalog = AaCenter;User ID = sa; Password = lee2018;", ["aa.dataSource.master_AaCenter.provider"] = "SqlServer" }); dbDatasource.Init(new NameValueCollection() { ["aa.dataSource.slave_AaCenter.connectionString"] = "Data Source =.; Initial Catalog = AaCenterS1;User ID = sa; Password = lee2018;", ["aa.dataSource.slave_AaCenter.provider"] = "SqlServer" }); DbContextHolder.SetDbSourceMode("slave"); IDapperContext dapperContext = new DapperContext(); IUserInfoRepository _userInforepository = new UserInfoRepository(dapperContext); var list = _userInforepository.GetAll().ToList(); //IVillageRepository villageRepository = new VillageRepository(); //villageRepository.Insert(new Village //{ // Id = Guid.NewGuid(), // VillageName = "aa", // GmtCreate = DateTime.Now, // GmtModified = DateTime.Now //}); //var model = villageRepository.Get(new Guid("6D880321-DB17-4B32-9F0A-CE9F3F25AA01")); //model.VillageName = "bbb"; //villageRepository.Update(model); ////var obj = _userInforepository.Insert(new UserInfo() ////{ //// RealName = "111", //// UserName = "******", //// GmtCreate=DateTime.Now, //// LastLoginDate=DateTime.Now, //// GmtModified=DateTime.Now ////}); // var users = _userInforepository.QueryAll(); //var userList = _userInforepository.From(sql => // sql.Select() // .Where(p => p.RealName.Contains("成")) // .OrderBy(x => x.SysNo) // .Page(1, 20) // ); //var count = userList.ToList().Count(); ////动态where //Expression<Func<UserInfo, bool>> expression = p => p.RealName == "成天"; //var where = DynamicWhereExpression.Init<UserInfo>(); //where = where.And(x => x.RealName == "成天"); //var dynamicUsers = _userInforepository.From(sql => // sql.Select() // .Where(where) // .OrderBy(x => x.SysNo) // .Page(1, 20) //); //var count2 = dynamicUsers.ToList().Count(); }