/// <summary> /// PERHAPS THE MOST IKPORTAN, WHERE QAS ARE GENERATED AND PASSWORDS TOO /// </summary> /// <param name="exams"> </param> /// <param name="pr"> </param> /// <param name="questionAnswer"></param> /// <returns></returns> private static string[] makeQAs(ref IEnumerable <ExamsRow> exams, ref PreferencesRow pr, out IList <string[]> questionAnswer) { bool showPoints = pr.showPoints; double pointFactor = pr.Factor; questionAnswer = new List <string[]>(); int pregunta = 1; int claveCount = 1; string Clave; string questionWeight; string qidString; Clave = string.Empty; questionWeight = string.Empty; qidString = string.Empty; foreach (DataRow row in exams) { string[] qAns = new string[2]; ExamsRow r = (ExamsRow)row; string examen = string.Empty; examen = ExtractQuestionAndWeight(ref questionWeight, ref qidString, ref pregunta, showPoints, pointFactor, ref r); qAns[0] = examen; string[] answers = ExtractAnswersArray(ref r); examen = ExtractAnswers(answers, ref r); qAns[1] = examen; ExtractKey(ref Clave, ref claveCount, answers, ref r); questionAnswer.Add(qAns); } if (qidString[qidString.Length - 1].Equals(SEP)) { qidString = qidString.Substring(0, qidString.Length - 1); //erase last separator } if (questionWeight[questionWeight.Length - 1].Equals(SEP)) { questionWeight = questionWeight.Substring(0, questionWeight.Length - 1); //erase last separator } questionWeight += SEP2.ToString() + pointFactor.ToString(); //KEEP THE FACTOR IN THE STRING!!! if (Clave[Clave.Length - 1].Equals(SEP)) { Clave = Clave.Substring(0, Clave.Length - 1); //erase last separator } ///IMPORTANT CUMJULATIVE INFO return(new string[3] { Clave, questionWeight, qidString }); // LAnswer , LQuestion, }
private static void FindFactor(ref PreferencesRow p, ref ExamsListRow ls) { ExamsRow[] arr = ls.GetExamsRows(); double sumPoint = arr.Sum(o => o.QuestionsRow.Weight); double factor = Convert.ToDouble(p.Points); factor /= (sumPoint); p.Factor = factor; arr = null; }
private static void doOneEncriptExam(ref PreferencesRow p, ref ExamsListRow ls, out IList <string[]> questionAnswer, string password) { IEnumerable <DB.ExamsRow> join = ls.GetExamsRows(); string[] ClaveWQID = null; ClaveWQID = makeQAs(ref join, ref p, out questionAnswer); ls.LQuestion = ClaveWQID[1]; // question weight string string LAnswer = ClaveWQID[0]; //clave verdadera sin encriptar string QIDString = ClaveWQID[2]; //secuencia de preguntas, importante guardar ls.CLAnswer = Rsx.Encryption.AESThenHMAC.SimpleEncryptWithPassword(LAnswer, password, null); //encripta ls.CQIDString = Rsx.Encryption.AESThenHMAC.SimpleEncryptWithPassword(QIDString, password, null); //encripta }
public ExamsListRow AddExam(ref PreferencesRow p) { ExamsListRow ls = ExamsList.NewExamsListRow(); ExamsList.AddExamsListRow(ls); Guid g = Guid.NewGuid(); ls.PID = p.PID; ////MAKES THE DOC FILE ls.GUID = g.ToString().Replace("-", null);//.Split('-')[4]; ls.Time = DateTime.Now; ls.Class = p.Class; return(ls); }
private static void updatePreferenceAndClone(ref PreferencesRow p) { // p.EndEdit(); // p.Class = materiaBox.Text; p.DateTime = DateTime.Now; // p.AYearID = ayearID; p.Year = p.DateTime.Year; DB.TAM.PreferencesTableAdapter.Update(p); PreferencesRow clone = Tables.CloneARow(p.Table, p) as DB.PreferencesRow; p = clone; p.Done = true; DB.TAM.PreferencesTableAdapter.Update(p); }
private void doOneDocExam(ref PreferencesRow p, ref ExamsListRow ls, ref IList <string[]> questionAnswer) { string filepathAux = examsPath + model + ls.GUID; string CryptoGUID = Rsx.Encryption.AESThenHMAC.SimpleEncryptWithPassword(ls.GUID, inter.Password, null); // string jpgQRCodeFile = filepathAux + JPG_EXT; Image img = Tools.CreateQRCode(CryptoGUID, qrSise); img.Save(filepathAux + JPG_EXT); img.Dispose(); // string destFile = filepathAux + WORD_EXT; ///MAKE WORD DOCUMENT /// File.Copy(templateFile, filepathAux + WORD_EXT); string title = p.Title + " (" + p.Class + ")"; bool showAnswer = p.showAnswer; string pass = inter.Password; object doc = Generator.MakeDOC(ref ls, ref questionAnswer, filepathAux, title, showAnswer, pass); inter.Status = Resources.ExamenCreado; bool close = true; bool quit = true; Generator.MakePDF(ref doc, close, quit); Byte[] rtf = IO.ReadFileBytes(filepathAux + PDF_EXT); ls.ExamFile = rtf; //salva una copia del archivo PDF en el servidor SQL DB.TAM.ExamsListTableAdapter.Update(ls); inter.Status = Resources.ExamenCreadoPDF; File.Delete(filepathAux + PDF_EXT); File.Delete(filepathAux + WORD_EXT); File.Delete(filepathAux + JPG_EXT); }
private static IList <ExamsRow> weightThem(ref PreferencesRow p, ref IList <ExamsRow> exams) { exams = exams.OrderBy(o => o.QuestionsRow.Weight).ToList(); int multiplier = 10000; IList <ExamsRow> rows = exams.ToList(); Func <ExamsRow, bool> MID = ex => { ex.MID = (ex.QuestionsRow.Weight * multiplier); ex.MID += rows.IndexOf(ex); return(true); }; exams = exams.Where(MID).ToList(); rows = null; /* * foreach (DB.ExamsRow ex in exams) * { * ex.MID = (ex.QuestionsRow.Weight * multiplier); * ex.MID += exams.IndexOf(ex); * } */ ///FILTER ACCORDING TO PREFERENCES exams = exams.OrderBy(o => o.MID).ToList(); IList <ExamsRow> join = null; join = GetByWeight(ref exams, multiplier, ref p); // else join = exams.ToList(); return(join); }
public void DoExams() { PreferencesRow p = inter.IBS.CurrentPreference; inter.IBS.Working = true; updatePreferenceAndClone(ref p); inter.IBS.Working = false; inter.IBS.LogPref.Position = inter.IBS.LogPref.Find(inter.IdB.Preferences.PIDColumn.ColumnName, p.PID); inter.IBS.Working = true; inter.Status = "Empezando..."; FillClassDataBase(p.Class); // inter.IBS.LogPref.MoveFirst(); //select item to clone Application.DoEvents(); inter.ProgressHandler?.Invoke(p.Models, EventArgs.Empty); int mod = 0; //models for (mod = 0; mod < p.Models; mod++) { inter.IdB.Exams.Clear(); inter.ProgressHandler?.Invoke(0, EventArgs.Empty); ExamsListRow ls = doOneExam(ref p); if (ls == null) { continue; } inter.ProgressHandler?.Invoke(0, EventArgs.Empty); Generator.FindFactor(ref p, ref ls); ////ENCRIPTAMIENTOOOOOOO inter.Status = "Procesando examen..."; IList <string[]> questionAnswer; doOneEncriptExam(ref p, ref ls, out questionAnswer, inter.Password); //SAVE COPY OF TABLE in EXAMLIST Generator.MakeTableBytes(ref ls, examsPath); DB.TAM.ExamsListTableAdapter.Update(inter.IdB.ExamsList); inter.ProgressHandler?.Invoke(0, EventArgs.Empty); inter.Status = Resources.Creando + "el examen " + ls.GUID; doOneDocExam(ref p, ref ls, ref questionAnswer); inter.Status = "Examen generado"; inter.ProgressHandler?.Invoke(0, EventArgs.Empty); } Generator.MakeTableBytes(ref p, examsPath); int count = p.GetExamsListRows().Count(); if (count != 0) { inter.Status = count + " Modelos generados"; } DB.TAM.PreferencesTableAdapter.Update(p); inter.IdB.Exams.Clear(); inter.IBS.Working = false; }
/// <summary> /// MAIN FILE FOR GENERATING AN EXAM /// </summary> /// <param name="p"></param> private ExamsListRow doOneExam(ref PreferencesRow p) { inter.Status = Resources.Creando + inter.IdB.Questions.Count + Resources.PregAleatorias; Func <DB.QuestionsRow, bool> selector = x => { bool?ok = x.TopicsRow?.UseIt; if (ok == null) { ok = false; } return((bool)ok); }; ///RANDOMNIZE RAW QUESTIONS IEnumerable <DB.QuestionsRow> questions = inter.IdB.Questions.Where(selector).ToArray(); //toma todas las preguntas if (questions.Count() == 0) { inter.Status = "No hay preguntas seleccionadas"; return(null); } int times = 3; questions = Tools.RandomnizeStringsTimes(questions, times); IList <ExamsRow> exams = new List <ExamsRow>(); //todas las preguntas randomnizadas seran guardadas primero en esta lista foreach (QuestionsRow q in questions) { ExamsRow er = inter.IdB.Exams.NewExamsRow(); //crea rows pero no los metas en la tabla er.QID = q.QID; //dales el id de la pregunta exams.Add(er); //agregalos a la lista } inter.Status = Resources.Filtrando; IEnumerable <ExamsRow> join = weightThem(ref p, ref exams); //not re-ordered // preguntas seleccionadas y filtradas Application.DoEvents(); inter.Status = Resources.OrderAleatorio; // de las preguntas del examen ya pesadas (filtradaS) join = Tools.RandomnizeStringsTimes(join, times); inter.Status = Resources.Seleccionando + join.Count() + Resources.PregAleatorias; Application.DoEvents(); foreach (ExamsRow ex in join) { inter.IdB.Exams.AddExamsRow(ex); //agregalas a la tabla para salvarlas DB.QuestionsRow q = ex.QuestionsRow; IEnumerable <AnswersRow> answ = q.GetAnswersRows(); ///RANDOMIZE RAW ASWERS answ = Tools.RandomnizeStringsTimes(answ, times); //CREATE EXAM QUESTION CODE! AIDSTRING string code = CreateExamQuestionCode(ref answ); ex.AIDString = code; ExamsRow auxiliar = ex; MakeTableBytes(ref auxiliar, examsPath); } DB.TAM.ExamsTableAdapter.Update(inter.IdB.Exams); Application.DoEvents(); ExamsListRow ls = inter.IdB.AddExam(ref p); // Image img = Tools.CreateQRCode(ls.GUID, qrSizeDB); ls.QRCode = Tools.imageToByteArray(img); DB.TAM.ExamsListTableAdapter.Update(inter.IdB.ExamsList); Application.DoEvents(); //este orden es importante foreach (DB.ExamsRow re in join) { re.EID = ls.EID; //ahora asocia las preguntas a cada examen generado } DB.TAM.ExamsTableAdapter.Update(inter.IdB.Exams); Application.DoEvents(); return(ls); }
public PreferencesRowChangeEvent(PreferencesRow row, global::System.Data.DataRowAction action) { this.eventRow = row; this.eventAction = action; }
public void RemovePreferencesRow(PreferencesRow row) { this.Rows.Remove(row); }
public void AddPreferencesRow(PreferencesRow row) { this.Rows.Add(row); }
private static void MakeTableBytes <T>(ref T l, string examPath) { Type tipo = l.GetType(); byte[] arr2 = null; // string afile = string.Empty; if (tipo.Equals(typeof(ExamsListRow))) { ExamsListRow ls = l as ExamsListRow; IEnumerable <ExamsRow> rows = ls.GetExamsRows(); ExamsDataTable exdt = new ExamsDataTable(); foreach (var item in rows) { exdt.ImportRow(item); } // afile = ExasmPath + ls.EID.ToString(); arr2 = Tables.MakeDTBytes(ref exdt, examPath); ls.EData = arr2; } else if (tipo.Equals(typeof(ExamsRow))) { //SAVE COPY OF TABLE ExamsRow ex = l as ExamsRow; QuestionsRow q = ex.QuestionsRow; // afile = ExasmPath + ex.QID.ToString(); IEnumerable<DB.QuestionsRow> shortQlist = // new List<DB.QuestionsRow>(); ((IList<DB.QuestionsRow>)shortQlist).Add(ex.QuestionsRow); QuestionsDataTable qdt = new QuestionsDataTable(); qdt.ImportRow(q); byte[] qarray = Tables.MakeDTBytes(ref qdt, examPath); ex.QData = qarray; Dumb.FD(ref qdt); AnswersDataTable adt = new AnswersDataTable(); IEnumerable <AnswersRow> answ = q.GetAnswersRows(); foreach (var item in answ) { adt.ImportRow(item); } // afile = ExasmPath + ex.QueToString() + ".xml"; arr2 = Tables.MakeDTBytes(ref adt, examPath); ex.AData = arr2; Dumb.FD(ref adt); } else if (tipo.Equals(typeof(PreferencesRow))) { PreferencesRow p = l as PreferencesRow; //SAVE A COPY OF EXAMS LISTS IEnumerable <DB.ExamsListRow> rows = p.GetExamsListRows(); ExamsListDataTable dt = new ExamsListDataTable(); foreach (var item in rows) { dt.ImportRow(item); } // afile = ExasmPath + p.PID.ToString() + ".xml"; arr2 = Tables.MakeDTBytes(ref dt, examPath); p.ELData = arr2; Dumb.FD(ref dt); } }
/// <summary> /// gets the questions that satisfy a given weight, based on the ExamRow.MID tag /// </summary> /// <param name="count"> how many questions to add from a given weight</param> /// <param name="exams"> a raw list of questions to weight in</param> /// <param name="multiplier">the factor to set MID range to search for</param> /// <param name="weight"> the weight</param> /// <returns>The weighted questions</returns> private static IList <ExamsRow> GetByWeight(ref IList <ExamsRow> exams, int multiplier, ref PreferencesRow p) { int min = 0; int max = 0; int howMany; List <DB.ExamsRow> join = new List <DB.ExamsRow>(); //the array that will contain the weighted questions; for (int x = 1; x <= 5; x++) { min = 0; min = x * multiplier; max = 0; max = (x + 1) * multiplier; howMany = 0; //initialize howMany = (int)p["D" + x]; // questions to add from preferences IEnumerable <DB.ExamsRow> rows = exams.Where(o => o.MID >= min && o.MID <= max).Take(howMany); join.AddRange(rows); } return(join); }