private string SelectCategory(int catId, string moduleName, string message)
{
if (ExportFeedService.CheakCategoryHierical(moduleName, catId) || ExportFeedService.CheakCategory(moduleName, catId))
{
return("<span style='color: blue;font-weight:bold;'>" + message + "</span");
}
return(message);
}
protected void btnChange_OnClick(object sender, EventArgs e)
{
if (chbFull.Checked)
{
ExportFeedService.InsertCategory(ModuleName, _catId);
}
else
{
ExportFeedService.DeleteCategory(ModuleName, _catId);
}
Response.Redirect("ExportFeed.aspx?moduleid=" + ModuleName + "&CatId=" + _catId);
}
protected void lbSetNotActive_Click(object sender, EventArgs e)
{
if ((_selectionFilter != null) && (_selectionFilter.Values != null))
{
if (!_inverseSelection)
{
foreach (var id in _selectionFilter.Values)
{
ExportFeedService.DeleteProduct(ModuleName, Convert.ToInt32(id));
}
}
else
{
var itemsIds = _paging.ItemsIds <int>("Product.ProductId as ID");
foreach (var id in itemsIds.Where(id => !_selectionFilter.Values.Contains(id.ToString(CultureInfo.InvariantCulture))))
{
ExportFeedService.DeleteProduct(ModuleName, Convert.ToInt32(id));
}
}
}
}
protected void btnResetExport_OnClick(object sender, EventArgs e)
{
ExportFeedService.DeleteModule(ModuleName);
Response.Redirect("ExportFeed.aspx?moduleid=" + ModuleName + "&CatId=" + _catId);
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = string.Format("{0} - {1}", AdvantShop.Configuration.SettingsMain.ShopName, Resource.Admin_MasterPageAdminCatalog_Catalog);
if (string.IsNullOrEmpty(ModuleName))
{
Response.Redirect("ExportFeed.aspx?ModuleId=YandexMarket");
return;
}
if (!string.IsNullOrEmpty(Request["CatId"]))
{
Int32.TryParse(Request["CatId"], out _catId);
}
Category cat = CategoryService.GetCategory(_catId);
if (cat != null)
{
lblCategoryName.Text = cat.Name;
sn.BuildNavigationAdmin(_catId);
}
if (!Page.IsPostBack)
{
var flag = ExportFeedService.CheakCategoryHierical(ModuleName, _catId);
pnlCategorySet.Enabled = !flag;
chbFull.Checked = ExportFeedService.CheakCategory(ModuleName, _catId);
pnlData.Enabled = !chbFull.Checked && !flag;
}
PageSubheader.Visible = true;
ModuleNameLiteral.Text = ModuleName;
if (!IsPostBack)
{
var node2 = new TreeNode {
Text = SelectCategory(0, ModuleName, Resource.Admin_m_Category_Root), Value = "0", Selected = true, NavigateUrl = ExportFeedNew + "?moduleid=" + ModuleName
};
tree2.Nodes.Add(node2);
LoadChildCategories2(tree2.Nodes[0]);
_paging = new SqlPaging
{
TableName = "[Catalog].[Product] left JOIN [Catalog].[Offer] ON [Product].[ProductID] = [Offer].[ProductID] AND [OfferListId]=6 INNER JOIN Catalog.ProductCategories on ProductCategories.ProductId = [Product].[ProductID] and Main=1",
ItemsPerPage = 100
};
var f = new Field {
Name = "Product.ProductId as ID", IsDistinct = true
};
_paging.AddField(f);
f = new Field {
Name = "ArtNo"
};
_paging.AddField(f);
f = new Field {
Name = "Name"
};
_paging.AddField(f);
f = new Field {
Name = "(Select count(*) from Settings.ExportFeedSelectedProducts where ModuleName=@ModuleName and ExportFeedSelectedProducts.ProductID=Product.ProductId) as Cheaked"
};
_paging.AddField(f);
var pf = new EqualFieldFilter {
Value = _catId.ToString(), ParamName = "@Parent"
};
f = new Field {
Name = "CategoryId", Filter = pf
};
_paging.AddField(f);
f = new Field {
Name = "SortOrder", Sorting = SortDirection.Ascending
};
_paging.AddField(f);
_paging.AddParam(new SqlParam {
ParamName = "@ModuleName", ParamValue = ModuleName
});
_paging.ExtensionWhere = "and Offer.Price > 0 and (Offer.Amount > 0 or Product.OrderByRequest=1) and HirecalEnabled=1 and Enabled=1";
grid.ChangeHeaderImageUrl("arrowName", "images/arrowup.gif");
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = Convert.ToInt32(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
var ids = new string[arrids.Length];
_selectionFilter = new InSetFieldFilter {
IncludeValues = true
};
for (int idx = 0; idx <= ids.Length - 1; idx++)
{
int t = int.Parse(arrids[idx]);
if (t != -1)
{
ids[idx] = t.ToString();
}
else
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
}
_selectionFilter.Values = ids;
}
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
var parentCategories = CategoryService.GetParentCategories(_catId);
parentCategories.Add(new Category {
CategoryId = 0
});
var nodes = tree2.Nodes;
for (var i = parentCategories.Count - 1; i >= 0; i--)
{
var ii = i;
var tn = (from TreeNode n in nodes where n.Value == parentCategories[ii].CategoryId.ToString() select n).SingleOrDefault();
if (tn == null)
{
continue;
}
if (i == 0)
{
tn.Select();
tn.Expand();
}
else
{
tn.Expand();
}
nodes = tn.ChildNodes;
}
if (grid.UpdatedRow != null)
{
var flag = Convert.ToBoolean(grid.UpdatedRow["Cheaked"]);
if (flag)
{
ExportFeedService.InsertProduct(ModuleName, Convert.ToInt32(grid.UpdatedRow["ID"]));
}
else
{
ExportFeedService.DeleteProduct(ModuleName, Convert.ToInt32(grid.UpdatedRow["ID"]));
}
}
DataTable data = _paging.PageItems;
while (data.Rows.Count < 1 && _paging.CurrentPageIndex > 1)
{
_paging.CurrentPageIndex--;
data = _paging.PageItems;
}
var clmn = new DataColumn("IsSelected", typeof(bool))
{
DefaultValue = _inverseSelection
};
data.Columns.Add(clmn);
if ((_selectionFilter != null) && (_selectionFilter.Values != null))
{
for (int i = 0; i <= data.Rows.Count - 1; i++)
{
int intIndex = i;
if (Array.Exists(_selectionFilter.Values, c => c == data.Rows[intIndex]["ID"].ToString()))
{
data.Rows[i]["IsSelected"] = !_inverseSelection;
}
}
}
if (data.Rows.Count < 1)
{
goToPage.Visible = false;
}
grid.DataSource = data;
grid.DataBind();
pageNumberer.PageCount = _paging.PageCount;
lblFound.Text = _paging.TotalRowsCount.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (SaasDataService.IsSaasEnabled && !SaasDataService.CurrentSaasData.HaveExcel)
{
mainDiv.Visible = false;
notInTariff.Visible = true;
}
lblCategoriesCount.Text = ExportFeedService.CheckCategory("CsvExport", 0)
? Resource.Admin_ExportCsv_AllCategories
: ExportFeedService.GetCsvCategoriesCount("CsvExport") + " " + Resource.Admin_ExportCsv_Categories;
//hrefAgaint.Visible = false;
SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_ExportExcel_Title));
if (!IsPostBack)
{
ChbCategorySort.Checked = Request[CategorySort].TryParseBool();
ddlEncoding.Items.Clear();
foreach (var enumItem in (EncodingsEnum[])Enum.GetValues(typeof(EncodingsEnum)))
{
ddlEncoding.Items.Add(new ListItem(enumItem.ToString(), enumItem.StrName()));
}
ddlEncoding.SelectedValue = CsvSettings.CsvEnconing;
ddlSeparetors.Items.Clear();
foreach (var enumItem in (SeparatorsEnum[])Enum.GetValues(typeof(SeparatorsEnum)))
{
ddlSeparetors.Items.Add(new ListItem(enumItem.ResourceKey(), enumItem.StrName()));
}
foreach (var enumItem in (SeparatorsEnum[])Enum.GetValues(typeof(SeparatorsEnum)))
{
if (CsvSettings.CsvSeparator == enumItem.StrName())
{
ddlSeparetors.SelectedValue = enumItem.StrName();
}
if (CsvSettings.CsvSeparator == SeparatorsEnum.Custom.StrName())
{
txtCustomSeparator.Text = CsvSettings.CsvSeparator;
}
}
txtColumSeparator.Text = CsvSettings.CsvColumSeparator;
txtPropertySeparator.Text = CsvSettings.CsvPropertySeparator;
chbCsvExportNoInCategory.Checked = CsvSettings.CsvExportNoInCategory;
}
if (choseDiv.FindControl("tblValues") != null && IsPostBack)
{
var cells = ((TableRow)choseDiv.FindControl("ddlRow")).Cells;
foreach (TableCell item in cells)
{
var element = item.Controls.OfType <DropDownList>().FirstOrDefault();
if (element == null)
{
continue;
}
if (item.Controls.OfType <DropDownList>().First().SelectedValue == ProductFields.None.ConvertIntString())
{
continue;
}
if (!FieldMapping.Contains((ProductFields)SQLDataHelper.GetInt(item.Controls.OfType <DropDownList>().First().SelectedValue)))
{
FieldMapping.Add((ProductFields)SQLDataHelper.GetInt((item.Controls.OfType <DropDownList>().First().SelectedValue)));//, cells.GetCellIndex(item));
}
else
{
MsgErr(string.Format(Resource.Admin_ImportCsv_DuplicateMessage, item.Controls.OfType <DropDownList>().First().SelectedItem.Text));
return;
}
}
if (ChbCategorySort.Checked)
{
var ind = FieldMapping.IndexOf(ProductFields.Category);
if (ind > 0)
{
FieldMapping.Insert(ind + 1, ProductFields.Sorting);
}
else
{
FieldMapping.Add(ProductFields.Sorting);
}
}
}
if (FieldMapping.Count == 0 && IsPostBack)
{
MsgErr(Resource.Admin_ExportCsv_ListEmpty);
return;
}
MsgErr(true);
OutDiv.Visible = CommonStatistic.IsRun;
linkCancel.Visible = CommonStatistic.IsRun;
}
