private bool SaveData() { objCommon = new clsCommon(); if (objCommon.IsRecordExists("tblCouponCode", tblCouponCode.ColumnNames.AppCouponCode, tblCouponCode.ColumnNames.AppCouponCodeID, txtCouponCode.Text, hdnPKID.Value)) { DInfo.ShowMessage("Coupon Code alredy exits.", Enums.MessageType.Error); return(false); } objCouponCode = new tblCouponCode(); if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "") { objCouponCode.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value)); } else { objCouponCode.AddNew(); } objCouponCode.AppCouponCode = txtCouponCode.Text; objCouponCode.s_AppDiscountPer = txtDiscountPer.Text; objCouponCode.s_AppStartDate = txtStartDate.Text; objCouponCode.s_AppEndDate = txtEndDate.Text; objCouponCode.AppIsActive = chkIsActive.Checked; objCouponCode.s_AppType = ddlType.SelectedValue; objCouponCode.Save(); intPkId = objCouponCode.AppCouponCodeID; objCouponCode = null; objCommon = null; return(true); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { lnkSaveAndAddnew.Visible = HasAdd; ViewState["SortOrder"] = appFunctions.Enum_SortOrderBy.Asc; ViewState["SortColumn"] = ""; SetRegulerExpression(); objCommon = new clsCommon(); objCommon.BindEnumtoDDL(typeof(Enums.Enum_CouponCodeType), ddlType, "-- Select Type --"); objCouponCode = null; if ((Request.QueryString.Get("ID") != null)) { objEncrypt = new clsEncryption(); try { hdnPKID.Value = objEncrypt.Decrypt(Request.QueryString.Get("ID"), appFunctions.strKey); } catch (Exception ex) { // noIdFoundRedirect("Employee.aspx"); } objEncrypt = null; SetValuesToControls(); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "HideTab()", true); } } }
private bool Delete(int intPKID) { bool retval = false; objCouponCode = new tblCouponCode(); if (objCouponCode.LoadByPrimaryKey(intPKID)) { objCouponCode.MarkAsDeleted(); objCouponCode.Save(); retval = true; } objCouponCode = null; return(retval); }
private void LoadDataGrid(bool IsResetPageIndex, bool IsSort) { objCouponCode = new tblCouponCode(); objDataTable = objCouponCode.LoadGridData(ddlFields.SelectedValue, txtSearch.Text.Trim(), ddlDateType.SelectedValue, txtStartDate.Text, txtEndDate.Text); if (IsResetPageIndex) { if (dgvGridView.PageCount > 0) { dgvGridView.PageIndex = 0; } } dgvGridView.DataSource = null; dgvGridView.DataBind(); lblCount.Text = 0.ToString(); hdnSelectedIDs.Value = ""; if (objDataTable.Rows.Count <= 0) { DInfo.ShowMessage("No data found", Enums.MessageType.Information); return; } else { if (ddlPerPage.SelectedItem.Text.ToLower() == "all") { dgvGridView.AllowPaging = false; } else { dgvGridView.AllowPaging = true; dgvGridView.PageSize = Convert.ToInt32(ddlPerPage.SelectedItem.Text); } lblCount.Text = objDataTable.Rows.Count.ToString(); objDataTable = SortDatatable(objDataTable, ViewState["SortColumn"].ToString(), (appFunctions.Enum_SortOrderBy)ViewState["SortOrder"], IsSort); dgvGridView.DataSource = objDataTable; dgvGridView.DataBind(); } objCouponCode = null; }
private void SetValuesToControls() { if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "") { objCouponCode = new tblCouponCode(); if (objCouponCode.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value))) { ddlType.SelectedValue = objCouponCode.s_AppType; hdnType.Value = objCouponCode.s_AppType; txtCouponCode.Text = objCouponCode.s_AppCouponCode; txtDiscountPer.Text = objCouponCode.s_AppDiscountPer; txtStartDate.Text = objCouponCode.AppStartDate.ToString("dd-MM-yyyy"); txtEndDate.Text = objCouponCode.AppEndDate.ToString("dd-MM-yyyy"); chkIsActive.Checked = objCouponCode.AppIsActive; if (objCouponCode.AppType == Convert.ToInt32(Enums.Enum_CouponCodeType.General)) { Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "HideTab()", true); } LoadAllData(); } objCouponCode = null; } }
protected void dgvGridView_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e) { if (!string.IsNullOrEmpty(e.CommandArgument.ToString())) { if (e.CommandName == "IsActive") { objCouponCode = new tblCouponCode(); if (objCouponCode.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString()))) { if (objCouponCode.AppIsActive == true) { objCouponCode.AppIsActive = false; } else if (objCouponCode.AppIsActive == false) { objCouponCode.AppIsActive = true; } objCouponCode.Save(); LoadDataGrid(false, false); } objCouponCode = null; } } }
//protected void btnCheckPincode_Click(object sender, EventArgs e) //{ // tblPinCode objPinCode = new tblPinCode(); // objPinCode.Where.AppPinCode.Value = txtPincode.Text; // objPinCode.Query.Load(); // if (objPinCode.RowCount > 0) // { // lblAvailability.Visible = true; // lblAvailability.Text = "Available"; // lblAvailability.ForeColor = System.Drawing.Color.Green; // } // else // { // lblAvailability.Visible = true; // lblAvailability.Text = "Not Available"; // lblAvailability.ForeColor = System.Drawing.Color.Red; // } // objPinCode = null; //} protected void btnCheckCouponCode_Click(object sender, EventArgs e) { decimal decprice = 0; decimal decpricediscount = 0; tblCouponCode objCouponCode = new tblCouponCode(); objDataTable = objCouponCode.CheckCouponCodeExists(txtCouponCode.Text); objCouponCode = null; if (objDataTable.Rows.Count > 0 && lblDiscount.Text == "") { //decprice = Convert.ToDecimal(SpanPrice.InnerText.ToString().Split('.')[1] + "." + SpanPrice.InnerText.ToString().Split('.')[2]); decprice = Convert.ToDecimal(SpanPrice.InnerText.ToString().Split('.')[1]); decpricediscount = (Convert.ToDecimal(objDataTable.Rows[0][tblCouponCode.ColumnNames.AppDiscountPer].ToString()) * decprice) / 100; DataTable dtTemp = new DataTable(); tblCouponCodeProduct objCouponCodeProduct = new tblCouponCodeProduct(); if (objDataTable.Rows[0][tblCouponCode.ColumnNames.AppType].ToString() == Convert.ToInt32(Enums.Enum_CouponCodeType.General).ToString()) { lblCouponCode.Text = "Price after discount: " + Convert.ToInt32(Math.Round((decprice - decpricediscount), 0)); lblCouponCode.ForeColor = System.Drawing.Color.Green; hdnPriceDiscount.Value = Convert.ToInt32(Math.Round(decpricediscount, 0)).ToString(); } else if (objDataTable.Rows[0][tblCouponCode.ColumnNames.AppType].ToString() == Convert.ToInt32(Enums.Enum_CouponCodeType.Category).ToString()) { dtTemp = objCouponCodeProduct.GetReferenceIDByCouponID(objDataTable.Rows[0][tblCouponCode.ColumnNames.AppCouponCodeID].ToString(), Convert.ToInt32(Enums.Enum_CouponCodeType.Category), hdnPKID.Value); objCouponCodeProduct = null; if (dtTemp.Rows.Count > 0) { lblCouponCode.Text = "Price after discount: " + Convert.ToInt32(Math.Round((decprice - decpricediscount), 0)); lblCouponCode.ForeColor = System.Drawing.Color.Green; hdnPriceDiscount.Value = Convert.ToInt32(Math.Round(decpricediscount, 0)).ToString(); } else { lblCouponCode.Text = "This coupon code does not exist for this product."; lblCouponCode.ForeColor = System.Drawing.Color.Red; hdnPriceDiscount.Value = "0"; } } else if (objDataTable.Rows[0][tblCouponCode.ColumnNames.AppType].ToString() == Convert.ToInt32(Enums.Enum_CouponCodeType.SubCategory).ToString()) { dtTemp = objCouponCodeProduct.GetReferenceIDByCouponID(objDataTable.Rows[0][tblCouponCode.ColumnNames.AppCouponCodeID].ToString(), Convert.ToInt32(Enums.Enum_CouponCodeType.SubCategory), hdnPKID.Value); objCouponCodeProduct = null; if (dtTemp.Rows.Count > 0) { lblCouponCode.Text = "Price after discount: " + Convert.ToInt32(Math.Round((decprice - decpricediscount), 0)); lblCouponCode.ForeColor = System.Drawing.Color.Green; hdnPriceDiscount.Value = Convert.ToInt32(Math.Round(decpricediscount, 0)).ToString(); } else { lblCouponCode.Text = "This coupon code does not exist for this product."; lblCouponCode.ForeColor = System.Drawing.Color.Red; hdnPriceDiscount.Value = "0"; } } else if (objDataTable.Rows[0][tblCouponCode.ColumnNames.AppType].ToString() == Convert.ToInt32(Enums.Enum_CouponCodeType.Product).ToString()) { dtTemp = objCouponCodeProduct.GetReferenceIDByCouponID(objDataTable.Rows[0][tblCouponCode.ColumnNames.AppCouponCodeID].ToString(), Convert.ToInt32(Enums.Enum_CouponCodeType.Product), hdnPKID.Value); objCouponCodeProduct = null; if (dtTemp.Rows.Count > 0) { lblCouponCode.Text = "Price after discount: " + Convert.ToInt32(Math.Round((decprice - decpricediscount), 0)); lblCouponCode.ForeColor = System.Drawing.Color.Green; hdnPriceDiscount.Value = Convert.ToInt32(Math.Round(decpricediscount, 0)).ToString(); } else { lblCouponCode.Text = "This coupon code does not exist for this product."; lblCouponCode.ForeColor = System.Drawing.Color.Red; hdnPriceDiscount.Value = "0"; } } objCouponCodeProduct = null; dtTemp = null; } else { hdnPriceDiscount.Value = Convert.ToInt32(Math.Round(decpricediscount, 0)).ToString(); lblCouponCode.Text = "This coupon code does not exist for this product."; lblCouponCode.ForeColor = System.Drawing.Color.Red; } }