Пример #1
0
    protected void btnApprove_Click(object sender, EventArgs e)
    {
        lblCancelSuccessMSG.Text = "";
        lngRecordId = GetRecordId();
        acnt        = GetApprovalCount();
        HttpClient HClient = new HttpClient();

        HClient.BaseAddress = new Uri(DataAcces.Url);
        HClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
        Pl_SubmitZeroLevel pl = new Pl_SubmitZeroLevel();

        pl.Ind           = 2;
        pl.ApplicationID = Convert.ToInt32(ApplicatioID);
        pl.UserID        = Convert.ToInt32(Session["UserId"]);
        pl.EntryByIP     = (IpAddress = GetIpAddress());
        pl.UserTypeId    = Convert.ToInt32(Session["UserTypeId"]);
        pl.recordId      = lngRecordId;
        pl.acnt          = acnt;
        pl.DocType       = DocTypeID;
        pl.Remarks       = txtRemark.Text;
        var uri      = "api/SecondLevel/PostApprovalRecord";
        var response = HClient.PostAsJsonAsync(uri, pl).Result;

        if (response.IsSuccessStatusCode)
        {
            var getdata = response.Content.ReadAsAsync <IEnumerable <PL_SecondLevel> >().Result;
            if (getdata != null)
            {
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Notify", "alert('Data Submitted.');window.location='FrmZeroLevel.aspx';", true);
            }
            getdata = null;
        }
        response = null; uri = null;
    }
Пример #2
0
    void GetCancelApplicationList()
    {
        HttpClient HClient = new HttpClient();

        HClient.BaseAddress = new Uri(DataAcces.Url);
        HClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
        Pl_SubmitZeroLevel pl = new Pl_SubmitZeroLevel();

        pl.Ind       = 52;
        pl.UserID    = Convert.ToInt32(Session["UserId"]);
        pl.CancelInd = 1;

        var uri      = "api/SecondLevel/CancelApplicationList";
        var response = HClient.PostAsJsonAsync(uri, pl).Result;

        if (response.IsSuccessStatusCode)
        {
            var getCanceldata = response.Content.ReadAsAsync <DataTable>().Result;
            if (getCanceldata.Rows.Count > 0)
            {
                lblCounter.Text = Convert.ToString(getCanceldata.Rows.Count);
                grdCancelApplicationList.DataSource = getCanceldata;
                grdCancelApplicationList.DataBind();
            }
            else
            {
                lblCounter.Text    = "0";
                lblCounter.Visible = true;
                grdCancelApplicationList.DataSource = new DataTable();
                grdCancelApplicationList.DataBind();
            }
        }
    }
        public DataTable PostRejectionRecord(Pl_SubmitZeroLevel pl)
        {
            DataTable dt = new DataTable();

            objPlSecondlevel.dt = objDlSecondlevel.SubmitRejection(pl);
            return(objPlSecondlevel.dt);
        }
Пример #4
0
        public DataTable SubmitRejection(Pl_SubmitZeroLevel pl)
        {
            SqlCommand cmd1 = new SqlCommand("SPApplicationEntry", con);

            cmd1.CommandType = CommandType.StoredProcedure;
            cmd1.Parameters.AddWithValue("@Ind", pl.Ind);
            cmd1.Parameters.AddWithValue("@ApplicationID", pl.ApplicationID);
            cmd1.Parameters.AddWithValue("@DocType", pl.DocType);
            cmd1.Parameters.AddWithValue("@LevelID", pl.UserTypeId);
            cmd1.Parameters.AddWithValue("@UserID", pl.UserID);
            cmd1.Parameters.AddWithValue("@LevelRemark", pl.Remarks);
            cmd1.Parameters.AddWithValue("@EntryByIP", pl.EntryByIP);
            cmd1.Parameters.AddWithValue("@ApprovalCount", pl.acnt);
            // cmd1.Parameters.AddWithValue("@MaxApproval",pl.maxaproval);
            cmd1.Parameters.AddWithValue("@RecordID", pl.recordId);
            cmd1.Parameters.AddWithValue("@IsConfirmed", false);
            cmd1.Parameters.AddWithValue("@IsRejected", true);
            cmd1.Parameters.AddWithValue("@IsCorrectionReqd", false);
            da = new SqlDataAdapter(cmd1);
            DataTable dt = new DataTable();

            da.Fill(dt);

            return(dt);
        }
