public ActionResult Create([Bind(Include = "TypeQuestionId,NameType")] TypeQuestion typeQuestion)
{
if (ModelState.IsValid)
{
db.TypeQuestion.Add(typeQuestion);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(typeQuestion));
}
public ActionResult Create([Bind(Include = "DifficultyMasterId,DifficultyId,Rate")] DifficultyRate difficultyRate)
{
if (ModelState.IsValid)
{
db.DifficultyRates.Add(difficultyRate);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DifficultyId = new SelectList(db.Difficulties, "DifficultyId", "DifficultyName", difficultyRate.DifficultyId);
ViewBag.DifficultyMasterId = new SelectList(db.Difficulties, "DifficultyId", "DifficultyName", difficultyRate.DifficultyMasterId);
return(View(difficultyRate));
}
public void AddTypeQuestion(TypeQuestion typeQuestion)
{
using (var dbContext = new FilRougeDBContext())
{
dbContext.TypeQuestion.Add(typeQuestion);
dbContext.SaveChanges();
}
}
/// <summary>
/// Methode d'ajout d'une technologie
/// </summary>
/// <param name="technology"></param>
public void AddTechnology(Technology technology)
{
using (var dbContext = new FilRougeDBContext())
{
dbContext.Technologies.Add(technology);
dbContext.SaveChanges();
}
}
/// <summary>
/// Création d'un Quizz
/// </summary>
/// <param name="difficultyid"></param>
/// <param name="technoid"></param>
/// <param name="userid"></param>
/// <param name="nomuser"></param>
/// <param name="prenomuser"></param>
/// <param name="questionlibre"></param>
/// <param name="nombrequestions"></param>
public Quizz CreateQuizz(QuizzViewModel quizzViewModel, int difficultymasterid)
{
Quizz unQuizz = null;
using (FilRougeDBContext db = new FilRougeDBContext())
{
var quizz = quizzViewModel.MapToQuizz();
List <Questions> questionsQuizz = AddQuestionToQuizz(quizz.QuestionLibre, quizz.NombreQuestion, quizz.TechnologyId, difficultymasterid, db);
int timer = quizz.Timer;
try
{
//TODO creer un viewbag des users => authorize create quizz
// verifier paramètres de création d'un quizz
Contact creatingQuizzContact = db.Users.Single(e => e.Id == quizz.ContactId);
Difficulty difficultyQuizz = db.Difficulties.Single(e => e.DifficultyId == difficultymasterid);
Technology technoQuizz = db.Technologies.Single(e => e.TechnoId == quizz.TechnologyId);
unQuizz = new Quizz
{
ContactId = creatingQuizzContact.Id,
DifficultyId = difficultymasterid,
TechnologyId = quizz.TechnologyId,
Timer = quizz.Timer,
PrenomUser = quizz.PrenomUser,
NomUser = quizz.NomUser,
NombreQuestion = quizz.NombreQuestion,
EtatQuizz = quizz.EtatQuizz,
QuestionLibre = quizz.QuestionLibre,
Contact = creatingQuizzContact,
Difficulty = difficultyQuizz,
Questions = questionsQuizz,
Technology = technoQuizz
};
db.Quizz.Add(unQuizz);
db.SaveChanges();
db.Dispose();
}
catch (AlreadyInTheQuestionsList e)
{
Console.WriteLine(e.Message);
db.Dispose();
}
catch (NoQuestionsForYou e)
{
Console.WriteLine(e.Message);
db.Dispose();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
return(unQuizz);
}
/// <summary>
/// Edition d'un type de question
/// </summary>
/// <param name="typeQuestion"></param>
/// <returns></returns>
public TypeQuestion EditTypeQuestion(TypeQuestion typeQuestion)
{
using (var dbContext = new FilRougeDBContext())
{
dbContext.Entry(typeQuestion).State = EntityState.Modified;
dbContext.SaveChanges();
}
return(typeQuestion);
}
/// <summary>
/// Suppression d'un type de question
/// </summary>
/// <param name="id"></param>
public void RemoveTypeQuestion(int id)
{
var typeQuestion = new TypeQuestion();
using (var dbContext = new FilRougeDBContext())
{
typeQuestion = dbContext.TypeQuestion.Find(id);
dbContext.TypeQuestion.Remove(typeQuestion);
dbContext.SaveChanges();
}
}
public int AddReponsesToQuestion(int id, List <Reponses> reponses)
{
using (var db = new FilRougeDBContext())
{
var questionAddReponse = db.Questions.Find(id);
questionAddReponse.Reponses = reponses; // ajout de la liste des réponses à la question
int nbRes = db.SaveChanges();
return(nbRes);
}
}
/// <summary>
/// Suppression d'une technologie par son id
/// </summary>
/// <param name="id"></param>
public void RemoveTechnology(int id)
{
var technologie = new Technology();
using (var dbContext = new FilRougeDBContext())
{
technologie = dbContext.Technologies.Find(id);
dbContext.Technologies.Remove(technologie);
dbContext.SaveChanges();
}
}
public int AddDifficulty(Difficulty difficulty)
{
int id = 0;
using (var dbContext = new FilRougeDBContext())
{
dbContext.Difficulties.Add(difficulty);
dbContext.SaveChanges();
id = difficulty.DifficultyId;
}
return(id);
}
/// <summary>
/// Edition d'une technologie par son "Id"
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Technology EditTechnology(Technology technology)
{
var technolgie = new Technology();
using (var dbContext = new FilRougeDBContext())
{
dbContext.Entry(technology).State = EntityState.Modified;
dbContext.SaveChanges();
}
return(technolgie);
}
public int AddDifficulty(DifficultyMasterViewModel difficultyViewModel)
{
int id = 0;
using (var dbContext = new FilRougeDBContext())
{
var difficulty = difficultyViewModel.MapToDifficultyMaster();
dbContext.Difficulties.Add(difficulty);
dbContext.SaveChanges();
id = difficulty.DifficultyId;
}
return(id);
}
/// <summary>
/// Ajouter une question dans la BDD
/// </summary>
/// <param name="questionsViewModel"></param>
/// <returns></returns>
public int AddQuestion(QuestionViewModel questionsViewModel)
{
var id = 0;
using (var dbContext = new FilRougeDBContext())
{
var question = questionsViewModel.MapToQuestion();
dbContext.Questions.Add(question);
dbContext.SaveChanges();
id = question.QuestionId;
}
return(id);
}
public int EditReponsesToQuestion(int id, List <Reponses> reponses)
{
using (var db = new FilRougeDBContext())
{
var questionEditReponses = db.Questions.Find(id).Reponses.ToList();
for (int i = 0; i < questionEditReponses.Count; i++)
{
questionEditReponses[i].Content = reponses[i].Content;
questionEditReponses[i].TrueReponse = reponses[i].TrueReponse;
}
int nbRes = db.SaveChanges();
return(nbRes);
}
}
public int EditDifficulty(DifficultyMasterViewModel difficultyViewModel)
{
var id = 0;
using (var dbContext = new FilRougeDBContext())
{
var difficulty = dbContext.Difficulties.Find(difficultyViewModel.DiffMasterId);
difficulty.DifficultyId = difficultyViewModel.DiffMasterId;
difficulty.DifficultyName = difficultyViewModel.DiffMasterName;
dbContext.Entry(difficulty).State = EntityState.Modified;
dbContext.SaveChanges();
id = difficulty.DifficultyId;
}
return(id);
}
/// <summary>
///
/// </summary>
/// <param name="difficultyid"></param>
/// <param name="technoid"></param>
/// <param name="userid"></param>
/// <param name="nomuser"></param>
/// <param name="prenomuser"></param>
/// <param name="questionlibre"></param>
/// <param name="nombrequestions"></param>
public static void CreateQuizz(int userid, int difficultymasterid, int technoid, string nomuser, string prenomuser, bool questionlibre, int nombrequestions)
{
List <Question> questionsQuizz = AddQuestionToQuizz(questionlibre, nombrequestions, technoid, difficultymasterid);
int timer = 0;
FilRougeDBContext db = new FilRougeDBContext();
try
{
Contact creatingQuizzContact = db.Contact.Single(e => e.UserId == userid);
DifficultyRate difficultyQuizz = db.DifficultyMaster.Single(e => e.DiffMasterId == difficultymasterid);
Technology technoQuizz = db.Technology.Single(e => e.TechnoId == technoid);
Quizz unQuizz = new Quizz
{
ContactId = userid,
DifficultyMasterId = difficultymasterid,
TechnologyId = technoid,
Timer = timer,
PrenomUser = prenomuser,
NomUser = nomuser,
NombreQuestion = nombrequestions,
EtatQuizz = 0,
QuestionLibre = questionlibre,
Contact = creatingQuizzContact,
DifficultyMaster = difficultyQuizz,
Questions = questionsQuizz,
Technology = technoQuizz
};
db.SaveChanges();
db.Dispose();
}
catch (AlreadyInTheQuestionsList e)
{
Console.WriteLine(e.Message);
db.Dispose();
}
catch (NoQuestionsForYou e)
{
Console.WriteLine(e.Message);
db.Dispose();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
db.Dispose();
}
}
public int EditQuizz(QuizzViewModel quizzViewModel)
{
int id = 0;
using (var db = new FilRougeDBContext())
{
var quizz = db.Quizz.Find(quizzViewModel.QuizzId);
quizz.NomUser = quizzViewModel.NomUser;
quizz.PrenomUser = quizzViewModel.PrenomUser;
db.Entry(quizz).State = EntityState.Modified;
db.SaveChanges();
id = quizz.QuizzId;
}
return(id);
}
/// <summary>
/// Sauvegarde de la Reponse et du commentaire du User dans la BDD
/// </summary>
/// <param name="questionViewModel"></param>
public void SaveUserResponse(List <Reponses> reponses, int quizzId, string commentaire)
{
using (FilRougeDBContext db = new FilRougeDBContext())
{
//Boucle pour les reponses du User
foreach (var reponse in reponses)
{
var uneReponseUser = new UserReponse()
{
QuizzId = quizzId,
ReponseId = reponse.ReponseId,
//TODO Changer pour recuperer la valeur de la reponse
Valeur = reponse.Content.ToString(),
Commentaire = commentaire,
EstRepondu = true
};
db.UserReponse.Add(uneReponseUser);
}
db.SaveChanges();
}
}
/// <summary>
/// Edition d'une question
/// </summary>
/// <param name="questionViewModel"></param>
/// <returns></returns>
public int EditQuestion(QuestionViewModel questionViewModel)
{
var id = 0;
using (var dbContext = new FilRougeDBContext())
{
var question = dbContext.Questions.Find(questionViewModel.QuestionId);
question.Commentaire = questionViewModel.Commentaire;
question.Content = questionViewModel.Content;
question.Active = questionViewModel.Active;
question.DifficultyId = questionViewModel.Difficulty.DifficultyId;
question.QuestionTypeId = questionViewModel.QuestionType.TypeQuestionId;
question.TechnologyId = questionViewModel.Technology.TechnoId;
dbContext.Entry(question).State = EntityState.Modified;
dbContext.SaveChanges();
id = question.QuestionId;
}
return(id);
}
/// <summary>
/// Sauvegarde de la Reponse du User dans la BDD
/// </summary>
/// <param name="questionViewModel"></param>
public void SaveUserResponse(List <Reponses> reponses, int quizzId)
{
using (FilRougeDBContext db = new FilRougeDBContext())
{
//mapping de la question
//var question = questionViewModel.MapToQuestion();
//Boucle pour les reponses du User
foreach (var reponse in reponses)
{
var uneReponseUser = new UserReponse()
{
QuizzId = quizzId,
ReponseId = reponse.ReponseId,
//TODO Changer pour recuperer la valeur de la reponse
Valeur = reponse.Content.ToString()
};
db.UserReponse.Add(uneReponseUser);
}
db.SaveChanges();
}
}
public void AddReponsesParDefaultToQuestion(int id)
{
using (var dbContext = new FilRougeDBContext())
{
var question = dbContext.Questions.FirstOrDefault(q => q.QuestionId == id);
var valeur = "saisieLibre";
if (question.MapToQuestionsViewModel().AnswerType == AnswerTypeEnum.SaisieCode)
{
valeur = "saisieCode";
}
//var listeReponseUnique = new List<Reponses>();
var uneReponse = new Reponses()
{
Content = valeur,
Question = question,
TrueReponse = true
};
question.Reponses.Add(uneReponse);
dbContext.SaveChanges();
}
}