private static void AddUserWithCreative()
{
var categories = GetCategories();
var category = categories[1];
var user = new User
{
Name = "Di",
BirthDate = DateTime.Now.AddYears(-25),
};
var crew = new Creative
{
CreativeName = "Another one genius",
Category = category,
User = user
};
user.Creatives.Add(crew);
using (var context = new TldrContext())
{
context.Users.Add(user);
context.SaveChanges();
}
}
private static void DeleteUser(String name)
{
using (var context = new TldrContext())
{
var user = context.Users.FirstOrDefault(c => c.Name == name);
context.Users.Remove(user);
context.SaveChanges();
}
}
private static void UpdateUser()
{
using (var context = new TldrContext())
{
var user = context.Users.FirstOrDefault(c => c.Name == "Diana");
user.BirthDate = DateTime.Now.AddYears(-25);
context.SaveChanges();
GetUser(user.UserID);
}
}
private static void DeleteUsers(string v)
{
using (var context = new TldrContext())
{
var users = context.Users.Where(c => c.Name == v).ToList();
foreach (var user in users)
{
context.Users.Remove(user);
}
context.SaveChanges();
}
}
private static List <Category> GetCategories()
{
using (var context = new TldrContext())
{
var category = new Category {
CategoryName = "new"
};
context.Categories.Add(category);
context.SaveChanges();
return(context.Categories.ToList <Category>());
}
}
