public bool GetTransiction()
{
UserAccountDLL aUser = new UserAccountDLL();
bool status = false;
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.GetTransiction(this, db);
db.Stop();
if (dt.Rows.Count > 0)
{
status = true;
}
}
catch (Exception)
{
throw;
}
finally
{
dt.Clear();
}
return(status);
}
public bool UpdateUserAccount(string UserId, string StakeId, string StakeKey)
{
UserAccountDLL aUser = new UserAccountDLL();
bool status = false;
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.UpdateUserAccount(UserId, StakeId, StakeKey, db);
if (dt.Rows.Count > 0)
{
Amount = dt.Rows[0][0].ToString();
status = true;
}
db.Stop();
}
catch (Exception)
{
throw;
}
return(status);
}
public bool checkUserIncomeAmounttoActin(decimal Amount, string UserId)
{
UserAccountDLL aUser = new UserAccountDLL();
bool status = false;
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.getAccountSummaryById(UserId, db);
db.Stop();
if (dt.Rows.Count > 0)
{
if (Convert.ToDecimal(dt.Rows[0]["Income"].ToString()) >= Amount)
{
status = true;
}
}
return(status);
}
catch (Exception)
{
throw;
}
}
public DataTable GetPaymentMethodInfoBySerial(string serial)
{
UserAccountDLL user = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
dt = user.GetPaymentInfoBySerial(serial, db);
db.Stop();
}
catch (Exception)
{
throw;
}
return(dt);
}
public DataTable GetPaymentInfoNyIdandType(string UserId, string Type)
{
UserAccountDLL user = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
dt = user.GetPaymentInfoNyIdandType(UserId, Type, db);
db.Stop();
}
catch (Exception)
{
throw;
}
return(dt);
}
public void InsertReceivePaymentWhenPinChange()
{
UserAccountDLL aUser = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.InsertReceivePaymentWhenPinChange(db);
db.Stop();
}
catch (Exception)
{
throw;
}
}
public bool SavePaymentInfo()
{
UserAccountDLL user = new UserAccountDLL();
bool status = false;
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
user.SavePaymentInfo(this, db);
status = true;
db.Stop();
}
catch (Exception)
{
throw;
}
return(status);
}
public bool InsertReceivePaymentWhenActive(string UserId, string RefferId, string Commission)
{
UserAccountDLL aUser = new UserAccountDLL();
bool status = false;
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
aUser.InsertReceivePaymentWhenActive(UserId, RefferId, Commission, db);
status = true;
db.Stop();
}
catch (Exception)
{
throw;
}
return(status);
}
public DataTable getDailyBonusById(string UserId)
{
UserAccountDLL aUser = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.getDailyBonusById(UserId, db);
db.Stop();
}
catch (Exception)
{
throw;
}
return(dt);
}
public DataTable getMoneyGenerateAmountByDateRangeById(string FromDate, string ToDate, string UserId)
{
UserAccountDLL aUser = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.getMoneyGenerateAmountByDateRangeById(FromDate, ToDate, UserId, db);
db.Stop();
}
catch (Exception)
{
throw;
}
return(dt);
}
public DataTable getTotalMatchingCommissionListbyDateRange(string FromDate, string ToDate)
{
UserAccountDLL aUser = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.getTotalMatchingCommissionListbyDateRange(FromDate, ToDate, db);
db.Stop();
}
catch (Exception)
{
throw;
}
return(dt);
}
public void updateUserAccountforTransfer()
{
UserAccountDLL aUser = new UserAccountDLL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
aUser.updateUserAccountforTransfer(this, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
// dt.Clear();
}
}
public DataTable getGeneratedMoneyList()
{
UserAccountDLL aUser = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.getGeneratedMoneyList(db);
db.Stop();
return(dt);
}
catch (Exception)
{
throw;
}
}
public bool UpdateUserIncomeBalanceFromCommission(string UserId, string ammount)
{
UserAccountDLL aUser = new UserAccountDLL();
bool status = false;
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.UpdateUserIncomeBalanceFromCommission(UserId, ammount, db);
status = true;
db.Stop();
}
catch (Exception)
{
throw;
}
return(status);
}
public bool ReceivePaymentMoney(string amount)
{
UserAccountDLL userAccountDll = new UserAccountDLL();
DataTable dt = new DataTable();
bool status = false;
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = userAccountDll.ReceivePaymentMoney(amount, db);
status = true;
db.Stop();
}
catch (Exception)
{
throw;
}
return(status);
}
public DataTable getAccountSummaryById(string UserId)
{
UserAccountDLL aUser = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.getAccountSummaryById(UserId, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
// dt.Clear();
}
return(dt);
}
public DataTable getWithdrawRequestListToUser(string UserId, string formDate, string toDate, string status)
{
UserAccountDLL aUser = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.getWithdrawRequestListToUser(UserId, formDate, toDate, status, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
// dt.Clear();
}
return(dt);
}
public DataTable updateWithdrawRequest(string Id, string Status)
{
UserAccountDLL aUser = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.updateWithdrawRequest(Id, Status, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
// dt.Clear();
}
return(dt);
}
public DataTable getUserIncomeStatementById(string UserId, string FromDate, string ToDate)
{
UserAccountDLL aUser = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.getUserIncomeStatementById(UserId, FromDate, ToDate, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
// dt.Clear();
}
return(dt);
}
public bool generateDailyBonus(string Date)
{
UserAccountDLL aUser = new UserAccountDLL();
bool status = false;
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.generateDailyBonus(Date, db);
if (dt.Rows.Count > 0)
{
status = true;
}
db.Stop();
}
catch (Exception)
{
throw;
}
return(status);
}
public bool InsertReceivePaymentWhenAffectIncome()
{
UserAccountDLL userAccountDll = new UserAccountDLL();
DataTable dt = new DataTable();
bool status = false;
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = userAccountDll.InsertReceivePaymentWhenAffectIncome(this, db);
if (dt.Rows.Count > 0)
{
TransectionId = dt.Rows[0][0].ToString();
}
status = true;
db.Stop();
}
catch (Exception)
{
throw;
}
return(status);
}
public bool UpdatePaymentInfoBySerial()
{
UserAccountDLL user = new UserAccountDLL();
DataTable dt = new DataTable();
bool status = false;
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
dt = user.UpdatePaymentInfoBySerial(this, db);
if (dt.Rows.Count > 0)
{
status = true;
}
db.Stop();
}
catch (Exception)
{
throw;
}
return(status);
}
public bool RequestToTransfer()
{
UserAccountDLL aUser = new UserAccountDLL();
bool status = false;
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.RequestToTransfer(this, db);
if (dt.Rows.Count > 0)
{
transfarId = dt.Rows[0][0].ToString();
status = true;
}
db.Stop();
}
catch (Exception)
{
throw;
}
return(status);
}
public DataTable getWithdrawRequestListToUser(string UserId, string formDate, string toDate, string status)
{
UserAccountDLL aUser = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.getWithdrawRequestListToUser(UserId, formDate, toDate, status, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
// dt.Clear();
}
return dt;
}
public bool UpdatePaymentInfoBySerial()
{
UserAccountDLL user = new UserAccountDLL();
DataTable dt = new DataTable();
bool status = false;
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
dt = user.UpdatePaymentInfoBySerial(this,db);
if (dt.Rows.Count > 0)
{
status = true;
}
db.Stop();
}
catch (Exception)
{
throw;
}
return status;
}
public DataTable getGeneratedMoneyList()
{
UserAccountDLL aUser = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.getGeneratedMoneyList(db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
}
public DataTable GetPaymentInfoNyIdandType(string UserId, string Type)
{
UserAccountDLL user = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
dt = user.GetPaymentInfoNyIdandType(UserId,Type, db);
db.Stop();
}
catch (Exception)
{
throw;
}
return dt;
}
public bool GetTransiction()
{
UserAccountDLL aUser = new UserAccountDLL();
bool status = false;
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.GetTransiction(this, db);
db.Stop();
if (dt.Rows.Count > 0)
{
status = true;
}
}
catch (Exception)
{
throw;
}
finally
{
dt.Clear();
}
return status;
}
public void InsertReceivePaymentWhenPinChange()
{
UserAccountDLL aUser = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.InsertReceivePaymentWhenPinChange(db);
db.Stop();
}
catch (Exception)
{
throw;
}
}
public bool generateDailyBonus(string Date)
{
UserAccountDLL aUser = new UserAccountDLL();
bool status = false;
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.generateDailyBonus(Date, db);
if (dt.Rows.Count > 0)
{
status = true;
}
db.Stop();
}
catch (Exception)
{
throw;
}
return status;
}
public void updateUserAccountforTransfer()
{
UserAccountDLL aUser = new UserAccountDLL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
aUser.updateUserAccountforTransfer(this, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
// dt.Clear();
}
}
public bool UpdateUserAccount(string UserId, string StakeId, string StakeKey)
{
UserAccountDLL aUser = new UserAccountDLL();
bool status = false;
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.UpdateUserAccount(UserId, StakeId, StakeKey, db);
if (dt.Rows.Count > 0)
{
Amount = dt.Rows[0][0].ToString();
status = true;
}
db.Stop();
}
catch (Exception)
{
throw;
}
return status;
}
public DataTable GetUserPlacementInfoById(string UserId)
{
UserAccountDLL aUser = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.GetUserPlacementInfoById(UserId, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
//dt.Clear();
}
return dt;
}
public DataTable getUserIncomeStatementById(string UserId, string FromDate, string ToDate)
{
UserAccountDLL aUser = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.getUserIncomeStatementById(UserId, FromDate, ToDate, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
// dt.Clear();
}
return dt;
}
public bool InsertReceivePaymentWhenAffectIncome()
{
UserAccountDLL userAccountDll = new UserAccountDLL();
DataTable dt = new DataTable();
bool status = false;
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = userAccountDll.InsertReceivePaymentWhenAffectIncome(this, db);
if (dt.Rows.Count > 0)
{
TransectionId = dt.Rows[0][0].ToString();
}
status = true;
db.Stop();
}
catch (Exception)
{
throw;
}
return status;
}
public DataTable getTotalMatchingCommissionListbyDateRange(string FromDate, string ToDate)
{
UserAccountDLL aUser = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.getTotalMatchingCommissionListbyDateRange(FromDate, ToDate, db);
db.Stop();
}
catch (Exception)
{
throw;
}
return dt;
}
public bool InsertReceivePaymentWhenActive(string UserId, string RefferId, string Commission)
{
UserAccountDLL aUser = new UserAccountDLL();
bool status = false;
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
aUser.InsertReceivePaymentWhenActive(UserId, RefferId, Commission, db);
status = true;
db.Stop();
}
catch (Exception)
{
throw;
}
return status;
}
public DataTable GetPaymentMethodInfoBySerial(string serial)
{
UserAccountDLL user = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
dt = user.GetPaymentInfoBySerial(serial, db);
db.Stop();
}
catch (Exception)
{
throw;
}
return dt;
}
public DataTable getAccountSummaryAllUser()
{
UserAccountDLL aUser = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.getAccountSummaryAllUser(db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
// dt.Clear();
}
return dt;
}
public DataTable getMoneyGenerateAmountById(string UserId)
{
UserAccountDLL aUser = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.getMoneyGenerateAmountById(UserId, db);
db.Stop();
}
catch (Exception)
{
throw;
}
return dt;
}
public bool RequestToTransfer()
{
UserAccountDLL aUser = new UserAccountDLL();
bool status = false;
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.RequestToTransfer(this, db);
if (dt.Rows.Count > 0)
{
transfarId = dt.Rows[0][0].ToString();
status = true;
}
db.Stop();
}
catch (Exception)
{
throw;
}
return status;
}
public DataTable getDailybounsListbyDateRangeByUserId(string FromDate, string ToDate, string UserId)
{
UserAccountDLL aUser = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.getDailybounsListbyDateRangeByUserId(FromDate, ToDate, UserId, db);
db.Stop();
}
catch (Exception)
{
throw;
}
return dt;
}
public bool SavePaymentInfo()
{
UserAccountDLL user=new UserAccountDLL();
bool status = false;
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
user.SavePaymentInfo(this, db);
status = true;
db.Stop();
}
catch (Exception)
{
throw;
}
return status;
}
public bool UpdateUserIncomeBalanceFromDeposit(string UserId, string ammount)
{
UserAccountDLL aUser = new UserAccountDLL();
bool status = false;
DataTable dt=new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.UpdateUserIncomeBalanceFromDeposit(UserId, ammount, db);
status = true;
db.Stop();
}
catch (Exception)
{
throw;
}
return status;
}
public bool ReceivePaymentMoney(string amount)
{
UserAccountDLL userAccountDll = new UserAccountDLL();
DataTable dt = new DataTable();
bool status = false;
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = userAccountDll.ReceivePaymentMoney(amount, db);
status = true;
db.Stop();
}
catch (Exception)
{
throw;
}
return status;
}
public DataTable updateWithdrawRequest(string Id, string Status)
{
UserAccountDLL aUser = new UserAccountDLL();
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.updateWithdrawRequest(Id, Status, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
// dt.Clear();
}
return dt;
}
public bool checkUserIncomeAmounttoActin(decimal Amount, string UserId)
{
UserAccountDLL aUser = new UserAccountDLL();
bool status = false;
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = aUser.getAccountSummaryById(UserId, db);
db.Stop();
if (dt.Rows.Count > 0)
{
if (Convert.ToDecimal(dt.Rows[0]["Income"].ToString()) >= Amount)
{
status = true;
}
}
return status;
}
catch (Exception)
{
throw;
}
}
