public static void DeleteItemFromDatabase(Object obj) { string query = QueryGenerator.GenerateDeleteQuery(obj.GetType()); Dictionary <string, string> parameters = QueryGenerator.GetValuesInADictionary(obj); dbWrapper.ExecuteCommand(query, parameters); }
public static void UpdateItem(Object oldObject, Object newObject) { if (oldObject.GetType() != newObject.GetType()) { throw new AttributeException("The type of the current object and the new object doesn't match"); } string query = QueryGenerator.GenerateUpdateQuery(oldObject.GetType()); Dictionary <string, string> parameters = QueryGenerator.GetValuesInADictionary(oldObject, newObject); dbWrapper.ExecuteCommand(query, parameters); }
public static void AddData(Object obj) { try { QueryGenerator.ProcessOneToManyInsert(obj); string query = QueryGenerator.GenerateInsertQuery(obj.GetType()); Dictionary <string, string> parameters = QueryGenerator.GetValuesInADictionary(obj); dbWrapper.ExecuteCommand(query, parameters); }catch (SQLiteException e) { throw new AttributeException("A row containing the same data already exists " + e.Message); } }