public bool SaveStakeInfo()
{
StakeInfoDAL saveStakeInfo = new StakeInfoDAL();
bool status = false;
DataTable dt = new DataTable();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = saveStakeInfo.SaveStaKeInfo(this, db);
if (dt.Rows.Count > 0)
{
status = true;
StakeId = dt.Rows[0][0].ToString();
}
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
dt.Clear();
}
return(status);
}
public decimal getstakeAmountByStakeId(string stakeId)
{
DataTable dt = new DataTable();
StakeInfoDAL stakeInfo = new StakeInfoDAL();
decimal amount = 0;
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = stakeInfo.getstakeAmountByStakeId(stakeId, db);
db.Stop();
if (dt.Rows.Count > 0)
{
amount = Convert.ToDecimal(dt.Rows[0][0].ToString());
}
return(amount);
}
catch (Exception)
{
throw;
}
finally
{
stakeInfo = null;
}
}
public bool updateKeyWhenReject(string Serial, string UserId)
{
bool status = false;
try
{
StakeInfoDAL stakeInfo = new StakeInfoDAL();
LumexDBPlayer db = LumexDBPlayer.Start(true);
stakeInfo.updateKeyWhenReject(Serial, UserId, db);
db.Stop();
status = true;
}
catch (Exception)
{
throw;
}
return(status);
}
public bool updateKeyonTransfer(DataTable dt)
{
bool status = false;
try
{
StakeInfoDAL stakeInfo = new StakeInfoDAL();
LumexDBPlayer db = LumexDBPlayer.Start(true);
stakeInfo.updateKeyonTransfer(this, dt, db);
db.Stop();
status = true;
}
catch (Exception)
{
throw;
}
return(status);
}
public DataTable GetStakeInfoList()
{
DataTable dt = new DataTable();
StakeInfoDAL stakeInfo = new StakeInfoDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = stakeInfo.GetStakeInfoList(db);
db.Stop();
return(dt);
}
catch (Exception)
{
throw;
}
finally
{
stakeInfo = null;
}
}
public DataTable updateKeyWhenPurchase(string NoofPin, string UnitPrice, string StakeId, string payby)
{
DataTable dt = new DataTable();
StakeInfoDAL stakeInfo = new StakeInfoDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = stakeInfo.updateKeyWhenPurchase(NoofPin, UnitPrice, StakeId, payby, db);
db.Stop();
return(dt);
}
catch (Exception)
{
throw;
}
finally
{
stakeInfo = null;
}
}
public DataTable GetFreeStakeListByStakeId(string stakeId)
{
DataTable dt = new DataTable();
StakeInfoDAL stakeInfo = new StakeInfoDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = stakeInfo.GetFreeStakeKeyListByStakeId(stakeId, db);
db.Stop();
return(dt);
}
catch (Exception)
{
throw;
}
finally
{
stakeInfo = null;
}
}
public DataTable getStakeKeyLogdatabyUser(string UserId)
{
DataTable dt = new DataTable();
StakeInfoDAL stakeInfo = new StakeInfoDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
dt = stakeInfo.getStakeKeyLogdatabyUser(UserId, db);
db.Stop();
return(dt);
}
catch (Exception)
{
throw;
}
finally
{
stakeInfo = null;
}
}
public bool CheckDuplicateKey(string pinserial)
{
StakeInfoDAL stakeInfo = new StakeInfoDAL();
bool status = false;
LumexDBPlayer db = LumexDBPlayer.Start(true);
try
{
status = stakeInfo.CheckDuplicateKey(pinserial, db);
}
catch (Exception)
{
throw;
}
finally
{
stakeInfo = null;
db.Stop();
}
return(status);
}
public bool UpdateStakeInfo()
{
StakeInfoDAL stakeInfo = new StakeInfoDAL();
bool status = false;
LumexDBPlayer db = LumexDBPlayer.Start(true);
try
{
stakeInfo.UpdateStakeInfo(this, db);
status = true;
}
catch (Exception)
{
throw;
}
finally
{
stakeInfo = null;
db.Stop();
}
return(status);
}
public bool CheckStakeKeyAvailability(string StakeKey, string UserId, string StakeId)
{
bool status = false;
try
{
StakeInfoDAL stakeInfo = new StakeInfoDAL();
LumexDBPlayer db = LumexDBPlayer.Start(true);
DataTable dt = stakeInfo.CheckStakeKeyAvailability(StakeKey, UserId, StakeId, db);
db.Stop();
if (dt.Rows.Count > 0)
{
status = true;
}
}
catch (Exception)
{
throw;
}
return(status);
}
public bool UpdateStakePinActivation(string serial, string IsActive)
{
StakeInfoDAL stakeInfo = new StakeInfoDAL();
bool status = false;
LumexDBPlayer db = LumexDBPlayer.Start(true);
try
{
stakeInfo.UpdateStakePinActivation(serial, IsActive, db);
status = true;
}
catch (Exception)
{
throw;
}
finally
{
stakeInfo = null;
db.Stop();
}
return(status);
}
public bool SaveGeneratedPin(DataTable dt)
{
StakeInfoDAL stakeInfo = new StakeInfoDAL();
bool status = false;
LumexDBPlayer db = LumexDBPlayer.Start(true);
try
{
stakeInfo.SaveGeneratedPin(dt, db);
status = true;
}
catch (Exception)
{
throw;
}
finally
{
stakeInfo = null;
db.Stop();
}
return(status);
}
