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();
}
