public static List <Plant> ReadPlantData()
{
var allPlants = new List <Plant>();
//const string connectionString = "";
//var queryString = "SELECT EmpNo, EName FROM Emp";
//using (var connection = new OracleConnection(connectionString))
//{
// var command = new OracleCommand(queryString, connection);
// connection.Open();
// using (var reader = command.ExecuteReader())
// {
// // Always call Read before accessing data.
// while (reader.Read())
// {
// Console.WriteLine(reader.GetInt32(0) + ", " + reader.GetString(1));
// }
// }
//}
var reader = DataReaderGenerator.Plants();
while (reader.Read())
{
var plant = new Plant();
plant.Name = reader["name"] as string;
plant.ID = reader["id"] as string;
plant.Description = reader["desc"] as string;
allPlants.Add(plant);
}
return(allPlants);
}
public static List <Unit> ReadUnitData()
{
var allUnits = new List <Unit>();
var reader = DataReaderGenerator.Units();
while (reader.Read())
{
var unit = new Unit();
unit.Name = reader["name"] as string;
unit.ID = reader["id"] as string;
unit.Description = reader["desc"] as string;
unit.AreaId = reader["area_id"] as string;
allUnits.Add(unit);
}
return(allUnits);
}
internal static List <Tag> ReadTagData()
{
var allTags = new List <Tag>();
var reader = DataReaderGenerator.Tags();
while (reader.Read())
{
var tag = new Tag();
tag.Name = reader["name"] as string;
tag.ID = reader["id"] as string;
tag.Description = reader["desc"] as string;
tag.UnitId = reader["unit_id"] as string;
allTags.Add(tag);
}
return(allTags);
}
public static List <Area> ReadAreaData()
{
var allAreas = new List <Area>();
var reader = DataReaderGenerator.Areas();
while (reader.Read())
{
var area = new Area();
area.Name = reader["name"] as string;
area.ID = reader["id"] as string;
area.Description = reader["desc"] as string;
area.PlantId = reader["plant_id"] as string;
allAreas.Add(area);
}
return(allAreas);
}
public static List <DMSVersion> ReadDocData()
{
var dmsVersions = new List <DMSVersion>();
var reader = DataReaderGenerator.Docs();
while (reader.Read())
{
var dmsVersion = new DMSVersion();
dmsVersion.Name = reader["name"] as string;
dmsVersion.ID = reader["id"] as string;
dmsVersion.Description = reader["desc"] as string;
dmsVersion.UnitId = reader["unit_id"] as string;
dmsVersion.TagId = reader["tag_id"] as string;
dmsVersions.Add(dmsVersion);
}
return(dmsVersions);
}