public List<databasestype> databasestypeGetAll() { List<databasestype> lstdatabasestype = new List<databasestype>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "databasestypeGetAll").Tables[0]; if (dt.Rows.Count > 0) { int colDatabaseTypeId = dt.Columns["DatabaseTypeId"].Ordinal; int colDatabaseName = dt.Columns["DatabaseName"].Ordinal; for (int i = 0; dt.Rows.Count > i; i++) { databasestype NewEnt = new databasestype(); NewEnt.DatabaseTypeId = Int32.Parse(dt.Rows[i].ItemArray[colDatabaseTypeId].ToString()); NewEnt.DatabaseName = dt.Rows[i].ItemArray[colDatabaseName].ToString(); lstdatabasestype.Add(NewEnt); } } return lstdatabasestype; } catch(Exception ex) { throw ex; } }
public int databasestypeAdd(databasestype databasestype) { try { return (int)SqlHelper.ExecuteScalar(SqlImplHelper.getConnectionString(), "databasestypeAdd", databasestype.DatabaseName); } catch(Exception ex) { throw ex; } }
public databasestype databasestypeGetById(int DatabaseTypeId) { try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "databasestypeGetById", DatabaseTypeId).Tables[0]; databasestype NewEnt = new databasestype(); if(dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; NewEnt.DatabaseTypeId = Int32.Parse(dr["DatabaseTypeId"].ToString()); NewEnt.DatabaseName = dr["DatabaseName"].ToString(); } return NewEnt; } catch(Exception ex) { throw ex; } }
public bool databasestypeUpdate(databasestype databasestype) { databasestypeImpl odatabasestypeImpl = new databasestypeImpl(); return odatabasestypeImpl.databasestypeUpdate( databasestype); }
public int databasestypeAdd(databasestype databasestype) { databasestypeImpl odatabasestypeImpl = new databasestypeImpl(); return odatabasestypeImpl.databasestypeAdd( databasestype); }
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(); } }
public bool databasestypeUpdate(databasestype databasestype) { try { int update = SqlHelper.ExecuteNonQuery(SqlImplHelper.getConnectionString(), "databasestypeUpdate", databasestype.DatabaseTypeId, databasestype.DatabaseName); if (update > 0) { return true; } else { return false; } } catch(Exception ex) { throw ex; } }