public ExcelPublisher(S21Settings settings)
{
if (settings != null)
{
puthToFile = settings.PuthToExcelDbFile;
}
CheckConnect();
}
public static object GetDataPublisher(S21Settings settings)
{
ExcelPublisher.ExcelPublisher publishers = new ExcelPublisher.ExcelPublisher(settings);
if (publishers.CheckConnect())
{
return(publishers.GetPublishers(publishers.publishersWorksheet));
}
return(null);
}
public static void AddPublisher(PublishersRange publisher, S21Settings settings)
{
ExcelPublisher.ExcelPublisher excel = new ExcelPublisher.ExcelPublisher(settings);
if (excel.CheckConnect() == true)
{
var datas = GetDataPublisher(settings) as List <PublishersRange>;
List <string> names = new List <string>(); // Будет хранить имена всех возвещателей, который находяться в excel.
foreach (var data in datas)
{
names.Add(data.Name);
}
names.Add(publisher.Name);
names.Sort();
int index = names.IndexOf(publisher.Name) + 2; // +2 -- есть общие начальные колонки в ексель таблице.
excel.AddPublisher(publisher, index);
}
}
public static bool CheckConnect(S21Settings settings)
{
ExcelPublisher.ExcelPublisher publisher = new ExcelPublisher.ExcelPublisher(settings);
return(publisher.CheckConnect());
}
public static Task <object> GetDataPublisherAsync(S21Settings settings)
{
return(Task.Run(() => GetDataPublisher(settings)));
}
public static Task <List <S21InfoPublisherField> > CreateS21ModelDataPublisherAsync(S21Settings settings)
{
return(Task.Run(() => CreateS21ModelDataPublisher(settings)));
}
public static List <S21InfoPublisherField> CreateS21ModelDataPublisher(S21Settings settings)
{
ExcelPublisher.ExcelPublisher publisherEx = new MinistryReports.ExcelPublisher.ExcelPublisher(settings);
return(blank.GenerateInfoPublishers(publisherEx.GetPublishers(publisherEx.publishersWorksheet)));
}
public static void SetSettings(S21Settings settings)
{
S21Blank.SetSettings(settings);
}
public S21Controller(S21Settings setting)
{
blank = new S21Blank();
SetSettings(setting);
}
