public void loadIncomeExpenditure()
{
try
{
LoanDSTableAdapters.IncomeExpenseTableAdapter incomeExpenditure = new LoanDSTableAdapters.IncomeExpenseTableAdapter();
LoanDS.IncomeExpenseDataTable tblincomeExpenditure = incomeExpenditure.GetIncomeExpense(MySessionManager.ClientID, MySessionManager.AppID);
if (tblincomeExpenditure.Rows.Count > 0)
{
txtBusinessSurplus.Value = tblincomeExpenditure[0].datBusinessSurplus.ToString();
txtIncome.Value = tblincomeExpenditure[0].datIncome.ToString();
txtOtherIncome.Value = tblincomeExpenditure[0].datOtherIncome.ToString();
txtRentUtil.Value = tblincomeExpenditure[0].datRent.ToString();
txtStaff.Text = tblincomeExpenditure[0].datStaff.ToString();
txtTransport.Text = tblincomeExpenditure[0].datTransport.ToString();
txtPayment.Value = tblincomeExpenditure[0].datPayments.ToString();
txthealth.Text = tblincomeExpenditure[0].datHealth.ToString();
txtEducation.Text = tblincomeExpenditure[0].datEducation.ToString();
txtClothing.Value = tblincomeExpenditure[0].datClothing.ToString();
txtCharity.Value = tblincomeExpenditure[0].datCharity.ToString();
txtUnexpected.Value = tblincomeExpenditure[0].datUnexpected.ToString();
txtOthers.Value = tblincomeExpenditure[0].datOthers.ToString();
txtEntertainment.Value = tblincomeExpenditure[0].datEntertainment.ToString();
txtFood.Text = tblincomeExpenditure[0].datFood.ToString();
}
}
catch
{}
}
public void loadIncomeExpenditure()
{
try
{
LoanDSTableAdapters.IncomeExpenseTableAdapter incomeExpenditure = new LoanDSTableAdapters.IncomeExpenseTableAdapter();
LoanDS.IncomeExpenseDataTable tblincomeExpenditure = incomeExpenditure.GetIncomeExpense(MySessionManager.ClientID, MySessionManager.AppID);
if(tblincomeExpenditure.Rows.Count>0)
{
txtBusinessSurplus.Value = tblincomeExpenditure[0].datBusinessSurplus.ToString();
txtIncome.Value = tblincomeExpenditure[0].datIncome.ToString();
txtOtherIncome.Value = tblincomeExpenditure[0].datOtherIncome.ToString();
txtRentUtil.Value = tblincomeExpenditure[0].datRent.ToString();
txtStaff.Text = tblincomeExpenditure[0].datStaff.ToString();
txtTransport.Text = tblincomeExpenditure[0].datTransport.ToString();
txtPayment.Value = tblincomeExpenditure[0].datPayments.ToString();
txthealth.Text = tblincomeExpenditure[0].datHealth.ToString();
txtEducation.Text = tblincomeExpenditure[0].datEducation.ToString();
txtClothing.Value = tblincomeExpenditure[0].datClothing.ToString();
txtCharity.Value = tblincomeExpenditure[0].datCharity.ToString();
txtUnexpected.Value = tblincomeExpenditure[0].datUnexpected.ToString();
txtOthers.Value = tblincomeExpenditure[0].datOthers.ToString();
txtEntertainment.Value = tblincomeExpenditure[0].datEntertainment.ToString();
txtFood.Text = tblincomeExpenditure[0].datFood.ToString();
}
}
catch
{}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
LoanDSTableAdapters.IncomeExpenseTableAdapter incomeExpenditure = new LoanDSTableAdapters.IncomeExpenseTableAdapter();
incomeExpenditure.InsertIncomeExpenses(MySessionManager.AppID,
MySessionManager.ClientID,
Convert.ToDecimal(txtBusinessSurplus.Value),
Convert.ToDecimal(txtIncome.Value),
Convert.ToDecimal(txtOtherIncome.Value),
Convert.ToDecimal(txtRentUtil.Value),
Convert.ToDecimal(txtFood.Text),
Convert.ToDecimal(txtEducation.Text),
Convert.ToDecimal(txtStaff.Text),
Convert.ToDecimal(txtTransport.Text),
Convert.ToDecimal(txthealth.Text),
Convert.ToDecimal(txtClothing.Value),
Convert.ToDecimal(txtEntertainment.Value),
Convert.ToDecimal(txtCharity.Value),
Convert.ToDecimal(txtPayment.Value),
Convert.ToDecimal(txtOthers.Value),
Convert.ToInt32(txtUnexpected.Value));
}
catch
{ }
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
LoanDSTableAdapters.IncomeExpenseTableAdapter incomeExpenditure = new LoanDSTableAdapters.IncomeExpenseTableAdapter();
incomeExpenditure.InsertIncomeExpenses(MySessionManager.AppID,
MySessionManager.ClientID,
Convert.ToDecimal(txtBusinessSurplus.Value),
Convert.ToDecimal(txtIncome.Value),
Convert.ToDecimal(txtOtherIncome.Value),
Convert.ToDecimal(txtRentUtil.Value),
Convert.ToDecimal(txtFood.Text),
Convert.ToDecimal(txtEducation.Text),
Convert.ToDecimal(txtStaff.Text),
Convert.ToDecimal(txtTransport.Text),
Convert.ToDecimal(txthealth.Text),
Convert.ToDecimal(txtClothing.Value),
Convert.ToDecimal(txtEntertainment.Value),
Convert.ToDecimal(txtCharity.Value),
Convert.ToDecimal(txtPayment.Value),
Convert.ToDecimal(txtOthers.Value),
Convert.ToInt32(txtUnexpected.Value));
}
catch
{ }
}
