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