public async Task <IActionResult> GetJobInfo([FromRoute] int id, [FromRoute] string name) { CustomConnection obj = new CustomConnection(id, name); //hard coded the server id IEnumerable <JobInfo> result = obj.ConnectJobs(); if (result == null) { return(NotFound()); } return(Ok(result)); }
public async Task <IActionResult> Gettable([FromRoute] int serverid, [FromRoute] int dbid) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var servername = from d in _context.servers where d.Server_ID == serverid select d; var reqservername = ""; foreach (var d in servername) { reqservername = d.Server_Name; } var reqdbname = ""; var dbname = from d in _context.databases where d.database_id == dbid select d; foreach (var d in dbname) { reqdbname = d.name; } //IEnumerable<table> result = from d in _context.tables // //where d.Database_Id == id // select d; CustomConnection obj = new CustomConnection(serverid, reqservername); IEnumerable <tableInfo> result = obj.ConnectTables(dbid); //IEnumerable<tableInfo> result = CustomConnectionForTables.ExecuteReader(reqservername, reqdbname, "sys.tables", serverid); if (result == null) { return(NotFound()); } return(Ok(result)); }
public async Task <IActionResult> ExecuteJob([FromRoute] int id, [FromRoute] string jobName, [FromRoute] int x) { var servername = from d in _context.servers where d.Server_ID == id select d; var ServerName = ""; foreach (var d in servername) { ServerName = d.Server_Name; } CustomConnection obj = new CustomConnection(id, ServerName); //hard coded the server id IEnumerable <JobInfo> result = obj.ExecuteJob(jobName); return(Ok("Return Statement")); }
public async Task <IActionResult> PoststgSAPPurgeTableList([FromBody] stgSAPPurgeTableList[] stgSAPPurgeTableList) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } for (int i = 0; i < stgSAPPurgeTableList.Length; i++) { _context.stgSAPPurgeTableList.Add(stgSAPPurgeTableList[i]); } //await _context.SaveChangesAsync(); _context.SaveChanges(); CustomConnection obj = new CustomConnection(); //hard coded the server id IEnumerable <JobInfo> result = obj.DeployAll(); return(CreatedAtAction("GetstgSAPPurgeTableList", new { id = stgSAPPurgeTableList[0].TableID }, stgSAPPurgeTableList)); }
public async Task <IActionResult> GetDatabase_Info([FromRoute] int id) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var servername = from d in _context.servers where d.Server_ID == id select d; var ServerName = ""; foreach (var d in servername) { ServerName = d.Server_Name; } // CustomConnection.CreateConnection(ans,"master","vwsysdatabases"); /* IEnumerable<db> result = from d in _context.databases * where d.Server_Id == id && d.Database_Name!= "Instrumentation" * select d; * */ CustomConnection obj = new CustomConnection(id, ServerName); IEnumerable <DbInfo> result = obj.ConnectDB(); //ConnectServer(Server_Info.Server_Name,result.Database_Name) if (result == null) { return(NotFound()); } return(Ok(result)); }