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