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));
}
