private void btnSaveXml_Click(object sender, EventArgs e)
{
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
var service = new XmlDataTableService();
var dt = service.ApplyConvertedDataSet(this.ConvertedDataSet);
service.SaveAsXml(dt, saveFileDialog1.FileName);
}
}
public void UpdateGrid()
{
var service = new XmlDataTableService();
var dt = this.DataTable.Copy();
/*dt = */service.ApplyFilters(dt, this.FilterList);
//this.comparerGrid.ModifiedDataTable = dt;
comparerGrid.OriginalDataTable = this.DataTable;
comparerGrid.ModifiedDataTable = dt;
comparerGrid.Reload();
}
private void reloadGrid()
{
var service = new XmlDataTableService();
var dt = this.DataTable.Copy();
service.ApplyFilters(dt, this.Transform.Filters);
service.ApplyOperations(dt, this.Transform.Operations);
grid.ModifiedDataTable = dt;
grid.Reload();
}
private void loadDataTable(int cdsID)
{
if (cdsList == null)
return;
var cds = cdsList.FirstOrDefault(x => x.ID == cdsID);
if (cds == null)
return;
var service = new XmlDataTableService();
var loadedDataTable = service.XmlToDataTable(cds.SourceXmlPath);
if (loadedTables.ContainsKey(cds.ID))
loadedTables[cds.ID] = loadedDataTable;
else
loadedTables.Add(cds.ID, loadedDataTable);
MessageBox.Show("XML Yüklendi.");
}
private void LoadCategoryTree()
{
try
{
var list = dataService.GetSubCategories(N11_STORE_ID, null);
categoryTable = new Dictionary<long, CategoryModel>();
treeN11Categories.Nodes.Clear();
foreach (CategoryModel cat in list)
{
treeN11Categories.Nodes.Add(categoryToTreeNode(cat, false));
treeProductCategories.Nodes.Add(categoryToTreeNode(cat, false));
}
}
catch (Exception ex)
{
throw ex;
}
try
{
//loadXml(this.CurrentConvertedDataSet.ID);
//var xmlColl = new ProductsXmlCollection(this.CurrentConvertedDataSet.SourceXmlPath);
//xmlColl.GetSubTable("mainCategory", "category", "subCategory");
var service = new XmlDataTableService();
//var dt = service.XmlToDataTable(this.CurrentConvertedDataSet.SourceXmlPath);
loadXml(this.CurrentConvertedDataSet.ID);
var dt = loadedTables[this.CurrentConvertedDataSet.ID];
dt = XmlDataTableService.GetSubTable(dt, "mainCategory", "category", "subCategory");
// Get mappings
//var treeTable = new Dictionary<string, Dictionary<string, List<string>>>();
var treeTable = new List<Tuple<string, string, string, string, long?>>();
var mappingTable = catService.GetCategoryMappings(N11_STORE_ID);
Func<object, string> cellValueToStr = x => x is System.DBNull ? "" : (string) x;
// DataTable to treeTable
foreach (DataRow dr in dt.Rows)
{
var mainCategory = cellValueToStr(dr["mainCategory"]);
var category = cellValueToStr(dr["category"]);
var subCategory = cellValueToStr(dr["subCategory"]);
var mappedCategory =
mappingTable.FirstOrDefault(x =>
mainCategory == (x.Level1 ?? "")
&& category == (x.Level2 ?? "")
&& subCategory == (x.Level3 ?? ""));
var mappedCatName = mappedCategory != null ? mappedCategory.CategoryName : "";
var mappedCatId = mappedCategory != null ? mappedCategory.CategoryID : (long?) null;
treeTable.Add(new Tuple<string, string, string, string, long?>(mainCategory, category, subCategory, mappedCatName, mappedCatId));
//if (!String.IsNullOrEmpty(mainCategory))
//{
// var level1 = treeTable.ContainsKey(mainCategory) ? treeTable[mainCategory] : null;
// if (level1 == null)
// {
// level1 = new Dictionary<string, List<string>>();
// treeTable.Add(mainCategory, level1);
// }
// if (!String.IsNullOrEmpty(category))
// {
// var level2 = level1.ContainsKey(category) ? level1[category] : null;
// if (level2 == null)
// {
// level2 = new List<string>();
// level1.Add(category, level2);
// }
// if (!String.IsNullOrEmpty(subCategory))
// {
// if (!level2.Contains(subCategory))
// level2.Add(subCategory);
// }
// }
//}
}
treeTable = treeTable.Distinct().ToList();
// Add tree nodes
categoryTreeView1.SetDataSource(treeTable);
//foreach (var mainCategory in treeTable.Keys)
//{
// var catTable = treeTable[mainCategory];
// var mainNode = treeStoreCategories.Nodes.Add(mainCategory);
// foreach (var category in catTable.Keys)
// {
// var subList = catTable[category];
// var node = mainNode.Nodes.Add(category);
// foreach (var subCategory in subList)
// {
// node.Nodes.Add(subCategory);
// }
// }
//}
categoriesLoaded = true;
}
catch (Exception ex)
{
//throw ex;
ex.GetType();
}
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
if (tree.Nodes.Count > 0)
{
var cds = tree.Nodes[0].Tag as ConvertedDataSetModel;
if (cds == null)
return;
//var products = new ProductsXmlCollection(cds.SourceXmlPath);
var service = new XmlDataTableService();
var loadedDataTable = service.XmlToDataTable(cds.SourceXmlPath);
if (loadedTables.ContainsKey(cds.ID))
loadedTables[cds.ID] = loadedDataTable;
else
loadedTables.Add(cds.ID, loadedDataTable);
MessageBox.Show("XML Yüklendi.");
}
}
