// @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);
}
private void LoadPaymentMethodList()
{
try
{
UserAccountBLL account = new UserAccountBLL();
string Type = "";
if (ddlType.SelectedValue == "0")
{
Type = "0";
}
else if (ddlType.SelectedValue == "2")
{
Type = "1";
}
else if (ddlType.SelectedValue == "3")
{
Type = "2";
}
DataTable dt = account.GetPaymentInfoNyIdandType((string)LumexSessionManager.Get("ActiveUserId"), Type);
if (ddlType.SelectedValue == "0")
{
ddlPaymentMethod.Items.Clear();
ddlPaymentMethod.DataSource = dt;
ddlPaymentMethod.DataTextField = "BankName";
ddlPaymentMethod.DataValueField = "Account";
ddlPaymentMethod.DataBind();
ddlPaymentMethod.Items.Insert(0, "Select Here..");
ddlPaymentMethod.SelectedIndex = 0;
ddlPaymentMethod.Items[0].Value = "";
}
else if (ddlType.SelectedValue == "2")
{
ddlPaymentMethod.Items.Clear();
ddlPaymentMethod.DataSource = dt;
ddlPaymentMethod.DataTextField = "CardNo";
ddlPaymentMethod.DataValueField = "CardWoner";
ddlPaymentMethod.DataBind();
ddlPaymentMethod.Items.Insert(0, "Select Here..");
ddlPaymentMethod.SelectedIndex = 0;
ddlPaymentMethod.Items[0].Value = "";
}
else if (ddlType.SelectedValue == "3")
{
ddlPaymentMethod.Items.Clear();
ddlPaymentMethod.DataSource = dt;
ddlPaymentMethod.DataTextField = "GatewayOwner";
ddlPaymentMethod.DataValueField = "GatewayEmail";
ddlPaymentMethod.DataBind();
ddlPaymentMethod.Items.Insert(0, "Select Here..");
ddlPaymentMethod.SelectedIndex = 0;
ddlPaymentMethod.Items[0].Value = "";
}
}
catch (Exception)
{
// throw;
}
}
//private void GetBranch()
//{
// DataTable dt = new DataTable();
// BranchBLL branchBll = new BranchBLL();
// try
// {
// dt = branchBll.GetBranchList();
// if (dt.Rows.Count > 0)
// {
// BranchDropDownList.DataSource = dt;
// BranchDropDownList.DataValueField = "BranchId";
// BranchDropDownList.DataTextField = "Name";
// BranchDropDownList.DataBind();
// BranchDropDownList.Items.Insert(0, "----------Select----------");
// // BranchDropDownList.SelectedIndex = 0;
// BranchDropDownList.SelectedValue = (string)LumexSessionManager.Get("UserBranchId");
// }
// dt.Clear();
// }
// catch (Exception ex)
// {
// string message = ex.Message;
// if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
// MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
// }
//}
protected void GetUserList()
{
UserBLL user = new UserBLL();
try
{
DataTable dt = user.GetUserListByBruchId(LumexSessionManager.Get("UserBranchId").ToString());
userListGridView.DataSource = dt;
userListGridView.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 ex)
{
string message = ex.Message;
if (ex.InnerException != null)
{
message += " --> " + ex.InnerException.Message;
}
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
user = null;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
msgbox.Visible = false;
if (!IsPostBack)
{
LumexSessionManager.Add("CenterId", "CNT001");
LumexSessionManager.Add("ActiveUserId", "Developer");
GetUserGroupList();
}
if (userGroupListGridView.Rows.Count > 0)
{
userGroupListGridView.UseAccessibleHeader = true;
userGroupListGridView.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null)
{
message += " --> " + ex.InnerException.Message;
}
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
}
private void PopulatSideberemenu()
{
usermenu = new DataTable();
string menufor = (string)LumexSessionManager.Get("ActiveMenuFor");
//if (menufor == "inv")
//{
// usermenu = (DataTable)LumexSessionManager.Get("menuinv");
//}
//else if (menufor == "acc")
//{
// usermenu = (DataTable)LumexSessionManager.Get("menuacc");
//}
//else if (menufor == "stn")
//{
// usermenu = (DataTable)LumexSessionManager.Get("menustn");
//}
//if (usermenu != null)
//{
// LumexSessionManager.Add("isMenu", "Y");
//}
//else
//{
// LumexSessionManager.Add("isMenu", "N");
//}
if (LumexSessionManager.Get("ActiveUserId").ToString() == "sysadmin")
{
PopulateUserMenuForDeveloper(menufor);
}
else
{
PopulateUserMenu(menufor);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
msgbox.Visible = false;
if (!IsPostBack)
{
LoadUserGroups();
//GetBranch();
// GetBranch();
userIdForUpdateHiddenField.Value = (string)LumexSessionManager.Get("UserIdForUpdate");
if (string.IsNullOrEmpty(userIdForUpdateHiddenField.Value))
{
Response.Redirect("~/setting/User/List.aspx", true);
}
else
{
GetUserById(userIdForUpdateHiddenField.Value.Trim());
}
}
if (LumexSessionManager.Get("UserGroupId").ToString() == "UG001")
{
txtbxemail.Enabled = true;
}
}
catch (Exception ex)
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
msgbox.Attributes.Add("Class", "alert alert-warning");
}
}
public bool UpdateUser(UserBLL user, LumexDBPlayer db)
{
bool status = false;
try
{
//db.AddParameters("@Serial", user.Serial.Trim());
db.AddParameters("@UserId", user.UserId.Trim());
db.AddParameters("@UserName", user.UserName.Trim());
//db.AddParameters("@EmployeeId", "");
db.AddParameters("@UserGroupId", user.UserGroupId.Trim());
//db.AddParameters("@Department", "");
//db.AddParameters("@Designation", "");
//db.AddParameters("@Address","");
db.AddParameters("@ContactNumber", user.Cell.Trim());
db.AddParameters("@Email", user.Email.Trim());
//db.AddParameters("@NationalId", "");
//db.AddParameters("@PassportNumber", "");
// db.AddParameters("@BaranchId", user.Branch);
db.AddParameters("@ModifiedBy", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal());
//db.AddParameters("@Password", LumexLibraryManager.EncodeIntoMd5Hash(user.Password));
status = Convert.ToBoolean(db.ExecuteNonQuery("UPDATE_USER_BY_ID", true));
}
catch (Exception)
{
throw;
}
finally
{
user = null;
}
return(status);
}
protected void btnChangePin_Click(object sender, EventArgs e)
{
UserBLL user = new UserBLL();
try
{
if (string.IsNullOrEmpty(currentPinTextBox.Text.Trim()))
{
msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Current Pin field is required.";
msgbox.Attributes.Add("Class", "alert alert-warning");
}
else if (string.IsNullOrEmpty(newPinTextBox.Text.Trim()))
{
msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "New Pin field is required.";
msgbox.Attributes.Add("Class", "alert alert-warning");
}
else if (string.IsNullOrEmpty(confirmNewPinTextBox.Text.Trim()))
{
msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Confirm New Pin field is required.";
msgbox.Attributes.Add("Class", "alert alert-warning");
}
else if (newPinTextBox.Text.Trim() != confirmNewPinTextBox.Text.Trim())
{
msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "New Pin & Confirm New Pin do not match.";
msgbox.Attributes.Add("Class", "alert alert-warning");
}
else
{
// user.UserId = LumexSessionManager.Get("ActiveLoginId").ToString();
/*need to modify this validateUser. */
if (user.varifypin((string)LumexSessionManager.Get("ActiveUserId"), currentPinTextBox.Text.Trim()))
{
user.UpdateUserPin((string)LumexSessionManager.Get("ActiveUserId"),
confirmNewPinTextBox.Text.Trim());
string message = "Pin <span class='actionTopic'>Updated</span> Successfully.";
MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/setting/User/pinset.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);");
}
else
{
string message = "<span class='actionTopic'>Invalid</span> Current Pin. You can't change your pin.";
MyAlertBox("ErrorAlert(\"" + "Process Failed" + "\", \"" + message + "\");");
}
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null)
{
message += " --> " + ex.InnerException.Message;
}
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
user = null;
}
}
protected void Page_Load(object sender, EventArgs e)
{
string ActiveUser = (string)LumexSessionManager.Get("ActiveUserId");
string ActiveUserName = (string)LumexSessionManager.Get("ActiveUserName");
// lblloginby.Text = ActiveUserName;
// string url = HttpContext.Current.Request.Url.AbsoluteUri;
// string path = HttpContext.Current.Request.Url.AbsolutePath;
// string host = HttpContext.Current.Request.Url.Host;
if (!IsPostBack)
{
if (string.IsNullOrEmpty(ActiveUser))
{
Response.Redirect("~/login.aspx");
}
else
{
// ImgbtnHr_Click();
PopulatSideberemenu();
string userID = LumexSessionManager.Get("ActiveUserId").ToString();
GetUserById(userID);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
msgbox.Visible = false;
if (!IsPostBack)
{
fromDateTextBox.Text = LumexLibraryManager.GetAppDateView(DateTime.Today.ToString());
toDateTextBox.Text = LumexLibraryManager.GetAppDateView(DateTime.Today.ToString());
LumexSessionManager.Add("CenterId", "CNT001");
LumexSessionManager.Add("ActiveUserId", "Developer");
}
if (deletedListGridView.Rows.Count > 0)
{
deletedListGridView.UseAccessibleHeader = true;
deletedListGridView.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null)
{
message += " --> " + ex.InnerException.Message;
}
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
}
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;
}
}
private void checkuserPinchangevalidity()
{
try
{
UserBLL user = new UserBLL();
DataTable dt = user.checkuserPinchangevalidity((string)LumexSessionManager.Get("ActiveUserId"));
lblChangeCout.Text = dt.Rows[0]["ModifyCount"].ToString();
if (Convert.ToInt32(lblChangeCout.Text) >= 3)
{
if (dt.Rows[0]["IsPaid"].ToString() == "Yes")
{
currentPinTextBox.Enabled = true;
btnPayforPinGenerate.Visible = false;
}
else
{
currentPinTextBox.Enabled = false;
btnPayforPinGenerate.Visible = true;
}
}
// Check change conditaion now.
}
catch (Exception)
{
//throw;
}
}
internal DataTable UpdatePaymentInfoBySerial(UserAccountBLL account, LumexDBPlayer db)
{
bool status;
DataTable dt = new DataTable();
try
{
db.AddParameters("@serial", LumexSessionManager.Get("Serial").ToString());
db.AddParameters("@UserId", account.UserId);
db.AddParameters("@GatewayType", account.Type);
db.AddParameters("@BankName", account.BankName);
db.AddParameters("@BankAccount", account.BankAccountNo);
db.AddParameters("@SwiftCode", account.SwiftCode);
db.AddParameters("@CardNo", account.CardNumber);
db.AddParameters("@CardWoner", account.CardOwnerName);
db.AddParameters("@ExpireDate", LumexLibraryManager.ParseAppDate(account.CardExpireDate));
db.AddParameters("@GatewayEmail", account.OnlineEmail);
db.AddParameters("@GatewayOwner", account.GateWayOwnerName);
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@IsActive", "Yes");
db.ExecuteNonQuery("INSERT INTO [dbo].[tblPaymetnMethod] ([GatewayType], [BankName], [BankAccount], [SwiftCode], [CardNo], [CardWoner], [ExpireDate], [GatewayEmail], [GatewayOwner], [UserId], [CreatedBy], [IsActive]) VALUES (@GatewayType, @BankName, @BankAccount, @SwiftCode, @CardNo, @CardWoner, @ExpireDate, @GatewayEmail, @GatewayOwner, @UserId, @CreatedBy, @IsActive)");
status = true;
}
catch (Exception)
{
throw;
}
return(dt);
}
protected void GetMenuListToPrivilegeUser()
{
AppMenuBLL appMenuBLL = new AppMenuBLL();
try
{
groupWiseMenuListListBox.Items.Clear();
DataTable dt = appMenuBLL.GetMenuListToPrivilegeUser(LumexSessionManager.Get("ActiveUserId").ToString(), menuForAppDropDownList.SelectedValue.Trim(), menuTypeDropDownList.SelectedValue.Trim(), menuGroupDropDownList.SelectedValue.Trim());
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
groupWiseMenuListListBox.Items.Add(new ListItem(dt.Rows[i]["MenuName"].ToString(), dt.Rows[i]["MenuId"].ToString()));
}
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null)
{
message += " --> " + ex.InnerException.Message;
}
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
appMenuBLL = null;
countMenuLabel.Text = "Total: " + groupWiseMenuListListBox.Items.Count.ToString();
}
}
//************************
protected void GetMenuListToPrivilegeUser()
{
AppMenuBLL appMenuBLL = new AppMenuBLL();
try
{
groupWiseMenuListListBox.Items.Clear();
DataTable dt = appMenuBLL.GetMenuListToPrivilegeUser(LumexSessionManager.Get("ActiveUserId").ToString(), menuForAppDropDownList.SelectedValue.Trim(), menuTypeDropDownList.SelectedValue.Trim(), menuGroupDropDownList.SelectedValue.Trim());
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
groupWiseMenuListListBox.Items.Add(new ListItem(dt.Rows[i]["MenuName"].ToString(), dt.Rows[i]["MenuId"].ToString()));
}
}
else
{
msgbox.Attributes.Add("class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "User Menu Not Found!!!"; msgDetailLabel.Text = "";
}
}
catch (Exception ex)
{
msgbox.Attributes.Add("class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
}
finally
{
appMenuBLL = null;
countMenuLabel.Text = "Total: " + groupWiseMenuListListBox.Items.Count.ToString();
}
}
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;
}
}
protected void EditBtn_Click(object sender, EventArgs e)
{
UserBLL aUser = new UserBLL();
LinkButton lnkBtn = (LinkButton)sender;
LumexSessionManager.Add("UserIdForUpdate", lblUserId.Text);
Response.Redirect("~/setting/User/UserInfoList.aspx");
}
private void ViewUserInfo()
{
UserBLL aUser = new UserBLL();
try
{
//if (Session["UserIdForView"] == null)
//{
// aUser.UserId = LumexSessionManager.Get("ActiveUserId").ToString();
//}
//else
//{
// aUser.UserId = LumexSessionManager.Get("UserIdForView").ToString();
//}
aUser.UserId = LumexSessionManager.Get("ActiveUserId").ToString();
lblUserId.Text = aUser.UserId;
LumexSessionManager.Add("UserIdForUpdate", lblUserId.Text);
DataTable dt = new DataTable();
dt = aUser.GetUserInfoByIdForView(aUser.UserId);
if (dt.Rows.Count > 0)
{
lvlName.Text = dt.Rows[0]["FirstName"].ToString() + dt.Rows[0]["LastName"].ToString();
lvlEmail.Text = dt.Rows[0]["Email"].ToString();
lvlMobile.Text = dt.Rows[0]["MobileNo"].ToString();
lvlLeft.Text = dt.Rows[0]["TotalLeft"].ToString() + " [" + dt.Rows[0]["LeftCount"].ToString() + "]";
lvlRight.Text = dt.Rows[0]["TotalRight"].ToString() + " [" + dt.Rows[0]["RightCount"].ToString() + "]";
LumexSessionManager.Remove("UserIdForView");
if (dt.Rows[0]["IsActive"].ToString() == "Yes")
{
btnActive.Visible = false;
lvlIsActive.Visible = false;
UserAccountBLL userAccount = new UserAccountBLL();
dt = userAccount.GetUserActivationInfoById(lblUserId.Text);
lblStakeName.Text = dt.Rows[0]["StakeName"].ToString();
lblStakeValue.Text = (('$') + dt.Rows[0]["Invest"].ToString());
lblReferal.Text = dt.Rows[0]["RefferId"].ToString();
lblPlacement.Text = dt.Rows[0]["PleacementId"].ToString() + "(" + dt.Rows[0]["PlacePosition"].ToString() + ")";
lblStakeJoinDate.Text = dt.Rows[0]["JoinDate"].ToString();
lblActiveDate.Text = dt.Rows[0]["ActiveDate"].ToString();
}
else
{
lvlIsActive.Visible = true;
lvlIsActive.Text = "Click the Active button to active your account.";
btnActive.Visible = true;
}
}
}
catch (Exception)
{
// throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if ((string)LumexSessionManager.Get("UserGroupId") == "UG003")
{
btnTodayBonusGenerate.Visible = false;
}
}
}
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 Page_Load(object sender, EventArgs e)
{
try
{
LumexSessionManager.RemoveAll();
Response.Redirect("/login.aspx");
}
catch (Exception)
{
//throw;
}
}
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();
}
public DataTable GetActiveUserGroupList(LumexDBPlayer db)
{
try
{
db.AddParameters("@BranchId", LumexSessionManager.Get("UserBranchId"));
DataTable dt = db.ExecuteDataTable("GET_ACTIVE_USER_GROUP_LIST", true);
return(dt);
}
catch (Exception)
{
throw;
}
}
public DataTable GetUserList(LumexDBPlayer db)
{
try
{
db.AddParameters("@BranchId", LumexSessionManager.Get("UserBranchId"));
DataTable dt = db.ExecuteDataTable("GET_USERS", true);
return(dt);
}
catch (Exception)
{
throw;
}
}
protected void btnDepositOk_OnClick(object sender, EventArgs e)
{
UserAccountBLL accountBll = new UserAccountBLL();
UserBLL userBll = new UserBLL();
bool status = false;
accountBll.Amount = txtbxDepositAmmount.Text.Trim();
userBll.UserId = (string)LumexSessionManager.Get("ActiveUserId");
if (userBll.varifypin(userBll.UserId, txtbxDepositPin.Text))
{
if (Convert.ToDecimal(accountBll.Amount) <= Convert.ToDecimal(lvlDeposit.Text))
{
status =
accountBll.UpdateUserIncomeBalanceFromDeposit((string)LumexSessionManager.Get("ActiveUserId"),
accountBll.Amount);
if (status)
{
string message = " <span class='actionTopic'>" + " Income Balance Updated Successfully " +
"</span>.";
MyAlertBox(
"var callbackOk = function () { window.location = \"/a/account/myaccount.aspx\"; }; SuccessAlert(\"" +
"Process Succeed" + "\", \"" + message + "\", callbackOk);");
}
else
{
string message = " <span class='actionTopic'>" + " Transfer Failed " +
"</span>.";
MyAlertBox(
"var callbackOk = function () { window.location = \"/\"; }; WarningAlert(\"" +
"Warning!!" + "\", \"" + message + "\", \"\");");
}
}
else
{
string message = " <span class='actionTopic'>" + "Sorry You don't have sufficent Balance." +
"</span>.";
MyAlertBox(
"var callbackOk = function () { window.location = \"/\"; }; WarningAlert(\"" +
"Warning!!" + "\", \"" + message + "\", \"\");");
}
}
else
{
string message = " <span class='actionTopic'>" + " Pin is Incorrect " +
"</span>.";
MyAlertBox(
"var callbackOk = function () { window.location = \"/\"; }; WarningAlert(\"" +
"Warning!!" + "\", \"" + message + "\", \"\");");
}
}
internal void InsertReceivePaymentWhenDailybonus(LumexDBPlayer db)
{
try
{
db.AddParameters("@CreatedBy", (string)LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("[INSERT_RECEIVE_PAYMENT_WHEN_DAILY_BONUS]", true);
}
catch (Exception)
{
// throw;
}
}
public DataTable CreateId(LumexDBPlayer db, string flag)
{
try
{
db.AddParameters("@HeadName", flag);
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
DataTable dt = db.ExecuteDataTable("[GET_AUTO_GENERATE_NUMBER_FROM_IDCREATE]", true);
return(dt);
}
catch (Exception)
{
throw;
}
}
internal void SaveGeneratedPin(DataTable dt, LumexDBPlayer db)
{
try
{
db.AddParameters("@StakeGen", dt);
db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteDataTable("INSERT_STAKE_PIN", true);
}
catch (Exception)
{
throw;
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
if (txtbxUserName.Text != "" && txtbxPassword.Text != "")
{
try
{
LoginBll loginbll = new LoginBll();
loginbll.UserId = txtbxUserName.Text.ToString();
loginbll.UserPass = txtbxPassword.Text.ToString();
if (loginbll.VerifyPassword())
{
loginbll = loginbll.GetUserById(loginbll.UserId);
if (loginbll.IsVarified == "Yes")
{
LumexSessionManager.Add("UserGroupId", loginbll.UserGroup);
LumexSessionManager.Add("ActiveUserId", loginbll.UserId);
LumexSessionManager.Add("ActiveUserName", loginbll.UserName);
LumexSessionManager.Add("UserLastName", loginbll.LastName);
LumexSessionManager.Add("UserAvater", loginbll.PerPhoto);
LumexSessionManager.Add("isMenu", "N");
LumexSessionManager.Add("ActiveMenuFor", "globalapp");
//LumexSessionManager.Add("UserIdForView","");
Response.Redirect("~/default.aspx", false);
}
else
{
string message = " <span class='actionTopic'>" + " Your account is not Varified. Please Check your Email. Thanks" + "</span>.";
MyAlertBox("var callbackOk = function () { window.location = \"/login.aspx\"; }; SuccessAlert(\"" +
"Process Succeed" + "\", \"" + message + "\", \"\");");
}
}
else
{
lblmsg.Visible = true;
lblmsg.Text = "User ID or Password is invalid.";
}
}
catch (Exception ex)
{
// lblmsg.Visible = true;
// lblmsg.Text = ex.ToString();
}
}
else
{
lblmsg.Visible = true;
lblmsg.Text = "UserName or Password field is Empty.";
}
}
internal void updateUserAccountforTransfer(BLL.UserAccountBLL userAccountBLL, LumexDBPlayer db)
{
try
{
db.AddParameters("@Amount", userAccountBLL.Amount);
db.AddParameters("@userId", (string)LumexSessionManager.Get("ActiveUserId"));
db.ExecuteNonQuery("Update tblUserAccounts Set Income = ISNULL( Income,0)-@Amount where UserId=@userId");
}
catch (Exception)
{
throw;
}
}
