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);
}