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