public void ModifyCorsec(GetUpdateDmtValueInputDto input)
{
////Modify Key
//var webConfigApp = WebConfigurationManager.OpenWebConfiguration("~");
//webConfigApp.AppSettings.Settings["queryCorsec"].Value = input.query;
//webConfigApp.Save();
//ConfigurationManager.RefreshSection("appSettings");
////Modify ConnString
//var connectionStringsSection = (ConnectionStringsSection)webConfigApp.GetSection("connectionStrings");
//connectionStringsSection.ConnectionStrings["ModifyWebConfigCorsec"].ConnectionString = "Data Source=" + input.serverName + ";Initial Catalog=" + input.dbName + ";User ID=" + input.credentialUser + ";password="******";";
//webConfigApp.Save();
//ConfigurationManager.RefreshSection("connectionStrings");
}
public void ModifyDMT(GetUpdateDmtValueInputDto input)
{
//Modify Key
var appsettingsjson = JObject.Parse(File.ReadAllText("appsettings.json"));
var webConfigApp = (JObject)appsettingsjson["App"];
webConfigApp.Property("queryDMT").Value = input.query;
////var webConfigApp = WebConfigurationManager.OpenWebConfiguration("~");
////webConfigApp.AppSettings.Settings["queryDMT"].Value = input.query;
//webConfigApp.Save();
//ConfigurationManager.RefreshSection("appSettings");
////Modify ConnString
//var connectionStringsSection = (ConnectionStringsSection)webConfigApp.GetSection("connectionStrings");
//connectionStringsSection.ConnectionStrings["ModifyWebConfigDMT"].ConnectionString = "Data Source=" + input.serverName + ";Initial Catalog=" + input.dbName + ";User ID=" + input.credentialUser + ";password="******";";
//webConfigApp.Save();
//ConfigurationManager.RefreshSection("connectionStrings");
}
public GetUpdateDmtValueInputDto GetCorsec()
{
GetUpdateDmtValueInputDto data = new GetUpdateDmtValueInputDto();
var appsettingsjson = JObject.Parse(File.ReadAllText("appsettings.json"));
var webConfigApp = (JObject)appsettingsjson["App"];
var queryCorsec = webConfigApp.Property("queryCorsec").Value.ToString();
data.query = queryCorsec;
var connectionStringsSection = (JObject)appsettingsjson["ConnectionStrings"];
var connString = connectionStringsSection.Property("ModifyWebConfigCorsec").Value.ToString();
//var webConfigApp = WebConfigurationManager.OpenWebConfiguration("~");
//var queryCorsec = webConfigApp.AppSettings.Settings["queryCorsec"].Value;
//data.query = queryCorsec;
//var connectionStringsSection = (ConnectionStringsSection)webConfigApp.GetSection("connectionStrings");
//var connString = connectionStringsSection.ConnectionStrings["ModifyWebConfigCorsec"].ToString();
if (connString != "" && connString != null)
{
string serverName = null;
string dbName = null;
string credentialUser = null;
string credentialPass = null;
string pwd = "password="******"Data Source=";
string initialCatalog = "Initial Catalog=";
string userID = "User ID=";
string password = pwd;
//start index
int iServerName = connString.IndexOf(dataSource);
int iInitialCatalog = connString.IndexOf(initialCatalog);
int iUserID = connString.IndexOf(userID);
int iPassword = connString.IndexOf(password);
//end index
int eServerName = connString.IndexOf(";", iServerName);
int eInitialCatalog = connString.IndexOf(";", iInitialCatalog);
int eUserID = connString.IndexOf(";", iUserID);
int ePassword = connString.IndexOf(";", iPassword);
serverName = connString.Substring(iServerName, eServerName - iServerName);
dbName = connString.Substring(iInitialCatalog, eInitialCatalog - iInitialCatalog);
credentialUser = connString.Substring(iUserID, eUserID - iUserID);
credentialPass = connString.Substring(iPassword, ePassword - iPassword);
serverName = serverName.Substring(dataSource.Length);
dbName = dbName.Substring(initialCatalog.Length);
credentialUser = credentialUser.Substring(userID.Length);
credentialPass = credentialPass.Substring(password.Length);
data = new GetUpdateDmtValueInputDto
{
query = queryCorsec,
credentialUser = credentialUser,
credentialPass = credentialPass,
serverName = serverName,
dbName = dbName
};
}
return(data);
}
