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() { 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; }