internal static void Create(Models.Transaction Transaction)
{
database.NewExecute(
"INSERT INTO transaction (`GUID`,`Type`,`userId`) VALUES (@Guid,@Type,@uId)",
new SQL().ParameterRange("@Guid", "@Type", "@uId"),
new SQL().ValuesRange(Transaction.TransationGUId, Transaction.TransationType, API.Staff.Id)
);
}
public static Models.Transaction FormatTransaction(MySqlDataReader reader)
{
Models.Transaction Transaction = null;
while (reader.Read())
{
Transaction = new Models.Transaction
{
TransactionId = reader.GetString("Id"),
TransationDate = reader["date_stamp"].ToString(),
TransationGUId = reader["GUID"].ToString(),
TransationType = reader.GetInt32("Type")
};
}
reader.Close();
return(Transaction);
}