public IEnumerable <TeamList> Get() { DBtools dbt = new DBtools(); return(dbt.GetDataTeamList()); //return new string[] { "value1", "value2" }; }
protected void changeSelection(object sender, EventArgs e) { DBtools db = new DBtools(); dgvItems.DataSource = db.caricaTables(cmbTables.SelectedItem.ToString()); dgvItems.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { // lo fa eseguire sempre TRANNE la prima volta, perchè al primo giro è false, poi diventa true // ispostback è sempre falsa la prima volta if (!Page.IsPostBack) { // inizializzazioni che vengono eseguite solo la prima volta che carico la pagina // lblMessaggio.Text = "Digita username e password, poi clicca sul pulsante INVIA"; //lblMessaggio.Text = "Premi il pulsante INVIA, apparirà la lista delle nazioni gestite."; DBtools db = new DBtools(); cmbTables.DataSource = db.getTableName(); cmbTables.DataBind(); cmbTables.SelectedIndex = 0; dgvItems.DataSource = db.getTable(cmbTables.SelectedItem.ToString()); dgvItems.DataBind(); } else { // elaborazioni da eseguire tutte le volte che la pagina viene ricaricata // lblMessaggio.Text = "Benvenuto al signor " + txtUserName.Text; // riempire la lista nazioni //DBtools db=new DBtools(); //dgvItems.DataSource = db.getTable(cmbTables.SelectedIndex.ToString()); //dgvItems.DataBind(); Getcountry(""); } }
private void btnLoad_Click(object sender, System.EventArgs e) { string sql; org.swyn.foundation.utils.DBtools db = new DBtools(tdb.User.Uhelper, tdb.User.Udbcon); this.objProfileDS.Clear(); sql = String.Format("Select * from tdbadmin.mp_profil"); db.FillDs(this.objProfileDS, sql, new string[] { "mp_profil" }); }
public static void callCreateTable(string table) { DBtools d = new DBtools(); bool err = d.createTable(table + ".sql"); if (!err) { Console.WriteLine("\nCreate " + table + " - SUCCESS\n"); } else { Console.WriteLine("\n" + table + " Not Created \n"); } }
private static void restoreDatabase() { DBtools d = new DBtools(); bool err = d.restore(); if (!err) { Console.WriteLine("\nRestore Database - SUCCESS\n"); } else { Console.WriteLine("\nRestore Database - FAILURE\n"); } }
private static void backupDatabase() { DBtools d = new DBtools(); bool err = d.backup(); if (!err) { Console.WriteLine("\nBackup Database - SUCCESS\n"); } else { Console.WriteLine("\nBackup Database - FAILURE\n"); } }
private void btnUpdate_Click(object sender, System.EventArgs e) { org.swyn.foundation.utils.DBtools db = new DBtools(tdb.User.Uhelper, tdb.User.Udbcon); db.UpdDs(this.objProfileDS, "tdbadmin.tdb_insprof", new string[] { "MPID", "MPUSER", "BCHST", "SECLEVEL", "S_ID", "LAND_ID", "DLTT_ID", "DLT_ID", "KAT_ID", "DLAT_ID", "DLNT_ID", "SAI_ID", "PRG_ID", "A_ZEIT", "E_ZEIT", "P_RANGE" }, "tdbadmin.tdb_updprof", new string[] { "MPID", "MPUSER", "BCHST", "SECLEVEL", "S_ID", "LAND_ID", "DLTT_ID", "DLT_ID", "KAT_ID", "DLAT_ID", "DLNT_ID", "SAI_ID", "PRG_ID", "A_ZEIT", "E_ZEIT", "P_RANGE" }, "tdbadmin.tdb_delprof", new string[] { "MPID" }, "mp_profil"); // IDbCommand inscmd = tdb.User.Uhelper.CreateCommand(dbc, "tdbadmin.tdb_insprof", // "MPID", "MPUSER", "BCHST", "SECLEVEL", "S_ID", "LAND_ID", "DLTT_ID", "DLT_ID", "KAT_ID", "DLAT_ID", "DLNT_ID", "SAI_ID", "PRG_ID", "A_ZEIT", "E_ZEIT", "P_RANGE"); // IDbCommand updcmd = tdb.User.Uhelper.CreateCommand(dbc, "tdbadmin.tdb_updprof", // "MPID", "MPUSER", "BCHST", "SECLEVEL", "S_ID", "LAND_ID", "DLTT_ID", "DLT_ID", "KAT_ID", "DLAT_ID", "DLNT_ID", "SAI_ID", "PRG_ID", "A_ZEIT", "E_ZEIT", "P_RANGE"); // IDbCommand delcmd = tdb.User.Uhelper.CreateCommand(dbc, "tdbadmin.tdb_delprof", "MPID"); // tdb.User.Uhelper.UpdateDataset(inscmd, delcmd, updcmd, this.objProfileDS, "mp_profil"); }
protected void Page_Load(object sender, EventArgs e) { db = new DBtools(); if (!IsPostBack) { tb1.DataSource = db.GetTableList(); tb1.DataBind(); tb2.DataSource = db.GetHeaders("Country"); tb2.DataBind(); tb3.Items.Insert(0, "ASC"); tb3.Items.Insert(1, "DESC"); } GetCountry(); }
public void LoadProfile(string Auser) { dbt = new DBtools(tdb.User.Uhelper, tdb.User.Udbcon); tdb.Season sai = new tdb.Season(); tdb.Language lang = new tdb.Language(); tdb.Customer pers = new tdb.Customer(); ProfileDS prof; string sql; // load profile from DB by user name prof = new ProfileDS(); sql = String.Format("Select * from tdbadmin.mp_profil where mpuser like '{0}'", Auser); dbt.FillDS(prof, sql, new string[] { "mp_profil" }); ProfileDS.mp_profilRow Rprof = prof.mp_profil[0]; // set now the user profile data // Console.WriteLine("Prof Id {0}", Rprof.MPID); Useclevel = Rprof.SECLEVEL; Ulangid = Rprof.S_ID; if (Ulangid > 0) { Ulang = lang.GetBez(Ulangid); } else { Ulang = ""; } Uofficeid = Rprof.BCHST; if (Uofficeid > 0) { Uoffice = pers.GetBez(Uofficeid); } else { Ulang = ""; } Udlatid = Rprof.DLAT_ID; Usaiid = Rprof.SAI_ID; if (Usaiid > 0) { Usai = sai.GetBez(Usaiid); } else { Usai = ""; } }
protected void changeIndex(object sender, EventArgs e) { DBtools d = new DBtools(); if (lstTabelle.SelectedValue == "country") { dg.DataSource = d.getCountries(); } else if (lstTabelle.SelectedValue == "Teams") { dg.DataSource = d.getTeams(); } else { dg.DataSource = d.getPilot(); } dg.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //inizializzazioni che vengono eseguite sonlo la prima volta che load la page //lblMessaggio.Text = "Digita Username e Password e premi invia"; DBtools d = new DBtools(); DataTable dt = d.nameTable(); List <string> list = new List <string>(); foreach (DataRow item in dt.Rows) { list.Add((item["TABLE_NAME"]).ToString()); } lstTabelle.DataSource = list; lstTabelle.DataBind(); } else { } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { // Inizializzazioni che vengono eseguite solo la prima volta che carico la pagina // lblMessaggio.Text = "DIGITA USERNAME E PASSWORD, POI PREMI IL PULSANTE INVIA"; lbxNazioni.Visible = false; lblMessaggio.Text = "Premi il pulsante INVIA, apparirà la griglia dei team e la lista delle nazioni gestite."; GetCountry(); } else { // Elaborazioni da eseguire tutte le volte che la pagina viene ricaricata // lblMessaggio.Text = "Benvenuto al sig. " + txtUserName.Text; // Riempio la lista nazioni DBtools myTools = new DBtools(); dgvTabella.DataSource = myTools.GetDataTable("Team"); dgvTabella.DataBind(); lbxNazioni.DataSource = myTools.GetCountries(); lbxNazioni.DataBind(); lbxNazioni.Visible = true; } }
public IEnumerable <TeamDtO> GetTeamsList() { DBtools d = new DBtools(); return(d.GetTeamsList()); }
[HttpGet("id/{id}")] // GET /api/TCDtO/id/1 public TeamDtOSpecifics GetTeamSpecifics(int id) { DBtools d = new DBtools(); return(d.GetTeamSpecifics(id)); }
static void Main(string[] args) { DBTools = new DBtools(); char scelta = ' '; do { Console.WriteLine("\n*** FORMULA ONE - CONSOLE ***\n"); Console.WriteLine("1 - Create Countries"); Console.WriteLine("2 - Create Teams"); Console.WriteLine("3 - Create Drivers"); Console.WriteLine("4 - Create Circuits"); Console.WriteLine("5 - Create Races"); Console.WriteLine("6 - Create RacesPoints"); Console.WriteLine("7 - Create Scorse"); Console.WriteLine("------------------"); Console.WriteLine("B - Backup"); Console.WriteLine("T - Restore"); Console.WriteLine("R - Reset"); Console.WriteLine("------------------"); Console.WriteLine("X - EXIT\n"); scelta = Console.ReadKey(true).KeyChar; switch (scelta) { case '1': DBTools.ExecuteSqlScript("Countries.sql"); break; case '2': DBTools.ExecuteSqlScript("Teams.sql"); break; case '3': DBTools.ExecuteSqlScript("Drivers.sql"); break; case '4': DBTools.ExecuteSqlScript("Circuits.sql"); break; case '5': DBTools.ExecuteSqlScript("Races.sql"); break; case '6': DBTools.ExecuteSqlScript("RacesPoints.sql"); break; case '7': DBTools.ExecuteSqlScript("Scores.sql"); break; case 'B': Thread.Sleep(1050); DBTools.DBBackup(); break; case 'T': Thread.Sleep(1050); DBTools.DBRestore(); break; case 'R': Thread.Sleep(1050); DBTools.DBBackup(); bool OK; OK = DBTools.callDropTable("Country"); if (OK) { OK = DBTools.callDropTable("Team"); } if (OK) { OK = DBTools.callDropTable("Driver"); } //script file if (OK) { OK = DBTools.callExecuteSqlScript("countries"); } if (OK) { OK = DBTools.callExecuteSqlScript("teams"); } if (OK) { OK = DBTools.callExecuteSqlScript("drivers"); } if (OK) { Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("RESET DB OK"); Console.ForegroundColor = ConsoleColor.White; } else { DBTools.DBRestore(); } break; default: if (scelta != 'X' && scelta != 'x') { Console.WriteLine("\nUncorrect Choice - Try Again\n"); } break; } } while (scelta != 'X' && scelta != 'x'); }
public Country Get(string isoCode) { DBtools db = new DBtools(); return(db.GetCountry(isoCode)); }
public IEnumerable <RaceResults> Get() { DBtools dt = new DBtools(); return(dt.GetRaceResult()); }
public IEnumerable <RaceResults> Get(string raceId) { DBtools dt = new DBtools(); return(dt.GetRaceResult(raceId)); }
public Country Get(string id) { DBtools db = new DBtools(); return(db.GetCountryById(id)); }
public IEnumerable <Country> Get() { DBtools db = new DBtools(); return(db.GetListCountry()); }
[HttpGet("number/{number}")] // GET /api/driver/number/10 public Driver GetDriverFromNumber(int number) { DBtools d = new DBtools(); return(d.GetDriver_number(number)); }
[HttpGet("name/{name}")] // GET /api/driver/name/Lewis Hamilton public Driver GetDriverFromName(string name) { DBtools d = new DBtools(); return(d.GetDriver_name(name)); }
public IEnumerable <Driver> get_driver() { DBtools db = new DBtools(); return(db.GetDriversObj()); }
public Team Get(int id) { DBtools db = new DBtools(); return(db.GetTeamById(id)); }
public List <Driver> Get() { DBtools d = new DBtools(); return(d.getDriversObj()); }
public List <Teams> Get() { DBtools d = new DBtools(); return(d.getTeamsObj()); }
public Driver Get(string id) { DBtools d = new DBtools(); return(d.getDriver(id)); }
public Teams Get(string id) { DBtools d = new DBtools(); return(d.getTeam(id)); }
public IEnumerable <Team> Get() { DBtools db = new DBtools(); return(db.GetListTeam()); }