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