public ActionResult Delete(TransferParameters transferParameters)
{
ConnectParameters connector = Common.GetConnectParameters(connectionString, container,
transferParameters.TargetName);
DbUtilities dbConn = new DbUtilities();
string table = transferParameters.Table;
try
{
dbConn.OpenConnection(connector);
if (String.IsNullOrEmpty(table))
{
return(BadRequest());
}
dbConn.DBDelete(table);
}
catch (Exception)
{
return(BadRequest());
}
string message = $"{table} has been cleared";
dbConn.CloseConnection();
return(Ok(message));
}
private void CreateStoredProcedures(ConnectParameters connector)
{
try
{
string contentRootPath = _env.ContentRootPath;
string sqlFile = contentRootPath + @"\DataBase\StoredProcedures.sql";
string sql = System.IO.File.ReadAllText(sqlFile);
string[] commandText = sql.Split(new string[] { String.Format("{0}GO{0}", Environment.NewLine) }, StringSplitOptions.RemoveEmptyEntries);
DbUtilities dbConn = new DbUtilities();
dbConn.OpenConnection(connector);
for (int x = 0; x < commandText.Length; x++)
{
if (commandText[x].Trim().Length > 0)
{
dbConn.SQLExecute(commandText[x]);
}
}
CreateInsertStoredProcedure(dbConn);
CreateUpdateStoredProcedure(dbConn);
dbConn.CloseConnection();
}
catch (Exception ex)
{
Exception error = new Exception("Create DMS Model Error: ", ex);
throw error;
}
}
private void CreatePPDMModel(DataModelParameters dmParameters, ConnectParameters connector)
{
try
{
CloudStorageAccount account = CloudStorageAccount.Parse(connectionString);
CloudFileClient fileClient = account.CreateCloudFileClient();
CloudFileShare share = fileClient.GetShareReference(dmParameters.FileShare);
if (share.Exists())
{
CloudFileDirectory rootDir = share.GetRootDirectoryReference();
CloudFile file = rootDir.GetFileReference(dmParameters.FileName);
if (file.Exists())
{
string sql = file.DownloadTextAsync().Result;
DbUtilities dbConn = new DbUtilities();
dbConn.OpenConnection(connector);
dbConn.SQLExecute(sql);
dbConn.CloseConnection();
}
}
}
catch (Exception ex)
{
Exception error = new Exception("Create PPDM Model Error: ", ex);
throw error;
}
}
public void DeleteTables()
{
try
{
string info = "";
_dbConn.OpenWithConnectionString(target);
foreach (string tableName in DatabaseTables.Names)
{
info = $"Deleting table {tableName}";
_logger.LogInformation(info);
_queueService.InsertMessage(infoQueue, info);
_dbConn.DBDelete(tableName);
}
}
catch (Exception ex)
{
_logger.LogInformation($"Error deleting tables {ex.ToString()}");
}
finally
{
_dbConn.CloseConnection();
}
}
private void CreateDMSModel(ConnectParameters connector)
{
try
{
string contentRootPath = _env.ContentRootPath;
string sqlFile = contentRootPath + @"\DataBase\DataScienceManagement.sql";
string sql = System.IO.File.ReadAllText(sqlFile);
DbUtilities dbConn = new DbUtilities();
dbConn.OpenConnection(connector);
dbConn.SQLExecute(sql);
dbConn.CloseConnection();
}
catch (Exception ex)
{
Exception error = new Exception("Create DMS Model Error: ", ex);
throw error;
}
}
public async Task <ActionResult <List <DmsIndex> > > Get(string source)
{
ConnectParameters connector = Common.GetConnectParameters(connectionString, container, source);
if (connector == null)
{
return(BadRequest());
}
DbUtilities dbConn = new DbUtilities();
List <DmsIndex> index = new List <DmsIndex>();
try
{
dbConn.OpenConnection(connector);
DbQueries dbq = new DbQueries();
string select = dbq["Index"];
string query = " where INDEXLEVEL = 1";
DataTable dt = dbConn.GetDataTable(select, query);
foreach (DataRow qcRow in dt.Rows)
{
string dataType = qcRow["Dataname"].ToString();
string indexNode = qcRow["Text_IndexNode"].ToString();
int indexId = Convert.ToInt32(qcRow["INDEXID"]);
string strProcedure = $"EXEC spGetDescendants '{indexNode}'";
query = "";
DataTable qc = dbConn.GetDataTable(strProcedure, query);
int nrOfObjects = qc.Rows.Count - 1;
index.Add(new DmsIndex()
{
Id = indexId,
DataType = dataType,
NumberOfDataObjects = nrOfObjects
});
}
}
catch (Exception)
{
return(BadRequest());
}
dbConn.CloseConnection();
return(index);
}
private void DeleteProjectTables(string cnStr)
{
string table;
Trace.TraceInformation("DeleteProjectTables: Start ");
DbUtilities dbConn = new DbUtilities();
dbConn.OpenConnection(cnStr);
//Delete tables in destination
//table = "WELL_LOG_CURVE_VALUE";
//dbConn.DBDelete(table);
//Clients.Caller.sendMessage("2%", "2%");
//table = "WELL_LOG_CURVE";
//dbConn.DBDelete(table);
//Clients.Caller.sendMessage("3%", "3%");
//table = "STRAT_WELL_SECTION";
//dbConn.DBDelete(table);
//Clients.Caller.sendMessage("4%", "4%");
//table = "STRAT_UNIT";
//dbConn.DBDelete(table);
//table = "STRAT_NAME_SET";
//dbConn.DBDelete(table);
//Clients.Caller.sendMessage("5%", "5%");
//table = "WELL";
//dbConn.DBDelete(table);
//table = "BUSINESS_ASSOCIATE";
//dbConn.DBDelete(table);
//table = "FIELD";
//dbConn.DBDelete(table);
//table = "R_WELL_DATUM_TYPE";
//dbConn.DBDelete(table);
//table = "R_WELL_STATUS";
//dbConn.DBDelete(table);
//Clients.Caller.sendMessage("9%", "9%");
dbConn.CloseConnection();
Trace.TraceInformation("DeleteProjectTables: End ");
}
public async Task <ActionResult <string> > GetChildren(string source, int id)
{
ConnectParameters connector = Common.GetConnectParameters(connectionString, container, source);
if (connector == null)
{
return(BadRequest());
}
DbUtilities dbConn = new DbUtilities();
dbConn.OpenConnection(connector);
DbQueries dbq = new DbQueries();
string select = dbq["Index"];
string query = $" where INDEXID = {id}";
DataTable dt = dbConn.GetDataTable(select, query);
if (dt.Rows.Count == 0)
{
return(NotFound());
}
string dataType = dt.Rows[0]["DATATYPE"].ToString();
string indexNode = dt.Rows[0]["Text_IndexNode"].ToString();
int indexLevel = Convert.ToInt32(dt.Rows[0]["INDEXLEVEL"]) + 1;
query = $" WHERE IndexNode.IsDescendantOf('{indexNode}') = 1 and INDEXLEVEL = {indexLevel}";
DataTable idx = dbConn.GetDataTable(select, query);
string result = "[]";
if (idx.Rows.Count > 0)
{
result = ProcessAllChildren(dbConn, idx);
}
dbConn.CloseConnection();
return(result);
}
public void CloseConnection()
{
dbConn.CloseConnection();
}
