public ActionResult MonthlyBudgetSearch(DailyExpenseViewModel model, string Budgetmonth)
{
model.budgetdetail = db.monthlyBudget.Where(b => b.BudgetMonth == Budgetmonth).ToList();
var detail = model.budgetdetail;
foreach (var item in detail)
{
var name = db.category.FirstOrDefault(x => x.Id == item.CategoryId);
model.CategoryName = name.CategoryName;
}
var detail1 = db.monthlyBudget.Where(b => b.BudgetMonth == Budgetmonth).Select(a => a.ActualAmount).ToList();
for (var i = 0; i < detail1.Count; i++)
{
model.TotalActual += detail1[i];
}
var detail2 = db.monthlyBudget.Where(b => b.BudgetMonth == Budgetmonth).Select(a => a.BudgetAmount).ToList();
for (var i = 0; i < detail2.Count; i++)
{
model.TotalBudget += detail2[i];
}
model.TotalDifference = model.TotalBudget - model.TotalActual;
return(View(model));
}
public ActionResult DailyExpenseView()
{
DailyExpenseViewModel model = new DailyExpenseViewModel();
ViewBag.ItemCategoryId = new SelectList(db.itemCategory, "Id", "ItemName", model.ItemCategoryId);
return(View(model));
}
public ActionResult MonthlyBudgetSearch()
{
DailyExpenseViewModel model = new DailyExpenseViewModel();
return(View(model));
}
public ActionResult DailyExpenseView(DailyExpenseViewModel model, DateTime Day)
{
var k = Day.Month;
var month = DateTimeFormatInfo.CurrentInfo.GetMonthName(k);
model.budgetdetail = db.monthlyBudget.Where(b => b.BudgetMonth == month).ToList();
// model.dailyexpensedetail = db.dailyExpense.Where(b => b.Day.Month == Day.Month).ToList();
//model.budgetdetail = db.monthlyBudget;
// model.budgetdetail = db.monthlyBudget.Where(s => s.BudgetMonth == BudgetMonth).ToList() ;
//model.dailyexpensedetail.Reverse();
ItemCategory newItem = new ItemCategory();
newItem = db.itemCategory.FirstOrDefault(x => x.Id == model.ItemCategoryId);
var matchcCategory = newItem.CategoryId;
MonthlyBudget newBudget = new MonthlyBudget();
newBudget = db.monthlyBudget.FirstOrDefault(y => y.CategoryId == matchcCategory && y.BudgetMonth == month);
var s = DateTime.ParseExact(newBudget.BudgetMonth, "MMMM", System.Globalization.CultureInfo.InvariantCulture).Month;
if (model.Day.Month == s)
{
newBudget.ActualAmount += model.Amount;
newBudget.Difference = newBudget.BudgetAmount - newBudget.ActualAmount;
}
//MonthlyBudget budget1 = db.monthlyBudget.FirstOrDefault(s => s.BudgetMonth.Month == BudgetMonth.Month);
//model.dailyexpensedetail = db.dailyExpense;
////model.dailyexpensedetail.Reverse();
//model.budgetdetail = db.monthlyBudget;
//ItemCategory newItem = new ItemCategory();
//newItem = db.itemCategory.FirstOrDefault(x => x.Id == model.ItemCategoryId);
//var matchcCategory = newItem.CategoryId;
//MonthlyBudget newBudget = new MonthlyBudget();
//newBudget = db.monthlyBudget.FirstOrDefault(y => y.CategoryId == matchcCategory);
//if (model.Day.Month == newBudget.BudgetMonth.Month)
//{
// newBudget.ActualAmount += model.Amount;
// newBudget.Difference = newBudget.BudgetAmount - newBudget.ActualAmount;
//}
Category newCategory = new Category();
var categoryNameList = db.category.Select(a => a).ToList();
foreach (var item in categoryNameList)
{
var categoryName = db.category.FirstOrDefault(z => z.Id == matchcCategory);
model.CategoryName = categoryName.CategoryName;
}
model.BudgetAmount = newBudget.BudgetAmount;
model.ActualAmount = newBudget.ActualAmount;
// model.Difference = newBudget.Difference;
model.BudgetMonth = newBudget.BudgetMonth;
var budgetList = db.monthlyBudget.Select(b => b).ToList();
foreach (var item in budgetList)
{
item.Difference = item.BudgetAmount - item.ActualAmount;
model.Difference = item.Difference;
}
var budgettal1 = db.monthlyBudget.Where(a => a.BudgetMonth == month).Select(l => l.BudgetAmount).ToList();
// var budgetall = db.monthlyBudget.Select(a => a.BudgetAmount).ToList();
for (var i = 0; i < budgettal1.Count; i++)
{
model.TotalBudget += budgettal1[i];
}
var newExpense = new DailyExpense
{
Day = model.Day,
ItemCategoryId = model.ItemCategoryId,
Amount = model.Amount
};
db.dailyExpense.Add(newExpense);
db.SaveChanges();
var budgetall1 = db.monthlyBudget.Where(a => a.BudgetMonth == month).Select(a => a.ActualAmount).ToList();
for (var i = 0; i < budgetall1.Count; i++)
{
model.TotalActual += budgetall1[i];
}
model.TotalDifference = model.TotalBudget - model.TotalActual;
model.dailyexpensedetail = db.dailyExpense.Where(b => b.Day.Month == Day.Month).ToList();
ModelState.Clear();
ViewBag.ItemCategoryId = new SelectList(db.itemCategory, "Id", "ItemName", model.ItemCategoryId);
return(View(model));
}
