public ActionResult Index()
{
var idActividad = HttpContext.Request.Params.Get("idActivity");
var idUnidadResponsable = HttpContext.Request.Params.Get("idUnit");
if (idActividad != null)
{
viewModel.idActivity = int.Parse(idActividad);
viewModel.idUnit = int.Parse(idUnidadResponsable);
viewModel = Survey.Business.Encuesta.ExisteCuestionario(viewModel);
Session["viewModel"] = viewModel;
if (viewModel.status == 0)
{
return(View(viewModel));
}
if (viewModel.status == 1)
{
return(View(viewModel));
}
}
return(View(viewModel));
}
public static string GetPreguntasPDF(Survey.Entidades.Ctl_Surveys viewModelSurvey)
{
Ctl_Survey_Questions pregunta = new Ctl_Survey_Questions();
Survey.Entidades.Ctl_Surveys viewModel = new Ctl_Surveys();
DataSet ds = Survey.Business.Encuesta.SelectPreguntas(viewModelSurvey);
var datos = "<table>";
datos = datos + "<tr><td></td><td>Encuesta: " + viewModelSurvey.name + "</td><td></td></tr>";
datos = datos + "<tr><td>idEncuesta: " + viewModelSurvey.idSurvey + "</td><td></td><td></td></tr>";
datos = datos + "<tr><td>idActividad: " + viewModelSurvey.idActivity + "</td><td></td><td></td></tr>";
datos = datos + "<tr><td>idUnidad: " + viewModelSurvey.idUnit + "</td><td></td><td></td></tr>";
datos = datos + "<tr><td></td><td></td><td></td></tr>";
datos = datos + "<tr><td colspan='3'>_____________________________________________________________________________________</td></tr>";
datos = datos + "<tr><td colspan='3'>Preguntas:</td></tr>";
datos = datos + "</table><br/><br/><br/>";
var renglon = TablaPreguntas(ds);
return(datos + renglon);
}
public ActionResult VistaPreliminar(string GridHtml)
{
try
{
Survey.Entidades.Ctl_Surveys viewModelSurvey = (Survey.Entidades.Ctl_Surveys)Session["viewModel"];
string HTMLContent = GetPreguntasPDF(viewModelSurvey);
//string HTMLContent = "Hello <b>World</b>";
if (HTMLContent.Length > 0)
{
using (MemoryStream stream = new System.IO.MemoryStream())
{
StringReader sr = new StringReader(HTMLContent);
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 100f, 0f);
PdfWriter writer = PdfWriter.GetInstance(pdfDoc, stream);
pdfDoc.Open();
XMLWorkerHelper.GetInstance().ParseXHtml(writer, pdfDoc, sr);
pdfDoc.Close();
return(File(stream.ToArray(), "application/pdf", "Grid.pdf"));
}
}
return(Json(new { Status = "false" }, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(new { Status = "false" }, JsonRequestBehavior.AllowGet));
}
}
// GET: SurveyClosed
public ActionResult Index()
{
var viewModel = new Survey.Entidades.Question();
Survey.Entidades.Ctl_Surveys viewModelSurvey = (Survey.Entidades.Ctl_Surveys)Session["viewModel"];
viewModel.encuesta = viewModelSurvey;
viewModel.preguntas = GetPreguntas(viewModelSurvey);
return(View(viewModel));
}
public List <Ctl_Survey_Questions> GetPreguntas(Survey.Entidades.Ctl_Surveys viewModelSurvey)
{
Ctl_Survey_Questions pregunta = new Ctl_Survey_Questions();
DataSet ds = Survey.Business.Encuesta.SelectPreguntas(viewModelSurvey);
List <Ctl_Survey_Questions> listaPreguntas = new List <Ctl_Survey_Questions>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
var preguntaResponse = new Ctl_Survey_Questions();
preguntaResponse.numericalOrder = int.Parse(ds.Tables[0].Rows[i]["NumericalOrder"].ToString());
preguntaResponse.question = ds.Tables[0].Rows[i]["Question"].ToString();
preguntaResponse.questionType = ds.Tables[0].Rows[i]["questionType"].ToString();
if (int.Parse(ds.Tables[0].Rows[i]["IdQuestionType"].ToString()) == 1 || int.Parse(ds.Tables[0].Rows[i]["IdQuestionType"].ToString()) == 2)
{
preguntaResponse.textLength = int.Parse(ds.Tables[0].Rows[i]["TextLength"].ToString());
}
if (int.Parse(ds.Tables[0].Rows[i]["IdQuestionType"].ToString()) == 6 || int.Parse(ds.Tables[0].Rows[i]["IdQuestionType"].ToString()) == 7)
{
preguntaResponse.textLength = int.Parse(ds.Tables[0].Rows[i]["TextLength"].ToString() == "" ? "0" : ds.Tables[0].Rows[i]["TextLength"].ToString());
}
switch (int.Parse(ds.Tables[0].Rows[i]["IdQuestionType"].ToString()))
{
case 2:
case 3:
case 4:
case 7:
preguntaResponse.optionQuestion = ds.Tables[0].Rows[i]["questionAdditional"].ToString();
break;
default:
preguntaResponse.optionQuestion = "";
break;
}
listaPreguntas.Add(preguntaResponse);
}
return(listaPreguntas);
}
private string GetPreguntasPDF(Survey.Entidades.Ctl_Surveys viewModelSurvey)
{
var campo = "";
Ctl_Survey_Questions pregunta = new Ctl_Survey_Questions();
Survey.Entidades.Ctl_Surveys viewModel = new Ctl_Surveys();
DataSet ds = Survey.Business.Encuesta.SelectPreguntas(viewModelSurvey);
List <Ctl_Survey_Questions> listaPreguntas = new List <Ctl_Survey_Questions>();
var datos = "<table>";
datos = datos + "<tr><td></td><td>Encuesta: " + viewModelSurvey.name + "</td><td></td></tr>";
datos = datos + "<tr><td>idEncuesta: " + viewModelSurvey.idSurvey + "</td><td></td><td></td></tr>";
datos = datos + "<tr><td>idActividad: " + viewModelSurvey.idActivity + "</td><td></td><td></td></tr>";
datos = datos + "<tr><td>idUnidad: " + viewModelSurvey.idUnit + "</td><td></td><td></td></tr>";
datos = datos + "<tr><td></td><td></td><td></td></tr>";
datos = datos + "<tr><td colspan='3'>_____________________________________________________________________________________</td></tr>";
datos = datos + "<tr><td colspan='3'>Preguntas:</td></tr>";
datos = datos + "</table><br/><br/><br/>";
var renglon = "";
if (ds.Tables[0].Rows.Count > 0)
{
renglon = "<table>";
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
var preguntaResponse = new Ctl_Survey_Questions();
preguntaResponse.numericalOrder = int.Parse(ds.Tables[0].Rows[i]["NumericalOrder"].ToString());
preguntaResponse.question = ds.Tables[0].Rows[i]["Question"].ToString();
preguntaResponse.questionType = ds.Tables[0].Rows[i]["questionType"].ToString();
preguntaResponse.idQuestionType = int.Parse(ds.Tables[0].Rows[i]["IdQuestionType"].ToString());
preguntaResponse.id = int.Parse(ds.Tables[0].Rows[i]["Id"].ToString());
if (int.Parse(ds.Tables[0].Rows[i]["IdQuestionType"].ToString()) == 1 || int.Parse(ds.Tables[0].Rows[i]["IdQuestionType"].ToString()) == 2)
{
preguntaResponse.textLength = int.Parse(ds.Tables[0].Rows[i]["TextLength"].ToString());
}
switch (int.Parse(ds.Tables[0].Rows[i]["IdQuestionType"].ToString()))
{
case 2:
case 3:
case 4:
case 7:
preguntaResponse.optionQuestion = ds.Tables[0].Rows[i]["questionAdditional"].ToString();
break;
}
if (preguntaResponse.idQuestionType == 1)
{
renglon = renglon + "<tr><td>" + preguntaResponse.numericalOrder + "</td><td>" + preguntaResponse.question + "</td><td></td></tr>";
renglon = renglon + "<tr><td></td><td colspan='2'>Escriba su respuesta: _______________________________________ </td></tr>";
}
if (ds.Tables[0].Rows[i]["idQuestionType"].ToString() == "2")
{
preguntaResponse.optionQuestion = "|" + preguntaResponse.optionQuestion;
var opcion = preguntaResponse.optionQuestion.Split('|');
var opcionesAnidadas = "";
for (int j = 1; j < opcion.Count() - 1; j++)
{
opcionesAnidadas = opcionesAnidadas + opcion[j] + ": _______________________________________<br/>";
}
renglon = renglon + "<tr><td>" + preguntaResponse.numericalOrder + "</td><td>" + preguntaResponse.question + "</td><td></td></tr>";
renglon = renglon + "<tr><td></td><td colspan='2'>" + opcionesAnidadas + "</td></tr>";
}
if (ds.Tables[0].Rows[i]["idQuestionType"].ToString() == "3")
{
preguntaResponse.optionQuestion = "|" + preguntaResponse.optionQuestion;
var opcion = preguntaResponse.optionQuestion.Split('|');
var opcionesAnidadas = "";
for (int j = 1; j < opcion.Count() - 1; j++)
{
opcionesAnidadas = opcionesAnidadas + "___ " + opcion[j] + "<br/>";
}
renglon = renglon + "<tr><td>" + preguntaResponse.numericalOrder + "</td><td>" + preguntaResponse.question + "</td><td></td></tr>";
renglon = renglon + "<tr><td></td><td colspan='2'>" + "Marque con X la(s) opcion(es) correcta(s): <br/>" + opcionesAnidadas + "</td></tr>";
}
if (ds.Tables[0].Rows[i]["idQuestionType"].ToString() == "4")
{
preguntaResponse.optionQuestion = "|" + preguntaResponse.optionQuestion;
var opcion = preguntaResponse.optionQuestion.Split('|');
var opcionesAnidadas = "";
for (int j = 1; j < opcion.Count() - 1; j++)
{
opcionesAnidadas = opcionesAnidadas + opcion[j] + "<br/>";
}
renglon = renglon + "<tr><td>" + preguntaResponse.numericalOrder + "</td><td>" + preguntaResponse.question + "</td><td></td></tr>";
renglon = renglon + "<tr><td></td><td colspan='2'>" + "Subraye la opción correcta: <br/>" + opcionesAnidadas + "</td></tr>";
}
if (preguntaResponse.idQuestionType == 5)
{
renglon = renglon + "<tr><td>" + preguntaResponse.numericalOrder + "</td><td>" + preguntaResponse.question + "</td><td></td></tr>";
renglon = renglon + "<tr><td></td><td colspan='2'>Escriba el nombre de su archivo: _______________________________________ </td></tr>";
}
if (ds.Tables[0].Rows[i]["idQuestionType"].ToString() == "6")
{
renglon = renglon + "<tr><td>" + preguntaResponse.numericalOrder + "</td><td>" + preguntaResponse.question + "</td><td></td></tr>";
renglon = renglon + "<tr><td></td><td colspan='2'>Escriba su respuesta: _______________________________________ </td></tr>";
}
if (ds.Tables[0].Rows[i]["idQuestionType"].ToString() == "7")
{
preguntaResponse.optionQuestion = "|" + preguntaResponse.optionQuestion;
var opcion = preguntaResponse.optionQuestion.Split('|');
var opcionesAnidadas = "";
for (int j = 1; j < opcion.Count() - 1; j++)
{
opcionesAnidadas = opcionesAnidadas + opcion[j] + ": _______________________________________<br/>";
}
renglon = renglon + "<tr><td>" + preguntaResponse.numericalOrder + "</td><td>" + preguntaResponse.question + "</td><td></td></tr>";
renglon = renglon + "<tr><td></td><td colspan='2'>" + opcionesAnidadas + "</td></tr>";
}
if (ds.Tables[0].Rows[i]["idQuestionType"].ToString() == "8")
{
renglon = renglon + "<tr><td>" + preguntaResponse.numericalOrder + "</td><td>" + preguntaResponse.question + "</td><td></td></tr>";
renglon = renglon + "<tr><td></td><td colspan='2'>Marca tu respuesta con una X: Si___ No___</td></tr>";
}
if (ds.Tables[0].Rows[i]["idQuestionType"].ToString() == "9")
{
renglon = renglon + "<tr><td>" + preguntaResponse.numericalOrder + "</td><td>" + preguntaResponse.question + "</td><td></td></tr>";
renglon = renglon + "<tr><td></td><td colspan='2'>Escriba su respuesta(dd/mm/aaaa): _______________________________________ </td></tr>";
}
if (ds.Tables[0].Rows[i]["idQuestionType"].ToString() == "10")
{
renglon = renglon + "<tr><td>" + preguntaResponse.numericalOrder + "</td><td>" + preguntaResponse.question + "</td><td></td></tr>";
renglon = renglon + "<tr><td></td><td colspan='2'>Escriba su respuesta(hh:mm): _______________________________________ </td></tr>";
}
if (ds.Tables[0].Rows[i]["idQuestionType"].ToString() == "11")
{
renglon = renglon + "<tr><td>" + preguntaResponse.numericalOrder + "</td><td>" + preguntaResponse.question + "</td><td></td></tr>";
renglon = renglon + "<tr><td></td><td colspan='2'>Escriba su respuesta(dd/mm/aaaa hh:mm:ss): _______________________________________ </td></tr>";
}
if (ds.Tables[0].Rows[i]["idQuestionType"].ToString() == "12")
{
renglon = renglon + "<tr><td>" + preguntaResponse.numericalOrder + "</td><td>" + preguntaResponse.question + "</td><td></td></tr>";
renglon = renglon + "<tr><td></td><td colspan='2'>Escriba su respuesta: Latitud _________________ Longitud _________________ </td></tr>";
}
renglon = renglon + "<tr><td>.</td><td colspan='2'> </td></tr>";
listaPreguntas.Add(preguntaResponse);
}
renglon = renglon + "</table>";
}
return(datos + renglon);
}
