public bool updateEntityStatus()
{
EntitySummaryContract entityStatus = new EntitySummaryContract();
var query = (from entitySummary in orgMaintEntitiesContext.EntitySummaries select entitySummary).FirstOrDefault();
if (query == null)
{
EntitySummary newEntitySummary = new EntitySummary();
entityStatus.TotalEntities = newEntitySummary.TotalEntities = 0;
entityStatus.TotalEntitiesAllocable = newEntitySummary.TotalEntitiesAllocable = 00;
entityStatus.TotalEntitiesUnallocated = newEntitySummary.TotalEntitiesUnallocated = 00;
entityStatus.DateUpdated = newEntitySummary.DateUpdated = DateTime.Now;
entityStatus.DateUpdatedString = newEntitySummary.DateUpdated.ToShortDateString();
orgMaintEntitiesContext.EntitySummaries.Add(newEntitySummary);
orgMaintEntitiesContext.SaveChanges();
query = newEntitySummary;
}
query.TotalEntities = 0;
query.TotalEntitiesAllocable = 00;
query.TotalEntitiesAllocated = 0;
query.TotalEntitiesUnallocated = 00;
query.DateUpdated = DateTime.Now;
List<EntityFinanceSummaryContract> entityList = GetEntitySummaryList();
decimal budgetAvailable = 0;
var query2 = (from budgetStatusSingle in orgMaintEntitiesContext.BudgetStatus select budgetStatusSingle).FirstOrDefault();
if (query2 == null)
{
BudgetStatu budgStatu = new BudgetStatu();
budgStatu.BudgetAvailable = 0;
budgStatu.BudgetAllocated = 0;
budgStatu.BudgetRequired = 00;
budgStatu.DateUpdated = DateTime.Now;
orgMaintEntitiesContext.BudgetStatus.Add(budgStatu);
}
else
budgetAvailable = query2.BudgetAvailable;
foreach (EntityFinanceSummaryContract entityElement in entityList)
{
query.TotalEntities += 1;
if (entityElement.BudgetAllocated > 0)
query.TotalEntitiesAllocated += 1;
else if (budgetAvailable > 0)
query.TotalEntitiesAllocable += 1;
budgetAvailable -= entityElement.BudgetRequired;
}
if (budgetAvailable < 0)
{
query2.BudgetRequired = -1 * budgetAvailable;
}
query.TotalEntitiesUnallocated = query.TotalEntities - (query.TotalEntitiesAllocable + query.TotalEntitiesAllocated);
orgMaintEntitiesContext.SaveChanges();
return true;
}
public EntitySummaryContract GetEntityStatus()
{
EntitySummaryContract entityStatus = new EntitySummaryContract();
var query = (from entitySummary in orgMaintEntitiesContext.EntitySummaries select entitySummary).FirstOrDefault();
if (query == null)
{
EntitySummary newEntitySummary = new EntitySummary();
entityStatus.TotalEntities = newEntitySummary.TotalEntities = 0;
entityStatus.TotalEntitiesAllocable = newEntitySummary.TotalEntitiesAllocable = 00;
entityStatus.TotalEntitiesUnallocated = newEntitySummary.TotalEntitiesUnallocated = 00;
entityStatus.DateUpdated = newEntitySummary.DateUpdated = DateTime.Now;
entityStatus.DateUpdatedString = newEntitySummary.DateUpdated.ToShortDateString();
orgMaintEntitiesContext.EntitySummaries.Add(newEntitySummary);
orgMaintEntitiesContext.SaveChanges();
}
entityStatus.TotalEntities = query.TotalEntities;
entityStatus.TotalEntitiesAllocable = query.TotalEntitiesAllocable;
entityStatus.TotalEntitiesAllocated = query.TotalEntitiesAllocated;
entityStatus.TotalEntitiesUnallocated = query.TotalEntitiesUnallocated;
entityStatus.DateUpdated = query.DateUpdated;
entityStatus.DateUpdatedString = query.DateUpdated.ToShortDateString();
return entityStatus;
}
public EntitySummaryContract GetEntityStatusMixed()
{
EntitySummaryContract entityStatus = new EntitySummaryContract();
var query = (from entitySummary in orgMaintEntitiesContext.EntitySummaries select entitySummary).FirstOrDefault();
if (query == null)
{
EntitySummary newEntitySummary = new EntitySummary();
entityStatus.TotalEntities = newEntitySummary.TotalEntities = 0;
entityStatus.TotalEntitiesAllocable = newEntitySummary.TotalEntitiesAllocable = 00;
entityStatus.TotalEntitiesUnallocated = newEntitySummary.TotalEntitiesUnallocated = 00;
entityStatus.DateUpdated = newEntitySummary.DateUpdated = DateTime.Now;
entityStatus.DateUpdatedString = newEntitySummary.DateUpdated.ToShortDateString();
orgMaintEntitiesContext.EntitySummaries.Add(newEntitySummary);
orgMaintEntitiesContext.SaveChanges();
}
else
{
List<EntityFinanceSummaryContract> entityList = GetEntitySummaryList();
decimal budgetAvailable = 0 ;
var query2 = (from budgetStatusSingle in orgMaintEntitiesContext.BudgetStatus select budgetStatusSingle).FirstOrDefault();
if (query2 == null)
{
BudgetStatu budgStatu = new BudgetStatu();
budgStatu.BudgetAvailable = 0;
budgStatu.BudgetAllocated = 0;
budgStatu.BudgetRequired = 00;
budgStatu.DateUpdated = DateTime.Now;
orgMaintEntitiesContext.BudgetStatus.Add(budgStatu);
}
else
budgetAvailable = query2.BudgetAvailable;
foreach(EntityFinanceSummaryContract entityElement in entityList)
{
query.TotalEntities += 1;
if (entityElement.BudgetAllocated > 0)
query.TotalEntitiesAllocated += 1;
else if (budgetAvailable > 0)
query.TotalEntitiesAllocable += 1;
budgetAvailable -= entityElement.BudgetRequired;
}
if (budgetAvailable < 0)
{
query2.BudgetRequired = -1 * budgetAvailable;
}
/*
var query = (from budgetStatusSingle in orgMaintEntitiesContext.BudgetStatus select budgetStatusSingle).FirstOrDefault();
if (query == null)
{
BudgetStatu budgStatu = new BudgetStatu();
budgStatu.BudgetAvailable = newContributorRecord.ConvertedAmount;
budgStatu.BudgetAllocated = 0;
budgStatu.BudgetRequired = 00;
budgStatu.DateUpdated = DateTime.Now;
orgMaintEntitiesContext.BudgetStatus.Add(budgStatu);
}
else
{
query.BudgetAvailable += newContributorRecord.ConvertedAmount;
query.DateUpdated = (DateTime)(DateTime)(newContributorRecord.DateDeposited == null ? DateTime.Now : newContributorRecord.DateDeposited);
}
entityStatus.TotalEntities = 0;
entityStatus.TotalEntitiesAllocable = 0;
entityStatus.TotalEntitiesAllocated = 0;
entityStatus.TotalEntitiesUnallocated = 0;
var budgetStatus = BudgetStatusService.getBudgetStatus();
var budgetAvailable = budgetStatus.BudgetAvailable;
var totalBudgetRequired = 0;
for (i = 0; i < entityList.length; i++) {
entityStatus.TotalEntities += 1;
if (entityList[i].BudgetAllocated > 0)
entityStatus.TotalEntitiesAllocated += 1;
else if (budgetAvailable > 0)
entityStatus.TotalEntitiesAllocable += 1;
budgetAvailable -= entityList[i].BudgetRequired;
}
if (budgetAvailable < 0) {
budgetStatus.BudgetRequired = -1 * budgetAvailable;
BudgetStatusService.updateBudgetStatus(budgetStatus);
}
// if ($localStorage.debugMode == true) alert(entityStatus.TotalEntities); if ($localStorage.debugMode == true) alert(entityStatus.TotalEntitiesAllocated); if ($localStorage.debugMode == true) alert(entityStatus.TotalEntitiesAllocable);
if (entityStatus.TotalEntities > (entityStatus.TotalEntitiesAllocated + entityStatus.TotalEntitiesAllocable))
entityStatus.TotalEntitiesUnallocated = entityStatus.TotalEntities - (entityStatus.TotalEntitiesAllocated + entityStatus.TotalEntitiesAllocable);
return entityStatus;
*/
entityStatus.TotalEntities = query.TotalEntities;
entityStatus.TotalEntities = query.TotalEntitiesAllocable;
entityStatus.TotalEntitiesAllocated = query.TotalEntitiesAllocated;
entityStatus.TotalEntitiesUnallocated = query.TotalEntitiesUnallocated;
entityStatus.DateUpdated = query.DateUpdated;
entityStatus.DateUpdatedString = query.DateUpdated.ToShortDateString();
}
return entityStatus;
}
