public void BtnSubmit_Click(object sender, EventArgs e)
        {
            MonthlyBills v = new MonthlyBills();

            string TheBill             = "";
            DataClasses1DataContext DC = new DataClasses1DataContext();
            int newmonthlyrows         = DC.MonthlyBills.Count() + 1;
            int dgrowcount             = dgMonthly.RowCount;

            if (newmonthlyrows == dgrowcount)
            {
                MonthlyBill Abill    = new MonthlyBill();
                int         rowindex = dgMonthly.CurrentRow.Index;
                var         update   = from b in DC.MonthlyBills
                                       select b;
                int monthlybillschanged = 0;
                foreach (var row in update)
                {
                    for (int rowz = 0; rowz < dgMonthly.RowCount - 1; rowz++)
                    {
                        TheBill = dgMonthly.Rows[rowz].Cells[0].Value.ToString();
                        if (TheBill == row.BILL)
                        {
                            if (row.COST != Convert.ToSingle(dgMonthly.Rows[rowz].Cells[1].Value) || row.Date != Convert.ToString(dgMonthly.Rows[rowz].Cells[2].Value))
                            {
                                row.COST = Convert.ToSingle(dgMonthly.Rows[rowz].Cells[1].Value);
                                row.Date = Convert.ToString(dgMonthly.Rows[rowz].Cells[2].Value);
                                monthlybillschanged++;
                            }
                        }
                    }
                }
                if (monthlybillschanged > 0)
                {
                    DC.SubmitChanges();
                    MessageBox.Show($"{monthlybillschanged} monthly bill(s) have been updated");
                }
            }
            else if (newmonthlyrows < dgrowcount)
            {
                var         xc       = dgMonthly.Rows[dgrowcount - 1];
                MonthlyBill Abill    = new MonthlyBill();
                int         rowindex = dgMonthly.CurrentRow.Index;
                TheBill    = dgMonthly.Rows[rowindex].Cells[0].Value.ToString();
                Abill.BILL = Convert.ToString(dgMonthly.Rows[rowindex].Cells[0].Value);
                Abill.COST = Convert.ToSingle(dgMonthly.Rows[rowindex].Cells[1].Value);
                Abill.Date = Convert.ToString(dgMonthly.Rows[rowindex].Cells[2].Value);
                DC.MonthlyBills.InsertOnSubmit(Abill);
                DC.SubmitChanges();
                MessageBox.Show($"{Abill.BILL} added to Monthly Bills");
                Refresh();
            }

            else if (newmonthlyrows > dgrowcount)
            {
                int    found      = 0;
                string DeleteBill = "";
                foreach (var fg in DC.MonthlyBills)
                {
                    found = 0;
                    string BillLookup = fg.BILL;
                    foreach (DataGridViewRow dg in dgMonthly.Rows)
                    {
                        string wwww = Convert.ToString(dg.Cells[0].Value);
                        if (BillLookup == wwww)
                        {
                            found = 1;
                            break;
                        }
                        else
                        {
                            continue;
                        }
                    }
                    if (found == 0)
                    {
                        DeleteBill = BillLookup;
                        var delete = from b in DC.MonthlyBills
                                     where b.BILL == DeleteBill
                                     select b;

                        DC.MonthlyBills.DeleteAllOnSubmit(delete);
                        DC.SubmitChanges();
                        MessageBox.Show($"deleted {DeleteBill}");
                        Refresh();
                    }
                }
            }
            float KeyBalanceUpdate;
            DataClasses2DataContext KY = new DataClasses2DataContext();
            KeyBalance KeyB            = new KeyBalance();
            int        rowindexKey     = DatagridKeyBalance.CurrentRow.Index;

            KeyBalanceUpdate = float.Parse(DatagridKeyBalance.Rows[0].Cells[0].Value.ToString());
            KeyBalance BB = KY.KeyBalances
                            .Where(c => c.Placeholder == "X")
                            .Single();

            if (BB.KeyBalance1 != KeyBalanceUpdate)
            {
                BB.DateTime    = DateTime.Now;
                BB.KeyBalance1 = KeyBalanceUpdate;
                KY.SubmitChanges();
                MessageBox.Show("Key Balance Updated");
            }
            string WE = "";
            float  amount;
            DataClasses1DataContext w = new DataClasses1DataContext();
            WeeklyBill we             = new WeeklyBill();
            int        windex         = DataGridWeeklyBIlls.CurrentRow.Index;

            WE     = DataGridWeeklyBIlls.Rows[windex].Cells[0].Value.ToString();
            amount = float.Parse(DataGridWeeklyBIlls.Rows[windex].Cells[1].Value.ToString());
            WeeklyBill wb = w.WeeklyBills
                            .Where(c => c.Bill == WE)
                            .Single();

            if (wb.Cost != amount)
            {
                wb.Cost = amount;
                w.SubmitChanges();
                MessageBox.Show("Weekly BIlls Updated");
            }
            decimal bh;
            string  thename;
            DataClasses1DataContext Bringit = new DataClasses1DataContext();
            BringHomePay            BRHOME  = new BringHomePay();
            int bindex = dgBringHome.CurrentRow.Index;

            thename = dgBringHome.Rows[bindex].Cells[0].Value.ToString();
            bh      = Decimal.Parse(dgBringHome.Rows[bindex].Cells[1].Value.ToString());
            BringHomePay brh = Bringit.BringHomePays
                               .Where(c => c.Name == thename)
                               .Single();

            if (brh.Amount != bh)
            {
                brh.Amount = bh;
                Bringit.SubmitChanges();
                MessageBox.Show("Bring Home Amount Changed");
            }
            formload();
        }
 partial void UpdateKeyBalance(KeyBalance instance);
 partial void DeleteKeyBalance(KeyBalance instance);
 partial void InsertKeyBalance(KeyBalance instance);