Example #1
0
    protected void SendAlert()
    {
        string msg     = "";
        string from    = "*****@*****.**";
        string subject = "Patent Renewal Request Notification";
        string str4    = "";

        if (Session["xcode"] != null)
        {
            str4 = Session["xcode"].ToString();
        }
        pt.Renewal renewal = new pt.Renewal();
        if (Session["Cx"] != null)
        {
            renewal = (pt.Renewal)Session["Cx"];
            msg     = ((((msg + "Dear <b>" + renewal.agt_name + "</b>, <br/>") + "This is to notify you that your patent application with application number <b>\"" + renewal.app_no + "\"</b> has been renewed. <br/>") + "Kindly print the certificate of the renewal <a href=\"http://pt.cldng.com/xpt/admin/pt/acceptance_unit/cert_status.aspx\">here</a>: ") + "using your transaction ID and this <b>code( " + str4 + " )</b> <br/>") + "Regards";
            Email email = new Email();
            if (email.sendMail("Commercial Law Department", renewal.agt_email, from, subject, msg, "") == "sent")
            {
                if (z.e_Contact_formStatus(succ, "1") > 0)
                {
                    base.Response.Write("<script language=\"javascript\" type=\"text/javascript\" >alert('E-mail sent successfully to the agent')</script>");
                    base.Response.Redirect("./profile.aspx");
                }
                else
                {
                    base.Response.Write("<script language=\"javascript\" type=\"text/javascript\">alert('E-mail not sent, Please check your internet connection or try again later')</script>");
                }
            }
            else
            {
                base.Response.Write("<script language=\"javascript\" type=\"text/javascript\">alert('The E-mail could not be sent, Please check your internet connection or try again later')</script>");
            }
        }
    }
Example #2
0
    public string updateRenewal(pt.Renewal aa)
    {
        string        connectionString = Connect();
        string        str2             = "";
        SqlConnection connection       = new SqlConnection(connectionString);
        SqlCommand    command          = connection.CreateCommand();

        command.CommandText  = "UPDATE renewal SET title=@title,type=@type,reg_no=@reg_no,app_no=@app_no,app_date=@app_date,xname=@xname ,xmobile=@xmobile ,xemail=@xemail,xaddy=@xaddy,  ";
        command.CommandText += " agt_code=@agt_code,agt_name=@agt_name,agt_addy=@agt_addy,agt_mobile=@agt_mobile,agt_email=@agt_email,last_rwl_date=@last_rwl_date ,reg_date=@reg_date ";
        command.CommandText += " WHERE log_staff=@papp ";
        connection.Open();
        command.Parameters.Add("@title", SqlDbType.NVarChar);
        command.Parameters.Add("@type", SqlDbType.NVarChar);
        command.Parameters.Add("@reg_no", SqlDbType.NVarChar);
        command.Parameters.Add("@app_no", SqlDbType.NVarChar);
        command.Parameters.Add("@app_date", SqlDbType.NVarChar);
        command.Parameters.Add("@xname", SqlDbType.NVarChar);
        command.Parameters.Add("@xmobile", SqlDbType.NVarChar);
        command.Parameters.Add("@xemail", SqlDbType.NVarChar);
        command.Parameters.Add("@xaddy", SqlDbType.Text);

        command.Parameters.Add("@agt_code", SqlDbType.NVarChar);
        command.Parameters.Add("@agt_name", SqlDbType.NVarChar);
        command.Parameters.Add("@agt_addy", SqlDbType.Text);
        command.Parameters.Add("@agt_mobile", SqlDbType.NVarChar);
        command.Parameters.Add("@agt_email", SqlDbType.NVarChar);
        command.Parameters.Add("@last_rwl_date", SqlDbType.NVarChar);
        command.Parameters.Add("@reg_date", SqlDbType.NVarChar);


        command.Parameters.Add("@papp", SqlDbType.NVarChar);
        command.Parameters["@title"].Value    = aa.title;
        command.Parameters["@type"].Value     = aa.type;
        command.Parameters["@reg_no"].Value   = aa.reg_no;
        command.Parameters["@app_no"].Value   = aa.app_no;
        command.Parameters["@app_date"].Value = aa.app_date;
        command.Parameters["@xname"].Value    = aa.xname;
        command.Parameters["@xmobile"].Value  = aa.xmobile;
        command.Parameters["@xemail"].Value   = aa.xemail;
        command.Parameters["@papp"].Value     = aa.log_staff;
        command.Parameters["@xaddy"].Value    = aa.xaddy;

        command.Parameters["@agt_code"].Value      = aa.agt_code;
        command.Parameters["@agt_name"].Value      = aa.agt_name;
        command.Parameters["@agt_addy"].Value      = aa.agt_addy;
        command.Parameters["@agt_mobile"].Value    = aa.agt_mobile;
        command.Parameters["@agt_email"].Value     = aa.agt_email;
        command.Parameters["@last_rwl_date"].Value = aa.last_rwl_date;
        command.Parameters["@reg_date"].Value      = aa.reg_date;

        str2 = command.ExecuteNonQuery().ToString();
        connection.Close();
        string admin = Session["pwalletID"].ToString();

        pt.XPwallet xxs = t.getXPwalletDetailsByID2(TextBox6.Text);
        t.activity_log(admin, "Edit Renewal", "Update", xxs.ID, xxs.data_status, "", "", "", "", "", "");
        return(str2);
    }
