Alleviations

 using System; using System.Collections.Generic; using System.Configuration; using System.IO; using System.Text; using System.Web; using AI_Portal_Cloud.Utilities; namespace AI_Portal_Cloud.DAL {     class Connection     {         public string ConnectionString { get; set; }         public string Host { get; set; }                public Connection()         {             string ServerID = GlobalConstant.server_id;             try             {                                  //if (!string.IsNullOrEmpty(ConfigurationManager.AppSettings.Get("Key3")) && string.IsNullOrEmpty(ServerID))                 //{             ...

 using System; using System.Collections.Generic; using System.Text; using System.Data; using Npgsql; using NpgsqlTypes; namespace AI_Portal_Cloud.DAL {     public class clsPSQLHelper : IDisposable     {         private NpgsqlConnection connection = null;         private String connectionString = "dbConnection";         private NpgsqlDataAdapter sqlData = new NpgsqlDataAdapter();         public NpgsqlCommand sqlCmd = new NpgsqlCommand();                  // {0} : IP, {1} : DB Name, {2} : userID, {3} : userPW         private String connectionFormat = "Server={0};Database={1};User Id={2};Password={3};Port={4}";         public String ConnectionString         {             set             {           ...

  public string UploadExceldata(string json)         {             string connectionString = String.Format(new Connection().ConnectionString);             DataSet ds = new DataSet();             BaseResultData oBaseResult = new BaseResultData();             var connection = new Npgsql.NpgsqlConnection(connectionString);             try             {                                if (!(connection.State == ConnectionState.Open))                 {                     connection.Open();                 }                 //NpgsqlTransaction tra...