コード例 #1
0
        private void GetGuardianDetailsToHF(int admissionno)
        {
            Hashtable ht = new Hashtable();

            ht.Add("AdmissionNo", admissionno);

            DataTable dt = StudentProfileBLL.GetGuardianDetailsToProfile(ht);

            if (dt.Rows.Count > 0)
            {
                //txtAddmissionNo.Text = dataTable.Rows[0]["AdmissionNo"].ToString();
                // students

                lblGname.Text = dt.Rows[0]["Nameguardian"].ToString();

                lblGnationality.Text = dt.Rows[0]["NationalityName"].ToString();
                lblGrel.Text         = dt.Rows[0]["RelationName"].ToString();
                lblGresAdd.Text      = dt.Rows[0]["Residentialaddressguardian"].ToString();
                lblGpreAdd.Text      = dt.Rows[0]["Presentaddressguardian"].ToString();
                lblGperAdd.Text      = dt.Rows[0]["Permanentaddressguardian"].ToString();
                lblGPNo.Text         = dt.Rows[0]["Telephoneguardian"].ToString();
                lblGMobile.Text      = dt.Rows[0]["Mobileguardian"].ToString();
                lblGemail.Text       = dt.Rows[0]["Emailguardian"].ToString();
            }
        }
コード例 #2
0
        private void GetStudentDetailsToHF(int admissionno)
        {
            Hashtable ht = new Hashtable();

            ht.Add("AdmissionNo", admissionno);

            DataTable dt = StudentProfileBLL.GetStudentDetailsToProfile(ht);

            if (dt.Rows.Count > 0)
            {
                //txtAddmissionNo.Text = dataTable.Rows[0]["AdmissionNo"].ToString();
                // students
                lblstuname.Text = dt.Rows[0]["Name"].ToString();
                lbladmsnNO.Text = dt.Rows[0]["AdmissionNo"].ToString();

                DateTime a = Convert.ToDateTime(dt.Rows[0]["AdmissionDate"].ToString());
                lbladmissiondate.Text = a.ToString("dd/MM/yyyy");

                lblSID.Text = dt.Rows[0]["StudentID"].ToString();

                DateTime b = Convert.ToDateTime(dt.Rows[0]["DOB"].ToString());
                lblDOB.Text = b.ToString("dd/MM/yyyy");

                lblGender.Text     = dt.Rows[0]["GenderName"].ToString();
                lblblood.Text      = dt.Rows[0]["BloodGroupName"].ToString();
                lblBirthplace.Text = dt.Rows[0]["BirthPlace"].ToString();

                lblnationality.Text = dt.Rows[0]["NationalityName"].ToString();

                lbllanguage.Text = dt.Rows[0]["Language"].ToString();
                lblreligion.Text = dt.Rows[0]["Religion"].ToString();

                lblStucategory.Text = dt.Rows[0]["StudentCategoryName"].ToString();
                lblCurrAdd.Text     = dt.Rows[0]["CurrentAddress"].ToString();
                lblPerAdd.Text      = dt.Rows[0]["PermanentAddress"].ToString();
                lblcity.Text        = dt.Rows[0]["City"].ToString();
                lblpincode.Text     = dt.Rows[0]["PinCode"].ToString();

                lblcountry.Text = dt.Rows[0]["CountryName"].ToString();

                lblphone.Text  = dt.Rows[0]["PhoneNumber"].ToString();
                lblphone2.Text = dt.Rows[0]["PhoneNUmber2"].ToString();
                lblemail.Text  = dt.Rows[0]["Email"].ToString();


                if (dt.Rows[0]["StudentPhoto"].ToString().Trim() != "")
                {
                    Image1.Visible = true;
                    var photo = dt.Rows[0]["StudentPhoto"].ToString().Trim();
                    Image1.ImageUrl = "~/img/Photos/" + dt.Rows[0]["StudentPhoto"].ToString().Trim();
                }
                else
                {
                    Image1.Visible = false;
                    Image1.ID      = null;
                }
            }
        }
