public CurrentProvider LoadSensors ( int roomIndex, string filePath ) { IExcelImport import = new DataManipulator(); DataTable var = new DataTable(); var.Columns.Add("1"); var.Columns.Add("2"); var.Columns.Add("3"); var.Columns.Add("4"); foreach (var sensor in User.Rooms[roomIndex].ListSensors) { var.Rows.Add ( sensor.Name, sensor.Fam, sensor.State, sensor.Data ); } var = import.InputFile ( filePath, var ); if (var != null) { for (var i = 0; i < var.Rows.Count; ++i) { var currSett = User.Rooms[roomIndex].Settings; var newSett = ""; if ("Дверь входная" == var.Rows[i][0].ToString()) { newSett = var.Rows[i][3].ToString(); newSett = string.Concat(newSett == "Закрыто" ?"0" :"1", currSett[1], currSett[2]); SetNewSettings(newSett, User.Rooms[roomIndex].RoomId, 0); UpdateStatusOfTheSensor(27, var.Rows[i][2].ToString()); } if ("Дверь прмоежуточная" == var.Rows[i][0].ToString()) { newSett = var.Rows[i][3].ToString(); newSett = string.Concat(currSett[0], newSett == "Закрыто" ? "0" : "1", currSett[2]); SetNewSettings(newSett, User.Rooms[roomIndex].RoomId, 1); UpdateStatusOfTheSensor(28, var.Rows[i][2].ToString()); } if ("Окно" == var.Rows[i][0].ToString()) { newSett = var.Rows[i][3].ToString(); newSett = string.Concat(currSett[0], currSett[1], newSett == "Закрыто" ? "0" : "1"); SetNewSettings(newSett, User.Rooms[roomIndex].RoomId, 2); UpdateStatusOfTheSensor(29, var.Rows[i][2].ToString()); } } } return(this); }