/// <summary>
/// Modifier Un Etudiant
/// </summary>
/// <param name="myStudent"></param>
/// <returns></returns>
public bool UpdateStudent(Student myStudent)
{
using (var db = new Ef())
{
db.Student.Attach(myStudent);
db.Entry(myStudent).State = EntityState.Modified;
return(db.SaveChanges() > 0);
}
}
/// <summary>
///
/// </summary>
/// <param name="myMatiere"></param>
/// <returns></returns>
public bool UpdateMatiere(Matiere myMatiere)
{
using (var db = new Ef())
{
db.Matiere.Attach(myMatiere);
db.Entry(myMatiere).State = EntityState.Modified;
return(db.SaveChanges() > 0);
}
}
/// <summary>
///
/// </summary>
/// <param name="myFiliere"></param>
/// <returns></returns>
public bool UpdateFiliere(Filiere myFiliere)
{
using (var db = new Ef())
{
db.Filiere.Attach(myFiliere);
db.Entry(myFiliere).State = System.Data.Entity.EntityState.Modified;
return(db.SaveChanges() > 0);
}
}
/// <summary>
///
/// </summary>
/// <param name="myCours"></param>
/// <returns></returns>
public bool UpdateCours(Cours myCours)
{
using (var db = new Ef())
{
db.Cours.Attach(myCours);
db.Entry(myCours).State = EntityState.Modified;
return(db.SaveChanges() > 0);
}
}
/// <summary>
///
/// </summary>
/// <param name="mStaff"></param>
/// <returns></returns>
public bool UpdateStaff(Staff mStaff)
{
using (var db = new Ef())
{
db.Staff.Attach(mStaff);
db.Entry(mStaff).State = System.Data.Entity.EntityState.Modified;
return(db.SaveChanges() > 0);
}
}
/// <summary>
///
/// </summary>
/// <param name="myCours"></param>
/// <returns></returns>
public bool AddCours(Cours myCours)
{
myCours.CoursGuid = Guid.NewGuid();
myCours.PeriodeScolaireGuid = GetCurrentPeriodeScolaireGuid;
using (var db = new Ef())
{
db.Cours.Add(myCours);
return(db.SaveChanges() > 0);
}
}
/// <summary>
///
/// </summary>
/// <param name="myNote"></param>
/// <returns></returns>
private static bool AddStudentNote(StudentNote myNote)
{
//var controlDate = GetCoursById(myNote.CoursGuid)?.StartDate;
//if (controlDate == null || !EstPresent(myNote.StudentGuid, myNote.CoursGuid, (DateTime)controlDate)) myNote.Note = 0;
using (var db = new Ef())
{
db.StudentNote.Add(myNote);
return(db.SaveChanges() > 0);
}
}
/// <summary>
///
/// </summary>
/// <param name="myNote"></param>
/// <returns></returns>
private static bool UpdateStudentNote(StudentNote myNote)
{
//var controlDate = GetCoursById(myNote.CoursGuid)?.StartDate;
//if (controlDate == null || !EstPresent(myNote.StudentGuid, myNote.CoursGuid, (DateTime)controlDate)) myNote.Note = 0;
using (var db = new Ef())
{
db.StudentNote.Attach(myNote);
db.Entry(myNote).State = EntityState.Modified;
return(db.SaveChanges() > 0);
}
}
/// <summary>
///
/// </summary>
/// <param name="myTicket"></param>
/// <returns></returns>
private static bool AddAbsenceTicket(AbsenceTicket myTicket)
{
if (!myTicket.IsPresent)
{
myTicket.RetardTime = new TimeSpan(0, 0, 0, 0);
}
using (var db = new Ef())
{
db.AbsenceTicket.Add(myTicket);
return(db.SaveChanges() > 0);
}
}
/// <summary>
///
/// </summary>
/// <param name="myTicket"></param>
/// <returns></returns>
private static bool UpdateAbsenceTicket(AbsenceTicket myTicket)
{
if (!myTicket.IsPresent)
{
myTicket.RetardTime = new TimeSpan(0, 0, 0, 0);
}
using (var db = new Ef())
{
db.AbsenceTicket.Attach(myTicket);
db.Entry(myTicket).State = EntityState.Modified;
return(db.SaveChanges() > 0);
}
}
/// <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);
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
using (IServiceScope serviceScope = app.ApplicationServices.GetService <IServiceScopeFactory>().CreateScope()) {
// Stand up the database.
Ef ef = serviceScope.ServiceProvider.GetRequiredService <Ef>();
ef.Database.Migrate();
// Add seed data if necessary.
if (ef.Invitees.Count() == 0)
{
ef.Invitees.AddRange(Constants.SEED_INVITEES);
ef.SaveChanges();
}
}
app.UseStaticFiles(Constants.URL_PATH_PREFIX_FOR_ASSETS);
app.UseMvc(routes => routes.MapRoute("default", Constants.URL_PATH_PREFIX.Substring(1) + "/{action=Index}/{controller=Home}"));
}