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(); }