public void GenerateReport()
{
int clientID = 0;
SurveyBL objSurvey = new SurveyBL();
clientID = objSurvey.GetPortalClientId();
int examId = 0;
if (!string.IsNullOrEmpty(txtExamID.Text))
{
examId = Convert.ToInt32(txtExamID.Text);
}
SurveyBL objBl = new SurveyBL();
DataSet ds = objBl.GetSurveyIndividualReport(clientID.ToString(), txtStudentName.Text, examId, rdpFromDate.SelectedDate.Value, rdpToDate.SelectedDate.Value);
FileInfo rptFileName = new FileInfo(Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["Reports"].ToString()) + @"\ Individual Responses from_" + rdpFromDate.SelectedDate.Value.ToString("MM/dd/yyyy HH:mm:ss").Replace("/", "-").Replace(":", "-") + ".xls");
// If any file exists in this directory having name 'Sample1.xlsx', then delete it
if (rptFileName.Exists)
{
rptFileName.Delete(); // ensures we create a new workbook
rptFileName = new FileInfo(Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["Reports"].ToString()) + @"\ Individual Responses from_" + rdpFromDate.SelectedDate.Value.ToString("MM/dd/yyyy HH:mm:ss").Replace("/", "-").Replace(":", "-") + ".xls");
}
// this.DeleteHistoricFiles();
if (ds != null & ds.Tables.Count > 0)
{
ExcelSheetGenerator objExcel = new ExcelSheetGenerator();
objExcel.GenerateReport(ds.Tables[0], rptFileName, "Individual Responses", "UserName");
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AppendHeader("Content-Disposition", "attachment; filename=\"" + "Individual Responses Report From -" + rdpFromDate.SelectedDate.Value.ToString("MM/dd/yyyy").Replace("/", "-").Replace(":", "-") + " " + rdpToDate.SelectedDate.Value.ToString("MM/dd/yyyy").Replace("/", "-").Replace(":", "-") + "" + ".xlsx");
Response.TransmitFile(rptFileName.ToString());
Response.End();
gReport.DataSource = ds.Tables[0];
}
else
{
gReport.DataSource = new object[0];
}
}
protected void gReport_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
int providerId = Convert.ToInt32(Session[BaseClass.EnumPageSessions.USERID]);
int clientID = 0;
SurveyBL objSurvey = new SurveyBL();
clientID = objSurvey.GetPortalClientId();
int examId = 0;
if (!string.IsNullOrEmpty(txtExamID.Text))
{
examId = Convert.ToInt32(txtExamID.Text);
}
SurveyBL objBl = new SurveyBL();
DataSet ds = null;
if (rdpFromDate.SelectedDate != null && rdpToDate.SelectedDate != null)
{
ds = objBl.GetSurveyIndividualReport(clientID.ToString(), txtStudentName.Text, examId, rdpFromDate.SelectedDate.Value, rdpToDate.SelectedDate.Value, providerId);
}
if (ds != null)
{
if (ds.Tables.Count > 0)
{
gReport.DataSource = ds.Tables[0];
}
else
{
gReport.DataSource = new object[0];
}
}
else
{
gReport.DataSource = new object[0];
}
objBl = null;
}
