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();
        }