�����JFIF��XX����������    $.' ",#(7),01444'9=82<.342  2!!22222222222222222222222222222222222222222222222222�����"����4���������������������������� ���������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������,�PG"Z_�4�˷����kjز�Z�,F+��_z�,�© �����zh6�٨�ic�fu������������������������������������#ډb���_�N��?�����������wQ���5-�~�I���8���������������������������������TK<5o�Iv-������������������k�_U_������������������������������~b�M��d��������Ӝ�U�Hh��?]��E�w��Q���k�{��_}qFW7HTՑ��Y��F�����?_�'ϔ��_�Ջt������������������������=||I �����6�έ"�����D���/[�k�9����Y�8������ds|\���Ҿp6�Ҵ���]��.����6���z<�v��@]�i%������������������������$j��~����g��J>��no����pM[me�i$[�����������s�o�ᘨ�˸ nɜG-�ĨU�ycP���3.DB�li�;���������������������hj���x����7Z^�N�h��������N3u{�:j�����x�힞��#M��&��jL P@��_���� P�������������������&��o8��������9������@Sz���6�t7#O�ߋ �����s}Yf�T������lmr����Z)'N��k�۞p�����w\�T���������������ȯ?�8`���O��i{wﭹW�[�r�� ��Q4F�׊������3m&L�=��h3�������z~��#����\�l :�F,j@�� ʱ�wQT����8�"kJO����6�֚l������������������}����R�>ډK���]��y����&����p�}b������;N�1�m�r$����|��7�>e�@���B�TM*-i�H��g�D�)� E�m�|�ؘbҗ�a���Ҿ����������������t4�����o���G��*oCN�rP���Q��@z,|?W[0���������:�n,j���WiE��W������$~/�hp\��?��{(�0���+�Y8rΟ�+����>S-S���������������VN;���}�s?.����� w��9��˟<���Mq4�Wv'������{)0�1mB����V����W[��������8�/<� �%���wT^�5���b��)iM� p�g�N�&ݝ������������VO~��q���u���9��� ����!��J27�����$����O-���! �:���%H��� ـ�������y�ΠM=t{!S�� �oK8�������t<����è��������:a��������[������ա�H���~��w��Qz`�p����o�^ ������Q��n����� �,uu�C��$ ^���,�������8�#��:�6��e�|~�����������!�3��3.�\0�����q��o�4`.|� ����y�Q�`~;�d�ׯ,��O�Zw�������`73�v�܋�<�����Ȏ�� ـ4k��5�K�a�u�=9Yd��$>x�A�&�� j0� ���vF��� Y���|�y��� ~�6�@c��1vOp��������Ig�����4��l�OD�����L����� R���c���j�_�uX�6��3?nk��Wy�f;^*B� ��@���~a�`��Eu�������+�����6�L��.ü>��}y���}_�O�6�͐�:�Yr���G�X��kG������l^w����������~㒶sy���Iu�!���� W ��X��N�7BV��O��!X�2����wvG�R�f�T#�����t�/?���%8�^�W�aT����G�cL�M���I��(J����1~�8�?aT ���]����AS�E��(��*E}� 2������#I/�׍qz��^t�̔���������b�Yz4x����t�){ OH�����+(E��A&�N�������XT��o��"�XC����'���)}�J�z�p� ����~5�}�^����+�6����w��c��Q�|�Lp�d�H��}�(�.|����k��c4^�����"�����Z?ȕ ��a<�������L�!0�39C� �Eu�����C�F�Ew�ç ;�n?�*o���B�8�bʝ���'#Rqf����M}7����]�������s2tcS{�\icTx;�\��7K���P������ʇ Z O-��~�������c>"��?��������P�����E��O�8��@�8��G��Q�g�a�Վ���󁶠��䧘��_%#r�>�����1�z�a���eb��qcP��ѵ��n���#L��� =��׀t� L�7�`�����V����A{�C:�g���e@�����w1 Xp�3�c3�ġ�������p��M"'-�@n4���fG���B3�DJ�8[Jo�ߐ���gK)ƛ��$���� �������8�3�����+���� �����6�ʻ���� ���S�kI�*KZlT _`�������?��K�����QK�d���������B`�s}�>���`������*�>��,*@J�d�oF*�����弝��O}�k��s��]��y�ߘ�������c1G�V���<=�7��7����6��q�PT��tXԀ�!9*4�4Tހ���3XΛex�46�������Y��D ����� ����BdemDa����\�_l,����G�/���֌7���Y�](�xTt^%�GE�����4�}bT����ڹ�����;��Y)���B�Q��u��>J/J ���⮶.�XԄ��j�ݳ������+E��d ���r�5�_D�����1 ���o�� �B�x�΢�#����<��W�����8���R6�@���g�M�.��� dr�D��>(otU��@�x=��~v���2� ӣ�d�oBd�����3�eO�6�㣷����������ݜ�6��6Y��Qz`����S��{���\P��~z m5{J/L��1������<�e�ͅPu���b�]�ϔ��������'�������f�b� Zpw��c`"��i���BD@:)ִ�:�]��h���v�E��w���T�l�������P����"Ju�}��وV ��J��G6��. J/�Qgl߭�e�����@�z�Zev2u����)]կ���������7x�������s�M�-<ɯ�c��r��v�����@��$�ޮ}lk���a����'����>x��O\�Z������Fu>������ck#��&:��`�$��ai�>2Δ����l���oF[h�������lE�ܺ�Π���k:)���`������� $[6�����9�����kOw�\|�����8}������ބ:��񶐕��������I�A1/���=�2[�,�!��.}gN#�u����b���� ~���������݊��}34q�����d�E��L��������c��$���"�[q�U�硬g^��%B ��z���r�p�������J�ru%v\h�����1Y�ne`������ǥ:g����pQM~�^��Xi� ��`S�:V2������9.�P���V������?B�k�� ��������AEvw%�_�9C�Q����wKekP�ؠ�\������;Io d�{ ߞo�c1eP�����\� `����E=���@K<�Y��������eڼ�J����w����{av�F�'�M�@��������������/J��+9p����|]���������Iw &`���8���&�M�hg���[�{�������Xj���%��Ӓ�������������������$��(�����ʹN�������<>�I���RY�����K2�NPlL�ɀ�)��&e��������B+ь����(������������������� � �JTx����_?EZ� }@���� 6�U���뙢ط�z��dWI��n` D����噥�[��uV��"�G&�����Ú����2�g�}&m���������������������?ċ���"����Om#�������������������������� ��{���������������������ON��"S�X���Ne��ysQ���@�������������Fn��Vg�����dX�~nj����������������������]J�<�K]:����FW���b�������62����������=��5f����JKw����bf�X������������������������55��~J �%^�������:�-�QIE��P��v�nZum� z � ~ə ���� ���ة����;�f��\v�������g�8�1��f2�������������������������4;�V���ǔ�)�������������������9���1\������������������������������c��v�/'Ƞ�w������������������$�4�R-��t����������������������������������� e�6�/�ġ �̕Ecy�J���u�B���<�W�ַ~�w[B1L۲�-JS΂�{���΃�������������������������������������������A��20�c#���������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������@���� 0!1@AP"#2Q`$3V�%45a6�FRUq����� ������^7ׅ,$n��������+��F�`��2X'��0vM��p�L=�������5��8������u�p~���.�`r�����\����O��,ư�0oS ��_�M�����l���4�kv\JSd���x���SW�<��Ae�IX����������$I���w�:S���y���›R��9�Q[���,�5�;�@]�%���u�@ *ro�lbI �� ��+���%m:�͇ZV�����u�̉����θau<�fc�.����{�4Ա� �Q����*�Sm��8\ujqs]{kN���)qO�y�_*dJ�b�7���yQqI&9�ԌK!�M}�R�;�������S�T���1���i[U�ɵz�]��U)V�S6���3$K{��ߊ<�(� E]Զ[ǼENg�����'�\?#)Dkf��J���o��v���'�%ƞ�&K�u��!��b�35LX�Ϸ��63$K�a�;�9>,R��W��3�3� d�JeTYE.Mϧ��-�o�j3+y��y^�c�������VO�9NV\nd�1 ��!͕_)a�v;����թ�M�lWR1��)El��P;��yوÏ�u 3�k�5Pr6<�⒲l�!˞*��u־�n�!�l:����UNW ��%��Chx8vL'��X�@��*��)���̮��ˍ��� ����D-M�+J�U�kvK����+�x8��cY������?�Ԡ��~3mo��|�u@[XeY�C�\Kp�x8�oC�C�&����N�~3-H���� ��MX�s�u<`���~"WL��$8ξ��3���a�)|:@�m�\���^�`�@ҷ)�5p+��6���p�%i)P M���ngc�����#0Aruz���RL+xSS?���ʮ}()#�t��mˇ!��0}}y����<�e� �-ή�Ԩ��X������ MF���ԙ~l L.3���}�V뽺�v������멬��Nl�)�2����^�Iq��a��M��qG��T�����c3#������3U�Ǎ���}��לS�|qa��ڃ�+���-��2�f����/��bz��ڐ�� �ݼ[2�ç����k�X�2�* �Z�d���J�G����M*9W���s{��w���T��x��y,�in�O�v��]���n����P�$��JB@=4�OTI�n��e�22a\����q�d���%�$��(���:���: /*�K[PR�fr\nڙdN���F�n�$�4��[�� U�zƶ����� �mʋ���,�ao�u 3�z� �x��Kn����\[��VFmbE;�_U��&V�Gg�]L�۪&#n%�$ɯ��dG���D�TI=�%+AB�Ru#��b4�1�»x�cs�YzڙJG��f��Il���d�eF'T� iA��T���uC�$����Y��H?����[!G`}���ͪ� �纤Hv\������j�Ex�K���!���OiƸ�Yj�+u-<���'q����uN�*�r\��+�]���<�wOZ.fp�ێ��,-*)V?j-kÊ#�`�r��dV����(�ݽBk�����G�ƛk�QmUڗe��Z���f}|����8�8��a���i��3'J�����~G_�^���d�8w������ R�`(�~�.��u���l�s+g�bv���W���lGc}��u���afE~1�Ue������Z�0�8�=e�� f@/�jqEKQQ�J���oN��J���W5~M>$6�Lt�;$ʳ{���^��6�{����v6���ķܰg�V�cnn �~z�x�«�,2�u�?cE+Ș�H؎�%�Za�)���X>uW�Tz�Nyo����s���FQƤ��$��*�&�LLXL)�1�" L��eO��ɟ�9=���:t��Z���c��Ž���Y?�ӭV�wv�~,Y��r�ۗ�|�y��GaF�����C�����.�+� ���v1���fήJ�����]�S��T��B��n5sW}y�$��~z�'�c ��8 ��� ,! �p��VN�S��N�N�q��y8z˱�A��4��*��'������2n<�s���^ǧ˭P�Jޮɏ�U�G�L�J�*#��<�V��t7�8����TĜ>��i}K%,���)[��z�21z ?�N�i�n1?T�I�R#��m-�����������������1����lA�`��fT5+��ܐ�c�q՝��ʐ��,���3�f2U�եmab��#ŠdQ�y>\��)�SLY����w#��.���ʑ�f��� ,"+�w�~�N�'�c�O�3F�������N<���)j��&��,-� �љ���֊�_�zS���TǦ����w�>��?�������n��U仆�V���e�����0���$�C�d���rP �m�׈e�Xm�Vu� �L��.�bֹ��� �[Դaզ���*��\y�8�Է:�Ez\�0�Kq�C b��̘��cө���Q��=0Y��s�N��S.����3.���O�o:���#���v7�[#߫ ��5�܎�L���Er4���9n��COWlG�^��0k�%<���ZB���aB_���������'=��{i�v�l�$�uC���mƎҝ{�c㱼�y]���W�i ��ߧc��m�H� m�"�"�����;Y�ߝ�Z�Ǔ�����:S#��|}�y�,/k�Ld� TA�(�AI$+I3��;Y*���Z��}|��ӧO��d�v��..#:n��f>�>���ȶI�TX��� 8��y����"d�R�|�)0���=���n4��6ⲑ�+��r<�O�܂~zh�z����7ܓ�HH�Ga롏���nCo�>������a ���~]���R���̲c?�6(�q�;5%� |�uj�~z8R�=X��I�V=�|{v�Gj\gc��q����z�؋%M�ߍ����1y��#��@f^���^�>N������#x#۹��6�Y~�?�dfPO��{��P�4��V��u1E1J �*|���%����JN��`eWu�zk M6���q t[�� ��g�G���v��WIG��u_ft����5�j�"�Y�:T��ɐ���*�;� e5���4����q$C��2d�}���� _S�L#m�Yp��O�.�C�;��c����Hi#֩%+) �Ӎ��ƲV���SYź��g |���tj��3�8���r|���V��1#;.SQ�A[���S������#���`n�+���$��$�I �P\[�@�s��(�ED�z���P��])8�G#��0B��[ى��X�II�q<��9�~[Z멜�Z�⊔IWU&A>�P~�#��dp<�?����7���c��'~���5 ��+$���lx@�M�dm��n<=e�dyX��?{�|Aef ,|n3�<~z�ƃ�uۧ�����P��Y,�ӥQ�*g�#먙R�\���;T��i,��[9Qi歉����c>]9�� ��"�c��P�� �Md?٥��If�ت�u��k��/����F��9�c*9��Ǎ:�ØF���z�n*�@|I�ށ9����N3{'��[�'ͬ�Ҳ4��#}��!�V� Fu��,�,mTIk���v C�7v���B�6k�T9��1�*l� '~��ƞF��lU��'�M ����][ΩũJ_�{�i�I�n��$����L�� j��O�dx�����kza۪��#�E��Cl����x˘�o�����V���ɞ�ljr��)�/,�߬h�L��#��^��L�ф�,íMƁe�̩�NB�L�����iL����q�}��(��q��6IçJ$�W�E$��:������=#����(�K�B����zђ <��K(�N�۫K�w��^O{!����)��H���>x�������lx�?>Պ�+�>�W���,Ly!_�D���Ō�l���Q�!�[ �S����J��1��Ɛ�Y}��b,+�Lo�x�ɓ)����=�y�oh�@�꥟/��I��ѭ=��P�y9��� �ۍYӘ�e+�p�Jnϱ?V\SO%�(�t� ���=?MR�[Ș�����d�/ ��n�l��B�7j� ��!�;ӥ�/�[-���A�>��dN�sLj ��,ɪv��=1c�.SQ�O3�U���ƀ�ܽ�E����������̻��9G�ϷD�7(�}��Ävӌ\��y�_0[w ���<΍>����a_��[0+�L��F.�޺��f�>oN�T����q;���y\��bՃ��y�jH�<|q-eɏ�_?_9+P���Hp$�����[ux�K w�Mw��N�ی'$Y2�=��q���KB��P��~�������Yul:�[<����F1�2�O���5=d����]Y�sw:���Ϯ���E��j,_Q��X��z`H1,#II ��d�wr��P˂@�ZJV����y$�\y�{}��^~���[:N����ߌ�U�������O��d�����ؾe��${p>G��3c���Ė�lʌ�� ת��[��`ϱ�-W����dg�I��ig2��� ��}s ��ؤ(%#sS@���~���3�X�nRG�~\jc3�v��ӍL��M[JB�T��s3}��j�Nʖ��W����;7���ç?=X�F=-�=����q�ߚ���#���='�c��7���ڑW�I(O+=:uxq�������������e2�zi+�kuG�R��������0�&e�n���iT^J����~\jy���p'dtG��s����O��3����9* �b#Ɋ�� p������[Bws�T�>d4�ۧs���nv�n���U���_�~,�v����ƜJ1��s�� �QIz���)�(lv8M���U=�;����56��G���s#�K���MP�=��LvyGd��}�VwWBF�'�à �?MH�U�g2�� ����!�p�7Q��j��ڴ����=��j�u��� Jn�A s���uM������e��Ɔ�Ҕ�!)�'��8Ϣ�ٔ���ޝ(��Vp���צ֖d=�IC�J�Ǡ{q������kԭ�߸���i��@K����u�|�p=..�*+����x�����z[Aqġ#s2a�Ɗ���RR�)*HRsi�~�a &f��M��P����-K�L@��Z��Xy�'x�{}��Zm+���:�)�) IJ�-i�u���� ���ܒH��'��L(7�y�GӜq���� j��� 6ߌg1�g�o���,kر���tY�?W,���p���e���f�OQS��!K�۟cҒA�|ս�j�>��=⬒��˧L[�� �߿2JaB~R��u�:��Q�] �0H~���]�7��Ƽ�I���(�}��cq '�ήET���q�?f�ab���ӥvr� �)o��-Q��_'����ᴎo��K������;��V���o��%���~OK ����*��b�f:���-ťIR��`B�5!RB@���ï�� �u �̯e\�_U�_������� g�ES��3��������QT��a�����x����U<~�c?�*�#]�MW,[8O�a�x��]�1bC|踤�P��lw5V%�)�{t�<��d��5���0i�XSU��m:��Z�┵�i�"��1�^B�-��P�hJ��&)O��*�D��c�W��vM��)����}���P��ܗ-q����\mmζZ-l@�}��a��E�6��F�@��&Sg@���ݚ�M����� ȹ 4����#p�\H����dYDo�H���"��\��..R�B�H�z_�/5˘����6��KhJR��P�mƶi�m���3��,#c�co��q�a)*P�t����R�m�k�7x�D�E�\Y�閣_X�<���~�)���c[[�BP����6�Yq���S��0����%_����;��Àv�~�| VS؇ ��'O0��F0��\���U�-�d@�����7�SJ*z��3n��y��P����O����������m�~�P�3|Y��ʉr#�C�<�G~�.,! ���bqx���h~0=��!ǫ�jy����l��O,�[B��~��|9��ٱ����Xly�#�i�B��g%�S��������tˋ���e���ې��\[d�t)��.+u�|1 ������#�~Oj����hS�%��i.�~X���I�H�m��0n���c�1uE�q��cF�RF�o���7� �O�ꮧ� ���ۛ{��ʛi5�rw?׌#Qn�TW��~?y$��m\�\o����%W� ?=>S�N@�� �Ʈ���R����N�)�r"C�:��:����� �����#��qb��Y�. �6[��2K����2u�Ǧ�HYR��Q�MV��� �G�$��Q+.>�����nNH��q�^��� ����q��mM��V��D�+�-�#*�U�̒ ���p욳��u:�������IB���m����PV@O���r[b= �� ��1U�E��_Nm�yKbN�O���U�}�the�`�|6֮P>�\2�P�V���I�D�i�P�O;�9�r�mAHG�W�S]��J*�_�G��+kP�2����Ka�Z���H�'K�x�W�MZ%�O�YD�Rc+o��?�q��Ghm��d�S�oh�\�D�|:W������UA�Qc yT�q��������~^�H��/��#p�CZ���T�I�1�ӏT����4��"�ČZ�����}��`w�#�*,ʹ�� ��0�i��課�Om�*�da��^gJ݅{���l�e9uF#T�ֲ��̲�ٞC"�q���ߍ ոޑ�o#�XZTp����@ o�8��(jd��xw�]�,f���`~��|,s��^����f�1���t��|��m�򸄭/ctr��5s��7�9Q�4�H1꠲BB@�l9@���C�����+�wp�xu�£Yc�9��?`@#�o�mH�s2��)�=��2�.�l����jg�9$�Y�S�%*L������R�Y������7Z���,*=�䷘$�������arm�o�ϰ���UW.|�r�uf����IGw�t����Zwo��~5 ��YյhO+=8fF�)�W�7�L9lM�̘·Y���֘YLf�큹�pRF���99.A �"wz��=E\Z���'a� 2��Ǚ�#;�'}�G���*��l��^"q��+2FQ� hj��kŦ��${���ޮ-�T�٭cf�|�3#~�RJ����t��$b�(R��(����r���dx� >U b�&9,>���%E\� Ά�e�$��'�q't��*�א���ެ�b��-|d���SB�O�O��$�R+�H�)�܎�K��1m`;�J�2�Y~9��O�g8=vqD`K[�F)k�[���1m޼c��n���]s�k�z$@��)!I �x՝"v��9=�ZA=`Ɠi �:�E��)`�7��vI��}d�YI�_ �o�:ob���o ���3Q��&D&�2=�� �Ά��;>�h����y.*ⅥS������Ӭ�+q&����j|UƧ�����}���J0��WW< ۋS�)jQR�j���Ư��rN)�Gű�4Ѷ(�S)Ǣ�8��i��W52���No˓� ۍ%�5brOn�L�;�n��\G����=�^U�dI���8$�&���h��'���+�(������cȁ߫k�l��S^���cƗjԌE�ꭔ��gF���Ȓ��@���}O���*;e�v�WV���YJ\�]X'5��ղ�k�F��b 6R�o՜m��i N�i�����>J����?��lPm�U��}>_Z&�KK��q�r��I�D�Չ~�q�3fL�:S�e>���E���-G���{L�6p�e,8��������QI��h��a�Xa��U�A'���ʂ���s�+טIjP�-��y�8ۈZ?J$��W�P� ��R�s�]��|�l(�ԓ��sƊi��o(��S0���Y� 8�T97.�����WiL��c�~�dxc�E|�2!�X�K�Ƙਫ਼�$((�6�~|d9u+�qd�^3�89��Y�6L�.I�����?���iI�q���9�)O/뚅����O���X��X�V��ZF[�یgQ�L��K1���RҖr@v�#��X�l��F���Нy�S�8�7�kF!A��sM���^rkp�jP�DyS$N���q���nxҍ!U�f�!eh�i�2�m����`�Y�I�9r�6� �TF���C}/�y�^���Η���5d�'��9A-��J��>{�_l+�`��A���[�'��յ�ϛ#w:݅�%��X�}�&�PSt�Q�"�-��\縵�/����$Ɨh�Xb�*�y��BS����;W�ջ_mc�����vt?2}1�;qS�d�d~u:2k5�2�R�~�z+|HE!)�Ǟl��7`��0�<�,�2*���Hl-��x�^����'_TV�gZA�'j� ^�2Ϊ��N7t�����?w�� �x1��f��Iz�C-Ȗ��K�^q�;���-W�DvT�7��8�Z�������� hK�(P:��Q- �8�n�Z���܃e貾�<�1�YT<�,�����"�6{�/ �?�͟��|1�:�#g��W�>$����d��J��d�B���=��jf[��%rE^��il:��B���x���Sּ�1հ��,�=��*�7 fcG��#q� �eh?��2�7�����,�!7x��6�n�LC�4x��},Geǝ�tC.��vS �F�43��zz\��;QYC,6����~;RYS/6���|2���5���v��T��i����������mlv��������&� �nRh^ejR�LG�f���? �ۉҬܦƩ��|��Ȱ����>3����!v��i�ʯ�>�v��オ�X3e���_1z�Kȗ\<������!�8���V��]��?b�k41�Re��T�q��mz��TiOʦ�Z��Xq���L������q"+���2ۨ��8}�&N7XU7Ap�d�X��~�׿��&4e�o�F��� �H�����O���č�c�� 懴�6���͉��+)��v;j��ݷ�� �UV�� i��� j���Y9GdÒJ1��詞�����V?h��l�����l�cGs�ځ�������y�Ac������\V3�? �� ܙg�>qH�S,�E�W�[�㺨�uch�⍸�O�}���a��>�q�6�n6�����N6�q��������N� ���! 1AQaq�0@����"2BRb�#Pr���3C`��Scst���$4D���%Td���� ?�����N����a��3��m���C���w��������xA�m�q�m����m������$����4n淿t'��C"w��zU=D�\R+w�p+Y�T�&�պ@��ƃ��3ޯ?�Aﶂ��aŘ���@-�����Q�=���9D��ռ�ѻ@��M�V��P��܅�G5�f�Y<�u=,EC)�<�Fy'�"�&�չ�X~f��l�KԆV��?�� �W�N����=(� �;���{�r����ٌ�Y���h{�١������jW����P���Tc�����X�K�r��}���w�R��%��?���E��m�� �Y�q|����\lEE4����r���}�lsI�Y������f�$�=�d�yO����p�����yBj8jU�o�/�S��?�U��*������ˍ�0�������u�q�m [�?f����a�� )Q�>����6#������� ?����0UQ����,IX���(6ڵ[�DI�MNލ�c&���υ�j\��X�R|,4��� j������T�hA�e��^���d���b<����n�� �즇�=!���3�^�`j�h�ȓr��jẕ�c�,ٞX����-����a�ﶔ���#�$��]w�O��Ӫ�1y%��L�Y<�wg#�ǝ�̗`�x�xa�t�w��»1���o7o5��>�m뭛C���Uƃߜ}�C���y1Xνm�F8�jI���]����H���ۺиE@I�i;r�8ӭ�����V�F�Շ| ��&?�3|x�B�MuS�Ge�=Ӕ�#BE5G������Y!z��_e��q�р/W>|-�Ci߇�t�1ޯќd�R3�u��g�=0 5��[?�#͏��q�cf���H��{ ?u�=?�?ǯ���}Z��z���hmΔ�BFTW�����<�q��(v� ��!��z���iW]*�J�V�z��gX֧A�q�&��/w���u�gYӘa���; �i=����g:��?2�dž6�ى�k�4�>�Pxs����}������G�9���3 ���)gG�R<>r h�$��'nc�h�P��Bj��J�ҧH� -��N1���N��?��~��}-q!=��_2hc�M��l�vY%UE�@|�v����M2�.Y[|y�"Eï��K�ZF,�ɯ?,q�?v�M 80jx�"�;�9vk�����+ ֧�� �ȺU��?�%�vcV��mA�6��Qg^M�����A}�3�nl� QRN�l8�kkn�'�����(��M�7m9و�q���%ޟ���*h$Zk"��$�9��: �?U8�Sl��,,|ɒ��xH(ѷ����Gn�/Q�4�P��G�%��Ա8�N��!� �&�7�;���eKM7�4��9R/%����l�c>�x;������>��C�:�����t��h?aKX�bhe�ᜋ^�$�Iհ �hr7%F$�E��Fd���t��5���+�(M6�t����Ü�UU|zW�=a�Ts�Tg������dqP�Q����b'�m���1{|Y����X�N��b �P~��F^F:����k6�"�j!�� �I�r�`��1&�-$�Bevk:y���#y�w��I0��x��=D�4��tU���P�ZH��ڠ底taP��6����b>�xa�����Q�#� WeF��ŮNj�p�J* mQ�N�����*I�-*�ȩ�F�g�3 �5��V�ʊ�ɮ�a��5F���O@{���NX��?����H�]3��1�Ri_u��������ѕ�� ����0��� F��~��:60�p�͈�S��qX#a�5>���`�o&+�<2�D����: �������ڝ�$�nP���*)�N�|y�Ej�F�5ټ�e���ihy�Z �>���k�bH�a�v��h�-#���!�Po=@k̆IEN��@��}Ll?j�O������߭�ʞ���Q|A07x���wt!xf���I2?Z��<ץ�T���cU�j��]���陎Ltl �}5�ϓ��$�,��O�mˊ�;�@O��jE��j(�ا,��LX���LO���Ц�90�O �.����a��nA���7������j4 ��W��_ٓ���zW�jcB������y՗+EM�)d���N�g6�y1_x��p�$Lv�:��9�"z��p���ʙ$��^��JԼ*�ϭ����o���=x�Lj�6�J��u82�A�H�3$�ٕ@�=Vv�]�'�qEz�;I˼��)��=��ɯ���x �/�W(V���p�����$ �m�������u�����񶤑Oqˎ�T����r��㠚x�sr�GC��byp�G��1ߠ�w e�8�$⿄����/�M{*}��W�]˷.�CK\�ުx���/$�WP�w���r� |i���&�}�{�X� �>��$-��l���?-z���g����lΆ���(F���h�vS*���b���߲ڡn,|)mrH[���a�3�ר�[1��3o_�U�3�TC�$��(�=�)0�kgP���� ��u�^=��4 �WYCҸ:��vQ�ר�X�à��tk�m,�t*��^�,�}D*�� �"(�I��9R����>`�`��[~Q]�#af��i6l��8���6�:,s�s�N6�j"�A4���IuQ��6E,�GnH��zS�HO�uk�5$�I�4��ؤ�Q9�@��C����wp��BGv[]�u�Ov����0I4���\��y�����Q�Ѹ��~>Z��8�T��a��q�ޣ;z��a���/��S��I:�ܫ_�|������>=Z����8:�S��U�I�J��"IY���8%b8���H��:�QO�6�;7�I�S��J��ҌAά3��>c���E+&jf$eC+�z�;��V����� �r���ʺ������my�e���aQ�f&��6�ND���.:��NT�vm�<- u���ǝ\MvZY�N�NT��-A�>jr!S��n�O 1�3�Ns�%�3D@���`������ܟ 1�^c<���� �a�ɽ�̲�Xë#�w�|y�cW�=�9I*H8�p�^(4���՗�k��arOcW�tO�\�ƍR��8����'�K���I�Q�����?5�>[�}��yU�ײ -h��=��% q�ThG�2�)���"ו3]�!kB��*p�FDl�A���,�eEi�H�f�Ps�����5�H:�Փ~�H�0Dت�D�I����h�F3�������c��2���E��9�H��5�zԑ�ʚ�i�X�=:m�xg�hd(�v����׊�9iS��O��d@0ڽ���:�p�5�h-��t�&���X�q�ӕ,��ie�|���7A�2���O%P��E��htj��Y1��w�Ѓ!����  ���� ࢽ��My�7�\�a�@�ţ�J ��4�Ȼ�F�@o�̒?4�wx��)��]�P��~�����u�����5�����7X ��9��^ܩ�U;Iꭆ 5 �������eK2�7(�{|��Y׎ �V��\"���Z�1� Z�����}��(�Ǝ"�1S���_�vE30>���p;� ΝD��%x�W�?W?v����o�^V�i�d��r[��/&>�~`�9Wh��y�;���R���� ;;ɮT��?����r$�g1�K����A��C��c��K��l:�'��3 c�ﳯ*"t8�~l��)���m��+U,z��`(��>yJ�?����h>��]��v��ЍG*�{`��;y]��I�T� ;c��NU�fo¾h���/$���|NS���1�S�"�H��V���T���4��uhǜ�]�v;���5�͠x��'C\�SBpl���h}�N����� A�Bx���%��ޭ�l��/����T��w�ʽ]D�=����K���ž�r㻠l4�S�O?=�k �M:� ��c�C�a�#ha���)�ѐxc�s���gP�iG���{+���x���Q���I= �� z��ԫ+ �8"�k�ñ�j=|����c ��y��CF��/���*9ж�h{ �?4�o� ��k�m�Q�N�x��;�Y��4膚�a�w?�6�>�e]�����Q�r�:����g�,i"�����ԩA��*M�<�G��b�if��l^M��5�� �Ҩ�{����6J��ZJ�����P�*�����Y���ݛu�_4�9�I8�7���������,^ToR���m4�H��?�N�S�ѕw��/S��甍�@�9H�S�T��t�ƻ���ʒU��*{Xs�@����f������֒Li�K{H�w^���������Ϥm�tq���s� ���ք��f:��o~s��g�r��ט� �S�ѱC�e]�x���a��) ���(b-$(�j>�7q�B?ӕ�F��hV25r[7 Y� }L�R��}����*sg+��x�r�2�U=�*'WS��ZDW]�WǞ�<��叓���{�$�9Ou4��y�90-�1�'*D`�c�^o?(�9��u���ݐ��'PI&� f�Jݮ�������:wS����jfP1F:X �H�9dԯ����˝[�_54 �}*;@�ܨ�� ð�yn�T���?�ןd�#���4rG�ͨ��H�1�|-#���Mr�S3��G�3�����)�.᧏3v�z֑��r����$G"�`j �1t��x0<Ɔ�Wh6�y�6��,œ�Ga��gA����y��b��)���h�D��ß�_�m��ü �gG;��e�v��ݝ�nQ� ��C����-�*��o���y�a��M��I�>�<���]obD��"�:���G�A��-\%LT�8���c�)��+y76���o�Q�#*{�(F�⽕�y����=���rW�\p���۩�c���A���^e6��K������ʐ�cVf5$�'->���ՉN"���F�"�UQ@�f��Gb~��#�&�M=��8�ט�JNu9��D��[̤�s�o�~������� G��9T�tW^g5y$b��Y'��س�Ǵ�=��U-2 #�MC�t(�i� �lj�@Q 5�̣i�*�O����s�x�K�f��}\��M{E�V�{�υ��Ƈ�����);�H����I��fe�Lȣr�2��>��W��I�Ȃ6������i��k�� �5�YOxȺ����>��Y�f5'��|��H+��98pj�n�.O�y�������jY��~��i�w'������l�;�s�2��Y��:'lg�ꥴ)o#'Sa�a�K��Z� �m��}�`169�n���"���x��I ��*+� }F<��cГ���F�P�������ֹ*�PqX�x۩��,� ��N�� �4<-����%����:��7����W���u�`����� $�?�I��&����o��o��`v�>��P��"��l���4��5'�Z�gE���8���?��[�X�7(��.Q�-��*���ތL@̲����v��.5���[��=�t\+�CNܛ��,g�SQnH����}*F�G16���&:�t��4ُ"A��̣��$�b �|����#rs��a�����T�� ]�<�j��B�S�('$�ɻ� �wP;�/�n��?�ݜ��x�F��yUn�~mL*-�������Xf�wd^�a�}��f�,=t�׵i�.2/wpN�Ep8�OР���•��R�FJ� 55TZ��T �ɭ�<��]��/�0�r�@�f��V��V����Nz�G��^���7hZi����k��3�,kN�e|�vg�1{9]_i��X5y7� 8e]�U����'�-2,���e"����]ot�I��Y_��n�(JҼ��1�O ]bXc���Nu�No��pS���Q_���_�?i�~�x h5d'�(qw52] ��'ޤ�q��o1�R!���`ywy�A4u���h<קy���\[~�4�\ X�Wt/� 6�����n�F�a8��f���z �3$�t(���q��q�x��^�XWeN'p<-v�!�{�(>ӽDP7��ո0�y)�e$ٕv�Ih'Q�EA�m*�H��RI��=:��� ���4牢) �%_iN�ݧ�l]� �Nt���G��H�L��� ɱ�g<���1V�,�J~�ٹ�"K��Q�� 9�HS�9�?@��k����r�;we݁�]I�!{ �@�G�[�"��`���J:�n]�{�cA�E����V��ʆ���#��U9�6����j�#Y�m\��q�e4h�B�7��C�������d<�?J����1g:ٳ���=Y���D�p�ц� ׈ǔ��1�]26؜oS�'��9�V�FVu�P�h�9�xc�oq�X��p�o�5��Ա5$�9W�V(�[Ak�aY錎qf;�'�[�|���b�6�Ck��)��#a#a˙��8���=äh�4��2��C��4tm^ �n'c����]GQ$[Wҿ��i���vN�{Fu ��1�gx��1┷���N�m��{j-,��x�� Ūm�ЧS�[�s���Gna���䑴�� x�p 8<������97�Q���ϴ�v�aϚG��Rt�Һ׈�f^\r��WH�JU�7Z���y)�vg=����n��4�_)y��D'y�6�]�c�5̪��\� �PF�k����&�c;��cq�$~T�7j ���nç]�<�g ":�to�t}�159�<�/�8������m�b�K#g'I'.W������6��I/��>v��\�MN��g���m�A�yQL�4u�Lj�j9��#44�t��l^�}L����n��R��!��t��±]��r��h6ٍ>�yҏ�N��fU�� ���� Fm@�8}�/u��jb9������he:A�y�ծw��GpΧh�5����l}�3p468��)U��d��c����;Us/�֔�YX�1�O2��uq�s��`hwg�r~�{ R��mhN��؎*q 42�*th��>�#���E����#��Hv�O����q�}������6�e��\�,Wk�#���X��b>��p}�դ��3���T5��†��6��[��@��P�y*n��|'f�֧>�lư΂�̺����SU�'*�q�p�_S�����M�� '��c�6������m�� ySʨ;M��r���Ƌ�m�Kxo,���Gm�P��A�G�:��i��w�9�}M(�^�V��$ǒ�ѽ�9���|���� �a����J�SQ�a���r�B;����}���ٻ֢�2�%U���c�#�g���N�a�ݕ�'�v�[�OY'��3L�3�;,p�]@�S��{ls��X�'���c�jw��k'a�.��}�}&�� �dP�*�bK=ɍ!����;3n�gΊU�ߴmt�'*{,=SzfD� A��ko~�G�aoq�_mi}#�m�������P�Xhύ�����mxǍ�΂���巿zf��Q���c���|kc�����?���W��Y�$���_Lv����l߶��c���`?����l�j�ݲˏ!V��6����U�Ђ(A���4y)H���p�Z_�x��>���e���R��$�/�`^'3qˏ�-&Q�=?��CFVR �D�fV�9��{�8g�������n�h�(P"��6�[�D���< E�����~0<@�`�G�6����Hг�cc�� �c�K.5��D��d�B���`?�XQ��2��ٿyqo&+�1^� DW�0�ꊩ���G�#��Q�nL3��c���������/��x ��1�1�[y�x�პCW��C�c�UĨ80�m�e�4.{�m��u���I=��f�����0QRls9���f���������9���~f�����Ǩ��a�"@�8���ȁ�Q����#c�ic������G��$���G���r/$W�(��W���V�"��m�7�[m�A�m����bo��D� j����۳� l���^�k�h׽����� ��#� iXn�v��eT�k�a�^Y�4�BN���ĕ���0������� !01@Q"2AaPq3BR�������?�����@4�Q�����T3,���㺠�W�[=JK�Ϟ���2�r^7��vc�:�9 �E�ߴ�w�S#d���Ix��u��:��Hp��9E!�� V 2;73|F��9Y���*ʬ�F��D����u&���y؟��^EA��A��(ɩ���^��GV:ݜDy�`��Jr29ܾ�㝉��[���E;Fzx��YG��U�e�Y�C���� ����v-tx����I�sם�Ę�q��Eb�+P\ :>�i�C'�;�����k|z�رn�y]�#ǿb��Q��������w�����(�r|ӹs��[�D��2v-%��@;�8<a���[\o[ϧw��I!��*0�krs)�[�J9^��ʜ��p1)� "��/_>��o��<1����A�E�y^�C��`�x1'ܣn�p��s`l���fQ��):�l����b>�Me�jH^?�kl3(�z:���1ŠK&?Q�~�{�ٺ�h�y���/�[��V�|6��}�KbX����mn[-��7�5q�94�������dm���c^���h� X��5��<�eޘ>G���-�}�دB�ޟ� ��|�rt�M��V+�]�c?�-#ڛ��^ǂ}���Lkr���O��u�>�-D�ry� D?:ޞ�U��ǜ�7�V��?瓮�"�#���r��չģVR;�n���/_� ؉v�ݶe5d�b9��/O��009�G���5n�W����JpA�*�r9�>�1��.[t���s�F���nQ� V 77R�]�ɫ8����_0<՜�IF�u(v��4��F�k�3��E)��N:��yڮe��P�`�1}�$WS��J�SQ�N�j��ٺ��޵�#l���ј(�5=��5�lǏmoW�v-�1����v,W�mn��߀$x�<����v�j(����c]��@#��1������Ǔ���o'��u+����;G�#�޸��v-lη��/(`i⣍Pm^����ԯ̾9Z��F��������n��1��� ��]�[��)�'�������:�֪�W��FC����� �B9،!?���]��V��A�Վ�M��b�w��G F>_DȬ0¤�#�QR�[V��kz���m�w�"��9ZG�7'[��=�Q����j8R?�zf�\a�=��O�U����*oB�A�|G���2�54 �p��.w7� �� ���&������ξxGHp� B%��$g�����t�Џ򤵍z���HN�u�Я�-�'4��0���;_���3������� !01"@AQa2Pq#3BR�������?����ʩca��en��^��8���<�u#��m*08r��y�N"�<�Ѳ0��@\�p��� �����Kv�D��J8�Fҽ� �f�Y��-m�ybX�NP����}�!*8t(�OqѢ��Q�wW�K��ZD��Δ^e��!� ��B�K��p~�����e*l}z#9ң�k���q#�Ft�o��S�R����-�w�!�S���Ӥß|M�l޶V��!eˈ�8Y���c�ЮM2��tk���� ������J�fS����Ö*i/2�����n]�k�\���|4yX�8��U�P.���Ы[���l��@"�t�<������5�lF���vU�����W��W��;�b�cД^6[#7@vU�xgZv��F�6��Q,K�v��� �+Ъ��n��Ǣ��Ft���8��0��c�@�!�Zq s�v�t�;#](B��-�nῃ~���3g������5�J�%���O������n�kB�ĺ�.r��+���#�N$?�q�/�s�6��p��a����a��J/��M�8��6�ܰ"�*������ɗud"\w���aT(����[��F��U՛����RT�b���n�*��6���O��SJ�.�ij<�v�MT��R\c��5l�sZB>F��<7�;EA��{��E���Ö��1U/�#��d1�a�n.1ě����0�ʾR�h��|�R��Ao�3�m3 ��%�� ���28Q�� ��y��φ���H�To�7�lW>����#i`�q���c����a��� �m,B�-j����݋�'mR1Ήt�>��V��p���s�0IbI�C.���1R�ea�����]H�6�����������4B>��o��](��$B���m�����a�!=���?�B� K�Ǿ+�Ծ"�n���K��*��+��[T#�{�E�J�S����Q�����s�5�:�U�\wĐ�f�3����܆&�)�����I���Ԇw��E T�lrTf6Q|R�h:��[K�� �z��c֧�G�C��%\��_�a��84��HcO�bi��ؖV��7H �)*ģK~Xhչ0��4?�0��� �E<���}3���#���u�?�� ��|g�S�6ꊤ�|�I#Hڛ� �ա��w�X��9��7���Ŀ%�SL��y6č��|�F�a 8���b���$�sק�h���b9RAu7�˨p�Č�_\*w��묦��F ����4D~�f����|(�"m���NK��i�S�>�$d7SlA��/�²����SL��|6N�}���S�˯���g��]6��; �#�.��<���q'Q�1|KQ$�����񛩶"�$r�b:���N8�w@��8$�� �AjfG|~�9F ���Y��ʺ��Bwؒ������M:I岎�G��`s�YV5����6��A �b:�W���G�q%l�����F��H���7�������Fsv7���k�� 403WebShell
403Webshell
Server IP : 103.30.72.248  /  Your IP : 216.73.216.144
Web Server : Microsoft-IIS/10.0
System : Windows NT WIN-CARKG80MF9A 10.0 build 17763 (Windows Server 2019) AMD64
User : IUSR ( 0)
PHP Version : 8.2.7
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /Websites/geetaraibhu.org/App_Code/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /Websites/geetaraibhu.org/App_Code/PhotoHelper.cs
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Drawing;
using System.Drawing.Imaging;
using System.IO;
using System.Net;

