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