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 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();
}
}
public int UpdateDiscountCoupon(DiscountZone discountZone)
{
try
{
Hashtable ht = new Hashtable();
ht.Add("@CouponID", discountZone.CouponID);
ht.Add("@ProfileID", discountZone.ProfileID);
ht.Add("@CouponCode", discountZone.CouponCode);
ht.Add("@CouponTitle", discountZone.CouponTitle);
ht.Add("@CouponDescription", discountZone.CouponDescription);
ht.Add("@CouponType", discountZone.CouponType);
ht.Add("@UseBoromelaCoupon", discountZone.UseBoromelaCoupon);
ht.Add("@UserUploadedCouponPath", discountZone.UserUploadedCouponPath);
ht.Add("@CouponEffectiveDate", discountZone.CouponEffectiveDate);
ht.Add("@CouponExpirydate", discountZone.CouponExpirydate);
ht.Add("@UpdatedOn", discountZone.UpdatedOn);
ht.Add("@TermsCondition", discountZone.TermsCondition);
ht.Add("@PrintedCouponNeed", discountZone.NeedToPrintCoupon);
ht.Add("@DiscountCouponURL", discountZone.DiscountCouponURL);
return(this.ExecuteNonQueryStoredProcedure("USP_DiscountZone_UpdateDiscountCoupon", ht));
}
catch
{
throw;
}
}
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 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);
}
public int AdSubcriptionEmailAddress(DiscountZone discountZone)
{
int intActionResult = 0;
try
{
Hashtable ht = new Hashtable();
ht.Add("@emailAddress", discountZone.DiscountSubcriptionEmail);
if (this.ExecuteStoredProcedureDataTable("USP_DRP_Common_SignUP_BeforeInsert_IsSignUPEmailDuplicate", ht).Rows.Count == 0)
{
ht.Clear();
ht.Add("@emailAddress", discountZone.DiscountSubcriptionEmail);
intActionResult = this.ExecuteNonQueryStoredProcedure("USP_SaveDiscountEmail", ht);
}
else
{
intActionResult = -1;
}
}
catch
{
throw;
}
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_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;
}
}
public DataTable Load_ListComments(DiscountZone discountZone)
{
try
{
Hashtable ht = new Hashtable();
ht.Add("@CouponID", discountZone.CouponID);
return(this.ExecuteStoredProcedureDataTable("USP_DRP_Common_LoadListComments", ht));
}
catch
{
throw;
}
}
public DataTable LoadDiscuntCompany(DiscountZone discountZone)
{
try
{
Hashtable ht = new Hashtable();
ht.Add("@ProfileID", discountZone.ProfileID);
return(this.ExecuteStoredProcedureDataTable("USP_DRP_Common_Load_DiscountAdminCompany", ht));
}
catch
{
throw;
}
}
public DataTable Load_DiscountByCategory(DiscountZone discountZone)
{
try
{
Hashtable ht = new Hashtable();
ht.Add("@CategoryID", discountZone.CategoryID);
return(this.ExecuteStoredProcedureDataTable("USP_DRP_Common_Load_DiscountByCategory", ht));
}
catch
{
throw;
}
}
public DataTable Load_WonCouponPrintingInformation(DiscountZone discountZone)
{
try
{
Hashtable ht = new Hashtable();
ht.Add("@ProfileID", discountZone.ProfileID);
ht.Add("@CouponID", discountZone.CouponID);
return(this.ExecuteStoredProcedureDataTable("USP_DRP_WonPrintCouponInformation", ht));
}
catch
{
throw;
}
}
public DataTable Load_DiscountInformation(DiscountZone discountZone)
{
try
{
Hashtable ht = new Hashtable();
ht.Add("@ProfileID", discountZone.ProfileID);
ht.Add("@CouponID", discountZone.CouponID);
return(this.ExecuteStoredProcedureDataTable("USP_DRP_Common_Load_SpecificDiscount", ht));
}
catch
{
throw;
}
}
public int UpdateDiscountStore(DiscountZone discountZone)
{
try
{
Hashtable ht = new Hashtable();
ht.Add("@ProfileID", discountZone.ProfileID);
ht.Add("@DiscountStoreType", discountZone.DiscountUserType);
return(this.ExecuteNonQueryStoredProcedure("USP_DiscountZone_UpdateDiscountStore", ht));
}
catch
{
throw;
}
}
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();
}
}
public DataTable LoadRecord_BS_SpecificDiscount(DiscountZone discountZone)
{
try
{
Hashtable ht = new Hashtable();
ht.Add("@CouponID", discountZone.CouponID);
ht.Add("@ProfileID", discountZone.ProfileID);
ht.Add("@CouponCode", discountZone.CouponCode);
return(this.ExecuteStoredProcedureDataTable("USP_DRP_CP_Load_SpecificDiscount", ht));
}
catch
{
throw;
}
}
private int AddEmailAdress()
{
int intActionResult = 0;
try
{
DiscountZone discountZone = new DiscountZone();
DiscountManegar manager = new DiscountManegar();
intActionResult = manager.AdSubcriptionEmailAddress(discountZone);
}
catch (Exception ex)
{
}
return(intActionResult);
}
public int Ad_Store(DiscountZone discountZone)
{
int _ActionResult = -1;
try
{
using (BC_DiscountZone bc = new BC_DiscountZone())
{
return(bc.InsertDiscountStore(discountZone));
}
}
catch
{
throw;
}
}
public int Update_Discount(DiscountZone discountZone)
{
int _ActionResult = -1;
try
{
using (BC_DiscountZone bc = new BC_DiscountZone())
{
return(bc.UpdateDiscountCoupon(discountZone));
}
}
catch
{
throw;
}
}
public DataTable Load_WonCouponPrintingInformation(DiscountZone discountZone)
{
int _ActionResult = -1;
try
{
using (BC_DiscountZone bc = new BC_DiscountZone())
{
return(bc.Load_WonCouponPrintingInformation(discountZone));
}
}
catch
{
throw;
}
}
public DataTable Load_ListComments(DiscountZone discountZone)
{
int _ActionResult = -1;
try
{
using (BC_DiscountZone bc = new BC_DiscountZone())
{
return(bc.Load_ListComments(discountZone));
}
}
catch
{
throw;
}
}
public DataTable LoadDiscuntSoreType(DiscountZone discountZone)
{
int _ActionResult = -1;
try
{
using (BC_DiscountZone bc = new BC_DiscountZone())
{
return(bc.LoadDiscuntSoreType(discountZone));
}
}
catch
{
throw;
}
}
public DataTable Load_DiscountByCategory(DiscountZone discountZone)
{
int _ActionResult = -1;
try
{
using (BC_DiscountZone bc = new BC_DiscountZone())
{
return(bc.Load_DiscountByCategory(discountZone));
}
}
catch
{
throw;
}
}
public DataTable LoadRecord_BS_SpecificDiscount(DiscountZone discountZone)
{
int _ActionResult = -1;
try
{
using (BC_DiscountZone bc = new BC_DiscountZone())
{
return(bc.LoadRecord_BS_SpecificDiscount(discountZone));
}
}
catch
{
throw;
}
}
public int AdSubcriptionEmailAddress(DiscountZone discountZone)
{
int _ActionResult = -1;
try
{
using (BC_DiscountZone bc = new BC_DiscountZone())
{
return(bc.AdSubcriptionEmailAddress(discountZone));
}
}
catch
{
throw;
}
}
public int InsertComment(DiscountZone discountZone)
{
try
{
Hashtable ht = new Hashtable();
ht.Add("@ProfileID", discountZone.ProfileID);
ht.Add("@CouponID", discountZone.CouponID);
ht.Add("@EmailAddress", discountZone.EmailAddress);
ht.Add("@Name", discountZone.Name);
ht.Add("@Subject", discountZone.Subject);
ht.Add("@Comment", discountZone.Comment);
return(this.ExecuteNonQueryStoredProcedure("USP_DiscountZone_InsertComment", ht));
}
catch
{
throw;
}
}
public int InsertDiscountStore(DiscountZone discountZone)
{
try
{
Hashtable ht = new Hashtable();
ht.Add("@ProfileID", discountZone.ProfileID);
ht.Add("@DiscountStoreType", discountZone.DiscountUserType);
ht.Add("@StoresIsActive", discountZone.IsActive);
ht.Add("@IsAdminAuthentication", discountZone.IsAdminAuthentication);
ht.Add("@CheckAdminForListiong", discountZone.CheckAdminForListing);
ht.Add("@CheckAdminForListiongFeaturedStore", discountZone.CheckAdminForListingFeatureStore);
ht.Add("@UserType", discountZone.IsAdminAuthentication);
return(this.ExecuteNonQueryStoredProcedure("USP_DiscountZone_InsertDiscountStore", ht));
}
catch
{
throw;
}
}
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 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 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;
}
}
