public void Get_ShouldCreateConnectionWhenConnectionStringIsValid() { SQLConnectionFactory connFactory = new SQLConnectionFactory(@"Data Source=localhost;initial catalog=Master;integrated security=true"); System.Data.IDbConnection connection = connFactory.GetConnection(); Assert.IsNotNull(connection); }
public SqlManager GetDBConnection() { string dataProvider = ConfigurationManager.AppSettings["dataProvider"]; string connectionString = ConfigurationManager.ConnectionStrings[dataProvider].ConnectionString; SQLConnectionFactory sqlConnection = new SQLConnectionFactory(DbProviderFactories.GetFactory(dataProvider), connectionString); sqlConnection.Connection.Open(); SqlManager sqlManager = new SqlManager(sqlConnection.Connection); if (sqlConnection.Connection.State == System.Data.ConnectionState.Open) { return(sqlManager); } return(null); }
public CreateCredential_CH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }
public CreateOrganization_CH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }
public ListRanks_QH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }
static void Main(string[] args) { string dataProvider = ConfigurationManager.AppSettings["dataProvider"]; string connectionString = ConfigurationManager.ConnectionStrings[dataProvider].ConnectionString; Console.WriteLine(dataProvider + "-----" + connectionString); SQLConnectionFactory sqlConnection = new SQLConnectionFactory(DbProviderFactories.GetFactory(dataProvider), connectionString); sqlConnection.Connection.Open(); if (sqlConnection.Connection.State == System.Data.ConnectionState.Open) { Console.WriteLine("Connection to database is established"); // Try to inserting and selecting data MD5 md5 = new MD5CryptoServiceProvider(); byte[] originalBytes = ASCIIEncoding.Default.GetBytes("password"); byte[] encodedBytes = md5.ComputeHash(originalBytes); //Convert encoded bytes back to a 'readable' string StringBuilder s = new System.Text.StringBuilder(); foreach (byte b in encodedBytes) { s.Append(b.ToString("x2").ToLower()); } string password = s.ToString(); SqlManager sqlManager = new SqlManager(sqlConnection.Connection); sqlManager.InsertInto( "users", new string[] { "id", "name", "username", "password", "privilege", "level" }, new object[] { 1, "indra", "tak3r", password, "admin", "1" }, string.Empty); object[] result = sqlManager.SelectFrom( "users", new string[] { "id", "name", "username", "password" }, string.Empty); foreach (object record in result) { Dictionary <string, object> dRecord = record as Dictionary <string, object>; if (dRecord != null) { foreach (KeyValuePair <string, object> pair in dRecord) { Console.WriteLine(string.Format("{0}:{1}", pair.Key, pair.Value.ToString())); } } } sqlManager.Update("users", new string[] { "name" }, new object[] { "kurniawan" }, "id=1"); result = sqlManager.SelectFrom( "users", new string[] { "id", "name", "username", "password" }, string.Empty); foreach (object record in result) { Dictionary <string, object> dRecord = record as Dictionary <string, object>; if (dRecord != null) { foreach (KeyValuePair <string, object> pair in dRecord) { Console.WriteLine(string.Format("{0}:{1}", pair.Key, pair.Value.ToString())); } } } //int rowAffected = sqlManager.DeleteFrom("users", "id=1"); //if (rowAffected == 1) //{ // Console.WriteLine("Successfully delete a record"); //} } else { Console.WriteLine("Connection to database is not established"); } }
public ListOrganizations_QH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }
public GetMemberByID_QH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }
public CreateOrgRole_CH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }
public GetLatestMemberAccessToken_QH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }
public CreateRank_CH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }
public CreateAccessToken_CH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }
public GetOrgRoleByID_QH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }
public CreateMemberRankHistory_CH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }
public CreatePayGrade_CH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }
public UpdateMember_CH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }
public GetOrganizationBySpectrumID_QH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }
public AuthenticateMember_QH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }
public ListMembersForOrganization_QH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }
public ListPayGrades_QH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }
public void Get_ShouldFailWhenConnectionStringIsNotValid() { SQLConnectionFactory connFactory = new SQLConnectionFactory(_fixture.Create <string>()); Assert.Throws <ArgumentException>(() => connFactory.GetConnection()); }
public GetAccessTokenByValue_QH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }
public InitPayGradesForOrgRole_CH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }
public ExpireAccessToken_CH(SQLConnectionFactory connFactory) { _connFactory = connFactory; }