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 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 async Task <List <User> > GetAllUser()
{
using (var db = new ManagementDbContext())
{
return(await(from user in db.Users select user).ToListAsync());
}
}
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();
}
}
public Altelier findAltelier(long Id)
{
Altelier altelier;
using (var db = new ManagementDbContext())
{
altelier = db.Alteliers.Find(Id);
}
return(altelier);
}
public static void SeedHostDb(ManagementDbContext context)
{
context.SuppressAutoSetTenantId = true;
// Host seed
new InitialHostDbBuilder(context).Create();
// Default tenant seed (in host database).
new DefaultTenantBuilder(context).Create();
new TenantRoleAndUserBuilder(context, 1).Create();
}
public int removeAltelier(long Id)
{
int retour = 0;
using (var db = new ManagementDbContext())
{
try
{
var altelier = db.Alteliers.Find(Id);
db.Alteliers.Remove(altelier);
db.SaveChangesAsync();
retour = 1;
}
catch (Exception e)
{
retour = 0;
}
}
return(retour);
}
private void CreateAccount(ManagementDbContext context)
{
if (context.Users.Count() == 0)
{
var manager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(new ManagementDbContext()));
var roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(new ManagementDbContext()));
string birtday = "June 18, 1996";
var user = new ApplicationUser()
{
UserName = "******",
Email = "*****@*****.**",
EmailConfirmed = true,
BirthDay = DateTime.Parse(birtday),
FullName = "Vu Duc Cuong"
};
manager.Create(user, "123@123a");
if (!roleManager.Roles.Any())
{
roleManager.Create(new IdentityRole {
Name = "Admin"
});
roleManager.Create(new IdentityRole {
Name = "User"
});
roleManager.Create(new IdentityRole {
Name = "Management"
});
}
var adminUser = manager.FindByEmail("*****@*****.**");
manager.AddToRoles(adminUser.Id, new string[] { "Admin", "User", "Management" });
}
}
public CoursesController(ManagementDbContext context)
{
_context = context;
}
public InitialHostDbBuilder(ManagementDbContext context)
{
_context = context;
}
public DefaultEditionCreator(ManagementDbContext context)
{
_context = context;
}
public DeviceActionController(ManagementDbContext db, IMapper mapper)
{
_db = db;
_mapper = mapper;
}
public UsersController(ManagementDbContext context)
{
_context = context;
}
public LampuService(ManagementDbContext dbContext)
{
this._db = dbContext;
}
public DefaultTenantBuilder(ManagementDbContext context)
{
_context = context;
}
public TenantRoleAndUserBuilder(ManagementDbContext context, int tenantId)
{
_context = context;
_tenantId = tenantId;
}
public FileController(ManagementDbContext db, IWebHostEnvironment env, IMapper mapper)
{
_db = db;
_virtualRoot = env.WebRootPath;
_mapper = mapper;
}
public SoftwareController(ManagementDbContext db)
{
_db = db;
}
public ManagementDbContext Init()
{
return(dbContext ?? (dbContext = new ManagementDbContext()));
}
public TaxIdController(ManagementDbContext db)
{
_db = db;
}
public RegistrationsController(ManagementDbContext context)
{
_context = context;
}
public WorkingPositionTipController(ManagementDbContext db)
{
_db = db;
}
public StudentController(ManagementDbContext db)
{
_db = db;
}
public DeviceActionTypeController(ManagementDbContext db, MapperConfiguration mapperCfg)
{
_db = db;
_mapperCfg = mapperCfg;
}
public DefaultLanguagesCreator(ManagementDbContext context)
{
_context = context;
}
public EmployeeController(ManagementDbContext db, IMapper mapper, MapperConfiguration mapperCfg)
{
_db = db;
_mapper = mapper;
_mapperCfg = mapperCfg;
}
public HostRoleAndUserCreator(ManagementDbContext context)
{
_context = context;
}
public DepartmentTipController(ManagementDbContext db)
{
_db = db;
}
public BatchesController(ManagementDbContext context)
{
_context = context;
}
public CertController(ManagementDbContext db, MapperConfiguration mapperCfg)
{
_db = db;
_mapperCfg = mapperCfg;
}
