protected void ClassesDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
UserBO userbo = new UserBO();
ConsentFormBO consentformbo = new ConsentFormBO();
String currentLoggedInUser = Request.Cookies["CurrentLoggedInUser"].Value;
user userobj = userbo.getUserById(currentLoggedInUser);
List <String> TeachingClasses = userbo.getTeachersTeachingClasses(currentLoggedInUser);
String FormID = Request.QueryString["FormId"];
String FoodPrefEnabled = Request.QueryString["FoodPref"];
if (consentformbo.retrieveClassList(FormID, ClassesDropDownList.SelectedItem.Text, userobj.school) == null || consentformbo.retrieveClassList(FormID, ClassesDropDownList.SelectedItem.Text, userobj.school).Count == 0)
{
noStudentsMsg.Visible = true;
}
else
{
noStudentsMsg.Visible = false;
}
StudentTables.DataSource = consentformbo.retrieveClassList(FormID, ClassesDropDownList.SelectedItem.Text, userobj.school);
StudentTables.DataBind();
if (FoodPrefEnabled == "True")
{
StudentTables.Columns[2].Visible = true;
}
else if (FoodPrefEnabled == "False")
{
StudentTables.Columns[2].Visible = false;
}
}
protected void ExportBtn_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=ConsentForm_Report.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
using (StringWriter sw = new StringWriter())
{
HtmlTextWriter hw = new HtmlTextWriter(sw);
//To Export all pages
StudentTables.HeaderRow.BackColor = Color.White;
foreach (TableCell cell in StudentTables.HeaderRow.Cells)
{
cell.BackColor = StudentTables.HeaderStyle.BackColor;
}
foreach (GridViewRow row in StudentTables.Rows)
{
row.BackColor = Color.White;
foreach (TableCell cell in row.Cells)
{
if (row.RowIndex % 2 == 0)
{
cell.BackColor = StudentTables.AlternatingRowStyle.BackColor;
}
else
{
cell.BackColor = StudentTables.RowStyle.BackColor;
}
cell.CssClass = "textmode";
}
}
StudentTables.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
UserBO userbo = new UserBO();
ConsentFormBO consentformbo = new ConsentFormBO();
String currentLoggedInUser = Request.Cookies["CurrentLoggedInUser"].Value;
user userobj = userbo.getUserById(currentLoggedInUser);
List <String> TeachingClasses = userbo.getTeachersTeachingClasses(currentLoggedInUser);
String FormID = Request.QueryString["FormId"];
String FoodPrefEnabled = Request.QueryString["FoodPref"];
ClassesDropDownList.DataSource = consentformbo.getSentClassesByFormID(FormID);
ClassesDropDownList.DataBind();
ClassesDropDownList.SelectedIndex = 0;
if (consentformbo.retrieveClassList(FormID, ClassesDropDownList.SelectedItem.Text, userobj.school) == null || consentformbo.retrieveClassList(FormID, ClassesDropDownList.SelectedItem.Text, userobj.school).Count == 0)
{
noStudentsMsg.Visible = true;
}
else
{
noStudentsMsg.Visible = false;
}
StudentTables.DataSource = consentformbo.retrieveClassList(FormID, ClassesDropDownList.SelectedItem.Text, userobj.school);
StudentTables.DataBind();
if (FoodPrefEnabled == "True")
{
StudentTables.Columns[2].Visible = true;
}
else if (FoodPrefEnabled == "False")
{
StudentTables.Columns[2].Visible = false;
}
//List<ConsentForm> consentFormRecords = consentformbo.getConsentFormsBySenderID(currentLoggedInUser);
//consentFormRecords.Reverse(); //sorts by latest at the top
//SelectedClassesListBox.DataSource = TeachingClasses;
//SelectedClassesListBox.DataBind(); //binds the data of classes that the user teaches
//ConsentFormList.DataSource = consentFormRecords;
//ConsentFormList.DataBind(); //bind entries
}
}
