public SupplyRequestState GetState(RestaurantDatabaseSettings ctx, int supplyRequestStateId)
{
SupplyRequestState result = null;
using (OracleConnection conn = new OracleConnection(ctx.ConnectionString))
{
string query = $"SELECT " +
$"{SupplyRequestState.ColumnNames.Id}, " +
$"{SupplyRequestState.ColumnNames.Description} " +
$"FROM {SupplyRequestState.TableName} sr " +
$"WHERE {SupplyRequestState.ColumnNames.Id} = {supplyRequestStateId}";
OracleCommand cmd = new OracleCommand(query, conn);
conn.Open();
OracleDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
result = new SupplyRequestState()
{
Id = Convert.ToInt32(reader[$"{SupplyRequestState.ColumnNames.Id}"]),
Description = reader[$"{SupplyRequestState.ColumnNames.Description}"]?.ToString()
};
}
reader.Dispose();
}
return(result);
}
public SupplyRequest()
{
State = SupplyRequestState.New;
}