コード例 #3
0
        private void GetParentsDetailsToHF(int admissionno)
        {
            Hashtable ht = new Hashtable();

            ht.Add("AdmissionNo", admissionno);

            DataTable dt = StudentProfileBLL.GetParentsDetailsToProfile(ht);

            if (dt.Rows.Count > 0)
            {
                // fathers`

                lblFname.Text          = dt.Rows[0]["Namefather"].ToString();
                lblFnationality.Text   = dt.Rows[0]["NationalityName"].ToString();
                lblFmaritalstatus.Text = dt.Rows[0]["ddlmaritalstatusf"].ToString();
                lblFeducation.Text     = dt.Rows[0]["Educationfather"].ToString();
                lblFocc.Text           = dt.Rows[0]["Occupationfather"].ToString();
                lblForg.Text           = dt.Rows[0]["Organizationfather"].ToString();
                lblFdesignation.Text   = dt.Rows[0]["Designationfather"].ToString();
                lblFyearofservice.Text = dt.Rows[0]["Yearofservicefather"].ToString();
                lblFOffAdd.Text        = dt.Rows[0]["Officeaddressfather"].ToString();
                lblFoffTelephone.Text  = dt.Rows[0]["OfficeTelephonefather"].ToString();

                lblFresidence.Text = dt.Rows[0]["Residentialaddressfather"].ToString();
                lblFPreAdd.Text    = dt.Rows[0]["Presentaddressfather"].ToString();
                lblFPerAdd.Text    = dt.Rows[0]["Permanentaddressfather"].ToString();
                lblFTelephone.Text = dt.Rows[0]["Telephonefather"].ToString();
                lblFMobile.Text    = dt.Rows[0]["Mobilefather"].ToString();
                lblFmail.Text      = dt.Rows[0]["Emailfather"].ToString();
                lblFresidence.Text = dt.Rows[0]["Residencewithfather"].ToString();



                //mother`s

                lblMName.Text          = dt.Rows[0]["Namemother"].ToString();
                lblMnationality.Text   = dt.Rows[0]["NationalityName"].ToString();
                lblMmaritalStatus.Text = dt.Rows[0]["ddlmaritalstatusf"].ToString();
                lblMeducation.Text     = dt.Rows[0]["Educationmother"].ToString();
                lblMocc.Text           = dt.Rows[0]["Occupationmother"].ToString();
                lblMOrg.Text           = dt.Rows[0]["Organizationmother"].ToString();
                lblMdesignation.Text   = dt.Rows[0]["Designationmother"].ToString();
                lblMYearofservice.Text = dt.Rows[0]["Yearofservicemother"].ToString();
                lblMoffAdd.Text        = dt.Rows[0]["Officeaddressmother"].ToString();
                lblMoffTel.Text        = dt.Rows[0]["Officetelephonemother"].ToString();

                lblMresidence.Text            = dt.Rows[0]["Residentialaddessmother"].ToString();
                lblMPreAdd.Text               = dt.Rows[0]["Presentaddressmother"].ToString();
                lblMPerAdd.Text               = dt.Rows[0]["Permanentaddressmother"].ToString();
                lblMTelephone.Text            = dt.Rows[0]["Telephonemother"].ToString();
                lblMMobile.Text               = dt.Rows[0]["Mobilemother"].ToString();
                lblMemail.Text                = dt.Rows[0]["Emailmother"].ToString();
                lblMresidencewithstudent.Text = dt.Rows[0]["Residencewithmother"].ToString();
            }
        }
コード例 #4
0
        private void GetStudentProfileBasic(int admissionno)
        {
            Hashtable ht = new Hashtable();

            ht.Add("AdmissionNo", admissionno);

            DataTable dt = StudentProfileBLL.GetStudentBasicDetailsToProfile(ht);

            if (dt.Rows.Count > 0)
            {
                lblSbatch.Text   = dt.Rows[0]["BatchYear"].ToString();
                lblSGrade.Text   = dt.Rows[0]["Class"].ToString();
                lblSSection.Text = dt.Rows[0]["SectionName"].ToString();
                lblSSession.Text = dt.Rows[0]["Session"].ToString();
            }
        }
