private void ClearDataBase(global::DataAccess.Context.AppContext dbContext)
{
// create transaction to clear DataBase
using (System.Data.Entity.DbContextTransaction transaction = dbContext.Database.BeginTransaction())
{
try
{
// disable all constraints in the database
dbContext.Database.ExecuteSqlCommand("EXEC sp_MSforeachtable \"ALTER TABLE ? NOCHECK CONSTRAINT all\"");
// gets all tables' names
string[] tableNames = dbContext.Database.SqlQuery <string>("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME NOT LIKE '%Migration%'").ToArray();
// clear out data in all tables
foreach (string tableName in tableNames)
{
dbContext.Database.ExecuteSqlCommand($"DELETE FROM [{tableName}];");
}
// enable all constraints in the database
dbContext.Database.ExecuteSqlCommand("EXEC sp_MSforeachtable @command1=\"print '?'\", @command2=\"ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all\"");
// commit transaction
transaction.Commit();
}
catch
{
// rollback transtaction on any error
transaction.Rollback();
throw;
}
}
}
// DB METHODS
public void Fill(global::DataAccess.Context.AppContext dbContext)
{
switch (fillMode)
{
case DataBaseFillMode.Regular: RegularFill(dbContext); break;
case DataBaseFillMode.Easy: RandomFill(dbContext: dbContext, userAmount: 10, photoAmount: 10, commentAmount: 100, likesAmount: 100, subjectAmount: 2, messagesAmount: 50); break;
case DataBaseFillMode.Middle: RandomFill(dbContext: dbContext, userAmount: 500, photoAmount: 500, commentAmount: 1000, likesAmount: 3000, subjectAmount: 5, messagesAmount: 500); break;
case DataBaseFillMode.Hard: RandomFill(dbContext: dbContext, userAmount: 1000, photoAmount: 1000, commentAmount: 2000, likesAmount: 5000, subjectAmount: 10, messagesAmount: 1000); break;
default: throw new NotImplementedException("Wrong DataBase fill mode");
}
}
private void RandomFill(global::DataAccess.Context.AppContext dbContext, int userAmount = 1000, int photoAmount = 10000, int commentAmount = 2000, int likesAmount = 5000, int subjectAmount = 10, int messagesAmount = 1000)
{
// USERS
#region USERS
User[] users = new User[userAmount];
for (int i = 0; i < userAmount; ++i)
{
bool isAdmin = random.Next(5) == 4;
bool hasAvatar = random.Next(5) == 4;
users[i] = new User
{
NickName = names[random.Next(names.Length)] + i,
Password = GeneratePassword(),
MainPhotoPath = hasAvatar ? GenerateImagePath() : null,
IsAdmin = isAdmin
};
if (isAdmin)
{
++adminAmount;
}
if (hasAvatar)
{
++userWithAvatar;
}
}
firstUser = users.First();
firstUserNickname = users.First().NickName;
this.userAmount = userAmount;
#endregion
// FOLLOWERS
#region FOLLOWERS
for (int i = 0; i < userAmount; ++i)
{
for (int j = 0; j < userAmount; ++j)
{
if (j != i && random.NextDouble() < 0.10) // 10 % to be a follower
{
users[i].Followers.Add(users[j]);
}
}
}
#endregion
// PHOTOS
#region PHOTOS
Photo[] photos = new Photo[photoAmount];
for (int i = 0; i < photoAmount; ++i)
{
User user = users[random.Next(users.Length)];
photos[i] = new Photo {
Path = GenerateImagePath(), User = user
};
if (userPhotoAmount.ContainsKey(user.NickName))
{
++userPhotoAmount[user.NickName];
}
else
{
userPhotoAmount.Add(user.NickName, 1);
}
}
this.photoAmount = photoAmount;
#endregion
// PHOTO LIKES
#region PHOTO LIKES
PhotoLike[] photoLikes = new PhotoLike[likesAmount];
for (int i = 0; i < likesAmount; ++i)
{
bool isLiked = random.Next(2) == 1;
photoLikes[i] = new PhotoLike
{
IsLiked = isLiked,
Photo = photos[random.Next(photoAmount)],
User = users[random.Next(userAmount - 1)] // last user sets no likes
};
if (isLiked)
{
++photoLikeAmountWithLike;
}
}
userDisliked = photoLikes.First(l => !l.IsLiked).User.NickName;
photoLikeAmount = likesAmount;
userWithoutPhotoLike = users.Last().NickName;
#endregion
// COMMENTS
#region COMMENTS
Comment[] comments = new Comment[commentAmount];
for (int i = 0; i < commentAmount; ++i)
{
DateTime date = GenerateDate();
comments[i] = new Comment
{
Date = date,
Photo = photos[random.Next(photoAmount)],
User = users[random.Next(userAmount)],
Text = GenerateSentence()
};
++commentMonth[date.Month - 1];
}
this.commentAmount = commentAmount;
#endregion
// COMMENTS LIKE
#region COMMENTS LIKE
CommentLike[] commentLikes = new CommentLike[likesAmount];
for (int i = 0; i < likesAmount; ++i)
{
bool isLiked = random.Next(2) == 1;
commentLikes[i] = new CommentLike
{
IsLiked = isLiked,
Comment = comments[random.Next(commentAmount)],
User = users[random.Next(userAmount - 1)] // last user sets no likes
};
if (isLiked)
{
++commentLikeAmountWithLike;
}
}
commentLikeAmount = likesAmount;
userWithoutCommentLike = users.Last().NickName;
#endregion
// SUBJECTS
#region SUBJECTS
Subject[] subjects = new Subject[subjectAmount];
for (int i = 0; i < subjectAmount; ++i)
{
subjects[i] = new Subject {
Name = $"Subject {i + 1}"
};
}
this.subjectAmount = subjectAmount;
#endregion
// MESSAGES
#region MESSAGES
Message[] messages = new Message[messagesAmount];
for (int i = 0; i < messagesAmount; ++i)
{
bool hasSubject = random.Next(2) == 1;
Subject subject = subjects[random.Next(subjectAmount)];
DateTime date = GenerateDate();
messages[i] = new Message
{
Date = date,
Subject = hasSubject ? subject : null,
User = users[random.Next(userAmount)],
Text = GenerateSentence()
};
if (hasSubject)
{
++messageWithSubjectAmount;
if (subjectMessageAmount.ContainsKey(subject.Name))
{
++subjectMessageAmount[subject.Name];
}
else
{
subjectMessageAmount[subject.Name] = 1;
}
}
else
{
if (subjectMessageAmount.ContainsKey("no subject"))
{
++subjectMessageAmount["no subject"];
}
else
{
subjectMessageAmount["no subject"] = 1;
}
}
++messageMonthAmount[date.Month - 1];
}
messageAmount = messagesAmount;
#endregion
#region Adding
dbContext.Users.AddRange(users);
dbContext.Photos.AddRange(photos);
dbContext.PhotoLike.AddRange(photoLikes);
dbContext.Comments.AddRange(comments);
dbContext.CommentLike.AddRange(commentLikes);
dbContext.Subjects.AddRange(subjects);
dbContext.Messages.AddRange(messages);
dbContext.SaveChanges();
#endregion
}
// PRIVATE METHODS
#region FILL MODE
private void RegularFill(global::DataAccess.Context.AppContext dbContext)
{
// USERS
#region USERS
User user1 = new User {
NickName = "John", Password = "******", MainPhotoPath = "1223/466/64.jpg", IsAdmin = false
};
User user2 = new User {
NickName = "Kayson", Password = "******", MainPhotoPath = null, IsAdmin = false
};
User user3 = new User {
NickName = "Clementine", Password = "******", MainPhotoPath = "1223/466/64.jpg", IsAdmin = false
};
User user4 = new User {
NickName = "Beverley", Password = "******", MainPhotoPath = null, IsAdmin = false
};
User user5 = new User {
NickName = "Harold", Password = "******", MainPhotoPath = "1223/466/64.jpg", IsAdmin = true
};
firstUser = user1;
firstUserNickname = user1.NickName;
userAmount = 5;
userWithAvatar = 3;
adminAmount = 1;
#endregion
// FOLLOWERS
#region FOLLOWERS
user1.Followers.Add(user2);
user1.Followers.Add(user3);
user1.Followers.Add(user5);
user2.Followers.Add(user1);
user2.Followers.Add(user3);
user2.Followers.Add(user4);
user3.Followers.Add(user4);
user3.Followers.Add(user5);
user4.Followers.Add(user1);
#endregion
// PHOTOS
#region PHOTOS
// to user
// 1
Photo photo1 = new Photo {
Path = "1/1.jpg", User = user1
};
Photo photo2 = new Photo {
Path = "1/2.jpg", User = user1
};
Photo photo3 = new Photo {
Path = "1/3.jpg", User = user1
};
// 2
Photo photo4 = new Photo {
Path = "2/1.jpg", User = user2
};
Photo photo5 = new Photo {
Path = "2/2.jpg", User = user2
};
Photo photo6 = new Photo {
Path = "2/3.jpg", User = user2
};
Photo photo7 = new Photo {
Path = "2/4.jpg", User = user2
};
Photo photo8 = new Photo {
Path = "2/5.jpg", User = user2
};
// 3
Photo photo9 = new Photo {
Path = "3/1.jpg", User = user3
};
Photo photo10 = new Photo {
Path = "3/2.jpg", User = user3
};
// 4
Photo photo11 = new Photo {
Path = "4/1.jpg", User = user4
};
// 5
Photo photo12 = new Photo {
Path = "5/1.jpg", User = user5
};
Photo photo13 = new Photo {
Path = "5/2.jpg", User = user5
};
photoAmount = 13;
userPhotoAmount.Add(user1.NickName, 3);
userPhotoAmount.Add(user2.NickName, 5);
userPhotoAmount.Add(user3.NickName, 2);
userPhotoAmount.Add(user4.NickName, 1);
userPhotoAmount.Add(user5.NickName, 2);
#endregion
// PHOTO LIKES
#region PHOTO LIKES
// to photo
// 1
PhotoLike photoLike1 = new PhotoLike {
IsLiked = true, Photo = photo1, User = user1
};
PhotoLike photoLike2 = new PhotoLike {
IsLiked = false, Photo = photo1, User = user2
};
PhotoLike photoLike3 = new PhotoLike {
IsLiked = true, Photo = photo1, User = user3
};
// 2
PhotoLike photoLike4 = new PhotoLike {
IsLiked = true, Photo = photo2, User = user4
};
PhotoLike photoLike5 = new PhotoLike {
IsLiked = false, Photo = photo2, User = user1
};
PhotoLike photoLike6 = new PhotoLike {
IsLiked = false, Photo = photo2, User = user2
};
PhotoLike photoLike7 = new PhotoLike {
IsLiked = true, Photo = photo2, User = user3
};
// 3
PhotoLike photoLike8 = new PhotoLike {
IsLiked = true, Photo = photo3, User = user2
};
// 4
PhotoLike photoLike9 = new PhotoLike {
IsLiked = true, Photo = photo4, User = user4
};
PhotoLike photoLike10 = new PhotoLike {
IsLiked = false, Photo = photo4, User = user1
};
PhotoLike photoLike11 = new PhotoLike {
IsLiked = true, Photo = photo4, User = user2
};
// 5
PhotoLike photoLike12 = new PhotoLike {
IsLiked = true, Photo = photo5, User = user3
};
PhotoLike photoLike13 = new PhotoLike {
IsLiked = true, Photo = photo5, User = user4
};
// 6
PhotoLike photoLike14 = new PhotoLike {
IsLiked = false, Photo = photo6, User = user1
};
PhotoLike photoLike15 = new PhotoLike {
IsLiked = true, Photo = photo6, User = user2
};
// 7
PhotoLike photoLike16 = new PhotoLike {
IsLiked = true, Photo = photo7, User = user2
};
PhotoLike photoLike17 = new PhotoLike {
IsLiked = true, Photo = photo7, User = user4
};
// 8
PhotoLike photoLike18 = new PhotoLike {
IsLiked = false, Photo = photo8, User = user1
};
// 9
PhotoLike photoLike19 = new PhotoLike {
IsLiked = true, Photo = photo9, User = user3
};
// 10
PhotoLike photoLike20 = new PhotoLike {
IsLiked = true, Photo = photo10, User = user2
};
// 11
PhotoLike photoLike21 = new PhotoLike {
IsLiked = true, Photo = photo11, User = user4
};
PhotoLike photoLike22 = new PhotoLike {
IsLiked = false, Photo = photo11, User = user1
};
PhotoLike photoLike23 = new PhotoLike {
IsLiked = false, Photo = photo11, User = user3
};
PhotoLike photoLike24 = new PhotoLike {
IsLiked = true, Photo = photo11, User = user2
};
// 12
PhotoLike photoLike25 = new PhotoLike {
IsLiked = true, Photo = photo12, User = user4
};
PhotoLike photoLike26 = new PhotoLike {
IsLiked = false, Photo = photo12, User = user2
};
PhotoLike photoLike27 = new PhotoLike {
IsLiked = true, Photo = photo12, User = user1
};
// 13
// no likes
userDisliked = user2.NickName;
photoLikeAmount = 27;
photoLikeAmountWithLike = 18;
userWithoutPhotoLike = user5.NickName;
#endregion
// COMMENTS
#region COMMENTS
// to photo
// 1
Comment comment1 = new Comment {
Date = new DateTime(year: 2018, month: 1, day: 15), Photo = photo1, User = user1, Text = "Here comes the rain again"
};
Comment comment2 = new Comment {
Date = new DateTime(year: 2018, month: 2, day: 1), Photo = photo1, User = user2, Text = "I'm only sleeping"
};
Comment comment3 = new Comment {
Date = new DateTime(year: 2018, month: 3, day: 4), Photo = photo1, User = user3, Text = "Another one bites the dust"
};
// 2
Comment comment4 = new Comment {
Date = new DateTime(year: 2017, month: 4, day: 5), Photo = photo2, User = user1, Text = "Rape me"
};
// 3
Comment comment5 = new Comment {
Date = new DateTime(year: 2016, month: 5, day: 6), Photo = photo3, User = user2, Text = "Falling away from me"
};
Comment comment6 = new Comment {
Date = new DateTime(year: 2018, month: 6, day: 7), Photo = photo3, User = user3, Text = "But in the end it doesn't even matter"
};
// 4
Comment comment7 = new Comment {
Date = new DateTime(year: 2018, month: 7, day: 8), Photo = photo4, User = user1, Text = "Sweet dreams are made of this"
};
Comment comment8 = new Comment {
Date = new DateTime(year: 2017, month: 8, day: 9), Photo = photo4, User = user4, Text = "My girl my girl don't lie to me tell me where did you sleep last night"
};
Comment comment9 = new Comment {
Date = new DateTime(year: 2018, month: 9, day: 10), Photo = photo4, User = user1, Text = "Monkey see, monkey do I'd rather be deal than cool"
};
Comment comment10 = new Comment {
Date = new DateTime(year: 2017, month: 10, day: 11), Photo = photo4, User = user4, Text = "I don't deserve this, darling, you look perfect tonight"
};
// 5
Comment comment11 = new Comment {
Date = new DateTime(year: 2018, month: 11, day: 12), Photo = photo5, User = user4, Text = "And if I only could, I'd make a deal with God, And I'd get him to swap our places"
};
Comment comment12 = new Comment {
Date = new DateTime(year: 2012, month: 12, day: 13), Photo = photo5, User = user1, Text = "I love to see you run around And i can see you now"
};
Comment comment13 = new Comment {
Date = new DateTime(year: 2018, month: 1, day: 14), Photo = photo5, User = user2, Text = "The Show Must Go On"
};
// 6
Comment comment14 = new Comment {
Date = new DateTime(year: 2000, month: 2, day: 15), Photo = photo6, User = user1, Text = "Goo goo g'joob"
};
// 7
Comment comment15 = new Comment {
Date = new DateTime(year: 2009, month: 3, day: 16), Photo = photo7, User = user3, Text = "And it's the missing that will kill you, knowing that you've missed your shot"
};
// 8
Comment comment16 = new Comment {
Date = new DateTime(year: 2018, month: 4, day: 17), Photo = photo8, User = user4, Text = "One is the loneliest number that you'll ever do"
};
Comment comment17 = new Comment {
Date = new DateTime(year: 2004, month: 5, day: 18), Photo = photo8, User = user1, Text = "I'm just your problem"
};
Comment comment18 = new Comment {
Date = new DateTime(year: 2018, month: 6, day: 19), Photo = photo8, User = user2, Text = "We didn't start the fire"
};
Comment comment19 = new Comment {
Date = new DateTime(year: 2003, month: 7, day: 20), Photo = photo8, User = user4, Text = "God Is Dead?"
};
// 9
Comment comment20 = new Comment {
Date = new DateTime(year: 2018, month: 8, day: 21), Photo = photo9, User = user4, Text = "I don't wanna hear you say it"
};
Comment comment21 = new Comment {
Date = new DateTime(year: 2015, month: 9, day: 22), Photo = photo9, User = user1, Text = "You're a dancer But you're dancing on air Just a matter of time till you fall"
};
Comment comment22 = new Comment {
Date = new DateTime(year: 2016, month: 10, day: 23), Photo = photo9, User = user3, Text = "Wouldn't it be nice if we were older Then we wouldn't have to wait so long?"
};
// 10
Comment comment23 = new Comment {
Date = new DateTime(year: 2015, month: 11, day: 24), Photo = photo10, User = user4, Text = "I shot the sheriff, but I did not shoot the deputy"
};
Comment comment24 = new Comment {
Date = new DateTime(year: 2010, month: 12, day: 25), Photo = photo10, User = user1, Text = "I hurt myself today To see if I still feel"
};
Comment comment25 = new Comment {
Date = new DateTime(year: 2010, month: 1, day: 26), Photo = photo10, User = user1, Text = "I said if you're thinking of being my brother, It don't matter if you're Black or White"
};
Comment comment26 = new Comment {
Date = new DateTime(year: 2014, month: 2, day: 27), Photo = photo10, User = user4, Text = "Well I've heard there was a secret chord"
};
Comment comment27 = new Comment {
Date = new DateTime(year: 2019, month: 3, day: 28), Photo = photo10, User = user2, Text = "Gotta find that fool who did that to you"
};
// 11
Comment comment28 = new Comment {
Date = new DateTime(year: 2014, month: 4, day: 1), Photo = photo11, User = user4, Text = "All we are is dust in the wind"
};
// 12
// no comments
// 13
Comment comment29 = new Comment {
Date = new DateTime(year: 2012, month: 5, day: 2), Photo = photo13, User = user2, Text = "I want to get away, I want to fly away, Yeah yeah yeah"
};
Comment comment30 = new Comment {
Date = new DateTime(year: 2014, month: 6, day: 3), Photo = photo13, User = user2, Text = "Where is my mind"
};
commentAmount = 30;
commentMonth[0] = 3;
commentMonth[1] = 3;
commentMonth[2] = 3;
commentMonth[3] = 2;
commentMonth[4] = 2;
commentMonth[5] = 2;
commentMonth[6] = 2;
commentMonth[7] = 2;
commentMonth[8] = 2;
commentMonth[9] = 2;
commentMonth[10] = 2;
commentMonth[11] = 2;
#endregion
// COMMENTS LIKE
#region COMMENTS LIKE
// to comment
// 1
CommentLike commentLike1 = new CommentLike {
IsLiked = true, Comment = comment1, User = user1
};
CommentLike commentLike2 = new CommentLike {
IsLiked = true, Comment = comment1, User = user3
};
CommentLike commentLike3 = new CommentLike {
IsLiked = false, Comment = comment1, User = user2
};
// 2
CommentLike commentLike4 = new CommentLike {
IsLiked = false, Comment = comment2, User = user1
};
CommentLike commentLike5 = new CommentLike {
IsLiked = true, Comment = comment2, User = user3
};
// 3
CommentLike commentLike6 = new CommentLike {
IsLiked = true, Comment = comment3, User = user1
};
// 4
// 5
CommentLike commentLike7 = new CommentLike {
IsLiked = false, Comment = comment5, User = user3
};
CommentLike commentLike8 = new CommentLike {
IsLiked = true, Comment = comment5, User = user5
};
// 6
// 7
CommentLike commentLike9 = new CommentLike {
IsLiked = true, Comment = comment7, User = user2
};
// 8
// 9
// 10
// 11
CommentLike commentLike10 = new CommentLike {
IsLiked = true, Comment = comment11, User = user1
};
// 12
// 13
// 14
CommentLike commentLike11 = new CommentLike {
IsLiked = false, Comment = comment14, User = user3
};
CommentLike commentLike12 = new CommentLike {
IsLiked = true, Comment = comment14, User = user1
};
// 15
// 16
CommentLike commentLike13 = new CommentLike {
IsLiked = true, Comment = comment16, User = user5
};
// 17
// 18
CommentLike commentLike14 = new CommentLike {
IsLiked = true, Comment = comment18, User = user1
};
CommentLike commentLike15 = new CommentLike {
IsLiked = true, Comment = comment18, User = user2
};
// 19
// 20
CommentLike commentLike16 = new CommentLike {
IsLiked = false, Comment = comment20, User = user3
};
// 21
// 22
CommentLike commentLike17 = new CommentLike {
IsLiked = true, Comment = comment22, User = user2
};
CommentLike commentLike18 = new CommentLike {
IsLiked = true, Comment = comment22, User = user5
};
// 23
// 24
// 25
CommentLike commentLike19 = new CommentLike {
IsLiked = true, Comment = comment25, User = user3
};
CommentLike commentLike20 = new CommentLike {
IsLiked = false, Comment = comment25, User = user1
};
// 26
// 27
// 28
CommentLike commentLike21 = new CommentLike {
IsLiked = false, Comment = comment28, User = user2
};
CommentLike commentLike22 = new CommentLike {
IsLiked = false, Comment = comment28, User = user3
};
// 29
// 30
commentLikeAmount = 22;
commentLikeAmountWithLike = 14;
userWithoutCommentLike = user4.NickName;
#endregion
// SUBJECTS
#region SUBJECTS
Subject subject1 = new Subject {
Name = "Subject 1"
};
Subject subject2 = new Subject {
Name = "Subject 2"
};
Subject subject3 = new Subject {
Name = "Subject 3"
};
Subject subject4 = new Subject {
Name = "Subject 4"
};
Subject subject5 = new Subject {
Name = "Subject 5"
};
subjectAmount = 5;
#endregion
// MESSAGES
#region MESSAGES
// to subject
// 1
Message message1 = new Message {
Date = new DateTime(year: 2000, month: 1, day: 1), Subject = subject1, User = user1, Text = "I've just seen a face"
};
Message message2 = new Message {
Date = new DateTime(year: 2001, month: 2, day: 2), Subject = subject1, User = user2, Text = "So maybe tomorrow, I'll find my way home"
};
Message message3 = new Message {
Date = new DateTime(year: 2002, month: 3, day: 3), Subject = subject1, User = user1, Text = "In a crooked little town, they were lost and never found"
};
// 2
Message message4 = new Message {
Date = new DateTime(year: 2003, month: 4, day: 4), Subject = subject2, User = user2, Text = "Wake me up when september ends"
};
Message message5 = new Message {
Date = new DateTime(year: 2004, month: 5, day: 5), Subject = subject2, User = user1, Text = "What does the fox say?"
};
// 3
Message message6 = new Message {
Date = new DateTime(year: 2005, month: 6, day: 16), Subject = subject3, User = user3, Text = "Daydream, I fell asleep amid the flowers, For a couple of hours on a beautiful day"
};
Message message7 = new Message {
Date = new DateTime(year: 2006, month: 7, day: 17), Subject = subject3, User = user1, Text = "We all live in a yellow submarine"
};
// 4
Message message8 = new Message {
Date = new DateTime(year: 2007, month: 8, day: 18), Subject = subject4, User = user4, Text = "Just tonight I will stay and well throw it all away"
};
Message message9 = new Message {
Date = new DateTime(year: 2008, month: 9, day: 19), Subject = subject4, User = user1, Text = "Somebody mixed my medicine"
};
// 5
Message message10 = new Message {
Date = new DateTime(year: 2009, month: 10, day: 15), Subject = subject5, User = user5, Text = "A couple of Gs, an R and an E, an I and an N"
};
Message message11 = new Message {
Date = new DateTime(year: 2010, month: 11, day: 15), Subject = subject5, User = user1, Text = "On candy stripe legs the Spiderman comes, Softly through the shadow of the evening sun"
};
Message message12 = new Message {
Date = new DateTime(year: 2011, month: 12, day: 15), Subject = subject5, User = user5, Text = "Everybody wants to rule the world"
};
Message message13 = new Message {
Date = new DateTime(year: 2012, month: 1, day: 15), Subject = subject5, User = user2, Text = "Don`t tell me I'm wrong, Don't tell that you knew all along"
};
// 6 deleted subject
Message message14 = new Message {
Date = new DateTime(year: 2013, month: 2, day: 15), Subject = null, User = user1, Text = "Cut my life into pieces"
};
Message message15 = new Message {
Date = new DateTime(year: 2014, month: 3, day: 15), Subject = null, User = user2, Text = "Listen to the wind blow, watch the sun rise, Running in the shadows, damn your love, damn your lies"
};
messageAmount = 15;
messageWithSubjectAmount = 13;
subjectMessageAmount[subject1.Name] = 3;
subjectMessageAmount[subject2.Name] = 2;
subjectMessageAmount[subject3.Name] = 2;
subjectMessageAmount[subject4.Name] = 2;
subjectMessageAmount[subject5.Name] = 4;
subjectMessageAmount["no subject"] = 2;
messageMonthAmount[0] = 2;
messageMonthAmount[1] = 2;
messageMonthAmount[2] = 2;
messageMonthAmount[3] = 1;
messageMonthAmount[4] = 1;
messageMonthAmount[5] = 1;
messageMonthAmount[6] = 1;
messageMonthAmount[7] = 1;
messageMonthAmount[8] = 1;
messageMonthAmount[9] = 1;
messageMonthAmount[10] = 1;
messageMonthAmount[11] = 1;
#endregion
#region Adding
dbContext.Users.AddRange(new User[] { user1, user2, user3, user4, user5 });
dbContext.Photos.AddRange(new Photo[] { photo1, photo2, photo3, photo4, photo5, photo6, photo7, photo8, photo9, photo10, photo11, photo12, photo13 });
dbContext.PhotoLike.AddRange(new PhotoLike[] { photoLike1, photoLike2, photoLike3, photoLike4, photoLike5, photoLike6, photoLike7, photoLike8, photoLike9,
photoLike10, photoLike11, photoLike12, photoLike13, photoLike14, photoLike15, photoLike16, photoLike17, photoLike18, photoLike19,
photoLike20, photoLike21, photoLike22, photoLike23, photoLike24, photoLike25, photoLike26, photoLike27 });
dbContext.Comments.AddRange(new Comment[] { comment1, comment2, comment3, comment4, comment5, comment6, comment7, comment8, comment9,
comment10, comment11, comment12, comment13, comment14, comment15, comment16, comment17, comment18, comment19,
comment20, comment21, comment22, comment23, comment24, comment25, comment26, comment27, comment28, comment29, comment30 });
dbContext.CommentLike.AddRange(new CommentLike[] { commentLike1, commentLike2, commentLike3, commentLike4, commentLike5, commentLike6, commentLike7, commentLike8, commentLike9,
commentLike10, commentLike11, commentLike12, commentLike13, commentLike14, commentLike15, commentLike16, commentLike17,
commentLike18, commentLike19, commentLike20, commentLike21, commentLike22 });
dbContext.Subjects.AddRange(new Subject[] { subject1, subject2, subject3, subject4, subject5 });
dbContext.Messages.AddRange(new Message[] { message1, message2, message3, message4, message5, message6, message7, message8, message9,
message10, message11, message12, message13, message14, message15 });
dbContext.SaveChanges();
#endregion
}
public void Purge(global::DataAccess.Context.AppContext dbContext)
{
ResetFields();
ClearDataBase(dbContext);
}
