public void InsertHearingType(Activity act){ using (var db = FactoryConn.GetConn ()) { db.CreateTable<HearingType> (); if (db.Table<HearingType> ().Count () == 0) { IEnumerable<String[]> data = GetDataOfFile (ConstantsDb.CONTENT_FOLDER_CATALOG + "/hearing_type.txt", act); List<HearingType> entities = new List<HearingType> (); foreach (String[] line in data) { try { HearingType model = new HearingType (); model.Id = int.Parse (line [0]); model.Description = line [1]; model.IsObsolete = line [2].Equals ("1"); model.Lock = line [3].Equals ("1"); model.Specification = line [4].Equals ("1"); entities.Add (model); } catch (Exception e) { Console.WriteLine ("HearingType error " + e.Message); } } db.InsertAll (entities); var content = db.Table<HearingType> ().ToList (); Console.WriteLine ("Se inserto en tabla HearingType:"); foreach (HearingType m in content) { Console.WriteLine ("Id: " + m.Id + " Name:" + m.Description); } } db.Close (); } }
public void InsertHearingFormatType(Activity act) { var db = new SQLiteConnection(ConstantsDB.DB_PATH); db.CreateTable <HearingType> (); if (db.Table <HearingType> ().Count() == 0) { IEnumerable <String[]> data = GetDataOfFile(ConstantsDB.CONTENT_FOLDER_CATALOG + "/hearing_format_type.txt", act); List <HearingType> entities = new List <HearingType>(); foreach (String[] line in data) { try{ HearingType model = new HearingType(); model.Id = int.Parse(line [0]); model.Name = line[1]; model.Description = line[2]; model.IsObsolete = line[3].Equals("1"); entities.Add(model); }catch (Exception e) { Console.WriteLine("error " + e.Message); } } db.InsertAll(entities); var content = db.Table <HearingType> ().ToList(); Console.WriteLine("Se inserto en tabla HearingType:"); foreach (HearingType m in content) { Console.WriteLine("Id: " + m.Id + " Name:" + m.Name); } } db.Close(); }