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