public void UpdateApproved(Expense expense)
{
var context = new ExpenseDataContext(this.account);
IExpenseEntity expenseRow = GetExpenseRowById(context, expense.UserName, expense.Id);
expenseRow.Approved = expense.Approved;
var queue = new AzureQueue <ApprovedExpenseMessage>(this.account, AzureStorageNames.ApprovedExpenseMessage);
queue.AddMessage(new ApprovedExpenseMessage {
ExpenseId = expense.Id, ApproveDate = DateTime.UtcNow, Username = expense.UserName
});
context.UpdateObject(expenseRow);
context.SaveChanges();
}
public void UpdateExpenseItemImages(string username, string expenseId, string expenseItemId, string imageUri, string thumbnailUri)
{
var context = new ExpenseDataContext(this.account);
// this query would work faster if we specify PartitionKey and RowKey
// For simplicity we'll just do a table scan by expense item id
var query = (from expenseItemRow in context.ExpenseExpenseItem
where expenseItemRow.PartitionKey == username.EncodePartitionAndRowKey() &&
expenseItemRow.RowKey == KeyGenerator.ExpenseItemEntityRowKey(expenseId, expenseItemId)
select expenseItemRow).AsTableServiceQuery();
var item = query.Execute().SingleOrDefault();
item.ReceiptUrl = imageUri;
item.ReceiptThumbnailUrl = thumbnailUri;
context.UpdateObject(item);
context.SaveChanges();
}
public void UpdateExpenseItemImages(string username, string expenseId, string expenseItemId, string imageUri, string thumbnailUri)
{
var context = new ExpenseDataContext(this.account);
// this query would work faster if we specify PartitionKey and RowKey
// For simplicity we'll just do a table scan by expense item id
var query = (from expenseItemRow in context.ExpenseExpenseItem
where expenseItemRow.PartitionKey == username.EncodePartitionAndRowKey()
&& expenseItemRow.RowKey == KeyGenerator.ExpenseItemEntityRowKey(expenseId, expenseItemId)
select expenseItemRow).AsTableServiceQuery();
var item = query.Execute().SingleOrDefault();
item.ReceiptUrl = imageUri;
item.ReceiptThumbnailUrl = thumbnailUri;
context.UpdateObject(item);
context.SaveChanges();
}
public void UpdateApproved(Expense expense)
{
var context = new ExpenseDataContext(this.account);
IExpenseEntity expenseRow = GetExpenseRowById(context, expense.UserName, expense.Id);
expenseRow.Approved = expense.Approved;
var queue = new AzureQueue<ApprovedExpenseMessage>(this.account, AzureStorageNames.ApprovedExpenseMessage);
queue.AddMessage(new ApprovedExpenseMessage { ExpenseId = expense.Id, ApproveDate = DateTime.UtcNow, Username = expense.UserName });
context.UpdateObject(expenseRow);
context.SaveChanges();
}