public XmlDocument GetAppXmlForAdmin(Hashtable State)
{
XmlDocument doc = new XmlDocument();
DB db = new DB();
StringBuilder b_sql = new StringBuilder();
b_sql.Append("SELECT staging_app_xml FROM applications ");
b_sql.Append("WHERE application_name='" + State["SelectedAdminApp"].ToString() + "'");
b_sql.Append(" AND customer_id='" + State["ServerAdminCustomerID"].ToString() + "'");
DataRow[] rows = db.ViziAppsExecuteSql(State, b_sql.ToString());
DataRow row = rows[0];
if (row["staging_app_xml"] == DBNull.Value || row["staging_app_xml"] == null)
{
State["AppXmlDoc"] = null;
return null;
}
string xml = row["staging_app_xml"].ToString();
Util util = new Util();
doc.LoadXml(util.DecodeMySql(xml));
db.CloseViziAppsDatabase(State);
return doc;
}
protected void Page_Load(object sender, EventArgs e)
{
Util util = new Util();
Hashtable State = (Hashtable)HttpRuntime.Cache[Session.SessionID];
if (util.CheckSessionTimeout(State,Response,"Default.aspx")) return;
try
{
if (!IsPostBack)
{
CopyRight.InnerText = HttpRuntime.Cache["CopyRight"].ToString();
UserLabel.Text = State["Username"].ToString();
}
if ( HttpRuntime.Cache["TechSupportEmail"] != null)
{
util.AddEmailToButton(SupportButton, HttpRuntime.Cache["TechSupportEmail"].ToString(), "Email To Tech Support");
}
util.UpdateSessionLog(State, "post", "TabMyProfile");
if (State["ServerAdminCustomerUsername"] != null)
UsernameLabel.Text = State["ServerAdminCustomerUsername"].ToString();
else
UsernameLabel.Text = State["Username"].ToString();
Message.Text = "";
string sql = null;
if (State["Username"].ToString() != "admin")
{
sql = "SELECT * FROM customers WHERE customer_id='" + State["CustomerID"].ToString() + "'";
}
else
{
sql = "SELECT * FROM customers WHERE customer_id='" + State["ServerAdminCustomerID"].ToString() + "'";
}
DB db = new DB();
DataRow[] rows = db.ViziAppsExecuteSql(State, sql);
DataRow row = rows[0];
PasswordTextBox.Text = "";
ConfirmPasswordBox.Text = "";
CompanyTextBox.Text = util.DecodeMySql(row["company"].ToString());
RoleTextBox.Text = util.DecodeMySql(row["role"].ToString());
FirstNameTextBox.Text = util.DecodeMySql(row["first_name"].ToString());
LastNameTextBox.Text = util.DecodeMySql(row["last_name"].ToString());
StreetTextBox.Text = util.DecodeMySql(row["street_address"].ToString());
CityTextBox.Text = util.DecodeMySql(row["city"].ToString());
if (row["state"] != null && row["state"].ToString().Length > 0)
StateList.Text = row["state"].ToString();
PostalCodeTextBox.Text = row["postal_code"].ToString();
CountryTextBox.Text = util.DecodeMySql(row["country"].ToString());
PhoneTextbox.Text = row["phone"].ToString();
EmailTextBox.Text = row["email"].ToString();
string status = row["status"].ToString();
//Additions for the CC fields
if (!IsPostBack)
{
CCFirstNameTextbox.Text = util.DecodeMySql(row["first_name"].ToString());
CCLastNameTextBox.Text = util.DecodeMySql(row["last_name"].ToString());
CCZipTextBox.Text = row["postal_code"].ToString();
}
db.CloseViziAppsDatabase(State);
TimeZones zone_util = new TimeZones();
string default_time_zone_delta_hours = row["default_time_zone_delta_hours"].ToString();
zone_util.InitTimeZones(State, DateTime.Now.ToUniversalTime(), TimeZoneList, default_time_zone_delta_hours);
string force_1_user_sessions = row["force_1_user_sessions"].ToString();
Force1UserSessions.Checked = force_1_user_sessions == "1" || force_1_user_sessions.ToLower() == "true";
}
catch (Exception ex)
{
util.ProcessMainExceptions(State, Response, ex);
}
}
private void PreFillBillingFormDetails()
{
Hashtable State = (Hashtable)HttpRuntime.Cache[Session.SessionID];
Util util = new Util();
if (State["ServerAdminCustomerUsername"] != null)
UserLabel.Text = State["ServerAdminCustomerUsername"].ToString();
else
UserLabel.Text = State["Username"].ToString();
string sql = null;
if (State["Username"].ToString() != "admin")
{
sql = "SELECT * FROM customers WHERE customer_id='" + State["CustomerID"].ToString() + "'";
}
else
{
sql = "SELECT * FROM customers WHERE customer_id='" + State["ServerAdminCustomerID"].ToString() + "'";
}
DB db = new DB();
DataRow[] rows = db.ViziAppsExecuteSql(State, sql);
db.CloseViziAppsDatabase(State);
DataRow row = rows[0];
CompanyTextBox.Text = util.DecodeMySql(row["company"].ToString());
EmailTextBox.Text = row["email"].ToString();
FirstNameTextBox.Text = util.DecodeMySql(row["first_name"].ToString());
LastNameTextBox.Text = util.DecodeMySql(row["last_name"].ToString());
StreetTextBox.Text = util.DecodeMySql(row["street_address"].ToString());
CityTextBox.Text = util.DecodeMySql(row["city"].ToString());
if (row["state"] != null && row["state"].ToString().Length > 0)
StateList.SelectedValue = row["state"].ToString();
//StateList.Text = row["state"].ToString();
PostalCodeTextBox.Text = row["postal_code"].ToString();
CountryTextBox.Text = util.DecodeMySql(row["country"].ToString());
PhoneTextbox.Text = row["phone"].ToString();
//+++++++++++++++++++++++++++++++++++++++++++++++++++++++
CCFirstNameTextbox.Text = util.DecodeMySql(row["first_name"].ToString());
CCLastNameTextBox.Text = util.DecodeMySql(row["last_name"].ToString());
CCZipTextBox.Text = row["postal_code"].ToString();
//++++++++++++++ To be Removed at the end ++++++++++++++++++++++++++
//CCNumberTextBox.Text = "4111111111111111";
//CCExpirationTextBox.Text = "12/2012";
//CCCardCodeTextBox.Text = "222";
}
protected void CustomersByAccount_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)
{
ClearMessages();
HideForCustomers();
Hashtable State = (Hashtable)HttpRuntime.Cache[Session.SessionID];
if (e.Text.IndexOf("->") > 0)
{
CustomersByEmail.Items[0].Selected = true;
AdminMessage.Text = "Select a customer and try again.";
return;
}
State["ServerAdminCustomerUsername"] = e.Text;
string sql = "SELECT * FROM customers WHERE username='******'";
DB db = new DB();
DataRow[] rows = db.ViziAppsExecuteSql(State, sql);
DataRow row = rows[0];
string customer_id = row["customer_id"].ToString();
string email = row["email"].ToString();
CustomersByAccount.FindItemByText(row["username"].ToString()).Selected = true;
CustomersByEmail.FindItemByText(email).Selected = true;
State["ServerAdminCustomerID"] = customer_id;
Util util = new Util();
RegisteredDateTime.Text = "Signed Up: " + row["registration_date_time"].ToString();
LastUsedDateTime.Text = "Last used: " + row["last_use_date_time"].ToString();
Password.Text = util.DecodeMySql(row["password"].ToString());
AccountTypes.Text = util.DecodeMySql(row["account_type"].ToString().Replace("type=","").Replace(";",""));
CustomerStatus.Text = row["status"].ToString();
if (row["email"] != null && row["email"].ToString().Length > 0)
{
util.AddEmailToButton(EmailCustomer, row["email"].ToString(), "Customer Email");
}
sql = "SELECT application_name FROM applications WHERE customer_id='" + customer_id + "' ORDER BY application_name";
rows = db.ViziAppsExecuteSql(State, sql);
Applications.Items.Clear();
foreach (DataRow row1 in rows)
{
Applications.Items.Add(new RadComboBoxItem(row1["application_name"].ToString()));
}
Applications.Items.Insert(0, new RadComboBoxItem("Select ViziApps App ->"));
db.CloseViziAppsDatabase(State);
ShowForCustomers();
}
