public void LoadConfigurations()
{
appSettings = new NameValueCollection();
connSettings = new ConnectionStringSettingsCollection();
var areaDir = new DirectoryInfo(HttpContext.Current.Server.MapPath("~/Modules"));
if(areaDir.Exists)
{
foreach(var dir in areaDir.GetDirectories())
{
var file = dir.GetFiles("web.config").FirstOrDefault();
if(file != null)
{
var config = WebConfigurationManager.OpenWebConfiguration(string.Format("/Modules/{0}/web.config", dir.Name));
var settings = config.AppSettings.Settings;
foreach(var key in settings.AllKeys)
{
appSettings.Add(string.Format("{0}.{1}", dir.Name, key), settings[key] == null ? "" : settings[key].ToString());
}
var conns = config.ConnectionStrings.ConnectionStrings;
foreach(ConnectionStringSettings conn in conns)
{
ConnectionStringSettings c = new ConnectionStringSettings(conn.Name, conn.ConnectionString, conn.ProviderName);
connSettings.Add(c);
}
}
}
}
}
/// <summary>
/// Initialize.
/// </summary>
/// <param name="name">Provider name.</param>
/// <param name="config">Config.</param>
public override void Initialize(string name, NameValueCollection config)
{
if (config == null)
throw new ArgumentNullException("config");
base.Initialize(name, config);
_connectionString = new ConnectionStringSettings(){
ConnectionString = config["connectionString"],
ProviderName = config["providerName"] ?? ""
};
if (String.IsNullOrEmpty(_connectionString.ConnectionString))
{
string connectionStringName = config["connectionStringName"];
if (connectionStringName == null || connectionStringName.Length == 0)
ThrowConnectionNameNotSpecified();
_connectionString = ConfigurationManager.ConnectionStrings[connectionStringName];
if (_connectionString == null)
ThrowConnectionStringNotFound(connectionStringName);
}
_holder = _connectionString == null || String.IsNullOrEmpty(_connectionString.ProviderName)
? SqlDbHolder.GetSqlDbHolder(SqlClientFactory.Instance, _connectionString.ConnectionString)
: SqlDbHolder.GetSqlDbHolder(_connectionString.ProviderName, _connectionString.ConnectionString);
_parser = new SqlAPQueryParser();
}
private ConnectionStringSettings Parse(ConnectionStringSettings connectionStringSettings)
{
var result = connectionStringSettings.ConnectionString;
result = ExpandEnvironmentVariables(result);
connectionStringSettings.ConnectionString = result;
return connectionStringSettings;
}
public DynamicModel(ConnectionStringSettings settings, string providerName = "System.Data.SqlClient")
{
Errors = new List<string>();
_dbProviderFactory = DbProviderFactories.GetFactory(providerName);
_connectionString = settings.ConnectionString;
}
protected virtual string BuildConnectionString(Guid streamId, ConnectionStringSettings setting)
{
if (this.shards == 0)
return setting.ConnectionString;
return setting.ConnectionString.FormatWith(this.ComputeHashKey(streamId));
}
public SqlConnectionFactory(ConnectionStringSettings connectionString)
{
if ( connectionString == null )
throw new ArgumentException("connectionString");
_connectionString = connectionString;
}
///<summary>
///更新连接字符串
///</summary>
///<param name="newName">连接字符串名称</param>
///<param name="newConString">连接字符串内容</param>
///<param name="newProviderName">数据提供程序名称</param>
private static void UpdateConnectionStringsConfig(string newName,
string newConString,
string newProviderName)
{
bool isModified = false; //记录该连接串是否已经存在
//如果要更改的连接串已经存在
if (ConfigurationManager.ConnectionStrings[newName] != null)
{
isModified = true;
}
//新建一个连接字符串实例
ConnectionStringSettings mySettings =
new ConnectionStringSettings(newName, newConString, newProviderName);
// 打开可执行的配置文件*.exe.config
Configuration config =
ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
// 如果连接串已存在，首先删除它
if (isModified)
{
config.ConnectionStrings.ConnectionStrings.Remove(newName);
}
// 将新的连接串添加到配置文件中.
config.ConnectionStrings.ConnectionStrings.Add(mySettings);
// 保存对配置文件所作的更改
config.Save(ConfigurationSaveMode.Modified);
// 强制重新载入配置文件的ConnectionStrings配置节
ConfigurationManager.RefreshSection("ConnectionStrings");
}
/// <summary>
/// Builds an instance of the concrete subtype of <see cref="T:Microsoft.Practices.EnterpriseLibrary.Data.Database"/>
/// the receiver knows how to build, based on the provided connection string and any configuration information
/// that might be contained by the <paramref name="configurationSource"/>.
/// </summary>
/// <param name="name">The name for the new database instance.</param>
/// <param name="connectionStringSettings">The connection string for the new database instance.</param>
/// <param name="configurationSource">The source for any additional configuration information.</param>
/// <returns>
/// The new database instance.
/// </returns>
public Database Assemble(string name, ConnectionStringSettings connectionStringSettings,
IConfigurationSource configurationSource) {
if(IsDebugEnabled)
log.Debug("EnterpriseLibrary용 OracleProvider 인스턴스를 빌드합니다... name=[{0}]", name);
var settings = OracleConnectionSettings.GetSettings(configurationSource);
if(settings != null) {
var data = settings.OracleConnectionsData.Get(name);
if(data != null) {
var packages = new IOraclePackage[data.Packages.Count];
var num = 0;
foreach(var package in data.Packages) {
packages[num++] = package;
}
return new OracleDatabase(connectionStringSettings.ConnectionString);
}
}
if(IsDebugEnabled)
log.Debug("OracleDatabase를 생성합니다. connectionString=[{0}]", connectionStringSettings.ConnectionString);
return new OracleDatabase(connectionStringSettings.ConnectionString);
}
/// <summary>
/// Initializes a new instance of the <see cref="AbstractDatabaseOperation"/> class.
/// </summary>
/// <param name="connectionStringSettings">Name of the connection string.</param>
protected AbstractDatabaseOperation(ConnectionStringSettings connectionStringSettings)
{
Guard.Against<ArgumentException>(connectionStringSettings == null,
"connectionStringSettings must resolve to a value");
this.connectionStringSettings = connectionStringSettings;
}
public SQLSubscriptionTrackingService(ConnectionStringSettings connectionStringSettings,
ISQLDialect dialect = null)
{
if (connectionStringSettings == null) throw new ArgumentNullException("connectionStringSettings");
_connectionProvider = new DefaultConnectionProvider(connectionStringSettings);
_dialect = dialect ?? connectionStringSettings.GetSQLDialect();
}
///<summary>
///创建ConnectionString(如果存在，先删除再创建)
///</summary>
///<param name="config">Configuration实例</param>
///<param name="newName">连接字符串名称</param>
///<param name="newConString">连接字符串内容</param>
///<param name="newProviderName">数据提供程序名称</param>
public static Boolean CreateConnectionStringsConfig(Configuration config, string newName, string newConString, string newProviderName)
{
if (config == null && string.IsNullOrEmpty(newName) && string.IsNullOrEmpty(newConString) && string.IsNullOrEmpty(newProviderName))
{
return false;
}
bool isModified = false;
//记录该连接串是否已经存在
//如果要更改的连接串已经存在
if (config.ConnectionStrings.ConnectionStrings[newName] != null)
{ isModified = true; }
//新建一个连接字符串实例
ConnectionStringSettings mySettings = new ConnectionStringSettings(newName, newConString, newProviderName);
// 如果连接串已存在，首先删除它
if (isModified)
{
config.ConnectionStrings.ConnectionStrings.Remove(newName);
}
// 将新的连接串添加到配置文件中.
config.ConnectionStrings.ConnectionStrings.Add(mySettings);
// 保存对配置文件所作的更改
config.Save(ConfigurationSaveMode.Modified);
return true;
}
private static AdoTemplate CreateTemplate(ConnectionStringSettings connectionStringSettings)
{
var dbProvider = DbProviderFactory.GetDbProvider(connectionStringSettings.ProviderName);
dbProvider.ConnectionString = connectionStringSettings.ConnectionString;
return new AdoTemplate(dbProvider)
{DataReaderWrapperType = typeof (NullMappingDataReader), CommandTimeout = 120};
}
public void GetConnectionString()
{
try
{
if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count > 0)
{
connString = rootWebConfig.ConnectionStrings.ConnectionStrings["Expenses"];
if (connection == null)
{
connection = new SqlConnection(connString.ToString());
Session["Connection"] = connection;
//connection.Open();
}
}
}
catch (Exception e)
{
Page.ClientScript.RegisterStartupScript(Page.GetType(),
"MessageBox", "alert('" + e.Message + "');", true);
}
finally
{
if (connection != null && connection.State == ConnectionState.Open)
{
connection.Close();
}
}
}
public static void DeleteDatabase(ConnectionStringSettings connectionString)
{
var builder = new SqlConnectionStringBuilder(connectionString.ConnectionString);
string databaseName = builder.InitialCatalog;
builder.InitialCatalog = string.Empty;
using (var conn = new SqlConnection(builder.ConnectionString))
{
conn.Open();
using (var command = conn.CreateCommand())
{
command.CommandText = string.Format(
@"IF EXISTS(select * from sys.databases where name='{0}')
BEGIN
DECLARE @DatabaseName nvarchar(50)
SET @DatabaseName = N'{0}'
DECLARE @Sql varchar(max)
SELECT @Sql = COALESCE(@Sql,'') + 'Kill ' + Convert(varchar, SPId) + ';'
FROM MASTER..SysProcesses
WHERE DBId = DB_ID(@DatabaseName) AND SPId <> @@SPId
EXEC(@Sql)
DROP DATABASE [{0}]
END",
databaseName);
command.ExecuteNonQuery();
}
}
}
public IDataProvider Create(ConnectionStringSettings settings, Transaction transactionMode)
{
var provider = ResolveDataProvider(settings.ProviderName);
provider.DbConnection = CreateConnection(settings.ProviderName, settings);
provider.TransactionMode = transactionMode;
return provider;
}
public void Dispose()
{
if (Connection != null)
{
Connection = null;
}
}
static void Main(string[] args)
{
// Объект ConnectionStringSettings представляет собой отдельную строку подключения в разделе строк подключения
// конфигурационного файла
ConnectionStringSettings setting = new ConnectionStringSettings()
{
Name = "MyConnectionString2", //имя строки подключения в конфигурационном файле
ConnectionString = @"Data Source=(localdb)\v11.0;AttachDbFilename=D:\KIN\DB\People.mdf;Integrated Security=True"
};
Configuration config; // Объект Config представляет конфигурационный файл
config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
Console.WriteLine(config.FilePath);
// Объект ConfigurationManager предоставляет доступ к файлам конфигурации
config.ConnectionStrings.ConnectionStrings.Add(setting);
config.Save(); // СОХРАНЕНИЕ СТРОКИ ПОДКЛЮЧЕНИЯ В ФАЙЛЕ
Console.WriteLine("Строка подключения записана в конфигурационный файл.");
// Получение строки подключения.
Console.WriteLine("Строка подключения MyConnectionString2");
Console.WriteLine(ConfigurationManager.ConnectionStrings["MyConnectionString2"].ConnectionString);
Console.WriteLine("Строка подключения DefaultConnection");
Console.WriteLine(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
Console.ReadKey();
}
public ConnProps(ConnectionStringSettings setting)
{
InitializeComponent();
textBoxName.Text = setting.Name;
textBoxConnString.Text = setting.ConnectionString;
textBoxProvider.Text = setting.ProviderName;
}
private static ConnectionStringSettings GetDefaultConnectionStringSettings()
{
var connStrSettingsList = ConfigurationManager.ConnectionStrings;
ConnectionStringSettings defaultConnStrSettings = null;
for (int i = 0; i < connStrSettingsList.Count; ++i)
{
var connStrSettings = connStrSettingsList[i];
if ("default".Equals(connStrSettings.Name, StringComparison.OrdinalIgnoreCase))
{
if (defaultConnStrSettings != null)
{
throw new ConfigurationErrorsException("Multiple connection string settings with name \"default\"");
}
defaultConnStrSettings = connStrSettingsList[i];
if (string.IsNullOrEmpty(defaultConnStrSettings.ConnectionString))
{
throw new ConfigurationErrorsException("A connection string setting with name \"default\" has empty or null ConnectionString");
}
}
}
if (defaultConnStrSettings == null)
{
throw new ConfigurationErrorsException("No connection string settings with name \"default\"");
}
return defaultConnStrSettings;
}
public void CreateConnectionString(ServerConfiguration serverConfiguration)
{
Configuration config = WebConfigurationManager.OpenWebConfiguration(System.Web.Hosting.HostingEnvironment.ApplicationVirtualPath);
ConnectionStringSettings connectionstringsets = new ConnectionStringSettings();
connectionstringsets.Name = "filth1connection";
// create connection string
if (serverConfiguration.Live)
{
connectionstringsets.ConnectionString = "Data Source=" + serverConfiguration.ServerName + ";Initial Catalog=" + serverConfiguration.Catalog + ";Integrated Security=false;User ID=" + serverConfiguration.Username + ";Password="******";multipleactiveresultsets=True;App=EntityFramework;"; //Encrypt=yes
try
{
using (var connection = new SqlConnection(connectionstringsets.ConnectionString))
{
connection.Open();
// most hostings doesn't allow this
// var command = connection.CreateCommand();
// command.CommandText = "CREATE DATABASE " + database;
// command.ExecuteNonQuery();
}
}
catch (Exception e)
{
throw e;
}
}
else
connectionstringsets.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDBFilename=|DataDirectory|filthdb_" + new Random().Next() + ".mdf" + ";User Instance=true;Integrated Security=true;multipleactiveresultsets=True;App=EntityFramework";
connectionstringsets.ProviderName = "System.Data.SqlClient";
config.ConnectionStrings.ConnectionStrings.Add(connectionstringsets);
config.Save();
}
///<summary>
///更新连接字符串
///</summary>
///<param name="newName">连接字符串名称</param>
///<param name="newConString">连接字符串内容</param>
///<param name="newProviderName">数据提供程序名称</param>
public static void UpdateConnectionStringsConfig(string newName, string newConString, string newProviderName)
{
//指定config文件读取
string file = System.Windows.Forms.Application.ExecutablePath;
Configuration config = ConfigurationManager.OpenExeConfiguration(file);
bool exist = false; //记录该连接串是否已经存在
//如果要更改的连接串已经存在
if (config.ConnectionStrings.ConnectionStrings[newName] != null)
{
exist = true;
}
// 如果连接串已存在，首先删除它
if (exist)
{
config.ConnectionStrings.ConnectionStrings.Remove(newName);
}
//新建一个连接字符串实例
ConnectionStringSettings mySettings =
new ConnectionStringSettings(newName, newConString, newProviderName);
// 将新的连接串添加到配置文件中.
config.ConnectionStrings.ConnectionStrings.Add(mySettings);
// 保存对配置文件所作的更改
config.Save(ConfigurationSaveMode.Modified);
// 强制重新载入配置文件的ConnectionStrings配置节
ConfigurationManager.RefreshSection("ConnectionStrings");
}
static ConnectionStringsSection GetConnectionStringsSection()
{
ConnectionStringsSection section = new ConnectionStringsSection();
ConnectionStringSettings connectionStringSettings = new ConnectionStringSettings(instanceName, connectionString, providerName);
section.ConnectionStrings.Add(connectionStringSettings);
return section;
}
/// <summary>
/// Initializes a new instance of the <see cref="AuthMutableStructureSearchManager"/> class.
/// </summary>
/// <param name="mutableRetrievalManagerFactory">
/// The mutable retrieval manager factory.
/// </param>
/// <param name="crossReferenceManager">
/// The cross reference manager.
/// </param>
/// <param name="connectionStringSettings">
/// The connection string settings.
/// </param>
public AuthMutableStructureSearchManager(
IAuthAdvancedMutableRetrievalManagerFactory mutableRetrievalManagerFactory,
IAuthCrossRetrievalManagerFactory crossReferenceManager,
ConnectionStringSettings connectionStringSettings)
: base(mutableRetrievalManagerFactory, crossReferenceManager, connectionStringSettings)
{
}
static void Main(string[] args)
{
// Code that runs on application startup
ConnectionStringSettings cs = new ConnectionStringSettings("dbconnstring", HP.Rfg.lib.utility.getParameter("dbconnstring"), "System.Data.SqlClient");
string poolSize = HP.Rfg.lib.utility.getParameter("dbpoolsize");
int poolSizeInt = 5;
int.TryParse(poolSize, out poolSizeInt);
string pathToTempDir = utility.getParameter("path_to_temp");
HP.Rfg.Control.RFGActivator.StartApplication(cs, HP.Rfg.lib.utility.getParameter("smtp"), poolSizeInt, pathToTempDir);
MessageCallback_Console msg = new MessageCallback_Console();
try
{
BatchJobs.Process(pathToTempDir, msg);
System.Environment.Exit(0);
}
catch (Exception ex)
{
msg.AppendLine(ex.Message + "\n" + ex.StackTrace + "\n");
System.Environment.Exit(-1);
}
finally
{
HP.Rfg.Control.RFGActivator.StopApplication();
}
//}
}
internal static SqlCeProvider GetNewOnMatch(ConnectionStringSettings connectionConfig)
{
if (ProviderNames.Contains(connectionConfig.ProviderName))
return new SqlCeProvider(connectionConfig.Name, connectionConfig.ConnectionString, connectionConfig.ProviderName);
return null;
}
public override void Initialize(string name, NameValueCollection config)
{
// Initialize values from web.config.
if (config == null) throw new ArgumentNullException("config");
if (name == null || name.Length == 0) name = "VauctionSessionStateStore";
if (String.IsNullOrEmpty(config["description"]))
{
config.Remove("description");
config.Add("description", "Vauction Session State Store provider");
}
// Initialize the abstract base class.
base.Initialize(name, config);
// Initialize the ApplicationName property.
// Get <sessionState> configuration element.
System.Configuration.Configuration cfg = WebConfigurationManager.OpenWebConfiguration(ApplicationName);
pConfig = (SessionStateSection)cfg.GetSection("system.web/sessionState");
// Initialize connection string.
pConnectionStringSettings = ConfigurationManager.ConnectionStrings[config["connectionStringName"]];
if (pConnectionStringSettings == null || pConnectionStringSettings.ConnectionString.Trim() == "")
throw new ProviderException("Connection string cannot be blank.");
connectionString = pConnectionStringSettings.ConnectionString;
// Initialize WriteExceptionsToEventLog
pWriteExceptionsToEventLog = false;
if (config["writeExceptionsToEventLog"] != null)
{
if (config["writeExceptionsToEventLog"].ToUpper() == "TRUE")
pWriteExceptionsToEventLog = true;
}
pApplicationName = (config["application"] != null) ? config["application"] : System.Web.Hosting.HostingEnvironment.ApplicationVirtualPath;
eventSource = (!String.IsNullOrEmpty(config["eventLogSource"])) ? config["eventLogSource"] : "VauctionSessionStateStore";
}
private static IDbConnectionProvider InitDb(DirectoryInfo directory, QueueName queueName)
{
var dbPath = Path.Combine(directory.FullName, queueName + ".db");
var connectionStringSettings = new ConnectionStringSettings
{
Name = dbPath,
ConnectionString = "Data Source=" + dbPath + "; Version=3",
ProviderName = "System.Data.SQLite"
};
var connectionProvider = new SingletonConnectionProvider(connectionStringSettings);
var connection = connectionProvider.GetConnection();
try
{
using (var command = connection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = new SQLiteDialect().CreateMessageQueueingServiceObjectsCommand;
command.ExecuteNonQuery();
}
}
finally
{
connectionProvider.ReleaseConnection(connection);
}
return connectionProvider;
}
/// <summary>
/// Initializes a new instance of the <see cref="SqlBulkInsertOperation"/> class.
/// </summary>
/// <param name="connectionStringSettings">Connection string settings to use.</param>
/// <param name="targetTable">The target table.</param>
/// <param name="timeout">The timeout.</param>
protected SqlBulkInsertOperation(ConnectionStringSettings connectionStringSettings, string targetTable, int timeout)
: base(connectionStringSettings)
{
Guard.Against(string.IsNullOrEmpty(targetTable), "TargetTable was not set, but it is mandatory");
this.targetTable = targetTable;
this.timeout = timeout;
}
public DynamicModel(ConnectionStringSettings settings, DbProviderFactory factory)
{
Errors = new List<string>();
_dbProviderFactory = factory;
_connectionString = settings.ConnectionString;
}
public int IndexOf (ConnectionStringSettings settings)
{
Contract.Requires (settings != null);
Contract.Ensures (Contract.Result<int>() >= -1);
return default(int);
}
private static IDbConnectionProvider InitDb(DirectoryInfo baseDirectory)
{
if (baseDirectory == null)
{
var appdomainDirectory = AppDomain.CurrentDomain.BaseDirectory;
baseDirectory = new DirectoryInfo(Path.Combine(appdomainDirectory, "platibus", "subscriptions"));
}
var dbPath = Path.Combine(baseDirectory.FullName, "subscriptions.db");
var connectionStringSettings = new ConnectionStringSettings
{
Name = dbPath,
ConnectionString = "Data Source=" + dbPath + "; Version=3",
ProviderName = "System.Data.SQLite"
};
var connectionProvider = new SingletonConnectionProvider(connectionStringSettings);
var connection = connectionProvider.GetConnection();
try
{
using (var command = connection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = new SQLiteDialect().CreateSubscriptionTrackingServiceObjectsCommand;
command.ExecuteNonQuery();
}
}
finally
{
connectionProvider.ReleaseConnection(connection);
}
return connectionProvider;
}
protected void Page_Load(object sender, EventArgs e)
{
System.Configuration.ConnectionStringSettings ConnectionStringSettings = System.Configuration.ConfigurationManager.ConnectionStrings["VysocinaCycling"];
if (ConnectionStringSettings == null || ConnectionStringSettings.ConnectionString.Trim() == "")
{
throw new ProviderException("Connection string cannot be blank.");
}
this.connectionString = ConnectionStringSettings.ConnectionString;
this.appService = new AppService();
}
private static void inicializa()
{
lock (lockObj)
{
if (inicializo)
{
return;
}
System.Configuration.ConnectionStringSettings connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["campanasConnection"];
modules = new Dictionary <string, JSONHTTPServices.ServiceModule>();
modules.Add("ges", new Gestion(connectionString.ConnectionString));
inicializo = true;
}
}
/// <summary>
/// Another ADO.NET method given to us by Bill cause he's awesome
/// </summary>
/// <returns></returns>
private System.Configuration.ConnectionStringSettings ReadConnectionString()
{
String strPath;
strPath = HttpContext.Current.Request.ApplicationPath + "/web.config";
System.Configuration.Configuration rootWebConfig =
System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(strPath);
System.Configuration.ConnectionStringSettings connString = null;
if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count > 0)
{
connString = rootWebConfig.ConnectionStrings.ConnectionStrings["GroceryStoreSimulatorConnectionString"];
}
return(connString);
}
private List <MissedCall> GetMissedCalls()
{
var rslt = new List <MissedCall>();
try
{
System.Data.SqlClient.SqlConnection conn = null;
System.Configuration.ConnectionStringSettings settings =
System.Configuration.ConfigurationManager.ConnectionStrings["oktell_ccwsConnectionString"];
SqlConnection myOdbcConnection = new SqlConnection(settings.ConnectionString);
SqlCommand myOdbcCommand = new SqlCommand();
myOdbcCommand.Connection = myOdbcConnection;
myOdbcCommand.CommandType = CommandType.Text;
myOdbcCommand.CommandText = "SELECT TOP 1000 [AbonentNumber], [DateTimeStart],[LenQueue] , [CallResult] FROM [oktell_cc_temp].[dbo].[A_Cube_CC_EffortConnections] with(nolock) where [DateTimeStart] > DATEADD(mi,-90,getDate()) and [IdTask] = '" + TaskId + "' and [CallResult] not in (5,8) ";
myOdbcCommand.Connection.Open();
SqlDataReader myOdbcReader = myOdbcCommand.ExecuteReader(CommandBehavior.CloseConnection);
while (myOdbcReader.Read())
{
rslt.Add(new MissedCall()
{
AbonentNumber = myOdbcReader.GetString(0),
DateTimeStart = myOdbcReader.GetDateTime(1),
CallResult = myOdbcReader.GetInt32(3),
LenQueue = myOdbcReader.GetFloat(2),
});
}
myOdbcReader.Close();
myOdbcConnection.Close();
return(rslt);
}
catch (Exception ex)
{
return(new List <MissedCall>());
}
}
private List <Tuple <Guid, String> > GetOperatorsId(int line = 1)
{
var rslt = new List <Tuple <Guid, String> >();
try
{
System.Data.SqlClient.SqlConnection conn = null;
System.Configuration.ConnectionStringSettings settings =
System.Configuration.ConfigurationManager.ConnectionStrings["oktell_ccwsConnectionString"];
SqlConnection myOdbcConnection = new SqlConnection(settings.ConnectionString);
SqlCommand myOdbcCommand = new SqlCommand();
myOdbcCommand.Connection = myOdbcConnection;
myOdbcCommand.CommandType = CommandType.Text;
if (line == 1)
{
myOdbcCommand.CommandText = "SELECT t2.Id, t2.Name FROM [oktell_settings].[dbo].[A_TaskManager_Operators] t1 WITH(NOLOCK), oktell_cc_temp.dbo.A_Cube_CC_Cat_OperatorInfo t2 with(nolock) WHERE t1.OperatorId = t2.Id and TaskId = 'B78D18B8-64AC-4A81-982E-A6C0987F2107'";
}
if (line == 2)
{
myOdbcCommand.CommandText = "SELECT t2.Id, t2.Name FROM [OKTELL_DB1.WILSTREAM.RU].[oktell_settings].[dbo].[A_TaskManager_Operators] t1 WITH(NOLOCK), [OKTELL_DB1.WILSTREAM.RU].oktell_cc_temp.dbo.A_Cube_CC_Cat_OperatorInfo t2 with(nolock) WHERE t1.OperatorId = t2.Id and TaskId = 'CDDB70E2-4CB8-4664-A966-442A83FA7D94'";
}
myOdbcCommand.Connection.Open();
SqlDataReader myOdbcReader = myOdbcCommand.ExecuteReader(CommandBehavior.CloseConnection);
while (myOdbcReader.Read())
{
rslt.Add(new Tuple <Guid, String> (myOdbcReader.GetGuid(0), myOdbcReader.GetString(1)));
}
myOdbcReader.Close();
myOdbcConnection.Close();
return(rslt);
}
catch (Exception ex)
{
return(new List <Tuple <Guid, String> >());
}
}
private List <Object[]> GetChartData(string Name)
{
var rslt = new List <Object[]>();
try
{
System.Data.SqlClient.SqlConnection conn = null;
System.Configuration.ConnectionStringSettings settings =
System.Configuration.ConfigurationManager.ConnectionStrings["oktell_ccwsConnectionString"];
SqlConnection myOdbcConnection = new SqlConnection(settings.ConnectionString);
SqlCommand myOdbcCommand = new SqlCommand();
myOdbcCommand.Connection = myOdbcConnection;
myOdbcCommand.CommandType = CommandType.StoredProcedure;
myOdbcCommand.CommandText = "ivi_stat_online_day";
myOdbcCommand.Parameters.AddWithValue("@report", Name);
myOdbcCommand.Connection.Open();
SqlDataReader myOdbcReader = myOdbcCommand.ExecuteReader(CommandBehavior.CloseConnection);
while (myOdbcReader.Read())
{
var row = new Object[3];
row[0] = myOdbcReader.GetInt32(0);
row[1] = myOdbcReader.GetString(1).ToString();
row[2] = myOdbcReader.GetString(2).ToString();
rslt.Add(row);
}
myOdbcReader.Close();
myOdbcConnection.Close();
return(rslt);
}
catch (Exception ex)
{
return(new List <Object[]>());
}
}
/// <summary>
/// Adds a connection string settings entry & saves it to the associated config file.
///
/// This may be app.config, or an auxiliary file that app.config points to or some
/// other xml file.
/// ConnectionStringSettings is the confusing type name of one entry including:
/// name + connection string + provider entry
/// </summary>
/// <param name="configuration">Pass in ConfigurationManager.OpenMachineConfiguration,
/// ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None) etc. </param>
/// <param name="connectionStringSettings">The entry to add</param>
public static void AddAndSaveOneConnectionStringSettings(
System.Configuration.Configuration configuration,
System.Configuration.ConnectionStringSettings connectionStringSettings)
{
// You cannot add to ConfigurationManager.ConnectionStrings using
// ConfigurationManager.ConnectionStrings.Add(connectionStringSettings) -- This fails.
// But you can add to the configuration section and refresh the ConfigurationManager.
// Get the connection strings section; Even if it is in another file.
ConnectionStringsSection connectionStringsSection = configuration.ConnectionStrings;
// Add the new element to the section.
connectionStringsSection.ConnectionStrings.Remove(connectionStringSettings.Name);
connectionStringsSection.ConnectionStrings.Add(connectionStringSettings);
// Save the configuration file.
configuration.Save(ConfigurationSaveMode.Modified);
// Delay wait to make sure file get saved and detect
Thread.Sleep(3000);
// This is needed. Otherwise the updates do not show up in ConfigurationManager
ConfigurationManager.RefreshSection("connectionStrings");
}
public void Remove(ConnectionStringSettings settings)
{
BaseRemove(settings.Name);
}
private void GetOLA02Data(string v, string v2)
{
GBClass001 SBApp = new GBClass001();
string tDATALOCK = "";
GenerateDropDownList();
System.Configuration.ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
{
SwcConn.Open();
string strSQLRV = " select * from SWCCASE ";
strSQLRV = strSQLRV + " where SWC000 = '" + v + "' ";
SqlDataReader readeSwc;
SqlCommand objCmdSwc = new SqlCommand(strSQLRV, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
while (readeSwc.Read())
{
string tSWC000 = readeSwc["SWC000"] + "";
string tSWC002 = readeSwc["SWC002"] + "";
string tSWC005 = readeSwc["SWC005"] + "";
LBSWC000.Text = tSWC000;
LBSWC002.Text = tSWC002;
LBSWC005.Text = tSWC005;
}
readeSwc.Close();
objCmdSwc.Dispose();
if (v2 == "AddNew")
{
string rONA000 = GetONAID();
TXTONA001.Text = rONA000;
}
else
{
string strSQLRV2 = " select * from OnlineApply05 ";
strSQLRV2 = strSQLRV2 + " where SWC000 = '" + v + "' ";
strSQLRV2 = strSQLRV2 + " and ONA05001 = '" + v2 + "' ";
SqlDataReader readeONA;
SqlCommand objCmdONA = new SqlCommand(strSQLRV2, SwcConn);
readeONA = objCmdONA.ExecuteReader();
while (readeONA.Read())
{
string tONA002 = readeONA["ONA05002"] + "";
string tONA003 = readeONA["ONA05003"] + "";
string tONA004 = readeONA["ONA05004"] + "";
string tONA005 = readeONA["ONA05005"] + "";
string tONA006 = readeONA["ONA05006"] + "";
string tONA007 = readeONA["ONA05007"] + "";
string tONA008 = readeONA["ONA05008"] + "";
string tONA009 = readeONA["ONA05009"] + "";
string tONA010 = readeONA["ONA05010"] + "";
string tONA011 = readeONA["ONA05011"] + "";
string tONA012 = readeONA["ONA05012"] + "";
tDATALOCK = readeONA["DATALOCK"] + "";
TXTONA001.Text = v2;
DDLONA002.SelectedValue = tONA002;
if (tONA003 == "1")
{
CHKBOXONA003.Checked = true;
}
if (tONA004 == "1")
{
CHKBOXONA004.Checked = true;
}
if (tONA005 == "1")
{
CHKBOXONA005.Checked = true;
}
if (tONA006 == "1")
{
CHKBOXONA006.Checked = true;
}
if (tONA007 == "1")
{
CHKBOXONA007.Checked = true;
}
if (tONA008 == "1")
{
CHKBOXONA008.Checked = true;
}
if (tONA009 == "1")
{
CHKBOXONA009.Checked = true;
}
if (tONA010 == "1")
{
CHKBOXONA010.Checked = true;
}
TXTONA011.Text = tONA011;
if (tONA012 == "1")
{
CHKBOXONA012.Checked = true;
}
//檔案類處理
string[] arrayFileNameLink = new string[] { tONA011 };
System.Web.UI.WebControls.HyperLink[] arrayLinkAppobj = new System.Web.UI.WebControls.HyperLink[] { Link011 };
for (int i = 0; i < arrayFileNameLink.Length; i++)
{
string strFileName = arrayFileNameLink[i];
System.Web.UI.WebControls.HyperLink FileLinkObj = arrayLinkAppobj[i];
FileLinkObj.Visible = false;
if (strFileName == "")
{
}
else
{
string tempLinkPateh = SwcUpLoadFilePath + v + "/" + strFileName;
FileLinkObj.Text = strFileName;
FileLinkObj.NavigateUrl = tempLinkPateh;
FileLinkObj.Visible = true;
}
}
}
}
}
}
protected void Page_PreInit(object sender, EventArgs e)
{
System.Configuration.ConnectionStringSettings _connectionSettings = null;
_connectionSettings = ConfigurationManager.ConnectionStrings["ConnectionString"];
IDbConnection _connection = null;
if (_connectionSettings.ProviderName.ToLower().Contains("sql"))
{
_connection = new SqlConnection(_connectionSettings.ConnectionString);
}
else if (_connectionSettings.ProviderName.ToLower().Contains("ole"))
{
_connection = new OleDbConnection(_connectionSettings.ConnectionString);
}
else if (_connectionSettings.ProviderName.ToLower().Contains("odbc"))
{
_connection = new OdbcConnection(_connectionSettings.ConnectionString);
}
else
{
_connection = new SqlConnection(_connectionSettings.ConnectionString);
}
IDbCommand dbCmd = _connection.CreateCommand();
//foreach (IDbDataParameter p in parameters)
//{ dbCmd.Parameters.Add(p); }
dbCmd.CommandText = "getMaster";
dbCmd.CommandType = CommandType.StoredProcedure;
IDbDataAdapter adapter = null;
//Inspect the provider type and create an instance of the matching connection object.
//Use Activator.CreateInstance for easy management.
//If performance becomes an issue, replace this line with hard coded direct object type creation code.
if (_connectionSettings.ProviderName.ToLower().Contains("sql"))
{
adapter = new SqlDataAdapter();
}
else if (_connectionSettings.ProviderName.ToLower().Contains("ole"))
{
adapter = new OleDbDataAdapter();
}
else if (_connectionSettings.ProviderName.ToLower().Contains("odbc"))
{
adapter = new OdbcDataAdapter();
}
else
{
adapter = new SqlDataAdapter();
}
adapter.SelectCommand = dbCmd;
DataSet ds = new DataSet();
_connection.Open();
adapter.Fill(ds);
_connection.Close();
string TemplateName = ds.Tables[0].Rows[0][0].ToString();
Page.MasterPageFile = TemplateName;
// Page.MasterPageFile = "~/Templates/AlternateSitetemplate.Master";
MasterPage MP = this.Master;
}
public void Add(ConnectionStringSettings settings)
{
BaseAdd((ConfigurationElement)settings);
}
public void Add(ConnectionStringSettings settings)
{
BaseAdd(settings);
}
public int IndexOf(ConnectionStringSettings settings)
{
return(BaseIndexOf(settings));
}
public void TestVistaDB()
{
string VersionInfo = null;
for (int i = 0; i < System.Configuration.ConfigurationManager.ConnectionStrings.Count; i++)
{
System.Diagnostics.Debug.WriteLine(System.Configuration.ConfigurationManager.ConnectionStrings[i].ToString());
}
string connectionName = "myVDBConnection";
// Find this connection string in the app.config
System.Configuration.ConnectionStringSettings connectionString = System.Configuration.ConfigurationManager.ConnectionStrings[connectionName];
if (connectionString == null)
{
VersionInfo = "Failed to load connectionString from config file";
Assert.Fail(VersionInfo);
}
DbProviderFactory factory = null;
// Loads the factory
try
{
factory = DbProviderFactories.GetFactory(connectionString.ProviderName);
}
catch
{
Assert.Fail("VistaDB library should be copied locally or installed into GAC.");
}
try
{
CreateDatabase(factory);
}
catch { }
// After this it looks pretty normal
using (DbConnection connection = factory.CreateConnection())
{
connection.ConnectionString = connectionString.ConnectionString;
connection.Open();
using (DbCommand command = connection.CreateCommand())
{
command.CommandText = "SELECT @@VERSION;";
command.CommandType = CommandType.Text;
using (DbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
string result = reader.GetString(0);
if (!reader.IsDBNull(0))
{
VersionInfo = result;
Assert.True(true, "Connected to: " + VersionInfo);
return;
}
}
}
}
}
VersionInfo = string.Empty;
Assert.Fail("Could not connect to VistaDB");
}
private void GetOLA02Data(string v, string v2)
{
GBClass001 SBApp = new GBClass001();
string tDATALOCK = "";
string DataLock2 = "";
System.Configuration.ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
{
SwcConn.Open();
string strSQLRV = " select * from SWCCASE ";
strSQLRV = strSQLRV + " where SWC000 = '" + v + "' ";
SqlDataReader readeSwc;
SqlCommand objCmdSwc = new SqlCommand(strSQLRV, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
while (readeSwc.Read())
{
string tSWC000 = readeSwc["SWC000"] + "";
string tSWC002 = readeSwc["SWC002"] + "";
string tSWC005 = readeSwc["SWC005"] + "";
LBSWC000.Text = tSWC000;
LBSWC002.Text = tSWC002;
LBSWC005.Text = tSWC005;
}
readeSwc.Close();
objCmdSwc.Dispose();
if (v2 == "AddNew")
{
string rONA000 = GetONAID();
TXTONA001.Text = rONA000;
}
else
{
string strSQLRV2 = " select * from OnlineApply05 ";
strSQLRV2 = strSQLRV2 + " where SWC000 = '" + v + "' ";
strSQLRV2 = strSQLRV2 + " and ONA05001 = '" + v2 + "' ";
SqlDataReader readeONA;
SqlCommand objCmdONA = new SqlCommand(strSQLRV2, SwcConn);
readeONA = objCmdONA.ExecuteReader();
while (readeONA.Read())
{
string tONA002 = readeONA["ONA05002"] + "";
string tONA003 = readeONA["ONA05003"] + "";
string tONA004 = readeONA["ONA05004"] + "";
string tONA005 = readeONA["ONA05005"] + "";
string tONA006 = readeONA["ONA05006"] + "";
string tONA007 = readeONA["ONA05007"] + "";
string tONA008 = readeONA["ONA05008"] + "";
string tONA009 = readeONA["ONA05009"] + "";
string tONA010 = readeONA["ONA05010"] + "";
string tONA011 = readeONA["ONA05011"] + "";
string tONA012 = readeONA["ONA05012"] + "";
string tReviewResults = readeONA["ReviewResults"] + "";
string tResultsExplain = readeONA["ResultsExplain"] + "";
string tReviewDoc = readeONA["ReviewDoc"] + "";
string tLOCKUSER2 = readeONA["LOCKUSER2"] + "";
tDATALOCK = readeONA["DATALOCK"] + "";
DataLock2 = readeONA["DATALOCK2"] + "";
TXTONA001.Text = v2;
DDLONA002.Text = tONA002;
if (tONA003 == "1")
{
CHKBOXONA003.Checked = true;
}
if (tONA004 == "1")
{
CHKBOXONA004.Checked = true;
}
if (tONA005 == "1")
{
CHKBOXONA005.Checked = true;
}
if (tONA006 == "1")
{
CHKBOXONA006.Checked = true;
}
if (tONA007 == "1")
{
CHKBOXONA007.Checked = true;
}
if (tONA008 == "1")
{
CHKBOXONA008.Checked = true;
}
if (tONA009 == "1")
{
CHKBOXONA009.Checked = true;
}
if (tONA010 == "1")
{
CHKBOXONA010.Checked = true;
}
TXTONA011.Text = tONA011;
if (tONA012 == "1")
{
CHKBOXONA012.Checked = true;
}
if (tReviewResults == "1")
{
CHKRRa.Checked = true; LBRR.Text = "審查結果：准予通過";
}
if (tReviewResults == "0")
{
CHKRRb.Checked = true; LBRR.Text = "審查結果：駁回";
}
ResultsExplain.Text = tResultsExplain;
LBResultsExplain.Text = tResultsExplain;
TXTReviewDoc.Text = tReviewDoc;
ReviewID.Text = SBApp.GetGeoUser(tLOCKUSER2, "Name");
//檔案類處理
string[] arrayFileNameLink = new string[] { tONA011, tReviewDoc };
System.Web.UI.WebControls.HyperLink[] arrayLinkAppobj = new System.Web.UI.WebControls.HyperLink[] { Link011, LinkReviewDoc };
for (int i = 0; i < arrayFileNameLink.Length; i++)
{
string strFileName = arrayFileNameLink[i];
System.Web.UI.WebControls.HyperLink FileLinkObj = arrayLinkAppobj[i];
FileLinkObj.Visible = false;
if (strFileName == "")
{
}
else
{
string tempLinkPateh = SwcUpLoadFilePath + v + "/" + strFileName;
FileLinkObj.Text = strFileName;
FileLinkObj.NavigateUrl = tempLinkPateh;
FileLinkObj.Visible = true;
}
}
}
}
}
string ssUserType = Session["UserType"] + "";
if (ssUserType == "03" && DataLock2 != "Y")
{
LBResultsExplain.Visible = false;
ReviewResults.Visible = true;
DataLock.Visible = true;
SaveCase.Visible = true;
}
if (DataLock2 == "Y")
{
ReViewUL.Visible = false;
ResultsExplain.Visible = false;
ReviewResults.Visible = true;
LBRR.Visible = true;
CHKRRa.Visible = false;
CHKRRb.Visible = false;
DataLock.Visible = false;
SaveCase.Visible = false;
}
}
public void ProcessRequest(HttpContext context)
{
string idLog = generateIdLog();
if (context.Request.RequestType == "POST")
{
try
{
//Imprime Request
string values = "";
System.Configuration.ConnectionStringSettings connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["campanasConnection"];
string connString = connectionString.ConnectionString;
Agendamiento agendar = new Agendamiento(connString);
GestionDAO g = new GestionDAO(connString);
try
{
using (var reader = new StreamReader(context.Request.InputStream))
{
values = reader.ReadToEnd();
}
log.InfoFormat("[{0}] Request Recibido: {1}", idLog, values);
}
catch (Exception ex)
{
log.ErrorFormat("[{0}] Error al recuperar información de Request: {1}", idLog, ex.Message);
}
var encoding = context.Request.ContentEncoding;
log.InfoFormat("[{0}] Encoding Request {0}", idLog, encoding);
//tomar todos los parametros de Request.Params
string numero_atencion = context.Request.Params["numero_atencion"];
string dnis = context.Request.Params["DNIS"];
string ani = context.Request.Params["ANI"];
string rut_cliente = context.Request.Params["rut_cliente"];
string fecha_nacimiento = context.Request.Params["fecha_nacimiento"];
string nombres_cliente = context.Request.Params["nombres_cliente"];
string apaterno_cliente = context.Request.Params["apaterno_cliente"];
string amaterno_cliente = context.Request.Params["amaterno_cliente"];
string telefono_fijo = context.Request.Params["telefono_fijo"];
string telefono_movil = context.Request.Params["telefono_movil"];
string email = context.Request.Params["email"];
string direccion = context.Request.Params["direccion"];
string comuna = context.Request.Params["comuna"];
string region = context.Request.Params["region"];
string tipo_requerimiento = context.Request.Params["tipo_requerimiento"];
string numero_oferta = context.Request.Params["numero_oferta"];
string nombre_oferta = context.Request.Params["nombre_oferta"];
string precio_oferta = context.Request.Params["precio_oferta"];
string categoria = context.Request.Params["categoria"];
string origen = context.Request.Params["origen"];
string codigo_equipo = context.Request.Params["codigo_equipo"];
string codigo_plan = context.Request.Params["codigo_plan"];
string fecha_agendamiento = context.Request.Params["fecha_agendamiento"];
string tipo_solicitud = context.Request.Params["tipo_solicitud"];
string privado = context.Request.Params["privado"];
string procedencia = context.Request.Params["procedencia"];
string default1 = context.Request.Params["default1"];
string default2 = context.Request.Params["default2"];
string default3 = context.Request.Params["default3"];
string default4 = context.Request.Params["default4"];
string default5 = context.Request.Params["default5"];
string nombreCompleto = nombres_cliente + " " + apaterno_cliente + " " + amaterno_cliente;
//Validando los datos
string errors = "";
if (IsValidLength(numero_atencion, 200, "numero_atencion", false) != "true")
{
errors = errors + IsValidLength(numero_atencion, 200, "numero_atencion", false) + "\n";
}
if (IsValidLength(dnis, 200, "dnis", false) != "true")
{
errors = errors + IsValidLength(dnis, 200, "dnis", false) + "\n";
}
if (IsValidLength(ani, 20, "ani", false) != "true")
{
errors = errors + IsValidLength(ani, 20, "ani", false) + "\n";
}
if (IsValidLength(rut_cliente, 11, "rut", false) != "true")
{
errors = errors + IsValidLength(rut_cliente, 11, "rut", false) + "\n";
}
if (IsFormatFechaNac_Date(fecha_nacimiento, true) != "true")
{
errors = errors + IsFormatFechaNac_Date(fecha_nacimiento, true) + "\n";
}
if (IsValidLength(nombreCompleto, 100, "nombreCompleto") != "true")
{
errors = errors + IsValidLength(nombreCompleto, 100, "nombreCompleto") + "\n";
}
if (IsValidLength(telefono_fijo, 20, "telefono_fijo") != "true")
{
errors = errors + IsValidLength(telefono_fijo, 20, "telefono_fijo") + "\n";
}
if (IsValidLength(telefono_movil, 20, "telefono_movil") != "true")
{
errors = errors + IsValidLength(telefono_movil, 20, "telefono_movil") + "\n";
}
if (IsValidLength(email, 200, "email") != "true")
{
errors = errors + IsValidLength(email, 200, "email") + "\n";
}
if (IsValidLength(direccion, 200, "direccion") != "true")
{
errors = errors + IsValidLength(direccion, 200, "direccion") + "\n";
}
if (IsValidLength(comuna, 40, "comuna") != "true")
{
errors = errors + IsValidLength(comuna, 40, "comuna") + "\n";
}
if (IsValidLength(region, 20, "region") != "true")
{
errors = errors + IsValidLength(region, 20, "region") + "\n";
}
if (IsValidLength(numero_oferta, 20, "numero_oferta") != "true")
{
errors = errors + IsValidLength(numero_oferta, 20, "numero_oferta") + "\n";
}
if (IsValidLength(nombre_oferta, 200, "nombre_oferta") != "true")
{
errors = errors + IsValidLength(nombre_oferta, 200, "nombre_oferta") + "\n";
}
if (IsValidLength(precio_oferta, 15, "precio_oferta") != "true")
{
errors = errors + IsValidLength(precio_oferta, 15, "precio_oferta") + "\n";
}
if (IsValidLength(categoria, 200, "categoria") != "true")
{
errors = errors + IsValidLength(categoria, 200, "categoria") + "\n";
}
if (IsValidLength(origen, 200, "origen") != "true")
{
errors = errors + IsValidLength(origen, 200, "origen") + "\n";
}
if (IsValidLength(codigo_plan, 200, "codigo_plan") != "true")
{
errors = errors + IsValidLength(codigo_plan, 200, "codigo_plan") + "\n";
}
if (IsValidLength(tipo_requerimiento, 200, "tipo_requerimiento", false) != "true")
{
errors = errors + IsValidLength(tipo_requerimiento, 200, "tipo_requerimiento") + "\n";
}
if (IsValidLength(tipo_solicitud, 200, "tipo_solicitud", false) != "true")
{
errors = errors + IsValidLength(tipo_solicitud, 200, "tipo_solicitud") + "\n";
}
if (IsValidLength(default1, 200, "default1") != "true")
{
errors = errors + IsValidLength(default1, 200, "default1") + "\n";
}
if (IsValidLength(default2, 200, "default2") != "true")
{
errors = errors + IsValidLength(default2, 200, "default2") + "\n";
}
if (IsValidLength(default3, 40, "default3") != "true")
{
errors = errors + IsValidLength(default3, 40, "default3") + "\n";
}
if (IsValidLength(default4, 200, "default4") != "true")
{
errors = errors + IsValidLength(default4, 200, "default4") + "\n";
}
DataDenis parametroDataDenis = new DataDenis();
parametroDataDenis = g.getNombreContactDesdeDNIS(dnis); //Recupera utilizando DNIS
if (parametroDataDenis == null)
{
errors = errors + string.Format("No es posible determinar la campanna a partir de DNIS: {0} - TIPO SOLICITUD: {1} - TIPO REQUERIMIENTO: {2}", dnis, tipo_solicitud, tipo_requerimiento);
}
int checkFechaAgendamiento = 0; //0: Invalida; 1: Valor OK; 2: Sin Fecha
if (string.IsNullOrEmpty(fecha_agendamiento))
{
checkFechaAgendamiento = 2;
}
else
{
if (IsFormat_Date(fecha_agendamiento) != "true")
{
checkFechaAgendamiento = 0;
errors = errors + IsFormat_Date(fecha_agendamiento) + "\n";
}
else
{
checkFechaAgendamiento = 1;
}
}
if (errors != "")
{
context.Response.StatusCode = 422;
context.Response.ContentType = "text/plain";
context.Response.Write(errors);
log.InfoFormat("[{0}] Response Code '{1}' - Message '{2}'", idLog, context.Response.StatusCode, errors);
}
else
{
if (checkFechaAgendamiento == 2) //Sin Fecha Agendamiendo
{
DateTime now = DateTime.Now;
if (!"C2C".Equals(parametroDataDenis.tipo_solicitud))
{
log.InfoFormat("[{0}] Registro CMB sin fecha de agendamiento. Se setea default", idLog);
int deltaMinutos;
if (!Int32.TryParse(System.Configuration.ConfigurationManager.AppSettings["deltaMinutosRegistrosCMB"].ToString(), out deltaMinutos))
{
deltaMinutos = 60;
log.WarnFormat("[{0}] No definido parámetro 'deltaMinutosRegistrosCMB'. Se utiliza default: 60", idLog);
}
fecha_agendamiento = dateTime2StringFormat(now.AddMinutes(deltaMinutos), "dd-MM-yy HH:mm:ss");
}
}
C2C_FORM p = new C2C_FORM(); // value object p
p.tabla = parametroDataDenis.tabla;
p.pais = parametroDataDenis.pais;
p.callCenter = parametroDataDenis.callCenter;
p.familia = parametroDataDenis.familia;
p.numero_atencion = numero_atencion;
p.dnis = dnis;
p.ani = ani;
p.rut_cliente = rut_cliente;
p.fecha_nacimiento = (String.IsNullOrEmpty(fecha_nacimiento) ? "" : dateTime2StringFormat(DateTime.ParseExact(fecha_nacimiento, "dd-MM-yy", CultureInfo.InvariantCulture, DateTimeStyles.None), "yyyy-MM-dd"));
p.nombres_cliente = nombres_cliente;
p.apaterno_cliente = apaterno_cliente;
p.amaterno_cliente = amaterno_cliente;
p.telefono_fijo = telefono_fijo;
p.telefono_movil = telefono_movil;
p.email = email;
p.direccion = direccion;
p.comuna = comuna;
p.region = region;
p.tipo_requerimiento = tipo_requerimiento;
p.numero_oferta = numero_oferta;
p.nombre_oferta = nombre_oferta;
p.precio_oferta = precio_oferta;
p.categoria = categoria;
p.origen = origen;
p.codigo_equipo = codigo_equipo;
p.codigo_plan = codigo_plan;
p.fecha_agendamiento = fecha_agendamiento;
p.tipo_solicitud = parametroDataDenis.tipo_solicitud;
p.privado = privado;
p.procedencia = procedencia;
p.default1 = default1;
p.default2 = default2;
p.default3 = getCuartilDesdePrioridad(default3);
p.default4 = default4;
p.default5 = default5;
p.campaignName = parametroDataDenis.campaign;
JsonObject insertaRegistro = new JsonObject();
DateTime fechaParaAgendarRegistro = DateTime.Now;
if (string.IsNullOrEmpty(p.fecha_agendamiento)) // Si no viene fecha
{
// se debe insertar directo a la contact
p.fecha_agendamiento = Utils.dateTime2StringHHmmss(fechaParaAgendarRegistro);
log.InfoFormat("[{0}] Se inserta para discado inmediato", idLog);
}
else
{
DateTime fechaAg = DateTime.ParseExact(p.fecha_agendamiento, "dd-MM-yy HH:mm:ss", CultureInfo.InvariantCulture, DateTimeStyles.None);
if (fechaParaAgendarRegistro > fechaAg)
{
p.fecha_agendamiento = Utils.dateTime2StringHHmmss(fechaParaAgendarRegistro);
log.InfoFormat("[{0}] Fecha Menor a la Actual. Se inserta para discado inmediato", idLog);
}
else
{
fechaParaAgendarRegistro = fechaAg;
log.InfoFormat("[{0}] Se inserta para la fecha y hora indicada", idLog);
}
}
Boolean canInsert = false;
try
{
using (GestionDAO gesDAO = new GestionDAO(connString))
{
insertaRegistro = gesDAO.SaveRegContact(p, "ASB", idLog);
canInsert = true;
}
}catch (Exception exInsert)
{
log.Error("[" + idLog + "] Error al Insertar el Registro", exInsert);
}
if (canInsert && Convert.ToInt32(insertaRegistro["status"]) == 0)
{
//Llamar a la Agenda
Agendamiento servicioAgendamiento = new Agendamiento(connString);
string i3Identity = insertaRegistro["i3Identity"].ToString();
string telefono = p.ani;
string agente = null;
string campana = p.campaignName;
string respuesta = servicioAgendamiento.agregarAgendaASB(i3Identity, fechaParaAgendarRegistro, telefono, agente, campana);
if (respuesta != null && respuesta.Equals("OK"))
{
//dar respuesta al cliente
context.Response.ContentType = "text/plain";
context.Response.Write("Ok");
log.InfoFormat("[{0}] Response Code '{1}' - Message '{2}'", idLog, context.Response.StatusCode, "OK");
}
else
{
string msg = "Error al registrar la agenda del registro";
context.Response.StatusCode = 500;
context.Response.ContentType = "text/plain";
context.Response.Write(msg);
log.ErrorFormat("[{0}] Response Code '{1}' - Message '{2}'", idLog, context.Response.StatusCode, msg);
}
}
else
{
string msg = "Error al insertar el registro";
context.Response.StatusCode = 500;
context.Response.ContentType = "text/plain";
context.Response.Write(msg);
log.ErrorFormat("[{0}] Response Code '{1}' - Message '{2}'", idLog, context.Response.StatusCode, msg);
}
}
}
catch (Exception exp)
{
//internal error
context.Response.StatusCode = 500;
context.Response.ContentEncoding = Encoding.UTF8;
context.Response.ContentType = "text/plain";
context.Response.Write("Error no Controlado");
log.ErrorFormat("[{0}] Internal Error - Message '{1}'", idLog, exp.Message);
log.Error("Internal Error: ", exp);
}
finally
{
context.Response.End();
}
}
else
{
context.Response.StatusCode = 405;
context.Response.ContentType = "text/plain";
context.Response.Write("Sólo se acepta invocación vía 'POST'");
log.ErrorFormat("[{0}] Response Code '{1}' - Message '{2}'", idLog, context.Response.StatusCode, "Sólo se acepta invocación vía 'POST'");
}
}
public static void AddAndSaveOneConnectionStringSettings(System.Configuration.Configuration configuration, System.Configuration.ConnectionStringSettings connectionStringSettings)
{
// You cannot add to ConfigurationManager.ConnectionStrings using
// ConfigurationManager.ConnectionStrings.Add
// (connectionStringSettings) -- This fails.
// But you can add to the configuration section and refresh the ConfigurationManager.
// Get the connection strings section; Even if it is in another file.
ConnectionStringsSection connectionStringsSection = configuration.ConnectionStrings;
// Add the new element to the section.
connectionStringsSection.ConnectionStrings.Add(connectionStringSettings);
// Save the configuration file.
configuration.Save(ConfigurationSaveMode.Minimal);
// This is this needed. Otherwise the connection string does not show up in
// ConfigurationManager
ConfigurationManager.RefreshSection("connectionStrings");
}
public ConnectionStringEx(CSS css)
{
_css = css;
}
