private TreeNode p3Nodes(P3Object p3)
{
string p3Name = string.Format("{0}: {1}", p3.Type.Value, p3.Name);
TreeNode ret = new TreeNode(p3Name);
List <PIObject> l = p3.GetComponents();
foreach (PIObject p in l)
{
P2Object pi = (P2Object)p;
TreeNode t = p2Nodes(pi);
ret.Nodes.Add(t);
}
return(ret);
}
private TreeNode p3Nodes(P3Object p3)
{
string p3Name = string.Format("{0}: {1}", p3.Type.Value, p3.Name);
TreeNode ret = new TreeNode(p3Name);
List<PIObject> l = p3.GetComponents();
foreach (PIObject p in l)
{
P2Object pi = (P2Object)p;
TreeNode t = p2Nodes(pi);
ret.Nodes.Add(t);
}
return (ret);
}
private List <P3Object> GetP3ComponentsByP4ID(int id)
{
List <P3Object> ret = new List <P3Object>();
using (SQLiteCommand comm = connection.CreateCommand())
{
comm.CommandText = DBConstants.P4_GET_P3_COMPONENTS_BY_ID_PREPARED_STATEMENT_STRING;
comm.Parameters.AddWithValue("@id", id);
comm.Prepare();
SQLiteDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
int idColumn = reader.GetOrdinal(DBConstants.P3_ID_FIELD);
int idValue = (reader.IsDBNull(idColumn)) ? -1 : reader.GetInt32(idColumn);
P3Object obj = GetP3ByID(idValue);
ret.Add(obj);
}
reader.Close();
reader = null;
}
return(ret);
}
public List <P3Object> GetAllP3Objects()
{
List <P3Object> ret = new List <P3Object>();
using (SQLiteCommand comm = connection.CreateCommand())
{
comm.CommandText = DBConstants.P3_GET_ALL_PREPARED_STATEMENT_STRING;
SQLiteDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
int idColumn = reader.GetOrdinal(DBConstants.ID_FIELD);
int nameColumn = reader.GetOrdinal(DBConstants.NAME_FIELD);
int idValue = (reader.IsDBNull(idColumn)) ? -1 : reader.GetInt32(idColumn);
string nameValue = (reader.IsDBNull(nameColumn)) ? string.Empty : reader.GetString(nameColumn);
P3Object obj = new P3Object(idValue, nameValue, PIObject.ObjectType.P3);
ret.Add(obj);
}
reader.Close();
reader = null;
}
return(ret);
}
private TreeNode p4Nodes(P4Object p4)
{
string p4Name = string.Format("{0}: {1}", p4.Type.Value, p4.Name);
TreeNode ret = new TreeNode(p4Name);
List <PIObject> l = p4.GetComponents();
foreach (PIObject p in l)
{
if (p.Type.Value == PIObject.ObjectType.P3.Value)
{
P3Object pi = (P3Object)p;
TreeNode t = p3Nodes(pi);
ret.Nodes.Add(t);
}
if (p.Type.Value == PIObject.ObjectType.P1.Value)
{
P1Object pi = (P1Object)p;
TreeNode t = p1Nodes(pi);
ret.Nodes.Add(t);
}
}
return(ret);
}
public P3Object GetP3ByID(int id)
{
P3Object ret = null;
using (SQLiteCommand comm = connection.CreateCommand())
{
comm.CommandText = DBConstants.P3_GET_BY_ID_PREPARED_STATEMENT_STRING;
comm.Parameters.AddWithValue("@id", id);
SQLiteDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
int idColumn = reader.GetOrdinal(DBConstants.ID_FIELD);
int nameColumn = reader.GetOrdinal(DBConstants.NAME_FIELD);
int idValue = (reader.IsDBNull(idColumn)) ? -1 : reader.GetInt32(idColumn);
string nameValue = (reader.IsDBNull(nameColumn)) ? string.Empty : reader.GetString(nameColumn);
ret = new P3Object(idValue, nameValue, PIObject.ObjectType.P3);
break;
}
reader.Close();
reader = null;
}
return(ret);
}
public List<P3Object> GetAllP3Objects()
{
List<P3Object> ret = new List<P3Object>();
using (SQLiteCommand comm = connection.CreateCommand())
{
comm.CommandText = DBConstants.P3_GET_ALL_PREPARED_STATEMENT_STRING;
SQLiteDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
int idColumn = reader.GetOrdinal(DBConstants.ID_FIELD);
int nameColumn = reader.GetOrdinal(DBConstants.NAME_FIELD);
int idValue = (reader.IsDBNull(idColumn)) ? -1 : reader.GetInt32(idColumn);
string nameValue = (reader.IsDBNull(nameColumn)) ? string.Empty : reader.GetString(nameColumn);
P3Object obj = new P3Object(idValue, nameValue, PIObject.ObjectType.P3);
ret.Add(obj);
}
reader.Close();
reader = null;
}
return (ret);
}
public P3Object GetP3ByName(string name)
{
P3Object ret = null;
using (SQLiteCommand comm = connection.CreateCommand())
{
comm.CommandText = DBConstants.P3_GET_BY_NAME_PREPARED_STATEMENT_STRING;
comm.Parameters.AddWithValue("@name", name);
SQLiteDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
int idColumn = reader.GetOrdinal(DBConstants.ID_FIELD);
int nameColumn = reader.GetOrdinal(DBConstants.NAME_FIELD);
int idValue = (reader.IsDBNull(idColumn)) ? -1 : reader.GetInt32(idColumn);
string nameValue = (reader.IsDBNull(nameColumn)) ? string.Empty : reader.GetString(nameColumn);
ret = new P3Object(idValue, nameValue, PIObject.ObjectType.P3);
break;
}
reader.Close();
reader = null;
}
return (ret);
}