Пример #5
0
    protected void lnkSave_Click(object sender, EventArgs e)
    {
        lblCancelMSG.Text = lblCancelSuccessMSG.Text = "";
        if (string.IsNullOrEmpty(txtCancelReason.Text))
        {
            cancelApplicationModal.Style.Add("display", "block");
            lblCancelMSG.Text    = "Please Enter Cancel Reason.";
            txtCancelReason.Text = "";
            txtCancelReason.Focus();
        }
        else
        {
            if (txtCancelReason.Text.Count() < 10)
            {
                cancelApplicationModal.Style.Add("display", "block");
                lblCancelMSG.Text = "Please Enter Minimum 10 Char.";
                //txtCancelReason.Text = "";
                txtCancelReason.Focus();
            }
            else
            {
                HttpClient HClient = new HttpClient();
                HClient.BaseAddress = new Uri(DataAcces.Url);
                HClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
                Pl_SubmitZeroLevel pl = new Pl_SubmitZeroLevel();
                pl.Ind            = 51;
                pl.ApplicationID  = Convert.ToInt32(lblApplicationID.Text);
                pl.UserID         = Convert.ToInt32(Session["UserId"]);
                pl.CancelInd      = 1;
                pl.CancelReason   = txtCancelReason.Text;
                pl.CancelDateTime = DateTime.Now;

                var uri      = "api/SecondLevel/PostCancelPopDetail";
                var response = HClient.PostAsJsonAsync(uri, pl).Result;
                if (response.IsSuccessStatusCode)
                {
                    var getdata = response.Content.ReadAsAsync <DataTable>().Result;
                    if (getdata.Rows.Count > 0)
                    {
                        if (getdata.Rows[0]["ReturnInd"].ToString() == "1")
                        {
                            lblCancelSuccessMSG.Text = "Record Cancel Successfully.";
                            cancelApplicationModal.Style.Add("display", "none");
                            lblCancelSuccessMSG.Style.Add("color", "#27c24c");
                            GetAppDetails();
                        }
                        else
                        {
                            lblCancelMSG.Text = "Record Not Cancelled Successfully.";
                            cancelApplicationModal.Style.Add("display", "block");
                        }
                    }
                }
                txtCancelReason.Text = "";
            }
        }
    }
 public DataTable PostSubmitPopDetail(Pl_SubmitZeroLevel pl)
 {
     if (pl != null)
     {
         objPlSecondlevel.dt = objDlSecondlevel.SubmitPopDetail(pl);
     }
     objPlSecondlevel.dt.TableName = "MyTable";
     return(objPlSecondlevel.dt);
 }
 public DataTable CancelApplicationList(Pl_SubmitZeroLevel pl)
 {
     if (pl != null)
     {
         objPlSecondlevel.dt = objDlSecondlevel.CancelApplicationList(pl);
     }
     objPlSecondlevel.dt.TableName = "MyTable";
     return(objPlSecondlevel.dt);
 }
Пример #8
0
    protected void lnkSubmit_Click(object sender, EventArgs e)
    {
        try
        {
            HttpClient HClient = new HttpClient();
            HClient.BaseAddress = new Uri(DataAcces.Url);
            HClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));

            Pl_SubmitZeroLevel pl = new Pl_SubmitZeroLevel();
            pl.Ind            = 1;
            pl.ApplicationID  = Convert.ToInt32(ApplicatioID);
            pl.Rollno         = txtRollNo.Text;
            pl.SName          = txtStudentName.Text;
            pl.ExamName       = txtExamName.Text;
            pl.BranchName     = txtBranchName.Text;
            pl.ExamSession    = Convert.ToString(0);
            pl.EnrollmentNo   = txtEnrollmentlNo.Text == "" ? "0" : txtEnrollmentlNo.Text;
            pl.College        = txtCollege.Text;
            pl.CGPA           = txtCGPA.Text == "" ? "0" : txtCGPA.Text;
            pl.Division       = txtDivision.Text;
            pl.UserID         = Convert.ToInt32(Session["UserId"]);
            pl.EntryByIP      = (IpAddress = GetIpAddress());
            pl.UserTypeId     = Convert.ToInt32(Session["UserTypeId"]);
            pl.maxaproval     = ApprovalCount;
            pl.DocType        = DocTypeID;
            pl.SubjectName    = txtSubjectName.Text;
            pl.DistinctionSub = txtDistinctionSub.Text;

            if (txtMeritNo.Text != string.Empty)
            {
                pl.MeritNo = Convert.ToInt32(txtMeritNo.Text);
            }
            else
            {
                pl.MeritNo = 0;
            }

            pl.LaterReferenceNo = txtLaterReferenceNo.Text;
            pl.PassingYear      = txtPassingYear.Text;
            pl.ExamMedium       = txtExamMedium.Text;

            var uri      = "api/SecondLevel/PostSubmitPopDetail/";
            var response = HClient.PostAsJsonAsync(uri, pl).Result;
            if (response.IsSuccessStatusCode)
            {
                var getdata = response.Content.ReadAsAsync <DataTable>().Result;
                if (getdata.Rows.Count > 0)
                {
                    Server.Transfer("FrmApproval.aspx");
                }
                getdata = null;
            }
            response = null; uri = null;
        }
        catch
        { }
    }
