public void SaveChanges()
{
Window fenetre2 = new Inscription();
fenetre2.Show();
fenetre2.DataContext = this;
}
public static List <Inscription> SectionInscription(int id_section, int id_person, String type)
{
var inscriptionList = new List <Inscription>();
var table = GeneralContext.Instance.ExecuteFunction("Inscription(@id_section, @id_person, @type)", id_section, id_person, type);
for (var i = 0; i < table.Rows.Count; i++)
{
var result = Convert.ToBoolean(table.Rows[i][0]);
if (result == true)
{
var iscription = new Inscription(id_section, id_person, type, "Usuario inscrito");
inscriptionList.Add(iscription);
}
else
{
var iscription = new Inscription(id_section, id_person, type, "Operacion fallida, el usuario ya se encuentra inscrito");
inscriptionList.Add(iscription);
}
}
;
return(inscriptionList);
}
/*************************/
public async Task SaveInscriAsync(Inscription item, bool isNewItem = false)
{
var uri = new Uri(string.Format(Config.InscriptionUrl, string.Empty));
try
{
var json = JsonConvert.SerializeObject(item);
var content = new StringContent(json, Encoding.UTF8, "application/json");
HttpResponseMessage response = null;
if (isNewItem)
{
response = await _client.PostAsync(uri, content);
}
else
{
response = await _client.PutAsync(uri, content);
}
if (response.IsSuccessStatusCode)
{
Debug.WriteLine(@"\tInscription successfully saved.");
}
}
catch (Exception ex)
{
Debug.WriteLine(@"\tERROR {0}", ex.Message);
}
}
/// <summary>
/// Retourne la liste de toutes les inscriptions de la table Inscription
/// </summary>
/// <returns>La liste de toutes les inscription; une liste vide sinon</returns>
public List <Inscription> GetAll()
{
List <Inscription> inscriptions = new List <Inscription>();
try {
using (MySqlConnection connection = connexion.getConnection()) {
connection.Open();
using (MySqlCommand command = new MySqlCommand(InscriptionService.GET_ALL_INSCRIPTION_QUERY, connection)) {
command.Prepare();
using (MySqlDataReader reader = command.ExecuteReader()) {
while (reader.Read())
{
Inscription inscriptionModel = new Inscription();
command.Parameters.AddWithValue("idInscription", inscriptionModel.IdInscription);
command.Parameters.AddWithValue("idActivite", inscriptionModel.IdActivite);
command.Parameters.AddWithValue("idMembre", inscriptionModel.IdMembre);
command.Parameters.AddWithValue("dateInscription", inscriptionModel.DateInscription);
command.Parameters.AddWithValue("dateFin", inscriptionModel.DateFin);
inscriptions.Add(inscriptionModel);
}
}
}
}
} catch (MySqlException mysqlException) {
System.Diagnostics.Debug.WriteLine(mysqlException.Message);
}
return(inscriptions);
}
public async Task <bool> UpdateInscription(Inscription inscription)
{
var currentPost = await GetInscription((int)inscription.RegistrationId);
currentPost.LastName = inscription.LastName;
currentPost.ExpeditionCity = inscription.ExpeditionCity;
currentPost.BirthCity = inscription.BirthCity;
currentPost.ExpeditionDepartment = inscription.ExpeditionDepartment;
currentPost.BirthDepartment = inscription.BirthDepartment;
currentPost.Direcction = inscription.Direcction;
currentPost.Email = inscription.Email;
currentPost.CivilStatus = inscription.CivilStatus;
currentPost.ExpeditionDate = inscription.ExpeditionDate;
currentPost.BirthDate = inscription.BirthDate;
currentPost.BloodType = inscription.BloodType;
currentPost.Modality = inscription.Modality;
currentPost.FirstName = inscription.FirstName;
currentPost.CellphoneNumber = inscription.CellphoneNumber;
currentPost.DocumentNumber = inscription.DocumentNumber;
currentPost.TelephoneNumber = inscription.TelephoneNumber;
currentPost.ExpeditionCountry = inscription.ExpeditionCountry;
currentPost.BirthCountry = inscription.BirthCountry;
currentPost.AcademicPeriod = inscription.AcademicPeriod;
currentPost.Program = inscription.Program;
currentPost.Campus = inscription.Campus;
currentPost.Sex = inscription.Sex;
currentPost.ApplicantType = inscription.ApplicantType;
currentPost.DocumentType = inscription.DocumentType;
int rows = await _context.SaveChangesAsync();
return(rows > 0);
}
/// <summary>
/// Fait un Find by Inscription dans la BD sur la table Inscription
/// </summary>
/// <param name="idInscription">l'id de l'inscription que l'on veut read</param>
/// <returns>des Inscriptions; null sinon</returns>
public List <Inscription> FindByActivite(int idInscription)
{
List <Inscription> inscriptions = null;
try {
using (MySqlConnection connection = connexion.getConnection()) {
connection.Open();
using (MySqlCommand command = new MySqlCommand(InscriptionService.FIND_BY_ACTIVITE, connection)) {
command.Prepare();
command.Parameters.AddWithValue("idActivite", idInscription);
using (MySqlDataReader reader = command.ExecuteReader()) {
Inscription inscriptionModel;
if (reader.Read())
{
inscriptions = new List <Inscription>();
do
{
inscriptionModel = new Inscription();
inscriptionModel.IdInscription = reader.GetString("id");
inscriptionModel.IdActivite = reader.GetString("idActivite");
inscriptionModel.IdMembre = reader.GetString("idMembre");
inscriptionModel.DateInscription = reader.GetDateTime("date_debut");
inscriptionModel.DateFin = reader.GetDateTime("date_fin");
inscriptions.Add(inscriptionModel);
} while (reader.Read());
}
}
}
}
} catch (MySqlException mysqlException) {
System.Diagnostics.Debug.WriteLine(mysqlException.Message);
}
return(inscriptions);
}
public ActionResult AddInscription(int idUser, int idCourse)
{
Inscription insc = new Inscription();
insc.UserID = idUser;
insc.CourseID = idCourse;
var user = db.Users.Where(u => u.ID == idUser);
db.Inscriptions.Add(insc);
db.SaveChanges();
/*
* //Definimos la conexión al servidor SMTP que vamos a usar
* //para mandar el mail. Hay que buscar como es en nuestro proveedor.
* SmtpClient clienteSmtp = new SmtpClient("smtp.gmail.com", 587);
* clienteSmtp.Credentials = new NetworkCredential("*****@*****.**", "martinez1234");
* clienteSmtp.EnableSsl = true;
*
* //Generamos el objeto MAIL a enviar
* MailMessage mailParaAdministrador = new MailMessage();
* mailParaAdministrador.From = new MailAddress("*****@*****.**", "inscripción");
* mailParaAdministrador.To.Add("*****@*****.**");
* mailParaAdministrador.Subject = "Nueva inscripción Curso";
* mailParaAdministrador.Body = "Nueva inscripción con exito: " + idCourse;
*
* //mandamos el mail
* clienteSmtp.Send(mailParaAdministrador);
*/
TempData["Message"] = "Gracias por haberse inscripto! Nos contactaremos a la brevedad";
return(RedirectToAction("Details", "User", new { idUser = idUser }));
}
/// <summary>
/// SendMessage接受体：接受来自InscriptionSlotButton，用于是指符文属性面板信息
/// </summary>
/// <param name="insc"></param>
public void OnReciveInscriptionMessage(Inscription insc)
{
inscriptionSettingPanel.SetActive(false);
inscriptionPagePanel.SetActive(false);
inscriptionAttributePanel.SetActive(true);
inscriptionAttributePanel.SendMessage("OnReceiveMessage", insc);
}
public void OnInscriptionCommand(object obj)
{
Inscription ins = new Inscription();
ins.Name = "Inscription";
ins.ShowDialog();
}
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 ActionResult AddUser(string Name, string Email, string NE)
//public ActionResult Inscription(InfoInscription info)
{
InfoInscription info = new InfoInscription();
info.Nom = Name;
info.Email = Email;
info.Education = NE;
var username = GenererUsername(info);
var pwd = GenererPwd(info);
Email email = new Email(info, username, pwd);
bool status = sendMail(email);
if (status)
{
niveauEducationDataClassesDataContext db = new niveauEducationDataClassesDataContext();
Inscription eleve = new Inscription {
nom = Name, email = Email, education = NE
};
db.Inscriptions.InsertOnSubmit(eleve);
db.SubmitChanges();
credential cr = new credential {
username = username, password = pwd, email = Email, firsttime = 1
};
db.credentials.InsertOnSubmit(cr);
db.SubmitChanges();
}
return(View("inscription"));
}
public ActionResult CreateEdit(InscriptionViewModel inscriptionVm)
{
/*
* //on instancie un objetBD à partir du view model récupéré en param
* //si le modelstate est valide
* //on crée une course
* //on redirige à la page index
* //sinon on retourne la view avec le view model de course
*/
Inscription inscription = this._repository.Get(inscriptionVm.Id);
if (ModelState.IsValid)
{
if (inscription == null)
{
inscription = new Inscription();
this._repository.Create(inscription);
}
inscriptionVm.Map(inscription);
inscription.dateInscription = DateTime.Now;
inscription.UtilisateurName = User.Identity.Name;
this._repository.Commit();
return(RedirectToAction(nameof(this.Index)));
}
return(View("CreateEdit", inscriptionVm));
}
protected void payerActivites(object sender, EventArgs e)
{
InscriptionService inscriptionService = new InscriptionService();
MembreService membreService = new MembreService();
string idMembre = (string)HttpContext.Current.Session["userID"];
Membre membre = membreService.Read(idMembre);
DateTime dateDebut = DateTime.Now;
List <Models.Activite> panier = (List <Models.Activite>)Session["panier"];
foreach (Models.Activite activite in panier)
{
DateTime dateFin = dateDebut.AddDays(activite.Duree);
Inscription inscriptionModel = new Inscription();
inscriptionModel.IdActivite = activite.id.ToString();
inscriptionModel.IdMembre = idMembre;
inscriptionModel.DateInscription = dateDebut;
inscriptionModel.DateFin = dateFin;
inscriptionService.Add(inscriptionModel);
}
membre.Adresse = adresseField.Text;
membre.Cart_Credit = noCarteField.Text;
membre.Cart_CVC = cvcField.Text;
membreService.Update(membre);
Session["panier"] = null;
Response.Redirect("Confirmation.aspx");
}
public static void ForgetInscription(Inscription i)
{
if (i == lastInscription)
{
lastInscription = null;
}
}
/*LinkInscription_LinkClicked_1
* Permet d'aler sur la view Inscription*/
private void LinkInscription_LinkClicked_1(object sender, LinkLabelLinkClickedEventArgs e)
{
Inscription inscrire = new Inscription();
inscrire.Hide();
inscrire.Show();
}
/// <summary>
/// Fonction appelée lorsque l'utilisateur clique sur le bouton "Ajouter"
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAjouter_Click(object sender, EventArgs e)
{
User user = (User)Session["user"];
// On vérifie que les entrés de l'utilisateur sont valides
Page.Validate("validerAjoutInscription");
// Si les entrés de l'utilisateur sont valide...
if (Page.IsValid)
{
// On ajoute une nouvelle inscription
Inscription nouvelleInscription = new Inscription();
nouvelleInscription.SetJeu(ddlJeu.SelectedValue);
nouvelleInscription.SetPlancher(int.Parse(ddlPlancher.SelectedValue));
nouvelleInscription.SetHeure(DateTime.Parse(ddlHeure.SelectedValue));
DataBaseHelper.ModifierBD("INSERT INTO Inscriptions (Username, Game, Floor, EventHour) VALUES('" + user.Name + "', '" +
nouvelleInscription.GetJeu() + "', " + nouvelleInscription.GetPlancher() + ",'" +
nouvelleInscription.GetHeure().ToString() + "');", Server);
// On ajoute visuellement à la page l'inscription
cblInscriptions.Items.Add(nouvelleInscription.ToString());
// On ajout l'inscription à la liste des inscriptions
user.inscriptions.Add(nouvelleInscription);
// On rend les inscriptions visibles
pnlEditionInscription.Visible = true;
}
}
/// <summary>
/// Fait un Read dans la BD sur la table Inscription
/// </summary>
/// <param name="idInscription">l'id de l'inscription que l'on veut read</param>
/// <returns>une Inscription; null sinon</returns>
public Inscription Read(int idInscription)
{
Inscription inscriptionModel = null;
try {
using (MySqlConnection connection = connexion.getConnection()) {
connection.Open();
using (MySqlCommand command = new MySqlCommand(InscriptionService.READ_INSCRIPTION_QUERY, connection)) {
command.Prepare();
command.Parameters.AddWithValue("idInscription", idInscription);
using (MySqlDataReader reader = command.ExecuteReader()) {
if (reader.Read())
{
inscriptionModel = new Inscription();
inscriptionModel.IdInscription = reader.GetString("id");
inscriptionModel.IdActivite = reader.GetString("idActivite");
inscriptionModel.IdMembre = reader.GetString("idMembre");
inscriptionModel.DateInscription = reader.GetDateTime("date_debut");
inscriptionModel.DateFin = reader.GetDateTime("date_fin");
}
}
}
}
} catch (MySqlException mysqlException) {
System.Diagnostics.Debug.WriteLine(mysqlException.Message);
}
return(inscriptionModel);
}
public ActionResult DeleteConfirmed(int id)
{
Inscription inscription = db.Incription.Find(id);
db.Incription.Remove(inscription);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public JsonResult Delete(int ID)
{
Inscription i = db.inscriptions.Find(ID);
db.inscriptions.Remove(i);
db.SaveChanges();
return(Json(0, JsonRequestBehavior.AllowGet));
}
/// <summary>
///
/// </summary>
/// <param name="myInscription"></param>
/// <returns></returns>
public bool AddInscription(Inscription myInscription)
{
using (var db = new Ef())
{
db.Inscription.Add(myInscription);
return(db.SaveChanges() > 0);
}
}
public ActionResult DeleteConfirmed(int id)
{
Inscription inscription = db.Inscriptions.Find(id);
inscription.DateDeleted = DateTime.Now;
db.SaveChanges();
return(RedirectToAction("Index"));
}
internal Inscription getInscriptionFromInterface()
{
I = new Inscription();
I.CIN = this.Cin;
I.COMMENTAIRE = txtCommentaire.Text;
I.NIVEAU = cmbNiveau.SelectedItem.ToString();
I.ANNEEUNIVERSITAIRE = cmbAnnee.SelectedItem.ToString();
return(I);
}
public static enrInsciption ToInscriptionBasique(this Inscription Inscription)
{
return(new enrInsciption
{
_num = Inscription.Num,
_idxCoureur = Inscription.IdxCoureur,
_idxCourse = Inscription.IdxCourse
});
}
public ActionResult Desinscription(int id)
{
Inscription inscription = db.Inscriptions.Find(id);
db.Inscriptions.Remove(inscription);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
Inscription inscription = await db.Inscriptions.FindAsync(id);
db.Inscriptions.Remove(inscription);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmedInscription(int id)
{
Inscription inscription = dbI.Inscriptions.Find(id);
dbI.Inscriptions.Remove(inscription);
dbI.SaveChanges();
this.AddNotification("SUPPRESSION EFFECTUER", NotificationType.SUCCESS);
return(RedirectToAction("ListInscription"));
}
public void DeleteInscription(Inscription cmd)
{
if (cmd == null)
{
throw new ArgumentNullException(nameof(cmd));
}
_context.Inscriptions.Remove(cmd);
}
/// <summary>
///
/// </summary>
/// <param name="myInscription"></param>
/// <returns></returns>
public bool UpdateInscription(Inscription myInscription)
{
using (var db = new Ef())
{
db.Inscription.Attach(myInscription);
db.Entry(myInscription).State = EntityState.Modified;
return(db.SaveChanges() > 0);
}
}
public Inscription GetInscriptionById(int id)
{
Inscription inscrip = new Inscription();
inscrip = _context.Inscriptions.FirstOrDefault(i => i.Id == id);
inscrip.Club = _context.Clubs.FirstOrDefault(c => c.Id == inscrip.IdClub);
inscrip.Membre = _context.Personnes.FirstOrDefault(p => p.Id == inscrip.IdMembre);
return(inscrip);
}
private void Click_Inscription(object sender, RoutedEventArgs e)
{
Inscription win2 = new Inscription();
win2.Show();
var myWindow = Window.GetWindow(this);
myWindow.Close();
}
