Agribusiness.Import.Controllers.SeminarController.ReadSeminar C# (CSharp) Метод

        public static SeminarViewModel ReadSeminar()
        {
            var imported = Db.Trackings.Where(a => a.Name == _seminarTable).Any();

            var seminars = new List<Seminar>();
            var errors = new List<KeyValuePair<string, string>>();

            ReadData("~/Assets/Seminar.xls", imported, seminars, errors);

            if (!imported)
            {
                var tracking = new Tracking() { Name = _seminarTable };
                Db.Trackings.Add(tracking);
                Db.SaveChanges();
            }

            var viewModel = SeminarViewModel.Create(seminars, errors, imported);
            return viewModel;
        }

        public ActionResult ImportAll()
        {
            ViewBag.Start = DateTime.Now;

            var results = new List <ImportResult>();

            var firm = FirmController.ReadFirms();

            results.Add(new ImportResult()
            {
                File = "Firms", Error = firm.Errors.Count, Read = firm.Firms.Count, Imported = firm.AlreadyImported
            });
            firm = FirmController.ReadArchiveFirms();
            results.Add(new ImportResult()
            {
                File = "Archive Firms", Error = firm.Errors.Count, Read = firm.Firms.Count, Imported = firm.AlreadyImported
            });

            var cfirm = ContactFirmsController.ReadContactFirm();

            results.Add(new ImportResult()
            {
                File = "Contact Firm", Error = cfirm.Errors.Count, Read = cfirm.ContactFirms.Count, Imported = cfirm.AlreadyImported
            });
            cfirm = ContactFirmsController.ReadArchiveContactFirm();
            results.Add(new ImportResult()
            {
                File = "Archive Contact Firm", Error = cfirm.Errors.Count, Read = cfirm.ContactFirms.Count, Imported = cfirm.AlreadyImported
            });

            var seminar = SeminarController.ReadSeminar();

            results.Add(new ImportResult()
            {
                File = "Seminar", Error = seminar.Errors.Count, Read = seminar.Seminars.Count, Imported = seminar.AlreadyImported
            });
            seminar = SeminarController.ReadArchiveSeminar();
            results.Add(new ImportResult()
            {
                File = "Archive Seminar", Error = seminar.Errors.Count, Read = seminar.Seminars.Count, Imported = seminar.AlreadyImported
            });

            var contact = ContactController.ReadContact();

            results.Add(new ImportResult()
            {
                File = "Contact", Error = contact.Errors.Count, Read = contact.Contacts.Count, Imported = contact.AlreadyImported
            });
            contact = ContactController.ReadArchiveContact();
            results.Add(new ImportResult()
            {
                File = "Archive Contact", Error = contact.Errors.Count, Read = contact.Contacts.Count, Imported = contact.AlreadyImported
            });

            var commodities = CommodityController.ReadCommodity();

            results.Add(new ImportResult()
            {
                File = "Commodity", Error = commodities.Errors.Count, Read = commodities.Commodities.Count, Imported = commodities.AlreadyImported
            });
            commodities = CommodityController.ReadArchiveCommodity();
            results.Add(new ImportResult()
            {
                File = "Archive Commodity", Error = commodities.Errors.Count, Read = commodities.Commodities.Count, Imported = commodities.AlreadyImported
            });

            ViewBag.End = DateTime.Now;

            return(View(results));
        }