API tools faq
paste
Ranish666

account menu for new mediflow client

Ranish666
Mar 9th, 2021 (edited)
784
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 8.67 KB | None | 0 0
raw download clone embed print report
  1. delete from tblmenu where ParentID in (20,60)
  2. update tblmenu set hasSubMenu = 1 where intMenuid = 60
  3. go
  4. go
  5. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'A/C Ledger', N'', N'', 1, 20, 1, 0, N'/Account/AccountLedger/Index', 1, N'fas fa-file-invoice')
  6. GO
  7. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Journal Voucher', N'', N'', 1, 20, 1, 0, N'/Account/JournalVoucherSub/Index', 1, N'fas fa-file-invoice')
  8. GO
  9. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Payment Voucher', N'', N'', 1, 20, 1, 0, N'/Account/PaymentVoucher/Index', 1, N'fas fa-file-invoice')
  10. GO
  11. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Receipt Voucher', N'', N'', 1, 20, 1, 0, N'/Account/ReceiptVoucher/Index', 1, N'fas fa-file-invoice')
  12. GO
  13. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Contra Voucher', N'', N'', 1, 20, 1, 0, N'/Account/ContraVoucher/Index', 1, N'fas fa-file-invoice')
  14. GO
  15. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Materialized ', N'', N'', 1, 3096, 1, 0, N'/Log/MaterializedReport', 1, N'fas fa-layer-group')
  16. GO
  17. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Ledger Report', N'', N'', 1, 60, 1, 0, N'/Account/AcLedgerReport/Index', 1, N'fas fa-file-invoice')
  18. GO
  19. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Hospital Journal', N'', N'', 1, 20, 1, 0, N'/Account/HJournal/Index', 1, N'fas fa-file-invoice')
  20. GO
  21. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Aging Report', N'', N'', 1, 60, 1, 0, N'/Account/AgingReport/Index', 1, N'fas fa-file-invoice')
  22. GO
  23. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Bank Cash Book', N'', N'', 1, 60, 1, 0, N'/Budget/BankCashBook/Index', 1, N'fas fa-file-invoice')
  24. GO
  25. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Budget Baadhphaad', N'', N'', 1, 60, 1, 0, N'/Budget/BudgetBaadhphaad/Index', 1, N'fas fa-file-invoice')
  26. GO
  27. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Journal Register', N'', N'', 1, 60, 1, 0, N'/Account/JournalReport/Index', 1, N'fas fa-file-invoice')
  28. GO
  29. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Payment Register', N'', N'', 1, 60, 1, 0, N'/Account/PaymentReport/Index', 1, N'fas fa-file-invoice')
  30. GO
  31. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Contra Register', N'', N'', 1, 60, 1, 0, N'/Account/ContraReport/Index', 1, N'fas fa-file-invoice')
  32. GO
  33. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Receipt Register', N'', N'', 1, 60, 1, 0, N'/Account/ReceiptReport/Index', 1, N'fas fa-file-invoice')
  34. GO
  35. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Balance Sheet', N'', N'', 1, 60, 1, 0, N'/Account/BalanceSheet/Index', 1, N'fas fa-file-invoice')
  36. GO
  37. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Trial Balance', N'', N'', 1, 60, 1, 0, N'/Account/TrialBalance/Index', 1, N'fas fa-file-invoice')
  38. GO
  39. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Bank Reconciliation', N'', N'', 1, 20, 1, 0, N'/Account/BankReconciliation/Index', 1, N'fas fa-file-invoice')
  40. GO
  41. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Cash Flow', N'', N'', 1, 60, 1, 0, N'/Account/CashFlow/Index', 1, N'fas fa-file-invoice')
  42. GO
  43. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES (N'Debit Credit Note', N'', N'', 1, 20, 1, 0, N'/Account/DebitCreditNote/Index', 1, N'fas fa-file-invoice')
  44. GO
  45. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Debit Credit Note Report', N'', N'', 1, 60, 1, 0, N'/Account/DebitCreditNote/Report', 1, N'fas fa-file-invoice')
  46. GO
  47. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Journal Voucher Sub', N'', N'', 1, 20, 1, 0, N'/Account/JournalVoucherSub/Index', 1, N'fas fa-file-invoice')
  48. GO
  49. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'PDC', N'', N'', 1, 20, 1, 0, N'/Account/PDC/Index', 1, N'fas fa-file-invoice')
  50. GO
  51. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'PDC Clearance', N'', N'', 1, 20, 1, 0, N'/Account/PDC/PDCClearance', 1, N'fas fa-file-invoice')
  52. GO
  53. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'PDC Report', N'', N'', 1, 60, 1, 0, N'/Account/PDCReport/Index', 1, N'fas fa-file-invoice')
  54. GO
  55. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'PDC Clearance Report', N'', N'', 1, 60, 1, 0, N'/Account/PDCReport/PDCClearanceReport', 1, N'fas fa-file-invoice')
  56. GO
  57. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Profit & Loss', N'', N'', 1, 60, 1, 0, N'/Account/ProfitAndLoss/Index', 1, N'fas fa-file-invoice')
  58. GO
  59. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Budget Type', N'', N'', 1, 20, 1, 0, N'/Budget/BudgetType/Index', 1, N'fas fa-file-invoice')
  60. GO
  61. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Budget Category', N'', N'', 1, 20, 1, 0, N'/Budget/BudgetCategory/Index', 1, N'fas fa-file-invoice')
  62. GO
  63. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Budget Title', N'', N'', 1, 20, 1, 0, N'/Budget/BudgetTitle/Index', 1, N'fas fa-file-invoice')
  64. GO
  65. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Budget Khata Report', N'', N'', 1, 60, 1, 0, N'/Budget/BudgetKhataReport/Index', 1, N'fas fa-file-invoice')
  66. GO
  67. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Budget Transfer', N'', N'', 1, 20, 1, 0, N'/Budget/BudgetTransfer/Index', 1, N'fas fa-file-invoice')
  68. GO
  69.  
  70. INSERT [dbo].[tblmenu] ( [strName], [strFormName], [strShorCut], [isOpen], [ParentID], [isActive], [hasSubMenu], [WebUrl], [IsActiveWeb], [Menuicon]) VALUES ( N'Day Book', N'', N'', 1, 60, 1, 0, N'/Account/DayBook/Index', 1, N'fas fa-file-invoice')
  71. GO
  72.  
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!