Пример #9
0
 internal DataTable CancelApplicationList(Pl_SubmitZeroLevel pl)
 {
     cmd             = new SqlCommand("SPApplicationDetail", con);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.AddWithValue("@Ind", pl.Ind);
     cmd.Parameters.AddWithValue("@UserID", pl.UserID);
     cmd.Parameters.AddWithValue("@CancelInd", pl.CancelInd);
     da = new SqlDataAdapter(cmd);
     dt = new DataTable();
     da.Fill(dt);
     return(dt);
 }
Пример #10
0
    protected void btnReject_Click(object sender, EventArgs e)
    {
        try
        {
            if (txtRemark.Text != null && txtRemark.Text != "")
            {
                lngRecordId = GetRecordId();
                acnt        = GetApprovalCount();
                HttpClient HClient = new HttpClient();
                HClient.BaseAddress = new Uri(DataAcces.Url);
                HClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
                Pl_SubmitZeroLevel pl = new Pl_SubmitZeroLevel();
                pl.Ind           = 2;
                pl.ApplicationID = Convert.ToInt32(ApplicatioID);
                pl.UserID        = Convert.ToInt32(Session["UserId"]);
                pl.EntryByIP     = (IpAddress = GetIpAddress());
                pl.UserTypeId    = Convert.ToInt32(Session["UserTypeId"]);
                pl.recordId      = lngRecordId;
                pl.acnt          = acnt;
                pl.DocType       = DocTypeID;
                pl.Remarks       = txtRemark.Text;
                //  pl.maxaproval = ApprovalCount;
                var uri      = "api/SecondLevel/PostRejectionRecord";
                var response = HClient.PostAsJsonAsync(uri, pl).Result;

                if (response.IsSuccessStatusCode)
                {
                    var getdata = response.Content.ReadAsAsync <DataTable>().Result;
                    if (getdata.Rows.Count > 0)
                    {
                        ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Notify", "alert('Application Rejected');window.location='FrmApproval.aspx';", true);
                    }
                    getdata = null;
                }
                response = null; uri = null;
            }
            else
            {
                lblmsg.Text = "Please Enter Remarks";
            }
        }
        catch { }
    }
Пример #11
0
        public DataTable SubmitApproval(Pl_SubmitZeroLevel pl)
        {
            DataTable dt = new DataTable();

            try
            {
                SqlCommand cmd1 = new SqlCommand("SPApplicationEntry", con);
                cmd1.CommandType = CommandType.StoredProcedure;
                cmd1.Parameters.AddWithValue("@Ind", 2);
                cmd1.Parameters.AddWithValue("@ApplicationID", pl.ApplicationID);
                cmd1.Parameters.AddWithValue("@DocType", pl.DocType);
                cmd1.Parameters.AddWithValue("@LevelID", pl.UserTypeId);
                cmd1.Parameters.AddWithValue("@LevelRemark", pl.Remarks);
                cmd1.Parameters.AddWithValue("@EntryByIP", pl.EntryByIP);
                cmd1.Parameters.AddWithValue("@ApprovalCount", pl.acnt);
                cmd1.Parameters.AddWithValue("@UserID", pl.UserID);
                cmd1.Parameters.AddWithValue("@RecordID", pl.recordId);
                cmd1.Parameters.AddWithValue("@IsConfirmed", true);
                cmd1.Parameters.AddWithValue("@IsRejected", false);
                cmd1.Parameters.AddWithValue("@IsCorrectionReqd", false);
                da = new SqlDataAdapter(cmd1);
                con.Close();
                da.Fill(dt);
                if (dt != null && dt.Rows.Count > 0)
                {
                    //  return dt;
                }
                else
                {
                    dt = null;
                }
            }
            catch (Exception ex)

            { msg = ex.Message; }
            return(dt);
        }
