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