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