Example #3
0
 protected void Page_Load(object sender, EventArgs e)
 {
     Verify.Visible = false;
     if (rbValid.SelectedValue == "Valid")
     {
         admin_status   = "2";
         Verify.Visible = true;
     }
     else if (rbValid.SelectedValue == "Invalid")
     {
         admin_status   = "1";
         Verify.Visible = true;
     }
     if (Request.QueryString["x"] != null)
     {
         if (Session["pwalletID"] != null)
         {
             if (Session["pwalletID"].ToString() != "")
             {
                 admin = Session["pwalletID"].ToString();
             }
             else
             {
                 Response.Redirect("../lo.aspx");
             }
         }
         else
         {
             Response.Redirect("../lo.aspx");
         }
         pID = Request.QueryString["x"].ToString();
         c_x = t.getRenewalByID(pID);
         c_p = t.getXPwalletDetailsByID(c_x.log_staff);
         payment_date.Text    = c_p.reg_date;
         transID.Text         = c_p.validationID;
         p_type.Text          = c_x.type;
         p_title.Text         = c_x.title;
         p_item_code.Text     = c_p.item_code;
         p_app_no.Text        = c_x.app_no;
         p_app_date.Text      = c_x.app_date;
         p_xname.Text         = c_x.xname;
         p_xaddy.Text         = c_x.xaddy;
         p_xemail.Text        = c_x.xemail;
         p_xmobile.Text       = c_x.xmobile;
         p_agt_addy.Text      = c_x.agt_addy;
         p_agt_code.Text      = c_x.agt_code;
         p_agt_email.Text     = c_x.agt_email;
         p_agt_mobile.Text    = c_x.agt_mobile;
         p_agt_name.Text      = c_x.agt_name;
         p_last_rwl_date.Text = c_x.last_rwl_date;
         p_due_date.Text      = Convert.ToDateTime(c_x.last_rwl_date).AddYears(1).ToString("yyyy-MM-dd");
     }
     else
     {
         Response.Redirect("./n_renewal.aspx");
     }
 }