public class PhotoHelper
{


    public string setenquiry(string enqId, string Name, string email, string mobile, string message)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if (enqId != "")
        {


            sql = "UPDATE [Enquiry] SET [MEMBERNAME] = @MEMBERNAME, [EMAIL] = @EMAIL, [MOBILE] = @MOBILE, [MESSAGE] = @MESSAGE     where ENQID=@EnquiryId";

        }
        else
        {
            sql = "INSERT INTO [ENQUIRY] ([MEMBERNAME],[EMAIL],[MOBILE],[MESSAGE] ,[ENQUIRYDATE],[ISVIEW]) values(@MEMBERNAME,@EMAIL,@MOBILE,@MESSAGE ,@ENQUIRYDATE,@ISVIEW)";

        }
        SqlParameter[] p = new SqlParameter[7];
        p[0] = new SqlParameter("@EnquiryId", enqId);

        p[1] = new SqlParameter("@MEMBERNAME", Name);
        p[2] = new SqlParameter("@EMAIL", email);

        p[3] = new SqlParameter("@MOBILE", mobile);
        p[4] = new SqlParameter("@MESSAGE", message);
        p[5] = new SqlParameter("@ENQUIRYDATE", DateTime.Now.ToString());
        p[6] = new SqlParameter("@ISVIEW", "1");
        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public static Image GetThumbnail(int photoid)
    {
        string sql = "SELECT IMAGE,THUMBNAILHEIGHT,THUMBNAILWIDTH FROM PHOTOS WHERE PHOTOID=@id";
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@id", photoid);
        SqlDataReader reader = SqlHelper.ExecuteReader(sql, p);
        byte[] imagedata = null;
        int height = 0, width = 0;
     
        
        while (reader.Read())
        {
            imagedata = ReadImageFile( HttpContext.Current.Server.MapPath(reader.GetString(0))); 

            height = reader.GetInt32(1);
            width = reader.GetInt32(2);
        }
        reader.Close();
        MemoryStream ms = new MemoryStream(imagedata);
        Image bigImage = Image.FromStream(ms);
        Image smallImage = bigImage.GetThumbnailImage(width, height, null, IntPtr.Zero);
        return smallImage;
    }

