public personne AjouterPersonne(personne person)
{
// Ajoute la personne à l'ORM EF
model.personnes.Add(person);
// Valide les changement dans la base de données
try
{
if (model.SaveChanges() > 0)
{
return(person);
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
return(null);
}
public List <evennement> TrouverEvennementsUtilisateur(personne personne)
{
var listInscrit = model.inscris.Where(p => p.id_personne.Equals(personne.id)).ToList();
List <evennement> listEvent = new List <evennement>();
foreach (inscri i in listInscrit)
{
listEvent.AddRange(model.evennements.Where(e => e.id.Equals(i.id_evennement)).ToList());
}
return(listEvent);
}
public inscri RechercherInscription(evennement Event, personne person)
{
try
{
var p1 = model.inscris.Where(p => p.id_personne.Equals(person.id)).Where(p => p.id_evennement.Equals(Event.id));
return(p1.FirstOrDefault <inscri>());
}
catch
{
return(null);
}
}
public static ListViewItem AddParticipant(this ListView lv, personne participant)
{
if (participant == null)
{
return(null);
}
ListViewItem lvi = new ListViewItem(new string[] { participant.nom, participant.prenom });
// On stocke l'objet Personne pour le réutiliser plus tard
lvi.Tag = participant;
lv.Items.Add(lvi);
return(lvi);
}
public FormEditEvent(evennement eventClicked, personne personneLogged)
{
InitializeComponent();
this.eventClicked = eventClicked;
this.personLogged = personneLogged;
// On vérifie si nous avons bien un objet Personne
if (eventClicked != null)
{
this.eventClicked = eventClicked;
this.txtId.Text = eventClicked.id.ToString();
this.txtTitle.Text = eventClicked.titre;
this.txtAddress.Text = eventClicked.adresse;
this.txtCity.Text = eventClicked.ville;
this.txtCapacity.Text = eventClicked.capacité_max.ToString();
this.dtDatePickerDate.Value = eventClicked.date;
if (eventClicked.id_createur == personneLogged.id)
{
this.lvParticipant.Visible = true;
this.deleteEvent.Visible = true;
this.txtTitle.Enabled = true;
this.txtAddress.Enabled = true;
this.txtCity.Enabled = true;
this.txtCapacity.Enabled = true;
this.dtDatePickerDate.Enabled = true;
this.btnOK.Enabled = true;
}
}
lvParticipant.Columns.Clear();
lvParticipant.Columns.Add(new ColumnHeader()
{
Name = "name", Text = "Last name", Width = 60
});
lvParticipant.Columns.Add(new ColumnHeader()
{
Name = "Fname", Text = "First Name", Width = 60
});
lvParticipant.Items.Clear();
var participants = manageEvent.FindAllParticipants(eventClicked);
foreach (personne p in participants)
{
lvParticipant.AddParticipant(p);
}
}
private void btnOK_Click(object sender, EventArgs e)
{
string name = txtName.Text;
string Fname = txtFname.Text;
string city = txtCity.Text;
string mail = txtMail.Text;
string password = txtPassword.Text;
personne newPerson = new personne(name, Fname, city, mail, password);
if (newPerson != null)
{
managePerson.AjouterPersonne(newPerson);
MessageBox.Show("The account has been created", "Creating event succeed", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
}
else
{
this.DialogResult = DialogResult.Cancel;
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (txtMail.Text != "" && txtPassword.Text != "")
{
string mailTest = txtMail.Text;
string passwordTest = txtPassword.Text;
personneLogged = GestionP.RechercherPersonne(mailTest, passwordTest);
if (personneLogged != null)
{
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("Bad mail or password", "login failed", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Entrez un mail et un mot de passe valide", "empty field", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void Unregistered(evennement eventclicked, personne personLogged)
{
string i = eventclicked.titre;
string p = personLogged.prenom;
var result = MessageBox.Show("Do u want to unregister to this event?", "Confirmation",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
inscri registration = manageRegistration.RechercherInscription(eventclicked, personLogged);
if (registration != null)
{
// Validation du formulaire : modification dans la listview
var ev = manageRegistration.SupprimerInscription(registration);
lvEvennement2.RemoveEvent(eventclicked);
lvEvennement.UpdateEvent(ev);
}
}
}
private void ModifyEvent(evennement eventclicked, personne personneLogged)
{
FormEditEvent form = new FormEditEvent(eventclicked, personneLogged);
form.ShowDialog();
if (form.DialogResult == DialogResult.OK)
{
// Validation du formulaire : modification dans la listview
if (lvEvennement.UpdateEvent(eventclicked) == null)
{
MessageBox.Show("L'event n'a pas pu être modifié", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (form.DialogResult == DialogResult.Yes)
{
lvEvennement2.AddEvennement(eventclicked);
lvEvennement.UpdateEvent(eventclicked);
/* if (lvEvennement2.AddEvennement(eventclicked) == null && lvEvennement.UpdateEvent(eventclicked) == null);
* {
* MessageBox.Show("Prob to update ur registration", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
*
* }*/
}
else if (form.DialogResult == DialogResult.No)
{
lvEvennement2.RemoveEvent(eventclicked);
lvEvennement.RemoveEvent(eventclicked);
/* if (lvEvennement2.AddEvennement(eventclicked) == null && lvEvennement.UpdateEvent(eventclicked) == null);
* {
* MessageBox.Show("Prob to update ur registration", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
*
* }*/
}
}
public inscri(evennement Event, personne person)
{
}
public AddEvent(personne personLogged)
{
InitializeComponent();
personLoggedGlobal = personLogged;
}
private void Form1_Load(object sender, EventArgs e)
{
if (this.personLogged == null)
{
// Création du formulaire de connexion
Signin login = new Signin();
// Appel du formualire en mode "Modal"
if (login.ShowDialog() == DialogResult.OK && login.personneLogged != null)
{
this.personLogged = login.personneLogged;
Logged.Text = "Bonjour " + this.personLogged.prenom;
}
}
var evennements = gestionEvent.TrouverTousLesEvennements();
lvEvennement.Columns.Clear();
lvEvennement.Columns.Add(new ColumnHeader()
{
Name = "id", Text = "Id", Width = 30
});
lvEvennement.Columns.Add(new ColumnHeader()
{
Name = "title", Text = "Titre", Width = 120
});
lvEvennement.Columns.Add(new ColumnHeader()
{
Name = "capacité_max", Text = "Capacité_max", Width = 60
});
lvEvennement.Columns.Add(new ColumnHeader()
{
Name = "nb_participant", Text = "Nombre participants", Width = 60
});
lvEvennement.Columns.Add(new ColumnHeader()
{
Name = "adresse", Text = "Adresse", Width = 80
});
lvEvennement.Columns.Add(new ColumnHeader()
{
Name = "ville", Text = "Ville", Width = 80
});
lvEvennement.Columns.Add(new ColumnHeader()
{
Name = "date", Text = "Date", Width = 150
});
lvEvennement.Columns.Add(new ColumnHeader()
{
Name = "creator", Text = "Creator", Width = 90
});
lvEvennement.Columns.Add(new ColumnHeader()
{
Name = "status", Text = "Status", Width = 50
});
lvEvennement.Items.Clear();
foreach (evennement evennement in evennements)
{
Console.WriteLine(evennement.capacité_max);
lvEvennement.AddEvennement(evennement);
}
lvEvennement2.Columns.Clear();
lvEvennement2.Columns.Add(new ColumnHeader()
{
Name = "id", Text = "Id", Width = 30
});
lvEvennement2.Columns.Add(new ColumnHeader()
{
Name = "title", Text = "Titre", Width = 120
});
lvEvennement2.Columns.Add(new ColumnHeader()
{
Name = "capacité_max", Text = "Capacité_max", Width = 60
});
lvEvennement2.Columns.Add(new ColumnHeader()
{
Name = "nb_participant", Text = "Nombre participants", Width = 60
});
lvEvennement2.Columns.Add(new ColumnHeader()
{
Name = "adresse", Text = "Adresse", Width = 80
});
lvEvennement2.Columns.Add(new ColumnHeader()
{
Name = "ville", Text = "Ville", Width = 80
});
lvEvennement2.Columns.Add(new ColumnHeader()
{
Name = "date", Text = "Date", Width = 150
});
lvEvennement2.Columns.Add(new ColumnHeader()
{
Name = "creator", Text = "Creator", Width = 90
});
lvEvennement2.Columns.Add(new ColumnHeader()
{
Name = "status", Text = "Status", Width = 50
});
lvEvennement2.Items.Clear();
evennements = gestionEvent.TrouverEvennementsUtilisateur(personLogged);
foreach (evennement evennement in evennements)
{
lvEvennement2.AddEvennement(evennement);
}
}