Example #4
0
    private void UpdateCustomer(string customerID, ListViewItem editItem)
    {
        if (IsValid)
        {
            String vid = ((Label)editItem.FindControl("Label4")).Text;

            pt.Renewal nn            = new pt.Renewal();
            string     title         = ((TextBox)editItem.FindControl("title")).Text;
            string     regno         = ((TextBox)editItem.FindControl("regno")).Text;
            string     appno         = ((TextBox)editItem.FindControl("appno")).Text;
            string     appdate       = ((TextBox)editItem.FindControl("appdate")).Text;
            string     xname         = ((TextBox)editItem.FindControl("xname")).Text;
            string     xaddy         = ((TextBox)editItem.FindControl("xaddy")).Text;
            string     xmobile       = ((TextBox)editItem.FindControl("xmobile")).Text;
            string     xemail        = ((TextBox)editItem.FindControl("xemail")).Text;
            string     type          = ((System.Web.UI.HtmlControls.HtmlSelect)editItem.FindControl("type")).Value;
            string     agt_code      = ((TextBox)editItem.FindControl("agt_code")).Text;
            string     agt_name      = ((TextBox)editItem.FindControl("agt_name")).Text;
            string     agt_addy      = ((TextBox)editItem.FindControl("agt_addy")).Text;
            string     agt_mobile    = ((TextBox)editItem.FindControl("agt_mobile")).Text;
            string     agt_email     = ((TextBox)editItem.FindControl("agt_email")).Text;
            string     last_rwl_date = ((TextBox)editItem.FindControl("last_rwl_date")).Text;
            string     reg_date      = ((TextBox)editItem.FindControl("reg_date")).Text;
            //  string log_staff = ((TextBox)editItem.FindControl("log_staff")).Text;
            nn.title         = title;
            nn.reg_no        = regno;
            nn.app_no        = appno;
            nn.app_date      = appdate;
            nn.xname         = xname;
            nn.xaddy         = xaddy;
            nn.xmobile       = xmobile;
            nn.xemail        = xemail;
            nn.type          = type;
            nn.agt_code      = agt_code;
            nn.agt_name      = agt_name;
            nn.agt_addy      = agt_addy;
            nn.agt_mobile    = agt_mobile;
            nn.agt_email     = agt_email;
            nn.last_rwl_date = last_rwl_date;
            nn.reg_date      = reg_date;
            nn.log_staff     = vid;

            updateRenewal(nn);
        }
    }
Example #5
0
 protected void Save_Click(object sender, EventArgs e)
 {
     if ((xref.Text != "") && (x_code.Text != ""))
     {
         c_p = t.getXPwalletDetailsByCode(xref.Text, x_code.Text);
         if (c_p.ID != null)
         {
             c_ren = t.getRenewalByLogstaffID(c_p.ID);
             if (c_ren.xID != null)
             {
                 transID.Text         = c_p.validationID;
                 payment_date.Text    = c_p.reg_date;
                 p_title.Text         = c_ren.title;
                 p_app_no.Text        = c_ren.app_no;
                 p_type.Text          = c_ren.type;
                 p_app_date.Text      = c_ren.app_date;
                 p_xname.Text         = c_ren.xname;
                 p_xaddy.Text         = c_ren.xaddy;
                 p_xmobile.Text       = c_ren.xmobile;
                 p_xemail.Text        = c_ren.xemail;
                 p_agt_code.Text      = c_ren.agt_code;
                 p_agt_name.Text      = c_ren.agt_name;
                 p_agt_addy.Text      = c_ren.agt_addy;
                 p_agt_mobile.Text    = c_ren.agt_mobile;
                 p_agt_email.Text     = c_ren.agt_email;
                 p_due_date.Text      = Convert.ToDateTime(c_ren.last_rwl_date).AddYears(1).ToString("yyyy-MM-dd");
                 p_next_due_date.Text = Convert.ToDateTime(c_ren.last_rwl_date).AddYears(2).ToString("yyyy-MM-dd");
                 showt = 1;
             }
         }
         else
         {
             msg   = "NO ENTRY EXISTS WITH THE DETAILS ABOVE,PLEASE CHECK THE DETAILS AND TRY AGAIN!!";
             showt = 0;
         }
     }
     else
     {
         Response.Write("<script language=JavaScript>alert('PLEASE ENTER A VALID REFERENCE NUMBER')</script>");
         showt = 0;
     }
 }
