public static Option <int> SelectIDENTITY(OleDbConnection connection, OleDbTransaction transaction)
{
var selectCommand = new OleDbCommand("SELECT @@IDENTITY", connection);
selectCommand.Transaction = transaction;
return(selectCommand.OptionalExecuteScalar <int>().getOptRight());
}
private Option <int> SelectPlanData(OleDbTransaction transaction, String target, String where)
{
var tableName = "`plan`";
var order = $"SELECT `{target}` FROM {tableName} WHERE {where}";
var command = new OleDbCommand(order, Connection);
command.Transaction = transaction;
return(command.OptionalExecuteScalar <int>().getOptRight());
}
private Option <int> SelectPlanId(OleDbTransaction transaction, Plan.Recode plan)
{
var tableName = "`plan`";
var where = $"`requester` = '{plan.Requester}' and `date` = #{plan.Date}# and `time` = '{plan.Time}'";
var order = $"SELECT `id` FROM {tableName} WHERE {where}";
var command = new OleDbCommand(order, Connection);
command.Transaction = transaction;
Console.WriteLine(order);
return(command.OptionalExecuteScalar <int>().getOptRight());
}
