public Task LoadAssignmentFromHistory (AssignmentHistory assignmentHistory)
{
return service
.GetAssignmentFromHistory (assignmentHistory)
.ContinueOnCurrentThread (t => {
PastAssignment = t.Result.FirstOrDefault ();
PastAssignment.IsHistory = true;
return t.Result;
});
}
public Task <List <Assignment> > GetAssignmentFromHistory(AssignmentHistory assignmentHistory, CancellationToken cancellationToken = default(CancellationToken))
{
return(Database.GetConnection(cancellationToken)
.QueryAsync <Assignment> (@"
select Assignment.*,
(SELECT SUM(Labor.Ticks) FROM Labor WHERE Assignment.Id = Labor.AssignmentId) as TotalTicks,
(SELECT COUNT(AssignmentItem.Id) FROM AssignmentItem WHERE Assignment.Id = AssignmentItem.AssignmentId) AS TotalItems,
(SELECT SUM(Expense.Cost) FROM Expense WHERE Assignment.Id = Expense.AssignmentId) AS TotalExpenses
from Assignment
where Assignment.Id = ?
", assignmentHistory.AssignmentId));
}
public SummaryHistoryActivity ()
{
historyViewModel = ServiceContainer.Resolve<HistoryViewModel> ();
itemViewModel = ServiceContainer.Resolve<ItemViewModel> ();
laborViewModel = ServiceContainer.Resolve<LaborViewModel> ();
photoViewModel = ServiceContainer.Resolve<PhotoViewModel> ();
expenseViewModel = ServiceContainer.Resolve<ExpenseViewModel> ();
documentViewModel = ServiceContainer.Resolve<DocumentViewModel> ();
menuViewModel = ServiceContainer.Resolve<MenuViewModel> ();
assignmentHistory = historyViewModel.SelectedAssignmentHistory;
}
/// <summary>
/// Sets up the history record for this cell
/// </summary>
public void SetHistory (AssignmentHistory history, bool enabled)
{
//Any 1-time settings
if (!loaded) {
number.TextColor =
length.TextColor =
description.TextColor =
date.TextColor = Theme.LabelColor;
phone.IconImage = Theme.IconPhone;
phoneIcon.Image = Theme.IconPhoneDark;
address.IconImage = Theme.Map;
address.UserInteractionEnabled = false;
loaded = true;
}
SelectionStyle = history.Type == AssignmentHistoryType.PhoneCall || !enabled ? UITableViewCellSelectionStyle.None : UITableViewCellSelectionStyle.Blue;
date.Text = history.Date.ToShortDateString ();
phone.TopLabel.Text = history.ContactName;
phone.BottomLabel.Text = history.ContactPhone;
if (history.Type == AssignmentHistoryType.PhoneCall) {
number.Hidden =
address.Hidden = true;
length.Hidden =
description.Hidden =
phoneIcon.Hidden = false;
length.Text = "Length: " + history.CallLength.ToString ();
description.Text = history.CallDescription;
} else {
number.Hidden =
address.Hidden = false;
length.Hidden =
description.Hidden =
phoneIcon.Hidden = true;
number.Text = "#" + history.JobNumber;
address.TopLabel.Text = history.Address;
address.BottomLabel.Text = string.Format ("{0}, {1} {2}", history.City, history.State, history.Zip);
}
title.Text = history.CompanyName;
}
public Task<List<Assignment>> GetAssignmentFromHistory (AssignmentHistory assignmentHistory, CancellationToken cancellationToken)
{
return Task.Factory.StartNew (() => new List<Assignment> { new Assignment { Id = assignmentHistory.AssignmentId } });
}
public Task<List<Assignment>> GetAssignmentFromHistory (AssignmentHistory assignmentHistory, CancellationToken cancellationToken = default(CancellationToken))
{
return Database.GetConnection (cancellationToken)
.QueryAsync<Assignment> (@"
select Assignment.*,
(SELECT SUM(Labor.Ticks) FROM Labor WHERE Assignment.Id = Labor.AssignmentId) as TotalTicks,
(SELECT COUNT(AssignmentItem.Id) FROM AssignmentItem WHERE Assignment.Id = AssignmentItem.AssignmentId) AS TotalItems,
(SELECT SUM(Expense.Cost) FROM Expense WHERE Assignment.Id = Expense.AssignmentId) AS TotalExpenses
from Assignment
where Assignment.Id = ?
", assignmentHistory.AssignmentId);
}
