public int Edit(Entity.Expense expense, String Id) { String Query = "Update Expense Set CATEGORY='" + expense.ExpenseCategory + "',DESCRIPTION='" + expense.ExpenseDescription + "',AMOUNT=" + expense.ExpenseAmount + ",DATE='" + expense.ExpenseDate + "' Where ID='" + Id + "'"; return(DataAccess.ExecuteQuery(Query)); }
public int Add(Entity.Expense expense) { String Query = "INSERT into Expense values ('" + expense.ExpenseId + "','" + expense.ExpenseCategory + "','" + expense.ExpenseDescription + "'," + expense.ExpenseAmount + ",'" + expense.ExpenseDate + "')"; return(DataAccess.ExecuteQuery(Query)); }