/*
* public ActionResult ExportRap()
* {
*
* ReportDocument rd = new ReportDocument();
* rd.Load(Path.Combine(Server.MapPath("~/Raport/zak.rpt")));
*
* Response.Buffer = false;
* Response.ClearContent();
* Response.ClearHeaders();
* try
* {
* Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
* stream.Seek(0, SeekOrigin.Begin);
* return File(stream, "application/pdf", "AuditRapport.pdf");
* }
* catch
* {
* throw;
* }
* }
*
*/
public ActionResult Report()
{
List <Question> x = (from c in qstDB.Questions where c.reponse == 0 select c).ToList();
QuestionReport qstReport = new QuestionReport();
byte[] abytes = qstReport.PrepareReport(x);
return(File(abytes, "application/pdf"));
}
private QuestionReport PrepareQuestionReport(Guid userId, Guid questionId)
{
var questionReport = new QuestionReport
{
UserId = userId,
QuestionId = questionId
};
return(questionReport);
}
public void AddQuestionRecord(string question, string choice, QuestionChoiceCorrectness choiceCorrect)
{
Init();
Color32 color = _choicesColors[choiceCorrect];
GameObject questionObject = _questionsPool.GetInstance();
questionObject.transform.SetAsFirstSibling();
QuestionReport qr = questionObject.GetComponent <QuestionReport>();
qr.UpdateIndicatorColor(color);
qr.UpdateQuestionChoice(question, choice);
UpdateQuestionsStatistic(choiceCorrect);
}
public MessageReport Create(QuestionReport obj)
{
var rp = new MessageReport();
try
{
_IQuestionReportRepository.Add(obj);
rp.Success = true;
rp.Message = "Phản hồi thành công!";
}catch (Exception ex)
{
rp.Message = ex.Message;
}
return(rp);
}
public MessageReport Update(string _id, QuestionReport obj)
{
var rp = new MessageReport();
try
{
var query = Builders <QuestionReport> .Filter.Eq(x => x._id, _id);
var update = Builders <QuestionReport> .Update.Set(x => x.Question_id, obj.Question_id)
.Set(x => x.Account_id, obj.Account_id)
.Set(x => x.Content, obj.Content)
.Set(x => x.CreatedDate, obj.CreatedDate);
_IQuestionReportRepository.Update(query, update);
rp.Success = true;
rp.Message = "Cập nhật thành công!";
}catch (Exception ex)
{
rp.Message = ex.Message;
}
return(rp);
}
public async Task <int> CreateAsync(int surveyId, string surveyTitle, string surveyDescription)
{
var surveyReport = new SurveyReport(surveyId, surveyTitle, surveyDescription);
await _surveyReportRepository.AddAsync(surveyReport);
var survey = await _surveyRepository.GetByIdWithQuestionsAsync(surveyId);
foreach (var question in survey.Questions)
{
var questionReport =
new QuestionReport(question.Content, question.Select, 0, question.QuestionPosition);
surveyReport.AddQuestionReport(questionReport);
await _questionReportRepository.AddAsync(questionReport);
foreach (var fieldData in question.FieldData)
{
switch (questionReport.Select)
{
case "short-answer":
case "long-answer":
{
var dataSet = new DataSet();
questionReport.AddDataSet(dataSet);
await _dataSetRepository.AddAsync(dataSet);
await _questionReportRepository.UpdateAsync(questionReport);
foreach (var label in questionReport.Labels)
{
dataSet.AddData("0");
await _dataSetRepository.UpdateAsync(dataSet);
}
}
break;
case "dropdown-menu":
{
foreach (var choiceOption in fieldData.ChoiceOptions)
{
questionReport.AddLabel(choiceOption.ViewValue);
}
var dataSet = new DataSet();
questionReport.AddDataSet(dataSet);
await _dataSetRepository.AddAsync(dataSet);
await _questionReportRepository.UpdateAsync(questionReport);
foreach (var label in questionReport.Labels)
{
dataSet.AddData("0");
await _dataSetRepository.UpdateAsync(dataSet);
}
}
break;
case "linear-scale":
{
for (var i = 1; i <= fieldData.MaxValue; i++)
{
questionReport.AddLabel(i.ToString());
}
var dataSet = new DataSet(question.Content);
questionReport.AddDataSet(dataSet);
await _dataSetRepository.AddAsync(dataSet);
await _questionReportRepository.UpdateAsync(questionReport);
foreach (var label in questionReport.Labels)
{
dataSet.AddData("0");
await _dataSetRepository.UpdateAsync(dataSet);
}
}
break;
case "multiple-grid":
case "single-grid":
{
foreach (var row in fieldData.Rows)
{
questionReport.AddLabel(row.Input);
}
foreach (var choiceOption in fieldData.ChoiceOptions)
{
var dataSet = new DataSet(choiceOption.ViewValue);
questionReport.AddDataSet(dataSet);
await _dataSetRepository.AddAsync(dataSet);
await _questionReportRepository.UpdateAsync(questionReport);
foreach (var row in fieldData.Rows)
{
dataSet.AddData("0");
await _dataSetRepository.UpdateAsync(dataSet);
}
}
}
break;
case "single-choice":
case "multiple-choice":
{
foreach (var choiceOption in fieldData.ChoiceOptions)
{
questionReport.AddLabel(choiceOption.ViewValue);
}
var dataSet = new DataSet(question.Content);
questionReport.AddDataSet(dataSet);
await _dataSetRepository.AddAsync(dataSet);
await _questionReportRepository.UpdateAsync(questionReport);
foreach (var label in questionReport.Labels)
{
dataSet.AddData("0");
await _dataSetRepository.UpdateAsync(dataSet);
}
}
break;
}
}
}
return(surveyReport.Id);
}
public async Task UpdateAsync(QuestionReport questionReport)
{
_context.QuestionReports.Update(questionReport);
await _context.SaveChangesAsync();
}
public async Task AddAsync(QuestionReport questionReport)
{
await _context.QuestionReports.AddAsync(questionReport);
await _context.SaveChangesAsync();
}
public JsonResult Update(string _id, [FromBody] QuestionReport obj)
{
return(Json(_QuestionReport.Update(_id, obj)));
}
public JsonResult Create([FromBody] QuestionReport obj)
{
return(Json(_QuestionReport.Create(obj)));
}
