public void Handle(UserCreated e) { using (var db = new CoreDbContext()) { db.Users.Add(new User { Id = e.Id, CreatedDate = e.CreatedDate, Deleted = false, Phone = e.Phone, Email = e.Email, Username = e.Username, TokenSession = string.Empty, Password = e.Password, Actived = false, TokenSessionExpiredDate = EngineeCurrentContext.SystemMinDate }); db.SaveChanges(); } }
private bool SaveBillingInfo(int tenant, Tuple <int, DateTime> bi, bool renewal = true) { var inserted = false; if (!Equals(bi, GetBillingInfo(tenant))) { using var tx = CoreDbContext.Database.BeginTransaction(); // last record is not the same var count = CoreDbContext.Tariffs .Count(r => r.Tenant == tenant && r.Tariff == bi.Item1 && r.Stamp == bi.Item2); if (bi.Item2 == DateTime.MaxValue || renewal || count == 0) { var efTariff = new DbTariff { Tenant = tenant, Tariff = bi.Item1, Stamp = bi.Item2 }; CoreDbContext.Tariffs.Add(efTariff); CoreDbContext.SaveChanges(); cache.Remove(GetTariffCacheKey(tenant)); inserted = true; } tx.Commit(); } if (inserted) { var t = tenantService.GetTenant(tenant); if (t != null) { // update tenant.LastModified to flush cache in documents tenantService.SaveTenant(CoreSettings, t); } } return(inserted); }
public void Execute(AddMemberToConversationCommand command) { var member = _db.Users.Find(command.MemberId); var conversation = _db.Conversations.Include(x => x.Members) .SingleOrDefault(x => x.Id == command.ConversationId); if (conversation == null) { throw new Exception("The conversation doesn't exist!"); } if (conversation.Members.All(m => m.UserId != command.UserId)) { throw new Exception("Brak uprawnień"); } conversation.AddMember(member.Id); _db.SaveChanges(); }
public void UpdateRightsForRole(Guid roleId, List <Guid> rightIds) { using (var db = new CoreDbContext()) { var temp = db.RelationShips.Where(i => i.FromId == roleId).ToList(); db.RelationShips.RemoveRange(temp); foreach (var rt in rightIds) { db.RelationShips.Add(new RelationShip() { FromId = roleId, ToId = rt, FromTableName = "Role", ToTableName = "Right" }); } db.SaveChanges(); } }
public void Handle(RelationShipAddedOneFromWithManyTo e) { using (var db = new CoreDbContext()) { foreach (var toId in e.ToIds) { var temp = db.RelationShips.FirstOrDefault(i => i.FromId == e.FromId && i.ToId == toId); if (temp == null) { temp = new RelationShip(); temp.FromId = e.FromId; temp.ToId = toId; temp.FromTableName = e.FromTableName; temp.ToTableName = e.ToTableName; temp.DisplayOrder = 0; db.RelationShips.Add(temp); } } db.SaveChanges(); } }
public User Authenticate(string email, string password) { var user = context.Users.SingleOrDefault(x => x.Email == email && x.Password == password); // return null if user not found if (user == null) { return(null); } // authentication successful so generate jwt token var tokenHandler = new JwtSecurityTokenHandler(); var key = Encoding.ASCII.GetBytes(appSettings.Secret); var EmployeeClaimsIdentity = new ClaimsIdentity(new Claim[] { new Claim(ClaimTypes.Name, user.UserId.ToString()), new Claim(ClaimTypes.Role, context.Roles.Include(x => x.Users).FirstOrDefault(x => x.Users.Any(y => y.UserId == user.UserId)).DisplayValue) }); var tokenDescriptor = new SecurityTokenDescriptor { Subject = new ClaimsIdentity(new Claim[] { new Claim(ClaimTypes.Name, user.UserId.ToString()), new Claim(ClaimTypes.Role, context.Roles.Include(x => x.Users).FirstOrDefault(x => x.Users.Any(y => y.UserId == user.UserId)).DisplayValue) }), Expires = DateTime.UtcNow.AddDays(7), SigningCredentials = new SigningCredentials(new SymmetricSecurityKey(key), SecurityAlgorithms.HmacSha256Signature) }; var token = tokenHandler.CreateToken(tokenDescriptor); user.Token = tokenHandler.WriteToken(token); context.SaveChanges(); return(user.WithoutPassword()); }
public void Handle(SendEmailToUser c) { var defaultFromEmail = SendGridHelper.DefaultFromEmail; var tran = new UserMessageTransaction() { Id = c.MessageTransactionId, Content = c.Content, From = defaultFromEmail, To = c.ToEmail, ToName = c.ToName, Subject = c.Subject, Type = (short)Enums.UserMessageType.Email, Status = (short)Enums.UserMessageTransactionStatus.Created, ToUserId = c.UserId, SendDate = c.SendDate, CreatedDate = c.CreatedDate }; using (var db = new CoreDbContext()) { db.UserMessageTransactions.Add(tran); db.SaveChanges(); } }
/// <summary> /// 添加菜单 /// </summary> /// <param name="menu">menu.</param> public bool Add(Menu menu) { _coreDbContext.Menu.Add(menu); return(_coreDbContext.SaveChanges() > 0); }
private void CreateHostRoleAndUsers() { // Admin role for host var adminRoleForHost = _context.Roles.IgnoreQueryFilters().FirstOrDefault(r => r.TenantId == null && r.Name == StaticRoleNames.Host.Admin); if (adminRoleForHost == null) { adminRoleForHost = _context.Roles.Add(new Role(null, StaticRoleNames.Host.Admin, StaticRoleNames.Host.Admin) { IsStatic = true, IsDefault = true }).Entity; _context.SaveChanges(); } // Grant all permissions to admin role for host var grantedPermissions = _context.Permissions.IgnoreQueryFilters() .OfType <RolePermissionSetting>() .Where(p => p.TenantId == null && p.RoleId == adminRoleForHost.Id) .Select(p => p.Name) .ToList(); var permissions = PermissionFinder .GetAllPermissions(new CoreAuthorizationProvider()) .Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Host) && !grantedPermissions.Contains(p.Name)) .ToList(); if (permissions.Any()) { _context.Permissions.AddRange( permissions.Select(permission => new RolePermissionSetting { TenantId = null, Name = permission.Name, IsGranted = true, RoleId = adminRoleForHost.Id }) ); _context.SaveChanges(); } // Admin user for host var adminUserForHost = _context.Users.IgnoreQueryFilters().FirstOrDefault(u => u.TenantId == null && u.UserName == AbpUserBase.AdminUserName); if (adminUserForHost == null) { var user = new User { TenantId = null, UserName = AbpUserBase.AdminUserName, Name = "admin", Surname = "admin", EmailAddress = "*****@*****.**", IsEmailConfirmed = true, IsActive = true }; user.Password = new PasswordHasher <User>(new OptionsWrapper <PasswordHasherOptions>(new PasswordHasherOptions())).HashPassword(user, "123qwe"); user.SetNormalizedNames(); adminUserForHost = _context.Users.Add(user).Entity; _context.SaveChanges(); // Assign Admin role to admin user _context.UserRoles.Add(new UserRole(null, adminUserForHost.Id, adminRoleForHost.Id)); _context.SaveChanges(); _context.SaveChanges(); } }
public bool Save() { return(_context.SaveChanges() >= 0); }
public void Delete(Main entity) { context.Mains.Remove(entity); context.SaveChanges(); }
//插入数据 public bool CreateUser(User_data user) { Context.user_data.Add(user); return(Context.SaveChanges() > 0); }
static void RegisterUrlRoutingAsRight(Assembly[] allAss) { foreach (var assembly in allAss) { var controllers = assembly.GetTypes() .Where(type => typeof(Controller).IsAssignableFrom(type)).ToList(); if (controllers.Count == 0) { continue; } var listMethods = controllers.SelectMany( type => type.GetMethods(BindingFlags.Instance | BindingFlags.DeclaredOnly | BindingFlags.Public)) .Where( m => !m.IsDefined(typeof(System.Web.Http.NonActionAttribute)) //&&!m.GetCustomAttributes(typeof(System.Runtime.CompilerServices.CompilerGeneratedAttribute),true).Any() ) .Select(x => new { Controller = x.DeclaringType.Name.Replace("Controller", string.Empty), Action = x.Name, RightDescription = x.GetCustomAttributes().Where(i => i.GetType() == typeof(RightDescriptionAttribute)) .Select(rd => rd as RightDescriptionAttribute).Where(rd => rd != null).Select(rd => rd.Description).FirstOrDefault() , Area = x.DeclaringType.Namespace.Split('.').Reverse().Skip(1).First(), ReturnType = x.ReturnType.FullName }) .OrderBy(x => x.Controller).ThenBy(x => x.Action).ToList(); using (var db = new CoreDbContext()) { foreach (var c in listMethods) { var rightName = $"/{c.Controller}/{c.Action}/"; var existed = db.Rights.FirstOrDefault( i => i.KeyName.Equals(rightName, StringComparison.OrdinalIgnoreCase)); if (existed == null) { var right = new Right() { Id = Guid.NewGuid(), KeyName = rightName, Title = rightName, Type = 0, ReturnType = c.ReturnType, GroupName = c.Controller, Description = c.RightDescription }; db.Rights.Add(right); var rs = db.RelationShips.FirstOrDefault( i => i.FromId == EngineeCurrentContext.AdminRoleId && i.ToId == right.Id); if (rs == null) { db.RelationShips.Add(new RelationShip() { FromId = EngineeCurrentContext.AdminRoleId, ToId = right.Id, DisplayOrder = 0, FromTableName = "Role", ToTableName = "Right" }); } } else { if (string.IsNullOrEmpty(existed.Description)) { existed.Description = c.RightDescription; } existed.GroupName = c.Controller; } } db.SaveChanges(); } } }
private void CreateRolesAndUsers() { // Admin role var adminRole = _context.Roles.IgnoreQueryFilters().FirstOrDefault(r => r.TenantId == _tenantId && r.Name == StaticRoleNames.Tenants.Admin); if (adminRole == null) { adminRole = _context.Roles.Add(new Role(_tenantId, StaticRoleNames.Tenants.Admin, StaticRoleNames.Tenants.Admin) { IsStatic = true }).Entity; _context.SaveChanges(); } // Grant all permissions to admin role var grantedPermissions = _context.Permissions.IgnoreQueryFilters() .OfType <RolePermissionSetting>() .Where(p => p.TenantId == _tenantId && p.RoleId == adminRole.Id) .Select(p => p.Name) .ToList(); var permissions = PermissionFinder .GetAllPermissions(new CoreAuthorizationProvider()) .Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Tenant) && !grantedPermissions.Contains(p.Name)) .ToList(); if (permissions.Any()) { _context.Permissions.AddRange( permissions.Select(permission => new RolePermissionSetting { TenantId = _tenantId, Name = permission.Name, IsGranted = true, RoleId = adminRole.Id }) ); _context.SaveChanges(); } // Admin user var adminUser = _context.Users.IgnoreQueryFilters().FirstOrDefault(u => u.TenantId == _tenantId && u.UserName == AbpUserBase.AdminUserName); if (adminUser == null) { adminUser = User.CreateTenantAdminUser(_tenantId, "*****@*****.**"); adminUser.Password = new PasswordHasher <User>(new OptionsWrapper <PasswordHasherOptions>(new PasswordHasherOptions())).HashPassword(adminUser, "123qwe"); adminUser.IsEmailConfirmed = true; adminUser.IsActive = true; _context.Users.Add(adminUser); _context.SaveChanges(); // Assign Admin role to admin user _context.UserRoles.Add(new UserRole(_tenantId, adminUser.Id, adminRole.Id)); _context.SaveChanges(); } }
public int SaveEvent(EventLog entity) { context.Entry(entity).State = Microsoft.EntityFrameworkCore.EntityState.Added; context.SaveChanges(); return(entity.EventLogId); }
public ActionResult TryCreate(string connectionString, string provider, bool drop = true) { var msg = ""; try { var factory = DbProviderFactories.GetFactory(provider); var connection = factory.CreateConnection(); connection.ConnectionString = connectionString; var recipe = provider.Equals("MySql.Data.MySqlClient", StringComparison.OrdinalIgnoreCase) ? "mysql" : "sql"; ////Generate sqlscripts for debug //var tmpPath = Server.MapPath("~/content/temp/sqlscripts/"); //if (!System.IO.Directory.Exists(tmpPath)) // System.IO.Directory.CreateDirectory(tmpPath); //if (drop) // Database.SetInitializer(new DropCreateDatabaseAlways<CoreDbContext>()); using (var dbContext = new CoreDbContext(connection, true) { Recipe = recipe }) { if (recipe == "mysql") { Database.SetInitializer(new CreateMySqlDatabaseIfNotExists <CoreDbContext>()); } else { Database.SetInitializer(new CreateDatabaseIfNotExists <CoreDbContext>()); } //#region for debug //string script = ((System.Data.Entity.Infrastructure.IObjectContextAdapter)dbContext).ObjectContext.CreateDatabaseScript(); //System.IO.File.WriteAllText(tmpPath + DNA.Utility.TextUtility.Slug(provider).ToLower() + ".sql", script); ////System.Data.Entity.Migrations.DbMigrationsConfiguration //#endregion //dbContext.Database.CreateIfNotExists(); var count = dbContext.Webs.Count(); if (dbContext.Roles.Count(n => n.Name.Equals("administrators")) == 0) { dbContext.Roles.Add(new Role() { Name = "administrators", Description = "The system administrators" }); } if (dbContext.Roles.Count(n => n.Name.Equals("guests")) == 0) { dbContext.Roles.Add(new Role() { Name = "guests", Description = "" }); } dbContext.SaveChanges(); } #region save configuration var config = new XmlDocument(); string configPath = Server.MapPath("~/web.config"); config.Load(configPath); var connectionStringsPath = "configuration/connectionStrings"; XmlNode connectionStringsNode = null; connectionStringsNode = config.SelectSingleNode(connectionStringsPath); var dnaCnnNode = connectionStringsNode.SelectSingleNode("add[@name='DNADB']"); if (dnaCnnNode == null) { dnaCnnNode = CreateConnectionNode(config, "DNADB", provider, connectionString); connectionStringsNode.AppendChild(dnaCnnNode); } else { dnaCnnNode.Attributes["providerName"].Value = provider; dnaCnnNode.Attributes["connectionString"].Value = connectionString; } config.Save(configPath); var unityConfig = new XmlDocument(); string unityConfigPath = Server.MapPath("~/unity.config"); unityConfig.Load(unityConfigPath); NameTable nt = new NameTable(); var nsmgr = new XmlNamespaceManager(nt); nsmgr.AddNamespace("n", "http://schemas.microsoft.com/practices/2010/unity"); var rNode = unityConfig.SelectSingleNode("//n:container/n:register[@type=\"IDataContext\"]/n:constructor/n:param[@name=\"recipe\"]", nsmgr); rNode.Attributes["value"].Value = recipe; unityConfig.Save(unityConfigPath); #endregion } catch (Exception e) { msg = e.Message; if (e.InnerException != null) { msg += "\t\n" + "Detail:" + e.InnerException.Message; } return(Json(new { code = 500, error = string.IsNullOrEmpty(msg) ? null : msg }, JsonRequestBehavior.AllowGet)); } return(Json(new { success = true, code = 200 }, JsonRequestBehavior.AllowGet)); }
public Comment AddComment(Comment comment) { _context.Comments.Add(comment); _context.SaveChanges(); return(comment); }
public Post AddPost(Post post) { _context.Posts.Add(post); _context.SaveChanges(); return(post); }
public static int SaveChanges_Auditable(this CoreDbContext context) { return(context.SaveChanges(AuditHelper.AutoSaveWithAuditEntryFactory(context.UserInfo?.PersonId.ToString()))); //return context.SaveChanges(AuditHelper.AutoSaveWithAuditEntryFactory(context.UserInfo.UserGUID)); }
public User AddUser(User user) { _context.Users.Add(user); _context.SaveChanges(); return(user); }
public Task <IdentityResult> CreateAsync(TRole role, CancellationToken cancellationToken, bool useTransaction = true) { _ctx.SaveChanges(role, useTransaction); return(Task.FromResult(IdentityResult.Success)); }
public void Add(Product product) { context.Add(product); context.SaveChanges(); }
void IUnitOfWork.Commit() { _dbContext.SaveChanges(); }
public void Commit() { _context.SaveChanges(); }
public void UpdateEmployeeRecord(Employee User) { __context.Employees.Update(User); __context.SaveChanges(); }
public void Initialize() { var options = new DbContextOptionsBuilder <CoreDbContext>() .UseInMemoryDatabase(databaseName: "TherapistEventDatabase") .Options; _testContext = new CoreDbContext(options); _testContext.Database.EnsureDeleted(); _testUsers = new List <User>(); _testTherapistEvents = new List <TherapistEvent>(); _testTargetStartDateTime = new DateTime(2010, 2, 8); _testTargetEndDateTime = new DateTime(2010, 2, 12); for (var i = 0; i < 8; i++) { var newUser = ModelFakes.UserFake.Generate(); _testContext.Add(newUser); _testContext.SaveChanges(); _testUsers.Add(ObjectExtensions.Copy(newUser)); Permission newPermission = new Permission { UserId = newUser.UserId, Role = "therapist" }; _testContext.Add(newPermission); _testContext.SaveChanges(); var newTherapistEvent = ModelFakes.TherapistEventFake.Generate(); newTherapistEvent.TherapistId = newUser.UserId; if (i <= 2) { newTherapistEvent.StartTime = _testTargetStartDateTime.AddDays(i); newTherapistEvent.EndTime = _testTargetEndDateTime.AddDays(-1 * i); } _testContext.Add(newTherapistEvent); _testContext.SaveChanges(); _testTherapistEvents.Add(ObjectExtensions.Copy(newTherapistEvent)); } _testNonTherapistUser = ModelFakes.UserFake.Generate(); _testContext.Add(_testNonTherapistUser); _testContext.SaveChanges(); _testUsers.Add(ObjectExtensions.Copy(_testNonTherapistUser)); var newEdgeTherapistEvent = ModelFakes.TherapistEventFake.Generate(); newEdgeTherapistEvent.TherapistId = _testUsers[0].UserId; newEdgeTherapistEvent.StartTime = _testTargetStartDateTime.AddDays(-1); _testContext.Add(newEdgeTherapistEvent); _testContext.SaveChanges(); _testTherapistEvents.Add(ObjectExtensions.Copy(newEdgeTherapistEvent)); newEdgeTherapistEvent = ModelFakes.TherapistEventFake.Generate(); newEdgeTherapistEvent.TherapistId = _testUsers[0].UserId; newEdgeTherapistEvent.EndTime = _testTargetEndDateTime.AddDays(1); _testContext.Add(newEdgeTherapistEvent); _testContext.SaveChanges(); _testTherapistEvents.Add(ObjectExtensions.Copy(newEdgeTherapistEvent)); _nonActiveTherapistEvent = ModelFakes.TherapistEventFake.Generate(); _nonActiveTherapistEvent.Active = false; _nonActiveTherapistEvent.StartTime = _testTargetStartDateTime; _nonActiveTherapistEvent.EndTime = _testTargetEndDateTime; _testContext.Add(_nonActiveTherapistEvent); _testContext.SaveChanges(); _testTherapistEvents.Add(ObjectExtensions.Copy(_nonActiveTherapistEvent)); _testTherapistEvent = new TherapistEvent { StartTime = DateTime.MinValue, EndTime = DateTime.MaxValue, TherapistId = _testUsers[0].UserId }; _testTherapistEventService = new TherapistEventService(_testContext); _testTherapistEventController = new TherapistEventController(_testTherapistEventService); }
public Restaurant Add(Restaurant restaurant) { context.Add(restaurant); context.SaveChanges(); return(restaurant); }
//插入数据 public bool CreatePerson(person peo) { Context.Person.Add(peo); return(Context.SaveChanges() > 0); }
public Guid RegistrationInit(ProfileRegistrationModel model) { if (model == null) { throw new CustomArgumentException("Registration data is empty!"); } // input validation if (String.IsNullOrWhiteSpace(model.Email)) { throw new CustomInputException("Email is empty!"); } if (String.IsNullOrWhiteSpace(model.Password)) { throw new CustomInputException("Password is empty!"); } if (!model.IsPasswordMatch()) { throw new CustomInputException("Password confirmation is not equal to Passowrd!"); } // security policy var securityPolicy = this.GetSecurityPolicy(); if (!securityPolicy.CheckStrength(model.Password)) { throw new CustomInputException("Password does not match Security Policy!"); } // change valid login model.Login = model.GetValidLogin(); // check if user already exists with login var persons = this.Persons .Include(t => t.User) .Where(p => p.User.Login.ToLower() == model.Login.ToLower()) .ToList(); if (persons.Any()) { throw new CustomInputException($"Person with login {model.Login} is already exist!"); } // create activity var now = CommonService.Now; var pin = CommonService.GeneratePin(10); var activity = Activity.Create(now.AddHours(DEFAULT_ACTIVITY_EXPIRATION_HOURS), DEFAULT_ACTIVITY_TYPE_REGISTRATION, model, pin); _dbContext.Set <Activity>().Add(activity); _dbContext.SaveChanges(); // raise event to send email DomainDispatcher.RaiseEvent(new RegistrationInitDomainEvent() { Email = model.Email, NameFirst = model.NameFirst, NameLast = model.NameLast, Login = model.Login, PIN = pin }); return(activity.ID); }
public virtual void Save() { _db.SaveChanges(); }