protected void LoadCategories()
{
//Now select on this collection
OMAMFundCategoryCollection Categories = new OMAMFundCategoryCollection();
Categories.Query.Select(Categories.Query.Id,
Categories.Query.FundCategory);
Categories.LoadAll();
CategoryList = Categories;
gvAllNews.PageIndex = 0;
loadDataGrid();
}
protected void populateDropdowns()
{
//Get All Fund Categories
OMAMFundCategoryCollection objCategoryCol = new OMAMFundCategoryCollection();
objCategoryCol.Query
.Select(objCategoryCol.Query.Id, objCategoryCol.Query.FundCategory)
.OrderBy(objCategoryCol.Query.Id.Ascending);
objCategoryCol.Query.Load();
ddlCategories.DataSource = objCategoryCol;
ddlCategories.DataTextField = "FundCategory";
ddlCategories.DataValueField = "Id";
ddlCategories.DataBind();
ddlCategories.Items.Insert(0, "All");
ddlCategories.SelectedIndex = 0;
Categories = objCategoryCol;
}
protected void populateDropDowns()
{
string sFolderPath;
//OK, Now get the categories available.
OMAMFundCategoryCollection fundCol = new OMAMFundCategoryCollection();
fundCol.Query
.OrderBy(fundCol.Query.FundCategory.Ascending);
fundCol.LoadAll();
cblCategoriesAvailable.DataSource = fundCol;
cblCategoriesAvailable.DataTextField = "FundCategory";
cblCategoriesAvailable.DataValueField = "Id";
cblCategoriesAvailable.DataBind();
//OK, Now get the S&P Rating Images.
sFolderPath = Server.MapPath(Settings["SPImageFolder"].ToString());
DirectoryInfo SPImages = new DirectoryInfo(sFolderPath);
FileInfo[] SPFiles = SPImages.GetFiles();
ddlSPRating.DataSource = SPFiles;
ddlSPRating.DataValueField = "Name";
ddlSPRating.DataTextField = "Name";
ddlSPRating.DataBind();
//OK, Now get the OBSR Rating Images.
sFolderPath = Server.MapPath(Settings["OBSRImageFolder"].ToString());
DirectoryInfo OBSRImages = new DirectoryInfo(sFolderPath);
FileInfo[] OBSRFiles = OBSRImages.GetFiles();
ddlOBSRRating.DataSource = OBSRFiles;
ddlOBSRRating.DataValueField = "Name";
ddlOBSRRating.DataTextField = "Name";
ddlOBSRRating.DataBind();
//OK, Now get the CityWire Rating Images.
sFolderPath = Server.MapPath(Settings["CWImageFolder"].ToString());
DirectoryInfo CityWireImages = new DirectoryInfo(sFolderPath);
FileInfo[] CWFiles = CityWireImages.GetFiles();
ddlCitywireRating.DataSource = CWFiles;
ddlCitywireRating.DataValueField = "Name";
ddlCitywireRating.DataTextField = "Name";
ddlCitywireRating.DataBind();
//OK, Now get the Factsheet files
sFolderPath = Server.MapPath(Settings["FactsheetFolder"].ToString());
DirectoryInfo diFactsheets = new DirectoryInfo(sFolderPath);
FileInfo[] fiFactsheets = diFactsheets.GetFiles();
ddlFactsheet.DataSource = fiFactsheets;
ddlFactsheet.DataValueField = "Name";
ddlFactsheet.DataTextField = "Name";
ddlFactsheet.DataBind();
ddlFactsheet.Items.Insert(0, "Please Select");
ddlFactsheet.SelectedIndex = 0;
//OK, Now get the Factsheet files
sFolderPath = Server.MapPath(Settings["ReasonFolder"].ToString());
DirectoryInfo diReasonFolder = new DirectoryInfo(sFolderPath);
FileInfo[] fiReasonFolder = diReasonFolder.GetFiles();
ddlReasons.DataSource = fiReasonFolder;
ddlReasons.DataValueField = "Name";
ddlReasons.DataTextField = "Name";
ddlReasons.DataBind();
ddlReasons.Items.Insert(0, "Please Select");
ddlReasons.SelectedIndex = 0;
//OK, Now get the AnnualReportFolder Files
sFolderPath = Server.MapPath(Settings["AnnualReportFolder"].ToString());
DirectoryInfo diAnnualReportFolder = new DirectoryInfo(sFolderPath);
FileInfo[] fiAnnualReportFolder = diAnnualReportFolder.GetFiles();
ddlAnnual.DataSource = fiAnnualReportFolder;
ddlAnnual.DataValueField = "Name";
ddlAnnual.DataTextField = "Name";
ddlAnnual.DataBind();
ddlAnnual.Items.Insert(0, "Please Select");
ddlAnnual.SelectedIndex = 0;
//OK, Now get the InterimFolder Files
sFolderPath = Server.MapPath(Settings["InterimFolder"].ToString());
DirectoryInfo diInterimFolder = new DirectoryInfo(sFolderPath);
FileInfo[] fiInterimFolder = diInterimFolder.GetFiles();
ddlInterim.DataSource = fiInterimFolder;
ddlInterim.DataValueField = "Name";
ddlInterim.DataTextField = "Name";
ddlInterim.DataBind();
ddlInterim.Items.Insert(0, "Please Select");
ddlInterim.SelectedIndex = 0;
//OK, Now get the SPReportFolder Files
sFolderPath = Server.MapPath(Settings["SPReportFolder"].ToString());
DirectoryInfo diSPReportFolder = new DirectoryInfo(sFolderPath);
FileInfo[] fiSPReportFolder = diSPReportFolder.GetFiles();
ddlOBSRReport.DataSource = fiSPReportFolder;
ddlOBSRReport.DataValueField = "Name";
ddlOBSRReport.DataTextField = "Name";
ddlOBSRReport.DataBind();
ddlOBSRReport.Items.Insert(0, "Please Select");
ddlOBSRReport.SelectedIndex = 0;
//OK, Now get the OBSRReportFolder Files
sFolderPath = Server.MapPath(Settings["OBSRReportFolder"].ToString());
DirectoryInfo diOBSRReportFolder = new DirectoryInfo(sFolderPath);
FileInfo[] fiOBSRReportFolder = diOBSRReportFolder.GetFiles();
ddlSPReport.DataSource = fiOBSRReportFolder;
ddlSPReport.DataValueField = "Name";
ddlSPReport.DataTextField = "Name";
ddlSPReport.DataBind();
ddlSPReport.Items.Insert(0, "Please Select");
ddlSPReport.SelectedIndex = 0;
//OK, Now get the SalesAidFolder Files
sFolderPath = Server.MapPath(Settings["SalesAidFolder"].ToString());
DirectoryInfo diSalesAidFolder = new DirectoryInfo(sFolderPath);
FileInfo[] fiSalesAidFolder = diSalesAidFolder.GetFiles();
ddlSalesAid.DataSource = fiSalesAidFolder;
ddlSalesAid.DataValueField = "Name";
ddlSalesAid.DataTextField = "Name";
ddlSalesAid.DataBind();
ddlSalesAid.Items.Insert(0, "Please Select");
ddlSalesAid.SelectedIndex = 0;
//OK, Now get the TermsheetFolder Files
sFolderPath = Server.MapPath(Settings["TermsheetFolder"].ToString());
DirectoryInfo diTermsheetFolder = new DirectoryInfo(sFolderPath);
FileInfo[] fiTermsheetFolder = diTermsheetFolder.GetFiles();
ddlTermsheet.DataSource = fiTermsheetFolder;
ddlTermsheet.DataValueField = "Name";
ddlTermsheet.DataTextField = "Name";
ddlTermsheet.DataBind();
ddlTermsheet.Items.Insert(0, "Please Select");
ddlTermsheet.SelectedIndex = 0;
}
