public MemoryStream SaveToXML(string filter)
        {
            string             db         = ConfigurationManager.AppSettings["DBConnectionString"];
            ContactsDBOperator dBOperator = new ContactsDBOperator(db);
            List <Contact>     contacts   = (filter == "")?dBOperator.GetAll():ContactsSearch(filter);

            //string file = ConfigurationManager.AppSettings["tempfilePath"];

            //string filepath = AppDomain.CurrentDomain.BaseDirectory + file;

            using (ExcelPackage package = new ExcelPackage())
            {
                var newworksheet = package.Workbook.Worksheets.Add("test");
                newworksheet.Cells["A1"].LoadFromCollection(contacts, true);

                var stream = new MemoryStream(package.GetAsByteArray());
                return(stream);

                //string filepath = "C:\\Users\\anotfullina\\Documents\\GitHub\\learning\\FinalService\\temp\\contacts1.xlsx";
                //FileInfo fi = new FileInfo(filepath);
                //package.SaveAs(fi);
            }



            //return "temp\\contacts.xls";
        }
        public string GetAllContacts()
        {
            Logger.Log.Info($"GetAllContacts called");
            string             db         = ConfigurationManager.AppSettings["DBConnectionString"];
            ContactsDBOperator dBOperator = new ContactsDBOperator(db);
            List <Contact>     contacts   = dBOperator.GetAll();

            if (contacts == null)
            {
                Logger.Log.Info($"Contacts list is empty");
                throw new FaultException <int>(0, $"Список контактов пуст");
            }
            else
            {
                JsonSerializerSettings settings = new JsonSerializerSettings();
                settings.DateFormatString = "d MMMM, yyyy";
                string responce = JsonConvert.SerializeObject(contacts, settings);
                Logger.Log.Info($"GetAllContacts return {contacts?.Count} contacts");
                return(responce);
            }
        }