public IHttpActionResult Putparticipants(string id, participants participants) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != participants.username) { return(BadRequest()); } db.Entry(participants).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!participantsExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult Postparticipants(participants participants) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.participants.Add(participants); try { db.SaveChanges(); } catch (DbUpdateException e) { if (participantsExists(participants.username)) { return(Conflict()); } else { throw e; } } return(CreatedAtRoute("DefaultApi", new { id = participants.username }, participants)); }
public static bool Insert(List <Joueur> joueurs) { List <participants> listEntities = new List <participants>(joueurs.Count()); foreach (Joueur joueur in joueurs) { LamaBD.participants entity = new participants(); entity.matricule = joueur.Matricule; entity.nom = joueur.Nom; entity.prenom = joueur.Prenom; //Trouver une solution pour prendre la date du serveur. entity.dateCreation = DateTime.Now; listEntities.Add(entity); } var task = LamaBD.helper.ParticipantHelper.CreationParticipant(listEntities); task.Wait(); if (task.Result) { return(true); } else { return(false); } }
public IActionResult Leave(int activityid) { int? id = HttpContext.Session.GetInt32("Id"); participants removeguest = _context.participants.Where(x => x.activityid == activityid).Where(x => x.usersid == (int)id).SingleOrDefault(); _context.Remove(removeguest); _context.SaveChanges(); return(RedirectToAction("Dashboard")); }
public IHttpActionResult Getparticipants(string id) { participants participants = db.participants.Find(id); if (participants == null) { return(NotFound()); } return(Ok(participants)); }
public IHttpActionResult Deleteparticipants(string username, int groupid, int purchaseid) { participants participants = db.participants.Find(username, groupid, purchaseid); if (participants == null) { return(NotFound()); } db.participants.Remove(participants); db.SaveChanges(); return(Ok(participants)); }
public IActionResult Leave(int id) { if (HttpContext.Session.GetInt32("userid") == null) { return(RedirectToAction("Index")); } int? temp = HttpContext.Session.GetInt32("userid"); int truetemp = (int)temp; participants toremove = _context.participants.SingleOrDefault(sec => sec.idactivities == id && sec.idusers == truetemp); _context.participants.Remove(toremove); _context.SaveChanges(); return(RedirectToAction("Home")); }
public static BachelorBackEnd.participants ParticipantobjFromViewToDto(ParticipantRegisterViewModel registerobj) { BachelorBackEnd.participants currentParticipants = new participants(); if (registerobj != null) { currentParticipants.firstname = registerobj.Firstname; currentParticipants.email = registerobj.Email; currentParticipants.lastname = registerobj.Lastname; currentParticipants.password = registerobj.Password; currentParticipants.pause = 0; } return(currentParticipants); }
private void button3_Click(object sender, EventArgs e) { //UPDATE PARTICIPANT try { if (MessageBox.Show("Are you sure you want to perform this operation?", "Question", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (db = new DataClasses1DataContext()) { var result = (from p in db.participants where p.id_participants == Decimal.Parse(dataGridView1.SelectedRows[0].Cells[0].Value.ToString()) select p).Take(1); foreach (var p in result) { participants participants = db.participants.Single(cp => cp.id_participants == p.id_participants); participants.name = textBox1.Text; participants.surname = textBox2.Text; participants.email = textBox3.Text; participants.phone = textBox4.Text; participants.id_countries = Int32.Parse((comboBox1.SelectedValue.ToString())); participants.city = textBox5.Text; participants.street = textBox6.Text; participants.postal_code = textBox7.Text; participants.id_education = Int32.Parse((comboBox2.SelectedValue.ToString())); db.SubmitChanges(); } //AKTUALIZACJA DATAGRID LIVE dataGridView1.DataSource = null; dataGridView1.Update(); dataGridView1.Refresh(); dataGridView1.DataSource = db.view_participants; } MessageBox.Show("The data has been modified!"); } } catch (Exception ex) { MessageBox.Show("Error" + ex); } }
public static bool Insert(List <Equipe> equipes, int idTournois) { List <equipes> listEntities = new List <equipes>(equipes.Count()); foreach (Equipe equipe in equipes) { LamaBD.equipes entity = new equipes(); entity.nom = equipe.Nom; entity.estElimine = equipe.EstElimine; entity.dateEnregistrement = DateTime.Now; entity.idTournoi = idTournois; foreach (Joueur joueurModel in equipe.LstJoueurs) { equipesparticipants ep = new equipesparticipants(); participants p = new participants(); p.matricule = joueurModel.Matricule; p.nom = joueurModel.Nom; p.prenom = joueurModel.Prenom; p.dateCreation = DateTime.Now; ep.participants = p; entity.equipesparticipants.Add(ep); } listEntities.Add(entity); } var task = LamaBD.helper.EquipeHelper.CreationEquipe(listEntities); task.Wait(); if (task.Result) { return(true); } else { return(false); } }
public IActionResult Join(int activityid) { int? id = HttpContext.Session.GetInt32("Id"); users user = _context.users.FirstOrDefault(x => x.id == (int)id); List <activity> allactivity = _context.activity.Where(x => x.date > DateTime.Now).Include(x => x.activityparticpants).OrderBy(x => x.date).ToList(); activity current = _context.activity.FirstOrDefault(x => x.id == activityid); foreach (var checking in allactivity) { foreach (var participant in checking.activityparticpants) { if (checking.date == current.date && checking.time == checking.time && checking.timetype == current.timetype) { if (checking.timetype == "Hours") { if ((checking.time.TotalHours + checking.duration) >= (current.time.Hours) && participant.usersid == user.id) { ViewBag.error = "time conflict"; ViewBag.allactivity = allactivity; ViewBag.user = user; return(View("dashboard")); } else if (checking.timetype == "Minutes") { if ((checking.time.TotalMinutes + checking.duration) >= (current.time.TotalMinutes) && participant.usersid == user.id) { ViewBag.error = "time conflicts"; ViewBag.allactivity = allactivity; ViewBag.user = user; return(View("dashboard")); } } } } else if (checking.date == current.date && checking.time == checking.time && participant.usersid == user.id) { ViewBag.error = "date conflicts"; ViewBag.allactivity = allactivity; ViewBag.user = user; return(View("dashboard")); } if (checking.timetype == "Days") { if ((checking.date.DayOfYear + checking.duration) >= (current.date.DayOfYear) && participant.usersid == user.id) { ViewBag.error = "date conflicts"; ViewBag.allactivity = allactivity; ViewBag.user = user; return(View("dashboard")); } } } } participants guest = new participants() { usersid = (int)id, activityid = activityid }; _context.Add(guest); _context.SaveChanges(); return(RedirectToAction("dashboard")); }
public IActionResult Join(int id) { if (HttpContext.Session.GetInt32("userid") == null) { return(RedirectToAction("Index")); } int?temp = HttpContext.Session.GetInt32("userid"); int truetemp = (int)temp; activities activ = _context.activities.SingleOrDefault(a => a.idactivities == id); List <participants> youracts = _context.participants.Where(p => p.idusers == truetemp).Include(p => p.activity).ToList(); foreach (var activity in youracts) { if (activity.activity.durationtype == "minutes") { System.TimeSpan duration = new System.TimeSpan(0, 0, activity.activity.durationint, 0); DateTime actend = activity.activity.date.Add(duration); if (activ.durationtype == "minutes") { System.TimeSpan duration2 = new System.TimeSpan(0, 0, activ.durationint, 0); DateTime thisactend = activ.date.Add(duration2); if (thisactend > activity.activity.date && thisactend < actend) { return(RedirectToAction("Home")); } } else if (activ.durationtype == "hours") { System.TimeSpan duration2 = new System.TimeSpan(0, activ.durationint, 0, 0); DateTime thisactend = activ.date.Add(duration2); if (thisactend > activity.activity.date && thisactend < actend) { return(RedirectToAction("Home")); } } else if (activ.durationtype == "days") { System.TimeSpan duration2 = new System.TimeSpan(activ.durationint, 0, 0, 0); DateTime thisactend = activ.date.Add(duration2); if (thisactend > activity.activity.date && thisactend < actend) { return(RedirectToAction("Home")); } } if (activ.date > activity.activity.date && activ.date < actend) { return(RedirectToAction("Home")); } } else if (activity.activity.durationtype == "hours") { System.TimeSpan duration = new System.TimeSpan(0, activity.activity.durationint, 0, 0); DateTime actend = activity.activity.date.Add(duration); if (activ.durationtype == "minutes") { System.TimeSpan duration2 = new System.TimeSpan(0, 0, activ.durationint, 0); DateTime thisactend = activ.date.Add(duration2); if (thisactend > activity.activity.date && thisactend < actend) { return(RedirectToAction("Home")); } } else if (activ.durationtype == "hours") { System.TimeSpan duration2 = new System.TimeSpan(0, activ.durationint, 0, 0); DateTime thisactend = activ.date.Add(duration2); if (thisactend > activity.activity.date && thisactend < actend) { return(RedirectToAction("Home")); } } else if (activ.durationtype == "days") { System.TimeSpan duration2 = new System.TimeSpan(activ.durationint, 0, 0, 0); DateTime thisactend = activ.date.Add(duration2); if (thisactend > activity.activity.date && thisactend < actend) { return(RedirectToAction("Home")); } } if (activ.date > activity.activity.date && activ.date < actend) { return(RedirectToAction("Home")); } } else if (activity.activity.durationtype == "days") { System.TimeSpan duration = new System.TimeSpan(activity.activity.durationint, 0, 0, 0); DateTime actend = activity.activity.date.Add(duration); if (activ.durationtype == "minutes") { System.TimeSpan duration2 = new System.TimeSpan(0, 0, activ.durationint, 0); DateTime thisactend = activ.date.Add(duration2); if (thisactend > activity.activity.date && thisactend < actend) { return(RedirectToAction("Home")); } } else if (activ.durationtype == "hours") { System.TimeSpan duration2 = new System.TimeSpan(0, activ.durationint, 0, 0); DateTime thisactend = activ.date.Add(duration2); if (thisactend > activity.activity.date && thisactend < actend) { return(RedirectToAction("Home")); } } else if (activ.durationtype == "days") { System.TimeSpan duration2 = new System.TimeSpan(activ.durationint, 0, 0, 0); DateTime thisactend = activ.date.Add(duration2); if (thisactend > activity.activity.date && thisactend < actend) { return(RedirectToAction("Home")); } } if (activ.date > activity.activity.date && activ.date < actend) { return(RedirectToAction("Home")); } } } participants newpart = new participants { idusers = truetemp, idactivities = id }; _context.Add(newpart); _context.SaveChanges(); return(RedirectToAction("Home")); }
public IActionResult Subact(DateTime date, string actname, string durationtype, int durationint, string description) { int? temp = HttpContext.Session.GetInt32("userid"); int truetemp = (int)temp; users ReturnedValue = _context.users.SingleOrDefault(user => user.idusers == truetemp); DateTime now = DateTime.Now; if (date <= now) { return(RedirectToAction("New")); } List <participants> youracts = _context.participants.Where(p => p.idusers == truetemp).Include(p => p.activity).ToList(); foreach (var activity in youracts) { if (activity.activity.durationtype == "minutes") { System.TimeSpan duration = new System.TimeSpan(0, 0, activity.activity.durationint, 0); DateTime actend = activity.activity.date.Add(duration); if (durationtype == "minutes") { System.TimeSpan duration2 = new System.TimeSpan(0, 0, durationint, 0); DateTime thisactend = date.Add(duration2); if (thisactend > activity.activity.date && thisactend < actend) { return(RedirectToAction("New")); } } else if (durationtype == "hours") { System.TimeSpan duration2 = new System.TimeSpan(0, durationint, 0, 0); DateTime thisactend = date.Add(duration2); if (thisactend > activity.activity.date && thisactend < actend) { return(RedirectToAction("New")); } } else if (durationtype == "days") { System.TimeSpan duration2 = new System.TimeSpan(durationint, 0, 0, 0); DateTime thisactend = date.Add(duration2); if (thisactend > activity.activity.date && thisactend < actend) { return(RedirectToAction("New")); } } if (date > activity.activity.date && date < actend) { return(RedirectToAction("New")); } } else if (activity.activity.durationtype == "hours") { System.TimeSpan duration = new System.TimeSpan(0, activity.activity.durationint, 0, 0); DateTime actend = activity.activity.date.Add(duration); if (durationtype == "minutes") { System.TimeSpan duration2 = new System.TimeSpan(0, 0, durationint, 0); DateTime thisactend = date.Add(duration2); if (thisactend > activity.activity.date && thisactend < actend) { return(RedirectToAction("New")); } } else if (durationtype == "hours") { System.TimeSpan duration2 = new System.TimeSpan(0, durationint, 0, 0); DateTime thisactend = date.Add(duration2); if (thisactend > activity.activity.date && thisactend < actend) { return(RedirectToAction("New")); } } else if (durationtype == "days") { System.TimeSpan duration2 = new System.TimeSpan(durationint, 0, 0, 0); DateTime thisactend = date.Add(duration2); if (thisactend > activity.activity.date && thisactend < actend) { return(RedirectToAction("New")); } } if (date > activity.activity.date && date < actend) { return(RedirectToAction("New")); } } else if (activity.activity.durationtype == "days") { System.TimeSpan duration = new System.TimeSpan(activity.activity.durationint, 0, 0, 0); DateTime actend = activity.activity.date.Add(duration); if (durationtype == "minutes") { System.TimeSpan duration2 = new System.TimeSpan(0, 0, durationint, 0); DateTime thisactend = date.Add(duration2); if (thisactend > activity.activity.date && thisactend < actend) { return(RedirectToAction("New")); } } else if (durationtype == "hours") { System.TimeSpan duration2 = new System.TimeSpan(0, durationint, 0, 0); DateTime thisactend = date.Add(duration2); if (thisactend > activity.activity.date && thisactend < actend) { return(RedirectToAction("New")); } } else if (durationtype == "days") { System.TimeSpan duration2 = new System.TimeSpan(durationint, 0, 0, 0); DateTime thisactend = date.Add(duration2); if (thisactend > activity.activity.date && thisactend < actend) { return(RedirectToAction("New")); } } if (date > activity.activity.date && date < actend) { return(RedirectToAction("New")); } } } activities newact = new activities { actname = actname, date = date, durationint = durationint, durationtype = durationtype, coordname = ReturnedValue.first_name, coordid = truetemp, description = description }; _context.Add(newact); _context.SaveChanges(); int check = newact.idactivities; participants newpart = new participants { idusers = truetemp, idactivities = check }; _context.Add(newpart); _context.SaveChanges(); return(RedirectToAction("Activityview", new { id = check })); }
private void btn_insertPartcipants_Click(object sender, EventArgs e) { try { Regex emailRegex = new Regex(@"\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"); Regex phoneRegex = new Regex(@"^[0-9]{9}$"); Regex postalcodeRegex = new Regex(@"^[0-9]{5}$"); //obsługa formularza if ((emailRegex.IsMatch(textBox3.Text)) && (phoneRegex.IsMatch(textBox4.Text)) && (postalcodeRegex.IsMatch(textBox7.Text)) && textBox1.Text.Length != 0 && textBox2.Text.Length != 0 && textBox5.Text.Length != 0 && textBox6.Text.Length != 0) { if (MessageBox.Show("Are you sure you want to perform this operation?", "Question", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (db = new DataClasses1DataContext()) { var free = (from f in db.view_participants_trainings where f.id_trainings == Decimal.Parse(comboBox4.SelectedValue.ToString()) select f.count_free).Single(); if (free > 0) { participants p = new participants(); p.name = textBox1.Text; p.surname = textBox2.Text; p.email = textBox3.Text; p.phone = textBox4.Text; p.id_countries = Int32.Parse((comboBox1.SelectedValue.ToString())); p.city = textBox5.Text; p.street = textBox6.Text; p.postal_code = textBox7.Text; p.id_education = Int32.Parse((comboBox2.SelectedValue.ToString())); p.id_offers = Int32.Parse((comboBox3.SelectedValue.ToString())); db.participants.InsertOnSubmit(p); db.SubmitChanges(); var last_participants_id = db.participants.ToArray().LastOrDefault().id_participants; participants_trainings pt = new participants_trainings(); pt.id_participants = Int32.Parse((last_participants_id.ToString())); pt.id_trainings = Int32.Parse((comboBox4.SelectedValue.ToString())); db.participants_trainings.InsertOnSubmit(pt); db.SubmitChanges(); MessageBox.Show("New training added!"); } else { MessageBox.Show("There are no places for training!"); } } } } else { MessageBox.Show("Wrongly completed form. Please correct errors!"); } } catch (FormatException ex) { MessageBox.Show(ex.ToString()); } }