public void InsertOrUpdateData(_DefaultModel data)
{
ConnectDB();
sqlite_cmd.CommandText = data.CreateTable();
sqlite_cmd.ExecuteNonQuery();
sqlite_cmd.CommandText = data.InsertOrUpdateValue();
sqlite_cmd.ExecuteNonQuery();
sqlite_connect.Close();
}
public void RemoveData(_DefaultModel data)
{
ConnectDB();
try
{
sqlite_cmd.CommandText = "DELETE FROM '" + data.TableName() + "' WHERE ID = " + data.ID;
sqlite_cmd.ExecuteNonQuery();
sqlite_cmd.CommandText = "SELECT count(*) FROM '" + data.TableName() + "'";
var count = Int32.Parse(sqlite_cmd.ExecuteScalar().ToString());
if (count == 0)
{
sqlite_cmd.CommandText = "DROP TABLE '" + data.TableName() + "'";
sqlite_cmd.ExecuteNonQuery();
}
}
catch { }
sqlite_connect.Close();
}
public _DefaultModel GetNewestData(String tableName, Type type)
{
ConnectDB();
try
{
sqlite_cmd.CommandText = "select* from '" + tableName + "' order by id desc limit 0,1"; //select table
SQLiteDataReader sqlite_datareader = sqlite_cmd.ExecuteReader();
_DefaultModel temp = (_DefaultModel)Activator.CreateInstance(type);
while (sqlite_datareader.Read())
{
temp = (_DefaultModel)Activator.CreateInstance(type, sqlite_datareader);
}
sqlite_connect.Close();
return(temp);
}
catch
{
sqlite_connect.Close();
return(null);
}
}
