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