Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public ActionResult Import()
- {
- var fileName = string.Format("{0}planilha.xlsx", HttpContext.Request.PhysicalApplicationPath);
- var connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0; data source={0}; Extended Properties=Excel 8.0;", fileName);
- var adapter = new OleDbDataAdapter("SELECT * FROM [Sheet 1$]", connectionString);
- var ds = new DataSet();
- adapter.Fill(ds, "anyNameHere");
- DataTable data = ds.Tables["anyNameHere"];
- List<EquipmentBuilder1> EquipmentBuilderList = new List<EquipmentBuilder1>();
- int RowNumber = 0;
- foreach (DataRow Row in data.Rows)
- {
- var productName = Row[1];
- var equipmentBuilder = Row[8];
- foreach (var EquipmentBuilder in equipmentBuilder.ToString().Split(';'))
- {
- var FoundEquipmentBuilder = EquipmentBuilderList.FirstOrDefault(x => x.Builder == EquipmentBuilder);
- if (FoundEquipmentBuilder == null)
- {
- //se nao encontarr um fabricante, adicioanr o fabricante mais o produto atual
- EquipmentBuilder1 equipmentBuilder1 = new EquipmentBuilder1()
- {
- Builder = EquipmentBuilder
- };
- equipmentBuilder1.ProductList = new List<Product1>()
- {
- new Product1(productName.ToString(), RowNumber)
- };
- EquipmentBuilderList.Add(equipmentBuilder1);
- }
- else
- {
- //se encontrar um fabricante, adicionar o produto
- FoundEquipmentBuilder.ProductList.Add(new Product1(productName.ToString(), RowNumber));
- }
- }
- RowNumber++;
- }
- var UmbracoProduct = Umbraco.TypedContent(1735);
- foreach (var Category in UmbracoProduct.Children)
- {
- foreach (var Product in Category.Children)
- {
- }
- }
- var UmbracoBuilders = Umbraco.TypedContent(1297);
- int ocorrenciasDiferentes = 0;
- foreach (var Builder in UmbracoBuilders.Children)
- {
- var UmbracoBuilder = EquipmentBuilderList.FirstOrDefault(x => x.Builder == Builder.Name);
- if (UmbracoBuilder != null)
- {
- if (UmbracoBuilder.ProductList.Count != Builder.GetPropertyValue<List<IPublishedContent>>("manufacturersComponentItemProduct").Count)
- {
- ocorrenciasDiferentes++;
- //descrepancia numeros diferentes
- }
- else
- {
- //ta tudo igual
- }
- }
- else
- {
- //erro caralho
- }
- }
- return null;
- }
Add Comment
Please, Sign In to add comment