Guest User

Untitled

a guest
Jul 23rd, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. public static void processElements()
  2. {
  3. Excel.Worksheet sheet = (Excel.Worksheet)_book.Worksheets.get_Item("Справочник");
  4.  
  5. Char[] charsToTrim = { ' ', '.' };
  6. for (int row = 2; row <= 796; row++)
  7. {
  8. Excel.Range range = sheet.get_Range("A" + row, "F" + row);
  9. Object[,] data = (Object[,])range.Value2;
  10.  
  11. String name = Convert.ToString(data[1, 2]).Trim();
  12.  
  13. try
  14. {
  15. element el = _db.elements.SingleOrDefault(e => e.name == name);
  16.  
  17. if (el == null)
  18. {
  19. int type_id = getTypeId(Convert.ToString(data[1, 6]).Trim(charsToTrim));
  20. int unit_id = getUnitId(Convert.ToString(data[1, 4]).Trim(charsToTrim));
  21.  
  22. el = new element
  23. {
  24. name = name,
  25. description = Convert.ToString(data[1, 3]).Trim(),
  26. count = 0,
  27. type_id = type_id,
  28. unit_id = unit_id,
  29. old_id = Convert.ToInt32(data[1, 1])
  30. };
  31.  
  32. _db.elements.InsertOnSubmit(el);
  33. }
  34. }
  35. catch (System.InvalidOperationException)
  36. {
  37. Console.WriteLine("Element with name '{0}' exists multiple times", name);
  38. }
  39. }
  40. _db.SubmitChanges();
  41.  
  42. Console.WriteLine("Element import complete");
  43. }
Add Comment
Please, Sign In to add comment