public ActionResult WordTranslate(int Id)
{
var words = db.Words.Where(s => s.CategoryID == Id).ToList();
int countWords = words.Count;
int wordid;
Random rand = new Random();
Words[] wordsarrwy = new Words[5];
List <Quastion <Words> > quastions = new List <Quastion <Words> >();
using (MaterialContext dbcontext = new MaterialContext())
{
int countword = db.Words.Count();
wordsarrwy[0] = words[0];
for (int i = 0; i < countWords; i++)
{
for (int j = 1; j < 5; j++)
{
wordid = rand.Next(1, 200);
wordsarrwy[j] = db.Words.FirstOrDefault(w => w.Id == wordid);
}
int word = rand.Next(dbcontext.Words.Count());
quastions.Add(new Quastion <Words>(words[i], wordsarrwy));
}
}
return(View(quastions));
}
public ActionResult GrammerTest(int id)
{
using (MaterialContext db = new MaterialContext())
{
try
{
GrammerText grammer = db.GrammerTexts.FirstOrDefault(u => u.Id == id);
var quiz = db.Quizs.Where(s => s.GrammerId == grammer.Id).FirstOrDefault();
ViewBag.Title = quiz.QuizName;
IQueryable <QuestionModel> questions = db.Questions.Where(q => q.QuizID == quiz.QuizID)
.Select(q => new QuestionModel
{
QuestionID = q.QuestionID,
QuestionText = q.QuestionText,
Choices = q.Choices.Select(c => new ChoiceModel
{
ChoiceID = c.ChoiceID,
ChoiceText = c.ChoiceText
}).ToList()
});
TestTextModel testText = new TestTextModel();
testText.Text = null;
testText.Questions = questions.ToList();
return(View("TestsText", testText));
}
catch (Exception ex)
{
return(View("TestsText"));
}
}
}
public ActionResult TestsText(List <AnswerMV> resultQuiz)
{
using (MaterialContext db = new MaterialContext())
{
int count = 0;
List <AnswerMV> finalResultQuiz = new List <AnswerMV>();
foreach (AnswerMV answser in resultQuiz)
{
AnswerMV result = db.Answers.Where(a => a.QuestionID == answser.QuestionID).Select(a => new AnswerMV
{
QuestionID = a.QuestionID.Value,
AnswerQ = a.AnswerText,
isCorrect = (answser.AnswerQ.ToLower().Equals(a.AnswerText.ToLower()))
}).FirstOrDefault();
finalResultQuiz.Add(result);
if (result.isCorrect)
{
count++;
}
}
SetPXLevel(count);
return(Json(new { result = finalResultQuiz }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// Gather all the textures in the node hierarchy, even the ones behind the generics.
/// </summary>
/// <param name="node">The node to look into.</param>
/// <returns>A collection of MaterialTextureNode.</returns>
private IEnumerable <MaterialTextureNode> GatherTextureValuesWithGenerics(IMaterialNode node)
{
var materialContext = new MaterialContext {
Material = Material, ExploreGenerics = true
};
return(GatherTextures(node, materialContext));
}
//words
#region
public ActionResult AllDictionary()
{
Session["WordQuestions"] = null;
using (MaterialContext db = new MaterialContext())
{
List <CategoryWord> viewModel = db.CategoryWords.ToList();
return(View(viewModel));
}
}
public static bool ChangeGremmer(int Id, string Name, string Text)
{
MaterialContext context = new MaterialContext();
var grammer = context.GrammerTexts.FirstOrDefault(c => c.Id == Id);
grammer.Name = Name;
grammer.Text = Text;
grammer.Date = DateTime.Now;
context.SaveChanges();
return(true);
}
/// <summary>
/// Common gather texture function.
/// </summary>
/// <param name="node">The node to look into.</param>
/// <param name="materialContext">The visitor context.</param>
/// <returns>A collection of MaterialTextureNode.</returns>
private IEnumerable <MaterialTextureNode> GatherTextures(IMaterialNode node, MaterialContext materialContext)
{
var textureValues = new List <MaterialTextureNode>();
node.VisitNodes((context, nodeEntry) =>
{
var textureValue = nodeEntry.Node as MaterialTextureNode;
if (textureValue != null)
{
textureValues.Add(textureValue);
}
}, materialContext);
return(textureValues);
}
public JsonResult ReplyAnswer(string answerId, string questId)
{
int result = 0;
using (MaterialContext dbcon = new MaterialContext())
{
var word = dbcon.Words.FirstOrDefault(s => s.Id == int.Parse(answerId));
if (word.Word == questId)
{
result = 1;
}
}
return(Json(result));
}
public void BaseOperationTest()
{
DbContextOptions <MaterialContext> options = InMemoryDbContextFactory.CreateOptions <MaterialContext>("Material_Base");
using (MaterialContext content = new MaterialContext(options))
{
var obj = content.Materials.SingleOrDefault <Material>(f => f.BomCode == "M1");
Assert.Null(obj);
Material m1 = Material.Builder("M1", "N1", 30);
Material m2 = Material.Builder("M2", "N2", 0);
Material m3 = Material.Builder("M3", "N3", 20);
content.Materials.Add(m1);
content.Materials.Add(m2);
content.Materials.Add(m3);
content.Materials.Add(m3);
var count = content.SaveChanges();
Assert.Equal(3, count);
obj = content.Materials.SingleOrDefault <Material>(f => f.BomCode == "M1");
Assert.NotNull(obj);
Assert.Equal("M1", obj.BomCode);
Assert.Equal("N1", obj.BomName);
Assert.Equal(30, obj.Quantity);
var objs = content.Materials.Where(f => f.Quantity > 0).ToList <Material>();
Assert.Equal(2, objs.Count());
objs = content.Materials.Where(f => f.Quantity / 2 > 10).ToList <Material>();
Assert.Single(objs);
objs = content.Materials.Where(f => f.BomName.Contains("N")).ToList <Material>();
Assert.Equal(3, objs.Count());
objs = content.Materials.Where(f => f.BomName.Contains("T")).ToList <Material>();
Assert.Empty(objs);
objs = content.Materials.Where(f => !f.BomName.Contains("T")).ToList <Material>();
Assert.Equal(3, objs.Count());
m2.BomName = "T2";
content.Materials.Update(m2);
content.SaveChanges();
objs = content.Materials.Where(f => !f.BomName.Contains("T")).ToList <Material>();
Assert.Equal(2, objs.Count());
}
}
private List <Words> LearnWords(string userName)
{
List <Words> words = new List <Words>();
var idwords = SqlQueries.ReadWordDatabase(userName);
using (MaterialContext db = new MaterialContext())
{
foreach (var x in idwords)
{
words.Add(db.Words.FirstOrDefault(s => s.Id == x.Id));
}
}
ViewData["LearnUserWords"] = words;
return(words);
}
public void BeforeTest()
{
var builder = new DbContextOptionsBuilder <MaterialContext>();
builder.EnableSensitiveDataLogging();
builder.UseInMemoryDatabase("testmaterial");
var context = new MaterialContext(builder.Options);
var repository = new MaterialRepository(context);
this.controller = new(
Mock.Of <ILogger <MaterialsController> >(),
repository);
Assert.IsNotNull(this.controller);
}
public ActionResult AddTestForMaterial(string question, string[] choice, int answer)
{
MaterialText materials = Session["TextReading"] as MaterialText;
if (materials != null)
{
using (MaterialContext dbc = new MaterialContext())
{
int testid = dbc.Quizs.Add(new Test.Quiz()
{
QuizName = materials.Name,
MaterilId = materials.Id
}).QuizID;
int questionId = dbc.Questions.Add(new Test.Question()
{
QuestionText = question,
QuizID = testid
}).QuestionID;
for (int i = 0; i < choice.Length; i++)
{
dbc.Choices.Add(new Test.Choice()
{
ChoiceText = choice[i], QuestionID = questionId
});
}
dbc.Answers.Add(new Test.Answer()
{
AnswerText = choice[answer - 1], QuestionID = questionId
});
dbc.SaveChanges();
ViewBag.ResultAddTest = "Вопрос добавлен";
return(View());
}
}
return(View());
}
public ActionResult TestsText(int id)
{
//MaterialText material = (MaterialText)Session["TextReading"];
//if (material != null)
//{
using (MaterialContext db = new MaterialContext())
{
try
{
var material = db.Materialtexts.FirstOrDefault(u => u.Id == id);
var quiz = db.Quizs.Where(s => s.MaterilId == id).FirstOrDefault();
ViewBag.Title = quiz.QuizName;
IQueryable <QuestionModel> questions = db.Questions.Where(q => q.QuizID == quiz.QuizID)
.Select(q => new QuestionModel
{
QuestionID = q.QuestionID,
QuestionText = q.QuestionText,
Choices = q.Choices.Select(c => new ChoiceModel
{
ChoiceID = c.ChoiceID,
ChoiceText = c.ChoiceText
}).ToList()
});
TestTextModel testText = new TestTextModel();
testText.Text = material.Text;
testText.Questions = questions.ToList();
return(View(testText));
}
catch (Exception ex)
{
return(View());
}
}
//}
//return View("Material");
}
public MaterialRepository(MaterialContext context)
{
_context = context;
}
public CategoryRepository(MaterialContext context)
{
_context = context;
}
private void MyCommandExecuted(object sender, ExecutedRoutedEventArgs e)
{
if (Clipboard.ContainsData(DataFormats.Text))
{
try
{
// get all text
string data = Clipboard.GetText();
// split to lines
string[] array = data.Split('\n');
// First line is nomer norma
WorkContext.Work.Number = array[0];
// Second line is Name of process
WorkContext.Work.Name = array[1];
// Third line is measure of process without "Измеритель"
WorkContext.Work.Measure = array[2].Replace("Измеритель", "");
// 4, 5, 6, 7, 8, 9, 10 are useless's lines
List <PriborContext> priborContexts = new List <PriborContext>();
using (var db = new SmetaApplication.DbContexts.SmetaDbAppContext())
{
foreach (var item in db.Pribors)
{
priborContexts.Add(new PriborContext(item));
}
int i = 9;
bool IsMaterial = true;
for (; IsMaterial && i < array.Length; i++)
{
int code;
string[] split = array[i].Split('\t');
// first column is code of pribor, if it isn't pribor, then set IsMaterial = false
//MessageBox.Show(array[i]);
if (int.TryParse(split[0], out code))
{
PriborContext priborContext = priborContexts.Find(x => int.Parse(x.Pribor.Code) == code);
if (priborContext == null)
{
throw new NullReferenceException("Прибор нет: " + split[0] + " : " + split[1]);
}
priborContext.PriborGroup.Count = 1;
WorkContext.PriborContexts.Add(priborContext);
// 2 column is name of pribor
// 3 column is measure of pribor
// begin from 4
if (i == 9)
{
double time;
bool IsBegin = true;
if (double.TryParse(split[3].Replace('.', ','), out time))
{
WorkContext.Work.Time1 = time;
}
else
{
IsBegin = false;
}
if (IsBegin && double.TryParse(split[4].Replace('.', ','), out time))
{
WorkContext.Work.Time2 = time;
}
else
{
IsBegin = false;
}
if (IsBegin && double.TryParse(split[5].Replace('.', ','), out time))
{
WorkContext.Work.Time3 = time;
}
else
{
IsBegin = false;
}
if (IsBegin && double.TryParse(split[6].Replace('.', ','), out time))
{
WorkContext.Work.Time4 = time;
}
else
{
IsBegin = false;
}
if (IsBegin && double.TryParse(split[7].Replace('.', ','), out time))
{
WorkContext.Work.Time5 = time;
}
else
{
IsBegin = false;
}
}
}
else
{
IsMaterial = false;
}
}
List <MaterialContext> materialContexts = new List <MaterialContext>();
foreach (var item in db.Materials)
{
materialContexts.Add(new MaterialContext(item));
}
// Materials
for (; i < array.Length; i++)
{
int code;
string[] split = array[i].Split('\t');
// first column is code of material, if it isn't material, then for does'nt work
//MessageBox.Show(array[i]);
if (int.TryParse(split[0], out code))
{
MaterialContext materialContext = materialContexts.Find(x => int.Parse(x.Material.Code) == code);
WorkContext.MaterailContexts.Add(materialContext);
if (materialContext == null)
{
throw new NullReferenceException("Материал нет: " + split[0] + " : " + split[1]);
}
// 2 column is name of material
// 3 column is measure of material
// begin from 4
double time;
bool IsBegin = true;
//MessageBox.Show(split[3]);
if (double.TryParse(split[3].Replace('.', ','), out time))
{
materialContext.MaterialGroup.Count1 = time;
}
else
{
IsBegin = false;
}
if (IsBegin && double.TryParse(split[4].Replace('.', ','), out time))
{
materialContext.MaterialGroup.Count2 = time;
}
else
{
IsBegin = false;
}
if (IsBegin && double.TryParse(split[5].Replace('.', ','), out time))
{
materialContext.MaterialGroup.Count3 = time;
}
else
{
IsBegin = false;
}
if (IsBegin && double.TryParse(split[6].Replace('.', ','), out time))
{
materialContext.MaterialGroup.Count4 = time;
}
else
{
IsBegin = false;
}
if (IsBegin && double.TryParse(split[7].Replace('.', ','), out time))
{
materialContext.MaterialGroup.Count5 = time;
}
else
{
IsBegin = false;
}
}
}
}
//WorkContext.Work.PriceMaterial = WorkContext.MaterailContexts.Sum(x => x.Material.Price * x.MaterialGroup.Count1);
//WorkContext.Work.PricePribor = WorkContext.PriborContexts.Sum(x => x.Pribor.Price * x.PriborGroup.Count);
}
catch (Exception exc)
{
MessageBox.Show("Ошибка формата: " + exc.ToString());
}
}
else
{
MessageBox.Show("Ошибка формата");
}
}
public MaterialController(MaterialContext context)
{
_context = context;
}
public ProdutoRepositorio(MaterialContext context)
{
_context = context;
}
