protected void getIDPSTypeData()
{
List <idstype> lstIDPSType = new List <idstype>();
idstypeBus oIDPSType = new idstypeBus();
lstIDPSType = oIDPSType.idstypeGetAll();
if (lstIDPSType.Count > 0)
{
ddlIDPSType.DataSource = lstIDPSType;
ddlIDPSType.DataValueField = "idsTypeId";
ddlIDPSType.DataTextField = "idsTypeName";
ddlIDPSType.DataBind();
}
}
protected void getIDPSData()
{
DataTable dttIDPS = new DataTable();
dttIDPS.Columns.Add(new DataColumn("idsId", System.Type.GetType("System.Int32")));
dttIDPS.Columns.Add(new DataColumn("idsName", System.Type.GetType("System.String")));
dttIDPS.Columns.Add(new DataColumn("idsversion", System.Type.GetType("System.String")));
dttIDPS.Columns.Add(new DataColumn("idsTypeId", System.Type.GetType("System.Int32")));
dttIDPS.Columns.Add(new DataColumn("idsTypeDesc", System.Type.GetType("System.String")));
dttIDPS.Columns.Add(new DataColumn("databaseTypeId", System.Type.GetType("System.Int32")));
dttIDPS.Columns.Add(new DataColumn("databaseTypeDesc", System.Type.GetType("System.String")));
dttIDPS.Columns.Add(new DataColumn("idsIP", System.Type.GetType("System.String")));
dttIDPS.Columns.Add(new DataColumn("active", System.Type.GetType("System.Boolean")));
List <ids> lstIDPS = new List <ids>();
idsBus oIDPS = new idsBus();
idstype auxIDPSType = new idstype();
idstypeBus oIDPSType = new idstypeBus();
databasestype auxDatabaseType = new databasestype();
databasestypeBus oDatabaseType = new databasestypeBus();
lstIDPS = oIDPS.idsGetAll();
if (lstIDPS.Count > 0)
{
foreach (ids row in lstIDPS)
{
auxIDPSType = oIDPSType.idstypeGetById(row.IdsTypeId);
auxDatabaseType = oDatabaseType.databasestypeGetById(row.DatabaseTypeId);
dttIDPS.Rows.Add(row.IdsId,
row.idsName,
row.IdsVersion,
row.IdsTypeId,
auxIDPSType.IdsTypeName,
row.DatabaseTypeId,
auxDatabaseType.DatabaseName,
row.IdsIP,
row.Active);
}
gvIDPS.DataSource = dttIDPS;
gvIDPS.DataBind();
}
}