Пример #12
0
    protected void lnkSubmit_Click(object sender, EventArgs e)
    {
        string progress = "";

        lblCancelSuccessMSG.Text = "";
        //progress = zeroLevelCheck();
        if (txtExamName.Text != "")
        {
            if (progress == "")
            {
                HttpClient HClient = new HttpClient();
                HClient.BaseAddress = new Uri(DataAcces.Url);
                HClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
                Pl_SubmitZeroLevel pl = new Pl_SubmitZeroLevel();
                pl.Ind            = 1;
                pl.ApplicationID  = Convert.ToInt32(ApplicatioID);
                pl.Rollno         = txtRollNo.Text;
                pl.SName          = txtStudentName.Text;
                pl.ExamName       = txtExamName.Text;
                pl.BranchName     = txtBranchName.Text;
                pl.ExamSession    = Convert.ToString(0);
                pl.EnrollmentNo   = txtEnrollmentlNo.Text == "" ? "0" : txtEnrollmentlNo.Text;
                pl.College        = txtCollege.Text;
                pl.CGPA           = txtCGPA.Text == "" ? "0" : txtCGPA.Text;
                pl.Division       = txtDivision.Text;
                pl.UserID         = Convert.ToInt32(Session["UserId"]);
                pl.EntryByIP      = (IpAddress = GetIpAddress());
                pl.UserTypeId     = Convert.ToInt32(Session["UserTypeId"]);
                pl.maxaproval     = ApprovalCount;
                pl.DocType        = DocTypeID;
                pl.SubjectName    = txtSubjectName.Text;
                pl.DistinctionSub = txtDistinctionSub.Text;
                pl.Remarks        = txtRemark.Text;
                pl.Rank           = ddlRank.SelectedItem.Text;
                pl.AwardedBy      = ddlAwardedby.Text;

                if (ddlAwardedby.SelectedIndex == 3)
                {
                    pl.AwardPrize = Convert.ToDecimal(txtAwardPrize.Text);
                }
                else
                {
                    pl.AwardPrize = 0;
                }

                if (txtMeritNo.Text != string.Empty)
                {
                    pl.MeritNo = Convert.ToInt32(txtMeritNo.Text);
                }
                else
                {
                    pl.MeritNo = 0;
                }
                pl.LaterReferenceNo = txtLaterReferenceNo.Text;

                if (DocTypeID == 10)
                {
                    pl.LaterReferenceDate = Convert.ToDateTime(txtDateResultDeclaration.Text);
                }
                else if (DocTypeID == 8 || DocTypeID == 9)
                {
                    pl.LaterReferenceDate = Convert.ToDateTime(txtLaterReferenceDate.Text);
                }
                else
                {
                    pl.LaterReferenceDate = DateTime.Now.Date;
                }

                // pl.DateResultDeclaration = Convert.ToDateTime(txtDateResultDeclaration.Text);

                pl.PassingYear = txtPassingYear.Text;
                pl.ExamMedium  = txtExamMedium.Text;

                var uri      = "api/SecondLevel/PostSubmitPopDetail/";
                var response = HClient.PostAsJsonAsync(uri, pl).Result;
                if (response.IsSuccessStatusCode)
                {
                    var getdata = response.Content.ReadAsAsync <DataTable>().Result;
                    if (getdata.Rows.Count > 0)
                    {
                        ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Notify", "alert('Data Saved.');window.location='FrmZeroLevel.aspx';", true);
                    }
                    getdata = null;
                }
                response = null; uri = null;
            }
            else
            {
                msgVal.Text = progress;
                viewApplicationModal.Style.Add("display", "block");
                //Popup(true);
                return;
            }
        }
        else
        {
            msgVal.Text = "Please Enter Exam Name";
            viewApplicationModal.Style.Add("display", "block");
            //Popup(true);
            return;
        }
    }
