Inheritance: DbContext
コード例 #1
0
        // Method to select data from the database
        public static IEnumerable<ReportsUI> GetReportData()
        {
            using (torontoDB db = new torontoDB())
            {

                var reportData = from c in db.ElectionContributions.AsEnumerable()

                                 // filter the report. This is hardcoded, but we should be taking these values
                                 // from select boxes on the view

                                 where c.ElectionType == ("Mayoral") && c.ElectionYear == (Convert.ToDouble(2010)) && c.WardNum == 2

                                  select new ReportsUI                                       // Create new ReportUI object and assign it the values selected from the database
                                  {
                                      ElectionType = c.ElectionType,
                                      ElectionYear = c.ElectionYear,
                                      WardNum = c.WardNum,
                                      ContributorFirstName = c.ContributorFirstName,
                                      ContributorLastName = c.ContributorLastName,
                                      CandidateLastName = c.CandidateLastName,
                                      ContributionTypeDesc = c.ContributionTypeDesc
                                  };

                return reportData.ToArray();                                                // ToArray() method is needed to prevent DbContext error

            }
        }
コード例 #2
0
        // Method to select data from the database
        // report 2 from results
        public static IEnumerable<ReportsUI> GetReportData2()
        {
            using (torontoDB db = new torontoDB())
            {

                var reportData2 = from c in db.ElectionResults.AsEnumerable()

                                 // filter the report. This is hardcoded, but should be taking these values
                                 // from select boxes on the view

                                 where c.ElectionType == ("Council") && c.ElectionYear == (Convert.ToDouble(2006)) && c.NumVotes >= 5000

                                 select new ReportsUI                                    // Create new ReportUI object and assign it the values selected from the database
                                 {
                                     ElectionType = c.ElectionType,
                                     ElectionYear = c.ElectionYear,
                                     CandidateFirstName = c.CandidateFirstName,
                                     CandidateLastName = c.CandidateLastName,
                                     WardNum = c.WardNum,
                                     NumVotes = c.NumVotes
                                 };

                return reportData2.ToArray();                                                // ToArray() method is needed to prevent DbContext error

            }
        }
コード例 #3
0
        // Method to select data from the database
        public static IEnumerable<ReportsUI> GetReportData(string ElectionType, int ElectionYear, int WardNum, String CandidateLastName, String ContributionTypeDesc)
        {
            using (torontoDB db = new torontoDB())
            {

                var reportData = from c in db.ElectionContributions.AsEnumerable()

                                 where c.ElectionType == (ElectionType) && c.ElectionYear == (Convert.ToDouble(ElectionYear)) && c.WardNum == (Convert.ToDouble(WardNum)) && c.CandidateLastName == CandidateLastName && c.ContributionTypeDesc == (ContributionTypeDesc)

                                 select new ReportsUI                                       // Create new ReportUI object and assign it the values selected from the database
                                 {
                                     ElectionType = c.ElectionType,
                                     ElectionYear = c.ElectionYear,
                                     WardNum = c.WardNum,
                                     ContributorFirstName = c.ContributorFirstName,
                                     ContributorLastName = c.ContributorLastName,
                                     CandidateLastName = c.CandidateLastName,
                                     ContributionTypeDesc = c.ContributionTypeDesc,
                                     Amount = c.Amount
                                 };

                return reportData.ToArray();                                                // ToArray() method is needed to prevent DbContext error

            }
        }