// @StakeName nvarchar(100) ,
//@DailyAwardFrom decimal(18, 2) ,
//@DailyAwardTo decimal(18, 2) ,
//@Avarage decimal(18, 2) ,
//@TotalDuration decimal(18, 2) ,
//@BinaryCap decimal(18, 2) ,
//@Parcentage decimal(18, 2) ,
//@CreatedBy varchar(50) ,
//@CreatedFrom varchar(50)
internal System.Data.DataTable SaveStaKeInfo(BLL.StakeInfoBLL stakeInfoBLL, LumexDBPlayer db)
{
bool status = true;
DataTable dt = new DataTable();
try
{
db.AddParameters("@StakeName", stakeInfoBLL.StakeName);
db.AddParameters("@Amount", stakeInfoBLL.Amount);
db.AddParameters("@DailyAwardFrom", stakeInfoBLL.DailyAwardFrom);
db.AddParameters("@DailyAwardTo", stakeInfoBLL.DailyAwardTo);
db.AddParameters("@Avarage", stakeInfoBLL.AvgAward);
db.AddParameters("@TotalDuration", stakeInfoBLL.TotalDuration);
db.AddParameters("@BinaryCap", stakeInfoBLL.BinaryCap);
db.AddParameters("@Parcentage", stakeInfoBLL.Parcentage);
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
dt = db.ExecuteDataTable("[INSERT_STAKE_INFO]", true);
}
catch (Exception)
{
throw;
}
return(dt);
}
internal void updateKeyonTransfer(BLL.StakeInfoBLL stakeInfoBLL, DataTable dt, LumexDBPlayer db)
{
try
{
db.AddParameters("@StakeKey", dt);
db.AddParameters("@SentTo", stakeInfoBLL.sendto);
db.AddParameters("@SentBy", stakeInfoBLL.transferBy);
db.AddParameters("@SendSms", stakeInfoBLL.sendSms);
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteDataTable("[UPDATE_STAKE_PIN_ON_TRANSFER]", true);
}
catch (Exception)
{
throw;
}
}
internal void UpdateStakeInfo(BLL.StakeInfoBLL stakeInfoBLL, LumexDBPlayer db)
{
try
{
db.AddParameters("@StakeId", stakeInfoBLL.StakeId);
db.AddParameters("@StakeName", stakeInfoBLL.StakeName);
db.AddParameters("@Amount", stakeInfoBLL.Amount);
db.AddParameters("@DailyAwardFrom", stakeInfoBLL.DailyAwardFrom);
db.AddParameters("@DailyAwardTo", stakeInfoBLL.DailyAwardTo);
db.AddParameters("@Avarage", stakeInfoBLL.AvgAward);
db.AddParameters("@TotalDuration", stakeInfoBLL.TotalDuration);
db.AddParameters("@BinaryCap", stakeInfoBLL.BinaryCap);
db.AddParameters("@Parcentage", stakeInfoBLL.Parcentage);
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteDataTable("[UPDATE_STAKE_INFO]", true);
}
catch (Exception)
{
throw;
}
}