public void InsertClass(Type t, object instance) { var collumns = ClassReader.FieldNames(t); var values = ClassReader.ValuesList(t, instance); var sb = new StringBuilder(); var sb2 = new StringBuilder(); foreach (string collumn in collumns) { sb.Append(collumn + ","); } sb.Remove(sb.Length - 1, 1); foreach (string value in values) { if (value == "") { sb2.Append("'0'" + ","); } else { sb2.Append("'" + value + "'" + ","); } } sb2.Remove(sb2.Length - 1, 1); var tablename = t.GetCustomAttributes(true).OfType <TableName>().First().value; string query = String.Format("INSERT INTO {0} ({1}) VALUES({2})", tablename, sb.ToString(), sb2.ToString()); database.CustomQuery(query); }
public BankDetails GetAccount(string accountNumber, string pinHash) { return(BankDetails.LoadAccount(database.QueryToDictionary(String.Format("select * from bankdetails where bank_rekeningnummer = '{0}' AND pin = '{1}'", accountNumber, pinHash), ClassReader.ClassToDictionary(typeof(BankDetails))))); }
public static List <Transaction> GetLatestTransactions(int accountID) { return(GetTransactions(database.QueryToDictionaries($"select * from (select * from transacties where bank_nummer_id={accountID} ORDER BY DATE(datum) DESC) sub ORDER BY datum DESC LIMIT 3", ClassReader.ClassToDictionary(typeof(Transaction))))); }
public List <Transaction> GetLatestTransactions(int accountID) { return(Transaction.GetTransactions(database.QueryToDictionaries("select * from (select * from transacties ORDER BY DATE(datum) DESC) sub ORDER BY datum DESC LIMIT 3", ClassReader.ClassToDictionary(typeof(Transaction))))); }