public ActionResult Calendrier(long?id)
{
var discipline = db.discipline;
ViewBag.id = 0;
ViewBag.accueil = true;
if (id.HasValue)
{
ViewBag.accueil = false;
discipline d = db.discipline.Find(id);
IQueryable <SportAsso.seance> seances = from seance in db.seance.Include(si => si.lieu).Include(si => si.section)
//where seance.section.discipline_id == id
select seance;
List <string> jours = new List <string>();
jours.Add("Lundi");
jours.Add("Mardi");
jours.Add("Mercredi");
jours.Add("Jeudi");
jours.Add("Vendredi");
jours.Add("Samedi");
jours.Add("Dimanche");
ViewBag.jours = jours;
ViewBag.id = id;
ViewBag.listSeance = seances.ToList <seance>();
}
return(View(discipline.ToList()));
}
public ResponseDiscipline(discipline responsdiscipline)
{
id_discipline = responsdiscipline.id_discipline;
Name_discipline = responsdiscipline.Name_discipline;
id_group = (int)responsdiscipline.id_group;
id_teacher = (int)responsdiscipline.id_teacher;
}
public ActionResult Edit([Bind(Include = "discipline_id,responsable_discipline_id,label,description")] discipline discipline)
{
if (ModelState.IsValid)
{
db.Entry(discipline).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Redirect"));
}
//ViewBag.responsable_discipline_id = new SelectList(db.utilisateur, "utilisateur_id", "login", discipline.responsable_discipline_id);
var responsables = new List <SelectListItem>();
foreach (utilisateur u in db.utilisateur)
{
if (u.type_user == "encadrant")
{
if (u.utilisateur_id == discipline.responsable_discipline_id)
{
responsables.Add(new SelectListItem()
{
Text = u.prenom + " " + u.nom + " " + u.login, Value = "" + u.utilisateur_id, Selected = true
});
}
else
{
responsables.Add(new SelectListItem()
{
Text = u.prenom + " " + u.nom + " " + u.login, Value = "" + u.utilisateur_id, Selected = false
});
}
}
}
ViewBag.responsable_discipline_id = responsables;
return(View(discipline));
}
public void DelDisciplina()
{
if (SelectedDiscipline != null)
{
discipline aux_discipline = new discipline();
aux_discipline.author_dni = SelectedDiscipline.author_dni;
aux_discipline.type = SelectedDiscipline.type;
aux_discipline.id_discipline = SelectedDiscipline.id_discipline;
this.Dialogs.Add(new DisciplinaDialogViewModel
{
Title = "Esborrar Disciplina",
Discipline = aux_discipline,
OkText = "Esborra",
TextEnabled = false,
OnOk = (sender) =>
{
Author.disciplines.Remove(SelectedDiscipline);
FillDisciplines();
sender.Close();
},
OnCancel = (sender) => { sender.Close(); },
OnCloseRequest = (sender) => { sender.Close(); }
});
}
}
public ActionResult Index(int?id)
{
/* if (NeedToSwithByRole())
* {
* return SwitchHomeByModelRole();
* }
*/
var discipline = db.discipline;
ViewData["titreSection"] = "test";
ViewData["descriptionSection"] = "test";
if (id.HasValue == false || id == 0)
{
ViewBag.detail = false;
ViewData["titreSection"] = "Découvrez les plaisirs du sport chez Sports Asso !";
ViewData["descriptionSection"] = "Des dizaines de disciplines exaltantes dispnnibles. Encadré par des proffessionels du sport, venez découvrir les nombreuses activité propossé par nontre association !";
}
else
{
ViewBag.detail = true;
discipline d = discipline.Find(id);
ViewData["titreSection"] = d.discipline_nom;
ViewData["descriptionSection"] = d.description;
}
IQueryable <section> q = from d in db.section where d.discipline_id == id select d;
ViewBag.list = q.ToList <section>();
return(View(discipline.ToList()));
}
public ActionResult Delete(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//participe participe = db.participe.Find(id);
long user_id = GetUserIdByLogin(User.Identity.GetUserName());
var part = from par in db.participe
where par.seance_id == id && par.utilisateur_id == user_id
select par;
participe participe = part.ToList().First();
seance s = db.seance.Find(participe.seance_id);
section sec = db.section.Find(s.section_id);
discipline d = db.discipline.Find(sec.discipline_id);
ViewData["titre"] = "Désinscription à la section " + sec.label + " de la discipline " + d.label;
ViewData["texte"] = "Comfirmez votre désinscription à la séance du " + s.jour_de_la_semaine + " de " + HourFormator("" + s.heure_debut) + " à " + HourFormator("" + s.heure_fin);
if (participe == null)
{
return(HttpNotFound());
}
return(View(participe));
}
public IHttpActionResult Putdiscipline(int id, discipline discipline)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != discipline.id_discipline)
{
return(BadRequest());
}
db.Entry(discipline).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!disciplineExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public static string FindFullTitleById(long section_id)
{
dbSportAssoEntities db = new dbSportAssoEntities();
section s = db.section.Find(section_id);
discipline d = db.discipline.Find(s.discipline_id);
return(d.discipline_nom + " - " + s.section_nom);
}
public specialization(int id = 0, discipline discipline_ = 0, expertise expertise_ = 0, double minWage_ = 0, double maxWage_ = 0)
{
specialization_id = id;
discipline = discipline_;
expertise = expertise_;
minWage = minWage_;
maxWage = maxWage_;
}
public ActionResult Delete(long id)
{
discipline discipline = _db.discipline.Find(id);
_db.discipline.Remove(discipline);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(long id)
{
discipline discipline = db.discipline.Find(id);
db.discipline.Remove(discipline);
db.SaveChanges();
return(RedirectToAction("Redirect"));
}
public IActionResult CreateDiscipline(discipline item)
{
using (var db = new ScheduleDB())
{
db.discipline.Add(item);
db.SaveChanges();
}
return(Redirect("/Discipline"));
}
public ActionResult Edit([Bind(Include = "discipline_id,discipline_nom,encadrant_id,description")] discipline discipline)
{
if (ModelState.IsValid)
{
db.Entry(discipline).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(discipline));
}
public IHttpActionResult Getdiscipline(int id)
{
discipline discipline = db.discipline.Find(id);
if (discipline == null)
{
return(NotFound());
}
return(Ok(discipline));
}
public IHttpActionResult Postdiscipline(discipline discipline)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.discipline.Add(discipline);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = discipline.id_discipline }, discipline));
}
public static string GetSeancesInfo(long id)
{
string res = "";
SportAssoEntities db = new SportAssoEntities();
seance s = db.seance.Find(id);
section sec = db.section.Find(s.section_id);
discipline d = db.discipline.Find(sec.discipline_id);
res = d.label + " - " + sec.label + " : " + s.jour_de_la_semaine + " de " + HourFormator("" + s.heure_debut) + " à " + HourFormator("" + s.heure_fin);
return(res);
}
public IHttpActionResult Deletediscipline(int id)
{
discipline discipline = db.discipline.Find(id);
if (discipline == null)
{
return(NotFound());
}
db.discipline.Remove(discipline);
db.SaveChanges();
return(Ok(discipline));
}
public ActionResult Details(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
discipline discipline = db.discipline.Find(id);
if (discipline == null)
{
return(HttpNotFound());
}
return(View(discipline));
}
public ActionResult Inscription(long id)
{
SportAssoEntities db = new SportAssoEntities();
ViewBag.seance_id = id;
seance s = db.seance.Find(id);
section sec = db.section.Find(s.section_id);
discipline d = db.discipline.Find(sec.discipline_id);
ViewBag.utilisateur_id = GetUserIdByLogin(User.Identity.GetUserName());
ViewBag.a_payer = false;
ViewData["titre"] = "Inscription à la section " + sec.label + " de la discipline " + d.label;
ViewData["texte"] = "Comfirmez votre inscription à la séance du " + s.jour_de_la_semaine + " de " + HourFormator("" + s.heure_debut) + " à " + HourFormator("" + s.heure_fin);
return(View());
}
} //ctor
public Employer(int id = 0, string lastName_ = null, string firstname_ = null, int phone1 = 0, string adresse_ = null, string city_ = null, discipline d = 0, bool isprivate = false) //ctor with parameters
{
companyID = id;
// companyName = companyName_;
lastName = lastName_;
firstName = firstname_;
phone = phone1;
adresse = adresse_;
city = city_;
// creationDate = creation;
discipline = d;
// numberEmployee = employeenum;
isPrivate = isprivate;
}
public ActionResult Create([Bind(Exclude = "discipline_id")] discipline discipline)
{
if (!ModelState.IsValid)
{
return(View());
}
try
{
_db.discipline.Add(discipline);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public void AddDisciplina()
{
discipline aux_discipline = new discipline();
aux_discipline.author_dni = Author.dni;
this.Dialogs.Add(new DisciplinaDialogViewModel
{
Title = "Afegir Disciplina",
Discipline = aux_discipline,
OkText = "Afegeix",
TextEnabled = true,
OnOk = (sender) =>
{
Author.disciplines.Add(aux_discipline);
FillDisciplines();
sender.Close();
},
OnCancel = (sender) => { sender.Close(); },
OnCloseRequest = (sender) => { sender.Close(); }
});
}
public ActionResult Index(long?id)
{
var seance = db.seance.Include(s => s.lieu).Include(s => s.section).Include(s => s.utilisateur);
ViewBag.titre_page = "Liste des Séances";
ViewBag.ajoutLier = "false";
ViewBag.section_id = 0;
if (id.HasValue)
{
seance = from b in db.seance.Include(si => si.lieu).Include(si => si.section).Include(si => si.utilisateur)
where b.section_id == id
select b;
section s = db.section.Find(id);
discipline d = db.discipline.Find(s.discipline_id);
ViewBag.titre_page = "Liste des séances de la section " + s.label + " de la discipline " + d.label;
ViewBag.ajoutLier = "true";
ViewBag.section_id = id;
}
return(View(seance.ToList()));
}
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
discipline discipline = db.discipline.Find(id);
if (discipline == null)
{
return(HttpNotFound());
}
//ViewBag.responsable_discipline_id = new SelectList(db.utilisateur, "utilisateur_id", "login", discipline.responsable_discipline_id);
var responsables = new List <SelectListItem>();
foreach (utilisateur u in db.utilisateur)
{
if (u.type_user == "encadrant")
{
if (u.utilisateur_id == discipline.responsable_discipline_id)
{
responsables.Add(new SelectListItem()
{
Text = u.prenom + " " + u.nom + " " + u.login, Value = "" + u.utilisateur_id, Selected = true
});
}
else
{
responsables.Add(new SelectListItem()
{
Text = u.prenom + " " + u.nom + " " + u.login, Value = "" + u.utilisateur_id, Selected = false
});
}
}
}
ViewBag.responsable_discipline_id = responsables;
return(View(discipline));
}
// Кнопка начала теста
private void qStartTest_Click(object sender, EventArgs e)
{
// Сохранение предмета и тему в объект класса
discipline discipline = new discipline()
{
subject = currentSubject,
theme = currentTheme,
};
// Создание запроса на получение списка вопроса
Request request = new Request()
{
request = "getQuestions",
client = QuestionHelper.client,
// конвертация объекта в тело запроса
body = JsonConvert.SerializeObject(discipline, Formatting.Indented),
};
// Отправка запроса к серверу
new Thread(() => {
Thread.CurrentThread.IsBackground = true;
new SocketHelper().DoRequest(request, (returned) => {
// получение списка вопросов
List <Question> questions = returned as List <Question>;
// Сохранение списка вопросов в управляющий класс
QuestionHelper.Questions = questions;
// и переходим на форму тестирования
TestingForm testingForm = new TestingForm();
try {
this.BeginInvoke((MethodInvoker)(() => this.Hide()));
if (testingForm.ShowDialog() != DialogResult.OK)
{
this.BeginInvoke((MethodInvoker)(() => this.Close()));
}
} catch (InvalidOperationException) {}
});
}).Start();
}
private void delAuthorWithOutProject()
{
author aux_author = SelectedAuthor;
aux_author.dni = SelectedAuthor.dni;
aux_author.name = SelectedAuthor.name;
List <project> aux_projectList = context.projects.Where(x => x.author_dni == aux_author.dni).ToList();
this.Dialogs.Add(new Esborrar_AutorBuitDialogViewModel()
{
Title = "Esborrar Contacte",
Author = aux_author,
OkText = "Esborrar",
TextEnabled = false,
OnOk = (sender) =>
{
try
{
if (aux_author.phones.Count > 0)
{
List <phone> phonesDelList = aux_author.phones.ToList();
foreach (phone item in phonesDelList)
{
phone p = context.phones.Where(x => x.id_phone == item.id_phone).SingleOrDefault();
context.phones.Remove(p);
}
}
if (aux_author.emails.Count > 0)
{
List <email> emailsDelList = aux_author.emails.ToList();
foreach (email item in emailsDelList)
{
email e = context.emails.Where(x => x.id_email == item.id_email).SingleOrDefault();
context.emails.Remove(e);
}
}
if (aux_author.disciplines.Count > 0)
{
List <discipline> disciplinaDelList = aux_author.disciplines.ToList();
foreach (discipline item in disciplinaDelList)
{
discipline d = context.disciplines.Where(x => x.id_discipline == item.id_discipline).SingleOrDefault();
context.disciplines.Remove(d);
}
}
author a = context.authors.Where(x => x.dni == SelectedAuthor.dni).SingleOrDefault();
context.authors.Remove(a);
try
{
context.SaveChanges();
} catch (Exception ex)
{
MessageBox.Show("Error en escriure a la BBDD");
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
FillAuthors(0);
sender.Close();
},
OnCancel = (sender) =>
{
FillAuthors(0);
sender.Close();
},
OnCloseRequest = (sender) =>
{
FillAuthors(0);
sender.Close();
}
});
}
private void delAuthorWithProject()
{
author aux_author = SelectedAuthor;
aux_author.dni = SelectedAuthor.dni;
aux_author.name = SelectedAuthor.name;
List <project> aux_projectList = context.projects.Where(x => x.author_dni == aux_author.dni).ToList();
this.Dialogs.Add(new ProjecteEsborrarDialogModel()
{
Title = "Esborrar Contacte",
Author = aux_author,
ProjectList = aux_projectList,
OkText = "Esborrar",
OnOk = (sender) =>
{
try
{
if (aux_author.projects.Count > 0)
{
List <project> projectsDelList = aux_author.projects.ToList();
foreach (project subitem in projectsDelList)
{
if (subitem.requests.Count > 0)
{
List <request> requestDelList = subitem.requests.ToList();
foreach (request item in requestDelList)
{
request r = context.requests.Where(x => x.id_request == item.id_request).SingleOrDefault();
context.requests.Remove(r);
}
}
if (subitem.files.Count > 0)
{
List <file> fileDelList = subitem.files.ToList();
foreach (file item in fileDelList)
{
file f = context.files.Where(x => x.id_file == item.id_file).SingleOrDefault();
context.files.Remove(f);
}
}
project p = context.projects.Where(x => x.id_project == subitem.id_project).SingleOrDefault();
context.projects.Remove(p);
}
}
if (aux_author.phones.Count > 0)
{
List <phone> phonesDelList = aux_author.phones.ToList();
foreach (phone item in phonesDelList)
{
phone p = context.phones.Where(x => x.id_phone == item.id_phone).SingleOrDefault();
context.phones.Remove(p);
}
}
if (aux_author.emails.Count > 0)
{
List <email> emailsDelList = aux_author.emails.ToList();
foreach (email item in emailsDelList)
{
email e = context.emails.Where(x => x.id_email == item.id_email).SingleOrDefault();
context.emails.Remove(e);
}
}
if (aux_author.disciplines.Count > 0)
{
List <discipline> disciplinaDelList = aux_author.disciplines.ToList();
foreach (discipline item in disciplinaDelList)
{
discipline d = context.disciplines.Where(x => x.id_discipline == item.id_discipline).SingleOrDefault();
context.disciplines.Remove(d);
}
}
author a = context.authors.Where(x => x.dni == SelectedAuthor.dni).SingleOrDefault();
Thread.Sleep(3000);
context.authors.Remove(a);
try
{
context.SaveChanges();
} catch (Exception ex)
{
MessageBox.Show("Error en escriure a la BBDD");
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
FillAuthors(0);
sender.Close();
},
OnCancel = (sender) =>
{
FillAuthors(0);
sender.Close();
},
OnCloseRequest = (sender) =>
{
FillAuthors(0);
sender.Close();
}
});
}
