public Test GetTest()
{
var test = new Test();
using (var context = new QuizDBEntities())
{
var tests = context.Tests.ToArray();
var questions = context.Questions.ToArray();
var variants = context.Variants.ToArray();
test = tests
.Select(t => new Test
{
Name = t.name,
Questions = questions
.Where(q => q.testId == t.id)
.Select(q => new Question
{
Id = q.id,
QuestionText = q.question,
Variants = variants
.Where(v => v.questionId == q.id)
.Select(v => new Variant
{
Id = v.id,
VariantText = v.variant
})
.ToList()
})
.ToList()
})
.FirstOrDefault();
}
return(test);
}
public Test GetTest()
{
var test = new Test();
using (var context = new QuizDBEntities())
{
var tests = context.Tests.ToArray();
var questions = context.Questions.ToArray();
var variants = context.Variants.ToArray();
test = tests
.Select(t => new Test
{
Name = t.name,
Questions = questions
.Where(q => q.testId == t.id)
.Select(q => new Question
{
Id = q.id,
QuestionText = q.question,
Variants = variants
.Where(v => v.questionId == q.id)
.Select(v => new Variant
{
Id = v.id,
VariantText = v.variant
})
.ToList()
})
.ToList()
})
.FirstOrDefault();
}
return test;
}
public HttpResponseMessage GetQuestion()
{
using (QuizDBEntities db = new QuizDBEntities())
{
var Qns = db.Questions
.Select(x => new
{
QuestionID = x.QuestionID,
QuestionName = x.QuestionName,
Image = x.Image,
x.Option1,
x.Option2,
x.Option3,
x.Option4,
})
.OrderBy(y => Guid.NewGuid())
.Take(10)
.ToArray();
var updated = Qns.AsEnumerable()
.Select(x => new
{
QuestionID = x.QuestionID,
QuestionName = x.QuestionName,
Image = x.Image,
Options = new string[] { x.Option1, x.Option2, x.Option3, x.Option4 }
}).ToList();
return(this.Request.CreateResponse(HttpStatusCode.OK, updated));
}
}
private void SaveTest()
{
try
{
using (var context = new QuizDBEntities())
{
var questionIdx = context.Questions.ToList().Select(t => t.id).Max() + 1;
var variantIdx = context.Variants.ToList().Select(t => t.id).Max() + 1;
context.Tests.Add(_currentTest);
foreach (var itemQuestion in _testQuestions)
{
var question = new Questions();
question.id = questionIdx++;
question.testId = this._currentTest.id;
question.question = itemQuestion.QuestionText;
//TODO: list variants
foreach (var itemVariant in itemQuestion.Variants)
{
var variant = new Variants();
variant.id = variantIdx++;
variant.variant = itemVariant.VariantText;
variant.imgPath = itemVariant.ImageUri;
variant.variant_type = itemVariant.Type;
variant.questionId = question.id;
if (itemVariant.IsCorrect == true)
{
var answer = new Answers();
answer.questionId = question.id;
answer.variantId = variant.id;
context.Answers.Add(answer);
}
question.Variants.Add(variant);
}
//
context.Questions.Add(question);
}
context.SaveChanges();
}
// Your code...
// Could also be before try if you know the exception occurs in SaveChanges
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
var error = String.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
error += string.Format("\n- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
public void UpdateOutput(Participant model)
{
using (QuizDBEntities db = new QuizDBEntities())
{
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public Participant Insert(Participant model)
{
using (QuizDBEntities db = new QuizDBEntities())
{
db.Participants.Add(model);
db.SaveChanges();
return(model);
}
}
public HttpResponseMessage GetAnswers(int[] Qids)
{
using (QuizDBEntities db = new QuizDBEntities())
{
var result = db.Questions.AsEnumerable().Where(y => Qids.Contains(y.QuestionID))
.OrderBy(x => { return(Array.IndexOf(Qids, x.QuestionID)); })
.Select(z => z.Answer).ToArray();
return(this.Request.CreateResponse(HttpStatusCode.OK, result));
}
}
public TestViewModel()
{
_tests = new ObservableCollection<Tests>();
using (var context = new QuizDBEntities())
{
foreach (var test in context.Tests)
{
_tests.Add(test);
}
}
}
public TestViewModel()
{
_tests = new ObservableCollection <Tests>();
using (var context = new QuizDBEntities())
{
foreach (var test in context.Tests)
{
_tests.Add(test);
}
}
}
public bool SignIn(string login, string password)
{
Users user;
using (var context = new QuizDBEntities())
{
user = context.Users
.FirstOrDefault(c => c.user_login == login && c.user_pass == password);
}
if (user != null)
{
return true;
}
return false;
}
public bool SignIn(string login, string password)
{
Users user;
using (var context = new QuizDBEntities())
{
user = context.Users
.FirstOrDefault(c => c.user_login == login && c.user_pass == password);
}
if (user != null)
{
return(true);
}
return(false);
}
public void AgregarDatosPersonales()
{
Datos_Personales DP = new Datos_Personales();
DP.ID = 1;
DP.Nombre = "XXX";
DP.Apellido = "ZZZ";
DP.Telefono = "12345678";
using (QuizDBEntities context = new QuizDBEntities())
{
// me agrega ala base datos
context.Datos_Personales.Add(DP);
context.SaveChanges();// guarda.
}
}
public void AgregarDirecciones()
{
Direcciones DP = new Direcciones();
DP.ID_Direcciones = 234;
DP.ID = 1;
DP.Pais = "C.R ";
DP.Provincia = " Heredia";
DP.Canton = "Central ";
DP.Distrito = "Ulloa ";
DP.Detalle = "WWWWWWWWWWW";
using (QuizDBEntities context = new QuizDBEntities())
{
// me agrega ala base datos
context.Direcciones.Add(DP);
context.SaveChanges();// guarda.
}
}
private async void btnAddTest_Click(object sender, RoutedEventArgs e)
{
int id;
string name = await this.ShowInputAsync("Name", "Please, enter test name", null);
if(name != null)
{
using (var context = new QuizDBEntities())
{
id = context.Tests.ToList().Select(t => t.id).Max() + 1;
}
Tests test = new Tests();
test.id = id;
test.name = name;
var view = new TestEdit(test);
this.Close();
view.Show();
}
}
private async void btnAddTest_Click(object sender, RoutedEventArgs e)
{
int id;
string name = await this.ShowInputAsync("Name", "Please, enter test name", null);
if (name != null)
{
using (var context = new QuizDBEntities())
{
id = context.Tests.ToList().Select(t => t.id).Max() + 1;
}
Tests test = new Tests();
test.id = id;
test.name = name;
var view = new TestEdit(test);
this.Close();
view.Show();
}
}
public HttpResponseMessage GetAllScores()
{
using (QuizDBEntities db = new QuizDBEntities())
{
var Pt = db.Participants
.Select(x => new { ParticipantID = x.ParticipantID, Name = x.Name, Email = x.Email, Score = x.Score })
.OrderBy(y => Guid.NewGuid())
.Take(10)
.ToArray();
var updated = Pt.AsEnumerable()
.Select(x => new
{
ParticipantID = x.ParticipantID,
Email = x.Email,
Name = x.Name,
Score = x.Score
}).ToList();
return(this.Request.CreateResponse(HttpStatusCode.OK, updated));
}
}
private void SaveTest()
{
try
{
using (var context = new QuizDBEntities())
{
var questionIdx = context.Questions.ToList().Select(t => t.id).Max() + 1;
var variantIdx = context.Variants.ToList().Select(t => t.id).Max() + 1;
context.Tests.Add(_currentTest);
foreach (var itemQuestion in _testQuestions)
{
var question = new Questions();
question.id = questionIdx++;
question.testId = this._currentTest.id;
question.question = itemQuestion.QuestionText;
//TODO: list variants
foreach (var itemVariant in itemQuestion.Variants)
{
var variant = new Variants();
variant.id = variantIdx++;
variant.variant = itemVariant.VariantText;
variant.imgPath = itemVariant.ImageUri;
variant.variant_type = itemVariant.Type;
variant.questionId = question.id;
if (itemVariant.IsCorrect == true)
{
var answer = new Answers();
answer.questionId = question.id;
answer.variantId = variant.id;
context.Answers.Add(answer);
}
question.Variants.Add(variant);
}
//
context.Questions.Add(question);
}
context.SaveChanges();
}
// Your code...
// Could also be before try if you know the exception occurs in SaveChanges
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
var error = String.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
error += string.Format("\n- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
public GenericRepository()
{
_context = new QuizDBEntities();
_dbSet = _context.Set <TEntity>();
}
