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(); }