Пример #13
0
        public DataTable SubmitPopDetail(Pl_SubmitZeroLevel pl)
        {
            DataTable dt = new DataTable();

            SqlCommand cmd = new SqlCommand("SPApplicationEntry", con);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@Ind", pl.Ind);
            cmd.Parameters.AddWithValue("@ApplicationID", pl.ApplicationID);
            cmd.Parameters.AddWithValue("@RollNo", pl.Rollno);
            cmd.Parameters.AddWithValue("@StudentName", pl.SName);
            cmd.Parameters.AddWithValue("@ExamName", pl.ExamName);
            cmd.Parameters.AddWithValue("@BranchName", pl.BranchName);
            cmd.Parameters.AddWithValue("@ExamSession", 0);
            cmd.Parameters.AddWithValue("@EnrollmentNo", pl.EnrollmentNo);
            cmd.Parameters.AddWithValue("@College", pl.College);
            cmd.Parameters.AddWithValue("@CGPA", pl.CGPA);
            cmd.Parameters.AddWithValue("@Division", pl.Division);
            cmd.Parameters.AddWithValue("@UserID", pl.UserID);
            cmd.Parameters.AddWithValue("@EntryByIP", pl.EntryByIP);
            cmd.Parameters.AddWithValue("@DocType", pl.DocType);
            cmd.Parameters.AddWithValue("@ExamPassingYear", pl.PassingYear);
            cmd.Parameters.AddWithValue("@ExamMedium", pl.ExamMedium);
            cmd.Parameters.AddWithValue("@MeritNo", pl.MeritNo);
            cmd.Parameters.AddWithValue("@SubjectName", pl.SubjectName);
            cmd.Parameters.AddWithValue("@DistinctionSubject", pl.DistinctionSub);
            cmd.Parameters.AddWithValue("@LetterRefNo", pl.LaterReferenceNo);
            cmd.Parameters.AddWithValue("@LetterRefDate", pl.LaterReferenceDate);
            cmd.Parameters.AddWithValue("@Ranking", pl.Rank);
            cmd.Parameters.AddWithValue("@AwardedBy", pl.AwardedBy);

            cmd.Parameters.AddWithValue("@AwardPrize", pl.AwardPrize);


            con.Open();
            int i = Convert.ToInt16(cmd.ExecuteScalar());

            con.Close();
            if (i > 0)
            {
                SqlCommand cmd1 = new SqlCommand("SPApplicationEntry", con);
                cmd1.CommandType = CommandType.StoredProcedure;
                cmd1.Parameters.AddWithValue("@Ind", 2);
                cmd1.Parameters.AddWithValue("@ApplicationID", pl.ApplicationID);
                //  cmd1.Parameters.AddWithValue("@ApplicationID", pl.UserID);
                //   cmd1.Parameters.AddWithValue("@DocType", pl.DocTypeID);
                cmd1.Parameters.AddWithValue("@DocType", pl.DocType);
                cmd1.Parameters.AddWithValue("@UserID", pl.UserID);
                cmd1.Parameters.AddWithValue("@LevelID", pl.UserTypeId);
                cmd1.Parameters.AddWithValue("@LevelRemark", pl.Remarks);
                cmd1.Parameters.AddWithValue("@EntryByIP", pl.EntryByIP);
                cmd1.Parameters.AddWithValue("@ApprovalCount", 0);
                //  cmd1.Parameters.AddWithValue("@MaxApproval",pl.ApprovalCount);


                cmd1.Parameters.AddWithValue("@RecordID", i);
                cmd1.Parameters.AddWithValue("@IsConfirmed", false);
                cmd1.Parameters.AddWithValue("@IsRejected", false);
                cmd1.Parameters.AddWithValue("@IsCorrectionReqd", false);
                con.Open();
                // j = Convert.ToInt16(cmd1.ExecuteScalar());
                da = new SqlDataAdapter(cmd1);
                con.Close();
                da.Fill(dt);
                if (dt != null && dt.Rows.Count > 0)
                {
                    //  return dt;
                }
                else
                {
                    dt = null;
                }
            }


            return(dt);
        }
 public DataTable PostApprovalRecord(Pl_SubmitZeroLevel objplSecondLevel)
 {
     objPlSecondlevel.dt = objDlSecondlevel.SubmitApproval(objplSecondLevel);
     return(objPlSecondlevel.dt);
 }
