private void addAnnotations(SQLite.TableQuery <MagpieIOS.MagpieBadge> table) { var documents = Environment.GetFolderPath(Environment.SpecialFolder.Personal); var dbPath = Path.Combine(documents, "db_sqlite-net.db"); var db = new SQLiteConnection(dbPath); int index = 0; foreach (MagpieBadge badge in table) { double lat = table.ElementAt(index).lat; double lon = table.ElementAt(index).lon; String name = table.ElementAt(index).bname; String sub = table.ElementAt(index).art + " - " + table.ElementAt(index).year; //if iscollected check String q = "SELECT * FROM MagpieUser WHERE bid = " + table.ElementAt(index).bid; var userTuple = db.Query <MagpieUser>(q); if (userTuple.ElementAt(0).isClaimed.Equals("")) { var annotation = new AnnotationModel(new CLLocationCoordinate2D(lat, lon), name, index, false, sub); map.AddAnnotation(annotation); } else { var annotation = new AnnotationModel(new CLLocationCoordinate2D(lat, lon), name, index, true, sub); map.AddAnnotation(annotation); } index++; } }
private static async Task SendOnEmail(SQLite.TableQuery <Model.Errors> notices) { var message = new Xamarin.Essentials.EmailMessage { Subject = "Отчет об ошибках", Body = "Здесь вы можете добавить описание вашей проблемы (если она есть). Мы постараемся вам помочь", To = new List <string>() { "*****@*****.**" }, BodyFormat = Xamarin.Essentials.EmailBodyFormat.PlainText }; var fn = "logs.txt"; var file = System.IO.Path.Combine(Xamarin.Essentials.FileSystem.CacheDirectory, fn); string log = Api.Funcs.PhoneModel + ":" + Environment.NewLine + Environment.NewLine + string.Join(Environment.NewLine, notices.Select(er => er.Name + Environment.NewLine + er.Method + Environment.NewLine + er.Params + Environment.NewLine)); System.IO.File.WriteAllText(file, log); message.Attachments.Add(new Xamarin.Essentials.EmailAttachment(fn)); await Xamarin.Essentials.Email.ComposeAsync(message); //*/ }