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
}
private static void makeExamCoupon(ref W.Document doc, string qrCodeJPG, ref ExamsListRow ls, bool showAnswer, string password)
{
string text = string.Empty;
W.Range aux = null;
aux = doc.Paragraphs.Last.Range;
text = "\n\n\n";
text += Resources.CortaCupon;
// text += "\n\n\n";
aux.Text = text;
aux.set_Style(W.WdBuiltinStyle.wdStyleFooter);
aux.InsertParagraphAfter();
doc.Paragraphs.Add(aux);
aux = doc.Paragraphs.Last.Range;
object lastRange = aux;
aux.InlineShapes.AddPicture(qrCodeJPG, ref roObj, ref roObj, ref lastRange);
aux.InlineShapes.AddPicture(ID_FILE, ref roObj, ref roObj, ref lastRange);
aux.set_Style(W.WdBuiltinStyle.wdStyleTitle);
aux.InsertParagraphAfter();
doc.Paragraphs.Add(aux);
aux = doc.Paragraphs.Last.Range;
int cuadros = ls.GetExamsRows().Count();
text = string.Empty;
text += Resources.ExamenRespuesta;
text += " ";
string ahorcado = string.Empty;
int j = 0;
for (int i = 0; i < cuadros; i++)
{
ahorcado += "__ ";
j++;
if (j == 5)
{
ahorcado += "-";
j = 0;
}
}
text += ahorcado;
text += "\n\n";
text += Resources.ExamenRespuesta;
text += " ";
string ahorcadoNr = string.Empty;
j = 0;
for (int i = 0; i < cuadros; i++)
{
int cuenta = i + 1;
ahorcadoNr += cuenta.ToString();
ahorcadoNr += " ";
if (cuenta < 10)
{
ahorcadoNr += " ";
}
j++;
if (j == 5)
{
ahorcadoNr += "-";
j = 0;
}
}
text += ahorcadoNr;
if (showAnswer)
{
text += "\n\n";
text += Resources.ExamenRespuestaCorrecta;
text += "\t";
text += Rsx.Encryption.AESThenHMAC.SimpleDecryptWithPassword(ls.CLAnswer, password, 0);
text += "\n\n";
text += "Encriptada como:\t";
text += ls.CLAnswer;
text += "\n\n";
text += "Examen modelo:\t";
text += ls.GUID;
// text += "\n\n"; text += "Encriptado como:\t"; text += ;
}
aux.Text = text;
aux.set_Style(W.WdBuiltinStyle.wdStyleFooter); /// ESTA ES LA CLAVE!!!
aux.InsertParagraphAfter();
doc.Paragraphs.Add(aux);
}
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);
}
}
internal void PopulateExamQuestions(ref ExamsListRow r)
{
// DB.TAM.ExamsTableAdapter.FillByEID(dt, r.EID);
//now find the examsTablewith questions and answers for the EXAM (list)
// if (!r.NeedsExams) return;
// string eid = ExasmPath + r.EID.ToString() + ".xml";
this.Preferences.Clear();
this.Preferences.ImportRow(r.PreferencesRow);
this.Class.Clear();
this.Class.ImportRow(r.PreferencesRow.ClassRow);
this.AYear.Clear();
this.AYear.ImportRow(r.PreferencesRow.AYearRow);
Environment.SpecialFolder dir = Environment.SpecialFolder.InternetCache;
string cache = Environment.GetFolderPath(dir) + "\\";
byte[] auxiliar;
auxiliar = r.EData;
ExamsDataTable dt2 = new ExamsDataTable();
Rsx.Dumb.Tables.ReadDTBytes(cache, ref auxiliar, ref dt2);
this.Exams.Clear();
this.Exams.Merge(dt2);
Rsx.Dumb.Dumb.FD(ref dt2);
this.ExamsList.Clear();
this.ExamsList.ImportRow(r);
r = this.ExamsList.First();
// if (r.NeedsExams) return;
this.Questions.Clear();
IEnumerable <ExamsRow> rows = r.GetExamsRows();
foreach (var item in rows)
{
auxiliar = item.QData;
QuestionsDataTable qdt = new QuestionsDataTable();
Rsx.Dumb.Tables.ReadDTBytes(cache, ref auxiliar, ref qdt);
this.Questions.Merge(qdt);
Rsx.Dumb.Dumb.FD(ref qdt);
}
this.Answers.Clear();
// IEnumerable<ExamsRow> rows = r.GetExamsRows();
foreach (var item in rows)
{
auxiliar = item.AData;
AnswersDataTable adt = new AnswersDataTable();
Rsx.Dumb.Tables.ReadDTBytes(cache, ref auxiliar, ref adt);
this.Answers.Merge(adt);
Rsx.Dumb.Dumb.FD(ref adt);
}
this.AcceptChanges();
}
