/// <summary> /// Return La Valeur du Paramettre System /// </summary> /// <param name="systemSetting"></param> /// <returns></returns> public object GetMatrixSetting(MatrixSettings systemSetting) { using (var db = new Ef()) { if (db.SystemSetting.Find(MatrixConstants.SystemGuid()) == null) { db.SystemSetting.Add(new MatrixSetting()); } switch (systemSetting) { case MatrixSettings.CurrentAnneeScolaire: return(db.SystemSetting.Find(MatrixConstants.SystemGuid()).CurrentAnneeScolaireGuid); case MatrixSettings.CurrentPerodeScolaire: return(db.SystemSetting.Find(MatrixConstants.SystemGuid()).CurrentPeriodeScolaireGuid); case MatrixSettings.EtablissementName: return(db.SystemSetting.Find(MatrixConstants.SystemGuid()).EtablissementName); case MatrixSettings.EtablissementFax: return(db.SystemSetting.Find(MatrixConstants.SystemGuid()).EtablissementFax); case MatrixSettings.EtablissementLogo: return(db.SystemSetting.Find(MatrixConstants.SystemGuid()).EtablissementLogo); default: return(null); } } }
private static void ProfileSeed(Ef ef) { var adminUserprofiles = new UserProfile { UserProfileGuid = MatrixConstants.SystemGuid(), UserSpace = UserSpace.AdminSpace }; var adminUserRoles = new UserRoles { UserProfileGuid = MatrixConstants.SystemGuid(), CanAddStudent = true, CanDeleteStudent = true }; var adminSettings = new UserSetting { UserProfileGuid = MatrixConstants.SystemGuid() }; ef.UserProfile.AddOrUpdate(adminUserprofiles); ef.UserRole.AddOrUpdate(adminUserRoles); ef.UserSetting.AddOrUpdate(adminSettings); }
private static void Staff_SeedFromSql(Context.SchoolContext ef) { var sqlString = Resources.Staffs; // RessourcesHelper.GetEmbeddedResource("DataService.Migrations.InitData.Staffs.sql"); //ef.Database.ExecuteSqlCommand("DELETE FROM Staffs"); //ef.Database.ExecuteSqlCommand(sqlString); var admin = new Staff { StaffGuid = MatrixConstants.SystemGuid(), Matricule = "SS-124-3652", PositionPrincipale = "Chef de Departement Info", DepartementPrincipale = "Informatique", HiredDate = DateTime.Today.AddDays(-500), Statut = StaffStatus.Actif, Person = new Person { Title = PersonTitles.Mr, PersonGuid = Guid.NewGuid(), FirstName = "Halid", LastName = "cisse", Nationality = "Mali", IdentityNumber = "", BirthDate = DateTime.Today.AddDays(-5000), BirthPlace = "Tayba", PhoneNumber = "0012547874", EmailAdress = "*****@*****.**", HomeAdress = "Mabella", RegistrationDate = DateTime.Today.AddDays(-100) } }; ef.Staffs.AddOrUpdate(admin); var x = ef.Staffs.ToList(); x.ForEach(s => s.Person.PhotoIdentity = GetRandomImg()); }
private static void Staff_SeedFromSql(Ef ef) { const string filePath = @"C:\Users\CISSE\Documents\Net\Matrix\DataService\Initializer\Staffs.sql"; var sqlFile = new FileInfo(filePath); var sqlString = sqlFile.OpenText().ReadToEnd(); ef.Database.ExecuteSqlCommand("DELETE FROM Staffs"); ef.Database.ExecuteSqlCommand(sqlString); var admin = new Staff { StaffGuid = MatrixConstants.SystemGuid(), StaffId = "Dl-I11-00", Position = "Chef de Departement Info", Departement = "Informatique", HiredDate = DateTime.Today.AddDays(-500), Statut = "Regulier", Title = "Mr", FirstName = "Halid", LastName = "cisse", Nationality = "", IdentityNumber = "", BirthDate = DateTime.Today.AddDays(-5000), BirthPlace = "Tayba", PhoneNumber = "0012547874", EmailAdress = "*****@*****.**", HomeAdress = "Mabella", RegistrationDate = DateTime.Today.AddDays(-100) }; ef.Staff.AddOrUpdate(admin); var x = ef.Staff.ToList(); x.ForEach(s => s.PhotoIdentity = GetRandomImg()); //x.ForEach (S => S.STAFF_ID = "ST-" + GenID(6)); }
/// <summary> /// Modifier Un Paramettre System /// </summary> /// <returns></returns> public bool SetMatrixSetting(MatrixSettings systemSetting, object newValue) { using (var db = new Ef()) { if (db.SystemSetting.Find(MatrixConstants.SystemGuid()) == null) { db.SystemSetting.Add(new MatrixSetting()); } switch (systemSetting) { case MatrixSettings.CurrentAnneeScolaire: db.SystemSetting.Find(MatrixConstants.SystemGuid()).CurrentAnneeScolaireGuid = (Guid)newValue; break; case MatrixSettings.CurrentPerodeScolaire: db.SystemSetting.Find(MatrixConstants.SystemGuid()).CurrentPeriodeScolaireGuid = (Guid)newValue; break; case MatrixSettings.EtablissementName: db.SystemSetting.Find(MatrixConstants.SystemGuid()).EtablissementName = (string)newValue; break; case MatrixSettings.EtablissementFax: db.SystemSetting.Find(MatrixConstants.SystemGuid()).EtablissementFax = (string)newValue; break; case MatrixSettings.EtablissementLogo: db.SystemSetting.Find(MatrixConstants.SystemGuid()).EtablissementLogo = (byte[])newValue; break; default: return(true); } return(db.SaveChanges() > 0); } }
/// <summary> /// Determine L'Utilisateur Actuelle /// </summary> /// <param name="userProfile"></param> public CurrentUser(UserProfile userProfile = null) { if (userProfile == null) { userProfile = new UserProfile { UserProfileGuid = MatrixConstants.SystemGuid(), UserSpace = UserSpace.AdminSpace }; } using (var db = new Ef()) { var st = db.Staff.Find(userProfile.UserProfileGuid); FirstName = st.FirstName; LastName = st.LastName; PhotoIdentity = st.PhotoIdentity; UserSpace = userProfile.UserSpace; UserSettings = db.UserSetting.Find(userProfile.UserProfileGuid); UserRoles = db.UserRole.Find(userProfile.UserProfileGuid); } }