public bool CheckUserName(string username)
{
_objDBGateway = new DatabaseGateway(_dbType);
int result = 0;
try
{
string query = "select count(*) from TB_Login where USERNAME='******'";
result = _objDBGateway.ExecuteScalar <int>(query);
if (result > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
throw;
}
return(isSuccess);
}
public static IIdempotenceTracker Default()
{
return
(new IdempotenceTracker(new ScriptProvider(),
DatabaseConnectionFactory.Default(),
DatabaseGateway.Default()));
}
public void SetUp()
{
using (DatabaseContextFactory.Create())
{
DatabaseGateway.ExecuteUsing(RawQuery.Create("delete from SubscriberMessageType"));
}
}
public void ClearSubscriptions()
{
using (DatabaseContextFactory.Create(ProviderName, ConnectionString))
{
DatabaseGateway.ExecuteUsing(RawQuery.Create("delete from SubscriberMessageType"));
}
}
public void DataAccessSetUp()
{
#if (NETCOREAPP2_1)
DbProviderFactories.RegisterFactory("System.Data.SqlClient", SqlClientFactory.Instance);
#endif
TransactionScopeFactory =
new DefaultTransactionScopeFactory(true, IsolationLevel.ReadCommitted, TimeSpan.FromSeconds(120));
DatabaseGateway = new DatabaseGateway();
DataRowMapper = new DataRowMapper();
DatabaseContextCache = new ThreadStaticDatabaseContextCache();
var connectionConfigurationProvider = new Mock <IConnectionConfigurationProvider>();
connectionConfigurationProvider.Setup(m => m.Get(It.IsAny <string>())).Returns(
new ConnectionConfiguration(
"Abacus",
"System.Data.SqlClient",
"Data Source=.\\sqlexpress;Initial Catalog=Abacus;Integrated Security=SSPI;"));
DatabaseContextFactory = new DatabaseContextFactory(
connectionConfigurationProvider.Object,
new DbConnectionFactory(),
new DbCommandFactory(),
new ThreadStaticDatabaseContextCache());
DatabaseContextFactory.ConfigureWith("Abacus");
QueryMapper = new QueryMapper(DatabaseGateway, DataRowMapper);
}
public void GlobalSetup()
{
DatabaseContextFactory = new DatabaseContextFactory(new DbConnectionFactory(), new DbCommandFactory(), new ThreadStaticDatabaseContextCache());
DatabaseGateway = new DatabaseGateway();
DatabaseContextFactory.ConfigureWith("Shuttle");
}
public void GlobalSetup()
{
DbProviderFactories.RegisterFactory("System.Data.SqlClient", SqlClientFactory.Instance);
var connectionConfigurationProvider = new Mock <IConnectionConfigurationProvider>();
connectionConfigurationProvider.Setup(m => m.Get(It.IsAny <string>())).Returns(
new ConnectionConfiguration(
"Shuttle",
"System.Data.SqlClient",
"server=.;database=shuttle;user id=sa;password=Pass!000"));
DatabaseContextFactory = new DatabaseContextFactory(
connectionConfigurationProvider.Object,
new DbConnectionFactory(),
new DbCommandFactory(),
new ThreadStaticDatabaseContextCache());
DatabaseGateway = new DatabaseGateway();
TransactionScopeFactory =
new DefaultTransactionScopeFactory(true, IsolationLevel.ReadCommitted, TimeSpan.FromSeconds(120));
DatabaseContextFactory.ConfigureWith("Shuttle");
}
public static ISubscriptionManager Default()
{
return
(new SubscriptionManager(new ScriptProvider(),
DatabaseConnectionFactory.Default(),
DatabaseGateway.Default()));
}
public SqlQueue(Uri uri)
: this(uri,
new ScriptProvider(),
DatabaseConnectionFactory.Default(),
DatabaseGateway.Default())
{
}
public TraceController GetTraceController(DatabaseGateway gateway, string databaseName, TraceControllerType type)
{
switch (type)
{
case TraceControllerType.Azure:
return(new AzureTraceController(gateway, databaseName));
case TraceControllerType.Sql:
return(new SqlTraceController(gateway, databaseName));
}
var source = new DatabaseSourceGateway(gateway);
var isAzure = source.IsAzure();
if (!isAzure)
{
return(new SqlTraceController(gateway, databaseName));
}
var version = source.GetVersion();
if (version < SqlServerVersion.Sql120)
{
throw new Exception("SQL Azure is only supported from Version 12");
}
return(new AzureTraceController(gateway, databaseName));
}
public void CreateInstanceTest()
{
DatabaseGateway objDatabaseGateway = new DatabaseGateway("Utility.DatabaseHelper.SQLiteHelper");
var items = objDatabaseGateway.ExecuteNonQuery("select * from TB_ITEMS");
Assert.IsNotNull(items);
}
public void BulkInsertTest()
{
DatabaseGateway objDatabaseGateway = new DatabaseGateway("Utility.DatabaseHelper.SQLiteHelper");
List <string> lstQueries = new List <string>();
for (int i = 2104; i < 2200; i++)
{
// var query="INSERT INTO TB_ITEMS(ItemName,Quantity) values('@iname',@qn);";
var query = "Insert into tb_item_details(itemid,purchasedquantity,purchasedprice,purchasedfrom,purchaseddate) values(@iId,@pq,@pp,'@pf','@pd');";
//query=query.Replace("@iname", "Test" + i);
//query=query.Replace("@qn", "50");
query = query.Replace("@iId", i.ToString());
query = query.Replace("@pq", "20");
query = query.Replace("@pp", "100");
query = query.Replace("@pf", "test");
query = query.Replace("@pd", DateTime.Now.Date.ToString());
lstQueries.Add(query);
}
Stopwatch sw = new Stopwatch();
sw.Reset();
sw.Start();
var items = objDatabaseGateway.BulkInsert(lstQueries);
sw.Stop();
var time = sw.ElapsedMilliseconds / 1000;
Assert.IsNotNull(items);
}
public bool Login(UserEntity entity)
{
_objDBGateway = new DatabaseGateway(_dbType);
int result = 0;
try
{
string query = "select count(*) from TB_Login where USERNAME='******' and PASSWORD='******'";
result = _objDBGateway.ExecuteScalar <int>(query);
if (result > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
throw;
}
return(isSuccess);
}
public bool AddLowBalanceRecovery(int RecoveryId)
{
try
{
//using (var db = new SoneriCISEntities())
//{
// tbl_Recovery_Low_Balance row = new tbl_Recovery_Low_Balance();
// row.RecoveryID = RequsetId;
// row.RecoveryDate = DateTime.Now;
// db.tbl_Recovery_Low_Balance.Add(row);
// db.SaveChanges();
//}
//return true;
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@RecoveryId", RecoveryId));
var success = Convert.ToString(DatabaseGateway.GetScalarDataUsingStoredProcedure("sp_Add_Recovery_Low_Balance", param));
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public void Should_be_able_store_different_versions_of_the_same_reference_id()
{
var repository = new DocumentRepository(DatabaseGateway, new DocumentQueryFactory());
using (TransactionScopeFactory.Create())
using (DatabaseContextFactory.Create())
{
var referenceId = Guid.NewGuid();
var query = RawQuery.Create($"select count(*) from dbo.Document where ReferenceId = '{referenceId}'");
Assert.That(DatabaseGateway.GetScalarUsing <int>(query), Is.Zero);
repository.Save(_documentFixture.GetDocument(Guid.NewGuid(), referenceId));
Assert.That(DatabaseGateway.GetScalarUsing <int>(query), Is.EqualTo(1));
repository.Save(_documentFixture.GetDocument(Guid.NewGuid(), referenceId));
Assert.That(DatabaseGateway.GetScalarUsing <int>(query), Is.EqualTo(2));
repository.Save(_documentFixture.GetDocument(Guid.NewGuid(), referenceId));
Assert.That(DatabaseGateway.GetScalarUsing <int>(query), Is.EqualTo(3));
}
}
public void TestSetUp()
{
DatabaseGateway = new DatabaseGateway();
DatabaseContextCache = new ThreadStaticDatabaseContextCache();
#if (!NETCOREAPP2_1 && !NETSTANDARD2_0)
DatabaseContextFactory = new DatabaseContextFactory(
new ConnectionConfigurationProvider(),
new DbConnectionFactory(),
new DbCommandFactory(),
new ThreadStaticDatabaseContextCache());
#else
DbProviderFactories.RegisterFactory("System.Data.SqlClient", System.Data.SqlClient.SqlClientFactory.Instance);
var connectionConfigurationProvider = new Mock <IConnectionConfigurationProvider>();
connectionConfigurationProvider.Setup(m => m.Get(It.IsAny <string>())).Returns(
new ConnectionConfiguration(
"Shuttle",
"System.Data.SqlClient",
"Data Source=.\\sqlexpress;Initial Catalog=shuttle;Integrated Security=SSPI;"));
DatabaseContextFactory = new DatabaseContextFactory(
connectionConfigurationProvider.Object,
new DbConnectionFactory(),
new DbCommandFactory(),
new ThreadStaticDatabaseContextCache());
#endif
ClearDataStore();
}
public void TestSetUp()
{
DbProviderFactories.RegisterFactory("System.Data.SqlClient", SqlClientFactory.Instance);
DatabaseGateway = new DatabaseGateway();
DatabaseContextCache = new ThreadStaticDatabaseContextCache();
var connectionConfigurationProvider = new Mock <IConnectionConfigurationProvider>();
connectionConfigurationProvider.Setup(m => m.Get(It.IsAny <string>())).Returns(
(string name) =>
new ConnectionConfiguration(
name,
"System.Data.SqlClient",
name.Equals(EventStoreProjectionConnectionStringName)
? "server=.;Initial Catalog=ShuttleProjection;user id=sa;password=Pass!000"
: "server=.;Initial Catalog=Shuttle;user id=sa;password=Pass!000"));
ConnectionConfigurationProvider = connectionConfigurationProvider.Object;
DatabaseContextFactory = new DatabaseContextFactory(
ConnectionConfigurationProvider,
new DbConnectionFactory(),
new DbCommandFactory(),
new ThreadStaticDatabaseContextCache());
ClearDataStore();
}
public void SetUp()
{
_mockProcessDataGateway = new Mock <IProcessDataGateway>();
_mockSystemTime = new Mock <ISystemTime>();
_databaseGateway = new DatabaseGateway(DatabaseContext, _mockProcessDataGateway.Object,
_mockSystemTime.Object);
}
public void TestSetUp()
{
DatabaseGateway = new DatabaseGateway();
DatabaseContextFactory = new DatabaseContextFactory(new DbConnectionFactory(), new DbCommandFactory(),
new ThreadStaticDatabaseContextCache());
EmptyDataStore();
}
public void Setup()
{
_mockProcessDataGateway = new Mock <IProcessDataGateway>();
_mockSystemTime = new Mock <ISystemTime>();
_databaseGateway = new DatabaseGateway(DatabaseContext, _mockProcessDataGateway.Object,
_mockSystemTime.Object);
DatabaseContext.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
}
public DataTable GetRequestDataForExport(string requestType, int cardType, string branchCode)
{
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@RequestType", requestType));
parameters.Add(new SqlParameter("@CardTypeId", cardType));
parameters.Add(new SqlParameter("@BranchCode", branchCode));
var data = DatabaseGateway.GetDataUsingStoredProcedure("sp_ExportData", parameters);
return data;
}
public static IIdempotenceService Default()
{
var configuration = SqlServerSection.Configuration();
return
(new IdempotenceService(configuration,
new ScriptProvider(configuration),
DatabaseConnectionFactory.Default(),
DatabaseGateway.Default()));
}
public static ISubscriptionManager Default()
{
var configuration = SqlServerSection.Configuration();
return
(new SubscriptionManager(configuration,
new ScriptProvider(configuration),
DatabaseConnectionFactory.Default(),
DatabaseGateway.Default()));
}
public void Setup()
{
_mockProcessDataGateway = new Mock <IProcessDataGateway>();
_mockSystemTime = new Mock <ISystemTime>();
_databaseGateway = new DatabaseGateway(DatabaseContext, _mockProcessDataGateway.Object,
_mockSystemTime.Object);
(_, _, _relationship, _, _, _oppositeRelationship) = PersonalRelationshipsHelper.SavePersonWithPersonalRelationshipAndOppositeToDatabase(DatabaseContext);
}
public void Should_be_able_to_catch_exception()
{
var dataSource = DefaultDataSource();
var databaseConnectionCache = new Mock<IDatabaseConnectionCache>();
databaseConnectionCache.Setup(m => m.Get(dataSource)).Returns((IDatabaseConnection) null);
var gateway = new DatabaseGateway(databaseConnectionCache.Object);
gateway.GetDataTableFor(dataSource, new Mock<IQuery>().Object);
}
public bool InsertNewRecovery(DateTime StartDate, DateTime EndDate)
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@Date", StartDate));
param.Add(new SqlParameter("@ToDate", EndDate));
var success = Convert.ToString(DatabaseGateway.GetScalarDataUsingStoredProcedure("sp_Insert_New_Recovery_Records_Count", param));
return(true);
}
protected void EmptyDataStore()
{
using (CreateDatabaseContext())
{
DatabaseGateway.ExecuteUsing(RawQuery.Create("delete from EventStore"));
DatabaseGateway.ExecuteUsing(RawQuery.Create("delete from KeyStore"));
DatabaseGateway.ExecuteUsing(RawQuery.Create("delete from SnapshotStore"));
DatabaseGateway.ExecuteUsing(RawQuery.Create("delete from TypeStore"));
DatabaseGateway.ExecuteUsing(RawQuery.Create("delete from ProjectionPosition"));
}
}
protected void ClearDataStore()
{
using (DatabaseContextFactory.Create(EventStoreConnectionStringName))
{
DatabaseGateway.ExecuteUsing(RawQuery.Create("delete from EventStore where Id = @Id").AddParameterValue(Columns.Id, RecallFixture.OrderId));
DatabaseGateway.ExecuteUsing(RawQuery.Create("delete from EventStore where Id = @Id").AddParameterValue(Columns.Id, RecallFixture.OrderProcessId));
DatabaseGateway.ExecuteUsing(RawQuery.Create("delete from KeyStore where Id = @Id").AddParameterValue(Columns.Id, RecallFixture.OrderId));
DatabaseGateway.ExecuteUsing(RawQuery.Create("delete from KeyStore where Id = @Id").AddParameterValue(Columns.Id, RecallFixture.OrderProcessId));
DatabaseGateway.ExecuteUsing(RawQuery.Create("delete from SnapshotStore where Id = @Id").AddParameterValue(Columns.Id, RecallFixture.OrderId));
DatabaseGateway.ExecuteUsing(RawQuery.Create("delete from SnapshotStore where Id = @Id").AddParameterValue(Columns.Id, RecallFixture.OrderProcessId));
}
}
public void Retrives_All_Batches()
{
var databaseGateway = new DatabaseGateway(ConnectionStringReader.GetIntegration(), TestDatabaseName);
var source = new DatabaseSourceGateway(databaseGateway);
var batches = source.GetBatches(null);
Assert.AreEqual(6, batches.Count());
var proc = batches.FirstOrDefault(p => p.ObjectName == "[dbo].[a_procedure]");
Assert.IsNotNull(proc);
}
public void Retrieves_Last_Statement_In_Large_Procedure()
{
var databaseGateway = new DatabaseGateway(ConnectionStringReader.GetIntegration(), TestDatabaseName);
var source = new DatabaseSourceGateway(databaseGateway);
var batches = source.GetBatches(null);
Assert.AreEqual(6, batches.Count());
var proc = batches.FirstOrDefault(p => p.ObjectName == "[dbo].[a_large_procedure]");
Assert.AreEqual(2, proc.StatementCount);
}
public List <string> GetMembers()
{
var gateway = new DatabaseGateway();
var transformer = new MemberRowTransformer();
var result = new List <string>();
foreach (string i in gateway.RetrieveSqlAs("SELECT members FROM dbo.tbl_Category", transformer))
{
result.Add(i);
}
return(result);
}
public void Start()
{
gateway = new DatabaseGateway("SqlSubscriptionManager", connectionStringSettingsProvider);
existsQuery = scriptConfiguration.GetScript(Script.SubscriptionManagerExists);
createQuery = scriptConfiguration.GetScript(Script.SubscriptionManagerCreate);
subscribeQuery = scriptConfiguration.GetScript(Script.SubscriptionManagerSubscribe);
unsubscribeQuery = scriptConfiguration.GetScript(Script.SubscriptionManagerUnsubscribe);
unsubscribeAllQuery = scriptConfiguration.GetScript(Script.SubscriptionManagerUnsubscribeAll);
inboxWorkQueueUrisQuery = scriptConfiguration.GetScript(Script.SubscriptionManagerInboxWorkQueueUrisQuery);
backboneInboxWorkQueueUriQuery = scriptConfiguration.GetScript(Script.SubscriptionManagerBackboneInboxWorkQueueUriQuery);
backboneInboxWorkQueueUrisQuery = scriptConfiguration.GetScript(Script.SubscriptionManagerBackboneInboxWorkQueueUrisQuery);
Create();
}
