private void btn_Save(object sender, RoutedEventArgs e) { if (tb_OpeningBalance.Text == "" || tb_Sale.Text == "" || tb_Delivery.Text == "" || tb_TotalSale.Text == "" || tb_TotalCash.Text == "" || tb_Deposit.Text == "" || tb_Expence.Text == "" || tb_ClosingBalance.Text == "") { AutoClosingMessageBox.Show("Please Fill all fields", "Alert", 2000); } else { try { tbl_FinanceChart fc = new tbl_FinanceChart(); fc.Date = DateTime.Now; fc.OpeningBalance = Convert.ToInt32(tb_OpeningBalance.Text); fc.Sale = Convert.ToInt32(tb_Sale.Text); fc.Delivery = Convert.ToInt32(tb_Delivery.Text); fc.TotalSale = Convert.ToInt32(tb_TotalSale.Text); fc.TotalCash = Convert.ToInt32(tb_TotalCash.Text); fc.Deposit = Convert.ToInt32(tb_Deposit.Text); fc.Expence = Convert.ToInt32(tb_Expence.Text); fc.ClosingBalance = Convert.ToInt32(tb_ClosingBalance.Text); FinanceChart.insert(fc); Close(); AutoClosingMessageBox.Show("Closings saved", "Success", 2000); } catch { AutoClosingMessageBox.Show("Please try again", "Fail", 2000); } } }
public static void insert(tbl_FinanceChart fc) { RMSDBEntities db = DBContext.getInstance(); db.tbl_FinanceChart.Add(fc); db.SaveChanges(); }
public static int getLastDayClosingBalance() { RMSDBEntities db = DBContext.getInstance(); tbl_FinanceChart fc = db.tbl_FinanceChart.OrderByDescending(a => a.Id).FirstOrDefault(); if (fc == null) { return(0); } else { int i = Convert.ToInt32(fc.ClosingBalance); return(i); } }