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>"); } } }
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); }
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"); } }
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); } }
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; } }
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); }
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"); } }
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>"); } }
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"); } }