Пример #15
0
    public void GetDoctypeDetail(DataRow dr)
    {
        lblCertifiacate.Attributes.CssStyle.Remove("font-size");
        spanforPrize.InnerText = spanAwardPrize.InnerText = "";
        pl         = new Pl_SubmitZeroLevel();
        pl.SName   = dr["StudentName"].ToString();
        lblNo.Text = dr["SrNo"].ToString();
        switch (Convert.ToInt16(Session["DocType"]))
        {
        case 2:     //Provision Certificate
            Provisional.Visible  = true;
            lblCertifiacate.Text = "Provisional Certificate";
            pl.Rollno            = dr["RollNo"].ToString();
            pl.EnrollmentNo      = dr["EnrollmentNo"].ToString();
            pl.ExamName          = dr["ExamName"].ToString() + " - " + dr["ExamYear"] + " (" + dr["ExamSession"] + ").";
            pl.CGPA     = dr["CGPAPercentage"].ToString();
            pl.College  = dr["College"].ToString();
            pl.Division = dr["Division"].ToString().ToUpper();
            Signature   = "Asstt. Registrar(Tabulation)";
            //divFloatRight.Style.Add("margin-top", "30px");
            lblVerification.Visible = lblYours.Visible = false;
            break;

        case 3:     //Passing Certificate
            passingcertificate.Visible = true;
            lblCertifiacate.Text       = "Passing Certificate";
            pl.Rollno         = dr["RollNo"].ToString();
            pl.EnrollmentNo   = dr["EnrollmentNo"].ToString();
            pl.ExamName       = dr["ExamName"].ToString();
            pl.SubjectName    = dr["SubjectName"].ToString();
            pl.ExamSession    = dr["ExamSession"] + " - " + dr["ExamYear"] + ".";
            pl.DistinctionSub = string.IsNullOrEmpty(dr["DistinctionSubject"].ToString()) ? " None." : dr["DistinctionSubject"].ToString() + ".";
            Signature         = "Asstt. Registrar(Exams.)";
            //divFloatRight.Style.Add("margin-top", "30px");
            lblVerification.Visible = lblYours.Visible = false;
            break;

        case 4:     // Merit Certificate
            MeritCertificate.Visible = true;
            lblCertifiacate.Text     = "Merit Certificate";
            pl.Rollno      = dr["RollNo"].ToString();
            pl.ExamName    = dr["ExamName"].ToString();
            pl.ExamSession = dr["ExamSession"] + "-" + dr["ExamYear"];
            pl.Division    = dr["Division"].ToString().ToUpper();
            pl.MeritNo     = Convert.ToInt32(dr["MeritNo"]);
            Signature      = "Assistant Registrar(Exams.)";
            //divFloatRight.Style.Add("margin-top", "30px");
            lblVerification.Visible = lblYours.Visible = false;
            break;

        case 5:     // Attempt Certificate
            AttempCerificate.Visible = true;
            lblCertifiacate.Text     = "Attempt Certificate";
            pl.Rollno      = dr["RollNo"].ToString();
            pl.ExamName    = dr["ExamName"].ToString();
            pl.ExamSession = dr["ExamSession"] + " - " + dr["ExamYear"];
            Signature      = "Asstt. Registrar(Tabulation)";
            //divFloatRight.Style.Add("margin-top", "30px");
            lblVerification.Visible = lblYours.Visible = false;
            break;

        case 6:     // Medal Certificate
            MedalCertificate.Visible = true;
            lblCertifiacate.Text     = "Certificate of Award";
            pl.Rollno       = dr["RollNo"].ToString();
            pl.EnrollmentNo = dr["EnrollmentNo"].ToString();
            pl.ExamName     = dr["ExamName"].ToString();
            pl.ExamSession  = dr["ExamSession"] + " - " + dr["ExamYear"];
            pl.Division     = dr["Division"].ToString().ToUpper();
            pl.Rank         = dr["Ranking"].ToString();
            pl.AwardedBy    = dr["AwardedBy"].ToString();
            pl.SubjectName  = dr["SubjectName"].ToString();
            if (pl.AwardedBy == "Cash Prize")
            {
                if (!String.IsNullOrEmpty(dr["AwardPrize"].ToString()))
                {
                    spanforPrize.InnerText   = " for Rs. ";
                    spanAwardPrize.InnerText = dr["AwardPrize"].ToString();
                }
            }
            Signature = "Registrar";
            //divFloatRight.Style.Add("margin-top", "30px");
            lblVerification.Visible = lblYours.Visible = false;
            break;

        //case 7: //Duplicate MarkSheet
        //    MarkSheetVerification.Visible = true;
        //    lblCertifiacate.Text = "Duplicate MarkSheet";
        //    pl.ExamName = dr["ExamName"].ToString();
        //    pl.ExamSession = dr["ExamSession"] + " - " + dr["ExamYear"] + ".";
        //    pl.Rollno = dr["RollNo"].ToString();
        //    pl.Division = dr["Division"].ToString().ToUpper();
        //    //pl.LaterReferenceNo = dr["LetterRefNo"].ToString();
        //    //pl.LaterReferenceDate = Convert.ToDateTime(dr["LetterRefDate"]);
        //    //Signature = "Asstt. Registrar()";
        //    break;

        case 8:     //MarkSheet Verification Certifiacte
            MarkSheetVerification.Visible = true;
            lblCertifiacate.Text          = "Marks Verification Certificate";
            pl.ExamName           = dr["ExamName"].ToString();
            pl.ExamSession        = dr["ExamSession"] + " - " + dr["ExamYear"] + ".";
            pl.Rollno             = dr["RollNo"].ToString();
            pl.Division           = dr["Division"].ToString().ToUpper();
            pl.LaterReferenceNo   = dr["LetterRefNo"].ToString();
            pl.LaterReferenceDate = Convert.ToDateTime(dr["LetterRefDate"]);
            Signature             = "Asstt. Registrar(Exam)";
            //divFloatRight.Style.Add("margin-top", "30px");
            lblVerification.Visible = lblYours.Visible = false;
            break;

        case 9:     //Degree Verification Certificate
            DegreeVerification.Visible = true;
            lblCertifiacate.Text       = "Degree Verification Certificate";
            pl.ExamName           = dr["ExamName"].ToString();
            pl.ExamSession        = dr["ExamSession"] + " - " + dr["ExamYear"] + ".";
            pl.Rollno             = dr["RollNo"].ToString();
            pl.Division           = dr["Division"].ToString().ToUpper();
            pl.BranchName         = dr["ExamBranch"].ToString();
            pl.LaterReferenceNo   = dr["LetterRefNo"].ToString();
            pl.LaterReferenceDate = Convert.ToDateTime(dr["LetterRefDate"]);
            lblVerification.Text  = "Verification";
            Signature             = "Asstt. Registrar(Tabulation)";
            //divFloatRight.Style.Add("margin-top", "30px");
            lblVerification.Visible = lblYours.Visible = true;
            break;

        case 10:                                                                                             //Date Of Dectlaration Certificate
            DateOfDeclaration.Visible = true;
            lblCertifiacate.Text      = "Certificate of Subjects offered and date of declaration of result"; //"Date Of Declaration Certificate";
            pl.Rollno                = dr["RollNo"].ToString();
            pl.EnrollmentNo          = dr["EnrollmentNo"].ToString();
            pl.ExamName              = dr["ExamName"].ToString();
            pl.ExamSession           = dr["ExamSession"] + " - " + dr["ExamYear"];
            pl.DateResultDeclaration = Convert.ToDateTime(dr["LetterRefDate"]);
            pl.SubjectName           = dr["SubjectName"].ToString();
            lblCertifiacate.Attributes.CssStyle.Add("font-size", "16px");
            Signature = "Asstt. Registrar(Exams.)";
            //divFloatRight.Style.Add("margin-top", "30px");
            lblVerification.Visible = lblYours.Visible = false;
            break;

        case 11:     //Medium of Instruction Certificate
            MediumOfInstruction.Visible = true;
            lblCertifiacate.Text        = "Medium of Instruction Certificate";
            pl.ExamName    = dr["ExamName"].ToString();
            pl.ExamSession = dr["ExamSession"] + " - " + dr["ExamYear"];
            pl.Rollno      = dr["RollNo"].ToString();
            Signature      = "Asstt. Registrar(Exams/Enquiry)";
            //divFloatRight.Style.Add("margin-top", "30px");
            lblVerification.Visible = lblYours.Visible = false;
            break;

        default:
            break;
        }
    }