private void LoadRecord_DiscountedCompany() { try { DiscountManegar manager = new DiscountManegar(); DataTable dt = new DataTable(); DiscountZone discountZone = new DiscountZone(); discountZone.ProfileID = intProfileID; dt = manager.LoadDiscuntCompany(discountZone); if (dt.Rows.Count > 0) { ddlCompanyName.DataSource = dt; ddlCompanyName.DataValueField = "ProfileID"; ddlCompanyName.DataTextField = "CompanyName"; ddlCompanyName.DataBind(); } else { lblSystemMessage.Text = "No Company available"; } } catch (Exception Exp) { lblSystemMessage.Text = Exp.Message.ToString(); } }
private void Load_DiscountByCompany(int profileID) { try { DiscountManegar manager = new DiscountManegar(); DataTable dt = new DataTable(); DiscountZone objDiscountZone = new DiscountZone(); objDiscountZone.ProfileID = profileID; dt = manager.Load_DiscountByCompany(objDiscountZone); if (dt.Rows.Count > 0) { grvListDiscountLeftpannel.DataSource = dt; grvListDiscountLeftpannel.DataBind(); Total_Record = dt.Rows.Count; } else { grvListDiscountLeftpannel.DataSource = null; grvListDiscountLeftpannel.DataBind(); } } catch (Exception ex) { lblSystemMessage.Text = ex.Message; } }
private int UpdateRecord_DiscountStore() { int intActionResult = 0; DiscountZone discountZone = new DiscountZone(); DiscountManegar manager = new DiscountManegar(); discountZone.ProfileID = Convert.ToInt16(ProfileID); discountZone.DiscountUserType = Convert.ToInt16(GetDiscountType); try { if (ProfileID != 0) { intActionResult = manager.UpdateDiscountStore(discountZone); } else { } } catch (Exception ex) { lblSystemMessage.Text = ex.Message; } return(intActionResult); }
private void Load_CouponPrintingInformation(int profileID, int CouponID) { try { DiscountManegar manager = new DiscountManegar(); DataTable dt = new DataTable(); DiscountZone objDiscountZone = new DiscountZone(); objDiscountZone.ProfileID = ProfileID; objDiscountZone.CouponID = CouponID; dt = manager.Load_CouponPrintingInformation(objDiscountZone); if (dt.Rows.Count > 0) { fvPrientCoupon.DataSource = dt; fvPrientCoupon.DataBind(); Address = dt.Rows[0]["BusinessAddress"].ToString(); } else { this.Display_RecordNotFound_ErrorPage(); } } catch (Exception ex) { lblSystemMessage.Text = ex.Message; } }
private void Load_DiscountInformation(int ProfileID, int CouponID) { try { DiscountManegar manager = new DiscountManegar(); DataTable dt = new DataTable(); DiscountZone objDiscountZone = new DiscountZone(); objDiscountZone.ProfileID = ProfileID; objDiscountZone.CouponID = CouponID; dt = manager.Load_DiscountInformation(objDiscountZone); if (dt.Rows.Count > 0) { grvListDiscountLeftpannel.DataSource = dt; grvListDiscountLeftpannel.DataBind(); this.LoadListComments(CouponID); } else { this.Display_RecordNotFound_ErrorPage(); } } catch (Exception ex) { lblSystemMessage.Text = ex.Message; } }
private int AddRecord_DiscountStore() { int intActionResult = 0; DiscountZone discountZone = new DiscountZone(); DateTimeValidation dateTimeValidation = new DateTimeValidation(); DiscountManegar manager = new DiscountManegar(); discountZone.ProfileID = Convert.ToInt16(ProfileID); discountZone.DiscountUserType = Convert.ToInt16(GetDiscountType); discountZone.IsActive = true; discountZone.CheckAdminForListing = false; discountZone.CheckAdminForListingFeatureStore = false; discountZone.IsAdminAuthentication = true; discountZone.UserType = Convert.ToBoolean(IsAdmin); try { if (ProfileID != 0 && policyRadioButtonList.SelectedValue.ToString() == "1") { intActionResult = manager.Ad_Store(discountZone); } else { intActionResult = -1; } } catch (Exception ex) { lblSystemMessage.Text = ex.Message; } return(intActionResult); }
private void LoadListComments(int _CouponID) { DiscountManegar manager = new DiscountManegar(); DataTable dt = new DataTable(); DiscountZone objDiscountZone = new DiscountZone(); objDiscountZone.CouponID = CouponID; dt = manager.Load_ListComments(objDiscountZone); if (dt.Rows.Count > 0) { grvComments.DataSource = dt; grvComments.DataBind(); } }
private int AddEmailAdress() { int intActionResult = 0; try { DiscountZone discountZone = new DiscountZone(); DiscountManegar manager = new DiscountManegar(); intActionResult = manager.AdSubcriptionEmailAddress(discountZone); } catch (Exception ex) { } return(intActionResult); }
private void LoadLeftPannelDiscountList() { try { DiscountManegar manager = new DiscountManegar(); DataTable dt = new DataTable(); dt = manager.LoadDiscountListLeftPannel(); if (dt.Rows.Count > 0) { grvListDiscountLeftpannel.DataSource = dt; grvListDiscountLeftpannel.DataBind(); } else { grvListDiscountLeftpannel.DataSource = null; grvListDiscountLeftpannel.DataBind(); } } catch (Exception ex) { } }
private int AddReport() { int intActionResult = -1; DiscountZone discountZone = new DiscountZone(); DiscountManegar manager = new DiscountManegar(); discountZone.ProfileID = intProfileID; discountZone.CouponID = intCouponID; discountZone.EmailAddress = txtEmailAddress.Text.ToString(); discountZone.Name = txtName.Text.ToString(); discountZone.Subject = txtSubject.Text.ToString(); discountZone.Report = txtReport.Text.ToString(); try { intActionResult = manager.Ad_Report(discountZone); } catch (Exception ex) { multiview.ActiveViewIndex = 2; lblSystemMessage.Text = ex.Message; } return(intActionResult); }
private void Load_RightPanelFeaturedStores() { try { DiscountManegar manager = new DiscountManegar(); DataTable dt = new DataTable(); dt = manager.Load_RightPanelFeaturedStores(); if (dt.Rows.Count > 0) { dlist.DataSource = dt; dlist.DataBind(); } else { dlist.DataSource = null; dlist.DataBind(); } } catch (Exception ex) { lblSystemMessage.Text = ex.Message; } }
private void Load_RightPanelPopularCouponAndDealCategoriesCount() { try { DiscountManegar manager = new DiscountManegar(); DataTable dt = new DataTable(); dt = manager.Load_RightPanelPopularCouponAndDealCategoriesCount(); if (dt.Rows.Count > 0) { dlist.DataSource = dt; dlist.DataBind(); } else { dlist.DataSource = null; dlist.DataBind(); } } catch (Exception ex) { lblSystemMessage.Text = ex.Message; } }
private void DiscountStoreType() { int inAction = -1; try { DiscountManegar manager = new DiscountManegar(); DataTable dt = new DataTable(); DiscountZone objDiscountZone = new DiscountZone(); objDiscountZone.ProfileID = intProfileID; dt = manager.LoadDiscuntSoreType(objDiscountZone); if (dt.Rows.Count > 0) { DiscountType = Convert.ToInt32(dt.Rows[0]["DiscountStoreType"]); if (DiscountType == 1) { DiscountTypeName = "Premium"; } else if (DiscountType == 2) { DiscountTypeName = "Standard"; } else { /// } } else { Response.Redirect("StoreType.aspx"); } } catch (Exception ex) { lblSystemMessage.Text = ex.Message; } }
private void LoadTopFive_Discount() { try { DiscountManegar manager = new DiscountManegar(); DataTable dt = new DataTable(); dt = manager.LoadList_DZ_Top5_Discount(); if (dt.Rows.Count > 0) { grvTopFiveDiscount.DataSource = dt; grvTopFiveDiscount.DataBind(); } else { grvTopFiveDiscount.DataSource = null; grvTopFiveDiscount.DataBind(); } } catch (Exception ex) { lblSystemMessage.Text = ex.Message; } }
private void LoadAllPrintableDiscount() { try { DiscountManegar manager = new DiscountManegar(); DataTable dt = new DataTable(); dt = manager.LoadAllPrintableDiscount(); if (dt.Rows.Count > 0) { grvListDiscountLeftpannel.DataSource = dt; grvListDiscountLeftpannel.DataBind(); Total_Record = dt.Rows.Count; } else { grvListDiscountLeftpannel.DataSource = null; grvListDiscountLeftpannel.DataBind(); } } catch (Exception ex) { lblSystemMessage.Text = ex.Message; } }
private void DiscountStoreType() { int inAction = -1; try { DiscountManegar manager = new DiscountManegar(); DataTable dt = new DataTable(); DiscountZone objDiscountZone = new DiscountZone(); objDiscountZone.ProfileID = ProfileID; dt = manager.LoadDiscuntSoreType(objDiscountZone); if (dt.Rows.Count > 0) { Response.Redirect("SelectDiscountType.aspx"); } else { } } catch (Exception ex) { lblSystemMessage.Text = ex.Message; } }
private int UpdateRecord_DiscountProfile() { DateTime dtFrom; DateTime dtTo; dtFrom = Convert.ToDateTime(txtFromDate.Text); dtTo = Convert.ToDateTime(txtToDate.Text); txtFromDate.Text = dtFrom.ToString("MM/dd/yyyy"); txtToDate.Text = dtTo.ToString("MM/dd/yyyy"); int intActionResult = 0; int validateInputDate = 0; int validateInputCoupon = 0; DataTable dt = new DataTable(); DiscountZone discountZone = new DiscountZone(); discountZone.CouponID = CouponID; discountZone.ProfileID = ProfileID; discountZone.CouponCode = CouponCode; DateTimeValidation dateTimeValidation = new DateTimeValidation(); DiscountManegar manager = new DiscountManegar(); DateTimeValidation.Date_Validation dateValidation = new DateTimeValidation.Date_Validation(); int validDateRange = DateTime.Compare(Convert.ToDateTime(dateValidation.date_Format_Back_End(txtToDate.Text.Trim())), Convert.ToDateTime(dateValidation.date_Format_Back_End(txtFromDate.Text.Trim()))); if (validDateRange >= 0) { validateInputDate = 1; dateTimeLabel.Text = ""; } else { validateInputDate = 0; dateTimeLabel.Text = "*Enter valid date range."; } discountZone.CouponTitle = couponTitleTextBox.Text.ToString(); discountZone.TermsCondition = termsConditionsTextBox.Text.ToString(); discountZone.CouponDescription = couponDescriptionTextBox.Text.ToString(); discountZone.CouponType = ddlCouponType.SelectedItem.ToString(); discountZone.UseBoromelaCoupon = Convert.ToInt16(DiscountType.SelectedValue); discountZone.UserUploadedCouponPath = ImagePath.ToString(); discountZone.NeedToPrintCoupon = Convert.ToBoolean(isPrintedCouponNeedRadioButtonList.SelectedValue); discountZone.CouponEffectiveDate = Convert.ToDateTime(dateValidation.date_Format_Back_End(txtFromDate.Text.Trim())); discountZone.CouponExpirydate = Convert.ToDateTime(dateValidation.date_Format_Back_End(txtToDate.Text.Trim())); discountZone.UpdatedOn = DateTime.Now; discountZone.DiscountCouponURL = urlTextBox.Text.ToString(); if (DiscountType.SelectedValue.ToString() == "2" && ImagePath == "") { validateInputCoupon = 0; couponLabel.Text = "*Please upload your won coupon."; } else { validateInputCoupon = 1; couponLabel.Text = ""; } try { if (validateInputCoupon == 1 && validateInputDate == 1) { intActionResult = manager.Update_Discount(discountZone); } else { } } catch (Exception ex) { lblSystemMessage.Text = ex.Message; } return(intActionResult); }
private int AddRecord_DiscountProfile() { int intActionResult = 0; int validateInputDate = 0; int validateInputCoupon = 0; DataTable dt = new DataTable(); int startDigit = 00000; DiscountZone discountZone = new DiscountZone(); DateTimeValidation dateTimeValidation = new DateTimeValidation(); DiscountManegar manager = new DiscountManegar(); DateTimeValidation.Date_Validation dateValidation = new DateTimeValidation.Date_Validation(); int validDateRange = DateTime.Compare(Convert.ToDateTime(dateValidation.date_Format_Back_End(txtToDate.Text.Trim())), Convert.ToDateTime(dateValidation.date_Format_Back_End(txtFromDate.Text.Trim()))); try { dt = manager.GenerateCouponCode(); if (dt.Rows.Count > 0) { GeneratedCopunCode = dt.Rows[0]["MaxCouponCode"].ToString(); } } catch (Exception ex) { lblSystemMessage.Text = ex.Message; } if (validDateRange > 0) { validateInputDate = 1; dateTimeLabel.Text = ""; } else { validateInputDate = 0; dateTimeLabel.Text = "*Enter valid date range."; } discountZone.CategoryID = Convert.ToInt16(CategoryID); discountZone.SubcategoryID = Convert.ToInt16(SubCategoryID); discountZone.ProfileID = Convert.ToInt16(ProfileID); discountZone.CouponTitle = couponTitleTextBox.Text.ToString(); discountZone.TermsCondition = termsConditionsTextBox.Text.ToString(); discountZone.CouponDescription = couponDescriptionTextBox.Text.ToString(); discountZone.CouponType = ddlCouponType.SelectedItem.ToString(); if (GetDiscountType == "1") { discountZone.CouponCode = "ApnerDeal-" + (startDigit + Convert.ToInt32(GeneratedCopunCode) + 1); } else { discountZone.CouponCode = "BM-STAN-" + (startDigit + Convert.ToInt32(GeneratedCopunCode) + 1); } discountZone.NeedToPrintCoupon = Convert.ToBoolean(isPrintedCouponNeedRadioButtonList.SelectedValue); discountZone.UseBoromelaCoupon = Convert.ToInt16(DiscountType.SelectedValue); discountZone.UserUploadedCouponPath = ImagePath.ToString(); discountZone.IsActive = true; discountZone.IsAdminAuthentication = true; discountZone.CheckAdminForListing = false; discountZone.UserType = Convert.ToBoolean(IsAdmin); discountZone.CouponEffectiveDate = Convert.ToDateTime(dateValidation.date_Format_Back_End(txtFromDate.Text)); discountZone.CouponExpirydate = Convert.ToDateTime(dateValidation.date_Format_Back_End(txtToDate.Text)); discountZone.UpdatedOn = DateTime.Now; discountZone.DiscountCouponURL = urlTextBox.Text.ToString(); if (DiscountType.SelectedValue.ToString() == "2" && ImagePath == "") { validateInputCoupon = 0; couponLabel.Text = "*Please upload your own coupon."; } else { validateInputCoupon = 1; couponLabel.Text = ""; } try { if (validateInputCoupon == 1 && validateInputDate == 1) { intActionResult = manager.Ad_Discount(discountZone); } else { } } catch (Exception ex) { lblSystemMessage.Text = ex.Message; } return(intActionResult); }
private void SelectRecordDiscount() { DiscountZone discountZone = new DiscountZone(); DateTimeValidation dateTimeValidation = new DateTimeValidation(); DiscountManegar manager = new DiscountManegar(); DataTable dt = new DataTable(); discountZone.CouponID = CouponID; discountZone.ProfileID = ProfileID; discountZone.CouponCode = CouponCode; dt = manager.LoadRecord_BS_SpecificDiscount(discountZone); if (dt.Rows.Count > 0) { couponTitleTextBox.Text = dt.Rows[0]["CouponTitle"].ToString(); couponDescriptionTextBox.Text = dt.Rows[0]["CouponDescription"].ToString(); txtFromDate.Text = dt.Rows[0]["CouponEffectiveDate"].ToString(); txtToDate.Text = dt.Rows[0]["CouponExpirydate"].ToString(); string PrientedCouponNeed = dt.Rows[0]["PrintedCouponNeed"].ToString(); if (PrientedCouponNeed == "True") { isPrintedCouponNeedRadioButtonList.SelectedValue = "True"; } else if (PrientedCouponNeed == "False") { isPrintedCouponNeedRadioButtonList.SelectedValue = "False"; } string CouponTemplate = dt.Rows[0]["UseBoromelaCoupon"].ToString(); if (CouponTemplate == "UsedBoromelaCouponTemplate") { DiscountType.SelectedValue = "1"; Enable_Panel(userCouponUpload, false); Enable_Panel(urlPanel, false); } else if (CouponTemplate == "UsedCompanyCouponTemplate") { DiscountType.SelectedValue = "2"; Enable_Panel(userCouponUpload, true); Enable_Panel(urlPanel, false); ImagePath = dt.Rows[0]["UserUploadedCouponPath"].ToString(); } else if (CouponTemplate == "UsedCompanyURL") { DiscountType.SelectedValue = "3"; Enable_Panel(urlPanel, true); Enable_Panel(userCouponUpload, false); urlTextBox.Text = dt.Rows[0]["DiscountCouponURL"].ToString(); } termsConditionsTextBox.Text = dt.Rows[0]["TermsCondition"].ToString(); } else { strSystemMessage = "<table style='width:500px; border:1px dashed #666666;'>"; strSystemMessage += "<tr>"; strSystemMessage += "<td colspan='2' style='width:100%; color:#000000; padding-top:7px; padding-left:10px;'>"; strSystemMessage += "Product Profile not found!"; strSystemMessage += "<br/><br/>"; strSystemMessage += "<strong>How did this happen? </strong>"; strSystemMessage += "<ul>"; strSystemMessage += "<li>You login session may be expired.</li>"; strSystemMessage += "<li>Your Discount may be deleted by ApnerDeal authority for some reason.</li>"; strSystemMessage += "</ul>"; strSystemMessage += "</td>"; strSystemMessage += "</tr>"; strSystemMessage += "</table>"; lblSystemMessage.Text = UTLUtilities.ShowErrorMessage(strSystemMessage); } }