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