public void Update(ExpenseEntryBO expenseEntryBo, int expenseIdForUpdate)
{
string queryStringIns = "";
CommonBAL cmnBAL = new CommonBAL();
queryStringIns = @"UPDATE SBP_Expense_Lookup
SET [Category_ID] =" + expenseEntryBo.Category_ID
+ ",[Expense_Description] = '" + expenseEntryBo.Expense_Description + "'"
+ ",[Frequency_ID] = " + expenseEntryBo.Expense_Frequency
+ ",[Update_Date] = '" + cmnBAL.GetCurrentServerDate().ToShortDateString() + "'"
+ " WHERE Expense_ID=" + expenseIdForUpdate;
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ExecuteNonQuery(queryStringIns);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
public void SaveExpense(ExpenseEntryBO expenseEntryBo)
{
string queryString = "";
CommonBAL cmnBAL = new CommonBAL();
queryString =
@"INSERT INTO SBP_Expense_Lookup
(
[Category_ID]
,[Expense_Description]
,[Frequency_ID]
,[Update_Date]
,[Expense_Type_ID]
)
VALUES
("
+ expenseEntryBo.Category_ID
+ ",'" + expenseEntryBo.Expense_Description
+ "'," + expenseEntryBo.Expense_Frequency
+ ",'" + cmnBAL.GetCurrentServerDate().ToShortDateString()
+ @",( Select b.Category_Type_ID
From dbo.SBP_Expense_Category_Lookup as b Where b.Category_ID=" + expenseEntryBo.Category_ID + @")"
+ "')";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ExecuteNonQuery(queryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
