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 StudentAppAuthorizationProvider())
.Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Host))
.ToList();
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 StudentAppAuthorizationProvider())
.Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Tenant))
.ToList();
foreach (var permission in permissions)
{
_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, "*****@*****.**", User.DefaultPassword);
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 int AddStudent(StudentMaster student)
{
if (_studentContext != null)
{
_studentContext.StudentMasters.Add(student);
_studentContext.SaveChanges();
return(student.StudentID);
}
else
{
return(0);
}
}
public ActionResult Create(StudentVM s)
{
Students student = new Students();
student.FirstName = s.FirstName;
student.LastName = s.LastName;
student.BirthDate = s.BirthDate;
student.Email = s.Email;
student.Gender = s.Gender;
student.DepartmentId = s.DepartmentId;
studentDbContext.Students.Add(student);
studentDbContext.SaveChanges();
return(Json("Success"));
}
public ActionResult InitialSetup(InitialSetup setup)
{
if (!ModelState.IsValid)
{
return(View());
}
var conString = $"Data Source={setup.ServerName};Initial Catalog={setup.DatabaseName};Persist Security Info=True;";
if (setup.IntegratedSecurity)
{
conString += "Integrated Security = true;";
}
else
{
conString += $"User ID={setup.Username};Password={setup.Password};";
}
var path = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
System.IO.File.AppendAllText(path + "\\creds.txt", conString);
using (var context = new StudentAppDbContext())
{
context.Logs.Add(new Log
{
Message = "Initial setup completed"
});
context.SaveChanges();
}
return(RedirectToAction("Index"));
}
private void AddSettingIfNotExists(string name, string value, int?tenantId = null)
{
if (_context.Settings.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.Any(l => l.TenantId == language.TenantId && l.Name == language.Name))
{
return;
}
_context.Languages.Add(language);
_context.SaveChanges();
}
public void UpdateCustomer(int id)
{
var studentInDb = studentDbContext.Students.FirstOrDefault(s => s.SerialId == id);
if (studentInDb == null)
{
throw new HttpResponseException(HttpStatusCode.NotFound);
}
studentDbContext.Students.Remove(studentInDb);
studentDbContext.SaveChanges();
}
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();
}
}
private void CreateEditions()
{
var defaultEdition = _context.Editions.FirstOrDefault(e => e.Name == EditionManager.DefaultEditionName);
if (defaultEdition == null)
{
defaultEdition = new Edition {
Name = EditionManager.DefaultEditionName, DisplayName = EditionManager.DefaultEditionName
};
_context.Editions.Add(defaultEdition);
_context.SaveChanges();
//TODO: Add desired features to the standard edition, if wanted!
}
}
static void Main(string[] args)
{
StudentAppDbContext ob = new StudentAppDbContext();
Student s1 = new Student();
s1.Name = "Vishnu";
s1.MobileNo = "898989898";
ob.Add(s1);//
ob.SaveChanges();
Console.WriteLine("Hello World!");
}
public ActionResult Index(Student model)
{
if (!ModelState.IsValid)
{
return(View());
}
using (var context = new StudentAppDbContext())
{
context.Students.Add(new Student
{
StdName = model.StdName,
StdSex = model.StdSex,
StdAddr = model.StdAddr,
StdDOB = model.StdDOB,
StdNat = model.StdNat
});
context.SaveChanges();
}
return(RedirectToAction("Index"));
}