private async Task InitializeAsync(DualTransaction transaction)
{
sourceTransaction = transaction.Decrease;
sourceSegment = await mapRepository.GetSegmentAsync(transaction.Decrease.StorageId);
destinationSegment = await mapRepository.GetSegmentAsync(transaction.Increase.StorageId);
}
private void ExecuteAddCheckCommand(object obj)
{
try
{
if (SelectedTransaction != null && SelectedBusinessPartner != null)
{
if (!string.IsNullOrEmpty(SelectedTransaction.FiscalNumber))
{
SelectedTransaction.BusinessPartnerId = SelectedBusinessPartner.Id;
_unitOfWork.Repository <TransactionHeaderDTO>().Update(SelectedTransaction);
_unitOfWork.Commit();
var myReport = new SingleTransaction();
myReport.SetDataSource(GetListDataSet());
var report = new ReportViewerCommon(myReport);
report.Show();
CloseWindow(obj);
}
else
{
MessageBox.Show("Fiscal Number can't be empty!");
}
}
}
catch
{
MessageBox.Show("Got problem while getting Attachment!", "Attachment Problem");
}
}
public void PrintTransaction(object obj)
{
var myReport = new SingleTransaction();
myReport.SetDataSource(GetListDataSet2());
var report = new ReportViewerCommon(myReport);
report.Show();
}
public SingleTransactionCommand(
IStorageStore storageStore,
IEventStore eventStore,
ITransactionValidationService transactionValidationService,
SingleTransactionType type,
SingleTransactionData data)
{
this.storageStore = storageStore;
this.eventStore = eventStore;
this.transactionValidationService = transactionValidationService;
this.transaction = CreateTransaction(type, data);
this.transactionEvent = CreateEvent(type, data);
}
public Task ValidateAsync(SingleTransaction transaction)
{
Initialize(transaction);
if (SourceTransactionIsIncrease && IsCurrentUserNotSystem)
{
throw new NotAuthorizedException();
}
if (SourceTransactionIsDecrease && IsCurrentUserNotSourceStorageOwnerOrSystem)
{
throw new NotAuthorizedException();
}
return(Task.CompletedTask);
}
public void ApplyTransaction(SingleTransaction transaction)
{
if (!IsTransactionPossible(transaction))
{
throw new ValidationException();
}
if (transaction.Type == SingleTransactionType.Increase)
{
IncreaseItemQuantity(transaction.Item);
}
else
{
DecreaseItemQuantity(transaction.Item);
}
}
public bool IsTransactionPossible(SingleTransaction transaction)
{
currentTransaction = transaction;
if (CurrentIdNotEqualTransactionId)
{
return(false);
}
if (CurrentTransactionTypeIsDecrease && CurrentItemQuantityLessThanTransactionItemOrEmpty)
{
return(false);
}
return(true);
}
public void GetAttachment(object obj)
{
var myReport = new SingleTransaction();
var dSet = GetAttachmentDataSet();
if (dSet == null)
{
MessageBox.Show("No Data found to display!");
}
else
{
myReport.SetDataSource(dSet);
var report = new ReportViewerCommon(myReport);
report.Show();
}
}
public async Task VisitAsync(SingleTransactionEvent e)
{
var storage = source.FirstOrDefault(entity => entity.Id == e.StorageId);
if (storage == null)
{
return;
}
var item = new Item(e.ItemName, e.ItemCount);
var transaction = new SingleTransaction(e.StorageId, e.TransactionType, item);
if (storage.IsTransactionPossible(transaction))
{
storage.ApplyTransaction(transaction);
}
await Task.CompletedTask;
}
private void Initialize(SingleTransaction transaction)
{
sourceTransaction = transaction;
}
public void UpdateMethod(DataTable dt)
{
string sql;
_data.Open();
SingleTransaction tran = new SingleTransaction(_data);
tran.Begin();
QueryParameterCollection para = new QueryParameterCollection();
try
{
foreach (DataRow dr in dt.Rows)
{
switch (dr.RowState)
{
case DataRowState.Added:
sql = "INSERT INTO T_METHODS(MID,MNAME,COMMENTARY,DETAIL,VALUETYPE,METHODTYPE) " +
"Values(@MID,@MNAME,@COMMENTARY,@DETAIL,@VALUETYPE,@METHODTYPE)";
para.Add("@MID", dt.Rows[0]["MID"]);
para.Add("@MNAME", dt.Rows[0]["MNAME"]);
para.Add("@COMMENTARY", dt.Rows[0]["COMMENTARY"]);
para.Add("@DETAIL", dt.Rows[0]["DETAIL"]);
para.Add("@VALUETYPE", dt.Rows[0]["VALUETYPE"]);
para.Add("@METHODTYPE", dt.Rows[0]["METHODTYPE"]);
break;
case DataRowState.Modified:
sql = "UPDATE T_METHODS SET MNAME=@MNAME,COMMENTARY=@COMMENTARY,DETAIL=@DETAIL,METHODTYPE=@METHODTYPE " +
"Where MID=@MID";
para.Add("@MNAME", dt.Rows[0]["MNAME"]);
para.Add("@COMMENTARY", dt.Rows[0]["COMMENTARY"]);
para.Add("@DETAIL", dt.Rows[0]["DETAIL"]);
para.Add("@VALUETYPE", dt.Rows[0]["VALUETYPE"]);
para.Add("@METHODTYPE", dt.Rows[0]["METHODTYPE"]);
para.Add("@MID", dt.Rows[0]["MID"]);
break;
case DataRowState.Deleted:
sql = "Delete From T_METHODS Where MID=@MID";
para.Add("@MID", dt.Rows[0]["MID"]);
break;
default:
continue;
}
_data.ExecuteNonQuery(sql, para);
}
tran.Commit();
}
catch (Exception e)
{
tran.Rollback();
throw e;
}
finally
{
_data.Close();
}
}
