public override bool ValidateUser(string username, string password) { bool isValid = false; using (EnterpriseContext _db = new EnterpriseContext()) { try { User user = (from u in _db.Users where u.Email == username select u).FirstOrDefault(); if (user != null && Crypto.VerifyHashedPassword(user.Password, password)) { isValid = true; } } catch { isValid = false; } } return(isValid); }
public override bool IsUserInRole(string username, string roleName) { bool outputResult = false; // Находим пользователя using (EnterpriseContext _db = new EnterpriseContext()) { try { // Получаем пользователя User user = (from u in _db.Users where u.Email == username select u).FirstOrDefault(); if (user != null) { // получаем роль Role userRole = _db.Roles.Find(user.RoleId); //сравниваем if (userRole != null && userRole.Name == roleName) { outputResult = true; } } } catch { outputResult = false; } } return(outputResult); }
public void Select_WithCallBack_Refresh__With_Key_Customers() { EnterpriseContext context = new EnterpriseContext(); using (EntityDatabaseConnection connection = GetConnection()) { connection.Open(); EntityDatabase <EnterpriseContext> .Connect(connection) .Table <Customer>() .Select("select 'Extra' as ExtraColumn, *, 'Extra' as ExtraColumn from Customers") .WithCallBack(e => new { e.ID, e.RV, e.LastName, e.FirstName }) .Refresh(context.Customers); connection.Close(); } context.Customers[0].NationalIdentityNumber = "9999999999"; using (EntityDatabaseConnection connection = GetConnection()) { connection.Open(); EntityDatabase <EnterpriseContext> .Connect(connection) .Table <Customer>() .Select("select 'Extra' as ExtraColumn, *, 'Extra' as ExtraColumn from Customers") .WithCallBack(e => new { e.ID, e.NationalIdentityNumber }) .Refresh(context.Customers); connection.Close(); } }
public override string[] GetRolesForUser(string email) { string[] role = new string[] { }; using (EnterpriseContext _db = new EnterpriseContext()) { try { // Получаем пользователя User user = (from u in _db.Users where u.Email == email select u).FirstOrDefault(); if (user != null) { // получаем роль Role userRole = _db.Roles.Find(user.RoleId); if (userRole != null) { role = new string[] { userRole.Name }; } } } catch { role = new string[] { }; } } return(role); }
public MembershipUser CreateUser(string email, string password) { MembershipUser membershipUser = GetUser(email, false); if (membershipUser == null) { try { using (EnterpriseContext _db = new EnterpriseContext()) { User user = new User(); user.Email = email; user.Password = Crypto.HashPassword(password); user.CreationDate = DateTime.Now; if (_db.Roles.Find(2) != null) { user.RoleId = 2; } _db.Users.Add(user); _db.SaveChanges(); membershipUser = GetUser(email, false); return(membershipUser); } } catch { return(null); } } return(null); }
public override void CreateRole(string roleName) { Role newRole = new Role() { Name = roleName }; EnterpriseContext db = new EnterpriseContext(); db.Roles.Add(newRole); db.SaveChanges(); }
public void Select_WithoutCallBack_Fill_Customers() { EnterpriseContext context = new EnterpriseContext(); using (EntityDatabaseConnection connection = GetConnection()) { connection.Open(); EntityDatabase <EnterpriseContext> .Connect(connection) .Table <Customer>() .Select("select 'Extra' as ExtraColumn, *, 'Extra' as ExtraColumn from Customers") .Fill(context.Customers); connection.Close(); } }
public void Select_WithCallBack_Products() { EnterpriseContext context = new EnterpriseContext(); using (EntityDatabaseConnection connection = GetConnection()) { connection.Open(); EntityDatabase <EnterpriseContext> .Connect(connection) .Table <Product>() .Select("select * from Products") .WithCallBack(e => new { e.ID, e.Name, e.Manufacturer, e.Length, e.Width, e.Height, e.Weight, e.Color, e.Power, e.EnergyEfficiency, e.Material, e.Quality, e.Kind, e.Image, e.RV }) .Fill(context.Products); connection.Close(); } }
public void Select_WithCallBack_OrderDetails() { EnterpriseContext context = new EnterpriseContext(); using (EntityDatabaseConnection connection = GetConnection()) { connection.Open(); EntityDatabase <EnterpriseContext> .Connect(connection) .Table <OrderDetail>() .Select("select * from OrderDetails") .WithCallBack(e => new { e.ID, e.RV, e.Amount, e.Fee, e.OrderID }) // OrderID is not null column, therefore it cann't be omitted in query, and must be loaded in model .Fill(context.OrderDetails); connection.Close(); } }
public void Select_WithCallBack_Orders() { EnterpriseContext context = new EnterpriseContext(); using (EntityDatabaseConnection connection = GetConnection()) { connection.Open(); EntityDatabase <EnterpriseContext> .Connect(connection) .Table <Order>() .Select("select * from Orders") .WithCallBack(e => new { e.ID, e.CustomerID, e.ReceiveDate, e.ShippingDate, e.RV }) .Fill(context.Orders); connection.Close(); } }
public void Select_WithCallBack_Merge_Without_Key_Customers() { EnterpriseContext context = new EnterpriseContext(); using (EntityDatabaseConnection connection = GetConnection()) { connection.Open(); EntityDatabase <EnterpriseContext> .Connect(connection) .Table <Customer>() .Select("select 'Extra' as ExtraColumn, *, 'Extra' as ExtraColumn from Customers") .WithCallBack(e => new { e.RV, e.LastName, e.FirstName }) .Merge(context.Customers); connection.Close(); } }
public void Select_WithCallBack_Fill_Customers_FiveTime() { EnterpriseContext context1 = new EnterpriseContext(); EnterpriseContext context2 = new EnterpriseContext(); EnterpriseContext context3 = new EnterpriseContext(); EnterpriseContext context4 = new EnterpriseContext(); EnterpriseContext context5 = new EnterpriseContext(); using (EntityDatabaseConnection connection = GetConnection()) { connection.Open(); EntityDatabase <EnterpriseContext> .Connect(connection) .Table <Customer>() .Select("select * from Customers") .WithCallBack(e => new { e.ID, e.FirstName, e.LastName, e.NationalIdentityNumber, e.RV }) // Same As context4 .Fill(context1.Customers); EntityDatabase <EnterpriseContext> .Connect(connection) .Table <Customer>() .Select("select * from Customers") .WithCallBack(e => new { e.ID, e.FirstName, e.LastName, e.RV }) // Same As context5 .Fill(context2.Customers); EntityDatabase <EnterpriseContext> .Connect(connection) .Table <Customer>() .Select("select * from Customers") .WithCallBack(e => new { e.ID, e.RV, e.FirstName, e.LastName, e.NationalIdentityNumber }) .Fill(context3.Customers); EntityDatabase <EnterpriseContext> .Connect(connection) .Table <Customer>() .Select("select * from Customers") .WithCallBack(e => new { e.ID, e.FirstName, e.LastName, e.NationalIdentityNumber, e.RV }) // Same As context1 .Fill(context4.Customers); EntityDatabase <EnterpriseContext> .Connect(connection) .Table <Customer>() .Select("select * from Customers") .WithCallBack(e => new { e.ID, e.FirstName, e.LastName, e.RV }) // Same As context2 .Fill(context5.Customers); connection.Close(); } }
public void SelectAsync_Prepared_With_Transaction_With_Parameter_With_CallBack() { EnterpriseContext context = new EnterpriseContext(); var consideredCustomers = UserDefinedTableTypeCreator.Create("BigIntIDs", () => new { ID = default(long) }) .Add(new { ID = 15L }) .Add(new { ID = 19L }); EntityDatabaseConnection connection = GetConnection(); var t = EntityDatabase <EnterpriseContext> .Connect(connection) .Transaction(IsolationLevel.Snapshot) .Select(@"select * from Customers c inner join @ConsideredCustomers cc on cc.ID = c.ID declare @Orders table (ID bigint, CustomerID int, ShippingDate date, RV binary(8)) insert into @Orders select o.ID, o.CustomerID, o.ShippingDate, o.RV from Orders o inner join @ConsideredCustomers cc on cc.ID = o.CustomerID where o.ReceiveDate > parse('1398/02/01' as date using 'fa-IR') select * from @Orders o order by o.ShippingDate select * from OrderDetails od inner join @Orders o on o.ID = od.OrderID select * from Products where ID = @ProductID") .WithParameters(new { ProductID = 6005, ConsideredCustomers = consideredCustomers }) .To(context) .Fill <Customer>(e => new { e.LastName, e.NationalIdentityNumber, e.FirstName, e.ID }) .Fill <Order>(e => new { e.ShippingDate, e.RV, e.ID }) .Fill <OrderDetail>(e => new { e.Amount, e.RV, e.Fee, e.ID, e.OrderID }) // OrderID is not null column, therefore it cann't be omitted in query, and must be loaded in model .Fill <Product>(e => new { e.ID, e.Name, e.Manufacturer }) .ExecuteAsync(); t.Wait(); }
public void Select_Prepared_Without_Parameter_With_CallBack() { EnterpriseContext context = new EnterpriseContext(); using (EntityDatabaseConnection connection = GetConnection()) { EntityDatabase <EnterpriseContext> .Connect(connection) .Select(@"select * from Customers select * from Orders select * from Products") .To(context) .Fill <Customer>(e => new { e.LastName, e.NationalIdentityNumber, e.FirstName, e.ID }) .Fill <Order>(e => new { e.RV, e.ID, e.CustomerID }) .Fill <Product>(e => new { e.ID, e.Name, e.Manufacturer }) .Execute(); } }
public void Select_Prepared_Without_Parameter_Without_CallBack() { EnterpriseContext context = new EnterpriseContext(); using (EntityDatabaseConnection connection = GetConnection()) { EntityDatabase <EnterpriseContext> .Connect(connection) .Select(@"select * from Customers select * from Orders select * from Products") .To(context) .Fill <Customer>() .Fill <Order>() .Fill <Product>() .Execute(); } }
public void Select_With_Transaction_Without_CallBack() { EnterpriseContext context = new EnterpriseContext(); using (EntityDatabaseConnection connection = GetConnection()) { EntityDatabase <EnterpriseContext> .Connect(connection) .Transaction(IsolationLevel.Snapshot) .Select(@"select * from Customers select * from Orders select * from Products") .To(context) .Fill <Customer>() .Fill <Order>() .Fill <Product>() .Execute(); } }
public void Select_Prepared_WithoutParameters_WithCallBack_Fill_Customers() { EnterpriseContext context = new EnterpriseContext(); using (EntityDatabaseConnection connection = GetConnection()) { connection.Open(); EntityDatabase <EnterpriseContext> .Connect(connection) .Table <Customer>() .Prepared() .Select(@"select 'Extra' as ExtraColumn, c.*, 'Extra' as ExtraColumn from Customers c") .WithCallBack(e => new { e.ID, e.FirstName, e.LastName, e.NationalIdentityNumber, e.RV }) .Fill(context.Customers); connection.Close(); } }
public void Select_Prepared_WithParameters_WithoutCallBack_Fill_Customers() { EnterpriseContext context = new EnterpriseContext(); using (EntityDatabaseConnection connection = GetConnection()) { connection.Open(); EntityDatabase <EnterpriseContext> .Connect(connection) .Table <Customer>() .Prepared() .WithParameters(new { CustomerID = 16 }) .Select(@"select 'Extra' as ExtraColumn, c.*, 'Extra' as ExtraColumn from Customers c where c.ID = @CustomerID") .Fill(context.Customers); connection.Close(); } }
public void SelectAsync_Prepared_With_Transaction_Without_Parameter_Without_CallBack_BigData() { EnterpriseContext context = new EnterpriseContext(); EntityDatabaseConnection connection = GetConnection(); var t = EntityDatabase <EnterpriseContext> .Connect(connection) .Transaction(IsolationLevel.Snapshot) .Select(@"select * from Customers c select * from Customers c select * from Customers c") .To(context) .Fill <Customer>() .Merge <Customer>() .Merge <Customer>() .ExecuteAsync(); t.Wait(); }
/// <summary> /// /// </summary> /// <param name="serviceProvider"></param> /// <param name="context"></param> /// <param name="uid"></param> /// <returns></returns> protected override async Task VailOfRole( IServiceProvider serviceProvider, AuthorizationHandlerContext context, string uid) { if (context.Resource is not DefaultHttpContext httpContext) { return; } var res = httpContext.GetEndpoint(); var routePattern = httpContext.GetRouteData().Values; var module = res.Metadata.GetMetadata <RuleModuleAttribute>(); var method = res.Metadata.GetMetadata <RuleMethodAttribute>(); if (module == null && method == null) { context.Succeed(this); return; } UsersContext usersContext = await UsersContext.GetInfo( serviceProvider, uid); string area = routePattern.ContainsKey("area") ? routePattern["area"].ToStringEx() : ""; if (await Rule.IsRule_NSpecial( serviceProvider, await EnterpriseContext.GetInfo(serviceProvider, ClaimsPrincipalEx.FindFirstValueEx(context.User, Macro.COOKIESLOGIN_EID)), usersContext, ConvertEx.ToStringEx(routePattern["controller"]), area, ConvertEx.ToStringEx(routePattern["action"]))) { context.Succeed(this); } }
public override MembershipUser GetUser(string email, bool userIsOnline) { try { using (EnterpriseContext _db = new EnterpriseContext()) { var users = from u in _db.Users where u.Email == email select u; if (users.Count() > 0) { User user = users.First(); MembershipUser memberUser = new MembershipUser("MyMembershipProvider", user.Email, null, null, null, null, false, false, user.CreationDate, DateTime.MinValue, DateTime.MinValue, DateTime.MinValue, DateTime.MinValue); return(memberUser); } } } catch { return(null); } return(null); }
public void GetBusinessReturnsListOfBusiness() { // Arrange var options = new DbContextOptionsBuilder <EnterpriseContext>().UseInMemoryDatabase("Enterprise").Options; var context = new EnterpriseContext(options); context.Businesses.Add(new Business { Id = 2, Name = "New Business" }); var controller = new BusinessController(context); // Act IActionResult actionResult = controller.GetBuisnesses(); var okObjectResult = actionResult as OkObjectResult; var valueresult = okObjectResult.Value as IEnumerable <Business>; // Assert Assert.NotNull(valueresult); Assert.NotNull(okObjectResult); Assert.Equal(200, okObjectResult.StatusCode); }
static Settings() { Context = new EnterpriseContext(new DbContextOptionsBuilder <EnterpriseContext>() .UseSqlite("Filename=desktop_games.db") .UseLazyLoadingProxies().Options); }
/// <summary> /// 递归判断用户菜单权限 /// </summary> /// <param name="navBarItems"></param> /// <returns></returns> private async Task <List <NavBarItem> > IsRule(List <NavBarItem> navBarItems) { //筛选子节点 foreach (var item in navBarItems) { if (item.Children != null) { item.Children = await IsRule(item.Children); } } var newItems = navBarItems.Select(async F => { //子项筛选之后为空则判断父级菜单自身权限 if (F.Children != null ? (F.Children.Count > 0 ? false : true) : true) { if (F.Module == null) { return new { Info = F, Value = true } } ; if (F.Module.Count < 1) { return new { Info = F, Value = true } } ; if (F.Module[0].Split('/').Length < 3) { return new { Info = F, Value = true } } ; //判断权限 return(new { Info = F, Value = await Rule.IsRule_NSpecial( HttpContext.RequestServices, EnterpriseContext.EmptyContext(HttpContext.RequestServices), (await UserInfoForLogin), F.Module[0].Split('/')[1], F.Module[0].Split('/')[0], F.Module[0].Split('/')[2]) }); } //子项筛选之后有值则默认显示父级菜单 return(new { Info = F, Value = true }); }); var result = await Task.WhenAll(newItems); navBarItems = (from T in result where T.Value select T.Info).ToList(); return(navBarItems); }
public EmployeeRepository(EnterpriseContext db) { this.db = db; }
public BusinessRepository(EnterpriseContext context) { _context = context; }
public FamilyController(EnterpriseContext context) { _familyRepository = new FamilyRepository(context); }
public OrderProductRepository(EnterpriseContext db) { this.db = db; }
public OfferingRepository(EnterpriseContext context) { _context = context; }
public CountryController(EnterpriseContext context) { _countryRepository = new CountryRepository(context); }