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);
}
