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