/// <summary>
/// Load all users
/// </summary>
private void LoadUsers()
{
School school = null;
Category category = null;
RoleType role = RoleType.All;
Region region = null;
Area area = null;
if (ddlSearchRegion.SelectedValue != "-1")
{
region = RegionService.GetRegion(ddlSearchRegion.SelectedValue);
}
if (ddlCategories.SelectedValue != "-1")
{
category = CategoryService.GetCategory(region, ddlCategories.SelectedValue);
}
if (ddlSearchArea.SelectedValue != "-1")
{
area = RegionService.GetArea(region, ddlSearchArea.SelectedValue);
}
if (ddlSearchSchool.SelectedValue != "-1")
{
school = RegionService.GetSchool(ddlSearchSchool.SelectedValue);
}
if (ddlUserType.SelectedValue != "-1")
{
role = (RoleType)Convert.ToInt32(ddlUserType.SelectedValue);
}
string orderby = (SortDirection == SortDirection.Ascending) ? " order by " + SortColumn + " ASC " : " order by " + SortColumn + " DESC ";
IList <DisplayUser> list = UserService.GetAllUsers(region, area, school, category, txtSearchUserName.Text, role, orderby);
gvUsers.DataSource = list;
gvUsers.DataBind();
lblRecCount.Text = string.Format("{0:d} users found", list.Count);
}
protected void btnFinal_Click(object sender, EventArgs e)
{
if (ddlStatus.SelectedValue != "-1")
{
Status status = (Status)Enum.Parse(typeof(Status), ddlStatus.SelectedValue);
string title = DateTime.Now.Year.ToString() + " ";
string fileName = string.Empty;
if (ddlArea.SelectedValue != "-1")
{
Area area = RegionService.GetArea(ddlArea.SelectedValue);
fileName = Path.Combine(Path.GetTempPath(), area.Name + ".pdf");
title = DateTime.Now.Year.ToString() + " " + area.Name + " Area Finalists";
ReportService.CreateFinalistReport(fileName, status, area, title);
}
else
{
Region region = RegionService.GetRegion(ddlRegion.SelectedValue);
title += region.Name + " Finalists";
fileName = Path.Combine(Path.GetTempPath(), "report.pdf");
ReportService.CreateFinalistReport(fileName, status, null, title);
}
byte[] buf = FileUtils.LoadFile(fileName);
Response.Clear();
Response.ContentType = "application/zip";
Response.AddHeader("Content-Disposition", "attachment; filename=" + System.IO.Path.GetFileName(fileName));
Response.AddHeader("Content-Length", buf.Length.ToString());
Response.BinaryWrite(buf);
Response.End();
System.IO.File.Delete(fileName);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Label lblId = modalDialog.FindControl("lblId") as Label;
TextBox txtFullName = modalDialog.FindControl("txtFullName") as TextBox;
TextBox txtEmail = modalDialog.FindControl("txtEmail") as TextBox;
TextBox txtComment = modalDialog.FindControl("txtComment") as TextBox;
TextBox txtPhone = modalDialog.FindControl("txtPhone") as TextBox;
DropDownList ddlRoleType = modalDialog.FindControl("ddlRoleType") as DropDownList;
DropDownList ddlRegion = modalDialog.FindControl("ddlRegion") as DropDownList;
DropDownList ddlArea = modalDialog.FindControl("ddlArea") as DropDownList;
DropDownList ddlCategory = modalDialog.FindControl("ddlCategory") as DropDownList;
DropDownList ddlSchool = modalDialog.FindControl("ddlSchool") as DropDownList;
Label labCustomError = modalDialog.FindControl("labCustomError") as Label;
UserInput input = new UserInput();
input.Id = Convert.ToInt32(lblId.Text);
input.FullName = txtFullName.Text;
input.EMail = txtEmail.Text;
input.Comment = txtComment.Text;
input.Phone = txtPhone.Text;
input.Role = (RoleType)Convert.ToInt32(ddlRoleType.SelectedValue);
if (input.Role == RoleType.RegionAdministrator)
{
Region region = RegionService.GetRegion(ddlRegion.SelectedValue);
input.Area = RegionService.GetArea(region, ddlArea.SelectedValue);
}
if (input.Role == RoleType.AreaJudge | input.Role == RoleType.RegionJudge)
{
input.Area = RegionService.GetArea(ddlArea.SelectedValue);
input.Category = CategoryService.GetCategory(input.Area.Region, ddlCategory.SelectedValue);
}
else if (input.Role == RoleType.Coordinator | input.Role == RoleType.Principal | input.Role == RoleType.Nominee)
{
input.School = RegionService.GetSchool(ddlSchool.SelectedValue);
if (input.Role == RoleType.Nominee)
{
input.Category = CategoryService.GetCategory(input.Area.Region, ddlCategory.SelectedValue);
}
}
MembershipCreateStatus status = UserService.AddNewUser(input);
if (status == MembershipCreateStatus.DuplicateEmail)
{
labCustomError.Text = "The email address is a duplicate, please enter a different email address";
labCustomError.Visible = true;
}
else
{
User user = UserService.GetUser(input.EMail);
if (input.Id <= 0)
{
UserService.SendUserEmail(user, "Sterling Scholar Registration Request", System.Web.HttpContext.Current.Server.MapPath("~/") + "/assets/NewUserTemplate.html");
}
modalDialog.HideModal();
}
}
protected void ddlArea_OnSelectedIndexChanged(object sender, EventArgs e)
{
if (!"-1".Equals(ddlArea.SelectedValue))
{
Region region = RegionService.GetRegion(ddlRegion.SelectedValue);
Area area = RegionService.GetArea(region, ((DropDownList)sender).SelectedValue);
LoadSchools(area);
}
}
private void LoadAreas(Region region)
{
ddlArea.DataMember = "Id";
ddlArea.DataTextField = "Name";
ddlArea.DataSource = region.Areas;
ddlArea.DataBind();
if (CurrentUser.Role == RoleType.Administrator)
{
ddlArea.Items.Insert(0, new ListItem("All", "-1"));
}
Area area = RegionService.GetArea(region, ddlArea.SelectedValue);
LoadSchools(area);
}
private IList <Portfolio> GetPortfolios()
{
School school = null;
Category category = null;
Region region = null;
string where = " where 1=1 ";
if (ddlRegion.SelectedValue != "-1")
{
region = RegionService.GetRegion(ddlRegion.SelectedValue);
where += " and p.School.Area.Region.Id = " + region.Id;
}
if (ddlCategories.SelectedValue != "-1" && null != region)
{
category = CategoryService.GetCategory(region, ddlCategories.SelectedValue);
where += " and p.Category.Id = " + category.Id;
}
if (ddlArea.SelectedValue != "-1" && null != region)
{
Area area = null;
if (null != region)
{
area = RegionService.GetArea(region, ddlArea.SelectedValue);
}
where += " and p.School.Area.Id = " + area.Id;
}
if (ddlSchools.SelectedValue != "-1")
{
school = RegionService.GetSchool(ddlSchools.SelectedValue);
where += " and p.School.Id = " + school.Id;
}
if (ddlStatus.SelectedValue != "-1")
{
Status status = (Status)Enum.Parse(typeof(Status), ddlStatus.SelectedValue);
where += " and p.Status = " + (int)status;
}
string orderby = (SortDirection == SortDirection.Ascending) ? " order by " + SortColumn + " ASC " : " order by " + SortColumn + " DESC ";
IList <Portfolio> list = PortfolioService.GetPortfolios(where + orderby);
return(list);
}
private void LoadSchools()
{
if (!"-1".Equals(ddlSearchRegion.SelectedValue))
{
Region region = RegionService.GetRegion(ddlSearchRegion.SelectedValue);
Area area = RegionService.GetArea(region, ddlSearchArea.SelectedValue);
IList <School> schools = RegionService.GetSchools(area);
ddlSearchSchool.DataSource = schools;
ddlSearchSchool.DataMember = "Id";
ddlSearchSchool.DataTextField = "Name";
ddlSearchSchool.DataBind();
ddlSearchSchool.Items.Insert(0, new ListItem("All", "-1"));
}
else
{
ddlSearchSchool.DataSource = null;
ddlSearchSchool.DataBind();
ddlSearchSchool.Items.Insert(0, new ListItem("All", "-1"));
}
}
private string GetWhereClause()
{
School school = null;
Category category = null;
Region region = null;
string where = " where 1=1 ";
if (ddlRegion.SelectedValue != "-1")
{
region = RegionService.GetRegion(ddlRegion.SelectedValue);
where += " and p.School.Area.Region.Id = " + region.Id;
}
if (ddlCategories.SelectedValue != "-1")
{
category = CategoryService.GetCategory(region, ddlCategories.SelectedValue);
where += " and p.Category.Id = " + category.Id;
}
if (ddlArea.SelectedValue != "-1")
{
Area area = RegionService.GetArea(ddlArea.SelectedValue);
where += " and p.School.Area.Id = " + area.Id;
}
if (ddlSchools.SelectedValue != "-1")
{
school = RegionService.GetSchool(ddlSchools.SelectedValue);
where += " and p.School.Id = " + school.Id;
}
if (ddlStatus.SelectedValue != "-1")
{
Status status = (Status)Enum.Parse(typeof(Status), ddlStatus.SelectedValue);
where += " and p.Status = " + (int)status;
}
return(where);
}
protected void ddlArea_OnSelectedIndexChanged(object sender, EventArgs e)
{
Area area = RegionService.GetArea(((DropDownList)sender).SelectedValue);
LoadSchools(area);
}
private void ShowDropDowns(RoleType role)
{
DropDownList ddlRegion = modalDialog.FindControl("ddlRegion") as DropDownList;
DropDownList ddlArea = modalDialog.FindControl("ddlArea") as DropDownList;
DropDownList ddlCategory = modalDialog.FindControl("ddlCategory") as DropDownList;
DropDownList ddlSchool = modalDialog.FindControl("ddlSchool") as DropDownList;
Label labRole = modalDialog.FindControl("labRole") as Label;
Label labSchool = modalDialog.FindControl("labSchool") as Label;
Label labRegion = modalDialog.FindControl("labRegion") as Label;
Label labArea = modalDialog.FindControl("labArea") as Label;
Label labCategory = modalDialog.FindControl("labCategory") as Label;
if (role == RoleType.AreaJudge | role == RoleType.RegionJudge)
{
ddlRegion.Visible = true;
ddlArea.Visible = (role == RoleType.AreaJudge);
labArea.Visible = (role == RoleType.AreaJudge);
ddlSchool.Visible = false;
labSchool.Visible = false;
ddlCategory.Visible = true;
labCategory.Visible = true;
}
else if (role == RoleType.Coordinator | role == RoleType.Principal)
{
ddlRegion.Visible = true;
labRegion.Visible = true;
ddlArea.Visible = true;
labArea.Visible = true;
ddlSchool.Visible = true;
labSchool.Visible = true;
ddlCategory.Visible = false;
labCategory.Visible = false;
Area area = RegionService.GetArea(ddlArea.SelectedValue);
LoadSchools(area);
}
else if (role == RoleType.Administrator)
{
ddlRegion.Visible = false;
ddlArea.Visible = false;
ddlCategory.Visible = false;
ddlSchool.Visible = false;
labSchool.Visible = false;
labRegion.Visible = false;
labArea.Visible = false;
labCategory.Visible = false;
}
else if (role == RoleType.RegionAdministrator)
{
ddlRegion.Visible = true;
ddlArea.Visible = true;
ddlCategory.Visible = false;
ddlSchool.Visible = false;
labSchool.Visible = false;
labRegion.Visible = true;
labArea.Visible = true;
labCategory.Visible = false;
}
else if (role == RoleType.Nominee)
{
ddlRegion.Visible = true;
labRegion.Visible = true;
ddlArea.Visible = true;
labArea.Visible = true;
ddlSchool.Visible = true;
labSchool.Visible = true;
ddlCategory.Visible = true;
labCategory.Visible = true;
Region region = RegionService.GetRegion(ddlRegion.SelectedValue);
Area area = RegionService.GetArea(region, ddlArea.SelectedValue);
LoadSchools(area);
}
}