protected void Submit_Click(object sender, EventArgs e)
{
if (Request.Cookies["oid"] != null)
{
order_id = long.Parse(Request.Cookies["oid"].Value);
}
CMEDCosWin coswin = new CMEDCosWin
{
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,
begindate = BeginDate.SelectedValue,
timezone = lstTimeZone.SelectedValue
};
var ret_order_id = controller.SaveCosWin(coswin);
//send email to Philip about a new relationship (names and email and order number) please visit the admin page for relationship details.
Util.SendAstrologicalEmail(coswin);
Response.Redirect("/Astrological_Thankyou.aspx");
}
public long SaveCosWin(CMEDCosWin calwin)
{
DB db = new DB();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SaveCosWin";
cmd.Parameters.AddWithValue("@ordernum", calwin.order_id);
cmd.Parameters.AddWithValue("@bmonth", calwin.bmonth);
cmd.Parameters.AddWithValue("@bday", calwin.bday);
cmd.Parameters.AddWithValue("@byear", calwin.byear);
cmd.Parameters.AddWithValue("@bhour", calwin.bhour);
cmd.Parameters.AddWithValue("@bmin", calwin.bmin);
cmd.Parameters.AddWithValue("@ampm", calwin.ampm);
cmd.Parameters.AddWithValue("@bcity", calwin.bcity);
cmd.Parameters.AddWithValue("@bstate", calwin.bstate);
cmd.Parameters.AddWithValue("@bcountry", calwin.bcountry);
cmd.Parameters.AddWithValue("@fname", calwin.fname);
cmd.Parameters.AddWithValue("@lname", calwin.lname);
cmd.Parameters.AddWithValue("@BeginDate", calwin.begindate);
cmd.Parameters.AddWithValue("@TimeZone", calwin.timezone);
cmd.Parameters.AddWithValue("@gender", calwin.gender);
DataTable dt = db.Execute(cmd);
DataRow row = dt.Rows[0];
return long.Parse(row["order_id"].ToString());
}
