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