protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["C_settingPop"] == "1") { lbladdress1.Text = Request.QueryString["address1"]; lbladdress2.Text = Request.QueryString["address2"]; lblcity.Text = Request.QueryString["city"]; lblcopname.Text = Request.QueryString["compamy_name"]; lblcountry.Text = Request.QueryString["country"]; lblphone.Text = Request.QueryString["phone"]; lblemail.Text = Request.QueryString["email"]; lblSecEmail.Text = Request.QueryString["secemail"]; lblfax.Text = Request.QueryString["fax"]; lblpostal.Text = Request.QueryString["postal"]; } if (!Page.IsPostBack) { XmlDocument xmldoc = new XmlDocument(); API.Service prof = new API.Service(); // API.Service prof = new API.Service(); xmldoc.LoadXml("<XML>" + prof.get_Profile(Session["Email"].ToString(), Session["P@ss"].ToString(), Session["UserID"].ToString()).InnerXml + "</XML>"); // xmldoc.LoadXml("<XML>" + prof.get_Profile("[email protected] ", "1234", "9").InnerXml + "</XML>"); XmlNodeList Response = xmldoc.SelectNodes("XML/RESPONSE/USER_NO"); txtfirst.Text = xmldoc.SelectSingleNode("XML/RESPONSE/USER_NO/FIRST_NAME").InnerText; txtsecond.Text = xmldoc.SelectSingleNode("XML/RESPONSE/USER_NO/LAST_NAME").InnerText; txtemail.Text = xmldoc.SelectSingleNode("XML/RESPONSE/USER_NO/EMAIL").InnerText; // Password1.Value = xmldoc.SelectSingleNode("XML/RESPONSE/USER_NO/PASSWORD").InnerText; conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["dbconn"].ConnectionString); if (conn.State == System.Data.ConnectionState.Closed) { conn.Open(); // Session["JobID"] = jobID.ToString(); //start, end and weeks string sqlgetvenddetails = " select * from ovms_clients as clt " + " join ovms_client_details as cltd on clt.client_id = cltd.client_id where clt.client_id = '" + Session["ClientID"].ToString() + "'"; SqlCommand v_details = new SqlCommand(sqlgetvenddetails, conn); SqlDataReader reader = v_details.ExecuteReader(); if (reader.HasRows == true) { while (reader.Read()) { string address1 = ""; txtPhone.Text = reader["client_phoneNumber"].ToString(); Txtcompemail.Text = reader["Primary_email"].ToString(); address1 = "Suite: " + reader["client_address1"].ToString(); // address1 = Server.HtmlDecode(address1 + " Postal Code: " + reader["vendor_postal_code"].ToString()); // address1 = address1 + " Country:" + reader["vendor_country"].ToString(); txtComp_name.Text = reader["client_name"].ToString(); txtsecEmail.Text = reader["secondary_email"].ToString(); txtSuite.Text = reader["client_address1"].ToString(); txtPostal.Text = reader["client_postal_code"].ToString(); txtcity.Text = reader["client_city"].ToString(); txtcountry.Text = reader["client_country"].ToString(); txtfax.Text = reader["client_faxNumber"].ToString(); txtadrres2.Text = reader["client_address2"].ToString(); // Txtaddres.Text = address1; } } reader.Close(); v_details.Dispose(); conn.Close(); } conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["dbconn"].ConnectionString); try { if (conn.State == System.Data.ConnectionState.Closed) { conn.Open(); string querystr = "SELECT TOP 1 client_id FROM ovms_client_smsnotification WHERE client_id = " + Session["ClientID"].ToString(); SqlCommand cmd = new SqlCommand(querystr, conn); SqlDataReader readers = cmd.ExecuteReader(); if (readers.HasRows == true) { while (readers.Read()) { if (readers["client_id"].ToString() == Session["ClientID"].ToString()) { string selectstr = "select * from ovms_client_smsnotification"; SqlCommand cmdsel = new SqlCommand(selectstr, conn); SqlDataReader reads = cmdsel.ExecuteReader(); if (reads.HasRows == true) { while (reads.Read()) { RadioButtonList1.SelectedValue = reads["newjob_notify"].ToString(); RadioButtonList2.SelectedValue = reads["interview_schedule_notify"].ToString(); RadioButtonList3.SelectedValue = reads["interview_reschedule_notify"].ToString(); RadioButtonList4.SelectedValue = reads["candid_approve_notify"].ToString(); RadioButtonList5.SelectedValue = reads["candid_reject_notify"].ToString(); RadioButtonList6.SelectedValue = reads["timesheet_approve_notify"].ToString(); RadioButtonList7.SelectedValue = reads["timesheet_reject_notify"].ToString(); } } reads.Close(); cmdsel.Dispose(); } } } } } catch (Exception ex) { errorDisp.Text = ex.Message; } finally { conn.Close(); } } }