protected void ButtonCSV_Click(object sender, EventArgs e)
{
try
{
#region Session Declaration
//Palash
string reportname = Convert.ToString(Session["reportname"]);
string numberOfRows = Convert.ToString(Session["numberOfRows"]);
string pageIndex = Convert.ToString(Session["pageIndex"]);
string sortColumnName = Convert.ToString(Session["sortColumnName"]);
string sortOrderBy = Convert.ToString(Session["sortOrderBy"]);
string BannerID = Convert.ToString(Session["BannerID"]);
string NAME = Convert.ToString(Session["NAME"]);
string StudentOID = Convert.ToString(Session["StudentOID"]);
string TERM = Convert.ToString(Session["TERM"]);
string FullPart = Convert.ToString(Session["FullPart"]);
string GPA = Convert.ToString(Session["GPA"]);
string CreditAttempted = Convert.ToString(Session["CreditAttempted"]);
string EarnedCredit = Convert.ToString(Session["EarnedCredit"]);
string Prealgebra = Convert.ToString(Session["Prealgebra"]);
string Algebra = Convert.ToString(Session["Algebra"]);
string Writting = Convert.ToString(Session["Writting"]);
string Reading = Convert.ToString(Session["Reading"]);
string English = Convert.ToString(Session["English"]);
string Math = Convert.ToString(Session["Math"]);
string ReadingScore = Convert.ToString(Session["ReadingScore"]);
string ScienceScore = Convert.ToString(Session["ScienceScore"]);
DateTime TestingDate = Convert.ToDateTime(Session["TestingDate"]);
string HighSchool = Convert.ToString(Session["HighSchool"]);
DateTime HS_GRAD_DATE = Convert.ToDateTime(Session["HS_GRAD_DATE"]);
string ADDR1 = Convert.ToString(Session["ADDR1"]);
string ADDR2 = Convert.ToString(Session["ADDR2"]);
string ADDR3 = Convert.ToString(Session["ADDR3"]);
string CITY = Convert.ToString(Session["CITY"]);
string STATE = Convert.ToString(Session["STATE"]);
string ZIP = Convert.ToString(Session["ZIP"]);
DateTime ImportDate = Convert.ToDateTime(Session["ImportDate"]);
string PPGMIND = Convert.ToString(Session["PPGMIND"]);
string MAJOR = Convert.ToString(Session["MAJOR"]);
string Email = Convert.ToString(Session["Email"]);
string Phone = Convert.ToString(Session["Phone"]);
//Palash
#endregion
int totalRecords;
string aoid = Request.QueryString["aid"].ToString();
string SortOrSearchFlag = "Search";
string query = Hiddenquery.Value;
string strParameter = HttpUtility.UrlDecode(query);
string MultipleSearch = "";
string SearchColName = "";
string SearchVal = "";
SortOrSearchFlag = "Search";
MultipleSearch = SearchColName;
if (!strParameter.Equals(string.Empty))
{
foreach (string str in strParameter.Substring(1).Split('&'))
{
string[] str1 = str.Split('=');
if (str1.Length > 0)
{
MultipleSearch = MultipleSearch + str1[0] + ",";
SearchVal = SearchVal + str1[1] + ",";
}
}
MultipleSearch = MultipleSearch.Substring(0, MultipleSearch.Length - 1);
SearchVal = SearchVal.Substring(0, SearchVal.Length - 1);
}
Assessment ass = new Assessment();
string output = ass.GetAssessmentResult(Convert .ToInt32 ( aoid), numberOfRows, pageIndex, out totalRecords, MultipleSearch, SearchVal, sortColumnName, sortOrderBy, BannerID, MAJOR, NAME, SortOrSearchFlag);
//Collection<Student> students = SearchStudent(reportname, numberOfRows, pageIndex, sortColumnName, sortOrderBy, out totalRecords, Convert.ToInt32("0"), request["NAME"], request["StudentOID"], request["TERM"], request["FullPart"], Convert.ToDouble(request["GPA"]), Convert.ToDouble(request["CreditAttempted"]), Convert.ToDouble(request["EarnedCredit"]), request["Prealgebra"], request["Algebra"], request["Writting"], request["Reading"], request["English"], request["Math"], request["ReadingScore"], request["ScienceScore"], Convert.ToDateTime(request["TestingDate"]), request["HighSchool"], Convert.ToDateTime(request["HS_GRAD_DATE"]), request["ADDR1"], request["ADDR2"], request["ADDR3"], request["CITY"], request["STATE"], request["ZIP"], Convert.ToDateTime(request["ImportDate"]), request["PPGMIND"], request["MAJOR"], request["Email"], request["Phone"]);
Collection<Student> students = SearchStudent(reportname, numberOfRows, pageIndex, sortColumnName, sortOrderBy, out totalRecords, Convert.ToInt32("0"), NAME, StudentOID, TERM, FullPart, GPA, CreditAttempted, EarnedCredit, Prealgebra, Algebra, Writting, Reading, English, Math, ReadingScore, ScienceScore, TestingDate, HighSchool, HS_GRAD_DATE, ADDR1, ADDR2, ADDR3, CITY, STATE, ZIP, ImportDate, PPGMIND, MAJOR, Email, Phone);
DataTable studentReportDt = this.ConvertListToDataTable(students);
string reportOIDStr = Request.QueryString["ReportOID"].ToString();
ExportToExcel.ExportToSpreadsheet(studentReportDt, reportOIDStr, "CSV");
}
catch (Exception ex)
{ }
}
