public void CreateTransaction(Transaction t) { var tResult = db.Database.SqlQuery<Transaction>("EXEC CreateTransaction @amount, @date, @accountId, @categoryId, @description", new SqlParameter("amount", t.Amount), new SqlParameter("date", t.Date), new SqlParameter("accountId", t.AccountId), new SqlParameter("categoryId", t.CategoryId), new SqlParameter("description", t.Description) ); }
public void EditTransaction(Transaction t) { var tResult = db.Database.SqlQuery<Transaction>("EXEC EditTransaction @name, @amount, @categoryId, @date, @description, @status, @transactionId", new SqlParameter("amount", t.Amount), new SqlParameter("categoryId", t.CategoryId), new SqlParameter("date", t.Date), new SqlParameter("description", t.Description), new SqlParameter("status", t.Status), new SqlParameter("transactionId", t.Id) ); }