public void Load()
{
string path = @"../../../file.txt";
var phonebookFIle = File.ReadAllText(path).Split(new[] { Environment.NewLine },
StringSplitOptions.None);
foreach (var phone in phonebookFIle)
{
var name = phone.Split()[0];
var phoneNumber = phone.Split()[1];
if (checkPhoneNormalBg.Check(phoneNumber))
{
var checkUser = dbContext.Users.Any(a => a.Name == name);
if (!checkUser)
{
var currentUser = new PhoneUser {
Name = name, PhoneNumber = phoneNumber
};
phoneBook.Add(currentUser);
}
}
dbContext.Users.UpdateRange(phoneBook);
dbContext.SaveChanges();
}
}
private void CreateHostRoleAndUsers()
{
//Admin role for host
var adminRoleForHost = _context.Roles.FirstOrDefault(r => r.TenantId == null && r.Name == StaticRoleNames.Host.Admin);
if (adminRoleForHost == null)
{
adminRoleForHost = _context.Roles.Add(new Role {
Name = StaticRoleNames.Host.Admin, DisplayName = StaticRoleNames.Host.Admin, IsStatic = true
});
_context.SaveChanges();
//Grant all tenant permissions
var permissions = PermissionFinder
.GetAllPermissions(new PhoneBookAuthorizationProvider())
.Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Host))
.ToList();
var personPermissions =
PermissionFinder.GetAllPermissions(new PersonAppAuthorizationProvider()).ToList();
permissions.AddRange(personPermissions);
foreach (var permission in permissions)
{
_context.Permissions.Add(
new RolePermissionSetting
{
Name = permission.Name,
IsGranted = true,
RoleId = adminRoleForHost.Id
});
}
_context.SaveChanges();
}
//Admin user for tenancy host
var adminUserForHost = _context.Users.FirstOrDefault(u => u.TenantId == null && u.UserName == User.AdminUserName);
if (adminUserForHost == null)
{
adminUserForHost = _context.Users.Add(
new User
{
UserName = User.AdminUserName,
Name = "System",
Surname = "Administrator",
EmailAddress = "*****@*****.**",
IsEmailConfirmed = true,
Password = new PasswordHasher().HashPassword(User.DefaultPassword)
});
_context.SaveChanges();
_context.UserRoles.Add(new UserRole(null, adminUserForHost.Id, adminRoleForHost.Id));
_context.SaveChanges();
}
}
private void CreateRolesAndUsers()
{
//Admin role
var adminRole = _context.Roles.FirstOrDefault(r => r.TenantId == _tenantId && r.Name == StaticRoleNames.Tenants.Admin);
if (adminRole == null)
{
adminRole = _context.Roles.Add(new Role(_tenantId, StaticRoleNames.Tenants.Admin, StaticRoleNames.Tenants.Admin)
{
IsStatic = true
});
_context.SaveChanges();
//Grant all permissions to admin role
var permissions = PermissionFinder
.GetAllPermissions(new PhoneBookAuthorizationProvider())
.Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Tenant))
.ToList();
var personPermissions =
PermissionFinder.GetAllPermissions(new PersonAppAuthorizationProvider()).ToList();
permissions.AddRange(personPermissions);
foreach (var permission in permissions)
{
if (!permission.IsGrantedByDefault)
{
_context.Permissions.Add(
new RolePermissionSetting
{
TenantId = _tenantId,
Name = permission.Name,
IsGranted = true,
RoleId = adminRole.Id
});
}
}
_context.SaveChanges();
}
//admin user
var adminUser = _context.Users.FirstOrDefault(u => u.TenantId == _tenantId && u.UserName == User.AdminUserName);
if (adminUser == null)
{
adminUser = User.CreateTenantAdminUser(_tenantId, "*****@*****.**", "123qwe");
adminUser.IsEmailConfirmed = true;
adminUser.IsActive = true;
_context.Users.Add(adminUser);
_context.SaveChanges();
//Assign Admin role to admin user
_context.UserRoles.Add(new UserRole(_tenantId, adminUser.Id, adminRole.Id));
_context.SaveChanges();
}
}
private void CreateRolesAndUsers()
{
// Admin role
var adminRole = _context.Roles.IgnoreQueryFilters().FirstOrDefault(r => r.TenantId == _tenantId && r.Name == StaticRoleNames.Tenants.Admin);
if (adminRole == null)
{
adminRole = _context.Roles.Add(new Role(_tenantId, StaticRoleNames.Tenants.Admin, StaticRoleNames.Tenants.Admin) { IsStatic = true }).Entity;
_context.SaveChanges();
}
// Grant all permissions to admin role
var grantedPermissions = _context.Permissions.IgnoreQueryFilters()
.OfType<RolePermissionSetting>()
.Where(p => p.TenantId == _tenantId && p.RoleId == adminRole.Id)
.Select(p => p.Name)
.ToList();
var permissions = PermissionFinder
.GetAllPermissions(new PhoneBookAuthorizationProvider())
.Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Tenant) &&
!grantedPermissions.Contains(p.Name))
.ToList();
if (permissions.Any())
{
_context.Permissions.AddRange(
permissions.Select(permission => new RolePermissionSetting
{
TenantId = _tenantId,
Name = permission.Name,
IsGranted = true,
RoleId = adminRole.Id
})
);
_context.SaveChanges();
}
// Admin user
var adminUser = _context.Users.IgnoreQueryFilters().FirstOrDefault(u => u.TenantId == _tenantId && u.UserName == AbpUserBase.AdminUserName);
if (adminUser == null)
{
adminUser = User.CreateTenantAdminUser(_tenantId, "*****@*****.**");
adminUser.Password = new PasswordHasher<User>(new OptionsWrapper<PasswordHasherOptions>(new PasswordHasherOptions())).HashPassword(adminUser, "123qwe");
adminUser.IsEmailConfirmed = true;
adminUser.IsActive = true;
_context.Users.Add(adminUser);
_context.SaveChanges();
// Assign Admin role to admin user
_context.UserRoles.Add(new UserRole(_tenantId, adminUser.Id, adminRole.Id));
_context.SaveChanges();
}
}
public ActionResult Create(Person person)
{
if (ModelState.IsValid)
{
dbContext.Persons.Add(person);
dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(person));
}
public ActionResult Create([Bind(Include = "Id,UserName,Phone,Information,CreatedAt")] PhoneNumber phoneNumber)
{
if (ModelState.IsValid)
{
db.PhoneNumbers.Add(phoneNumber);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(phoneNumber));
}
public ActionResult Create(Phone phone, int?id)
{
if (ModelState.IsValid)
{
phone.Person = dbContext.Persons.Find(id);
dbContext.Phones.Add(phone);
dbContext.SaveChanges();
return(RedirectToAction("Index", new { id = id }));
}
return(View(phone));
}
private void CreateEditions()
{
var defaultEdition = _context.Editions.IgnoreQueryFilters().FirstOrDefault(e => e.Name == EditionManager.DefaultEditionName);
if (defaultEdition == null)
{
defaultEdition = new Edition { Name = EditionManager.DefaultEditionName, DisplayName = EditionManager.DefaultEditionName };
_context.Editions.Add(defaultEdition);
_context.SaveChanges();
/* Add desired features to the standard edition, if wanted... */
}
}
public JsonResult Create(ContactVM contactVM)
{
Contact contact = MapperUtil.MapToContact(contactVM);
db.Contacts.Add(contact);
db.SaveChanges();
lastContactId = db.Contacts.Max(item => item.Id);
return(Json(lastContactId, JsonRequestBehavior.AllowGet));
}
public void Create()
{
_context.DisableAllFilters();
new TestOrganizationUnitsBuilder(_context, _tenantId).Create();
_context.SaveChanges();
}
public ActionResult <People> AddPeople([FromBody] People incomingPeople)
{
var db = new PhoneBookDbContext();
db.People.Add(incomingPeople);
db.SaveChanges();
return(incomingPeople);
}
public Entities.ContactEntity.Contact Update(Entities.ContactEntity.Contact contact)
{
PhoneBookDbContext db = new PhoneBookDbContext();
db.Contacts.Update(contact);
db.SaveChanges();
return(contact);
}
public void Delete(int contactId)
{
PhoneBookDbContext db = new PhoneBookDbContext();
var contact = GetById(contactId);
db.Remove(contact);
db.SaveChanges();
}
public int Add(Entities.ContactEntity.Contact contact)
{
PhoneBookDbContext db = new PhoneBookDbContext();
var result = db.Add(contact);
db.SaveChanges();
return(result.Entity.ContactId);
}
public void Create()
{
new DefaultEditionCreator(_context).Create();
new DefaultLanguagesCreator(_context).Create();
new HostRoleAndUserCreator(_context).Create();
new DefaultSettingsCreator(_context).Create();
_context.SaveChanges();
}
private OrganizationUnit CreateOU(string displayName, string code, long?parentId = null)
{
var ou = _context.OrganizationUnits.Add(new OrganizationUnit(_tenantId, displayName, parentId)
{
Code = code
});
_context.SaveChanges();
return(ou);
}
private void AddSettingIfNotExists(string name, string value, int?tenantId = null)
{
if (_context.Settings.IgnoreQueryFilters().Any(s => s.Name == name && s.TenantId == tenantId && s.UserId == null))
{
return;
}
_context.Settings.Add(new Setting(tenantId, null, name, value));
_context.SaveChanges();
}
private void AddLanguageIfNotExists(ApplicationLanguage language)
{
if (_context.Languages.IgnoreQueryFilters().Any(l => l.TenantId == language.TenantId && l.Name == language.Name))
{
return;
}
_context.Languages.Add(language);
_context.SaveChanges();
}
public bool DeleteContact([FromBody] int id)
{
using (var db = new PhoneBookDbContext())
{
var contact = db.Contacts.FirstOrDefault(c => c.Id == id);
db.Contacts.Remove(contact);
db.SaveChanges();
return(true);
}
}
//delete a contact with id, given as a parameter
public ActionResult DeleteContact(int citizenToDelId)
{
PhoneBookDbContext db = new PhoneBookDbContext();
Citizen citizenToDelete = db.tblCitizens.Single(c => c.CitizenId == citizenToDelId);
if (citizenToDelete != null)
{
db.tblCitizens.Remove(citizenToDelete);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
protected override void Seed(PhoneBook.Data.PhoneBookDbContext context)
{
PhoneBookDbContext ctx = new PhoneBookDbContext();
ctx.PhoneNumbers.Add(new Models.PhoneNumber
{
Phone = "0893454345",
UserName = "******",
Information = "Lorem ipsun dolor sit amet",
CreatedAt = DateTime.Now,
});
ctx.SaveChanges();
}
public bool CreateContact(ContactDto contact)
{
using (var db = new PhoneBookDbContext())
{
db.Contacts.Add(new Contact
{
Name = contact.Name,
Phone = contact.Phone
});
db.SaveChanges();
return(true);
}
}
private void CreateUserAndRoles()
{
//Default tenant
var defaultTenant = _context.Tenants.FirstOrDefault(t => t.TenancyName == Tenant.DefaultTenantName);
if (defaultTenant == null)
{
_context.Tenants.Add(new Tenant {
TenancyName = Tenant.DefaultTenantName, Name = Tenant.DefaultTenantName
});
_context.SaveChanges();
}
}
public ActionResult <Object> DeletePeople([FromRoute] int id)
{
var db = new PhoneBookDbContext();
var peopleToDelete = db.People.FirstOrDefault(people => people.Id == id);
if (peopleToDelete != null)
{
db.People.Remove(peopleToDelete);
db.SaveChanges();
return(peopleToDelete);
}
else
{
return(new { message = "Person or people not found" });
}
}
public ActionResult DeleteGroupOfEmployees([FromBody] DeletePeopleViewModel vm)
{
var db = new PhoneBookDbContext();
var peopleIDsSelectedForDelete = db.People.Where(people => vm.PeopleIds.Contains(people.Id));
if (peopleIDsSelectedForDelete != null)
{
db.People.RemoveRange(peopleIDsSelectedForDelete);
db.SaveChanges();
return(Ok());
}
else
{
return(Ok(vm));
}
}
private void CreatePhone()
{
var defaultPhone = _context.Persons.FirstOrDefault(p => p.EmailAddress == "*****@*****.**");
if (defaultPhone == null)
{
_context.Persons.Add(new Person()
{
Name = "张三",
EmailAddress = "*****@*****.**",
Phones = new List <Phone>()
{
new Phone()
{
Type = PhoneType.Business, Number = "87115555"
},
new Phone()
{
Type = PhoneType.Home, Number = "010-1109"
}
}
});
}
var defaultPerson = _context.Persons.FirstOrDefault(p => p.EmailAddress == "*****@*****.**");
if (defaultPerson == null)
{
_context.Persons.Add(new Person()
{
Name = "李四",
EmailAddress = "*****@*****.**",
Phones = new List <Phone>()
{
new Phone()
{
Type = PhoneType.Business, Number = "88452675"
},
new Phone()
{
Type = PhoneType.Home, Number = "010-441109"
}
}
});
}
_context.SaveChanges();
}
public ActionResult <object> UpdatePeople([FromRoute] int id, [FromBody] People newInformation)
{
var db = new PhoneBookDbContext();
var peopleToUpdate = db.People.FirstOrDefault(people => people.Id == id);
if (peopleToUpdate != null)
{
peopleToUpdate.FirstName = newInformation.FirstName;
peopleToUpdate.LastName = newInformation.LastName;
peopleToUpdate.PhoneNumber = newInformation.PhoneNumber;
peopleToUpdate.Email = newInformation.Email;
db.SaveChanges();
return(Ok(peopleToUpdate));
}
else
{
return(NotFound());
}
}
public ActionResult Index()
{
PhoneBookDbContext db = new PhoneBookDbContext();
Citizen userAddingCitizen = new Citizen();
TryUpdateModel(userAddingCitizen);
//If user entered the both values and they are valid
if (ModelState.IsValid)
{
//pulling entity from db with parameters gaved by user
Citizen citizenFromDbByName = db.tblCitizens.FirstOrDefault(o => o.Name == userAddingCitizen.Name);
Citizen citizenFromDbByPhone = db.tblCitizens.FirstOrDefault(o => o.PhoneNumber == userAddingCitizen.PhoneNumber);
//if the same details already exists in db - adding relative messages
//and returning to the form
if (citizenFromDbByName != null)
{
ModelState.AddModelError(string.Empty, citizenFromDbByName.Name + " уже есть в справочнике.");
}
if (citizenFromDbByPhone != null)
{
ModelState.AddModelError(string.Empty, "Введенный номер уже назначен контакту с именем: " + citizenFromDbByPhone.Name);
}
if ((citizenFromDbByName != null) || (citizenFromDbByPhone != null))
{
return(View(db.spGetContacts(1).ToList()));
}
//if all entered data is ok - push it to the db
else
{
db.tblCitizens.Add(userAddingCitizen);
db.SaveChanges();
return(RedirectToAction("Index", "Home",
new { successMessage = userAddingCitizen.Name + " был добавлен в список" }));
}
}
//if something wrong with entered data - return to the same form and throw the error message
else
{
return(View(db.spGetContacts(1).ToList()));
}
}
private void CreateDefaultTenant()
{
// Default tenant
var defaultTenant = _context.Tenants.IgnoreQueryFilters().FirstOrDefault(t => t.TenancyName == AbpTenantBase.DefaultTenantName);
if (defaultTenant == null)
{
defaultTenant = new Tenant(AbpTenantBase.DefaultTenantName, AbpTenantBase.DefaultTenantName);
var defaultEdition = _context.Editions.IgnoreQueryFilters().FirstOrDefault(e => e.Name == EditionManager.DefaultEditionName);
if (defaultEdition != null)
{
defaultTenant.EditionId = defaultEdition.Id;
}
_context.Tenants.Add(defaultTenant);
_context.SaveChanges();
}
}
public static void SeedDatabase(PhoneBookDbContext context)
{
Guard.Against.Null(context, nameof(context));
context.Database.Migrate();
if (context.Contacts.Any())
{
return;
}
context.Contacts.AddRange(
new Contact("Vitaliy K.", "+79998885533"),
new Contact("Mr. Smith", "+15551356745"),
new Contact("Chuck Norris", "+8888888888"),
new Contact("George Bush Jr.", "+11111111111")
);
context.SaveChanges();
}
