public void CalculateMatchingCommission(string UserId, decimal LeftAmount, decimal rightAmount) { DataTable dt = new DataTable(); genologyDAL genology = new genologyDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(true); dt = genology.CalculateMatchingCommission(UserId, LeftAmount, rightAmount, db); db.Stop(); //return dt; } catch (Exception) { throw; } }
public DataTable find(string UserId) { DataTable dt = new DataTable(); genologyDAL genology = new genologyDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(true); dt = genology.find(UserId, db); db.Stop(); return dt; } catch (Exception) { throw; } }
public bool generateBainaryMatchData() { DataTable dt = new DataTable(); genologyDAL genology = new genologyDAL(); string LeftChild = ""; string RightChild = ""; bool status = false; DataRow dr = null; try { dt = getStakeJoiningList(); DataTable dtnode = getMatchingNodeList(); DataTable dtParent = getStakeJoiningParentList(); for (int i = 0; i < dt.Rows.Count; i++) { InserNode = new DataTable(); InserNode.Columns.Add(new DataColumn("NodeId")); InserNode.Columns.Add(new DataColumn("ChildId")); InserNode.Columns.Add(new DataColumn("Amount")); InserNode.Columns.Add(new DataColumn("Position")); LeftChild = ""; RightChild = ""; findLeftRight(dt.Rows[i]["PleacementId"].ToString(), out LeftChild, out RightChild); if (LeftChild != "") { viststack.Push(LeftChild); DataView view = new DataView(dt); view.RowFilter = "UserId = '" + LeftChild + "'"; DataView viewNode = new DataView(dtnode); viewNode.Sort = "ChildId"; viewNode.RowFilter = "NodeID = '" + dt.Rows[i]["PleacementId"].ToString() + "'"; if (viewNode.Count > 0) { int index = viewNode.Find(view[0]["UserId"].ToString()); if (index == -1) { if (Convert.ToDecimal(view[0]["StakeAmount"].ToString()) > 0) { dr = InserNode.NewRow(); dr["NodeId"] = dt.Rows[i]["PleacementId"].ToString(); dr["ChildId"] = view[0]["UserId"].ToString(); dr["Amount"] = view[0]["StakeAmount"].ToString(); dr["Position"] = "L"; InserNode.Rows.Add(dr); } } } else { if (Convert.ToDecimal(view[0]["StakeAmount"].ToString()) > 0) { dr = InserNode.NewRow(); dr["NodeId"] = dt.Rows[i]["PleacementId"].ToString(); dr["ChildId"] = view[0]["UserId"].ToString(); dr["Amount"] = view[0]["StakeAmount"].ToString(); dr["Position"] = "L"; InserNode.Rows.Add(dr); } } VisitChildrenByParentId(dt.Rows[i]["PleacementId"].ToString(), dt, dtnode, "L"); } if (RightChild != "") { viststack.Push(RightChild); DataView view = new DataView(dt); view.RowFilter = "UserId = '" + RightChild + "'"; DataView viewNode = new DataView(dtnode); viewNode.Sort = "ChildId"; viewNode.RowFilter = "NodeID = '" + dt.Rows[i]["PleacementId"].ToString() + "'"; if (viewNode.Count > 0) { int index = viewNode.Find(view[0]["UserId"].ToString()); if (index == -1) { if (Convert.ToDecimal(view[0]["StakeAmount"].ToString()) > 0) { dr = InserNode.NewRow(); dr["NodeId"] = dt.Rows[i]["PleacementId"].ToString(); dr["ChildId"] = view[0]["UserId"].ToString(); dr["Amount"] = view[0]["StakeAmount"].ToString(); dr["Position"] = "R"; InserNode.Rows.Add(dr); } } } else { if (Convert.ToDecimal(view[0]["StakeAmount"].ToString()) > 0) { dr = InserNode.NewRow(); dr["NodeId"] = dt.Rows[i]["PleacementId"].ToString(); dr["ChildId"] = view[0]["UserId"].ToString(); dr["Amount"] = view[0]["StakeAmount"].ToString(); dr["Position"] = "R"; InserNode.Rows.Add(dr); } } VisitChildrenByParentId(dt.Rows[i]["PleacementId"].ToString(), dt, dtnode, "R"); } if (InserNode.Rows.Count > 0) { insertIntoNodeList(InserNode); status = true; } } //LumexDBPlayer db = LumexDBPlayer.Start(true); //dt = genology.getStakeJoiningList(db); //db.Stop(); // return dt; return status; } catch (Exception) { throw; } }
private void insertIntoNodeList(DataTable dt) { genologyDAL genology = new genologyDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(true); dt = genology.insertIntoNodeList(dt, db); db.Stop(); } catch (Exception) { throw; } }
private DataTable getStakeJoiningParentList() { DataTable dt = new DataTable(); genologyDAL genology = new genologyDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(true); dt = genology.getStakeJoiningParentList(db); db.Stop(); return dt; } catch (Exception) { throw; } }
public DataTable getNodeList() { DataTable dt = new DataTable(); genologyDAL genology = new genologyDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(true); dt = genology.getNodeList(db); db.Stop(); return dt; } catch (Exception) { throw; } }
public void getNodeLeftRightAmount(string UserId, out decimal LeftAmount, out decimal RightAmount) { LeftAmount = 0; RightAmount = 0; DataTable dt = new DataTable(); genologyDAL genology = new genologyDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(true); dt = genology.getNodeLeftRightAmount(UserId, db); db.Stop(); if (dt.Rows.Count > 0) { decimal.TryParse(dt.Rows[0][0].ToString(), out LeftAmount); decimal.TryParse(dt.Rows[0][1].ToString(), out RightAmount); } // return dt; } catch (Exception) { throw; } }
public bool GenerateBinaryNodeByChileId(string UserId,string Amount) { bool status = false; DataTable dt = new DataTable(); genologyDAL genology = new genologyDAL(); DataRow dr = null; try { dt = getStakeJoiningList(); InserNode = new DataTable(); InserNode.Columns.Add(new DataColumn("NodeId")); InserNode.Columns.Add(new DataColumn("ChildId")); InserNode.Columns.Add(new DataColumn("Amount")); InserNode.Columns.Add(new DataColumn("Position")); viststack.Push(UserId); while (viststack.Count>0) { string childId = viststack.Pop(); DataView view = new DataView(dt); view.RowFilter = "UserId = '" + childId + "'"; if (view.Count > 0) { dr = InserNode.NewRow(); dr["NodeId"] = view[0]["PleacementId"].ToString(); dr["ChildId"] = UserId; dr["Amount"] = Amount.ToString(); dr["Position"] =view[0]["PlacePosition"].ToString(); InserNode.Rows.Add(dr); viststack.Push(view[0]["PleacementId"].ToString()); } } if (InserNode.Rows.Count > 0) { insertIntoNodeList(InserNode); status = true; } //LumexDBPlayer db = LumexDBPlayer.Start(true); //dt = genology.getStakeJoiningList(db); //db.Stop(); // return dt; return status; } catch (Exception) { throw; } }