Example #6
0
    public List <pt.Renewal> getAddressServiceByID(string ID)
    {
        List <pt.Renewal> list = new List <pt.Renewal>();
        //  new AddressService();
        SqlConnection connection = new SqlConnection(Connect());
        SqlCommand    command    = new SqlCommand("SELECT * FROM renewal AS e  INNER JOIN x_pwallet AS p     ON e.log_staff = p.ID  WHERE validationID='" + ID + "' ", connection);

        connection.Open();
        SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);

        while (reader.Read())
        {
            pt.Renewal item = new pt.Renewal
            {
                xID           = Convert.ToInt64(reader["xID"]).ToString(),
                title         = reader["title"].ToString(),
                type          = reader["type"].ToString(),
                reg_no        = reader["reg_no"].ToString(),
                app_no        = reader["app_no"].ToString(),
                app_date      = reader["app_date"].ToString(),
                xname         = reader["xname"].ToString(),
                xaddy         = reader["xaddy"].ToString(),
                xmobile       = reader["xmobile"].ToString(),
                xemail        = reader["xemail"].ToString(),
                agt_code      = reader["agt_code"].ToString(),
                agt_name      = reader["agt_name"].ToString(),
                agt_addy      = reader["agt_addy"].ToString(),
                agt_mobile    = reader["agt_mobile"].ToString(),
                agt_email     = reader["agt_email"].ToString(),
                last_rwl_date = reader["last_rwl_date"].ToString(),
                reg_date      = reader["reg_date"].ToString(),
                reg_time      = reader["reg_time"].ToString(),
                log_staff     = reader["log_staff"].ToString(),
                visible       = ID,
            };
            list.Add(item);
        }
        reader.Close();
        return(list);
    }
