protected void Submit_Click(object sender, EventArgs e) { string value; decimal number; int workshopID = 0; int ProductID = 0; value = txtCost.Text; if (!Decimal.TryParse(value, out number)) { lblCostErrorMessage.Text = "invalid tuition value entered"; lblCostErrorMessage.Visible = true; return; } if (!string.IsNullOrEmpty(txtDeposit.Text)) { value = txtDeposit.Text; if (!Decimal.TryParse(value, out number)) { lblCostErrorMessage.Text = "invalid deposit value entered"; lblCostErrorMessage.Visible = true; return; } } var m = Request.QueryString["new"]; if (!string.IsNullOrEmpty(m)) { if (m == "yes") { workshopID = 0; } else { if (!string.IsNullOrEmpty(lstWorkShops.SelectedValue.ToString())) { workshopID = Int32.Parse(lstWorkShops.SelectedValue.ToString()); } } } else { if (!string.IsNullOrEmpty(lstWorkShops.SelectedValue.ToString())) { workshopID = Int32.Parse(lstWorkShops.SelectedValue.ToString()); } } if (!string.IsNullOrEmpty(txtProductID.Text)) { ProductID = 0; } CMEDWorkshop workshop = new CMEDWorkshop { Active = chkActive.Checked, Archive = ChkArchive.Checked, CanPurchase = chkCanPurchase.Checked, DepositOn = chkTurnOffDeposit.Checked, MealCostOn = chkTurnMealCost.Checked, DateLine = txtDateLine.Text, FullImageUrl = txtMainPhoto.SelectedValue, ID = workshopID, Location = txtLocation.Text, LongDescription = FreeTextBox1.Text, PurchaseDescription = FreeTextBox2.Text, Cost = Decimal.Parse(txtCost.Text), MealsCost = Decimal.Parse(txtMealDeposit.Text), MealsCount = Int32.Parse(txtMealsCount.Text), RegisterURL = txtPurchaseUrl.Text, ShortDescription = FreeTextBox3.Text, ThumbNailImageUrl = txtThumbNail.SelectedValue, Title = txtTitle.Text, Deposit = Decimal.Parse(txtDeposit.Text), SubTitle = txtSubTitle.Text, Prerequisite = txtPrerequisite.Text, ProductID = ProductID, Sort = Int32.Parse(txtSort.Text), }; try { controller.SaveCMEDWorkshop(workshop); BindDropDown(); ClearForm(); } catch (Exception ex) { throw ex; } }
public List<CMEDWorkshop> GetCMEDWorkshopsAll() { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetCMEDWorkshopsAll"; DataTable dt = db.Execute(cmd); List<CMEDWorkshop> Items = new List<CMEDWorkshop>(); foreach (DataRow dr in dt.Rows) { CMEDWorkshop Item = new CMEDWorkshop { ID = Int32.Parse(dr["ID"].ToString()), Title = dr["Title"].ToString(), SubTitle = dr["SubTitle"].ToString(), Location = dr["Location"].ToString(), DateLine = dr["DateLine"].ToString(), Prerequisite = dr["Prerequisite"].ToString(), ShortDescription = dr["ShortDescription"].ToString(), LongDescription = dr["LongDescription"].ToString(), PurchaseDescription = dr["PurchaseDescription"].ToString(), Cost = Decimal.Parse(dr["Cost"].ToString()), MealsCost = Decimal.Parse(dr["MealsCost"].ToString()), MealsCount = Int32.Parse(dr["MealsCount"].ToString()), Deposit = Decimal.Parse(dr["Deposit"].ToString()), RegisterURL = dr["RegisterURL"].ToString(), ThumbNailImageUrl = dr["ThumbNailImageUrl"].ToString(), FullImageUrl = dr["FullImageUrl"].ToString(), Active = Boolean.Parse(dr["Active"].ToString()), Archive = Boolean.Parse(dr["Archive"].ToString()), DepositOn = Boolean.Parse(dr["DepositOn"].ToString()), MealCostOn = Boolean.Parse(dr["MealCostOn"].ToString()), Sort = Int32.Parse(dr["Sort"].ToString()), ProductID = Int32.Parse(dr["ProductID"].ToString()), }; Items.Add(Item); } return Items; }
public void SaveCMEDWorkshop(CMEDWorkshop worshop) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SaveCMEDWorkshop"; cmd.Parameters.AddWithValue("@ID", worshop.ID); cmd.Parameters.AddWithValue("@ProductID", worshop.ProductID); cmd.Parameters.AddWithValue("@Title", worshop.Title); cmd.Parameters.AddWithValue("@SubTitle", worshop.SubTitle); cmd.Parameters.AddWithValue("@Location", worshop.Location); cmd.Parameters.AddWithValue("@DateLine", worshop.DateLine); cmd.Parameters.AddWithValue("@Prerequisite", worshop.Prerequisite); cmd.Parameters.AddWithValue("@ShortDescription", worshop.ShortDescription); cmd.Parameters.AddWithValue("@LongDescription", worshop.LongDescription); cmd.Parameters.AddWithValue("@PurchaseDescription", worshop.PurchaseDescription); cmd.Parameters.AddWithValue("@RegisterURL", worshop.RegisterURL); cmd.Parameters.AddWithValue("@ThumbNailImageUrl", worshop.ThumbNailImageUrl); cmd.Parameters.AddWithValue("@FullImageUrl", worshop.FullImageUrl); cmd.Parameters.AddWithValue("@Cost", worshop.Cost); cmd.Parameters.AddWithValue("@MealsCost", worshop.MealsCost); cmd.Parameters.AddWithValue("@MealsCount", worshop.MealsCount); cmd.Parameters.AddWithValue("@Deposit", worshop.Deposit); cmd.Parameters.AddWithValue("@Active", worshop.Active); cmd.Parameters.AddWithValue("@Archive", worshop.Archive); cmd.Parameters.AddWithValue("@Sort", worshop.Sort); cmd.Parameters.AddWithValue("@DepositOn", worshop.DepositOn); cmd.Parameters.AddWithValue("@MealCostOn", worshop.MealCostOn); cmd.Parameters.AddWithValue("@CanPurchase", worshop.CanPurchase); db.Execute(cmd); return; }
public CMEDWorkshop GetCMEDWorkShop(int workshop_id) { DB db = new DB(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetCMEDWorkShop"; cmd.Parameters.AddWithValue("@ID", workshop_id); DataTable dt = db.Execute(cmd); DataRow dr = dt.Rows[0]; CMEDWorkshop workShop = new CMEDWorkshop { ID = Int32.Parse(dr["ID"].ToString()), Title = dr["Title"].ToString(), SubTitle = dr["SubTitle"].ToString(), Location = dr["Location"].ToString(), DateLine = dr["DateLine"].ToString(), Prerequisite = dr["Prerequisite"].ToString(), ShortDescription = dr["ShortDescription"].ToString(), LongDescription = dr["LongDescription"].ToString(), PurchaseDescription = dr["PurchaseDescription"].ToString(), Cost = Decimal.Parse(dr["Cost"].ToString()), MealsCost = Decimal.Parse(dr["MealsCost"].ToString()), MealsCount = Int32.Parse(dr["MealsCount"].ToString()), Deposit = Decimal.Parse(dr["Deposit"].ToString()), RegisterURL = dr["RegisterURL"].ToString(), ThumbNailImageUrl = dr["ThumbNailImageUrl"].ToString(), FullImageUrl = dr["FullImageUrl"].ToString(), Active = Boolean.Parse(dr["Active"].ToString()), Archive = Boolean.Parse(dr["Archive"].ToString()), CanPurchase = Boolean.Parse(dr["CanPurchase"].ToString()), DepositOn = Boolean.Parse(dr["DepositOn"].ToString()), MealCostOn = Boolean.Parse(dr["MealCostOn"].ToString()), Sort = Int32.Parse(dr["Sort"].ToString()), ProductID = Int32.Parse(dr["ProductID"].ToString()), }; return workShop; }
protected void RegisterButton_Click(object sender, ImageClickEventArgs e) { var id = txtID.Value; if (Request.Cookies["email"] == null) { FormsAuthentication.SignOut(); FormsAuthentication.RedirectToLoginPage(); } var email = Request.Cookies["email"].Value; CMEDWorkShopBalance objbalance = controller.GetCMEDWorkShopBalancePayment(Convert.ToInt32(id), email.ToString()); workshop = controller.GetCMEDWorkShop(Convert.ToInt32(id)); if (!string.IsNullOrEmpty(id)) { if (Helper.IsNumeric(id)) { Price = Convert.ToInt32(objbalance.balance); } else { Response.Redirect("http://www.myss.com/"); } var amt = 0m; try { decimal charge = Price; if (charge > 0) { long ShoppingCartID = controller.IssueNewGlobalID(); try { controller.SaveCartItem(workshop.ProductID, Price, ShoppingCartID, EmailTextBox.Text.Trim(), GetUserIP()); } catch (Exception ex) { throw ex; } string auth_status = string.Empty; string auth_code = string.Empty; string auth_message = string.Empty; string auth_response_code = string.Empty; string auth_transaction_id = string.Empty; CMEDShopTransaction transaction = new CMEDShopTransaction { order_id = ShoppingCartID, first_name = FirstNameTextBox.Text, last_name = LastNameTextBox.Text, address = AddressTextBox.Text, city = CityTextBox.Text, state = State.SelectedValue, postal_code = ZipTextBox.Text, email = EmailTextBox.Text, phone_number = PhoneNumberTextBox.Text, transaction_type = "Credit Card", status = "Status" }; try { long transaction_id = controller.CreateCMEDShopTransaction(transaction); CreateCharge(out auth_status, out auth_code, out auth_message, out auth_response_code, out auth_transaction_id, out amt, charge, transaction_id); controller.UpateCMEDShopTransaction(transaction_id, auth_status, auth_code, auth_message, auth_response_code, auth_transaction_id); long order_id = controller.CreateOrderFromCart(ShoppingCartID); HttpCookie Checkout = new HttpCookie("Confirmation"); Checkout["Email"] = transaction.email; Checkout["WorkShopName"] = workshop.Title; Checkout.Expires = DateTime.Now.AddMinutes(30); Response.Cookies.Add(Checkout); Util.SendWelcomeMailWorkShopBalance(transaction, amt, workshop.Title); String s = "CMEDWorkshopPurchaseThankYou.aspx"; Response.Redirect(s); } catch (Exception ex) { string error = ex.Message; lblErrorMessage.Text = "Unable to create customer record, please contact myss.com support: "; return; } } } catch (Exception ex) { string error = ex.Message; lblErrorMessage.Text = "Unable to process your credit card. Please verify the information or try another card. "; return; } } }
protected void btn_SubmitPaypal_Click(object sender, ImageClickEventArgs e) { var id = txtID.Value; if (Request.Cookies["email"] == null) { FormsAuthentication.SignOut(); FormsAuthentication.RedirectToLoginPage(); } var email = Request.Cookies["email"].Value; CMEDWorkShopBalance objbalance = controller.GetCMEDWorkShopBalancePayment(Convert.ToInt32(id), email.ToString()); workshop = controller.GetCMEDWorkShop(Convert.ToInt32(id)); if (!string.IsNullOrEmpty(id)) { if (Helper.IsNumeric(id)) { Price = Convert.ToInt32(objbalance.balance); } else { Response.Redirect("http://www.myss.com/"); } long ShoppingCartID = controller.IssueNewGlobalID(); Response.Cookies["ShoppingCartID"].Value = ShoppingCartID.ToString(); try { controller.SaveCartItem(workshop.ProductID, Price, ShoppingCartID, EmailTextBox.Text.Trim(), GetUserIP()); } catch (Exception ex) { throw ex; } string auth_status = string.Empty; string auth_code = string.Empty; string auth_message = string.Empty; string auth_response_code = string.Empty; string auth_transaction_id = string.Empty; CMEDShopTransaction transaction = new CMEDShopTransaction { order_id = ShoppingCartID, first_name = FirstNameTextBox.Text, last_name = LastNameTextBox.Text, address = AddressTextBox.Text, city = CityTextBox.Text, state = State.SelectedValue, postal_code = ZipTextBox.Text, email = EmailTextBox.Text, phone_number = PhoneNumberTextBox.Text, transaction_type = "Credit Card", status = "in-progress" }; try { if (Request.Cookies["TransactionID"] == null) { long transaction_id = controller.CreateCMEDShopTransaction(transaction); //write the cookie of transaction_id for use later Response.Cookies["TransactionID"].Value = transaction_id.ToString(); } Cart cart = controller.LoadCart(ShoppingCartID); if (cart.order_amount == 0) { Response.Redirect(redirectPage); } NVPAPICaller payPalCaller = new NVPAPICaller(); string retTokenMsg = ""; string token = ""; NVPCodec decoder = new NVPCodec(); string amt01 = cart.order_amount.ToString(); bool retToken = payPalCaller.ShortcutExpressCheckout(amt01, ShoppingCartID, ref token, ref retTokenMsg, true); if (retToken) { HttpContext.Current.Session["token"] = token; Response.Redirect(retTokenMsg); } else { lblErrorMessage.Text = "PayPal is not responding, please try again in a few moments."; } } catch (Exception ex) { throw ex; } } }
protected void Page_Load(object sender, EventArgs e) { var PayPalEnabled = Convert.ToBoolean(ConfigurationManager.AppSettings["PayPalEnabled"]); if (PayPalEnabled) { pnlCreditCard.Enabled = false; pnlCreditCard.Visible = false; RegisterButton.Visible = false; btn_SubmitPaypal.Visible = false; } else { pnlCreditCard.Visible = true; RegisterButton.Visible = true; PaymentMethod.Visible = false; lblPaymentMethod.Visible = false; } if (!IsPostBack) { var m = Request.QueryString["id"]; if (!string.IsNullOrEmpty(m)) { if (Helper.IsNumeric(m)) { try { workshop = controller.GetCMEDWorkShop(Int32.Parse(m)); lblTitle.Text = workshop.Title; lblDateline.Text = workshop.DateLine; lblLocation.Text = workshop.Location; txtID.Value = workshop.ID.ToString(); lnkOverView.NavigateUrl = "CMEDWorkshopDetail.aspx?id=" + workshop.ID.ToString(); lnkRegistration.NavigateUrl = "WorkshopPurchaseDetail.aspx?id=" + workshop.ID.ToString(); ID = workshop.ID; Response.Cookies["WorkShopName"].Value = workshop.Title; if (Request.Cookies["email"] == null) { FormsAuthentication.SignOut(); FormsAuthentication.RedirectToLoginPage(); } var email = Request.Cookies["email"].Value; CMEDWorkShopBalance objbalance = controller.GetCMEDWorkShopBalancePayment(ID, email.ToString()); if (objbalance.balance <= 0) { lblNoRegistration1.Text = "You have no balance to be paid off for this workshop."; lblNoRegistration2.Text = "if you need more information , please contact David Smith at: "; lblNoRegistration1.Visible = true; lblNoRegistration2.Visible = true; lblEmail.Visible = true; lnkEmail.Visible = true; pnlContent.Visible = false; RegistrationTitle.Visible = false; return; } if (objbalance.rowcount == 0) { lblNoRegistration1.Visible = true; lblNoRegistration2.Visible = true; lblEmail.Visible = true; lnkEmail.Visible = true; pnlContent.Visible = false; RegistrationTitle.Visible = false; } else { FirstNameTextBox.Text = objbalance.first_name; LastNameTextBox.Text = objbalance.last_name; EmailTextBox.Text = objbalance.email; AddressTextBox.Text = objbalance.address; CityTextBox.Text = objbalance.city; ZipTextBox.Text = objbalance.posta_code; State.SelectedValue = objbalance.state; PhoneNumberTextBox.Text = objbalance.phone_number; pnlContent.Visible = true; } lblTotalCost.Text = objbalance.balance.ToString("C2"); lblBalance.Text = objbalance.balance.ToString("C2"); Response.Cookies["Balance"].Value = objbalance.balance.ToString(); } catch (Exception ex) { throw ex; } } } } }
protected void Page_Load(object sender, EventArgs e) { var m = Request.QueryString["id"]; if (!string.IsNullOrEmpty(m)) { if (Helper.IsNumeric(m)) { try { workshop = controller.GetCMEDWorkShop(Int32.Parse(m)); lblTitle.Text = workshop.Title; lblDateline.Text = workshop.DateLine; lblLocation.Text = workshop.Location; txtID.Value = workshop.ID.ToString(); lnkOverView.NavigateUrl = "CMEDWorkshopDetail.aspx?id=" + workshop.ID.ToString(); lnkRegistration.NavigateUrl = "WorkshopPurchaseDetail.aspx?id=" + workshop.ID.ToString(); ID = workshop.ID; if (!IsPostBack) { PaymentDropDown.Items.Add(new ListItem { Text = "", Value = "" }); PaymentDropDown.Items.Add(new ListItem { Text = "Full Payment Option - " + String.Format("{0:C}", workshop.Cost), Value = workshop.Cost.ToString("#####.##") }); if (workshop.Deposit > 0 && workshop.DepositOn == false) { PaymentDropDown.Items.Add(new ListItem { Text = "Deposit Payment Option - " + String.Format("{0:C}", workshop.Deposit), Value = workshop.Deposit.ToString("#####.##") }); } decimal balance = workshop.Cost - workshop.Deposit; PaymentDropDown.Items.Add(new ListItem { Text = "Balance Payment - " + String.Format("{0:C}", balance), Value = balance.ToString("#####.##") }); if (workshop.MealsCost > 0 && workshop.MealCostOn == false) { PaymentDropDown.Items.Add(new ListItem { Text = "Meal Plan 7 Meals - " + String.Format("{0:C}", workshop.MealsCost), Value = workshop.MealsCost.ToString("#####.##") }); } } if (PaymentDropDown.SelectedValue.Length > 0) { string TotalCost = PaymentDropDown.SelectedItem.Text; lblTotalCost.Text = TotalCost; } else { lblTotalCost.Text = string.Empty; } } catch (Exception ex) { throw ex; } } } }