protected override async Task When() { using (var context = new ApplicationDataContext()) { try { context.Add(new Product { Id = Guid.NewGuid(), No = 1, Description = "Record 1" }); context.Add(new Product { Id = Guid.NewGuid(), No = 2, Description = "Record 2" }); context.Add(new Product { Id = Guid.NewGuid(), No = 3, Description = "Record 3" }); context.Add(new Product { Id = Guid.NewGuid(), No = 4, Description = "Record 4" }); context.Add(new Product { Id = Guid.NewGuid(), No = 5, Description = "Record 5" }); await context.SaveChangesAsync(); _result = await context.Products .OrderBy(e => e.No) .ToListAsync(); } catch (Exception e) { TestContext.WriteLine(e); throw; } } }
public async Task <IActionResult> UploadBlob([Bind("Title, VideoLink, Title, Description, DatePosted")] VideoModel VM) { CloudBlobContainer container = GetCloudBlobContainer(); CloudBlockBlob blob = container.GetBlockBlobReference(VM.Title); // Create the blob in blob storage var path = $@"{VM.VideoLink}"; var req = System.Net.WebRequest.Create(VM.VideoLink); using (Stream stream = req.GetResponse().GetResponseStream()) { blob.UploadFromStreamAsync(stream).Wait(); } var Wd = Directory.GetCurrentDirectory(); /* using (var fileStream = System.IO.File.OpenRead(path)) * { * blob.UploadFromStreamAsync(fileStream).Wait(); * }*/ VM.Owner = currentUser; // Add video meta data to the SQL DB if (ModelState.IsValid) { _context.Add(VM); await _context.SaveChangesAsync(); return(View("Home/Index")); } // if we got this far something went wrong return(View()); }
public async Task <IActionResult> CreateSucursal([FromBody] Sucursal nuevaSucursal) { try { // Validar si el objecto viene vacio if (nuevaSucursal == null) { return(BadRequest("Error: Modelo de Sucursal está vacio")); } // Validar si no posee la misma id que otro objecto if (await _dataContext.Sucursales .AsNoTracking() .AnyAsync(s => s.IdSucursal == nuevaSucursal.IdSucursal)) { return(BadRequest("Error: El id no es valido")); } // Validar si no posee el mismo nombre que otra sucursal if (await _dataContext.Sucursales.AsNoTracking().AnyAsync(s => s.NombreSucursal.ToLower() == nuevaSucursal.NombreSucursal.ToLower())) { return(BadRequest("Error: Ya existe una sucursal con el mismo nombre")); } // Pasa las validaciones y se guarda en la base de datos _dataContext.Add(nuevaSucursal); await _dataContext.SaveChangesAsync(); return(Ok()); } catch { return(BadRequest("Error")); } }
public async Task <IActionResult> CreateComuna([FromBody] Comuna nuevaComuna) { try { // Validar si el objecto viene vacio if (nuevaComuna == null) { return(BadRequest("Error: Modelo Comuna vacio")); } // Validar si no posee la misma id que otro objecto if (await _dataContext.Comunas.AsNoTracking().AnyAsync(comuna => comuna.Id == nuevaComuna.Id)) { return(BadRequest("Error: El id no es valido")); } // Validar si no posee el mismo nombre que otra comuna if (await _dataContext.Comunas.AsNoTracking().AnyAsync(comuna => comuna.Nombre.ToLower() == nuevaComuna.Nombre.ToLower())) { return(BadRequest("Error: Ya existe una comuna con el mismo nombre")); } // Pasa las validaciones y se guarda en la base de datos _dataContext.Add(nuevaComuna); await _dataContext.SaveChangesAsync(); return(Ok()); } catch { return(BadRequest("Error")); } }
public async Task MainAsync() { var db = new ApplicationDataContext(); var token = await db.Settings.FirstOrDefaultAsync(s => s.Id == "DISCORD_TOKEN"); if (token == null || token.Value == "") { Console.WriteLine("Please enter the discord token:"); if (token == null) { token = new Setting() { Id = "DISCORD_TOKEN" }; db.Add(token); } token.Value = Console.ReadLine(); await db.SaveChangesAsync(); } db.Dispose(); await _client.LoginAsync(Discord.TokenType.Bot, token.Value); await _client.StartAsync(); await Task.Delay(-1, MainThread.Token); }
public async Task <IActionResult> Create([Bind("Name,Trainer")] Horse horse, int raceId, int laneId, int year) { ApplicationUser user = await _userManager.GetUserAsync(HttpContext.User); Race race = await _context.Races.FindAsync(raceId, laneId, year); if (ModelState.IsValid) { Guid id = Guid.NewGuid(); horse.Id = id; horse.ApplicationUserId = user.Id; _context.Add(horse); try { race.HorseId = id; _context.Update(race); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!HorseExists(horse.Id)) { return(NotFound()); } else { throw; } } await _context.SaveChangesAsync(); return(RedirectToAction("Race", "Races", new { raceNbr = raceId })); } return(View(horse)); }
public async Task <IActionResult> _GroupCreate(Group group) { ApplicationUser user = await _userManager.GetUserAsync(HttpContext.User); if (ModelState.IsValid) { group.ApplicationUserId = user.Id; _context.Add(group); //foreach (var member in group.Members) //{ // member.GroupId = group.Id; // _context.Add(member); //} await _context.SaveChangesAsync(); return(RedirectToAction("UserCart", "ApplicationUser")); } return(View(group)); }
public bool Add <TEntity>(TEntity entity) where TEntity : class { try { _dataContext.Add(entity); return(true); } catch (Exception) { return(false); } }
private async Task GuildUserUpdatedAsync(SocketUser prevUser, SocketUser newUser) { var db = new ApplicationDataContext(); await Log.LogAsync(newUser, $"{newUser.Username} Status change {newUser.Status} {newUser.Activity.Name}"); db.Add(new DiscordUserEvent() { EventTime = DateTime.Now, Game = newUser.Activity.Name, Status = newUser.Status.ToString(), UserId = newUser.Id }); await db.SaveChangesAsync(); db.Dispose(); }
protected override void Up(MigrationBuilder migrationBuilder) { var ctx = new ApplicationDataContext(); ctx.Add(new RelatedVoiceEvent() { InitalEvent = "Joined", SecondaryEvent = "Left", IsPrimary = true }); ctx.Add(new RelatedVoiceEvent() { InitalEvent = "Admin Deafened", SecondaryEvent = "Admin Undeafened", IsPrimary = true }); ctx.Add(new RelatedVoiceEvent() { InitalEvent = "Admin Muted", SecondaryEvent = "Admin Unmuted", IsPrimary = true }); ctx.Add(new RelatedVoiceEvent() { InitalEvent = "Self Deafened", SecondaryEvent = "Self Undeafened", IsPrimary = true }); ctx.Add(new RelatedVoiceEvent() { InitalEvent = "Self Muted", SecondaryEvent = "Self Unmuted", IsPrimary = true }); ctx.Add(new RelatedVoiceEvent() { InitalEvent = "Self Muted", SecondaryEvent = "Left", IsPrimary = false }); ctx.Add(new RelatedVoiceEvent() { InitalEvent = "Self Deafened", SecondaryEvent = "Left", IsPrimary = false }); ctx.Add(new RelatedVoiceEvent() { InitalEvent = "Admin Deafened", SecondaryEvent = "Left", IsPrimary = false }); ctx.Add(new RelatedVoiceEvent() { InitalEvent = "Admin Muted", SecondaryEvent = "Left", IsPrimary = false }); ctx.SaveChanges(); }
private async Task ReactionAddedAsync(Cacheable <IUserMessage, ulong> arg1, ISocketMessageChannel arg2, SocketReaction arg3) { Console.WriteLine($"Adding Reaction {arg3.Emote.Name}"); using (var db = new ApplicationDataContext()) { await DiscordMessage.CreateOrGetAsync(await arg1.GetOrDownloadAsync()); var reaction = new UserMessageReaction() { Created = DateTime.UtcNow, MessageId = arg3.MessageId, ReactorId = arg3.UserId, Reaction = arg3.Emote.Name }; db.Add(reaction); await db.SaveChangesAsync(); } }
private static async Task Add(SocketMessage message, string[] parts) { if (message.MentionedUsers.Count() != 1) { await message.Channel.SendMessageAsync("Please include only one author with an @"); return; } await DiscordUser.CreateOrGetAsync(message.Author); await DiscordUser.CreateOrGetAsync(message.MentionedUsers.First()); var quoteText = parts.Skip(2).Where(s => !s.Contains(message.MentionedUsers.First().Mention)).SkipLast(1).Aggregate("", (c, n) => c + " " + n).Trim(); var quote = new Quote() { AddedById = message.Author.Id, AuthorId = message.MentionedUsers.First().Id, Created = DateTime.Now, QuoteText = quoteText }; _db.Add(quote); await _db.SaveChangesAsync(); await message.Channel.SendMessageAsync($"Quote {quote.Id} created!"); }
public void Add(Question question) { _context.Add(question); _context.SaveChanges(); }
public void Add(Quiz quiz) { _context.Add(quiz); _context.SaveChanges(); }