public void Insert(WeeklySummaryCollection weeklySummaryCollection)
{
foreach (WeeklySummary _week in weeklySummaryCollection)
{
Insert(_week);
}
}
public bool IsWeeklyConfirm(int periodID, int entityID)
{
WeeklySummaryCollection collection = new WeeklySummaryCollection();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "SP_SEL_Table";
SqlParameter _param = command.Parameters.Add("@value1", System.Data.SqlDbType.VarChar);
_param.Value = "Weekly_Summary";
SqlParameter _param2 = command.Parameters.Add("@value2", System.Data.SqlDbType.VarChar);
_param2.Value = "1,2";
SqlParameter _param3 = command.Parameters.Add("@value3", System.Data.SqlDbType.VarChar);
_param3.Value = periodID + "," + entityID;
SqlParameter _param4 = command.Parameters.Add("@order_by1", System.Data.SqlDbType.VarChar);
_param4.Value = "1";
SqlParameter _param5 = command.Parameters.Add("@order_by2", System.Data.SqlDbType.TinyInt);
_param5.Value = 0;
command.CommandType = System.Data.CommandType.StoredProcedure;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
WeeklySummary _week = new WeeklySummary();
PeriodAccess _perioda = new PeriodAccess();
_week.Period = new PeriodCollection(_perioda.Query(Convert.ToInt32(reader["Period_ID"])))[0]; //_periodc[0];
EntityAccess _entity = new EntityAccess();
_week.Entity = new EntityCollection(_entity.Query(Convert.ToInt32(reader["Entity_Id"])))[0];
_week.BaseCurrency = reader["Base_Currency"].ToString();
_week.ExchangeRate = Convert.ToDecimal(reader["Exchange_Rate"].ToString());
_week.BasePrevBalance = Convert.ToDecimal(reader["Base_Prev_Balance"].ToString());
_week.SGDPrevBalance = Convert.ToDecimal(reader["SGD_Prev_Balance"].ToString());
_week.BaseWinAndLoss = Convert.ToDecimal(reader["Base_Win_Lose"].ToString());
_week.SGDWinAndLoss = Convert.ToDecimal(reader["SGD_Win_Lose"].ToString());
_week.BaseTransfer = Convert.ToDecimal(reader["Base_Transfer"].ToString());
_week.SGDTransfer = Convert.ToDecimal(reader["SGD_Transfer"].ToString());
_week.BaseTransaction = Convert.ToDecimal(reader["Base_Transaction"].ToString());
_week.SGDTransaction = Convert.ToDecimal(reader["SGD_Transaction"].ToString());
_week.BaseBalance = Convert.ToDecimal(reader["Base_Balance"].ToString());
_week.SGDBalance = Convert.ToDecimal(reader["SGD_Balance"].ToString());
_week.Status = (WeeklySummaryStatus)Convert.ToInt32(reader["Status"].ToString());
string userinfo = reader["Confirm_User"].ToString();
try
{
UserAccess usera = new UserAccess();
_week.ConfirmUser = new UserCollection(usera.Query(Convert.ToInt32(reader["Confirm_User"])))[0];
}
catch
{
_week.ConfirmUser = new User();
}
collection.Add(_week);
}
reader.Close();
if (collection.Count > 0)
{
if (collection[0].ConfirmUser.UserID.Equals(0))
return false;
else
return true;
}
else
{
return false;
}
}
else
{
reader.Close();
return false;
}
}
}
public void WinLossConfirm(WeeklySummaryCollection weeklySummaryCollection)
{
foreach (WeeklySummary _week in weeklySummaryCollection)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand _command = new SqlCommand();
_command.Connection = connection;
_command.CommandText = "SP_UPD_Table";
SqlParameter _param = _command.Parameters.Add("@value1", System.Data.SqlDbType.VarChar);
_param.Value = "Weekly_Summary";
SqlParameter _param2 = _command.Parameters.Add("@value2", System.Data.SqlDbType.VarChar);
_param2.Value = "7,8,10,13,14,15,16";
StringBuilder _content = new StringBuilder();
_content.AppendFormat("{0}{1}", _week.BaseTransfer, ",");
_content.AppendFormat("{0}{1}", _week.SGDTransfer, ",");
_content.AppendFormat("{0}{1}", _week.BaseBalance, ",");
_content.AppendFormat("{0}{1}", _week.SGDBalance, ",");
_content.AppendFormat("{0}{1}", (int)_week.Status, ",");
_content.AppendFormat("{0}", _week.ConfirmUser.UserID, ",");
SqlParameter _param3 = _command.Parameters.Add("@value3", System.Data.SqlDbType.VarChar);
_param3.Value = _content.ToString();
SqlParameter _param4 = _command.Parameters.Add("@value4", System.Data.SqlDbType.VarChar);
_param4.Value = "1,2";
SqlParameter _param5 = _command.Parameters.Add("@value5", System.Data.SqlDbType.VarChar);
_param5.Value = _week.Period.ID + "," + _week.Entity.EntityID;
_command.CommandType = System.Data.CommandType.StoredProcedure;
connection.Open();
_command.ExecuteNonQuery();
}
}
}
private void HasWeeklySummary(int entityID)
{
WeeklySummaryCollection _wsa;
using (WeeklySummaryAccessClient _weeklySummaryAccessClient = new WeeklySummaryAccessClient(EndpointName.WeeklySummaryAccess))
{
var _period = PeriodService.Instance.GetCurrentPeriod()[0];
_wsa = new WeeklySummaryCollection(_weeklySummaryAccessClient.Query(_period.ID, entityID));
if (!_wsa.Any())
{
using (EntityAccessClient _entityAccessClient = new EntityAccessClient(EndpointName.EntityAccess))
{
var _entity = _entityAccessClient.Query2(entityID)[0];
if (_entity.SumType != SumType.Not)
{
WeeklySummary _newWeeklySummary = new WeeklySummary
{
Entity = _entity,
ExchangeRate = _entity.ExchangeRate,
Period = _period,
BaseCurrency = _entity.Currency.CurrencyID,
};
_weeklySummaryAccessClient.Insert1(_newWeeklySummary);
}
}
}
}
}
public void Update(WeeklySummaryCollection weeklySummaryCollection)
{
foreach (WeeklySummary _week in weeklySummaryCollection)
{
Update(_week);
}
}
public void SetConfirm(Transaction transaction)
{
using (TransactionAccessClient _tran = new TransactionAccessClient(EndpointName.TransactionAccess))
{
SettleService _settle = new SettleService();
WeeklySummaryCollection _weekco = new WeeklySummaryCollection();
//From Entity
WeeklySummary _weekFrom = new WeeklySummary();
_weekFrom.ExchangeRate = transaction.ExchangeRate;
_weekFrom.Period = transaction.Period;
_weekFrom.Entity = transaction.FromEntity;
_weekFrom.BaseTransaction = -(transaction.Amount);
_weekFrom.BaseCurrency = transaction.FromCurrency;
//To Entity
WeeklySummary _weekTo = new WeeklySummary();
_weekTo.ExchangeRate = transaction.ExchangeRate;
_weekTo.Period = transaction.Period;
_weekTo.Entity = transaction.ToEntity;
_weekTo.BaseTransaction = transaction.To_Amount;
_weekTo.BaseCurrency = transaction.ToCurrency;
_weekco.Add(_weekFrom);
_weekco.Add(_weekTo);
_settle.TransactionConfirm(_weekco);
_tran.SetConfirm(transaction.ID, transaction.Updater.UserID, transaction.Period.ID);
}
}
public Tuple<Transfer, Entity> Transfer(int entryUserID, EntityCollection entityCollection, decimal[] baseTransfer)
{
User _user = (new UserAccessClient(EndpointName.UserAccess)).QueryuserID(entryUserID)[0];
Entity _exchangeDiffEntity = EntityService.Instance.LoadEntity(int.Parse(PropertiesService.Instance.GetPropertyValue(SpecialProperty.ExchangeDiff)[0].PropertyValue))[0];
WeeklySummaryCollection _weeklySummaryCollection = new WeeklySummaryCollection();
foreach (Entity _entity in entityCollection)
{
_weeklySummaryCollection.AddRange(GetWeeklySummary(_entity.EntityID));
}
Record _record = RecordHelper.GenerateTempRecord();
_record.Type = RecordType.Transfer;
int _index = 0;
//Transfer
Transfer _transfer = new Transfer()
{
RecordID = _record.RecordID,
ToEntity = entityCollection[_index],
Currency = new Currency() { CurrencyID = _weeklySummaryCollection[_index].BaseCurrency },
ExchangeRate = _weeklySummaryCollection[_index].ExchangeRate,
BaseBefore = _weeklySummaryCollection[_index].BaseBalance,
SGDBefore = _weeklySummaryCollection[_index].SGDBalance,
};
foreach (Entity _entity in entityCollection)
{
if (_index == 0)
{
_index++;
continue;
}
TransferDetail _transferDetail = new TransferDetail()
{
RecordID = _record.RecordID,
Entity = _entity,
BaseCurrency = _weeklySummaryCollection[_index].BaseCurrency,
ExchangeRate = _weeklySummaryCollection[_index].ExchangeRate,
BaseBefore = _weeklySummaryCollection[_index].BaseBalance,
SGDBefore = _weeklySummaryCollection[_index].SGDBalance,
};
_transferDetail.BaseTransfer = baseTransfer[_index];
_transferDetail.SGDTransfer = (_transferDetail.BaseTransfer / _transfer.ExchangeRate).ExtRound();
_transferDetail.ProfitAndLoss = (_transferDetail.BaseTransfer / _transferDetail.ExchangeRate).ExtRound() - _transferDetail.SGDTransfer;
_transferDetail.BaseResult = 0;
_transferDetail.SGDResult = 0;
_transfer.TransferDetailCollection.Add(_transferDetail);
_index++;
}
_transfer.BaseResult = _transfer.TransferDetailCollection.Sum(x=>x.BaseTransfer)+_transfer.BaseBefore;
_transfer.SGDResult = (_transfer.BaseResult / _transfer.ExchangeRate).ExtRound();
//Record
_index = 0;
Journal _journal = new Journal()
{
RecordID = _record.RecordID,
EntityID = entityCollection[_index].EntityID,
BaseCurrency = _transfer.Currency.CurrencyID,
ExchangeRate = _transfer.ExchangeRate,
BaseAmount = _transfer.TransferDetailCollection.Sum(TransferDetail => TransferDetail.BaseTransfer),
SGDAmount = _transfer.TransferDetailCollection.Sum(TransferDetail => TransferDetail.SGDTransfer),
EntryUser = _user,
};
_record.JournalCollection.Add(_journal);
foreach (Entity _entity in entityCollection)
{
if (_index == 0)
{
_index++;
continue;
}
_journal = new Journal()
{
RecordID = _record.RecordID,
EntityID = _entity.EntityID,
BaseCurrency = _transfer.TransferDetailCollection[_index - 1].BaseCurrency,
ExchangeRate = _transfer.TransferDetailCollection[_index - 1].ExchangeRate,
BaseAmount = _transfer.TransferDetailCollection[_index - 1].BaseTransfer * -1,
SGDAmount = (_transfer.TransferDetailCollection[_index - 1].SGDTransfer + _transfer.TransferDetailCollection[_index - 1].ProfitAndLoss) * -1,
EntryUser = _user,
};
_record.JournalCollection.Add(_journal);
_index++;
}
_journal = new Journal()
{
RecordID = _record.RecordID,
EntityID = _exchangeDiffEntity.EntityID,
SGDAmount = _transfer.TransferDetailCollection.Sum(TransferDetail => TransferDetail.ProfitAndLoss)
};
_record.JournalCollection.Add(_journal);
_transfer.RecordNotInDB = _record;
return new Tuple<Transfer, Entity>(_transfer, _exchangeDiffEntity);
}
private EntityCollection SetLastLevel(EntityCollection entityCollection, WeeklySummaryCollection weeklySummaryCollection)
{
for (int i = 0; i < entityCollection.Count; i++)
{
if (entityCollection[i].IsLastLevel == 1)
{
WeeklySummaryCollection _weeklySummaryCollection = CalculateService.Instance.GetWeeklySummary(entityCollection[i].EntityID);
if (_weeklySummaryCollection.Count == 0)
{
entityCollection.RemoveAt(i--);
}
else
{
weeklySummaryCollection.AddRange(_weeklySummaryCollection);
}
continue;
}
EntityCollection _subEntities = entityCollection[i].SubEntities;
entityCollection.RemoveAt(i);
if (_subEntities.Count > 0)
{
entityCollection.InsertRange(i, _subEntities);
}
i--;
}
return entityCollection;
}
private EntityCollection SetTransaction(EntityCollection entityCollection, WeeklySummaryCollection weeklySummaryCollection)
{
for (int i = 0; i < entityCollection.Count; i++)
{
if (entityCollection[i].SumType == SumType.Transaction)
{
entityCollection[i].SubEntities = SetSubtotal(entityCollection[i].SubEntities, weeklySummaryCollection);
WeeklySummaryCollection _weeklySummaryCollection = CalculateService.Instance.GetWeeklySummary(entityCollection[i].EntityID);
if (_weeklySummaryCollection.Count == 0)
{
WeeklySummary _weeklySummary = new WeeklySummary(PeriodService.Instance.GetCurrentPeriod()[0], entityCollection[i]);
using (WeeklySummaryAccessClient _weeklySummaryAccessClient = new WeeklySummaryAccessClient(EndpointName.WeeklySummaryAccess))
{
_weeklySummaryAccessClient.Insert1(_weeklySummary);
}
weeklySummaryCollection.Add(_weeklySummary);
}
else
{
weeklySummaryCollection.AddRange(_weeklySummaryCollection);
}
continue;
}
EntityCollection _subEntities = entityCollection[i].SubEntities;
entityCollection.RemoveAt(i);
if (_subEntities.Count > 0)
{
entityCollection.InsertRange(i, _subEntities);
}
i--;
}
return entityCollection;
}
private WeeklySummaryCollection ExcelConfirmTransfer(EntityCollection entityCollection, WeeklySummaryCollection forSave)
{
WeeklySummaryCollection _return = new WeeklySummaryCollection();
foreach (Entity _entity in entityCollection)
{
if (_entity.IsLastLevel == 1)
{
WeeklySummaryCollection _lastLevel = forSave;
if (_lastLevel.Count == 0)
{
continue;
}
forSave.AddRange(_lastLevel);
_return.AddRange(_lastLevel);
}
else if (_entity.SumType == SumType.Subtotal)
{
WeeklySummaryCollection _lastLevel = ConfirmTransfer(_entity.SubEntities, forSave);
WeeklySummary _subtotal = CalculateService.Instance.GetWeeklySummary(_entity.EntityID)[0];
if (_subtotal.Status == WeeklySummaryStatus.Confirm)
{
forSave.Add(_subtotal);
_return.Add(_subtotal);
continue;
}
_subtotal.BaseTransfer = _lastLevel.Sum(WeeklySummary => WeeklySummary.BaseWinAndLoss);
_subtotal.SGDTransfer = _lastLevel.Sum(WeeklySummary => WeeklySummary.SGDWinAndLoss);
_lastLevel.All(lastLevel =>
{
lastLevel.BaseTransfer = lastLevel.BaseWinAndLoss * -1;
lastLevel.SGDTransfer = lastLevel.SGDWinAndLoss * -1;
lastLevel.BaseBalance += lastLevel.BasePrevBalance + lastLevel.BaseWinAndLoss + lastLevel.BaseTransfer;
lastLevel.SGDBalance += lastLevel.SGDPrevBalance + lastLevel.SGDWinAndLoss + lastLevel.SGDTransfer;
return true;
});
_subtotal.BaseBalance += _subtotal.BasePrevBalance + _subtotal.BaseWinAndLoss + _subtotal.BaseTransfer;
_subtotal.SGDBalance += _subtotal.SGDPrevBalance + _subtotal.SGDWinAndLoss + _subtotal.SGDTransfer;
forSave.Add(_subtotal);
_return.Add(_subtotal);
}
else if (_entity.SumType == SumType.Transaction)
{
WeeklySummaryCollection _subtotal = ConfirmTransfer(_entity.SubEntities, forSave);
WeeklySummary _transfer = CalculateService.Instance.GetWeeklySummary(_entity.EntityID)[0];
if (_transfer.Status == WeeklySummaryStatus.Confirm)
{
forSave.Add(_transfer);
_return.Add(_transfer);
continue;
}
_transfer.BaseTransfer = _subtotal.Sum(WeeklySummary => WeeklySummary.BaseTransfer);
_transfer.SGDTransfer = _subtotal.Sum(WeeklySummary => WeeklySummary.SGDTransfer);
_subtotal.All(subtotal =>
{
subtotal.BaseBalance += subtotal.BasePrevBalance + subtotal.BaseWinAndLoss + subtotal.BaseTransfer;
subtotal.SGDBalance += subtotal.SGDPrevBalance + subtotal.SGDWinAndLoss + subtotal.SGDTransfer;
return true;
});
_transfer.BaseBalance += _transfer.BasePrevBalance + _transfer.BaseWinAndLoss + _transfer.BaseTransfer;
_transfer.SGDBalance += _transfer.SGDPrevBalance + _transfer.SGDWinAndLoss + _transfer.SGDTransfer;
forSave.Add(_transfer);
_return.Add(_transfer);
}
continue;
}
return _return;
}
private WeeklySummaryCollection ConfirmTransfer(EntityCollection entityCollection, WeeklySummaryCollection forSave)
{
WeeklySummaryCollection _return = new WeeklySummaryCollection();
foreach (Entity _entity in entityCollection)
{
if (_entity.IsLastLevel == 1)
{
WeeklySummaryCollection _lastLevel = CalculateService.Instance.GetWeeklySummary(_entity.EntityID);
if (_lastLevel.Count == 0)
{
continue;
}
_lastLevel.All(lastLevel =>
{
List<decimal> _winAndLoss = DataEntryService.Instance.GetjournalSum(PeriodService.Instance.GetCurrentPeriod()[0].ID, (int)SumType.Subtotal, lastLevel.Entity.EntityID);
if (_winAndLoss.Count < 2)
{
return true;
}
lastLevel.BaseWinAndLoss = _winAndLoss[0];
lastLevel.SGDWinAndLoss = _winAndLoss[1];
return true;
});
forSave.AddRange(_lastLevel);
_return.AddRange(_lastLevel);
}
else if (_entity.SumType == SumType.Subtotal)
{
WeeklySummaryCollection _lastLevel = ConfirmTransfer(_entity.SubEntities, forSave);
WeeklySummary _subtotal = CalculateService.Instance.GetWeeklySummary(_entity.EntityID)[0];
_subtotal.BaseWinAndLoss = _lastLevel.Sum(WeeklySummary => WeeklySummary.BaseWinAndLoss);
_subtotal.SGDWinAndLoss = _lastLevel.Sum(WeeklySummary => WeeklySummary.SGDWinAndLoss);
List<decimal> _transfer = DataEntryService.Instance.GetjournalSum(PeriodService.Instance.GetCurrentPeriod()[0].ID, (int)SumType.Transaction, _subtotal.Entity.EntityID);
if (_transfer.Count >= 2)
{
_subtotal.BaseTransfer = _transfer[0];
_subtotal.SGDTransfer = _transfer[1];
}
_lastLevel.All(lastLevel =>
{
lastLevel.BaseBalance = lastLevel.BasePrevBalance + lastLevel.BaseWinAndLoss + lastLevel.BaseTransfer;
lastLevel.SGDBalance = lastLevel.SGDPrevBalance + lastLevel.SGDWinAndLoss + lastLevel.SGDTransfer;
return true;
});
_subtotal.BaseBalance = _subtotal.BasePrevBalance + _subtotal.BaseWinAndLoss + _subtotal.BaseTransfer;
_subtotal.SGDBalance = _subtotal.SGDPrevBalance + _subtotal.SGDWinAndLoss + _subtotal.SGDTransfer;
forSave.Add(_subtotal);
_return.Add(_subtotal);
}
else if (_entity.SumType == SumType.Transaction)
{
WeeklySummaryCollection _subtotal = ConfirmTransfer(_entity.SubEntities, forSave);
WeeklySummary _transfer = CalculateService.Instance.GetWeeklySummary(_entity.EntityID)[0];
_transfer.BaseWinAndLoss = _subtotal.Sum(WeeklySummary => WeeklySummary.BaseBalance);
_transfer.SGDWinAndLoss = _subtotal.Sum(WeeklySummary => WeeklySummary.SGDBalance);
_subtotal.All(subtotal =>
{
//subtotal.BaseBalance = subtotal.BasePrevBalance + subtotal.BaseWinAndLoss + subtotal.BaseTransfer;
//subtotal.SGDBalance = subtotal.SGDPrevBalance + subtotal.SGDWinAndLoss + subtotal.SGDTransfer;
return true;
});
_transfer.BaseBalance = _transfer.BasePrevBalance + _transfer.BaseWinAndLoss + _transfer.BaseTransfer;
_transfer.SGDBalance = _transfer.SGDPrevBalance + _transfer.SGDWinAndLoss + _transfer.SGDTransfer;
forSave.Add(_transfer);
_return.Add(_transfer);
}
continue;
}
return _return;
}
public WeeklySummaryCollection Confirm(int confirmUserID, int entityID)
{
User _confirmUser = (new UserAccessClient(EndpointName.UserAccess)).QueryuserID(confirmUserID)[0];
WeeklySummaryCollection _confirm = new WeeklySummaryCollection();
Entity _entity = EntityService.Instance.LoadEntity(entityID)[0];
if ((_entity.SumType != SumType.Transaction) && (_entity.SumType != SumType.Subtotal))
{
return _confirm;
}
_entity.SubEntities = ((_entity.SumType == SumType.Transaction) ? SetSubtotal(_entity.SubEntities, new WeeklySummaryCollection()) : SetLastLevel(_entity.SubEntities, new WeeklySummaryCollection()));
ConfirmTransfer(new EntityCollection(new Entity[] { _entity }), _confirm);
if (_confirm.Count <= 0)
{
return _confirm;
}
foreach (WeeklySummary _weeklySummary in _confirm)
{
_weeklySummary.Status = WeeklySummaryStatus.Confirm;
_weeklySummary.ConfirmUser = _confirmUser;
}
using (WeeklySummaryAccessClient _weeklySummaryAccessClient = new WeeklySummaryAccessClient(EndpointName.WeeklySummaryAccess))
{
_weeklySummaryAccessClient.Update2(_confirm.ToArray());
}
//<EntityID, RecordID>
Dictionary<int, int> _pairs = new Dictionary<int, int>();
foreach (WeeklySummary _weeklySummary in _confirm)
{
int _recordID = -1;
using (RecordAccessClient _recordAccessClient = new RecordAccessClient(EndpointName.RecordAccess))
{
_pairs[_weeklySummary.Entity.EntityID] = (_recordID = _recordAccessClient.QueryRecordID(_weeklySummary.Entity.EntityID, PeriodService.Instance.GetCurrentPeriod()[0].ID));
}
if (_recordID > 0)
{
if (_pairs.Values.Count(RecordID => (RecordID == _recordID)) == 1)
{
using (RecordAccessClient _recordAccessClient = new RecordAccessClient(EndpointName.RecordAccess))
{
_recordAccessClient.ChangeStatus(_recordID, RecordStatus.Confirm);
}
}
}
}
foreach (KeyValuePair<int, int> _pair in _pairs)
{
if (_pair.Value > 0)
{
continue;
}
Entity _subtotal = null;
if (_entity.SumType == SumType.Transaction)
{
if ((_subtotal = _entity.SubEntities.FirstOrDefault(Entity => (_pair.Key == Entity.EntityID))) == null)
{
continue;
}
}
else if (_pair.Key == _entity.EntityID)
{
_subtotal = _entity;
}
else
{
continue;
}
EntityCollection _entityCollection = new EntityCollection() { _subtotal };
_entityCollection.AddRange(_subtotal.SubEntities);
decimal[] _baseTransfer = new decimal[_entityCollection.Count];
for (int i = 1; i < _entityCollection.Count; i++)
{
_baseTransfer[i] = _confirm.FirstOrDefault(WeeklySummary => (WeeklySummary.Entity.EntityID == _entityCollection[i].EntityID)).BaseTransfer;
}
Transfer _transfer = CalculateService.Instance.Transfer(confirmUserID, _entityCollection, _baseTransfer).Item1;
DataEntryService.Instance.InsertTransfer(_transfer.RecordNotInDB, _transfer);
}
return _confirm;
}
public Tuple<EntityCollection, WeeklySummaryCollection> LoadPAndLEntity(int entityID)
{
EntityCollection _entityTree = EntityService.Instance.LoadEntity();
WeeklySummaryCollection _weeklySummaryCollection = new WeeklySummaryCollection();
_entityTree.RemoveAll(Entity => ((Entity.EntityID != entityID) && (Entity.ParentID == 0)));
foreach (Entity _entity in _entityTree)
{
_entity.SubEntities = SetTransaction(_entity.SubEntities, _weeklySummaryCollection);
WeeklySummaryCollection _transferButNotSave = new WeeklySummaryCollection();
ConfirmTransfer(_entity.SubEntities, _transferButNotSave);
for (int i = 0; i < _weeklySummaryCollection.Count; i++)
{
WeeklySummary _transfer = _transferButNotSave.FirstOrDefault(WeeklySummary => (WeeklySummary.Entity.EntityID == _weeklySummaryCollection[i].Entity.EntityID));
if (_transfer == null)
{
continue;
}
_weeklySummaryCollection[i] = _transfer;
}
}
return new Tuple<EntityCollection, WeeklySummaryCollection>(_entityTree, _weeklySummaryCollection);
}
protected void Tree_FromEntity_SelectedNodeChanged(object sender, EventArgs e)
{
if (Tree_FromEntity.SelectedNode.ImageToolTip.Equals("0"))
return;
tx_FromEntity.Text = Tree_FromEntity.SelectedNode.Text;
lb_FromEntityID.Text = Tree_FromEntity.SelectedNode.Value;
CalculateServiceClient _client = new CalculateServiceClient();
WeeklySummary _week = new WeeklySummaryCollection(_client.GetWeeklySummary(Convert.ToInt32(Tree_FromEntity.SelectedNode.Value)))[0];
lb_FromCurrency.Text = _week.BaseCurrency;
tx_FromAmount.Text = ((int)_week.BaseBalance).ToString();
int _toAmount = 0;
try
{
_toAmount =(int)System.Math.Round(_week.BaseBalance * _week.ExchangeRate,1, MidpointRounding.AwayFromZero);
}
catch
{
//Library.Alert(" Please Check Number ");
_toAmount = 0;
}
tx_Amount.Text = _toAmount.ToString();
Panel_From.Visible = false;
CheckExchange();
}