public void Add(Tabel tabel) { if (_list.Exists(item => item == tabel)) return; _list.Add(tabel); }
public void StartImport() { TabelList tabelList = TabelList.GetInstance(); string[] files = Directory.GetFiles(FilePath, "*.txt"); foreach (var file in files) { string date = file.Split('_')[2].Split('.')[0]; int month = Convert.ToInt32(string.Concat(date[0], date[1])); int year = Convert.ToInt32(string.Concat("20", date[2], date[3])); string[] lines = File.ReadAllLines(file); for (int i = 1; i < lines.Count(); i++) { string[] fields = lines[i].Split(';'); for (int j = 2; j < fields.Count(); j++) { if ((fields[j] == "Я") || (fields[j] == "Я/Н")) { Tabel tabel = new Tabel(fields[0], new DateTime(year, month, j - 1)); tabel.Save(); } } } File.Move(file, FilePath + @"\processed\" + DateTime.Today.ToShortDateString() + " " + Path.GetFileName(file)); } }
protected override void loadFromSql() { DataTable dt = _provider.Select("Tabel"); foreach (DataRow row in dt.Rows) { Tabel tabel = new Tabel(row); Add(tabel); } }
public void StartImport() { try { using (ExcelDoc excel = new ExcelDoc(FilePath)) { int i = 7; string curCell = "H" + i; while (excel.getValue(curCell) != null) { curCell = "A" + i; if ((excel.getValue(curCell) == null) || ((excel.getValue(curCell).ToString().ToUpper() != "AM") && (excel.getValue(curCell).ToString().ToUpper() != "АМ"))) { curCell = "H" + i; i++; continue; } curCell = "H" + i; string number = excel.getValue(curCell).ToString(); curCell = "D" + i; DateTime dateBegin; DateTime.TryParse(excel.getValue1(curCell).ToString(), out dateBegin); curCell = "E" + i; DateTime dateEnd; DateTime.TryParse(excel.getValue1(curCell).ToString(), out dateEnd); for (DateTime date = dateBegin; date <= dateEnd; date = date.AddDays(1)) { Tabel tabel = new Tabel(number, date) { Comment = "businessTrip" }; tabel.Save(); } curCell = "H" + i; i++; } } } catch (NullReferenceException ex) { LogManager.Logger.Error(ex, "Error in file {file}", FilePath); } catch (COMException ex) { LogManager.Logger.Error(ex, "Error in file {file}", FilePath); } }