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";
}
}
private void InsertShipper()
{
int CustomerID = 0;
String BDayString = "";
BDayString = cmbDay.Text + "-" + cmbMonth.Text + "-" + cmbYear.Text;
string sqlStr;
if (CustomerNumberHidden.Value == null || CustomerNumberHidden.Value == "")
{
sqlStr = "INSERT INTO Customer (FirstName, LastName, Gender, BirthDate ,Address1,Address2,City, StateID,CountryID,PostalCode,Email, Phone, PassportNum, LanguageID, HowHearTextID, HowHearSpecific, WhereStayID, RoomOther,RoomNo, EmergencyName, Relationship, EmergencyNumber, EmergencyEmail, DiveLevelID, DiveOrgID, NumberOfDives, Insurance, InsuranceName, EmergencyCountryID, Facebook, DietaryRestrictions, LastDiveDate, ArrivalDate, NationalityCountryID, CheckinInstructorID, InsurancePolicyNumber, InsuranceContactPhone, WelcomeEmailPending) VALUES (@FirstName,@LastName, @Gender, @BirthDate, @Address1,@Address2,@City,@StateID, @Country,@PostalCode,@Email, @Phone, @PassportNum, @LanguageID, @HowHear, @HowHearSpecific, @WhereStayID, @RoomOther, @RoomNo, @EmergencyName, @Relationship, @EmergencyNumber, @EmergencyEmail, @DiveLevelID, @DiveOrgID, @NumberOfDives, @EmergencyCountryID, @Facebook, @DietaryRestrictions, @LastDiveDate, @ArrivalDate, @Insurance, @InsuranceName, @NationalityCountryID, @CheckinInstructorID, @InsurancePolicyNumber, @InsuranceContactPhone, @WelcomeEmailPending)";
}
else
{
CustomerID = Convert.ToInt32(CustomerNumberHidden.Value);
sqlStr = "Update Customer Set FirstName=@FirstName, LastName=@LastName, Gender=@Gender, BirthDate=@BirthDate, Address1=@Address1,Address2=@Address2,City=@City, StateID=@StateID, CountryID=@CountryID, PostalCode=@PostalCode,Email=@Email, Phone=@Phone, PassportNum=@PassportNum, LanguageID=@LanguageID, HowHearTextID=@HowHearTextID, HowHearSpecific=@HowHearSpecific, WhereStayID =@WhereStayID, RoomOther=@RoomOther,RoomNo=@RoomNo, EmergencyName=@EmergencyName, Relationship=@Relationship, EmergencyNumber=@EmergencyNumber, EmergencyEmail=@EmergencyEmail, DiveLevelID=@DiveLevelID, DiveOrgID=@DiveOrgID, NumberOfDives=@NumberOfDives, Insurance=@Insurance, InsuranceName=@InsuranceName, EmergencyCountryID=@EmergencyCountryID, Facebook=@Facebook, DietaryRestrictions=@DietaryRestrictions, LastDiveDate=@LastDiveDate, ArrivalDate=@ArrivalDate, NationalityCountryID=@NationalityCountryID, CheckinInstructorID=@CheckinInstructorID, InsurancePolicyNumber=@InsurancePolicyNumber, InsuranceContactPhone=@InsuranceContactPhone, WelcomeEmailPending=@WelcomeEmailPending WHERE CustomerID=" + CustomerID;
}
List <OleDbParameter> parameters = GenerateCustomerParams();
OleDbTools.ExecuteSqlStatement(sqlStr, parameters);
if (CustomerID == 0)
{
CustomerID = Convert.ToInt32(OleDbTools.GetSingleSqlValue("SELECT TOP 1 CustomerID from [Customer] ORDER BY [CustomerID] DESC"));
}
UploadImage(CustomerID);
sqlStr = "UPDATE Customer SET [image]=@MyImage WHERE CustomerID=" + CustomerID;
parameters.Clear();
parameters.Add(new OleDbParameter("Image", OleDbType.VarChar)
{
Value = this.Session["imgFilePath"]
});
OleDbTools.ExecuteSqlStatement(sqlStr, parameters);
string urlStr = "FormSubmitted.aspx?Camera=" + useCamera + "&ID=" + CustomerID;
Response.Redirect(urlStr);
//IDnum.InnerText = CustomerID.ToString();
//submittingImg.Style.Add("display", "none");
//divThankYou.Style.Add("display", "block");
//pnlFormSubmitted.Style.Add("display", "block");
//stepbuttons.Style.Add("display", "none");
}
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 List <OleDbParameter> GenerateCustomerParams()
{
String BDayString = "";
BDayString = cmbDay.Text + "-" + cmbMonth.Text + "-" + cmbYear.Text;
String UseWelcomeEmail = OleDbTools.GetSingleSqlValue("SELECT TOP 1 UseWelcomeEmail from [GlobalSettings]");
List <OleDbParameter> parameters = new List <OleDbParameter>();
parameters.Add(new OleDbParameter("FirstName", OleDbType.VarChar)
{
Value = FirstName.Text
});
parameters.Add(new OleDbParameter("LastName", OleDbType.VarChar)
{
Value = LastName.Text
});
parameters.Add(new OleDbParameter("Gender", OleDbType.VarChar)
{
Value = Gender.SelectedValue
});
parameters.Add(new OleDbParameter("BirthDate", OleDbType.DBDate)
{
Value = DateTime.Parse(BDayString, System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MMM-yyyy")
});
parameters.Add(new OleDbParameter("Address1", OleDbType.VarChar)
{
Value = Address1.Text
});
parameters.Add(new OleDbParameter("Address2", OleDbType.VarChar)
{
Value = Address2.Text
});
parameters.Add(new OleDbParameter("City", OleDbType.VarChar)
{
Value = City.Text
});
if (StateID.SelectedValue != "")
{
parameters.Add(new OleDbParameter("StateID", OleDbType.Numeric)
{
Value = Convert.ToInt32(StateID.SelectedValue)
});
}
else
{
parameters.Add(new OleDbParameter("StateID", OleDbType.Numeric)
{
Value = DBNull.Value
});
}
if (CountryID.SelectedValue != "")
{
parameters.Add(new OleDbParameter("CountryID", OleDbType.Numeric)
{
Value = Convert.ToInt32(CountryID.SelectedValue)
});
}
else
{
parameters.Add(new OleDbParameter("CountryID", OleDbType.Numeric)
{
Value = DBNull.Value
});
}
parameters.Add(new OleDbParameter("PostalCode", OleDbType.VarChar)
{
Value = PostalCode.Text
});
parameters.Add(new OleDbParameter("Email", OleDbType.VarChar)
{
Value = Email.Text
});
parameters.Add(new OleDbParameter("Phone", OleDbType.VarChar)
{
Value = Phone.Text
});
parameters.Add(new OleDbParameter("PassportNum", OleDbType.VarChar)
{
Value = PassportNum.Text
});
if (LanguageID.SelectedValue != "")
{
parameters.Add(new OleDbParameter("LanuguageID", OleDbType.Numeric)
{
Value = Convert.ToInt32(LanguageID.SelectedValue)
});
}
else
{
parameters.Add(new OleDbParameter("LanuguageID", OleDbType.Numeric)
{
Value = DBNull.Value
});
}
if (HowHearTextID.SelectedValue != "")
{
parameters.Add(new OleDbParameter("HowHear", OleDbType.Numeric)
{
Value = Convert.ToInt32(HowHearTextID.SelectedValue)
});
}
else
{
parameters.Add(new OleDbParameter("HowHear", OleDbType.Numeric)
{
Value = DBNull.Value
});
}
parameters.Add(new OleDbParameter("HowHearSpecific", OleDbType.VarChar)
{
Value = HowHearSpecific.Text
});
if (WhereStayID.SelectedValue != "")
{
parameters.Add(new OleDbParameter("WhereStayID", OleDbType.Numeric)
{
Value = Convert.ToInt32(WhereStayID.SelectedValue)
});
}
else
{
parameters.Add(new OleDbParameter("WhereStayID", OleDbType.Numeric)
{
Value = DBNull.Value
});
}
parameters.Add(new OleDbParameter("RoomOther", OleDbType.VarChar)
{
Value = RoomOther.Text
});
parameters.Add(new OleDbParameter("RoomNo", OleDbType.VarChar)
{
Value = RoomNo.Text
});
parameters.Add(new OleDbParameter("EmergencyName", OleDbType.VarChar)
{
Value = EmergencyName.Text
});
parameters.Add(new OleDbParameter("Relationship", OleDbType.VarChar)
{
Value = Relationship.Text
});
parameters.Add(new OleDbParameter("EmergencyNumber", OleDbType.VarChar)
{
Value = EmergencyNumber.Text
});
parameters.Add(new OleDbParameter("EmergencyEmail", OleDbType.VarChar)
{
Value = EmergencyEmail.Text
});
if (DiveLevelID.SelectedValue != "")
{
parameters.Add(new OleDbParameter("DiveLevelID", OleDbType.Numeric)
{
Value = Convert.ToInt32(DiveLevelID.SelectedValue)
});
}
else
{
parameters.Add(new OleDbParameter("DeveLevelID", OleDbType.Numeric)
{
Value = DBNull.Value
});
}
if (DiveOrgID.SelectedValue != "")
{
parameters.Add(new OleDbParameter("DiveOrgID", OleDbType.Numeric)
{
Value = Convert.ToInt32(DiveOrgID.SelectedValue)
});
}
else
{
parameters.Add(new OleDbParameter("DiveOrgID", OleDbType.Numeric)
{
Value = DBNull.Value
});
}
if (NumberOfDives.Text != "")
{
parameters.Add(new OleDbParameter("NumberOfDives", OleDbType.VarChar)
{
Value = NumberOfDives.Text
});
}
else
{
parameters.Add(new OleDbParameter("NumberOfDives", OleDbType.Numeric)
{
Value = DBNull.Value
});
}
if (Insurance.SelectedValue != "")
{
parameters.Add(new OleDbParameter("Insurance", OleDbType.Boolean)
{
Value = Convert.ToBoolean(Convert.ToInt32(Insurance.SelectedValue))
});
}
else
{
parameters.Add(new OleDbParameter("Insurance", OleDbType.Boolean)
{
Value = DBNull.Value
});
}
parameters.Add(new OleDbParameter("InsuranceName", OleDbType.VarChar)
{
Value = InsuranceName.Text
});
if (EmergencyCountryID.SelectedValue != "")
{
parameters.Add(new OleDbParameter("EmergencyCountryID", OleDbType.Numeric)
{
Value = Convert.ToInt32(EmergencyCountryID.SelectedValue)
});
}
else
{
parameters.Add(new OleDbParameter("EmergencyCountryID", OleDbType.Numeric)
{
Value = DBNull.Value
});
}
parameters.Add(new OleDbParameter("Facebook", OleDbType.VarChar)
{
Value = Facebook.Text
});
parameters.Add(new OleDbParameter("DietaryRestrictions", OleDbType.VarChar)
{
Value = DietaryRestrictions.Text
});
parameters.Add(new OleDbParameter("LastDiveDate", OleDbType.VarChar)
{
Value = LastDiveDate.Text
});
parameters.Add(new OleDbParameter("ArrivalDate", OleDbType.DBDate)
{
Value = DateTime.Now.ToShortDateString()
});
if (NationalityCountryID.SelectedValue != "")
{
parameters.Add(new OleDbParameter("NationalityCountryID", OleDbType.Numeric)
{
Value = Convert.ToInt32(NationalityCountryID.SelectedValue)
});
}
else
{
parameters.Add(new OleDbParameter("NationalityCountryID", OleDbType.Numeric)
{
Value = DBNull.Value
});
}
if (CheckinInstructorID.SelectedValue != "")
{
parameters.Add(new OleDbParameter("CheckinInstructorID", OleDbType.Numeric)
{
Value = Convert.ToInt32(CheckinInstructorID.SelectedValue)
});
}
else
{
parameters.Add(new OleDbParameter("CheckinInstructorID", OleDbType.Numeric)
{
Value = DBNull.Value
});
}
parameters.Add(new OleDbParameter("InsurancePolicyNumber", OleDbType.VarChar)
{
Value = InsurancePolicyNumber.Text
});
parameters.Add(new OleDbParameter("InsuranceContactPhone", OleDbType.VarChar)
{
Value = InsuranceContactPhone.Text
});
if (UseWelcomeEmail == "True")
{
parameters.Add(new OleDbParameter("WelcomeEmailPending", OleDbType.Boolean)
{
Value = true
});
}
else
{
parameters.Add(new OleDbParameter("WelcomeEmailPending", OleDbType.Boolean)
{
Value = false
});
}
return(parameters);
}
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;
}
}
}
