public static void entityInsert(Entity entity, Account account)
{
var _esc = new EntityServiceClient();
var _parentEntity = _esc.LoadEntity2(entity.ParentID)[0];
entity.ExchangeRate = _parentEntity.ExchangeRate;
entity.Currency.CurrencyID = _parentEntity.Currency.CurrencyID;
_esc.NewEntity3(entity, account);
}
private bool checkSameTransaction(int entityID,string entityName)
{
var esc = new EntityServiceClient();
EntityCollection _ec = new EntityCollection();
EntityCollection _ecs = new EntityCollection(esc.LoadEntity2(entityID));
var _newTallyCollection = EntitiesFunc.entityCollectioin(_ec, _ecs);
if (_newTallyCollection.Where(x => (x.SumType == SumType.Transaction && x.EntityName == entityName) || (x.SumType == SumType.Subtotal && x.EntityName == entityName)).Count() > 0)
return true;
else
return false;
}
private void insertNodeEntity(string jsonEntityString)
{
JsonEntities _jsonEntity = JsonConvert.DeserializeObject<JsonEntities>(jsonEntityString);
if (checkSameTransaction(_jsonEntity.ParentID,_jsonEntity.EntityName) && (_jsonEntity.SumType==1 || _jsonEntity.SumType==2))
{
Response.Write(string.Format("There are two {0} {1} Entities!", _jsonEntity.EntityName,EntitiesFunc.sumTypeFunc(_jsonEntity.SumType)));
}
else
{
var _epsr = new EndPeriodServiceClient();
var _esr = new EntityServiceClient();
decimal _exchangeRate;
Currency _currency;
if(_jsonEntity.SumType==1)
{
_currency = new Currency{CurrencyID =_jsonEntity.EntityName};
_exchangeRate = _epsr.GetEndPeriodRate(new Currency { CurrencyID = _jsonEntity.EntityName })[0].ExchangeRate;
}
else if (_jsonEntity.SumType == 2)
{
_currency = _esr.LoadEntity2(_jsonEntity.ParentID)[0].Currency;
_exchangeRate = decimal.Parse(_jsonEntity.EntityName);
}
else if (_jsonEntity.ParentID == 0)
{
_currency = null;
_exchangeRate = 1;
}
else
{
var _parentSubTotalEntity= _esr.QueryParentSubTotalEntity(_jsonEntity.ParentID)[0];
_exchangeRate = _parentSubTotalEntity.ExchangeRate;
_currency = _parentSubTotalEntity.Currency;
}
#region "Entity"
Entity _entity = new Entity
{
EntityName = _jsonEntity.EntityName,
EntityType = EntitiesFunc.entityTypeFunc(_jsonEntity.EntityType),
IsAccount = _jsonEntity.IsAccount ? 1 : 0,
IsLastLevel = _jsonEntity.IsLastLevel ? 1 : 0,
ParentID = _jsonEntity.ParentID,
ExchangeRate = _exchangeRate,
Currency = _currency,
SumType = EntitiesFunc.sumTypeFunc(_jsonEntity.SumType)
};
#endregion
try
{
if (!_jsonEntity.IsAccount)
{//no account
EntitiesFunc.entityInsert(_entity);
}
else
{//has account
#region "Account"
Account _account = new Account
{
AccountName = _jsonEntity.Account.AccountName,
Company = _jsonEntity.Account.Company,
Password = _jsonEntity.Account.Password,
AccountType = EntitiesFunc.accoutnTypeFunc(_jsonEntity.Account.AccountType),
BettingLimit = _jsonEntity.Account.BettingLimit,
DateOpen = _jsonEntity.Account.DateOpen,
Factor = _jsonEntity.Account.Factor,
Personnel = _jsonEntity.Account.Personnel,
IP = _jsonEntity.Account.IP,
Odds = _jsonEntity.Account.Odds,
IssuesConditions = _jsonEntity.Account.IssuesConditions,
RemarksAcc = _jsonEntity.Account.RemarksAcc,
Perbet = _jsonEntity.Account.Perbet
};
#endregion
EntitiesFunc.entityInsert(_entity, _account);
}
Response.Write("Success!");
}
catch
{
Response.Write("Fail!");
}
}
}