private void btnAtualizar_Click(object sender, EventArgs e) { ClsAlternativa mObjAlternativa = new ClsAlternativa() { Id_Questao = Convert.ToInt32(gridQuestao.CurrentRow.Cells[0].Value) }; mObjAlternativa.Selecionar(); DataSet Ds = new DataSet(); Ds = mObjAlternativa.DSAlternariva; frmQuestao frm = new frmQuestao() { aux = 2 }; frm.lblId_Questao.Text = gridQuestao.CurrentRow.Cells[0].Value.ToString(); frm.txtPergunta.Text = gridQuestao.CurrentRow.Cells[1].Value.ToString(); frm.lblId_Alternativa1.Text = Ds.Tables[0].Rows[0][0].ToString(); frm.txtAlternativa1.Text = Ds.Tables[0].Rows[0]["Ds_Alternativa"].ToString(); frm.chk1.Checked = Convert.ToBoolean(Ds.Tables[0].Rows[0]["St_Verificacao"]); frm.lblId_Alternativa2.Text = Ds.Tables[0].Rows[1][0].ToString(); frm.txtAlternativa2.Text = Ds.Tables[0].Rows[1]["Ds_Alternativa"].ToString(); frm.chk2.Checked = Convert.ToBoolean(Ds.Tables[0].Rows[1]["St_Verificacao"]); frm.lblId_Alternativa3.Text = Ds.Tables[0].Rows[2][0].ToString(); frm.txtAlternativa3.Text = Ds.Tables[0].Rows[2]["Ds_Alternativa"].ToString(); frm.chk3.Checked = Convert.ToBoolean(Ds.Tables[0].Rows[2]["St_Verificacao"]); frm.lblId_Alternativa4.Text = Ds.Tables[0].Rows[3][0].ToString(); frm.txtAlternativa4.Text = Ds.Tables[0].Rows[3]["Ds_Alternativa"].ToString(); frm.chk4.Checked = Convert.ToBoolean(Ds.Tables[0].Rows[3]["St_Verificacao"]); frm.lblId_Alternativa5.Text = Ds.Tables[0].Rows[4][0].ToString(); frm.txtAlternativa5.Text = Ds.Tables[0].Rows[4]["Ds_Alternativa"].ToString(); frm.chk5.Checked = Convert.ToBoolean(Ds.Tables[0].Rows[4]["St_Verificacao"]); frm.txtJustificativa.Text = gridQuestao.CurrentRow.Cells[2].Value.ToString(); frm.ShowDialog(); }
private void btnSalvar_Click(object sender, EventArgs e) { ClsQuestao mObjQuestao = new ClsQuestao() { Id_Questao = Convert.ToInt32(0 + lblId_Questao.Text), Id_Materia = Convert.ToInt32(cbMateria.SelectedValue), Ds_Pergunta = txtPergunta.Text, Ds_Justificativa = txtJustificativa.Text, Id_Prontuario = 1 }; ClsAlternativa mObjAlternativa = new ClsAlternativa(); if (aux == 1) { mObjQuestao.Inserir(); mObjAlternativa.Id_Questao = maxID(); mObjAlternativa.St_Verificacao = Convert.ToInt32(chk1.CheckState); mObjAlternativa.Ds_Alternativa = txtAlternativa1.Text; mObjAlternativa.Inserir(); mObjAlternativa.Id_Questao = maxID(); mObjAlternativa.St_Verificacao = Convert.ToInt32(chk2.CheckState); mObjAlternativa.Ds_Alternativa = txtAlternativa2.Text; mObjAlternativa.Inserir(); mObjAlternativa.Id_Questao = maxID(); mObjAlternativa.St_Verificacao = Convert.ToInt32(chk3.CheckState); mObjAlternativa.Ds_Alternativa = txtAlternativa3.Text; mObjAlternativa.Inserir(); mObjAlternativa.Id_Questao = maxID(); mObjAlternativa.St_Verificacao = Convert.ToInt32(chk4.CheckState); mObjAlternativa.Ds_Alternativa = txtAlternativa4.Text; mObjAlternativa.Inserir(); mObjAlternativa.Id_Questao = maxID(); mObjAlternativa.St_Verificacao = Convert.ToInt32(chk5.CheckState); mObjAlternativa.Ds_Alternativa = txtAlternativa5.Text; mObjAlternativa.Inserir(); MessageBox.Show("Inserido com sucesso!"); this.Close(); } else if (aux == 2) { mObjQuestao.Atualizar(); mObjAlternativa.Id_Questao = Convert.ToInt32(0 + lblId_Questao.Text); mObjAlternativa.Id_Alternativas = Convert.ToInt32(0 + lblId_Alternativa1.Text); mObjAlternativa.St_Verificacao = Convert.ToInt32(chk1.CheckState); mObjAlternativa.Ds_Alternativa = txtAlternativa1.Text; mObjAlternativa.Atualizar(); mObjAlternativa.Id_Questao = Convert.ToInt32(0 + lblId_Questao.Text); mObjAlternativa.Id_Alternativas = Convert.ToInt32(0 + lblId_Alternativa2.Text); mObjAlternativa.St_Verificacao = Convert.ToInt32(chk2.CheckState); mObjAlternativa.Ds_Alternativa = txtAlternativa2.Text; mObjAlternativa.Atualizar(); mObjAlternativa.Id_Questao = Convert.ToInt32(0 + lblId_Questao.Text); mObjAlternativa.Id_Alternativas = Convert.ToInt32(0 + lblId_Alternativa3.Text); mObjAlternativa.St_Verificacao = Convert.ToInt32(chk3.CheckState); mObjAlternativa.Ds_Alternativa = txtAlternativa3.Text; mObjAlternativa.Atualizar(); mObjAlternativa.Id_Questao = Convert.ToInt32(0 + lblId_Questao.Text); mObjAlternativa.Id_Alternativas = Convert.ToInt32(0 + lblId_Alternativa4.Text); mObjAlternativa.St_Verificacao = Convert.ToInt32(chk4.CheckState); mObjAlternativa.Ds_Alternativa = txtAlternativa4.Text; mObjAlternativa.Atualizar(); mObjAlternativa.Id_Questao = Convert.ToInt32(0 + lblId_Questao.Text); mObjAlternativa.Id_Alternativas = Convert.ToInt32(0 + lblId_Alternativa5.Text); mObjAlternativa.St_Verificacao = Convert.ToInt32(chk5.CheckState); mObjAlternativa.Ds_Alternativa = txtAlternativa5.Text; mObjAlternativa.Atualizar(); MessageBox.Show("Atualizado com sucesso!"); this.Close(); } lblId_Questao.Text = string.Empty; }
public void ImprimirProva(int IdProva) { ClsProva mObjProva = new ClsProva { Id_Prova = IdProva }; mObjProva.Selecionar(); var Header = "<body style='font-family: sans-serif;'" + "<div id = 'Header' style = 'padding: 5px;'>" + "<h2> Instituto Federal de São Paulo - Campus Capivari - " + DateTime.Now.ToShortDateString() + "</h2>" + "<h3> Professor - " + mObjProva.Id_Prontuario.ToString() + "</h3>" + "<h3> Prova - " + mObjProva.Nm_Prova + "</h3>" + "<p style = 'font-weight: bold;'> Nome:________________________________________________ Prontuario:___________ Nota:______ </p>" + "</div>" + "<div id='Body' style='border: 1px solid black; margin-top: 10px; padding:10px'>"; mObjProva.ImprimiQuestaoProva(); DataSet Ds = mObjProva.DSProva; ClsQuestao mObjQuestao = new ClsQuestao(); ClsAlternativa mObjAlternativa = new ClsAlternativa(); var Body = ""; int contador = 0; foreach (DataRow Questao in Ds.Tables[0].Rows) { contador++; mObjQuestao.Id_Questao = Convert.ToInt32(Questao[1]); mObjQuestao.Selecionar(); mObjAlternativa.Id_Questao = Convert.ToInt32(Questao[1]); mObjAlternativa.Selecionar(); DataSet DsAlternativa = mObjAlternativa.DSAlternariva; var QuestaoPDF = "<div id='questao' style=''>" + "<div id='Enunciado'>" + contador.ToString() + " - " + mObjQuestao.Ds_Pergunta + " </div>" + "<div id='Respostas' style='margin-top: 5px;'>" + "A - " + DsAlternativa.Tables[0].Rows[0][1].ToString() + " <br>" + "B - " + DsAlternativa.Tables[0].Rows[1][1].ToString() + " <br>" + "C - " + DsAlternativa.Tables[0].Rows[2][1].ToString() + " <br>" + "D - " + DsAlternativa.Tables[0].Rows[3][1].ToString() + " <br>" + "E - " + DsAlternativa.Tables[0].Rows[4][1].ToString() + " <br>" + "</div>" + "</div>" + "<div id='Divider' style='width: auto; height: 5px; border-top:1px dashed black; margin:5px 0 5px 0;'></div>"; Body += QuestaoPDF; } var Footer = "</div>" + "</body>"; var Rendere = new IronPdf.HtmlToPdf(); Rendere.PrintOptions.Title = "Prova [NOME PROVA]"; Rendere.PrintOptions.MarginTop = 10; Rendere.PrintOptions.MarginLeft = 10; Rendere.PrintOptions.MarginRight = 10; Rendere.PrintOptions.MarginBottom = 10; Rendere.PrintOptions.Footer.DrawDividerLine = true; Rendere.PrintOptions.Footer.FontFamily = "Arial"; Rendere.PrintOptions.Footer.FontSize = 10; Rendere.PrintOptions.Footer.LeftText = "{date} {time}"; Rendere.PrintOptions.Footer.RightText = "{page} of {total-pages}"; var PDF = Rendere.RenderHtmlAsPdf(Header + Body + Footer); var OutputPath = "Prova " + mObjProva.Nm_Prova + ".pdf"; PDF.SaveAs(OutputPath); System.Diagnostics.Process.Start(OutputPath); }