public void It_should_rollback_first_command()
{
// ARRANGE
IUnitOfWork uow = null;
var repository = Fixture.CreateRepository(out uow);
// reset this test
repository.Delete<Customer>(c => c.FirstName == "Joe" && c.LastName == "Jellybean");
// ACT
using (var transaction = new TransactionContext().Begin())
{
try
{
repository.Add<Customer>(new Customer { FirstName = "Joe", LastName = "Jellybean" });
uow.SaveChanges();
// ProductName is required. force a failure.
repository.Add<Product>(new Product { ProductName = null });
uow.SaveChanges();
// should cause a rollback on customer insert (above)
transaction.Commit();
}
catch (DbEntityValidationException)
{
}
}
// ASSERT
var customer = repository.Find<Customer>(c => c.FirstName == "Joe" && c.LastName == "Jellybean");
Assert.IsNull(customer);
}
private void Button_Click(object sender, RoutedEventArgs e)
{
MessageTextBlock.Text = "Created Transaction Context";
_context = _context ?? CreateTxContext(decimal.Parse(amountField.Text));
_context.Completed += context_Completed;
_context.Begin(true);
}
public void It_should_persist_the_changes_to_the_database()
{
// ARRANGE
IUnitOfWork uow = null;
var repository = Fixture.CreateRepository(out uow);
// ACT
using (var transaction = new TransactionContext().Begin())
{
repository.Add<Customer>(new Customer { FirstName = "Joe", LastName = "Jellybean" });
uow.SaveChanges();
repository.Add<Product>(new Product { ProductName = "Logitech Mouse" });
uow.SaveChanges();
transaction.Commit();
}
// ASSERT
var customer = repository.Find<Customer>(c => c.FirstName == "Joe" && c.LastName == "Jellybean");
var product = repository.Find<Product>(p => p.ProductName == "Logitech Mouse");
Assert.IsNotNull(customer);
Assert.IsNotNull(product);
}
public static async Task SimpleTest()
{
const string TraceFileName = "Transactions.TransactionHandlerTest.SimpleTest.log.csv";
try
{
Trace.AutoFlush = true;
Trace.Listeners.Add(new TextWriterTraceListener(new StreamWriter(TraceFileName, false)));
using (var dataSource = new MockDataSource("ds", "tx"))
using (var context = new TransactionContext(TransactionContextAffinity.RequiresNew))
{
var command = new MockDataCommand();
await dataSource.ExecuteNonQuery(command).ConfigureAwait(false);
context.VoteCommit();
}
}
finally
{
Trace.Close();
}
CheckTraceLog(TraceFileName);
}
public void CreateTransactionContextTest(TransactionContextAffinity affinity)
{
using (var context = new TransactionContext(affinity))
{
Assert.AreEqual(affinity, context.Affinity);
Assert.AreEqual(TransactionContextState.Entered, context.State);
Assert.AreEqual(IsolationLevel.ReadCommitted, context.IsolationLevel);
}
}
void context_Completed(TransactionContext sender, RetailSDKException error, TransactionRecord record)
{
var errorMsg = (error != null ? error.ToString() : "no error");
Dispatcher.BeginInvoke(new Action(() =>
{
MessageTextBlock.Text = "Transaction Completed " + errorMsg;
}));
_context = null;
}
private void RemoveId(TransactionContext context)
{
var referenceSystem = context._transaction.ReferenceSystem();
var reference = referenceSystem.ReferenceForId(((int) context._object)
);
if (reference != null)
{
referenceSystem.RemoveReference(reference);
}
}
private ServiceConfig CreateServiceConfig(TransactionContext trCtx)
{
ServiceConfig config = new ServiceConfig();
TransactionOption transactionOption =
(TransactionOption)Enum.Parse(typeof(TransactionOption), trCtx.Affinity.ToString());
config.Transaction = transactionOption;
System.EnterpriseServices.TransactionIsolationLevel isolationLevel =
(System.EnterpriseServices.TransactionIsolationLevel)Enum.Parse(typeof(System.EnterpriseServices.TransactionIsolationLevel), trCtx.IsolationLevel.ToString());
config.IsolationLevel = isolationLevel;
return config;
}
public void OnRequest(IHttpServerTransaction transaction, HttpRequestHead request, bool shouldKeepAlive)
{
AddXFF(request, transaction.RemoteEndPoint);
var expectContinue = request.IsContinueExpected();
var ignoreResponseBody = request.Method != null && request.Method.ToUpperInvariant() == "HEAD";
currentContext = new TransactionContext(expectContinue, ignoreResponseBody, shouldKeepAlive);
if (lastSegment == null)
currentContext.Segment.AttachTransaction(transaction);
QueueSegment(currentContext.Segment);
requestDelegate.OnRequest(request, currentContext.RequestBody, currentContext);
}
public TakePayment()
{
InitializeComponent();
RetailSDK.SetNetworkHandler(new CustomNetworkHandler());
RetailSDK.Initialize();
ChargeButton.IsEnabled = false;
MessageTextBlock.Text = "SDK Initialized";
InitializeMerchant();
//Synchronizing amount field to terminal display
amountField.TextChanged += (sender, args) =>
{
decimal amount;
if (_context != null && _context.Invoice != null && decimal.TryParse(amountField.Text, out amount))
{
//This would pump the updated total to the payment device
_context.Invoice.Items[0].UnitPrice = amount;
}
};
RetailSDK.DeviceDiscovered += (sender, device) =>
{
device.Connected += pd =>
{
try
{
var deviceId = pd.Id;
Dispatcher.BeginInvoke(new Action(() =>
{
MessageTextBlock.Text = string.Format("{0}Connected to {1}", merchantStatus, deviceId);
ChargeButton.IsEnabled = true;
const decimal serviceFee = 2.7m;
var total = decimal.Parse(amountField.Text);
_context = CreateTxContext(total);
_context.TotalDisplayFooter = string.Format("\n+${0}% fee\n${1}", serviceFee, decimal.Round(total * (1 + serviceFee/100), 2));
}));
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
};
};
}
public IOperationResult CreatePackage(Package package)
{
//check if package already exist!
// return new OperationResult() { Result = false, Message = "Package already exist!", Data = new List<object> { Package.Id } };
bool result;
using (var transactionContext = new TransactionContext())
{
result = cdDataProvider.CreatePackage(package, transactionContext);
if (result)
{
transactionContext.Commit();
}
}
return new OperationResult() { Result = result, Data = new List<object> { } };
}
internal override EntityDesignerViewModel LoadModel(
SerializationResult serializationResult, Partition partition, string fileName, ISchemaResolver schemaResolver,
ValidationController validationController, ISerializerLocator serializerLocator)
{
var docData = VSHelpers.GetDocData(PackageManager.Package, fileName) as IEntityDesignDocData;
docData.CreateAndLoadBuffer();
EntityDesignerViewModel evm = null;
var serializationContext = new SerializationContext(GetDirectory(partition.Store), fileName, serializationResult);
var transactionContext = new TransactionContext();
transactionContext.Add(SerializationContext.TransactionContextKey, serializationContext);
using (var t = partition.Store.TransactionManager.BeginTransaction("Load Model from " + fileName, true, transactionContext))
{
var uri = Tools.XmlDesignerBase.Base.Util.Utils.FileName2Uri(fileName);
var context = PackageManager.Package.DocumentFrameMgr.EditingContextManager.GetNewOrExistingContext(uri);
evm =
ModelTranslatorContextItem.GetEntityModelTranslator(context).TranslateModelToDslModel(null, partition) as
EntityDesignerViewModel;
if (evm == null)
{
serializationResult.Failed = true;
}
else
{
if (t.IsActive)
{
t.Commit();
}
}
}
// Validate imported model
if (!serializationResult.Failed
&& (validationController != null))
{
validationController.Validate(partition, ValidationCategories.Load);
}
return evm;
}
public void It_should_not_persist_to_the_database()
{
// ARRANGE
IUnitOfWork uow = null;
var repository = Fixture.CreateRepository(out uow);
// reset this test
repository.Delete<Customer>(c => c.FirstName == "Joe" && c.LastName == "Jellybean");
// ACT
using (var transaction = new TransactionContext().Begin())
{
repository.Add<Customer>(new Customer { FirstName = "Joe", LastName = "Jellybean" });
//transaction.Commit(); // ommit for this test
}
// ASSERT
var customer = repository.Find<Customer>(c => c.FirstName == "Joe" && c.LastName == "Jellybean");
Assert.IsNull(customer);
}
public SimpleMembershipInitializer()
{
Database.SetInitializer<TransactionContext>(null);
try
{
using (var context = new TransactionContext())
{
if (!context.Database.Exists())
{
// Create the SimpleMembership database without Entity Framework migration schema
((IObjectContextAdapter)context).ObjectContext.CreateDatabase();
}
}
WebSecurity.InitializeDatabaseConnection("TransactionContext", "UserProfile", "UserId", "UserName", autoCreateTables: true);
}
catch (Exception ex)
{
throw new InvalidOperationException("The Membership database could not be initialized. For more information, please see http://go.microsoft.com/fwlink/?LinkId=256588", ex);
}
}
/// <summary>
/// This method loads the DSL view model with the items in the artifact's C-Model.
/// </summary>
internal void ReloadModel(EntityDesignerViewModel viewModel)
{
var diagram = viewModel.GetDiagram();
if (diagram == null)
{
// empty DSL diagram
return;
}
// get our artifact
var artifact = EditingContextManager.GetArtifact(viewModel.EditingContext) as EntityDesignArtifact;
Debug.Assert(artifact != null);
var serializationResult = new SerializationResult();
var serializationContext = new SerializationContext(GetDirectory(viewModel.Store), artifact.Uri.LocalPath, serializationResult);
var transactionContext = new TransactionContext();
transactionContext.Add(SerializationContext.TransactionContextKey, serializationContext);
var workaroundFixSerializationTransactionValue = false;
if (viewModel.Store.PropertyBag.ContainsKey("WorkaroundFixSerializationTransaction"))
{
workaroundFixSerializationTransactionValue = (bool)viewModel.Store.PropertyBag["WorkaroundFixSerializationTransaction"];
}
try
{
// To fix performance issue during reload, we turn-off layout during "serialization".
viewModel.Store.PropertyBag["WorkaroundFixSerializationTransaction"] = true;
using (var t = viewModel.Store.TransactionManager.BeginTransaction("ReloadModel", true, transactionContext))
{
if (artifact.ConceptualModel() == null)
{
return;
}
DesignerModel.Diagram diagramModel = null;
// If DiagramId is not string empty, try to get the diagram from the artifact.
// There is a situation where we could not find the diagram given an ID (for example: EDMX Model's Diagram that is created by VS before SQL 11;
// In that case, we assign temporary ID to the diagram and a new ID will be generated every time the model is reloaded.)
// We could safely choose the first diagram since multiple diagrams feature didn't exist in VS prior to SQL11 release.
if (!string.IsNullOrEmpty(diagram.DiagramId))
{
diagramModel = artifact.DesignerInfo.Diagrams.GetDiagram(diagram.DiagramId);
}
if (diagramModel == null)
{
diagramModel = artifact.DesignerInfo.Diagrams.FirstDiagram;
}
if (diagramModel != null)
{
// Re-establish the xref between Escher conceptual model and DSL root model.
// and between Escher Diagram model and DSL diagram model.
Debug.Assert(viewModel.ModelXRef != null, "Why ModelXRef is null?");
if (viewModel.ModelXRef != null)
{
viewModel.ModelXRef.Add(artifact.ConceptualModel(), viewModel, viewModel.EditingContext);
viewModel.ModelXRef.Add(diagramModel, diagram, viewModel.EditingContext);
ModelTranslatorContextItem.GetEntityModelTranslator(viewModel.EditingContext)
.TranslateModelToDslModel(diagramModel, viewModel.Partition);
}
}
if (t.IsActive)
{
t.Commit();
}
}
}
finally
{
viewModel.Store.PropertyBag["WorkaroundFixSerializationTransaction"] = workaroundFixSerializationTransactionValue;
}
}
public virtual TransactionContext Enter()
{
if(_state != TransactionContextState.Created
&& _state != TransactionContextState.Exitted)
throw new InvalidContextStateException(_state, new TransactionContextState[] { TransactionContextState.Created, TransactionContextState.Exitted }, "Context should be in one of the following states in Enter - {Created, Exitted}.");
TransactionContextState fromState = _state;
parentContext = CallContext.GetData(THREAD_CURRENT_CONTEXT__KEY) as TransactionContext;
CallContext.SetData(THREAD_CURRENT_CONTEXT__KEY, this);
_state = TransactionContextState.Entered;
RaiseStateChangedEvent(fromState);
return this;
}
public static void Initialize(string dataPath, string virtualPath)
{
Licensing.ActivateLicense(
@"<License>
<Field name='Name'>Daniel Honaker</Field>
<Field name='sfId'>003j000000RSOxBAAX</Field>
<Component name='Dynamic Geometry Library' expiration='2015/11/18' />
<Component name='Navigation Accuracy Library' expiration='2015/11/18' />
<Component name='Terrain Analysis Library' expiration='2015/11/18' />
<Component name='Spatial Analysis Library' expiration='2015/11/18' />
<Component name='Communications Library' expiration='2015/11/18' />
<Component name='Insight3D' expiration='2015/11/18' />
<Component name='Tracking Library' expiration='2015/11/18' />
<Component name='Route Design Library' expiration='2015/11/18' />
<Component name='Orbit Propagation Library' expiration='2015/11/18' />
<Component name='Auto-Routing Library' expiration='2015/11/18' />
<Signature>SJH4qBqzoL2HKM+Q9TbP7NkFk56vYPoroBRERMWikQum8SQF9bBL35E4N0JUCxpIdMVETg2l3JSd4ddGUHmm33+r6Iamau3SYhzyZsk4dmeEztt3HpZiKZsxr4bcEuLSpCe/8qMXxoJUrbr0K34fELpeOSb5FIGHjxdExsafF1E=</Signature>
</License>");
m_virtualPath = virtualPath;
m_earth = CentralBodiesFacet.GetFromContext().Earth;
//Make sure the default descriptor for the ExampleEntity class is set.
ExampleEntity.RegisterEntityClass();
//Create the primary TransactionContext that will be used throughout the application.
TransactionContext context = new TransactionContext();
context.Committed += context_Committed;
//Create the master entity set that will be populated by our data feed.
m_entities = new EntitySet<ExampleEntity>(context);
m_entities.Changed += m_entities_Changed;
//Create and start the data feed.
m_provider = new ExampleEntityProvider(dataPath, m_entities);
m_provider.Start();
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AccountMainVo inVo = (AccountMainVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <AccountMainVo> voList = new ValueObjectList <AccountMainVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select * from (
select tam.rank_name as Account_Name,sum(tam.acquistion_cost) as Total_AcquisitionCose,sum(tam.current_depreciation) as Total_CurrentDepreication,
sum(tam.monthly_depreciation) as Total_MonthlyDepreication,sum(tam.accum_depreciation_now) as Total_AccumDepreication,sum(tam.net_value) as Total_NetBook
from (select a.account_code_name, f.rank_name,g.account_main_id,c.location_cd,e.asset_cd, e.asset_no, e.asset_name, e.asset_model, e.asset_serial, e.asset_supplier,
g.qty, a.account_code_cd, b.account_location_cd, f.rank_cd, b.account_location_name, g.comment_data, e.asset_life, e.acquistion_date, e.acquistion_cost,
g.depreciation_start, g.depreciation_end, g.current_depreciation,g.monthly_depreciation, g.accum_depreciation_now, g.net_value, e.asset_invoice,
g.registration_date_time, g.registration_user_cd from t_account_main g
left join m_account_code a on a.account_code_id = g.account_code_id
left join m_account_location b on b.account_location_id = g.account_location_id
left join m_location c on c.location_id = g.location_id
left join m_user_location d on d.user_location_id = g.user_location_id
left join m_asset e on e.asset_id = g.asset_id
left join m_rank f on f.rank_id = g.rank_id) tam group by tam.rank_name
union
select Case when sum(tam.acquistion_cost) > -1 then 'Total' else 'Total'
end codename, sum(tam.acquistion_cost) as Total_AcquisitionCose,sum(tam.current_depreciation) as Total_CurrentDepreication,
sum(tam.monthly_depreciation) as Total_MonthlyDepreication,sum(tam.accum_depreciation_now) as Total_AccumDepreication,sum(tam.net_value) as Total_NetBook
from (select a.account_code_name, f.rank_name,g.account_main_id,c.location_cd,e.asset_cd, e.asset_no, e.asset_name, e.asset_model, e.asset_serial, e.asset_supplier,
g.qty, a.account_code_cd, b.account_location_cd, f.rank_cd, b.account_location_name, g.comment_data, e.asset_life, e.acquistion_date, e.acquistion_cost,
g.depreciation_start, g.depreciation_end, g.current_depreciation,g.monthly_depreciation, g.accum_depreciation_now, g.net_value, e.asset_invoice,
g.registration_date_time, g.registration_user_cd from t_account_main g
left join m_account_code a on a.account_code_id = g.account_code_id
left join m_account_location b on b.account_location_id = g.account_location_id
left join m_location c on c.location_id = g.location_id
left join m_user_location d on d.user_location_id = g.user_location_id
left join m_asset e on e.asset_id = g.asset_id
left join m_rank f on f.rank_id = g.rank_id) tam ) tbl order by account_name = 'Total'
");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
AccountMainVo outVo = new AccountMainVo
{
// , h., i., k., o.prodution_work_content_name
TotalAccumDepreication = double.Parse(dataReader["Total_AccumDepreication"].ToString()),
TotalAcquisitionCose = double.Parse(dataReader["Total_AcquisitionCose"].ToString()),
TotalCurrentDepreication = double.Parse(dataReader["Total_CurrentDepreication"].ToString()),
TotalMonthlyDepreication = double.Parse(dataReader["Total_MonthlyDepreication"].ToString()),
TotalNetBook = double.Parse(dataReader["Total_NetBook"].ToString()),
AccountCodeName = dataReader["Account_Name"].ToString(),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
protected override SqlTransactionalCommandsContext CreateSqlTransactionalCommandsContext(IDbConnection connection, TransactionContext transactionContext)
{
return(new MySqlSqlTransactionalCommandsContext(this, connection, transactionContext));
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
if (vo == null)
return null;
return getDao.Execute(trxContext, vo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
return(CheckBuildingRelationDao.Execute(trxContext, vo));
}
public bool HasChildren(TransactionContext transactionContext, byte[] parent)
{
var hashSet = transactionContext.Transaction.SelectHashSet <byte[], byte[]>(CHILDREN, parent, 0);
return(hashSet.Count() > 0);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
return(addProcessWorkDao.Execute(trxContext, vo));
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
WareHouseMainVo inVo = (WareHouseMainVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <WareHouseMainVo> voList = new ValueObjectList <WareHouseMainVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select m.invertory_time_cd, m.invertory_time_id, k.unit_name, d.user_location_name,c.location_cd as before, j.location_cd as after, h.detail_postion_cd, g.warehouse_main_id,c.location_cd,e.asset_cd, e.asset_no, e.asset_name, e.asset_model, e.asset_serial, e.asset_supplier, e.asset_invoice, e.label_status, e.asset_po, g.qty, a.account_code_cd, b.account_location_cd, f.rank_cd, b.account_location_name, g.comment_data, e.asset_life, e.acquistion_date, e.acquistion_cost,e.asset_type, g.depreciation_start, g.depreciation_end, g.current_depreciation,g.monthly_depreciation, g.accum_depreciation_now, g.net_value, g.registration_date_time, g.registration_user_cd from t_warehouse_main g
left join m_account_code a on a.account_code_id = g.account_code_id
left join m_account_location b on b.account_location_id = g.account_location_id
left join m_location c on c.location_id = g.before_location_id
left join m_location j on j.location_id = g.after_location_id
left join m_user_location d on d.user_location_id = g.user_location_id
left join m_asset e on e.asset_id = g.asset_id
left join m_rank f on f.rank_id = g.rank_id
left join m_detail_postion h on h.detail_postion_id = g.detail_position_id
left join m_unit k on k.unit_id = g.unit_id
left join t_invertory_equipments l on l.warehouse_main_id = g.warehouse_main_id
left join m_invertory_time m on m.invertory_time_id = l.invertory_time_id
where 1=1 ");
if (!String.IsNullOrEmpty(inVo.AssetCode))
{
sql.Append(@" and e.asset_cd =:asset_cd");
sqlParameter.AddParameterString("asset_cd", inVo.AssetCode);
}
if (!String.IsNullOrEmpty(inVo.RankCode))
{
sql.Append(" and f.rank_cd =:rank_cd");
sqlParameter.AddParameterString("rank_cd", inVo.RankCode);
}
if (!String.IsNullOrEmpty(inVo.AssetModel))
{
sql.Append(" and e.asset_model =:asset_model");
sqlParameter.AddParameterString("asset_model", inVo.AssetModel);
}
if (!String.IsNullOrEmpty(inVo.AssetName))
{
sql.Append(" and e.asset_name =:asset_name");
sqlParameter.AddParameterString("asset_name", inVo.AssetName);
}
if (!String.IsNullOrEmpty(inVo.AssetType))
{
sql.Append(" and e.asset_type =:asset_type");
sqlParameter.AddParameterString("asset_type", inVo.AssetType);
}
if (!String.IsNullOrEmpty(inVo.AssetInvoice))
{
sql.Append(" and e.asset_invoice =:asset_invoice");
sqlParameter.AddParameterString("asset_invoice", inVo.AssetInvoice);
}
if (!String.IsNullOrEmpty(inVo.AfterLocationCd))
{
sql.Append(" and j.location_cd =:location_cd");
sqlParameter.AddParameterString("location_cd", inVo.AfterLocationCd);
}
if (!String.IsNullOrEmpty(inVo.DetailPositionCd))
{
sql.Append(" and h.detail_postion_cd =:detail_postion_cd");
sqlParameter.AddParameterString("detail_postion_cd", inVo.DetailPositionCd);
}
if (!String.IsNullOrEmpty(inVo.LabelStatus))//label status
{
sql.Append(" and e.label_status =:label_status");
sqlParameter.AddParameterString("label_status", inVo.LabelStatus);
}
if (!String.IsNullOrEmpty(inVo.AssetPO))//label status
{
sql.Append(" and e.asset_po =:asset_po");
sqlParameter.AddParameterString("asset_po", inVo.AssetPO);
}
if (!String.IsNullOrEmpty(inVo.Net_Value))//search theo net value
{
if (inVo.Net_Value == "0$")
{
sql.Append(" and g.net_value = 0");
}
else if (inVo.Net_Value == "1$")
{
sql.Append(" and g.net_value > 0 and g.net_value <2 ");
}
}
sql.Append(" and l.invertory_equipments_id in (select max(invertory_equipments_id) from t_invertory_equipments group by warehouse_main_id) ");
sql.Append(" order by g.registration_date_time desc");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
WareHouseMainVo outVo = new WareHouseMainVo
{
// , h., i., k., o.prodution_work_content_name
WareHouseMainId = int.Parse(dataReader["warehouse_main_id"].ToString()),
AfterLocationCd = dataReader["after"].ToString(),
BeforeLocationCd = dataReader["before"].ToString(),
DetailPositionCd = dataReader["detail_postion_cd"].ToString(),
AssetCode = dataReader["asset_cd"].ToString(),
AssetNo = int.Parse(dataReader["asset_no"].ToString()),
AssetName = dataReader["asset_name"].ToString(),
AssetModel = dataReader["asset_model"].ToString(),
AssetSerial = dataReader["asset_serial"].ToString(),
AssetSupplier = dataReader["asset_supplier"].ToString(),
QTY = int.Parse(dataReader["qty"].ToString()),
UnitName = dataReader["unit_name"].ToString(),
UserLocationName = dataReader["user_location_name"].ToString(),
AccountCodeCode = dataReader["account_code_cd"].ToString(),
AccountLocationCode = dataReader["account_location_cd"].ToString(),
RankCode = dataReader["rank_cd"].ToString(),
AccountLocationName = dataReader["account_location_name"].ToString(),
CommnetsData = dataReader["comment_data"].ToString(),
AssetLife = int.Parse(dataReader["asset_life"].ToString()),
AcquisitionDate = DateTime.Parse(dataReader["acquistion_date"].ToString()),
AcquisitionCost = double.Parse(dataReader["acquistion_cost"].ToString()),
StartDepreciation = DateTime.Parse(dataReader["depreciation_start"].ToString()),
EndDepreciation = DateTime.Parse(dataReader["depreciation_end"].ToString()),
CurrentDepreciation = double.Parse(dataReader["current_depreciation"].ToString()),
MonthlyDepreciation = double.Parse(dataReader["monthly_depreciation"].ToString()),
AccumDepreciation = double.Parse(dataReader["accum_depreciation_now"].ToString()),
NetValue = double.Parse(dataReader["net_value"].ToString()),
AssetInvoice = (dataReader["asset_invoice"].ToString()),
AssetType = dataReader["asset_type"].ToString(),
LabelStatus = (dataReader["label_status"].ToString()),
AssetPO = dataReader["asset_po"].ToString(),
Invertory = dataReader["invertory_time_cd"].ToString(),
InvertoryId = int.Parse(dataReader["invertory_time_id"].ToString()),
RegistrationDateTime = DateTime.Parse(dataReader["registration_date_time"].ToString()),
RegistrationUserCode = (dataReader["registration_user_cd"].ToString()),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
return(updateCavityDao.Execute(trxContext, vo));
}
public TransactionRepository(TransactionContext context)
{
_context = context;
_transactions = _context.Transactions;
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
return(deleteCustomerLineMasterMntDao.Execute(trxContext, vo));
}
private static void CreateDeductibleDefinitionIfEnabled(TransactionContext transactionContext, bool isClaimDetailLevelDeductible, List<DeductibleDefinition> deductibles, decimal? amount, bool? isDeductiblePaidByInsurer, string nonFundedMovementType, string fundedMovementType, string productCode, IBusinessComponent context)
{
if (!amount.HasValue)
{
return;
}
var deductibleDefinition = new DeductibleDefinition { Amount = amount.Value, NonFundedMovementType = nonFundedMovementType };
deductibleDefinition.IsClaimDetailDeductible = isClaimDetailLevelDeductible;
if (isDeductiblePaidByInsurer.GetValueOrDefault(false))
{
if (string.IsNullOrEmpty(fundedMovementType))
{
throw new InvalidOperationException(MessageServiceFactory.GetMessageBody(MessageConstants.NoFundedMovementType, nonFundedMovementType));
}
deductibleDefinition.FundedMovementType = fundedMovementType;
}
PopulateRecoveryMovementType(transactionContext, deductibleDefinition, productCode, context);
deductibles.Add(deductibleDefinition);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
MaterialInVo inVo = (MaterialInVo)vo;
//create command
SAPCommandAdapter sapCommandAdapter = base.GetSAPCommandAdaptor(trxContext, SAPRFCNameEnum.RFC_MATERIAL.GetValue());
//create parameter
SAPParameterList sapParameter = sapCommandAdapter.CreateParameterList();
sapParameter.AddParameter("IM_WERKS", inVo.ImWerks); // "1100");
sapParameter.AddParameter("IM_PERIOD_FROM", inVo.ImPeriodFrom); // "20160323");
sapParameter.AddParameter("IM_PERIOD_TO", inVo.ImPeriodTo); // "20160323");
sapParameter.AddParameter("IM_MATERIAL_FROM", inVo.ImMaterialFrom); // "ZP01");
sapParameter.AddParameter("IM_MATERIAL_TO", inVo.ImMaterialTo); // "ZP01");
sapParameter.AddParameter("IM_SOURCE", inVo.ImSource); // "1");
SAPFunction sapFuntion = sapCommandAdapter.Execute(trxContext, sapParameter);
DataTable sapMaterial = sapFuntion.GetSAPTable("TB_MATERIAL_DATA");
DataTable sapVendor = sapFuntion.GetSAPTable("TB_VENDOR_DATA");
DataTable sapReturn = sapFuntion.GetSAPTable("TB_RETURN");
MaterialOutVo outVo = new MaterialOutVo();
////getting material detail
outVo.MaterialListVo = new List <Vo.MaterialOutVo>();
foreach (DataRow dr in sapMaterial.Rows)
{
MaterialOutVo currOutVo = new MaterialOutVo();
currOutVo.outmatnr = ConvertNull <string>(dr, "OUT_MATNR");
currOutVo.outmaktx = ConvertNull <string>(dr, "OUT_MAKTX");
currOutVo.outmtart = ConvertNull <string>(dr, "OUT_MTART");
if (IsValid(ConvertNull <string>(dr, "OUT_ERSDA")))
{
currOutVo.outersda = Convert.ToDateTime(ConvertNull <string>(dr, "OUT_ERSDA"));
}
if (IsValid(ConvertNull <string>(dr, "OUT_LAEDA")))
{
currOutVo.outlaeda = Convert.ToDateTime(ConvertNull <string>(dr, "OUT_LAEDA"));
}
currOutVo.outlvorm1 = ConvertNull <string>(dr, "OUT_LVORM1");
currOutVo.outxchpf = ConvertNull <string>(dr, "OUT_XCHPF");
currOutVo.outmeins = ConvertNull <string>(dr, "OUT_MEINS");
currOutVo.outbismt = ConvertNull <string>(dr, "OUT_BISMT");
currOutVo.outmatkl = ConvertNull <string>(dr, "OUT_MATKL");
currOutVo.outspart = ConvertNull <string>(dr, "OUT_SPART");
currOutVo.outprdha = ConvertNull <string>(dr, "OUT_PRDHA");
currOutVo.outmstae = ConvertNull <string>(dr, "OUT_MSTAE");
currOutVo.outmtpos = ConvertNull <string>(dr, "OUT_MTPOS");
currOutVo.outntgew = Convert.ToDecimal(ConvertNull <string>(dr, "OUT_NTGEW"));
currOutVo.outgewei = ConvertNull <string>(dr, "OUT_GEWEI");
currOutVo.outvolum = Convert.ToDecimal(ConvertNull <string>(dr, "OUT_VOLUM"));
currOutVo.outvoleh = ConvertNull <string>(dr, "OUT_VOLEH");
currOutVo.outgroes = ConvertNull <string>(dr, "OUT_GROES");
currOutVo.outzeinr = ConvertNull <string>(dr, "OUT_ZEINR");
currOutVo.outwerks = ConvertNull <string>(dr, "OUT_WERKS");
currOutVo.outlvorm2 = ConvertNull <string>(dr, "OUT_LVORM2");
currOutVo.outdisgr = ConvertNull <string>(dr, "OUT_DISGR");
currOutVo.outekgrp = ConvertNull <string>(dr, "OUT_EKGRP");
currOutVo.outmmsta = ConvertNull <string>(dr, "OUT_MMSTA");
currOutVo.outdismm = ConvertNull <string>(dr, "OUT_DISMM");
currOutVo.outminbe = Convert.ToDecimal(ConvertNull <string>(dr, "OUT_MINBE"));
currOutVo.outfxhor = Convert.ToInt32(ConvertNull <string>(dr, "OUT_FXHOR"));
currOutVo.outdispo = ConvertNull <string>(dr, "OUT_DISPO");
currOutVo.outdsnam = ConvertNull <string>(dr, "OUT_DSNAM");
currOutVo.outdisls = ConvertNull <string>(dr, "OUT_DISLS");
currOutVo.outbstmi = Convert.ToDecimal(ConvertNull <string>(dr, "OUT_BSTMI"));
currOutVo.outbstma = Convert.ToDecimal(ConvertNull <string>(dr, "OUT_BSTMA"));
currOutVo.outbstfe = Convert.ToDecimal(ConvertNull <string>(dr, "OUT_BSTFE"));
currOutVo.outmabst = Convert.ToDecimal(ConvertNull <string>(dr, "OUT_MABST"));
currOutVo.outrdprf = ConvertNull <string>(dr, "OUT_RDPRF");
currOutVo.outbstrf = Convert.ToDecimal(ConvertNull <string>(dr, "OUT_BSTRF"));
currOutVo.outbeskz = ConvertNull <string>(dr, "OUT_BESKZ");
currOutVo.outsobsl = ConvertNull <string>(dr, "OUT_SOBSL");
currOutVo.outlgpro = ConvertNull <string>(dr, "OUT_LGPRO");
currOutVo.outusequ = ConvertNull <string>(dr, "OUT_USEQU");
currOutVo.outvspvb = ConvertNull <string>(dr, "OUT_VSPVB");
currOutVo.outrgekz = ConvertNull <string>(dr, "OUT_RGEKZ");
currOutVo.outlgfsb = ConvertNull <string>(dr, "OUT_LGFSB");
currOutVo.outdzeit = Convert.ToInt32(ConvertNull <string>(dr, "OUT_DZEIT"));
currOutVo.outplifz = Convert.ToInt32(ConvertNull <string>(dr, "OUT_PLIFZ"));
currOutVo.outwebaz = Convert.ToInt32(ConvertNull <string>(dr, "OUT_WEBAZ"));
currOutVo.outmrppp = ConvertNull <string>(dr, "OUT_MRPPP");
currOutVo.outfhori = ConvertNull <string>(dr, "OUT_FHORI");
currOutVo.outeisbe = Convert.ToDecimal(ConvertNull <string>(dr, "OUT_EISBE"));
currOutVo.outlgrad = Convert.ToDecimal(ConvertNull <string>(dr, "OUT_LGRAD"));
currOutVo.outeislo = Convert.ToDecimal(ConvertNull <string>(dr, "OUT_EISLO"));
currOutVo.outrwpro = ConvertNull <string>(dr, "OUT_RWPRO");
currOutVo.outshflg = ConvertNull <string>(dr, "OUT_SHFLG");
currOutVo.outshzet = Convert.ToInt32(ConvertNull <string>(dr, "OUT_SHZET"));
currOutVo.outshpro = ConvertNull <string>(dr, "OUT_SHPRO");
currOutVo.outstrgr = ConvertNull <string>(dr, "OUT_STRGR");
currOutVo.outvrmod = ConvertNull <string>(dr, "OUT_VRMOD");
currOutVo.outvint1 = Convert.ToInt32(ConvertNull <string>(dr, "OUT_VINT1"));
currOutVo.outvint2 = Convert.ToInt32(ConvertNull <string>(dr, "OUT_VINT2"));
currOutVo.outmiskz = ConvertNull <string>(dr, "OUT_MISKZ");
currOutVo.outmtvfp = ConvertNull <string>(dr, "OUT_MTVFP");
currOutVo.outaltsl = ConvertNull <string>(dr, "OUT_ALTSL");
currOutVo.outkausf = Convert.ToDecimal(ConvertNull <string>(dr, "OUT_KAUSF"));
currOutVo.outkzaus = ConvertNull <string>(dr, "OUT_KZAUS");
if (IsValid(ConvertNull <string>(dr, "OUT_AUSDT")))
{
currOutVo.outausdt = Convert.ToDateTime(ConvertNull <string>(dr, "OUT_AUSDT"));
}
currOutVo.outnfmat = ConvertNull <string>(dr, "OUT_NFMAT");
outVo.MaterialListVo.Add(currOutVo);
}
////getting supplier detail
outVo.SupplierListVo = new List <Vo.SupplierVo>();
foreach (DataRow dr in sapVendor.Rows)
{
SupplierVo currVo = new SupplierVo();
currVo.OutMatnr = ConvertNull <string>(dr, "OUT_MATNR");
currVo.OutWerks = ConvertNull <string>(dr, "OUT_WERKS");
currVo.OutEkorg = ConvertNull <string>(dr, "OUT_EKORG");
if (IsValid(ConvertNull <string>(dr, "OUT_VALID_FROM")))
{
currVo.OutValidFrom = Convert.ToDateTime(ConvertNull <string>(dr, "OUT_VALID_FROM"));
}
if (IsValid(ConvertNull <string>(dr, "OUT_VALID_TO")))
{
currVo.OutValidTo = Convert.ToDateTime(ConvertNull <string>(dr, "OUT_VALID_TO"));
}
currVo.OutVendor = ConvertNull <string>(dr, "OUT_VENDOR");
currVo.OutName = ConvertNull <string>(dr, "OUT_NAME");
outVo.SupplierListVo.Add(currVo);
}
outVo.SapMessageListVo = new List <SapMessageVo>();
foreach (DataRow dr in sapReturn.Rows)
{
SapMessageVo message = new SapMessageVo();
message.MessageType = ConvertNull <string>(dr, "TYPE");
message.MessageCode = ConvertNull <string>(dr, "CODE");
message.Message = ConvertNull <string>(dr, "MESSAGE");
message.LogNumber = ConvertNull <string>(dr, "LOG_NO");
message.LogMessageNumber = ConvertNull <string>(dr, "LOG_MSG_NO");
message.MessageVariable1 = ConvertNull <string>(dr, "MESSAGE_V1");
message.MessageVariable2 = ConvertNull <string>(dr, "MESSAGE_V2");
message.MessageVariable3 = ConvertNull <string>(dr, "MESSAGE_V3");
message.MessageVariable4 = ConvertNull <string>(dr, "MESSAGE_V4");
outVo.SapMessageListVo.Add(message);
}
return(outVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
return(addRoleDao.Execute(trxContext, vo));
}
public ProposalResponse(TransactionContext transactionContext, int status, string message) : base(transactionContext.TxID, transactionContext.ChannelID, status, message)
{
TransactionContext = transactionContext;
proposalResponsePayload = new WeakItem <ProposalResponsePayloadDeserializer, Protos.Peer.FabricProposalResponse.ProposalResponse>((pr) => new ProposalResponsePayloadDeserializer(pr.Payload), () => ProtoProposalResponse);
}
private static async Task ExecuteNode(TransactionContextTestNode node)
{
if (node.Parent == null)
Assert.That(TransactionContext.CurrentTransactionContext, Is.Null);
var tcs = new TaskCompletionSource<TransactionContextState>();
using (var tx = new TransactionContext(node.Affinity))
{
Assert.That(TransactionContext.CurrentTransactionContext, Is.EqualTo(tx));
Assert.That(tx.IsController, Is.EqualTo(node.IsController));
if (node.IsController)
{
tx.StateChanged +=
(s, e) =>
{
if (e.NewState == TransactionContextState.Exited)
tcs.SetResult(e.OldState);
};
}
await node.ExecuteOperation().ConfigureAwait(false);
if (node.Children != null)
{
foreach (var child in node.Children)
await ExecuteNode(child).ConfigureAwait(false);
}
if (node.VoteAction == VoteAction.VoteCommit)
tx.VoteCommit();
else if (node.VoteAction == VoteAction.VoteRollback)
tx.VoteRollback();
}
if (node.Parent == null)
Assert.That(TransactionContext.CurrentTransactionContext, Is.Null);
if (node.IsController)
{
var actualCommitState = await tcs.Task.ConfigureAwait(false);
Assert.That(actualCommitState, Is.EqualTo(node.GetExpectedCommitState()));
}
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
return(deleteLocalSupplierCavityDao.Execute(trxContext, vo));
}
public Transaction()
{
AccessedKeys = new List<string>();
NodesLocation = new Dictionary<string, List<Node>>();
Nodes = new List<Node>();
Central = (ICentralDirectory)Activator.GetObject(
typeof(ICentralDirectory),
"tcp://localhost:9090/CentralDirectory");
while (true)
{
Tctx = Central.BeginTx();
if (Tctx.Txid != -1)
break;
Thread.Sleep(500);
}
Console.WriteLine(Tctx);
}
public BankController(TransactionContext tcontext, UserContext ucontext, BankContext bcontext)
{
_tcontext = tcontext;
_ucontext = ucontext;
_bcontext = bcontext;
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DeliveryOrderVo inVo = (DeliveryOrderVo)vo;
//create command
SAPCommandAdapter sapCommandAdapter = base.GetSAPCommandAdaptor(trxContext, "Z_GTSDFG7301_DELIVERY_RFC"); // SAPRFCNameEnum.RFC_DELIVERY_ORDER.GetValue());
//create parameter for table IT_WERKS
SAPParameterList sapParameterTable1 = sapCommandAdapter.CreateParameterList();
sapParameterTable1.AddParameter("SIGN", "I"); //value set from invo
sapParameterTable1.AddParameter("OPTION", "EQ");
sapParameterTable1.AddParameter("PLANT_LOW", "1100");
sapParameterTable1.AddParameter("PLANT_HIGH", "");
//create parameter for table IT_VBELN
SAPParameterList sapParameterTable2 = sapCommandAdapter.CreateParameterList();
sapParameterTable2.AddParameter("SIGN", "I"); //value set from invo
sapParameterTable2.AddParameter("OPTION", "EQ");
sapParameterTable2.AddParameter("DELIV_NUMB_LOW", inVo.DoNo); //"0081110720"
sapParameterTable2.AddParameter("DELIV_NUMB_HIGH", inVo.DoNo); //"0081110720"
//create parameter for table Z_GTSDFG7301_DELIVERY_RFC
SAPParameterList sapParameter = sapCommandAdapter.CreateParameterList();
sapParameter.AddParameter("IT_WERKS", sapParameterTable1);
sapParameter.AddParameter("IT_VBELN", sapParameterTable2);
SAPFunction sapFuntion = sapCommandAdapter.ExecuteTable(trxContext, sapParameter);
//Header table data
DataTable headerTable = sapFuntion.GetSAPTable("ET_HEADER");
//detail table data
DataTable itemTable = sapFuntion.GetSAPTable("ET_ITEM");
// result message table data
DataTable resultMessageTable = sapFuntion.GetSAPTable("ET_RETURN");
DeliveryOrderVo outVo = new DeliveryOrderVo();
// get the Header data
foreach (DataRow dr in headerTable.Rows)
{
outVo.CreationDate = DateTime.ParseExact(ConvertNull <string>(dr, "ERDAT"), "yyyy-mm-dd", null);
outVo.DoumentDate = DateTime.ParseExact(ConvertNull <string>(dr, "AUDAT"), "yyyy-mm-dd", null);
outVo.Status = ConvertNull <string>(dr, "GBSTK");
outVo.PickedQuantity = (int)double.Parse(ConvertNull <string>(dr, "PIKMG"));
outVo.DoNo = ConvertNull <string>(dr, "VBELN");
outVo.CustomerPoNumber = ConvertNull <string>(dr, "BSTNK");
outVo.CustomerNumber = ConvertNull <string>(dr, "KUNNR").TrimStart('0');
outVo.CustomerName = ConvertNull <string>(dr, "NAME1");
outVo.SoNo = ConvertNull <string>(dr, "VBELN_SALES").TrimStart('0');
outVo.Amount = (int)double.Parse(ConvertNull <string>(dr, "MENGE"));
outVo.DeliveryDate = DateTime.ParseExact(ConvertNull <string>(dr, "BLDAT"), "yyyy-mm-dd", null);
outVo.DocumentType = ConvertNull <string>(dr, "AUART");
}
//get the Item data
outVo.DeliveryOrderDtlList = new List <DeliveryOrderDtlVo>();
foreach (DataRow dr in itemTable.Rows)
{
DeliveryOrderDtlVo dtlOutVo = new DeliveryOrderDtlVo();
dtlOutVo.SoNumber = ConvertNull <string>(dr, "VGBEL");
dtlOutVo.SoItem = ConvertNull <string>(dr, "VGPOS");
dtlOutVo.OrderQuantity = (int)double.Parse(ConvertNull <string>(dr, "KWMENG"));
dtlOutVo.QuantityStock = (int)double.Parse(ConvertNull <string>(dr, "LGMNG"));
dtlOutVo.DoNo = ConvertNull <string>(dr, "VBELN");
dtlOutVo.DeliveryItemNumber = ConvertNull <string>(dr, "POSNR");
dtlOutVo.BatchNo = ConvertNull <string>(dr, "CHARG");
dtlOutVo.MaterialNumber = ConvertNull <string>(dr, "MATNR");
dtlOutVo.MaterialType = ConvertNull <string>(dr, "MTART");
dtlOutVo.MaterialTypeDesc = ConvertNull <string>(dr, "MTBEZ");
dtlOutVo.MaterialDesc = ConvertNull <string>(dr, "MAKTX");
dtlOutVo.MaterialStatisticsGroup = ConvertNull <string>(dr, "VERSG");
dtlOutVo.MaterialStatisticsGroupDesc = ConvertNull <string>(dr, "BEZEI20");
dtlOutVo.MaterialGroup = ConvertNull <string>(dr, "MATKL");
dtlOutVo.MaterialGroupDesc = ConvertNull <string>(dr, "WGBEZ");
dtlOutVo.QuantitySales = (int)double.Parse(ConvertNull <string>(dr, "LFIMG"));
if (!string.Equals(ConvertNull <string>(dr, "ERDAT"), "0000-00-00"))
{
dtlOutVo.PickingDate = DateTime.ParseExact(ConvertNull <string>(dr, "ERDAT"), "yyyy-mm-dd", null);
}
//dtlOutVo.PickingTime = DateTime.ParseExact(ConvertNull<string>(dr, "ERZET"), "HH:mm:ss", null);
dtlOutVo.StorageLocation = ConvertNull <string>(dr, "LGORT");
outVo.DeliveryOrderDtlList.Add(dtlOutVo);
}
//get the Return Message data
outVo.DeliveryOrderResultMessageList = new List <SapMessageVo>();
foreach (DataRow dr in resultMessageTable.Rows)
{
SapMessageVo message = new SapMessageVo();
message.MessageType = ConvertNull <string>(dr, "TYPE");
message.MessageClassId = ConvertNull <string>(dr, "ID");
message.MessageNumber = ConvertNull <string>(dr, "NUMBER");
message.Message = ConvertNull <string>(dr, "MESSAGE");
message.LogNumber = ConvertNull <string>(dr, "LOG_NO");
message.LogMessageNumber = ConvertNull <string>(dr, "LOG_MSG_NO");
message.MessageVariable1 = ConvertNull <string>(dr, "MESSAGE_V1");
message.MessageVariable2 = ConvertNull <string>(dr, "MESSAGE_V2");
message.MessageVariable3 = ConvertNull <string>(dr, "MESSAGE_V3");
message.MessageVariable4 = ConvertNull <string>(dr, "MESSAGE_V4");
outVo.DeliveryOrderResultMessageList.Add(message);
}
return(outVo);
}
private void CommitTransactions(TransactionContext trCtx)
{
Hashtable transactionsByDataSourceToCommit =
dataSourceTransactionsByTrCtx[trCtx] as Hashtable;
if(transactionsByDataSourceToCommit != null)
{
foreach(DictionaryEntry entry in transactionsByDataSourceToCommit)
{
DataSession ds = (DataSession)entry.Value;
ds.Transaction.Commit();
ds.Connection.Close();
}
transactionsByDataSourceToCommit.Clear();
}
}
public TransactionDetailsRepository(TransactionContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public LocationEnum GetLocation(TransactionContext transactionContext, byte[] item)
{
return((LocationEnum)transactionContext.Transaction.Select <byte[], int>(LOCATIONS, item).Value);
}
public MockBusinessTransaction(TransactionContext transactionContext)
{
SetContext(transactionContext);
}
public IOperationResult DeleteTemplateByName(string templateName)
{
// var template=null;//GetTemplateByName(templateName);
if (GetTemplateByName(templateName) == null)
return new OperationResult() { Result = false, Message = "template Name does not exist!", Data = new List<object> { templateName } };
bool IsCommandScheduledAgainstTemplate = false;
using (var dbContext = new DbContext())
{
IsCommandScheduledAgainstTemplate = cdDataProvider.IsCommandScheduledAgainstTemplate(templateName, dbContext);
}
if (IsCommandScheduledAgainstTemplate)
{
return new OperationResult() { Result = false, Message = "Template could not be deleted because there are commands scheduled against this template.Please delete scheduled commands against this template!", Data = new List<object> { templateName } };
}
bool result;
using (var transactionContext = new TransactionContext())
{
// result = cdDataProvider.DeleteTemplateByName(template, transactionContext);
result = cdDataProvider.DeleteTemplateByName(templateName, transactionContext);
if (result)
{
transactionContext.Commit();
}
}
return new OperationResult() { Result = result, Data = new List<object> { templateName } };
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
return(getMoldDao.Execute(trxContext, vo));
}
public IOperationResult UpdatePackage(string id, Package package)
{
//check if package exist!
//return new OperationResult() { Result = false, Message = "Package does not exist!", Data = new List<object> { id } };
bool result;
using (var transactionContext = new TransactionContext())
{
result = cdDataProvider.UpdatePackage(id, package, transactionContext);
if (result)
{
transactionContext.Commit();
}
}
return new OperationResult() { Result = result, Data = new List<object> {id} };
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
return(addProcessDefectiveReasonNewDao.Execute(trxContext, vo));
}
public IOperationResult UpdateTemplateByName(string templateName, Template template)
{
if (GetTemplateByName(templateName) == null)
return new OperationResult() { Result = false, Message = "template Name does not exist!", Data = new List<object> { template.Name } };
template.Params = GetParam(template);
bool result;
using (var transactionContext = new TransactionContext())
{
result = cdDataProvider.UpdateTemplateByName(templateName, template, transactionContext);
if (result)
{
transactionContext.Commit();
}
}
return new OperationResult() { Result = result, Data = new List<object> { template.Name } };
}
private static void PopulateRecoveryMovementType(TransactionContext transactionContext, DeductibleDefinition definition, string productCode, IBusinessComponent context)
{
string movementType;
if (definition.FundedMovementType != null && ClaimsBusinessLogicHelper.TryGetRecoveryReserveMovementType(transactionContext, definition.FundedMovementType, productCode, context, out movementType))
{
definition.RecoveryFundedMovementType = movementType;
}
if (definition.FundedMovementType != null && ClaimsBusinessLogicHelper.TryGetRecoveryReserveMovementType(transactionContext, definition.FundedMovementType, productCode, context, out movementType))
{
definition.RecoveryNonFundedMovementType = movementType;
}
}
public IOperationResult UpdateTerminalFilter(string filterId, FilterDefs terminalFilter)
{
if (!GetTerminalFilters().Any(c => c.FilterId == Convert.ToInt32(filterId)))
return new OperationResult() { Result = false, Message = "Terminal Filter does not exist!", Data = new List<object> { filterId } };
bool result;
using (var transactionContext = new TransactionContext())
{
result = cdDataProvider.UpdateTerminalFilter(filterId, terminalFilter, transactionContext);
if (result)
{
transactionContext.Commit();
}
}
return new OperationResult() { Result = result, Data = new List<object> { terminalFilter.FilterId } };
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
BuildingVo inVo = (BuildingVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("Select ct.building_id, ct.building_cd, ct.building_name, ");
sqlQuery.Append(" ct.factory_cd from m_building ct ");
sqlQuery.Append(" where ct.factory_cd = :faccd ");
if (inVo.BuildingCode != null)
{
sqlQuery.Append(" and ct.building_cd like :buildingcd ");
}
if (inVo.BuildingName != null)
{
sqlQuery.Append(" and ct.building_name like :buildingname ");
}
if (inVo.BuildingId > 0)
{
sqlQuery.Append(" and ct.building_id = :buildingid ");
}
if (inVo.FactoryCode != null)
{
sqlQuery.Append(" and factory_cd = :factorycd ");
}
sqlQuery.Append(" order by ct.building_cd");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
if (inVo.BuildingCode != null)
{
sqlParameter.AddParameterString("buildingcd", inVo.BuildingCode + "%");
}
if (inVo.BuildingId > 0)
{
sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId);
}
if (inVo.BuildingName != null)
{
sqlParameter.AddParameterString("buildingname", inVo.BuildingName + "%");
}
if (inVo.FactoryCode != null)
{
sqlParameter.AddParameterString("factorycd", inVo.FactoryCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
BuildingVo outVo = new BuildingVo();
while (dataReader.Read())
{
BuildingVo currOutVo = new BuildingVo
{
BuildingId = Convert.ToInt32(dataReader["building_id"]),
BuildingCode = dataReader["building_cd"].ToString(),
BuildingName = dataReader["building_name"].ToString(),
FactoryCode = dataReader["factory_cd"].ToString()
};
outVo.BuildingListVo.Add(currOutVo);
}
dataReader.Close();
return(outVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
return(updateInspectionTestInstructionDao.Execute(trxContext, vo));
}
public double TotalWork(TransactionContext transactionContext, byte[] item)
{
return(transactionContext.Transaction.Select <byte[], double>(TOTAL_WORK, item).Value);
}
public IOperationResult CreateTemplate(Template template)
{
if (GetTemplate(template.TemplateId.ToString()) != null)
return new OperationResult() { Result = false, Message = "template id already exist!", Data = new List<object> { template.TemplateId } };
if (GetTemplateByName(template.Name) != null)
return new OperationResult() { Result = false, Message = "template name already exist!", Data = new List<object> { template.Name } };
// Get param
template.Params = GetParam(template);
bool result;
using (var transactionContext = new TransactionContext())
{
result = cdDataProvider.CreateTemplate(template, transactionContext);
if (result)
{
transactionContext.Commit();
}
}
return new OperationResult() { Result = result, Data = new List<object> { template.TemplateId } };
}
public IOperationResult CreateTerminalFilter(FilterDefs terminalFilter)
{
if (GetTerminalFilters().Any(c => c.FilterId == terminalFilter.FilterId || c.FilterName == terminalFilter.FilterName))
return new OperationResult() { Result = false, Message = "Terminal Filter already exist!", Data = new List<object> { terminalFilter.FilterId, terminalFilter.FilterName } };
bool result;
using (var transactionContext = new TransactionContext())
{
result = cdDataProvider.CreateTerminalFilter(terminalFilter, transactionContext);
if (result)
{
transactionContext.Commit();
}
}
return new OperationResult() { Result = result, Data = new List<object> { terminalFilter.FilterId } };
}
public async Task Invoke(IAddressable target, IInvokable invokable, Message message)
{
try
{
// Don't process messages that have already timed out
if (message.IsExpired)
{
message.DropExpiredMessage(MessagingStatisticsGroup.Phase.Invoke);
return;
}
RequestContext.Import(message.RequestContextData);
if (Config.Globals.PerformDeadlockDetection && !message.TargetGrain.IsSystemTarget)
{
UpdateDeadlockInfoInRequestContext(new RequestInvocationHistory(message.TargetGrain, message.TargetActivation, message.DebugContext));
// RequestContext is automatically saved in the msg upon send and propagated to the next hop
// in RuntimeClient.CreateMessage -> RequestContext.ExportToMessage(message);
}
bool startNewTransaction = false;
TransactionInfo transactionInfo = message.TransactionInfo;
if (message.IsTransactionRequired && transactionInfo == null)
{
// TODO: this should be a configurable parameter
var transactionTimeout = Debugger.IsAttached ? TimeSpan.FromMinutes(30) : TimeSpan.FromSeconds(10);
// Start a new transaction
transactionInfo = await this.transactionAgent.Value.StartTransaction(message.IsReadOnly, transactionTimeout);
startNewTransaction = true;
}
if (transactionInfo != null)
{
TransactionContext.SetTransactionInfo(transactionInfo);
}
object resultObject;
try
{
var request = (InvokeMethodRequest)message.GetDeserializedBody(this.SerializationManager);
if (request.Arguments != null)
{
CancellationSourcesExtension.RegisterCancellationTokens(target, request, this.loggerFactory, logger, this, this.cancellationTokenRuntime);
}
var invoker = invokable.GetInvoker(typeManager, request.InterfaceId, message.GenericGrainType);
if (invoker is IGrainExtensionMethodInvoker &&
!(target is IGrainExtension))
{
// We are trying the invoke a grain extension method on a grain
// -- most likely reason is that the dynamic extension is not installed for this grain
// So throw a specific exception here rather than a general InvalidCastException
var error = String.Format(
"Extension not installed on grain {0} attempting to invoke type {1} from invokable {2}",
target.GetType().FullName, invoker.GetType().FullName, invokable.GetType().FullName);
var exc = new GrainExtensionNotInstalledException(error);
string extraDebugInfo = null;
#if DEBUG
extraDebugInfo = Utils.GetStackTrace();
#endif
logger.Warn(ErrorCode.Stream_ExtensionNotInstalled,
string.Format("{0} for message {1} {2}", error, message, extraDebugInfo), exc);
throw exc;
}
#pragma warning disable 618
var invokeInterceptor = this.CurrentStreamProviderRuntime?.GetInvokeInterceptor();
#pragma warning restore 618
var requestInvoker = new GrainMethodInvoker(target, request, invoker, siloInterceptors, interfaceToImplementationMapping, invokeInterceptor);
await requestInvoker.Invoke();
resultObject = requestInvoker.Result;
}
catch (Exception exc1)
{
if (invokeExceptionLogger.IsEnabled(LogLevel.Debug) || message.Direction == Message.Directions.OneWay)
{
invokeExceptionLogger.Warn(ErrorCode.GrainInvokeException,
"Exception during Grain method call of message: " + message, exc1);
}
transactionInfo = TransactionContext.GetTransactionInfo();
if (transactionInfo != null)
{
// Must abort the transaction on exceptions
transactionInfo.IsAborted = true;
if (startNewTransaction)
{
var abortException = (exc1 as OrleansTransactionAbortedException) ??
new OrleansTransactionAbortedException(transactionInfo.TransactionId, exc1);
this.transactionAgent.Value.Abort(transactionInfo, abortException);
exc1 = abortException;
}
}
// If a grain allowed an inconsistent state exception to escape and the exception originated from
// this activation, then deactivate it.
var ise = exc1 as InconsistentStateException;
if (ise != null && ise.IsSourceActivation)
{
// Mark the exception so that it doesn't deactivate any other activations.
ise.IsSourceActivation = false;
var activation = (target as Grain)?.Data;
if (activation != null)
{
invokeExceptionLogger.Info($"Deactivating {activation} due to inconsistent state.");
this.DeactivateOnIdle(activation.ActivationId);
}
}
if (message.Direction != Message.Directions.OneWay)
{
SafeSendExceptionResponse(message, exc1);
}
return;
}
transactionInfo = TransactionContext.GetTransactionInfo();
if (transactionInfo != null && transactionInfo.ReconcilePending() > 0)
{
var abortException = new OrleansOrphanCallException(transactionInfo.TransactionId, transactionInfo.PendingCalls);
// Can't exit before the transaction completes.
TransactionContext.GetTransactionInfo().IsAborted = true;
if (startNewTransaction)
{
this.transactionAgent.Value.Abort(TransactionContext.GetTransactionInfo(), abortException);
}
if (message.Direction != Message.Directions.OneWay)
{
SafeSendExceptionResponse(message, abortException);
}
return;
}
if (startNewTransaction)
{
// This request started the transaction, so we try to commit before returning.
await this.transactionAgent.Value.Commit(transactionInfo);
}
if (message.Direction == Message.Directions.OneWay)
{
return;
}
SafeSendResponse(message, resultObject);
}
catch (Exception exc2)
{
logger.Warn(ErrorCode.Runtime_Error_100329, "Exception during Invoke of message: " + message, exc2);
if (message.Direction != Message.Directions.OneWay)
{
SafeSendExceptionResponse(message, exc2);
}
if (exc2 is OrleansTransactionInDoubtException)
{
// TODO: log an error message?
}
else if (TransactionContext.GetTransactionInfo() != null)
{
// Must abort the transaction on exceptions
TransactionContext.GetTransactionInfo().IsAborted = true;
var abortException = (exc2 as OrleansTransactionAbortedException) ??
new OrleansTransactionAbortedException(TransactionContext.GetTransactionInfo().TransactionId, exc2);
this.transactionAgent.Value.Abort(TransactionContext.GetTransactionInfo(), abortException);
}
}
finally
{
TransactionContext.Clear();
}
}
private void RollbackTransactions(TransactionContext trCtx)
{
Hashtable transactionsByDataSourceToRollback =
dataSourceTransactionsByTrCtx[trCtx] as Hashtable;
if(transactionsByDataSourceToRollback != null)
{
foreach(DictionaryEntry entry in transactionsByDataSourceToRollback)
{
DataSession ds = (DataSession)entry.Value;
ds.Transaction.Rollback();
ds.Connection.Close();
}
transactionsByDataSourceToRollback.Clear();
}
}
public bool IsLocation(TransactionContext transactionContext, byte[] item, LocationEnum location)
{
return(transactionContext.Transaction.Select <byte[], int>(LOCATIONS, item).Value == (int)location);
}
