Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <form id="formFilter" action="goes to controller" method="post">
- @Html.AntiForgeryToken()
- <input type="button" value="Submit" onclick="OnFormSubmit()" />
- </form>
- <div id="dataResult"></div>
- <script>
- var frm = $('#formFilter');
- OnFormSubmit();
- function OnFormSubmit() {
- $.ajax({
- type: frm.attr('method'),
- url: frm.attr('action'),
- data: frm.serialize(),
- success: function (data) {
- console.log('Submission successfull.');
- $("#dataResult").html(data);
- $('#dataTable').DataTable({
- "pageLength": 100,
- });
- },
- error: function (data) {
- console.log(data);
- },
- });
- }
- </script>
- private List<TrackingTest> GetListChanges(Report ControlData)
- {
- var CCListFilter = db.TrackingTest.SqlQuery("select top 20000 * FROM testtable ").ToList();
- var cclisttop100 = db.TrackingTest.SqlQuery("select top 100 * FROM testtable ").ToList();
- {
- if (!string.IsNullOrEmpty(ControlData.primary_name) || !string.IsNullOrEmpty(ControlData.card_holder_name) || !string.IsNullOrEmpty(ControlData.card_number) ||
- (ControlData.account_num != null) || !string.IsNullOrEmpty(ControlData.checknumbers) ||
- !string.IsNullOrEmpty(ControlData.filenumber) || ((ControlData.claimamount1 != null) && (ControlData.claimamount2 != null)) ||
- !string.IsNullOrEmpty(ControlData.type_fraudCard) ||
- ((ControlData.denied_fraud1 != null) && (ControlData.denied_fraud2 != null)) || ((ControlData.insuranceClaim1 != null) && (ControlData.insuranceClaim2 != null))
- || ( ControlData.frauddate1 != DateTime.MinValue) || (ControlData.frauddate2 != DateTime.MinValue)
- )
- {
- if (!string.IsNullOrEmpty(ControlData.primary_name))
- {
- CCListFilter = CCListFilter.Where(x => x.primary_name.Contains(ControlData.primary_name.ToUpper())).ToList();
- }
- if (!string.IsNullOrEmpty(ControlData.card_holder_name))
- {
- CCListFilter = CCListFilter.Where(x => x.card_holder_name.Contains(ControlData.card_holder_name.ToUpper())).ToList();
- }
- if (!string.IsNullOrEmpty(ControlData.card_number))
- {
- CCListFilter = CCListFilter.Where(x => x.card_number == ControlData.card_number).ToList();
- }
- if ((ControlData.account_num != null))
- {
- CCListFilter = CCListFilter.Where(x => x.account_num == ControlData.account_num).ToList();
- }
- if (ControlData.filenumber != null)
- {
- CCListFilter = CCListFilter.Where(x => x.file_number == ControlData.filenumber).ToList();
- }
- if (ControlData.frauddate1 != DateTime.MinValue)
- {
- CCListFilter = CCListFilter.Where(x => x.fraud_date == ControlData.frauddate1).ToList();
- }
- if (ControlData.frauddate1 != DateTime.MinValue && ControlData.frauddate2 != DateTime.MinValue)
- {
- CCListFilter = CCListFilter.Where(x => x.fraud_date >= ControlData.frauddate1 && x.fraud_date <= ControlData.frauddate2).ToList();
- }
- ...i have more IF statementes here....
- return CCListFilter;
- }
- }
- return cclisttop100;
- }
Add Comment
Please, Sign In to add comment