public void CreateExpenseGroup(Expense entity)
{
try
{
var dataProvider = new ExpenseProvider(_context);
dataProvider.Create(entity);
dataProvider.Commit();
if (entity.ExpenseId == 0)
{
entity.ExpenseId = dataProvider.GetGroupByKey(entity.PropertyCode, entity.Category, entity.ExpenseDate.Value);
}
if (entity.ExpenseId > 0)
{
entity.ParentId = entity.ExpenseId;
dataProvider.Update(entity.ExpenseId, entity);
dataProvider.Commit();
}
}
catch
{
throw;
}
}
public int UpdateCombinedExpense(int sourceId, int targetId)
{
try
{
var dataProvider = new ExpenseProvider(_context);
var entity = _context.Expenses.Where(x => x.ExpenseId == sourceId).FirstOrDefault();
int originalParentId = entity.ParentId;
float originalAmount = entity.ExpenseAmount;
entity.ParentId = targetId;
dataProvider.Update(sourceId, entity);
dataProvider.Commit();
// update original expense total
if (originalParentId != sourceId)
{
var totalAmount = _context.Expenses.Where(x => x.ParentId == originalParentId && x.ExpenseId != originalParentId)
.Select(x => x.ExpenseAmount)
.Sum();
var sourceEntity = _context.Expenses.Where(x => x.ExpenseId == originalParentId).FirstOrDefault();
if (sourceEntity != null)
{
sourceEntity.ExpenseAmount = totalAmount;
dataProvider.Update(originalParentId, sourceEntity);
}
}
if (sourceId != targetId)
{
var totalAmount = _context.Expenses.Where(x => x.ParentId == targetId && x.ExpenseId != targetId)
.Select(x => x.ExpenseAmount)
.Sum();
var targetEntity = _context.Expenses.Where(x => x.ExpenseId == targetId).FirstOrDefault();
if (targetEntity != null)
{
targetEntity.ExpenseAmount = totalAmount;
dataProvider.Update(targetId, targetEntity);
}
}
dataProvider.Commit();
return(sourceId);
}
catch
{
return(-1);
}
}
// Replaced by stored precedure version MoveWorkflowAll above due to performance issue using Entity Framework for bulk db operation
public RevenueApprovalStatus?BacktrackWorkflowAll(DateTime month, string propertyCode, RevenueApprovalStatus state)
{
try
{
var provider = new ExpenseProvider(_context);
DateTime startDate = new DateTime(month.Year, month.Month, 1);
DateTime endDate = new DateTime(month.Year, month.Month, DateTime.DaysInMonth(month.Year, month.Month));
var expenses = provider.RetrieveCombinedExpenses(startDate, endDate, propertyCode);
var prevState = PrevState(state);
if (expenses != null && prevState != null)
{
foreach (var expense in expenses)
{
if (expense.ApprovalStatus >= prevState)
{
expense.ApprovalStatus = prevState.Value;
RetrackWorkflowSignature(expense, state);
provider.Update(expense.ExpenseId, expense);
}
}
provider.Commit();
return(prevState);
}
}
catch
{
throw;
}
return(null);
}
public bool SetFieldStatus(int expenseId, string fieldname, bool included)
{
try
{
var provider = new ExpenseProvider(_context);
var entity = provider.Retrieve(expenseId);
if (entity != null)
{
if (fieldname == "IncludeOnStatement")
{
entity.IncludeOnStatement = included;
provider.Update(entity.ExpenseId, entity);
provider.Commit();
return(true);
}
else // not supported field; just ignore for now...
{
return(true);
}
}
}
catch
{
throw;
}
return(false);
}
public RevenueApprovalStatus?BacktrackWorkflow(int expenseId, RevenueApprovalStatus state)
{
try
{
var dataProvider = new ExpenseProvider(_context);
var entity = dataProvider.Retrieve(expenseId);
var prevState = PrevState(state);
if (entity != null && prevState != null)
{
entity.ApprovalStatus = prevState.Value;
RetrackWorkflowSignature(entity, state);
dataProvider.Update(expenseId, entity);
dataProvider.Commit();
return(prevState);
}
}
catch
{
throw;
}
return(null);
}
public RevenueApprovalStatus?MoveWorkflow(int expenseId, RevenueApprovalStatus state)
{
try
{
var dataProvider = new ExpenseProvider(_context);
var entity = dataProvider.Retrieve(expenseId);
var nextState = NextState(state);
if (entity != null && nextState != null)
{
entity.ApprovalStatus = state;
SetWorkflowSignature(entity, state);
dataProvider.Update(expenseId, entity);
dataProvider.Commit();
return(nextState);
}
}
catch
{
throw;
}
return(null);
}
