protected void Submit_Click(object sender, EventArgs e) { if (Request.Cookies["oid"] != null) { order_id = long.Parse(Request.Cookies["oid"].Value); } CMEDCalWin calwin = new CMEDCalWin { 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.SaveCalWin(calwin); //send email to Philip about a new relationship (names and email and order number) please visit the admin page for relationship details. Util.SendAstrologicalEmail(calwin); Response.Redirect("/Astrological_Thankyou.aspx"); }
public long SaveCalWin(CMEDCalWin calwin) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SaveCalWin"; 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()); }