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 string accountDiv(Entity[] account) { StringBuilder _sbAccount = new StringBuilder(); if (account.Count() > 0) { _sbAccount.Append("<ul>"); for (int i = 0; i < account.Count(); i++) { var t = account[i]; var _esr = new EntityServiceClient(); var _account = _esr.LoadAccount2(t.EntityID)[0]; if (i != account.Count() - 1) _sbAccount.AppendFormat("<li id='account{0}'><a onclick='clickSubEntities(this.id)' id='{0}' entitytype='{1}' er='{2}' currency='{3}' parentid='{4}' entityname='{5}' company='{6}' accountname='{7}' password='******' accounttype='{9}' bettinglimit='{10}' dateopen='{11}' personnel='{12}' ip='{13}' odds='{14}' issuesconditions='{15}' remarks='{16}' factor='{17}' perbet='{18}' status='{19}' accountid='{20}' islastlevel='{21}'><span>{5}</span></a>", t.EntityID, t.EntityType, t.ExchangeRate, t.Currency.CurrencyID, t.ParentID, t.EntityName, _account.Company, _account.AccountName, _account.Password, _account.AccountType, _account.BettingLimit, _account.DateOpen, _account.Personnel, _account.IP, _account.Odds, _account.IssuesConditions, _account.RemarksAcc, _account.Factor, _account.Perbet, _account.Status, _account.ID, t.IsLastLevel); else _sbAccount.AppendFormat("<li class='last' id='account{0}'><a onclick='clickSubEntities(this.id)' id='{0}' entitytype='{1}' er='{2}' currency='{3}' parentid='{4}' entityname='{5}' company='{6}' accountname='{7}' password='******' accounttype='{9}' bettinglimit='{10}' dateopen='{11}' personnel='{12}' ip='{13}' odds='{14}' issuesconditions='{15}' remarks='{16}' factor='{17}' perbet='{18}' status='{19}' accountid='{20}' islastlevel='{21}'><span>{5}</span></a>", t.EntityID, t.EntityType, t.ExchangeRate, t.Currency.CurrencyID, t.ParentID, t.EntityName, _account.Company, _account.AccountName, _account.Password, _account.AccountType, _account.BettingLimit, _account.DateOpen, _account.Personnel, _account.IP, _account.Odds, _account.IssuesConditions, _account.RemarksAcc, _account.Factor, _account.Perbet, _account.Status, _account.ID, t.IsLastLevel); } _sbAccount.Append("</ul>"); } return _sbAccount.ToString(); }
private void loadRelation(int entityId) { const string _deleteIcon = "<span title=\"Remove relation\" onclick=\"deleteRelation(this);\" class=\"ui-button-icon-primary ui-icon ui-icon-closethick \"></span>"; StringBuilder sb = new StringBuilder(); EntityServiceClient _esc = new EntityServiceClient(); var _relationEntity = _esc.RelationEntity(entityId); if (!_relationEntity.Any()) { sb.Append("<tr id=\"trRelationTitle\"><td class=\"relationTitle\">Relation</td><td class=\"relationTitle\">To</td><td class=\"relationTitle\">Value</td><td ></td></tr>"); } else if (!_relationEntity.First().Description.Equals(RelationDescription.PAndLSum)) { sb.Append("<tr id=\"trRelationTitle\"><td class=\"relationTitle\">Relation</td><td class=\"relationTitle\">To</td><td class=\"relationTitle\">Value</td><td ></td></tr>"); foreach (var r in _relationEntity) { sb.AppendFormat("<tr id='rId{0}' rtype='{1}' targetEntityId='{2}' ><td>{3}</td><td>{4}({5})</td><td>{6}</td><td>{7}</td></tr>", entityId, r.Description, r.TargetEntity.EntityID, r.Description, r.TargetEntity.EntityName, r.Entity.EntityName, r.Numeric, _deleteIcon); } } else { sb.Append("<tr id=\"trRelationTitle\"><td class=\"relationTitle\">Relation</td><td class=\"relationTitle\">To</td><td ></td></tr>"); foreach (var r in _relationEntity) { sb.AppendFormat("<tr id='rId{0}' rtype='{1}' targetEntityId='{2}' ><td>{3}</td><td>{4}({5})</td><td>{6}</td></tr>", entityId, r.Description, r.TargetEntity.EntityID, r.Description, r.TargetEntity.EntityName, r.Entity.EntityName, _deleteIcon); } } Response.Write(sb.ToString()); }
public static void entityUpdate(Entity entity, Account account) { var _esc = new EntityServiceClient(); _esc.SaveEntity3(SessionData.UserID,entity, account); }
public static void entityUpdate(Entity entity, CashEntity cashEntity) { var _esc = new EntityServiceClient(); _esc.SaveEntity2(entity, cashEntity); }
public static void entityInsert(Entity entity, CashEntity cashEntity) { var _esc = new EntityServiceClient(); _esc.NewEntity2(entity, cashEntity); }
public static void entityInsert(Entity entity) { var _esc = new EntityServiceClient(); _esc.NewEntity1(entity); }
private void genEntities(int entityID) { var _esr = new EntityServiceClient(); var _entities = _esr.LoadSingleEntityList(entityID); var _transactionEntities = _entities.Where(x => x.SumType == SumType.Transaction); var _subTotalEntities = _entities.Where(x => x.SumType == SumType.Subtotal); var _nodeEntities = _entities.Where(x => x.SumType == SumType.Not && x.ParentID != 0 && x.IsAccount!=1); var _node1 = from e in _nodeEntities where _transactionEntities.Select(x => x.EntityID).Contains(e.ParentID) select e; var _node2 = from e in _nodeEntities where _subTotalEntities.Select(x => x.EntityID).Contains(e.ParentID) select e; var _node3 = from e in _nodeEntities where !_transactionEntities.Select(x => x.EntityID).Contains(e.ParentID) && !_subTotalEntities.Select(x => x.EntityID).Contains(e.ParentID) select e; var _account = _entities.Where(x =>x.IsAccount==1); StringBuilder _sbResponse = new StringBuilder(); nodeDiv(_transactionEntities.ToArray(),"transaction"); _sbResponse.AppendFormat("{0},{1},{2},{3},{4},{5}", nodeDiv(_transactionEntities.ToArray(), "transaction"), nodeDiv(_node1.ToArray(), "nodeone"), nodeDiv(_subTotalEntities.ToArray(), "subtotal"), nodeDiv(_node2.ToArray(), "nodetwo"), accountDiv(_account.ToArray()), nodeDiv(_node3.ToArray(), "NotSet")); Response.Write(_sbResponse.ToString()); }
private void setBadDebt(int entityID) { var _esr = new EntityServiceClient(); try { _esr.ChangeEntityType(entityID, EntityType.BadDebt); Response.Write("Success!"); } catch { Response.Write("Fail!"); } }
private void setER(int entityID, string currency, decimal ER) { var _esc = new EntityServiceClient(); try { _esc.SetCurrencyAndRate(entityID, currency, ER); Response.Write("Set Exchange Rate success!"); } catch { Response.Write("Faled!"); } }
private void removeEntity(int EntityID) { var _esr = new EntityServiceClient(); try { _esr.Disable(EntityID); Response.Write("Success!"); } catch { Response.Write("Fail!"); } }
private void loadSubEntities(int entityID) { var _esr = new EntityServiceClient(); try { Response.Write(JsonEntityFunc.LoadSubEntitiesTree(entityID)); } catch { Response.Write("Fail!"); } }
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!"); } } }
private void removeRelation(int entityId, int targetEntityId) { var _esc = new EntityServiceClient(); try { _esc.RemoveRelation(entityId, targetEntityId); Response.Write("Success!"); } catch (Exception) { Response.Write("Fail!"); } }
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 addRelation(string entityClass, int relationValue, decimal value, int entityId, int targetEntityId) { var _esc = new EntityServiceClient(); //var _relationCollection = if (_esc.GetRelateEntity(entityId).Any(x => x.Description == RelationDescription.Allocate) && relationValue==1) Response.Write("There is already a Allocate Relation!"); else if (relationValue == 5 && entityClass.IndexOf("MainEntity", StringComparison.OrdinalIgnoreCase) == -1) {//when other entities chose the PnLSum Response.Write("PAndLSum type only can be chosen by P&L Main Entity!"); } else if (entityClass.IndexOf("MainEntity", StringComparison.OrdinalIgnoreCase)!=-1 && relationValue<5) {//when PnL Main entity didn't choose the PnLSum type Response.Write("P&L Main Entity only can choose the PnLSum type!"); } else { RelationDescription _newR = relationValue == 1 ? RelationDescription.Allocate : relationValue == 2 ? RelationDescription.Position : relationValue == 3 ? RelationDescription.Commission : relationValue == 4 ? RelationDescription.FollowBet : RelationDescription.PAndLSum; #region "Relation Value" /* switch (_relationValue) { case 1: { _newRD = RelationDescription.Allocate; break; } case 2: { _newRD = RelationDescription.Commission; break; } case 3: { _newRD = RelationDescription.Position; break; } case 4: { _newRD = RelationDescription.FollowBet; break; } } */ #endregion Relation _newRelation = new Relation { Entity = new Entity { EntityID = entityId }, TargetEntity = new Entity { EntityID = targetEntityId }, Description = _newR, Numeric = value }; if (entityId != targetEntityId) { try { _esc.NewRelation(_newRelation); Response.Write("Success!"); } catch (Exception) { Response.Write("Failed!"); } } else { Response.Write("You can't relate to yourself!"); } } }
private void BindTree() { List<MyObject> list = new List<MyObject>(); EntityServiceClient _intclient = new EntityServiceClient(); foreach (Entity entity in new EntityCollection(_intclient.LoadCashMainAndTransaction())) { list.Add(new MyObject() { Id = entity.EntityID, Name = entity.EntityName, ParentId = entity.ParentID, ToolTip = entity.Currency.CurrencyID }); } //Session["TreeList"] = list; BindTree(list, null); }