protected void BtnSubmit_Click(object sender, EventArgs e) { Order obj = (Order)Session["reserveproperty"]; // if (Session["reserveproperty"] != null) { string InsertReservation = "insert into Reservation(First_Name,Last_Name,Home_Phone,Cell_Phone,Work_Phone,Email_ID,Confirm_Email_ID,Pick_Location," + " Source,Destination,Share_Type,Pickup_Date,PickUp_Hour,PickUp_Min,PickUp_AMPM,RoundTrip,Need_Message,No_of_Passengers,Payment_Mode,Special_Instruction," + " Round_Source, Round_Destination,Round_Pickup_Location,Round_Pickup_Date,Round_PickUp_Hour,Round_PickUp_Min,Round_PickUp_AMPM,Round_No_of_Passengers)" + "Values(@FirstName,@LastName,@Home_Phone,@Cell_Phone,@Work_Phone,@EmailID,@ConfirmEmailID,@PickLocation,@Source,@Destination,@ShareType,@PickupDate,@PickUp_Hour," + "@PickUpMin,@PickUpAMPM,@RoundTrip,@NeedMessage,@NoOfPassengers,@PaymentMode,@SpecialInstruction,@RoundSource,@RoundDestination,@RoundPickupLocation," + " @RoundPickupDate,@RoundPickUpHour,@RoundPickUpMin,@RoundPickUpAMPM,@RoundNoOfPassengers )"; SqlParameter [] param = new SqlParameter[28]; param[0] = new SqlParameter("@FirstName", SqlDbType.VarChar); param[0].Value = obj.First_name; param[1] = new SqlParameter("@LastName", SqlDbType.VarChar); param[1].Value = obj.Last_name; param[2] = new SqlParameter("@Home_Phone", SqlDbType.VarChar); param[2].Value = obj.Home_phone_no; param[3] = new SqlParameter("@Cell_Phone", SqlDbType.VarChar); param[3].Value = obj.Cell_phone_no; param[4] = new SqlParameter("@Work_Phone", SqlDbType.VarChar); param[4].Value = obj.Work_phone_no; param[5] = new SqlParameter("@EmailID", SqlDbType.VarChar); param[5].Value = obj.Email; param[6] = new SqlParameter("@ConfirmEmailID", SqlDbType.VarChar); param[6].Value = obj.Confirm_email; param[7] = new SqlParameter("@PickLocation", SqlDbType.VarChar); param[7].Value = obj.Pick_location; param[8] = new SqlParameter("@Source", SqlDbType.VarChar); param[8].Value = obj.From_place; param[9] = new SqlParameter("@Destination", SqlDbType.VarChar); param[9].Value = obj.To_place; param[10] = new SqlParameter("@ShareType", SqlDbType.VarChar); param[10].Value = obj.Share_type; param[11] = new SqlParameter("@PickupDate", SqlDbType.Date); param[11].Value = obj.pickup_date; param[12] = new SqlParameter("@PickUp_Hour", SqlDbType.VarChar); param[12].Value = obj.pick_up_hour; param[13] = new SqlParameter("@PickUpMin", SqlDbType.VarChar); param[13].Value = obj.pick_up_min; param[14] = new SqlParameter("@PickUpAMPM", SqlDbType.VarChar); param[14].Value = obj.pick_up_ampm; param[15] = new SqlParameter("@RoundTrip", SqlDbType.VarChar); param[15].Value = obj.RoundTrip; param[16] = new SqlParameter("@NeedMessage", SqlDbType.Bit); param[16].Value = obj.sms_required; param[17] = new SqlParameter("@NoOfPassengers", SqlDbType.Int); param[17].Value = obj.No_of_passengers; param[18] = new SqlParameter("@PaymentMode", SqlDbType.VarChar); param[18].Value = obj.PaymentMode; param[19] = new SqlParameter("@SpecialInstruction", SqlDbType.VarChar); param[19].Value = obj.special_instruction; param[20] = new SqlParameter("@RoundSource", SqlDbType.VarChar); param[20].Value = obj.Round_from_Location; param[21] = new SqlParameter("@RoundDestination", SqlDbType.VarChar); param[21].Value = obj.Round_to_Location; param[22] = new SqlParameter("@RoundPickupLocation", SqlDbType.VarChar); param[22].Value = obj.Round_pick_up_Location; param[23] = new SqlParameter("@RoundPickupDate", SqlDbType.Date); if (obj.Round_pick_up_date == "") { param[23].Value = null; } else { param[23].Value = obj.Round_pick_up_date; } param[24] = new SqlParameter("@RoundPickUpHour", SqlDbType.VarChar); param[24].Value = obj.Round_pick_up_hour; param[25] = new SqlParameter("@RoundPickUpMin", SqlDbType.VarChar); param[25].Value = obj.Round_pick_up_min; param[26] = new SqlParameter("@RoundPickUpAMPM", SqlDbType.VarChar); param[26].Value = obj.Round_pick_up_ampm; param[27] = new SqlParameter("@RoundNoOfPassengers", SqlDbType.Int); param[27].Value = obj.Round_No_ofPassengers; DBConnection databaseObject = new DBConnection(); databaseObject.ExecuteNonQuery(InsertReservation, param); EmailFormat emailobj = new EmailFormat(); string str = hidden.Value; emailobj.SendEmail(obj.Email, "RegardingReservationDetails", str, null); } }
protected void btnSubmit_Click(object sender, EventArgs e) { StringBuilder sb = new StringBuilder(); sb.Append("Here is the new message for you"); sb.Append("<tr>"); sb.Append("<td>"); sb.Append("Nmae :"); sb.Append("</td>"); sb.Append("<td>"); sb.Append(txtName.Text); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("</br>"); sb.Append("<tr>"); sb.Append("<td>"); sb.Append("Email :"); sb.Append("</td>"); sb.Append("<td>"); sb.Append(txtEmail.Text); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("</br>"); sb.Append("<tr>"); sb.Append("<td>"); sb.Append("PhoneNumber :"); sb.Append("</td>"); sb.Append("<td>"); sb.Append(lblPhoneNo.Text); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("</br>"); sb.Append("<tr>"); sb.Append("<td>"); sb.Append("Find Our Website :"); sb.Append("</td>"); if (drpFind.SelectedIndex > 0) { sb.Append("<td>"); sb.Append(drpFind.SelectedItem.Text); sb.Append("</td>"); } sb.Append("</tr>"); sb.Append("</br>"); sb.Append("<tr>"); sb.Append("<td>"); sb.Append("Comment From User :"******"</td>"); sb.Append("<td>"); sb.Append(txtComments.Text); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("</br>"); EmailFormat emailobj = new EmailFormat(); string result = emailobj.SendEmail("*****@*****.**", "new message from'" + txtName.Text + "'", sb.ToString()); ClientScript.RegisterStartupScript(this.GetType(), "Clear", "alert('Message sent successfully');Reset();", true); }