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