// Bare data
public ContactBareDataDB GetContactBareDataByContactId(int contactId)
{
ContactBareDataDB bareData = new ContactBareDataDB();
if (this.OpenConnection() == true)
{
string query = "SELECT * FROM contact_bare_data where contact_id = @contact_id";
//Create Command
SQLiteCommand cmd = new SQLiteCommand(query, connection);
cmd.Parameters.AddWithValue("@contact_id", contactId);
//Create a data reader and Execute the command
SQLiteDataReader dataReader = cmd.ExecuteReader();
//Read the data and store them in the list
while (dataReader.Read())
{
int id = Int32.Parse(dataReader["id"].ToString());
string data = dataReader["bare_data"].ToString();
bareData.Id = id;
bareData.ContactId = contactId;
bareData.BareData = data;
}
//close Data Reader
dataReader.Close();
//close Connection
this.CloseConnection();
}
return bareData;
}
// Insert bare data
public int AddContactBareData(ContactBareDataDB bareData)
{
//open connection
if (this.OpenConnection() == true)
{
SQLiteTransaction trans = connection.BeginTransaction();
int res = -1;
try
{
SQLiteCommand comm = connection.CreateCommand();
comm.Transaction = trans;
comm.CommandText = "INSERT INTO contact_bare_data (contact_id, bare_data) VALUES(@contact_id, @bare_data)";
comm.Parameters.AddWithValue("@contact_id", bareData.ContactId);
comm.Parameters.AddWithValue("@bare_data", bareData.BareData);
comm.ExecuteNonQuery();
SQLiteCommand lastIdComm = connection.CreateCommand();
lastIdComm.CommandText = "SELECT last_insert_rowid()";
res = Int32.Parse(lastIdComm.ExecuteScalar().ToString());;
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
}
//close connection
this.CloseConnection();
return res;
}
return -1;
}
public int AddContactBareData(ContactBareDataDB bareData)
{
DBManager db = new DBManager();
return db.AddContactBareData(bareData);
}