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

        private static void ReadData(string file, bool imported, List<Seminar> seminars, List<KeyValuePair<string, string>> errors)
        {
            var sheet = ExcelHelpers.OpenWorkbook(HostingEnvironment.MapPath(file));

            for (var i = sheet.FirstRowNum + 1; i <= sheet.LastRowNum; i++)
            {
                var row = sheet.GetRow(i);

                try
                {
                    var s_id = ExcelHelpers.ReadIntCell(row, 7);

                    // check the existance
                    if (Db.Seminars.Any(a => a.s_Id == s_id)) throw new Exception("Already exists");

                    // check and see if we came across it already in this file
                    var item = seminars.Where(a => a.s_Id == s_id).FirstOrDefault();
                    if (item != null)
                    {
                        errors.Add(new KeyValuePair<string, string>(s_id.ToString(), "duplicate value, replacing old"));

                        // get the index to remove the first one
                        seminars.Remove(item);
                    }

                    var seminar = new Seminar();

                    seminar.ApplicationStatus = ExcelHelpers.ReadCell(row, 0);  // a
                    seminar.ContactName = ExcelHelpers.ReadCell(row, 1);        // b
                    seminar.DateApplicationFormComplete = ExcelHelpers.ReadDateCell(row, 2);    // c
                    seminar.DateCreated = ExcelHelpers.ReadDateCell(row, 3);    // d
                    seminar.DateModified = ExcelHelpers.ReadDateCell(row, 4);   // e
                    seminar.Expectations = ExcelHelpers.ReadCell(row, 5);       // f
                    seminar.ContactId = ExcelHelpers.ReadIntCell(row, 6);       // g

                    seminar.s_Id = ExcelHelpers.ReadIntCell(row, 7);            // h
                    seminar.CreatedBy = ExcelHelpers.ReadCell(row, 8);          // i
                    seminar.ModifiedBy = ExcelHelpers.ReadCell(row, 9);         // j

                    seminar.IsCaseExecutive = ExcelHelpers.ReadBoolCell(row, 10);   // k
                    seminar.IsDiscussionGroupLead = ExcelHelpers.ReadBoolCell(row, 11); // l
                    seminar.IsFaculty = ExcelHelpers.ReadBoolCell(row, 12);     // m
                    seminar.IsSteeringCommittee = ExcelHelpers.ReadBoolCell(row, 13);   // n
                    seminar.IsPanelist = ExcelHelpers.ReadBoolCell(row, 14);    // o
                    seminar.IsParticipant = ExcelHelpers.ReadBoolCell(row, 15); // p
                    seminar.IsSpeaker = ExcelHelpers.ReadBoolCell(row, 16);     // Q
                    seminar.IsStaff = ExcelHelpers.ReadBoolCell(row, 17);       // r
                    seminar.IsVendor = ExcelHelpers.ReadBoolCell(row, 18);      // s
                    seminar.Accepted = ExcelHelpers.ReadBoolCell(row, 19);      // t
                    seminar.ExpensesComped = ExcelHelpers.ReadBoolCell(row, 20);// u

                    seminar.IsApplicant = ExcelHelpers.ReadBoolCell(row, 21);   // v
                    seminar.IsInvitee = ExcelHelpers.ReadBoolCell(row, 22);     // w

                    seminar.Year = ExcelHelpers.ReadIntCell(row, 23);           // x
                    seminar.PreviousYear = ExcelHelpers.ReadIntCell(row, 24);   // y

                    seminars.Add(seminar);
                }
                catch (Exception ex)
                {
                    errors.Add(new KeyValuePair<string, string>(ExcelHelpers.ReadIntCell(row, 7).ToString(), ex.Message));
                }

            }

            // save all the instances
            if (!imported)
            {
                foreach (var a in seminars)
                {
                    Db.Seminars.Add(a);
                }

                Db.SaveChanges();
            }
        }