private void DoImport(NBrightInfo nbi)
{
var fname = StoreSettings.Current.FolderTempMapPath + "\\" + nbi.GetXmlProperty("genxml/hidden/hiddatafile");
if (System.IO.File.Exists(fname))
{
var xmlFile = new XmlDocument();
try
{
xmlFile.Load(fname);
}
catch (Exception e)
{
Exceptions.LogException(e);
NBrightBuyUtils.SetNotfiyMessage(ModuleId, "xmlloadfail", NotifyCode.fail, ControlPath + "/App_LocalResources/Import.ascx.resx");
return;
}
// Ref old cat id , id new cat
////////////////////////////////////////////////////////////////////////////
Dictionary <string, int> categoryListIDGiud = new Dictionary <string, int>();
Dictionary <int, int> categoryListIDFather = new Dictionary <int, int>();
///////////////////////////////////////////////////////////////////////////
var objCtrl = new NBrightBuyController();
// get all valid languages
var langList = DnnUtils.GetCultureCodeList(PortalId);
foreach (var lang in langList)
{
//Import Categories
#region "categories"
var nodList = xmlFile.SelectNodes("root/categories/" + lang + "/NB_Store_CategoriesInfo");
if (nodList != null)
{
var categoryid = -1;
foreach (XmlNode nod in nodList)
{
try
{
//if category Id exist replage guidKey
var guidKeyNod = nod.SelectSingleNode("CategoryID").InnerText;
if (guidKeyNod != null)
{
var guidKey = guidKeyNod;
categoryid = -1;
// see if category already exists (update if so)
var nbiImport = objCtrl.GetByGuidKey(PortalSettings.Current.PortalId, -1, "CATEGORY", guidKey);
if (nbiImport != null)
{
categoryid = nbiImport.ItemID;
}
var CategoryData = new CategoryData(categoryid, lang);
// clear down existing XML data
var i = new NBrightInfo(true);
i.PortalId = PortalSettings.Current.PortalId;
CategoryData.DataRecord.XMLData = i.XMLData;
CategoryData.DataLangRecord.XMLData = i.XMLData;
// assign guidkey to legacy productid (guidKey)
CategoryData.DataRecord.GUIDKey = guidKey;
CategoryData.DataRecord.SetXmlProperty("genxml/textbox/txtcategoryref", guidKey);
// do mapping of XML data
// DATA FIELDS
var cD_CategoryID = nod.SelectSingleNode("CategoryID").InnerText;
var cD_PortalID = nod.SelectSingleNode("PortalID").InnerText;
var cD_Archived = nod.SelectSingleNode("Archived").InnerText;
var cD_Hide = nod.SelectSingleNode("Hide").InnerText;
var cD_CreatedByUser = nod.SelectSingleNode("CreatedByUser").InnerText;
var cD_CreatedDate = nod.SelectSingleNode("CreatedDate").InnerText;
var cD_ParentCategoryID = nod.SelectSingleNode("ParentCategoryID").InnerText;
var cD_ListOrder = nod.SelectSingleNode("ListOrder").InnerText;
var cD_Lang = nod.SelectSingleNode("Lang").InnerText;
var cD_ProductCount = nod.SelectSingleNode("ProductCount").InnerText;
var cD_ProductTemplate = nod.SelectSingleNode("ProductTemplate").InnerText;
var cD_ListItemTemplate = nod.SelectSingleNode("ListItemTemplate").InnerText;
var cD_ListAltItemTemplate = nod.SelectSingleNode("ListAltItemTemplate").InnerText;
var cD_ImageURL = nod.SelectSingleNode("ImageURL").InnerText;
// DATA LANG FIELDS
var cL_CategoryName = nod.SelectSingleNode("CategoryName").InnerText;
var cL_ParentName = nod.SelectSingleNode("ParentName").InnerText;
var cL_CategoryDesc = nod.SelectSingleNode("CategoryDesc").InnerText;
var cL_Message = nod.SelectSingleNode("Message").InnerText;
var cL_SEOPageTitle = nod.SelectSingleNode("SEOPageTitle").InnerText;
var cL_SEOName = nod.SelectSingleNode("SEOName").InnerText;
var cL_MetaDescription = nod.SelectSingleNode("MetaDescription").InnerText;
var cL_MetaKeywords = nod.SelectSingleNode("MetaKeywords").InnerText;
// Populate DATA CATEGORY
CategoryData.DataRecord.SetXmlProperty("genxml/hidden/recordsortorder", cD_ListOrder);
CategoryData.DataRecord.SetXmlProperty("genxml/checkbox/chkishidden", cD_Hide);
CategoryData.DataRecord.SetXmlProperty("genxml/checkbox/chkdisable", "False");
CategoryData.DataRecord.SetXmlProperty("genxml/dropdownlist/ddlgrouptype", "cat");
if (cD_ParentCategoryID != null && cD_ParentCategoryID != "0")
{
CategoryData.DataRecord.SetXmlProperty("genxml/dropdownlist/ddlparentcatid", cD_ParentCategoryID);
}
// Populate DATA CATEGORY LANG
if (cL_CategoryName != null && cL_CategoryName != "")
{
CategoryData.DataLangRecord.SetXmlProperty("genxml/textbox/txtcategoryname", cL_CategoryName);
}
if (cL_CategoryDesc != null && cL_CategoryDesc != "")
{
CategoryData.DataLangRecord.SetXmlProperty("genxml/textbox/txtcategorydesc", cL_CategoryDesc);
}
if (cL_MetaDescription != null && cL_MetaDescription != "")
{
CategoryData.DataLangRecord.SetXmlProperty("genxml/textbox/txtmetadescription", cL_MetaDescription);
}
if (cL_MetaKeywords != null && cL_MetaKeywords != "")
{
CategoryData.DataLangRecord.SetXmlProperty("genxml/textbox/txtmetakeywords", cL_MetaKeywords);
}
if (cL_SEOPageTitle != null && cL_SEOPageTitle != "")
{
CategoryData.DataLangRecord.SetXmlProperty("genxml/textbox/txtseopagetitle", cL_SEOPageTitle);
}
if (cL_SEOName != null && cL_SEOName != "")
{
CategoryData.DataLangRecord.SetXmlProperty("genxml/textbox/txtseoname", cL_SEOName);
}
if (cL_Message != null && cL_Message != "")
{
CategoryData.DataLangRecord.SetXmlProperty("genxml/edt/message", cL_Message);
}
categoryListIDGiud.Add(CategoryData.CategoryRef, CategoryData.CategoryId);
if (cD_ParentCategoryID != null && cD_ParentCategoryID != "" && cD_ParentCategoryID != "0")
{
categoryListIDFather.Add(CategoryData.CategoryId, Convert.ToInt32(cD_ParentCategoryID));
}
CategoryData.Save();
}
}
catch (Exception e)
{
var logMessage = "CATEGORY: CategoryId: " + categoryid.ToString() + " : " + e.ToString();
LogOutput.LogWrite(logMessage);
}
}
//loop on The dictionary
foreach (var catl in categoryListIDFather)
{
//Key
var tempNewID = catl.Key;
//Value
var tempOldFather = catl.Value;
var tempNewFather = categoryListIDGiud[tempOldFather.ToString()];
var CategoryData = new CategoryData(tempNewID, lang);
CategoryData.ParentItemId = tempNewFather;
CategoryData.DataRecord.SetXmlProperty("genxml/dropdownlist/ddlparentcatid", tempNewFather.ToString());
CategoryData.Save();
}
}
#endregion
// Import Products
#region "data"
nodList = xmlFile.SelectNodes("root/products/" + lang + "/P");
if (nodList != null)
{
var productid = -1;
var prodname = "";
foreach (XmlNode nod in nodList)
{
try
{
var guidKeyNod = nod.SelectSingleNode("NB_Store_ProductsInfo/ProductID");
if (guidKeyNod != null)
{
var guidKey = guidKeyNod.InnerText;
productid = -1;
// See if e already have a product imported, if so we want to update (maybe multiple languages, or a 2nd migrate)
var nbiImport = objCtrl.GetByGuidKey(PortalSettings.Current.PortalId, -1, "PRD", guidKey);
if (nbiImport != null)
{
productid = nbiImport.ItemID;
}
var productData = new ProductData(productid, lang);
productid = productData.Info.ItemID; // set productid, so we have the id if it goes wrong.
prodname = productData.ProductName;
// clear down existing XML data
var i = new NBrightInfo(true);
productData.DataRecord.XMLData = i.XMLData;
productData.DataLangRecord.XMLData = i.XMLData;
// assign guidkey to legacy productid (guidKey)
productData.DataRecord.GUIDKey = guidKey;
productData.DataRecord.SetXmlProperty("genxml/importref", guidKey);
// do mapping of XML data
// DATA FIELDS
var pD_ProductID = nod.SelectSingleNode("NB_Store_ProductsInfo/ProductID").InnerText;
var pD_PortalID = nod.SelectSingleNode("NB_Store_ProductsInfo/PortalID").InnerText;
var pD_TaxCategoryID = nod.SelectSingleNode("NB_Store_ProductsInfo/TaxCategoryID").InnerText;
var pD_Featured = nod.SelectSingleNode("NB_Store_ProductsInfo/Featured").InnerText;
var pD_Archived = nod.SelectSingleNode("NB_Store_ProductsInfo/Archived").InnerText;
var pD_CreatedByUser = nod.SelectSingleNode("NB_Store_ProductsInfo/CreatedByUser").InnerText;
var pD_CreatedDate = nod.SelectSingleNode("NB_Store_ProductsInfo/CreatedDate").InnerText;
var pD_IsDeleted = nod.SelectSingleNode("NB_Store_ProductsInfo/IsDeleted").InnerText;
var pD_ProductRef = nod.SelectSingleNode("NB_Store_ProductsInfo/ProductRef").InnerText;
var pD_Lang = nod.SelectSingleNode("NB_Store_ProductsInfo/Lang").InnerText;
var pD_Manufacturer = nod.SelectSingleNode("NB_Store_ProductsInfo/Manufacturer").InnerText;
var pD_ModifiedDate = nod.SelectSingleNode("NB_Store_ProductsInfo/ModifiedDate").InnerText;
var pD_IsHidden = nod.SelectSingleNode("NB_Store_ProductsInfo/IsHidden").InnerText;
// DATA LANG FIELDS
var pL_ProductName = nod.SelectSingleNode("NB_Store_ProductsInfo/ProductName").InnerText;
var pL_Summary = nod.SelectSingleNode("NB_Store_ProductsInfo/Summary").InnerText;
var pL_Description = nod.SelectSingleNode("NB_Store_ProductsInfo/Description").InnerText;
var pL_SEOName = nod.SelectSingleNode("NB_Store_ProductsInfo/SEOName").InnerText;
var pL_TagWords = nod.SelectSingleNode("NB_Store_ProductsInfo/TagWords").InnerText;
var pL_Desc = nod.SelectSingleNode("NB_Store_ProductsInfo/Description").InnerText;
if (pD_ProductRef != null)
{
productData.DataRecord.SetXmlProperty("genxml/textbox/txtproductref", pD_ProductRef);
}
if (pD_Manufacturer != null)
{
productData.DataRecord.SetXmlProperty("genxml/textbox/customorder", pD_Manufacturer);
}
// langauge main fields
if (pL_ProductName != null)
{
productData.DataLangRecord.SetXmlProperty("genxml/textbox/txtproductname", pL_ProductName);
}
if (pL_Summary != null)
{
productData.DataLangRecord.SetXmlProperty("genxml/textbox/txtsummary", pL_Summary);
}
if (pL_SEOName != null)
{
productData.DataLangRecord.SetXmlProperty("genxml/textbox/txtseoname", pL_SEOName);
}
if (pL_SEOName != null)
{
productData.DataLangRecord.SetXmlProperty("genxml/textbox/txtseopagetitle", pL_SEOName);
}
if (pL_TagWords != null)
{
productData.DataLangRecord.SetXmlProperty("genxml/textbox/txttagwords", pL_TagWords);
}
//edt
if (pL_Desc != null)
{
productData.DataLangRecord.SetXmlProperty("genxml/edt", "");
productData.DataLangRecord.SetXmlProperty("genxml/edt/description", pL_Desc);
}
////////////////////////////// CUSTOM FIELDS /////////////////////////////////////
////////////////////////////// CUSTOM FIELDS /////////////////////////////////////
////////////////////////////// CUSTOM FIELDS /////////////////////////////////////
#region "Custom Fields"
// Custom Fields the Custom fields in Nbstore are stored in XmlData xml file area.
if (nod.SelectSingleNode("NB_Store_ProductsInfo/XMLData").FirstChild != null) // verify if there are custom fileds
{
var InputCustomFieldsXml = new XmlDocument();
InputCustomFieldsXml.Load(new StringReader(nod.SelectSingleNode("NB_Store_ProductsInfo/XMLData").InnerText));
var nodListCustom = InputCustomFieldsXml.SelectSingleNode("genxml");
var custominfo = new NBrightInfo();
custominfo.XMLData = nodListCustom.OuterXml;
// ***************************
// process custom fields here.
// ***************************
}
#endregion
////////////////////////////// END CUSTOM FIELDS /////////////////////////////////////
////////////////////////////// END CUSTOM FIELDS /////////////////////////////////////
////////////////////////////// END CUSTOM FIELDS /////////////////////////////////////
// Models
var nodListModels = nod.SelectNodes("M/NB_Store_ModelInfo");
foreach (XmlNode nodMod in nodListModels)
{
//load single node module strucuture
var ModelID = nodMod.SelectSingleNode("ModelID").InnerText;
var ProductID = nodMod.SelectSingleNode("ProductID").InnerText;
var ListOrder = nodMod.SelectSingleNode("ListOrder").InnerText;
var UnitCost = nodMod.SelectSingleNode("UnitCost").InnerText;
var Barcode = nodMod.SelectSingleNode("Barcode").InnerText;
var ModelRef = nodMod.SelectSingleNode("ModelRef").InnerText;
var Lang = nodMod.SelectSingleNode("Lang").InnerText;
var ModelName = nodMod.SelectSingleNode("ModelName").InnerText;
var QtyRemaining = nodMod.SelectSingleNode("QtyRemaining").InnerText;
var QtyTrans = nodMod.SelectSingleNode("QtyTrans").InnerText;
var QtyTransDate = nodMod.SelectSingleNode("QtyTransDate").InnerText;
var ProductName = nodMod.SelectSingleNode("ProductName").InnerText;
var PortalID = nodMod.SelectSingleNode("PortalID").InnerText;
var Weight = nodMod.SelectSingleNode("Weight").InnerText;
var Height = nodMod.SelectSingleNode("Height").InnerText;
var Length = nodMod.SelectSingleNode("Length").InnerText;
var Width = nodMod.SelectSingleNode("Width").InnerText;
var Deleted = nodMod.SelectSingleNode("Deleted").InnerText;
var QtyStockSet = nodMod.SelectSingleNode("QtyStockSet").InnerText;
var DealerCost = nodMod.SelectSingleNode("DealerCost").InnerText;
var PurchaseCost = nodMod.SelectSingleNode("PurchaseCost").InnerText;
var XMLData = nodMod.SelectSingleNode("XMLData").InnerText;
var Extra = nodMod.SelectSingleNode("Extra").InnerText;
var DealerOnly = nodMod.SelectSingleNode("DealerOnly").InnerText;
var Allow = nodMod.SelectSingleNode("Allow").InnerText;
////////////////////////////// FINE CUSTOM FIELDS /////////////////////////////////////
////////////////////////////// FINE CUSTOM FIELDS /////////////////////////////////////
////////////////////////////// FINE CUSTOM FIELDS /////////////////////////////////////
//il dentro al tag model cè un genxml che identifica il modello
// MODELLI CAMPI DATA
////////////////////////////// MODELS /////////////////////////////////////
////////////////////////////// MODELS /////////////////////////////////////
////////////////////////////// MODELS /////////////////////////////////////
var newkey = Utils.GetUniqueKey();
var strXmlModel = @"<genxml><models><genxml>
<files />
<hidden><modelid>" + newkey + "</modelid>" +
@"</hidden>
<textbox>
<availabledate datatype=""date"" />
<txtqtyminstock>0</txtqtyminstock>
<txtmodelref>" + ModelRef + @"</txtmodelref>
<txtunitcost>" + UnitCost + @"</txtunitcost>
<txtsaleprice>0.00</txtsaleprice>
<txtbarcode>" + Barcode + @"</txtbarcode>
<txtqtyremaining>" + QtyRemaining + @"</txtqtyremaining>
<txtqtystockset>" + QtyStockSet + @"</txtqtystockset>
<txtdealercost>" + DealerCost + @"</txtdealercost>
<txtpurchasecost>" + PurchaseCost + @"</txtpurchasecost>
<weight>" + Weight + @"</weight>
<depth>" + Length + @"</depth>
<width>" + Width + @"</width>
<height>" + Height + @"</height>
<unit />
<delay />
</textbox>
<checkbox>
<chkstockon>False</chkstockon>
<chkishidden>False</chkishidden>
<chkdeleted>False</chkdeleted>
<chkdealeronly>False</chkdealeronly>
</checkbox>
<dropdownlist>
<modelstatus>010</modelstatus>
</dropdownlist>
<checkboxlist />
<radiobuttonlist />
</genxml></models></genxml>";
var strXmlModelLang = @"<genxml><models><genxml>
<files />
<hidden />
<textbox>
<txtmodelname>" + ModelName + "</txtmodelname>" +
"<txtextra>" + Extra + @"</txtextra>
</textbox>
<checkbox /><dropdownlist /><checkboxlist /><radiobuttonlist />
</genxml></models></genxml>";
if (productData.DataRecord.XMLDoc.SelectSingleNode("genxml/models") == null)
{
productData.DataRecord.AddXmlNode(strXmlModel, "genxml/models", "genxml");
productData.DataLangRecord.AddXmlNode(strXmlModelLang, "genxml/models", "genxml");
}
else
{
productData.DataRecord.AddXmlNode(strXmlModel, "genxml/models/genxml", "genxml/models");
productData.DataLangRecord.AddXmlNode(strXmlModelLang, "genxml/models/genxml", "genxml/models");
}
}
////////////////////////////// IMAGES /////////////////////////////////////
////////////////////////////// IMAGES /////////////////////////////////////
////////////////////////////// IMAGES /////////////////////////////////////
////////////////////////////// IMAGES /////////////////////////////////////
// copy all the images from Portals\0\productimages to Portals\0\NBStore\images
var nodListImages = nod.SelectNodes("I/NB_Store_ProductImageInfo");
foreach (XmlNode nodImg in nodListImages)
{
var ImageID = nodImg.SelectSingleNode("ImageID").InnerText;
var Hidden = nodImg.SelectSingleNode("Hidden").InnerText;
var ImageUrl = nodImg.SelectSingleNode("ImageURL").InnerText;
var ImagePath = nodImg.SelectSingleNode("ImagePath").InnerText;
productData.AddNewImage(ImageUrl, ImagePath);
}
////////////////////////////// DOCS /////////////////////////////////////
////////////////////////////// DOCS /////////////////////////////////////
////////////////////////////// DOCS /////////////////////////////////////
////////////////////////////// DOCS /////////////////////////////////////
// copy all the DOCS from Portals\0\productdocs to Portals\0\NBStore\docs
var nodListDocs = nod.SelectNodes("D/NB_Store_ProductDocInfo");
var lp = 1;
var objCtrlDoc = new NBrightBuyController();
foreach (XmlNode nodDoc in nodListDocs)
{
var DocID = nodDoc.SelectSingleNode("DocID").InnerText;
var ProductID = nodDoc.SelectSingleNode("ProductID").InnerText;
var DocPath = nodDoc.SelectSingleNode("DocPath").InnerText;
var ListOrder = nodDoc.SelectSingleNode("ListOrder").InnerText;
var Hidden = nodDoc.SelectSingleNode("Hidden").InnerText;
var FileName = nodDoc.SelectSingleNode("FileName").InnerText;
var FileExt = nodDoc.SelectSingleNode("FileExt").InnerText;
var Lang = nodDoc.SelectSingleNode("Lang").InnerText;
var DocDesc = nodDoc.SelectSingleNode("DocDesc").InnerText;
productData.AddNewDoc(DocPath, FileName);
productData.DataRecord.SetXmlProperty("genxml/docs/genxml[" + lp.ToString() + "]/hidden/fileext", FileExt);
DocPath = DocPath.Replace("productdocs", @"NBStore\docs");
productData.DataRecord.SetXmlProperty("genxml/docs/genxml[" + lp.ToString() + "]/hidden/filepath", DocPath);
objCtrlDoc.Update(productData.DataRecord);
// if doesen't exisit the xml genxml strucuture inside the DataLangRecor I create it
var strXml = "<genxml><docs><genxml><textbox/></genxml></docs></genxml>";
if (productData.DataLangRecord.XMLDoc.SelectSingleNode("genxml/docs") == null)
{
productData.DataLangRecord.AddXmlNode(strXml, "genxml/docs", "genxml");
}
else
{
productData.DataLangRecord.AddXmlNode(strXml, "genxml/docs/genxml", "genxml/docs");
}
/////////////////////////////////////////////////
productData.DataLangRecord.SetXmlProperty("genxml/docs/genxml[" + lp.ToString() + "]/textbox/txtdocdesc", DocDesc);
productData.DataLangRecord.SetXmlProperty("genxml/docs/genxml[" + lp.ToString() + "]/textbox/txttitle", FileName);
objCtrlDoc.Update(productData.DataLangRecord);
lp += 1;
}
////////////////////////////// CATEGORIES /////////////////////////////////////
////////////////////////////// CATEGORIES /////////////////////////////////////
////////////////////////////// CATEGORIES /////////////////////////////////////
////////////////////////////// CATEGORIES /////////////////////////////////////
var nodListCat = nod.SelectNodes("C/NB_Store_ProductCategoryInfo");
foreach (XmlNode nodCat in nodListCat)
{
var ProductID = nodCat.SelectSingleNode("ProductID").InnerText;
var CategoryID = nodCat.SelectSingleNode("CategoryID").InnerText;
if (ProductID == guidKey)
{
if (categoryListIDGiud.ContainsKey(CategoryID))
{
var newCategoryId = categoryListIDGiud[CategoryID];
productData.AddCategory(newCategoryId);
}
}
}
////////////////////////////// SAVE PRODUCT /////////////////////////////////////
productData.Save();
}
}
catch (Exception e)
{
var logMessage = "PRODUCTS: " + prodname + " ProductId: " + productid.ToString() + " : " + e.ToString();
LogOutput.LogWrite(logMessage);
}
}
}
////////////////////////////// RELATED PRODUCTS /////////////////////////////////////
//recicle on all the xml import Product and reconnect the related product
foreach (var lang2 in langList)
{
if (nodList != null)
{
foreach (XmlNode nod in nodList)
{
var guidKeyNod = nod.SelectSingleNode("NB_Store_ProductsInfo/ProductID");
if (guidKeyNod != null)
{
var guidKey = guidKeyNod.InnerText;
var productid = -1;
try
{
// See if e already have a product imported, if so we want to update (maybe multiple languages, or a 2nd migrate)
var nbiImport = objCtrl.GetByGuidKey(PortalSettings.Current.PortalId, -1, "PRD", guidKey);
if (nbiImport != null)
{
productid = nbiImport.ItemID;
}
var productData = new ProductData(productid, lang2);
////////////////////////////// RELATED PRODUCTS /////////////////////////////////////
////////////////////////////// RELATED PRODUCTS /////////////////////////////////////
var nodListRelated = nod.SelectNodes("R/NB_Store_ProductRelatedInfo");
if (nodListRelated != null) //if there are related
{
foreach (XmlNode nodRel in nodListRelated)
{
// id in the related product import file
var ImportRelatedProductID = nodRel.SelectSingleNode("RelatedProductID").InnerText;
// extract Id of the new created product thet have the old id in the guidKey
var tempID = objCtrl.GetByGuidKey(PortalSettings.Current.PortalId, -1, "PRD", ImportRelatedProductID);
if (tempID != null)
{
int IDRelatedprod = tempID.ItemID;
productData.AddRelatedProduct(IDRelatedprod);
productData.Save();
}
}
}
}
catch (Exception e)
{
var logMessage = "RELATED PRODUCTS: ProductId: " + productid.ToString() + " : " + e.ToString();
LogOutput.LogWrite(logMessage);
}
}
}
}
}
LogOutput.LogWrite("END: " + DateTime.Now);
#endregion
}
NBrightBuyUtils.SetNotfiyMessage(ModuleId, "Import", NotifyCode.ok, ControlPath + "/App_LocalResources/Import.ascx.resx");
}
}