public void SaveCategory(Expense_CategoryEntryBO categoryEntryBo)
{
string queryString = "";
CommonBAL cmnBAL = new CommonBAL();
queryString =
@"INSERT INTO SBP_Expense_Category_Lookup
([Category_Name]
,[Category_Type_ID]
,[Sub_Category]
,[Update_Date]
)
VALUES
("
+ "'" + categoryEntryBo.Category_Name
+ "'," + categoryEntryBo.Category_Type_ID
+ ",'" + categoryEntryBo.Sub_Category
+ "','" + cmnBAL.GetCurrentServerDate().ToShortDateString()
+ "')";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ExecuteNonQuery(queryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
public void Update(Expense_CategoryEntryBO categoryEntryBo, int CategoryIdForUpdate)
{
string queryStringIns = "";
CommonBAL cmnBAL = new CommonBAL();
queryStringIns = @"UPDATE SBP_Expense_Category_Lookup
SET [Category_Name] ='" + categoryEntryBo.Category_Name + "'"
+ ",[Category_Type_ID] = " + categoryEntryBo.Category_Type_ID
+ ",[Sub_Category] = '" + categoryEntryBo.Sub_Category + "'"
+ ",[Update_Date] = '" + cmnBAL.GetCurrentServerDate().ToShortDateString() + "'"
+ " WHERE Category_ID=" + CategoryIdForUpdate;
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ExecuteNonQuery(queryStringIns);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
