public JArray SearchAccountStatementDetails([FromBody] AccountStatementSearch data)
        {
            Dictionary <string, object> commandParams = new Dictionary <string, object>();

            commandParams.Add("@p_SortColumn", data.SortColumn);
            commandParams.Add("@p_SortOrder", data.SortOrder);
            commandParams.Add("@p_PageSize", data.PageSize);
            commandParams.Add("@p_PageStart", data.PageStart);

            if (data.AccountID.HasValue)
            {
                commandParams.Add("@p_AccountID", data.AccountID.Value);
            }

            if (data.AdministratorID.HasValue)
            {
                commandParams.Add("@p_AdministratorID", data.AdministratorID.Value);
            }

            commandParams.Add("@p_AccountStatementType", data.AccountStatementType);

            commandParams.Add("@p_StatementmentPeriodDate", data.StatementPeriodDate);

            if (data.StatementPeriodID.HasValue)
            {
                commandParams.Add("@p_StatementPeriodID", data.StatementPeriodID.Value);
            }

            if (data.ClientID.HasValue)
            {
                commandParams.Add("@p_ClientID", data.ClientID.Value);
            }

            DynamicList lst = DynamicList.GetData("[dbo].[spCCR_AccountStatementDetails_SelectForGrid]", commandParams);

            if (lst.Count > 0)
            {
                var data1 = (JArray)lst[0].GetValue("Data");
                return(data1);
            }

            return(null);
        }
        public JArray SearchAccountStatementSummary([FromBody] AccountStatementSearch data)
        {
            Dictionary <string, object> commandParams = new Dictionary <string, object>();

            if (data.AccountID.HasValue)
            {
                commandParams.Add("@p_AccountID", data.AccountID.Value);
            }

            if (data.AdministratorID.HasValue)
            {
                commandParams.Add("@p_AdministratorID", data.AdministratorID.Value);
            }

            commandParams.Add("@p_AccountStatementType", data.AccountStatementType);

            commandParams.Add("@p_StatementmentPeriodDate", data.StatementPeriodDate);

            if (data.StatementPeriodID.HasValue)
            {
                commandParams.Add("@p_StatementPeriodID", data.StatementPeriodID.Value);
            }

            if (data.ClientID.HasValue)
            {
                commandParams.Add("@p_ClientID", data.ClientID.Value);
            }

            DynamicList lst = DynamicList.GetData("[dbo].[spCCR_AccountStatementSummary_SelectForGrid]", commandParams);

            if (lst.Count > 0)
            {
                return(lst.GetJson());
            }

            return(null);
        }
        private void ShowAccountStatement_Click(object sender, EventArgs e)
        {
            Account_BO accountBO = new Account_BO();
            ArrayList  list      = new ArrayList(accountBO.readAccount());

            if (AccountStatementSearch.Text == "" || stYear.Text == "")
            {
                MessageBox.Show("Wrong!!! Enter the information fully");
            }
            else
            {
                try
                {
                    int flag = 0;
                    int flag1 = 0;
                    int i1 = 0, i2 = 0;
                    for (int i = 0; i < list.Count; i++)
                    {
                        if (list[i].ToString() == AccountStatementSearch.Text)
                        {
                            flag = 1;
                            i1   = i;
                            break;
                        }
                    }
                    for (int i = i1; list[i].ToString() != "*****"; i++)
                    {
                        if (list[i].ToString() == stYear.Text)
                        {
                            flag1 = 1;
                            i2    = i;
                            break;
                        }
                    }
                    if (flag == 1 && flag1 == 1)
                    {
                        try
                        {
                            Home_Admin_AccountStatement_Show home_Admin_AccountStatement_Show = new Home_Admin_AccountStatement_Show();
                            home_Admin_AccountStatement_Show.giveIndex(i1);
                            home_Admin_AccountStatement_Show.giveYear(i2);

                            this.Hide();
                            home_Admin_AccountStatement_Show.Show();
                        }
                        catch (Exception)
                        {
                            MessageBox.Show("Error!!!");
                        }
                    }
                    if (flag == 0)
                    {
                        MessageBox.Show("Sorry!!! This account number isn't Exist");
                        AccountStatementSearch.Clear();
                    }
                    if (flag1 == 0)
                    {
                        MessageBox.Show("Sorry!!! This year isn't Exist");
                        stYear.ResetText();
                    }
                }
                catch (Exception)
                {
                    MessageBox.Show("No User Exists");
                }
            }
        }