protected void Page_Load(object sender, EventArgs e)
{
lblAvialable.Text = GetString("com.department.defaulttaxes");
mDepartmentId = QueryHelper.GetInteger("departmentid", 0);
if (mDepartmentId > 0)
{
mDepartmentInfoObj = DepartmentInfoProvider.GetDepartmentInfo(mDepartmentId);
EditedObject = mDepartmentInfoObj;
if (mDepartmentInfoObj != null)
{
CheckEditedObjectSiteID(mDepartmentInfoObj.DepartmentSiteID);
// Get tax classes assigned to department
DataSet ds = TaxClassInfoProvider.GetDepartmentTaxClasses(mDepartmentId);
if (!DataHelper.DataSourceIsEmpty(ds))
{
mCurrentValues = TextHelper.Join(";", SystemDataHelper.GetStringValues(ds.Tables[0], "TaxClassID"));
}
if (!RequestHelper.IsPostBack())
{
uniSelector.Value = mCurrentValues;
}
}
}
uniSelector.IconPath = GetObjectIconUrl("ecommerce.taxclass", "object.png");
uniSelector.OnSelectionChanged += uniSelector_OnSelectionChanged;
uniSelector.WhereCondition = GetSelectorWhereCondition();
}
protected void Page_Load(object sender, EventArgs e)
{
taxClassId = QueryHelper.GetInteger("taxclassid", 0);
bool hideBreadcrumbs = QueryHelper.GetBoolean("hidebreadcrumbs", false);
string taxClassName = "";
TaxClassInfo tc = TaxClassInfoProvider.GetTaxClassInfo(taxClassId);
if (tc != null)
{
CheckEditedObjectSiteID(tc.TaxClassSiteID);
taxClassName = ResHelper.LocalizeString(tc.TaxClassDisplayName);
}
// initializes page title
string[,] pageTitleTabs = new string[2, 3];
pageTitleTabs[0, 0] = GetString("TaxClass_Edit.ItemListLink");
pageTitleTabs[0, 1] = "~/CMSModules/Ecommerce/Pages/Tools/Configuration/TaxClasses/TaxClass_List.aspx?siteId=" + SiteID;
pageTitleTabs[0, 2] = "_parent";
pageTitleTabs[1, 0] = taxClassName;
pageTitleTabs[1, 1] = "";
pageTitleTabs[1, 2] = "";
CMSMasterPage master = (CMSMasterPage)CurrentMaster;
if (!hideBreadcrumbs)
{
master.Title.Breadcrumbs = pageTitleTabs;
}
master.Tabs.OnTabCreated += Tabs_OnTabCreated;
}
/// <summary>
/// Returns product total tax in site main currency.
/// </summary>
/// <param name="skuPrice">SKU price</param>
/// <param name="skuId">SKU ID</param>
/// <param name="stateId">Customer billing address state ID</param>
/// <param name="countryId">Customer billing addres country ID</param>
/// <param name="isTaxIDSupplied">Indicates if customer tax registration ID is supplied</param>
private static double GetSKUTotalTax(double skuPrice, int skuId, int stateId, int countryId, bool isTaxIDSupplied)
{
double totalTax = 0;
int cacheMinutes = 0;
// Try to get data from cache
using (CachedSection <double> cs = new CachedSection <double>(ref totalTax, cacheMinutes, true, null, "skutotaltax|", skuId, skuPrice, stateId, countryId, isTaxIDSupplied))
{
if (cs.LoadData)
{
// Get all the taxes and their values which are applied to the specified product
DataSet ds = TaxClassInfoProvider.GetTaxes(skuId, countryId, stateId, null);
if (!DataHelper.DataSourceIsEmpty(ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
bool zeroTax = ValidationHelper.GetBoolean(dr["TaxClassZeroIfIDSupplied"], false);
if (!(isTaxIDSupplied && zeroTax))
{
double taxValue = ValidationHelper.GetDouble(dr["TaxValue"], 0);
bool isFlat = ValidationHelper.GetBoolean(dr["TaxIsFlat"], false);
// Add tax value
totalTax += TaxClassInfoProvider.GetTaxValue(skuPrice, taxValue, isFlat);
}
}
}
// Cache the data
cs.Data = totalTax;
}
}
return(totalTax);
}
protected void Page_Load(object sender, EventArgs e)
{
// Check UI element
CheckUIElementAccessHierarchical(ModuleName.ECOMMERCE, IsMultiStoreConfiguration ? "Tools.Ecommerce.CountriesTaxClasses" : "Configuration.TaxClasses.Countries");
taxClassId = QueryHelper.GetInteger("objectid", 0);
TaxClassInfo taxClassObj = TaxClassInfoProvider.GetTaxClassInfo(taxClassId);
EditedObject = taxClassObj;
// Check if configured tax class belongs to configured site
if (taxClassObj != null)
{
CheckEditedObjectSiteID(taxClassObj.TaxClassSiteID);
}
GridViewCountries.Columns[0].HeaderText = GetString("TaxClass_Country.Country");
GridViewCountries.Columns[1].HeaderText = GetString("TaxClass_Country.Value");
DataSet ds = TaxClassCountryInfoProvider.GetCountriesAndTaxValues(taxClassId);
// Bounded CountryID field
GridViewCountries.Columns[2].Visible = true;
GridViewCountries.DataSource = ds.Tables[0];
GridViewCountries.DataBind();
// After id is copied, the CountryID column it's not needed anymore
GridViewCountries.Columns[2].Visible = false;
// Set header actions
CurrentMaster.HeaderActions.AddAction(new SaveAction());
CurrentMaster.HeaderActions.ActionPerformed += HeaderActions_ActionPerformed;
}
protected void Page_Load(object sender, EventArgs e)
{
mTaxClassId = QueryHelper.GetInteger("objectid", 0);
if (mTaxClassId > 0)
{
mTaxClassInfoObj = TaxClassInfoProvider.GetTaxClassInfo(mTaxClassId);
EditedObject = mTaxClassInfoObj;
if (mTaxClassInfoObj != null)
{
int editedSiteId = mTaxClassInfoObj.TaxClassSiteID;
// Check object's site id
CheckEditedObjectSiteID(editedSiteId);
// Offer global products when allowed
bool offerGlobalProducts;
if (editedSiteId != 0)
{
offerGlobalProducts = ECommerceSettings.AllowGlobalProducts(editedSiteId);
}
// Configuring global products
else
{
offerGlobalProducts = ECommerceSettings.AllowGlobalProducts(CurrentSiteName);
}
PreloadUniSelector(offerGlobalProducts);
uniSelector.WhereCondition = GetSelectorWhereCondition(offerGlobalProducts);
}
}
}
protected void AddTaxClassToProduct()
{
// Prepare the parameters
// string where = "SKUName LIKE '%%'";
SKUInfo product = null;
// Get the product
DataSet products = SKUInfoProvider.GetSKUs(null, null);
if (!DataHelper.DataSourceIsEmpty(products))
{
int nb = products.Tables[0].Rows.Count;
for (int i = 0; i < nb; i++)
{
//product = new SKUInfo(products.Tables[0].Rows[0]);
DataRow row = products.Tables[0].Rows[i];
product = new SKUInfo(row);
// Get the tax class
TaxClassInfo taxClass = TaxClassInfoProvider.GetTaxClassInfo("TVA_EU21", SiteContext.CurrentSiteName);
TaxClassInfo taxClass1 = TaxClassInfoProvider.GetTaxClassInfo("VAT", SiteContext.CurrentSiteName);
if ((product != null) && (taxClass != null))
{
// Add tax class to product
SKUTaxClassInfoProvider.AddTaxClassToSKU(taxClass.TaxClassID, product.SKUID);
SKUTaxClassInfoProvider.AddTaxClassToSKU(taxClass1.TaxClassID, product.SKUID);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
EditedObject = Product;
if (ProductID > 0)
{
DataSet ds = TaxClassInfoProvider.GetSKUTaxClasses(ProductID);
if (!DataHelper.DataSourceIsEmpty(ds))
{
currentValues = TextHelper.Join(";", DataHelper.GetStringValues(ds.Tables[0], "TaxClassID"));
}
uniSelector.WhereCondition = GetWhereCondition();
if (!RequestHelper.IsPostBack())
{
uniSelector.Value = currentValues;
}
headTitle.Text = GetString("product_edit_tax.taxtitle");
}
// Get category of product
OptionCategoryInfo category = OptionCategoryInfoProvider.GetOptionCategoryInfo(Product.SKUOptionCategoryID);
// Ensure correct info label for Attribute and Text product option
if (category != null)
{
if (category.CategoryType != OptionCategoryTypeEnum.Products)
{
headTitle.Text = GetString("product_edit_tax.taxtitleforoption");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Init header actions
HeaderActions actions = CurrentMaster.HeaderActions;
actions.ActionPerformed += HeaderActions_ActionPerformed;
string newElementName;
if (IsMultiStoreConfiguration)
{
newElementName = "new.configuration.globaltaxclass";
CheckUIElementAccessHierarchical(ModuleName.ECOMMERCE, "Tools.Ecommerce.TaxClasses");
}
else
{
newElementName = "new.configuration.taxclass";
CheckUIElementAccessHierarchical(ModuleName.ECOMMERCE, "Configuration.TaxClasses");
}
// Prepare the new tax class header element
actions.ActionsList.Add(new HeaderAction
{
Text = GetString("TaxClass_List.NewItemCaption"),
RedirectUrl = GetRedirectURL(newElementName),
});
// Show copy from global link when not configuring global tax classes
if (ConfiguredSiteID != 0)
{
// Show "Copy from global" link only if there is at least one global tax class
DataSet ds = TaxClassInfoProvider.GetTaxClasses().TopN(1).OnSite(0).Column("TaxClassID");
if (!DataHelper.DataSourceIsEmpty(ds))
{
actions.ActionsList.Add(new HeaderAction
{
Text = GetString("general.copyfromglobal"),
OnClientClick = "return ConfirmCopyFromGlobal();",
CommandName = "copyFromGlobal",
ButtonStyle = ButtonStyle.Default
});
// Register javascript to confirm action
string script = "function ConfirmCopyFromGlobal() {return confirm(" + ScriptHelper.GetString(GetString("com.ConfirmTaxClassFromGlobal")) + ");}";
ScriptHelper.RegisterClientScriptBlock(this, typeof(string), "ConfirmCopyFromGlobal", ScriptHelper.GetScript(script));
}
}
// Show information about usage of global objects when used on site
HandleGlobalObjectInformation(UniGrid.ObjectType);
// Filter records by site
UniGrid.WhereCondition = "ISNULL(TaxClassSiteID, 0) = " + ConfiguredSiteID;
}
protected void Page_Load(object sender, EventArgs e)
{
ScriptHelper.RegisterJQuery(this);
// Check UI element
CheckUIElementAccessHierarchical(ModuleName.ECOMMERCE, IsMultiStoreConfiguration ? "Tools.Ecommerce.CountriesTaxClasses" : "Configuration.TaxClasses.Countries");
taxClassId = QueryHelper.GetInteger("objectid", 0);
TaxClassInfo taxClassObj = TaxClassInfoProvider.GetTaxClassInfo(taxClassId);
EditedObject = taxClassObj;
// Check if configured tax class belongs to configured site
if (taxClassObj != null)
{
CheckEditedObjectSiteID(taxClassObj.TaxClassSiteID);
currencyCode = CurrencyInfoProvider.GetMainCurrencyCode(taxClassObj.TaxClassSiteID);
// Check presence of main currency
CheckMainCurrency(taxClassObj.TaxClassSiteID);
}
GridViewCountries.Columns[0].HeaderText = GetString("TaxClass_Country.Country");
GridViewCountries.Columns[1].HeaderText = GetString("TaxClass_Country.Value");
GridViewCountries.Columns[2].HeaderText = GetString("TaxClass_Country.IsFlat");
DataSet ds = TaxClassCountryInfoProvider.GetCountriesAndTaxValues(taxClassId);
GridViewCountries.Columns[3].Visible = true;
GridViewCountries.DataSource = ds.Tables[0];
GridViewCountries.DataBind();
// After id is copied, the 4th column it's not needed anymore
GridViewCountries.Columns[3].Visible = false;
// Init scripts
string currencySwitchScript = string.Format(@"
function switchCurrency(isFlatValue, labelId){{
if(isFlatValue)
{{
$cmsj('#' + labelId).html('{0}');
}}else{{
$cmsj('#' + labelId).html('%');
}}
}}", ScriptHelper.GetString(HTMLHelper.HTMLEncode(currencyCode), false));
ScriptHelper.RegisterClientScriptBlock(this, typeof(string), "CurrencySwitch", currencySwitchScript, true);
ScriptHelper.RegisterStartupScript(this, typeof(string), "InitializeGrid", "$cmsj('input[id*=\"chkIsFlatValue\"]').change();", true);
// Set header actions
CurrentMaster.HeaderActions.AddAction(new SaveAction(this));
CurrentMaster.HeaderActions.ActionPerformed += HeaderActions_ActionPerformed;
}
/// <summary>
/// Sets data to database.
/// </summary>
protected void btnOK_Click(object sender, EventArgs e)
{
CheckConfigurationModification();
string errorMessage = new Validator()
.NotEmpty(txtTaxClassDisplayName.Text.Trim(), GetString("general.requiresdisplayname"))
.NotEmpty(txtTaxClassName.Text.Trim(), GetString("general.requirescodename")).Result;
if (!ValidationHelper.IsCodeName(txtTaxClassName.Text.Trim()))
{
errorMessage = GetString("General.ErrorCodeNameInIdentificatorFormat");
}
if (errorMessage == "")
{
// TaxClassName must be unique
TaxClassInfo taxClassObj = TaxClassInfoProvider.GetTaxClassInfo(txtTaxClassName.Text.Trim(), SiteInfoProvider.GetSiteName(ConfiguredSiteID));
// If taxClassName value is unique
if ((taxClassObj == null) || (taxClassObj.TaxClassID == taxclassid))
{
// If taxClassName value is unique -> determine whether it is update or insert
if (taxClassObj == null)
{
// Get TaxClassInfo object by primary key
taxClassObj = TaxClassInfoProvider.GetTaxClassInfo(taxclassid);
}
if (taxClassObj != null)
{
taxClassObj.TaxClassDisplayName = txtTaxClassDisplayName.Text.Trim();
taxClassObj.TaxClassName = txtTaxClassName.Text.Trim();
taxClassObj.TaxClassZeroIfIDSupplied = chkTaxZero.Checked;
TaxClassInfoProvider.SetTaxClassInfo(taxClassObj);
lblInfo.Visible = true;
lblInfo.Text = GetString("General.ChangesSaved");
}
}
else
{
lblError.Visible = true;
lblError.Text = GetString("TaxClass_Edit.TaxClassNameExists");
}
}
else
{
lblError.Visible = true;
lblError.Text = errorMessage;
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Check permissions for CMS Desk -> Ecommerce
if (!CMSContext.CurrentUser.IsAuthorizedPerUIElement("CMS.Ecommerce", "Configuration.TaxClasses.General"))
{
RedirectToCMSDeskUIElementAccessDenied("CMS.Ecommerce", "Configuration.TaxClasses.General");
}
rfvTaxClassDisplayName.ErrorMessage = GetString("general.requiresdisplayname");
rfvTaxClassName.ErrorMessage = GetString("general.requirescodename");
// Control initializations
lblTaxClassDisplayName.Text = GetString("TaxClass_Edit.TaxClassDisplayNameLabel");
lblTaxClassName.Text = GetString("TaxClass_Edit.TaxClassNameLabel");
lblTaxZero.Text = GetString("TaxClass_Edit.lblTaxZero");
btnOk.Text = GetString("General.OK");
// Get taxClass id from querystring
taxclassid = QueryHelper.GetInteger("taxclassid", 0);
if (taxclassid > 0)
{
TaxClassInfo taxClassObj = TaxClassInfoProvider.GetTaxClassInfo(taxclassid);
EditedObject = taxClassObj;
if (taxClassObj != null)
{
CheckEditedObjectSiteID(taxClassObj.TaxClassSiteID);
// Fill editing form
if (!RequestHelper.IsPostBack())
{
LoadData(taxClassObj);
// Show that the taxClass was created or updated successfully
if (QueryHelper.GetString("saved", "") == "1")
{
lblInfo.Visible = true;
lblInfo.Text = GetString("General.ChangesSaved");
}
}
}
else
{
btnOk.Enabled = false;
lblError.Visible = true;
lblError.Text = GetString("TaxClass_Edit.TaxClassDoesNotExists");
return;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Init header actions
HeaderActions actions = CurrentMaster.HeaderActions;
actions.ActionPerformed += new CommandEventHandler(HeaderActions_ActionPerformed);
// Prepare the new tax class header element
actions.ActionsList.Add(new HeaderAction()
{
Text = GetString("TaxClass_List.NewItemCaption"),
RedirectUrl = ResolveUrl("TaxClass_New.aspx?siteId=" + SiteID),
ImageUrl = GetImageUrl("Objects/Ecommerce_TaxClass/add.png"),
ControlType = HeaderActionTypeEnum.Hyperlink
});
// Show copy from global link when not configuring global tax classes
if (ConfiguredSiteID != 0)
{
// Show "Copy from global" link only if there is at least one global tax class
DataSet ds = TaxClassInfoProvider.GetTaxClasses("TaxClassSiteID IS NULL", null, 1, "TaxClassID");
if (!DataHelper.DataSourceIsEmpty(ds))
{
actions.ActionsList.Add(new HeaderAction()
{
Text = GetString("general.copyfromglobal"),
OnClientClick = "return ConfirmCopyFromGlobal();",
ImageUrl = GetImageUrl("Objects/Ecommerce_TaxClass/fromglobal.png"),
CommandName = "copyFromGlobal",
ControlType = HeaderActionTypeEnum.LinkButton
});
// Register javascript to confirm action
string script = "function ConfirmCopyFromGlobal() {return confirm(" + ScriptHelper.GetString(GetString("com.ConfirmTaxClassFromGlobal")) + ");}";
ScriptHelper.RegisterClientScriptBlock(this, typeof(string), "ConfirmCopyFromGlobal", ScriptHelper.GetScript(script));
}
}
UniGrid.OnAction += new OnActionEventHandler(uniGrid_OnAction);
UniGrid.ZeroRowsText = GetString("general.nodatafound");
// Configuring global records from specific site
if ((ConfiguredSiteID == 0) && (SiteID != 0))
{
ShowInformation(GetString("com.UsingGlobalSettings"));
}
// Filter records by site
UniGrid.WhereCondition = "ISNULL(TaxClassSiteID, 0) = " + ConfiguredSiteID;
}
/// <summary>
/// Handles the UniGrid's OnAction event.
/// </summary>
/// <param name="actionName">Name of item (button) that throws event</param>
/// <param name="actionArgument">ID (value of Primary key) of corresponding data row</param>
protected void uniGrid_OnAction(string actionName, object actionArgument)
{
if (actionName == "edit")
{
URLHelper.Redirect("TaxClass_Frameset.aspx?taxclassid=" + Convert.ToString(actionArgument) + "&siteId=" + SiteID);
}
else if (actionName == "delete")
{
// Check permissions
CheckConfigurationModification();
TaxClassInfoProvider.DeleteTaxClassInfo(ValidationHelper.GetInteger(actionArgument, 0));
}
}
protected void Page_Load(object sender, EventArgs e)
{
var taxClassId = QueryHelper.GetInteger("objectid", 0);
var taxClassInfoObj = TaxClassInfoProvider.GetTaxClassInfo(taxClassId);
EditedObject = taxClassInfoObj;
if (taxClassInfoObj != null)
{
editedSiteId = taxClassInfoObj.TaxClassSiteID;
// Check object's site id
CheckEditedObjectSiteID(editedSiteId);
uniGrid.WhereCondition = new WhereCondition().WhereEquals("SKUTaxClassID", taxClassId).ToString(true);
}
}
/// <summary>
/// Handles the UniGrid's OnAction event.
/// </summary>
/// <param name="actionName">Name of item (button) that throws event</param>
/// <param name="actionArgument">ID (value of Primary key) of corresponding data row</param>
protected void uniGrid_OnAction(string actionName, object actionArgument)
{
if (actionName == "edit")
{
var editElementName = IsMultiStoreConfiguration ? "edit.Tools.Ecommerce.TaxProperties" : "edit.Configuration.TaxClasses";
string url = GetRedirectURL(editElementName);
url = URLHelper.AddParameterToUrl(url, "objectid", ValidationHelper.GetInteger(actionArgument, 0).ToString("0"));
URLHelper.Redirect(url);
}
else if (actionName == "delete")
{
// Check permissions
CheckConfigurationModification();
TaxClassInfoProvider.DeleteTaxClassInfo(ValidationHelper.GetInteger(actionArgument, 0));
}
}
/// <summary>
/// Sets data to database.
/// </summary>
protected void btnOK_Click(object sender, EventArgs e)
{
CheckConfigurationModification();
string errorMessage = new Validator()
.NotEmpty(txtTaxClassDisplayName.Text.Trim(), GetString("general.requiresdisplayname"))
.NotEmpty(txtTaxClassName.Text.Trim(), GetString("general.requirescodename")).Result;
if (!ValidationHelper.IsCodeName(txtTaxClassName.Text.Trim()))
{
errorMessage = GetString("General.ErrorCodeNameInIdentificatorFormat");
}
if (errorMessage == "")
{
TaxClassInfo taxClassObj = TaxClassInfoProvider.GetTaxClassInfo(txtTaxClassName.Text.Trim(), SiteInfoProvider.GetSiteName(ConfiguredSiteID));
if (taxClassObj == null)
{
// If taxClassName value is unique for configured site
taxClassObj = new TaxClassInfo();
taxClassObj.TaxClassDisplayName = txtTaxClassDisplayName.Text.Trim();
taxClassObj.TaxClassName = txtTaxClassName.Text.Trim();
taxClassObj.TaxClassZeroIfIDSupplied = chkTaxZero.Checked;
taxClassObj.TaxClassSiteID = ConfiguredSiteID;
TaxClassInfoProvider.SetTaxClassInfo(taxClassObj);
URLHelper.Redirect("TaxClass_Frameset.aspx?taxclassid=" + Convert.ToString(taxClassObj.TaxClassID) + "&saved=1&siteId=" + SiteID);
}
else
{
lblError.Visible = true;
lblError.Text = GetString("TaxClass_Edit.TaxClassNameExists");
}
}
else
{
lblError.Visible = true;
lblError.Text = errorMessage;
}
}
protected void Page_Load(object sender, EventArgs e)
{
lblSiteTitle.Text = GetString("product_edit_tax.taxtitle");
if (ProductID > 0)
{
DataSet ds = TaxClassInfoProvider.GetSKUTaxClasses(ProductID);
if (!DataHelper.DataSourceIsEmpty(ds))
{
currentValues = TextHelper.Join(";", SqlHelperClass.GetStringValues(ds.Tables[0], "TaxClassID"));
}
this.uniSelector.WhereCondition = GetWhereCondition(currentValues);
if (!RequestHelper.IsPostBack())
{
this.uniSelector.Value = currentValues;
}
}
this.uniSelector.IconPath = GetObjectIconUrl("ecommerce.taxclass", "object.png");
}
protected void Page_Load(object sender, EventArgs e)
{
rfvTaxClassDisplayName.ErrorMessage = GetString("general.requiresdisplayname");
rfvTaxClassName.ErrorMessage = GetString("general.requirescodename");
// Get taxClass id from querystring
taxclassid = QueryHelper.GetInteger("taxclassid", 0);
if (taxclassid > 0)
{
TaxClassInfo taxClassObj = TaxClassInfoProvider.GetTaxClassInfo(taxclassid);
EditedObject = taxClassObj;
if (taxClassObj != null)
{
CheckEditedObjectSiteID(taxClassObj.TaxClassSiteID);
// Fill editing form
if (!RequestHelper.IsPostBack())
{
LoadData(taxClassObj);
// Show that the taxClass was created or updated successfully
if (QueryHelper.GetString("saved", "") == "1")
{
// Show message
ShowChangesSaved();
}
}
}
else
{
btnOk.Enabled = false;
// Show error message
ShowError(GetString("TaxClass_Edit.TaxClassDoesNotExists"));
return;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Check UI element
CheckUIElementAccessHierarchical(ModuleName.ECOMMERCE, IsMultiStoreConfiguration ? "Tools.Ecommerce.StatesTaxClasses" : "Configuration.TaxClasses.States");
// Get tax class Id from URL
taxClassId = QueryHelper.GetInteger("objectid", 0);
TaxClassInfo taxClass = TaxClassInfoProvider.GetTaxClassInfo(taxClassId);
EditedObject = taxClass;
// Check if configured tax class belongs to configured site
if (taxClass != null)
{
// Check site id of tax class
CheckEditedObjectSiteID(taxClass.TaxClassSiteID);
}
if (!RequestHelper.IsPostBack())
{
// Fill the drpCountry with countries which have some states or colonies
drpCountry.DataSource = CountryInfoProvider.GetCountriesWithStates();
drpCountry.DataValueField = "CountryID";
drpCountry.DataTextField = "CountryDisplayName";
drpCountry.DataBind();
}
// Set grid view properties
gvStates.Columns[0].HeaderText = GetString("taxclass_state.gvstates.state");
gvStates.Columns[1].HeaderText = GetString("Code");
gvStates.Columns[2].HeaderText = GetString("taxclass_state.gvstates.value");
gvStates.Columns[3].HeaderText = GetString("StateId");
LoadGridViewData();
// Set header actions
CurrentMaster.HeaderActions.AddAction(new SaveAction());
CurrentMaster.HeaderActions.ActionPerformed += HeaderActions_ActionPerformed;
CurrentMaster.DisplaySiteSelectorPanel = true;
}
protected void Page_Load(object sender, EventArgs e)
{
taxClassId = QueryHelper.GetInteger("taxclassid", 0);
bool hideBreadcrumbs = QueryHelper.GetBoolean("hidebreadcrumbs", false);
string taxClassName = "";
TaxClassInfo tc = TaxClassInfoProvider.GetTaxClassInfo(taxClassId);
if (tc != null)
{
CheckEditedObjectSiteID(tc.TaxClassSiteID);
taxClassName = ResHelper.LocalizeString(tc.TaxClassDisplayName);
}
// initializes page title
string[,] pageTitleTabs = new string[2, 3];
pageTitleTabs[0, 0] = GetString("TaxClass_Edit.ItemListLink");
pageTitleTabs[0, 1] = "~/CMSModules/Ecommerce/Pages/Tools/Configuration/TaxClasses/TaxClass_List.aspx?siteId=" + SiteID;
pageTitleTabs[0, 2] = "configEdit";
pageTitleTabs[1, 0] = taxClassName;
pageTitleTabs[1, 1] = "";
pageTitleTabs[1, 2] = "";
CMSMasterPage master = (CMSMasterPage)this.CurrentMaster;
if (!hideBreadcrumbs)
{
master.Title.Breadcrumbs = pageTitleTabs;
}
master.Title.TitleText = GetString("TaxClass_Edit.HeaderCaption-Properties");
master.Title.TitleImage = GetImageUrl("Objects/Ecommerce_TaxClass/object.png");
master.Title.HelpTopicName = "new_classgeneral_tab";
master.Title.HelpName = "helpTopic";
master.Tabs.ModuleName = "CMS.Ecommerce";
master.Tabs.ElementName = "Configuration.TaxClasses";
master.Tabs.UrlTarget = "taxClassContent";
master.Tabs.OnTabCreated += new UITabs.TabCreatedEventHandler(Tabs_OnTabCreated);
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsMultiStoreConfiguration)
{
CheckUIElementAccessHierarchical(ModuleName.ECOMMERCE, "Ecommerce.GlobalDepartments.DefaultTaxClasses");
}
else
{
CheckUIElementAccessHierarchical(ModuleName.ECOMMERCE, "Configuration.Departments.TaxClasses");
}
mDepartmentId = QueryHelper.GetInteger("objectId", 0);
if (mDepartmentId > 0)
{
mDepartmentInfoObj = DepartmentInfoProvider.GetDepartmentInfo(mDepartmentId);
EditedObject = mDepartmentInfoObj;
if (mDepartmentInfoObj != null)
{
CheckEditedObjectSiteID(mDepartmentInfoObj.DepartmentSiteID);
// Get tax classes assigned to department
DataSet ds = TaxClassInfoProvider.GetDepartmentTaxClasses(mDepartmentId);
if (!DataHelper.DataSourceIsEmpty(ds))
{
mCurrentValues = TextHelper.Join(";", DataHelper.GetStringValues(ds.Tables[0], "TaxClassID"));
}
if (!RequestHelper.IsPostBack())
{
uniSelector.Value = mCurrentValues;
}
}
}
uniSelector.OnSelectionChanged += uniSelector_OnSelectionChanged;
uniSelector.WhereCondition = GetSelectorWhereCondition();
}
protected void RemoveTaxClassFromProduct()
{
// Prepare the parameters
// string where = "SKUName LIKE N'MyNew%'";
SKUInfo product = null;
// Get the tax class
TaxClassInfo taxClass = TaxClassInfoProvider.GetTaxClassInfo("VAT", SiteContext.CurrentSiteName);
// TaxClassInfo taxClass1 = TaxClassInfoProvider.GetTaxClassInfo("VAT", CMSContext.CurrentSiteName);
// Get the product
DataSet products = SKUInfoProvider.GetSKUs(null, null);
if (!DataHelper.DataSourceIsEmpty(products))
{
// product = new SKUInfo(products.Tables[0].Rows[0]);
// }
int nb = products.Tables[0].Rows.Count;
for (int i = 0; i < nb; i++)
{
DataRow row = products.Tables[0].Rows[i];
product = new SKUInfo(row);
if ((product != null) && (taxClass != null))
{
// Get the tax class added to product
SKUTaxClassInfo skuTaxClass = SKUTaxClassInfoProvider.GetSKUTaxClassInfo(taxClass.TaxClassID, product.SKUID);
// Remove tax class from product
SKUTaxClassInfoProvider.DeleteSKUTaxClassInfo(skuTaxClass);
}
// }
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Check permissions for CMS Desk -> Ecommerce
if (!CMSContext.CurrentUser.IsAuthorizedPerUIElement("CMS.Ecommerce", "Configuration.Departments.TaxClasses"))
{
RedirectToCMSDeskUIElementAccessDenied("CMS.Ecommerce", "Configuration.Departments.TaxClasses");
}
lblAvialable.Text = GetString("com.department.defaulttaxes");
mDepartmentId = QueryHelper.GetInteger("departmentid", 0);
if (mDepartmentId > 0)
{
mDepartmentInfoObj = DepartmentInfoProvider.GetDepartmentInfo(mDepartmentId);
EditedObject = mDepartmentInfoObj;
if (mDepartmentInfoObj != null)
{
CheckEditedObjectSiteID(mDepartmentInfoObj.DepartmentSiteID);
DataSet ds = TaxClassInfoProvider.GetDepartmentTaxClasses(mDepartmentId);
if (!DataHelper.DataSourceIsEmpty(ds))
{
mCurrentValues = TextHelper.Join(";", SqlHelperClass.GetStringValues(ds.Tables[0], "TaxClassID"));
}
if (!RequestHelper.IsPostBack())
{
uniSelector.Value = mCurrentValues;
}
}
}
uniSelector.IconPath = GetObjectIconUrl("ecommerce.taxclass", "object.png");
uniSelector.OnSelectionChanged += uniSelector_OnSelectionChanged;
uniSelector.WhereCondition = GetSelectorWhereCondition();
}
protected void Page_Load(object sender, EventArgs e)
{
ScriptHelper.RegisterJQuery(this);
// Check UI element
CheckUIElementAccessHierarchical(ModuleName.ECOMMERCE, IsMultiStoreConfiguration ? "Tools.Ecommerce.StatesTaxClasses" : "Configuration.TaxClasses.States");
// Get tax class Id from URL
taxClassId = QueryHelper.GetInteger("objectid", 0);
TaxClassInfo taxClass = TaxClassInfoProvider.GetTaxClassInfo(taxClassId);
EditedObject = taxClass;
// Check if configured tax class belongs to configured site
if (taxClass != null)
{
// Check site id of tax class
CheckEditedObjectSiteID(taxClass.TaxClassSiteID);
currencyCode = CurrencyInfoProvider.GetMainCurrencyCode(taxClass.TaxClassSiteID);
// Check presence of main currency
CheckMainCurrency(taxClass.TaxClassSiteID);
}
if (!RequestHelper.IsPostBack())
{
// Fill the drpCountry with countries which have some states or colonies
drpCountry.DataSource = CountryInfoProvider.GetCountriesWithStates();
drpCountry.DataValueField = "CountryID";
drpCountry.DataTextField = "CountryDisplayName";
drpCountry.DataBind();
}
// Set grid view properties
gvStates.Columns[0].HeaderText = GetString("taxclass_state.gvstates.state");
gvStates.Columns[1].HeaderText = GetString("Code");
gvStates.Columns[2].HeaderText = GetString("taxclass_state.gvstates.value");
gvStates.Columns[3].HeaderText = GetString("taxclass_state.gvstates.isflat");
gvStates.Columns[4].HeaderText = GetString("StateId");
LoadGridViewData();
// Init scripts
string currencySwitchScript = string.Format(@"
function switchCurrency(isFlatValue, labelId){{
if(isFlatValue)
{{
jQuery('#' + labelId).html('{0}');
}}else{{
jQuery('#' + labelId).html('%');
}}
}}", ScriptHelper.GetString(HTMLHelper.HTMLEncode(currencyCode), false));
ScriptHelper.RegisterClientScriptBlock(this, typeof(string), "CurrencySwitch", currencySwitchScript, true);
ScriptHelper.RegisterStartupScript(this, typeof(string), "InitializeGrid", "jQuery('input[id*=\"chkIsFlatValue\"]').change();", true);
// Set header actions
CurrentMaster.HeaderActions.AddAction(new SaveAction(this));
CurrentMaster.HeaderActions.ActionPerformed += HeaderActions_ActionPerformed;
CurrentMaster.DisplaySiteSelectorPanel = true;
}
protected void Page_Load(object sender, EventArgs e)
{
this.CurrentMaster.Title.TitleText = GetString("TaxClass_List.HeaderCaption");
this.CurrentMaster.Title.TitleImage = GetImageUrl("Objects/Ecommerce_TaxClass/object.png");
this.CurrentMaster.Title.HelpTopicName = "tax_classes_list";
this.CurrentMaster.Title.HelpName = "helpTopic";
// Prepare the new payment option header element
string[,] actions = new string[2, 9];
actions[0, 0] = "HyperLink";
actions[0, 1] = GetString("TaxClass_List.NewItemCaption");
actions[0, 3] = "~/CMSModules/Ecommerce/Pages/Tools/Configuration/TaxClasses/TaxClass_New.aspx?siteId=" + SiteID;
actions[0, 5] = GetImageUrl("Objects/Ecommerce_TaxClass/add.png");
// Show copy from global link when not configuring global tax classes
if (ConfiguredSiteID != 0)
{
// Show "Copy from global" link only if there is at least one global tax class
DataSet ds = TaxClassInfoProvider.GetTaxClasses("TaxClassSiteID IS NULL", null, 1, "TaxClassID");
if (!DataHelper.DataSourceIsEmpty(ds))
{
actions[1, 0] = HeaderActions.TYPE_SAVEBUTTON;
actions[1, 1] = GetString("general.copyfromglobal");
actions[1, 2] = "return ConfirmCopyFromGlobal();";
actions[1, 3] = null;
actions[1, 4] = null;
actions[1, 5] = GetImageUrl("Objects/Ecommerce_TaxClass/fromglobal.png");
actions[1, 6] = "copyFromGlobal";
actions[1, 7] = String.Empty;
actions[1, 8] = true.ToString();
// Register javascript to confirm action
string script = "function ConfirmCopyFromGlobal() {return confirm(" + ScriptHelper.GetString(GetString("com.ConfirmTaxClassFromGlobal")) + ");}";
ScriptHelper.RegisterClientScriptBlock(this, typeof(string), "ConfirmCopyFromGlobal", ScriptHelper.GetScript(script));
}
}
this.CurrentMaster.HeaderActions.Actions = actions;
this.CurrentMaster.HeaderActions.ActionPerformed += new CommandEventHandler(HeaderActions_ActionPerformed);
UniGrid.OnAction += new OnActionEventHandler(uniGrid_OnAction);
UniGrid.ZeroRowsText = GetString("general.nodatafound");
// Configuring global records
if (ConfiguredSiteID == 0)
{
// Select only global records
UniGrid.WhereCondition = "TaxClassSiteID IS NULL";
// Show "using global settings" info message only if showing global store settings
if (SiteID != 0)
{
lblGlobalInfo.Visible = true;
lblGlobalInfo.Text = GetString("com.UsingGlobalSettings");
}
}
else
{
// Select only site-specific records
UniGrid.WhereCondition = "TaxClassSiteID = " + ConfiguredSiteID;
}
}
/// <summary>
/// Copies site-specific tax classes from global list.
/// </summary>
protected void CopyFromGlobal()
{
CheckConfigurationModification();
TaxClassInfoProvider.CopyFromGlobal(ConfiguredSiteID);
}
protected void Page_Load(object sender, EventArgs e)
{
ScriptHelper.RegisterJQuery(this);
// Check permissions for CMS Desk -> Ecommerce
if (!CMSContext.CurrentUser.IsAuthorizedPerUIElement("CMS.Ecommerce", "Configuration.TaxClasses.States"))
{
RedirectToCMSDeskUIElementAccessDenied("CMS.Ecommerce", "Configuration.TaxClasses.States");
}
// Get tax class Id from URL
mTaxClassId = QueryHelper.GetInteger("taxclassid", 0);
mTaxClassObj = TaxClassInfoProvider.GetTaxClassInfo(mTaxClassId);
EditedObject = mTaxClassObj;
// Check if configured tax class belongs to configured site
if (mTaxClassObj != null)
{
// Check site id of tax class
CheckEditedObjectSiteID(mTaxClassObj.TaxClassSiteID);
currencyCode = CurrencyInfoProvider.GetMainCurrencyCode(mTaxClassObj.TaxClassSiteID);
// Check presence of main currency
string currencyErr = CheckMainCurrency(mTaxClassObj.TaxClassSiteID);
if (!string.IsNullOrEmpty(currencyErr))
{
// Show message
lblError.Text = currencyErr;
lblError.Visible = true;
}
}
if (!RequestHelper.IsPostBack())
{
// Fill the drpCountry with countries which have some states or colonies
drpCountry.DataSource = CountryInfoProvider.GetCountriesWithStates();
drpCountry.DataValueField = "CountryID";
drpCountry.DataTextField = "CountryDisplayName";
drpCountry.DataBind();
}
// Set grid view properties
gvStates.Columns[0].HeaderText = GetString("taxclass_state.gvstates.state");
gvStates.Columns[1].HeaderText = GetString("Code");
gvStates.Columns[2].HeaderText = GetString("taxclass_state.gvstates.value");
gvStates.Columns[3].HeaderText = GetString("taxclass_state.gvstates.isflat");
gvStates.Columns[4].HeaderText = GetString("StateId");
gvStates.GridLines = GridLines.Horizontal;
LoadGridViewData();
// Init scripts
string currencySwitchScript = string.Format(@"
function switchCurrency(isFlatValue, labelId){{
if(isFlatValue)
{{
jQuery('#'+labelId).html('({0})');
}}else{{
jQuery('#'+labelId).html('(%)');
}}
}}", ScriptHelper.GetString(currencyCode, false));
ScriptHelper.RegisterClientScriptBlock(this, typeof(string), "CurrencySwitch", currencySwitchScript, true);
ScriptHelper.RegisterStartupScript(this, typeof(string), "InitializeGrid", "jQuery('input[id*=\"chkIsFlatValue\"]').change();", true);
mSave = GetString("general.save");
// Set header actions
string[,] actions = new string[1, 10];
actions[0, 0] = HeaderActions.TYPE_SAVEBUTTON;
actions[0, 1] = this.GetString("Header.Settings.SaveChanged");
actions[0, 2] = String.Empty;
actions[0, 3] = String.Empty;
actions[0, 4] = String.Empty;
actions[0, 5] = this.GetImageUrl("CMSModules/CMS_Content/EditMenu/save.png");
actions[0, 6] = "save";
actions[0, 8] = true.ToString();
this.CurrentMaster.HeaderActions.Actions = actions;
this.CurrentMaster.HeaderActions.ActionPerformed += this.HeaderActions_ActionPerformed;
this.CurrentMaster.DisplaySiteSelectorPanel = true;
}
private object gridElem_OnExternalDataBound(object sender, string sourceName, object parameter)
{
DataRowView rowView = parameter as DataRowView;
if (rowView != null)
{
SKUInfo sku = new SKUInfo(rowView.Row);
switch (sourceName.ToLowerCSafe())
{
case "skuname":
string fullName = sku.SKUName;
// For variant, add name from parent SKU
if (sku.SKUParentSKUID != 0)
{
SKUInfo parentSku = SKUInfoProvider.GetSKUInfo(sku.SKUParentSKUID);
fullName = string.Format("{0}: {1}", parentSku.SKUName, sku.SKUName);
}
return(HTMLHelper.HTMLEncode(fullName));
case "optioncategory":
OptionCategoryInfo optionCategory = OptionCategoryInfoProvider.GetOptionCategoryInfo(sku.SKUOptionCategoryID);
// Return option category display name for product option or '-' for product
if (optionCategory != null)
{
return(HTMLHelper.HTMLEncode(optionCategory.CategoryDisplayName ?? ""));
}
return("-");
case "skunumber":
return(ResHelper.LocalizeString(sku.SKUNumber, null, true));
case "skuprice":
// Format price
return(CurrencyInfoProvider.GetFormattedPrice(sku.SKUPrice, sku.SKUSiteID));
case "skudepartmentid":
// Transform to display name and localize
DepartmentInfo department = DepartmentInfoProvider.GetDepartmentInfo(sku.SKUDepartmentID);
return((department != null) ? HTMLHelper.HTMLEncode(ResHelper.LocalizeString(department.DepartmentDisplayName)) : "");
case "skumanufacturerid":
// Transform to display name and localize
ManufacturerInfo manufacturer = ManufacturerInfoProvider.GetManufacturerInfo(sku.SKUManufacturerID);
return((manufacturer != null) ? HTMLHelper.HTMLEncode(ResHelper.LocalizeString(manufacturer.ManufacturerDisplayName)) : "");
case "skubrandid":
// Transform to display name and localize
BrandInfo brand = BrandInfoProvider.GetBrandInfo(sku.SKUBrandID);
return((brand != null) ? HTMLHelper.HTMLEncode(ResHelper.LocalizeString(brand.BrandDisplayName)) : "");
case "skucollectionid":
// Transform to display name and localize
CollectionInfo collection = CollectionInfoProvider.GetCollectionInfo(sku.SKUCollectionID);
return((collection != null) ? HTMLHelper.HTMLEncode(ResHelper.LocalizeString(collection.CollectionDisplayName)) : "");
case "skutaxclassid":
// Transform to display name and localize
TaxClassInfo taxClass = TaxClassInfoProvider.GetTaxClassInfo(sku.SKUTaxClassID);
return((taxClass != null) ? HTMLHelper.HTMLEncode(ResHelper.LocalizeString(taxClass.TaxClassDisplayName)) : "");
case "skusupplierid":
// Transform to display name and localize
SupplierInfo supplier = SupplierInfoProvider.GetSupplierInfo(sku.SKUSupplierID);
return((supplier != null) ? HTMLHelper.HTMLEncode(ResHelper.LocalizeString(supplier.SupplierDisplayName)) : "");
case "skupublicstatusid":
// Transform to display name and localize
PublicStatusInfo publicStatus = PublicStatusInfoProvider.GetPublicStatusInfo(sku.SKUPublicStatusID);
return((publicStatus != null) ? HTMLHelper.HTMLEncode(ResHelper.LocalizeString(publicStatus.PublicStatusDisplayName)) : "");
case "skuinternalstatusid":
// Transform to display name and localize
InternalStatusInfo internalStatus = InternalStatusInfoProvider.GetInternalStatusInfo(sku.SKUInternalStatusID);
return((internalStatus != null) ? HTMLHelper.HTMLEncode(ResHelper.LocalizeString(internalStatus.InternalStatusDisplayName)) : "");
case "skuavailableitems":
int?count = sku.SKUAvailableItems as int?;
int?reorderAt = sku.SKUReorderAt as int?;
// Emphasize the number when product needs to be reordered
if (count.HasValue && ((reorderAt.HasValue && (count <= reorderAt)) || (!reorderAt.HasValue && (count <= 0))))
{
// Format message informing about insufficient stock level
return(string.Format("<span class=\"OperationFailed\">{0}</span>", count));
}
return(count);
case "itemstobereordered":
int difference = sku.SKUReorderAt - sku.SKUAvailableItems;
// Return difference, or '-'
return((difference > 0) ? difference.ToString() : "-");
case "skusiteid":
return(UniGridFunctions.ColoredSpanYesNo(sku.SKUSiteID == 0));
}
}
return(parameter);
}
/// <summary>
/// Returns where condition based on webpart fields.
/// </summary>
private WhereCondition GetWhereCondition()
{
var where = new WhereCondition().WhereEquals("SKUSiteID", SiteContext.CurrentSiteID);
// Show products only from current site or global too, based on setting
if (ECommerceSettings.AllowGlobalProducts(SiteContext.CurrentSiteName))
{
where.Where(w => w.WhereEquals("SKUSiteID", SiteContext.CurrentSiteID).Or().WhereNull("SKUSiteID"));
}
// Show/hide product variants - it is based on type of inventory tracking for parent product
string trackByVariants = TrackInventoryTypeEnum.ByVariants.ToStringRepresentation();
where.Where(v => v.Where(w => w.WhereNull("SKUParentSKUID").And().WhereNotEquals("SKUTrackInventory", trackByVariants))
.Or()
.Where(GetParentProductWhereCondition(new WhereCondition().WhereEquals("SKUTrackInventory", trackByVariants))));
// Product type filter
if (!string.IsNullOrEmpty(ProductType) && (ProductType != FILTER_ALL))
{
if (ProductType == PRODUCT_TYPE_PRODUCTS)
{
where.WhereNull("SKUOptionCategoryID");
}
else if (ProductType == PRODUCT_TYPE_PRODUCT_OPTIONS)
{
where.WhereNotNull("SKUOptionCategoryID");
}
}
// Representing filter
if (!string.IsNullOrEmpty(Representing) && (Representing != FILTER_ALL))
{
SKUProductTypeEnum productTypeEnum = Representing.ToEnum <SKUProductTypeEnum>();
string productTypeString = productTypeEnum.ToStringRepresentation();
where.WhereEquals("SKUProductType", productTypeString);
}
// Product number filter
if (!string.IsNullOrEmpty(ProductNumber))
{
where.WhereContains("SKUNumber", ProductNumber);
}
// Department filter
DepartmentInfo di = DepartmentInfoProvider.GetDepartmentInfo(Department, CurrentSiteName);
di = di ?? DepartmentInfoProvider.GetDepartmentInfo(Department, null);
if (di != null)
{
where.Where(GetColumnWhereCondition("SKUDepartmentID", new WhereCondition().WhereEquals("SKUDepartmentID", di.DepartmentID)));
}
// Manufacturer filter
ManufacturerInfo mi = ManufacturerInfoProvider.GetManufacturerInfo(Manufacturer, CurrentSiteName);
mi = mi ?? ManufacturerInfoProvider.GetManufacturerInfo(Manufacturer, null);
if (mi != null)
{
where.Where(GetColumnWhereCondition("SKUManufacturerID", new WhereCondition().WhereEquals("SKUManufacturerID", mi.ManufacturerID)));
}
// Brand filter
BrandInfo bi = BrandInfoProvider.GetBrandInfo(Brand, CurrentSiteName);
if (bi != null)
{
where.Where(GetColumnWhereCondition("SKUBrandID", new WhereCondition().WhereEquals("SKUBrandID", bi.BrandID)));
}
// Collection filter
CollectionInfo ci = CollectionInfoProvider.GetCollectionInfo(Collection, CurrentSiteName);
if (ci != null)
{
where.Where(GetColumnWhereCondition("SKUCollectionID", new WhereCondition().WhereEquals("SKUCollectionID", ci.CollectionID)));
}
// Tax class filter
TaxClassInfo tci = TaxClassInfoProvider.GetTaxClassInfo(TaxClass, CurrentSiteName);
if (tci != null)
{
where.Where(GetColumnWhereCondition("SKUTaxClassID", new WhereCondition().WhereEquals("SKUTaxClassID", tci.TaxClassID)));
}
// Supplier filter
SupplierInfo si = SupplierInfoProvider.GetSupplierInfo(Supplier, CurrentSiteName);
si = si ?? SupplierInfoProvider.GetSupplierInfo(Supplier, null);
if (si != null)
{
where.Where(GetColumnWhereCondition("SKUSupplierID", new WhereCondition().WhereEquals("SKUSupplierID", si.SupplierID)));
}
// Needs shipping filter
if (!string.IsNullOrEmpty(NeedsShipping) && (NeedsShipping != FILTER_ALL))
{
if (NeedsShipping == NEEDS_SHIPPING_YES)
{
where.Where(GetColumnWhereCondition("SKUNeedsShipping", new WhereCondition().WhereTrue("SKUNeedsShipping")));
}
else if (NeedsShipping == NEEDS_SHIPPING_NO)
{
where.Where(GetColumnWhereCondition("SKUNeedsShipping", new WhereCondition().WhereFalse("SKUNeedsShipping").Or().WhereNull("SKUNeedsShipping")));
}
}
// Price from filter
if (PriceFrom > 0)
{
where.WhereGreaterOrEquals("SKUPrice", PriceFrom);
}
// Price to filter
if (PriceTo > 0)
{
where.WhereLessOrEquals("SKUPrice", PriceTo);
}
// Public status filter
PublicStatusInfo psi = PublicStatusInfoProvider.GetPublicStatusInfo(PublicStatus, CurrentSiteName);
if (psi != null)
{
where.Where(GetColumnWhereCondition("SKUPublicStatusID", new WhereCondition().WhereEquals("SKUPublicStatusID", psi.PublicStatusID)));
}
// Internal status filter
InternalStatusInfo isi = InternalStatusInfoProvider.GetInternalStatusInfo(InternalStatus, CurrentSiteName);
if (isi != null)
{
where.Where(GetColumnWhereCondition("SKUInternalStatusID", new WhereCondition().WhereEquals("SKUInternalStatusID", isi.InternalStatusID)));
}
// Allow for sale filter
if (!string.IsNullOrEmpty(AllowForSale) && (AllowForSale != FILTER_ALL))
{
if (AllowForSale == ALLOW_FOR_SALE_YES)
{
where.WhereTrue("SKUEnabled");
}
else if (AllowForSale == ALLOW_FOR_SALE_NO)
{
where.WhereEqualsOrNull("SKUEnabled", false);
}
}
// Available items filter
if (!string.IsNullOrEmpty(AvailableItems))
{
int value = ValidationHelper.GetInteger(AvailableItems, int.MaxValue);
where.WhereLessOrEquals("SKUAvailableItems", value);
}
// Needs to be reordered filter
if (NeedsToBeReordered)
{
where.Where(w => w.Where(v => v.WhereNull("SKUReorderAt").And().WhereLessOrEquals("SKUAvailableItems", 0))
.Or()
.Where(z => z.WhereNotNull("SKUReorderAt").And().WhereLessOrEquals("SKUAvailableItems".AsColumn(), "SKUReorderAt".AsColumn())));
}
return(where);
}
protected void Page_Load(object sender, EventArgs e)
{
ScriptHelper.RegisterJQuery(this);
// Check permissions for CMS Desk -> Ecommerce
if (!CMSContext.CurrentUser.IsAuthorizedPerUIElement("CMS.Ecommerce", "Configuration.TaxClasses.Countries"))
{
RedirectToCMSDeskUIElementAccessDenied("CMS.Ecommerce", "Configuration.TaxClasses.Countries");
}
mTaxClassId = QueryHelper.GetInteger("taxclassid", 0);
mTaxClassObj = TaxClassInfoProvider.GetTaxClassInfo(mTaxClassId);
EditedObject = mTaxClassObj;
// Check if configured tax class belongs to configured site
if (mTaxClassObj != null)
{
CheckEditedObjectSiteID(mTaxClassObj.TaxClassSiteID);
currencyCode = CurrencyInfoProvider.GetMainCurrencyCode(mTaxClassObj.TaxClassSiteID);
// Check presence of main currency
string currencyErr = CheckMainCurrency(mTaxClassObj.TaxClassSiteID);
if (!string.IsNullOrEmpty(currencyErr))
{
// Show message
lblError.Text = currencyErr;
lblError.Visible = true;
}
}
GridViewCountries.Columns[0].HeaderText = GetString("TaxClass_Country.Country");
GridViewCountries.Columns[1].HeaderText = GetString("TaxClass_Country.Value");
GridViewCountries.Columns[2].HeaderText = GetString("TaxClass_Country.IsFlat");
DataSet ds = TaxClassCountryInfoProvider.GetCountriesAndTaxValues(mTaxClassId);
GridViewCountries.Columns[3].Visible = true;
GridViewCountries.DataSource = ds.Tables[0];
GridViewCountries.DataBind();
// After id is copied, the 4th column it's not needed anymore
GridViewCountries.Columns[3].Visible = false;
GridViewCountries.GridLines = GridLines.Horizontal;
// Init scripts
string currencySwitchScript = string.Format(@"
function switchCurrency(isFlatValue, labelId){{
if(isFlatValue)
{{
jQuery('#'+labelId).html('({0})');
}}else{{
jQuery('#'+labelId).html('(%)');
}}
}}", ScriptHelper.GetString(currencyCode, false));
ScriptHelper.RegisterClientScriptBlock(this, typeof(string), "CurrencySwitch", currencySwitchScript, true);
ScriptHelper.RegisterStartupScript(this, typeof(string), "InitializeGrid", "jQuery('input[id*=\"chkIsFlatValue\"]').change();", true);
mSave = GetString("general.save");
// Set header actions
string[,] actions = new string[1, 10];
actions[0, 0] = HeaderActions.TYPE_SAVEBUTTON;
actions[0, 1] = this.GetString("Header.Settings.SaveChanged");
actions[0, 2] = String.Empty;
actions[0, 3] = String.Empty;
actions[0, 4] = String.Empty;
actions[0, 5] = this.GetImageUrl("CMSModules/CMS_Content/EditMenu/save.png");
actions[0, 6] = "save";
actions[0, 8] = true.ToString();
this.CurrentMaster.HeaderActions.Actions = actions;
this.CurrentMaster.HeaderActions.ActionPerformed += this.HeaderActions_ActionPerformed;
}