Example #7
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if ((((this.Session["transID"] != null) && (this.Session["transID"].ToString() != "")) && (this.Session["x_code"] != null)) && (this.Session["x_code"].ToString() != ""))
     {
         this.c_p = this.t.getXPwalletDetailsByCode(this.Session["transID"].ToString(), this.Session["x_code"].ToString());
         if (this.c_p.ID != null)
         {
             this.c_ren = this.t.getRenewalByLogstaffID(this.c_p.ID);
             if (this.c_ren.xID != null)
             {
                 this.transID.Text         = this.c_p.validationID;
                 this.payment_date.Text    = this.c_p.reg_date;
                 this.p_title.Text         = this.c_ren.title;
                 this.p_app_no.Text        = this.c_ren.app_no;
                 this.p_type.Text          = this.c_ren.type;
                 this.p_app_date.Text      = this.c_ren.app_date;
                 this.p_xname.Text         = this.c_ren.xname;
                 this.p_xaddy.Text         = this.c_ren.xaddy;
                 this.p_xmobile.Text       = this.c_ren.xmobile;
                 this.p_xemail.Text        = this.c_ren.xemail;
                 this.p_agt_code.Text      = this.c_ren.agt_code;
                 this.p_agt_name.Text      = this.c_ren.agt_name;
                 this.p_agt_addy.Text      = this.c_ren.agt_addy;
                 this.p_agt_mobile.Text    = this.c_ren.agt_mobile;
                 this.p_agt_email.Text     = this.c_ren.agt_email;
                 this.p_due_date.Text      = Convert.ToDateTime(this.c_ren.last_rwl_date).AddYears(1).ToString("yyyy-MM-dd");
                 this.p_next_due_date.Text = Convert.ToDateTime(this.c_ren.last_rwl_date).AddYears(2).ToString("yyyy-MM-dd");
             }
         }
         else
         {
             this.msg = "NO ENTRY EXISTS WITH THE DETAILS ABOVE,PLEASE CHECK THE DETAILS AND TRY AGAIN!!";
         }
     }
     else
     {
         base.Response.Write("<script language=JavaScript>alert('PLEASE ENTER A VALID REFERENCE NUMBER')</script>");
     }
 }
    protected void Page_Load(object sender, EventArgs e)
    {
        Verify.Visible = false;
        if (rbValid.SelectedValue == "Approved")
        {
            admin_status   = "3";
            Verify.Visible = true;
        }
        else if (rbValid.SelectedValue == "Refused")
        {
            admin_status   = "2";
            Verify.Visible = true;
        }
        if (Request.QueryString["x"] != null)
        {
            if (Session["pwalletID"] != null)
            {
                if (Session["pwalletID"].ToString() != "")
                {
                    admin = Session["pwalletID"].ToString();
                }
                else
                {
                    Response.Redirect("../lo.aspx");
                }
            }
            else
            {
                Response.Redirect("../lo.aspx");
            }
            pID          = Request.QueryString["x"].ToString();
            c_x          = t.getRenewalByID(pID);
            c_p          = t.getXPwalletDetailsByID(c_x.log_staff);
            lt_tm_office = z.getXPtOfficeDetailsByID(c_x.log_staff);
            this.lt_mi   = this.t.getPtInfoByUserID(this.pID);
            this.lt_rep  = this.t.getRepListByUserID(this.lt_mi[0].log_staff);
            xname.Value  = lt_rep[0].agent_code;
            xname2.Value = lt_mi[0].title_of_invention;

            xname3.Value = lt_mi[0].reg_number;
            xname4.Value = "OAI/PT/" + t.ValidationIDByPwalletID(lt_mi[0].log_staff);
            xname5.Value = lt_mi[0].log_staff;
            for (int i = 0; i < lt_tm_office.Count; i++)
            {
                xcomments          = xcomments + "<tr>";
                xcomments          = xcomments + "<td align=\"center\" colspan=\"2\">";
                xcomments          = xcomments + "<strong>" + lt_tm_office[i].xcomment.ToUpper() + "</strong><br />";
                lt_x_admin_details = z.getTmAdminDetailsByID(lt_tm_office[i].xofficer);
                if (lt_x_admin_details.Count > 0)
                {
                    xcomments = xcomments + "COMMENT BY: <strong>" + lt_x_admin_details[0].xname.ToUpper() + "( " + z.getRoleNameByID(lt_x_admin_details[0].xroleID).ToUpper() + " )</strong><br />   Date: <strong>" + lt_tm_office[i].reg_date.ToUpper() + "</strong>";
                }
                else
                {
                    xcomments = xcomments + "COMMENT BY: <strong> NA</strong>";
                }

                xcomments = xcomments + "</td>";
                xcomments = xcomments + "</tr>";
                if (lt_tm_office[i].xdoc1 != "")
                {
                    xcomments = xcomments + "<tr>";
                    xcomments = xcomments + "<td colspan=\"2\" align=\"center\">";
                    xcomments = xcomments + "View Document 1: <a href=" + lt_tm_office[i].xdoc1 + " target='_blank'>View</a>";
                    xcomments = xcomments + "</td>";
                    xcomments = xcomments + "</tr>";
                }
                if (lt_tm_office[i].xdoc2 != "")
                {
                    xcomments = xcomments + "<tr>";
                    xcomments = xcomments + "<td colspan=\"2\" align=\"center\">";
                    xcomments = xcomments + "View Document 2: <a href=" + lt_tm_office[i].xdoc2 + " target='_blank'>View</a>";
                    xcomments = xcomments + "</td>";
                    xcomments = xcomments + "</tr>";
                }
                if (lt_tm_office[i].xdoc3 != "")
                {
                    xcomments = xcomments + "<tr>";
                    xcomments = xcomments + "<td colspan=\"2\" align=\"center\">";
                    xcomments = xcomments + "View Document 3: <a href=" + lt_tm_office[i].xdoc3 + " target='_blank'>View</a>";
                    xcomments = xcomments + "</td>";
                    xcomments = xcomments + "</tr>";
                }
            }
            payment_date.Text    = c_p.reg_date;
            transID.Text         = c_p.validationID;
            p_type.Text          = c_x.type;
            p_title.Text         = c_x.title;
            p_item_code.Text     = c_p.item_code;
            p_app_no.Text        = c_x.app_no;
            p_app_date.Text      = c_x.app_date;
            p_xname.Text         = c_x.xname;
            p_xaddy.Text         = c_x.xaddy;
            p_xemail.Text        = c_x.xemail;
            p_xmobile.Text       = c_x.xmobile;
            p_agt_addy.Text      = c_x.agt_addy;
            p_agt_code.Text      = c_x.agt_code;
            p_agt_email.Text     = c_x.agt_email;
            p_agt_mobile.Text    = c_x.agt_mobile;
            p_agt_name.Text      = c_x.agt_name;
            p_last_rwl_date.Text = c_x.last_rwl_date;
            p_due_date.Text      = Convert.ToDateTime(c_x.last_rwl_date).AddYears(1).ToString("yyyy-MM-dd");
        }
        else
        {
            Response.Redirect("./rej_renewal.aspx");
        }
    }
