/// <summary>
/// Отбираем все или конкретный
/// </summary>
/// <param name="numberOffice">Номер кабинета</param>
/// <param name="isAll">Если true запрашиваем все</param>
public QrCodeOffice SelectOffice(string numberOffice, bool isAll = false)
{
var modelOfficeList = new QrCodeOffice
{
Kabinet = isAll
? Inventory.Database.SqlQuery <EfDatabaseXsdQrCodeModel.Kabinet>($"Select * From Kabinet").ToArray()
: Inventory.Database
.SqlQuery <EfDatabaseXsdQrCodeModel.Kabinet>(
$"Select * From Kabinet Where NumberKabinet ='{numberOffice}'").ToArray()
};
return(modelOfficeList);
}
public void CreateQrCodeOffice()
{
Select auto = new Select();
QrCodeOffice office = auto.SelectOffice("357", true);
GenerateBarcode qrCode = new GenerateBarcode();
OfficeStikerCode stickerQrOffice = new OfficeStikerCode();
//Создание qr кодов
foreach (var qrCodeOffice in office.Kabinet)
{
qrCodeOffice.FullPathPng = qrCode.GenerateQrCode("C:\\Testing\\" + qrCodeOffice.IdNumberKabinet, qrCodeOffice.NumberKabinet);
}
stickerQrOffice.CreateDocument("C:\\Testing\\QrCodeOffice", office);
//Удаление всех png
foreach (var cabinet in office.Kabinet)
{
File.Delete(cabinet.FullPathPng);
}
}
