//public void WriteDataToDatabase() //{ // using (SchoolEntityModelContainer context = new SchoolEntityModelContainer()) // { // context.Groups.Load(); // context.Groups.Add(new Groups() { Id = 1, Name = "C#-15-01" }); // context.Users.Load(); // foreach (var it in _users) // { // Users user = new Users() // { // FirstName = it.FirstName, // SecondName = it.SecondName, // LastName = it.LastName, // imageUri = it.Uri, // Age = (short)it.Age, // GroupsId = 1 // }; // var roles = context.Roles.Local.ToList(); // var currentRole = roles.FirstOrDefault(i => it.GetRoleType() == i.Role); // if (currentRole == null) // { // currentRole = roles.LastOrDefault(); // int roleId = currentRole != null ? currentRole.Id + 1 : 1; // context.Roles.Add(new Roles() { Role = it.GetRoleType(), Id = roleId }); // user.RolesId = roleId; // } // else // user.RolesId = currentRole.Id; // context.Users.Add(user); // } // context.SaveChanges(); // } //} public List<string> GetGroups() { using (SchoolEntities context = new SchoolEntities()) { return (from currGroup in context.Groups select currGroup.Name).ToList(); } }
public string GetUsers() { using (SchoolEntities context = new SchoolEntities()) { var users = (from user in context.Users select user).ToList(); string res = JsonConvert.SerializeObject(users); return res; } }