private void Btndeletemastergp_Click(object sender, EventArgs e)
{
string dpPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "accounts.sqlite");
var db = new SQLiteConnection(dpPath);
var subitem = new SubAccountTable();
subitem.MId = Convert.ToInt32(txtviewid.Text);
var data_s = db.Query <SubAccountTable>("select * from SubAccountTable where mid=" + Convert.ToInt32(txtviewid.Text));
if (data_s.Count > 0)
{
Toast.MakeText(this, "Record Will not deleted as Sub A/c Exists...,", ToastLength.Short).Show();
}
else
{
var item = new MasterTable();
item.Id = Convert.ToInt32(txtviewid.Text);
var data = db.Delete(item);
Toast.MakeText(this, "Record Deleted Successfully...,", ToastLength.Short).Show();
txtmastergp.Text = "";
load_spiner_master();
}
}
private void Btndeletesubmastergp_Click(object sender, EventArgs e)
{
var item = new SubAccountTable();
item.Id = Convert.ToInt32(txtsubmasterid.Text);
string dpPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "accounts.sqlite");
var db = new SQLiteConnection(dpPath);
var data = db.Delete(item);
Toast.MakeText(this, "Record Deleted Successfully...,", ToastLength.Short).Show();
txtsubmastergpname.Text = "";
load_spiner_master();
load_spiner_sub_master();
}
private void Btnsavesubmastergp_Click(object sender, EventArgs e)
{
string dpPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "accounts.sqlite");
var db = new SQLiteConnection(dpPath);
db.CreateTable <SubAccountTable>();
SubAccountTable tbl = new SubAccountTable();
tbl.subaccountname = Convert.ToString(txtsubmastergpname.Text);
tbl.MId = Convert.ToInt32(txtmasterid.Text);
db.Insert(tbl);
Toast.MakeText(this, "Record Added Successfully...,", ToastLength.Short).Show();
txtsubmastergpname.Text = "";
load_spiner_master();
load_spiner_sub_master();
}
