public LoginResultDto Login(LoginDto dto)
{
var result = new LoginResultDto();
dto.Password = DatabaseCreation.GetMd5(DatabaseCreation.GetSimpleMd5(dto.Password));
var accountFromDb = db.Accounts.FirstOrDefault(x => x.UserName == dto.UserName && x.Password == dto.Password && !x.DelFlag);
if (accountFromDb == null)
{
return(null);
}
var user = db.Users.FirstOrDefault(u => u.Id == accountFromDb.UserId && !u.DelFlag);
if (user != null)
{
result.User = new UserInformationResponseDto(user, accountFromDb.UserName);
}
var group = db.Groups.FirstOrDefault(g => g.Id == accountFromDb.GroupId && !g.DelFlag);
if (group != null)
{
result.Group = new GroupResponseDto
{
Id = group.Id,
Name = group.Name
};
}
db.SaveChanges();
return(result);
}
public AppConfig(IConfiguration configuration)
{
ConnectionStrings = new ConnectionStrings(configuration);
WebApplication = new WebApplication(configuration);
ProductInfo = new ProductInfo(configuration);
Security = new Security(configuration);
DatabaseCreation = new DatabaseCreation(configuration);
ServiceApi = new ServiceApi(configuration);
Logging = new Logging(configuration);
AzureAdOptions = new AzureAdOptions(configuration);
ApplicationInsights = new ApplicationInsights(configuration);
Content = new Content(configuration);
}
protected override void OnCreate(Bundle savedInstanceState)
{
databaseCreation = new DatabaseCreation();
//databaseCreation.InitaliseDatabase();
base.OnCreate(savedInstanceState);
SetContentView(Resource.Layout.activity_main);
DrawTopImageInPurple();
button_next = FindViewById <Button>(Resource.Id.titlePage_button_ok);
button_next.Click += Button_next_Click;
}
/// <summary>
/// Ensures that the migration database exists.
/// </summary>
/// <param name="projectdllPath"></param>
/// <param name="repoType"></param>
/// <param name="configFilePath"></param>
/// <param name="args"></param>
private void CreateRepoDatabase(string projectdllPath, Type repoType, string configFilePath, params object[] args)
{
var repoBase = TypeHandler.CreateRepoBase(projectdllPath, repoType, args);
var connectionString = ConnectionStringHandler.FindConnectionString(repoBase, configFilePath);
var builder = new System.Data.SqlClient.SqlConnectionStringBuilder
{
ConnectionString = connectionString
};
string databaseName = builder.InitialCatalog;
var migrationDbExists = DatabaseChecking.CheckDatabaseExists(connectionString, databaseName);
if (!migrationDbExists)
{
DatabaseCreation.CreateDatabase(connectionString, databaseName);
}
}
public void AddStudent(StudentDto dto)
{
var user = new User();
var account = new Account();
var student = new Student();
try
{
user.FirstName = dto.FirstName;
user.LastName = dto.LastName;
user.Avatar = dto.Avatar;
user.Gender = dto.Gender;
user.Birthday = Convert.ToDateTime(dto.Birthday);
user.PhoneNumber = dto.PhoneNumber;
user.Address = dto.Address;
user.IdentificationNumber = dto.IdentificationNumber;
db.Users.Add(user);
account.UserName = "******" + db.Accounts.Max(x => x.Id).ToString();
account.Password = DatabaseCreation.GetMd5(DatabaseCreation.GetSimpleMd5("12345678"));
account.UserId = user.Id;
account.GroupId = 4;
db.Accounts.Add(account);
student.UserId = user.Id;
student.ClassId = dto.ClassId;
student.ParentId = dto.ParentId;
student.Status = 0;
db.Students.Add(student);
}
catch (Exception e)
{
throw e;
}
db.SaveChanges();
}
public bool Add(TeacherDto dto)
{
var user = new EM.Database.Schema.User();
var account = new Account();
var teacher = new Teacher();
try
{
user.FirstName = dto.FirstName;
user.LastName = dto.LastName;
user.Avatar = dto.Avatar;
user.Gender = dto.Gender;
user.Birthday = Convert.ToDateTime(dto.Birthday);
user.PhoneNumber = dto.PhoneNumber;
user.Address = dto.Address;
user.IdentificationNumber = dto.IdentificationNumber;
db.Users.Add(user);
account.UserName = "******" + db.Accounts.Max(x => x.Id).ToString();
account.Password = DatabaseCreation.GetMd5(DatabaseCreation.GetSimpleMd5("12345678"));
account.UserId = user.Id;
account.GroupId = 6;
db.Accounts.Add(account);
teacher.UserId = user.Id;
teacher.TeamId = dto.TeamId;
db.Teachers.Add(teacher);
}
catch (Exception e)
{
return(false);
}
db.SaveChanges();
return(true);
}
private void CreateSupportingDatasets()
{
databaseCreation = new DatabaseCreation();
databaseCreation.InitaliseDatabase();
}