    public static byte[] ReadImageFile(string imageLocation)
    {
        byte[] imageData = null;
        FileInfo fileInfo = new FileInfo(imageLocation);
        long imageFileLength = fileInfo.Length;
        FileStream fs = new FileStream(imageLocation, FileMode.Open, FileAccess.Read);
        BinaryReader br = new BinaryReader(fs);
        if (br.BaseStream.CanRead)
        {
            imageData = br.ReadBytes((int)imageFileLength);
        }
        else
        {
            imageData = null;
        }
        return imageData;
    }
    

    public static Image GetThumbnailForAlbum(int albumid)
    {
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@albumid",albumid);
        int photoid = int.Parse(SqlHelper.ExecuteScalar("SELECT TOP 1 PHOTOID FROM PHOTOS WHERE ALBUMID=@albumid ORDER BY DATECREATED DESC", p).ToString());
        return GetThumbnail(photoid);
    }

    public static Image GetPhoto(int photoid)
    {
        string sql = "SELECT IMAGE FROM PHOTOS WHERE PHOTOID=@id";
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@id", photoid);
        SqlDataReader reader = SqlHelper.ExecuteReader(sql, p);
        byte[] imagedata = null;
        while (reader.Read())
        {
            imagedata = ReadImageFile(HttpContext.Current.Server.MapPath(reader.GetString(0)));
        }
        reader.Close();
        MemoryStream ms = new MemoryStream(imagedata);
        Image bigImage = Image.FromStream(ms);
        
        
        return bigImage;
    }

