//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);
}
