public long AddOrUpdateDepartment(AddDepartmentCriteria departmentCirteria)
{
long retour = 0;
Department department = departmentCirteria.department;
if (department != null)
{
Department departmentToUpdateOrSave = null;
departmentToUpdateOrSave = (department.Id != 0) ? db.Departments.Find(department.Id) : db.Departments.Create();
departmentToUpdateOrSave.department_name = department.department_name;
departmentToUpdateOrSave.isWorkshop = department.isWorkshop;
db.Entry(departmentToUpdateOrSave).State = (department.Id != 0) ? EntityState.Modified : EntityState.Added;
List <long> altelierIds = departmentCirteria.altelierIds;
if (altelierIds.Count() > 0)
{
//Add into table derpatment_altelier
}
db.SaveChanges();
retour = departmentToUpdateOrSave.Id;
}
return(retour);
}
private void CreatTypeCar(ManagementDbContext context)
{
if (context.TypeCars.Count() == 0)
{
List <TypeCar> listTypeCars = new List <TypeCar>()
{
new TypeCar()
{
Name = "Xe khách"
},
new TypeCar()
{
Name = "Xe hợp đồng"
},
};
context.TypeCars.AddRange(listTypeCars);
context.SaveChanges();
}
if (context.PostCategories.Count() == 0)
{
List <PostCategory> lstPostCate = new List <PostCategory>()
{
new PostCategory()
{
Name = "Tổng hợp", Status = true, Alias = "Tonghop"
}
};
context.PostCategories.AddRange(lstPostCate);
context.SaveChanges();
}
}
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 int ModifyUser(long id, string username, string password, int authority)
{
int retour = 0;
using (var db = new ManagementDbContext())
{
try
{
var result = (from u in db.Users
where u.Username == username && u.Id != id
select u.Id).FirstOrDefault();
if (result == 0)
{
var user = db.Users.Find(id);
user.Username = username;
user.Password = password;
user.Authority = authority;
user.UpdateBy = Comon.UserId;
db.Entry(user).State = EntityState.Modified;
//db.SaveChanges();
db.SaveChanges();
retour = 1;
}
}
catch (Exception e)
{
retour = 0;
}
}
return(retour);
}
public int Registrer(string username, string password, int authority)
{
int retour = 0;
using (var db = new ManagementDbContext())
{
var result = (from u in db.Users
where u.Username == username
select u.Id).FirstOrDefault();
if (result == 0)
{
var user = new User
{
CreateBy = Comon.UserId,
Username = username,
Password = password,
//TODO: Change a more solide methode to get the authority
Authority = authority
};
db.Users.Add(user);
db.SaveChanges();
retour = 1;
}
else
{
retour = 0;
}
}
return(retour);
}
public void Create()
{
new DefaultEditionCreator(_context).Create();
new DefaultLanguagesCreator(_context).Create();
new HostRoleAndUserCreator(_context).Create();
new DefaultSettingsCreator(_context).Create();
_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();
}
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();
}
public long AddOrUpdateAltelier(Altelier altelier)
{
long retour = 0;
if (altelier != null)
{
Altelier altelierToUpdateOrSave = null;
altelierToUpdateOrSave = (altelier.Id > 0) ? db.Alteliers.Find(altelier.Id) : db.Alteliers.Create();
altelierToUpdateOrSave.alterlier_name = altelier.alterlier_name;
altelierToUpdateOrSave.alterlier_propotion = altelier.alterlier_propotion;
db.Entry(altelierToUpdateOrSave).State = (altelier.Id > 0) ? EntityState.Modified : EntityState.Added;
db.SaveChanges();// TODO: change to asyn
retour = altelierToUpdateOrSave.Id;
}
return(retour);
}
public long AddorUpdateEmployee(Employee employee)
{
long retour = 0;
if (employee != null)
{
Employee employeeToSaveOrUpdate = null;
employeeToSaveOrUpdate = (employee.id > 0) ? db.Employees.Find(employee.id) : db.Employees.Create();
employeeToSaveOrUpdate.employee_name = employee.employee_name;
employeeToSaveOrUpdate.altelier_id = employee.altelier_id;
employeeToSaveOrUpdate.haveDorm = employee.haveDorm;
employeeToSaveOrUpdate.haveSeniorityPay = employee.haveSeniorityPay;
employeeToSaveOrUpdate.havePaySocialSecurity = employee.havePaySocialSecurity;
employeeToSaveOrUpdate.isTeamLeader = employee.isTeamLeader;
db.Entry(employeeToSaveOrUpdate).State = (employee.id > 0) ? EntityState.Modified : EntityState.Added;
db.SaveChanges();
retour = employeeToSaveOrUpdate.id;
}
return(retour);
}
public long AddOrUpdateUser(User user)
{
long retour = 0;
if (user != null)
{
User userToCreateOrUpdate = null;
userToCreateOrUpdate = (user.Id > 0) ? db.Users.Find(user.Id) : db.Users.Create();
if (db.Users.Where(p => p.Username == user.Username).FirstOrDefault() != null && user.Id == 0)
{
return(0);
}
userToCreateOrUpdate.Username = user.Username;
userToCreateOrUpdate.Password = Comon.GetEncryptText(user.Password);
userToCreateOrUpdate.Authority = user.Authority;
db.Entry(userToCreateOrUpdate).State = (user.Id > 0) ? EntityState.Modified : EntityState.Added;
db.SaveChanges();//TODO: async
retour = userToCreateOrUpdate.Id;
}
return(retour);
}
public long AddOrUpdateRevenue(Revenue revenue)
{
long retour = 0;
if (revenue != null)
{
Revenue revenueToCreateOrUpdate = null;
revenueToCreateOrUpdate = (revenue.id > 0) ? db.Revenues.Find(revenue.id) : db.Revenues.Create();
if (db.Revenues.Where(p => p.year == revenue.year && p.month == revenue.month).FirstOrDefault() != null && revenue.id == 0)
{
return(0);
}
revenueToCreateOrUpdate.year = revenue.year;
revenueToCreateOrUpdate.month = revenue.month;
revenueToCreateOrUpdate.number = revenue.number;
db.Entry(revenueToCreateOrUpdate).State = (revenue.id > 0) ? EntityState.Modified : EntityState.Added;
db.SaveChanges();//TODO: async
retour = revenueToCreateOrUpdate.id;
}
return(retour);
}
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();
}
}
private void CreateHostRoleAndUsers()
{
// Admin role for host
var adminRoleForHost = _context.Roles.IgnoreQueryFilters().FirstOrDefault(r => r.TenantId == null && r.Name == StaticRoleNames.Host.Admin);
if (adminRoleForHost == null)
{
adminRoleForHost = _context.Roles.Add(new Role(null, StaticRoleNames.Host.Admin, StaticRoleNames.Host.Admin)
{
IsStatic = true, IsDefault = true
}).Entity;
_context.SaveChanges();
}
// Grant all permissions to admin role for host
var grantedPermissions = _context.Permissions.IgnoreQueryFilters()
.OfType <RolePermissionSetting>()
.Where(p => p.TenantId == null && p.RoleId == adminRoleForHost.Id)
.Select(p => p.Name)
.ToList();
var permissions = PermissionFinder
.GetAllPermissions(new ManagementAuthorizationProvider())
.Where(p => p.MultiTenancySides.HasFlag(MultiTenancySides.Host) &&
!grantedPermissions.Contains(p.Name))
.ToList();
if (permissions.Any())
{
_context.Permissions.AddRange(
permissions.Select(permission => new RolePermissionSetting
{
TenantId = null,
Name = permission.Name,
IsGranted = true,
RoleId = adminRoleForHost.Id
})
);
_context.SaveChanges();
}
// Admin user for host
var adminUserForHost = _context.Users.IgnoreQueryFilters().FirstOrDefault(u => u.TenantId == null && u.UserName == AbpUserBase.AdminUserName);
if (adminUserForHost == null)
{
var user = new User
{
TenantId = null,
UserName = AbpUserBase.AdminUserName,
Name = "admin",
Surname = "admin",
EmailAddress = "*****@*****.**",
IsEmailConfirmed = true,
IsActive = true
};
user.Password = new PasswordHasher <User>(new OptionsWrapper <PasswordHasherOptions>(new PasswordHasherOptions())).HashPassword(user, "123qwe");
user.SetNormalizedNames();
adminUserForHost = _context.Users.Add(user).Entity;
_context.SaveChanges();
// Assign Admin role to admin user
_context.UserRoles.Add(new UserRole(null, adminUserForHost.Id, adminRoleForHost.Id));
_context.SaveChanges();
_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 ManagementAuthorizationProvider())
.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();
}
}