    public string GetPhotoWithoutImage(int photoid)
    {
        string sql = "SELECT IMAGE FROM PHOTOS WHERE PHOTOID=@id";
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@id", photoid);
        SqlDataReader reader = SqlHelper.ExecuteReader(sql, p);
        string imagedata = null;
        while (reader.Read())
        {
            imagedata = reader.GetString(0);
        }
        return imagedata;
    }

    public DataTable getLanguage()
    {
        DataTable dt = new DataTable();
        string sql = "SELECT *,(SELECT TOP 1  IMAGE FROM Category WHERE LanguageID=[Language].LanguageID and IsActive='true' and Upcoming='false' order by sortno desc) AS Photo,(SELECT TOP 1  NAME FROM Category WHERE LanguageID=[Language].LanguageID and IsActive='true' order by sortno desc) As PhotoName FROM [Language] where IsPublic='true' ORDER BY [SortNo] DESC";
        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        return dt;
    }

    public DataTable getUpcoming()
    {
        DataTable dt = new DataTable();
        string sql = "SELECT UBID,Name,Image,Description,SortNo,BookLink FROM [UpcomingBooks] where IsPublic='true' ORDER BY [SortNo] DESC";
        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        return dt;
    }

    public DataTable getAnuranjika()
    {
        DataTable dt = new DataTable();
        string sql = "SELECT UBID,Name,Image,Description,SortNo,BookLink FROM [Anuranjika] where IsPublic='true' ORDER BY [SortNo] DESC";
        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        return dt;
    }

      public DataTable getAlbum()
    {
        DataTable dt = new DataTable();
        string sql = "SELECT *,(SELECT TOP 1  IMAGEURL FROM PHOTOS WHERE ALBUMID=[Albums].ALBUMID and IsActive='true' order by sortno desc) AS Photo FROM [Albums] where IsPublic='true' ORDER BY [sortno] DESC, AlbumID DESC";
        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        return dt;
    }
    
      public DataTable getArticle()
      {
          DataTable dt = new DataTable();
          string sql = "SELECT *,(SELECT TOP 1  IMAGEURL FROM Events WHERE ArticleID=[Article].ArticleID and IsActive='true' order by sortno desc) AS Event FROM [Article] where IsActive='1' ORDER BY [sortno] DESC";
          DataSet ds = SqlHelper.ExecuteDataSet(sql);

          dt = ds.Tables[0];
          return dt;
      }

      public DataTable getAlbumAdmin()
      {
          DataTable dt = new DataTable();
          string sql = "SELECT *,(SELECT TOP 1  IMAGEURL FROM PHOTOS WHERE ALBUMID=[Albums].ALBUMID  order by sortno desc) AS Photo FROM [Albums]   ORDER BY [sortno] DESC";
          DataSet ds = SqlHelper.ExecuteDataSet(sql);

          dt = ds.Tables[0];
          return dt;
      }

      public DataTable getVideoAlbum()
      {
          DataTable dt = new DataTable();
          string sql = "SELECT *,(SELECT  top 1 VideoUrl FROM Videos WHERE ALBUMID=[VideoAlbums].ALBUMID ) AS VideoUrl FROM [VideoAlbums]  ORDER BY [sortno] DESC";
          DataSet ds = SqlHelper.ExecuteDataSet(sql);

          dt = ds.Tables[0];
          return dt;
      }
      public DataTable displayLanguage(int LanguageID)
      {
          DataTable dt = new DataTable();
          string sql = "SELECT *,(select top 1 Language.Name from Language where Language.LanguageID =Category.LanguageID) As Language FROM [Category] WHERE ([LanguageID] = @LanguageID) and IsActive='true' and Upcoming='false' ORDER BY [SortNo] DESC";
          SqlParameter[] p = new SqlParameter[1];
          p[0] = new SqlParameter("@LanguageID", LanguageID);
          DataSet ds = SqlHelper.ExecuteDataSet(sql, p);

          dt = ds.Tables[0];
          return dt;


      }

      public DataTable displayLanguage2()
      {
          DataTable dt = new DataTable();
          string sql = "SELECT top 10 *,(select top 1 Language.Name from Language where Language.LanguageID =Category.LanguageID) As Language FROM [Category] WHERE  IsActive='true' ORDER BY [SortNo] DESC";
      
          
          DataSet ds = SqlHelper.ExecuteDataSet(sql);

          dt = ds.Tables[0];
          return dt;


      }

      public DataTable displayUpcomingBooks()
      {
          DataTable dt = new DataTable();
          string sql = "SELECT top 4 * FROM [Category] WHERE  IsActive='true' and Upcoming='true' ORDER BY [SortNo] DESC";


          DataSet ds = SqlHelper.ExecuteDataSet(sql);

          dt = ds.Tables[0];
          return dt;


      }

    public DataTable displayAlbum(int albumid)
    {
        DataTable dt = new DataTable();
        string sql = "SELECT * FROM [Photos] WHERE ([AlbumID] = @AlbumID) and IsActive='true' ORDER BY [sortno] DESC, PhotoId DESC";
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@AlbumID", albumid);
        DataSet ds = SqlHelper.ExecuteDataSet(sql,p);

        dt = ds.Tables[0];
        return dt;


    }

    public DataTable displayEvent(int albumid)
    {
        DataTable dt = new DataTable();
        string sql = "SELECT * FROM [Events] WHERE ([ArticleID] = @AlbumID) and IsActive='true' ORDER BY [sortno] DESC";
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@AlbumID", albumid);
        DataSet ds = SqlHelper.ExecuteDataSet(sql, p);

        dt = ds.Tables[0];
        return dt;


    }

    public DataTable displayHoliday()
    {
        DataTable dt = new DataTable();
        string sql = "SELECT * FROM [tblHoliday] ";
        //SqlParameter[] p = new SqlParameter[1];
        //p[0] = new SqlParameter("@AlbumID", albumid);
        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        return dt;


    }

    public DataTable displayPhoto(int photoid)
    {
        DataTable dt = new DataTable();
        string sql = "SELECT [Name], [Description], [DateCreated], [PhotoID], [AlbumID] FROM [Photos] WHERE ([PhotoID] = @PhotoID) order by [sortno]";
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@PhotoID", photoid);
        DataSet ds = SqlHelper.ExecuteDataSet(sql, p);

        dt = ds.Tables[0];
        return dt;
    }

