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