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