public ActionResult AddMonthly()
{
var monthlyTable = _context.MonthlySubscrations.OrderByDescending(d => d.Id).ToList();
var newViewModel = new MonthlyAdminViewModel
{
monthlySubscrations = monthlyTable
};
return(View(newViewModel));
}
public ActionResult AddMonthlyToDb(MonthlyAdminViewModel monthlyAdminView)
{
var result = Array.ConvertAll(monthlyAdminView.monthlySubscration.Result.Split(':'), int.Parse).ToList();
if (result[0] > result[1])
{
monthlyAdminView.monthlySubscration.Tip = Convert.ToString('1');
}
else if (result[0] < result[1])
{
monthlyAdminView.monthlySubscration.Tip = Convert.ToString('2');
}
else
{
monthlyAdminView.monthlySubscration.Tip = Convert.ToString('X');
}
//proveruva dali ima element so toj datum i ako nema totalOdd go stava da bide na novozadadeniot odd
if (_context.MonthlySubscrations.Where(date => date.Date == monthlyAdminView.monthlySubscration.Date)
.ToList().Count == 0)
{
monthlyAdminView.monthlySubscration.TotalOdd = monthlyAdminView.monthlySubscration.Odd;
}
//ima elementi => gi zima site na toj den i proveruva dali e eden => ako e eden togas na noviot Total oDD mu go dodava stariot i do mnozi so noviot Odd
else
{
var getAllOnDateQ = _context.MonthlySubscrations
.Where(date => date.Date == monthlyAdminView.monthlySubscration.Date).ToList();
if (getAllOnDateQ.Count == 1)
{
monthlyAdminView.monthlySubscration.TotalOdd = getAllOnDateQ[0].TotalOdd * monthlyAdminView.monthlySubscration.Odd;
}
else
{ //znaci ima poise od eden element na toj datum i gi proga niz loop i gi dadava site
foreach (var odd in getAllOnDateQ)
{
monthlyAdminView.monthlySubscration.TotalOdd = odd.TotalOdd * monthlyAdminView.monthlySubscration.Odd;
}
}
}
//pravi update vo baza za na starite TotalOdd da go dodade noviot TotalOdd
_context.MonthlySubscrations.Where(date => date.Date == monthlyAdminView.monthlySubscration.Date).ToList()
.ForEach(totalOdd => totalOdd.TotalOdd = monthlyAdminView.monthlySubscration.TotalOdd);
_context.MonthlySubscrations.Add(monthlyAdminView.monthlySubscration);
_context.SaveChanges();
var monthlyTable = _context.MonthlySubscrations.OrderByDescending(d => d.Date).ToList();
var newViewModel = new MonthlyAdminViewModel
{
monthlySubscrations = monthlyTable
};
return(View("AddMonthly", newViewModel));
}
public ActionResult DeleteMonthly(int id)
{
var monthlyTip = _context.MonthlySubscrations.FirstOrDefault(x => x.Id == id);
_context.MonthlySubscrations.Remove(monthlyTip);
_context.SaveChanges();
var monthlyViewModel = _context.MonthlySubscrations.OrderByDescending(d => d.Id).ToList();
var newViewModelMonthly = new MonthlyAdminViewModel
{
monthlySubscrations = monthlyViewModel
};
return(View("AddMonthly", newViewModelMonthly));
}