//Adds a new record with the given parameters public void AddRecord(Employee emp) { try { //sqldb_query = "INSERT INTO Employee (Name, LastName, Age) VALUES ('" + sName + "','" + sLastName + "'," + iAge + ");"; sqldb_query = "INSERT INTO Employee (Id, Title, Email, City, Picture, ImageUrl, ReportCount, FName, LName, ManagerId, Department, OfficePhone, CellPhone) VALUES ('" + emp.Id + "','" + emp.Title + "','" + emp.Email + "','" + emp.City + "','" + emp.Picture + "','" + emp.ImageDownloadPath + "','" + emp.ReportCount + "','" + emp.FName + "','" + emp.LName + "','" + emp.ManagerId + "','" + emp.Department + "','" + emp.OfficePhone + "','" + emp.CellPhone + "');"; sqldb.ExecSQL(sqldb_query); sqldb_message = "Record saved"; } catch(SQLiteException ex) { sqldb_message = ex.Message; } }
/* // 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); }