public AuthModel CreateAuthModel(AuthModel authModel) { var createdAuthModel = _authDbContext.AuthModel.Add(authModel); _authDbContext.SaveChanges(); return(createdAuthModel.Entity); }
public AuthInfo CreateAuthInfo(AuthInfo authInfo) { var createdAuthInfo = _authDbContext.AuthInfo.Add(authInfo); _authDbContext.SaveChanges(); return(createdAuthInfo.Entity); }
private void DeleteRelatedDate(Device device) { var ud = _context.UserDevices.Where(ud => ud.Device.DeviceId == device.DeviceId); _context.RemoveRange(ud); _context.SaveChanges(); }
public void ExpireSession(AppUser user, Guid sessionId) { AuthSession session = _authDbContext.AuthSessions .Single(s => s.User == user && s.Id == sessionId && s.ExpiredTime == null); session.ExpiredTime = SystemClock.Instance.GetCurrentInstant(); _authDbContext.SaveChanges(); }
private void DeleteRelatedData(Category category) { foreach (var device in category.Devices) { var ud = _context.UserDevices.Where(ud => ud.Device.DeviceId == device.DeviceId); _context.RemoveRange(ud); _context.SaveChanges(); } }
public string SetConnection(string username, DateTime expire) { var id = Guid.NewGuid().ToString(); db.Connections.Add(new Connection { ConnectionId = id, Username = username, ExpireDate = expire }); db.SaveChanges(); return(id); }
public IActionResult Put(int id, ParkingProfileViewModel model) { if (id == 0 && model == null) { return(null); } var parking = _dbContext.parkings .FirstOrDefault(p => p.ParkingId == id); var facilities = _dbContext.ParkingFacilities .FirstOrDefault(p => p.Parking.ParkingId == parking.ParkingId); if (parking == null) { return(NotFound()); } parking.Name = model.Name; parking.Description = model.Description; parking.City = model.City; parking.Address = model.Address; var result = _dbContext.Update(parking); if (_dbContext.SaveChanges() > 0) { if (facilities == null) { var facility = new ParkingFacilities() { Parking = parking, GuestRoom = model.GuestRoom, OnlinePayment = model.OnlinePayment, ServiceStation = model.ServiceStation }; _dbContext.Add(facilities); _dbContext.SaveChanges(); } else { facilities.ServiceStation = model.ServiceStation; facilities.OnlinePayment = model.OnlinePayment; facilities.GuestRoom = model.GuestRoom; _dbContext.Update(facilities); _dbContext.SaveChanges(); } } return(Ok()); }
//This methos should be used to Create a new User public bool CreateUser(User user) { context.Users.Add(user); int returnValue = context.SaveChanges(); return(returnValue > 0 ? true : false); }
/// <summary> /// Stores an XML Element to the database /// </summary> /// <param name="element">XML Element</param> /// <param name="friendlyName">Friendly Name</param> public void StoreElement(XElement element, string friendlyName) { if (element == null) { throw new ArgumentException("Element is null", nameof(element)); } var entity = _db.DataProtectionKeys.SingleOrDefault(k => k.FriendlyName == friendlyName); if (null != entity) { entity.XmlData = element.ToString(); _db.DataProtectionKeys.Update(entity); } else { _db.DataProtectionKeys.Add(new DataProtectionKey { FriendlyName = friendlyName, XmlData = element.ToString() }); } _db.SaveChanges(); }
public IActionResult Post([FromForm] IFormFile file, int id) { if (file == null && id == 0) { return(null); } ParkingImages model = new ParkingImages(); using (var memoryStream = new MemoryStream()) { file.CopyToAsync(memoryStream); model.Image = memoryStream.ToArray(); } model.Parking = _context.parkings.FirstOrDefault(p => p.ParkingId == id); var result = _context.Add(model); if (_context.SaveChanges() == 0) { return(BadRequest()); } return(Ok()); }
public IActionResult Post([FromForm] IFormFile file, int id) { var park = _context.parkings.FirstOrDefault(p => p.ParkingId == id); if (park == null) { return(NotFound()); } using (var memoryStream = new MemoryStream()) { file.CopyToAsync(memoryStream); park.ParkImage = memoryStream.ToArray(); } var result = _context.Update(park); if (_context.SaveChanges() == 0) { return(BadRequest()); } return(Ok()); }
public async Task <IActionResult> PutSlot(int slotId, SlotCreateViewModel model) { if (slotId == 0) { return(null); } var sLot = _context.slots.FirstOrDefault(p => p.SlotId == slotId); if (sLot == null) { return(NotFound()); } sLot.No = model.SlotNo; _context.Update(sLot); if (_context.SaveChanges() == 0) { return(BadRequest()); } return(Ok()); }
public AppUser AddNewUser(string provider, List <Claim> claims) { var appUser = new AppUser(); appUser.Provider = provider; appUser.NameIdentifier = claims.GetClaim(ClaimTypes.NameIdentifier); appUser.Username = claims.GetClaim("username"); appUser.Firstname = claims.GetClaim(ClaimTypes.GivenName); appUser.Lastname = claims.GetClaim(ClaimTypes.Surname); var name = claims.GetClaim("name"); // very rudimentary handling of splitting a users fullname into first and last name. Not very robust. if (string.IsNullOrEmpty(appUser.Firstname)) { appUser.Firstname = name?.Split(' ').First(); } if (string.IsNullOrEmpty(appUser.Lastname)) { var nameSplit = name?.Split(' '); if (nameSplit.Length > 1) { appUser.Lastname = name?.Split(' ').Last(); } } appUser.Email = claims.GetClaim(ClaimTypes.Email); appUser.Mobile = claims.GetClaim(ClaimTypes.MobilePhone); appUser.Roles = "NewUser"; var entity = _context.AppUsers.Add(appUser); _context.SaveChanges(); return(entity.Entity); }
public User Register(RegistrationModel model, string asRole) { var userRole = _roleRepository.Get(asRole); var salt = new byte[512 / 8]; _cryptoServiceProvider.GetNonZeroBytes(salt); var hashedPass = GetHashedPassword(model.Password, salt); var user = new User { Username = model.Username, Email = model.Email, Salt = salt, HashedPassword = hashedPass, Roles = new List <Role> { userRole } }; _userRepository.Add(user); _context.SaveChanges(); return(user); }
public void AuthDbContextTest() { using (var context = new AuthDbContext()) { context.SaveChanges(); } }
public void CreateUserAsync(UserDto user) { var usertomap = mapper.Map <User>(user); context.Users.Add(usertomap); context.SaveChanges(); }
public void Create(User user) { try { user.Password = Crypto.EncryptPassword(user.Password); Ctx.Users.Add(user); Ctx.SaveChanges(); Logger.LogInformation($"Salvando usuário -> {user.UserId}"); } catch (Exception ex) { Logger.LogError(ex.Message); throw; } }
/// <summary> /// initializing Acl tables, remove after using /// for using in Hillavas.BaseProject_MaterialPro.Data.Migrations.Configuration.cs /// just add "AclSeed.Init(context);" to seed method /// </summary> /// <param name="db">project context</param> public bool Init() { using (var bt = _db.Database.BeginTransaction()) { var rep = AddAdminUserAndRole(); if (!rep.Success) { return(false); } #region UserInRole var userInRole = new UserInRole() { UserId = rep.UserId, RoleId = rep.RoleId }; _db.Set <UserInRole>().Add(userInRole); if (_db.SaveChanges() == 0) { bt.Rollback(); return(false); } #endregion var actionsRep = AddActions(); if (!actionsRep.Success) { bt.Rollback(); return(false); } _db.Set <ActionInRole>().AddRange(actionsRep.actions.Select(x => new ActionInRole { RoleId = rep.RoleId, ActionId = x.ActionId, IsDefault = x.ActionName == "ProfileInfo" ? true : false })); if (_db.SaveChanges() == 0) { bt.Rollback(); return(false); } bt.Commit(); return(true); } }
private static void UpdateAdminPermissions(AuthDbContext dbContext) { // making sure the admin have all permissions after each deploy var dbContextPermissions = dbContext.Permissions.Where(x => x.UserId == 1).ToList(); dbContext.Permissions.RemoveRange(dbContextPermissions); dbContext.SaveChanges(); var allPermissions = Enum.GetValues(typeof(UserPermission)).Cast <UserPermission>() .Select(p => new Permission { UserPermission = p, UserId = 1 }); dbContext.Permissions.AddRange(allPermissions); dbContext.SaveChanges(); }
public static void Initialize(IApplicationBuilder app, AuthDbContext context) { context.Database.EnsureCreated(); InitializeTokenServerConfigurationDatabase(app); context.SaveChanges(); }
public static void Seed(this AuthDbContext dbContext) { dbContext.Products.Add(new Models.Product { Name = "Name1", LatinName = "LatinName1", Description = "Description1", Kind = "Kind1", Type = "Type1", Light = "Light1", Water = "Water1", ProductDate = DateTime.Now, Picture = null, PictureTwo = null, PictureThree = null, Trade = "Trade1", Delivery = "Delivery1", Soil = "Soil1" }); dbContext.Products.Add(new Models.Product { Name = "Name2", LatinName = "LatinName2", Description = "Description2", Kind = "Kind2", Type = "Type2", Light = "Light2", Water = "Water2", ProductDate = DateTime.Now, Picture = null, PictureTwo = null, PictureThree = null, Trade = "Trade2", Delivery = "Delivery2", Soil = "Soil2" }); dbContext.Products.Add(new Models.Product { Name = "Name3", LatinName = "LatinName3", Description = "Description3", Kind = "Kind3", Type = "Type3", Light = "Light3", Water = "Water3", ProductDate = DateTime.Now, Picture = null, PictureTwo = null, PictureThree = null, Trade = "Trade3", Delivery = "Delivery3", Soil = "Soil3" }); dbContext.SaveChanges(); }
public void Create() { new DefaultEditionCreator(_context).Create(); new DefaultLanguagesCreator(_context).Create(); new HostRoleAndUserCreator(_context).Create(); new DefaultSettingsCreator(_context).Create(); _context.SaveChanges(); }
public void UpdateAccount(Account account) { using (var context = new AuthDbContext()) { context.Entry(account).State = EntityState.Modified; context.SaveChanges(); } }
//database relationships public TermGrade InitializeGrades(string term) { var termGrade = new TermGrade { Term = term, Grade = 0 }; string[] types = { "Quiz1", "Quiz2", "Quiz3", "Assignment1", "Assignment2", "Assignment3" }; var item = new QuizOrAssignment(); for (int i = 0; i < types.Length; i++) { item = new QuizOrAssignment { Grade = 0, Type = types[i] }; authDbContext.Add(item); authDbContext.SaveChanges(); switch (i) { case 0: termGrade.Quiz1ID = item.ID; break; case 1: termGrade.Quiz2ID = item.ID; break; case 2: termGrade.Quiz3ID = item.ID; break; case 3: termGrade.Assignment1ID = item.ID; break; case 4: termGrade.Assignment2ID = item.ID; break; case 5: termGrade.Assignment3ID = item.ID; break; default: break; } } return(termGrade); }
public bool CreateUser(User user) { var createdUser = _context.Add(user); if (_context.SaveChanges() > 0) { return(true); } return(false); }
public ActionResult Register(AppUser user) { if (ModelState.IsValid) { db.AppUsers.Add(user); db.SaveChanges(); return(RedirectToAction("Login", "Accounts")); } return(View()); }
private void AddSettingIfNotExists(string name, string value, int?tenantId = null) { if (_context.Settings.Any(s => s.Name == name && s.TenantId == tenantId && s.UserId == null)) { return; } _context.Settings.Add(new Setting(tenantId, null, name, value)); _context.SaveChanges(); }
public IActionResult Create(Song song) { try { List <String> listExt = new List <String>() { "mp3", "wav", "m4a", "flac", "mp4", "wma", "aac" }; var Files = Request.Form.Files; foreach (var file in Files) { var songs = Path.Combine(hostingEnvironment.WebRootPath, "songs"); if (file.Length > 0) { string filename = Guid.NewGuid().ToString(); var old_filename = file.FileName.Split('.'); var extension = old_filename.Last().ToLower(); if (listExt.Contains(extension) == false) { ViewData["error_file_type"] = "You have send a non authorized type file"; return(View()); } song.PathFileSong = filename + "." + extension; using (var fileStream = new FileStream(Path.Combine(songs, song.PathFileSong), FileMode.Create)) { file.CopyTo(fileStream); } _context.Add(song); _context.SaveChanges(); } } return(View()); } catch { return(View()); } }
private void AddLanguageIfNotExists(ApplicationLanguage language) { if (_context.Languages.Any(l => l.TenantId == language.TenantId && l.Name == language.Name)) { return; } _context.Languages.Add(language); _context.SaveChanges(); }
public IActionResult GetUnreservedSlot(int id) { ReservationHistoryViewModel model = new ReservationHistoryViewModel(); if (id == 0) { } var slotreservation = _context.slotReservations.Include(p => p.slot).Include(p => p.slot.Parking) .FirstOrDefault(p => p.SlotReservationId == id && p.slot.Reserved == true); if (slotreservation != null) { slotreservation.ReservationEndTime = DateTime.Now; _context.Update(slotreservation); _context.SaveChanges(); } var slot = _context.slots.FirstOrDefault(p => p.SlotId == slotreservation.slot.SlotId); if (slot != null) { slot.Reserved = false; _context.Update(slot); _context.SaveChanges(); } model.Id = slotreservation.SlotReservationId; model.No = slotreservation.slot.SlotId; model.Parking = slotreservation.slot.Parking.Name; model.ReservationTime = slotreservation.ReservationTime.ToString(); model.EndTime = slotreservation.ReservationEndTime.ToString(); model.City = slotreservation.slot.Parking.City; return(new OkObjectResult(model)); }