internal static void Create(Models.TransactionDescription TransactionDescription) { database.NewExecute( "INSERT INTO description (`Description`,`CreditAccount`,`DebitAccount`,`GUID`) VALUES (@d,@ca,@da,@g)" , new SQL().ParameterRange("@d", "@ca", "@da", "@g") , new SQL().ValuesRange(TransactionDescription.Description, TransactionDescription.CreditAccount.Number, TransactionDescription.DebitAccount.Number, TransactionDescription.GUID)); }
public static Models.TransactionDescription FormatTransactionDescription(MySqlDataReader reader) { Models.TransactionDescription Td = null; while (reader.Read()) { Td = new Models.TransactionDescription { Id = reader["Id"].ToString(), GUID = reader["Guid"].ToString(), Description = reader["Description"].ToString(), DateStamp = reader.GetDateTime("date_stamp"), CreditAccount = new Account { Number = reader["CreditAccount"].ToString() }, DebitAccount = new Account { Number = reader["DebitAccount"].ToString() } }; } reader.Close(); return(Td); }