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) { 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"); } }
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; } }
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 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(); } }
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); }
// @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); }
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 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(); } }
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 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; } }
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 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); } }
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()); }
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 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 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 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; } }
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 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; } }
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; } }
internal DataTable InsertReceivePaymentWhenPinChange(LumexDBPlayer db) { try { db.AddParameters("@UserId", (string)LumexSessionManager.Get("ActiveUserId")); db.AddParameters("Amount", "5"); db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal()); DataTable dt = db.ExecuteDataTable("INSERT_RECEIVE_PAYMENT_WHEN_PINCHANGE", true); return(dt); } catch (Exception) { throw; } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { loadtStakeList(); GetUserPlacementInfoById((string)LumexSessionManager.Get("ActiveUserId")); } } catch (Exception) { //throw; } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { //initializeTree(); DrawTree((string)LumexSessionManager.Get("ActiveUserId")); } } catch (Exception) { // throw; } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { getmyAccountSummary((string)LumexSessionManager.Get("ActiveUserId")); } loadGridView(); } catch (Exception) { //throw; } }
public void DeleteUserGroup(string userGroupId, LumexDBPlayer db) { try { db.AddParameters("@UserGroupId", userGroupId); db.AddParameters("@DeletedBy", LumexSessionManager.Get("ActiveUserId")); db.AddParameters("@DeletedFrom", LumexLibraryManager.GetTerminal()); db.AddParameters("@BranchId", LumexSessionManager.Get("UserBranchId")); db.ExecuteNonQuery("DELETE_USER_GROUP_BY_ID", true); } catch (Exception) { throw; } }