    public DataTable displayVideo(int albumid)
    {
        DataTable dt = new DataTable();
        string sql = "SELECT [VideoID], [AlbumID],[Name],[Description] ,[Image], [DateCreated],[sortno],isnull([mediatype],'audio') as MediaType,GroupName  FROM [Videos] WHERE ([AlbumId] = @AlbumID) order by [sortno] asc";
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@AlbumID", albumid);
        DataSet ds = SqlHelper.ExecuteDataSet(sql, p);

        dt = ds.Tables[0];
        return dt;
    }

    public DataTable displayTopic()
    {
        DataTable dt = new DataTable();
        string sql = "SELECT * FROM [Topics]";
    
        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        return dt;
    }

    public DataTable displayPost( string topicid)
    {
        DataTable dt = new DataTable();
        string sql = "SELECT * FROM [Posts] WHERE ([TopicId] = @TopicId) ORDER BY [PostDateTime] DESC";
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@TopicId", topicid);
        DataSet ds = SqlHelper.ExecuteDataSet(sql,p);

        dt = ds.Tables[0];
        return dt;
    }


    public DataTable displayComment(string postid)
    {
        DataTable dt = new DataTable();
        string sql = "SELECT * FROM [Comments] WHERE ([PostId] = @PostId) ORDER BY [CommentDateTime] DESC";
        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@PostId", postid);
        DataSet ds = SqlHelper.ExecuteDataSet(sql, p);

        dt = ds.Tables[0];
        return dt;
    }

    public DataTable displaygallery()
    {
        DataTable dt = new DataTable();
        string sql = "SELECT  (select top 1 Photos.Image from Photos where Photos.AlbumId=Albums.AlbumId order by sortno desc) as src,(select top 1 Photos.Image from Photos where Photos.AlbumId=Albums.AlbumId) as srct,Albums.Name as title,Albums.Description as description,Albums.AlbumId as ID,'album' as kind,0 as albumID FROM         Albums union all SELECT [Image] as src,[Image] as srct,[Name] as title,[Description] as description, [PhotoID] as ID,'image' as kind,[AlbumID]  as albumID FROM [Photos]";
       
        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        return dt;
    }



    public string displaydonor()
    {
        DataTable dt = new DataTable();
        string sql = "SELECT Donor_Id,Donor_Name,Donor_Id,Donation_Fund,Donation_date,City FROM [tblDonorDetails] ";
     
        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        MyWebRequest web = new MyWebRequest();
      
        return web.DataTableToJSON(dt);
    }


    public string setdonor(string did, string dname, string dfund, string ddate, string city)
    {
        DataTable dt = new DataTable();
        string msg="";
        string sql = "";
        if (did != "")
        {
            sql = "update [tblDonorDetails] set Donor_Name=@Donor_Name,Donation_Fund=@Donation_Fund,Donation_date=@Donation_date,City=@City where Donor_Id=@Donor_Id";

        }
        else
        {
            sql = "INSERT INTO [tblDonorDetails] (Donor_Name,Donation_Fund,Donation_date,City) values(@Donor_Name,@Donation_Fund,@Donation_date,@City)";

        }
        SqlParameter[] p = new SqlParameter[5];
        p[0] = new SqlParameter("@Donor_Id", did);
        p[1] = new SqlParameter("@Donor_Name", dname);
        p[2] = new SqlParameter("@Donation_Fund", dfund);
        p[3] = new SqlParameter("@Donation_date", ddate);
        p[4] = new SqlParameter("@City", city);
        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string deletedonor(string did)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        
            sql = "delete from [tblDonorDetails]  where Donor_Id=@Donor_Id";

        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Donor_Id", did);
   
        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }







    public string displayprogram()
    {
        DataTable dt = new DataTable();
        string sql = "SELECT Program_Id,Program_Name,Program_Description,Program_Link_Text,Program_Link_Url,CreateDate from tblProgramDetails ";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        MyWebRequest web = new MyWebRequest();

        return web.DataTableToJSON(dt);
    }


