//private void BindUserEmailid() //{ // try // { // DataTable dt = new DataTable(); // dt = local_category.getAllUserEmailid(); // if (dt.Rows.Count > 0) // { // ddEmailID.DataSource = dt; // ddEmailID.DataTextField = "Emailid"; // ddEmailID.DataValueField = "UserId"; // ddEmailID.DataBind(); // ddEmailID.Items.Insert(0, "Select User Emailid"); // } // } // catch // { } //} protected void btnCreateSubCategory_Click(object sender, EventArgs e) { string couponStatus = Convert.ToString(ddSpecialCoupon.SelectedValue); string couponcode = txtCouponCode.Text.Trim(); //string useremail = ddEmailID.SelectedItem.ToString(); //Int32 userid = Convert.ToInt32(ddEmailID.SelectedValue); decimal priceamount = Convert.ToDecimal(txtPrice.Text.Trim()); int discount = Convert.ToInt32(txtDiscountpercent.Text); bool active = true; int result = 0; try { if (local_product.IfCouponExists(couponcode) == "F") { //result= local_product.AddNewCoupon(useremail, userid, couponcode, discount, priceamount, active); result = local_product.AddNewCoupon(couponStatus, couponcode, discount, priceamount, active); if (result != 0) { lblMessage.ForeColor = Color.Green; lblMessage.Text = "New Coupon Created & Coupon-Code : " + txtCouponCode.Text; txtCouponCode.Text = ""; txtDiscountpercent.Text = ""; txtPrice.Text = ""; ddSpecialCoupon.SelectedIndex = 0; } } else { lblMessage.ForeColor = Color.Red; lblMessage.Text = "Coupon-code already exists!"; } } catch (Exception ex) { lblMessage.ForeColor = Color.Red; lblMessage.Text = ex.Message; } }