protected void SetColors() { var dt = new DataTable(); dt = OleDbTools.GetDataTable("SELECT SignInFormControl, SignInFormColor FROM SignInFormColor"); foreach (DataRow row in dt.Rows) { string myControl = row.ItemArray[0].ToString(); if (myControl == "Page Background") { pagebody.Attributes.Add("bgcolor", row.ItemArray[1].ToString()); } else { this.Session[myControl + "Color"] = row.ItemArray[1].ToString(); } } PhotoPanel.BackColor = System.Drawing.ColorTranslator.FromHtml(this.Session["Section BackgroundColor"].ToString()); PersonalInfoPanel.BackColor = System.Drawing.ColorTranslator.FromHtml(this.Session["Section BackgroundColor"].ToString()); AddressPanel.BackColor = System.Drawing.ColorTranslator.FromHtml(this.Session["Section BackgroundColor"].ToString()); lblPersonalInfoPanel.ForeColor = System.Drawing.ColorTranslator.FromHtml(this.Session["Section TextColor"].ToString()); lblAddressPanel.ForeColor = System.Drawing.ColorTranslator.FromHtml(this.Session["Section TextColor"].ToString()); CertifiedDiver.ForeColor = System.Drawing.ColorTranslator.FromHtml(this.Session["Section TextColor"].ToString()); lblCamera.ForeColor = System.Drawing.ColorTranslator.FromHtml(this.Session["Section TextColor"].ToString()); lblFileUpload.ForeColor = System.Drawing.ColorTranslator.FromHtml(this.Session["Section TextColor"].ToString()); }
public Country(string CountryID) { _CountryID = CountryID; DataTable srs = new DataTable(); srs = OleDbTools.GetDataTable("Select CountryName from Country Where CountryID = " + _CountryID); _CountryName = srs.Rows[0]["CountryName"].ToString(); }
public State(string StateID) { _StateID = StateID; if (StateID == "0") { _StateName = "--Select--"; } else { DataTable srs; srs = OleDbTools.GetDataTable("Select StateName from State Where StateID = " + StateID); _StateName = srs.Rows[0]["StateName"].ToString(); } }
protected void prevCustClick(Object Sender, EventArgs E) { CustomerNumberError.Style["color"] = "red"; if (CustomerNumber.Text == null) { CustomerNumberError.Visible = true; CustomerNumberError.Text = "Please provide a customer number."; FirstName.Text = ""; LastName.Text = ""; prevCustomerModal.Style["display"] = "table"; return; } float output; if (!float.TryParse(CustomerNumber.Text, out output)) { CustomerNumberError.Visible = true; CustomerNumberError.Text = "Please enter a valid number."; FirstName.Text = ""; LastName.Text = ""; prevCustomerModal.Style["display"] = "table"; return; } var dt = new DataTable(); dt = OleDbTools.GetDataTable("SELECT * FROM Customer WHERE CustomerID = " + CustomerNumber.Text); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; InitializeCustomer(dr); CustomerNumberError.Text = "Customer " + FirstName.Text + " " + LastName.Text + " Found"; CustomerNumberError.Style["color"] = "green"; CustomerNumberHidden.Value = CustomerNumber.Text; prevCustomerModal.Style["display"] = "none"; } else { CustomerNumberError.Style["color"] = "red"; CustomerNumberError.Text = "Customer Number not found."; FirstName.Text = ""; LastName.Text = ""; prevCustomerModal.Style["display"] = "table"; } }
public static void InitCountries() { Countries = new List <Country>(); DataTable srs = new DataTable(); srs = OleDbTools.GetDataTable("Select * from Country Left JOIN [State] on State.CountryID = Country.CountryID ORDER BY CountryName, StateName"); double PrevCountryID = -999; foreach (DataRow dr in srs.Rows) { if (PrevCountryID != Convert.ToDouble(dr["Country.CountryID"])) { Countries.Add(new Country(dr["Country.CountryID"].ToString(), dr["CountryName"].ToString(), (dr["StateID"] != DBNull.Value))); PrevCountryID = Convert.ToDouble(dr["Country.CountryID"]); } if ((dr["StateID"] != DBNull.Value)) { Countries[Countries.Count - 1]._States.Add(new State(dr["StateID"].ToString(), dr["StateName"].ToString())); } } }
static void InitCountries() { List <Country> Countries = new List <Country>(); DataTable srs = new DataTable(); srs = OleDbTools.GetDataTable("Select * from Country Left JOIN [State] on State.CountryID = Country.Country ID ORDER BY CountryName, StateName"); double PrevCountryID = -999; foreach (dr in srs.Rows) { if (PrevCountryID != dr[CountryID]) { Countries.Add(new Country(dr[CountryID], dr[CountryName], Not(dr[StateID] = DBNull))); PrevCountryID = dr[CountryID]; } if ((dr[StateID] != DBNull)) { Countries(Countries.Count - 1).States.Add(new State(dr[StateID], dr[StateName])); } } }
protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { this.Session["imgFilePath"] = ""; Country.InitCountries(); CountryID.DataSource = Country.Countries; CountryID.DataBind(); Insurance.SelectedValue = "-1"; CertifiedDiver.SelectedValue = "-1"; EmergencyCountryID.DataSource = Country.Countries; EmergencyCountryID.DataBind(); NationalityCountryID.DataSource = Country.Countries; NationalityCountryID.DataBind(); HowHearTextID.DataBind(); WhereStayID.DataBind(); DiveLevelID.DataBind(); DiveOrgID.DataBind(); LanguageID.DataBind(); CheckinInstructorID.DataBind(); //Add blank item at index 0 CountryID.Items.Insert(0, new ListItem("--Select--", "0")); CountryID.SelectedIndex = -1; EmergencyCountryID.Items.Insert(0, new ListItem("--Select--", "0")); EmergencyCountryID.SelectedIndex = -1; NationalityCountryID.Items.Insert(0, new ListItem("--Select--", "0")); NationalityCountryID.SelectedIndex = -1; Gender.Items.Insert(0, new ListItem("--Select--", "0")); DiveOrgID.Items.Insert(0, new ListItem("--Select--", "0")); DiveLevelID.Items.Insert(0, new ListItem("--Select--", "0")); WhereStayID.Items.Insert(0, new ListItem("--Select--", "0")); HowHearTextID.Items.Insert(0, new ListItem("--Select--", "0")); LanguageID.Items.Insert(0, new ListItem("--Select--", "0")); CheckinInstructorID.Items.Insert(0, new ListItem("--Select--", "0")); var Termsdt = new DataTable(); Termsdt = OleDbTools.GetDataTable("SELECT TermsText, ShowTerms, [Language] FROM GlobalSettings, [Language] WHERE GlobalSettings.LanguageID = [Language].LanguageID"); if (Termsdt.Rows[0]["ShowTerms"].ToString() == "True") { this.Session["ShowTerms"] = true; pTerms.InnerHtml = Termsdt.Rows[0].ItemArray[0].ToString().Replace(System.Environment.NewLine, "<br />"); } else { this.Session["ShowTerms"] = false; } SetColors(); string language = Termsdt.Rows[0]["Language"].ToString(); optLanguage.SelectedValue = language; var sectionsdt = new DataTable(); sectionsdt = OleDbTools.GetDataTable("SELECT * FROM RegisterFormSection"); var fieldsdt = new DataTable(); fieldsdt = OleDbTools.GetDataTable("SELECT * FROM RegisterFormField WHERE RegisterFormSectionID in (Select RegisterFormSectionID From RegisterFormSection WHERE Display=True)"); this.Session["sectionsdt"] = sectionsdt; this.Session["fieldsdt"] = fieldsdt; ChangeForm(); if (useCamera.ToLower() == "yes") { FileUploadValidator.Enabled = false; } } }