public void AddGroupAdmin(Group @group, User user)
{
var newAdmin = new GroupAdmin {
User = user
};
group.GroupAdmins.Add(newAdmin);
context.SaveChanges();
}
public void Execute()
{
PrintAllAdminsCommand printAllAdmins = new PrintAllAdminsCommand();
printAllAdmins.Execute();
System.Console.WriteLine("Select the id of the group you want to delete the admin: ");
int idGrupa = Convert.ToInt32(System.Console.ReadLine());
GroupAdmin groupAdmin = unitOfWork.GroupAdminRepository.FindBy(grA => grA.Group.Id == idGrupa);
unitOfWork.GroupAdminRepository.Delete(groupAdmin);
unitOfWork.save();
}
public void Execute()
{
PrintAllGroupsCommand printAllGroups = new PrintAllGroupsCommand();
PrintAllUsersCommand printAllUsers = new PrintAllUsersCommand();
printAllGroups.Execute();
System.Console.WriteLine();
System.Console.WriteLine("Select the id of the group you want to add an admin: ");
int idGrupa = Convert.ToInt32(System.Console.ReadLine());
Group group = unitOfWork.GroupRepository.FindBy(g => g.Id == idGrupa);
//inner join pe idGrupa
foreach (UserGroup userGroup in unitOfWork.UserGroupRepository.GetAll())
{
if (userGroup.GroupId == idGrupa)
{
System.Console.WriteLine(unitOfWork.UserRepository.FindBy(u => u.Id == userGroup.UserId));
}
}
System.Console.WriteLine("Select the id of the user from the group you want to add as admin: ");
int idUser = Convert.ToInt32(System.Console.ReadLine());
User user = unitOfWork.UserRepository.FindBy(u => u.Id == idUser);
GroupAdmin groupAdmin = new GroupAdmin()
{
GroupAdminForeignKey = user.Id, Name = user.Fullname, Group = group
};
unitOfWork.GroupAdminRepository.Add(groupAdmin);
group.Admin = groupAdmin;
unitOfWork.save();
}
public static void Initialize(HangoutsContext context)
{
context.Database.EnsureCreated();
//Look for any Users.
if (context.Users.Any())
{
return; // DB has been seeded
}
var users = new User[]
{
new User {
Username = "******", Fullname = "Ghita"
},
new User {
Username = "******", Fullname = "Ghita"
},
new User {
Username = "******", Fullname = "Ghita"
},
new User {
Username = "******", Fullname = "Ghita"
},
};
foreach (User user in users)
{
context.Users.Add(user);
}
context.SaveChanges();
var activities = new Activity[]
{
new Activity {
Description = "Football"
},
new Activity {
Description = "Dancing"
}
};
foreach (Activity activity in activities)
{
context.Activities.Add(activity);
}
context.SaveChanges();
var plans = new Plan[]
{
new Plan {
Description = "Teatru la Cluj", BeginnigTimePlan = "5/12/2007 5:05 PM", EndTimePlan = "5/12/2007 7:05 PM"
},
new Plan {
Description = "Pizza la Sibiu", BeginnigTimePlan = "1/09/2007 9:05 AM", EndTimePlan = "1/09/2007 9:05 AM 11:05 AM"
}
};
foreach (Plan plan in plans)
{
context.Plans.Add(plan);
}
context.SaveChanges();
var interests = new Interest[]
{
new Interest {
Description = "Cycling"
},
new Interest {
Description = "Dancing"
},
new Interest {
Description = "Film"
}
};
foreach (Interest intere in interests)
{
context.Interests.Add(intere);
}
context.SaveChanges();
var groups = new Group[]
{
new Group {
Name = "Group1"
},
new Group {
Name = "Group2"
},
new Group {
Name = "Group3"
}
};
foreach (Group group in groups)
{
context.Groups.Add(group);
}
context.SaveChanges();
//Adding one Group Admin
Group group2 = context.Groups.FirstOrDefault();
User user2 = context.Users.FirstOrDefault();
GroupAdmin groupAdmin = new GroupAdmin()
{
GroupAdminForeignKey = user2.Id, Name = user2.Fullname, Group = group2
};
context.GroupAdmins.Add(groupAdmin);
group2.Admin = groupAdmin;
context.SaveChanges();
//Adding some Interests to Users
User user3 = context.Users.FirstOrDefault();
Interest interest = context.Interests.FirstOrDefault();
Interest interest2 = context.Interests.SingleOrDefault(inter => inter.Description == "Dancing");
user3.Interests.Add(interest);
user3.Interests.Add(interest2);
interest.User = user3;
interest2.User = user3;
context.SaveChanges();
//ADDING SOME GROUP ACTIVITIES
context.GroupActivities.Add(new GroupActivity {
GroupId = context.Groups.SingleOrDefault(g => g.Name == "Group2").Id, ActivityId = context.Activities.SingleOrDefault(a => a.Description == "Football").Id
});
context.GroupActivities.Add(new GroupActivity {
GroupId = context.Groups.SingleOrDefault(g => g.Name == "Group1").Id, ActivityId = context.Activities.SingleOrDefault(a => a.Description == "Dancing").Id
});
context.SaveChanges();
//Many to many seed 1st way
var user1 = context.Users.FirstOrDefault();
var userGroup = new UserGroup {
GroupId = context.Groups.FirstOrDefault().Id, UserId = context.Users.FirstOrDefault().Id
};
user1.UserGroups.Add(userGroup);
context.Groups.FirstOrDefault().UserGroups.Add(userGroup);
context.SaveChanges();
//Many to many seed 2nd way
context.UserGroups.Add(new UserGroup {
GroupId = context.Groups.SingleOrDefault(g => g.Name == "Group2").Id, UserId = context.Users.SingleOrDefault(u => u.Username == "Adrian").Id
});
context.SaveChanges();
}
