public Users RegisterUser(Models.UserRegistration userRegister)
{
var userInDbUserName = _context.Users.FirstOrDefault(x => x.Username == userRegister.Username);
var userInDbEmail = _context.Users.FirstOrDefault(x => x.Email == userRegister.Email);
if (userInDbUserName != null)
{
throw new UserException("Username already in use!");
}
if (userInDbEmail != null)
{
throw new UserException("Email already in use!");
}
if (userRegister.Password != userRegister.PasswordConfirmation)
{
throw new UserException("Passwords do not match!");
}
var user = new Users
{
Email = userRegister.Email,
Username = userRegister.Username,
FirstName = userRegister.FirstName,
LastName = userRegister.LastName,
JoinDate = DateTime.Now
};
user.PasswordSalt = HashGenSalt.GenerateSalt();
user.PasswordHash = HashGenSalt.GenerateHash(user.PasswordSalt, userRegister.Password);
_context.Users.Add(user);
_context.SaveChanges();
foreach (var role in userRegister.Roles)
{
UsersRoles usersRoles = new UsersRoles
{
UserId = user.Id,
RoleId = role
};
_context.UsersRoles.Add(usersRoles);
}
_context.SaveChanges();
return(user);
}
public UserAuthenticationResult Authenticate(UserLoginModel model)
{
var user = _context.Users
.Include(x => x.UsersRoles)
.ThenInclude(x => x.Role)
.FirstOrDefault(x => x.Username == model.Username);
if (user == null)
{
throw new ArgumentNullException("Error");
}
if (user.PasswordHash != HashGenSalt.GenerateHash(user.PasswordSalt, model.Password))
{
return(null);
}
var tokenHandler = new JwtSecurityTokenHandler();
var key = Encoding.ASCII.GetBytes(_options.Value.Secret);
var tokenDescriptor = new SecurityTokenDescriptor
{
Subject = new ClaimsIdentity(new Claim[]
{
new Claim(ClaimTypes.NameIdentifier, user.Id.ToString()),
new Claim(ClaimTypes.Name, user.Username),
}),
Issuer = _options.Value.Issuer,
Expires = DateTime.UtcNow.AddDays(7),
SigningCredentials = new SigningCredentials(new SymmetricSecurityKey(key), SecurityAlgorithms.HmacSha256Signature)
};
var token = tokenHandler.CreateToken(tokenDescriptor);
return(new UserAuthenticationResult
{
Id = user.Id,
Token = tokenHandler.WriteToken(token),
Username = user.Username
});
}
partial void OnModelCreatingPartial(ModelBuilder modelBuilder)
{
var webClient = new WebClient();
var korisnikLozinkaSalt = HashGenSalt.GenerateSalt();
var korisnikLozinkaHash = HashGenSalt.GenerateHash(korisnikLozinkaSalt, "test");
var kupacLozinkaSalt = HashGenSalt.GenerateSalt();
var kupacLozinkaHash = HashGenSalt.GenerateHash(kupacLozinkaSalt, "test");
//KORISNICI
modelBuilder.Entity <Korisnici>().HasData(new Korisnici()
{
KorisnikId = 5,
Email = "*****@*****.**",
Ime = "test",
Prezime = "test",
DatumRodjenja = DateTime.Now,
KorisnickoIme = "*****@*****.**",
LozinkaSalt = korisnikLozinkaSalt,
LozinkaHash = korisnikLozinkaHash
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 1,
Title = "The Shawshank Redemption",
Description = "Two imprisoned men bond over a number of years, finding solace and eventual redemption through acts of common decency.",
ReleaseDate = DateTime.Parse("1994-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BNjQ2NDA3MDcxMF5BMl5BanBnXkFtZTgwMjE5NTU0NzE@._V1_CR0,60,640,360_AL_UX477_CR0,0,477,268_AL_.jpg"),
Type = "Movie"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 2,
Title = "The Godfather",
Description = "An organized crime dynasty's aging patriarch transfers control of his clandestine empire to his reluctant son.",
ReleaseDate = DateTime.Parse("1972-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BM2MyNjYxNmUtYTAwNi00MTYxLWJmNWYtYzZlODY3ZTk3OTFlXkEyXkFqcGdeQXVyNzkwMjQ5NzM@._V1_UY268_CR3,0,182,268_AL_.jpg"),
Type = "Movie"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 3,
Title = "The Godfather: Part II",
Description = "The early life and career of Vito Corleone in 1920s New York City is portrayed, while his son, Michael, expands and tightens his grip on the family crime syndicate.",
ReleaseDate = DateTime.Parse("1974-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BMWMwMGQzZTItY2JlNC00OWZiLWIyMDctNDk2ZDQ2YjRjMWQ0XkEyXkFqcGdeQXVyNzkwMjQ5NzM@._V1_UY268_CR3,0,182,268_AL_.jpg"),
Type = "Movie"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 4,
Title = "The Dark Knight",
Description = "When the menace known as the Joker wreaks havoc and chaos on the people of Gotham, Batman must accept one of the greatest psychological and physical tests of his ability to fight injustice.",
ReleaseDate = DateTime.Parse("2008-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BMTMxNTMwODM0NF5BMl5BanBnXkFtZTcwODAyMTk2Mw@@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "Movie"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 5,
Title = "12 Angry Men",
Description = "A jury holdout attempts to prevent a miscarriage of justice by forcing his colleagues to reconsider the evidence.",
ReleaseDate = DateTime.Parse("1957-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BMWU4N2FjNzYtNTVkNC00NzQ0LTg0MjAtYTJlMjFhNGUxZDFmXkEyXkFqcGdeQXVyNjc1NTYyMjg@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "Movie"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 6,
Title = "The Lord of the Rings: The Return of the King",
Description = "Gandalf and Aragorn lead the World of Men against Sauron's army to draw his gaze from Frodo and Sam as they approach Mount Doom with the One Ring.",
ReleaseDate = DateTime.Parse("2003-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BNzA5ZDNlZWMtM2NhNS00NDJjLTk4NDItYTRmY2EwMWZlMTY3XkEyXkFqcGdeQXVyNzkwMjQ5NzM@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "Movie"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 7,
Title = "Schindler's List",
Description = "In German-occupied Poland during World War II, industrialist Oskar Schindler gradually becomes concerned for his Jewish workforce after witnessing their persecution by the Nazis.",
ReleaseDate = DateTime.Parse("1993-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BNDE4OTMxMTctNmRhYy00NWE2LTg3YzItYTk3M2UwOTU5Njg4XkEyXkFqcGdeQXVyNjU0OTQ0OTY@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "Movie"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 8,
Title = "Pulp Fiction",
Description = "The lives of two mob hitmen, a boxer, a gangster and his wife, and a pair of diner bandits intertwine in four tales of violence and redemption.",
ReleaseDate = DateTime.Parse("1994-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BNGNhMDIzZTUtNTBlZi00MTRlLWFjM2ItYzViMjE3YzI5MjljXkEyXkFqcGdeQXVyNzkwMjQ5NzM@._V1_UY268_CR1,0,182,268_AL_.jpg"),
Type = "Movie"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 9,
Title = "The Good, the Bad and the Ugly",
Description = "A bounty hunting scam joins two men in an uneasy alliance against a third in a race to find a fortune in gold buried in a remote cemetery.",
ReleaseDate = DateTime.Parse("1966-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BOTQ5NDI3MTI4MF5BMl5BanBnXkFtZTgwNDQ4ODE5MDE@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "Movie"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 10,
Title = "The Lord of the Rings: The Fellowship of the Ring",
Description = "A meek Hobbit from the Shire and eight companions set out on a journey to destroy the powerful One Ring and save Middle-earth from the Dark Lord Sauron.",
ReleaseDate = DateTime.Parse("2001-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BN2EyZjM3NzUtNWUzMi00MTgxLWI0NTctMzY4M2VlOTdjZWRiXkEyXkFqcGdeQXVyNDUzOTQ5MjY@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "Movie"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 11,
Title = "Fight Club",
Description = "Two imprisoned men bond over a number of years, finding solace and eventual redemption through acts of common decency.",
ReleaseDate = DateTime.Parse("1999-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BMmEzNTkxYjQtZTc0MC00YTVjLTg5ZTEtZWMwOWVlYzY0NWIwXkEyXkFqcGdeQXVyNzkwMjQ5NzM@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "Movie"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 12,
Title = "Forrest Gump",
Description = "The presidencies of Kennedy and Johnson, the events of Vietnam, Watergate and other historical events unfold through the perspective of an Alabama man with an IQ of 75",
ReleaseDate = DateTime.Parse("1994-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BNWIwODRlZTUtY2U3ZS00Yzg1LWJhNzYtMmZiYmEyNmU1NjMzXkEyXkFqcGdeQXVyMTQxNzMzNDI@._V1_UY268_CR1,0,182,268_AL_.jpg"),
Type = "Movie"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 13,
Title = "Inception",
Description = "A thief who steals corporate secrets through the use of dream-sharing technology is given the inverse task of planting an idea into the mind of a C.E.O.",
ReleaseDate = DateTime.Parse("2010-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BMjAxMzY3NjcxNF5BMl5BanBnXkFtZTcwNTI5OTM0Mw@@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "Movie"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 14,
Title = "The Lord of the Rings: The Two Towers",
Description = "While Frodo and Sam edge closer to Mordor with the help of the shifty Gollum, the divided fellowship makes a stand against Sauron's new ally, Saruman, and his hordes of Isengard.",
ReleaseDate = DateTime.Parse("2002-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BZGMxZTdjZmYtMmE2Ni00ZTdkLWI5NTgtNjlmMjBiNzU2MmI5XkEyXkFqcGdeQXVyNjU0OTQ0OTY@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "Movie"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 15,
Title = "Planet",
Description = "Greed and class discrimination threaten the newly formed symbiotic relationship between the wealthy Park family and the destitute Kim clan.",
ReleaseDate = DateTime.Parse("2019-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BYWZjMjk3ZTItODQ2ZC00NTY5LWE0ZDYtZTI3MjcwN2Q5NTVkXkEyXkFqcGdeQXVyODk4OTc3MTY@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "TV Show"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 16,
Title = "Planet 2",
Description = "Two imprisoned men bond over a number of years, finding solace and eventual redemption through acts of common decency.",
ReleaseDate = DateTime.Parse("1999-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BMmEzNTkxYjQtZTc0MC00YTVjLTg5ZTEtZWMwOWVlYzY0NWIwXkEyXkFqcGdeQXVyNzkwMjQ5NzM@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "TV Show"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 17,
Title = "Dexter",
Description = "The presidencies of Kennedy and Johnson, the events of Vietnam, Watergate and other historical events unfold through the perspective of an Alabama man with an IQ of 75",
ReleaseDate = DateTime.Parse("1994-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BNWIwODRlZTUtY2U3ZS00Yzg1LWJhNzYtMmZiYmEyNmU1NjMzXkEyXkFqcGdeQXVyMTQxNzMzNDI@._V1_UY268_CR1,0,182,268_AL_.jpg"),
Type = "TV Show"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 18,
Title = "Friends",
Description = "A thief who steals corporate secrets through the use of dream-sharing technology is given the inverse task of planting an idea into the mind of a C.E.O.",
ReleaseDate = DateTime.Parse("2010-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BMjAxMzY3NjcxNF5BMl5BanBnXkFtZTcwNTI5OTM0Mw@@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "TV Show"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 19,
Title = "Two and a half man",
Description = "While Frodo and Sam edge closer to Mordor with the help of the shifty Gollum, the divided fellowship makes a stand against Sauron's new ally, Saruman, and his hordes of Isengard.",
ReleaseDate = DateTime.Parse("2002-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BZGMxZTdjZmYtMmE2Ni00ZTdkLWI5NTgtNjlmMjBiNzU2MmI5XkEyXkFqcGdeQXVyNjU0OTQ0OTY@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "TV Show"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 20,
Title = "Bing bang teory",
Description = "Greed and class discrimination threaten the newly formed symbiotic relationship between the wealthy Park family and the destitute Kim clan.",
ReleaseDate = DateTime.Parse("2019-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BYWZjMjk3ZTItODQ2ZC00NTY5LWE0ZDYtZTI3MjcwN2Q5NTVkXkEyXkFqcGdeQXVyODk4OTc3MTY@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "TV Show"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 21,
Title = "Planet 3",
Description = "Two imprisoned men bond over a number of years, finding solace and eventual redemption through acts of common decency.",
ReleaseDate = DateTime.Parse("1999-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BMmEzNTkxYjQtZTc0MC00YTVjLTg5ZTEtZWMwOWVlYzY0NWIwXkEyXkFqcGdeQXVyNzkwMjQ5NzM@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "TV Show"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 22,
Title = "Dexter 2",
Description = "The presidencies of Kennedy and Johnson, the events of Vietnam, Watergate and other historical events unfold through the perspective of an Alabama man with an IQ of 75",
ReleaseDate = DateTime.Parse("1994-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BNWIwODRlZTUtY2U3ZS00Yzg1LWJhNzYtMmZiYmEyNmU1NjMzXkEyXkFqcGdeQXVyMTQxNzMzNDI@._V1_UY268_CR1,0,182,268_AL_.jpg"),
Type = "TV Show"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 23,
Title = "Friends 3",
Description = "A thief who steals corporate secrets through the use of dream-sharing technology is given the inverse task of planting an idea into the mind of a C.E.O.",
ReleaseDate = DateTime.Parse("2010-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BMjAxMzY3NjcxNF5BMl5BanBnXkFtZTcwNTI5OTM0Mw@@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "TV Show"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 24,
Title = "Two and a half man 2",
Description = "While Frodo and Sam edge closer to Mordor with the help of the shifty Gollum, the divided fellowship makes a stand against Sauron's new ally, Saruman, and his hordes of Isengard.",
ReleaseDate = DateTime.Parse("2002-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BZGMxZTdjZmYtMmE2Ni00ZTdkLWI5NTgtNjlmMjBiNzU2MmI5XkEyXkFqcGdeQXVyNjU0OTQ0OTY@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "TV Show"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 25,
Title = "Bing bang teory 5",
Description = "Greed and class discrimination threaten the newly formed symbiotic relationship between the wealthy Park family and the destitute Kim clan.",
ReleaseDate = DateTime.Parse("2019-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BYWZjMjk3ZTItODQ2ZC00NTY5LWE0ZDYtZTI3MjcwN2Q5NTVkXkEyXkFqcGdeQXVyODk4OTc3MTY@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "TV Show"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 26,
Title = "Friends 4",
Description = "A thief who steals corporate secrets through the use of dream-sharing technology is given the inverse task of planting an idea into the mind of a C.E.O.",
ReleaseDate = DateTime.Parse("2010-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BMjAxMzY3NjcxNF5BMl5BanBnXkFtZTcwNTI5OTM0Mw@@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "TV Show"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 27,
Title = "Two and a half man 3",
Description = "While Frodo and Sam edge closer to Mordor with the help of the shifty Gollum, the divided fellowship makes a stand against Sauron's new ally, Saruman, and his hordes of Isengard.",
ReleaseDate = DateTime.Parse("2002-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BZGMxZTdjZmYtMmE2Ni00ZTdkLWI5NTgtNjlmMjBiNzU2MmI5XkEyXkFqcGdeQXVyNjU0OTQ0OTY@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "TV Show"
});
modelBuilder.Entity <Articles>().HasData(new Articles()
{
ArticleId = 28,
Title = "Bing bang teory 4",
Description = "Greed and class discrimination threaten the newly formed symbiotic relationship between the wealthy Park family and the destitute Kim clan.",
ReleaseDate = DateTime.Parse("2019-06-24"),
Image = webClient.DownloadData("https://m.media-amazon.com/images/M/MV5BYWZjMjk3ZTItODQ2ZC00NTY5LWE0ZDYtZTI3MjcwN2Q5NTVkXkEyXkFqcGdeQXVyODk4OTc3MTY@._V1_UX182_CR0,0,182,268_AL_.jpg"),
Type = "TV Show"
});
//ACTORS
modelBuilder.Entity <Actors>().HasData(new Actors()
{
ActorId = 1,
Name = "Kang-ho Song",
Age = 44
});
modelBuilder.Entity <Actors>().HasData(new Actors()
{
ActorId = 2,
Name = "Morgan Freeman",
Age = 82
});
modelBuilder.Entity <Actors>().HasData(new Actors()
{
ActorId = 3,
Name = "Tim Robbins",
Age = 44
});
modelBuilder.Entity <Actors>().HasData(new Actors()
{
ActorId = 4,
Name = "Al Pacino",
Age = 44
});
modelBuilder.Entity <Actors>().HasData(new Actors()
{
ActorId = 5,
Name = "John Travolta",
Age = 44
});
modelBuilder.Entity <Actors>().HasData(new Actors()
{
ActorId = 6,
Name = "Samuel L. Jackson",
Age = 44
});
modelBuilder.Entity <Actors>().HasData(new Actors()
{
ActorId = 7,
Name = "Henry Fonda",
Age = 44
});
modelBuilder.Entity <Actors>().HasData(new Actors()
{
ActorId = 8,
Name = "Leonardo DiCaprio",
Age = 44
});
modelBuilder.Entity <Actors>().HasData(new Actors()
{
ActorId = 9,
Name = "Joseph Gordon-Levitt",
Age = 44
});
modelBuilder.Entity <Actors>().HasData(new Actors()
{
ActorId = 10,
Name = "Elliot Page",
Age = 44
});
modelBuilder.Entity <ArticleActorRelation>().HasData(new ArticleActorRelation()
{
RelationId = 1,
ActorId = 1,
ArticleId = 1
});
modelBuilder.Entity <ArticleActorRelation>().HasData(new ArticleActorRelation()
{
RelationId = 2,
ActorId = 2,
ArticleId = 2,
});
modelBuilder.Entity <ArticleActorRelation>().HasData(new ArticleActorRelation()
{
RelationId = 3,
ActorId = 3,
ArticleId = 3,
});
modelBuilder.Entity <ArticleActorRelation>().HasData(new ArticleActorRelation()
{
RelationId = 4,
ActorId = 4,
ArticleId = 4,
});
modelBuilder.Entity <ArticleActorRelation>().HasData(new ArticleActorRelation()
{
RelationId = 5,
ActorId = 5,
ArticleId = 5,
});
modelBuilder.Entity <ArticleActorRelation>().HasData(new ArticleActorRelation()
{
RelationId = 6,
ActorId = 6,
ArticleId = 6,
});
modelBuilder.Entity <ArticleActorRelation>().HasData(new ArticleActorRelation()
{
RelationId = 7,
ActorId = 7,
ArticleId = 7,
});
modelBuilder.Entity <ArticleActorRelation>().HasData(new ArticleActorRelation()
{
RelationId = 8,
ActorId = 8,
ArticleId = 8,
});
modelBuilder.Entity <ArticleActorRelation>().HasData(new ArticleActorRelation()
{
RelationId = 9,
ActorId = 9,
ArticleId = 9,
});
modelBuilder.Entity <ArticleActorRelation>().HasData(new ArticleActorRelation()
{
RelationId = 10,
ActorId = 10,
ArticleId = 10,
});
modelBuilder.Entity <ArticleActorRelation>().HasData(new ArticleActorRelation()
{
RelationId = 11,
ActorId = 6,
ArticleId = 11,
});
modelBuilder.Entity <ArticleActorRelation>().HasData(new ArticleActorRelation()
{
RelationId = 12,
ActorId = 5,
ArticleId = 12,
});
modelBuilder.Entity <ArticleActorRelation>().HasData(new ArticleActorRelation()
{
RelationId = 13,
ActorId = 2,
ArticleId = 1,
});
modelBuilder.Entity <ArticleActorRelation>().HasData(new ArticleActorRelation()
{
RelationId = 14,
ActorId = 5,
ArticleId = 15,
});
//RATING
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 1,
ArticleId = 1,
Grade = 5,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 2,
ArticleId = 2,
Grade = 5,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 3,
ArticleId = 3,
Grade = 5,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 4,
ArticleId = 4,
Grade = 4,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 5,
ArticleId = 5,
Grade = 4,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 6,
ArticleId = 6,
Grade = 5,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 7,
ArticleId = 7,
Grade = 3,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 8,
ArticleId = 8,
Grade = 3,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 9,
ArticleId = 9,
Grade = 2,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 10,
ArticleId = 10,
Grade = 5,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 11,
ArticleId = 11,
Grade = 3,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 12,
ArticleId = 12,
Grade = 3,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 13,
ArticleId = 13,
Grade = 3,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 14,
ArticleId = 14,
Grade = 5,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 15,
ArticleId = 15,
Grade = 2,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 16,
ArticleId = 16,
Grade = 5,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 17,
ArticleId = 17,
Grade = 5,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 18,
ArticleId = 18,
Grade = 5,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 19,
ArticleId = 19,
Grade = 4,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 20,
ArticleId = 20,
Grade = 4,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 21,
ArticleId = 21,
Grade = 5,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 22,
ArticleId = 22,
Grade = 3,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 23,
ArticleId = 23,
Grade = 2,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 24,
ArticleId = 24,
Grade = 5,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 25,
ArticleId = 25,
Grade = 4,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 26,
ArticleId = 26,
Grade = 5,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 27,
ArticleId = 27,
Grade = 3,
});
modelBuilder.Entity <Rating>().HasData(new Rating()
{
RatingId = 28,
ArticleId = 28,
Grade = 3,
});
}
partial void OnModelCreatingPartial(ModelBuilder modelBuilder)
{
//users
Users u1 = new Users
{
Id = 1,
Email = "*****@*****.**",
FirstName = "test",
JoinDate = DateTime.Now,
LastName = "test",
Username = "******"
};
u1.PasswordSalt = HashGenSalt.GenerateSalt();
u1.PasswordHash = HashGenSalt.GenerateHash(u1.PasswordSalt, "test");
modelBuilder.Entity <Users>().HasData(u1);
Users u2 = new Users
{
Id = 2,
Email = "*****@*****.**",
FirstName = "test",
JoinDate = DateTime.Now,
LastName = "test",
Username = "******"
};
u2.PasswordSalt = HashGenSalt.GenerateSalt();
u2.PasswordHash = HashGenSalt.GenerateHash(u2.PasswordSalt, "test");
modelBuilder.Entity <Users>().HasData(u2);
//roles
modelBuilder.Entity <Roles>().HasData(new WebAPI.Database.Roles()
{
Id = 1,
Name = "Administrator"
});
modelBuilder.Entity <Roles>().HasData(new WebAPI.Database.Roles()
{
Id = 2,
Name = "Member"
});
//users roles
modelBuilder.Entity <UsersRoles>().HasData(new WebAPI.Database.UsersRoles()
{
Id = 1,
RoleId = 1,
UserId = 1
});
modelBuilder.Entity <UsersRoles>().HasData(new WebAPI.Database.UsersRoles()
{
Id = 2,
RoleId = 2,
UserId = 2
});
//cities
modelBuilder.Entity <Cities>().HasData(new WebAPI.Database.Cities()
{
Id = 1,
Name = "Dortmund",
PostalCode = 1132
});
modelBuilder.Entity <Cities>().HasData(new WebAPI.Database.Cities()
{
Id = 2,
Name = "Berlin",
PostalCode = 1134
});
modelBuilder.Entity <Cities>().HasData(new WebAPI.Database.Cities()
{
Id = 3,
Name = "Munchen",
PostalCode = 421
});
modelBuilder.Entity <Cities>().HasData(new WebAPI.Database.Cities()
{
Id = 4,
Name = "Frankfurt",
PostalCode = 42
});
modelBuilder.Entity <Cities>().HasData(new WebAPI.Database.Cities()
{
Id = 5,
Name = "Nurnberg",
PostalCode = 243
});
modelBuilder.Entity <Cities>().HasData(new WebAPI.Database.Cities()
{
Id = 6,
Name = "Wiesbaden",
PostalCode = 15
});
modelBuilder.Entity <Cities>().HasData(new WebAPI.Database.Cities()
{
Id = 7,
Name = "Hamburg",
PostalCode = 2143
});
modelBuilder.Entity <Cities>().HasData(new WebAPI.Database.Cities()
{
Id = 8,
Name = "Leverkusen",
PostalCode = 1442
});
//positions
modelBuilder.Entity <Positions>().HasData(new WebAPI.Database.Positions()
{
Id = 1,
Abbreviation = "GK",
Name = "GoalKeper"
});
modelBuilder.Entity <Positions>().HasData(new WebAPI.Database.Positions()
{
Id = 2,
Abbreviation = "CB",
Name = "CentreBack"
});
modelBuilder.Entity <Positions>().HasData(new WebAPI.Database.Positions()
{
Id = 3,
Abbreviation = "MF",
Name = "Midfield"
});
modelBuilder.Entity <Positions>().HasData(new WebAPI.Database.Positions()
{
Id = 4,
Abbreviation = "ST",
Name = "Striker"
});
//leagues
modelBuilder.Entity <Leagues>().HasData(new WebAPI.Database.Leagues()
{
Id = 1,
Name = "Bundesliga",
Established = DateTime.Now,
Organizer = "DFB"
});
modelBuilder.Entity <Leagues>().HasData(new WebAPI.Database.Leagues()
{
Id = 2,
Name = "Bundesliga 2",
Established = DateTime.Now,
Organizer = "DFB"
});
//clubs
modelBuilder.Entity <Clubs>().HasData(new WebAPI.Database.Clubs()
{
Id = 1,
Name = "Borussia Dortmund",
Abbreviation = "BVB",
CityId = 1,
Founded = DateTime.Now,
Logo = File.ReadAllBytes("../Img/BorussiaDortmund.png"),
MarketValue = 1000000,
Nickname = "Milioneri"
});
modelBuilder.Entity <Clubs>().HasData(new WebAPI.Database.Clubs()
{
Id = 2,
Name = "Hertha Berlin",
Abbreviation = "HB",
CityId = 2,
Founded = DateTime.Now,
Logo = File.ReadAllBytes("../Img/HerthaBerlin.png"),
MarketValue = 244443,
Nickname = "Berliners"
});
modelBuilder.Entity <Clubs>().HasData(new WebAPI.Database.Clubs()
{
Id = 3,
Name = "Union Berlin",
Abbreviation = "UB",
CityId = 2,
Founded = DateTime.Now,
Logo = File.ReadAllBytes("../Img/UnionBerlin.jpg"),
MarketValue = 72532,
Nickname = "Berliners"
});
modelBuilder.Entity <Clubs>().HasData(new WebAPI.Database.Clubs()
{
Id = 4,
Name = "Bayern Munchen",
Abbreviation = "BMH",
CityId = 3,
Founded = DateTime.Now,
Logo = File.ReadAllBytes("../Img/BayernMunich.png"),
MarketValue = 72532,
Nickname = "Bavarci"
});
modelBuilder.Entity <Clubs>().HasData(new WebAPI.Database.Clubs()
{
Id = 5,
Name = "Nurnberg",
Abbreviation = "NB",
CityId = 5,
Founded = DateTime.Now,
Logo = File.ReadAllBytes("../Img/Nurnberg.png"),
MarketValue = 237981,
Nickname = "Bergs"
});
modelBuilder.Entity <Clubs>().HasData(new WebAPI.Database.Clubs()
{
Id = 6,
Name = "St. Pauli",
Abbreviation = "STP",
CityId = 7,
Founded = DateTime.Now,
Logo = File.ReadAllBytes("../Img/StPauli.png"),
MarketValue = 7234,
Nickname = "Pauls"
});
modelBuilder.Entity <Clubs>().HasData(new WebAPI.Database.Clubs()
{
Id = 7,
Name = "Bayer Leverkusen",
Abbreviation = "BLE",
CityId = 8,
Founded = DateTime.Now,
Logo = File.ReadAllBytes("../Img/Leverkuzen.png"),
MarketValue = 151243,
Nickname = "Pharmacists"
});
modelBuilder.Entity <Clubs>().HasData(new WebAPI.Database.Clubs()
{
Id = 8,
Name = "Wehen Wiesbaden",
Abbreviation = "WW",
CityId = 6,
Founded = DateTime.Now,
Logo = File.ReadAllBytes("../Img/Wiesbaden.png"),
MarketValue = 151243,
Nickname = "Pharmacists"
});
//stadium
modelBuilder.Entity <Stadiums>().HasData(new WebAPI.Database.Stadiums()
{
Id = 1,
Capacity = 80000,
ClubId = 1,
DateBuilt = DateTime.Now,
Name = "Signal Iduna Park"
});
modelBuilder.Entity <Stadiums>().HasData(new WebAPI.Database.Stadiums()
{
Id = 2,
Capacity = 75000,
ClubId = 2,
DateBuilt = DateTime.Now,
Name = "Olympiastadion Berlin"
});
modelBuilder.Entity <Stadiums>().HasData(new WebAPI.Database.Stadiums()
{
Id = 3,
Capacity = 70000,
ClubId = 3,
DateBuilt = DateTime.Now,
Name = "Stadion An der Alten Försterei"
});
modelBuilder.Entity <Stadiums>().HasData(new WebAPI.Database.Stadiums()
{
Id = 4,
Capacity = 75000,
ClubId = 4,
DateBuilt = DateTime.Now,
Name = "Allianz Arena"
});
modelBuilder.Entity <Stadiums>().HasData(new WebAPI.Database.Stadiums()
{
Id = 5,
Capacity = 40000,
ClubId = 5,
DateBuilt = DateTime.Now,
Name = "Max-Morlock-Stadion"
});
modelBuilder.Entity <Stadiums>().HasData(new WebAPI.Database.Stadiums()
{
Id = 6,
Capacity = 35000,
ClubId = 6,
DateBuilt = DateTime.Now,
Name = "Millerntor-Stadion"
});
modelBuilder.Entity <Stadiums>().HasData(new WebAPI.Database.Stadiums()
{
Id = 7,
Capacity = 55000,
ClubId = 7,
DateBuilt = DateTime.Now,
Name = "BayArena"
});
modelBuilder.Entity <Stadiums>().HasData(new WebAPI.Database.Stadiums()
{
Id = 8,
Capacity = 40000,
ClubId = 8,
DateBuilt = DateTime.Now,
Name = "Brita-Arena"
});
//referee
modelBuilder.Entity <Referees>().HasData(new WebAPI.Database.Referees()
{
Id = 1,
CityId = 1,
FirstName = "Felix",
LastName = "Magath",
MiddleName = "N/A"
});
modelBuilder.Entity <Referees>().HasData(new WebAPI.Database.Referees()
{
Id = 2,
CityId = 3,
FirstName = "Felix",
LastName = "Brych",
MiddleName = "N/A"
});
modelBuilder.Entity <Referees>().HasData(new WebAPI.Database.Referees()
{
Id = 3,
CityId = 4,
FirstName = "Marco",
LastName = "Fritz",
MiddleName = "N/A"
});
modelBuilder.Entity <Referees>().HasData(new WebAPI.Database.Referees()
{
Id = 4,
CityId = 5,
FirstName = "Manuel",
LastName = "Grafe",
MiddleName = "N/A"
});
modelBuilder.Entity <Referees>().HasData(new WebAPI.Database.Referees()
{
Id = 5,
CityId = 6,
FirstName = "Tobias",
LastName = "Welz",
MiddleName = "N/A"
});
//players
modelBuilder.Entity <Players>().HasData(new WebAPI.Database.Players()
{
Id = 1,
Birthdate = DateTime.Now,
FirstName = "Mats",
LastName = "Hummels",
Height = 200,
IsSigned = true,
Jersey = 5,
MiddleName = "N/A",
StrongerFoot = 1,
Value = 100000,
Weight = 90
});
modelBuilder.Entity <Players>().HasData(new WebAPI.Database.Players()
{
Id = 2,
Birthdate = DateTime.Now,
FirstName = "Marco",
LastName = "Reus",
Height = 180,
IsSigned = true,
Jersey = 17,
MiddleName = "N/A",
StrongerFoot = 2,
Value = 100000,
Weight = 85
});
modelBuilder.Entity <Players>().HasData(new WebAPI.Database.Players()
{
Id = 3,
Birthdate = DateTime.Now,
FirstName = "Robert",
LastName = "Lewandovski",
Height = 180,
IsSigned = true,
Jersey = 7,
MiddleName = "N/A",
StrongerFoot = 2,
Value = 100000,
Weight = 85
});
modelBuilder.Entity <Players>().HasData(new WebAPI.Database.Players()
{
Id = 4,
Birthdate = DateTime.Now,
FirstName = "Thomas",
LastName = "Muller",
Height = 180,
IsSigned = true,
Jersey = 7,
MiddleName = "N/A",
StrongerFoot = 2,
Value = 100000,
Weight = 85
});
modelBuilder.Entity <Players>().HasData(new WebAPI.Database.Players()
{
Id = 5,
Birthdate = DateTime.Now,
FirstName = "Vedad",
LastName = "Ibisevic",
Height = 190,
IsSigned = true,
Jersey = 7,
MiddleName = "N/A",
StrongerFoot = 2,
Value = 100000,
Weight = 85
});
modelBuilder.Entity <Players>().HasData(new WebAPI.Database.Players()
{
Id = 6,
Birthdate = DateTime.Now,
FirstName = "Dodi",
LastName = "Lukebakio",
Height = 200,
IsSigned = true,
Jersey = 7,
MiddleName = "N/A",
StrongerFoot = 0,
Value = 200000,
Weight = 85
});
modelBuilder.Entity <Players>().HasData(new WebAPI.Database.Players()
{
Id = 7,
Birthdate = DateTime.Now,
FirstName = "Charles",
LastName = "Aranguiz",
Height = 180,
IsSigned = true,
Jersey = 7,
MiddleName = "N/A",
StrongerFoot = 2,
Value = 100000,
Weight = 85
});
modelBuilder.Entity <Players>().HasData(new WebAPI.Database.Players()
{
Id = 8,
Birthdate = DateTime.Now,
FirstName = "Kai",
LastName = "Havertz",
Height = 180,
IsSigned = true,
Jersey = 7,
MiddleName = "N/A",
StrongerFoot = 1,
Value = 100000,
Weight = 85
});
modelBuilder.Entity <Players>().HasData(new WebAPI.Database.Players()
{
Id = 9,
Birthdate = DateTime.Now,
FirstName = "Robin",
LastName = "Hack",
Height = 180,
IsSigned = true,
Jersey = 7,
MiddleName = "N/A",
StrongerFoot = 1,
Value = 20000,
Weight = 85
});
modelBuilder.Entity <Players>().HasData(new WebAPI.Database.Players()
{
Id = 10,
Birthdate = DateTime.Now,
FirstName = "Patric",
LastName = "Erras",
Height = 180,
IsSigned = true,
Jersey = 7,
MiddleName = "N/A",
StrongerFoot = 1,
Value = 20000,
Weight = 85
});
modelBuilder.Entity <Players>().HasData(new WebAPI.Database.Players()
{
Id = 11,
Birthdate = DateTime.Now,
FirstName = "Henk",
LastName = "Veerman",
Height = 180,
IsSigned = true,
Jersey = 14,
MiddleName = "N/A",
StrongerFoot = 1,
Value = 204000,
Weight = 77
});
modelBuilder.Entity <Players>().HasData(new WebAPI.Database.Players()
{
Id = 12,
Birthdate = DateTime.Now,
FirstName = "Marvin",
LastName = "Senger",
Height = 205,
IsSigned = true,
Jersey = 7,
MiddleName = "N/A",
StrongerFoot = 0,
Value = 444000,
Weight = 100
});
modelBuilder.Entity <Players>().HasData(new WebAPI.Database.Players()
{
Id = 13,
Birthdate = DateTime.Now,
FirstName = "Neven",
LastName = "Subotic",
Height = 195,
IsSigned = true,
Jersey = 2,
MiddleName = "N/A",
StrongerFoot = 0,
Value = 10000,
Weight = 93
});
modelBuilder.Entity <Players>().HasData(new WebAPI.Database.Players()
{
Id = 14,
Birthdate = DateTime.Now,
FirstName = "Felix",
LastName = "Kroos",
Height = 176,
IsSigned = true,
Jersey = 99,
MiddleName = "N/A",
StrongerFoot = 0,
Value = 444000,
Weight = 77
});
modelBuilder.Entity <Players>().HasData(new WebAPI.Database.Players()
{
Id = 15,
Birthdate = DateTime.Now,
FirstName = "Manuel",
LastName = "Schaffler",
Height = 186,
IsSigned = true,
Jersey = 99,
MiddleName = "N/A",
StrongerFoot = 0,
Value = 444000,
Weight = 77
});
modelBuilder.Entity <Players>().HasData(new WebAPI.Database.Players()
{
Id = 16,
Birthdate = DateTime.Now,
FirstName = "Paterson",
LastName = "Chato",
Height = 197,
IsSigned = true,
Jersey = 99,
MiddleName = "N/A",
StrongerFoot = 2,
Value = 444000,
Weight = 77
});
//contracts
modelBuilder.Entity <Contracts>().HasData(new WebAPI.Database.Contracts()
{
Id = 1,
ClubId = 1,
ExpirationDate = DateTime.Now.AddYears(3),
IsExpired = false,
PlayerId = 1,
RedemptionClause = 50000,
SignedDate = DateTime.Now
});
modelBuilder.Entity <Contracts>().HasData(new WebAPI.Database.Contracts()
{
Id = 2,
ClubId = 2,
ExpirationDate = DateTime.Now.AddYears(3),
IsExpired = false,
PlayerId = 2,
RedemptionClause = 50000,
SignedDate = DateTime.Now
});
modelBuilder.Entity <Contracts>().HasData(new WebAPI.Database.Contracts()
{
Id = 3,
ClubId = 4,
ExpirationDate = DateTime.Now.AddYears(3),
IsExpired = false,
PlayerId = 3,
RedemptionClause = 50000,
SignedDate = DateTime.Now
});
modelBuilder.Entity <Contracts>().HasData(new WebAPI.Database.Contracts()
{
Id = 4,
ClubId = 4,
ExpirationDate = DateTime.Now.AddYears(3),
IsExpired = false,
PlayerId = 4,
RedemptionClause = 50000,
SignedDate = DateTime.Now
});
modelBuilder.Entity <Contracts>().HasData(new WebAPI.Database.Contracts()
{
Id = 5,
ClubId = 2,
ExpirationDate = DateTime.Now.AddYears(3),
IsExpired = false,
PlayerId = 5,
RedemptionClause = 50000,
SignedDate = DateTime.Now
});
modelBuilder.Entity <Contracts>().HasData(new WebAPI.Database.Contracts()
{
Id = 6,
ClubId = 2,
ExpirationDate = DateTime.Now.AddYears(3),
IsExpired = false,
PlayerId = 6,
RedemptionClause = 50000,
SignedDate = DateTime.Now
});
modelBuilder.Entity <Contracts>().HasData(new WebAPI.Database.Contracts()
{
Id = 7,
ClubId = 3,
ExpirationDate = DateTime.Now.AddYears(3),
IsExpired = false,
PlayerId = 7,
RedemptionClause = 50000,
SignedDate = DateTime.Now
});
modelBuilder.Entity <Contracts>().HasData(new WebAPI.Database.Contracts()
{
Id = 8,
ClubId = 3,
ExpirationDate = DateTime.Now.AddYears(3),
IsExpired = false,
PlayerId = 8,
RedemptionClause = 50000,
SignedDate = DateTime.Now
});
modelBuilder.Entity <Contracts>().HasData(new WebAPI.Database.Contracts()
{
Id = 9,
ClubId = 5,
ExpirationDate = DateTime.Now.AddYears(3),
IsExpired = false,
PlayerId = 9,
RedemptionClause = 50000,
SignedDate = DateTime.Now
});
modelBuilder.Entity <Contracts>().HasData(new WebAPI.Database.Contracts()
{
Id = 10,
ClubId = 5,
ExpirationDate = DateTime.Now.AddYears(3),
IsExpired = false,
PlayerId = 10,
RedemptionClause = 50000,
SignedDate = DateTime.Now
});
modelBuilder.Entity <Contracts>().HasData(new WebAPI.Database.Contracts()
{
Id = 11,
ClubId = 6,
ExpirationDate = DateTime.Now.AddYears(3),
IsExpired = false,
PlayerId = 11,
RedemptionClause = 50000,
SignedDate = DateTime.Now
});
modelBuilder.Entity <Contracts>().HasData(new WebAPI.Database.Contracts()
{
Id = 12,
ClubId = 6,
ExpirationDate = DateTime.Now.AddYears(3),
IsExpired = false,
PlayerId = 12,
RedemptionClause = 50000,
SignedDate = DateTime.Now
});
modelBuilder.Entity <Contracts>().HasData(new WebAPI.Database.Contracts()
{
Id = 13,
ClubId = 7,
ExpirationDate = DateTime.Now.AddYears(3),
IsExpired = false,
PlayerId = 13,
RedemptionClause = 50000,
SignedDate = DateTime.Now
});
modelBuilder.Entity <Contracts>().HasData(new WebAPI.Database.Contracts()
{
Id = 14,
ClubId = 7,
ExpirationDate = DateTime.Now.AddYears(3),
IsExpired = false,
PlayerId = 14,
RedemptionClause = 50000,
SignedDate = DateTime.Now
});
modelBuilder.Entity <Contracts>().HasData(new WebAPI.Database.Contracts()
{
Id = 15,
ClubId = 8,
ExpirationDate = DateTime.Now.AddYears(3),
IsExpired = false,
PlayerId = 15,
RedemptionClause = 50000,
SignedDate = DateTime.Now
});
modelBuilder.Entity <Contracts>().HasData(new WebAPI.Database.Contracts()
{
Id = 16,
ClubId = 8,
ExpirationDate = DateTime.Now.AddYears(3),
IsExpired = false,
PlayerId = 16,
RedemptionClause = 50000,
SignedDate = DateTime.Now
});
//playerPositions
var rand = new Random();
for (int i = 1; i <= 16; i++)
{
modelBuilder.Entity <PlayerPositions>().HasData(new WebAPI.Database.PlayerPositions()
{
Id = i,
PlayerId = i,
PositionId = rand.Next(1, 4)
});
}
}
partial void OnModelCreatingPartial(ModelBuilder modelBuilder)
{
var korisnikLozinkaSalt = HashGenSalt.GenerateSalt();
var korisnikLozinkaHash = HashGenSalt.GenerateHash(korisnikLozinkaSalt, "test");
var kupacLozinkaSalt = HashGenSalt.GenerateSalt();
var kupacLozinkaHash = HashGenSalt.GenerateHash(kupacLozinkaSalt, "test");
//KORISNICI
modelBuilder.Entity <Korisnici>().HasData(new Korisnici()
{
KorisnikId = 1,
Email = "*****@*****.**",
Ime = "test",
Prezime = "test",
DatumRodjenja = DateTime.Now,
KorisnickoIme = "desktop",
LozinkaSalt = korisnikLozinkaSalt,
LozinkaHash = korisnikLozinkaHash
});
//KUPCI
modelBuilder.Entity <Kupci>().HasData(new Kupci()
{
KupacId = 1,
Email = "*****@*****.**",
Ime = "test",
Prezime = "test",
DatumRegistracije = DateTime.Now,
KorisnickoIme = "mobile",
LozinkaSalt = kupacLozinkaSalt,
LozinkaHash = kupacLozinkaHash
});
//GRADOVI
modelBuilder.Entity <Gradovi>().HasData(new Gradovi()
{
GradId = 1,
Naziv = "Sarajevo",
DatumObjave = DateTime.Now
});
modelBuilder.Entity <Gradovi>().HasData(new Gradovi()
{
GradId = 2,
Naziv = "Mostar",
DatumObjave = DateTime.Now
});
modelBuilder.Entity <Gradovi>().HasData(new Gradovi()
{
GradId = 3,
Naziv = "Tuzla",
DatumObjave = DateTime.Now
});
modelBuilder.Entity <Gradovi>().HasData(new Gradovi()
{
GradId = 4,
Naziv = "Banja luka",
DatumObjave = DateTime.Now
});
modelBuilder.Entity <Gradovi>().HasData(new Gradovi()
{
GradId = 5,
Naziv = "Beograd",
DatumObjave = DateTime.Now
});
modelBuilder.Entity <Gradovi>().HasData(new Gradovi()
{
GradId = 6,
Naziv = "Zagreb",
DatumObjave = DateTime.Now
});
modelBuilder.Entity <Gradovi>().HasData(new Gradovi()
{
GradId = 7,
Naziv = "Split",
DatumObjave = DateTime.Now
});
modelBuilder.Entity <Gradovi>().HasData(new Gradovi()
{
GradId = 8,
Naziv = "Obavještenje za putnike",
Sadrzaj = "Željeznice FBiH obavještavaju putnike da BH vozovi koji redovno saobraćaju na relacijama Sarajevo-Bihać-Sarajevo i Sarajevo- Banja Luka- Sarajevo do daljnjeg saobraćaju samo na relaciji Sarajevo-Doboj- Sarajevo, zbog vanrednog događaja na dijelu pruge Željeznica Republike Srpske između Doboja i Banja Luke 05.01.2019. godine, kada je došlo do iskakanje iz šina lokalnog putničkog voza Željeznica RS. Po okončanju posljedica izazvanih ovim vanrednim događajem, ponovo će biti uspostavljena linija Sarajevo-Bihać- Sarajevo i Sarajevo –Banja Luka- Sarajevo. Putnički saobraćaj na ostalim relacijama odvija se po Redu vožnje ŽFBiH.",
DatumObjave = DateTime.Now
});
modelBuilder.Entity <Gradovi>().HasData(new Gradovi()
{
GradId = 9,
Naziv = "Putnički voz 2154",
Sadrzaj = "Željeznice FBiH obavještavaju putnike da se do daljnjeg otkazuje saobraćaj lokalnog putničkog voza 2154 koji je saobraćao na relaciji Sarajevo-Zenica sa polaskom iz Sarajeva u 11:02 h i lokalnog putničkog voza 2155 koji je saobraćao na relaciji Zenica-Sarajevo sa polaskom iz Zenice u 11:07 h. Saobraćaj ovih vozova otkazuje se zbog izvođenja radova na pruzi, odnosno, zbog radova na ugradnji optičkog kabla na pomenutoj dionici. O ponovnoj uspostavi saobraćaja navedenih vozova, putnici će biti blagovremeno obaviješteni.",
DatumObjave = DateTime.Now.AddDays(2)
});
modelBuilder.Entity <Gradovi>().HasData(new Gradovi()
{
GradId = 10,
Naziv = "Info o saobraćaju",
Sadrzaj = "Željeznice Federacije Bosne i Hercegovine od 01.06.2020. godine uspostavljaju željeznički putnički prevoz u lokalnom saobraćaju, a vozovi će voziti u skladu sa izmijenjenim Redom vožnje.",
DatumObjave = DateTime.Now.AddDays(1)
});
//ZELJEZNICKE STANICE
modelBuilder.Entity <ZeljeznickeStanice>().HasData(new ZeljeznickeStanice()
{
ZeljeznickaStanicaId = 1,
Email = "*****@*****.**",
Naziv = "Ž.S. Sarajevo",
Adresa = "Halida Kajtaza 10",
Telefon = "033251251",
GradId = 1
});
modelBuilder.Entity <ZeljeznickeStanice>().HasData(new ZeljeznickeStanice()
{
ZeljeznickaStanicaId = 2,
Email = "*****@*****.**",
Naziv = "Ž.S. Mostar",
Adresa = "Ložionička 12",
Telefon = "036565565",
GradId = 1
});
modelBuilder.Entity <ZeljeznickeStanice>().HasData(new ZeljeznickeStanice()
{
ZeljeznickaStanicaId = 3,
Email = "*****@*****.**",
Naziv = "Ž.S. Tuzla",
Adresa = "Radnička 23",
Telefon = "035458754",
GradId = 1
});
modelBuilder.Entity <ZeljeznickeStanice>().HasData(new ZeljeznickeStanice()
{
ZeljeznickaStanicaId = 4,
Email = "*****@*****.**",
Naziv = "Ž.S. Banja Luka",
Adresa = "Trg pobjede 56",
Telefon = "051478724",
GradId = 1
});
modelBuilder.Entity <ZeljeznickeStanice>().HasData(new ZeljeznickeStanice()
{
ZeljeznickaStanicaId = 5,
Email = "*****@*****.**",
Naziv = "Ž.S. Zagreb",
Adresa = "Strojarska cesta 11",
Telefon = "+385013333200",
GradId = 1
});
modelBuilder.Entity <ZeljeznickeStanice>().HasData(new ZeljeznickeStanice()
{
ZeljeznickaStanicaId = 6,
Email = "*****@*****.**",
Naziv = "Ž.S. Split",
Adresa = "Dubrovačka 11",
Telefon = "+385078924233",
GradId = 1
});
modelBuilder.Entity <ZeljeznickeStanice>().HasData(new ZeljeznickeStanice()
{
ZeljeznickaStanicaId = 7,
Email = "*****@*****.**",
Naziv = "Ž.S. Beograd",
Adresa = "Jurija Gagarina 33",
Telefon = "+381112222300",
GradId = 1
});
//RELACIJE
int RelacijaID = 1;
for (int zod = 1; zod < 8; zod++)
{
for (int zdo = 1; zdo < 8; zdo++)
{
if (zod != zdo)
{
modelBuilder.Entity <Relacije>().HasData(new Relacije()
{
RelacijaId = RelacijaID++,
ZeljeznickaStanicaOdid = zod,
ZeljeznickaStanicaDoid = zdo
});
}
}
}
modelBuilder.Entity <Relacije>().HasData(new Relacije()
{
RelacijaId = 51,
ZeljeznickaStanicaOdid = 1,
ZeljeznickaStanicaDoid = 2
});
modelBuilder.Entity <Relacije>().HasData(new Relacije()
{
RelacijaId = 52,
ZeljeznickaStanicaOdid = 1,
ZeljeznickaStanicaDoid = 2
});
modelBuilder.Entity <Relacije>().HasData(new Relacije()
{
RelacijaId = 53,
ZeljeznickaStanicaOdid = 2,
ZeljeznickaStanicaDoid = 1
});
//PUTOVANJA
int PutovanjeID = 1;
double cijena = 5;
int PutovanjeID2 = 43;
double cijena2 = 5.25;
int PutovanjeID3 = 85;
double cijena3 = 7.45;
for (int i = 1; i < 43; i++)
{
cijena = cijena + 0.50;
modelBuilder.Entity <Putovanja>().HasData(new Putovanja()
{
RelacijaId = i,
PutovanjeId = PutovanjeID++,
DatumPolaska = DateTime.Today.AddDays(1),
VrijemePolaska = new TimeSpan(3, 30, 0),
VrijemeDolaska = new TimeSpan(10, 30, 0),
Cijena = cijena
});
}
for (int i = 1; i < 43; i++)
{
cijena2 = cijena2 + 0.50;
modelBuilder.Entity <Putovanja>().HasData(new Putovanja()
{
RelacijaId = i,
PutovanjeId = PutovanjeID2++,
DatumPolaska = DateTime.Today.AddDays(2),
VrijemePolaska = new TimeSpan(4, 30, 0),
VrijemeDolaska = new TimeSpan(11, 30, 0),
Cijena = cijena2
});
}
for (int i = 1; i < 43; i++)
{
cijena3 = cijena3 + 0.50;
modelBuilder.Entity <Putovanja>().HasData(new Putovanja()
{
RelacijaId = i,
PutovanjeId = PutovanjeID3++,
DatumPolaska = DateTime.Today.AddDays(3),
VrijemePolaska = new TimeSpan(5, 30, 0),
VrijemeDolaska = new TimeSpan(12, 30, 0),
Cijena = cijena3
});
}
modelBuilder.Entity <Putovanja>().HasData(new Putovanja()
{
RelacijaId = 1,
PutovanjeId = 127,
DatumPolaska = DateTime.Today.AddDays(3),
VrijemePolaska = new TimeSpan(5, 30, 0),
VrijemeDolaska = new TimeSpan(12, 30, 0),
Cijena = cijena3
});
modelBuilder.Entity <Putovanja>().HasData(new Putovanja()
{
RelacijaId = 1,
PutovanjeId = 128,
DatumPolaska = DateTime.Today.AddDays(3),
VrijemePolaska = new TimeSpan(5, 30, 0),
VrijemeDolaska = new TimeSpan(12, 30, 0),
Cijena = cijena3
});
modelBuilder.Entity <Putovanja>().HasData(new Putovanja()
{
RelacijaId = 2,
PutovanjeId = 129,
DatumPolaska = DateTime.Today.AddDays(3),
VrijemePolaska = new TimeSpan(5, 30, 0),
VrijemeDolaska = new TimeSpan(12, 30, 0),
Cijena = cijena3
});
//KARTE
Random rnd = new Random();
for (int i = 1; i < 31; i++)
{
modelBuilder.Entity <Karte>().HasData(new Karte()
{
KartaId = i,
RedniBrojSjedista = rnd.Next(1, 30),
RedniBrojVagona = rnd.Next(1, 10)
});
}
//REZERVACIJE
for (int i = 1; i < 20; i++)
{
modelBuilder.Entity <Rezervacije>().HasData(new Rezervacije()
{
RezervacijaId = i,
KartaId = i,
DatumRezervacije = DateTime.Now,
KupacId = 1,
PutovanjeId = rnd.Next(1, 126),
Kompletirana = true
});
}
//nekompletirane
for (int i = 20; i < 31; i++)
{
modelBuilder.Entity <Rezervacije>().HasData(new Rezervacije()
{
RezervacijaId = i,
KartaId = i,
DatumRezervacije = DateTime.Now,
KupacId = 1,
PutovanjeId = rnd.Next(1, 126),
Kompletirana = false
});
}
//PRODANE KARTE
for (int i = 1; i < 20; i++)
{
modelBuilder.Entity <KupljeneKarte>().HasData(new KupljeneKarte()
{
ProdanaKartaId = i,
BrojRacuna = BrojRacunaHelper.GenerisiBrojRacuna(),
DatumProdaje = DateTime.Now,
RezervacijaId = rnd.Next(1, 30),
Popust = 0,
KupacId = 1,
KonacnaCijena = rnd.Next(1, 77)
});
}
//nekompletirane
for (int i = 20; i < 31; i++)
{
modelBuilder.Entity <KupljeneKarte>().HasData(new KupljeneKarte()
{
ProdanaKartaId = i,
BrojRacuna = BrojRacunaHelper.GenerisiBrojRacuna(),
DatumProdaje = DateTime.Now,
RezervacijaId = i,
Popust = 0,
KupacId = 1,
KonacnaCijena = rnd.Next(1, 77)
});
}
for (int i = 1; i < 100; i++)
{
modelBuilder.Entity <Pretrage>().HasData(new Pretrage()
{
RezervacijaID = rnd.Next(1, 30),
RelacijaId = rnd.Next(1, 42),
KupacId = 1,
PretragaId = i,
Ocjena = rnd.Next(3, 5)
});
}
}
