protected void Submit_Click(object sender, EventArgs e)
{
if (Request.Cookies["oid"] != null)
{
order_id = long.Parse(Request.Cookies["oid"].Value);
}
CMEDRelationship relationship = new CMEDRelationship {
order_id = order_id,
bmonth = BMonth.SelectedValue,
bday = BDay.SelectedValue,
byear = BYear.SelectedValue,
bhour = BHour.SelectedValue,
bmin = BMin.SelectedValue,
ampm = AMPM.SelectedValue,
bcity = BCity.Text,
bstate = BState.Text,
bcountry = BCountry.Text,
fname = FName.Text,
lname = LName.Text,
gender = Gender.SelectedValue,
bmonth2 = BMonth2.SelectedValue,
bday2 = BDay2.SelectedValue,
byear2 = BYear2.SelectedValue,
bhour2 = BHour2.SelectedValue,
bmin2 = BMin2.SelectedValue,
ampm2 = AMPM2.SelectedValue,
bcity2 = BCity2.Text,
bstate2 = BState2.Text,
bcountry2 = BCountry2.Text,
fname2 = FName2.Text,
lname2 = LName2.Text,
gender2 = Gender2.SelectedValue
};
var ret_order_id = controller.SaveRelationShip(relationship);
//send email to Philip about a new relationship (names and email and order number) please visit the admin page for relationship details.
Util.SendAstrologicalEmail(relationship);
Response.Redirect("/Astrological_Thankyou.aspx");
}
public long SaveRelationShip(CMEDRelationship relationship)
{
DB db = new DB();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SaveRelationShip";
cmd.Parameters.AddWithValue("@ordernum", relationship.order_id);
cmd.Parameters.AddWithValue("@bmonth", relationship.bmonth);
cmd.Parameters.AddWithValue("@bday", relationship.bday);
cmd.Parameters.AddWithValue("@byear", relationship.byear);
cmd.Parameters.AddWithValue("@bhour", relationship.bhour);
cmd.Parameters.AddWithValue("@bmin", relationship.bmin);
cmd.Parameters.AddWithValue("@ampm", relationship.ampm);
cmd.Parameters.AddWithValue("@bcity", relationship.bcity);
cmd.Parameters.AddWithValue("@bstate", relationship.bstate);
cmd.Parameters.AddWithValue("@bcountry", relationship.bcountry);
cmd.Parameters.AddWithValue("@fname", relationship.fname);
cmd.Parameters.AddWithValue("@lname", relationship.lname);
cmd.Parameters.AddWithValue("@gender", relationship.gender);
cmd.Parameters.AddWithValue("@bmonth2", relationship.bmonth);
cmd.Parameters.AddWithValue("@bday2", relationship.bday);
cmd.Parameters.AddWithValue("@byear2", relationship.byear);
cmd.Parameters.AddWithValue("@bhour2", relationship.bhour);
cmd.Parameters.AddWithValue("@bmin2", relationship.bmin);
cmd.Parameters.AddWithValue("@ampm2", relationship.ampm);
cmd.Parameters.AddWithValue("@bcity2", relationship.bcity);
cmd.Parameters.AddWithValue("@bstate2", relationship.bstate);
cmd.Parameters.AddWithValue("@bcountry2", relationship.bcountry);
cmd.Parameters.AddWithValue("@fname2", relationship.fname);
cmd.Parameters.AddWithValue("@lname2", relationship.lname);
cmd.Parameters.AddWithValue("@gender2", relationship.gender2);
DataTable dt = db.Execute(cmd);
DataRow row = dt.Rows[0];
return long.Parse(row["order_id"].ToString());
}