Example #9
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if ((((Session["transID"] != null) && (Session["transID"].ToString() != "")) && (Session["x_code"] != null)) && (Session["x_code"].ToString() != ""))
        {
            c_p = t.getXPwalletDetailsByCode(Session["transID"].ToString(), Session["x_code"].ToString());
            string admin = Session["pwalletID"].ToString();
            ad = z.getAdminDetails(admin);
            // vame2.Text = z.getRoleName(ad.xroleID).ToUpper();
            try
            {
                //  vame2.Text = z.getRoleName(ad.xroleID).ToUpper();
                vame2.Text = ad.Designation.ToUpper();
            }

            catch (Exception ee)
            {
            }

            try
            {
                //  vame.Text = ad.Designation.ToUpper();
                vame.Text = ad.xname.ToUpper();
            }

            catch (Exception ee)
            {
            }


            if (string.IsNullOrEmpty(ad.FilePath))
            {
                img.Visible = false;
            }
            else
            {
                img.Visible  = true;
                img.ImageUrl = ".." + ad.FilePath;
            }

            if (c_p.ID != null)
            {
                c_ren = t.getRenewalByLogstaffID(c_p.ID);
                if (c_ren.xID != null)
                {
                    transID.Text         = c_p.validationID;
                    payment_date.Text    = c_p.reg_date;
                    p_title.Text         = c_ren.title;
                    p_app_no.Text        = c_ren.app_no;
                    p_type.Text          = c_ren.type;
                    p_app_date.Text      = c_ren.app_date;
                    p_xname.Text         = c_ren.xname;
                    p_xaddy.Text         = c_ren.xaddy;
                    p_xmobile.Text       = c_ren.xmobile;
                    p_xemail.Text        = c_ren.xemail;
                    p_agt_code.Text      = c_ren.agt_code;
                    p_agt_name.Text      = c_ren.agt_name;
                    p_agt_addy.Text      = c_ren.agt_addy;
                    p_agt_mobile.Text    = c_ren.agt_mobile;
                    p_agt_email.Text     = c_ren.agt_email;
                    p_due_date.Text      = Convert.ToDateTime(c_ren.last_rwl_date).AddYears(1).ToString("yyyy-MM-dd");
                    p_next_due_date.Text = Convert.ToDateTime(c_ren.last_rwl_date).AddYears(2).ToString("yyyy-MM-dd");
                }
            }
            else
            {
                msg = "NO ENTRY EXISTS WITH THE DETAILS ABOVE,PLEASE CHECK THE DETAILS AND TRY AGAIN!!";
            }
        }
        else
        {
            Response.Write("<script language=JavaScript>alert('PLEASE ENTER A VALID REFERENCE NUMBER')</script>");
        }
    }
