private void getStakeKeyLogdata()
{
try
{
StakeInfoBLL stakeInfo = new StakeInfoBLL();
DataTable dt = new DataTable();
if ((string)LumexSessionManager.Get("UserGroupId") == "UG003")
{
dt = stakeInfo.getStakeKeyLogdatabyUser((string)LumexSessionManager.Get("ActiveUserId"));
GridViewStakeLog.DataSource = dt;
GridViewStakeLog.DataBind();
if (dt.Rows.Count < 1)
{
msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = "";
}
GridviewHeadStyle();
}
else
{
dt = stakeInfo.getStakeKeyLogdataAll();
GridViewStakeLog.DataSource = dt;
GridViewStakeLog.DataBind();
if (dt.Rows.Count < 1)
{
msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = "";
}
GridviewHeadStyle();
}
}
catch (Exception)
{
throw;
}
}
protected void txtbxNoStake_TextChanged(object sender, EventArgs e)
{
try
{
StakeInfoBLL stakeInfo = new StakeInfoBLL();
if (ddlstakeList.SelectedIndex != 0)
{
lblStakeName.Text = ddlstakeList.SelectedItem.Text;
lblQuntity.Text = txtbxNoStake.Text;
lblUnitPrice.Text = stakeInfo.getstakeAmountByStakeId(ddlstakeList.SelectedValue).ToString();
lblPrice.Text = (Convert.ToDecimal(lblQuntity.Text) * Convert.ToDecimal(lblUnitPrice.Text)).ToString();
lblTotalPrice.Text = lblPrice.Text;
}
else
{
lblStakeName.Text = "0";
lblQuntity.Text = "0.00";
lblUnitPrice.Text = "0.00";
lblPrice.Text = "0.00";
lblTotalPrice.Text = "0.00";
}
}
catch (Exception)
{
throw;
}
}
protected void txtbxStakeKey_TextChanged(object sender, EventArgs e)
{
try
{
StakeInfoBLL stakeInfo = new StakeInfoBLL();
if (stakeInfo.CheckStakeKeyAvailability(txtbxStakeKey.Text, (string)LumexSessionManager.Get("ActiveUserId"), ddlStakeList.SelectedValue))
{
// iconuserName.Attributes.Remove("class");
iconStakeKey.Attributes.Add("class", "icon icon-ok-sign text-success");
hdnStakeKey.Value = "1";
txtbxStakeKey.Focus();
}
else
{
// iconuserName.Attributes.Remove("class");
iconStakeKey.Attributes.Add("class", "icon icon-ban-circle text-error");
hdnStakeKey.Value = "0";
txtbxUserPin.Focus();
}
}
catch (Exception)
{
//throw;
}
}
private void GetGeneratedPinList()
{
try
{
StakeInfoBLL stakeInfo = new StakeInfoBLL();
DataTable dt = stakeInfo.getGeneratedPinList();
gridviewStakePin.DataSource = dt;
gridviewStakePin.DataBind();
if (dt.Rows.Count > 0)
{
// PinStatistic
string[] pindata = dt.Rows[0]["PinStatistic"].ToString().Split('/');
lblTotalUsed.Text = pindata[0];
lblTotalActive.Text = pindata[1];
lblTotalGenerate.Text = dt.Rows.Count.ToString();
lblTotalInactive.Text =
(int.Parse(lblTotalGenerate.Text) - int.Parse(lblTotalActive.Text)).ToString();
}
}
catch (Exception)
{
// throw;
}
}
private void loadtStakeList()
{
DataTable dt = new DataTable();
StakeInfoBLL stakeInfo = new StakeInfoBLL();
try
{
dt = stakeInfo.GetStakeInfoList();
ddlStakeList.DataSource = dt;
ddlStakeList.DataTextField = "StakeName";
ddlStakeList.DataValueField = "StakeId";
ddlStakeList.DataBind();
ddlStakeList.Items.Insert(0, "Select Here..");
ddlStakeList.SelectedIndex = 0;
ddlStakeList.Items[0].Value = "";
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null)
{
message += " --> " + ex.InnerException.Message;
}
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
}
protected void activateLinkButton_Click(object sender, EventArgs e)
{
try
{
LinkButton lnkBtn = (LinkButton)sender;
GridViewRow row = (GridViewRow)lnkBtn.NamingContainer;
StakeInfoBLL stakeInfo = new StakeInfoBLL();
string serial = gridviewStakePin.Rows[row.RowIndex].Cells[0].Text.ToString();
string IsActive = "Yes";
if (gridviewStakePin.Rows[row.RowIndex].Cells[7].Text.ToString() == "yes")
{
string message = " <span class='actionTopic'>" + " This Pin Already Used you can not Deactive this Pin. Thanks" + "</span>.";
MyAlertBox(
"var callbackOk = function () { window.location = \"/a/initialdata/initialDataElement.aspx\"; }; WarningAlert(\"" +
"Process Failed" + "\", \"" + message + "\", \"\");");
}
else if (gridviewStakePin.Rows[row.RowIndex].Cells[9].Text.ToString() != (string)LumexSessionManager.Get("ActiveUserId"))
{
string message = " <span class='actionTopic'>" + " This Pin is already transfered, you can not Deactive this Pin. Thanks" + "</span>.";
MyAlertBox(
"var callbackOk = function () { window.location = \"/a/initialdata/initialDataElement.aspx\"; }; WarningAlert(\"" +
"Process Failed" + "\", \"" + message + "\", \"\");");
}
else
{
if (lnkBtn.Text == "Active")
{
IsActive = "Yes";
}
else
{
IsActive = "No";
}
stakeInfo.UpdateStakePinActivation(serial, IsActive);
string message = " <span class='actionTopic'>" + " This Pin activation updated Successfully. Thanks" + "</span>.";
MyAlertBox(
"var callbackOk = function () { window.location = \"/a/initialdata/initialDataElement.aspx\"; }; SuccessAlert(\"" +
"Process Succeed" + "\", \"" + message + "\", \"\");");
GetGeneratedPinList();
}
// appMenu.UpdateMenuActivation(menuListGridView.Rows[row.RowIndex].Cells[0].Text.ToString(), "True");
// MyAlertBox("alert(\"Menu Activated Successfully.\"); window.location=\"/setting/AppMenu/MenuList.aspx\"");
}
catch (Exception ex)
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
msgbox.Attributes.Add("Class", "alert alert-warning");
}
}
private void ReceivePaymentWhenActive()
{
StakeInfoBLL stakeInfo = new StakeInfoBLL();
UserAccountBLL UserAccount = new UserAccountBLL();
DataTable dt = new DataTable();
dt = stakeInfo.GetStakeInfoById(ddlStakeList.SelectedValue);
UserAccount.InsertReceivePaymentWhenActive((string)LumexSessionManager.Get("ActiveUserId"), txtbxReferId.Text.Trim(), dt.Rows[0]["Commission"].ToString());
}
protected void RejectKeyLinkButton_Click(object sender, EventArgs e)
{
LinkButton lnkBtn = (LinkButton)sender;
GridViewRow row = (GridViewRow)lnkBtn.NamingContainer;
Label lblSerial = (Label)grdviewReceiavleKey.Rows[row.RowIndex].FindControl("lblSerial");
StakeInfoBLL stakeInfo = new StakeInfoBLL();
stakeInfo.updateKeyWhenReject(lblSerial.Text, (string)LumexSessionManager.Get("ActiveUserId"));
getStakeKeyList();
getStakeKeyReceivableList();
}
private void getStakeKeyReceivableList()
{
try
{
StakeInfoBLL stakeInfo = new StakeInfoBLL();
DataTable dt = stakeInfo.getStakePinListBySentto((string)LumexSessionManager.Get("ActiveUserId"));
grdviewReceiavleKey.DataSource = dt;
grdviewReceiavleKey.DataBind();
lblReceivableKey.Text = dt.Rows.Count.ToString();
}
catch (Exception)
{
throw;
}
}
protected void btnActivation_Click(object sender, EventArgs e)
{
try
{
UserBLL user = new UserBLL();
if (user.varifypin((string)LumexSessionManager.Get("ActiveUserId"), txtbxUserPin.Text))
{
UserAccountBLL userAccount = new UserAccountBLL();
StakeInfoBLL stakeInfo = new StakeInfoBLL();
MailContactBLL mailContactBll = new MailContactBLL();
UserBLL userBll = new UserBLL();
bool status = userAccount.UpdateUserAccount((string)LumexSessionManager.Get("ActiveUserId"),
ddlStakeList.SelectedValue, txtbxStakeKey.Text.Trim());
if (status)
{
if (hdnfldRefActive.Value == "No")
{
ReceivePaymentWhenActive();
genologyBLL genology = new genologyBLL();
genology.GenerateBinaryNodeByChileId((string)LumexSessionManager.Get("ActiveUserId"), userAccount.Amount);
}
string message = " <span class='actionTopic'> Your Account is Activated successfully. Thanks" + "</span>.";
MyAlertBox(
"var callbackOk = function () { window.location = \"/a/initialdata/initialDataElement.aspx\"; }; SuccessAlert(\"" +
"Process Succeed" + "\", \"" + message + "\", \"\");");
}
else
{
}
DataTable dt = stakeInfo.GetStakeInfoById(ddlStakeList.SelectedValue);
string body = PopulateBody(dt);
dt = userBll.GetUserInfoById((string)LumexSessionManager.Get("ActiveUserId"));
mailContactBll.SendHtmlFormattedEmail(dt.Rows[0]["Email"].ToString(), "Money Receipt", body);
}
}
catch (Exception)
{
//throw;
}
}
protected void ReceiveKeyLinkButton_Click(object sender, EventArgs e)
{
LinkButton lnkBtn = (LinkButton)sender;
GridViewRow row = (GridViewRow)lnkBtn.NamingContainer;
Label lblSerial = (Label)grdviewReceiavleKey.Rows[row.RowIndex].FindControl("lblSerial");
StakeInfoBLL stakeInfo = new StakeInfoBLL();
stakeInfo.updateKeyWhenReceived(lblSerial.Text, (string)LumexSessionManager.Get("ActiveUserId"));
getStakeKeyList();
getStakeKeyReceivableList();
string message = " <span class='actionTopic'>" +
"Key received successfully." + "</span>.";
MyAlertBox(
"var callbackOk = function () { window.location = \"/a/stake/stakekeymanage.aspx\"; }; WarningAlert(\"" +
"Process Failed" + "\", \"" + message + "\", \"\");");
// RemoveNewKeyToSendList(row);
}
private void getStakeKeyList()
{
try
{
StakeInfoBLL stakeInfo = new StakeInfoBLL();
DataTable dt = stakeInfo.getStakePinListByOwner((string)LumexSessionManager.Get("ActiveUserId"));
gridviewMyStakePin.DataSource = dt;
gridviewMyStakePin.DataBind();
for (int i = 0; i < gridviewMyStakePin.Rows.Count; i++)
{
if (string.IsNullOrEmpty(gridviewMyStakePin.Rows[i].Cells[5].Text))
{
LinkButton lnkbtn = (LinkButton)gridviewMyStakePin.Rows[i].FindControl("sendLinkButton");
lnkbtn.Enabled = false;
//break;
}
}
}
catch (Exception)
{
throw;
}
}
private void GetStakeInfoList()
{
try
{
DataTable dt = new DataTable();
StakeInfoBLL stakeInfo = new StakeInfoBLL();
dt = stakeInfo.GetStakeInfoList();
if (dt.Rows.Count > 0)
{
gridviewStake.DataSource = dt;
gridviewStake.DataBind();
}
GridViewStyle();
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null)
{
message += " --> " + ex.InnerException.Message;
}
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
StakeInfoBLL stakeBll = new StakeInfoBLL();
stakeBll.StakeName = txtBxStakeName.Text.Trim();
stakeBll.Amount = txtBxAmount.Text;
stakeBll.DailyAwardFrom = txtBxAwardFrom.Text.Trim();
stakeBll.DailyAwardTo = txtBxAwardTo.Text.Trim();
stakeBll.AvgAward = txtBxAvarage.Text.Trim();
stakeBll.TotalDuration = txtBxDuration.Text.Trim();
stakeBll.BinaryCap = txtBxBainoryCap.Text.Trim();
stakeBll.Parcentage = txtBxCommission.Text.Trim();
if (btnSave.Text != "Update")
{
bool status = stakeBll.SaveStakeInfo();
if (status)
{
string message = " <span class='actionTopic'>" + " Data Saved Successfully as Id: " +
stakeBll.StakeId + "</span>.";
MyAlertBox(
"var callbackOk = function () { window.location = \"/a/stake/create.aspx\"; }; SuccessAlert(\"" +
"Process Succeed" + "\", \"" + message + "\", \"\");");
GetStakeInfoList();
}
else
{
msgbox.Visible = true;
msgTitleLabel.Text = "Duplicate Data";
msgTitleLabel.Text = "This Group is already Added.";
}
}
else
{
stakeBll.StakeId = hdbFieldId.Value;
stakeBll.UpdateStakeInfo();
btnSave.Text = "Save";
string message = " <span class='actionTopic'>" + " Data Update Successfully as Id: " +
stakeBll.StakeId + "</span>.";
MyAlertBox(
"var callbackOk = function () { window.location = \"/a/stake/create.aspx\"; }; SuccessAlert(\"" +
"Process Succeed" + "\", \"" + message + "\", \"\");");
txtBxStakeName.Text = "";
txtBxAmount.Text = "";
txtBxAwardFrom.Text = "";
txtBxAwardTo.Text = "";
txtBxAvarage.Text = "";
txtBxDuration.Text = "";
txtBxBainoryCap.Text = "";
txtBxCommission.Text = "";
GetStakeInfoList();
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null)
{
message += " --> " + ex.InnerException.Message;
}
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
}
protected void btnSendTo_Click(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
DataRow dr = null;
UserBLL user = new UserBLL();
StakeInfoBLL stake = new StakeInfoBLL();
if (user.varifypin((string)LumexSessionManager.Get("ActiveUserId"), txtbxUserPin.Text.Trim()))
{
dt.Columns.Add(new DataColumn("Serial"));
dt.Columns.Add(new DataColumn("StakePin"));
dt.Columns.Add(new DataColumn("StakeName"));
for (int i = 0; i < gridviewSendKeyList.Rows.Count; i++)
{
dr = dt.NewRow();
Label lblSerial = (Label)gridviewSendKeyList.Rows[i].FindControl("lblSerial");
dr["Serial"] = lblSerial.Text;
dr["StakeName"] = gridviewSendKeyList.Rows[i].Cells[1].Text.ToString();
dr["StakePin"] = gridviewSendKeyList.Rows[i].Cells[2].Text.ToString();
dt.Rows.Add(dr);
}
stake.sendto = txtbxTransferTo.Text;
stake.transferBy = (string)LumexSessionManager.Get("ActiveUserId");
stake.sendSms = txtbxSendSMS.Text;
if (stake.sendto != stake.transferBy)
{
bool status = stake.updateKeyonTransfer(dt);
if (status)
{
string message = " <span class='actionTopic'>" +
" This Pin is transfered successfully. Thanks" + "</span>.";
MyAlertBox(
"var callbackOk = function () { window.location = \"/a/stake/stakekeymanage.aspx\"; }; SuccessAlert(\"" +
"Process Success" + "\", \"" + message + "\", callbackOk);");
}
}
else
{
string message = " <span class='actionTopic'>" +
"Key Sender and Receiver will not Same. Thanks" + "</span>.";
MyAlertBox(
"var callbackOk = function () { window.location = \"/a/stake/stakekeymanage.aspx\"; }; WarningAlert(\"" +
"Process Failed" + "\", \"" + message + "\", \"\");");
}
}
else
{
string message = " <span class='actionTopic'>" + " This Pin is already transfered, you can not Deactive this Pin. Thanks" + "</span>.";
MyAlertBox(
"var callbackOk = function () { window.location = \"/a/stake/stakekeymanage.aspx\"; }; WarningAlert(\"" +
"Process Failed" + "\", \"" + message + "\", \"\");");
}
}
catch (Exception)
{
throw;
}
}
protected void btnPurches_Click(object sender, EventArgs e)
{
try
{
UserAccountBLL userAccount = new UserAccountBLL();
StakeInfoBLL stakeInfo = new StakeInfoBLL();
UserBLL user = new UserBLL();
if (user.varifypin((string)LumexSessionManager.Get("ActiveUserId"), txtbxUserPintoPurches.Text))
{
DataTable dt = userAccount.getAccountSummaryById((string)LumexSessionManager.Get("ActiveUserId"));
Decimal WalletAmount = 0;
string totalcount = "";
if (ddlPaymentBy.SelectedValue == "1")
{
WalletAmount = Convert.ToDecimal(dt.Rows[0]["Income"].ToString());
}
else if (ddlPaymentBy.SelectedValue == "2")
{
WalletAmount = Convert.ToDecimal(dt.Rows[0]["FxFund"].ToString());
}
if (Convert.ToDecimal(lblTotalPrice.Text) <= WalletAmount)
{
///NEW///
StakeInfoBLL stake = new StakeInfoBLL();
int TotalPin = Convert.ToInt16(txtbxNoStake.Text);
DataTable dtstake = new DataTable();
DataRow dr = null;
dtstake.Columns.Add(new DataColumn("StakeId"));
dtstake.Columns.Add(new DataColumn("StakePin"));
dtstake.Columns.Add(new DataColumn("IsActive"));
for (int i = 0; i < TotalPin;)
{
string pinserial = GetSerialNumber();
dr = dtstake.NewRow();
if (!stake.CheckDuplicateKey(pinserial))
{
dr["StakeId"] = ddlstakeList.SelectedValue;
dr["StakePin"] = pinserial;
dr["IsActive"] = "Yes";
dtstake.Rows.Add(dr);
i++;
}
}
if (dtstake.Rows.Count == TotalPin && TotalPin > 0)
{
bool status = stake.SaveGeneratedPin(dtstake);
if (status)
{
dt = stakeInfo.updateKeyWhenPurchase(lblQuntity.Text, lblUnitPrice.Text,
ddlstakeList.SelectedValue, ddlPaymentBy.SelectedValue);
if (dt.Rows.Count > 0)
{
totalcount = dt.Rows[0][0].ToString();
}
string message = " <span class='actionTopic'>" + totalcount +
"KEY purchase Successfully. Thanks" + "</span>.";
MyAlertBox(
"var callbackOk = function () { window.location = \"/a/stake/stakekeymanage.aspx\"; }; SuccessAlert(\"" +
"Process Success" + "\", \"" + message + "\",callbackOk);");
getStakeKeyList();
}
}
}
else
{
string message = " <span class='actionTopic'>" +
"Sorry you don't have sufficent Amount to purchase KEY. Thanks" + "</span>.";
MyAlertBox(
"var callbackOk = function () { window.location = \"/a/initialdata/stakekeymanage.aspx\"; }; WarningAlert(\"" +
"Process Failed" + "\", \"" + message + "\", \"\");");
}
}
else
{
string message = " <span class='actionTopic'>" + "Sorry Your PIN is not Correct. Input the correct one Thanks" + "</span>.";
MyAlertBox(
"var callbackOk = function () { window.location = \"/a/initialdata/stakekeymanage.aspx\"; }; WarningAlert(\"" +
"Process Failed" + "\", \"" + message + "\", \"\");");
}
}
catch (Exception)
{
//throw;
}
}
protected void btnGenerate_Click(object sender, EventArgs e)
{
try
{
LoginBll loginbll = new LoginBll();
loginbll.UserId = (string)LumexSessionManager.Get("ActiveUserId");
loginbll.UserPass = txtbxPassword.Text.Trim();
if (loginbll.VerifyPassword())
{
StakeInfoBLL stake = new StakeInfoBLL();
int TotalPin = Convert.ToInt16(txtbxTotalPin.Text);
DataTable dt = new DataTable();
DataRow dr = null;
dt.Columns.Add(new DataColumn("StakeId"));
dt.Columns.Add(new DataColumn("StakePin"));
dt.Columns.Add(new DataColumn("IsActive"));
for (int i = 0; i < TotalPin;)
{
Random random = new Random();
string pinserial = GetSerialNumber();
dr = dt.NewRow();
if (!stake.CheckDuplicateKey(pinserial))
{
dr["StakeId"] = ddlStakeList.SelectedValue;
dr["StakePin"] = pinserial;
dr["IsActive"] = "Yes";
dt.Rows.Add(dr);
i++;
}
}
if (dt.Rows.Count == TotalPin && TotalPin > 0)
{
bool status = stake.SaveGeneratedPin(dt);
if (status)
{
UserAccountBLL accountBll = new UserAccountBLL();
accountBll.TotalAmount = Convert.ToDecimal(txtbxTotalPin.Text) *
stake.getstakeAmountByStakeId(ddlStakeList.SelectedValue);
accountBll.Particular = "Generate PIN Amount-" + accountBll.TotalAmount.ToString() + " of Stake" +
ddlStakeList.SelectedItem.Text;
accountBll.RPType = "CR";
accountBll.AffectforId = "";
accountBll.Affectfor = "PIN Generate";
accountBll.InsertReceivePaymentWhenAffectIncome();
GetGeneratedPinList();
string message = " <span class='actionTopic'> The" + TotalPin.ToString() +
" is Generated successfully. Thanks" + "</span>.";
MyAlertBox(
"var callbackOk = function () { window.location = \"/a/initialdata/initialDataElement.aspx\"; }; SuccessAlert(\"" +
"Process Succeed" + "\", \"" + message + "\", \"\");");
}
}
}
else
{
msgbox.Visible = true; msgTitleLabel.Text = "Password Miss Match!!"; msgDetailLabel.Text = "Sorry your given password don't Match. Try Correct one.";
msgbox.Attributes.Add("Class", "alert alert-warning");
}
}
catch (Exception)
{
throw;
}
}
