コード例 #1
0
        // GET: TrainingPrograms
        public ActionResult Index(string _pastprograms)
        {
            using (SqlConnection conn = Connection)
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    if (_pastprograms == "true")
                    {
                        cmd.CommandText = @"SELECT * 
                                        FROM TrainingProgram 
                                        WHERE StartDate <= getdate();";
                    }
                    else
                    {
                        cmd.CommandText = @"SELECT * 
                                        FROM TrainingProgram 
                                        WHERE StartDate >= getdate();";
                    }
                    SqlDataReader reader = cmd.ExecuteReader();

                    TrainingProgramIndexViewModel toTheModel       = new TrainingProgramIndexViewModel();
                    List <TrainingProgram>        trainingPrograms = new List <TrainingProgram>();

                    while (reader.Read())
                    {
                        TrainingProgram trainingProgram = new TrainingProgram
                        {
                            Id           = reader.GetInt32(reader.GetOrdinal("id")),
                            Name         = reader.GetString(reader.GetOrdinal("name")),
                            StartDate    = reader.GetDateTime(reader.GetOrdinal("startDate")),
                            EndDate      = reader.GetDateTime(reader.GetOrdinal("endDate")),
                            MaxAttendees = reader.GetInt32(reader.GetOrdinal("maxAttendees"))
                        };
                        trainingPrograms.Add(trainingProgram);
                    }
                    toTheModel.TrainingPrograms = trainingPrograms;
                    if (_pastprograms == "true")
                    {
                        toTheModel.PastProgram = true;
                    }
                    else if (_pastprograms == "false")
                    {
                        toTheModel.PastProgram = false;
                    }
                    reader.Close();

                    return(View(toTheModel));
                }
            }
        }
        // GET: TrainingProgram
        public async Task <IActionResult> Index()
        {
            using (IDbConnection conn = Connection)
            {
                string sql = @"SELECT tp.Id, 
                                      tp.[Name],
                                      tp.StartDate, 
                                      tp.EndDate,
                                      tp.MaxAttendees
                                FROM TrainingProgram tp
                                ORDER BY tp.Id";
                IEnumerable <TrainingProgram> trainingPrograms = await conn.QueryAsync <TrainingProgram>(sql);

                TrainingProgramIndexViewModel viewModel = new TrainingProgramIndexViewModel();
                viewModel.TrainingPrograms = trainingPrograms.Where(tp => tp.StartDate > DateTime.Today).ToList();
                return(View(viewModel));
            }
        }