public TargetAmount Delete(int goalId)
{
TargetAmount dbEntry = context.TargetAmounts.FirstOrDefault(g => g.ID == goalId);
if (dbEntry != null)
{
context.TargetAmounts.Remove(dbEntry);
context.SaveChanges();
}
return(dbEntry);
}
public ViewResult EditTarget(int id)
{
ViewBag.FormTitle = "Edit Target";
TargetAmount g = _targetAmountRepo.TargetAmounts.Where(x => x.ID == id).FirstOrDefault();
return(View(new TargetFormViewModel
{
Target = g,
TargetTypes = new SelectList(_targetTypeRepo.TargetTypes.ToList(), "ID", "Name")
}));
}
public ViewResult MonthlyReport(DateTime?date)
{
if (date == null)
{
date = DateTime.Now;
}
List <Donation> donations = _repo.Donations.Where(e => e.Date.Month == date.Value.Month && e.Date.Year == date.Value.Year).ToList();
List <PieChartData> data = new List <PieChartData>();
List <Charity> cats = _catRepo.Charities.ToList();
foreach (var cat in cats)
{
data.Add(new PieChartData
{
Category = cat.Name,
Data = Convert.ToString(donations.Where(e => e.CharityID == cat.ID).Select(e => e.Amount).Sum())
});
}
int daysInMonth = DateTime.DaysInMonth(date.Value.Year, date.Value.Month);
List <LineChartData> lineData = new List <LineChartData>();
double sum = 0;
for (int i = 1; i <= daysInMonth; i++)
{
sum += donations.Where(e => e.Date.Day == i).Select(e => e.Amount).Sum();
lineData.Add(new LineChartData
{
XData = i.ToString(),
YData = Convert.ToString(sum)
});
}
List <IncomeEntry> incomes = _incomeRepo.IncomeEntries.Where(i => i.Date.Month == date.Value.Month && i.Date.Year == date.Value.Year).ToList();
TargetAmount donationsGoal = _goalRepo.TargetAmounts.Where(g => g.TargetType.Name.Equals("Charity")).FirstOrDefault();
decimal targetDonationsAmount = Convert.ToDecimal(incomes.Select(i => i.Amount).Sum()) * donationsGoal.Percentage / 100;
return(View(new DonationsListViewModel
{
Donations = donations,
Date = date.Value,
PieChartData = data,
LineChartData = lineData,
Total = Convert.ToDecimal(donations.Select(e => e.Amount).Sum()),
DonationsGoal = targetDonationsAmount,
DonationsPercentage = donationsGoal.Percentage
}));
}
private void LoadTargetDist()
{
try
{
if (TargetID != -1)
{
if (targetAlreadyExists())
{
btnSave.Text = "Edit";
}
else
{
btnSave.Text = "Save";
}
BranchID = getBranchIDfromUser();
SalesBranchTarget salesBranchTarget = getBranchTarget();//must load TargetID and BranchID first
if (salesBranchTarget == null)
{
TargetAmount = 0;
TargetCurrencyID = -1;
}
else
{
TargetAmount = (double)salesBranchTarget.Amount;
TargetCurrencyID = salesBranchTarget.CurrencyID;
}
lblBranchTarget.Text = TargetAmount.ToString();
//string targetIDs = getLast5YearsTargetIDs();
string salesMenIDs = getAllSalesMenIDs();
string salesMenInBranchIDs = getMyBranchSalesMenIDs(salesMenIDs);
DataTable userLastTargets = getLastUserTargets(salesMenInBranchIDs, BranchID);
if (salesMenIDs != "")
{
LoadSalesMenTable(salesMenIDs, userLastTargets);
}
}
else
{
ScriptManager.RegisterStartupScript(Page, typeof(Page),
"NoTarget", "alert('Target is invalid!');", true);
}
}
catch (Exception ex)
{
//Logger.LogException(ex);
}
}
public IViewComponentResult Invoke()
{
DateTime date = DateTime.Now;
List <Donation> donations = _repo.Donations.Where(e => e.Date.Month == date.Month && e.Date.Year == date.Year).ToList();
List <IncomeEntry> incomes = _incomeRepo.IncomeEntries.Where(i => i.Date.Month == date.Month && i.Date.Year == date.Year).ToList();
TargetAmount donationsGoal = _goalRepo.TargetAmounts.Where(g => g.TargetType.Name.Equals("Charity")).FirstOrDefault();
decimal targetDonationsAmount = Convert.ToDecimal(incomes.Select(i => i.Amount).Sum()) * donationsGoal.Percentage / 100;
return(View(new DonationsVsGoalViewModel
{
DonationsTotal = Math.Round(Convert.ToDecimal(donations.Select(e => e.Amount).Sum()), 2),
DonationsGoal = targetDonationsAmount
}));
}
public void CopyFrom(Skill skill)
{
id = skill.id;
displayName = skill.displayName;
cooldown = skill.cooldown;
manaCost = skill.manaCost;
isPassive = skill.isPassive;
icon = skill.icon;
description = skill.description;
targetType = skill.targetType;
targetCount = skill.targetCount;
targetSite = skill.targetSite;
possiblePositions = skill.possiblePositions;
possibleTargets = skill.possibleTargets;
SkillEffects = skill.SkillEffects;
RemainingCooldown = skill.RemainingCooldown;
}
public void Save(TargetAmount g)
{
if (g.ID == 0)
{
context.TargetAmounts.Add(g);
}
else
{
TargetAmount dbEntry = context.TargetAmounts.FirstOrDefault(x => x.ID == g.ID);
if (dbEntry != null)
{
dbEntry.Amount = g.Amount;
dbEntry.Percentage = g.Percentage;
dbEntry.TypeID = g.TypeID;
}
}
context.SaveChanges();
}
public void AddProgress()
{
if (CurrentAmount < TargetAmount)
{
CurrentAmount++;
}
if (TargetAmount != 0)
{
progressText.text = CurrentAmount.ToString() + "/" + TargetAmount.ToString();
}
if (CurrentAmount == TargetAmount) //task is complete
{
QuestManager.Current.DisplayCompleteTask(this);
Completed = true;
canvasGroup.alpha = 0.5f;
}
else if (TargetAmount != 0) //if not complete, just show update
{
QuestManager.Current.DisplayUpdateTask(this);
}
}
public ViewResult MonthlyReport(DateTime?date)
{
if (date == null)
{
date = DateTime.Now;
}
List <Share> shares = _repo.Shares.Where(e => e.Date.Year == Convert.ToDateTime(date).Year ? (e.Date.Month == Convert.ToDateTime(date).Month ?
e.Date.Day <= Convert.ToDateTime(date).Day : e.Date.Month <= Convert.ToDateTime(date).Month) : e.Date.Year <= Convert.ToDateTime(date).Year).ToList();
List <PieChartData> data = new List <PieChartData>();
List <StockViewModel> svm = new List <StockViewModel>();
List <Stock> stocks = _stockRepo.Stocks.ToList();
foreach (var stock in stocks)
{
try
{
Dictionary <DateTime, double> stockData =
JsonConvert.DeserializeObject <Dictionary <DateTime, double> >(HttpContext.Session.GetString(stock.Ticker));
var sData = stockData.First();
List <Share> listOfShares = shares.Where(e => e.StockID == stock.ID).ToList();
int totalShares = listOfShares.Select(e => e.NumOfShares).Sum();
svm.Add(new StockViewModel()
{
Stock = stock,
TotalNumOfShares = totalShares,
CurrentValue = Convert.ToDouble(sData.Value),
TotalValue = Convert.ToDouble(sData.Value) * (double)totalShares
});
}
catch (Exception e)
{
}
}
List <LineChartData> lineData = new List <LineChartData>();
DateTime now = DateTime.Now;
int day = now.Day;
int month = now.Month;
int year = now.Year;
double currentValue = 0;
DateTime currentDate = new DateTime(now.Year, now.Month, 1);
while (currentDate <= now)
{
double total = 0;
DateTime valueDate;
if (currentDate.DayOfWeek == DayOfWeek.Saturday)
{
valueDate = currentDate.AddDays(-1);
}
else if (currentDate.DayOfWeek == DayOfWeek.Sunday)
{
valueDate = currentDate.AddDays(-2);
}
else
{
valueDate = currentDate;
}
foreach (var stock in stocks)
{
Dictionary <DateTime, double> stockData =
JsonConvert.DeserializeObject <Dictionary <DateTime, double> >(HttpContext.Session.GetString(stock.Ticker));
var sData = stockData.Keys.Where(x => Convert.ToDateTime(x).Day == valueDate.Day &&
Convert.ToDateTime(x).Month == valueDate.Month && Convert.ToDateTime(x).Year == valueDate.Year).FirstOrDefault();
if (sData == DateTime.MinValue)
{
sData = stockData.Keys.First();
}
if (sData != null && sData != DateTime.MinValue)
{
List <Share> lineDataShares = shares.Where(e => e.StockID == stock.ID).ToList();
List <Share> previousMonthsDataShares = lineDataShares.Where(e => e.Date.Year < currentDate.Year ||
e.Date.Year == currentDate.Year && e.Date.Month < currentDate.Month).ToList();
List <Share> currentMonthsDataShares = lineDataShares.Where(e => e.Date.Year == currentDate.Year && e.Date.Month == currentDate.Month &&
e.Date.Day <= currentDate.Day).ToList();
decimal totalShares = previousMonthsDataShares.Select(e => e.NumOfShares).Sum() + currentMonthsDataShares.Select(e => e.NumOfShares).Sum();
double s = Convert.ToDouble(stockData.GetValueOrDefault(sData));
double stockValue = s * (double)totalShares;
total += stockValue;
}
}
currentValue = total;
lineData.Add(new LineChartData
{
XData = currentDate.Day.ToString(),
YData = currentValue.ToString()
});
currentDate = currentDate.AddDays(1);
}
List <int> sectors = _stockRepo.Stocks.Select(x => x.SectorID).Distinct().ToList();
foreach (var sector in sectors)
{
List <Share> sectorShares = shares.Where(e => e.Date.Year == currentDate.Year ? (e.Date.Month == currentDate.Month
? e.Date.Day <= currentDate.Day : e.Date.Month <= currentDate.Month) : e.Date.Year <= currentDate.Year).ToList();
int totalShares = sectorShares.Where(e => e.Stock.SectorID == sector).Select(e => e.NumOfShares).Sum();
data.Add(new PieChartData
{
Category = _sectorRepo.Sectors.Where(x => x.ID == sector).FirstOrDefault().Name,
Data = Convert.ToString(totalShares)
});
}
double amountInvested = 0;
List <Share> monthlyShares = shares.Where(e => e.Date.Month == currentDate.Month && e.Date.Year == currentDate.Year).ToList();
foreach (var s in monthlyShares)
{
amountInvested += (double)s.PurchasePrice * (double)s.NumOfShares;
}
List <IncomeEntry> incomes = _incomeRepo.IncomeEntries.Where(i => i.Date.Month == date.Value.Month && i.Date.Year == date.Value.Year).ToList();
TargetAmount investmentGoal = _goalRepo.TargetAmounts.Where(g => g.TargetType.Name.Equals("Investments")).FirstOrDefault();
TargetAmount stockGoal = _goalRepo.TargetAmounts.Where(g => g.TargetType.Name.Equals("Stock")).FirstOrDefault();
TargetAmount goldGoal = _goalRepo.TargetAmounts.Where(g => g.TargetType.Name.Equals("Gold")).FirstOrDefault();
TargetAmount bondGoal = _goalRepo.TargetAmounts.Where(g => g.TargetType.Name.Equals("Bond")).FirstOrDefault();
decimal targetInvestmentAmount = Convert.ToDecimal(incomes.Select(i => i.Amount).Sum()) * investmentGoal.Percentage / 100;
return(View(new StockListViewModel
{
Stocks = svm,
Date = date.Value,
PieChartData = data,
LineChartData = lineData,
AmountInvested = (decimal)amountInvested,
StockGoal = targetInvestmentAmount * stockGoal.Percentage / 100,
GoldGoal = targetInvestmentAmount * goldGoal.Percentage / 100,
BondGoal = targetInvestmentAmount * bondGoal.Percentage / 100,
StockGoalPercentage = stockGoal.Percentage,
GoldGoalPercentage = goldGoal.Percentage,
BondGoalPercentage = bondGoal.Percentage
}));
}
public override bool chooseTargetAmount(Outcome value1, TargetAmount value2, Ability value3, Game value4)
{
Debug.Log("Player - chooseTargetAmount");
return(false);
}
