protected void btnDownload_Click(object sender, EventArgs e)
        {
            Lib.Entities.BaseForm baseForm = null;
            string excelname = "file.xlsx";

            using (Lib.Repositories.BaseFormRepository repo = new Lib.Repositories.BaseFormRepository(this.ActiveUser))
            {
                baseForm = repo.getInstanceByPeriodDate(DateTime.Now);
            }

            if (baseForm != null)
            {
                excelname = Commons.StringUtils.removeAccents(baseForm.Name) + ".xlsx";

                filePath = Server.MapPath("/App_Data/" + excelname);
                Lib.Utils.ExcelUtils utils = new Lib.Utils.ExcelUtils();

                bool save = utils.createExcel(filePath, true);

                if (save)
                {
                    System.IO.FileInfo file = new System.IO.FileInfo(filePath);

                    Response.Clear();
                    Response.Buffer = true;

                    Response.AddHeader("content-disposition", "attachment;filename=" + excelname);
                    Response.ContentEncoding = Encoding.UTF8;

                    Response.Cache.SetCacheability(HttpCacheability.Private);
                    Response.ContentType = "application/vnd.ms-excel";
                    Response.WriteFile(file.FullName);

                    Response.Flush();
                    Response.End();
                }
            }
        }
        protected void btnImport_Click(object sender, EventArgs e)
        {
            Lib.Utils.ExcelUtils utils = new Lib.Utils.ExcelUtils();
            string extensionDefault = ".xlsx";
            string url = "";

            if (fuForm.HasFile)
            {
                string extension = System.IO.Path.GetExtension(fuForm.FileName);

                if (extensionDefault != extension)
                {
                    hdnError.Value = "O arquivo deve ser do tipo excel (xlsx).";
                }
                else
                {
                    try
                    {
                        filePath = Server.MapPath("/App_Data/fileUploaded.xlsx");
                        fuForm.SaveAs(filePath);

                        DataSet dataSet = utils.importExcelFile(filePath);
                        List<string> notAnsweredQuestions = null;
                        List<string> incorrectAnsweredQuestions = null;

                        bool canShowButton = canShowSubmitButton(dataSet.Tables, out notAnsweredQuestions, out incorrectAnsweredQuestions);

                        if (canShowButton)
                        {
                            //rptListBlocks.DataSource = dataSet.Tables;
                            //rptListBlocks.DataBind();

                            long id = saveResponseForm(dataSet.Tables);

                            url = String.Format("~/Form/View.aspx?rfid={0}", id.ToString());
                        }
                        else
                        {
                            StringBuilder sb = new StringBuilder();

                            if (notAnsweredQuestions.Count > 0)
                            {
                                sb.AppendLine(String.Format("Não foi possível carregar o arquivo pois ainda existem perguntas sem respostas."));
                                sb.AppendLine();

                                foreach (var item in notAnsweredQuestions)
                                {
                                    sb.AppendLine(item);
                                }
                            }

                            if (incorrectAnsweredQuestions.Count > 0)
                            {
                                sb.AppendLine();
                                sb.AppendLine();
                                sb.AppendLine(String.Format("Perguntas com respostas incorretas: "));
                                sb.AppendLine();

                                foreach (var item in incorrectAnsweredQuestions)
                                {
                                    sb.AppendLine(item);
                                }
                            }

                            litNotAnsweredQuestions.Text = sb.ToString().Replace("\r\n", "<br/>");
                        }
                    }
                    catch
                    {
                        hdnError.Value = "Arquivo inválido. Exporte o questionário e preencha novamente.";
                    }
                }
            }

            loadRanking();

            if (!string.IsNullOrEmpty(url))
            {
                Response.Redirect(url);
            }
        }