コード例 #5
0
        private void GetContactDetailsToHF(int admissionno)
        {
            Hashtable ht = new Hashtable();

            ht.Add("AdmissionNo", admissionno);

            DataTable dt = StudentProfileBLL.GetContactDetailsToProfile(ht);

            if (dt.Rows.Count > 0)
            {
                // emergency contact

                lblEname.Text        = dt.Rows[0]["NameE"].ToString();
                lblEnationality.Text = dt.Rows[0]["NationalityName"].ToString();
                lblErel.Text         = dt.Rows[0]["RsWithStudentE"].ToString();
                lblEpreAdd.Text      = dt.Rows[0]["PresentAddressE"].ToString();
                lblEperAdd.Text      = dt.Rows[0]["PermanentAddressE"].ToString();
                lblETelephone.Text   = dt.Rows[0]["TelephoneNoE"].ToString();
                lblEmobile.Text      = dt.Rows[0]["MobileNoE"].ToString();
                lblEemail.Text       = dt.Rows[0]["EmailE"].ToString();


                //referees

                lblR1name.Text        = dt.Rows[0]["NameR1"].ToString();
                lblR1nationality.Text = dt.Rows[0]["NationalityName"].ToString();
                lblR1rel.Text         = dt.Rows[0]["RsWithStudentR1"].ToString();
                lblR1preadd.Text      = dt.Rows[0]["PresentAddressR1"].ToString();
                lblR1peradd.Text      = dt.Rows[0]["PermanentAddressR1"].ToString();
                lblR1Telephone.Text   = dt.Rows[0]["TelephoneNoR1"].ToString();
                lblR1Mobile.Text      = dt.Rows[0]["MobileNoR1"].ToString();
                lblR1mail.Text        = dt.Rows[0]["EmailR1"].ToString();

                lblR2name.Text        = dt.Rows[0]["NameR2"].ToString();
                lblR2nationality.Text = dt.Rows[0]["NationalityName"].ToString();
                lblR2rel.Text         = dt.Rows[0]["RsWithStudentR2"].ToString();
                lblR2preadd.Text      = dt.Rows[0]["PresentAddressR2"].ToString();
                lblR2peradd.Text      = dt.Rows[0]["PermanentAddressR2"].ToString();
                lblR2tel.Text         = dt.Rows[0]["TelephoneNoR2"].ToString();
                lblR2mobile.Text      = dt.Rows[0]["MobileNoR2"].ToString();
                lblR2email.Text       = dt.Rows[0]["EmailR2"].ToString();
            }
        }
コード例 #6
0
        private void GetPreviousDetailsToHF(int admissionno)
        {
            Hashtable ht = new Hashtable();

            ht.Add("AdmissionNo", admissionno);

            DataTable dt = StudentProfileBLL.GetPreviousDetailsToProfile(ht);

            if (dt.Rows.Count > 0)
            {
                //txtAddmissionNo.Text = dataTable.Rows[0]["AdmissionNo"].ToString();
                // students

                lblPrevIname.Text              = dt.Rows[0]["Institutename"].ToString();
                lblPrevGrade.Text              = dt.Rows[0]["Prevgrade"].ToString();
                lblPrevAdd.Text                = dt.Rows[0]["Addressschool"].ToString();
                lblPrevTel.Text                = dt.Rows[0]["Telephoneschool"].ToString();
                lblPrevmail.Text               = dt.Rows[0]["Emailschool"].ToString();
                lblPrevdateattended.Text       = dt.Rows[0]["Dateattended"].ToString();
                lblPrevAttendingcurrently.Text = dt.Rows[0]["Attendingcurrently"].ToString();
            }
        }