�����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 :  C:/Websites/JU_REPLICA_UNIV/App_Code/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : C:/Websites/JU_REPLICA_UNIV/App_Code/ApplicationData.cs

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Common;
using Business;

using System.Data.SqlClient;

using System.Runtime.Serialization;
using Business.Model;
using DataAccessHandler;


//using Microsoft.Practices.EnterpriseLibrary.Data;
//using Microsoft.Practices.EnterpriseLibrary.Data.Sql;
namespace DAO
{
    #region academicyear
    namespace DataLayer
    {
        public class ACADEMICYEARDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<ACADEMICYEAR> GetAllACADEMICYEAR()
            {

                string dbCommand = ("spGetACADEMICYEARAll");

                List<ACADEMICYEAR> list = new List<ACADEMICYEAR>();

                try
                {
                    // dbManager.Open();

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, null, out connection))
                    {

                        while (dataReader.Read())
                        {

                            ACADEMICYEAR obj = new ACADEMICYEAR();

                            if (dataReader["ORG_ID"] != DBNull.Value) { obj.ORG_ID = (int)dataReader["ORG_ID"]; }
                            if (dataReader["ACA_YEAR_ID"] != DBNull.Value) { obj.ACA_YEAR_ID = (int)dataReader["ACA_YEAR_ID"]; }
                            if (dataReader["ACADEMIC_YEAR"] != DBNull.Value) { obj.ACADEMIC_YEAR = (string)dataReader["ACADEMIC_YEAR"]; }
                            if (dataReader["SORTORDER"] != DBNull.Value) { obj.SORTORDER = (int)dataReader["SORTORDER"]; }
                            if (dataReader["ISACTIVE"] != DBNull.Value) { obj.ISACTIVE = (bool)dataReader["ISACTIVE"]; }
                            if (dataReader["ISDELETE"] != DBNull.Value) { obj.ISDELETE = (bool)dataReader["ISDELETE"]; }
                            if (dataReader["ISPERMIT"] != DBNull.Value) { obj.ISPERMIT = (bool)dataReader["ISPERMIT"]; }

                            list.Add(obj);

                        }

                    }

                }



                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }

                return list;

            }

            public bool ManageACADEMICYEAR(ACADEMICYEAR ay)
            {
                bool flag = false;

                string dbCommand = ("spManageACADEMICYEAR");
                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("@ORG_ID", ay.ORG_ID, DbType.Int32));
                parameters.Add(dbManager.CreateParameter("@ACA_YEAR_ID", ay.ACA_YEAR_ID, DbType.Int32));
                parameters.Add(dbManager.CreateParameter("@ACADEMIC_YEAR", ay.ACADEMIC_YEAR, DbType.String));
                parameters.Add(dbManager.CreateParameter("@SORTORDER", ay.SORTORDER, DbType.String));
                parameters.Add(dbManager.CreateParameter("@ISACTIVE", ay.ISACTIVE, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("@ISDELETE", ay.ISDELETE, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("@ISPERMIT", ay.ISPERMIT, DbType.Boolean));

                try
                {
                    object s = dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray());
                    if (s != null && s != DBNull.Value)
                    {
                        flag = true;

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;




            }
        }
    }

    #endregion

    #region SHIFT
    namespace DataLayer
    {
        public class SHIFTDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<SHIFT> GetAllSHIFT()
            {

                string dbCommand = ("spGetSHIFTAll");

                List<SHIFT> list = new List<SHIFT>();

                try
                {
                    // dbManager.Open();

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, null, out connection))
                    {

                        while (dataReader.Read())
                        {

                            SHIFT obj = new SHIFT();

                            if (dataReader["ORG_ID"] != DBNull.Value) { obj.ORG_ID = (int)dataReader["ORG_ID"]; }
                            if (dataReader["ACA_YEAR_ID"] != DBNull.Value) { obj.ACA_YEAR_ID = (int)dataReader["ACA_YEAR_ID"]; }
                            if (dataReader["SHIFT_ID"] != DBNull.Value) { obj.SHIFT_ID = (int)dataReader["SHIFT_ID"]; }
                            if (dataReader["SHIFT_NAME"] != DBNull.Value) { obj.SHIFT_NAME = (string)dataReader["SHIFT_NAME"]; }
                            if (dataReader["SHIFT_FROM"] != DBNull.Value) { obj.SHIFT_FROM = (string)dataReader["SHIFT_FROM"]; }
                            if (dataReader["SHIFT_TO"] != DBNull.Value) { obj.SHIFT_TO = (string)dataReader["SHIFT_TO"]; }
                            if (dataReader["SORTORDER"] != DBNull.Value) { obj.SORTORDER = (int)dataReader["SORTORDER"]; }
                            if (dataReader["ISACTIVE"] != DBNull.Value) { obj.ISACTIVE = (bool)dataReader["ISACTIVE"]; }
                            if (dataReader["ISDELETE"] != DBNull.Value) { obj.ISDELETE = (bool)dataReader["ISDELETE"]; }
                            if (dataReader["ISPERMIT"] != DBNull.Value) { obj.ISPERMIT = (bool)dataReader["ISPERMIT"]; }

                            list.Add(obj);

                        }

                    }

                }



                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }

                return list;

            }

            public bool ManageSHIFT(SHIFT sh)
            {
                bool flag = false;

                string dbCommand = ("spManageSHIFT");
                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("@ORG_ID", sh.ORG_ID, DbType.Int32));
                parameters.Add(dbManager.CreateParameter("@ACA_YEAR_ID", sh.ACA_YEAR_ID, DbType.Int32));
                parameters.Add(dbManager.CreateParameter("@SHIFT_ID", sh.SHIFT_ID, DbType.Int32));
                parameters.Add(dbManager.CreateParameter("@SHIFT_NAME", sh.SHIFT_NAME, DbType.String));
                parameters.Add(dbManager.CreateParameter("@SHIFT_FROM", sh.SHIFT_FROM, DbType.String));
                parameters.Add(dbManager.CreateParameter("@SHIFT_TO", sh.SHIFT_TO, DbType.String));
                parameters.Add(dbManager.CreateParameter("@SORTORDER", sh.SORTORDER, DbType.String));
                parameters.Add(dbManager.CreateParameter("@ISACTIVE", sh.ISACTIVE, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("@ISDELETE", sh.ISDELETE, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("@ISPERMIT", sh.ISPERMIT, DbType.Boolean));

                try
                {
                    object s = dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray());
                    if (s != null && s != DBNull.Value)
                    {
                        flag = true;

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;




            }
        }
    }

    #endregion

    #region registration_process
    #region  applicant_regdetails

    namespace DataLayer
    {
        public class tbl_Appfrm_RegDetailDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_Appfrm_RegDetail> GetAlltbl_Appfrm_RegDetail()
            {

                string dbCommand = ("spGettbl_Appfrm_RegDetailAll");

                List<tbl_Appfrm_RegDetail> list = new List<tbl_Appfrm_RegDetail>();
                try
                {
                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, null, out connection))
                    {


                        while (dataReader.Read())
                        {

                            tbl_Appfrm_RegDetail obj = new tbl_Appfrm_RegDetail();

                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["AdvtNo"] != DBNull.Value) { obj.AdvtNo = (string)dataReader["AdvtNo"]; }
                            if (dataReader["PostCode"] != DBNull.Value) { obj.PostCode = (string)dataReader["PostCode"]; }
                            if (dataReader["AppliedProgram"] != DBNull.Value) { obj.AppliedProgram = (string)dataReader["AppliedProgram"]; }
                            if (dataReader["Gender"] != DBNull.Value) { obj.Gender = (string)dataReader["Gender"]; }
                            if (dataReader["FullName"] != DBNull.Value) { obj.FullName = (string)dataReader["FullName"]; }
                            if (dataReader["FatherName"] != DBNull.Value) { obj.FatherName = (string)dataReader["FatherName"]; }

                            if (dataReader["dob"] != DBNull.Value) { obj.dob = (string)dataReader["dob"]; }
                            if (dataReader["Category"] != DBNull.Value) { obj.Category = (string)dataReader["Category"]; }
                            if (dataReader["Ph"] != DBNull.Value) { obj.Ph = (bool)dataReader["Ph"]; }
                            if (dataReader["PhType"] != DBNull.Value) { obj.PhType = (string)dataReader["PhType"]; }
                            if (dataReader["Mobile"] != DBNull.Value) { obj.Mobile = (string)dataReader["Mobile"]; }
                            if (dataReader["IsMobileVerified"] != DBNull.Value) { obj.IsMobileVerified = (bool)dataReader["IsMobileVerified"]; }
                            if (dataReader["Email"] != DBNull.Value) { obj.Email = (string)dataReader["Email"]; }
                            if (dataReader["IsEmailVerified"] != DBNull.Value) { obj.IsEmailVerified = (bool)dataReader["IsEmailVerified"]; }
                            if (dataReader["IsStepComplete"] != DBNull.Value) { obj.IsStepComplete = (bool)dataReader["IsStepComplete"]; }
                            if (dataReader["RegistrationDate"] != DBNull.Value) { obj.RegistrationDate = (DateTime)dataReader["RegistrationDate"]; }
                            if (dataReader["Domicile"] != DBNull.Value) { obj.Domicile = (string)dataReader["Domicile"]; }
                            if (dataReader["EnrollNo"] != DBNull.Value) { obj.EnrollNo = (string)dataReader["EnrollNo"]; }
                            if (dataReader["JUWard"] != DBNull.Value) { obj.JUWard = (string)dataReader["JUWard"]; }
                            list.Add(obj);

                        }

                    }
                }
                catch
                {

                }
                finally
                {
                    dbManager.CloseConnection(connection);
                }

                return list;

            }


            public List<tbl_Appfrm_RegDetail> GetAlltbl_Appfrm_RegDetailByRegNo(string RegNo)
            {

                string dbCommand = ("spGettbl_Appfrm_RegDetailByRegNo");

                List<tbl_Appfrm_RegDetail> list = new List<tbl_Appfrm_RegDetail>();

                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("@RegNo", RegNo, DbType.String));

                try
                {
                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {


                        while (dataReader.Read())
                        {

                            tbl_Appfrm_RegDetail obj = new tbl_Appfrm_RegDetail();

                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["AdvtNo"] != DBNull.Value) { obj.AdvtNo = (string)dataReader["AdvtNo"]; }
                            if (dataReader["PostCode"] != DBNull.Value) { obj.PostCode = (string)dataReader["PostCode"]; }
                            if (dataReader["AppliedProgram"] != DBNull.Value) { obj.AppliedProgram = (string)dataReader["AppliedProgram"]; }
                            if (dataReader["AppliedPost"] != DBNull.Value) { obj.AppliedPost = (string)dataReader["AppliedPost"]; }
                            if (dataReader["Gender"] != DBNull.Value) { obj.Gender = (string)dataReader["Gender"]; }
                            if (dataReader["FullName"] != DBNull.Value) { obj.FullName = (string)dataReader["FullName"]; }
                            if (dataReader["FatherName"] != DBNull.Value) { obj.FatherName = (string)dataReader["FatherName"]; }
                            if (dataReader["MotherName"] != DBNull.Value) { obj.MotherName = (string)dataReader["MotherName"]; }
                            if (dataReader["dob"] != DBNull.Value) { obj.dob = (string)dataReader["dob"]; }
                            if (dataReader["Category"] != DBNull.Value) { obj.Category = (string)dataReader["Category"]; }
                            if (dataReader["Ph"] != DBNull.Value) { obj.Ph = (bool)dataReader["Ph"]; }
                            if (dataReader["PhType"] != DBNull.Value) { obj.PhType = (string)dataReader["PhType"]; }
                            if (dataReader["Mobile"] != DBNull.Value) { obj.Mobile = (string)dataReader["Mobile"]; }
                            if (dataReader["IsMobileVerified"] != DBNull.Value) { obj.IsMobileVerified = (bool)dataReader["IsMobileVerified"]; }
                            if (dataReader["Email"] != DBNull.Value) { obj.Email = (string)dataReader["Email"]; }
                            if (dataReader["IsEmailVerified"] != DBNull.Value) { obj.IsEmailVerified = (bool)dataReader["IsEmailVerified"]; }
                            if (dataReader["IsStepComplete"] != DBNull.Value) { obj.IsStepComplete = (bool)dataReader["IsStepComplete"]; }
                            if (dataReader["RegistrationDate"] != DBNull.Value) { obj.RegistrationDate = (DateTime)dataReader["RegistrationDate"]; }
                            if (dataReader["photo"] != DBNull.Value) { obj.Photo = (string)dataReader["photo"]; }
                            if (dataReader["CategoryCode"] != DBNull.Value) { obj.CategoryCode = (string)dataReader["CategoryCode"]; }
                            if (dataReader["Domicile"] != DBNull.Value) { obj.Domicile = (string)dataReader["Domicile"]; }
                            if (dataReader["Nationality"] != DBNull.Value) { obj.Nationality = (string)dataReader["Nationality"]; }
                            if (dataReader["ABCID"] != DBNull.Value) { obj.ABCID = (string)dataReader["ABCID"]; }
                            if (dataReader["DEBID"] != DBNull.Value) { obj.DEBID = (string)dataReader["DEBID"]; }
                            if (dataReader["EnrollNo"] != DBNull.Value) { obj.EnrollNo = (string)dataReader["EnrollNo"]; }
                            if (dataReader["JUWard"] != DBNull.Value) { obj.JUWard = (string)dataReader["JUWard"]; }
                            if (dataReader["UIDID"] != DBNull.Value) { obj.UIDID = (string)dataReader["UIDID"]; }

                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;

            }
            public bool IsApplicantNotExistsEmail(string ackemail, string post)
            {


                bool flag = true;
                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("@Email", ackemail, DbType.String));
                parameters.Add(dbManager.CreateParameter("@AppliedProgram", post, DbType.String));

                try
                {
                    object s = dbManager.GetScalarValue("Usp_IfExistsApplicantEmail", CommandType.StoredProcedure, parameters.ToArray());

                    if (s != null && s != DBNull.Value)
                    {
                        flag = false;

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }

                return flag;

            }

            public string ApplicantPasswordUpdate(string ackemail, string newpassword, string post)
            {


                string flag = "";

                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("@Email", ackemail, DbType.String));
                parameters.Add(dbManager.CreateParameter("@Password", newpassword, DbType.String));
                parameters.Add(dbManager.CreateParameter("@Post", post, DbType.String));




                try
                {

                    object s = dbManager.GetScalarValue("Usp_UpdateApplicantPassword", CommandType.StoredProcedure, parameters.ToArray());

                    if (s != null && s != DBNull.Value)
                    {
                        flag = s.ToString();

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }
            public bool IsApplicantNotExistsMobile(string ackemail, string post)
            {


                bool flag = true;
                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("@Mobile", ackemail, DbType.String));
                parameters.Add(dbManager.CreateParameter("@AppliedProgram", post, DbType.String));

                try
                {
                    object s = dbManager.GetScalarValue("Usp_IfExistsApplicantMobile", CommandType.StoredProcedure, parameters.ToArray());


                    if (s != null && s != DBNull.Value)
                    {
                        flag = false;

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }



            public string Managetbl_Appfrm_RegDetail(tbl_Appfrm_RegDetail reg)
            {

                string dbCommand = ("spManagetbl_Appfrm_RegDetail");
                var parameters = new List<IDbDataParameter>();


                parameters.Add(dbManager.CreateParameter("RegNo", reg.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("AdvtNo", reg.AdvtNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("PostCode", reg.PostCode, DbType.String));
                parameters.Add(dbManager.CreateParameter("AppliedProgram", reg.AppliedProgram, DbType.String));
                parameters.Add(dbManager.CreateParameter("Gender", reg.Gender, DbType.String));
                parameters.Add(dbManager.CreateParameter("FullName", reg.FullName, DbType.String));
                parameters.Add(dbManager.CreateParameter("FatherName", reg.FatherName, DbType.String));
                parameters.Add(dbManager.CreateParameter("MotherName", reg.MotherName, DbType.String));
                parameters.Add(dbManager.CreateParameter("dob", reg.dob, DbType.String));
                parameters.Add(dbManager.CreateParameter("Category", reg.Category, DbType.String));
                parameters.Add(dbManager.CreateParameter("Ph", reg.Ph, DbType.String));
                parameters.Add(dbManager.CreateParameter("PhType", reg.PhType, DbType.String));
                parameters.Add(dbManager.CreateParameter("Mobile", reg.Mobile, DbType.String));
                parameters.Add(dbManager.CreateParameter("IsMobileVerified", reg.IsMobileVerified, DbType.String));
                parameters.Add(dbManager.CreateParameter("Email", reg.Email, DbType.String));
                parameters.Add(dbManager.CreateParameter("IsEmailVerified", reg.IsEmailVerified, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("IsStepComplete", reg.IsStepComplete, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("RegistrationDate", reg.RegistrationDate, DbType.DateTime));
                parameters.Add(dbManager.CreateParameter("Domicile", reg.Domicile, DbType.String));
               parameters.Add(dbManager.CreateParameter("Nationality", reg.Nationality, DbType.String));
                parameters.Add(dbManager.CreateParameter("DEBID", reg.DEBID, DbType.String));
                parameters.Add(dbManager.CreateParameter("ABCID", reg.ABCID, DbType.String));
                parameters.Add(dbManager.CreateParameter("EnrollNo", reg.EnrollNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("JUWard", reg.JUWard, DbType.String));
                parameters.Add(dbManager.CreateParameter("UIDID", reg.UIDID, DbType.String));

                string flag = "";
                try
                {
                    flag = Convert.ToString(dbManager.GetScalarValue(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));

                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;
            }


        }
    }

    #endregion

    #region applicant_login

    namespace DataLayer
    {
        public class tbl_Appfrm_LogInDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_Appfrm_LogIn> GetAlltbl_Appfrm_LogIn()
            {

                string dbCommand = ("spGettbl_Appfrm_LogInAll");

                List<tbl_Appfrm_LogIn> list = new List<tbl_Appfrm_LogIn>();


                try
                {
                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, null, out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Appfrm_LogIn obj = new tbl_Appfrm_LogIn();

                            if (dataReader["LID"] != DBNull.Value) { obj.LID = (int)dataReader["LID"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["Password"] != DBNull.Value) { obj.Password = (string)dataReader["Password"]; }
                            if (dataReader["UserName"] != DBNull.Value) { obj.UserName = (string)dataReader["UserName"]; }
                            if (dataReader["EmailId"] != DBNull.Value) { obj.EmailId = (string)dataReader["EmailId"]; }
                            if (dataReader["MobileNo"] != DBNull.Value) { obj.MobileNo = (string)dataReader["MobileNo"]; }
                            if (dataReader["LastLogInTime"] != DBNull.Value) { obj.LastLogInTime = (DateTime)dataReader["LastLogInTime"]; }
                            if (dataReader["Browser"] != DBNull.Value) { obj.Browser = (string)dataReader["Browser"]; }
                            if (dataReader["MacId"] != DBNull.Value) { obj.MacId = (string)dataReader["MacId"]; }
                            if (dataReader["IpAddr"] != DBNull.Value) { obj.IpAddr = (string)dataReader["IpAddr"]; }
                            if (dataReader["LastLagOutTime"] != DBNull.Value) { obj.LastLagOutTime = (DateTime)dataReader["LastLagOutTime"]; }
                            if (dataReader["IsActive"] != DBNull.Value) { obj.IsActive = (bool)dataReader["IsActive"]; }
                            if (dataReader["IsDelete"] != DBNull.Value) { obj.IsDelete = (bool)dataReader["IsDelete"]; }

                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {

                    dbManager.CloseConnection(connection);
                }
                return list;

            }

            public List<tbl_Appfrm_LogIn> GetAlltbl_Appfrm_LogInByRegNoPassword(string reg, string pass, string programcode)
            {

                string dbCommand = ("spGettbl_Appfrm_LogInByRegNoPass");

                List<tbl_Appfrm_LogIn> list = new List<tbl_Appfrm_LogIn>();

                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("RegNo", reg, DbType.String));
                parameters.Add(dbManager.CreateParameter("Password", pass, DbType.String));
                parameters.Add(dbManager.CreateParameter("ProgramCode", programcode, DbType.String));
                try
                {


                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Appfrm_LogIn obj = new tbl_Appfrm_LogIn();

                            if (dataReader["LID"] != DBNull.Value) { obj.LID = (int)dataReader["LID"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["Password"] != DBNull.Value) { obj.Password = (string)dataReader["Password"]; }
                            if (dataReader["UserName"] != DBNull.Value) { obj.UserName = (string)dataReader["UserName"]; }
                            if (dataReader["EmailId"] != DBNull.Value) { obj.EmailId = (string)dataReader["EmailId"]; }
                            if (dataReader["MobileNo"] != DBNull.Value) { obj.MobileNo = (string)dataReader["MobileNo"]; }
                            if (dataReader["LastLogInTime"] != DBNull.Value) { obj.LastLogInTime = (DateTime)dataReader["LastLogInTime"]; }
                            if (dataReader["Browser"] != DBNull.Value) { obj.Browser = (string)dataReader["Browser"]; }
                            if (dataReader["MacId"] != DBNull.Value) { obj.MacId = (string)dataReader["MacId"]; }
                            if (dataReader["IpAddr"] != DBNull.Value) { obj.IpAddr = (string)dataReader["IpAddr"]; }
                            if (dataReader["LastLagOutTime"] != DBNull.Value) { obj.LastLagOutTime = (DateTime)dataReader["LastLagOutTime"]; }
                            if (dataReader["IsActive"] != DBNull.Value) { obj.IsActive = (bool)dataReader["IsActive"]; }
                            if (dataReader["IsDelete"] != DBNull.Value) { obj.IsDelete = (bool)dataReader["IsDelete"]; }

                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    //  dbManager.CloseConnection(connection);
                }
                return list;

            }

            public bool Managetbl_Appfrm_LogIn(tbl_Appfrm_LogIn ln)
            {

                string dbCommand = ("spManagetbl_Appfrm_LogIn");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("LID", ln.LID, DbType.Int32));
                parameters.Add(dbManager.CreateParameter("RegNo", ln.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("Password", ln.Password, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserName", ln.UserName, DbType.String));
                parameters.Add(dbManager.CreateParameter("EmailId", ln.EmailId, DbType.String));
                parameters.Add(dbManager.CreateParameter("MobileNo", ln.MobileNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("LastLogInTime", ln.LastLogInTime, DbType.DateTime));
                parameters.Add(dbManager.CreateParameter("Browser", ln.Browser, DbType.String));
                parameters.Add(dbManager.CreateParameter("MacId", ln.MacId, DbType.String));
                parameters.Add(dbManager.CreateParameter("IpAddr", ln.IpAddr, DbType.String));
                parameters.Add(dbManager.CreateParameter("LastLagOutTime", ln.LastLagOutTime, DbType.DateTime));
                parameters.Add(dbManager.CreateParameter("IsActive", ln.IsActive, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("IsDelete", ln.IsDelete, DbType.Boolean));

                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally { dbManager.CloseConnection(connection); }
                return flag;
            }


            public string ChangePassword(string RegNo, string oldPassword, string newPassword)
            {

                string dbCommand = ("spChangetbl_Appfrm_LogInPass");
                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("RegNo", RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("Password", oldPassword, DbType.String));
                parameters.Add(dbManager.CreateParameter("NewPassword", newPassword, DbType.String));

                string flag = "";
                try
                {

                    flag = Convert.ToString(dbManager.GetScalarValue(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally { dbManager.CloseConnection(connection); }
                return flag;
            }

            public string UpdateLogout(string RegNo)
            {

                string dbCommand = ("sp_Appfrm_UpdateLogout");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("@RegNo", RegNo, DbType.String));



                string flag = "";
                try
                {

                    flag = Convert.ToString(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally { dbManager.CloseConnection(connection); }
                return flag;
            }

        }
    }


    #endregion

    #region applicant_personal

    namespace DataLayer
    {
        public class tbl_Appfrm_PersonalDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_Appfrm_Personal> GetAlltbl_Appfrm_Personal(string regno)
            {

                string dbCommand = ("spGettbl_Appfrm_PersonalAll");

                List<tbl_Appfrm_Personal> list = new List<tbl_Appfrm_Personal>();
                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("@RegNo", regno, DbType.String));

                try
                {


                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Appfrm_Personal obj = new tbl_Appfrm_Personal();

                            if (dataReader["Id"] != DBNull.Value) { obj.Id = (int)dataReader["Id"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["FatherName"] != DBNull.Value) { obj.FatherName = (string)dataReader["FatherName"]; }
                            if (dataReader["MotherName"] != DBNull.Value) { obj.MotherName = (string)dataReader["MotherName"]; }
                            if (dataReader["MaritialStatus"] != DBNull.Value) { obj.MaritialStatus = (string)dataReader["MaritialStatus"]; }
                            if (dataReader["SpouseName"] != DBNull.Value) { obj.SpouseName = (string)dataReader["SpouseName"]; }
                            if (dataReader["Religion"] != DBNull.Value) { obj.Religion = (string)dataReader["Religion"]; }
                            if (dataReader["Natinality"] != DBNull.Value) { obj.Natinality = (string)dataReader["Natinality"]; }
                            if (dataReader["PAddL1"] != DBNull.Value) { obj.PAddL1 = (string)dataReader["PAddL1"]; }
                            if (dataReader["PAddL2"] != DBNull.Value) { obj.PAddL2 = (string)dataReader["PAddL2"]; }
                            if (dataReader["PCity"] != DBNull.Value) { obj.PCity = (string)dataReader["PCity"]; }
                            if (dataReader["PState"] != DBNull.Value) { obj.PState = (string)dataReader["PState"]; }
                            if (dataReader["PPin"] != DBNull.Value) { obj.PPin = (string)dataReader["PPin"]; }
                            if (dataReader["CAddL1"] != DBNull.Value) { obj.CAddL1 = (string)dataReader["CAddL1"]; }
                            if (dataReader["CAddL2"] != DBNull.Value) { obj.CAddL2 = (string)dataReader["CAddL2"]; }
                            if (dataReader["CCity"] != DBNull.Value) { obj.CCity = (string)dataReader["CCity"]; }
                            if (dataReader["CState"] != DBNull.Value) { obj.CState = (string)dataReader["CState"]; }
                            if (dataReader["CPin"] != DBNull.Value) { obj.CPin = (string)dataReader["CPin"]; }
                            if (dataReader["Contact1"] != DBNull.Value) { obj.Contact1 = (string)dataReader["Contact1"]; }
                            if (dataReader["Contact2"] != DBNull.Value) { obj.Contact2 = (string)dataReader["Contact2"]; }
                            if (dataReader["IdName"] != DBNull.Value) { obj.IdName = (string)dataReader["IdName"]; }
                            if (dataReader["IdNumber"] != DBNull.Value) { obj.IdNumber = (string)dataReader["IdNumber"]; }
                            if (dataReader["IdAtt"] != DBNull.Value) { obj.IdAtt = (string)dataReader["IdAtt"]; }

                            if (dataReader["FullName"] != DBNull.Value) { obj.FullName = (string)dataReader["FullName"]; }
                            if (dataReader["Picture"] != DBNull.Value) { obj.Picture = (string)dataReader["Picture"]; }
                            if (dataReader["Sign"] != DBNull.Value) { obj.Sign = (string)dataReader["Sign"]; }
                            if (dataReader["Gender"] != DBNull.Value) { obj.Gender = (string)dataReader["Gender"]; }
                            if (dataReader["dob"] != DBNull.Value) { obj.dob = (string)dataReader["dob"]; }
                            if (dataReader["Category"] != DBNull.Value) { obj.Category = (string)dataReader["Category"]; }
                            if (dataReader["NadId"] != DBNull.Value) { obj.NadId = (string)dataReader["NadId"]; }

                            list.Add(obj);

                        }

                    }
                }
                catch (Exception ex) { System.Web.HttpContext.Current.Response.Write(ex.Message); }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;

            }

            public string Managetbl_Appfrm_Personal(tbl_Appfrm_Personal per)
            {

                string dbCommand = ("spManagetbl_Appfrm_Personal");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("RegNo", per.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("MaritialStatus", per.MaritialStatus, DbType.String));
                parameters.Add(dbManager.CreateParameter("SpouseName", per.SpouseName, DbType.String));

                parameters.Add(dbManager.CreateParameter("Religion", per.Religion, DbType.String));

                parameters.Add(dbManager.CreateParameter("Natinality", per.Natinality, DbType.String));
                parameters.Add(dbManager.CreateParameter("PAddL1", per.PAddL1, DbType.String));
                parameters.Add(dbManager.CreateParameter("PAddL2", per.PAddL2, DbType.String));
                parameters.Add(dbManager.CreateParameter("PCity", per.PCity, DbType.String));
                parameters.Add(dbManager.CreateParameter("PState", per.PState, DbType.String));
                parameters.Add(dbManager.CreateParameter("PPin", per.PPin, DbType.String));
                parameters.Add(dbManager.CreateParameter("CAddL1", per.CAddL1, DbType.String));
                parameters.Add(dbManager.CreateParameter("CAddL2", per.CAddL2, DbType.String));
                parameters.Add(dbManager.CreateParameter("CCity", per.CCity, DbType.String));
                parameters.Add(dbManager.CreateParameter("CState", per.CState, DbType.String));
                parameters.Add(dbManager.CreateParameter("CPin", per.CPin, DbType.String));
                parameters.Add(dbManager.CreateParameter("Contact1", per.Contact1, DbType.String));
                parameters.Add(dbManager.CreateParameter("Contact2", per.Contact2, DbType.String));
                parameters.Add(dbManager.CreateParameter("IdName", per.IdName, DbType.String));
                parameters.Add(dbManager.CreateParameter("IdNumber", per.IdNumber, DbType.String));
                parameters.Add(dbManager.CreateParameter("IdAtt", per.IdAtt, DbType.String));
                parameters.Add(dbManager.CreateParameter("NadId", per.NadId, DbType.String));
                try
                {

                    return (dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray())).ToString();
                }
                catch (Exception ex)
                {

                    return ex.Message;
                }
                finally
                {
                    dbManager.CloseConnection(connection);

                }
            }




        }
    }

    #endregion

    #region applicant_photo

    namespace DataLayer
    {
        public class tbl_Appfrm_PhotosDAO
        {

            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_Appfrm_Photos> GetAlltbl_Appfrm_Photos(string regno)
            {

                string dbCommand = ("spGettbl_Appfrm_PhotosAll");

                List<tbl_Appfrm_Photos> list = new List<tbl_Appfrm_Photos>();
                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("RegNo", regno, DbType.String));
                try
                {
                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Appfrm_Photos obj = new tbl_Appfrm_Photos();

                            if (dataReader["id"] != DBNull.Value) { obj.id = (int)dataReader["id"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["Photo"] != DBNull.Value) { obj.Photo = (string)dataReader["Photo"]; }
                            if (dataReader["Signature"] != DBNull.Value) { obj.Sign = (string)dataReader["Signature"]; }
                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;

            }

            public bool Managetbl_Appfrm_Photos(tbl_Appfrm_Photos ph)
            {

                string dbCommand = ("spManagetbl_Appfrm_Photos");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("id", ph.id, DbType.String));
                parameters.Add(dbManager.CreateParameter("RegNo", ph.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("Photo", ph.Photo, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sign", ph.Sign, DbType.String));

                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch
                {
                    return false;
                }
                finally
                {
                    dbManager.CloseConnection(connection);

                }
                return flag;
            }




        }
    }

    #endregion


    #region applicant_education

    namespace DataLayer
    {
        public class tbl_Appfrm_EducationDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_Appfrm_Education> GetAlltbl_Appfrm_Education(string regno)
            {

                string dbCommand = ("spGettbl_Appfrm_EducationAll");

                List<tbl_Appfrm_Education> list = new List<tbl_Appfrm_Education>();
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("RegNo", regno, DbType.String));
                try
                {
                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Appfrm_Education obj = new tbl_Appfrm_Education();

                            if (dataReader["ID"] != DBNull.Value) { obj.ID = (int)dataReader["ID"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["Education"] != DBNull.Value) { obj.Education = (string)dataReader["Education"]; }
                            if (dataReader["DegreeName"] != DBNull.Value) { obj.DegreeName = (string)dataReader["DegreeName"]; }
                            if (dataReader["Subject"] != DBNull.Value) { obj.Subject = (string)dataReader["Subject"]; }
                            if (dataReader["UniversityName"] != DBNull.Value) { obj.UniversityName = (string)dataReader["UniversityName"]; }
                            if (dataReader["PassingYear"] != DBNull.Value) { obj.PassingYear = (string)dataReader["PassingYear"]; }
                            if (dataReader["MarksObtained"] != DBNull.Value) { obj.MarksObtained = (decimal)dataReader["MarksObtained"]; }
                            if (dataReader["TotalMark"] != DBNull.Value) { obj.TotalMark = (decimal)dataReader["TotalMark"]; }
                            if (dataReader["PersentMarks"] != DBNull.Value) { obj.Percentage = (decimal)dataReader["PersentMarks"]; }
                            if (dataReader["RollNo"] != DBNull.Value) { obj.RollNo = (string)dataReader["RollNo"]; }
                            if (dataReader["CollegeName"] != DBNull.Value) { obj.CollegeName = (string)dataReader["CollegeName"]; }
                            if (dataReader["Status"] != DBNull.Value) { obj.Status = (string)dataReader["Status"]; }
                            if (dataReader["Mode"] != DBNull.Value) { obj.Mode = (string)dataReader["Mode"]; }
                            if (dataReader["Grade"] != DBNull.Value) { obj.Grade = (string)dataReader["Grade"]; }
                            if (dataReader["Stream"] != DBNull.Value) { obj.Stream = (string)dataReader["Stream"]; }
                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;

            }

            public bool Managetbl_Appfrm_Education(tbl_Appfrm_Education edu)
            {

                string dbCommand = ("spManagetbl_Appfrm_Education");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("ID", edu.ID, DbType.String));
                parameters.Add(dbManager.CreateParameter("RegNo", edu.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("Education", edu.Education, DbType.String));
                parameters.Add(dbManager.CreateParameter("DegreeName", edu.DegreeName, DbType.String));
                parameters.Add(dbManager.CreateParameter("Stream", edu.Stream, DbType.String));
                parameters.Add(dbManager.CreateParameter("Subject", edu.Subject, DbType.String));
                parameters.Add(dbManager.CreateParameter("UniversityName", edu.UniversityName, DbType.String));
                parameters.Add(dbManager.CreateParameter("PassingYear", edu.PassingYear, DbType.String));
                parameters.Add(dbManager.CreateParameter("MarksObtained", edu.MarksObtained, DbType.String));
                parameters.Add(dbManager.CreateParameter("TotalMark", edu.TotalMark, DbType.String));
                parameters.Add(dbManager.CreateParameter("Percentage", edu.Percentage, DbType.String));
                parameters.Add(dbManager.CreateParameter("RollNo", edu.RollNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("CollegeName", edu.CollegeName, DbType.String));
                parameters.Add(dbManager.CreateParameter("Status", edu.Status, DbType.String));
                parameters.Add(dbManager.CreateParameter("Mode", edu.Mode, DbType.String));
                parameters.Add(dbManager.CreateParameter("Grade", edu.Grade, DbType.String));
                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;
            }

        }
    }

    #endregion


    #region BindEducationforPHd
    namespace DataLayer
    {
        public class tbl_Appfrm_PHDDAO
        {




            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_Appfrm_PHD> GetAlltbl_Appfrm_PHD(string regno, string programcode)
            {

                string dbCommand = ("spGettbl_Appfrm_PHDAll");

                List<tbl_Appfrm_PHD> list = new List<tbl_Appfrm_PHD>();
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("RegNo", regno, DbType.String));
                parameters.Add(dbManager.CreateParameter("ProgramCode", programcode, DbType.String));
                try
                {
                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Appfrm_PHD obj = new tbl_Appfrm_PHD();

                            if (dataReader["ID"] != DBNull.Value) { obj.ID = (int)dataReader["ID"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["Degree"] != DBNull.Value) { obj.Degree = (string)dataReader["Degree"]; }
                            if (dataReader["CurrentStatus"] != DBNull.Value) { obj.CurrentStatus = (string)dataReader["CurrentStatus"]; }
                            if (dataReader["RegistrationDate"] != DBNull.Value) { obj.RegistrationDate = (string)dataReader["RegistrationDate"]; }
                            if (dataReader["SubmissionDate"] != DBNull.Value) { obj.SubmissionDate = (string)dataReader["SubmissionDate"]; }
                            if (dataReader["AwardDate"] != DBNull.Value) { obj.AwardDate = (string)dataReader["AwardDate"]; }
                            if (dataReader["University"] != DBNull.Value) { obj.University = (string)dataReader["University"]; }
                            if (dataReader["Thesis"] != DBNull.Value) { obj.Thesis = (string)dataReader["Thesis"]; }
                            if (dataReader["Specialization"] != DBNull.Value) { obj.Specialization = (string)dataReader["Specialization"]; }
                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;

            }



            public bool Managetbl_Appfrm_PHD(tbl_Appfrm_PHD phd)
            {

                string dbCommand = ("spManagetbl_Appfrm_PHD");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("ID", phd.ID, DbType.String));
                parameters.Add(dbManager.CreateParameter("RegNo", phd.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("ProgramCode", phd.ProgramCode, DbType.String));
                parameters.Add(dbManager.CreateParameter("Degree", phd.Degree, DbType.String));
                parameters.Add(dbManager.CreateParameter("CurrentStatus", phd.CurrentStatus, DbType.String));
                parameters.Add(dbManager.CreateParameter("RegistrationDate", phd.RegistrationDate, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubmissionDate", phd.SubmissionDate, DbType.String));
                parameters.Add(dbManager.CreateParameter("AwardDate", phd.AwardDate, DbType.String));
                parameters.Add(dbManager.CreateParameter("University", phd.University, DbType.String));
                parameters.Add(dbManager.CreateParameter("Thesis", phd.Thesis, DbType.String));
                parameters.Add(dbManager.CreateParameter("Specialization", phd.Specialization, DbType.String));


                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;
            }







        }
    }


    #endregion

    #region applicant_educationbyprogram

    namespace DataLayer
    {
        public class tbl_Appfrm_EducationByProgramDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_Appfrm_EducationByProgram> GetAlltbl_Appfrm_EducationByProgram(string regno, string progcode)
            {

                string dbCommand = ("spGettbl_Appfrm_EducationAllByProgram");

                List<tbl_Appfrm_EducationByProgram> list = new List<tbl_Appfrm_EducationByProgram>();
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("RegNo", regno, DbType.String));
                parameters.Add(dbManager.CreateParameter("ProgramCode", progcode, DbType.String));
                try
                {

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Appfrm_EducationByProgram obj = new tbl_Appfrm_EducationByProgram();

                            if (dataReader["ID"] != DBNull.Value) { obj.ID = (int)dataReader["ID"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["Education"] != DBNull.Value) { obj.Education = (string)dataReader["Education"]; }
                            if (dataReader["DegreeName"] != DBNull.Value) { obj.DegreeName = (string)dataReader["DegreeName"]; }
                            if (dataReader["Discipline"] != DBNull.Value) { obj.Discipline = (string)dataReader["Discipline"]; }
                            if (dataReader["UniversityName"] != DBNull.Value) { obj.UniversityName = (string)dataReader["UniversityName"]; }
                            if (dataReader["PassingYear"] != DBNull.Value) { obj.PassingYear = (string)dataReader["PassingYear"]; }
                            if (dataReader["MarksObtained"] != DBNull.Value) { obj.MarksObtained = (decimal)dataReader["MarksObtained"]; }
                            if (dataReader["TotalMark"] != DBNull.Value) { obj.TotalMark = (decimal)dataReader["TotalMark"]; }
                            if (dataReader["PersentMarks"] != DBNull.Value) { obj.PersentMarks = (decimal)dataReader["PersentMarks"]; }
                            if (dataReader["DSESubjectScore"] != DBNull.Value) { obj.DSESubjectScore = (decimal)dataReader["DSESubjectScore"]; }
                            if (dataReader["CoreSubjectScore"] != DBNull.Value) { obj.CoreSubjectScore = (decimal)dataReader["CoreSubjectScore"]; }
                            if (dataReader["RollNo"] != DBNull.Value) { obj.RollNo = (string)dataReader["RollNo"]; }
                            if (dataReader["CollegeName"] != DBNull.Value) { obj.CollegeName = (string)dataReader["CollegeName"]; }
                            if (dataReader["SubjectName"] != DBNull.Value) { obj.SubjectName = (string)dataReader["SubjectName"]; }
                            if (dataReader["Status"] != DBNull.Value) { obj.Status = (string)dataReader["Status"]; }
                            if (dataReader["Mode"] != DBNull.Value) { obj.Mode = (string)dataReader["Mode"]; }
                            if (dataReader["Grade"] != DBNull.Value) { obj.Grade = (string)dataReader["Grade"]; }
                            if (dataReader["Attachment1"] != DBNull.Value) { obj.Attachment1 = (string)dataReader["Attachment1"]; }
                            if (dataReader["Attachment2"] != DBNull.Value) { obj.Attachment2 = (string)dataReader["Attachment2"]; }

                            if (dataReader["ProgramName"] != DBNull.Value) { obj.ProgramName = (string)dataReader["ProgramName"]; }
                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;

            }

            public bool Managetbl_Appfrm_EducationByProgram(tbl_Appfrm_EducationByProgram edu)
            {

                string dbCommand = ("spManagetbl_Appfrm_EducationByProgram");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("ID", edu.ID, DbType.String));
                parameters.Add(dbManager.CreateParameter("RegNo", edu.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("ProgramCode", edu.ProgramCode, DbType.String));
                parameters.Add(dbManager.CreateParameter("Education", edu.Education, DbType.String));
                parameters.Add(dbManager.CreateParameter("DegreeName", edu.DegreeName, DbType.String));
                parameters.Add(dbManager.CreateParameter("Discipline", edu.Discipline, DbType.String));
                parameters.Add(dbManager.CreateParameter("UniversityName", edu.UniversityName, DbType.String));
                parameters.Add(dbManager.CreateParameter("PassingYear", edu.PassingYear, DbType.String));
                parameters.Add(dbManager.CreateParameter("MarksObtained", edu.MarksObtained, DbType.String));
                parameters.Add(dbManager.CreateParameter("TotalMark", edu.TotalMark, DbType.String));
                parameters.Add(dbManager.CreateParameter("PersentMarks", edu.PersentMarks, DbType.String));
                parameters.Add(dbManager.CreateParameter("CoreSubjectScore", edu.CoreSubjectScore, DbType.String));
                parameters.Add(dbManager.CreateParameter("DSESubjectScore", edu.DSESubjectScore, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubjectName", edu.SubjectName, DbType.String));
                parameters.Add(dbManager.CreateParameter("RollNo", edu.RollNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("CollegeName", edu.CollegeName, DbType.String));
                parameters.Add(dbManager.CreateParameter("Status", edu.Status, DbType.String));
                parameters.Add(dbManager.CreateParameter("Mode", edu.Mode, DbType.String));
                parameters.Add(dbManager.CreateParameter("Grade", edu.Grade, DbType.String));
             
                parameters.Add(dbManager.CreateParameter("Attachment1", edu.Attachment1, DbType.String));
                parameters.Add(dbManager.CreateParameter("Attachment2", edu.Attachment2, DbType.String));
                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;
            }




        }
    }

    #endregion


    #region applicantotherqual

    namespace DataLayer
    {
        public class tbl_Appfrm_OthersDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;
            public List<tbl_Appfrm_Others> GetAlltbl_Appfrm_Others(string regno)
            {


                string dbCommand = ("spGettbl_Appfrm_OthersAll");

                List<tbl_Appfrm_Others> list = new List<tbl_Appfrm_Others>();
                var parameters = new List<IDbDataParameter>();


                parameters.Add(dbManager.CreateParameter("RegNo", regno, DbType.String));
                try
                {

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {


                        while (dataReader.Read())
                        {

                            tbl_Appfrm_Others obj = new tbl_Appfrm_Others();

                            if (dataReader["ID"] != DBNull.Value) { obj.ID = (int)dataReader["ID"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["SCORENAME"] != DBNull.Value) { obj.SCORENAME = (string)dataReader["SCORENAME"]; }
                            if (dataReader["SCORE"] != DBNull.Value) { obj.SCORE = (string)dataReader["SCORE"]; }
                            if (dataReader["YEAR"] != DBNull.Value) { obj.YEAR = (int)dataReader["YEAR"]; }
                            if (dataReader["RollNo"] != DBNull.Value) { obj.RollNo = (string)dataReader["RollNo"]; }
                            if (dataReader["Other1"] != DBNull.Value) { obj.Other1 = (string)dataReader["Other1"]; }
                            if (dataReader["Other2"] != DBNull.Value) { obj.Other2 = (string)dataReader["Other2"]; }
                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;




            }

            public bool Managetbl_Appfrm_Others(tbl_Appfrm_Others oth)
            {

                string dbCommand = ("spManagetbl_Appfrm_Others");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("ID", oth.ID, DbType.String));
                parameters.Add(dbManager.CreateParameter("RegNo", oth.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("SCORENAME", oth.SCORENAME, DbType.String));
                parameters.Add(dbManager.CreateParameter("SCORE", oth.SCORE, DbType.String));
                parameters.Add(dbManager.CreateParameter("YEAR", oth.YEAR, DbType.String));
                parameters.Add(dbManager.CreateParameter("RollNo", oth.RollNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("Other1", oth.Other1, DbType.String));
                parameters.Add(dbManager.CreateParameter("Other2", oth.Other2, DbType.String));

                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;




            }





        }
    }

    #endregion

    #region applicant_education_subject
    namespace DataLayer
    {
        public class tbl_Appfrm_AppliedSubjectDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_Appfrm_AppliedSubject> GetAlltbl_Appfrm_AppliedSubject(string regno)
            {

                string dbCommand = ("spGettbl_Appfrm_AppliedSubjectAll");

                List<tbl_Appfrm_AppliedSubject> list = new List<tbl_Appfrm_AppliedSubject>();

                var parameters = new List<IDbDataParameter>();


                parameters.Add(dbManager.CreateParameter("RegNo", regno, DbType.String));


                try
                {

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {


                        while (dataReader.Read())
                        {

                            tbl_Appfrm_AppliedSubject obj = new tbl_Appfrm_AppliedSubject();

                            if (dataReader["ID"] != DBNull.Value) { obj.ID = (int)dataReader["ID"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["Education"] != DBNull.Value) { obj.Education = (string)dataReader["Education"]; }
                            if (dataReader["Stream"] != DBNull.Value) { obj.Stream = (string)dataReader["Stream"]; }
                            if (dataReader["SubPhy"] != DBNull.Value) { obj.SubPhy = (string)dataReader["SubPhy"]; }
                            if (dataReader["SubPhyMM"] != DBNull.Value) { obj.SubPhyMM = (decimal)dataReader["SubPhyMM"]; }
                            if (dataReader["SubPhyOM"] != DBNull.Value) { obj.SubPhyOM = (decimal)dataReader["SubPhyOM"]; }
                            if (dataReader["SubPhyP"] != DBNull.Value) { obj.SubPhyP = (decimal)dataReader["SubPhyP"]; }
                            if (dataReader["SubChem"] != DBNull.Value) { obj.SubChem = (string)dataReader["SubChem"]; }
                            if (dataReader["SubChemMM"] != DBNull.Value) { obj.SubChemMM = (decimal)dataReader["SubChemMM"]; }
                            if (dataReader["SubChemOM"] != DBNull.Value) { obj.SubChemOM = (decimal)dataReader["SubChemOM"]; }
                            if (dataReader["SubChemP"] != DBNull.Value) { obj.SubChemP = (decimal)dataReader["SubChemP"]; }
                            if (dataReader["SubMath"] != DBNull.Value) { obj.SubMath = (string)dataReader["SubMath"]; }
                            if (dataReader["SubMathMM"] != DBNull.Value) { obj.SubMathMM = (decimal)dataReader["SubMathMM"]; }
                            if (dataReader["SubMathOM"] != DBNull.Value) { obj.SubMathOM = (decimal)dataReader["SubMathOM"]; }
                            if (dataReader["SubMathP"] != DBNull.Value) { obj.SubMathP = (decimal)dataReader["SubMathP"]; }
                            if (dataReader["SubBio"] != DBNull.Value) { obj.SubBio = (string)dataReader["SubBio"]; }
                            if (dataReader["SubBioMM"] != DBNull.Value) { obj.SubBioMM = (decimal)dataReader["SubBioMM"]; }
                            if (dataReader["SubBioOM"] != DBNull.Value) { obj.SubBioOM = (decimal)dataReader["SubBioOM"]; }
                            if (dataReader["SubBioP"] != DBNull.Value) { obj.SubBioP = (decimal)dataReader["SubBioP"]; }
                            if (dataReader["Sub1"] != DBNull.Value) { obj.Sub1 = (string)dataReader["Sub1"]; }
                            if (dataReader["Sub1MM"] != DBNull.Value) { obj.Sub1MM = (decimal)dataReader["Sub1MM"]; }
                            if (dataReader["Sub1OM"] != DBNull.Value) { obj.Sub1OM = (decimal)dataReader["Sub1OM"]; }
                            if (dataReader["Sub1P"] != DBNull.Value) { obj.Sub1P = (decimal)dataReader["Sub1P"]; }
                            if (dataReader["Sub2"] != DBNull.Value) { obj.Sub2 = (string)dataReader["Sub2"]; }
                            if (dataReader["Sub2MM"] != DBNull.Value) { obj.Sub2MM = (decimal)dataReader["Sub2MM"]; }
                            if (dataReader["Sub2OM"] != DBNull.Value) { obj.Sub2OM = (decimal)dataReader["Sub2OM"]; }
                            if (dataReader["Sub2P"] != DBNull.Value) { obj.Sub2P = (decimal)dataReader["Sub2P"]; }
                            if (dataReader["Sub3"] != DBNull.Value) { obj.Sub3 = (string)dataReader["Sub3"]; }
                            if (dataReader["Sub3MM"] != DBNull.Value) { obj.Sub3MM = (decimal)dataReader["Sub3MM"]; }
                            if (dataReader["Sub3OM"] != DBNull.Value) { obj.Sub3OM = (decimal)dataReader["Sub3OM"]; }
                            if (dataReader["Sub3P"] != DBNull.Value) { obj.Sub3P = (decimal)dataReader["Sub3P"]; }
                            if (dataReader["Sub4"] != DBNull.Value) { obj.Sub4 = (string)dataReader["Sub4"]; }
                            if (dataReader["Sub4MM"] != DBNull.Value) { obj.Sub4MM = (decimal)dataReader["Sub4MM"]; }
                            if (dataReader["Sub4OM"] != DBNull.Value) { obj.Sub4OM = (decimal)dataReader["Sub4OM"]; }
                            if (dataReader["Sub4P"] != DBNull.Value) { obj.Sub4P = (decimal)dataReader["Sub4P"]; }
                            if (dataReader["Sub5"] != DBNull.Value) { obj.Sub5 = (string)dataReader["Sub5"]; }
                            if (dataReader["Sub5MM"] != DBNull.Value) { obj.Sub5MM = (decimal)dataReader["Sub5MM"]; }
                            if (dataReader["Sub5OM"] != DBNull.Value) { obj.Sub5OM = (decimal)dataReader["Sub5OM"]; }
                            if (dataReader["Sub5P"] != DBNull.Value) { obj.Sub5P = (decimal)dataReader["Sub5P"]; }
                            if (dataReader["Sub6"] != DBNull.Value) { obj.Sub6 = (string)dataReader["Sub6"]; }
                            if (dataReader["Sub6MM"] != DBNull.Value) { obj.Sub6MM = (decimal)dataReader["Sub6MM"]; }
                            if (dataReader["Sub6OM"] != DBNull.Value) { obj.Sub6OM = (decimal)dataReader["Sub6OM"]; }
                            if (dataReader["Sub6P"] != DBNull.Value) { obj.Sub6P = (decimal)dataReader["Sub6P"]; }
                            if (dataReader["IsActive"] != DBNull.Value) { obj.IsActive = (bool)dataReader["IsActive"]; }
                            if (dataReader["IsDelete"] != DBNull.Value) { obj.IsDelete = (bool)dataReader["IsDelete"]; }

                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;
            }
            public bool Managetbl_Appfrm_AppliedSubject(tbl_Appfrm_AppliedSubject edusub)
            {



                string dbCommand = ("spManagetbl_Appfrm_AppliedSubject");
                var parameters = new List<IDbDataParameter>();


                parameters.Add(dbManager.CreateParameter("ID", edusub.ID, DbType.String));
                parameters.Add(dbManager.CreateParameter("RegNo", edusub.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("Education", edusub.Education, DbType.String));
                parameters.Add(dbManager.CreateParameter("Stream", edusub.Stream, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubPhy", edusub.SubPhy, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubPhyMM", edusub.SubPhyMM, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubPhyOM", edusub.SubPhyOM, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubPhyP", edusub.SubPhyP, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubChem", edusub.SubChem, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubChemMM", edusub.SubChemMM, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubChemOM", edusub.SubChemOM, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubChemP", edusub.SubChemP, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubMath", edusub.SubMath, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubMathMM", edusub.SubMathMM, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubMathOM", edusub.SubMathOM, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubMathP", edusub.SubMathP, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubBio", edusub.SubBio, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubBioMM", edusub.SubBioMM, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubBioOM", edusub.SubBioOM, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubBioP", edusub.SubBioP, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub1", edusub.Sub1, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub1MM", edusub.Sub1MM, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub1OM", edusub.Sub1OM, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub1P", edusub.Sub1P, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub2", edusub.Sub2, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub2MM", edusub.Sub2MM, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub2OM", edusub.Sub2OM, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub2P", edusub.Sub2P, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub3", edusub.Sub3, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub3MM", edusub.Sub3MM, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub3OM", edusub.Sub3OM, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub3P", edusub.Sub3P, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub4", edusub.Sub4, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub4MM", edusub.Sub4MM, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub4OM", edusub.Sub4OM, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub4P", edusub.Sub4P, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub5", edusub.Sub5, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub5MM", edusub.Sub5MM, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub5OM", edusub.Sub5OM, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub5P", edusub.Sub5P, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub6", edusub.Sub6, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub6MM", edusub.Sub6MM, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub6OM", edusub.Sub6OM, DbType.String));
                parameters.Add(dbManager.CreateParameter("Sub6P", edusub.Sub6P, DbType.String));
                parameters.Add(dbManager.CreateParameter("IsActive", edusub.IsActive, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("IsDelete", edusub.IsDelete, DbType.Boolean));
                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;


            }
        }
    }
    #endregion

    #region applicantWeightage

    namespace DataLayer
    {
        public class tbl_Appfrm_WeightageDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_Appfrm_Weightage> GetAlltbl_Appfrm_Weightage(string regno)
            {

                string dbCommand = ("spGettbl_Appfrm_WeightageAll");

                List<tbl_Appfrm_Weightage> list = new List<tbl_Appfrm_Weightage>();
                var parameters = new List<IDbDataParameter>();


                parameters.Add(dbManager.CreateParameter("RegNo", regno, DbType.String));
                try
                {

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Appfrm_Weightage obj = new tbl_Appfrm_Weightage();

                            if (dataReader["ID"] != DBNull.Value) { obj.ID = (int)dataReader["ID"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["WEIGHTAGECODE"] != DBNull.Value) { obj.WEIGHTAGECODE = (string)dataReader["WEIGHTAGECODE"]; }
                            if (dataReader["WEIGHTAGE"] != DBNull.Value) { obj.WEIGHTAGE = (string)dataReader["WEIGHTAGE"]; }
                            if (dataReader["STATUS"] != DBNull.Value) { obj.STATUS = (bool)dataReader["STATUS"]; }
                            if (dataReader["Other1"] != DBNull.Value) { obj.Other1 = (string)dataReader["Other1"]; }
                            if (dataReader["Other2"] != DBNull.Value) { obj.Other2 = (string)dataReader["Other2"]; }
                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;



            }


            public List<tbl_Appfrm_Weightage> GetAlltbl_Appfrm_WeightageDetailsByRegNo(string regno)
            {

                string dbCommand = ("spGettbl_Appfrm_WeightageDetailsByRegNo");

                List<tbl_Appfrm_Weightage> list = new List<tbl_Appfrm_Weightage>();
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("RegNo", regno, DbType.String));
                try
                {


                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Appfrm_Weightage obj = new tbl_Appfrm_Weightage();

                            if (dataReader["ID"] != DBNull.Value) { obj.ID = (int)dataReader["ID"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["WEIGHTAGECODE"] != DBNull.Value) { obj.WEIGHTAGECODE = (string)dataReader["WEIGHTAGECODE"]; }
                            if (dataReader["WEIGHTAGE"] != DBNull.Value) { obj.WEIGHTAGE = (string)dataReader["WEIGHTAGE"]; }
                            if (dataReader["STATUS"] != DBNull.Value) { obj.STATUS = (bool)dataReader["STATUS"]; }
                            if (dataReader["Other1"] != DBNull.Value) { obj.Other1 = (string)dataReader["Other1"]; }
                            if (dataReader["Other2"] != DBNull.Value) { obj.Other2 = (string)dataReader["Other2"]; }
                            if (dataReader["SortOrder"] != DBNull.Value) { obj.SortOrder = (int)dataReader["SortOrder"]; }
                            if (dataReader["IsShowForm"] != DBNull.Value) { obj.IsShowForm = (bool)dataReader["IsShowForm"]; }
                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;



            }

            public bool Managetbl_Appfrm_Weightage(tbl_Appfrm_Weightage weight)
            {

                string dbCommand = ("spManagetbl_Appfrm_Weightage");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("ID", weight.ID, DbType.String));
                parameters.Add(dbManager.CreateParameter("RegNo", weight.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("WEIGHTAGECODE", weight.WEIGHTAGECODE, DbType.String));
                parameters.Add(dbManager.CreateParameter("WEIGHTAGE", weight.WEIGHTAGE, DbType.String));
                parameters.Add(dbManager.CreateParameter("STATUS", weight.STATUS, DbType.String));
                parameters.Add(dbManager.CreateParameter("Other1", weight.Other1, DbType.String));
                parameters.Add(dbManager.CreateParameter("Other2", weight.Other2, DbType.String));

                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;


            }





        }
    }
    #endregion


    #region applicantExamCenter

    namespace DataLayer
    {
        public class tbl_Appfrm_ExamCenterDAO
        {

            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_Appfrm_ExamCenter> GetAlltbl_Appfrm_ExamCenterDetailsByRegNo(string regno)
            {

                string dbCommand = ("spGettbl_Appfrm_ExamCenterByRegNo");

                List<tbl_Appfrm_ExamCenter> list = new List<tbl_Appfrm_ExamCenter>();
                var parameters = new List<IDbDataParameter>();


                parameters.Add(dbManager.CreateParameter("RegNo", regno, DbType.String));
                try
                {

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Appfrm_ExamCenter obj = new tbl_Appfrm_ExamCenter();

                            if (dataReader["ID"] != DBNull.Value) { obj.ID = (int)dataReader["ID"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["ProgramCode"] != DBNull.Value) { obj.ProgramCode = (string)dataReader["ProgramCode"]; }
                            if (dataReader["ExamCenter1"] != DBNull.Value) { obj.ExamCenter1 = (string)dataReader["ExamCenter1"]; }
                            if (dataReader["ExamCenter2"] != DBNull.Value) { obj.ExamCenter2 = (string)dataReader["ExamCenter2"]; }
                            if (dataReader["ExamCenter3"] != DBNull.Value) { obj.ExamCenter3 = (string)dataReader["ExamCenter3"]; }
                            if (dataReader["ExamCenter4"] != DBNull.Value) { obj.ExamCenter4 = (string)dataReader["ExamCenter4"]; }
                            if (dataReader["ExamCenter4"] != DBNull.Value) { obj.ExamCenter5 = (string)dataReader["ExamCenter5"]; }
                            if (dataReader["CreationDate"] != DBNull.Value) { obj.CreationDate = (DateTime)dataReader["CreationDate"]; }
                            if (dataReader["UpdateDate"] != DBNull.Value) { obj.UpdateDate = (DateTime)dataReader["UpdateDate"]; }
                            if (dataReader["IsActive"] != DBNull.Value) { obj.IsActive = (bool)dataReader["IsActive"]; }
                            if (dataReader["IsDelete"] != DBNull.Value) { obj.IsDelete = (bool)dataReader["IsDelete"]; }
                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;



            }

            public bool Managetbl_Appfrm_ExamCenter(tbl_Appfrm_ExamCenter exam)
            {

                string dbCommand = ("spManagetbl_Appfrm_ExamCenter");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("ID", exam.ID, DbType.String));
                parameters.Add(dbManager.CreateParameter("RegNo", exam.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("ProgramCode", exam.ProgramCode, DbType.String));
                parameters.Add(dbManager.CreateParameter("ExamCenter1", exam.ExamCenter1, DbType.String));
                parameters.Add(dbManager.CreateParameter("ExamCenter2", exam.ExamCenter2, DbType.String));
                parameters.Add(dbManager.CreateParameter("ExamCenter3", exam.ExamCenter3, DbType.String));
                parameters.Add(dbManager.CreateParameter("ExamCenter4", exam.ExamCenter4, DbType.String));
                parameters.Add(dbManager.CreateParameter("ExamCenter5", exam.ExamCenter5, DbType.String));
                parameters.Add(dbManager.CreateParameter("CreationDate", exam.CreationDate, DbType.DateTime));
                parameters.Add(dbManager.CreateParameter("UpdateDate", exam.UpdateDate, DbType.DateTime));
                parameters.Add(dbManager.CreateParameter("IsActive", exam.IsActive, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("IsDelete", exam.IsDelete, DbType.Boolean));



                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;


            }





        }
    }
    #endregion

    #region applicantreg_attachment
    namespace DataLayer
    {
        public class tbl_Appfrm_AttachmentDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_Appfrm_Attachment> GetAlltbl_Appfrm_Attachment(string RegNo)
            {

                string dbCommand = ("spGettbl_Appfrm_AttachmentAll");

                List<tbl_Appfrm_Attachment> list = new List<tbl_Appfrm_Attachment>();

                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("RegNo", RegNo, DbType.String));
                try
                {

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Appfrm_Attachment obj = new tbl_Appfrm_Attachment();

                            if (dataReader["ID"] != DBNull.Value) { obj.ID = (int)dataReader["ID"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["Index"] != DBNull.Value) { obj.Index = (int)dataReader["Index"]; }
                            if (dataReader["AttachmentName"] != DBNull.Value) { obj.AttachmentName = (string)dataReader["AttachmentName"]; }
                            if (dataReader["AttachmentText"] != DBNull.Value) { obj.AttachmentText = (string)dataReader["AttachmentText"]; }
                            if (dataReader["FullPath"] != DBNull.Value) { obj.FullPath = (string)dataReader["FullPath"]; }
                            if (dataReader["CreationDate"] != DBNull.Value) { obj.CreationDate = (DateTime)dataReader["CreationDate"]; }
                            if (dataReader["UpdateDate"] != DBNull.Value) { obj.UpdateDate = (DateTime)dataReader["UpdateDate"]; }
                            if (dataReader["Status"] != DBNull.Value) { obj.Status = (string)dataReader["Status"]; }
                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;

            }

            public bool Managetbl_Appfrm_Attachment(tbl_Appfrm_Attachment att)
            {

                string dbCommand = ("spManagetbl_Appfrm_Attachment");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("ID", att.ID, DbType.String));
                parameters.Add(dbManager.CreateParameter("RegNo", att.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("Index", att.Index, DbType.String));
                parameters.Add(dbManager.CreateParameter("AttachmentName", att.AttachmentName, DbType.String));
                parameters.Add(dbManager.CreateParameter("FullPath", att.FullPath, DbType.String));
                parameters.Add(dbManager.CreateParameter("CreationDate", att.CreationDate, DbType.DateTime));
                parameters.Add(dbManager.CreateParameter("UpdateDate", att.UpdateDate, DbType.DateTime));


                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {

                    dbManager.CloseConnection(connection);
                }
                return flag;
            }




        }
    }

    #endregion



    #endregion


    #region RegistrationUtilities
    #region otp
    namespace DataLayer
    {
        public class tbl_OTPDAO
        {

            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_OTP> GetAlltbl_OTP()
            {

                string dbCommand = ("spGettbl_OTPAll");

                List<tbl_OTP> list = new List<tbl_OTP>();
                try
                {
                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, null, out connection))
                    {
                        while (dataReader.Read())
                        {

                            tbl_OTP obj = new tbl_OTP();


                            if (dataReader["id"] != DBNull.Value) { obj.id = (int)dataReader["id"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["EmailId"] != DBNull.Value) { obj.EmailId = (string)dataReader["EmailId"]; }
                            if (dataReader["MobileNo"] != DBNull.Value) { obj.MobileNo = (string)dataReader["MobileNo"]; }
                            if (dataReader["MobileOtp"] != DBNull.Value) { obj.MobileOtp = (string)dataReader["MobileOtp"]; }
                            if (dataReader["IsMobileOtpUsed"] != DBNull.Value) { obj.IsMobileOtpUsed = (bool)dataReader["IsMobileOtpUsed"]; }
                            if (dataReader["MobileOtpDate"] != DBNull.Value) { obj.MobileOtpDate = (string)dataReader["MobileOtpDate"]; }
                            if (dataReader["MobileOtpUsedDate"] != DBNull.Value) { obj.MobileOtpUsedDate = (string)dataReader["MobileOtpUsedDate"]; }
                            if (dataReader["EmailOtp"] != DBNull.Value) { obj.EmailOtp = (string)dataReader["EmailOtp"]; }
                            if (dataReader["IsEmailOtpUsed"] != DBNull.Value) { obj.IsEmailOtpUsed = (bool)dataReader["IsEmailOtpUsed"]; }
                            if (dataReader["EmailOtpDate"] != DBNull.Value) { obj.EmailOtpDate = (string)dataReader["EmailOtpDate"]; }
                            if (dataReader["EmailOtpUsedDate"] != DBNull.Value) { obj.EmailOtpUsedDate = (string)dataReader["EmailOtpUsedDate"]; }

                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;

            }


            public string GetOTPByMobielEmail(string mobile, string email, int ismobile)
            {
                string otp = "";
                string dbCommand = ("sp_GetNewOTP");

                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("EmailId", email, DbType.String));
                parameters.Add(dbManager.CreateParameter("MobileNo", mobile, DbType.String));
                parameters.Add(dbManager.CreateParameter("IsMobileOtp", ismobile, DbType.String));
                try
                {

                    object s = dbManager.GetScalarValue(dbCommand, CommandType.StoredProcedure, parameters.ToArray());
                    if (s != null && s != DBNull.Value)
                    {
                        otp = Convert.ToString(s);

                    }

                }
                catch { }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return otp;

            }

            public int GetCountOTPMobielEmailByDay(string mobile, string email, int ismobile)
            {
                int otp = 0;
                string dbCommand = ("sp_GetCountOTPByDay");

                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("EmailId", email, DbType.String));
                parameters.Add(dbManager.CreateParameter("MobileNo", mobile, DbType.String));
                parameters.Add(dbManager.CreateParameter("IsMobileOtp", ismobile, DbType.String));
                try
                {

                    object s = dbManager.GetScalarValue(dbCommand, CommandType.StoredProcedure, parameters.ToArray());
                    if (s != null && s != DBNull.Value)
                    {
                        otp = Convert.ToInt32(s);

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return otp;

            }

            public bool Managetbl_OTP(tbl_OTP otp, int ismobile)
            {


                string dbCommand = ("spMangetbl_OTP");
                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("id", otp.id, DbType.String));
                parameters.Add(dbManager.CreateParameter("RegNo", otp.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("EmailId", otp.EmailId, DbType.String));
                parameters.Add(dbManager.CreateParameter("MobileNo", otp.MobileNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("MobileOtp", otp.MobileOtp, DbType.String));
                parameters.Add(dbManager.CreateParameter("IsMobileOtpUsed", otp.IsMobileOtpUsed, DbType.String));
                parameters.Add(dbManager.CreateParameter("MobileOtpDate", otp.MobileOtpDate, DbType.String));
                parameters.Add(dbManager.CreateParameter("MobileOtpUsedDate", otp.MobileOtpUsedDate, DbType.String));
                parameters.Add(dbManager.CreateParameter("EmailOtp", otp.EmailOtp, DbType.String));
                parameters.Add(dbManager.CreateParameter("IsEmailOtpUsed", otp.IsEmailOtpUsed, DbType.String));
                parameters.Add(dbManager.CreateParameter("EmailOtpDate", otp.EmailOtpDate, DbType.String));
                parameters.Add(dbManager.CreateParameter("EmailOtpUsedDate", otp.EmailOtpUsedDate, DbType.String));
                parameters.Add(dbManager.CreateParameter("IsMobileOtp", ismobile, DbType.String));


                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }





        }
    }
    #endregion

    #region steps

    namespace DataLayer
    {
        public class tbl_StepsDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_Steps> GetAlltbl_Steps()
            {

                string dbCommand = "spGettbl_StepsAll";

                List<tbl_Steps> list = new List<tbl_Steps>();
                try
                {

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, null, out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Steps obj = new tbl_Steps();

                            if (dataReader["StepId"] != DBNull.Value) { obj.StepId = (int)dataReader["StepId"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["StepName"] != DBNull.Value) { obj.StepName = (string)dataReader["StepName"]; }
                            if (dataReader["IsComplete"] != DBNull.Value) { obj.IsComplete = (bool)dataReader["IsComplete"]; }
                            if (dataReader["CompletionDate"] != DBNull.Value) { obj.CompletionDate = (DateTime)dataReader["CompletionDate"]; }
                            if (dataReader["UpdateDate"] != DBNull.Value) { obj.UpdateDate = (DateTime)dataReader["UpdateDate"]; }
                            if (dataReader["IpAdd"] != DBNull.Value) { obj.IpAdd = (string)dataReader["IpAdd"]; }
                            if (dataReader["MacId"] != DBNull.Value) { obj.MacId = (string)dataReader["MacId"]; }
                            if (dataReader["BrowserName"] != DBNull.Value) { obj.BrowserName = (string)dataReader["BrowserName"]; }

                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {

                    dbManager.CloseConnection(connection);
                }

                return list;

            }

            public bool Managetbl_Steps(tbl_Steps stp)
            {

                string dbCommand = ("spManagetbl_Steps");
                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("@StepId", stp.StepId, DbType.String));
                parameters.Add(dbManager.CreateParameter("RegNo", stp.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("StepName", stp.StepName, DbType.String));
                parameters.Add(dbManager.CreateParameter("IsComplete", stp.IsComplete, DbType.String));
                parameters.Add(dbManager.CreateParameter("CompletionDate", stp.CompletionDate, DbType.DateTime));
                parameters.Add(dbManager.CreateParameter("UpdateDate", stp.UpdateDate, DbType.DateTime));
                parameters.Add(dbManager.CreateParameter("IpAdd", stp.IpAdd, DbType.String));
                parameters.Add(dbManager.CreateParameter("MacId", stp.MacId, DbType.String));
                parameters.Add(dbManager.CreateParameter("BrowserName", stp.BrowserName, DbType.String));
                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;
                // bool flag = false; flag = (dbManager.ExecuteNonQuery(System.Data.CommandType.StoredProcedure, dbCommand) == 1); dbManager.Close();  dbManager.Dispose();  return flag;
            }




        }
    }

    #endregion

    #endregion

    #region commonselect

    namespace DataLayer
    {
        public class tbl_ReportDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;
            public List<tbl_Report> GetAlltbl_Report(string command)
            {

                string dbCommand = "sp_GetAllDetails";

                List<tbl_Report> list = new List<tbl_Report>();
                try
                {
                    var parameters = new List<IDbDataParameter>();
                    parameters.Add(dbManager.CreateParameter("Flag", command, DbType.String));

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Report obj = new tbl_Report();

                            if (dataReader["Id"] != DBNull.Value) { obj.Id = Convert.ToInt32(dataReader["Id"]); }
                            if (dataReader["Row1"] != DBNull.Value) { obj.Row1 = Convert.ToString(dataReader["Row1"]); }
                            if (dataReader["Row2"] != DBNull.Value) { obj.Row2 = Convert.ToString(dataReader["Row2"]); }
                            if (dataReader["Row3"] != DBNull.Value) { obj.Row3 = Convert.ToString(dataReader["Row3"]); }
                            if (dataReader["Row4"] != DBNull.Value) { obj.Row4 = Convert.ToString(dataReader["Row4"]); }
                            if (dataReader["Row5"] != DBNull.Value) { obj.Row5 = Convert.ToString(dataReader["Row5"]); }
                            if (dataReader["Row6"] != DBNull.Value) { obj.Row6 = Convert.ToString(dataReader["Row6"]); }
                            if (dataReader["Row7"] != DBNull.Value) { obj.Row7 = Convert.ToString(dataReader["Row7"]); }
                            if (dataReader["Row8"] != DBNull.Value) { obj.Row8 = Convert.ToString(dataReader["Row8"]); }
                            if (dataReader["Row9"] != DBNull.Value) { obj.Row9 = Convert.ToString(dataReader["Row9"]); }
                            if (dataReader["Row10"] != DBNull.Value) { obj.Row10 = Convert.ToString(dataReader["Row10"]); }

                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;

            }
            public bool ManageRow(tbl_Report ay)
            {

                string dbCommand = ("spMangetbl_Row");
                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("Id", ay.Id, DbType.String));
                parameters.Add(dbManager.CreateParameter("Row1", ay.Row1, DbType.String));
                parameters.Add(dbManager.CreateParameter("Row2", ay.Row2, DbType.String));
                parameters.Add(dbManager.CreateParameter("Row3", ay.Row3, DbType.String));
                parameters.Add(dbManager.CreateParameter("Row4", ay.Row4, DbType.String));
                parameters.Add(dbManager.CreateParameter("Row5", ay.Row5, DbType.String));
                parameters.Add(dbManager.CreateParameter("Row6", ay.Row6, DbType.String));
                parameters.Add(dbManager.CreateParameter("Row7", ay.Row7, DbType.String));
                parameters.Add(dbManager.CreateParameter("Row8", ay.Row8, DbType.String));
                parameters.Add(dbManager.CreateParameter("Row9", ay.Row9, DbType.String));
                parameters.Add(dbManager.CreateParameter("Row10", ay.Row10, DbType.String));
                parameters.Add(dbManager.CreateParameter("ActionFlag", ay.ActionFlag, DbType.String));
                parameters.Add(dbManager.CreateParameter("Flag", ay.Flag, DbType.String));
                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;
            }




            public List<tbl_Report> GetAlltbl_ReportDDL(string command)
            {

                string dbCommand = "sp_GetAllDetailsDDL";

                List<tbl_Report> list = new List<tbl_Report>();
                try
                {
                    var parameters = new List<IDbDataParameter>();
                    parameters.Add(dbManager.CreateParameter("Flag", command, DbType.String));


                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Report obj = new tbl_Report();

                            if (dataReader["Id"] != DBNull.Value) { obj.Id = (int)dataReader["Id"]; }
                            if (dataReader["Row1"] != DBNull.Value) { obj.Row1 = Convert.ToString(dataReader["Row1"]); }
                            if (dataReader["Row2"] != DBNull.Value) { obj.Row2 = Convert.ToString(dataReader["Row2"]); }
                            if (dataReader["Row3"] != DBNull.Value) { obj.Row3 = Convert.ToString(dataReader["Row3"]); }
                            if (dataReader["Row4"] != DBNull.Value) { obj.Row4 = Convert.ToString(dataReader["Row4"]); }

                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;

            }

            public object GetAllRagistervalidity(string p)
            {
                throw new NotImplementedException();
            }
        }
    }

    #endregion

    #region appliedProgram
    namespace DataLayer
    {
        public class tbl_Appfrm_AppliedProgramDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_Appfrm_AppliedProgram> GetAlltbl_Appfrm_AppliedProgram(string RegNo)
            {

                string dbCommand = ("spGettbl_Appfrm_AppliedProgramAll");

                List<tbl_Appfrm_AppliedProgram> list = new List<tbl_Appfrm_AppliedProgram>();
                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("RegNo", RegNo, DbType.String));
                try
                {

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Appfrm_AppliedProgram obj = new tbl_Appfrm_AppliedProgram();

                            if (dataReader["ID"] != DBNull.Value) { obj.ID = (int)dataReader["ID"]; }
                            if (dataReader["AcknowledgementNo"] != DBNull.Value) { obj.AcknowledgementNo = (string)dataReader["AcknowledgementNo"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["AppliedProgram"] != DBNull.Value) { obj.AppliedProgram = (string)dataReader["AppliedProgram"]; }
                            if (dataReader["AppliedMode"] != DBNull.Value) { obj.AppliedMode = (string)dataReader["AppliedMode"]; }
                            if (dataReader["ProgramMode"] != DBNull.Value) { obj.ProgramMode = (string)dataReader["ProgramMode"]; }
                            if (dataReader["SelectionMode"] != DBNull.Value) { obj.SelectionMode = (string)dataReader["SelectionMode"]; }
                            if (dataReader["ProgramName"] != DBNull.Value) { obj.ProgramName = (string)dataReader["ProgramName"]; }
                            if (dataReader["Fee"] != DBNull.Value) { obj.Fee = Convert.ToString(dataReader["Fee"]); }
                            if (dataReader["IsPaid"] != DBNull.Value) { obj.IsPaid = Convert.ToBoolean(dataReader["IsPaid"]); }
                            if (dataReader["IsActive"] != DBNull.Value) { obj.IsActive = Convert.ToBoolean(dataReader["IsActive"]); }
                            if (dataReader["IsDelete"] != DBNull.Value) { obj.IsDelete = Convert.ToBoolean(dataReader["IsDelete"]); }

                            if (dataReader["RegistrationDate"] != DBNull.Value) { obj.RegistrationDate = Convert.ToString(dataReader["RegistrationDate"]); }
                            if (dataReader["CompletionDate"] != DBNull.Value) { obj.CompletionDate = Convert.ToString(dataReader["CompletionDate"]); }
                            if (dataReader["TransId"] != DBNull.Value) { obj.TransId = (string)dataReader["TransId"]; }
                            if (dataReader["TransactionStatus"] != DBNull.Value) { obj.TransactionStatus = (string)dataReader["TransactionStatus"]; }


                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;

            }



            public List<tbl_Appfrm_AppliedProgram> GetAlltbl_Appfrm_LockedProgram(string RegNo)
            {

                string dbCommand = ("spGettbl_Appfrm_LockedProgramAll");

                List<tbl_Appfrm_AppliedProgram> list = new List<tbl_Appfrm_AppliedProgram>();
                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("RegNo", RegNo, DbType.String));
                try
                {

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Appfrm_AppliedProgram obj = new tbl_Appfrm_AppliedProgram();

                            if (dataReader["ID"] != DBNull.Value) { obj.ID = (int)dataReader["ID"]; }
                            if (dataReader["AcknowledgementNo"] != DBNull.Value) { obj.AcknowledgementNo = (string)dataReader["AcknowledgementNo"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["AppliedProgram"] != DBNull.Value) { obj.AppliedProgram = (string)dataReader["AppliedProgram"]; }
                            if (dataReader["SelectionMode"] != DBNull.Value) { obj.SelectionMode = (string)dataReader["SelectionMode"]; }
                            if (dataReader["ProgramName"] != DBNull.Value) { obj.ProgramName = (string)dataReader["ProgramName"]; }
                            if (dataReader["IsPaid"] != DBNull.Value) { obj.IsPaid = (bool)dataReader["IsPaid"]; }
                            if (dataReader["IsActive"] != DBNull.Value) { obj.IsActive = (bool)dataReader["IsActive"]; }
                            if (dataReader["IsDelete"] != DBNull.Value) { obj.IsDelete = (bool)dataReader["IsDelete"]; }
                            if (dataReader["RegistrationDate"] != DBNull.Value) { obj.RegistrationDate = (string)dataReader["RegistrationDate"]; }
                            if (dataReader["CompletionDate"] != DBNull.Value) { obj.CompletionDate = (string)dataReader["CompletionDate"]; }

                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;

            }


            public List<tbl_Appfrm_AppliedProgram> GetAlltbl_Appfrm_ExamedProgram(string RegNo)
            {

                string dbCommand = ("spGettbl_Appfrm_ExamedProgramAll");

                List<tbl_Appfrm_AppliedProgram> list = new List<tbl_Appfrm_AppliedProgram>();
                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("RegNo", RegNo, DbType.String));
                try
                {

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Appfrm_AppliedProgram obj = new tbl_Appfrm_AppliedProgram();

                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["AppliedProgram"] != DBNull.Value) { obj.AppliedProgram = (string)dataReader["AppliedProgram"]; }
                            if (dataReader["ProgramName"] != DBNull.Value) { obj.ProgramName = (string)dataReader["ProgramName"]; }

                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;

            }


            public bool Updatetbl_Appfrm_AppliedProgram(tbl_Appfrm_AppliedProgram pst)
            {

                string dbCommand = ("spManagetbl_Appfrm_AppliedProgram");
                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("ID", pst.ID, DbType.String));
                parameters.Add(dbManager.CreateParameter("AcknowledgementNo", pst.AcknowledgementNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("RegNo", pst.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("AppliedProgram", pst.AppliedProgram, DbType.String));
                parameters.Add(dbManager.CreateParameter("IsPaid", pst.IsPaid, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("IsActive", pst.IsActive, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("IsDelete", pst.IsDelete, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("RegistrationDate", pst.RegistrationDate, DbType.String));
                parameters.Add(dbManager.CreateParameter("CompletionDate", pst.CompletionDate, DbType.String));

                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }

        }
    }
    #endregion

    #region payment

    namespace DataLayer
    {
        public class tbl_PaymentDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_Payment> GetAlltbl_Payment()
            {

                string dbCommand = ("spGettbl_PaymentAll");

                List<tbl_Payment> list = new List<tbl_Payment>();
                try
                {

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, null, out connection))
                    {
                        {

                            while (dataReader.Read())
                            {

                                tbl_Payment obj = new tbl_Payment();

                                if (dataReader["PaymentId"] != DBNull.Value) { obj.PaymentId = (int)dataReader["PaymentId"]; }
                                if (dataReader["MerchantLogin"] != DBNull.Value) { obj.MerchantLogin = (string)dataReader["MerchantLogin"]; }
                                if (dataReader["MerchantPass"] != DBNull.Value) { obj.MerchantPass = (string)dataReader["MerchantPass"]; }
                                if (dataReader["MerchantDiscretionaryData"] != DBNull.Value) { obj.MerchantDiscretionaryData = (string)dataReader["MerchantDiscretionaryData"]; }
                                if (dataReader["ProductID"] != DBNull.Value) { obj.ProductID = (string)dataReader["ProductID"]; }
                                if (dataReader["ClientCode"] != DBNull.Value) { obj.ClientCode = (string)dataReader["ClientCode"]; }
                                if (dataReader["CustomerAccountNo"] != DBNull.Value) { obj.CustomerAccountNo = (string)dataReader["CustomerAccountNo"]; }
                                if (dataReader["TransactionType"] != DBNull.Value) { obj.TransactionType = (string)dataReader["TransactionType"]; }
                                if (dataReader["TransactionAmount"] != DBNull.Value) { obj.TransactionAmount = (decimal)dataReader["TransactionAmount"]; }
                                if (dataReader["TransactionCurrency"] != DBNull.Value) { obj.TransactionCurrency = (string)dataReader["TransactionCurrency"]; }
                                if (dataReader["TransactionServiceCharge"] != DBNull.Value) { obj.TransactionServiceCharge = (decimal)dataReader["TransactionServiceCharge"]; }
                                if (dataReader["TransactionID"] != DBNull.Value) { obj.TransactionID = (string)dataReader["TransactionID"]; }
                                if (dataReader["TransactionDateTime"] != DBNull.Value) { obj.TransactionDateTime = (string)dataReader["TransactionDateTime"]; }
                                if (dataReader["TransactionStatus"] != DBNull.Value) { obj.TransactionStatus = (string)dataReader["TransactionStatus"]; }
                                if (dataReader["BankID"] != DBNull.Value) { obj.BankID = (string)dataReader["BankID"]; }
                                if (dataReader["UserDefined1"] != DBNull.Value) { obj.UserDefined1 = (string)dataReader["UserDefined1"]; }
                                if (dataReader["UserDefined2"] != DBNull.Value) { obj.UserDefined2 = (string)dataReader["UserDefined2"]; }
                                if (dataReader["UserDefined3"] != DBNull.Value) { obj.UserDefined3 = (string)dataReader["UserDefined3"]; }
                                if (dataReader["UserDefined4"] != DBNull.Value) { obj.UserDefined4 = (string)dataReader["UserDefined4"]; }
                                if (dataReader["UserDefined5"] != DBNull.Value) { obj.UserDefined5 = (string)dataReader["UserDefined5"]; }
                                if (dataReader["UserDefined6"] != DBNull.Value) { obj.UserDefined6 = (string)dataReader["UserDefined6"]; }
                                if (dataReader["CareationDate"] != DBNull.Value) { obj.CareationDate = (DateTime)dataReader["CareationDate"]; }
                                if (dataReader["UpdateDate"] != DBNull.Value) { obj.UpdateDate = (DateTime)dataReader["UpdateDate"]; }
                                if (dataReader["PaymentText"] != DBNull.Value) { obj.PaymentText = (string)dataReader["PaymentText"]; }
                                if (dataReader["IsActive"] != DBNull.Value) { obj.IsActive = (bool)dataReader["IsActive"]; }
                                if (dataReader["IsDelete"] != DBNull.Value) { obj.IsDelete = (bool)dataReader["IsDelete"]; }

                                list.Add(obj);

                            }

                        }
                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;

            }



            public List<tbl_Payment> GetAllLatest100tbl_Payment()
            {

                string dbCommand = ("spGettbl_PaymentAllLatest100");

                List<tbl_Payment> list = new List<tbl_Payment>();
                try
                {

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, null, out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Payment obj = new tbl_Payment();

                            if (dataReader["PaymentId"] != DBNull.Value) { obj.PaymentId = (int)dataReader["PaymentId"]; }

                            if (dataReader["ProductID"] != DBNull.Value) { obj.ProductID = (string)dataReader["ProductID"]; }

                            if (dataReader["CustomerAccountNo"] != DBNull.Value) { obj.CustomerAccountNo = (string)dataReader["CustomerAccountNo"]; }
                            if (dataReader["TransactionType"] != DBNull.Value) { obj.TransactionType = (string)dataReader["TransactionType"]; }
                            if (dataReader["TransactionAmount"] != DBNull.Value) { obj.TransactionAmount = (decimal)dataReader["TransactionAmount"]; }
                            if (dataReader["TransactionCurrency"] != DBNull.Value) { obj.TransactionCurrency = (string)dataReader["TransactionCurrency"]; }
                            if (dataReader["TransactionServiceCharge"] != DBNull.Value) { obj.TransactionServiceCharge = (decimal)dataReader["TransactionServiceCharge"]; }
                            if (dataReader["TransactionID"] != DBNull.Value) { obj.TransactionID = (string)dataReader["TransactionID"]; }
                            if (dataReader["TransactionDateTime"] != DBNull.Value) { obj.TransactionDateTime = (string)dataReader["TransactionDateTime"]; }
                            if (dataReader["TransactionStatus"] != DBNull.Value) { obj.TransactionStatus = (string)dataReader["TransactionStatus"]; }
                            if (dataReader["BankID"] != DBNull.Value) { obj.BankID = (string)dataReader["BankID"]; }
                            if (dataReader["UserDefined1"] != DBNull.Value) { obj.UserDefined1 = (string)dataReader["UserDefined1"]; }
                            if (dataReader["UserDefined2"] != DBNull.Value) { obj.UserDefined2 = (string)dataReader["UserDefined2"]; }
                            if (dataReader["UserDefined3"] != DBNull.Value) { obj.UserDefined3 = (string)dataReader["UserDefined3"]; }
                            if (dataReader["UserDefined4"] != DBNull.Value) { obj.UserDefined4 = (string)dataReader["UserDefined4"]; }
                            if (dataReader["UserDefined5"] != DBNull.Value) { obj.UserDefined5 = (string)dataReader["UserDefined5"]; }
                            if (dataReader["UserDefined6"] != DBNull.Value) { obj.UserDefined6 = (string)dataReader["UserDefined6"]; }


                            if (dataReader["PaymentText"] != DBNull.Value) { obj.PaymentText = (string)dataReader["PaymentText"]; }


                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;

            }



            public List<tbl_Payment> GetAlltbl_PaymentSuccess()
            {

                string dbCommand = ("spGettbl_PaymentAllSuccess");

                List<tbl_Payment> list = new List<tbl_Payment>();
                try
                {


                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, null, out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Payment obj = new tbl_Payment();

                            if (dataReader["PaymentId"] != DBNull.Value) { obj.PaymentId = (int)dataReader["PaymentId"]; }

                            if (dataReader["ProductID"] != DBNull.Value) { obj.ProductID = (string)dataReader["ProductID"]; }

                            if (dataReader["CustomerAccountNo"] != DBNull.Value) { obj.CustomerAccountNo = (string)dataReader["CustomerAccountNo"]; }
                            if (dataReader["TransactionType"] != DBNull.Value) { obj.TransactionType = (string)dataReader["TransactionType"]; }
                            if (dataReader["TransactionAmount"] != DBNull.Value) { obj.TransactionAmount = (decimal)dataReader["TransactionAmount"]; }
                            if (dataReader["TransactionCurrency"] != DBNull.Value) { obj.TransactionCurrency = (string)dataReader["TransactionCurrency"]; }
                            if (dataReader["TransactionServiceCharge"] != DBNull.Value) { obj.TransactionServiceCharge = (decimal)dataReader["TransactionServiceCharge"]; }
                            if (dataReader["TransactionID"] != DBNull.Value) { obj.TransactionID = (string)dataReader["TransactionID"]; }
                            if (dataReader["TransactionDateTime"] != DBNull.Value) { obj.TransactionDateTime = (string)dataReader["TransactionDateTime"]; }
                            if (dataReader["TransactionStatus"] != DBNull.Value) { obj.TransactionStatus = (string)dataReader["TransactionStatus"]; }
                            if (dataReader["BankID"] != DBNull.Value) { obj.BankID = (string)dataReader["BankID"]; }
                            if (dataReader["UserDefined1"] != DBNull.Value) { obj.UserDefined1 = (string)dataReader["UserDefined1"]; }
                            if (dataReader["UserDefined2"] != DBNull.Value) { obj.UserDefined2 = (string)dataReader["UserDefined2"]; }
                            if (dataReader["UserDefined3"] != DBNull.Value) { obj.UserDefined3 = (string)dataReader["UserDefined3"]; }
                            if (dataReader["UserDefined4"] != DBNull.Value) { obj.UserDefined4 = (string)dataReader["UserDefined4"]; }
                            if (dataReader["UserDefined5"] != DBNull.Value) { obj.UserDefined5 = (string)dataReader["UserDefined5"]; }
                            if (dataReader["UserDefined6"] != DBNull.Value) { obj.UserDefined6 = (string)dataReader["UserDefined6"]; }


                            if (dataReader["PaymentText"] != DBNull.Value) { obj.PaymentText = (string)dataReader["PaymentText"]; }


                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;

            }

            public bool Managetbl_Payment(tbl_Payment p)
            {
                string dbCommand = ("spManagetbl_Payment");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("PaymentId", p.PaymentId, DbType.String));
                parameters.Add(dbManager.CreateParameter("MerchantLogin", p.MerchantLogin, DbType.String));
                parameters.Add(dbManager.CreateParameter("MerchantPass", p.MerchantPass, DbType.String));
                parameters.Add(dbManager.CreateParameter("MerchantDiscretionaryData", p.MerchantDiscretionaryData, DbType.String));
                parameters.Add(dbManager.CreateParameter("ProductID", p.ProductID, DbType.String));
                parameters.Add(dbManager.CreateParameter("ClientCode", p.ClientCode, DbType.String));
                parameters.Add(dbManager.CreateParameter("CustomerAccountNo", p.CustomerAccountNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionType", p.TransactionType, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionAmount", p.TransactionAmount, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionCurrency", p.TransactionCurrency, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionServiceCharge", p.TransactionServiceCharge, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionID", p.TransactionID, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionDateTime", p.TransactionDateTime, DbType.String));
                parameters.Add(dbManager.CreateParameter("BankID", p.BankID, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined1", p.UserDefined1, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined2", p.UserDefined2, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined3", p.UserDefined3, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined4", p.UserDefined4, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined5", p.UserDefined5, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined6", p.UserDefined6, DbType.String));
                parameters.Add(dbManager.CreateParameter("PaymentText", p.PaymentText, DbType.String));
                parameters.Add(dbManager.CreateParameter("IsActive", p.IsActive, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("IsDelete", p.IsDelete, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("TransactionStatus", p.TransactionStatus, DbType.String));

                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }

            public bool Managetbl_PaymentAdmission(tbl_Payment p)
            {
                string dbCommand = ("spManagetbl_PaymentAdmission");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("PaymentId", p.PaymentId, DbType.String));
                parameters.Add(dbManager.CreateParameter("MerchantLogin", p.MerchantLogin, DbType.String));
                parameters.Add(dbManager.CreateParameter("MerchantPass", p.MerchantPass, DbType.String));
                parameters.Add(dbManager.CreateParameter("MerchantDiscretionaryData", p.MerchantDiscretionaryData, DbType.String));
                parameters.Add(dbManager.CreateParameter("ProductID", p.ProductID, DbType.String));
                parameters.Add(dbManager.CreateParameter("ClientCode", p.ClientCode, DbType.String));
                parameters.Add(dbManager.CreateParameter("CustomerAccountNo", p.CustomerAccountNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionType", p.TransactionType, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionAmount", p.TransactionAmount, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionCurrency", p.TransactionCurrency, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionServiceCharge", p.TransactionServiceCharge, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionID", p.TransactionID, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionDateTime", p.TransactionDateTime, DbType.String));
                parameters.Add(dbManager.CreateParameter("BankID", p.BankID, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined1", p.UserDefined1, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined2", p.UserDefined2, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined3", p.UserDefined3, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined4", p.UserDefined4, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined5", p.UserDefined5, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined6", p.UserDefined6, DbType.String));
                parameters.Add(dbManager.CreateParameter("PaymentText", p.PaymentText, DbType.String));
                parameters.Add(dbManager.CreateParameter("IsActive", p.IsActive, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("IsDelete", p.IsDelete, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("TransactionStatus", p.TransactionStatus, DbType.String));

                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }

            public bool Managetbl_PaymentDirectAdmission(tbl_Payment p)
            {
                string dbCommand = ("spManagetbl_PaymentDirectAdmission");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("PaymentId", p.PaymentId, DbType.String));
                parameters.Add(dbManager.CreateParameter("MerchantLogin", p.MerchantLogin, DbType.String));
                parameters.Add(dbManager.CreateParameter("MerchantPass", p.MerchantPass, DbType.String));
                parameters.Add(dbManager.CreateParameter("MerchantDiscretionaryData", p.MerchantDiscretionaryData, DbType.String));
                parameters.Add(dbManager.CreateParameter("ProductID", p.ProductID, DbType.String));
                parameters.Add(dbManager.CreateParameter("ClientCode", p.ClientCode, DbType.String));
                parameters.Add(dbManager.CreateParameter("CustomerAccountNo", p.CustomerAccountNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionType", p.TransactionType, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionAmount", p.TransactionAmount, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionCurrency", p.TransactionCurrency, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionServiceCharge", p.TransactionServiceCharge, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionID", p.TransactionID, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionDateTime", p.TransactionDateTime, DbType.String));
                parameters.Add(dbManager.CreateParameter("BankID", p.BankID, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined1", p.UserDefined1, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined2", p.UserDefined2, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined3", p.UserDefined3, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined4", p.UserDefined4, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined5", p.UserDefined5, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined6", p.UserDefined6, DbType.String));
                parameters.Add(dbManager.CreateParameter("PaymentText", p.PaymentText, DbType.String));
                parameters.Add(dbManager.CreateParameter("IsActive", p.IsActive, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("IsDelete", p.IsDelete, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("TransactionStatus", p.TransactionStatus, DbType.String));

                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }

            public bool Managetbl_PaymentAdmissionRest(tbl_Payment p)
            {
                string dbCommand = ("spManagetbl_PaymentAdmissionRest");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("PaymentId", p.PaymentId, DbType.String));
                parameters.Add(dbManager.CreateParameter("MerchantLogin", p.MerchantLogin, DbType.String));
                parameters.Add(dbManager.CreateParameter("MerchantPass", p.MerchantPass, DbType.String));
                parameters.Add(dbManager.CreateParameter("MerchantDiscretionaryData", p.MerchantDiscretionaryData, DbType.String));
                parameters.Add(dbManager.CreateParameter("ProductID", p.ProductID, DbType.String));
                parameters.Add(dbManager.CreateParameter("ClientCode", p.ClientCode, DbType.String));
                parameters.Add(dbManager.CreateParameter("CustomerAccountNo", p.CustomerAccountNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionType", p.TransactionType, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionAmount", p.TransactionAmount, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionCurrency", p.TransactionCurrency, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionServiceCharge", p.TransactionServiceCharge, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionID", p.TransactionID, DbType.String));
                parameters.Add(dbManager.CreateParameter("TransactionDateTime", p.TransactionDateTime, DbType.String));
                parameters.Add(dbManager.CreateParameter("BankID", p.BankID, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined1", p.UserDefined1, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined2", p.UserDefined2, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined3", p.UserDefined3, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined4", p.UserDefined4, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined5", p.UserDefined5, DbType.String));
                parameters.Add(dbManager.CreateParameter("UserDefined6", p.UserDefined6, DbType.String));
                parameters.Add(dbManager.CreateParameter("PaymentText", p.PaymentText, DbType.String));
                parameters.Add(dbManager.CreateParameter("IsActive", p.IsActive, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("IsDelete", p.IsDelete, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("TransactionStatus", p.TransactionStatus, DbType.String));

                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }
            public bool Paid_Payment(string RegNo)
            {
                string dbCommand = ("USP_CheckPaymentStatusByRegNo");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("RegNo", RegNo, DbType.String));


                bool flag = false;
                try
                {

                    object s = dbManager.GetScalarValue(dbCommand, CommandType.StoredProcedure, parameters.ToArray());
                    if (s != null && s != DBNull.Value)
                    {
                        flag = true;

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }



            public string CheckForm_Status(string RegNo)
            {
                string dbCommand = ("USP_CheckFormStatusByRegNo");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("RegNo", RegNo, DbType.String));


                string flag = "1";
                try
                {

                    object s = dbManager.GetScalarValue(dbCommand, CommandType.StoredProcedure, parameters.ToArray());
                    if (s != null && s != DBNull.Value)
                    {
                        flag = s.ToString();

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }
            public bool check_Payment(string RegNo, string post)
            {
                string dbCommand = ("USP_CheckPaymentStatusByRegNoPost");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("RegNo", RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("Post", post, DbType.String));

                bool flag = false;
                try
                {

                    object s = dbManager.GetScalarValue(dbCommand, CommandType.StoredProcedure, parameters.ToArray());

                    if (s != null && s != DBNull.Value)
                    {
                        flag = true;

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }

            public bool check_PaymentForAdmission(string RegNo, string post)
            {
                string dbCommand = ("USP_CheckAdmissionPaymentStatusByRegNoPost");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("RegNo", RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("Post", post, DbType.String));

                bool flag = false;
                try
                {

                    object s = dbManager.GetScalarValue(dbCommand, CommandType.StoredProcedure, parameters.ToArray());

                    if (s != null && s != DBNull.Value)
                    {
                        flag = true;

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }

            public bool check_PaymentForDirectAdmission(string RegNo, string post)
            {
                string dbCommand = ("USP_CheckDirectAdmissionPaymentStatusByRegNoPost");
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("RegNo", RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("Post", post, DbType.String));

                bool flag = false;
                try
                {

                    object s = dbManager.GetScalarValue(dbCommand, CommandType.StoredProcedure, parameters.ToArray());

                    if (s != null && s != DBNull.Value)
                    {
                        flag = true;

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }
        }
    }

    #endregion

    #region attachment

    namespace DataLayer
    {
        public class tbl_AttachmentDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_Attachment> GetAlltbl_Attachment()
            {

                string dbCommand = ("spGetbl_AttachmentAll");

                List<tbl_Attachment> list = new List<tbl_Attachment>();
                try
                {

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, null, out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_Attachment obj = new tbl_Attachment();

                            if (dataReader["ID"] != DBNull.Value) { obj.ID = (int)dataReader["ID"]; }
                            if (dataReader["AttachmentName"] != DBNull.Value) { obj.AttachmentName = (string)dataReader["AttachmentName"]; }
                            if (dataReader["AttachmentText"] != DBNull.Value) { obj.AttachmentText = (string)dataReader["AttachmentText"]; }
                            if (dataReader["MaxSize"] != DBNull.Value) { obj.MaxSize = (string)dataReader["MaxSize"]; }
                            if (dataReader["MimeType"] != DBNull.Value) { obj.MimeType = (string)dataReader["MimeType"]; }
                            if (dataReader["CreationDate"] != DBNull.Value) { obj.CreationDate = (DateTime)dataReader["CreationDate"]; }
                            if (dataReader["UpdateDate"] != DBNull.Value) { obj.UpdateDate = (DateTime)dataReader["UpdateDate"]; }
                            if (dataReader["Status"] != DBNull.Value) { obj.Status = (bool)dataReader["Status"]; }

                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;

            }

            public List<tbl_Attachment> Gettbl_PendingAttachmentByRegNo(string RegNo)
            {

                string dbCommand = ("spGettbl_PendingAttachmentRegNo");
                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("RegNo", RegNo, DbType.String));

                List<tbl_Attachment> list = new List<tbl_Attachment>();
                try
                {

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {
                        while (dataReader.Read())
                        {

                            tbl_Attachment obj = new tbl_Attachment();

                            if (dataReader["ID"] != DBNull.Value) { obj.ID = (int)dataReader["ID"]; }
                            if (dataReader["AttachmentName"] != DBNull.Value) { obj.AttachmentName = (string)dataReader["AttachmentName"]; }
                            if (dataReader["AttachmentText"] != DBNull.Value) { obj.AttachmentText = (string)dataReader["AttachmentText"]; }
                            if (dataReader["MaxSize"] != DBNull.Value) { obj.MaxSize = (string)dataReader["MaxSize"]; }
                            if (dataReader["MimeType"] != DBNull.Value) { obj.MimeType = (string)dataReader["MimeType"]; }
                            if (dataReader["FullPath"] != DBNull.Value) { obj.FullPath = (string)dataReader["FullPath"]; }
                            if (dataReader["CreationDate"] != DBNull.Value) { obj.CreationDate = (DateTime)dataReader["CreationDate"]; }
                            if (dataReader["UpdateDate"] != DBNull.Value) { obj.UpdateDate = (DateTime)dataReader["UpdateDate"]; }
                            if (dataReader["Status"] != DBNull.Value) { obj.Status = (bool)dataReader["Status"]; }

                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;

            }
            public List<tbl_Attachment> Gettbl_PendingAttachmentByRegNoForAdmission(string RegNo)
            {

                string dbCommand = ("spGettbl_PendingAttachmentRegNoForAdmission");
                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("RegNo", RegNo, DbType.String));

                List<tbl_Attachment> list = new List<tbl_Attachment>();
                try
                {

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {
                        while (dataReader.Read())
                        {

                            tbl_Attachment obj = new tbl_Attachment();

                            if (dataReader["ID"] != DBNull.Value) { obj.ID = (int)dataReader["ID"]; }
                            if (dataReader["AttachmentName"] != DBNull.Value) { obj.AttachmentName = (string)dataReader["AttachmentName"]; }
                            if (dataReader["AttachmentText"] != DBNull.Value) { obj.AttachmentText = (string)dataReader["AttachmentText"]; }
                            if (dataReader["MaxSize"] != DBNull.Value) { obj.MaxSize = (string)dataReader["MaxSize"]; }
                            if (dataReader["MimeType"] != DBNull.Value) { obj.MimeType = (string)dataReader["MimeType"]; }
                            if (dataReader["FullPath"] != DBNull.Value) { obj.FullPath = (string)dataReader["FullPath"]; }
                            if (dataReader["CreationDate"] != DBNull.Value) { obj.CreationDate = (DateTime)dataReader["CreationDate"]; }
                            if (dataReader["UpdateDate"] != DBNull.Value) { obj.UpdateDate = (DateTime)dataReader["UpdateDate"]; }
                            if (dataReader["Status"] != DBNull.Value) { obj.Status = (bool)dataReader["Status"]; }

                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;

            }

            public bool Managetbl_Attachment(tbl_Attachment att)
            {

                string dbCommand = ("spManagetbl_Attachment");
                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("ID", att.ID, DbType.String));
                parameters.Add(dbManager.CreateParameter("AttachmentName", att.AttachmentName, DbType.String));
                parameters.Add(dbManager.CreateParameter("AttachmentText", att.AttachmentText, DbType.String));
                parameters.Add(dbManager.CreateParameter("MaxSize", att.MaxSize, DbType.String));
                parameters.Add(dbManager.CreateParameter("MimeType", att.MimeType, DbType.String));
                parameters.Add(dbManager.CreateParameter("CreationDate", att.CreationDate, DbType.DateTime));
                parameters.Add(dbManager.CreateParameter("UpdateDate", att.UpdateDate, DbType.DateTime));
                parameters.Add(dbManager.CreateParameter("Status", att.Status, DbType.Boolean));

                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;
            }




        }
    }
    #endregion


    #region examtemp

    namespace DataLayer
    {
        public class tbl_Appfrm_ExamDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_Appfrm_Exam> GetAlltbl_Appfrm_Exam(string RegNo)
            {


                string dbCommand = ("spGettbl_Appfrm_ExamAll");

                List<tbl_Appfrm_Exam> list = new List<tbl_Appfrm_Exam>();
                var parameters = new List<IDbDataParameter>();
                parameters.Add(dbManager.CreateParameter("RegNo", RegNo, DbType.String));
                try
                {

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {


                        while (dataReader.Read())
                        {

                            tbl_Appfrm_Exam obj = new tbl_Appfrm_Exam();

                            if (dataReader["ID"] != DBNull.Value) { obj.ID = (int)dataReader["ID"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["RollNo"] != DBNull.Value) { obj.RollNo = (string)dataReader["RollNo"]; }
                            if (dataReader["ProgramCode"] != DBNull.Value) { obj.ProgramCode = (string)dataReader["ProgramCode"]; }
                            if (dataReader["TotalMarks"] != DBNull.Value) { obj.TotalMarks = (string)dataReader["TotalMarks"]; }
                            if (dataReader["ObtainedMarks"] != DBNull.Value) { obj.ObtainedMarks = (string)dataReader["ObtainedMarks"]; }
                            if (dataReader["IsQuilified"] != DBNull.Value) { obj.IsQuilified = (bool)dataReader["IsQuilified"]; }
                            if (dataReader["Other1"] != DBNull.Value) { obj.Other1 = (string)dataReader["Other1"]; }
                            if (dataReader["Other2"] != DBNull.Value) { obj.Other2 = (string)dataReader["Other2"]; }

                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;




            }

            public bool Managetbl_Appfrm_Exam(tbl_Appfrm_Exam exam)
            {

                string dbCommand = ("spManagetbl_Appfrm_Exam");
                var parameters = new List<IDbDataParameter>();


                parameters.Add(dbManager.CreateParameter("ID", exam.ID, DbType.String));
                parameters.Add(dbManager.CreateParameter("RegNo", exam.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("RollNo", exam.RollNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("ProgramCode", exam.ProgramCode, DbType.String));
                parameters.Add(dbManager.CreateParameter("TotalMarks", exam.TotalMarks, DbType.String));
                parameters.Add(dbManager.CreateParameter("ObtainedMarks", exam.ObtainedMarks, DbType.String));
                parameters.Add(dbManager.CreateParameter("IsQuilified", exam.IsQuilified, DbType.String));
                parameters.Add(dbManager.CreateParameter("Other1", exam.Other1, DbType.String));
                parameters.Add(dbManager.CreateParameter("Other2", exam.Other2, DbType.String));

                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));

                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);

                }
                return flag;
            }





        }
    }
    #endregion


    #region disciplineChoice

    namespace DataLayer
    {
        public class tbl_Appfrm_ChoiceDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_Appfrm_Choice> GetAlltbl_Appfrm_Choice(string RegNo)
            {


                string dbCommand = ("spGettbl_Appfrm_ChoiceAll");

                List<tbl_Appfrm_Choice> list = new List<tbl_Appfrm_Choice>();
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("RegNo", RegNo, DbType.String));
                try
                {

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {
                        while (dataReader.Read())
                        {

                            tbl_Appfrm_Choice obj = new tbl_Appfrm_Choice();

                            if (dataReader["ID"] != DBNull.Value) { obj.ID = (int)dataReader["ID"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["RollNo"] != DBNull.Value) { obj.RollNo = (string)dataReader["RollNo"]; }
                            if (dataReader["ProgramCode"] != DBNull.Value) { obj.ProgramCode = (string)dataReader["ProgramCode"]; }
                            if (dataReader["ChoiceCode"] != DBNull.Value) { obj.ChoiceCode = (string)dataReader["ChoiceCode"]; }
                            if (dataReader["ChoiceOrder"] != DBNull.Value) { obj.ChoiceOrder = (int)dataReader["ChoiceOrder"]; }
                            if (dataReader["Other1"] != DBNull.Value) { obj.Other1 = (string)dataReader["Other1"]; }
                            if (dataReader["Other2"] != DBNull.Value) { obj.Other2 = (string)dataReader["Other2"]; }
                            if (dataReader["IsActive"] != DBNull.Value) { obj.IsActive = (bool)dataReader["IsActive"]; }
                            if (dataReader["IsDelete"] != DBNull.Value) { obj.IsDelete = (bool)dataReader["IsDelete"]; }

                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;





            }

            public bool Managetbl_Appfrm_Choice(tbl_Appfrm_Choice choice)
            {

                string dbCommand = ("spManagetbl_Appfrm_Choice");
                var parameters = new List<IDbDataParameter>();


                parameters.Add(dbManager.CreateParameter("ID", choice.ID, DbType.String));
                parameters.Add(dbManager.CreateParameter("RegNo", choice.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("RollNo", choice.RollNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("ProgramCode", choice.ProgramCode, DbType.String));
                parameters.Add(dbManager.CreateParameter("ChoiceCode", choice.ChoiceCode, DbType.String));
                parameters.Add(dbManager.CreateParameter("ChoiceOrder", choice.ChoiceOrder, DbType.String));
                parameters.Add(dbManager.CreateParameter("Other1", choice.Other1, DbType.String));
                parameters.Add(dbManager.CreateParameter("Other2", choice.Other2, DbType.String));
                parameters.Add(dbManager.CreateParameter("IsActive", choice.IsActive, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("IsDelete", choice.IsDelete, DbType.Boolean));

                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }



            public bool Shifttbl_Appfrm_Choice(tbl_Appfrm_Choice choice)
            {

                string dbCommand = ("spShifttbl_Appfrm_Choice");
                var parameters = new List<IDbDataParameter>();



                parameters.Add(dbManager.CreateParameter("RegNo", choice.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("RollNo", choice.RollNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("ProgramCode", choice.ProgramCode, DbType.String));
                parameters.Add(dbManager.CreateParameter("ChoiceCode", choice.ChoiceCode, DbType.String));
                parameters.Add(dbManager.CreateParameter("ChoiceOrder", choice.ChoiceOrder, DbType.String));


                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }

            public bool Locktbl_Appfrm_Choice(string regno, string programcode)
            {

                string dbCommand = ("spLock_Appfrm_Choice");
                var parameters = new List<IDbDataParameter>();



                parameters.Add(dbManager.CreateParameter("RegNo", regno, DbType.String));

                parameters.Add(dbManager.CreateParameter("ProgramCode", programcode, DbType.String));



                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }

            public bool IfLockedProgramChoise(string regno, string programcode)
            {

                string dbCommand = ("IfLockedProgramChoise");
                var parameters = new List<IDbDataParameter>();



                parameters.Add(dbManager.CreateParameter("RegNo", regno, DbType.String));

                parameters.Add(dbManager.CreateParameter("ProgramCode", programcode, DbType.String));



                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.GetScalarValue(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }





        }
    }
    #endregion



    #region appliedseat

    namespace DataLayer
    {
        public class tbl_Appfrm_AppliedSeatDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_Appfrm_AppliedSeat> GetAlltbl_Appfrm_AppliedSeat(string RegNo, string ProgramCode)
            {


                string dbCommand = ("spGettbl_Appfrm_AppliedSeatAll");

                List<tbl_Appfrm_AppliedSeat> list = new List<tbl_Appfrm_AppliedSeat>();
                var parameters = new List<IDbDataParameter>();

                parameters.Add(dbManager.CreateParameter("RegNo", RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("ProgramCode", ProgramCode, DbType.String));
                try
                {

                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {
                        while (dataReader.Read())
                        {

                            tbl_Appfrm_AppliedSeat obj = new tbl_Appfrm_AppliedSeat();

                            if (dataReader["ID"] != DBNull.Value) { obj.ID = (int)dataReader["ID"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["RollNo"] != DBNull.Value) { obj.RollNo = (string)dataReader["RollNo"]; }
                            if (dataReader["ProgramCode"] != DBNull.Value) { obj.ProgramCode = (string)dataReader["ProgramCode"]; }
                            if (dataReader["ChoiceCode"] != DBNull.Value) { obj.ChoiceCode = (string)dataReader["ChoiceCode"]; }
                            if (dataReader["ChoiceOrder"] != DBNull.Value) { obj.ChoiceOrder = (int)dataReader["ChoiceOrder"]; }
                            if (dataReader["SeatType"] != DBNull.Value) { obj.SeatType = (string)dataReader["SeatType"]; }
                            if (dataReader["SeatRank"] != DBNull.Value) { obj.SeatRank = (string)dataReader["SeatRank"]; }
                            if (dataReader["IsActive"] != DBNull.Value) { obj.IsActive = (bool)dataReader["IsActive"]; }
                            if (dataReader["IsDelete"] != DBNull.Value) { obj.IsDelete = (bool)dataReader["IsDelete"]; }

                            list.Add(obj);

                        }

                    }
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return list;





            }

            public bool Managetbl_Appfrm_AppliedSeat(tbl_Appfrm_AppliedSeat choice)
            {

                string dbCommand = ("spManagetbl_Appfrm_AppliedSeat");
                var parameters = new List<IDbDataParameter>();


                parameters.Add(dbManager.CreateParameter("ID", choice.ID, DbType.String));
                parameters.Add(dbManager.CreateParameter("RegNo", choice.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("RollNo", choice.RollNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("ProgramCode", choice.ProgramCode, DbType.String));
                parameters.Add(dbManager.CreateParameter("ChoiceCode", choice.ChoiceCode, DbType.String));
                parameters.Add(dbManager.CreateParameter("ChoiceOrder", choice.ChoiceOrder, DbType.String));
                parameters.Add(dbManager.CreateParameter("SeatType", choice.SeatType, DbType.String));
                parameters.Add(dbManager.CreateParameter("SeatRank", choice.SeatRank, DbType.String));
                parameters.Add(dbManager.CreateParameter("IsActive", choice.IsActive, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("IsDelete", choice.IsDelete, DbType.Boolean));

                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }





            public bool Locktbl_Appfrm_AppliedSeat(string regno, string programcode)
            {

                string dbCommand = ("spLock_Appfrm_AppliedSeat");
                var parameters = new List<IDbDataParameter>();



                parameters.Add(dbManager.CreateParameter("RegNo", regno, DbType.String));

                parameters.Add(dbManager.CreateParameter("ProgramCode", programcode, DbType.String));



                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }

            public bool IfLockedProgramSeatChoise(string regno, string programcode)
            {

                string dbCommand = ("IfLockedProgramSeat");
                var parameters = new List<IDbDataParameter>();



                parameters.Add(dbManager.CreateParameter("RegNo", regno, DbType.String));

                parameters.Add(dbManager.CreateParameter("ProgramCode", programcode, DbType.String));



                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.GetScalarValue(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }





        }
    }
    #endregion

    #region SpecialProgram


    namespace DataLayer
    {
        public class tbl_SubProgramsDAO
        {
            DBManager dbManager = new DBManager();
            IDbConnection connection = null;

            public List<tbl_SubPrograms> GetAlltbl_SubPrograms()
            {

                string dbCommand = "spGettbl_SubProgramsAll";

                List<tbl_SubPrograms> list = new List<tbl_SubPrograms>();
                try
                {
                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, null, out connection))
                    {

                        while (dataReader.Read())
                        {

                            tbl_SubPrograms obj = new tbl_SubPrograms();

                            if (dataReader["SubSrNo"] != DBNull.Value) { obj.SubSrNo = (int)dataReader["SubSrNo"]; }
                            if (dataReader["ProgramCode"] != DBNull.Value) { obj.ProgramCode = (string)dataReader["ProgramCode"]; }
                            if (dataReader["SubProgramCode"] != DBNull.Value) { obj.SubProgramCode = (string)dataReader["SubProgramCode"]; }
                            if (dataReader["SubProgramName"] != DBNull.Value) { obj.SubProgramName = (string)dataReader["SubProgramName"]; }
                            if (dataReader["SubSelectionMode"] != DBNull.Value) { obj.SubSelectionMode = (string)dataReader["SubSelectionMode"]; }
                            if (dataReader["InstituteName"] != DBNull.Value) { obj.InstituteName = (string)dataReader["InstituteName"]; }
                            if (dataReader["ProgramFee"] != DBNull.Value) { obj.ProgramFee = (string)dataReader["ProgramFee"]; }
                            if (dataReader["SpecialFee"] != DBNull.Value) { obj.SpecialFee = (string)dataReader["SpecialFee"]; }

                            list.Add(obj);

                        }

                    }
                }
                catch { }
                finally { dbManager.CloseConnection(connection); }
                return list;

            }

            public bool managetbl_SubPrograms(tbl_SubPrograms sub)
            {

                string dbCommand = "spManagetbl_SubPrograms";
                var parameters = new List<IDbDataParameter>();


                parameters.Add(dbManager.CreateParameter("SubSrNo", sub.SubSrNo, DbType.Int32));
                parameters.Add(dbManager.CreateParameter("ProgramCode", sub.ProgramCode, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubProgramCode", sub.SubProgramCode, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubProgramName", sub.SubProgramName, DbType.String));
                parameters.Add(dbManager.CreateParameter("SubSelectionMode", sub.SubSelectionMode, DbType.String));
                parameters.Add(dbManager.CreateParameter("InstituteName", sub.InstituteName, DbType.String));
                parameters.Add(dbManager.CreateParameter("ProgramFee", sub.ProgramFee, DbType.String));
                parameters.Add(dbManager.CreateParameter("SpecialFee", sub.SpecialFee, DbType.String));

                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }





        }
    }

    #endregion

    #region SubProgramAppfrm

    namespace DataLayer

    {
        public class tbl_Appfrm_AppliedSubProgramDAO
        {

            DBManager dbManager = new DBManager();
            IDbConnection connection = null;
            public List<tbl_Appfrm_AppliedSubProgram> GetAlltbl_Appfrm_AppliedSubProgram(string regNo, string ProgramCode)
            {

                string dbCommand = "spGettbl_Appfrm_AppliedSubProgramAllByRegNoProgramCode";

                List<tbl_Appfrm_AppliedSubProgram> list = new List<tbl_Appfrm_AppliedSubProgram>();
                var parameters = new List<IDbDataParameter>();


                parameters.Add(dbManager.CreateParameter("RegNo", regNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("ProgramCode", ProgramCode, DbType.String));
                try
                {
                    using (IDataReader dataReader = dbManager.GetDataReader(dbCommand, System.Data.CommandType.StoredProcedure, parameters.ToArray(), out connection))
                    {


                        while (dataReader.Read())
                        {

                            tbl_Appfrm_AppliedSubProgram obj = new tbl_Appfrm_AppliedSubProgram();

                            if (dataReader["ID"] != DBNull.Value) { obj.ID = (int)dataReader["ID"]; }
                            if (dataReader["AcknowledgementNo"] != DBNull.Value) { obj.AcknowledgementNo = (string)dataReader["AcknowledgementNo"]; }
                            if (dataReader["RegNo"] != DBNull.Value) { obj.RegNo = (string)dataReader["RegNo"]; }
                            if (dataReader["AppliedProgram"] != DBNull.Value) { obj.AppliedProgram = (string)dataReader["AppliedProgram"]; }
                            if (dataReader["AppliedMode"] != DBNull.Value) { obj.AppliedMode = (string)dataReader["AppliedMode"]; }
                            if (dataReader["PaidFee"] != DBNull.Value) { obj.PaidFee = (string)dataReader["PaidFee"]; }
                            if (dataReader["IsPaid"] != DBNull.Value) { obj.IsPaid = (bool)dataReader["IsPaid"]; }
                            if (dataReader["IsActive"] != DBNull.Value) { obj.IsActive = (bool)dataReader["IsActive"]; }
                            if (dataReader["IsDelete"] != DBNull.Value) { obj.IsDelete = (bool)dataReader["IsDelete"]; }
                            if (dataReader["RegistrationDate"] != DBNull.Value) { obj.RegistrationDate = (string)dataReader["RegistrationDate"]; }
                            if (dataReader["CompletionDate"] != DBNull.Value) { obj.CompletionDate = (string)dataReader["CompletionDate"]; }

                            list.Add(obj);

                        }

                    }
                }
                catch { }
                finally { dbManager.CloseConnection(connection); }

                return list;

            }

            public bool Managetbl_Appfrm_AppliedSubProgram(tbl_Appfrm_AppliedSubProgram sub)
            {

                string dbCommand = "spManagetbl_Appfrm_AppliedSubProgram";


                var parameters = new List<IDbDataParameter>();


                parameters.Add(dbManager.CreateParameter("ID", sub.ID, DbType.Int32));
                parameters.Add(dbManager.CreateParameter("AcknowledgementNo", sub.AcknowledgementNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("RegNo", sub.RegNo, DbType.String));
                parameters.Add(dbManager.CreateParameter("AppliedProgram", sub.AppliedProgram, DbType.String));
                parameters.Add(dbManager.CreateParameter("AppliedMode", sub.AppliedMode, DbType.String));
                parameters.Add(dbManager.CreateParameter("PaidFee", sub.PaidFee, DbType.String));
                parameters.Add(dbManager.CreateParameter("IsPaid", sub.IsPaid, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("IsActive", sub.IsActive, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("IsDelete", sub.IsDelete, DbType.Boolean));
                parameters.Add(dbManager.CreateParameter("RegistrationDate", sub.RegistrationDate, DbType.String));
                parameters.Add(dbManager.CreateParameter("CompletionDate", sub.CompletionDate, DbType.String));
                bool flag = false;
                try
                {

                    flag = Convert.ToBoolean(dbManager.ExecuteNonQuery(dbCommand, CommandType.StoredProcedure, parameters.ToArray()));
                }
                catch { throw; }
                finally
                {
                    dbManager.CloseConnection(connection);
                }
                return flag;

            }




        }
    }
    #endregion
}

Youez - 2016 - github.com/yon3zu
LinuXploit