Пример #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            List <ConversionReqModel> ConversionRequest = new List <ConversionReqModel>();

            using (var con = Classes.DB.InstBTCDB("instbtc"))
            {
                if (Request.HttpMethod == "POST")
                {
                    #region Build Additional Query for Search
                    string client_id_query       = !string.IsNullOrEmpty(txtClientId.Value) ? $"AND cv.client_id={txtClientId.Value} " : string.Empty;
                    string email_query           = !string.IsNullOrEmpty(txtClientEmail.Value) ? $"AND cl.email='{txtClientEmail.Value}' " : string.Empty;
                    string created_date_query    = !string.IsNullOrEmpty(txtCreatedDate.Value) ? $"AND cv.created_date::date='{DateTime.Parse(txtCreatedDate.Value)}' " : string.Empty;
                    string credited_status_query = !string.IsNullOrEmpty(txtStatus.Value) ? $"AND cv.credited_status='{txtStatus.Value}' " : string.Empty;
                    string client_name_query     = !string.IsNullOrEmpty(txtClientName.Value) ? $"AND cv.client_name LIKE '%{txtClientName.Value}%' " : string.Empty;

                    AddedQuery = string.Concat(client_id_query, email_query, created_date_query, credited_status_query, client_name_query);
                    #endregion
                }

                #region Data Filling and Pagination Handling
                Dictionary <string, int> pagerDictionary = new Dictionary <string, int>();
                string paginationString = "page";
                DocListPager.initialize(paginationString, 10);
                pagerDictionary   = DocListPager.paginate(Utilities.ConversionReqUtilities.GetConversionRequest(con, AddedQuery).Count().ToString());
                ConversionRequest = Utilities.ConversionReqUtilities.GetConversionRequest(con, AddedQuery, pagerDictionary["offset"], pagerDictionary["limit"]);
                #endregion
            }

            rowCount.InnerHtml   = $"{ConversionRequest.Count().ToString()} Records Found. .";
            resultBody.InnerHtml = BuildHtmlTable(ConversionRequest);
        }
Пример #2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            this.OrderByMode = Request.QueryString["mode"] ?? "desc";
            this.OrderBy     = Request.QueryString["orderby"] ?? "";

            if (this.OrderByMode.ToLower() != "desc")
            {
                this.OrderByMode = "asc";
            }

            if (!this.OrderByDictionary.ContainsKey(this.OrderBy))
            {
                this.OrderBy = this.OrderByDictionary.Keys.First();
            }

            using (NpgsqlConnection conn = Classes.DB.InstBTCDB("instbtc"))
            {
                string txtType        = Request.QueryString["txtType"];
                string txtStatus      = Request.QueryString["txtStatus"];
                string txtClientId    = Request.QueryString["txtClientId"];
                string txtClientEmail = Request.QueryString["txtClientEmail"];
                string txtClientName  = Request.QueryString["txtClientName"];
                string txtCreatedDate = Request.QueryString["txtCreatedDate"];

                List <Documents>         docs            = new List <Documents>();
                Dictionary <string, int> pagerDictionary = new Dictionary <string, int>();
                string paginationString = "page";

                DocListPager.initialize(paginationString, 10);
                TotalDocs       = Utilities.Documents.DocumentsCount(conn);
                pagerDictionary = DocListPager.paginate(TotalDocs);
                docs            = Utilities.Documents.GetDocuments(conn, pagerDictionary["offset"], pagerDictionary["limit"], orderby: $"{this.OrderByDictionary[this.OrderBy]} {this.OrderByMode.ToUpper()}");

                string query = this.getQuery(conn, txtType, txtStatus, txtClientId, txtClientEmail, txtClientName, txtCreatedDate);

                if (query.Length > 0)
                {
                    TotalDocs = Utilities.Documents.DocumentsCount(conn, query);
                    DocListPager.AppendExistedQuery();
                    pagerDictionary = DocListPager.paginate(TotalDocs);
                    docs            = Utilities.Documents.GetDocuments(conn, query, pagerDictionary["offset"], pagerDictionary["limit"], orderby: $"{this.OrderByDictionary[this.OrderBy]} {this.OrderByMode.ToUpper()}");
                }
                rowCount.InnerText = $"{TotalDocs} Records Found";
                ShowDocuments(conn, docs);
            }
        }
Пример #3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string pageChecker = Request.QueryString["page"];

            if (string.IsNullOrEmpty(pageChecker))
            {
                Session.Remove("WithdrawalSearch");
            }

            using (NpgsqlConnection conn = Classes.DB.InstBTCDB("instbtc"))
            {
                NpgsqlCommand command = new NpgsqlCommand();
                string        query   = string.Empty;

                if (Request.HttpMethod == "POST")
                {
                    string status         = txtStatus.Value;
                    string clientId       = txtClientId.Value;
                    string clientEmail    = txtClientEmail.Value;
                    string clientName     = txtClientName.Value;
                    string walletId       = txtWalletId.Value;
                    string documentId     = txtWalletId.Value;
                    string createdDate    = txtCreatedDate.Value;
                    string docStatus      = txtDocStatus.Value;
                    string refferenceHash = txtHash.Value;

                    WithdrawalSearchModel searchModel = new WithdrawalSearchModel()
                    {
                        Status      = status,
                        ClientModel = new ClientModelSearch
                        {
                            Id    = clientId,
                            Email = clientEmail
                        },
                        DocumentStatus  = docStatus,
                        ClientName      = clientName,
                        WalletId        = walletId,
                        DocumentId      = documentId,
                        CreatedDate     = createdDate,
                        refference_hash = refferenceHash
                    };
                    Session["WithdrawalSearch"] = searchModel;
                }

                if (Session["WithdrawalSearch"] != null)
                {
                    WithdrawalSearchModel sessionSearchModel = (WithdrawalSearchModel)Session["WithdrawalSearch"];

                    //Get SQLCommand Parameters and Query Parameters
                    KeyValuePair <NpgsqlCommand, string> pair = getParameter(sessionSearchModel);
                    command = pair.Key;
                    query   = pair.Value;
                }

                //Get Withdrawals Datas
                List <MWithdrawal> withdrawalRequest = new List <MWithdrawal>();
                withdrawalRequest = WithdrawalUtilities.WithdrawalRequest(conn, command, query);

                #region Pagination
                Dictionary <string, int> pagerDictionary = new Dictionary <string, int>();
                string paginationString = "page";
                DocListPager.initialize(paginationString, 10);
                TotalRequest         = WithdrawalUtilities.GetWithdrawalCount(conn, command, query);
                pagerDictionary      = DocListPager.paginate(TotalRequest);
                withdrawalRequest    = WithdrawalUtilities.WithdrawalRequest(conn, command, query, pagerDictionary["offset"], pagerDictionary["limit"]);
                rowCount.InnerText   = $"{TotalRequest} Records Found";
                resultBody.InnerHtml = BuildHtmlTable(withdrawalRequest).ToString();
                #endregion

                //Get Document Statuses Selection
                OptionUtilities optionUtilities = new OptionUtilities();
                txtDocStatus.Items.Clear();
                txtDocStatus.Items.AddRange(optionUtilities.GetDocumentStatusOptions());

                //Return Values to their Fields
                ReturnFieldValues();
            }
        }