public void CreateEcole(Ecole oldEcole, Ecole newEcole)
{
string filename = null;
if (!string.IsNullOrEmpty(newEcole.Logo))
{
string ext = Path.GetExtension(newEcole.Logo);
filename = Guid.NewGuid().ToString() + ext;
FileInfo fileSource = new FileInfo(newEcole.Logo);
string filePath = Path.Combine(dbFolder, "logo", filename);
FileInfo fileDest = new FileInfo(filePath);
if (!fileDest.Directory.Exists)
{
fileDest.Directory.Create();
}
fileSource.CopyTo(fileDest.FullName);
}
newEcole.Logo = filename;
ecoleRepo.Add(newEcole);
if (!string.IsNullOrEmpty(oldEcole.Logo))
{
File.Delete(oldEcole.Logo);
}
}
private void Update(Ecole institution)
{
Ecole i = dbEntities.Ecoles.FirstOrDefault(x => x.nom == institution.nom);
if (i is null)
{
dbEntities.Ecoles.Add(institution);
}
else
{
if (institution.nom != null)
{
i.nom = institution.nom;
}
if (institution.academie != null)
{
i.academie = institution.academie;
}
if (institution.direction_Provinciale != null)
{
i.direction_Provinciale = institution.direction_Provinciale;
}
if (institution.ministere != null)
{
i.ministere = institution.ministere;
}
if (institution.commoune != null)
{
i.commoune = institution.commoune;
}
}
dbEntities.SaveChanges();
}
public async Task <IActionResult> CreateProfesseur([FromBody] long ecoleId, ProfesseurCreateDto professeurCreateDto)
{
if (professeurCreateDto.name == null)
{
return(BadRequest());
}
Ecole ecole = await _ecoleRepository.GetById(ecoleId);
if (ecole == null)
{
return(NotFound());
}
Professeur professeur = Professeur.From(professeurCreateDto);
professeur.Ecole = ecole;
await _professeurRepository.CreateEntity(professeur);
var res = await _ecoleRepository.SaveAsync();
if (!res)
{
return(BadRequest());
}
return(Created("professeur/me", professeur));
}
public IActionResult Create(int idclasse, int idecole, Eleve model)
{
if (ModelState.IsValid)
{
db.Add(model);
db.SaveChanges();
}
if (ModelState.IsValid)
{
var mod = new Inscription
{
ClasseID = idclasse,
AnneeScolaire = DateTime.Now,
EleveID = model.EleveID
};
db.Add(mod);
db.SaveChanges();
return(RedirectToAction("Detail", "Classe", new { id = idclasse }));
}
Ecole mode = db.Ecoles.Include(c => c.Classes).AsNoTracking().FirstOrDefault(e => e.EcoleID == idecole);
ViewData["cl"] = new SelectList(mode.Classes, "ClasseID", "Nomcomplet");
ViewData["PrefetID"] = db.Ecoles.Find(idecole).PrefetID;
return(View(model));
}
public async Task <IActionResult> CreateEleve([FromBody] long ecoleId, EleveCreateDto eleveCreateDto)
{
if (eleveCreateDto.name == null)
{
return(BadRequest());
}
Ecole ecole = await _ecoleRepository.GetById(ecoleId);
if (ecole == null)
{
return(NotFound());
}
Eleve eleve = eleve.From(eleveCreateDto);
eleve.Ecole = ecole;
await _eleveRepository.CreateEntity(eleve);
var res = await _ecoleRepository.SaveAsync();
if (!res)
{
return(BadRequest());
}
return(Created("professeur/me", eleve));
}
private void btnImprimer_Click(object sender, EventArgs e)
{
List <ListEtudiantPrint> items = new List <ListEtudiantPrint>();
Ecole ecole = ecoleBLO.GetEcole();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
Etudiant et = dataGridView1.Rows[i].DataBoundItem as Etudiant;
items.Add
(
new ListEtudiantPrint
(
et.Matricule,
et.Nom,
et.Prenom,
et.DateNaissance,
et.LieuNaissance,
et.CarteEtudiant,
et.Email,
et.Contact,
ecole?.Identifiant,
ecole?.Nom,
!string.IsNullOrEmpty(ecole?.Logo) ? File.ReadAllBytes(ecole?.Logo) : null
)
);
}
Form f = new FormPreview("ProductListRpt.rdlc", items);
f.Show();
}
public async Task <IActionResult> Edit(int id, [Bind("EcoleID,nom,description,RegleID")] Ecole ecole)
{
if (id != ecole.EcoleID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(ecole);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!EcoleExists(ecole.EcoleID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["RegleID"] = new SelectList(_context.regles, "RegleID", "RegleID", ecole.RegleID);
return(View(ecole));
}
public async Task <IActionResult> UpdateEcole([FromBody] long id, EcoleCreateDto ecoleCreateDto)
{
if (ecoleCreateDto.name == null)
{
return(BadRequest());
}
Ecole ecole = await _ecoleRepository.GetById(id);
if (ecole == null)
{
return(NotFound());
}
ecole.Name = ecoleCreateDto.name;
var res = await _ecoleRepository.SaveAsync();
if (!res)
{
return(BadRequest());
}
return(Ok());
}
public IActionResult Delete(int id)
{
Ecole model = db.Ecoles.Find(id);
db.Ecoles.Remove(model);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IActionResult Update(int id)
{
FillSousDivisions();
Ecole model = db.Ecoles.Find(id);
ViewData["PrefetID"] = new SelectList(db.Prefets, "PrefetID", "Nom");
return(View(model));
}
public JsonResult Delete(int ID)
{
Ecole e = db.ecoles.Find(ID);
db.ecoles.Remove(e);
db.SaveChanges();
return(Json(0, JsonRequestBehavior.AllowGet));
}
public FrmCreateEcole(Ecole ecole, Action callBack) : this(callBack)
{
this.oldEcole = ecole;
txtNomEcole.Text = ecole.NomEcole;
txtContact.Text = ecole.Contact.ToString();
txtBoitePostale.Text = ecole.BoitePostale;
txtEmail.Text = ecole.Email.ToString();
}
public FrmListeEcole(Ecole ecole, Action callback) : this(callback)
{
this.oldEco = ecole;
txtNomEcole.Text = ecole.NomEcole;
txtEmailEcole.Text = ecole.EmailEcole;
txtContactEcole.Text = ecole.ContactEcole.ToString();
pictureBoxLogo.Image = ecole.Logo != null?Image.FromStream(new MemoryStream(ecole.Logo)) : null;
}
public ActionResult DeleteConfirmed(int id)
{
Ecole ecole = db.Ecoles.Find(id);
db.Ecoles.Remove(ecole);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public Ecole GetEcole()
{
Ecole ecole = ecoleRepo.Get();
if (ecole != null)
if (!string.IsNullOrEmpty(ecole.Logo))
ecole.Logo = Path.Combine(dbFolder, "logo", ecole.Logo);
return ecole;
}
public IActionResult Create(int idecole)
{
Ecole model = db.Ecoles.Include(c => c.Classes).AsNoTracking().FirstOrDefault(e => e.EcoleID == idecole);
ViewData["cl"] = new SelectList(model.Classes, "ClasseID", "Nomcomplet");
ViewData["idecole"] = idecole;
ViewData["PrefetID"] = model.PrefetID;
return(View());
}
public FormEditEcole(Ecole ecole, Action callback) : this(callback)
{
this.oldEcole = ecole;
txtIdentifiant.Text = ecole.Identifiant;
txtNom.Text = ecole.Nom;
if (ecole.Logo != null)
{
pictureBox1.Image = Image.FromStream(new MemoryStream(1));
}
}
public ActionResult Edit([Bind(Include = "Id,Nom")] Ecole ecole)
{
if (ModelState.IsValid)
{
db.Entry(ecole).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ecole));
}
public frmCreerEcole(Ecole ecole, Action callBack) : this(callBack)
{
this.oldEcole = ecole;
textBoxIntitule.Text = ecole.Intitule;
textBoxTelephone.Text = ecole.Telephone.ToString();
textBoxEcomail.Text = ecole.Ecomail;
if (ecole.Logo != null)
{
pictureBox2.Image = Image.FromStream(new MemoryStream(ecole.Logo));
}
}
public ActionResult Create([Bind(Include = "Id,Nom")] Ecole ecole)
{
if (ModelState.IsValid)
{
db.Ecoles.Add(ecole);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ecole));
}
public static string ExporterEcole(Ecole E)
{
string variables = "";
variables += "\newcommand{\\graphoEcoleNom}{" + E.EcoleNom + "}\n";
variables += "\newcommand{\\graphoEcoleAdresse}{" + E.EcoleAdresse + "}\n";
variables += "\newcommand{\\graphoEcoleCP}{" + E.EcoleCP + "}\n";
variables += "\newcommand{\\graphoEcoleVille}{" + E.EcoleVille + "}\n";
variables += "\newcommand{\\graphoEcoleTelephone}{" + E.EcoleTelephone + "}\n";
return(variables);
}
public FormEditEcole()
{
InitializeComponent();
ecoleBLO = new EcoleBLO(ConfigurationManager.AppSettings["DbFolder"]);
oldEcole = ecoleBLO.GetEcole();
if (oldEcole != null)
{
txtNom.Text = oldEcole.Nom;
txtIdentifiant.Text = oldEcole.Identifiant;
pictureBox1.ImageLocation = oldEcole.Logo;
}
}
public IActionResult Create(Ecole model)
{
FillSousDivisions();
if (ModelState.IsValid)
{
db.Ecoles.Add(model);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewData["PrefetID"] = new SelectList(db.Prefets, "PrefetID", "Nom", model.PrefetID);
return(View(model));
}
public async Task <IActionResult> Create([Bind("EcoleID,nom,description,RegleID")] Ecole ecole)
{
if (ModelState.IsValid)
{
_context.Add(ecole);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["RegleID"] = new SelectList(_context.regles, "RegleID", "RegleID", ecole.RegleID);
return(View(ecole));
}
public FrmSchoolEdit(Ecole ecole, Action callBack) : this(callBack)
{
this.oldEcole = ecole;
txtName.Text = ecole.Name;
txtPostalCode.Text = ecole.PostalCode;
txtPhone.Text = ecole.PhoneNumber.ToString();
txtEmail.Text = ecole.Email;
if (ecole.Logo != null)
{
pictureBox1.Image = Image.FromStream(new MemoryStream(ecole.Logo));
}
}
public async Task <IActionResult> GetEcole(long id)
{
Ecole ecole = await _ecoleRepository.GetById(id);
if (ecole == null)
{
return(NotFound());
}
var res = _mapper.Map <EcoleResponseDto>(ecole);
return(Ok(res));
}
public FrmCreateEcole()
{
InitializeComponent();
ecoleBLO = new EcoleBLO(ConfigurationManager.AppSettings["DbFolder"]);
oldEcole = ecoleBLO.GetEcole();
if (oldEcole != null)
{
email.Text = oldEcole.email;
NomEcole.Text = oldEcole.NomEcole;
localisation.Text = oldEcole.lieu;
tel.Text = oldEcole.tel.ToString();
BP.Text = oldEcole.BP;
}
}
/// <summary>
/// Ajoute une nouvelle école
/// </summary>
/// <param name="ecole"></param>
public static void nouvelleEcole(Ecole ecole)
{
string nom = ecole.EcoleNom;
string adresse = ecole.EcoleAdresse;
string cp = ecole.EcoleCP;
string ville = ecole.EcoleVille;
string telephone = ecole.EcoleTelephone;
using (IDbConnection connection = new SQLiteConnection(DBAccess.connectionString()))
{
connection.Execute("INSERT INTO ECOLE (EcoleNom, EcoleAdresse, EcoleCP, EcoleVille, EcoleTelephone) VALUES " +
"(@nom, @adresse, @cp, @ville, @telephone)", new { nom, adresse, cp, ville, telephone });
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
checkForm();
Ecole newEcole = new Ecole
(
txtNomEcole.Text.ToUpper(),
txtLocalisation.Text,
txtContact.Text,
txtEmail.Text,
txtBoitePostale.Text,
pictureBox1.ImageLocation
);
ecoleBLO.CreateEcole(oldEcole, newEcole);
MessageBox.Show
(
"Save done !",
"Confirmation",
MessageBoxButtons.OK,
MessageBoxIcon.Information
);
Close();
}
catch (TypingException ex)
{
MessageBox.Show
(
ex.Message,
"Typing error",
MessageBoxButtons.OK,
MessageBoxIcon.Warning
);
}
catch (Exception ex)
{
ex.WriteToFile();
MessageBox.Show
(
"An error occurred! Please try again later.",
"Erreur",
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
}
}
// GET: Ecoles/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Ecole ecole = db.Ecoles.Find(id);
if (ecole == null)
{
return(HttpNotFound());
}
return(View(ecole));
}
