public Store GetStoreById(GetStore pGetStore)
{
string path;
string connectionString;
if (pGetStore.IsTest)
{
path = Directory.GetParent(Directory.GetCurrentDirectory()).Parent.Parent.Parent.FullName;
connectionString = string.Format("Server=(localdb)\\MSSQLLocalDB;Integrated Security=true;AttachDbFileName={0}\\PaymentGateway.Dal\\Database\\PaymentGateway.mdf;Database=PaymantGateway;Trusted_Connection=Yes;", path);
}
else
{
path = Path.GetDirectoryName(Path.GetDirectoryName(Directory.GetCurrentDirectory()));
connectionString = string.Format("Server=(localdb)\\MSSQLLocalDB;Integrated Security=true;AttachDbFileName={0}\\PaymentGatewayApi\\PaymentGateway.Dal\\Database\\PaymentGateway.mdf;Database=PaymantGateway;Trusted_Connection=Yes;", path);
}
_optionsBuilder.UseSqlServer(connectionString);
using (var paymentGatewayContext = new PaymentGatewayContext(_optionsBuilder.Options))
{
return(paymentGatewayContext.Stores.Include(store => store.RelStoreAcquirer)
.ThenInclude(relStoreAcquirer => relStoreAcquirer.Acquirer).Where(s => s.Id.Equals(pGetStore.Id)).FirstOrDefault());
}
}
public void SaveTransaction(Transaction pTransaction)
{
string path;
string connectionString;
if (pTransaction.IsTest)
{
path = Directory.GetParent(Directory.GetCurrentDirectory()).Parent.Parent.Parent.FullName;
connectionString = string.Format("Server=(localdb)\\MSSQLLocalDB;Integrated Security=true;AttachDbFileName={0}\\PaymentGateway.Dal\\Database\\PaymentGateway.mdf;Database=PaymantGateway;Trusted_Connection=Yes;", path);
}
else
{
path = Path.GetDirectoryName(Path.GetDirectoryName(Directory.GetCurrentDirectory()));
connectionString = string.Format("Server=(localdb)\\MSSQLLocalDB;Integrated Security=true;AttachDbFileName={0}\\PaymentGatewayApi\\PaymentGateway.Dal\\Database\\PaymentGateway.mdf;Database=PaymantGateway;Trusted_Connection=Yes;", path);
}
_optionsBuilder.UseSqlServer(connectionString);
using (var paymentGatewayContext = new PaymentGatewayContext(_optionsBuilder.Options))
{
paymentGatewayContext.Transactions.Add(pTransaction);
paymentGatewayContext.SaveChanges();
}
}