//public ActionResult Index()
//{
// DbSet<MessageModels> messages = db.Message;
// return View(messages.ToList());
//}
public ActionResult CreateExacly(int id)
{
System.Diagnostics.Debug.WriteLine(id);
var query1 = db.User.Where(i => i.Email == User.Identity.Name);
UserModels author = query1.Single();
var query2 = db.Friend.Where(i => i.ID == id);
FriendModels friendship = query2.Single();
var query3 = db.User.Where(i => i.ID == friendship.MyObservations.ID);
UserModels receiver = query3.Single();
System.Diagnostics.Debug.WriteLine("Author", author.FullName);
System.Diagnostics.Debug.WriteLine("Receiver", receiver.FullName);
MessageModels message = new MessageModels();
message.Contents = Request.Form["inputarea"];
message.ReceiverUser = receiver;
message.SenderUser = author;
message.IsDeleted = false;
message.PostDate = DateTime.Now;
message.ReadDate = null;
db.Message.Add(message);
db.SaveChanges();
return(RedirectToAction("Index", "MessageModel", new { id }));
}
public ActionResult InviteToFriend(string myEmail, string friendEmail, int advId)
{
try
{
System.Diagnostics.Debug.WriteLine("Próba dodania przyjaciela");
System.Diagnostics.Debug.WriteLine(myEmail);
System.Diagnostics.Debug.WriteLine(friendEmail);
var query1 = db.User.Where(i => i.Email == myEmail);
UserModels user1 = query1.Single();
var query2 = db.User.Where(i => i.Email == friendEmail);
UserModels user2 = query2.Single();
FriendModels friendship = new FriendModels();
friendship.MyObservations = user2;
friendship.MyFollowers = user1;
friendship.StartDate = DateTime.Now;
FriendModels friendship2 = new FriendModels();
friendship2.MyObservations = user1;
friendship2.MyFollowers = user2;
friendship2.StartDate = DateTime.Now;
db.Friend.Add(friendship);
db.Friend.Add(friendship2);
db.SaveChanges();
return(RedirectToAction("Details", "AdvertisementModel", new { id = advId }));
}
catch
{
return(RedirectToAction("Details", "AdvertisementModel", new { id = advId }));
}
}
public void SetFriendCategory(FriendModels vessel)
{
FriendModels model = friendRepository.Get(vessel.Id);
model.FriendCategory = vessel.FriendCategory;
friendRepository.Edit(model);
friendRepository.Save();
}
public ActionResult Index(int?id)
{
var query = db.User.Where(i => i.Email == User.Identity.Name);
UserModels logedUser = query.Single();
var viewModel = new MessageFriendViewModels();
viewModel.Friends = db.Friend.Include(s => s.MyObservations).Where(i => i.MyFollowers.ID == logedUser.ID);
if (id != null)
{
var query2 = db.Friend.Where(i => i.ID == id.Value);
FriendModels friendship = query2.Single();
System.Diagnostics.Debug.WriteLine("Myf MyO: ", friendship.MyFollowers, friendship.MyObservations, "---");
var query3 = db.User.Where(i => i.ID == friendship.MyObservations.ID);
UserModels receiver = query3.Single();
// message isReaded
List <MessageModels> messagesList = db.Message.Where(i => i.ReceiverUser.ID == logedUser.ID)
.Where(j => j.ReadDate == null)
.Where(j => j.SenderUser.ID == receiver.ID)
.ToList();
foreach (var x in messagesList)
{
System.Diagnostics.Debug.WriteLine("IN LOOP");
x.ReadDate = DateTime.Now;
}
db.SaveChanges();
System.Diagnostics.Debug.WriteLine(receiver.ID);
System.Diagnostics.Debug.WriteLine("---------------------------");
System.Diagnostics.Debug.WriteLine("Chose friend: ", receiver.FullName, "---");
ViewBag.FriendId = id.Value;
viewModel.Messages = db.Message.Where(i => ((i.SenderUser.ID == logedUser.ID ||
i.ReceiverUser.ID == logedUser.ID) && (i.ReceiverUser.ID == receiver.ID || i.SenderUser.ID == receiver.ID)));
}
return(View(viewModel));
//var messages = db.Message.Include(s => s.SenderUser).Include(s => s.ReceiverUser);
//return View(messages.ToList());
}
public PartialViewResult LoadFriendCategoryDiv(string Id)
{
int relationId = friendRepository.GetFriendshipIdByCurrentUserIdAndUserId(User.Identity.GetUserId(), Id);
FriendModels Friend = friendRepository.Get(relationId);
List <FriendCategoryModels> FriendCategories = friendCategoryRepository.GetAll();
FriendCategoryViewModels model = new FriendCategoryViewModels {
FriendshipRelationId = relationId,
ActiveCategory = Friend.Category,
FriendCategories = FriendCategories,
FriendId = Id
};
return(PartialView("_FriendCategoriesEditor", model));
}
public ActionResult Details(int?id)
{
if (id == null)
{
return(RedirectToAction("Index"));
}
var query = db.Friend.Include(s => s.MyFollowers).Include(s => s.MyObservations).Where(i => i.ID == id);
FriendModels friend = query.Single();
if (friend == null)
{
return(HttpNotFound());
}
return(View(friend));
}
public static void SeedUsers(ApplicationDbContext context)
{
// Create the users
UserStore <ApplicationUser> store = new UserStore <ApplicationUser>(context);
UserManager <ApplicationUser> manager = new UserManager <ApplicationUser>(store);
ApplicationUser eliasU = new ApplicationUser {
UserName = "******",
Email = "*****@*****.**"
};
manager.Create(eliasU, "password");
ApplicationUser nicoU = new ApplicationUser {
UserName = "******",
Email = "*****@*****.**"
};
manager.Create(nicoU, "password");
ApplicationUser oskarU = new ApplicationUser {
UserName = "******",
Email = "*****@*****.**"
};
manager.Create(oskarU, "password");
ApplicationUser randomU = new ApplicationUser {
UserName = "******",
Email = "*****@*****.**"
};
manager.Create(randomU, "password");
ApplicationUser corazonU = new ApplicationUser {
UserName = "******",
Email = "*****@*****.**"
};
manager.Create(corazonU, "password");
ApplicationUser andreasU = new ApplicationUser {
UserName = "******",
Email = "*****@*****.**"
};
manager.Create(andreasU, "password");
ApplicationUser mathiasU = new ApplicationUser {
UserName = "******",
Email = "*****@*****.**"
};
manager.Create(mathiasU, "password");
ApplicationUser lightU = new ApplicationUser {
UserName = "******",
Email = "*****@*****.**"
};
manager.Create(lightU, "password");
ApplicationUser hakU = new ApplicationUser {
UserName = "******",
Email = "*****@*****.**"
};
manager.Create(hakU, "password");
ApplicationUser alfonsU = new ApplicationUser {
UserName = "******",
Email = "*****@*****.**"
};
manager.Create(alfonsU, "password");
// Define Profiles
ProfileModels eliasP = new ProfileModels {
Id = eliasU.Id,
FirstName = "Elias",
LastName = "Stagg",
Gender = Gender.Man,
Biography = "This is an example biography of the profile for Elias Stagg.",
BirthDate = new DateTime(1998, 04, 22),
Desperation = 10,
Loneliness = 10,
Horniness = 4,
Pride = 6,
ProfileImage = setInitializerProfilePicture("/Content/Images/stagg.jpg")
};
ProfileModels nicoP = new ProfileModels {
Id = nicoU.Id,
FirstName = "Nicolas",
LastName = "Björkefors",
Gender = Gender.Man,
Biography = "This is an example biography of the profile for Nicolas Björkefors.",
BirthDate = new DateTime(1998, 01, 05),
Desperation = 9,
Loneliness = 10,
Horniness = 3,
Pride = 8,
ProfileImage = setInitializerProfilePicture("/Content/Images/smugOkuu.png")
};
ProfileModels oskarP = new ProfileModels {
Id = oskarU.Id,
FirstName = "Oskar",
LastName = "Olofsson",
Gender = Gender.Man,
Biography = "This is an example biography of the profile for Oskar Olofsson.",
BirthDate = new DateTime(1982, 09, 15),
Desperation = 9,
Loneliness = 10,
Horniness = 10,
Pride = 1,
ProfileImage = setInitializerProfilePicture("/Content/Images/pickadoller.jpg")
};
ProfileModels randomP = new ProfileModels {
Id = randomU.Id,
FirstName = "Random",
LastName = "Svensson",
Gender = Gender.Attackhelicopter,
Biography = "This is an example biography of the profile for Random Svensson.",
BirthDate = new DateTime(1980, 08, 14),
Desperation = 5,
Loneliness = 6,
Horniness = 10,
Pride = 9,
ProfileImage = setInitializerProfilePicture("/Content/Images/random.png")
};
ProfileModels corazonP = new ProfileModels {
Id = corazonU.Id,
FirstName = "Corazon",
LastName = "D'amico",
Gender = Gender.Man,
Biography = "Este es un ejemplo de biografía del perfil de Corazon D'amico.",
BirthDate = new DateTime(1971, 07, 15),
Desperation = 10,
Loneliness = 10,
Horniness = 7,
Pride = 3,
ProfileImage = setInitializerProfilePicture("/Content/Images/corazon.png")
};
ProfileModels andreasP = new ProfileModels {
Id = andreasU.Id,
FirstName = "Andreas",
LastName = "Ask",
Gender = Gender.Man,
Biography = "Ja, nu har du hittat min profil. Diskutera vad detta innebär sakligt i par eller nåt. Och förresten har någon sett min fez?",
BirthDate = new DateTime(1900, 01, 25),
Desperation = 8,
Loneliness = 10,
Horniness = 7,
Pride = 5,
ProfileImage = setInitializerProfilePicture("/Content/Images/ask.jpg")
};
ProfileModels mathiasP = new ProfileModels {
Id = mathiasU.Id,
FirstName = "Mathias",
LastName = "Hatakka",
Gender = Gender.Man,
Biography = "Jag har en katt, och katten. Har flera katter. Mitt hem är praktiskt taget ett katthem.",
BirthDate = new DateTime(1900, 05, 11),
Desperation = 5,
Loneliness = 10,
Horniness = 7,
Pride = 8,
ProfileImage = setInitializerProfilePicture("/Content/Images/katt.jpg")
};
ProfileModels lightP = new ProfileModels {
Id = lightU.Id,
FirstName = "月",
LastName = "夜神",
Gender = Gender.Man,
Biography = "を魚取り、ヌードリングする",
BirthDate = new DateTime(1996, 03, 22),
Desperation = 3,
Loneliness = 10,
Horniness = 7,
Pride = 10,
ProfileImage = setInitializerProfilePicture("/Content/Images/light.png")
};
ProfileModels hakP = new ProfileModels {
Id = hakU.Id,
FirstName = "Hak",
LastName = "Son",
Gender = Gender.Man,
Biography = "Don't come near me or the princess. I'll kill you.",
BirthDate = new DateTime(1982, 09, 29),
Desperation = 2,
Loneliness = 10,
Horniness = 8,
Pride = 10,
ProfileImage = setInitializerProfilePicture("/Content/Images/hak.png")
};
ProfileModels alfonsP = new ProfileModels {
Id = alfonsU.Id,
FirstName = "Alfons",
LastName = "Åberg",
Gender = Gender.Man,
Biography = "Någon som vill med på brajbaxningsäventyr?",
BirthDate = new DateTime(2002, 12, 11),
Desperation = 6,
Loneliness = 10,
Horniness = 4,
Pride = 10,
ProfileImage = setInitializerProfilePicture("/Content/Images/braj.png")
};
// Define Posts
PostModels post1 = new PostModels {
PostFromId = eliasU.Id,
PostToId = randomU.Id,
PostDateTime = new DateTime(2019, 01, 12, 14, 44, 24),
Text = "Praise RNGesus!"
};
PostModels post2 = new PostModels {
PostFromId = oskarU.Id,
PostToId = randomU.Id,
PostDateTime = new DateTime(2019, 01, 13, 23, 45, 02),
Text = "Shit asså."
};
PostModels post3 = new PostModels {
PostFromId = nicoU.Id,
PostToId = randomU.Id,
PostDateTime = new DateTime(2019, 01, 14, 19, 01, 08),
Text = "Söker efter någon att spela Pokémon Reborn med!"
};
PostModels post4 = new PostModels {
PostFromId = randomU.Id,
PostToId = randomU.Id,
PostDateTime = new DateTime(2019, 01, 15, 17, 33, 48),
Text = "Does this thing work?"
};
PostModels post5 = new PostModels {
PostFromId = nicoU.Id,
PostToId = corazonU.Id,
PostDateTime = new DateTime(2019, 01, 15, 07, 27, 33),
Text = "I'm your biggest fan!"
};
PostModels post6 = new PostModels {
PostFromId = corazonU.Id,
PostToId = corazonU.Id,
PostDateTime = new DateTime(2019, 01, 15, 08, 03, 17),
Text = "Gracias."
};
PostModels post7 = new PostModels {
PostFromId = corazonU.Id,
PostToId = eliasU.Id,
PostDateTime = new DateTime(2019, 01, 16, 17, 28, 51),
Text = "Hola señor."
};
PostModels post8 = new PostModels {
PostFromId = oskarU.Id,
PostToId = nicoU.Id,
PostDateTime = new DateTime(2019, 01, 18, 22, 04, 55),
Text = "Mate, get stuck in there. Scrum!"
};
PostModels post9 = new PostModels {
PostFromId = eliasU.Id,
PostToId = randomU.Id,
PostDateTime = new DateTime(2019, 01, 20, 19, 05, 33),
Text = "Fett avis på din randomness."
};
PostModels post10 = new PostModels {
PostFromId = lightU.Id,
PostToId = alfonsU.Id,
PostDateTime = new DateTime(2019, 01, 22, 21, 09, 53),
Text = "死ね、 人間のくず"
};
PostModels post11 = new PostModels {
PostFromId = alfonsU.Id,
PostToId = mathiasU.Id,
PostDateTime = new DateTime(2019, 01, 22, 21, 05, 18),
Text = "Hej jag vill klappa katter."
};
PostModels post12 = new PostModels {
PostFromId = andreasU.Id,
PostToId = eliasU.Id,
PostDateTime = new DateTime(2019, 01, 23, 07, 48, 32),
Text = "Kom ihåg att evaluera dina hattalternativ noga varje morgon. Idag valde jag min fez."
};
PostModels post13 = new PostModels {
PostFromId = mathiasU.Id,
PostToId = oskarU.Id,
PostDateTime = new DateTime(2019, 01, 24, 11, 39, 33),
Text = "En av mina katter har tappat sitt hår. Får jag låna lite av ditt?"
};
PostModels post14 = new PostModels {
PostFromId = nicoU.Id,
PostToId = lightU.Id,
PostDateTime = new DateTime(2019, 01, 24, 22, 52, 04),
Text = "私はLですwwww."
};
PostModels post15 = new PostModels {
PostFromId = oskarU.Id,
PostToId = alfonsU.Id,
PostDateTime = new DateTime(2019, 01, 25, 10, 41, 52),
Text = "Har svårt att stå emot en sådan lockande inbjudan! Hänger med på studs."
};
PostModels post16 = new PostModels {
PostFromId = alfonsU.Id,
PostToId = andreasU.Id,
PostDateTime = new DateTime(2019, 02, 14, 06, 37, 09),
Text = "Eyy, Andy! Ska du med och baxa braj?"
};
// Define requests
RequestModels request1 = new RequestModels {
RequestDateTime = DateTime.Now,
RequestFromId = nicoU.Id,
RequestToId = corazonU.Id
};
RequestModels request2 = new RequestModels {
RequestDateTime = DateTime.Now,
RequestFromId = oskarU.Id,
RequestToId = corazonU.Id
};
RequestModels request3 = new RequestModels {
RequestDateTime = DateTime.Now,
RequestFromId = oskarU.Id,
RequestToId = eliasU.Id
};
RequestModels request4 = new RequestModels {
RequestDateTime = DateTime.Now,
RequestFromId = randomU.Id,
RequestToId = eliasU.Id
};
RequestModels request5 = new RequestModels {
RequestDateTime = DateTime.Now,
RequestFromId = nicoU.Id,
RequestToId = lightU.Id
};
RequestModels request6 = new RequestModels {
RequestDateTime = DateTime.Now,
RequestFromId = lightU.Id,
RequestToId = mathiasU.Id
};
RequestModels request7 = new RequestModels {
RequestDateTime = DateTime.Now,
RequestFromId = randomU.Id,
RequestToId = alfonsU.Id
};
RequestModels request8 = new RequestModels {
RequestDateTime = DateTime.Now,
RequestFromId = alfonsU.Id,
RequestToId = eliasU.Id
};
RequestModels request9 = new RequestModels {
RequestDateTime = DateTime.Now,
RequestFromId = hakU.Id,
RequestToId = eliasU.Id
};
RequestModels request10 = new RequestModels {
RequestDateTime = DateTime.Now,
RequestFromId = andreasU.Id,
RequestToId = nicoU.Id
};
// Define FriendCategories
FriendCategoryModels category1 = new FriendCategoryModels {
CategoryName = "Default"
};
FriendCategoryModels category2 = new FriendCategoryModels {
CategoryName = "Acquaintances"
};
FriendCategoryModels category3 = new FriendCategoryModels {
CategoryName = "BFFs"
};
// Define Visits
VisitorModels eliasV1 = new VisitorModels {
VisitDateTime = new DateTime(2019, 01, 25, 10, 41, 52),
VisitFromId = nicoU.Id,
VisitToId = eliasU.Id
};
VisitorModels eliasV2 = new VisitorModels {
VisitDateTime = new DateTime(2019, 05, 15, 12, 54, 8),
VisitFromId = oskarU.Id,
VisitToId = eliasU.Id
};
VisitorModels eliasV3 = new VisitorModels {
VisitDateTime = new DateTime(2019, 05, 04, 22, 21, 54),
VisitFromId = andreasU.Id,
VisitToId = eliasU.Id
};
VisitorModels eliasV4 = new VisitorModels {
VisitDateTime = new DateTime(2019, 02, 21, 23, 15, 12),
VisitFromId = lightU.Id,
VisitToId = eliasU.Id
};
VisitorModels eliasV5 = new VisitorModels {
VisitDateTime = new DateTime(2019, 05, 25, 13, 41, 45),
VisitFromId = randomU.Id,
VisitToId = eliasU.Id
};
VisitorModels nicoV1 = new VisitorModels {
VisitDateTime = new DateTime(2019, 05, 25, 13, 41, 45),
VisitFromId = randomU.Id,
VisitToId = nicoU.Id
};
VisitorModels nicoV2 = new VisitorModels {
VisitDateTime = new DateTime(2019, 07, 30, 20, 35, 26),
VisitFromId = andreasU.Id,
VisitToId = nicoU.Id
};
VisitorModels nicoV3 = new VisitorModels {
VisitDateTime = new DateTime(2019, 08, 25, 14, 37, 55),
VisitFromId = lightU.Id,
VisitToId = nicoU.Id
};
VisitorModels oskarV = new VisitorModels {
VisitDateTime = new DateTime(2019, 09, 26, 15, 38, 56),
VisitFromId = andreasU.Id,
VisitToId = oskarU.Id
};
VisitorModels lightV = new VisitorModels {
VisitDateTime = new DateTime(2019, 05, 24, 19, 48, 26),
VisitFromId = andreasU.Id,
VisitToId = lightU.Id
};
VisitorModels mathiasV = new VisitorModels {
VisitDateTime = new DateTime(2019, 06, 23, 18, 47, 41),
VisitFromId = andreasU.Id,
VisitToId = mathiasU.Id
};
VisitorModels randomV = new VisitorModels {
VisitDateTime = new DateTime(2019, 09, 12, 09, 37, 23),
VisitFromId = andreasU.Id,
VisitToId = randomU.Id
};
VisitorModels hakV = new VisitorModels {
VisitDateTime = new DateTime(2019, 03, 28, 10, 00, 00),
VisitFromId = andreasU.Id,
VisitToId = randomU.Id
};
VisitorModels andreasV = new VisitorModels {
VisitDateTime = new DateTime(2019, 04, 19, 14, 12, 35),
VisitFromId = alfonsU.Id,
VisitToId = randomU.Id
};
VisitorModels alfonsV = new VisitorModels {
VisitDateTime = new DateTime(2019, 08, 25, 14, 37, 55),
VisitFromId = andreasU.Id,
VisitToId = alfonsU.Id
};
context.Visitors.AddRange(new[] { eliasV1, eliasV2, eliasV3, eliasV4, eliasV5, nicoV1, nicoV2, nicoV3, oskarV, lightV, mathiasV, randomV, hakV, andreasV, alfonsV });
context.Profiles.AddRange(new[] { eliasP, nicoP, oskarP, randomP, corazonP, andreasP, mathiasP, lightP, hakP, alfonsP }); // Add profiles
context.Posts.AddRange(new[] { post1, post2, post3, post4, post5, post6, post7, post8, post9, post10, post11, post12, post13, post14, post15, post16 }); // Add posts
context.Requests.AddRange(new[] { request1, request2, request3, request4, request5, request6, request7, request8, request9, request10 }); // Add requests
context.Categories.AddRange(new[] { category1, category2, category3 }); // Add friend categories
context.SaveChanges(); // We need to save the friend categories into the database to be able to access their IDs for the creation of the friends.
// Define friendships
FriendModels friends1 = new FriendModels {
UserId = nicoU.Id,
FriendId = oskarU.Id,
FriendCategory = category1.Id
};
FriendModels friends2 = new FriendModels {
UserId = nicoU.Id,
FriendId = eliasU.Id,
FriendCategory = category2.Id
};
FriendModels friends3 = new FriendModels {
UserId = eliasU.Id,
FriendId = corazonU.Id,
FriendCategory = category3.Id
};
FriendModels friends4 = new FriendModels {
UserId = oskarU.Id,
FriendId = randomU.Id,
FriendCategory = category1.Id
};
FriendModels friends5 = new FriendModels {
UserId = oskarU.Id,
FriendId = alfonsU.Id,
FriendCategory = category1.Id
};
FriendModels friends6 = new FriendModels {
UserId = eliasU.Id,
FriendId = lightU.Id,
FriendCategory = category1.Id
};
FriendModels friends7 = new FriendModels {
UserId = andreasU.Id,
FriendId = eliasU.Id,
FriendCategory = category1.Id
};
FriendModels friends8 = new FriendModels {
UserId = nicoU.Id,
FriendId = hakU.Id,
FriendCategory = category1.Id
};
context.Friends.AddRange(new[] { friends1, friends2, friends3, friends4, friends5, friends6, friends7, friends8 }); // Add friendships
context.SaveChanges();
}
