public async Task <ReestrSetting> CreateReestrSetting(ReestrSetting reestr)
{
using (var connection = _applicationContextFactory.CreateConnection())
{
await connection.InsertAsync(reestr);
return(reestr);
}
}
public async Task <Customer> CreateCustomer(Customer customer)
{
using (var connection = _factory.CreateConnection())
{
await connection.InsertAsync(customer);
return(customer);
}
}
public async Task <BarrelStorage> CreateBarrelStorage(BarrelStorage barrelStorage)
{
using (var connection = _factory.CreateConnection())
{
await connection.InsertAsync(barrelStorage);
return(barrelStorage);
}
}
public async Task <Report> CreateAsync(Report report)
{
using (var connection = _factory.CreateConnection())
{
int id = await connection.InsertAsync(report);
report.Id = id;
return(report);
}
}
public async Task <Recipe> CreateRecipe(Recipe recipe)
{
using (var connection = _factory.CreateConnection())
{
//string query = "INSERT INTO Recipes (`ShortName`, `LongName`, `Brix`, `StorageCondition`, `TransportationCondition`, `Сarbohydrates`, `VitaminC`, `EnergyValue`, `DryContent`) VALUES " +
// "(@ShortName,@LongName,@Brix,@StorageCondition,@TransportationCondition,@Сarbohydrates,@VitaminC,@EnergyValue,@DryContent)";
await connection.InsertAsync(recipe);
return(recipe);
}
}
public async Task <RoomInfo> SaveAsync(RoomInfo roomInfo)
{
using (var connection = _factory.CreateConnection())
{
roomInfo.Id = await connection.InsertAsync(roomInfo);
return(roomInfo);
}
}
public async Task <IEnumerable <MultiRoomInfo> > FilterRooms(string ipAddress, DateTime from, DateTime to)
{
string query = @"SELECT *FROM MultiRoomInfos as r
Left join ActiveDevices as d on
r.deviceid=d.id where date>=@from and date<=@to and d.ipaddress=@ipAddress" ;
using (var connection = _factory.CreateConnection())
{
var result = await connection.QueryAsync <MultiRoomInfo, ActiveDevice, MultiRoomInfo>(query,
(r, d)
=>
{
r.ActiveDevice = d;
return(r);
},
new
{ from = from.Date.ToString("yyyy-MM-dd"), to = to.Date.ToString("yyyy-MM-dd"), ipAddress });
return(result);
}
}
public async Task <Result> ChangeCredential(int id, string login, string password)
{
using (var connection = _factory.CreateConnection())
{
var query = "Select *from users where login=@login";
var existedUser = await connection.QueryFirstOrDefaultAsync <User>(query, new { login });
if (existedUser != null)
{
return(Result.CreateError("Пользователь с таким логином уже существует"));
}
var queryUpdate = "Update users set login=@login,password=@password where id =@id";
var row = await connection.ExecuteAsync(queryUpdate, (id, password, login));
return(new Result
{
IsSuccess = row > 0
});
}
}
public async Task TransferData()
{
List <RoomInfo> roomInfos = new List <RoomInfo>();
using (var file = new StreamReader("log.log"))
{
int i = 0;
string line;
RoomInfo room = null;
while ((line = await file.ReadLineAsync()) != null)
{
if (!line.Contains("ADDED To Graph"))
{
room = new RoomInfo();
i = 0;
continue;
}
i++;
var time = line.Split().TakeWhile(x => x != "[INF]");
var agg = time.Aggregate((a, b) => a + " " + b);
var t = DateTime.Parse(agg.Trim());
room.Date = t;
room.DeviceId = 2;
if (i == 1)
{
var h = line.Split().ElementAt(11);
room.Humidity = double.Parse(h.Replace(".", ","));
}
if (i == 2)
{
var te = line.Split().ElementAt(11);
room.Temperature = double.Parse(te.Replace(".", ","));
roomInfos.Add(room);
}
}
}
using (var connection = _factory.CreateConnection())
{
foreach (var item in roomInfos)
{
await connection.InsertAsync(item);
}
}
}
public async Task <Device> CreateAsync(Device device)
{
string query = "SELECT *FROM DEVICES WHERE ipaddress =@address";
using (var connection = _factory.CreateConnection())
{
var dev = await connection.QueryFirstOrDefaultAsync <Device>(query, new { address = device.IPAddress });
if (dev != null)
{
return(dev);
}
int id = await connection.InsertAsync(device);
device.Id = id;
return(device);
}
}
public void Start()
{
using (var connection = _factory.CreateConnection())
{
try
{
connection.Execute(Query.createMultiRoom);
connection.Execute(Query.addDeviceType);
//connection.Execute(Query.alterRoomInfos);
//connection.Execute(Query.dropReportTable);
//connection.Execute(Query.createReportTable);
System.Console.WriteLine("Success");
}
catch (Exception ex)
{
System.Console.WriteLine(ex.Message);
System.Console.WriteLine(ex?.InnerException);
}
}
}
public async Task <IEnumerable <ActiveDevice> > GetActiveDevicesListsWithReports()
{
string query = @"SELECT *FROM ActiveDevices as ad
Left join Reports as r on ad.reportid=r.id
where ad.isAdded = 1 and ad.isActive=1 and r.isclosed=0" ;
using (var connection = _factory.CreateConnection())
{
var entities = await connection.QueryAsync <ActiveDevice, Report, ActiveDevice>(query,
(ad, r) =>
{
ad.Report = r;
ad.ReportId = r.Id;
return(ad);
});
return(entities);
}
}
public async Task <Reestr> CreateReestr(Reestr reestr)
{
using (var connection = _factory.CreateConnection())
{
int barrelNumber = 1;
string firstQuery = "SELECT * FROM Reestrs ORDER BY id DESC LIMIT 1";
var result = await connection.QueryFirstOrDefaultAsync <Reestr>(firstQuery);
if (result != null)
{
barrelNumber = result.BarrelNumber + 1;
}
reestr.BarrelNumber = barrelNumber;
await connection.InsertAsync(reestr);
return(reestr);
}
}