Guest User

Untitled

a guest
Nov 15th, 2018
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.81 KB | None | 0 0
  1. <form id="formFilter" action="goes to controller" method="post">
  2. @Html.AntiForgeryToken()
  3. <input type="button" value="Submit" onclick="OnFormSubmit()" />
  4.  
  5. </form>
  6.  
  7.  
  8. <div id="dataResult"></div>
  9.  
  10. <script>
  11. var frm = $('#formFilter');
  12.  
  13. OnFormSubmit();
  14. function OnFormSubmit() {
  15. $.ajax({
  16. type: frm.attr('method'),
  17. url: frm.attr('action'),
  18. data: frm.serialize(),
  19. success: function (data) {
  20.  
  21. console.log('Submission successfull.');
  22. $("#dataResult").html(data);
  23. $('#dataTable').DataTable({
  24. "pageLength": 100,
  25.  
  26. });
  27. },
  28. error: function (data) {
  29.  
  30. console.log(data);
  31. },
  32. });
  33. }
  34.  
  35. </script>
  36.  
  37. private List<TrackingTest> GetListChanges(Report ControlData)
  38. {
  39. var CCListFilter = db.TrackingTest.SqlQuery("select top 20000 * FROM testtable ").ToList();
  40.  
  41.  
  42. var cclisttop100 = db.TrackingTest.SqlQuery("select top 100 * FROM testtable ").ToList();
  43. {
  44. if (!string.IsNullOrEmpty(ControlData.primary_name) || !string.IsNullOrEmpty(ControlData.card_holder_name) || !string.IsNullOrEmpty(ControlData.card_number) ||
  45. (ControlData.account_num != null) || !string.IsNullOrEmpty(ControlData.checknumbers) ||
  46. !string.IsNullOrEmpty(ControlData.filenumber) || ((ControlData.claimamount1 != null) && (ControlData.claimamount2 != null)) ||
  47. !string.IsNullOrEmpty(ControlData.type_fraudCard) ||
  48. ((ControlData.denied_fraud1 != null) && (ControlData.denied_fraud2 != null)) || ((ControlData.insuranceClaim1 != null) && (ControlData.insuranceClaim2 != null))
  49. || ( ControlData.frauddate1 != DateTime.MinValue) || (ControlData.frauddate2 != DateTime.MinValue)
  50. )
  51. {
  52.  
  53.  
  54. if (!string.IsNullOrEmpty(ControlData.primary_name))
  55. {
  56.  
  57. CCListFilter = CCListFilter.Where(x => x.primary_name.Contains(ControlData.primary_name.ToUpper())).ToList();
  58. }
  59.  
  60. if (!string.IsNullOrEmpty(ControlData.card_holder_name))
  61. {
  62. CCListFilter = CCListFilter.Where(x => x.card_holder_name.Contains(ControlData.card_holder_name.ToUpper())).ToList();
  63. }
  64.  
  65. if (!string.IsNullOrEmpty(ControlData.card_number))
  66. {
  67. CCListFilter = CCListFilter.Where(x => x.card_number == ControlData.card_number).ToList();
  68. }
  69.  
  70. if ((ControlData.account_num != null))
  71. {
  72. CCListFilter = CCListFilter.Where(x => x.account_num == ControlData.account_num).ToList();
  73. }
  74. if (ControlData.filenumber != null)
  75. {
  76. CCListFilter = CCListFilter.Where(x => x.file_number == ControlData.filenumber).ToList();
  77. }
  78. if (ControlData.frauddate1 != DateTime.MinValue)
  79. {
  80. CCListFilter = CCListFilter.Where(x => x.fraud_date == ControlData.frauddate1).ToList();
  81. }
  82. if (ControlData.frauddate1 != DateTime.MinValue && ControlData.frauddate2 != DateTime.MinValue)
  83. {
  84. CCListFilter = CCListFilter.Where(x => x.fraud_date >= ControlData.frauddate1 && x.fraud_date <= ControlData.frauddate2).ToList();
  85. }
  86. ...i have more IF statementes here....
  87.  
  88. return CCListFilter;
  89. }
  90. }
  91. return cclisttop100;
  92. }
Add Comment
Please, Sign In to add comment