void FillContacts() { var uri = ContactsContract.CommonDataKinds.Phone.ContentUri; string[] projection = { ContactsContract.CommonDataKinds.Phone.Number, ContactsContract.Contacts.InterfaceConsts.DisplayName, ContactsContract.Contacts.InterfaceConsts.PhotoId }; //select id,DisplayName,PhotoId where id=1 var loader = new CursorLoader(this, uri, projection, null, null, null); var cursor = (ICursor)loader.LoadInBackground(); List<Contact> contactList = new List<Contact>(); if (cursor.MoveToFirst()) { do { contactList.Add( new Contact(cursor.GetString(cursor.GetColumnIndex(projection[0])), cursor.GetString(cursor.GetColumnIndex(projection[1])), cursor.GetString(cursor.GetColumnIndex(projection[2])) ) ); } while (cursor.MoveToNext()); } string items = ""; foreach ( Contact c in contactList) { items += c.DisplayName + "," + c.Number + "," + c.PhotoId; } textView1.Text = items; }
protected override void OnCreate(Bundle bundle) { base.OnCreate(bundle); SetContentView(Resource.Layout.HomeScreen); listView = FindViewById<ListView>(Resource.Id.List); string[] projection = new string[] { VegetableProvider.InterfaceConsts.Id, VegetableProvider.InterfaceConsts.Name }; string[] fromColumns = new string[] { VegetableProvider.InterfaceConsts.Name }; int[] toControlIds = new int[] { Android.Resource.Id.Text1 }; // ManagedQuery is deprecated in Honeycomb (3.0, API11) cursor = ManagedQuery(VegetableProvider.CONTENT_URI, projection, null, null, null); // ContentResolver requires you to close the query yourself //cursor = ContentResolver.Query(VegetableProvider.CONTENT_URI, projection, null, null, null); //StartManagingCursor(cursor); // CursorLoader introduced in Honeycomb (3.0, API11) var loader = new CursorLoader(this, VegetableProvider.CONTENT_URI, projection, null, null, null); cursor = (ICursor)loader.LoadInBackground(); // create a SimpleCursorAdapter adapter = new SimpleCursorAdapter(this, Android.Resource.Layout.SimpleListItem1, cursor, fromColumns, toControlIds); listView.Adapter = adapter; listView.ItemClick += OnListItemClick; }
void FillContacts() { var uri = ContactsContract.Contacts.ContentUri; string[] projection = { ContactsContract.Contacts.InterfaceConsts.Id, ContactsContract.Contacts.InterfaceConsts.DisplayName, ContactsContract.Contacts.InterfaceConsts.PhotoId }; var loader = new Android.Content.CursorLoader(activity, uri, projection, null, null, null); using (var cursor = (ICursor)loader.LoadInBackground()) { contactList = new List <Contact> (); if (cursor.MoveToFirst()) { do { contactList.Add(new Contact { Id = cursor.GetLong(cursor.GetColumnIndex(projection [0])), DisplayName = cursor.GetString(cursor.GetColumnIndex(projection [1])), PhotoId = cursor.GetString(cursor.GetColumnIndex(projection [2])) }); }while (cursor.MoveToNext()); } } }
public static List<Song> LoadSongs (Activity context) { var uri = MediaStore.Audio.Media.ExternalContentUri; String selection = MediaStore.Audio.Media.InterfaceConsts.IsMusic + " != 0"; string[] projection = { MediaStore.Audio.Media.InterfaceConsts.Id, MediaStore.Audio.Albums.InterfaceConsts.AlbumId, MediaStore.Audio.Media.InterfaceConsts.Title, MediaStore.Audio.Media.InterfaceConsts.Artist, }; var loader = new CursorLoader (context, uri, projection, selection, null, null); var cursor = (ICursor)loader.LoadInBackground (); List<Song> songs = new List<Song> (); if (cursor.MoveToFirst ()) { do { songs.Add (new Song ( cursor.GetLong (cursor.GetColumnIndex (projection [0])), cursor.GetLong (cursor.GetColumnIndex (projection [1])), cursor.GetString (cursor.GetColumnIndex (projection [2])), cursor.GetString (cursor.GetColumnIndex (projection [3])) )); } while (cursor.MoveToNext ()); } return songs; }
static int PICK_CONTACT_REQUEST = 42; // The request code protected void OnActivityResult(TaskCompletionSource<ContactInfo> tcs, ActivityResultEventArgs e) //int requestCode, Android.App.Result resultCode, Intent data) { // Check which request it is that we're responding to if (e.requestCode == PICK_CONTACT_REQUEST) { // Make sure the request was successful if (e.resultCode == Android.App.Result.Ok) { var loader = new CursorLoader(MainActivity.Instance, e.data.Data, projection, null, null, null); var cursor = (Android.Database.ICursor)loader.LoadInBackground(); var contactList = new List<ContactInfo>(); if (cursor.MoveToFirst()) { do { contactList.Add(GetContactInfoFromCursor(cursor)); } while (cursor.MoveToNext()); } tcs.SetResult(contactList.FirstOrDefault()); return; } } tcs.SetResult(null); }
private ICursor CreateCursor() { string[] columns = { MediaStore.Images.Media.InterfaceConsts.Data, MediaStore.Images.Media.InterfaceConsts.Id }; string orderBy = MediaStore.Images.Media.InterfaceConsts.Id; var loader = new CursorLoader(this, MediaStore.Images.Media.ExternalContentUri, columns, null, null, orderBy + " DESC"); var cursor = (ICursor)loader.LoadInBackground(); return cursor; }
static int PICK_CONTACT_REQUEST = 42; // The request code protected void OnActivityResult(TaskCompletionSource<ContactInfo> tcs, ActivityResultEventArgs e) //int requestCode, Android.App.Result resultCode, Intent data) { // Check which request it is that we're responding to if (e.requestCode == PICK_CONTACT_REQUEST) { // Make sure the request was successful if (e.resultCode == Android.App.Result.Ok) { //var uri = ContactsContract.Contacts.ContentUri; string[] projection = { ContactsContract.Contacts.InterfaceConsts.Id, ContactsContract.Contacts.InterfaceConsts.DisplayName, ContactsContract.Contacts.InterfaceConsts.PhotoId, }; var loader = new CursorLoader(MainActivity.Instance, e.data.Data, projection, null, null, null); var cursor = (Android.Database.ICursor)loader.LoadInBackground(); var contactList = new List<ContactInfo>(); if (cursor.MoveToFirst()) { do { var displayName = cursor.GetString(cursor.GetColumnIndex(projection[1])); var nameParts = displayName.Split(' '); var lastName = nameParts.Length > 1 ? nameParts[1] : null; contactList.Add(new ContactInfo() { Id = cursor.GetLong(cursor.GetColumnIndex(projection[0])).ToString(), GivenName = nameParts[0], AdditionalName = null, FamilyName = lastName }); } while (cursor.MoveToNext()); } tcs.SetResult(contactList.FirstOrDefault()); return; } } tcs.SetResult(null); }
// Read back the user name and print it to the console: bool ReadBackName() { // Get the URI for the user's profile: Android.Net.Uri uri = ContactsContract.Profile.ContentUri; // Setup the "projection" (columns we want) for only the display name: string[] projection = { ContactsContract.Contacts.InterfaceConsts.DisplayName }; // Use a CursorLoader to retrieve the user's profile data: CursorLoader loader = new CursorLoader (this, uri, projection, null, null, null); ICursor cursor = (ICursor)loader.LoadInBackground(); // Print the user name to the console if reading back succeeds: if (cursor != null) { if (cursor.MoveToFirst()) { Console.WriteLine(cursor.GetString(cursor.GetColumnIndex(projection[0]))); return true; } } return false; }
public System.String PhonesByUri(Uri uri) { var loader = new CursorLoader (_context, uri, null, null, null, null); ICursor cur; cur = (ICursor)loader.LoadInBackground (); cur.MoveToFirst(); System.String phones=""; int id = cur.GetInt(cur.GetColumnIndex(ContactsContract.Contacts.InterfaceConsts.Id)); if (System.Int16.Parse(cur.GetString(cur.GetColumnIndex(ContactsContract.Contacts.InterfaceConsts.HasPhoneNumber))) > 0) { var _loader = new CursorLoader (_context, ContactsContract.CommonDataKinds.Phone.ContentUri,null,ContactsContract.CommonDataKinds.Phone.InterfaceConsts.ContactId +" = "+id,null, null); ICursor pCur; pCur = (ICursor)_loader.LoadInBackground (); while (pCur.MoveToNext()) { phones+=pCur.GetString(pCur.GetColumnIndex(ContactsContract.CommonDataKinds.Phone.InterfaceConsts.Data))+"\r\n"; } pCur.Close(); } return phones; }
private void LoadSCData() { Android.Net.Uri uri; // String[] projection = {BowlingContract.BaseColumns._ID, BowlingContract.ScorecardColumns.SCORECARD_SEASONID, BowlingContract.ScorecardColumns.SCORECARD_BOWLING_DATE, BowlingContract.ScorecardColumns.SCORECARD_GAME1, BowlingContract.ScorecardColumns.SCORECARD_GAME2, BowlingContract.ScorecardColumns.SCORECARD_GAME3, BowlingContract.ScorecardColumns.SCORECARD_TOTAL, BowlingContract.ScorecardColumns.SCORECARD_AVERAGE }; uri = BowlingContract.URI_TABLE; // CursorLoader introduced in Honeycomb (3.0, API11) var loader = new CursorLoader(_activity, uri, projection, null, null, null); var mCursor = (Android.Database.ICursor)loader.LoadInBackground(); mScorecards = new List<Scorecard>(); //mCursor = mContentResolver.Query(BowlingContract.URI_TABLE, projection, null, null, BowlingContract.ScorecardColumns.SCORECARD_BOWLING_DATE + " DESC"); if (mCursor != null) { if (mCursor.MoveToFirst()) { do { int _id = mCursor.GetInt(mCursor.GetColumnIndex(BowlingContract.BaseColumns._ID)); String seasonId = mCursor.GetString(mCursor.GetColumnIndex(BowlingContract.ScorecardColumns.SCORECARD_SEASONID)); String bowlingDate = mCursor.GetString(mCursor.GetColumnIndex(BowlingContract.ScorecardColumns.SCORECARD_BOWLING_DATE)); String game1 = mCursor.GetString(mCursor.GetColumnIndex(BowlingContract.ScorecardColumns.SCORECARD_GAME1)); String game2 = mCursor.GetString(mCursor.GetColumnIndex(BowlingContract.ScorecardColumns.SCORECARD_GAME2)); String game3 = mCursor.GetString(mCursor.GetColumnIndex(BowlingContract.ScorecardColumns.SCORECARD_GAME3)); String seriesTotal = mCursor.GetString(mCursor.GetColumnIndex(BowlingContract.ScorecardColumns.SCORECARD_TOTAL)); String seriesAverage = mCursor.GetString(mCursor.GetColumnIndex(BowlingContract.ScorecardColumns.SCORECARD_AVERAGE)); // Scorecard scorecard = new Scorecard(_id, seasonId, bowlingDate, game1, game2, game3, seriesTotal, seriesAverage); mScorecards.Add(scorecard); } while (mCursor.MoveToNext()); } } }
private string GetPathToImage(Android.Net.Uri uri) { string doc_id = ""; try{ using (var c1 = Application.Context.ContentResolver.Query (uri, null, null, null, null)) { c1.MoveToFirst (); String document_id = c1.GetString (0); doc_id = document_id.Substring (document_id.LastIndexOf (":") + 1); } }catch{ Log.Debug ("GetPathToImage","Excepcion! El content es File"); Android.Content.Context context = Android.App.Application.Context; try{ String[] proj = { MediaStore.MediaColumns.Data }; Log.Debug ("GetPathToImage","Y la URI? "+uri.ToString()); // var c1 = context.ContentResolver.Query (uri, proj, null, null, null) var loader = new CursorLoader (context, uri, proj, null, null, null); var c1 = (ICursor)loader.LoadInBackground(); if(c1==null){ Log.Debug ("GetPathToImage","Sigue siendo nulo-"); } c1.MoveToFirst (); Log.Debug ("GetPathToImage","Pasamos?"); String document_id = c1.GetString (0); doc_id = document_id.Substring (document_id.LastIndexOf (":") + 1); Log.Debug ("GetPathToImage","Y bien? "+doc_id); } catch(Exception ex){ Log.Debug ("GetPathToImage","Excepcion! "+ex); } } string path = null; // The projection contains the columns we want to return in our query. string selection = Android.Provider.MediaStore.Images.Media.InterfaceConsts.Id + " =? "; using (var cursor = Application.Context.ContentResolver.Query(Android.Provider.MediaStore.Images.Media.ExternalContentUri, null, selection, new string[] {doc_id}, null)) { if (cursor == null) return path; var columnIndex = cursor.GetColumnIndexOrThrow(Android.Provider.MediaStore.Images.Media.InterfaceConsts.Data); cursor.MoveToFirst(); path = cursor.GetString(columnIndex); //cursor.Close (); } return path; }
public static string GetContactIDFromLookupKey(Context ctx, string lookupKey) { var loader = new CursorLoader(ctx, ContactsContract.Contacts.ContentUri, new string[] { ContactsContract.Contacts.InterfaceConsts.Id }, ContactsContract.Contacts.InterfaceConsts.LookupKey + " = ?", new string[] { lookupKey }, null); var cursor = (ICursor)loader.LoadInBackground(); string id = null; if (cursor.MoveToFirst()) { id = cursor.GetString(0); } cursor.Close(); return id; }
public static IEnumerable<AndroidContact> GetContactList(Activity context) { string[] projection = { ContactsContract.Contacts.InterfaceConsts.Id, ContactsContract.Contacts.InterfaceConsts.DisplayName, ContactsContract.Contacts.InterfaceConsts.PhotoThumbnailUri }; var loader = new CursorLoader(context, ContactsContract.Contacts.ContentUri, projection, null, null, null); var cursor = (ICursor)loader.LoadInBackground(); if (cursor.MoveToFirst()) { do { var c = new AndroidContact(); c.Id = cursor.GetString(0); c.DisplayName = cursor.GetString(1); var uri = cursor.GetString(2); if (uri != null) c.PhotoThumbnailUri = Android.Net.Uri.Parse(uri); yield return c; } while (cursor.MoveToNext()); } cursor.Close(); }
// Convert a gallery URI to a regular file path private string GetPath(Android.Net.Uri uri) { string[] projection = new string[] { MediaStore.MediaColumns.Data }; CursorLoader loader = new CursorLoader(Activity, uri, projection, null, null, null); ICursor cursor = (ICursor)loader.LoadInBackground(); int column_index = cursor.GetColumnIndexOrThrow(MediaStore.MediaColumns.Data); cursor.MoveToFirst(); return cursor.GetString(column_index); }
private String GetRealPathFromUri(Context context, Uri uri) { String[] proj = { MediaStore.Images.ImageColumns.Data }; CursorLoader loader = new CursorLoader(context, uri, proj, null, null, null); ICursor cursor = (ICursor)loader.LoadInBackground(); int columnIndex = cursor.GetColumnIndexOrThrow(MediaStore.Images.ImageColumns.Data); cursor.MoveToFirst(); String result = cursor.GetString(columnIndex); cursor.Close(); return result; }
private void CreateLoader() { string[] columns = { MediaStore.Images.Media.InterfaceConsts.Data, MediaStore.Images.Media.InterfaceConsts.Id }; string orderBy = MediaStore.Images.Media.InterfaceConsts.Id; _loader = new CursorLoader(_ctx, MediaStore.Images.Media.ExternalContentUri, columns, null, null, orderBy + " DESC"); }
public Uri[] GetContactsUriByName(System.String selname,bool ignorecase) { selname = selname.Replace ("'", "''"); string _linq1 = System.String.Concat (ContactsContract.Contacts.InterfaceConsts.DisplayName, " LIKE '", selname, "'"); string _linq2 = System.String.Concat ("UPPER(", ContactsContract.Contacts.InterfaceConsts.DisplayName, ") LIKE UPPER('", selname, "')"); var loader = new CursorLoader (_context, ContactsContract.Contacts.ContentUri, null, (!ignorecase) ? (_linq1) : (_linq2), null, null); ICursor cur; cur = (ICursor)loader.LoadInBackground (); Uri[] contactsUri = new Uri[cur.Count]; if (cur.MoveToFirst ()) { int c = 0; do { System.String lookupKey = cur.GetString (cur.GetColumnIndex (ContactsContract.Contacts.InterfaceConsts.LookupKey)); Uri uri = Uri.WithAppendedPath (ContactsContract.Contacts.ContentLookupUri, lookupKey); contactsUri [c] = uri; c++; } while(cur.MoveToNext ()); } cur.Close (); return contactsUri; }
void FillContacts() { var uri = ContactsContract.CommonDataKinds.Phone.ContentUri; string[] projection = { ContactsContract.CommonDataKinds.Phone.InterfaceConsts.ContactId, ContactsContract.Contacts.InterfaceConsts.DisplayName, ContactsContract.Contacts.InterfaceConsts.PhotoThumbnailUri, ContactsContract.CommonDataKinds.Phone.Number, ContactsContract.CommonDataKinds.Phone.NormalizedNumber }; // Build query statement string selection = ContactsContract.Contacts.InterfaceConsts.HasPhoneNumber + "= ?"; string[] selectionArgs = { "1" }; string order = ContactsContract.Contacts.InterfaceConsts.Starred + " DESC"; order += ", " + ContactsContract.CommonDataKinds.Phone.InterfaceConsts.ContactId; // Load query results var loader = new CursorLoader (_activity, uri, projection, selection, selectionArgs, order); var cursor = (ICursor)loader.LoadInBackground (); _contactList = new List<Contact> (); if (cursor.MoveToFirst ()) { do { _contactList.Add(new Contact{ Id = cursor.GetLong(cursor.GetColumnIndex(projection[0])), DisplayName = cursor.GetString(cursor.GetColumnIndex(projection[1])), PhotoThumbnailId = cursor.GetString(cursor.GetColumnIndex(projection[2])), Number = cursor.GetString(cursor.GetColumnIndex(projection[3])), NormalizedNumber = cursor.GetString(cursor.GetColumnIndex(projection[4])) }); } while (cursor.MoveToNext ()); } }
public System.String NameByUri(Uri uri) { var loader = new CursorLoader (_context, uri, null, null, null, null); ICursor cur; cur = (ICursor)loader.LoadInBackground(); cur.MoveToFirst(); return cur.GetString(cur.GetColumnIndex(ContactsContract.Contacts.InterfaceConsts.DisplayName)); }
public int IdByUri(Uri uri) { var loader = new CursorLoader (_context, uri, null, null, null, null); ICursor cur; cur = (ICursor)loader.LoadInBackground(); cur.MoveToFirst(); return cur.GetInt(cur.GetColumnIndex(ContactsContract.Contacts.InterfaceConsts.Id)); }
public Uri[] GetContactUrisByPhone(System.String phone) { Uri contactUri = Uri.WithAppendedPath(ContactsContract.PhoneLookup.ContentFilterUri, Uri.Encode(phone)); var loader = new CursorLoader (_context, contactUri, null, null, null, null); ICursor cur; cur = (ICursor)loader.LoadInBackground(); if((cur!=null)&(cur.Count>0)) { Uri[] contactsUri=new Uri[cur.Count]; try { if (cur.MoveToFirst()) { int c=0; do { System.String lookupKey = cur.GetString(cur.GetColumnIndex(ContactsContract.Contacts.InterfaceConsts.LookupKey)); Uri uri = Uri.WithAppendedPath(ContactsContract.Contacts.ContentLookupUri, lookupKey); contactsUri[c]=uri; c++; } while(cur.MoveToNext()); } } catch (System.Exception e) { Log.Error("xxx",e.Message); } cur.Close(); return contactsUri; } else { cur.Close(); return null; } }
/* * Fill list with message data from user Inbox. * */ public static void Fill_With_Inbox_Data(Activity context,ListView listView) { Pay_SMS_Main psm=new Pay_SMS_Main(); update_inbox_messages = true; List<String> items=new List<String>(); bool valid_body_check=false; String smsFilteredBody=""; String[] smsTimePaying= new string[5]; String[] projection = new String[]{ "address", "body","date" }; CursorLoader loader=new CursorLoader(context); try{ //slaže podatke obrnutim redom,tj od najstarijeg do najmlađeg tako da kad dodajem novi podatak na kraj da bude poredano loader = new CursorLoader( context,Android.Net.Uri.Parse ("content://sms/inbox"), projection, null, null, null); }catch(Exception e){ Log.Debug ("Problem kod loadera",e.ToString ()); } ICursor cursor = (ICursor)loader.LoadInBackground (); if (cursor.MoveToFirst ()) { // must check the result to prevent exception do { try { //Ako je broj iz datoteke Zone_Numbers_Assets, odnosno ako je broj iz raspona dozvoljenih if (psm.CheckSMSNumbers(cursor.GetString (cursor.GetColumnIndexOrThrow (projection [0])))) { String smsSender = cursor.GetString (cursor.GetColumnIndexOrThrow (projection [0])); String smsBody = cursor.GetString (cursor.GetColumnIndexOrThrow (projection [1])); String smsTime = cursor.GetString (cursor.GetColumnIndexOrThrow (projection [2])); long smsTimeLong=long.Parse (smsTime); String smsDate=psm.ConvertDateFromMillseconds (smsTimeLong); smsTime=psm.ConvertTimeFromMillseconds (smsTimeLong); try{ var tuple=ParseSMS.ParseSMSbody (smsBody); valid_body_check = tuple.Item1; //bool true or false smsFilteredBody = tuple.Item2; // car registration smsTimePaying=tuple.Item3.Split ('.');// car_time }catch(Exception e){ Log.Debug ("Greska prilikom filtriranja sms poruke.",e.ToString ()); } //check if sms body pass validation if(valid_body_check){ String msgData = psm.MessageDisplay (smsSender, smsFilteredBody,smsTime,smsTimePaying[0],smsDate); items.Add (msgData); } } } catch (Exception e) { Log.Debug ("UCITAVANJE SMS-a u Pay_SMS_Main", e.ToString ()); } } while (cursor.MoveToNext ()); } else { // empty box, no SMS cursor.Close (); } //okrecem podatke u descending nacin,tako da je najnoviji podatak na pocetku items.Reverse (); DeleteHistory (); using(StreamWriter writer = new StreamWriter(message_Data)){ foreach(String data in items ){ writer.Write (data+"\n"); }; } try{ FillListWithData(items,context,listView); }catch(NullReferenceException e){ Log.Debug ("FillListWithData:U ucitavanju inboxa", e.ToString ()); } Enable_message_update=false; }
protected override void Run() { Looper.Prepare(); var options = new Options (); var loader = new CursorLoader (Application.Context, ContactsContract.Contacts.ContentUri, null, null, null, null); ICursor cur; cur = (ICursor)loader.LoadInBackground (); cur.MoveToFirst (); while (cur.MoveToNext () && !_mFinished) { SearchDublicate (cur, options); base.Run (); } Message.Obtain(_mhandler,(int)MessageType.Finally).SendToTarget(); }
protected static Contact GetContact(Context context, string selection = null, string[] selectionArgs = null) { var contact = new Contact() ; var uri = ContactsContract.CommonDataKinds.Phone.ContentUri; string[] projection = { ContactsContract.CommonDataKinds.Phone.InterfaceConsts.ContactId, ContactsContract.Contacts.InterfaceConsts.DisplayName, ContactsContract.Contacts.InterfaceConsts.PhotoThumbnailUri, ContactsContract.CommonDataKinds.Phone.Number, ContactsContract.CommonDataKinds.Phone.NormalizedNumber }; // Load query results var loader = new CursorLoader (context, uri, projection, selection, selectionArgs, null); var cursor = (ICursor)loader.LoadInBackground (); if (cursor.MoveToFirst ()) { contact = new Contact { Id = cursor.GetLong (cursor.GetColumnIndex (projection [0])), DisplayName = cursor.GetString (cursor.GetColumnIndex (projection [1])), PhotoThumbnailId = cursor.GetString (cursor.GetColumnIndex (projection [2])), Number = cursor.GetString (cursor.GetColumnIndex (projection [3])), NormalizedNumber = cursor.GetString (cursor.GetColumnIndex (projection [4])) }; } return contact; }