protected void Page_Load(object sender, System.EventArgs e)
{
//CommonFunctions.Connection.Open ();
MainAdapter = CommonFunctions.PrepareAdapter(CommonFunctions.GetConnection(), "SELECT * FROM Users WHERE ID = @UserID", SqlDbType.Int);
CountriesAdapter = CommonFunctions.PrepareAdapter(CommonFunctions.GetConnection(), "SELECT DISTINCT(Country) AS Country " +
"FROM Users WHERE (IfAgent = 1) AND (LEN(Country) > 0) AND NOT (ID = @UserID)", SqlDbType.Int);
AgentsAdapter = CommonFunctions.PrepareAdapter(CommonFunctions.GetConnection(), "SELECT -1 AS ID, 'Not referred by anyone' AS FullName " +
"UNION SELECT ID, LastName + ', ' + FirstName AS FullName FROM Users WHERE (Country = @Country) AND" +
" (IfAgent = 1) AND NOT (ID = @UserID)", SqlDbType.NVarChar, 300, SqlDbType.Int);
IfAdmin.Visible = AuthenticationManager.IfAdmin && (AuthenticationManager.UserID != userid);
IfAdminLabel.Visible = AuthenticationManager.IfAdmin && (AuthenticationManager.UserID != userid);
MainAdapter.SelectCommand.Parameters["@UserID"].Value = userid;
//lock (CommonFunctions.Connection)
if (MainAdapter.Fill(MainDataSet, "Users") == 0)
{
Response.Redirect(CommonFunctions.PrepareURL("InternalError.aspx"), true);
}
//CountryRequired.Enabled = (MainDataSet.Tables["Users"].Rows[0]["IfAgent"] is bool) &&
// (bool)MainDataSet.Tables["Users"].Rows[0]["IfAgent"];
DBConnection obj = new DBConnection();
try
{
if (!IsPostBack)
{
DataTable dt = VADBCommander.CountyDistinctSimpleList();
ddlCountries.DataSource = dt;
//ddlCountries.DataTextField = "country";
//ddlCountries.DataValueField = "country";
if (ddlCountries.Items.Contains(new ListItem(MainDataSet.Tables["Users"].Rows[0]["country"].ToString(),
MainDataSet.Tables["Users"].Rows[0]["country"].ToString())))
{
ddlCountries.SelectedValue = MainDataSet.Tables["Users"].Rows[0]["country"].ToString();
}
//ddlCountries.DataBind();
}
}
catch (Exception ex) { Response.Write(ex.Message); }
finally { obj.CloseConnection(); }
if (!IsPostBack)
{
EmailAddress.Text = MainDataSet.Tables["Users"].Rows[0]["Email"].ToString();
FirstName.Text = MainDataSet.Tables["Users"].Rows[0]["FirstName"].ToString();
LastName.Text = MainDataSet.Tables["Users"].Rows[0]["LastName"].ToString();
CompanyName.Text = MainDataSet.Tables["Users"].Rows[0]["CompanyName"].ToString();
Address.Text = MainDataSet.Tables["Users"].Rows[0]["Address"].ToString();
City.Text = MainDataSet.Tables["Users"].Rows[0]["City"].ToString();
State.Text = MainDataSet.Tables["Users"].Rows[0]["State"].ToString();
Zip.Text = MainDataSet.Tables["Users"].Rows[0]["Zip"].ToString();
//foreach (ListItem li in ddlCountries.Items)
//{
// if (li.Value.ToLower() == MainDataSet.Tables["Users"].Rows[0]["Country"].ToString().ToLower())
// {
// ddlCountries.SelectedValue = MainDataSet.Tables["Users"].Rows[0]["Country"].ToString();
// }
//}
PrimaryTelephone.Text = MainDataSet.Tables["Users"].Rows[0]["PrimaryTelephone"].ToString();
EveningTelephone.Text = MainDataSet.Tables["Users"].Rows[0]["EveningTelephone"].ToString();
DaytimeTelephone.Text = MainDataSet.Tables["Users"].Rows[0]["DaytimeTelephone"].ToString();
MobileTelephone.Text = MainDataSet.Tables["Users"].Rows[0]["MobileTelephone"].ToString();
Website.Text = MainDataSet.Tables["Users"].Rows[0]["Website"].ToString();
Registered.Text = MainDataSet.Tables["Users"].Rows[0]["Registered"].ToString();
PayTravelAgents.Checked = MainDataSet.Tables["Users"].Rows[0]["IfPayTravelAgents"] is bool?
(bool)MainDataSet.Tables["Users"].Rows[0]["IfPayTravelAgents"] : false;
ReservationSame.Checked = MainDataSet.Tables["Users"].Rows[0]["IfReservationSame"] is bool?
(bool)MainDataSet.Tables["Users"].Rows[0]["IfReservationSame"] : false;
ReservationNotSame.Checked = !ReservationSame.Checked;
ReservationEmail.Text = MainDataSet.Tables["Users"].Rows[0]["ReservationEmail"].ToString();
ReservationFirstName.Text = MainDataSet.Tables["Users"].Rows[0]["ReservationFirstName"].ToString();
ReservationLastName.Text = MainDataSet.Tables["Users"].Rows[0]["ReservationLastName"].ToString();
if (IfAdmin.Visible)
{
IfAdmin.SelectedIndex = (MainDataSet.Tables["Users"].Rows[0]["IfAdmin"] is bool) &&
(bool)MainDataSet.Tables["Users"].Rows[0]["IfAdmin"] ? 0 : 1;
}
ReservationSame_CheckedChanged(sender, e);
CountriesAdapter.SelectCommand.Parameters["@UserID"].Value = userid;
//lock (CommonFunctions.Connection)
CountriesAdapter.Fill(MainDataSet, "Countries");
AgentCountries.DataSource = MainDataSet;
if (!IsPostBack)
{
DataBind();
}
if (MainDataSet.Tables["Users"].Rows[0]["ReferredByID"] is int)
{
object country = null;
using (SqlConnection connection = CommonFunctions.GetConnection()) {
connection.Open();
SqlCommand getcountry = new SqlCommand("SELECT Country FROM Users WHERE ID = @UserID", connection);
getcountry.Parameters.Add("@UserID", SqlDbType.Int, 4);
getcountry.Parameters["@UserID"].Value = (int)MainDataSet.Tables["Users"].Rows[0]["ReferredByID"];
country = getcountry.ExecuteScalar();
connection.Close();
}
if (country is string)
{
try
{
AgentCountries.SelectedValue = (string)country;
}
catch (Exception)
{
}
}
AgentCountries_SelectedIndexChanged(sender, e);
try
{
Agents.SelectedValue = ((int)MainDataSet.Tables["Users"].Rows[0]["ReferredByID"]).ToString();
}
catch (Exception)
{
}
}
else
{
AgentCountries_SelectedIndexChanged(sender, e);
}
}
}