Example #10
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["x"] != null)
        {
            if (Session["pwalletID"] != null)
            {
                if (Session["pwalletID"].ToString() != "")
                {
                    admin = Session["pwalletID"].ToString();
                }
                else
                {
                    Response.Redirect("../lo.aspx");
                }
            }
            else
            {
                Response.Redirect("../lo.aspx");
            }
            pID           = Request.QueryString["x"].ToString();
            c_x           = t.getRenewalByID(pID);
            Session["Cx"] = c_x;
            c_p           = t.getXPwalletDetailsByID(c_x.log_staff);
            lt_tm_office  = z.getXPtOfficeDetailsByID(c_x.log_staff);
            for (int i = 0; i < lt_tm_office.Count; i++)
            {
                xcomments          = xcomments + "<tr>";
                xcomments          = xcomments + "<td align=\"center\" colspan=\"2\">";
                xcomments          = xcomments + "<strong>" + lt_tm_office[i].xcomment.ToUpper() + "</strong><br />";
                lt_x_admin_details = z.getTmAdminDetailsByID(lt_tm_office[i].xofficer);
                if (lt_x_admin_details.Count > 0)
                {
                    xcomments = xcomments + "COMMENT BY: <strong>" + lt_x_admin_details[0].xname.ToUpper() + "( " + z.getRoleNameByID(lt_x_admin_details[0].xroleID).ToUpper() + " )</strong><br />   Date: <strong>" + lt_tm_office[i].reg_date.ToUpper() + "</strong>";
                }
                else
                {
                    xcomments = xcomments + "COMMENT BY: <strong> NA</strong>";
                }
                xcomments = xcomments + "</td>";
                xcomments = xcomments + "</tr>";
                if (lt_tm_office[i].xdoc1 != "")
                {
                    xcomments = xcomments + "<tr>";
                    xcomments = xcomments + "<td colspan=\"2\" align=\"center\">";
                    xcomments = xcomments + "View Document 1: <a href=" + lt_tm_office[i].xdoc1 + " target='_blank'>View</a>";
                    xcomments = xcomments + "</td>";
                    xcomments = xcomments + "</tr>";
                }
                if (lt_tm_office[i].xdoc2 != "")
                {
                    xcomments = xcomments + "<tr>";
                    xcomments = xcomments + "<td colspan=\"2\" align=\"center\">";
                    xcomments = xcomments + "View Document 2: <a href=" + lt_tm_office[i].xdoc2 + " target='_blank'>View</a>";
                    xcomments = xcomments + "</td>";
                    xcomments = xcomments + "</tr>";
                }
                if (lt_tm_office[i].xdoc3 != "")
                {
                    xcomments = xcomments + "<tr>";
                    xcomments = xcomments + "<td colspan=\"2\" align=\"center\">";
                    xcomments = xcomments + "View Document 3: <a href=" + lt_tm_office[i].xdoc3 + " target='_blank'>View</a>";
                    xcomments = xcomments + "</td>";
                    xcomments = xcomments + "</tr>";
                }
            }
            payment_date.Text    = c_p.reg_date;
            transID.Text         = c_p.validationID;
            p_type.Text          = c_x.type;
            p_title.Text         = c_x.title;
            p_item_code.Text     = c_p.item_code;
            p_app_no.Text        = c_x.app_no;
            p_app_date.Text      = c_x.app_date;
            p_xname.Text         = c_x.xname;
            p_xaddy.Text         = c_x.xaddy;
            p_xemail.Text        = c_x.xemail;
            p_xmobile.Text       = c_x.xmobile;
            p_agt_addy.Text      = c_x.agt_addy;
            p_agt_code.Text      = c_x.agt_code;
            p_agt_email.Text     = c_x.agt_email;
            p_agt_mobile.Text    = c_x.agt_mobile;
            p_agt_name.Text      = c_x.agt_name;
            p_last_rwl_date.Text = c_x.last_rwl_date;
            p_due_date.Text      = Convert.ToDateTime(c_x.last_rwl_date).AddYears(1).ToString("yyyy-MM-dd");
        }
        else
        {
            Response.Redirect("./app_renewal.aspx");
        }

        if (Request.QueryString["x2"] != null)
        {
            Session["transID"] = null;
            Session["x_code"]  = null;
            Session["transID"] = transID.Text;
            Session["x_code"]  = c_p.log_officer;
            Response.Redirect("./admin_cert_status.aspx");
        }
    }