MainActivity.cs

﻿using System;
using System.Linq;
using System.Collections.Generic;
using Android.App;
using Android.Content;
using Android.Runtime;
using Android.Views;
using Android.Widget;
using Android.OS;
using System.Net;
using System.Threading.Tasks;
using System.Json;
using System.IO;
using Android.Database.Sqlite;

namespace ListViewSample
{
	[Activity (Label = "ListViewSample", MainLauncher = true, Icon = "@drawable/icon")]
	public class MainActivity : ListActivity
	{
		private string url = "http://learnresfull-restcall.rhcloud.com/restaurent/";

		List<TableItem> items = new List<TableItem> ();
		ProgressDialog progress;
		private EmployeeDatabase sqldb;
		protected override void OnCreate (Bundle bundle)
		{
			base.OnCreate(bundle);

			progress = new ProgressDialog(this);

			sqldb = new EmployeeDatabase("employee_db");

			progress.Indeterminate = true;
			progress.SetProgressStyle(ProgressDialogStyle.Spinner);
			progress.SetMessage("Contacting server. Please wait...");
			progress.SetCancelable(false);
			progress.Show();
			Android.Database.ICursor sqldb_cursor = sqldb.GetRecordCursor ();
			if (sqldb_cursor.Count > 0) {
				populateListFromDB (sqldb_cursor);
			} else {
				createListView ();
			}
		}

		protected override void OnListItemClick(ListView l, View v, int position, long id)
		{
			var selected_employee = items[position];

			//Android.Widget.Toast.MakeText(this, t.Heading, Android.Widget.ToastLength.Short).Show();

			Console.WriteLine ("******  {0} ******" , selected_employee.Id);

			Intent intent = new Intent(this, typeof(EmployeeDetailActivity));
			intent.PutExtra ("emp_id", selected_employee.Id);
			StartActivity(intent);
		}

		/*  // Sample data to test list view
		private List<TableItem> createSampleData (int range){

			var itemsList = new List<TableItem>();

			for (int r = 0; r < range; r++) {

				var items = new TableItem {

					Heading = string.Format("Item 1 {0}", r) , 
					SubHeading = string.Format("Item Description {0}", r)
				};
				itemsList.Add (items);
			}
			return itemsList;

		}
		*/

		public  void createListView()
		{
			var itemsList = new List<TableItem>();
			var httpReq = (HttpWebRequest)HttpWebRequest.Create (new Uri (url));
			httpReq.BeginGetResponse ((ar) => {
				var request = (HttpWebRequest)ar.AsyncState;

				using (var response = (HttpWebResponse)request.EndGetResponse (ar)) {

					var s = response.GetResponseStream ();

					var j = (JsonArray)JsonArray.Load (s);

					for (int r = 0; r < j.Count; r++) {
						var obj = j[r];
						// Writing Employee record in database
						var employee = new Employee {
							Id = obj["id"] , 
							Title = obj["title"],
							Email = obj["email"],
							City = obj["city"],
							Picture = obj["picture"],
							ImageDownloadPath = obj["imageDownloadPath"],
							ReportCount = obj["reportCount"],
							FName = obj["firstName"],
							LName = obj["lastName"],
							ManagerId = obj["managerId"],
							Department = obj["department"],
							OfficePhone = obj["officePhone"],
							CellPhone = obj["cellPhone"]
						};

						sqldb.AddRecord (employee);

						Console.WriteLine("-------  {0}  --------",sqldb.Message);

					}

					RunOnUiThread (() => {
						populateListFromDB(sqldb.GetRecordCursor ());
					});
	
				}

			}, httpReq);
		

	}

		private  void populateListFromDB(Android.Database.ICursor sqldb_cursor){


			if (sqldb_cursor != null) 
			{

				sqldb_cursor.MoveToFirst();
				do {
					var itm = new TableItem {
						Id = sqldb_cursor.GetString(0),
						Heading = sqldb_cursor.GetString(1) , 
						SubHeading = sqldb_cursor.GetString(2),
						DownloadUrl = sqldb_cursor.GetString(3),
						ImageName = sqldb_cursor.GetString(4)
					};
					items.Add (itm);
				} while (sqldb_cursor.MoveToNext());

			}
			progress.Dismiss();
			ListAdapter = new HomeScreenAdapter(this, items);
			ListView.FastScrollEnabled = true;
		}
	}
}