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