Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static void processElements()
- {
- Excel.Worksheet sheet = (Excel.Worksheet)_book.Worksheets.get_Item("Справочник");
- Char[] charsToTrim = { ' ', '.' };
- for (int row = 2; row <= 796; row++)
- {
- Excel.Range range = sheet.get_Range("A" + row, "F" + row);
- Object[,] data = (Object[,])range.Value2;
- String name = Convert.ToString(data[1, 2]).Trim();
- try
- {
- element el = _db.elements.SingleOrDefault(e => e.name == name);
- if (el == null)
- {
- int type_id = getTypeId(Convert.ToString(data[1, 6]).Trim(charsToTrim));
- int unit_id = getUnitId(Convert.ToString(data[1, 4]).Trim(charsToTrim));
- el = new element
- {
- name = name,
- description = Convert.ToString(data[1, 3]).Trim(),
- count = 0,
- type_id = type_id,
- unit_id = unit_id,
- old_id = Convert.ToInt32(data[1, 1])
- };
- _db.elements.InsertOnSubmit(el);
- }
- }
- catch (System.InvalidOperationException)
- {
- Console.WriteLine("Element with name '{0}' exists multiple times", name);
- }
- }
- _db.SubmitChanges();
- Console.WriteLine("Element import complete");
- }
Add Comment
Please, Sign In to add comment