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