C# (CSharp) ProviderPortalEntities.up_CourseBrowseListForCsvExport Beispiele

Beispiel #1

        public override void GenerateCsv()
        {
            _logger("Starting Course browser CSV creation.");

            var courseItems = _db.up_CourseBrowseListForCsvExport();

            using (Stream stream = File.Open(Constants.W_Course_Browse_CsvFilename, FileMode.OpenOrCreate, FileAccess.Write, FileShare.Read))
            {
                using (TextWriter writer = new StreamWriter(stream))
                {
                    var csv = new CsvWriter(writer);

                    csv.WriteField <string>("CATEGORY_CODE");

                    csv.WriteField <string>("COURSE_COUNT");

                    csv.WriteField <string>("PARENT_CATEGORY_CODE");

                    csv.WriteField <string>("DESCRIPTION");

                    csv.WriteField <string>("SEARCHABLE_FLAG");

                    csv.NextRecord();

                    foreach (var courseItem in courseItems.ToList())
                    {
                        csv.WriteField(courseItem.CATEGORY_CODE);

                        csv.WriteField(courseItem.COURSE_COUNT);

                        csv.WriteField(courseItem.PARENT_CATEGORY_CODE);

                        csv.WriteField(courseItem.DESCRIPTION);

                        csv.WriteField(courseItem.SEARCHABLE_FLAG);

                        csv.NextRecord();
                    }
                }
            }
        }