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