private Option <int> DeletePlanRecode(OleDbTransaction transaction, int id)
{
var tableName = "`plan`";
var orderText =
$"DELETE FROM {tableName}"
+ $"WHERE `id` = {id}";
var command = new OleDbCommand(orderText, Connection);
command.Transaction = transaction;
return(command.OptionalExecuteNonQuery().getOptRight());
}
private Option <int> Update(OleDbTransaction transaction, int id, Plan.Recode recode)
{
var tableName = "`plan`";
var orderText =
$" UPDATE {tableName}"
+ $" SET `date` = #{recode.Date}#, `time` = '{recode.Time}'"
+ $" WHERE `id` = {id}";
var command = new OleDbCommand(orderText, Connection);
command.Transaction = transaction;
return(command.OptionalExecuteNonQuery().getOptRight());
}
private Option <int> InsertRestPlan(OleDbTransaction transaction, Plan.Recode restPlan)
{
var tableName = "`plan`";
var rows = "`requester`, `date`, `time`, `type`";
var values = $"'{restPlan.Requester}', #{restPlan.Date}#, '{restPlan.Time}', 'rest'";
var order = $"INSERT INTO {tableName}({rows}) VALUES ({values})";
var command = new OleDbCommand(order, Connection);
command.Transaction = transaction;
var result = command.OptionalExecuteNonQuery();
if (result.isLeft())
{
return(new None <int>());
}
return(OleDbExtension.SelectIDENTITY(Connection, transaction));
}
