/// <summary> /// import from sheet Smlouva /// </summary> /// <param name="excel_con"></param> private void ImportSmlouva(OleDbConnection excel_con) { DataTable dtExcelData = new DataTable(); dtExcelData.Columns.AddRange(new DataColumn[6] { new DataColumn("Id", typeof(int)), new DataColumn("PoskytovatelZdravotnichSluzebId", typeof(int)), new DataColumn("PojistovnaId", typeof(int)), new DataColumn("TypSmlouvy", typeof(string)), new DataColumn("DatumOd", typeof(DateTime)), new DataColumn("DatumDo", typeof(DateTime)) }); using (OleDbDataAdapter oda = new OleDbDataAdapter("SELECT * FROM [Smlouva$]", excel_con)) { oda.Fill(dtExcelData); foreach (DataRow row in dtExcelData.Rows) { int typSmlouvyId = _dataConnector.GetTypSmlouvy((string)row["TypSmlouvy"], (DateTime)row["DatumOd"]).Id; Smlouva smlouva = new Smlouva() { PoskytovatelZdravotnichSluzebId = (int)row["PoskytovatelZdravotnichSluzebId"], PojistovnaId = (int)row["PojistovnaId"], TypSmlouvyId = typSmlouvyId, DatumOd = (DateTime)row["DatumOd"], DatumDo = row.IsNull("DatumDo") ? null : (DateTime?)row["DatumDo"] }; _dataConnector.CreateSmlouva(smlouva); } } }