//when grid view of seminar is selected protected void gvSeminar_SelectedIndexChanged(object sender, EventArgs e) { Panel1.Visible = true; Member m = (Member)Session["user"]; List <ShoppingCart> shoppingcarts = ShoppingCartDBMgr.getAllShoppingCart(m.Email); gvSeminar.DataSource = shoppingcarts; gvSeminar.DataBind(); List <Seminar> seminars = SeminarMgr.getAllSeminar(); List <Schedule> schedules = ScheduleMgr.getAllSchedule(); List <Review> reviews = ReviewDBMgr.getAllReviewById(m.Email); Seminar a = seminars[gvSeminar.PageSize * gvSeminar.PageIndex + gvSeminar.SelectedIndex]; Schedule b = schedules[gvSeminar.SelectedIndex]; if (reviews == null) { tbxRating.Text = "0"; tbxRemarks.Text = " "; } else { Review c = reviews[gvSeminar.SelectedIndex]; tbxRating.Text = c.Rating.ToString(); tbxRemarks.Text = c.Remarks; } tbxId.Text = a.Id; tbxName.Text = a.Name; tbxPrice.Text = a.Price.ToString(); tbxDate.Text = b.Date.ToShortDateString(); }
//when confirm button are clicked protected void btnConfirm_Click(object sender, EventArgs e) { //payment details can not be null if (tbxName.Text != null && tbxCC.Text != null && ddlCCType.Text != null && tbxExpDate.Text != null) { ShoppingCart sc = (ShoppingCart)Session["cart"]; sc.Name = tbxName.Text; if (rdbCash.Checked == true) { sc.OptionPay = rdbCash.Text; } else { sc.OptionPay = rdbCC.Text; } sc.CreditCard = tbxCC.Text; sc.CreditCardType = ddlCCType.Text; sc.SecurityCode = tbxCode.Text; sc.CCExpiryDate = tbxExpDate.Text; string a = lblAmount.Text; string b = a.Substring(1); lblAmount.Text = b; sc.TotalAmount = Convert.ToDecimal(lblAmount.Text); Review r = new Review() { Rating = 0, Remarks = " ", Seminar = sc.Seminar, Member = sc.Member }; int id = ReviewDBMgr.insertReview(r); int Id = ShoppingCartDBMgr.purchaseSeminar(sc); lblOutput.Text = "Confirm. order id is " + Id; //display output for payment successfully //lblOutput.Text = "Payment Successfully!"; //make it null for amount, date and session of cart after transaction are being successful lblAmount.Text = null; lblDate.Text = null; Session["cart"] = null; //send an email for confirmation SmtpClient client = new SmtpClient("smtp.gmail.com"); client.EnableSsl = true; client.Credentials = new NetworkCredential("*****@*****.**", "inft.3050"); MailMessage msg = new MailMessage("*****@*****.**", sc.Member.Email); msg.Subject = "Payment confirmation"; msg.Body = "Thanks for joining our seminar!"; client.Send(msg); } else { //display an output if payment is not valid lblOutput.Text = "Payment is not valid!"; } }
protected void btnUpdate_Click(object sender, EventArgs e) { Member m = (Member)Session["user"]; List <ShoppingCart> shoppingcarts = ShoppingCartDBMgr.getAllShoppingCart(m.Email); gvSeminar.DataSource = shoppingcarts; gvSeminar.DataBind(); List <Seminar> seminars = SeminarMgr.getAllSeminar(); Seminar a = seminars[gvSeminar.SelectedIndex]; List <Review> reviews = ReviewDBMgr.getAllReviewById(m.Email); //Review c = reviews[gvSeminar.SelectedIndex]; //tbxRating.Text = c.Rating.ToString(); //tbxRemarks.Text = c.Remarks; Review r = new Review() { Rating = Convert.ToInt32(tbxRating.Text), Remarks = tbxRemarks.Text, Seminar = a, Member = m }; int row = ReviewDBMgr.updateReview(r); lblOutput.Text = row + " Updated!"; }