public void updateWalletBalance(int CurrentUserID) { int ActiveCount = 0, ChildID = 0; TreeLevel3 t = new TreeLevel3(); Array TotalChildList = t.GetLevel123TotalNodeList(CurrentUserID); //Convert Array Object to int Array int[] ChildList = TotalChildList.Cast <int>().ToArray(); foreach (int i in ChildList) { ChildID = ChildList[i]; if (db.CheckByQuery("select * from Member where ID=" + ChildID + " and Active='True'")) { ActiveCount++; } } if (ActiveCount > 0) { int Amount = ActiveCount * db.getIntByQuery("select * from DollarRate where ID=1", "Rate"); db.ChangeByQuery("update Wallet set Balance = Balance + " + Amount + " where MemberID=" + CurrentUserID); } }
public void updateWalletBalance(int MemberID) { DBBase db = new DBBase(); TreeLevel3 t = new TreeLevel3(); Array TotalChildList = t.GetLevel123TotalNodeList(MemberID); //Convert Array Object to int Array int[] ChildList = TotalChildList.Cast <int>().ToArray(); for (int i = 0; i < ChildList.Length; i++) { ChildID = ChildList[i]; //Check ChildID is Active if (db.CheckByQuery("select * from Member where ID=" + ChildID + " and Active='True'")) { ActiveCount++; } } if (ActiveCount > 0) { int Amount = ActiveCount * db.getIntByQuery("select * from DollarRate where ID=1", "Rate"); db.ChangeByQuery("update Wallet set Balance = Balance + " + Amount + " where MemberID=" + MemberID); } }
public void updateWalletBalance(int CurrentUserID) { int ActiveCount = 0, ChildID = 0; int Period = 0; int day = DateTime.Now.Day; if (day > 14 || day < 29) { Period = 1; } if (day == 30 || day == 31 || day < 14) { Period = 2; } TreeLevel3 t = new TreeLevel3(); Array TotalChildList = t.GetLevel123TotalNodeList(CurrentUserID); //Convert Array Object to int Array int[] ChildList = TotalChildList.Cast <int>().ToArray(); for (int i = 0; i < ChildList.Length; i++) { ChildID = ChildList[i]; if (db.CheckByQuery("select * from Member where ID=" + ChildID + " and Active='True'") && !(db.CheckByQuery("select * from Payment where MemberID=" + CurrentUserID + " and Child=" + ChildID + " and Period=" + Period))) { db.ChangeByQuery("insert into Payment values(" + CurrentUserID + "," + ChildID + "," + Period + ")"); ActiveCount++; } } if (ActiveCount > 0) { int Amount = ActiveCount * db.getIntByQuery("select * from DollarRate where ID=1", "Rate"); db.ChangeByQuery("update Wallet set Balance = Balance + " + Amount + " where MemberID=" + CurrentUserID); } if (day == 14 || day == 29) { db.ChangeByQuery("delete From Payment"); } }