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;
            }
        }
Exemplo n.º 2
0
        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);
        }
Exemplo n.º 3
0
        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();");
            }
        }
Exemplo n.º 4
0
        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);
        }
Exemplo n.º 5
0
        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);
        }
Exemplo n.º 6
0
        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);
        }
Exemplo n.º 7
0
        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);
        }
Exemplo n.º 8
0
        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);
        }
Exemplo n.º 9
0
        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();");
            }
        }