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 SaveAll_Click(object sender, EventArgs e) { int num; if (Session["lt_pwx"] != null) { lt_pwx.Clear(); lt_pwx = (List <pt.Stage>)Session["lt_pwx"]; } if (Session["lt_mix"] != null) { lt_mix.Clear(); lt_mix = (List <pt.PtInfo>)Session["lt_mix"]; c_ptinfo.xID = lt_mix[0].xID; } if (Session["lt_repx"] != null) { lt_repx.Clear(); lt_repx = (List <pt.Representative>)Session["lt_repx"]; c_rep.ID = lt_repx[0].ID; } if (Session["lt_appx"] != null) { lt_appx.Clear(); lt_appx = (List <pt.Applicant>)Session["lt_appx"]; } if (Session["lt_invx"] != null) { lt_invx.Clear(); lt_invx = (List <pt.Inventor>)Session["lt_invx"]; } if (Session["lt_assinfox"] != null) { lt_assinfox.Clear(); lt_assinfox = (List <pt.Assignment_info>)Session["lt_assinfox"]; c_assinfo.ID = lt_assinfox[0].ID; } if (Session["lt_xprix"] != null) { lt_xprix.Clear(); lt_xprix = (List <pt.Priority_info>)Session["lt_xprix"]; c_pri.xID = lt_xprix[0].xID; } SetLatestRowsFromGrid_App_gv(); SetLatestRowsFromGrid_Inv_gv(); c_ptinfo.reg_number = ""; c_ptinfo.xtype = lbl_type.Text; c_ptinfo.title_of_invention = txt_title_of_invention.Text; c_ptinfo.pt_desc = txt_pt_desc.Text; if (lt_pwx.Count > 0) { t.updatePwalletDate(lt_pwx[0].ID, TextBox1.Text); c_ptinfo.log_staff = lt_pwx[0].ID; } c_ptinfo.reg_date = TextBox1.Text; try { lt_mix[0].reg_date = TextBox1.Text; if ((lt_mix[0].reg_date == null) || (c_ptinfo.reg_date == "")) { c_ptinfo.reg_date = xreg_date; } else { c_ptinfo.reg_date = lt_mix[0].reg_date; } } catch (Exception ee) { } c_ptinfo.xvisible = xvisible; c_ptinfo.claim_no = "0"; c_ptinfo.loa_no = "0"; c_ptinfo.pct_no = "0"; c_ptinfo.doa_no = "0"; c_assinfo.date_of_assignment = txt_assignment_date.Text; c_assinfo.assignee_name = txt_assignee_name.Text; c_assinfo.assignee_address = txt_assignee_address.Text; c_assinfo.assignee_nationality = select_assignee_nationality.SelectedValue; c_assinfo.assignor_name = txt_assignor_name.Text; c_assinfo.assignor_address = txt_assignor_address.Text; c_assinfo.assignor_nationality = select_assignor_nationality.SelectedValue; if (lt_pwx.Count > 0) { c_assinfo.log_staff = lt_pwx[0].ID; } c_assinfo.visible = xvisible; c_rep.agent_code = rep_code.Text; c_rep.xname = rep_xname.Text; c_rep.nationality = "160"; c_rep.country = "160"; c_rep.state = select_rep_state.SelectedValue; c_rep.address = txt_rep_address.Text; c_rep.xmobile = txt_rep_telephone.Text; c_rep.xemail = txt_rep_email.Text; c_rep.reg_date = TextBox1.Text; if ((c_rep.reg_date == null) || (c_rep.reg_date == "")) { c_rep.reg_date = xreg_date; } c_rep.visible = xvisible; if (lt_pwx.Count > 0) { c_rep.log_staff = lt_pwx[0].ID; } if (Session["lt_app"] != null) { lt_app = (List <SortedList <string, string> >)Session["lt_app"]; } if (Session["lt_inv"] != null) { lt_inv = (List <SortedList <string, string> >)Session["lt_inv"]; } if (Session["lt_pri"] != null) { lt_pri = (List <SortedList <string, string> >)Session["lt_pri"]; } if (lt_app.Count > 0) { for (num = 0; num < lt_app.Count; num++) { pt.Applicant applicant = new pt.Applicant { xname = lt_app[num]["txt_name_app"], address = lt_app[num]["txt_address_app"], xemail = lt_app[num]["txt_email_app"], xmobile = lt_app[num]["txt_mobile_app"], nationality = lt_app[num]["select_app_nationality"] }; if (Session["log_staff"] != null) { applicant.log_staff = Session["log_staff"].ToString(); } applicant.visible = xvisible; c_app = null; c_app = applicant; lt_xapp.Add(c_app); } } if (lt_inv.Count > 0) { for (num = 0; num < lt_inv.Count; num++) { pt.Inventor inventor = new pt.Inventor { xname = lt_inv[num]["txt_name_inv"], address = lt_inv[num]["txt_address_inv"], xemail = lt_inv[num]["txt_email_inv"], xmobile = lt_inv[num]["txt_mobile_inv"], nationality = lt_inv[num]["select_inv_nationality"] }; if (Session["log_staff"] != null) { inventor.log_staff = Session["log_staff"].ToString(); } inventor.visible = xvisible; c_inv = null; c_inv = inventor; lt_xinv.Add(c_inv); } } c_pri.countryID = select_country_pri.SelectedValue; c_pri.app_no = txt_application_no_pri.Text; c_pri.xdate = txt_date_pri.Text; if (Session["log_staff"] != null) { c_pri.log_staff = Session["log_staff"].ToString(); } c_pri.xvisible = xvisible; lt_xpri.Add(c_pri); if (((((lt_mix.Count == 0) && (lt_repx.Count == 0)) && ((lt_appx.Count == 0) && (lt_invx.Count == 0))) && (lt_assinfox.Count == 0)) && (lt_xprix.Count == 0)) { pt_succ = t.addNewPatent(lt_xapp, lt_xpri, lt_xinv, c_ptinfo, c_assinfo, c_rep); } else { if (lt_repx.Count == 0) { rep_updateID = t.addRepresentative(c_rep); } else { rep_updateID = t.updateRepresentative(c_rep); } if (lt_assinfox.Count == 0) { if (((((c_assinfo.assignee_name != null) && (c_assinfo.assignee_name != "")) && ((c_assinfo.date_of_assignment != null) && (c_assinfo.date_of_assignment != ""))) && (c_assinfo.ID != null)) && (c_assinfo.ID != "")) { assinfo_updateID = t.addAssignment_info(c_assinfo); } } else if (((c_assinfo.ID != null)) && (c_assinfo.ID != "")) { assinfo_updateID = t.updateAssignment_info(c_assinfo); } if (lt_xprix.Count == 0) { // pri_updateID = t.addPriority_info(c_pri); } else { foreach (GridViewRow row in Gridview1.Rows) { String box = ((TextBox)row.FindControl("txt_name_pri")).Text; String box2 = ((TextBox)row.FindControl("txt_pri_date")).Text; String box3 = ((TextBox)row.FindControl("vid")).Text; String box4 = ((DropDownList)row.FindControl("select_inv_nationality2")).SelectedValue; var dd = ""; c_pri.app_no = box; c_pri.countryID = box4; c_pri.xdate = box2; c_pri.xID = box3; if (box3 != "") { pri_updateID = t.updatePriority_info(c_pri); } // TextBox box = ((TextBox)row.FindControl("txt_name_pri"); } for (num = 0; num < lt_pri.Count; num++) { // pri_updateID = t.updatePriority_info(c_pri); } } if (lt_xapp.Count == 0) { foreach (pt.Applicant applicant2 in lt_xapp) { if ((applicant2.xname != null) && (applicant2.xname != "")) { app_updateID = t.addApplicant(applicant2); } } } else { t.deleteApplicant(lt_pwx[0].ID); foreach (pt.Applicant applicant2 in lt_xapp) { if ((applicant2.xname != null) && (applicant2.xname != "")) { app_updateID = t.addApplicant(applicant2); } } } if (lt_xinv.Count == 0) { foreach (pt.Inventor inventor2 in lt_xinv) { if ((inventor2.xname != null) && (inventor2.xname != "")) { inv_updateID = t.addInventor(inventor2); } else { t.deleteInventor(inventor2.log_staff); } } } else { t.deleteInventor(lt_pwx[0].ID); foreach (pt.Inventor inventor2 in lt_xinv) { if ((inventor2.xname != null) && (inventor2.xname != "")) { inv_updateID = t.addInventor(inventor2); } else { t.deleteInventor(inventor2.log_staff); } } } if (lt_mix.Count == 0) { mix_updateID = t.addPt(c_ptinfo); t.updatePtReg(mix_updateID, c_ptinfo.xtype); Session["mix_updateID"] = c_ptinfo.xID; if (Convert.ToInt32(mix_updateID) > 0) { Response.Redirect("./edit_form_docs.aspx"); } } else { mix_updateID = t.updatePtInfo(c_ptinfo); // t.updatePtReg(c_ptinfo.xID, c_ptinfo.xtype); Session["mix_updateID"] = c_ptinfo.xID; if (Convert.ToInt32(mix_updateID) > 0) { Response.Redirect("./edit_form_docs.aspx"); } } t.activity_log(admin, "Edit Application", "Update", lt_pwx[0].ID, lt_pwx[0].data_status, oldproduct_title, txt_title_of_invention.Text, oldname, lt_app[0]["txt_name_app"], "", ""); } }
protected void Save_Click(object sender, EventArgs e) { if (xref.Text != "") { if (xref.Text.Contains("OAI/PT/")) { xref.Text = xref.Text.Replace("OAI/PT/", ""); } r = xref.Text; lt_pw = t.getStageByUserIDAdmin(xref.Text); if (lt_pw.Count > 0) { Session["pwID"] = lt_pw[0].ID; agt = lt_pw[0].applicantID; Session["xvid"] = xref.Text; Session["edit_transID"] = xref.Text; lt_mi = t.getPtInfoByUserID(lt_pw[0].ID); lt_rep = t.getRepByUserID(lt_pw[0].ID); if (lt_pw[0].status == "1") { status = "Payment Verification Office"; if (lt_pw[0].data_status == "Fresh") { data_status = "Untreated"; } else if (lt_pw[0].data_status == "Invalid") { data_status = "Invalid"; } else if (lt_pw[0].data_status == "V_Contact") { data_status = "Being processed"; } } if (lt_pw[0].status == "2") { status = "Patent Search Office"; if (lt_pw[0].data_status == "Valid") { data_status = "Successfully reviewed"; } else if (lt_pw[0].data_status == "S_Contact") { data_status = "Being processed"; } } if (lt_pw[0].status == "3") { status = "Patent Examiner 1 Office"; if (lt_pw[0].data_status == "Further Search") { data_status = "Further search required"; status = "Patent Search Office"; } else if (lt_pw[0].data_status == "E_Contact") { data_status = "Being processed"; } else if (lt_pw[0].data_status == "Search Conducted") { data_status = "Successfully reviewed"; } else if (lt_pw[0].data_status == "Refused") { data_status = "Refused"; } } if (lt_pw[0].status == "4") { status = "Patent Approving Office"; if (lt_pw[0].data_status == "Not-Patentable") { data_status = "Not-patentable"; status = "Patent Examiner 1 Office"; } else if (lt_pw[0].data_status == "A_Contact") { data_status = "Being processed"; } else if (lt_pw[0].data_status == "Futher Review") { data_status = "Successfully reviewed"; } } if (lt_pw[0].status == "5") { status = "Registrars Office"; if (lt_pw[0].data_status == "Review Patent") { data_status = "Being reviewed"; status = "Patent Approving Office"; } else if (lt_pw[0].data_status == "R_Contact") { data_status = "Being processed"; } else if (lt_pw[0].data_status == "Patentable") { data_status = "Successfully reviewed"; } } if (lt_pw[0].status == "6") { status = "Registrars Office"; if (lt_pw[0].data_status == "Grant Patent") { data_status = "Patent granted"; } } showt = 1; trans_status = "Current Office: <b>" + status + "</b>; Status: <b>" + data_status + "</b>"; } else { status = "N/A"; trans_status = "Current Office: " + status; } } else { Response.Write("<script language=JavaScript>alert('PLEASE ENTER A VALID REFERENCE NUMBER')</script>"); } lt_pw = t.getStageByUserIDAdmin(xref.Text); t.activity_log(admin, "Edit Status", "Update", lt_pw[0].ID, lt_pw[0].data_status, "", "", "", "", "", ""); }