protected void allDeletedListButton_Click(object sender, EventArgs e) { UserGroupBLL userGroup = new UserGroupBLL(); try { string fromDate = LumexLibraryManager.ParseAppDate(fromDateTextBox.Text.Trim()); string toDate = LumexLibraryManager.ParseAppDate(toDateTextBox.Text.Trim()); DataTable dt = userGroup.GetDeletedUserGroupListByDateRangeAll(fromDate, toDate, "All"); deletedListGridView.DataSource = dt; deletedListGridView.DataBind(); if (deletedListGridView.Rows.Count > 0) { deletedListGridView.UseAccessibleHeader = true; deletedListGridView.HeaderRow.TableSection = TableRowSection.TableHeader; } else { msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Data 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 { userGroup = null; } }
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 ViewButton_Click(object sender, EventArgs e) { try { if (ddlStatus.SelectedValue == "P") { GridViewWithdrawRequest.Columns[6].Visible = false; GridViewWithdrawRequest.Columns[7].Visible = false; } else if (ddlStatus.SelectedValue == "R") { // GridViewWithdrawRequest.Columns[5].Visible = false; GridViewWithdrawRequest.Columns[7].Visible = false; GridViewWithdrawRequest.Columns[10].Visible = false; GridViewWithdrawRequest.Columns[11].Visible = false; } else if (ddlStatus.SelectedValue == "A") { // GridViewWithdrawRequest.Columns[5].Visible = false; GridViewWithdrawRequest.Columns[6].Visible = false; GridViewWithdrawRequest.Columns[10].Visible = false; GridViewWithdrawRequest.Columns[11].Visible = false; } UserAccountBLL userAccount = new UserAccountBLL(); DataTable dt = userAccount.getWithdrawRequestList(LumexLibraryManager.ParseAppDate(fromDateTextBox.Text), LumexLibraryManager.ParseAppDate(toDateTextBox.Text), ddlStatus.SelectedValue); GridViewWithdrawRequest.DataSource = dt; GridViewWithdrawRequest.DataBind(); if (GridViewWithdrawRequest.Rows.Count > 0) { // generateButton.Visible = true; GridViewWithdrawRequest.UseAccessibleHeader = true; GridViewWithdrawRequest.HeaderRow.TableSection = TableRowSection.TableHeader; } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { MyAlertBox("MyOverlayStop();"); } }
internal DataTable getMatchingCommissionListbyDateRange(string FromDate, string ToDate, LumexDBPlayer db) { DataTable dt = new DataTable(); try { db.AddParameters("@FromDate", LumexLibraryManager.ParseAppDate(FromDate)); db.AddParameters("@ToDate", LumexLibraryManager.ParseAppDate(ToDate)); dt = db.ExecuteDataTable("Select [Serial],[UserId],[Leftcarry],[RightCarry],[CarryFlash],[CarryForward],[CarryFrwdPosition],[MatchCommission],[DailyAcBonus],[CalculateDate] FROM [dbo].[tblDailyFlashHistory] where CAST(CalculateDate AS DATE) BETWEEN CAST(@FromDate AS DATE) AND CAST(@ToDate AS DATE)"); } catch (Exception) { throw; } return(dt); }
internal DataTable getDailybounsListbyDateRange(string FromDate, string ToDate, LumexDBPlayer db) { DataTable dt = new DataTable(); try { db.AddParameters("@FromDate", LumexLibraryManager.ParseAppDate(FromDate)); db.AddParameters("@ToDate", LumexLibraryManager.ParseAppDate(ToDate)); dt = db.ExecuteDataTable("SELECT [Serial],[UserId],[DailyBonus],CONVERT(VARCHAR, CAST([BonusDate] AS SMALLDATETIME), 103)as [BonusDate] ,[CreatedFrom],[CreatedBy],[InvestAmount] FROM [dbo].[tblDailyBous] where CAST(BonusDate AS DATE) BETWEEN CAST(@FromDate AS DATE) AND CAST(@ToDate AS DATE) ORDER BY [BonusDate] ASC"); } catch (Exception) { throw; } return(dt); }
internal DataTable getTotalMatchingCommissionListbyDateRange(string FromDate, string ToDate, LumexDBPlayer db) { DataTable dt = new DataTable(); try { db.AddParameters("@FromDate", LumexLibraryManager.ParseAppDate(FromDate)); db.AddParameters("@ToDate", LumexLibraryManager.ParseAppDate(ToDate)); dt = db.ExecuteDataTable("Select [amount],CONVERT(VARCHAR, CAST([TransectionDate] AS SMALLDATETIME), 103) as [TransectionDate] FROM [dbo].[tblReceivePayment] where CAST(TransectionDate AS DATE) BETWEEN CAST(@FromDate AS DATE) AND CAST(@ToDate AS DATE) ORDER BY [TransectionDate] ASC"); } catch (Exception) { throw; } return(dt); }
internal DataTable getMoneyGenerateAmountByDateRangeById(string FromDate, string ToDate, string UserId, LumexDBPlayer db) { DataTable dt = new DataTable(); try { db.AddParameters("@FromDate", LumexLibraryManager.ParseAppDate(FromDate)); db.AddParameters("@ToDate", LumexLibraryManager.ParseAppDate(ToDate)); dt = db.ExecuteDataTable("Select [Serial],[Amount],[GenerateBy],[GenerateFrom],[GenerateDate] FROM [dbo].[tblMoneyGenerate] where CAST(GenerateDate AS DATE) BETWEEN CAST(@FromDate AS DATE) AND CAST(@ToDate AS DATE)"); } catch (Exception) { throw; } return(dt); }
internal DataTable getDailybounsListbyDateRangeByUserId(string FromDate, string ToDate, string UserId, LumexDBPlayer db) { DataTable dt = new DataTable(); try { db.AddParameters("@UserId", UserId); db.AddParameters("@FromDate", LumexLibraryManager.ParseAppDate(FromDate)); db.AddParameters("@ToDate", LumexLibraryManager.ParseAppDate(ToDate)); dt = db.ExecuteDataTable("SELECT [Serial],[UserId],[DailyBonus],[BonusDate],[CreatedFrom],[CreatedBy],[InvestAmount]FROM [dbo].[tblDailyBous] where UserId=@UserId and CAST(BonusDate AS DATE) BETWEEN CAST(@FromDate AS DATE) AND CAST(@ToDate AS DATE)"); } catch (Exception) { throw; } return(dt); }
protected void ViewButton_Click(object sender, EventArgs e) { try { UserAccountBLL userAccount = new UserAccountBLL(); DataTable dt = userAccount.getUserIncomeStatementById((string)LumexSessionManager.Get("ActiveUserId"), LumexLibraryManager.ParseAppDate(fromDateTextBox.Text), LumexLibraryManager.ParseAppDate(toDateTextBox.Text)); DesignGridviewBalaceSheet(dt); } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { //MyAlertBox("MyOverlayStop();"); } }