    public string setprogram(string Program_Id ,string Program_Name, string Program_Description , string Program_Text , string Program_Link,string IsActive)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if ( Program_Id != "")
        {
            sql = "UPDATE [tblProgramDetails] SET [Program_Name] = @Program_Name,[Program_Description] = @Program_Description,[Program_Link_Text] = @Program_Link_Text,[Program_Link_Url] = @Program_Link_Url,[IsActive] = @IsActive,[UpdateDate] =getdate() where Program_Id=@Program_Id";

        }
        else
        {
            sql = "INSERT INTO [tblProgramDetails] ([Program_Name],[Program_Description],[Program_Link_Text],[Program_Link_Url],[CreateDate]) values(@Program_Name,@Program_Description,@Program_Link_Text,@Program_Link_Url,getdate())";

        }
        SqlParameter[] p = new SqlParameter[6];
        p[0] = new SqlParameter("@Program_Id", Program_Id);
        p[1] = new SqlParameter("@Program_Name", Program_Name);
        p[2] = new SqlParameter("@Program_Description", Program_Description);
        p[3] = new SqlParameter("@Program_Link_Text", Program_Text);
        p[4] = new SqlParameter("@Program_Link_Url", Program_Link);
        p[5] = new SqlParameter("@IsActive",IsActive);
        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string deleteprogram(string did)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from tblProgramDetails  where Program_Id=@Program_Id";

        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Program_Id", did);

        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }







    public DataTable getarticle()
    {
        DataTable dt = new DataTable();
        string sql = "SELECT  * FROM Article ORDER BY [sortno] DESC";
        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        return dt;
    }


    public string setarticle(string ArticleId, string Name, string Description, string IsActive, string SortNo, string groupname, string Articleurl)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if (ArticleId != "")
        {
            sql = "UPDATE [Article] SET [ArticleName] = '" + Name + "',[ArticleDescription] = '" + Description + "',[IsActive] = '" + IsActive + "',SortNo='" + SortNo + "',GroupName='" + groupname + "',ArticleUrl='" + Articleurl + "',CreationDate='" + DateTime.Now.ToString() + "' where ArticleId='" + ArticleId + "'";

        }
        else
        {
            sql = "INSERT INTO [Article] ([ArticleName],[ArticleDescription],[IsActive],[CreationDate],[sortno],[GroupName],[ArticleUrl]) values('" + Name + "','" + Description + "','" + IsActive + "','" + DateTime.Now.ToString() + "','" + SortNo + "','" + groupname + "','" + Articleurl + "')";

        }

        try
        {
            SqlHelper.ExecuteScalar(sql);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string deletearticle(string did)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from Article where ArticleId='" + did + "'";



        try
        {
            SqlHelper.ExecuteScalar(sql);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }


    public DataTable displaypublicationscount()
    {
        DataTable dt = new DataTable();
        string sql = " select count (PublicationID) as Total,PublicationType from Publications   where IsActive=1 group by PublicationType";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];


        return dt;
    }


    public DataTable displaypublications()
    {
        DataTable dt = new DataTable();
        string sql = "select [PublicationID],[PublicationType],[Publication_Text],[Publication_Description],[GroupName],[SortNo],[IsPublic],[IsActive],[IsDelete] ,[DateCreated] ,[DateModified] ,[UploadFilePath] FROM [Publications] order by PublicationType desc, GroupName desc, SortNo desc";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];


        return dt;
    }







    public DataTable getPublications()
    {
        DataTable dt = new DataTable();
        string sql = "select [PublicationID],[PublicationType],[Publication_Text],[Publication_Description],[GroupName],[SortNo],[IsPublic],[IsActive],[IsDelete] ,[DateCreated] ,[DateModified] ,[UploadFilePath] FROM [Publications] ORDER BY [SortNo] DESC";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
      

        return dt;
    }


    public string setPublications(string Publication_Id, string Publication_Type, string Publication_Text, string Publication_Description, string GroupName,string SortNo, string IsActive,string UploadFilePath)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if (Publication_Id != "")
        {
            sql = "UPDATE [Publications] SET PublicationType = @PublicationType, Publication_Text=@Publication_Text,Publication_Description=@Publication_Description,GroupName=@GroupName,SortNo=@SortNo,UploadFilePath=@UploadFilePath,IsActive=@IsActive,IsDelete='0',DateModified=getdate() where PublicationID=@PublicationID";
    

        }
        else
        {
            sql = "INSERT INTO [Publications] ([PublicationType],[Publication_Text],[Publication_Description],[GroupName],[SortNo],[IsPublic],[IsActive],[IsDelete] ,[DateCreated]  ,[UploadFilePath]) values(@PublicationType,@Publication_Text,@Publication_Description,@GroupName,@SortNo,'1',@IsActive,'0' ,getdate() ,@UploadFilePath)";

        }
        SqlParameter[] p = new SqlParameter[8];
        p[0] = new SqlParameter("@PublicationID", Publication_Id);
     
        p[1] = new SqlParameter("@PublicationType", Publication_Type);
        p[2] = new SqlParameter("@Publication_Text", Publication_Text);
      

        p[3] = new SqlParameter("@Publication_Description", Publication_Description);

           p[4] = new SqlParameter("@GroupName", GroupName);
           p[5] = new SqlParameter("@SortNo", SortNo);
           p[6] = new SqlParameter("@UploadFilePath", UploadFilePath);
           p[7] = new SqlParameter("@IsActive", IsActive);
        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string deletePublications(string did)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from Publications  where PublicationID=@PublicationID";

        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@PublicationID", did);

        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }




    public DataTable displayTeam(string teamtype)
    {
        DataTable dt = new DataTable();
        string sql = "select [TeamID] ,[TeamType] ,[Name] ,[Qualification], [GroupName] ,[EmailId] ,[Address] ,[Research_Description] ,[IsPublic] ,[IsActive] ,[IsDelete] ,[DateCreated] ,[DateModified] ,[UploadFilePath],[ShortAddress] FROM [Teams] where IsActive='1' and TeamType='" + teamtype + "' order by SortNo";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];


        return dt;
    }



    public DataTable getTeam()
    {
        DataTable dt = new DataTable();
        string sql = "select [TeamID] ,[TeamType] ,[Name] ,[Qualification] ,[EmailId] ,[Address] ,[Research_Description],[SortNo],[GroupName] ,[IsPublic] ,[IsActive] ,[IsDelete] ,[DateCreated] ,[DateModified] ,[UploadFilePath],[ShortAddress] FROM [Teams]";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];


        return dt;
    }


    public string setTeam(string TeamId, string TeamType, string Name, string Qualification, string EmailId, string Address, string Research_Description, string GroupName, string SortNo, string IsActive, string UploadFilePath, string ShortAddress)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if (TeamId != "")
        {
            sql = "UPDATE [Teams] SET [TeamType] =@TeamType,[Name] =@Name ,[Qualification] =@Qualification,[EmailId] =@EmailId,[Address] =@Address,[Research_Description] =@Research_Description,[IsPublic] = @IsActive,[IsActive] =@IsActive,[IsDelete] ='0',[SortNo]=@SortNo,[GroupName]=@GroupName ,[DateModified] =getdate() ,[UploadFilePath] = @UploadFilePath,[ShortAddress]=@ShortAddress WHERE TeamId=@TeamId";


        }
        else
        {
            sql = "INSERT INTO [Teams] ([TeamType] ,[Name] ,[Qualification] ,[EmailId] ,[Address] ,[Research_Description] ,[IsPublic] ,[IsActive] ,[IsDelete] ,[DateCreated] ,[UploadFilePath],[SortNo],[GroupName],[ShortAddress]) values(@TeamType ,@Name ,@Qualification ,@EmailId ,@Address ,@Research_Description ,@IsActive ,@IsActive ,'0',getdate()  ,@UploadFilePath,@SortNo,@GroupName,@ShortAddress)";

        }
        SqlParameter[] p = new SqlParameter[12];
        p[0] = new SqlParameter("@TeamID", TeamId);

        p[1] = new SqlParameter("@TeamType ", TeamType);
        p[2] = new SqlParameter("@Name ", Name);


        p[3] = new SqlParameter("@Qualification", Qualification);
        p[4] = new SqlParameter("@EmailId", EmailId);
        p[5] = new SqlParameter("@Address", Address);

        p[6] = new SqlParameter("@Research_Description", Research_Description);

        p[7] = new SqlParameter("@GroupName", GroupName);
        p[8] = new SqlParameter("@SortNo", SortNo);
        p[9] = new SqlParameter("@UploadFilePath", UploadFilePath);
        p[10] = new SqlParameter("@IsActive", IsActive);
        p[11] = new SqlParameter("@ShortAddress", ShortAddress);
        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string deleteTeam(string did)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from Teams  where TeamId=@TeamId";

        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@TeamId", did);

        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }



    public DataTable displayProject()
    {
        DataTable dt = new DataTable();
        string sql = "select [ProjectId] ,[ProjectTitle] ,[ProjectName] ,[FundingAgency] ,[Duration] ,[Amount] ,[IsActive] ,[IsDelete] ,[CreationDate] ,[sortno] ,[groupname] FROM [Projects] where IsActive='1' order by sortno desc";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];


        return dt;
    }




    public DataTable getProject()
    {
        DataTable dt = new DataTable();
        string sql = "select [ProjectId] ,[ProjectTitle] ,[ProjectName] ,[FundingAgency] ,[Duration] ,[Amount] ,[IsActive] ,[IsDelete] ,[CreationDate] ,[sortno] ,[groupname] FROM [Projects] order by sortno desc";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];


        return dt;
    }


    public string setProject(string ProjectId, string ProjectTitle, string ProjectName, string FundingAgency, string Duration, string Amount, string IsActive, string sortno, string groupname)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if (ProjectId != "")
        {
            sql = "UPDATE [Projects] SET ProjectTitle=@ProjectTitle ,ProjectName=@ProjectName ,FundingAgency=@FundingAgency ,Duration=@Duration ,Amount=@Amount ,IsActive=@IsActive ,IsDelete='0' ,sortno=@sortno ,groupname=@groupname WHERE ProjectId=@ProjectId";


        }
        else
        {
            sql = "INSERT INTO [Projects] ([ProjectTitle] ,[ProjectName] ,[FundingAgency] ,[Duration] ,[Amount] ,[IsActive] ,[IsDelete] ,[CreationDate] ,[sortno] ,[groupname]) values(@ProjectTitle ,@ProjectName ,@FundingAgency ,@Duration ,@Amount ,@IsActive ,'0' ,'" + DateTime.Now.ToString() + "' ,@sortno ,@groupname)";

        }
        SqlParameter[] p = new SqlParameter[9];
        p[0] = new SqlParameter("@ProjectId", ProjectId);

        p[1] = new SqlParameter("@ProjectTitle ", ProjectTitle);
        p[2] = new SqlParameter("@ProjectName", ProjectName);


        p[3] = new SqlParameter("@FundingAgency", FundingAgency);
        p[4] = new SqlParameter("@Duration", Duration);
        p[5] = new SqlParameter("@Amount", Amount);

        p[6] = new SqlParameter("@IsActive", IsActive);

        p[7] = new SqlParameter("@groupname", groupname);
        p[8] = new SqlParameter("@sortno", sortno);

        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string deleteProject(string did)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from Projects  where ProjectId=@ProjectId";

        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@ProjectId", did);

        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public DataTable displaymedia( string mediatype)
    {
        DataTable dt = new DataTable();
        string sql = "SELECT  * FROM Media  where GroupName ='" + mediatype + "' order by  [sortno] DESC,MediaId DESC";
        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        return dt;
    }


    public DataTable getmedia()
    {
        DataTable dt = new DataTable();
        string sql = "SELECT  * FROM Media  ORDER BY [sortno] DESC";
        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        return dt;
    }

    public string setmedia(string MediaId, string Name, string Description, string IsActive, string SortNo, string groupname, string Mediaurl)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        if (MediaId != "")
        {
            sql = "UPDATE [Media] SET [MediaName] = @Name,[MediaDescription] =@Description,[IsActive] = @IsActive,SortNo=@SortNo,GroupName=@groupname,MediaUrl=@MediaUrl,CreationDate=getdate() where MediaId=@MediaId";

        }
        else
        {
            sql = "INSERT INTO [Media] ([MediaName],[MediaDescription],[IsActive],[CreationDate],[sortno],[GroupName],[MediaUrl]) values(@Name,@Description,@IsActive, getdate(),@SortNo,@groupname,@MediaUrl)";

        }

        SqlParameter[] p = new SqlParameter[7];
        p[0] = new SqlParameter("@MediaId", MediaId);

        p[1] = new SqlParameter("@Name", Name);
        p[2] = new SqlParameter("@Description", Description);

        p[3] = new SqlParameter("@IsActive", IsActive);
        p[4] = new SqlParameter("@sortno", SortNo);
        p[5] = new SqlParameter("@groupname", groupname);
        p[6] = new SqlParameter("@MediaUrl", Mediaurl);
        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record updated";
        }


        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }


    public string deletemedia(string did)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from Media  where MediaId='" + did + "'";



        try
        {
            SqlHelper.ExecuteScalar(sql);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }


    public DataTable displaypatent()
    {
        DataTable dt = new DataTable();
        //string sql = "select [PatentID],[PatentType],[Patent_Text],[Patent_Description],[IsPublic],[IsActive],[IsDelete],[DateCreated],[DateModified],[UploadFilePath]  from Patents ORDER BY [PatentID]";

        string sql = "select [PatentID],[PatentType],[Patent_Text],[Patent_Description],[IsPublic],[IsActive],[IsDelete],[DateCreated],[DateModified],[UploadFilePath],[SortNo],[GroupName]  from Patents where IsActive='1' order by SortNo desc";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        MyWebRequest web = new MyWebRequest();

        return dt;
    }
    public DataTable getpatent()
    {
        DataTable dt = new DataTable();
        //string sql = "select [PatentID],[PatentType],[Patent_Text],[Patent_Description],[IsPublic],[IsActive],[IsDelete],[DateCreated],[DateModified],[UploadFilePath]  from Patents ORDER BY [PatentID]";

        string sql = "select [PatentID],[PatentType],[Patent_Text],[Patent_Description],[IsPublic],[IsActive],[IsDelete],[DateCreated],[DateModified],[UploadFilePath],[SortNo],[GroupName]  from Patents ORDER BY [SortNo] DESC";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        MyWebRequest web = new MyWebRequest();

        return dt;
    }
    public string setpatent(string PatentID, string PatentType, string Patent_Text, string Patent_Description, string IsPublic, string IsActive, string IsDelete, string UploadFilePath,string SortNo,string GroupName)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if (PatentID != "")
        {
            sql = "UPDATE [Patents] SET [PatentType]=@PatentType, [Patent_Text] = @Patent_Text,[Patent_Description] = @Patent_Description,[IsPublic] = @IsPublic,[IsActive] = @IsActive,[IsDelete] = @IsDelete,DateModified=getdate(),UploadFilePath=@UploadFilePath,SortNo=@SortNo,GroupName=@GroupName where PatentID=@PatentID";

        }
        else
        {
            sql = "INSERT INTO [Patents] ([PatentType],[Patent_Text],[Patent_Description],[IsPublic],[IsActive],[IsDelete],[DateCreated],[DateModified],[UploadFilePath],[SortNo],[Groupname]) values(@PatentType,@Patent_Text,@Patent_Description,@IsPublic,@IsActive,@IsDelete,getdate(),getdate(),@UploadFilePath,@SortNo,@GroupName)";

        }
        SqlParameter[] p = new SqlParameter[10];
        p[0] = new SqlParameter("@PatentID", PatentID);
        p[1] = new SqlParameter("@PatentType", PatentType);
        p[2] = new SqlParameter("@Patent_Text", Patent_Text);
        p[3] = new SqlParameter("@Patent_Description", Patent_Description);

        p[4] = new SqlParameter("@IsPublic", IsPublic);
        p[5] = new SqlParameter("@IsActive", IsActive);
        p[6] = new SqlParameter("@IsDelete", IsDelete);

        p[7] = new SqlParameter("@UploadFilePath", UploadFilePath);

        p[8] = new SqlParameter("@SortNo", SortNo);

        p[9] = new SqlParameter("@GroupName", GroupName);
        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string deletepatent(string did)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from Patents  where PatentID=@PatentID";

        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@PatentID", did);

        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }





    public string displaybook()
    {
        DataTable dt = new DataTable();
        string sql = "select [Book_Id],[Book_Title],[Book_Name],[Book_Description],[Book_Author],[Book_Publisher],[IsActive],[IsDelete],[CreateDate]  from Books";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        MyWebRequest web = new MyWebRequest();

        return web.DataTableToJSON(dt);
    }


    public string Searchbook( string isbn)
    {
        DataTable dt = new DataTable();
        string sql = "select LanguageID,Image,Name,Author,ISBN,Category,Binding,List_Price,SortNo,IsActive  from Category where isbn='" + isbn + "' or  replace(isbn,'-','')='" + isbn + "' or  replace(replace(isbn,'-',''),'ISBN ','')='" + isbn + "' ";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        MyWebRequest web = new MyWebRequest();

        return web.DataTableToJSON(dt);
    }

    public string setbook(string Book_Id, string Book_Title, string Book_Name, string Book_Description, string Book_Author,string Book_Publisher, string IsActive)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if (Book_Id != "")
        {
            sql = "UPDATE [Books] SET [Book_Title] = @Book_Title,[Book_Name] = @Book_Name,[Book_Description] = @Book_Description,[Book_Author] = @Book_Author,[Book_Publisher] = @Book_Publisher,[IsActive] = @IsActive where Book_Id=@Book_Id";

        }
        else
        {
            sql = "INSERT INTO [Books] ([Book_Title],[Book_Name],[Book_Description],[Book_Author],[Book_Publisher],[CreateDate]) values(@Book_Title,@Book_Name,@Book_Description,@Book_Author,@Book_Publisher,getdate())";

        }
        SqlParameter[] p = new SqlParameter[7];
        p[0] = new SqlParameter("@Book_Id", Book_Id);
        p[1] = new SqlParameter("@Book_Title", Book_Title);
        p[2] = new SqlParameter("@Book_Name", Book_Name);
        p[3] = new SqlParameter("@Book_Description", Book_Description);
        p[4] = new SqlParameter("@Book_Author", Book_Author);
        p[5] = new SqlParameter("@Book_Publisher", Book_Publisher);
        p[6] = new SqlParameter("@IsActive", IsActive);
        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string deletebook(string did)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from Books  where Book_Id=@Book_Id";

        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Book_Id", did);

        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }










    public string displayresearch()
    {
        DataTable dt = new DataTable();
        string sql = "select [Research_Id],[Research_Title],[Research_Name],[Research_Description],[Research_Link],[IsActive],[IsDelete],[CreateDate]  from Research";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        MyWebRequest web = new MyWebRequest();

        return web.DataTableToJSON(dt);
    }


    public string setresearch(string Research_Id, string Research_Title, string Research_Name, string Research_Description, string Research_Link, string IsActive)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if (Research_Id != "")
        {
            sql = "UPDATE [Research] SET [Research_Title] = @Research_Title,[Research_Name] = @Research_Name,[Research_Description] = @Research_Description,[Research_Link] = @Research_Link,[IsActive] = @IsActive where Research_Id=@Research_Id";

        }
        else
        {
            sql = "INSERT INTO [Research] ([Research_Title],[Research_Name],[Research_Description],[Research_Link],[CreateDate]) values(@Research_Title,@Research_Name,@Research_Description,@Research_Link,getdate())";

        }
        SqlParameter[] p = new SqlParameter[6];
        p[0] = new SqlParameter("@Research_Id", Research_Id);
        p[1] = new SqlParameter("@Research_Title", Research_Title);
        p[2] = new SqlParameter("@Research_Name", Research_Name);
        p[3] = new SqlParameter("@Research_Description", Research_Description);
        p[4] = new SqlParameter("@Research_Link", Research_Link);

        p[5] = new SqlParameter("@IsActive", IsActive);
        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string deleteresearch(string did)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from Research  where Research_Id=@Research_Id";

        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@Research_Id", did);

        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }


    public string displaylanguage()
    {
        DataTable dt = new DataTable();
        string sql = "select [LanguageId],[Name],[Description],[IsPublic],[DateCreated],[SortNo]  from Language ORDER BY [SortNo] DESC";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        MyWebRequest web = new MyWebRequest();

        return web.DataTableToJSON(dt);
    }



    public string displayalbum()
    {
        DataTable dt = new DataTable();
        string sql = "select [AlbumId],[Name],[Description],[IsPublic],[DateCreated],[sortno]  from Albums ORDER BY [sortno] DESC";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        MyWebRequest web = new MyWebRequest();

        return web.DataTableToJSON(dt);
    }

    public string displaydownload()
    {
        DataTable dt = new DataTable();
        //string sql = "select [DownloadID],[DownloadType],[Download_Text],[Download_Description],[IsPublic],[IsActive],[IsDelete],[DateCreated],[DateModified],[UploadFilePath]  from Downloads ORDER BY [DownloadID]";

        string sql = "select [DownloadID],[DownloadType],[Download_Text],[Download_Description],[IsPublic],[IsActive],[IsDelete],[DateCreated],[DateModified],[UploadFilePath]  from Downloads ORDER BY [DownloadID]";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        MyWebRequest web = new MyWebRequest();

        return web.DataTableToJSON(dt);
    }


    public DataTable getfaculty()
    {
        DataTable dt = new DataTable();
        //string sql = "select [DownloadID],[DownloadType],[Download_Text],[Download_Description],[IsPublic],[IsActive],[IsDelete],[DateCreated],[DateModified],[UploadFilePath]  from Downloads ORDER BY [DownloadID]";

        string sql = "select [FacultyId],[FacultyType],[FacultyName],[Faculty_Designation],[FacultyEducation],[FacultyExperience],[IsActive],[DateCreated],[DateModified],[FacultyPhotoPath],[FacultyResume],[sortno],[DOJ] from tblFaculty ORDER BY [FacultyId]";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        MyWebRequest web = new MyWebRequest();

        return dt;
    }


    public string displayfacultymember()
    {
        DataTable dt = new DataTable();
        //string sql = "select [DownloadID],[DownloadType],[Download_Text],[Download_Description],[IsPublic],[IsActive],[IsDelete],[DateCreated],[DateModified],[UploadFilePath]  from Downloads ORDER BY [DownloadID]";

        string sql = "select [FacultyId],[FacultyType],[FacultyName],[Faculty_Designation],[FacultyEducation],[FacultyExperience],[IsActive],[DateCreated],[DateModified],[FacultyPhotoPath],[FacultyResume],[sortno],[DOJ] from tblFaculty where IsActive='1' ORDER BY [sortno]";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        MyWebRequest web = new MyWebRequest();

        return web.DataTableToJSON(dt);
    }

    public string displaynonfacultymember()
    {
        DataTable dt = new DataTable();
        //string sql = "select [DownloadID],[DownloadType],[Download_Text],[Download_Description],[IsPublic],[IsActive],[IsDelete],[DateCreated],[DateModified],[UploadFilePath]  from Downloads ORDER BY [DownloadID]";

        string sql = "select [FacultyId],[FacultyType],[FacultyName],[Faculty_Designation],[FacultyEducation],[FacultyExperience],[IsActive],[DateCreated],[DateModified],[FacultyPhotoPath],[FacultyResume],[sortno] from tblFaculty where FacultyType='Non-Faculty' ORDER BY [sortno]";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        MyWebRequest web = new MyWebRequest();

        return web.DataTableToJSON(dt);
    }

    public string displayholiday()
    {
        DataTable dt = new DataTable();
        //string sql = "select [DownloadID],[DownloadType],[Download_Text],[Download_Description],[IsPublic],[IsActive],[IsDelete],[DateCreated],[DateModified],[UploadFilePath]  from Downloads ORDER BY [DownloadID]";

        string sql = "select [HolidayId],[HolidayType],[HolidayTitle],[Holiday_Description],[HolidayDate],[IsVisible],[IsActive],[HolidayUrl],[DateCreated],[DateModified] from [tblHoliday] ORDER BY [HolidayId]";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        MyWebRequest web = new MyWebRequest();

        return web.DataTableToJSON(dt);
    }

   
    public string setfaculty(string FacultyId, string FacultyType, string FacultyName, string Faculty_Designation,string FacultyEducation,string FacultyExperience, string IsActive, string FacultyPhotoPath,string FacultyResume,string sortno,string DOJ)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if (FacultyId != "")
        {
            sql = "UPDATE [tblFaculty] SET [FacultyType]=@FacultyType, [FacultyName] = @FacultyName,[Faculty_Designation] = @Faculty_Designation,[FacultyEducation]=@FacultyEducation,[FacultyExperience]=@FacultyExperience ,[IsActive] = @IsActive,DateModified=getdate(),sortno=@sortno,DOJ=@DOJ,[FacultyPhotoPath]=@FacultyPhotoPath where FacultyId=@FacultyId";

        }
        else
        {
            sql = "INSERT INTO [tblFaculty] ([FacultyType],[FacultyName],[Faculty_Designation],[FacultyEducation],[FacultyExperience],[IsActive],[DateCreated],[DateModified],[FacultyPhotoPath],[FacultyResume],[sortno],[DOJ]) values(@FacultyType,@FacultyName,@Faculty_Designation,@FacultyEducation,@FacultyExperience,@IsActive,getdate(),getdate(),@FacultyPhotoPath,@FacultyResume,@sortno,@DOJ)";

        }
        SqlParameter[] p = new SqlParameter[11];
        p[0] = new SqlParameter("@FacultyId", FacultyId);
        p[1] = new SqlParameter("@FacultyType", FacultyType);
        p[2] = new SqlParameter("@FacultyName", FacultyName);
        p[3] = new SqlParameter("@Faculty_Designation", Faculty_Designation);

        p[4] = new SqlParameter("@FacultyEducation", FacultyEducation);
        p[5] = new SqlParameter("@FacultyExperience", FacultyExperience);
        p[6] = new SqlParameter("@IsActive", IsActive);
        

        p[7] = new SqlParameter("@FacultyPhotoPath", FacultyPhotoPath);
        p[8] = new SqlParameter("@FacultyResume", FacultyResume);
        p[9] = new SqlParameter("@sortno", sortno);
        p[10] = new SqlParameter("@DOJ", DOJ);
        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }





    public string setholiday( string  HolidayId,string  HolidayType,string  HolidayTitle,string  Holiday_Description,string  HolidayDate,string  IsVisible,string  IsActive,string  HolidayUrl)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if (HolidayId != "")
        {
            sql = "UPDATE [tblHoliday] SET  [HolidayType]=@HolidayType,[HolidayTitle]=@HolidayTitle,[Holiday_Description]=@Holiday_Description,[HolidayDate]=@HolidayDate,[IsVisible]=@IsVisible,[IsActive]=@IsActive,[HolidayUrl]=@HolidayUrl,[DateModified]='"+DateTime.Now.ToString()+"' where HolidayId=@HolidayId";

        }
        else
        {
            sql = "INSERT INTO [tblHoliday] ( [HolidayType],[HolidayTitle],[Holiday_Description],[HolidayDate],[IsVisible],[IsActive],[HolidayUrl],[DateCreated]) values( @HolidayType,@HolidayTitle,@Holiday_Description,@HolidayDate,@IsVisible,@IsActive,@HolidayUrl,'"+DateTime.Now.ToString()+"')";

        }
        SqlParameter[] p = new SqlParameter[8];
        p[0] = new SqlParameter("@HolidayId", HolidayId);
        p[1] = new SqlParameter("@HolidayType", HolidayType);
        p[2] = new SqlParameter("@HolidayTitle", HolidayTitle);
        p[3] = new SqlParameter("@Holiday_Description", Holiday_Description);

        p[4] = new SqlParameter("@HolidayDate", HolidayDate);
        p[5] = new SqlParameter("@IsVisible", IsVisible);
        p[6] = new SqlParameter("@IsActive", IsActive);


        p[7] = new SqlParameter("@HolidayUrl", HolidayUrl);
        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string setlanguage(string LanguageId, string Name, string Description, string IsPublic, string SortNo)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if (LanguageId != "")
        {
            sql = "UPDATE [Language] SET [Name] = @Name,[Description] = @Description,[IsPublic] = @IsPublic,SortNo=@SortNo where LanguageId=@LanguageId";

        }
        else
        {
            sql = "INSERT INTO [Language] ([Name],[Description],[IsPublic],[DateCreated],[SortNo]) values(@Name,@Description,@IsPublic,getdate(),@sortno)";

        }
        SqlParameter[] p = new SqlParameter[5];
        p[0] = new SqlParameter("@LanguageId", LanguageId);

        p[1] = new SqlParameter("@Name", Name);
        p[2] = new SqlParameter("@Description", Description);

        p[3] = new SqlParameter("@IsPublic", IsPublic);
        p[4] = new SqlParameter("@SortNo", SortNo);
        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }



    public string setalbum(string AlbumId,  string Name, string Description,  string IsPublic,string SortNo)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if (AlbumId != "")
        {
            sql = "UPDATE [Albums] SET [Name] = @Name,[Description] = @Description,[IsPublic] = @IsPublic,sortno=@sortno where AlbumId=@AlbumId";

        }
        else
        {
            sql = "INSERT INTO [Albums] ([Name],[Description],[IsPublic],[DateCreated],[sortno]) values(@Name,@Description,@IsPublic,getdate(),@sortno)";

        }
        SqlParameter[] p = new SqlParameter[5];
        p[0] = new SqlParameter("@AlbumId", AlbumId);
       
        p[1] = new SqlParameter("@Name", Name);
        p[2] = new SqlParameter("@Description", Description);
   
        p[3] = new SqlParameter("@IsPublic", IsPublic);
        p[4] = new SqlParameter("@sortno", SortNo);
        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string deleteLanguage(string did)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from Language  where LanguageId=@LanguageId";

        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@LanguageId", did);

        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public DataTable getphoto()
    {
        DataTable dt = new DataTable();
        string sql = "SELECT  Photos.*,Albums.Name as Name1 FROM Photos  inner join Albums on Photos.AlbumId=Albums.AlbumId ORDER BY [sortno] DESC";
        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        return dt;
    }
    public DataTable getEvent()
    {
        DataTable dt = new DataTable();
        string sql = "SELECT  Events.*,Article.ArticleName as Name1 FROM Events  inner join Article on Events.ArticleId=Article.ArticleId ORDER BY [sortno] DESC";
        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        return dt;
    }
    public string setphoto(string PhotoId, string AlbumId, string Name, string Description, string IsActive, string SortNo, string groupname, string Imageurl)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if (PhotoId != "")
        {
            sql = "UPDATE [Photos] SET [Name] = '" + Name + "',[Description] = '" + Description + "',[IsActive] = '" + IsActive + "',SortNo='" + SortNo + "',GroupName='" + groupname + "',ImageUrl='" + Imageurl + "',Creationdate='" + DateTime.Now.ToString() + "',AlbumId='" + AlbumId + "' where PhotoId='" + PhotoId + "'";

        }
        else
        {
            sql = "INSERT INTO [Photos] ([Name],[Description],[IsActive],[Creationdate],[sortno],[GroupName],[AlbumId],[ImageUrl]) values('" + Name + "','" + Description + "','" + IsActive + "','" + DateTime.Now.ToString() + "','" + SortNo + "','" + groupname + "','" + AlbumId + "','" + Imageurl + "')";

        }

        try
        {
            SqlHelper.ExecuteScalar(sql);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string setEvent(string EventId, string ArticleId, string Name, string Description, string IsActive, string SortNo, string groupname, string Imageurl)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if (EventId != "")
        {
            sql = "UPDATE [Events] SET [Name] = '" + Name + "',[Description] = '" + Description + "',[IsActive] = '" + IsActive + "',SortNo='" + SortNo + "',GroupName='" + groupname + "',ImageUrl='" + Imageurl + "',DateCreated='" + DateTime.Now.ToString() + "',ArticleId='" + ArticleId + "' where EventId='" + EventId + "'";

        }
        else
        {
            sql = "INSERT INTO [Events] ([Name],[Description],[IsActive],[DateCreated],[sortno],[GroupName],[ArticleId],[ImageUrl]) values('" + Name + "','" + Description + "','" + IsActive + "','" + DateTime.Now.ToString() + "','" + SortNo + "','" + groupname + "','" + ArticleId + "','" + Imageurl + "')";

        }

        try
        {
            SqlHelper.ExecuteScalar(sql);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }
    public string deletephoto(string did)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from Photos  where PhotoId='" + did + "'";



        try
        {
            SqlHelper.ExecuteScalar(sql);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string deleteEvent(string did)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from Events  where EventId='" + did + "'";



        try
        {
            SqlHelper.ExecuteScalar(sql);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string deletealbum(string did)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from Albums  where AlbumId=@AlbumId";

        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@AlbumId", did);

        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }



    public string deletefaculty(string fid)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from tblFaculty  where FacultyId=@FacultyId";

        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@FacultyId", fid);

        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }


    public string deleteholiday(string hid)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from tblHoliday  where HolidayId=@HolidayId";

        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@HolidayId", hid);

        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }





    public DataTable displaymedia()
    {
        DataTable dt = new DataTable();
        string sql = "select [AlbumId],[Name],[Description],[IsPublic],[DateCreated],[sortno]  from VideoAlbums ORDER BY [sortno] DESC";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];


        return dt;
    }





    public string displayvideoalbum()
    {
        DataTable dt = new DataTable();
        string sql = "select [AlbumId],[Name],[Description],[IsPublic],[DateCreated],[sortno],(SELECT TOP 1  IMAGE FROM Videos WHERE ALBUMID=[VideoAlbums].ALBUMID) AS Media  from VideoAlbums ORDER BY [sortno] DESC";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        MyWebRequest web = new MyWebRequest();

        return web.DataTableToJSON(dt);
    }


    public string setvideoalbum(string AlbumId, string Name, string Description, string IsPublic, string SortNo)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if (AlbumId != "")
        {
            sql = "UPDATE [VideoAlbums] SET [Name] = @Name,[Description] = @Description,[IsPublic] = @IsPublic,[sortno]=@sortno where AlbumId=@AlbumId";

        }
        else
        {
            sql = "INSERT INTO [VideoAlbums] ([Name],[Description],[IsPublic],[DateCreated],[sortno]) values(@Name,@Description,@IsPublic,getdate(),@sortno)";

        }
        SqlParameter[] p = new SqlParameter[5];
        p[0] = new SqlParameter("@AlbumId", AlbumId);

        p[1] = new SqlParameter("@Name", Name);
        p[2] = new SqlParameter("@Description", Description);

        p[3] = new SqlParameter("@IsPublic", IsPublic);
        p[4] = new SqlParameter("@sortno", SortNo);
        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string deletevideoalbum(string did)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from VideoAlbums  where AlbumId=@AlbumId";

        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@AlbumId", did);

        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }




    public DataTable getvideo()
    {
        DataTable dt = new DataTable();
        string sql = "SELECT  Videos.* FROM Videos inner join VideoAlbums on Videos.AlbumId=VideoAlbums.AlbumId   ORDER BY [sortno] DESC";
        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        return dt;
    }



    public string setvideo(string VideoId, string AlbumId, string Name, string Description, string IsActive, string SortNo, string groupname, string Imageurl)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if (VideoId != "")
        {
            sql = "UPDATE [Videos] SET [Name] = '" + Name + "',[Description] = '" + Description + "',[IsPublic] = '" + IsActive + "',SortNo='" + SortNo + "',GroupName='" + groupname + "',VideoUrl='" + Imageurl + "',DateCreated='" + DateTime.Now.ToString() + "',AlbumId='" + AlbumId + "' where VideoId='" + VideoId + "'";

        }
        else
        {
            sql = "INSERT INTO [Videos] ([Name],[Description],[IsActive],[sortno],[GroupName],[AlbumId],[VideoUrl]) values('" + Name + "','" + Description + "','" + IsActive + "','" + SortNo + "','" + groupname + "','" + AlbumId + "','" + Imageurl + "')";

        }

        try
        {
            SqlHelper.ExecuteScalar(sql);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string deletevideo(string did)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from Videos  where VideoId='" + did + "'";



        try
        {
            SqlHelper.ExecuteScalar(sql);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public DataTable getdownload()
    {
        DataTable dt = new DataTable();
        //string sql = "select [DownloadID],[DownloadType],[Download_Text],[Download_Description],[IsPublic],[IsActive],[IsDelete],[DateCreated],[DateModified],[UploadFilePath]  from Downloads ORDER BY [DownloadID]";

        string sql = "select [DownloadID],[DownloadType],[Download_Text],[Download_Description],[IsPublic],[IsActive],[IsDelete],[DateCreated],[DateModified],[UploadFilePath]  from Downloads ORDER BY [DownloadID]";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        MyWebRequest web = new MyWebRequest();

        return dt;
    }
    public string setdownload(string DownloadID, string DownloadType, string Download_Text, string Download_Description, string IsPublic, string IsActive, string IsDelete, string UploadFilePath)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if (DownloadID != "")
        {
            sql = "UPDATE [Downloads] SET [DownloadType]=@DownloadType, [Download_Text] = @Download_Text,[Download_Description] = @Download_Description,[IsPublic] = @IsPublic,[IsActive] = @IsActive,[IsDelete] = @IsDelete,DateModified=getdate(),UploadFilePath=@UploadFilePath where DownloadID=@DownloadID";

        }
        else
        {
            sql = "INSERT INTO [Downloads] ([DownloadType],[Download_Text],[Download_Description],[IsPublic],[IsActive],[IsDelete],[DateCreated],[DateModified],[UploadFilePath]) values(@DownloadType,@Download_Text,@Download_Description,@IsPublic,@IsActive,@IsDelete,getdate(),getdate(),@UploadFilePath)";

        }
        SqlParameter[] p = new SqlParameter[8];
        p[0] = new SqlParameter("@DownloadID", DownloadID);
        p[1] = new SqlParameter("@DownloadType", DownloadType);
        p[2] = new SqlParameter("@Download_Text", Download_Text);
        p[3] = new SqlParameter("@Download_Description", Download_Description);

        p[4] = new SqlParameter("@IsPublic", IsPublic);
        p[5] = new SqlParameter("@IsActive", IsActive);
        p[6] = new SqlParameter("@IsDelete", IsDelete);

        p[7] = new SqlParameter("@UploadFilePath", UploadFilePath);
        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string deletedownload(string did)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from Downloads  where DownloadID=@DownloadID";

        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@DownloadID", did);

        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public DataTable displayslider( string stype)
    {
        DataTable dt = new DataTable();
        //string sql = "select [SliderID],[SliderType],[Slider_Text],[Slider_Description],[IsPublic],[IsActive],[IsDelete],[DateCreated],[DateModified],[UploadFilePath]  from Sliders ORDER BY [SliderID]";

        string sql = "select [SliderID],[SliderType],[Slider_Text],[Slider_Description],[IsPublic],[IsActive],[IsDelete],[DateCreated],[DateModified],[UploadFilePath]  from Sliders where SliderType='"+stype+"'  ORDER BY [SliderID]";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        MyWebRequest web = new MyWebRequest();

        return dt;
    }

    public DataTable getslider()
    {
        DataTable dt = new DataTable();
        //string sql = "select [SliderID],[SliderType],[Slider_Text],[Slider_Description],[IsPublic],[IsActive],[IsDelete],[DateCreated],[DateModified],[UploadFilePath]  from Sliders ORDER BY [SliderID]";

        string sql = "select [SliderID],[SliderType],[Slider_Text],[Slider_Description],[IsPublic],[IsActive],[IsDelete],[DateCreated],[DateModified],[UploadFilePath]  from Sliders ORDER BY [SliderID]";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        MyWebRequest web = new MyWebRequest();

        return dt;
    }
    public string setslider(string SliderID, string SliderType, string Slider_Text, string Slider_Description, string IsPublic, string IsActive, string IsDelete, string UploadFilePath)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if (SliderID != "")
        {
            sql = "UPDATE [Sliders] SET [SliderType]=@SliderType, [Slider_Text] = @Slider_Text,[Slider_Description] = @Slider_Description,[IsPublic] = @IsPublic,[IsActive] = @IsActive,[IsDelete] = @IsDelete,DateModified=getdate(),UploadFilePath=@UploadFilePath where SliderID=@SliderID";

        }
        else
        {
            sql = "INSERT INTO [Sliders] ([SliderType],[Slider_Text],[Slider_Description],[IsPublic],[IsActive],[IsDelete],[DateCreated],[DateModified],[UploadFilePath]) values(@SliderType,@Slider_Text,@Slider_Description,@IsPublic,@IsActive,@IsDelete,getdate(),getdate(),@UploadFilePath)";

        }
        SqlParameter[] p = new SqlParameter[8];
        p[0] = new SqlParameter("@SliderID", SliderID);
        p[1] = new SqlParameter("@SliderType", SliderType);
        p[2] = new SqlParameter("@Slider_Text", Slider_Text);
        p[3] = new SqlParameter("@Slider_Description", Slider_Description);

        p[4] = new SqlParameter("@IsPublic", IsPublic);
        p[5] = new SqlParameter("@IsActive", IsActive);
        p[6] = new SqlParameter("@IsDelete", IsDelete);

        p[7] = new SqlParameter("@UploadFilePath", UploadFilePath);
        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string deleteslider(string did)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from Sliders  where SliderID=@SliderID";

        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@DownloadID", did);

        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string displaytopic()
    {
        DataTable dt = new DataTable();
        string sql = "SELECT TopicId,TopicName ,LastPostTitle,LastPostUserName,LastPostDateTime,IsPublic FROM [Topics]";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        MyWebRequest web = new MyWebRequest();

        return web.DataTableToJSON(dt);
    }


    public string settopic(string TopicId, string TopicName, string IsPublic)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";
        if (TopicId != "")
        {
            sql = "UPDATE [Topics] SET [TopicName] = @TopicName,IsPublic=@IsPublic WHERE [TopicId]=@TopicId";

        }
        else
        {
            sql = "INSERT INTO [Topics] ([TopicName],[IsPublic]) VALUES (@TopicName,@IsPublic)";

        }
        SqlParameter[] p = new SqlParameter[3];
        p[0] = new SqlParameter("@TopicId", TopicId);
        p[1] = new SqlParameter("@TopicName", TopicName);


        p[2] = new SqlParameter("@IsPublic", IsPublic);
        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record updated";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }

    public string deletetopic(string did)
    {
        DataTable dt = new DataTable();
        string msg = "";
        string sql = "";

        sql = "delete from Topics  where TopicId=@TopicId";

        SqlParameter[] p = new SqlParameter[1];
        p[0] = new SqlParameter("@TopicId", did);

        try
        {
            SqlHelper.ExecuteScalar(sql, p);
            msg = "Record Deleted";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }

        return msg;
    }





    public string getlogin(string userid, string password)
    {
        string rs = "0";
        DataTable dt = new DataTable();
        string sql = "SELECT * FROM Admin WHERE (USERNAME = @Name and PASSWORD=@Password)";
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Name", userid);
        p[1] = new SqlParameter("@Password", password);
        DataSet ds = SqlHelper.ExecuteDataSet(sql, p);

        dt = ds.Tables[0];
        if (dt.Rows.Count > 0)
        {
            HttpContext.Current.Response.Cookies["mname"].Value = userid;
            HttpContext.Current.Response.Cookies["mname"].Expires = DateTime.Now.AddHours(1);
            // HttpContext.Current.Session["mname"] = userid;
            rs = "1";
        }
        else
        {
            rs = "Your User Name or Password has wrong!";
        }
        return rs;
    }



    public string setpassword(string userid, string oldpassword,string password)
    {
        string rs = "0";
        DataTable dt = new DataTable();
        string sql = "SELECT * FROM Admin WHERE (USERNAME = @Name and PASSWORD=@Password)";
        SqlParameter[] p = new SqlParameter[2];
        p[0] = new SqlParameter("@Name", userid);
        p[1] = new SqlParameter("@Password", oldpassword);
        DataSet ds = SqlHelper.ExecuteDataSet(sql, p);

        dt = ds.Tables[0];
        if (dt.Rows.Count > 0)
        {
            string sql1 = "update Admin set  PASSWORD=@Password WHERE (USERNAME = @Name)";
            SqlParameter[] p1 = new SqlParameter[2];
            p1[0] = new SqlParameter("@Name", userid);
            p1[1] = new SqlParameter("@Password", password);
            SqlHelper.ExecuteScalar(sql1, p1);
            rs = "Password has been reset sucessfully";
        }
        else
        {
            rs = "Your old Password is wrong!";
        }
        return rs;
    }

    public string SaveOrder(string Name, string AName, string FName, string MName, string Address, string Book, string Price, string Mobile, string Email, string MB, string AB)
    {
        //return Name + AName + FName + MName + Address + Book + Price + Mobile + Email + MB + AB;

      
        string sql = "";

        string msg = "";
        sql = "INSERT INTO [sanskriti].[dbo].[Order_Book] ([Name] ,[AName] ,[FName] ,[MName] ,[Address] ,[Book] ,[Price] ,[Mobile] ,[Email] ,[MotiveBook] ,[AboutBook] ,[OrderDate]) VALUES (@Name ,@AName ,@FName ,@MName ,@Address ,@Book ,@Price ,@Mobile ,@Email ,@MotiveBook ,@AboutBook ,@OrderDate)";

        SqlParameter[] p = new SqlParameter[12];
        p[0] = new SqlParameter("@Name", Name);
        p[1] = new SqlParameter("@AName", AName);
        p[2] = new SqlParameter("@FName",FName);
        p[3] = new SqlParameter("@MName",MName);
        p[4] = new SqlParameter("@Address",Address);
        p[5] = new SqlParameter("@Book",Book);
        p[6] = new SqlParameter("@Price", Price);
        p[7] = new SqlParameter("@Mobile",Mobile);
        p[8] = new SqlParameter("@Email", Email);
        p[9] = new SqlParameter("@MotiveBook", MB);
        p[10] = new SqlParameter("@AboutBook",AB);
        p[11] = new SqlParameter("@OrderDate", DateTime.Now);
      


   
        try
        {
            SqlHelper.ExecuteNonQuery(sql, p);
            msg = "Request Sent Sucessfully";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }
        return msg;
    }

    public int getnextid()
    {
        int id = 0;

        string strQuery = "SELECT case when (select COUNT(1) from Order_Book)=0 then 1 else IDENT_CURRENT('Order_Book')+1 end AS Current_Identity";
    
       
        id =Convert.ToInt32((object)  SqlHelper.ExecuteScalar(strQuery));
        return id;
    }




    public string checkSmsDay(string memberid, string mobile,string type)
    {
        string rs = "1";
        DataTable dt = new DataTable();
        string sql = "SELECT * FROM SMSTBL WHERE (MEMBERID = @MEMBERID and MOBILE=@MOBILE AND SMSTYPE=@SMSTYPE AND (convert(date,SMSDATE,103)=convert(date,getdate(),103)))";
        SqlParameter[] p = new SqlParameter[3];
        p[0] = new SqlParameter("@MEMBERID", memberid);
        p[1] = new SqlParameter("@MOBILE", mobile);
        p[2] = new SqlParameter("@SMSTYPE", type);
        DataSet ds = SqlHelper.ExecuteDataSet(sql, p);

        dt = ds.Tables[0];
        if (dt.Rows.Count > 0)
        {
           
            rs = "0";
        }
        else
        {
            rs = "1";
        }
        return rs;
    }


    public string InsertSMS(string mid, string mname, string type, string mobile, string date, string issent, string senttime)
    {
        //return Name + AName + FName + MName + Address + Book + Price + Mobile + Email + MB + AB;


        string sql = "";

        string msg = "";
        sql = "INSERT INTO [SMSTBL] ([MEMBERID],[MEMBERNAME],[SMSTYPE],[MOBILE],[SMSDATE],[ISSENT],[SENTTIME]) VALUES (@MEMBERID,@MEMBERNAME,@SMSTYPE,@MOBILE,@SMSDATE,@ISSENT,@SENTTIME)";

        SqlParameter[] p = new SqlParameter[7];
        p[0] = new SqlParameter("@MEMBERID", mid);
        p[1] = new SqlParameter("@MEMBERNAME", mname);
        p[2] = new SqlParameter("@SMSTYPE", type);
        p[3] = new SqlParameter("@MOBILE", mobile);
        p[4] = new SqlParameter("@SMSDATE", date);
        p[5] = new SqlParameter("@ISSENT", issent);
        p[6] = new SqlParameter("@SENTTIME", senttime);
     




        try
        {
            SqlHelper.ExecuteNonQuery(sql, p);
            msg = "Request Sent Sucessfully";
        }
        catch (Exception ex)
        {

            msg = ex.Message;
        }
        return msg;
    }


    public DataTable getholiday()
    {
        DataTable dt = new DataTable();
        string sql = "select [HolidayId],[HolidayType],[HolidayTitle],[Holiday_Description],[HolidayDate],[IsVisible],[IsActive],[HolidayUrl],[DateCreated],[DateModified] from [tblHoliday] ORDER BY [HolidayId]";

        DataSet ds = SqlHelper.ExecuteDataSet(sql);

        dt = ds.Tables[0];
        return dt;


    }

}

Youez - 2016 - github.com/yon3zu
LinuXploit