protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
Xamarin.Essentials.Platform.Init(this, savedInstanceState);
SetContentView(Resource.Layout.layout1);
lstdata = FindViewById <ListView>(Resource.Id.listView1);
db.CreateDB();
var editname = FindViewById <EditText>(Resource.Id.EmployeeName);
var editid = FindViewById <EditText>(Resource.Id.EmployeeID);
var editprofile = FindViewById <EditText>(Resource.Id.Profile);
var btnadd = FindViewById <Button>(Resource.Id.AddButton);
var btndelete = FindViewById <Button>(Resource.Id.DeleteButton);
var btnedit = FindViewById <Button>(Resource.Id.EditButton);
Console.WriteLine("Data in db are");
disp = db.SelectTable();
foreach (var s in disp)
{
Console.WriteLine(s.id + s.employeeid + s.name);
}
LoadData();
btnadd.Click += delegate
{
Employee employee = new Employee()
{
name = editname.Text, employeeid = editid.Text, Profile = editprofile.Text
};
insertflag = db.InsertData(employee);
Console.WriteLine("inserted the data" + insertflag);
editname.Text = ""; editid.Text = ""; editprofile.Text = "";
LoadData();
};
btndelete.Click += delegate
{
Employee employee = new Employee()
{
name = editname.Text, employeeid = editid.Text, Profile = editprofile.Text
};
deleteflag = db.DeleteCell(employee);
Console.WriteLine("deleted the data" + deleteflag);
LoadData();
};
btnedit.Click += delegate
{
Employee employee = new Employee()
{
name = editname.Text, employeeid = editid.Text, Profile = editprofile.Text
};
editflag = db.UpdateTable(employee);
LoadData();
};
lstdata.ItemClick += (s, e) =>
{
//for (int i = 0; i < lstdata.Count; i++)
//{
//if (e.Position == i)
// lstdata.GetChildAt(e.Position).SetBackgroundColor(Android.Graphics.Color.DarkGray);
// else
//lstdata.GetChildAt(i).SetBackgroundColor(Android.Graphics.Color.Transparent);
//}
var textname = e.View.FindViewById <TextView>(Resource.Id.Textname);
var emp = db.SelectCell(textname.Text);
editname.Text = emp.name;
editid.Text = emp.employeeid;
editprofile.Text = emp.Profile;
Console.WriteLine(textname.Text);
Console.WriteLine(emp.id + emp.name + emp.employeeid);
};
void LoadData()
{
lstsource = db.SelectTable();
var adapter = new ListViewAdapter(this, lstsource);
lstdata.Adapter = adapter;
}
}
