public double GetActuals(TreeNode <Account> node, TreeNode <Job> job_treenode) { if (job_treenode == null) { return(0); } JobAccount jacc = mAccountant.JobAccountMgr.FindByJobAccount(job_treenode.DataSource, node.DataSource); if (jacc != null) { return(jacc.CurrentBalance); } double sum = 0; if (job_treenode.Children.Count > 0) { foreach (TreeNode <Job> job_childnode in job_treenode.Children) { sum += GetActuals(node, job_childnode); } } else { foreach (TreeNode <Account> child_node in node.Children) { sum += GetActuals(child_node, job_treenode); } } return(sum); }
protected override OpResult _Store(JobAccount _obj) { if (_obj == null) { return(OpResult.NotifyStoreAction(OpResult.ResultStatus.ObjectIsNull, _obj, "JobAccount object cannot be created as it is null")); } if (Exists(_obj)) { ExecuteNonQuery(GetQuery_UpdateQuery(_obj)); return(OpResult.NotifyStoreAction(OpResult.ResultStatus.Updated, _obj)); } ExecuteNonQuery(GetQuery_InsertQuery(_obj)); if (_obj.JobAccountID == null) { _obj.JobAccountID = DbMgr.GetLastInsertID(); } _obj.FromDb = true; return(OpResult.NotifyStoreAction(OpResult.ResultStatus.Created, _obj)); }
/// <summary> /// Verify that the Database object matches the provided values /// </summary> /// <param name="jobAccount">The job account.</param> /// <param name="jobAccountName">Name of the job account.</param> /// <param name="databaseId">The database identifier.</param> private static void VerifyJobAccountInformation(JobAccount jobAccount, string jobAccountName, string databaseId) { Assert.Equal(jobAccountName, jobAccount.Name); Assert.Equal(databaseId, jobAccount.Properties.DatabaseId); }
private DbUpdateStatement GetQuery_UpdateQuery(JobAccount _obj) { return(DbMgr.CreateUpdateClause("JobAccounts", GetFields(_obj), "JobAccountID", _obj.JobAccountID)); }
private DbInsertStatement GetQuery_InsertQuery(JobAccount _obj) { Dictionary <string, DbFieldEntry> fields = GetFields(_obj); return(DbMgr.CreateInsertClause("JobAccounts", fields)); }